Search Results load_newentry

Overview

APPS.IEC_VALIDATE_PVT is a private PL/SQL package belonging to the Oracle E-Business Suite (EBS) Advanced Marketing / iMarketing (IEC) module, which underpins campaign list management, contact point validation, and schedule entry processing. The package is classified under the API classification "PVT," denoting a private package whose procedures and functions are intended for internal invocation by the public APIs and concurrent programs within the IEC and AMS (Advanced Marketing System) schema rather than for direct external calls. Its status is documented as VALID in both EBS 12.1.1 and 12.2.2 metadata. The package's central business purpose is the validation and manipulation of marketing list records, target group entries, contact points, and schedule entries — providing the reusable validation and data-migration logic that supports the user-visible list and schedule management functions. The ETRM metadata identifies 14 documented procedures and functions, making it a moderately sized but functionally significant private package within the IEC module.

Key Procedures and Functions

The documented procedures and functions reflect a design centered on list validation, entry movement, and schedule maintenance:

• INIT_CONTACTPOINTRECORD — Initializes a contact point record, preparing the data structure used during contact point validation and updates.
• VALIDATE_LIST — Performs validation of a marketing list against configured rules.
• MOVE_RECYCLEDENTRY / MOVE_RECYCLEDENTRIES — Move individual or bulk recycled list entries back into active processing.
• COPY_TARGETGROUPENTRIES — Copies target group entries, typically to support list reuse or campaign duplication.
• LOAD_NEWENTRY / LOAD_NEWENTRIES — Load single or multiple new entries into marketing lists.
• UPDATE_TZ_MAPPINGS — Maintains time zone mapping data used to schedule communications correctly.
• ADD_RECORD_TO_LIST_INTERACTIVE / ADD_RECORD_TO_LIST — Add records to a list, with an interactive variant for form-driven use and a set-based variant for programmatic use.
• UPDATE_CONTACTPOINT — Updates contact point records.
• COPY_SCHEDULEENTRIES_PUB, MOVE_SCHEDULEENTRIES_PUB, PURGE_SCHEDULEENTRIES_PUB — Public entry points for copying, moving, and purging schedule entries respectively.

Tables Accessed

The package operates against a range of AMS, HZ, FND, and IEC tables via APPS synonyms. The AMS tables — AMS_ACT_LISTS, AMS_LIST_ENTRIES, and AMS_LIST_HEADERS_ALL — hold the marketing list definitions and their member entries that the validation and load procedures read and write. HZ_CONTACT_POINTS, HZ_PHONE_AREA_CODES, and HZ_PHONE_COUNTRY_CODES support contact point validation and phone-number normalization. FND_ORACLE_USERID is used for session/user context. The IEC global tables — IEC_G_LIST_SUBSETS, IEC_G_MKTG_ITEM_CC_TZS, IEC_G_REP_SUBSET_COUNTS, IEC_G_RETURN_ENTRIES, IEC_G_SUBSET_RT_INFO, IEC_G_TIMEZONE_MAPPINGS, and its sequence IEC_G_TIMEZONE_MAPPINGS_S — provide staging and configuration data for list subsets, time zone handling, and return-entry tracking. IEC_O_VALIDATION_HISTORY stores the audit trail of validation results.

Usage Notes

As a private (PVT) package, IEC_VALIDATE_PVT is not intended for direct invocation by customers. It is called primarily by the public package IEC_SCHEDULE_MGMT_PUB, which the ETRM metadata confirms references this package, and it also references itself (recursive internal calls). The interactive procedures (notably ADD_RECORD_TO_LIST_INTERACTIVE) are invoked indirectly through the iMarketing forms that manage lists and schedules, while the _PUB procedures such as COPY_SCHEDULEENTRIES_PUB, MOVE_SCHEDULEENTRIES_PUB, and PURGE_SCHEDULEENTRIES_PUB expose schedule maintenance to concurrent programs and to the AMS_LISTHEADER_PVT public API layer. Customers requiring programmatic access should use the public IEC and AMS APIs rather than this private package, since Oracle does not guarantee signature stability for PVT-classified objects across patches or upgrades.