Search Results iec_admin_pvt




Overview
Explore in AI Chat

Overview

IEC_ADMIN_PVT is a private PL/SQL package in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the APPS schema and classified under the ETRM metadata as a Private (PVT) API. The package resides in the Oracle Marketing (AMS) and Telephony/Interaction Center (IEC) functional area, and its stated purpose is to provide private API procedures consumed by the Administrative utility within that subsystem. The package header comment, dated 30-Apr-2001 and last modified 16-Jun-2005, identifies it as an internal support package rather than a public integration point; the API classification of PVT confirms that it is not intended for direct invocation by external customizations, and ETRM records indicate it is referenced by zero other packages.

Functionally, IEC_ADMIN_PVT centralizes the administrative maintenance operations for campaign schedules, calling lists, list subsets, and calendar definitions. These operations support the setup and adjustment of outbound dialing campaigns managed through the Interaction Center.

Key Procedures and Functions

The package exposes seven documented procedures and functions:

  • UPDATE_CAMP_SCHEDULE — The procedure most directly associated with the searched term. It is the private API used to update campaign schedule parameters. As documented in the package body, it was created on 15-May-2001 and modified on 09-Jul-2001. The header notes that an AO Admin uses this procedure to update campaign schedule parameters, and that the dialing_method parameter was disabled when CTI support was removed. The body declares a record variable of type AMS_Camp_Schedule_PUB.schedule_rec_type, indicating that the procedure ultimately delegates the update to the public AMS campaign schedule API rather than writing directly to the base table.
  • UPDATE_LIST_DIALINGMETHOD — Updates the dialing method associated with a calling list, reflecting subsequent changes to telephony configuration.
  • UPDATE_LIST_HEADER — Maintains header-level attributes of a calling list.
  • DELETE_LIST_SUBSET — Removes a subset definition from a calling list.
  • GET_TG_ENTRY_LIST — Retrieves a list of telephony gateway (TG) entries for administrative display or processing.
  • GET_TG_ENTRY_DETAILS — Returns the detail attributes for a specific telephony gateway entry.
  • COPY_CALENDAR_DAY — Copies calendar day definitions, supporting the reuse of calling calendars across time periods.

Tables Accessed

The ETRM metadata documents access, through APPS synonyms, to the following tables:

Usage Notes

Because IEC_ADMIN_PVT is a private API, it is not published for customer extension and is invoked internally by the Interaction Center administrative forms and related administrative utilities. ETRM records show no other packages referencing it, which further indicates that its callers are form-based or administrative in nature rather than part of a public programmatic interface. The presence of both x_msg_data and x_return_value OUT parameters in UPDATE_CAMP_SCHEDULE follows the standard EBS API error-handling convention, returning a message payload and a status code to the calling form or program unit. Customizations requiring campaign schedule maintenance should call the public AMS_Camp_Schedule_PUB API instead of IEC_ADMIN_PVT, which serves only as the administrative wrapper for schedule updates.