Results for “get_fk_igr_i_entry_lvls”

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

Overview

IGR_I_APPL_PKG is an Oracle EBS Advanced Education (IGS) application package owned by APPS and classified as an OTHER API within the ETRM repository. It encapsulates the core Data Manipulation Language operations for the IGR_I_APPL entity, which stores applicant enquiry records captured through the institution's admissions and recruitment processes. The package provides a controlled, version-aware interface for inserting, locking, updating, and deleting applicant enquiry rows, together with a suite of validation helpers used to resolve foreign-key relationships and enforce database constraints before DML executes. Its naming and structure conform to the standard Oracle Forms-generated table handler pattern, in which a private BEFORE_DML trigger point orchestrates the flow of row-level processing while individual public procedures expose discrete operations to callers.

Key Procedures and Functions

The package exposes twelve documented procedures and functions. INSERT_ROW creates a new applicant enquiry record, accepting the full set of descriptive and Who columns and returning the generated primary key through its OUT parameters. LOCK_ROW obtains a row-level lock on an existing applicant record to support optimistic concurrency during form editing. UPDATE_ROW performs the corresponding modification, and DELETE_ROW removes an enquiry record. ADD_ROW is the form-integration entry point that the Oracle Forms block invokes, internally dispatching to the appropriate insert or update logic and serving as the public wrapper around the lower-level DML procedures.

Two primary-key and constraint helpers support validation: GET_PK_FOR_VALIDATION returns the composite primary key values needed to confirm row existence, while CHECK_CONSTRAINTS applies the package's business-rule validations before a row is committed. Three foreign-key resolvers are documented: GET_FK_IGS_PE_PERSON, GET_FK_IGS_CA_INST_REL, and GET_FK_IGR_I_ENTRY_LVLS. The last of these, GET_FK_IGR_I_ENTRY_LVLS, is the routine most closely associated with the user's search term; it resolves the entry-level foreign key reference used to associate an enquiry with a valid admissions entry level. GET_FK_IGS_AD_CODE_CLASSES likewise validates a lookup-code relationship. BEFORE_DML is the internal trigger procedure that sequences constraint checking and key derivation ahead of any insert, update, or delete.

Tables Accessed

The package reads and writes three APPS-synonymed tables. IGR_I_APPL_ALL is the base transactional table holding applicant enquiry rows, and is the primary target of INSERT_ROW, UPDATE_ROW, and DELETE_ROW. IGR_I_APPL_S is the corresponding translation or shadow table, accessed so that descriptive (TL) attributes remain synchronized across languages. IGS_PE_HZ_PARTIES provides person and party information, and is read during foreign-key resolution—particularly by GET_FK_IGS_PE_PERSON—to confirm that a supplied person identifier corresponds to a valid TCA party record before the enquiry is persisted.

Usage Notes

IGR_I_APPL_PKG is typically invoked from the Oracle Forms-based admissions enquiry maintenance screens, where the block-level ON-INSERT, ON-UPDATE, ON-DELETE, and ON-LOCK triggers call ADD_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW respectively. The package is also referenced by six other packages in the ETRM schema, indicating it functions as a shared persistence layer for enquiry data rather than a standalone utility. Third-party or custom extensions that need to create applicant enquiries programmatically should call ADD_ROW or INSERT_ROW in preference to direct table inserts, so that BEFORE_DML validation and constraint checking are applied consistently. In Oracle EBS 12.1.1 and 12.2.2 environments the package resides in the APPS schema, and callers must therefore hold appropriate execution privileges or be invoked from within the APPS schema itself.