Search Results igs_ca_type_pkg




Overview
Explore in AI Chat

Overview

IGS_CA_TYPE_PKG is an Oracle EBS PL/SQL package body owned by the APPS schema that provides the core data-access and maintenance API for the IGS_CA_TYPE table, the repository of calendar type definitions used throughout the Oracle Student System (formerly Oracle iLearning/Student Systems) product family. Calendar types describe the categories of academic calendars that an institution maintains — for example, academic year calendars, semester structures, enrolment period calendars, and fee-calendar classifications. Because these type definitions are referenced by a wide range of downstream entities (calendar instances, attendance type loading, unit offering patterns, enrolment configuration, and fee triggers), the package exists primarily to centralise validation, surrogate-key generation, and referential-integrity enforcement for the base table. It is documented in the ETRM as API classification OTHER, indicating that it is an internal generated/support package rather than a formally published public API, though its procedures are callable from other PL/SQL units within the APPS schema.

Key Procedures and Functions

The package exposes ten documented procedures and functions, reflecting a standard Oracle Forms-style table handler pattern:

  • INSERT_ROW — Inserts a new calendar type record into IGS_CA_TYPE, applying column-level defaults and validation.
  • UPDATE_ROW — Updates the mutable attributes of an existing calendar type record.
  • DELETE_ROW — Removes a calendar type record, subject to constraint checks.
  • ADD_ROW — Higher-level insert wrapper that combines key generation and insertion in a single call.
  • LOCK_ROW — Acquires a row-level lock on a calendar type to support concurrent-update control from Forms or batch processes.
  • BEFORE_DML — Central pre-DML hook that populates audit/who columns and derives values prior to insert or update.
  • CHECK_CONSTRAINTS — Validates business and referential constraints before the DML is committed.
  • GET_PK_FOR_VALIDATION — Returns the primary key of the row being processed so dependent validation logic can resolve the correct record.
  • GET_FK_IGS_CA_ARTS_TC_CA_CD — Resolves the foreign-key relationship to the IGS_CA_ARTS_TC_CA_CD calendar type / teaching calendar mapping.
  • GET_FK_IGS_LOOKUPS_VIEW — Resolves foreign-key references against the FND lookups view used for descriptive flexfield or lookup-backed attributes.

Tables Accessed

The only documented table referenced through APPS synonyms is IGS_CA_TYPE, the master calendar type table. All ten procedures operate against this single entity: INSERT_ROW/ADD_ROW write to it, UPDATE_ROW and LOCK_ROW modify or lock existing rows, DELETE_ROW removes them, and the GET_FK procedures read it (and the related lookup view) to validate foreign-key values. Supporting objects include APP_EXCEPTION, FND_MESSAGE, FND_GLOBAL and IGS_GE_MSG_STACK for error handling and message resolution, and IGS_CA_VAL_CAT for calendar type validation categories.

Usage Notes

IGS_CA_TYPE_PKG is not referenced by any other database object at the schema level, so it is invoked by external callers rather than by database triggers or views. In practice it is called from the Oracle Forms calendar type maintenance screen, from concurrent programs that load or validate calendar configuration, and from the twenty-two dependent packages that consume calendar types — including IGS_CA_INST_PKG, IGS_EN_CONFIG_ENR_CP_PKG, IGS_PS_OFR_PKG, IGS_PS_FEE_TRG_PKG and IGS_FI_UNIT_FEE_TRG_PKG. Custom extensions should call these procedures rather than issuing direct DML against IGS_CA_TYPE so that audit columns, surrogate keys and constraint validation remain consistent. Because the package is classified OTHER rather than as a published API, signature stability across patch levels should be verified before relying on it in custom code.