Results for “ams_deliverable_pvt_w”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.AMS_DELIVERABLE_PVT_W is a private PL/SQL package belonging to the Oracle Marketing (AMS) application schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The "_PVT" suffix denotes that this is a private API package, intended to encapsulate the internal business logic that supports the public deliverable management APIs and the Marketing Deliverables (AMS_DELIVERABLE) entity. It provides the procedural foundation for creating, maintaining, validating, and completing deliverable records used within marketing campaigns and related promotional activities.

The package status is VALID in the ETRM metadata, and its API classification is listed as OTHER, indicating it is not a formally published public interface. It depends on FND_API and the SYS STANDARD package, which is characteristic of Oracle's Application Programming Interface design pattern, where PL/SQL APIs follow standardized error-handling, message-stack, and savepoint conventions defined in FND_API.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within this package. Their names and inferred purposes are as follows:

• CREATE_DELIVERABLE — Inserts a new deliverable record, establishing the core attributes required to represent a deliverable within the marketing data model.
• UPDATE_DELIVERABLE — Modifies the attributes of an existing deliverable, supporting change management throughout the deliverable lifecycle.
• VALIDATE_DELIVERABLE — Performs validation checks on deliverable data prior to persistence, ensuring data integrity and business rule compliance.
• CHECK_DELIV_ITEMS — Verifies the deliverable items associated with a deliverable, supporting consistency and completeness checks against child records.
• CHECK_DELIV_RECORD — Validates the existence and integrity of a deliverable record, typically invoked before update or delete operations.
• INIT_DELIV_REC — Initializes a deliverable record structure, preparing an in-memory record for subsequent processing by the API.
• COMPLETE_DELIV_REC — Finalizes and persists a deliverable record, marking it as complete within the transactional workflow.

Consistent with Oracle's private API pattern, these routines are expected to operate on record-type parameters rather than long positional argument lists, though the ETRM documentation does not enumerate specific signatures.

Tables Accessed

The ETRM metadata excerpt does not enumerate the base tables accessed via APPS synonyms. Based on the package's function and its association with the AMS_DELIVERABLE entity, the routines logically operate against the AMS_DELIVERABLES and AMS_DELIVERABLE_ITEMS tables, plus related AMS marketing objects. CREATE_DELIVERABLE and UPDATE_DELIVERABLE perform DML on the deliverable master table, while CHECK_DELIV_ITEMS inspects the child items table.

Usage Notes

AMS_DELIVERABLE_PVT_W is referenced by no other packages per the ETRM metadata, but internal self-references are documented, indicating the package calls its own procedures. It is typically invoked indirectly through the public AMS deliverable API and the Oracle Marketing forms and concurrent programs that manage deliverables. Custom code should avoid calling this private package directly and instead use the corresponding public API, as private packages are subject to change between releases without notice. It is validated in both 12.1.1 and 12.2.2.