Search Results revoke_sourcecode

Overview

AMS_SOURCECODE_PVT is a private (PVT) PL/SQL package body owned by the APPS schema within the Oracle E-Business Suite Advanced Marketing (AMS) module. Its principal business function is the generation, retrieval, and maintenance of source codes used to track and attribute marketing activities and responses across campaigns. Source codes serve as the identifying vehicle through which marketing activities are linked to responses, leads, and revenue, making this package a foundational utility within the Oracle Marketing source code framework.

Because the package is classified as PVT, it is intended solely for internal consumption by other AMS packages and is not a public API surfaced to external callers. This classification is confirmed by the fact that the package body is referenced by twelve other packages, which invoke its procedures and functions within the broader Oracle Marketing processing flow. The header revision information in the source indicates the package has been in production since at least the 11i era and remains part of the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

The package exposes nine documented procedures and functions, of which the primary documented units are:

• IS_SOURCE_CODE_UNIQUE — a function that verifies whether a given source code already exists in the AMS_SOURCE_CODES table, returning an FND_API boolean indicator (g_true or g_false). It is used to enforce uniqueness before a new source code is committed.
• GET_NEW_SOURCE_CODE — generates a new, unique source code string, typically comprised of geographic, date, and customer-based components obtained via a sequence routine.
• GET_SOURCE_CODE — retrieves an existing source code record, supporting lookups by callers that need to resolve or display an established code.
• CREATE_SOURCECODE — creates a new source code record, persisting the generated or supplied code into the underlying AMS tables.
• REVOKE_SOURCECODE — reverses or invalidates an existing source code, marking it no longer active. This is the procedure most directly associated with the user search term "revoke_sourcecode".
• MODIFY_SOURCECODE — updates attributes of an existing source code record; a forward declaration for this procedure appears in the package body header.

Tables Accessed

The package interacts with several AMS tables through APPS synonyms:

• AMS_SOURCE_CODES — the base table holding source code definitions; queried by IS_SOURCE_CODE_UNIQUE and updated by CREATE, MODIFY, and REVOKE operations.
• AMS_SOURCE_CODES_S and AMS_SOURCE_CODES_GEN_S — the translated (TL) and generated-code sequence tables supporting the source code framework and unique code generation.
• AMS_GENERATED_CODES — stores generated code segments used when assembling new source codes via GET_NEW_SOURCE_CODE.
• DUAL — used for single-row select operations in utility logic.

Usage Notes

AMS_SOURCECODE_PVT is not intended for direct invocation by end users or external integrations. It is invoked internally by Oracle Marketing forms and concurrent programs and by the twelve dependent AMS packages that orchestrate campaign and activity source code processing. The REVOKE_SOURCECODE procedure is typically called when a source code is retired or invalidated as part of campaign wrap-up or correction workflows. Customizations should avoid calling this private package directly; instead, the public AMS APIs that wrap it should be used to preserve upgrade safety across EBS 12.1.1 and 12.2.2.