Search Results get_transaction_status

Overview

APPS.IES_TRANSACTION_UTIL_PKG is a utility package in the Oracle E-Business Suite (EBS) Internet Expenses (OIE) module. Its primary business function is to provide reusable, low-level transaction handling routines that operate against the IES transaction staging tables. These transactions represent expense report data captured from external sources — for example, corporate card feeds, spreadsheet uploads, or interface data — that must be validated, staged, and ultimately merged into the core expense structures. This package supplies the plumbing code that other Internet Expenses programs invoke to insert, update, and manage transaction records, keeping that logic centralized and consistent across the module. It is an internal helper package rather than a user-facing API, and the ETRM registers it with an API classification of OTHER, reflecting its supportive role.

The package body was compiled and is documented as VALID at owner APPS. It addresses the recurring requirement in the Internet Expenses transaction pipeline to manipulate large character payloads and to restart interrupted batch processing without losing previously staged data.

Key Procedures and Functions

The package body exposes five documented procedures and functions:

• INSERT_TRANSACTION — Inserts a new transaction record into the Internet Expenses transaction staging structure, populating the columns required for subsequent validation and processing.
• UPDATE_TRANSACTION — Modifies an existing transaction record, used when correction or status changes are required against staged data.
• GETTEMPORARYCLOB — Returns a temporary CLOB value, serving as a working buffer for assembling or transferring large text payloads during transaction processing.
• GETRESTARTXMLDATA — Retrieves persisted XML data used to resume or restart an interrupted transaction-processing run, allowing batch jobs to continue without reprocessing completed work.

No parameter signatures are documented in the ETRM metadata; consumers should reference the deployed package specification for exact signatures.

Tables Accessed

The metadata documents direct references to a small set of objects, all resolved through APPS synonyms:

• IES_TRANSACTIONS_S — the primary Internet Expenses transaction staging sequence/table. The INSERT_TRANSACTION and UPDATE_TRANSACTION routines read and write here. This is the object most closely associated with the search term "ies_transactions_s."
• DBMS_LOB — the Oracle-supplied large object package, invoked for CLOB and LOB manipulation supporting the temporary CLOB and XML payload handling.
• DUAL — used for scalar expression evaluation, for example to obtain sequence values or PL/SQL function results without referencing a real table.

Usage Notes

IES_TRANSACTION_UTIL_PKG is invoked programmatically by other Internet Expenses components rather than directly by end users. ETRM records that it is referenced by exactly one other package, which calls its utility routines during transaction staging. Typical invocation contexts include concurrent programs that load or validate expense transaction interfaces, and any custom code extending the standard Internet Expenses transaction flow that must insert or update records on IES_TRANSACTIONS_S.

Because the package is a utility helper, customers should not call it in isolation; it assumes the surrounding Internet Expenses transaction context. Any modification should duplicate the standard package and avoid altering APPS-owned code, per EBS customization standards. It depends on IES_TRANSACTIONS_S, DBMS_LOB, DBMS_STANDARD, and STANDARD remaining valid and accessible in the APPS schema.