Search Results igs_ge_s_log_entry_pkg




Overview
Explore in AI Chat

Overview

IGS_GE_S_LOG_ENTRY_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM repository as a generic table-handling (OTHER) API. The "IGS" prefix places it within the Oracle Student System (formerly Oracle iLearning/Student Systems) product family, while the "GE" component indicates it belongs to a General/Generic subsystem used for shared infrastructure across higher-education modules. The package provides the standard insert, update, delete, locking, and validation operations for the IGS_GE_S_LOG_ENTRY entity, which functions as the line-level detail table behind the log entry framework. In this role it acts as a low-level building block rather than a public business API: the student system uses it to record individual log entries generated during processing, error handling, and audit capture. The package is documented as VALID under both EBS 12.1.1 and 12.2.2, and it delegates the constraints of its underlying table to the Oracle database through automatically generated DML logic, a pattern characteristic of Oracle Designer/Forms-generated table APIs.

Key Procedures and Functions

The ETRM metadata records nine procedures and functions exposed by this package:

  • INSERT_ROW — Inserts a new row into the log entry table from supplied column values.
  • UPDATE_ROW — Updates an existing row, typically located by primary key, with the supplied column values.
  • DELETE_ROW — Deletes an existing log entry row identified by its primary key.
  • LOCK_ROW — Obtains a row-level lock on the target record, preventing concurrent modification during a transaction.
  • ADD_ROW — Higher-level convenience routine that coordinates adding a row, including argument defaulting and constraint handling.
  • GET_PK_FOR_VALIDATION — Returns the primary key value used to validate that a candidate row exists before DML is performed.
  • GET_FK_IGS_GE_S_LOG — Returns the foreign key value linking the log entry to its parent IGS_GE_S_LOG record, used for referential validation.
  • CHECK_CONSTRAINTS — Validates the mandatory and referential constraints of the table prior to committing a change.
  • BEFORE_DML — Internal pre-DML hook invoked by the other routines to enforce derived-column and audit-column population before the row is written.

No parameter signatures are documented in the ETRM extract; the procedures should be treated by name and purpose only.

Tables Accessed

The only documented table is IGS_GE_S_LOG_ENTRY, referenced through its APPS synonym. The package is the primary Data Manipulation gateway for this table: all inserts, updates, deletions, and locks pass through the procedures above. The table stores detail lines associated with a parent log entry record, and the presence of GET_FK_IGS_GE_S_LOG confirms a foreign-key relationship to the IGS_GE_S_LOG parent table. Depending on its column set, the table would hold log sequence, message text, error code, severity, and date-stamp information.

Usage Notes

This package is not designed for direct end-user invocation. ETRM shows it referenced by five other program units — IGS_CA_INS_ROLL_CI, IGS_EN_GEN_011, IGS_GE_GEN_001, IGS_GE_GEN_003, and IGS_GE_S_LOG_PKG — indicating that it is called internally by student system concurrent programs and by the higher-level log-handling package IGS_GE_S_LOG_PKG, which owns the business interface. Callers invoke INSERT_ROW/ADD_ROW when a processing step generates a log message, and UPDATE_ROW or DELETE_ROW when entries require correction or purge. Because the package performs no autonomous commit, the calling transaction controls commit and rollback scope. Custom extensions should follow the same rule: call the package within the caller's transaction, avoid updating IGS_GE_S_LOG_ENTRY directly so that CHECK_CONSTRAINTS and BEFORE_DML logic are honoured, and respect the parent/child relationship enforced through GET_FK_IGS_GE_S_LOG.