Results for “okl_book_controller_pvt”

50+ results




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

Overview

OKL_BOOK_CONTROLLER_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema, belonging to the Oracle Lease and Finance Management (OKL) product family within the ETRM (Enterprise Transaction and Resource Management) module set. In Oracle EBS 12.1.1 and 12.2.2, this package orchestrates the booking and activation lifecycle of lease and finance contracts. Its central business responsibility is to drive a contract from a validated state through pricing, upfront tax calculation, quality assurance (QA) checking, approval submission, stream generation, journal entry creation, and final activation.

The package is declared with AUTHID CURRENT_USER, meaning it executes under the privileges of the calling user rather than the definer, and it relies on the APPS synonym layer to resolve all underlying OKL tables. It also exposes global constants that define controller task identifiers (for example, G_VALIDATE_CONTRACT = 'OKLBCTQA', G_CALC_UPFRONT_TAX = 'OKLBCTUT', G_PRICE_CONTRACT = 'OKLBCTST', and G_SUBMIT_CONTRACT = 'OKLBCTBK') and standard program status values (PENDING, RUNNING, COMPLETE, ERROR), which are used to track the progress of controller-driven processes.

Key Procedures and Functions

The documented metadata lists 17 procedures and functions that collectively implement the contract booking workflow:

Tables Accessed

The package reads and writes several core OKL and OKC tables via APPS synonyms:

Usage Notes

OKL_BOOK_CONTROLLER_PVT is a private package and is not intended for direct customer invocation; it is called internally by the OKL booking controller framework. It is typically invoked from Oracle Forms during contract entry (through Next-button validation procedures), and from concurrent programs that execute the staged controller programs (SUBMIT_CONTROLLER_PRG1/EXEC_CONTROLLER_PRG1 and their stage-two counterparts). It is also referenced by approximately 10 other packages in the OKL schema, forming part of the contract booking service layer. Customizations should extend or wrap this package rather than modify it directly, since it ships under the APPS schema and is subject to Oracle support and patching.