Results for “ecx_party_id”

50+ results




Overview
Explore in AI Chat

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

Overview

OKL_INVOKE_PRICING_ENGINE_PVT is a private (PVT) PL/SQL package in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. As its name indicates, it serves as the integration bridge that invokes the pricing engine from within the lease and finance contract lifecycle. The package is defined in source file OKLRSSMS.pls and is owned by APPS with AUTHID CURRENT_USER. Its header dates to 2002, reflecting its origins in the early release of the OKL product family, and it remains documented in ETRM for both 12.1.1 and 12.2.2.

The package's principal role is to generate pricing stream records tied to a lease or loan contract. Pricing streams represent the projected cash flows — rentals, depreciation, interest, and residual amounts — produced when the pricing engine processes the financial terms of a contract. By encapsulating the call mechanics, the package shields calling APIs from the lower-level interface to the pricing engine.

Key Procedures and Functions

The ETRM metadata documents a single procedure for this package:

  • GENERATE_STREAMS_ST — The entry point that triggers stream generation for a pricing request. The _ST suffix follows the OKL/OKC API naming convention, indicating a standard-style interface that returns a status rather than raising unhandled exceptions to the caller. It drives the pricing engine to produce the numeric stream lines for the contract under consideration.

No other procedures or functions are documented. The package header declares a substantial block of global constants — error token names, missing-value indicators (G_MISS_NUM, G_MISS_CHAR, G_MISS_DATE), return-status values, and defined exceptions (G_EXCEPTION_HALT_PROCESSING, G_EXCEPTION_ERROR, G_EXCEPTION_UNEXPECTED_ERROR). These support structured error propagation consistent with OKL_API conventions.

The header also defines XML Gateway transaction constants: G_XMLG_TRX_TYPE = 'OKL_ST' plus subtypes including LSBO, LNBO, LSRO, LNRO, LSBI, LNBI and others. These encode lease/loan book-out, restructure-out, and corresponding book-in operations, indicating the package participates in events routed through or posted to the XML Gateway.

Tables Accessed

No base tables are documented in the ETRM metadata because the package accesses its data through APPS synonyms rather than direct object references, and the metadata does not enumerate those synonyms. Functionally, the package works within the OKL contract schema to populate pricing stream results that are typically persisted in the stream tables (for example, OKL_TRX_STRMS) via the calling layer. Its work builds upon contract header and line information maintained in the OKL tables and hands generated results back to the invoking API for storage and downstream processing.

Usage Notes

As a private API, OKL_INVOKE_PRICING_ENGINE_PVT is not intended for direct invocation by end users or external customizations. ETRM records that the package is referenced by four other packages, confirming that its callers are higher-level OKL APIs and that it sits at an internal integration tier.

Typical invocation paths are:

  • OKL contract APIs invoked from the Lease and Finance contract entry forms or from concurrent programs that book, restructure, or reprice a contract.
  • XML Gateway processing for the OKL_ST transaction types noted above, where inbound or outbound messages drive pricing stream generation.
  • Other OKL routine APIs that delegate pricing to this package as part of a larger transaction flow.

Regarding the searched term ecx_party_id: this value is a party identifier used by the e-commerce/XML Gateway layer (Migration/ECX tables). It appears in the metadata context because XML Gateway transactions handled by OKL routinely carry party context, and the package's involvement in OKL_ST message flows places it logically near such party identifiers. The package header itself contains no declared ecx_party_id parameter, so any such value is passed through the higher-level calling interface rather than held by this private package.