Search Results igs_as_grd_sch_trn_pkg

Overview

The APPS.IGS_AS_GRD_SCH_TRN_PKG package is a component of the Oracle E-Business Suite student system, specifically the Academic Records (AS) module used by higher education institutions. It belongs to the grading and schema transcript infrastructure, providing the low-level Data Manipulation Language (DML) layer for the IGS_AS_GRD_SCH_TRN_ALL table. The package encapsulates the insert, update, locking, and deletion logic for grade schema transcript records, shielding calling applications and concurrent programs from direct table manipulation. Its classification within ETRM is listed as OTHER, indicating it is not a public API intended for external integration but rather an internal, table-handler style package that supports the broader grade schema processing framework. The object is stored under the APPS schema and is reported with VALID status, confirming that the package compiles cleanly against the referenced objects in a supported 12.1.1 or 12.2.2 environment.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within this package. Their documented purposes are as follows:

• INSERT_ROW — Inserts a new row into the grade schema transcript table, populating the columns required for a transcript record.
• LOCK_ROW — Acquires a row-level lock on an existing transcript record to prevent concurrent modification during a grade schema maintenance operation.
• DELETE_ROW — Removes a transcript row from the underlying table, typically invoked when a grade schema transcript entry is superseded or purged.
• GET_PK_FOR_VALIDATION — Retrieves the primary key values needed by the calling program to validate or cross-reference the affected transcript record.
• GET_FK_IGS_AS_GRD_SCH_GRADE — Returns the foreign key reference linking the transcript record to the parent grade schema grade definition, enforcing referential integrity.
• CHECK_CONSTRAINTS — Validates the business and database constraints applicable to the transcript row before the DML is committed.
• BEFORE_DML — Implements the pre-DML trigger-style logic that populates audit columns and performs last-minute validation immediately prior to the insert, update, or delete operation.

The presence of LOCK_ROW, CHECK_CONSTRAINTS, and BEFORE_DML is characteristic of the Oracle Designer/Forms-generated table handler pattern, in which each base table is wrapped by a package exposing a consistent set of DML primitives.

Tables Accessed

Per the documented dependencies, the package operates against a single base table accessed through the APPS synonym IGS_AS_GRD_SCH_TRN_ALL. This is the grade schema transcript table that stores the transcript-level attributes associated with a grade schema, including the relationships between a student's academic record and the schema used to render the transcript. The package is the sole documented DML gateway to this table from the grade schema side, and its foreign-key helper explicitly ties transcript rows to the grade schema grade entity.

Usage Notes

ETRM records that IGS_AS_GRD_SCH_TRN_PKG is referenced by one other package, IGS_AS_GRD_SCH_GRADE_PKG, in addition to appearing in its own dependency list. This means the grade schema grade package invokes the transcript handler to maintain related transcript rows when grade definitions are created or amended. Because it is an OTHER-classified internal package, it should not be called directly by customer extensions; customizations should instead target the supported public APIs. In practice, the package is invoked indirectly through Oracle Forms-based grade schema maintenance windows and through any concurrent or batch process that programmatically manipulates grade schema transcript data. The dependency on SYS.STANDARD merely reflects the implicit PL/SQL base package required by every compiled unit and carries no functional significance. When troubleshooting grade schema transcript issues, DBAs may query the package body definition and trace which of the seven documented procedures is executed during the failing transaction.