Search Results ams_list_src_mapping_w




Overview
Explore in AI Chat

Overview

AMS_LIST_SRC_MAPPING_W is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Marketing (AMS) product family and supports the configuration of list source mappings used by marketing list generation and audience segmentation. In the AMS data model, a list source represents the origin from which marketing list members are drawn, and a mapping defines how columns or attributes from a source query are translated into the target list entity. The package provides the programmatic and concurrent-program entry points through which these mapping records are created, copied, and maintained, particularly in the context of Oracle Territory Manager (ETRM) style table-copy operations. Its API classification in the ETRM repository is OTHER, indicating that it is an internal processing package rather than a formally published public API, and it is not referenced by any other documented package.

Key Procedures and Functions

Three documented program units are exposed by the package:

  • CREATE_MAPPING — Creates a list source mapping record, persisting the association between a list source and its target attributes into the underlying mapping table. It is the primary entry point for programmatically establishing a new mapping definition.
  • ROSETTA_TABLE_COPY_IN_P1 — Performs the inbound phase of the Rosetta-style table copy mechanism, loading or staging source data into the working table structure used by the copy process. The "_P1" suffix indicates this is the first stage of the operation, typically invoked before the corresponding outbound phase.
  • ROSETTA_TABLE_COPY_OUT_P1 — Performs the outbound phase of the same copy mechanism, moving the staged data from the working structure into its final destination. It is invoked after the inbound phase has completed successfully.

Parameter lists are not documented in the ETRM metadata and should not be assumed; callers should inspect the package specification in the database for exact signatures.

Tables Accessed

The package depends on the AMS_LIST_SRC_MAPPING table, which is the base schema object holding list source mapping definitions. All create and maintenance logic routes through this table. The ETRM reference also lists a dependency on JTF_VARCHAR2_TABLE_1000, the standard Oracle CRM Foundation collection type used to pass arrays of strings between the package and its callers. The documented table accessed via APPS synonyms is PLITBLM, an internal PL/SQL table used for bulk processing and array handling within the package body. Supporting dependencies include the SYS.STANDARD package. Because the package body is not reproduced in the metadata, no further tables should be inferred.

Usage Notes

Typical invocation occurs from Oracle Marketing setup forms, from concurrent programs that build or refresh list source mappings, and from custom code that must replicate mapping definitions between environments. The Rosetta copy procedures are generally invoked in sequence—copy-in followed by copy-out—as part of a controlled data migration or duplication routine. Because the package is classified as OTHER and is unsupported as a public API, direct calls should be reserved for extension development only and validated against each target release, since AMS internal packages can change between 12.1.1 and 12.2.2 without public notice. Developers should verify the package specification in the APPS schema before relying on any procedure signature.