Search Results qp_loader_pvt




Overview
Explore in AI Chat

Overview

QP_LOADER_PVT is a private PL/SQL package in the APPS schema that supports the Oracle E-Business Suite Oracle Pricing (QP) module. It provides row-level loader APIs used to seed and maintain Pricing Transaction Entity (PTE) configuration metadata. Specifically, the package handles the loading of source system definitions, source-system-to-functional-area mappings, and request type definitions, including their translated (multi-language) descriptions. These routines are part of the infrastructure that allows pricing transaction entities — the configurable entities that drive pricing and order capture behavior — to be registered and enabled within the application.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking session rather than the definer, which is typical for loader utilities invoked within setup or upgrade contexts. Its header carries the revision marker QPXVLDQS.pls 120.1, indicating it belongs to the Oracle Pricing seed data loader family.

Key Procedures and Functions

  • QP_PTE_SOURCE_SYS_LOAD_ROW — Loads a single Pricing Transaction Entity source system row. It registers a source system identified by a PTE code and application short name, together with an enabled flag, a custom mode indicator, a last-update date, and an owner value. This procedure populates the source system registry used by pricing to recognize originating systems.
  • QP_PTE_SS_FN_AREA_LOAD_ROW — Loads a source system to functional area association. It links a PTE code and application short name to a functional area identifier, carrying enabled and seeded flags, a custom mode indicator, and audit/owner values. This defines which functional areas a given source system participates in.
  • QP_PTE_REQ_TYPES_LOAD_ROW — Loads a Pricing Transaction Entity request type definition. It records the PTE code and request type code along with order-level and line-level global structures and their corresponding view names, plus an enabled flag, description, custom mode indicator, and owner. This establishes the request types available for pricing processing.
  • QP_PTE_REQ_TYPES_TRANSLATE_ROW — Loads the translated description for a request type. It mirrors the request type loader parameters and is responsible for inserting translated (TL) description rows so that request type text is available in multiple languages.

All four procedures share a consistent parameter convention: identifiers, flags, a custom_mode indicator (supporting seeded versus customer-defined data), a last_update_date string, and an owner value. The package also declares a who_type record for standard WHO audit columns (created_by, creation_date, last_updated_by, last_update_date, last_update_login).

Tables Accessed

Usage Notes

QP_LOADER_PVT is a private (PVT) API and is not intended for direct customer invocation. It is referenced by zero other packages in the documented metadata, indicating it is called from seed data loader scripts, concurrent setup programs, or upgrade utilities rather than from the runtime pricing engine. It is typically executed during installation, patching, or setup of Pricing Transaction Entities to register source systems, functional area mappings, and request types programmatically.

The presence of custom_mode parameters reflects Oracle's standard seed data pattern, in which seeded rows are protected and customer-modified rows are preserved across upgrades. Because the package is AUTHID CURRENT_USER, callers must have appropriate privileges on the underlying QP and FND tables. The last_update_date and owner parameters align with Oracle's seed loader conventions for tracking record provenance and enabling merge-style upgrades.