SQL-007: CollectionsRepository.GetPrimaryDebtorName¶
This statement is a read operation invoked through StoredProc (named query Collections_GetPrimaryDebtorName). Executed by CollectionsRepository.GetPrimaryDebtorName.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-007 |
| Operation type | Read |
| Execution method | StoredProc (named query Collections_GetPrimaryDebtorName) |
| Database | Oracle |
| Schema | WCIS_DBA* (package owner; unqualified inside package); [unqualified]** |
| Command type | StoredProcedure |
| Business object | CollectionsRepository |
| Criteria property | N/A — no IBusinessCriteria |
| Lifecycle method | GetPrimaryDebtorName |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:legal_col_seq_num_in |
Input | NUMBER (.NET long) |
N/A | Legal collection case id |
return |
Return | VARCHAR2 → string |
N/A** | Primary debtor name |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| LEGAL_COLLECTION_DEBTOR | Read | See Sample SQL |
| LEGAL_COLLECTION | Read | See Sample SQL |
| AFFILIATE | Read | See Sample SQL |
| POLICY | Read | See Sample SQL |
| THRDPARTY | Read | See Sample SQL |
| PERSON | Read | See Sample SQL |
| THRDPARTY_FIRM | Read | See Sample SQL |
| COMPANY | Read | See Sample SQL |
Sample SQL¶
Source: Data/SAIF.Data.NHibernate/Mappings/Collections/Collections.hbm.xml:19
select pk80010_legal_collections.getPrimaryDebtorName(:legal_col_seq_num_in) as DebtorName from dual
Operations and processes¶
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:38