Search Results init_deliv_rec

Overview

APPS.AMS_DELIVERABLE_PVT is a private PL/SQL package within the Oracle E-Business Suite Marketing (AMS) module. It encapsulates the core business logic governing the creation, maintenance, validation, and lifecycle management of marketing deliverables—the tangible assets, collateral, and offer items associated with marketing activities and campaigns. As a private (PVT) package, it is not intended to be called directly by external consumers; instead, it functions as the implementation layer behind the public application programming interface exposed by AMS_DELIVERABLE_PUB, and it is invoked by workflow components, approval logic, and the public wrapper packages. The package adheres to the standard EBS API architecture, relying on FND_API for error handling, message stacking, and the standard API return-status conventions, and on JTF_PLSQL_API for shared utility routines. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and it remains a foundational dependency for deliverable-related processing across the AMS schema.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions within AMS_DELIVERABLE_PVT, covering the full deliverable lifecycle:

• CREATE_DELIVERABLE — Inserts a new deliverable record, populating base and translation tables and establishing the initial status and setup attributes.
• UPDATE_DELIVERABLE — Modifies an existing deliverable's attributes and descriptive information.
• DELETE_DELIVERABLE — Removes a deliverable and its associated dependent records.
• LOCK_DELIVERABLE — Acquires a logical lock on a deliverable to serialize concurrent modification attempts.
• VALIDATE_DELIVERABLE — Performs business-rule validation on deliverable data prior to persistence.
• CHECK_DELIV_ITEMS — Verifies the component items or kit items associated with a deliverable.
• CHECK_DELIV_RECORD — Confirms the existence and integrity of a deliverable record.
• INIT_DELIV_REC — Initializes the deliverable record structure, typically populating default values in preparation for creation.
• COMPLETE_DELIV_REC — Finalizes the deliverable record, completing any post-processing required before commit.

Parameter lists are not enumerated here; consumers should reference the package specification for exact signatures.

Tables Accessed

The package reads and writes several core AMS tables through APPS synonyms. AMS_DELIVERABLES_ALL_B stores the base deliverable definitions, with AMS_DELIVERABLES_ALL_B_S providing the primary key sequence and AMS_DELIVERABLES_ALL_TL holding language-specific translated descriptions. AMS_DELIV_KIT_ITEMS captures component item relationships for deliverable kits, while MTL_SYSTEM_ITEMS_B supplies inventory item master data referenced by deliverables. AMS_CUSTOM_SETUPS_B and AMS_CUSTOM_SETUP_ATTR provide configurable custom setup attributes, and AMS_OBJECT_ASSOCIATIONS links deliverables to related marketing objects. AMS_USER_STATUSES_B supplies the user-defined status values governing workflow, AMS_ACT_BUDGETS provides budget context, FND_LANGUAGES supports translation handling, and DUAL and PLITBLM support internal PL/SQL operations.

Usage Notes

AMS_DELIVERABLE_PVT is invoked indirectly rather than through direct calls. The public package AMS_DELIVERABLE_PUB delegates its operations to this private package, and workflow activity components such as AMS_WFCMPAPR_PVT and AMS_APPROVAL_SUBMIT_PVT call it during approval and completion processing. The concurrent-request copy logic in AMS_COPYACTIVITIES_PVT also references it. The user-status helper packages AMS_DELIVERABLE_CUHK and AMS_DELIVERABLE_VUHK, together with the wrapper AMS_DELIVERABLE_PVT_W, depend on it for status transition logic. Customizations should target the public API (AMS_DELIVERABLE_PUB) rather than this private package, since its signatures and internal behavior are subject to change across patches and releases. When troubleshooting deliverable creation, update, or status-transition errors, review FND_API message stack output surfaced by these callers.