Search Results g_level_statement

Overview

OKL_CS_CREATE_QUOTE_PVT is a private (PVT) PL/SQL package body owned by APPS and shipped as part of the Oracle Lease and Finance Management (formerly Oracle Contracts) module within Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to provide the internal implementation layer that supports the creation, submission, and termination of lease and finance quotes. The package acts as a convenience wrapper over the record-based API exposed by OKL_AM_CREATE_QUOTE_PVT, converting table-type collections into record-type calls that the underlying API can consume.

The header comment embedded in the source documents this design intent explicitly: the procedure accepts its parameters as table types and then iteratively invokes the record-type API. In practice, only a single record is normally supplied in the PL/SQL table, so the record API executes once per invocation. This pattern allows callers to work with bulk-collection signatures while the core quote logic remains record-oriented. The package body also implements a diagnostic logging framework built on FND_LOG, defining level constants plus a module name prefix that is concatenated with individual routine names for traceability.

Key Procedures and Functions

The package exposes four documented routines. Their parameter lists are intentionally not enumerated here; only their purpose is described.

• CREATE_TERMINATE_QUOTE — The central entry point. It accepts quote, assignment, and quantity-per-vehicle table structures and returns corresponding output tables alongside the standard API return status, message count, and message data convention. It delegates to OKL_AM_CREATE_QUOTE_PUB's record-type API, looping through the supplied collections. Debug logging is gated by three flags evaluated at entry: exception, procedure, and statement levels.
• FETCH_RULE_QUOTE_PARTIES — Retrieves the parties associated with a rule-driven quote, allowing downstream logic and user interfaces to resolve the participants attached to a given quote rule.
• SUBMIT_FOR_APPROVAL — Moves a constructed or modified quote into the approval workflow, initiating the routing and authorization steps required before a quote can become effective.
• SEND_TERMINATE_QUOTE — Transmits a termination quote, supporting the end-of-term or early-termination business flows handled by the contracts and leasing quote engine.

Tables Accessed

The documented table reference for this package is limited to PLITBLM, an APPS synonym. This is a standard Oracle tool used in PL/SQL table-to-record conversion scenarios, consistent with the wrapper design described in the header comment. The substantive quote, assignment, and quantity-per-vehicle data is exchanged through the three table-type parameters rather than through direct DML, meaning the bulk of the underlying persistence is performed by the delegated record API and its own dependent packages.

Usage Notes

Because the package is classified PVT, it is not intended for direct invocation by end users or by customer-written code. It is called internally by the quote-creation stack, typically from Oracle Forms quote screens and from concurrent or batch processes that build termination quotes. It is referenced by one other package in the ETRM dependency graph, confirming its role as a subordinate implementation module rather than a public interface.

The g_level_statement constant that prompted the search is one of three FND_LOG level constants declared at the top of the body, alongside the procedure and exception levels. It is passed to OKL_DEBUG_PUB.Check_Log_On to determine whether statement-level diagnostics should be emitted for the fully qualified module name. Customizations should not alter this package; debugging should instead be controlled through the standard OKL debug logging profile options.