Search Results ozf_funds_pub




Overview
Explore in AI Chat

Overview

APPS.OZF_OFFER_PUB is the public application programming interface for the Oracle Trade Management (formerly Oracle Offers) offer-processing engine in Oracle E-Business Suite 12.1.1 and 12.2.2. It resides in the APPS schema and is classified as a PUB (public) API, meaning it is designed to be called by external packages, concurrent programs, and custom extensions rather than being an internal implementation detail. The package orchestrates the creation, validation, and modification of trade promotion offers ("offers"), which represent promotional campaigns, deals, and incentive programs extended to customers and channels. It acts as the transactional entry point through which offer data — including product eligibility, accrual and budget associations, currency attributes, and modifier (adjustment) definitions — is persisted into the underlying Trade Management tables.

Key Procedures and Functions

  • PROCESS_MODIFIERS — Processes modifier records associated with an offer. Modifiers define the pricing or accrual adjustments (for example, percentage off, fixed amount, or list-line qualifications) that apply to the offer. This procedure validates and applies those modifier definitions against the offer's supporting data.
  • PROCESS_VO — Processes an offer using a view-object (VO) or Java-based integration structure. The "VO" naming convention indicates that this entry point accepts an offer payload assembled from the Trade Management middle-tier object model, allowing the Java/Forms layer to pass offer attributes and child entities into PL/SQL for persistence and business-rule enforcement.
  • PROCESS_OFFER_FROM_ADAPTER — Processes an offer that originates from an external adapter. This procedure supports the integration layer that accepts offers supplied by third-party or upstream systems, mapping adapter input into the standard offer structures so the offer is created and made consistent with Trade Management conventions.

Tables Accessed

The package reads and writes through APPS synonyms to the core Trade Management and shared reference tables. OZF_OFFERS holds the offer header and detail records. OZF_FUNDS_ALL_B stores the funds and budget associations linked to offers, while OZF_ACT_BUDGETS captures budget activity against those offers. Offer-to-product eligibility is maintained in AMS_ACT_PRODUCTS and OZF_XREF_MAP, with product master validation against MTL_SYSTEM_ITEMS. Modifier and qualification list data is drawn from QP_LIST_LINES, and the related PL/SQL list table type PLITBLM is used for in-memory list processing. Currency and resource context come from FND_CURRENCIES and JTF_RS_RESOURCE_EXTNS, and audit/user context is derived from FND_USER.

Usage Notes

OZF_OFFER_PUB is invoked from the Trade Management forms and business-object layer, from concurrent programs that build and refresh offers, and from custom PL/SQL integrations. The dependency metadata shows that APPS.OZF_FUNDS_PUB — the funds public API returned by the search term "ozf_funds_pub" — references OZF_OFFER_PUB, and the package is also referenced by OZF_OFFER_PUB_OAW, OZF_OFFER_PUB_W, OZF_QUOTA_PUB, and PV_OFFER_PUB. The OAW and _W variants are the object-attribute-wrapper and Java wrapper forms used by the middle tier, confirming that standard invocation flows from the OAF/Forms user interface through the wrapper into OZF_OFFER_PUB. Integrators should prefer these public procedures over direct DML against OZF_OFFERS, because the package relies on FND_API and SYS.STANDARD to perform validation, standard error handling, and consistent seeding of offer records. Trace and debug should be enabled at the wrapper level to observe payload construction before the call into the public API.