Search Results ozf_offer_pub_oaw




Overview
Explore in AI Chat

Overview

The APPS.OZF_OFFER_PUB_OAW package is an internal Oracle E-Business Suite PL/SQL unit belonging to the Oracle Trade Management (formerly Oracle Offers / iStore promotions) module, identified by the OZF application prefix. The OAW suffix designates that this package is an OA Framework (Oracle Application Framework) interaction wrapper. It exists to bridge the strongly typed PL/SQL collection structures declared in OZF_OFFER_PUB (the public Offers API) and the weakly typed, generic JTF collection types (JTF_NUMBER_TABLE and JTF_VARCHAR2_TABLE_100) that the OA Framework and its "Rosetta" data-conversion layer can marshal between the middle tier and the database.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the definer, and the version stamp (ozfaofps.pls 120.1, dated 2005) indicates it has been stable and largely unchanged from 11i through the 12.1.1 and 12.2.2 releases. Its API classification is OTHER, confirming that it is not a supported public interface but an infrastructure component consumed internally by the OA Framework offers pages.

Key Procedures and Functions

The ETRM metadata documents twenty-six procedures in this package. All are named according to the pattern ROSETTA_TABLE_COPY_IN_P<n> and ROSETTA_TABLE_COPY_OUT_P<n>, where <n> is a numeric suffix that identifies a distinct parameter signature. The documented suffixes are 2, 4, 6, 8, 10, 12, 14, 17, 19, and 21 (both IN and OUT variants are listed for each), with the excerpt additionally showing the IN signature for P2, OUT for P2, and IN for P4.

Two functional families exist:

  • ROSETTA_TABLE_COPY_IN_P<n> — Converts inbound generic JTF tables (positional scalar arrays passed by the OA Framework) into a strongly typed OZF_OFFER_PUB record or table type. The snippet shows P2 targeting ozf_offer_pub.act_product_tbl_type and P4 targeting ozf_offer_pub.discount_line_tbl_type, accepting up to twenty-three positional arguments (a0–a22) of alternating numeric and varchar2 collection types.
  • ROSETTA_TABLE_COPY_OUT_P<n> — The inverse operation, unpacking a populated OZF_OFFER_PUB table type back into the individual JTF_NUMBER_TABLE / JTF_VARCHAR2_TABLE_100 out-parameters for transport to the middle tier.

Each numeric suffix corresponds to a different Offers entity type (for example, active products, discount lines, and other promotion sub-entities), with the differing count of arguments reflecting the width of each entity's row structure. No business logic, validation, or DML is performed by these procedures; they are purely structural marshalling routines.

Tables Accessed

The only documented table reference is PLITBLM, reached through an APPS synonym. PLITBLM is the standard Oracle EBS "PL/SQL Interface Table for BoL/MLS" utility that manages multi-lingual and index-by table handling within the PL/SQL toolkit. Its appearance here reflects the package's role in supporting the toolkit's name-value and table-transfer plumbing rather than any direct read or write of Trade Management transactional data. The procedures manipulate in-memory PL/SQL collections and do not themselves issue SELECT, INSERT, UPDATE, or DELETE against the Offers schema tables; the actual persistence of offer, product, and discount-line data is handled by the OZF_OFFER_PUB routines for which this wrapper prepares the payload.

Usage Notes

APPS.OZF_OFFER_PUB_OAW is never invoked directly by end users or by customer-written concurrent programs. It is called by generated OA Framework business-component code and by the framework's Rosetta integration layer whenever an Offers-based page (such as offer creation, product eligibility maintenance, or discount line editing) needs to pass a multi-row collection between the Java middle tier and the PL/SQL API.

  • Framework invocation: The OA Framework detects that an API expects a PL/SQL table parameter and selects the matching COPY_IN or COPY_OUT variant by signature size. The numeric suffixes allow the framework to bind collections of different entity widths without overloading ambiguity.
  • Internal-only status: Because the package is classified as OTHER and is referenced by zero other documented packages, customizations that call it directly are unsupported and will be vulnerable to patch changes in the OZF_OFFER_PUB record definitions.
  • Compatibility: Behaviour is consistent across 12.1.1 and 12.2.2; the 120.1 version stamp and 2005 date suggest no regressions are expected between these releases.
  • Debugging: Errors here typically surface as ORA-06531 (uninitialized collection) or type-mismatch exceptions during offer page submission, indicating a mismatch between the framework's expected parameter signature and the database package version.