Search Results create_source

Overview

AMS_DMSource_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a PUB (public) API within the Oracle Marketing (AMS) product family. Its historical purpose was to expose source-related operations for the Oracle Marketing data mining and campaign source infrastructure, serving as a published interface through which other modules and external callers could create and manage source definitions used by marketing and ODM (Oracle Data Mining) accelerators.

The package header carries the version marker "$Header: amspdsrs.pls 115.8 2003/12/03 06:42:17 choang ship $", indicating its last substantive revision dates to December 2003. Critically, the history block records that the package was "Stubbed out" by its original author (choang) on 02-Dec-2003. In the delivered 12.1.1 and 12.2.2 file systems, the package body is empty: the source excerpt shows the declaration block opening and immediately closing with END AMS_DMSource_PUB; with no procedure or function implementations. ETRM metadata confirms zero documented procedures or functions for this object.

Key Procedures and Functions

According to the ETRM 12.2.2 documentation, this package exposes no documented procedures or functions. The historical comments in the source header nevertheless preserve evidence of an earlier API surface that has since been removed. These historical references include a create_source operation, which is the term most likely matched by a search for "create_source".

The comments document the evolution of that original API:

• create_source — the primary historical entry point for defining a marketing source. The 27-Jan-2001 note records removal of target_value from this routine for use by the ODM Accelerator; the 12-Feb-2001 note records the addition of parameter p_target_value back for ODM; the 07-Jan-2002 note records removal of the security group identifier.
• Record type change — the 30-Jan-2001 note states the record type was changed to carry rule_id instead of tree_node, reflecting a shift in how source hierarchies were identified.

No parameter lists are documented for these historical routines, and none should be inferred. The only verifiable fact for 12.1.1 and 12.2.2 is that no callable procedures or functions are delivered.

Tables Accessed

ETRM records no table references for this package through APPS synonyms. This is consistent with the package being stubbed out: with no executable body, no SQL statements are issued and no AMS base tables or views are read or written. Earlier revisions of the package, by implication of its source-tracking function, would have operated against the Oracle Marketing source definition tables, but the delivered metadata documents no such dependencies and none should be assumed for remediation or impact analysis.

Usage Notes

Because AMS_DMSource_PUB is declared AUTHID CURRENT_USER, any historical invocation would have executed with the privileges of the calling schema rather than as APPS. However, in 12.1.1 and 12.2.2 the package is inert, so invocation has no effect. It is not referenced by any other package (zero referencing packages per ETRM), and no forms, concurrent programs, or standard Oracle flows call it in the delivered product.

For custom code or upgrade remediation, the practical guidance is:

• Treat any legacy call to AMS_DMSource_PUB.create_source as obsolete; the routine no longer exists and compilation will fail.
• Do not attempt to reverse-engineer parameters from the historical comments; they are changelog notes, not a specification.
• Migration from 12.1.1 to 12.2.2 poses no risk from this object, as it is stubbed in both releases and carries no table dependencies.
• Where source-creation functionality is genuinely required, consult the currently supported Oracle Marketing public APIs rather than this retired package.

In summary, AMS_DMSource_PUB is a retained, empty shell preserved for compatibility of the package namespace. Its documentation value lies primarily in its header history, which records the deprecation path of the former create_source marketing API.