Search Results load_ins_header

Overview

QP_BULK_UTIL is a utility package in the Oracle Advanced Pricing (QP) module of Oracle E-Business Suite, owned by the APPS schema and classified as a UTIL (utility) API. It provides the low-level insert, update, and delete operations used by the bulk loader infrastructure to move pricing data from the QP interface staging tables into the base pricing tables. Its procedures mirror the record structures defined in QP_BULK_LOADER_PUB, operating on header, line, qualifier, and pricing attribute records. The package is not a business-facing API in the same sense as QP_BULK_LOADER_PUB, but rather the internal workhorse invoked during the bulk load cycle to persist or remove staged pricing entities.

Key Procedures and Functions

• LOAD_INS_HEADER — Loads interface header records for insert processing based on a request ID, returning a header record.
• LOAD_UDT_HEADER — Loads interface header records for update or delete processing based on a request ID, returning a header record.
• INSERT_HEADER — Inserts a pricing list header from the supplied header record.
• INSERT_LINE — Inserts a pricing list line from the supplied line record.
• INSERT_QUALIFIER — Inserts a qualifier from the supplied qualifier record.
• INSERT_PRICING_ATTR — Inserts a pricing attribute from the supplied attribute record.
• UPDATE_HEADER — Updates an existing pricing list header.
• UPDATE_LINE — Updates an existing pricing list line.
• UPDATE_LINE_TO_OLD — Updates a line to its prior (old) state; annotated with bug reference 6028305.
• UPDATE_QUALIFIER — Updates an existing qualifier.
• UPDATE_PRICING_ATTR — Updates an existing pricing attribute.
• DELETE_HEADER — Deletes header data for a given request ID; the primary entry point relevant to the "delete_qualifier" search.
• DELETE_LINE — Deletes line data for a given request ID.
• DELETE_QUALIFIER — Deletes qualifier data for a given request ID. All four delete procedures accept a single numeric request ID parameter.
• DELETE_PRICING_ATTR — Deletes pricing attribute data for a given request ID.

All INSERT and UPDATE procedures use IN OUT NOCOPY record parameters based on QP_BULK_LOADER_PUB types, allowing the caller to receive any values populated during processing.

Tables Accessed

The package reads and writes the QP interface and base pricing tables through APPS synonyms: QP_INTERFACE_LIST_HEADERS, QP_INTERFACE_LIST_LINES, QP_INTERFACE_QUALIFIERS, and QP_INTERFACE_PRICING_ATTRIBS for staging data; QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL for list headers; QP_LIST_LINES for list lines; QP_QUALIFIERS for qualifiers; and QP_PRICING_ATTRIBUTES and QP_PRICING_ATTRIBUTES_S for pricing attributes. QP_INTERFACE_ERRORS and QP_INTERFACE_ERRORS_S capture processing errors, QP_RLTD_MODIFIERS holds related modifier relationships, FND_LANGUAGES supports translatable (TL) table handling, and DUAL is used for standard PL/SQL queries.

Usage Notes

QP_BULK_UTIL is invoked indirectly by the pricing bulk loader rather than called directly by end users. The procedures are driven by concurrent programs or wrapper logic in QP_BULK_LOADER_PUB, using a request ID to correlate the rows being processed. Delete operations such as DELETE_QUALIFIER are used when rollback or cleanup of a bulk load is required, removing staged or persisted qualifier rows associated with that request. The package is referenced by one other package and should be treated as internal; customizations should call QP_BULK_LOADER_PUB where a supported public interface exists.