Search Results igs_ca_da_inst_ofst_pkg




Overview
Explore in AI Chat

Overview

APPS.IGS_CA_DA_INST_OFST_PKG is a PL/SQL package in the Oracle EBS Applications (APPS) schema that belongs to the Student Systems / Student Records family of modules, specifically the IGS (Institution of Higher Education) product line covering calendar, attendance, and related institutional data. The "CA" component denotes the Calendar/Attendance sub-domain, while "DA_INST_OFST" refers to the institution offset entity — typically an offset or adjustment record associated with an institution record within the calendar structure. The package provides the programmatic data-access layer for the IGS_CA_DA_INST_OFST table, encapsulating the standard row-level DML operations (insert, update, delete, lock) alongside constraint validation and pre-DML processing logic that Oracle EBS uses to enforce referential and business integrity.

As documented in ETRM for 12.1.1, the package carries an API classification of OTHER, meaning it is not published as a formal public API but is an internal implementation package used by Oracle's own forms and dependent packages. It is schema-resident in APPS and has a VALID status, indicating it compiles cleanly and is deployed in a supported state.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions:

  • INSERT_ROW — Inserts a new record into the underlying institution-offset table, applying defaulted and derived column values before the physical insert.
  • LOCK_ROW — Acquires a row-level lock on a specified offset record to support optimistic concurrency control during edit operations.
  • UPDATE_ROW — Modifies an existing institution-offset record, observing the same validation rules applied on insert.
  • ADD_ROW — Adds a row, typically invoked in contexts where a higher-level container (such as an institution or calendar block) supplies the parent context.
  • DELETE_ROW — Removes an institution-offset record subject to the package's constraint checks.
  • GET_PK_FOR_VALIDATION — Returns the primary key of a row so that the caller can perform validation, typically for foreign-key or duplicate checks prior to DML.
  • CHECK_CONSTRAINTS — Evaluates the business and referential constraints governing the offset record; raises an error if any constraint is violated.
  • BEFORE_DML — A pre-DML hook that runs standard housekeeping (such as populating WHO columns, defaults, or derived attributes) before insert, update, or delete.
  • GET_FK_IGS_CA_DA_INST — Resolves the foreign key to the parent IGS_CA_DA_INST record, linking each offset row to its owning institution instance.

Tables Accessed

The package operates on a single documented base table, IGS_CA_DA_INST_OFST, accessed through an APPS synonym. This table stores the institution-offset rows that the package inserts, updates, locks, and deletes. The GET_FK_IGS_CA_DA_INST function additionally resolves the relationship to the parent IGS_CA_DA_INST entity, though the offset table itself remains the primary DML target.

Usage Notes

IGS_CA_DA_INST_OFST_PKG is an internal support package rather than a customer-facing public API. ETRM shows it referenced by three or more sibling objects: IGS_CA_DA_INST_OFCNT_PKG, IGS_CA_DA_INST_PKG, and IGS_CA_INS_ROLL_CI, plus itself. In practice it is invoked by those packages and by Oracle Forms-based UI layers (for example, institution and calendar maintenance forms) whenever institution-offset data is created or amended. Because the API classification is OTHER, customers should not call these procedures directly for extensions; customizations should instead target the documented public APIs or use table-level DML with appropriate validation, while honoring the constraint logic enforced by CHECK_CONSTRAINTS and BEFORE_DML.