Search Results check_object_attribute




Overview
Explore in AI Chat

Overview

The APPS.AMS_OBJECTATTRIBUTE_PVT package is a private (PVT) PL/SQL API belonging to the Oracle Marketing (AMS) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. Its central business function is to manage the collection of descriptive attributes associated with marketing objects — campaigns, events, and event offerings — that are created and maintained through Oracle Marketing's custom setup framework. When a marketing object is instantiated, the application must determine which attributes apply to it based on the setup type chosen by the user, persist those attribute definitions against the object instance, and support subsequent modification of individual attribute values. This package encapsulates that logic so that it is performed consistently regardless of the calling context.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the definer, which is typical of seeded private APIs that are called from within the AMS application stack. It carries three documented procedures and references four tables through APPS synonyms. The object is classified as private, indicating it is not intended as a public integration interface; it is invoked internally by other AMS packages, six of which are documented as referencing it.

Key Procedures and Functions

  • CREATE_OBJECT_ATTRIBUTES — Creates all attributes used by a given marketing object (campaign, event, or event offering). The procedure validates that the supplied object type and setup type are valid, selects the attributes available for that setup type, and inserts them into the object attribute table. It also inserts the mandatory general attribute at display sequence zero, ensuring this attribute appears first for every object and is flagged as defined at creation time. This procedure is intended to be called whenever a new marketing object is created.
  • MODIFY_OBJECT_ATTRIBUTE — Handles changes to an existing attribute associated with a marketing object. Its documented purpose parallels the creation logic, providing the update path when attribute definitions or values for an object require adjustment after initial creation.
  • CHECK_OBJECT_ATTRIBUTE — Performs validation of object attribute data. This is the procedure surfaced when a user searches for "check_object_attribute", and it is the validation entry point used by callers before committing attribute changes.

All three procedures follow the standard EBS PL/SQL API convention, accepting API version, initialization, commit, and validation-level control parameters and returning standard x_return_status, x_msg_count, and x_msg_data out parameters. Exact parameter signatures are not reproduced here beyond what the documented metadata specifies.

Tables Accessed

  • AMS_CUSTOM_SETUP_ATTR — Read during object attribute creation to retrieve the set of attributes available for the selected setup type. This table defines the attribute template applied to new objects.
  • AMS_OBJECT_ATTRIBUTES — The primary transactional table into which attribute records for a specific object instance are inserted and updated.
  • AMS_OBJECT_ATTRIBUTES_S — The intersection or sequence-related table supporting object attribute processing, consulted alongside the base attribute table.
  • DUAL — Used for scalar evaluations and simple validation queries performed within the package's procedures.

Usage Notes

As a private API, AMS_OBJECTATTRIBUTE_PVT is not exposed as a public integration point. It is invoked indirectly by Oracle Marketing forms and by other AMS packages during campaign, event, and event offering creation and maintenance; the documented metadata identifies six dependent packages. Custom code should avoid calling this package directly. Developers requiring attribute creation or validation functionality should instead use the corresponding public AMS APIs, which internally delegate to this private layer, thereby preserving upgrade safety across EBS 12.1.1 and 12.2.2.