---
title: pk82396_medical_bills stored procedure documentation
summary: Analysis of Oracle package pk82396_medical_bills including business rules and operations.
status: draft
owner: <owner>
last_reviewed: 2026-07-24
library: SAIF.Business.External.Users
sqlserver_status: "not-found"
reference_type: package
---

# pk82396_medical_bills

> [!WARNING]
> **Procedure not found in Oracle.** This procedure/package was referenced in application code but does not exist in `DBA_SOURCE`. The referencing code is flagged as **possibly dead code**.

**SQL Server also checked (2026-08-17).** This reference was additionally queried against all known SQL Server BDS databases via `legends sqlserver query`; no matching source was returned there either. The reference remains unresolved in both Oracle and SQL Server.

## Overview

| Field | Value |
| --- | --- |
| **Schema** | [unknown]** |
| **Type** | Package (expected) |
| **Database** | [unknown]** |
| **Status** | ⚠️ Not found in Oracle or SQL Server |
| **Calling libraries** | `SAIF.Business.External.Users` |
| **Calling classes** | `clsNewUserArgs` |

## Possibly dead code references

The following .NET code paths reference this procedure. Since the procedure does not exist in Oracle (as determined in the Phase 1b analysis), these may be dead code:

| Class | Method | Source file |
| --- | --- | --- |
| `clsNewUserArgs` | `IsValidProviderRegistration` | `Business\SAIF.Business.External.Users\clsNewUserArgs.vb` |

## Related documentation
- [Procedure catalog](index.md)
- [Operations and processes](../operations-processes.md)
- [SQL catalog](../sql/index.md)

> **Note:** Statements marked with `**` could not be confirmed; treat as unknown until verified.

## Sources
- `Business\SAIF.Business.External.Users\clsNewUserArgs.vb`