Search Results igs_tr_step_pkg




Overview
Explore in AI Chat

Overview

IGS_TR_STEP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Student Systems / Higher Education transaction (TR) module, specifically the IGS_TR_STEP entity. In Oracle EBS 12.1.1 and 12.2.2, the IGS_TR_STEP_PKG package is a table-handler style package generated against the IGS_TR_STEP table. It encapsulates the standard DML manipulation and validation logic for transaction step records used within the academic transaction processing framework. The package is classified as an "OTHER" API in the ETRM documentation, meaning it is an internal supporting package rather than a formally published public API. Its status is VALID, confirming it is a compiled and active database object. The package has dependencies on the STANDARD package in the SYS schema, which is typical for EBS generated table handlers that rely on standard referential integrity and error-handling utilities.

Key Procedures and Functions

The documented interface exposes eleven procedures and functions. The core DML procedures are INSERT_ROW, UPDATE_ROW, DELETE_ROW, and ADD_ROW, which provide the insert, update, delete, and add operations against the IGS_TR_STEP record set. LOCK_ROW provides row-level locking semantics to support concurrent access control. The BEFORE_DML procedure handles pre-DML logic such as deriving values, validating business rules, and populating WHO columns before an insert or update is committed. The CHECK_CONSTRAINTS procedure enforces table-level and unique constraints prior to committing changes. Three foreign key retrieval routines are documented: GET_FK_IGS_PE_PERSON, GET_FK_IGS_TR_ITEM, and GET_FK_IGS_LOOKUPS_VIEW, each of which resolves a foreign key reference for the corresponding parent entity. GET_PK_FOR_VALIDATION returns the primary key value used to validate the record being processed. Notably, IGS_TR_STEP_PKG is itself both a caller and a dependent of related packages, and the metadata shows it references and is referenced by itself, indicating internal recursive calls within the package body.

Tables Accessed

The package operates against a single documented base table accessed through the APPS synonym IGS_TR_STEP. All insert, update, delete, lock, and validation operations in the DML procedures target this table. Foreign key resolution routines reference parent entities conceptually tied to IGS_PE_PERSON, IGS_TR_ITEM, and IGS_LOOKUPS_VIEW, although these are resolved indirectly through the GET_FK procedures rather than through direct table DML in this package. The IGS_TR_STEP table stores individual step definitions or step instances belonging to a transaction item, and this package is the primary programmatic gateway for maintaining those rows.

Usage Notes

IGS_TR_STEP_PKG is typically invoked from the Oracle Forms-based student transaction maintenance windows and from related PL/SQL packages rather than from concurrent programs directly. The ETRM metadata records that it is referenced by five other packages: IGS_LOOKUPS_VIEW_PKG, IGS_RE_GEN_003, IGS_TR_GEN_002, IGS_TR_ITEM_PKG, and IGS_TR_STEP_NOTE_PKG. This dependency pattern confirms that the package serves as a lower-level data access layer consumed by higher-level transaction generation and note packages. Customizations that manipulate transaction step data should call the documented DML procedures rather than issuing direct SQL against IGS_TR_STEP, to preserve BEFORE_DML processing, constraint checks, and WHO column auditing. When extending or debugging transaction behavior, developers should review the consuming packages listed above to understand the full call path.