Search Results get_fk_igs_ad_appl_stat

Overview

IGS_AD_APPL_PKG is a foundational PL/SQL package in the Oracle E-Business Suite (EBS) schema APPS, belonging to the Oracle Student System (IGS) product family focused on admissions processing. The package encapsulates the core database-side logic that governs admissions applications and their associated interest records. In the ETRM registry it is classified as an OTHER API and carries a VALID status, indicating it is an active, deployed database object rather than a deprecated or superseded one.

Functionally, the package provides a stable programmatic interface through which admissions application data is inserted, locked, updated, and deleted in a controlled and consistent manner. It is the central persistence component that many higher-level admissions packages depend upon to manipulate the underlying application records while respecting referential integrity and validation rules.

Key Procedures and Functions

The package exposes 16 documented procedures and functions, organized around standard table-handling conventions:

• INSERT_ROW — creates a new admissions application record.
• ADD_ROW — an alternate entry point for adding rows, frequently used by forms and calling APIs.
• UPDATE_ROW — modifies an existing application record.
• DELETE_ROW — removes an application record.
• LOCK_ROW — obtains a row-level lock to protect against concurrent modification.
• BEFORE_DML — a trigger-style routine that enforces pre-DML logic such as defaulting and validation.
• CHECK_CONSTRAINTS — validates referential and business constraints before DML is applied.
• GET_PK_FOR_VALIDATION — retrieves primary-key information for validation purposes.
• GET_FK_* — a family of foreign-key lookup functions: GET_FK_IGS_AD_SS_APPL_TYP, GET_FK_IGS_CA_INST_REL, GET_FK_IGS_PE_PERSON, GET_FK_IGS_AD_APPL_STAT, GET_FK_IGS_AD_FEE_STAT, GET_FK_IGS_AD_PRD_AD_PRC_CA, GET_FK_IGS_AD_PRCS_CAT, and GET_FK_IGS_AD_CODE_CLASSES. Each resolves and validates the associated foreign entity.

Tables Accessed

The package operates primarily on the following tables, accessed through APPS synonyms:

• IGS_AD_APPL_ALL — the primary admissions application table, holding the master applicant record. INSERT, UPDATE, DELETE, and LOCK operations all target this table.
• IGS_AD_APL_INT_S — the application interest intersection table, capturing the relationship between applications and academic interests. This supports the application’s associated interest data.

Referential checks resolve against the entities implied by the foreign-key lookups, including the personal/party record (IGS_PE_PERSON), the application status (IGS_AD_APPL_STAT), fee status (IGS_AD_FEE_STAT), processing category (IGS_AD_PRCS_CAT), code classes (IGS_AD_CODE_CLASSES), institution relationship (IGS_CA_INST_REL), and application type (IGS_AD_SS_APPL_TYP).

Usage Notes

IGS_AD_APPL_PKG is an internal processing package rather than an end-user-facing API. It is typically invoked indirectly by Oracle Student System forms, concurrent programs, and the higher-level admissions packages that depend on it. The ETRM metadata records 19 referencing packages, including IGS_AD_ACAD_INTEREST_PKG, IGS_AD_APPL_LTR_PKG, IGS_AD_APPL_STAT_PKG, IGS_AD_APP_INTENT_PKG, IGS_AD_APP_REQ_PKG, IGS_AD_FEE_STAT_PKG, IGS_AD_PRCS_CAT_PKG, IGS_AD_PS_APPL_PKG, IGS_AD_PS_APPL_INST_PKG, IGS_AD_SPL_INTERESTS_PKG, IGS_AD_SPL_TALENTS_PKG, IGS_CA_INST_REL_PKG, and several concurrent-program units such as IGS_AD_GEN_014 and IGS_AD_IMP_004.

Customizations and extensions should respect the existing DML order and call CHECK_CONSTRAINTS before committing, and should not bypass the package by writing directly to IGS_AD_APPL_ALL. Because records are shared, LOCK_ROW should be used in multi-user update paths. This behavior is consistent across EBS 12.1.1 and 12.2.2.