Results for “igs_ad_cat_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AD_CAT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Student System (IGS) product family. The naming convention — IGS_AD_CAT — places it within the Admissions (AD) module and associates it with the "Category" entity, most commonly the admission category construct used to classify applicants, application types, and related admissions processing rules. In ETRM terms the package is classified as OTHER rather than as a formal public API, which indicates that it functions primarily as a table-handling and validation package supporting the IGS_AD_CAT_ALL base table rather than as an end-user-facing interface.

The package provides the standard DML support layer for admission category data: insertion, update, deletion, row locking, primary key resolution, and constraint enforcement. It is a foundational dependency for a broad set of admissions, enrollment, financial aid, and prospect-to-student conversion packages, reflecting the central role that the category entity plays across the student lifecycle.

Key Procedures and Functions

The ETRM metadata documents eight procedures within IGS_AD_CAT_PKG. Their purposes are as follows:

• INSERT_ROW — Inserts a new admission category record into the underlying table, populating the mandatory columns and WHO columns required for a valid row.
• UPDATE_ROW — Applies changes to an existing admission category record identified by its primary key.
• DELETE_ROW — Removes an admission category record from the table, typically after validation that no dependent data would be orphaned.
• LOCK_ROW — Acquires a row-level lock on the specified record, used to serialize concurrent modifications and prevent lost updates.
• ADD_ROW — A higher-level insert routine, generally wrapping INSERT_ROW with preparatory logic such as key derivation or default value assignment.
• GET_PK_FOR_VALIDATION — Retrieves the primary key of a category record so that validation logic can confirm the row exists and is accessible before further processing.
• CHECK_CONSTRAINTS — Enforces business and referential integrity rules on the category data, raising errors when the supplied values violate the expected constraints.
• BEFORE_DML — A pre-DML hook invoked prior to insert, update, or delete operations, used to apply common validation, defaulting, and WHO column maintenance.

No parameter signatures are published in the ETRM extract; callers should inspect the package specification in the target environment before invoking these routines directly.

Tables Accessed

The only documented table referenced through APPS synonyms is IGS_AD_CAT_ALL. This is the multi-organization (or "_ALL") table that stores admission category definitions and their associated attributes. All eight procedures operate against this table: the DML routines insert, update, and delete rows; LOCK_ROW and GET_PK_FOR_VALIDATION read it to establish and confirm record identity; CHECK_CONSTRAINTS and BEFORE_DML read it to validate incoming values against existing data.

At the database level the package also references SYS.STANDARD, the standard PL/SQL package, which is a normal dependency for any compiled package unit.

Usage Notes

IGS_AD_CAT_PKG is an internal support package rather than a user-invoked API. It is typically called from the Oracle Forms-based admissions setup windows where administrators define and maintain admission categories, with the form's block-level triggers delegating insert, update, and delete operations to the corresponding package procedures. Direct end-user invocation is not expected.

The package is referenced by ten other APPS packages, including IGS_AD_APCTR_RU_PKG, IGS_AD_CAT_PS_TYPE_PKG, IGS_AD_CT_HECS_PAYOP_PKG, IGS_AD_PERD_AD_CAT_PKG, IGS_AD_PRCS_CAT_PKG, IGS_CO_CAT_MAP_PKG, IGS_EN_CAT_MAPPING_PKG, IGS_FI_FEE_CAT_MAP_PKG, IGS_PS_OF_OPT_AD_CAT_PKG, and IGS_PS_PAT_OF_STUDY_PKG. This dependency graph shows the package serving as the shared access layer for admission categories consumed by admissions processing, program-of-study option configuration, enrollment category mapping, and finance fee category mapping. Custom code that needs to add or modify admission categories should invoke this package's procedures rather than issuing direct DML against IGS_AD_CAT_ALL, so that validation and WHO column handling remain consistent. Because the package is a dependency of numerous upstream components, changes to its behavior warrant regression testing across the admissions, enrollment, and financial aid flows that consume it.