SAIF.Data.NHibernate stored procedures¶
This page catalogs the Oracle PL/SQL packages and the SQL Server stored procedure invoked by this library (7 packages/procedures total, 6 retrieved successfully and 1 not returned by the database).
Procedure catalog¶
| Package / Procedure | Schema | Type | Purpose | Calling business objects |
|---|---|---|---|---|
PK80010_LEGAL_COLLECTIONS |
WCIS_DBA | Package | Implements: get_cases_by_reference, get_category_totals, getDebtorSSN, getDebtorName, getPrimaryDebtorName, get_fraud_other_address, get_policy_address, get_thirdparty_address, search_collections, applyPayments (→ applyIt, legalcol_payment_ref_insert), interest_calc_select (→ get_interest_start_date), getPolicyPayments, getThirdPartyPayments, getDebtorsWithoutPayments, getDebtorsWithExpiredLocs, getBalanceBroughtToMinAmount, get_last_statement_balance | CollectionsRepository |
PK80011_LEGALCOL_SOIL |
WCIS_DBA | Package | Implements: create_reference_records, create_SOIL_transactions (→ find_DOR_balance, insert_soil_tran, remove_soil_flag) | CollectionsRepository |
PK72846_VIEW_POLICY |
WCIS_DBA | Package (function) | Implements: SP73111_GET_WCIS_STD_PREMIUM | PoliciesRepository |
PK73101_IMAGE |
WCIS_DBA | Package (procedure overload of function) | Implements: TRACK_IN_REPORT (procedure overload → remote track_in_report@POLDB) |
PolicyPeriodPayrollAuditRepository |
PK82001_CLAIM |
WCIS_DBA | Package | Implements: getMissingTLPayments — ⚠️ not present in the retrieved spec or body (package contains only getPersonAddress_GW, typeAddressExists_GW) | MissingTimeLossRepository (⚠️ possibly dead code — the call would fail at runtime) |
bp_clm_segmntn_complexity_score |
dbo | SQL Server procedure | Implements: bp_clm_segmntn_complexity_score (→ dbo.bp_clm_segmntn_complexity_score_dtl, dbo.bp_clm_segmntn_complexity_score_dtl_2026, eis_staging.dbo.bp_send_message — not retrieved**) | ClaimScoreRepository |
PK82039_BILLENTRY_TASK_PROCESS |
Unknown** | Package** | ⚠️ Not returned by the database (not-found-by-cli); referencing code flagged possibly dead | None — ⚠️ possibly dead code: the named queries have no caller; ClaimBillEntryRepository delegates to ICCClaimApiService |
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Security and authorization
- Database tables
- SQL catalog
- API reference
Sources¶
Data/SAIF.Data.NHibernate/Mappings/**