Search Results igs_ad_gov_bas_fr_ty_pkg

Overview

IGS_AD_GOV_BAS_FR_TY_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Applications DBA (AD) product family within the Student Systems / Higher Education (IGS) module set. Its name resolves as "IGS AD (Admissions) – GOVernment BASis FOR Type." The package encapsulates the data-maintenance logic for the IGS_AD_GOV_BAS_FR_TY entity, which stores the mapping between government bodies and the basis-for-admission types that apply to them — for example, which government agencies, funding authorities, or statutory categories are valid sources for a given basis-for-admission type. This is reference or lookup data used during admissions processing, so the package functions as a low-level table-handling API (commonly generated by the Oracle Forms / Oracle Designer table-handler pattern) rather than as a business-rule engine. It performs the standard insert, update, delete, lock, and validation operations that Forms-based maintenance screens and dependent APIs require. The package is documented as VALID, version 12.1.1, in the ETRM repository and carries no additional business-specific scope beyond row maintenance.

Key Procedures and Functions

The documented public interface comprises eight subprograms, all consistent with a generated table handler:

• INSERT_ROW — Inserts a new row into the underlying entity, populating the column set defined for the table.
• UPDATE_ROW — Applies changes to an existing row, keyed on the primary key columns.
• DELETE_ROW — Removes a single row identified by its primary key.
• LOCK_ROW — Acquires a row-level lock so that an editing session can safely update the record and detect concurrent modification.
• ADD_ROW — Convenience wrapper that performs the insert path, typically invoked from a Forms "create record" action.
• GET_PK_FOR_VALIDATION — Resolves or verifies the primary key for a row before validation, ensuring uniqueness checks run against the correct record.
• CHECK_CONSTRAINTS — Enforces the mandatory, foreign-key, and uniqueness rules associated with the entity before a DML operation is committed.
• BEFORE_DML — A pre-DML hook that computes derived or WHO-audit columns and performs any final checks immediately prior to insert, update, or delete.

No parameter lists are reproduced here; the metadata documents subprogram names and their roles only.

Tables Accessed

The package operates on a single documented table, IGS_AD_GOV_BAS_FR_TY, accessed through its APPS synonym. All eight subprograms target this table: the DML routines write to it, LOCK_ROW and GET_PK_FOR_VALIDATION select from it for key resolution and concurrency control, and CHECK_CONSTRAINTS and BEFORE_DML read it to validate integrity and derive audit values. No other application tables are documented as referenced.

Usage Notes

This package is a supporting component rather than a user-facing entry point. It is documented as referenced by APPS.IGS_AD_BASIS_FOR_AD_PKG, the admissions basis-for-admission package, which invokes it when maintaining the government/basis-for-type relationship. It also appears in its own dependency list, indicating internal self-reference. Its only technical dependency is SYS.STANDARD. Typical invocation is from Oracle Forms maintenance blocks tied to the IGS Admissions setup module and from the parent IGS_AD_BASIS_FOR_AD_PKG; direct calls from custom code should be limited to controlled data loads, since bypassing the Forms layer bypasses the surrounding validation flow. Deployments should confirm current naming locates this package as a viable object in the target instance, as package names in the IGS schema changed across releases.