Search Results modify_object_attribute

Overview

AMS_OBJECTATTRIBUTE_PVT is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle Marketing (AMS) product family and supports the attribute infrastructure used by the Oracle Marketing object model. In Oracle EBS, marketing entities such as campaigns, events, offers, and one-to-many lists are described by flexible, extensible attribute definitions. The AMS_OBJECTATTRIBUTE_PVT package encapsulates the internal logic required to create, modify, and validate those object attribute definitions, shielding the underlying data model from direct manipulation.

The package is classified as a private (PVT) API, meaning it is not intended as a public integration surface. It is consumed internally by other AMS packages rather than by external interfaces. ETRM documents six dependent packages that reference it, and the package body itself depends on AMS_OBJECT_ATTRIBUTES, AMS_OBJECT_ATTRIBUTES_S, AMS_CUSTOM_SETUP_ATTR, AMS_UTILITY_PVT, FND_API, FND_GLOBAL, FND_MSG_PUB, and DUAL. This dependency profile confirms that the package participates in the standard EBS API framework, using FND_API for return status and FND_MSG_PUB for error message handling.

Key Procedures and Functions

ETRM documents three procedures or functions within the package body:

• CREATE_OBJECT_ATTRIBUTES — Creates one or more object attribute definitions for a given marketing object. It is the principal entry point for registering an attribute against an AMS object type and is responsible for seeding the base attribute rows in the supporting tables.
• MODIFY_OBJECT_ATTRIBUTE — Updates an existing object attribute definition. It handles changes to attribute metadata while preserving referential integrity with the attribute definition records and any associated setup attributes.
• CHECK_OBJECT_ATTRIBUTE — Performs validation on an object attribute prior to creation or modification. The procedure enforces business rules and data consistency, returning status information through the standard API messaging framework.

No parameter lists are documented in ETRM for these units; consumers should treat them as internal and reference the package specification for exact signatures.

Tables Accessed

The package body reads from and writes to the following documented tables through APPS synonyms:

• AMS_OBJECT_ATTRIBUTES — The primary table storing object attribute definitions. CREATE_OBJECT_ATTRIBUTES inserts here and MODIFY_OBJECT_ATTRIBUTE updates existing rows.
• AMS_OBJECT_ATTRIBUTES_S — The secondary (translation/security) table companion to AMS_OBJECT_ATTRIBUTES, maintained in parallel to keep the attribute definition synchronized.
• AMS_CUSTOM_SETUP_ATTR — Holds custom setup attribute configuration, consulted to align user-defined attributes with the standard object attribute framework.
• DUAL — Used for single-row selection, typically for sequence or date lookups within the API logic.

Usage Notes

Because AMS_OBJECTATTRIBUTE_PVT is a private package, it is normally invoked indirectly. The most common call paths are Oracle Marketing application forms and concurrent programs that configure object attributes, as well as other AMS APIs that delegate attribute persistence to this package. In EBS 12.1.1 and 12.2.2 the package remains valid and is not referenced by any database object outside the AMS dependency chain, reinforcing its internal role.

Custom code should not call this package directly; the supported approach is to use the public AMS APIs and let them route through AMS_OBJECTATTRIBUTE_PVT. Any direct invocation risks bypassing validation logic implemented in CHECK_OBJECT_ATTRIBUTE and FND_MSG_PUB error handling. When troubleshooting attribute creation or update failures, the FND_API return status and FND_MSG_PUB message stack produced by these procedures are the primary diagnostic sources.