Search Results qp_prc_contexts_s

Overview

QP_LOADER_DIST_PUB is a public PL/SQL package body in the APPS schema that supports the distribution and loader layer of the Oracle Advanced Pricing (QP) module. Its primary business function is to load and translate pricing setup data — specifically pricing contexts and pricing segments — between staging representations and the base, sequence, and translation tables that back the pricing engine. In effect, it provides the row-level load and translation routines used when pricing context and segment definitions must be moved from a source or upgrade form into the live E-Business Suite tables.

The "_DIST_" naming convention indicates this package belongs to the distribution or migration path of the pricing data model rather than to the interactive pricing engine. It depends on QP_PRC_CONTEXTS_B, QP_PRC_CONTEXTS_S, and QP_PRC_CONTEXTS_TL for pricing contexts, and on QP_SEGMENTS_B, QP_SEGMENTS_S, and QP_SEGMENTS_TL for segments. It also references FND_FLEX_VALUE_SETS, FND_LANGUAGES, FND_GLOBAL, QP_UPGRADE_ERRORS, and DUAL, and it internally references its own specification QP_LOADER_DIST_PUB. ETRM records it as referenced by zero other database objects, marking it as a top-level entry point rather than a utility embedded within other PL/SQL units.

Key Procedures and Functions

The documented package exposes four public routines, organized as two load/translate pairs — one pair for pricing contexts and one for segments:

• QP_PRC_CONTEXTS_LOAD_ROW — Loads a single pricing context row, driving the base (QP_PRC_CONTEXTS_B) and sequence (QP_PRC_CONTEXTS_S) tables that define the context and its segment ordering.
• QP_PRC_CONTEXTS_TRANSLATE_ROW — Handles the translatable attribute columns of a pricing context through QP_PRC_CONTEXTS_TL, resolving language through FND_LANGUAGES and FND_GLOBAL.
• QP_SEGMENTS_LOAD_ROW — Loads a single pricing segment row into QP_SEGMENTS_B and QP_SEGMENTS_S, including validation against the flex value sets identified by FND_FLEX_VALUE_SETS.
• QP_SEGMENTS_TRANSLATE_ROW — Writes the translated description columns of a segment to QP_SEGMENTS_TL for the appropriate installed language.

No parameter lists are documented in the ETRM metadata; callers must obtain exact signatures from the package specification. The procedures are intended for programmatic, row-at-a-time invocation as part of a larger load driver.

Tables Accessed

The package reads and writes the following base, sequence, and translation tables. Base tables (QP_PRC_CONTEXTS_B, QP_SEGMENTS_B) store the language-independent definition of a context or segment; sequence tables (QP_PRC_CONTEXTS_S, QP_SEGMENTS_S) store the ordering of segments within a context; translation tables (QP_PRC_CONTEXTS_TL, QP_SEGMENTS_TL) store language-dependent text. FND_FLEX_VALUE_SETS supplies the value set definitions against which segment values are validated, and FND_LANGUAGES together with FND_GLOBAL identifies the language and session context for translation rows. QP_UPGRADE_ERRORS records failures encountered during loading so that rejected rows can be diagnosed. DUAL is used for trivial single-row selection or sequence lookups.

Usage Notes

QP_LOADER_DIST_PUB is typically invoked by Oracle's pricing data migration and upgrade routines rather than from an end-user form. Typical call sites include concurrent programs and loader drivers that iterate over staged pricing context and segment records and call the LOAD and TRANSLATE procedures per row. Because it is classified as a public (PUB) API and is not referenced by other database objects, it is also a valid target for custom code and data conversion scripts that must populate pricing contexts and segments with correct base, sequence, and translation records. Custom implementations should call the procedures in the proper order — load the base/sequence row first, then the translation row — and should inspect QP_UPGRADE_ERRORS after execution to confirm that no rows were rejected. As with all APPS public APIs, usage must respect multi-org and language session settings established by FND_GLOBAL.