Skip to content

SAIF.Business.Claim.Legal stored procedures

This page catalogs the Oracle stored-procedure/function members across the 3 packages invoked by this library. Real Oracle PL/SQL source was retrieved for all three packages via the Legends CLI (legends oracle query --owner SAIF --name <package_name>, schema WCIS_DBA) on 2026-08-31: pk80001_legalnet and pk80005_assignment returned both package specification and body; pk82289_legalnet_letters returned only the package specification (no body was available from DBA_SOURCE/ALL_SOURCE for this package — this is normal/expected for this API, not an error). Every procedure page below documents real signatures, and business rules/operations extracted from actual PL/SQL logic where a body was available, or from the calling VB.NET code (marked inferred) for pk82289_legalnet_letters.

Procedure catalog

Package / Procedure Schema Type Purpose Calling business objects
pk80001_legalnet WCIS_DBA Package (98 members) Legal-case, hearing schedule, appeal, case outcome, case note, file-location, mail-date/OAR, consolidation, and attorney-profile CRUD for the LegalNet module clsLegalCase, clsLegalSchedule, clsAppeal, clsCaseOutcome, clsCaseNote, clsAttorneyProfile, clsConsolidations, clsLegalFileLocation, clsLegalCaseEvaluation, clsCaseSearch, and others
pk80005_assignment WCIS_DBA Package (42 members) Automated attorney-assignment batch engine: conflict-of-interest/rotation/calendar/caseload checks, assignment result recording, and Outlook/calendar integration queries clsAssignmentProcess, clsAttorneyConflict, clsAttorneySchedule
pk82289_legalnet_letters WCIS_DBA Package (4 members, spec only) Legal letter request selection, worker/claim lookup, and printed-date update for Xpressions letter printing clsLetterRequest

Sources

  • SAIF.Business.Claim.Legal\LegalNet\, SAIF.Business.Claim.Legal\TableMaint\, SAIF.Business.Claim.Legal\Print\ (see individual per-package procedure pages for exact referencing call sites)