Skip to content

sp82289_medicallystationarydt

[!WARNING] Procedure source not returned by the database. sp82289_medicallystationarydt was queried in Oracle via the Legends CLI on 2026-08-31 (legends oracle query --name sp82289_medicallystationarydt, attempted 2026-08-31T21:10:00Z) and no source was returned. This was a properly-executed retrieval attempt, not a skipped one. The referencing code is flagged as possibly dead code pending further investigation — this is not a definitive finding.

Overview

Field Value
Schema Unknown — not returned by CLI
Type Unknown — presumed procedure from the BOF call site only (CommandType.StoredProcedure)
Database Unknown — not returned by CLI
Status ⚠️ Queried via Legends CLI on 2026-08-31; no source returned
Query executed legends oracle query --name sp82289_medicallystationarydt
Calling libraries SAIF.Business.Claim
Calling classes clsMedicallyStationaryDate

Possibly Dead Code References

The following .NET code path references this procedure. Because the database returned no source for it, this may be dead code — but this has not been confirmed. A not-found result is consistent with several unruled-out explanations: the object was dropped and the caller is genuinely orphaned; the object exists under a schema or synonym the CLI query did not resolve; the object exists but is not visible to the querying account's privileges; or the object lives in a different database instance or behind a database link.

Class Method Source File
clsMedicallyStationaryDate GetMedicallyStationaryDate (entry point, line 110); header comment naming the procedure (line 11); DataRequest.ID = "MedicallyStationaryDate" (line 75); AddParm("inSaifClaimNum", …, 7) (line 78); AddCursorParm("recordset", ParameterDirection.Output) (line 79); RetrieveSQL returns the procedure name (line 170) SAIF.Business.Claim/clsMedicallyStationaryDate.vb

No parameter table, business rule, or operation can be produced for this procedure — its signature and body are unknown, and nothing beyond the caller-side AddParm name above may be asserted.

Sources

  • Retrieved via legends oracle query --name sp82289_medicallystationarydt on 2026-08-31 — no source returned (not found by CLI)
  • Referencing code: SAIF.Business.Claim/clsMedicallyStationaryDate.vb (lines 11, 35, 75–79, 110, 170)