Skip to content

getHeader

[!WARNING] Status: not-found-by-cli. The package WCIS_DBA.pk80001_legalnet was retrieved successfully in full (spec + body, 98 enumerated members, 148,911 characters) via legends oracle query --name pk80001_legalnet on 2026-08-31. A case-insensitive search of the entire retrieved source for the substring header returns zero matches — getHeader is not a member of the retrieved package. The .NET call site SAIF.Application.Claim.Legal/clsLegalData.vb:31 (Return "pk80001_legalNet.getHeader") is a live, verified binding: clsLegalData is constructed and consumed as a read-only value object, and if this code path executes against an environment whose pk80001_legalnet matches the retrieved version, the call would fail at runtime with ORA-06550/PLS-00302 (undefined program unit). This is most likely environment/version drift or a removed package member, not evidence that clsLegalData is dead code — treat the caller as a live call site that would error if invoked, not as unreachable code. Do not present a fabricated signature for getHeader.

Overview

Field Value
Schema WCIS_DBA
Package pk80001_legalnet
Type PROCEDURE (inferred from caller)
Database Oracle
Status ⚠️ Member not found in retrieved package; package itself was successfully retrieved
Query executed legends oracle query --name pk80001_legalnet (2026-08-31T21:20:00Z)
Calling libraries SAIF.Application.Claim.Legal
Calling classes clsLegalData

Call Sites

The .NET caller references this procedure as a stored procedure invocation:

Class Method Source File Evidence
clsLegalData .New(IDataPortalInfo, ClaimID, LegalCaseSeqNum) constructor SAIF.Application.Claim.Legal\clsLegalData.vb:29–31 Return "pk80001_legalNet.getHeader" via RetrieveSQL read-only property

Caller-side invocation detail

Source: SAIF.Application.Claim.Legal\clsLegalData.vb:29–65

Friend ReadOnly Property RetrieveSQL() As String
    Get
        Return "pk80001_legalNet.getHeader"
    End Get
End Property

' clsLegalData constructor
Public Sub New(ByVal inDPI As IDataPortalInfo, ByVal inClaimId As Decimal, ByVal inLegalCaseSeqNum As Decimal)
    Dim result = SqlHelper.ResultSetQuery(inDPI, "Get Legal Information")
    ' Parameter binding (inferred from .NET code):
    ' Command: CommandType.StoredProcedure; Name: "pk80001_legalNet.getHeader"
    ' Parameters:
    '   AddParm("aLegalCaseNum", inLegalCaseSeqNum) — IN NUMBER
    '   AddCursorParm("recordset") — OUT REF CURSOR
    ' Result set consumed:
    If result.Any Then
        m_CaseNum = result.First.GetString("CaseNum")
        m_AttyName = result.First.GetString("AttyName")
        m_CaseStatus = result.First.GetString("CaseStatus")
        m_HearingDate = CDate(result.First.GetString("HearingDate"))
    End If
End Sub

Inferred Signature

These parameters are inferred from the caller only. The procedure body is not available; this signature describes only what clsLegalData.vb binds. No actual PL/SQL signature has been extracted.

Parameter Direction (inferred) Type (inferred) Description
aLegalCaseNum IN NUMBER Legal case sequence number passed as inLegalCaseSeqNum from the constructor.
recordset OUT REF CURSOR Result set cursor expected by SqlHelper.ResultSetQuery.

Result-set columns consumed by caller

Column .NET accessor Mapped property Type
CaseNum GetString clsLegalData.CaseNum String
AttyName GetString clsLegalData.AttorneyName String
CaseStatus GetString clsLegalData.CaseStatus String
HearingDate GetString then CDate clsLegalData.HearingDate Date (via CDate conversion)

Cross-library corroboration

The same package WCIS_DBA.pk80001_legalnet is referenced by SAIF.Business.Claim.Legal in its saif-business-claim-legal/procedures/pk80001_legalnet.md. That library's documentation does not include a getHeader entry despite cataloging all 98 retrieved members — an independent confirmation that the member is genuinely absent from the retrieved artifact.

Sources

  • Legends CLI query executed 2026-08-31T21:20:00Z: legends oracle query --name pk80001_legalnet — retrieved WCIS_DBA.pk80001_legalnet spec + body (148,911 characters, 98 enumerated members); substring search for "header" across full source returned 0 matches
  • Referencing code: SAIF.Application.Claim.Legal\clsLegalData.vb:29–65 (caller-side inference only; no procedure body available)
  • Cross-library verification: SAIF.Business.Claim.Legal\procedures\pk80001_legalnet.md (same package, no getHeader member documented)