Search Results check_entry_record

Overview

APPS.AMS_LISTENTRY_PVT is a private (PVT) PL/SQL package within the Oracle E-Business Suite Marketing (AMS) module. It encapsulates the core business logic for managing list entry records — the individual prospect or customer rows that populate a marketing list header. Marketing lists in AMS are used to define target audiences for campaigns, and each list is composed of a header (stored in AMS_LIST_HEADERS_ALL) and one or more list entries that identify the specific parties or source records selected for the list. The PVT suffix indicates that this package is intended for internal use by the corresponding public API layer; it is not designed to be called directly by external consumers. The public package AMS_LISTENTRY_PUB and its wrapper AMS_LISTENTRY_PUB_W delegate their operations to this package, which performs validation, record manipulation, and source code assignment against the underlying AMS tables.

Key Procedures and Functions

The package exposes eleven documented procedures and functions that collectively manage the full lifecycle of a list entry record:

• CREATE_LISTENTRY — Inserts a new list entry into the AMS_LIST_ENTRIES table, establishing the association between a marketing list header and the selected party or source record.
• UPDATE_LISTENTRY — Modifies an existing list entry, allowing attributes such as entry status or associated identifiers to be changed.
• DELETE_LISTENTRY — Removes a list entry record, typically invoked when a party is de-selected from a marketing list.
• LOCK_LISTENTRY — Acquires a row-level lock on the list entry to prevent concurrent modification during a transaction.
• VALIDATE_LISTENTRY — Performs integrity and business rule checks on a list entry before it is committed.
• CHECK_ENTRY_ITEMS — Validates the set of items associated with a list entry, ensuring consistency of the entry’s constituent records.
• CHECK_ENTRY_RECORD — Verifies the existence and validity of a specific entry record.
• INIT_ENTRY_REC — Initializes the PL/SQL record structure used to hold entry data during processing.
• COMPLETE_ENTRY_REC — Finalizes and populates the entry record after all attributes have been assigned.
• UPDATE_LISTENTRY_SOURCE_CODE — Updates the source code associated with a list entry, linking it to the AMS_SOURCE_CODES reference table for campaign tracking and response attribution.
• GET_LISTPINCODE — Retrieves the PIN code associated with a list, used for list authentication or promotional code purposes.

Tables Accessed

The package reads from and writes to the following tables via APPS synonyms:

• AMS_LIST_ENTRIES and AMS_LIST_ENTRIES_S — the primary and secondary (translation/audit) tables holding list entry records; the core of the package’s DML operations.
• AMS_LIST_HEADERS_ALL — the parent list header table, referenced to validate and associate entries with their owning list.
• AMS_SOURCE_CODES — the source code reference table used by UPDATE_LISTENTRY_SOURCE_CODE.
• AMS_CAMPAIGNS_ALL_B and AMS_CAMPAIGN_SCHEDULES — campaign and schedule tables, accessed to validate that entries relate to active campaigns and their schedules.
• DUAL — used for singleton SELECT operations.

Usage Notes

Because AMS_LISTENTRY_PVT is a private package, it is not invoked directly by end users. It is called through the public API packages AMS_LISTENTRY_PUB and AMS_LISTENTRY_PUB_W, which are in turn invoked by the Marketing List Entry forms, concurrent programs that build or refresh marketing lists, and custom PL/SQL integrations that need to manage list membership programmatically. Internal dependencies include AMS_LISTHEADER_PVT (list header logic) and IEC_VALIDATE_PVT (validation framework), while the package itself relies on FND_API and JTF_PLSQL_API for standard API error handling and record management. Custom developers should call the public packages rather than AMS_LISTENTRY_PVT to ensure supported behavior across Oracle EBS 12.1.1 and 12.2.2.