Search Results jg_globe_util_pkg

Overview

JG_GLOBE_UTIL_PKG is a utility package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API classification of OTHER. Its role is to support the processing of line-level global events raised by the Oracle EBS applications that participate in globalization and international trade data flows. The package header declares AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking user rather than the definer, which is typical for utility packages that are called from a wide range of integration and application contexts.

The header comment block identifies the package as a helper for "global events" originating from transactional modules. Two distinct source modules are covered: Purchasing (PO), through process_po_globe_event, and the iProcurement / iStore style ICX layer, through process_icx_line_globe_event. A third, non-business routine, DEBUG, provides a diagnostic logging facility. The package is not documented as being referenced by any other packaged API, indicating it is normally invoked directly by application code, concurrent programs, or integration code rather than nested inside a larger API call chain.

Key Procedures and Functions

• process_po_globe_event — A procedure that processes line-level global events originating from the PO module. It is the entry point used when a purchasing document line must be evaluated or propagated through globalization logic. Per the documented signature it accepts document type, level type, and level identifier inputs; parameter details beyond those documented categories are not reproduced here.
• process_icx_line_globe_event — A function that processes line-level global events from the ICX module. This is the routine associated with the user's search term, and it returns a VARCHAR2 result, allowing the caller to inspect an outcome or status value. Its documented inputs identify the operating organization, the item, and the deliver-to organization, reflecting the ICX line context in which the event is raised.
• DEBUG — A procedure that writes the supplied line of text (p_line) to a system file. It is a development and troubleshooting aid used to trace execution, not a business-facing routine.

Tables Accessed

The ETRM metadata records PO_LINES_ALL and DUAL as the tables referenced through APPS synonyms. PO_LINES_ALL is the principal Purchasing line table and is consistent with the package's purpose of resolving and processing line-level globalization events for purchasing documents. DUAL is the standard single-row Oracle utility table, typically used for trivial expression evaluation, sequence retrieval, or unconditional return paths. No other base tables are documented for this package.

Usage Notes

Because process_icx_line_globe_event is a function returning VARCHAR2, it is well suited to inline invocation within SQL or PL/SQL where a status or computed value is required for a given organization, item, and deliver-to organization combination. process_po_globe_event is invoked procedurally when a PO line event must be processed.

Typical invocation points are Oracle Forms business logic, concurrent programs that batch-process globalization events, and custom integration code that must replicate EBS globalization behavior. The absence of documented dependents means callers should treat these routines as top-level entry points and should not assume defensive error handling beyond what the package itself provides. The DEBUG procedure is intended for diagnostic use only and should not be relied upon as part of a production interface. When migrating between 12.1.1 and 12.2.2, the documented package remains unchanged in structure and behavior.