Search Results qp_prc_contexts_translate_row




Overview
Explore in AI Chat

Overview

QP_LOADER_DIST_PUB is a public PL/SQL package in the Oracle E-Business Suite APPS schema that supports the Oracle Advanced Pricing (QP) module. Its role is to load and translate the seeded and customizable configuration metadata that defines pricing contexts, pricing segments, and the relationships between them. In the Advanced Pricing data model, a pricing context represents a logical grouping of qualifier attributes (for example, Customer, Order Type, or Item), while segments define the individual attribute components that participate in qualifier matching. QP_LOADER_DIST_PUB provides the procedural entry points by which this context-and-segment metadata is inserted, updated, and localized across languages. It is classified as a public API (AUTHID CURRENT_USER), meaning it executes with the privileges of the calling user and is intended for use by Oracle's own loader and upgrade utilities rather than as an end-user-facing interface. The package is widely associated with the distribution and upgrade of Advanced Pricing qualifier metadata across environments.

Key Procedures and Functions

  • QP_PRC_CONTEXTS_TRANSLATE_ROW — Loads or updates the translated (language-specific) information for a pricing context. It is invoked when the descriptive name and description attributes of a context must be populated in a given language, driving the multilanguage records that back the pricing context.
  • QP_PRC_CONTEXTS_LOAD_ROW — Loads or updates the base (non-translated) definition of a pricing context, including its code, type, seeded and enabled flags, owning application, and audit columns. This procedure establishes the core pricing context record.
  • QP_SEGMENTS_TRANSLATE_ROW — Loads or updates the translated information for a pricing segment, supplying the language-specific seed names and descriptions that describe the segment and its formatting.
  • QP_SEGMENTS_LOAD_ROW — Loads or updates the base definition of a pricing segment, capturing the segment code, associated context, availability, mapping column, value set, precedence, format type, and required flag. This procedure establishes the core segment record tied to a pricing context.

Tables Accessed

Through APPS synonyms, the package reads and writes the principal Advanced Pricing context and segment tables: QP_PRC_CONTEXTS_B (base table), QP_PRC_CONTEXTS_S (the corresponding translated, or TL-style, seed table), QP_PRC_CONTEXTS_TL (translation table), QP_SEGMENTS_B, QP_SEGMENTS_S, and QP_SEGMENTS_TL. It also references the value-set repository FND_FLEX_VALUE_SETS when resolving segment flex value sets, and FND_LANGUAGES to identify valid languages for translation records. QP_UPGRADE_ERRORS is used to log errors encountered during loading or upgrade operations, and DUAL is used for single-row lookups and validations. The B, S, and TL table family reflects Oracle's standard multilanguage object pattern.

Usage Notes

QP_LOADER_DIST_PUB is typically invoked by Oracle-supplied seed data loaders, patching, and upgrade utilities rather than from ordinary forms. It is most commonly called during the installation, patching, or upgrade of Oracle Advanced Pricing, when seeded pricing contexts and segments must be distributed into a target environment, and it may also be executed to enable or refresh translated context and segment descriptions. Because the procedures accept scalar VARCHAR2 parameters mirroring the columns of the underlying tables, custom load scripts and data-migration routines can call the package directly to programmatically create or update pricing contexts and segments. Developers should be aware that it operates under AUTHID CURRENT_USER, and any custom invocation should supply valid language, application, and value-set references to avoid entries in QP_UPGRADE_ERRORS.