Search Results p_vendor_site

Overview

OKL_PAY_INVOICES_CONS_PUB is the public API package body for the Oracle Lease Management (OKL) invoice consolidation process within Oracle E-Business Suite. Its purpose is to consolidate payable invoices generated from lease contracts so that they can be grouped, reviewed, and subsequently disbursed through Oracle Payables. The package belongs to the OKL module, which forms part of the ETRM (Enterprise Transaction and Revenue Management) family in release 12.1.1 and 12.2.2, where lease and financing transactions are processed alongside standard receivables, payables, and fixed asset flows.

The package implements the standard Oracle API pattern: it is a lightweight public wrapper that validates and forwards calls to the corresponding private implementation package, OKL_PAY_INVOICES_CONS_PVT, which contains the actual business logic. The public body handles savepoint management, message list initialization through the OKC_API and FND_API utilities, and exception propagation via the standardized Fnd_Api return status and exception conventions (G_RET_STS_ERROR and G_RET_STS_UNEXP_ERROR). This design isolates callers from implementation details and enforces consistent error handling.

Key Procedures and Functions

• CONSOLIDATION — The primary public entry point for the invoice consolidation process. It accepts an API version, initialization flag, standard return/message output parameters, and filter criteria that include contract number, vendor, vendor site (p_vendor_site), VPA number, stream type purpose, and a from/to date range. The vendor site parameter was introduced as part of the R12 disbursement changes (reference timestamp 24-APR-2007) and allows callers to restrict consolidation to invoices tied to a specific supplier site. Internally, the procedure opens a savepoint, delegates to the private package, raises the appropriate Fnd_Api exception if the return status indicates error or unexpected error, and rolls back to the savepoint on exception.
• CONSOLIDATION_INV — A companion procedure that performs the invoice-level consolidation work. Like CONSOLIDATION, it follows the public wrapper convention and ultimately operates against the external pay invoice staging table, supporting the same consolidation lifecycle.

Tables Accessed

The documented table reference for this package is OKL_EXT_PAY_INVS_B, the base table that holds external payable invoice data originating from lease contracts. The consolidation logic reads eligible invoice rows from this table (filtered by vendor, vendor site, contract, or stream type purpose where supplied) and prepares them for grouping and subsequent disbursement processing. Write operations against this table are performed by the private implementation package invoked through the public wrappers. Because the filter criteria include p_vendor_site, callers specifically use this table to isolate invoices tied to a given supplier site prior to consolidation.

Usage Notes

• The package is typically invoked from Oracle Lease Management concurrent programs and from the disbursement-related user interfaces where lease payables must be batched before payment processing.
• Because it is a PUB-classified API, custom code and Oracle-delivered programs should call only the public procedures (CONSOLIDATION, CONSOLIDATION_INV) and never the private implementation directly.
• Callers must supply p_api_version and respect the Fnd_Api return status contract, checking x_return_status for G_RET_STS_ERROR or G_RET_STS_UNEXP_ERROR; messages can be retrieved using Fnd_Msg_Pub.count_and_get.
• The R12 disbursement enhancement (vendor, vendor site, VPA number, and stream type purpose parameters) should be used when restricting consolidation to a specific supplier or supplier site.
• The package is not referenced by any other documented packages, meaning its invocation is driven directly by concurrent programs, forms, or external custom code rather than by other PL/SQL APIs.