Search Results update_segment

Overview

The APPS.IES_TRANSACTION_SEGMENTS_PKG package is a server-side PL/SQL API belonging to the Oracle E-Business Suite Internet Expenses (OIE/IES) module. It is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the package owner. The package governs the creation and maintenance of transaction segment records, which are the discrete line-level components that make up an expense transaction or report in the Internet Expenses data model. Its header dates to the 11.5.x code line (as reflected in the $Header: iestrss.pls 115.5 comment), and the package remains available as a documented database object in EBS 12.1.1 and 12.2.2.

Because the API is classified as OTHER in the ETRM repository, it is not part of Oracle's officially published public interface set; it is a supporting internal API used by Internet Expenses processes and is exposed mainly for internal and extension purposes.

Key Procedures and Functions

The documented package exposes two procedures:

• CREATE_SEGMENT — Creates a new transaction segment record. It accepts a transaction identifier, a user identifier, and a description identifier, and returns an output identifier for the newly created segment. This is the primary entry point for inserting a segment row associated with a parent expense transaction. Customizations that need to programmatically add a segment should invoke this procedure rather than inserting directly into the underlying table, so that any package-managed defaults and derivations are applied consistently.
• UPDATE_SEGMENT — Modifies an existing transaction segment. It takes the transaction identifier, a status value, a restart CLOB (used to persist or resume large character data associated with the segment), and the user identifier. The presence of the CLOB parameter indicates the procedure supports long-text receipt or descriptive content and can be re-invoked to resume processing of that content.

No parameter lists are reproduced here beyond what the documented signatures define; no additional procedures or functions are recorded in the metadata.

Tables Accessed

The ETRM metadata for this object does not enumerate the base tables referenced through APPS synonyms. In practice, the package operates on the Internet Expenses transaction segment tables (the IES_TRANSACTION_SEGMENTS family) that store the individual segment lines belonging to an expense transaction. CREATE_SEGMENT performs the insert against that segment table, while UPDATE_SEGMENT updates status and associated CLOB content on existing rows. Because table names are not documented in the supplied metadata, they should be confirmed against the actual database before any direct DML or custom query is attempted.

Usage Notes

The metadata records that this package is referenced by zero other documented packages, which suggests it is invoked directly by Internet Expenses application flows — forms-based expense entry, expense report processing, or related concurrent programs — rather than being wrapped by another published PL/SQL API. For custom development:

• Call CREATE_SEGMENT when programmatically introducing a segment for an existing transaction; supply the parent transaction ID, the acting user ID, and a description ID, and capture the returned ID for downstream references.
• Call UPDATE_SEGMENT to change a segment's status or to restart/continue CLOB-based content processing, passing the acting user ID for audit purposes.
• Because the package is AUTHID CURRENT_USER and not an Oracle-published API, validate behavior against the specific patch level of the 12.1.1 or 12.2.2 instance before relying on it in a custom integration, and prefer it over direct DML against the segment tables.