Results for “get_bankruptcy_status”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_STREAM_BILLING_PVT is a private PL/SQL API package in the Oracle E-Business Suite (EBS) Lease Management (OKL) module, owned by the APPS schema and classified as a PVT (private) API. It encapsulates the core billing engine logic for lease streams, providing the reusable procedural foundation that public and controller packages invoke to generate billable transaction records from lease stream definitions. Within the Oracle Enterprise Contracts and Lease Management architecture, the package bridges contract header data, stream and stream-element definitions, and receivable-side billing data, ensuring that periodic lease billing, bankruptcy handling, and customer detail resolution are performed consistently across the billing lifecycle. The package is status VALID and is documented for both EBS 12.1.1 and 12.2.2. Because it is a PVT classification, it is intended to be called by other APIs rather than directly by end-user forms or external integrations; the public counterpart, OKL_STREAM_BILLING_PUB, exposes the supported entry points that delegate into this package.

Key Procedures and Functions

Six documented program units comprise the streaming billing interface:

• BILL_STREAMS — The principal billing driver; generates billing lines for lease streams, evaluating stream type and element rules to determine billable amounts.
• PROCESS_BILL_TBL — Processes the internal billing table produced by BILL_STREAMS, applying validation, adjustments, and committing the resulting receivables-facing records.
• GET_PRINTING_LEAD_DAYS — Returns the printing lead-time configuration used to schedule invoice or statement generation relative to bill dates.
• GET_BANKRUPTCY_STATUS — Determines the bankruptcy status of a lease counterparty from the IEX bankruptcy data, supporting billing holds and special handling.
• GET_BANKRUPTCY_STATUS_NEW — An enhanced variant providing current bankruptcy status resolution, likely reflecting additional data sources or rules.
• GET_CUSTOMER_DTLS — Resolves customer details (account, party, and profile attributes) required during billing to populate billing and receivable information.

Tables Accessed

The package reads and writes across contract, stream, and receivables tables:

• OKL_STREAMS, OKL_STRM_ELEMENTS — Lease stream headers and elements; the source of billing amounts and dates.
• OKC_K_HEADERS_B, OKC_K_HEADERS_ALL_B, OKC_K_ITEMS, OKC_K_LINES_B, OKC_K_PARTY_ROLES_B, OKC_RULES_B — Contract header, line, item, party role, and rules data defining the leasing contract and its roles.
• AR_RECEIPT_CLASSES, AR_RECEIPT_METHODS — Receivables setup used to default receipt classification and method during billing.
• HZ_CUST_ACCOUNTS, HZ_PARTIES, HZ_CUSTOMER_PROFILES — Customer account, party, and profile data resolved via GET_CUSTOMER_DTLS.
• IEX_BANKRUPTCIES — Bankruptcy records backing the status functions.
• FND_LANGUAGES — Language configuration for multilingual handling.

Usage Notes

OKL_STREAM_BILLING_PVT is invoked indirectly through higher-level billing programs rather than called directly. Its documented callers include OKL_STREAM_BILLING_PUB (the public wrapper), OKL_BILLING_CONTROLLER_PVT, OKL_INTERNAL_BILLING_PVT, OKL_EXT_BILLING_CHARGES_PVT, OKL_BPD_ADVANCED_BILLING_PVT, OKL_AM_TERMNT_QUOTE_PVT, and OKL_REPORT_PVT. In practice, the package is triggered during lease billing concurrent program runs and billing-related forms processing, where streams are billed and bankruptcy status and customer details drive eligibility. Customizations should call the PUB layer rather than this PVT package, since Oracle does not guarantee the private API signature across releases. Its dependencies on FND_API and OKC_API confirm standard EBS error-handling and contract API integration.