Results for “get_creation_date”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.AMS_PHONE_UTILS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the API convention "OTHER." Its declared purpose is to satisfy the requirements of the Advanced Outbound module, which needs to present and order telephone numbers 1 through 6 for a given party. Because the HZ (Trading Community) tables at the time of the package's creation could not support the required ordering of phone numbers by creation date in a single query, Oracle introduced this utility package to retrieve a desired phone number according to a preferred order derived from the creation date sequence. The package was first created in February 2001 and carries a header revision consistent with the 11.5.x code line, but it remains part of the 12.1.1 and 12.2.2 APPS schema and continues to be referenced by dependent components.

Key Procedures and Functions

The package exposes three documented functions, each of which returns a single value to the caller:

• GET_PHONE — Returns the formatted phone number for a specified party and a preferred-order position, allowing the caller to request the "nth" phone number for a party rather than relying on a single primary number.
• GET_RAW_PHONE — Returns the unformatted, "raw" phone number. This is useful for programmatic comparisons, matching, or storage where formatting characters would interfere.
• GET_CREATION_DATE — Returns the creation date associated with the phone record, which is the value used to establish the preferred ordering consumed by GET_PHONE.

No procedures are documented, and no private functions or procedures are noted. Input parameters follow the naming convention p_; output variables use the x_ prefix. The spec header states that the package must be created with definer's authority (AUTHID DEFINER), though the excerpt shows an AUTHID CURRENT_USER declaration in the source line.

Tables Accessed

The package accesses HZ_CONTACT_POINTS through APPS synonyms. HZ_CONTACT_POINTS stores contact point records, including phone numbers, associated with parties in the Trading Community Architecture. AMS_PHONE_UTILS reads this table to resolve a party's phone numbers and to order them by creation date so that a requested preferred position can be returned. No insert, update, or delete activity is documented; the package is a read-only utility.

Usage Notes

AMS_PHONE_UTILS is invoked programmatically rather than from a standard concurrent program or form, though Advanced Outbound and other sales or telemarketing components may call it indirectly. It is referenced by 10 other packages, indicating that it functions as a shared low-level service for phone number resolution across the AMS and related application modules. Customizations that need to reproduce the "phone number by preferred order" behavior of Advanced Outbound should call GET_PHONE, GET_RAW_PHONE, and GET_CREATION_DATE rather than querying HZ_CONTACT_POINTS directly, preserving the creation-date ordering logic. Because the package is compiled under APPS, callers must hold execute privilege on it and must supply a valid party identifier plus the desired preferred-order position.