Search Results qp_prl_loader_pub




Overview
Explore in AI Chat

Overview

QP_PRL_LOADER_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name derives from "Price List Loader," and its business purpose is to load price list and pricing-related data from the Oracle Pricing interface tables into the base pricing entities used by Oracle Advanced Pricing. In the Oracle EBS 12.1.1 and 12.2.2 releases, pricing data — including price list headers, price list lines, pricing attributes, and qualifiers — is staged in interface tables via concurrent programs, flat-file loads, or external integrations, and then validated and applied to the transactional pricing schema. QP_PRL_LOADER_PUB is the public API that drives that validation and application process, typically as part of the broader price list import and concurrent processing model.

The package is classified as PUB, meaning it is documented for public use and is intended to be callable by external components and custom code. This is significant because it allows integrators to invoke price list loading logic programmatically without directly manipulating the interface or base tables, thereby preserving the integrity and validation rules enforced by Oracle Advanced Pricing.

Key Procedures and Functions

The documented metadata identifies two overloaded procedures, both named LOAD_PRICE_LIST. Although their signatures differ, both share the core purpose of loading price list data into the Oracle Pricing schema.

  • LOAD_PRICE_LIST (overload 1): This variant accepts a process identifier and a request type code, and returns status and error information through output parameters. It is designed to be called when the caller requires programmatic feedback on the result of the load operation, including a status indicator and an error message string. The presence of the request type code parameter reflects integration with Oracle's concurrent processing framework, allowing the loader to behave appropriately depending on how it was invoked.
  • LOAD_PRICE_LIST (overload 2): This variant accepts a process identifier, a request type code, and an action code. Rather than returning status through output parameters, it relies on the action code to determine the behavior to be performed (for example, a validation versus an application action). This overload is suited for callers that drive the loader through an action-oriented interface.

Both procedures operate against the same interface and base schema, so the choice between them depends on whether the invoking program requires explicit status and error output or an action-code-driven control flow.

Tables Accessed

The documented tables accessed by this package are the Oracle Pricing interface tables, accessed through APPS synonyms:

  • QP_INTERFACE_LIST_HEADERS: Stores the staged header-level information for price lists being imported, such as list name, currency, and effective dates.
  • QP_INTERFACE_LIST_LINES: Stores the staged line-level pricing information, including item, price, and pricing unit details associated with each price list header.
  • QP_INTERFACE_PRICING_ATTRIBS: Holds pricing attribute values used to qualify price list lines, enabling attribute-based pricing during the load.
  • QP_INTERFACE_QUALIFIERS: Contains qualifier records that define the conditions under which price list lines apply.

The package reads these interface tables to validate incoming data and then writes the resulting validated records into the corresponding Oracle Pricing base entities. This two-step model — interface staging followed by validated application — is characteristic of Oracle's import architecture and ensures that only clean, fully validated pricing data reaches the transactional schema.

Usage Notes

QP_PRL_LOADER_PUB is typically invoked in the context of price list import and batch loading. The most common invocation paths include the Oracle Pricing concurrent programs that process interface data, and custom or third-party integration code that stages records in the QP_INTERFACE tables and then calls the loader API to validate and apply them. The referenced-by metadata indicates that at least four other packages call this API, confirming its role as a shared, reusable entry point rather than a private implementation detail.

When invoking the package, callers should populate the interface tables first, then call the appropriate LOAD_PRICE_LIST overload with a valid process identifier. Because the package is classified PUB and is part of the documented API surface, it may be called directly from custom PL/SQL; however, direct manipulation of the underlying interface tables should be confined to the documented columns. The presence of the request type code in both overloads indicates the API anticipates execution within the concurrent manager framework, where request types govern conflict resolution and processing behavior. In 12.2.2 environments, the online patching adoption does not alter this package's signature, so integrations built on 12.1.1 remain compatible at the API level.