Search Results user_profile_missing

Overview

AMS_ITEM_SECTION_PVT is a private PL/SQL package in the Oracle E-Business Suite Advanced Marketing (AMS) module. Its business purpose is to manage the association between marketing items and sections — that is, to establish and remove the link that records which items belong to which item sections, together with the supporting attributes such as start and end dates, sort order, and association reason code. The package follows the standard EBS API programming model, exposing the conventional parameters p_api_version, p_init_msg_list, p_commit, and p_validation_level together with the standard output parameters x_return_status, x_msg_count, and x_msg_data. It begins execution with a SAVEPOINT, performs a compatibility check through FND_API.Compatible_API_Call, and initializes the message list via FND_MSG_PUB when requested. The "PVT" suffix indicates that this is a private, internal API intended to be called by other AMS packages rather than directly by end users. The header history records the package as created on 22 January 2001 and revised on 17 May 2002 to remove references to the G_USER_ID global, reflecting the shift of user context handling to the standard FND_GLOBAL facilities.

Key Procedures and Functions

Two documented procedures constitute the public interface of the package:

• CREATE_ITEM_SEC_ASSOC — Creates the association between a marketing item and a section. It accepts the standard API control parameters, a validation level, and an input record of type section_rec_type describing the association to be created. Internally it declares several JTF collection types — JTF_NUMBER_TABLE, JTF_DATE_TABLE, JTF_VARCHAR2_TABLE_300 — to carry section identifiers, start and end dates, sort order, and association reason codes through the processing logic. The procedure is the primary entry point for binding items into sections.
• DELETE_ITEM_SEC_ASSOC — Removes an existing item-to-section association. It complements the create procedure and gives callers the means to reverse or expire an association previously established through CREATE_ITEM_SEC_ASSOC.

Parameter lists are not reproduced here; the documented procedures should be invoked only through their declared API signatures as defined in the package specification.

Tables Accessed

The documented table reference for this package is PLITBLM (accessed through its APPS synonym). This is the standard FND message/translation table used by the message-handling infrastructure, and it is referenced in support of the FND_MSG_PUB message list processing rather than as part of the marketing item-section business logic itself. The underlying item and section association data is manipulated through the AMS base tables that the package's collection variables feed into during the create and delete operations.

Usage Notes

Because AMS_ITEM_SECTION_PVT is classified as a private API and is referenced by zero other documented packages, it is not intended for direct invocation by external or customer code. It is typically called from within the AMS marketing setup and item-section maintenance flows — for example, from the forms and utilities that let marketing administrators assign catalog items to sections. Callers must pass a valid API version, set p_init_msg_list and p_commit appropriately, and inspect x_return_status on return. Note that the historical reference to user_profile_missing is not addressed by this package's documented content; missing profile option values are generally diagnosed through FND_PROFILE rather than through this API. Custom code should use the public AMS APIs rather than this private package.