Search Results update_profile_wrap

Overview

The APPS.IEM_PARAMETERS_PVT package is a private (PVT) PL/SQL API within the Oracle E-Business Suite (EBS) iRep / Interaction and Email Management (IEM) module family. It is owned by the APPS schema and carries a VALID status in both 12.1.1 and 12.2.2 releases. The package encapsulates the server-side logic required to read and persist configuration parameters and profile-style settings that govern IEM processing behaviour. Because it is classified as a "PVT" API, it is not intended as a public integration surface; it acts as the internal implementation layer that public IEM packages call into. In practice, IEM_PARAMETERS_PVT functions as the parameter management engine for the interaction management subsystem, allowing stored profile values to be selected for a given context and updated through a controlled, validated transaction path. Its dependency on FND_API confirms that it participates in the standard EBS API error-handling and savepoint conventions, ensuring that any failures raised during a parameter update can be rolled back consistently with the surrounding business transaction.

Key Procedures and Functions

• SELECT_PROFILE — Retrieves the current value(s) of an IEM-related profile or parameter for a supplied context. It is the read accessor used by downstream IEM code to obtain effective settings before processing an interaction.
• UPDATE_PROFILE — Applies changes to a stored profile or parameter value. This is the core mutation routine and is expected to enforce validation and transactional integrity consistent with the FND_API framework.
• UPDATE_PROFILE_WRAP — A wrapper routine around UPDATE_PROFILE that provides a standardised invocation envelope, typically adding error capture, savepoint management, or message-stack handling so that calling packages can invoke the update without duplicating boilerplate logic.

Tables Accessed

The package operates against several underlying objects referenced through APPS synonyms:

• HZ_PARTIES — The Trading Community Architecture (TCA) party master. Access here supports resolving party-specific context so that profile values can be selected or applied against the correct party record.
• JTF_RS_RESOURCE_EXTNS — The resource extension table for the CRM resource model. It supports linking parameter or profile values to resources such as agents or sales representatives.
• PLITBLM — A standard EBS PL/SQL index-by table type used primarily for passing arrays (notably VARCHAR2 tables) between the private package and its callers, consistent with the JTF_VARCHAR2_TABLE_100 dependency noted in the metadata.

Usage Notes

APPS.IEM_PARAMETERS_PVT is a private package and is therefore not intended to be called directly from custom code; supported entry points are the public IEM packages that reference it. The documented dependent packages are IEM_CLIENT_PUB and IEM_CONFIGURATION_PUB, confirming that parameter selection and update occur during client configuration and configuration-management flows. The package is typically invoked indirectly when IEM setup forms, configuration routines, or concurrent processes need to read effective profile values or persist parameter changes. Because it depends on FND_API and uses standard PL/SQL table types, callers should invoke it within a properly initialised EBS session holding the required APPS privileges. Customisations should target the public wrappers rather than this private layer to remain upgrade-safe across 12.1.1 and 12.2.2.