SQL-053: CollectionsRepository.ApplyPayments¶

This statement is a update / create operation invoked through StoredProc (inline CreateSqlQuery + ExecuteUpdate). Executed by CollectionsRepository.ApplyPayments.

Classification¶

Field	Value
SQL ID	SQL-053
Operation type	Update / Create
Execution method	StoredProc (inline `CreateSqlQuery` + `ExecuteUpdate`)
Database	Oracle
Schema	WCIS_DBA* (package owner; unqualified inside package)
Command type	StoredProcedure
Business object	`CollectionsRepository`
Criteria property	N/A — no IBusinessCriteria
Lifecycle method	`ApplyPayments`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:inSeqNum`	Input	NUMBER (.NET `SetDecimal`)	N/A	Case id; 0 applies payments for all cases
`:pmt_date`	Input	DATE (.NET `SetDateTime`)	N/A	Transaction date; ignored by the procedure body

Tables¶

Table	Access	Columns used
LEGAL_COLLECTION_TRANSACTION	R/U	See Sample SQL
LEGAL_COLLECTION_TRAN_CODE	Write	See Sample SQL
LC_TRAN_CATEGORY_CODE	Write	See Sample SQL
LEGAL_COLLECTION_PAYMENT_REF	C	See Sample SQL

Sample SQL¶

Source: Data/SAIF.Data.NHibernate/Repositories/CollectionsRepository.cs:88

call WCIS_DBA.PK80010_LEGAL_COLLECTIONS.APPLYPAYMENTS(
    :inSeqNum,
    :pmt_date
)

Operations and processes¶

Collections payment application

Business rules¶

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Data/SAIF.Data.NHibernate/Repositories/CollectionsRepository.cs:86