Search Results get_fk_igf_ap_isir_matched




Overview
Explore in AI Chat

Overview

IGF_AP_ISIR_CORR_PKG is a PL/SQL package owned by the APPS schema within Oracle E-Business Suite. It provides the transaction-processing API layer for the IGF_AP_ISIR_CORR_ALL entity, which stores correction records applied to ISIR (Institutional Student Information Record) data in the Financial Aid module. Each ISIR correction captures the original value reported by the student, the corrected value applied by the institution, the SAR field number affected, the correction sequence and calendar context, and a correction status indicator.

The package is a table-handler style API. It encapsulates all direct DML against the correction table so that callers do not manipulate the base table directly, and it enforces primary key, unique key, and foreign key integrity through dedicated validation functions. The package header declares AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the defining user, a common pattern for seed-data and form-driven APIs in EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new ISIR correction row, returning the generated row identifier and primary key through IN OUT NOCOPY parameters. It accepts the full set of column attributes and a defaulted mode flag.
  • LOCK_ROW — Acquires a row-level lock on the identified correction record, used to serialize concurrent updates in an Oracle Forms environment.
  • UPDATE_ROW — Updates an existing correction record identified by its row identifier and primary key, with the same column attributes and mode flag used by insert.
  • ADD_ROW — Combines the insert path with key generation, returning both row identifier and primary key to the caller.
  • DELETE_ROW — Removes a correction record based on the supplied row identifier.
  • GET_PK_FOR_VALIDATION — Validates that the supplied primary key value exists, returning a Boolean result.
  • GET_UK_FOR_VIOLATION of the unique key — GET_UK_FOR_VALIDATION validates the unique combination of ISIR identifier, SAR field number, and correction status, returning a Boolean result.
  • GET_FK_IGF_AP_ISIR_MATCHED — Foreign key validation routine for the ISIR header reference. It confirms that the ISIR identifier supplied on a correction record corresponds to a valid, matched ISIR parent row before the child correction is committed. This is the routine surfaced by the user's search term.
  • GET_FK_IGS_CA_INST_ALL — Foreign key validation against the IGS_CA_INST_ALL calendar instance table, ensuring the correction's calendar type and sequence reference a valid calendar instance.
  • BEFORE_DML — Internal trigger-style routine invoked ahead of DML operations to apply validation and derived-value logic.

Tables Accessed

The package operates against IGF_AP_ISIR_CORR_ALL, the base correction table, which is the target of insert, update, and delete operations and the source for all validation queries. It reads IGF_AP_ISIR_CORR_S, the corresponding sequence and key-generation view or table, to obtain new ISIRC_ID primary key values. Validation lookups that resolve the ISIR identifier and calendar instance reference also touch DUAL for singleton expression evaluation and the ISIR and calendar instance parent tables through foreign key checks. All references are made through APPS synonyms, consistent with the EBS data model.

Usage Notes

IGF_AP_ISIR_CORR_PKG is typically invoked from Oracle Forms user exits and PL/SQL blocks that maintain ISIR correction data, and from custom batch or concurrent programs that load corrections in bulk. Because the package is referenced by six other packages, the recommended practice is to call its procedures rather than issuing direct DML against IGF_AP_ISIR_CORR_ALL, so that key validation and locking semantics remain consistent. The GET_FK_IGF_AP_ISIR_MATCHED routine is particularly relevant to integrations that create correction rows, since it must succeed before the correction can be considered bound to a valid matched ISIR.