Search Results modifier_operation

Overview

PV_OFFER_PUB is a public PL/SQL API package owned by the APPS schema in Oracle E-Business Suite, shipping as part of the Oracle Trade Management (formerly Oracle Marketing) module. Its source header (pvxvoffs.pls) places the package in the pricing and offer-management layer of the ETRM data model. The package exposes a programmatic interface for creating and maintaining offer records together with their associated discount lines, qualifiers, product relationships, and budget assignments.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer. This is the standard convention for EBS public APIs that are invoked from multiple entry points, including concurrent programs, forms, and external integration code. The presence of a single public entry point, CREATE_OFFER, indicates that offer creation is the primary supported operation, while update and delete processing is handled through the operation fields embedded in the record structures rather than through separate API calls.

The global record and collection types defined in the specification — Modifier_LIST_Rec_Type, discount_line_rec_type, and discount_line_tbl_type — establish the attribute contract used by callers. Each scalar field defaults to the appropriate Fnd_Api.g_miss_num or g_miss_char sentinel, the standard EBS pattern for distinguishing "not supplied" from "explicitly null." The record includes business attributes such as OFFER_TYPE, OFFER_CODE, USER_STATUS_ID, BUDGET_AMOUNT_TC, TRANSACTION_CURRENCY_CODE, and the operation control fields OFFER_OPERATION and MODIFIER_OPERATION.

Key Procedures and Functions

• CREATE_OFFER — The single documented public procedure. It creates an offer header and its associated child entities using the modifier and discount-line record structures described in the package specification. The procedure accepts the offer attributes together with the discount line collection and qualifier information required to fully define a pricing offer. The OFFER_OPERATION and MODIFIER_OPERATION fields on the record drive the operation the API performs on the offer and its modifier lines respectively, so a single call can create, update, or otherwise process the supplied data according to those values.

No other procedures or functions are documented for this package in the ETRM metadata.

Tables Accessed

• OZF_OFFERS — The master offer table. CREATE_OFFER writes the offer header record here, including offer type, code, status, and currency information.
• OZF_OFFER_DISCOUNT_LINES — Stores the discount lines belonging to the offer, populated from the discount_line_tbl_type collection passed by the caller.
• OZF_OFFER_QUALIFIERS — Holds the qualifier definitions that determine which transactions or customers are eligible for the offer.
• OZF_DISCOUNT_PRODUCT_RELN — Maintains the relationship between discount lines and the products or product hierarchies to which they apply.
• OZF_ACT_BUDGETS — Records budget amounts associated with the offer, consistent with the BUDGET_AMOUNT_TC and BUDGET_OFFER_YN attributes in the modifier record.
• PLITBLM — A standard EBS PL/SQL table used internally for handling collection data during API processing.

Usage Notes

PV_OFFER_PUB is typically invoked from the Oracle Trade Management offer setup forms, from concurrent programs that load offer data in bulk, and from custom integration code that creates offers programmatically. Because the package is classified as a public API, direct calls from custom code are supported provided callers populate the record structures correctly and respect the sentinel defaults. At least one other package in the ETRM schema references this API, indicating that internal components also depend on it for offer creation. Developers should note that only CREATE_OFFER is exposed publicly; offer modification and deletion are expected to be expressed through the operation fields rather than through dedicated procedures.