Search Results get_qual_table_name_and_pk

Overview

AMS_UTILITY_PVT is the private utility package body in the Oracle EBS Oracle Marketing (AMS) schema, owned by APPS and shipped with a VALID status in both 12.1.1 and 12.2.2. It provides the shared, low-level helper services on which the rest of the Marketing application depends: message and debug handling built on the FND message stack, generic validation routines for foreign keys, lookups, and uniqueness, value-set and flexfield lookups, currency conversion, timezone resolution between the system default and the user profile, and assorted name/description resolutions for resources, source codes, and divisions. Because it is a PVT (private) package, it is not exposed as a supported public API; it exists to consolidate utility logic so that public Marketing APIs and concurrent programs do not duplicate it. The ETRM metadata records 46 documented procedures and functions, and the package is referenced by 292 other database objects, while it is itself not referenced by any database object, confirming its position as a leaf-level dependency.

Key Procedures and Functions

The documented entry points fall into several functional groups.

• Logging and diagnostics: DEBUG_MESSAGE, LOG_MESSAGE, LOGGING_ENABLED, CREATE_LOG, and ERROR_MESSAGE handle debug output, runtime logging to AMS_ACT_LOGS, and error capture through FND_MSG_PUB and FND_MESSAGE. DISPLAY_MESSAGES retrieves and surfaces the stacked messages.
• Generic validation: CHECK_FK_EXISTS verifies foreign key integrity; CHECK_LOOKUP_EXISTS tests whether a value exists in a lookup type; CHECK_UNIQUENESS enforces duplicate prevention; IS_Y_OR_N validates the standard Yes/No flag convention; GET_QUAL_TABLE_NAME_AND_PK resolves qualification table and primary key metadata.
• Lookup and attribute resolution: GET_LOOKUP_MEANING, GET_OBJECT_NAME, GET_SOURCE_CODE, and GET_RESOURCE_NAME return translated meanings, object names, source code descriptions, and resource (employee) names.
• Currency and timezone: CONVERT_CURRENCY performs currency conversion through the GL currency APIs; GET_SYSTEM_TIMEZONE and GET_USER_TIMEZONE resolve defaults; CONVERT_TIMEZONE converts a timestamp between zones.
• Security/context: IS_IN_MY_DIVISION determines whether a record falls within the current user's division or organization scope.

Tables Accessed

The package reads and writes a focused set of base objects through APPS synonyms. AMS_ACT_LOGS and its sequences AMS_ACT_LOGS_S and AMS_ACT_LOGS_TRANSACTION_ID_S support the logging routines. Campaign configuration is read from AMS_CAMPAIGN_SCHEDULES, AMS_CUSTOM_SETUP_ATTR, AMS_SOURCE_CODES, and AMS_STATUS_ORDER_RULES. Reference data comes from FND_LOOKUP_VALUES and QP_LIST_LINES, while HZ_PARTIES, MTL_SYSTEM_ITEMS_KFV, MTL_UNITS_OF_MEASURE, and OZF_SYS_PARAMETERS_ALL provide party, item, unit of measure, and system parameter values. DUAL and PLITBLM are used for single-row selection and array membership tests, and the FND, GL, WF, JTF, and QP packages listed as dependencies supply supporting APIs.

Usage Notes

AMS_UTILITY_PVT is invoked internally by the Marketing public APIs (for example AMS_ACCESS_PVT and AMS_OBJECTATTRIBUTE_PVT), by Marketing forms and concurrent programs, and by custom extensions that require the same validation, conversion, or logging behavior. The recommended practice is to call the public AMS APIs rather than this private package directly, since its signatures are not covered by Oracle's compatibility guarantee and may change between releases. Where custom code must reuse logging or lookup helpers, the dependency list should be validated against the target instance to confirm that required synonyms and FND packages are present.