Search Results lock_import_list

Overview

AMS_IMPORT_LIST_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Marketing (AMS) product family and provides the programmatic interface for managing the import list header records used when marketing lists are loaded into EBS from external files or source systems. An "import list" represents a staged set of rows that will ultimately become a marketing list, together with the control attributes describing how the load should proceed: the source file, the vendor or partner supplying the data, deduplication behavior, row-skipping rules, scheduled load time, and processing status.

The package source is declared with AUTHID CURRENT_USER, and the header identifies the original file as amspimps.pls. The declared record type ams_import_rec_type exposes the full attribute set of the import list header, including identifiers and audit columns (import_list_header_id, object_version_number, last_update_date, created_by, last_update_login), descriptive attributes (name, version, description, keywords, country), processing controls (import_type, status_code, status_date, scheduled_time, rows_to_skip, processed_rows, loaded_no_of_rows, loaded_date, process_immed_flag, dedupe_flag, headings_flag), cost and currency fields, and the standard attribute1 through attribute15 and attribute_category extension columns, plus usage, rented_list_flag, and server_flag.

Key Procedures and Functions

The documented public interface consists of four procedures:

• CREATE_IMPORT_LIST — Inserts a new import list header record, populating the attributes supplied through the ams_import_rec_type structure. It establishes the identifying key and the initial processing state for a staged import.
• UPDATE_IMPORT_LIST — Modifies an existing import list header, allowing status, scheduling, counts, and descriptive attributes to be refreshed as a load progresses or its parameters change.
• DELETE_IMPORT_LIST — Removes an import list header record that is no longer required, supporting housekeeping of staged or abandoned imports.
• LOCK_IMPORT_LIST — Acquires a logical lock on an import list header. This is the procedure most commonly associated with the search term lock_import_list. Its purpose is to serialize concurrent access to a single import list so that only one process (for example, a single concurrent program submission or a single form session) can update or process that list at a time, preventing duplicate loads, conflicting status updates, and inconsistent row counters.

No parameter lists are reproduced here, as the documented metadata names the procedures only.

Tables Accessed

The dependency metadata for this object does not enumerate the underlying tables directly; the package operates on the marketing import list header entity (logical table AMS_IMPORT_LIST_HEADERS and its associated _TL and _B variants) through APPS synonyms. The record structure indicates that the package reads and writes header-level rows and controls aspects of the detail staging rows referenced by import_list_header_id. No downstream packages are documented as referencing this package.

Usage Notes

AMS_IMPORT_LIST_PUB is the supported public layer for import list maintenance and is normally invoked from the Oracle Marketing list import forms and from concurrent programs that stage, validate, and load imported list data. Custom integrations that create or drive list imports should call these procedures rather than writing to the header tables directly, so that audit columns, object version numbers, and locking semantics remain consistent. In particular, a caller that intends to update or process a given import list should invoke LOCK_IMPORT_LIST first and treat a lock failure as an indication that another session already owns the record. Because the package is declared AUTHID CURRENT_USER, the invoking schema must hold the necessary privileges on the APPS synonyms.