Search Results igs_ca_ins_roll_ci




Overview
Explore in AI Chat

Overview

The APPS.IGS_CA_INS_ROLL_CI package is a PL/SQL module within the Oracle E-Business Suite (EBS) Student System / Oracle Student Information Management component of the IGS (Institution of Higher/Graduate Studies) application family. It is classified under the APPS schema and its status is VALID in both Oracle EBS 12.1.1 and 12.2.2. Its name derives from the constituent elements IGS_CA (Calendar / Attendance, the IGS sub-module governing academic calendar structures), INS_ROLL (instance roll, referring to the rolling forward or rollover of an academic instance), and CI (calendar instance). Accordingly, the package provides the procedural logic used to roll registration/instance data forward from one calendar instance to a subsequent one, and to validate the preconditions under which such a rollover is permissible. The package operates as a private utility API rather than a public concurrent-program entry point, and the ETRM record confirms it is referenced by no other packages, indicating it is called internally by IGS calendar and instance-processing logic.

Key Procedures and Functions

The ETRM documentation identifies eight callable units:

  • CHK_AND_ROLL_RET — the principal entry point; performs the check-and-roll operation that validates prerequisites and initiates the rollover of retained/returning instance data.
  • CALP_INS_ROLLVR_CI — the core rollover routine that carries calendar-instance records across to the target instance.
  • CALP_INS_ROLLVR_CIR — variant of the rollover logic operating against the instance-relationship (CIR) structures.
  • CALP_INS_ROLLVR_DAI — performs rollover at the detailed academic-instance (DAI) level.
  • CALP_INS_ROLLVR_DAIO — rollover targeting detailed academic-instance office/organisation data.
  • CALP_INS_ROLLVR_DAIOC — companion routine handling further detailed-instance attribute processing during rollover.
  • CALP_INS_ROLLVR_DAIP — rollover processing for detailed academic-instance participant/personnel records.
  • CALP_VAL_APCOOD_ROLL — a validation routine (prefix VAL) that verifies the roll eligibility or attribute conditions prior to committing a rollover.

The naming convention (CALP prefix on most units) suggests these are calendar-processing subprograms intended for internal invocation rather than direct form wiring.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

Usage Notes

Because ETRM records zero packages referencing IGS_CA_INS_ROLL_CI, it is not a shared public interface. It is invoked internally during academic-calendar instance rollover processing — typically when a new academic term or instance is created and prior instance records must be propagated. Administrators and developers should treat it as a private helper package: it should not be called directly from Forms or custom concurrent programs without confirming the calling context and transaction boundaries. Diagnostics should be drawn from IGS_GE_S_LOG_ENTRY, which the package populates during execution.