Results for “igs_ad_prcs_cat_pkg”

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

Overview

IGS_AD_PRCS_CAT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the processing of admissions processing categories within the Oracle Student System (formerly Oracle iLearning/Student Systems) admissions module. The package encapsulates the business logic required to create, maintain, and validate category processing records stored in the IGS_AD_PRCS_CAT_ALL table, which forms part of the admissions setup and processing infrastructure used by educational institutions running EBS 12.1.1 and 12.2.2.

The package functions as a foundational data-access and constraint-handling component rather than an end-user-facing program. It provides a consistent, reusable interface for manipulating admissions processing category data, ensuring referential integrity, validation, and auditability across the many dependent packages that call it. Its API classification is documented as OTHER, indicating it is a supporting utility package rather than a registered public API. In the context of the wider admissions schema, IGS_AD_PRCS_CAT_PKG acts as a central hub: it is referenced by nine other packages and itself references the SYS.STANDARD package, reflecting its role as a low-level building block within the admissions processing chain.

Key Procedures and Functions

The ETRM documentation records eleven procedures and functions within the package. The core DML operations are exposed through INSERT_ROW, UPDATE_ROW, DELETE_ROW, and ADD_ROW, which provide the standard create, modify, and remove capabilities against the processing category record set. The LOCK_ROW procedure supplies row-level concurrency control, ensuring that a record is locked for exclusive modification before updates are applied.

Validation and constraint enforcement are handled by CHECK_CONSTRAINTS, which verifies that the data being persisted satisfies the business and database constraints defined for the entity. GET_PK_FOR_VALIDATION retrieves the primary key value required to perform validation checks, while GET_FK_IGS_AD_CAT and GET_FK_IGS_LOOKUPS_VIEW return foreign key references to the admissions category and lookup view entities respectively, supporting dependent-row and lookup validation.

Two automatic DML-trigger style routines, BEFOREROWINSERTUPDATEDELETE1 and BEFORE_DML, implement the pre-insert, pre-update, and pre-delete logic that fires as part of the package's table API. These routines ensure defaulting, derived column population, and validation occur consistently whenever the underlying table is modified.

Tables Accessed

The sole table documented as referenced through APPS synonyms is IGS_AD_PRCS_CAT_ALL. This table stores the admissions processing category definitions and related configuration records that the package creates, queries, updates, and deletes. All DML procedures operate against this table, while the foreign-key retrieval functions read related key values used to populate and validate the joins between processing categories, admissions categories (IGS_AD_CAT), and lookup code values exposed through the lookups view.

Usage Notes

IGS_AD_PRCS_CAT_PKG is typically invoked indirectly rather than as a standalone program. It is called from the admissions processing packages that depend on it, including IGS_AD_APPL_HIST_PKG, IGS_AD_APPL_PKG, IGS_AD_CAT_PKG, IGS_AD_PRCS_CAT_LTR_PKG, IGS_AD_PRCS_CAT_STEP_PKG, IGS_AD_PRD_AD_PRC_CA_PKG, IGS_AD_QUAL_TYPE_PKG, IGS_AD_SS_APPL_TYP_PKG, and IGS_LOOKUPS_VIEW_PKG. This dependency pattern indicates that the package serves the processing-category letter, processing-category step, product admissions category, applicant type, and qualification type workflows of the Student System.

Practical invocations occur through Oracle Forms and OA Framework pages that maintain admissions processing category configuration, through concurrent programs that generate and process category letters and steps, and through custom PL/SQL extensions that require validated access to IGS_AD_PRCS_CAT_ALL. Because the package enforces constraints and row locking, custom code should call these procedures rather than issuing direct DML against the table, ensuring that validation, defaulting, and audit behavior remain consistent with standard Oracle functionality in both 12.1.1 and 12.2.2 environments.