Search Results create_deliv_kit_item

Overview

AMS_DELIVKITITEM_PVT is a private PL/SQL package in the Oracle E-Business Suite Oracle Marketing (AMS) module. It provides the core application programming interface for maintaining deliverable kit items, which are the line-level components that make up a deliverable kit such as a collateral package, event kit, or campaign bundle. The package encapsulates the create, update, delete, lock, and validation operations required to keep kit item data consistent while shielding callers from direct manipulation of the underlying AMS tables.

The package body is dated 2005 and carries a header of amsvdkib.pls 120.0, placing it in the AMS deliverable infrastructure. As a PVT (private) classification package, its procedures are intended to be invoked by other AMS packages or API layers rather than directly by end users. The ETRM metadata confirms it is referenced by five other packages, indicating a supporting role within the deliverable and kit management stack.

Key Procedures and Functions

The documented API exposes nine procedures and functions. Their purposes are summarized below; parameter signatures are not enumerated here, as the public contract is defined by the package specification.

• CREATE_DELIV_KIT_ITEM — Inserts a new deliverable kit item using the AMS_DELIV_KIT_ITEMS_S sequence to generate the primary key. The source excerpt shows it accepts an API version, an initialization flag, a commit flag, a validation level, a kit item record, and returns the new identifier along with standard FND_API return status, message count, and message data. It performs a count check and evaluates the kit_flag on AMS_DELIVERABLES_ALL_B to enforce the AMS_KIT_PART_CANNOT_BE_KIT business rule.
• DELETE_DELIV_KIT_ITEM — Removes a kit item, including the appropriate validation and cleanup of dependent rows.
• UPDATE_DELIV_KIT_ITEM — Modifies attributes of an existing kit item while reapplying consistency and validation rules.
• LOCK_DELIV_KIT_ITEM — Selects the row for update to provide pessimistic locking so concurrent sessions do not modify the same kit item simultaneously.
• VALIDATE_DELIV_KIT_ITEM — Applies the business validation rules for a kit item record, returning FND_API error and warning messages.
• CHECK_DELIV_KIT_ITEM_ITEMS — Verifies that the kit item's constituent records are internally consistent before an operation proceeds.
• CHECK_DELIV_KIT_ITEM_RECORD — Performs a record-level integrity check on a kit item, confirming required fields and existence.
• INIT_DELIV_KIT_ITE_REC — Initializes the kit item record structure to a known default state, typically before it is populated by a caller.
• COMPLETE_DELIV_KIT_ITEM_REC — Completes or finalizes the kit item record, deriving fields and ensuring all required data is present before the record is persisted.

Tables Accessed

The package operates against three documented AMS tables and DUAL.

• AMS_DELIV_KIT_ITEMS — The base table holding deliverable kit item rows. It is read for existence and count checks and written during create, update, and delete operations.
• AMS_DELIV_KIT_ITEMS_S — The sequence source used to generate unique kit item identifiers.
• AMS_DELIVERABLES_ALL_B — The parent deliverable table. The package reads kit_flag to determine whether a referenced deliverable is itself a kit, supporting the rule that a kit part cannot also be a kit.
• DUAL — Used solely to fetch the next sequence value.

Usage Notes

AMS_DELIVKITITEM_PVT is normally called from other AMS packages rather than from Oracle Forms or concurrent programs directly. In EBS 12.1.1 and 12.2.2 it follows the FND_API standard, so callers should pass the API version, honor the initialization and commit flags, and inspect x_return_status along with the message stack. Custom code should avoid referencing this private package directly, since its signature may change between releases; the supported route is through the AMS deliverable public APIs that wrap it.