Search Results outstanding_billed_amt
Overview
OKL_CS_LC_CONTRACT_PVT is a private PL/SQL package owned by the APPS schema within the Oracle Lease and Finance Management (OLFM) module of Oracle E-Business Suite. The "LC" token in the name denotes Lease Contracts, and the "PVT" suffix classifies the package as a private API — meaning it is intended for internal consumption by other OLFM packages and views rather than as a published integration interface. The package exposes a broad set of utility and query routines that consolidate contract-level financial, party, and reference information used by the Contract Summary (CS) family of views, including OKL_CS_LC_CONTRACT_PVT itself, OKL_CS_BILLINGTRX_UV, OKL_CS_PAYMENT_SUMMARY_UV, OKL_CS_DEPRECN_SCHEDULES_UV, and OKL_CS_VAT_SCHEDULES_UV. It also feeds extensions in the Oracle Incentive Compensation (IEX) schema such as IEX_AVAIL_CONTRACTS_V2 and IEX_WRITTENOFF_INVOICES_V2, indicating that contract data surfaced by this package reaches downstream commission and billing transaction modules. Documented status is VALID in ETRM 12.1.1 and 12.2.2.
Key Procedures and Functions
The ETRM metadata documents 40 procedures and functions. The prominent ones include:
- NEXT_DUE / LAST_DUE — determine the next and previous due dates on a lease contract's payment schedule, used by payment summary views.
- TOTAL_ASSET_COST / TOTAL_SUBSIDY_COST — return aggregate asset and subsidy cost figures associated with the contract.
- OUT_STANDING_RCVBLE, OUTSTANDING_BILLED_AMT, OUTSTANDING_UNBILLED_AMT — calculate receivable balances, split by billed and unbilled portions, for aging and collections reporting.
- CONTRACT_DATES — returns the key date set (start, end, first payment, etc.) for the contract header.
- RENT_SECURITY_INTEREST — surfaces the security interest clause data held on the lease agreement.
- NOTES / NOTE_CONTEXT_INFO — retrieve and contextualize JTF notes attached to the contract.
- GET_VENDOR_PROGRAM / GET_PRIVATE_LABEL / GET_CURRENCY / GET_SYNDICATE_FLAG / GET_ORG_ID / GET_RESOURCE_ID / GET_WARNING_MESSAGE / GET_K_ACCESS_LEVEL — accessor functions that expose vendor program attributes, private-label indicators, contract currency, syndication status, owning organization, assigned resource, warning text, and OKC access-level settings.
- PARTY_TYPE_INFO — resolves the party classification for the contract's customer or counterparty.
Tables Accessed
The package reads and, in some cases, writes through APPS synonyms across several EBS schemas. Contract header and access data come from OKC_K_HEADERS_ALL_B, OKC_K_HEADERS_B, and OKC_K_ACCESSES. Party and customer information is drawn from HZ_PARTIES, HZ_CUST_ACCOUNTS, and the JTF_RS_* resource tables (JTF_RS_GROUPS_B, JTF_RS_GROUPS_DENORM, JTF_RS_GROUP_MEMBERS, JTF_RS_RESOURCE_EXTNS, JTF_RS_ROLES_B, JTF_RS_ROLE_RELATIONS). Financial amounts pull from AP_INVOICE_LINES_ALL and AR_CASH_RECEIPTS_ALL. Notes text is sourced from JTF_NOTES_TL, and FND_APPLICATION provides application reference lookups.
Usage Notes
Because OKL_CS_LC_CONTRACT_PVT depends on OKC_API, OKL_API, and OKL_DEAL_CREATE_PUB, it is normally invoked from within the OLFM call stack rather than from external custom code. The 14 documented referrers — including OKL_CREDIT_MGNT_PVT and the OKL_CS_*_UV object views — call its routines to populate OAF-based Contract Summary pages, collections workbenches, and IEX commission views. Custom extensions should call the public OKL_API or OKL_DEAL_CREATE_PUB APIs instead of this private package, and direct calls should be considered upgrade-sensitive between 12.1.1 and 12.2.2.