Search Results igs_ad_prd_ad_prc_ca_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_AD_PRD_AD_PRC_CA_PKG package is a repository-level PL/SQL package within the Oracle E-Business Suite Academic Products (IGS) module. It manages the association between academic periods and processing categories, a configuration construct used by higher-education institutions to control how admissions and academic processing rules apply across defined time windows. The package is classified as OTHER within the ETRM metadata, indicating that it is not a published public API but rather an internal maintenance package that supports the surrounding IGS admissions and academic structure code base. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and it is owned by the APPS schema.

The package encapsulates the standard DML and validation logic for a single intersection table, IGS_AD_PRD_AD_PRC_CA, which links academic periods to processing categories. This design isolates the referential integrity, locking, and constraint-checking logic required for that relationship, allowing other packages in the IGS admissions suite to manipulate the data safely and consistently.

Key Procedures and Functions

The package exposes nine documented routines that follow the conventional Oracle EBS table-handler pattern:

  • INSERT_ROW — Inserts a new period-to-processing-category association record.
  • UPDATE_ROW — Modifies an existing association record.
  • LOCK_ROW — Obtains a row-level lock to support concurrency control during updates.
  • DELETE_ROW — Removes an association record.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key value used to validate the record prior to DML.
  • CHECK_CONSTRAINTS — Enforces the business and referential constraints applicable to the association.
  • BEFORE_DML — Executes pre-processing logic (defaulting, validation, auditing) before insert, update, or delete operations.
  • GET_FK_IGS_AD_PERD_AD_CAT — Resolves the foreign key reference to the academic period category entity.
  • GET_FK_IGS_AD_PRCS_CAT — Resolves the foreign key reference to the processing category entity.

The two GET_FK functions provide the foreign key lookups needed to maintain integrity against the parent period and processing category definitions.

Tables Accessed

The package operates on the table IGS_AD_PRD_AD_PRC_CA, referenced through an APPS synonym. This table stores the association rows between academic periods and processing categories. All insert, update, lock, delete, and validation activity is centered on this single table. The foreign key helper functions imply logical dependencies on the parent period-category and processing-category tables, though only the association table is documented as directly accessed.

Usage Notes

This package is referenced by seven other packages in the APPS schema, including IGS_AD_APPL_PKG, IGS_AD_INS_ADMPERD, IGS_AD_PECRS_OFOP_DT_PKG, IGS_AD_PERD_AD_CAT_PKG, IGS_AD_PRCS_CAT_PKG, IGS_AD_PRD_PS_OF_OPT_PKG, and IGS_AD_VAL_APAC. It is therefore invoked indirectly through these higher-level packages rather than called directly by Oracle Forms or concurrent programs. Because it is an internal maintenance package, customizations should avoid direct invocation; extension or correction should be performed through the calling packages or by tuning this package in a supported manner. Its dependency on SYS.STANDARD confirms it relies only on core PL/SQL functionality.