Search Results igs_ca_da_inst_ofcnt_pkg




Overview
Explore in AI Chat

Overview

IGS_CA_DA_INST_OFCNT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Student Systems / Higher Education product family, indicated by the IGS prefix, and specifically to the Curriculum Assignment (CA) component, where "DA" denotes a data access layer and INST_OFCNT refers to institution offering count data. The package encapsulates the database access logic for the IGS_CA_DA_INST_OFCNT table, which stores institution-level counts associated with offerings in the academic structure. Its classification is OTHER, meaning it is an internal infrastructure package rather than a public API, and it is not documented as a formal extension point for customer modification.

The package exists to centralize the insert, update, delete, and validation operations performed against institution offering count records, ensuring consistent constraint checking and primary/foreign key handling across the modules that depend on this data.

Key Procedures and Functions

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

  • INSERT_ROW — Inserts a new institution offering count record into the underlying table.
  • UPDATE_ROW — Modifies an existing institution offering count record.
  • DELETE_ROW — Removes an institution offering count record.
  • ADD_ROW — Adds a record, typically used where the caller supplies values and the package performs the insert logic.
  • LOCK_ROW — Acquires a row-level lock on a specific record, used to serialize concurrent modifications.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of the record being validated, supporting the constraint-checking flow.
  • CHECK_CONSTRAINTS — Validates that data being written complies with the table's business and referential constraints before DML proceeds.
  • BEFORE_DML — A pre-DML hook that executes standard housekeeping logic, such as defaulting and validation, before an insert, update, or delete is applied.
  • GET_FK_IGS_CA_DA_INST_OFST — Resolves the foreign key relationship to the institution offering (IGS_CA_DA_INST_OFST) parent record.
  • GET_FK_IGS_LOOKUPS_VIEW — Resolves the foreign key relationship to the lookups view, supporting validation of coded values.

Tables Accessed

Per the documented metadata, this package accesses the table IGS_CA_DA_INST_OFCNT through APPS synonyms. This table holds the institution offering count records that the procedures above maintain. No other base tables are documented as directly referenced, though the two foreign key helper functions indicate logical dependencies on the institution offering table (IGS_CA_DA_INST_OFST) and on the lookups view used for validated code values.

Usage Notes

IGS_CA_DA_INST_OFCNT_PKG is referenced by three other packages: IGS_CA_DA_INST_OFST_PKG, IGS_CA_INS_ROLL_CI, and IGS_LOOKUPS_VIEW_PKG. This confirms its role as a low-level data access package consumed by higher-level business logic rather than being invoked directly by an end user. It is typically called from within these dependent packages when institution offering count data must be created, validated, or maintained as part of a broader transaction, such as rolling up offering counts for an institution.

Because the package is classified OTHER and is internally referenced, it should not be treated as a supported public API. Customizations should avoid calling it directly; instead, customers should extend at the level of the dependent packages or use supported APIs. When troubleshooting data integrity issues in IGS_CA_DA_INST_OFCNT, this package is the correct starting point for tracing insert, update, delete, and constraint-validation behaviour.