Results for “itg_x_utils”

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

Overview

APPS.ITG_X_UTILS is a shared PL/SQL utility package owned by the APPS schema within Oracle E-Business Suite, classified in the ETRM repository under API classification OTHER. Its source header identifies it as part of the ITG (Internet Trading Gateway / Procurement collaboration) module, referencing revision metadata dating to 2003–2006. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, a design choice consistent with a broadly invoked internal utility library.

Functionally, ITG_X_UTILS serves as a common helper layer for the ITG procurement and supplier collaboration flows. It supplies constants that anchor the module's integration identity — the application short name ITG, application ID 230, standard user and responsibility identifiers, and the collaboration point names OIPC, OIPC_FINAL, and XML_GATEWAY. It also defines the outbound business event oracle.apps.itg.outbound and a correlation identifier prefix used when routing messages through the Oracle Workflow event system and XML Gateway. The package maintains session-level state for trading partner identity (party type, default trading partner site, party and party site identifiers) and publishes an initialization flag reflecting package load status, a safeguard introduced under bug fix 4169685 after installation-time data insertion into HR_LOCATIONS was removed.

Key Procedures and Functions

• GETCOUNTY — Returns the region value corresponding to a county name or its equivalent, based on the supplied address style and two region inputs. Declared with PRAGMA RESTRICT_REFERENCES WNDS.
• GETFLEXQUALIFIERSEGMENT — Resolves which segment within a given key flexfield structure holds a named flexfield qualifier, returning the FND_ID_FLEX_SEGMENTS application column name. Also WNDS-restricted.
• GET_INVENTORY_ORG_ID — Derives the inventory organization identifier used in requisition and purchasing context.
• GETREQUISTNID and GETREQLINENUM — Retrieve requisition header identifiers and requisition line numbers for downstream processing and messaging.
• GETSTATE, GETTAXID, SIGNOF — Small scalar helpers returning state information, tax registration identifiers, and the sign of a numeric value.
• SEGSTRING — Constructs a concatenated key flexfield segment string, typically for display or message payload assembly.
• SUMPOLINELOCS and SUMREQLINES — Aggregate quantities across purchase order line locations and requisition lines respectively.
• GETATTACHMENTS and GETTEXTATTACHMENTS — Retrieve document attachments and short-text attachment content associated with business entities.
• ISPOLINEAPPROVED — Determines whether a purchase order line has reached an approved state.
• ADDCBODDESCMSG, GETCBODDESCMSG, TRANSLATECBODDESCMSG — Manage CBOD (canonical business object document) description message text, including adding, retrieving, and translating message content for outbound collaboration.

Tables Accessed

The package reads through APPS synonyms across several EBS schemas. Workflow and integration configuration is drawn from WF_SYSTEMS and ECX_TP_HEADERS, supporting trading partner and local system resolution. Flexfield metadata comes from FND_ID_FLEX_SEGMENTS, FND_ID_FLEX_STRUCTURES, FND_SEGMENT_ATTRIBUTE_TYPES, and FND_SEGMENT_ATTRIBUTE_VALUES. Attachment handling references FND_ATTACHED_DOCUMENTS, FND_DOCUMENTS_SHORT_TEXT, and FND_DOCUMENT_ENTITIES. Organization and location data is sourced from HR_ALL_ORGANIZATION_UNITS and HR_LOCATIONS_ALL. Procurement objects include PO_LINE_LOCATIONS_ALL and PO_REQUISITION_HEADERS_ALL. Financial system parameters and reporting entity configuration are read from FINANCIALS_SYSTEM_PARAMS_ALL and AP_REPORTING_ENTITIES_ALL.

Usage Notes

ITG_X_UTILS is a foundational dependency: ETRM records it as referenced by 25 other packages, indicating wide reuse across the ITG collaboration stack. It is typically invoked from PL/SQL-based integration code, concurrent programs, and outbound event subscribers rather than directly from Oracle Forms. Because it carries AUTHID CURRENT_USER, callers must possess the necessary object privileges on the referenced tables. The g_initialized flag allows callers and diagnostics to detect load-time problems, particularly missing HR_LOCATIONS_ALL setup data, before executing dependent logic.