Search Results update_list_dialingmethod

Overview

The APPS.IEC_ADMIN_PVT package is a private PL/SQL API belonging to the Oracle EBS Interaction Center / Telephony (IEC) and Advanced Marketing (AMS) subsystem. Its stated purpose, per the embedded header comments, is "to provide easy to use apis for IEC Admin." The package centralizes the administrative maintenance operations that govern outbound telephony campaign behavior — campaign schedule definitions, dialing method configuration, predictive dialing parameters, and list-level settings — so that the calling Forms and concurrent programs do not manipulate the underlying AMS and IEC tables directly.

The package was created on 30-Apr-2001 by msista and was subsequently modified by gpagadal in July 2001, with additional fields and procedures added. The source header revision ($Header: IECADMS.pls 120.1 2005/06/16) indicates the file has been relatively stable since the R12 code line. It carries a PVT (private) classification in ETRM, meaning it is intended for internal consumption by the IEC Admin forms layer rather than as a public, supported extension API.

Key Procedures and Functions

Seven procedures are documented for this package:

• UPDATE_CAMP_SCHEDULE — Updates a campaign schedule row, governing the telephony behavior of an outbound campaign. Its documented IN parameters include the campaign schedule identifier, dialing method, calendar, abandon limit, predictive timeout, user status, and user identifier, returning a message buffer and a numeric return value (1 for success, 0 otherwise). The dialing method parameter is annotated "(CTI disabled)" in the comments, reflecting that computer-telephony integration options are constrained in this code path.
• UPDATE_LIST_DIALINGMETHOD — The procedure most relevant to the search term "update_list_dialingmethod." It updates the dialing method attribute associated with a calling list, allowing administrators to switch how a list is dialed (for example between preview and predictive modes) without recreating the list.
• UPDATE_LIST_HEADER — Maintains attributes on the list header record, the parent entity that defines a calling list used by telemarketing and campaign activity.
• DELETE_LIST_SUBSET — Removes a list subset definition, used when administrators break a large list into operational segments and later need to eliminate one.
• GET_TG_ENTRY_LIST — Retrieves a set of telephony gateway entries, typically for display in an administrative query window; the package declares a TG_ENTRY_CURSOR ref cursor type to support this.
• GET_TG_ENTRY_DETAILS — Returns the detail attributes of a single telephony gateway entry, complementing the list-based retrieval above.
• COPY_CALENDAR_DAY — Duplicates a calendar day definition, supporting the rapid setup of telephony calling calendars across day patterns.

Tables Accessed

The package operates against seven documented tables via APPS synonyms:

• AMS_CAMPAIGN_SCHEDULES_B — the campaign schedule base table written by UPDATE_CAMP_SCHEDULE.
• AMS_ACT_LISTS — the activity/list association table underpinning list dialing method updates.
• AMS_LIST_HEADERS_ALL — the list header table maintained by UPDATE_LIST_HEADER and referenced by the subset and dialing method routines.
• IEC_G_LIST_SUBSETS — stores list subset definitions deleted by DELETE_LIST_SUBSET.
• IEC_G_CAL_DAYS_B — calendar day definitions copied by COPY_CALENDAR_DAY.
• IEC_G_CAL_CALLABLE_RGNS and IEC_G_CAL_CALLABLE_RGNS_S — callable region definitions and their corresponding sequence, used to validate telephony calling windows.

Usage Notes

As a private (PVT) API, IEC_ADMIN_PVT is not intended for direct invocation from customer extensions. It is referenced by zero other packages according to ETRM, indicating its callers are external to the PL/SQL dependency graph — almost certainly the IEC Admin Oracle Forms module and related administrative UI. Standard Oracle EBS practice for PVT packages applies: use the corresponding public API or the supported Forms user interface instead of calling these procedures directly, because signature and behavior may change without a public compatibility guarantee.