Search Results iec_subset_pvt




Overview
Explore in AI Chat

Overview

IEC_SUBSET_PVT is an Oracle E-Business Suite private PL/SQL package owned by the APPS schema. It forms part of the Telephony/Interaction Center (IEC) module, specifically the subsystem responsible for subset management associated with outbound calling campaigns and list transition processing. The package carries the "PVT" (private) API classification, indicating that it is an internal implementation layer not intended for direct invocation by external or customer-written code. Its function is to support the creation, maintenance, and recreation of subset views and runtime metadata used when transition processing occurs across a working subset of records drawn from contact and list tables. In deployments at the 12.1.1 and 12.2.2 release levels, the package is validated and active. Documentation excerpts and dependency metadata identify it as a foundational component consumed principally by IEC_VALIDATE_PVT and other internal IEC processing routines.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions within this package. Their names and documented purposes are as follows:

  • CREATE_SUBSET_VIEW — Establishes a database view representing the active subset of records to be processed, providing a queryable projection over the underlying subset source tables.
  • DROP_SUBSET_VIEW — Removes an existing subset view, typically during cleanup at the conclusion of a subset cycle or campaign.
  • RECREATE_SUBSET_VIEW — Rebuilds a subset view in place, preserving prior configuration while refreshing the underlying definition.
  • DROP_TARGET_GROUP_VIEWS — Removes views associated with target groups, supporting the teardown of grouped targeting structures.
  • GET_SUBSET_VIEW — Retrieves the identity or definition of the current subset view for use by callers within the IEC processing chain.
  • CREATE_SUBSET_RT_INFO — Populates runtime information records for a subset, enabling downstream processing to reference subset state at execution time.
  • SUBSET_TRANSITION — Orchestrates transition processing for a subset, advancing records through defined states.
  • CONTINUAL_TRANSITION — Handles the continuous or ongoing transition mode, allowing repeated or incremental processing of subset records.

Tables Accessed

The package accesses a range of IEC and foundation tables through APPS synonyms. Underlying subset definitions are held in IEC_G_LIST_SUBSETS, while IEC_G_SUBSET_RT_INFO and its sequence IEC_G_SUBSET_RT_INFO_S manage subset runtime metadata. Runtime entry records are stored in IEC_G_RETURN_ENTRIES and transition-specific records in IEC_O_TRANSITION_PHONES and IEC_O_TRANSITION_SUBSETS. Historical call data is referenced through IEC_O_RCY_CALL_HISTORIES. Foundation dependencies include FND_ORACLE_USERID for schema/user identification and ALL_VIEWS, which supports determination of existing view definitions. The package also leverages the DBMS_SQL dynamic SQL facility and PLITBLM for dynamic view manipulation.

Usage Notes

As a private package, IEC_SUBSET_PVT is invoked internally by the IEC application rather than by end users or external customizations. Dependency metadata shows that it is referenced by IEC_VALIDATE_PVT and is itself self-referential, confirming its role as a nested utility layer within IEC list and subset processing. Administrators and developers should ordinarily interact with the public IEC APIs or the underlying forms and concurrent programs rather than calling this package directly. Because it manipulates database views dynamically through DBMS_SQL, any schema-level changes to the underlying subset tables may require recreation of the affected views via the documented procedures. Direct calls may be appropriate only for advanced diagnostic purposes within a controlled environment, and such calls should not be embedded in custom code that must remain upgrade-safe across EBS releases.