Search Results get_listid

Overview

The APPS.IEC_COMMON_UTIL_PVT package is a private utility package within the Oracle E-Business Suite Interaction Center / iStore eCommerce (IEC) module family. Its source header (IECCMUTS.pls, version 120.1, dated 2006) indicates it predates the 12.1.1 and 12.2.2 releases, but it remains present and functional in both. The package provides shared low-level services that support campaign, list, and schedule processing — most notably name and identifier resolution for lists, subsets, and schedules, plus concurrency control over schedule execution. A significant portion of the package is dedicated to locking and unlocking schedules so that concurrent processes cannot simultaneously act on the same schedule/server combination. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema, and its API classification as PVT signals that it is not intended as a public integration API — it is consumed internally by other IEC/IEO packages (referenced by 5 other packages per the ETRM metadata).

Key Procedures and Functions

The ETRM documentation records nine procedures/functions. The GET_* routines are name/ID resolution helpers: GET_SCHEDULENAME returns the schedule name for a given schedule identifier (the object the user searched for); GET_SCHEDULEID performs the inverse lookup; GET_LISTNAME and GET_LISTID provide the same translation for lists, and GET_SUBSETNAME resolves subset names. GET_SOURCETYPEVIEW returns the source type view name for a specified target group, raising an exception when the view cannot be located. The concurrency routines are LOCK_SCHEDULE and UNLOCK_SCHEDULE. LOCK_SCHEDULE attempts to lock a schedule based on source, schedule, and server identifiers, using configurable lock attempts and attempt intervals, and returns a success flag; the source comment notes an unresolved design question about whether it should be an autonomous transaction. UNLOCK_SCHEDULE releases that lock. Note that parameter lists are deliberately not reproduced here; the documented signatures for these procedures carry minor IN/OUT NOCOPY variations across releases.

Tables Accessed

The package reads and writes several underlying objects through APPS synonyms. AMS_LIST_HEADERS_ALL supplies list and subset metadata used by the name/ID resolvers. Lock state is persisted in IEC_G_LIST_LOCK_STATES and its _S sequence/companion object. Server and runtime context for schedule locking is drawn from IEO_SVR_RT_INFO, IEO_SVR_SERVERS, and IEO_SVR_TYPES_B. The package also references FND_ORACLE_USERID for session/application user identity, and calls DBMS_LOCK to obtain database-level locks in support of the schedule coordination logic.

Usage Notes

Because IEC_COMMON_UTIL_PVT is a PVT (private) package, it should not be invoked directly from custom forms or concurrent programs. It is called by higher-level IEC/IEO packages — the metadata confirms it is referenced by five other packages — which in turn drive campaign schedule processing and list maintenance. Typical runtime paths include Interaction Center and eCommerce concurrent programs that execute schedule batches, where LOCK_SCHEDULE/UNLOCK_SCHEDULE prevent two workers from processing the same schedule. If custom code must resolve a schedule name from its ID, the supported approach is to call the public wrapper that internally invokes GET_SCHEDULENAME, not the private package itself, since the private API is subject to change without notice between 12.1.1 and 12.2.2.