| insert | insert | AUTO_ID: serviceInvoiceLineItemID
| Creates a new row on Service Invoice Line Item table. | |
| read | read | | Reads a row of data from Service Invoice Line Item table. | |
| modify | modify | OPTIMISTIC_LOCKING: yes
| Modifies an existing row on Service Invoice Line Item table. | |
| remove | remove | | Removes an existing row from Service Invoice Line Item table. | |
| searchByServiceInvoice | readmulti | ORDER_BY: amountInvoiced
| Search Service Invoice Line Item by Service Invoice. | |
| searchByServiceAuthorizationLineItem | readmulti | | Search Service Invoice Line Item by Service Authorization Line Item. | |
| searchByServiceProvisionAndClientDetails | readmulti | ORDER_BY: serviceDateFrom
WHERE: (
caseID = :caseID
) AND (
serviceID = :serviceID
) AND
(
clientID = :clientID
) AND (
providerID = :providerID
) AND (
:placementServiceInd = '1'
OR
serviceDateFrom = :serviceDateFrom
)
| Search Service Invoice Line Item by Service Provision and Client details. | |
| searchByConcernRoleIDCaseIDServiceID | readmulti | ORDER_BY: serviceInvoiceLineItemID
WHERE: (
:searchByCaseID = '0'
OR
caseID = :caseID
)AND
(
:searchByClientID = '0'
OR
clientID = :clientID
)AND
(
:searchByServiceID = '0'
OR
serviceID = :serviceID
)
| Search Service Invoice Line Item by ConcerRoleID, CaseID and ServiceID. | |
| searchByProviderAndServiceInvoice | nsmulti | | Search service invoice line item by provider and service invoice.
@deprecated Since Curam 5.2 SP6, replaced with { @link curam.cpm.sl.entity.base.ServiceInvoiceLineItem#searchByProviderAndServiceInvoiceID(RetrieveProviderSILIKey)}. This method is not performant. This method takes a long time when a service invoice for a provider is searched. This method is replaced by a more performant method.
See release note: CR00303803 | SQL |
| searchByServiceOffering | readmulti | | Search Service Invoice Line Item by Service Offering. | |
| searchByProviderOffering | readmulti | | Search Service Invoice Line Item by Provider and Service. | |
| searchSILIPayslip | nsmulti | | Searches all Invoice based un-processed Payslips. | SQL |
| searchByProvider | readmulti | | Search Service Invoice Line Item by Provider. | |
| searchILIsBySILI | nsmulti | | Search InstructionLineItem by Service Invoice Line Item. | SQL |
| searchByServiceAuthorizationAndValidity | readmulti | | Retrieves the service invoice line items for given service authorization and validity status. | |
| searchByProviderAndServiceInvoiceID | nsmulti | | Search Service Invoice Line Item by Provider and Service Invoice. | SQL |
| searchByServiceAuthorizationLineItemAndSILIStatuses | nsmulti | | Searches service invoice line item by authorization ID and either of two given statuses. | SQL |
