Search Results gmf_ar_customer

Overview

APPS.GMF_AR_CUSTOMER is a public PL/SQL package belonging to the Oracle Process Manufacturing (OPM) subset of Oracle E-Business Suite. It is defined with AUTHID CURRENT_USER and is classified under the generic API classification of "OTHER" in the ETRM repository. Its principal role is to resolve and format customer-related reference data — phone information, payment terms, freight-on-board terms, sales representative, currency, and currency date — into human-readable values suitable for display on OPM documents and inquiry screens. The package therefore acts as a presentation utility layer over Oracle Receivables and OPM organization data rather than as a transactional business API. The source header identifies an early file revision (gmfcscos.pls, 115.6, dated 2004), and inline comments attribute prototype changes to Bug 1982384 and additions to Bug 1822750, indicating the package has evolved through support-driven enhancements.

Key Procedures and Functions

The package exposes eight documented routines, most of which return a formatted string or date for a supplied identifier:

• PHONE — Returns a formatted telephone number for a customer, resolved from customer, address, contact, party, party site, and phone type identifiers.
• PHONE_DATE — Returns a date associated with the customer phone record. The prototype was revised under Bug 1982384, consistent with the parallel change to PHONE.
• TERMS — Returns the descriptive payment terms text for a given payment term identifier.
• FOB — Returns the descriptive freight-on-board term for a given FOB point code.
• SALESREP — Returns sales representative information for a salesrep identifier and operating unit organization identifier.
• CURRENCY — Returns the currency associated with a customer, customer site use, and operating unit organization.
• CURRENCY_DATE — Returns the currency date corresponding to the same customer/site/organization combination.
• IS_OPM_ORG — Returns a Boolean indicating whether the supplied organization identifier is an OPM-enabled organization.

All functions except IS_OPM_ORG are declared with PRAGMA RESTRICT_REFERENCES (..., WNDS), asserting that they write no database state. This makes them safe for use inside SQL statements and views, a deliberate design choice consistent with a display-oriented utility package.

Tables Accessed

The ETRM metadata for this object does not enumerate the underlying base tables. Based on the function semantics and standard OPM/Receivables data models, the package reads customer, address, contact, and phone records (typically via AR customer and site tables), payment terms, FOB point lookups, sales representative assignments, currency and currency conversion date information, and OPM organization definitions. All access is performed through APPS synonyms. The documented behavior confirms read-only activity: no insert, update, or delete logic is exposed, and the WNDS pragmas formally prohibit database writes.

Usage Notes

GMF_AR_CUSTOMER is typically invoked from OPM forms and report or concurrent program code wherever a stored code value must be translated into descriptive text for the user — for example, converting a term identifier into its display name on an order or invoice inquiry, or deriving the currency and currency date for a customer site within a specific operating unit. Because the functions are RESTRICT_REFERENCES WNDS-compliant, they may be called directly from SQL, including views and custom queries. The package is referenced by one other database package, indicating it participates in a small dependency chain rather than being a standalone entry point. Developers extending OPM functionality should treat it as a stable read-only utility, and note the AUTHID CURRENT_USER declaration when considering privileges and invoker's rights behavior.