Search Results igs_ad_qual_type_pkg

Overview

IGS_AD_QUAL_TYPE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the maintenance and validation of admission qualifying type setup data. In the Oracle Student System (formerly Oracle iLearning/Student Administration, now part of the Higher Education suite), an "admission qualifying type" defines the category of qualification a prospective student presents during an admission process. The package encapsulates the data-manipulation logic for the IGS_AD_QUAL_TYPE entity, providing the insert, lock, update, delete, and validation routines required by the associated maintenance form and any programmatic callers. Because IGS_AD_QUAL_TYPE is a component of the admission categorization framework, this package is closely tied to admission categories and admission process types, and it enforces referential integrity against the parent admission process category record.

The package is classified under ETRM as API classification OTHER. It does not expose a formal business API surface but rather acts as a table-handler generated against the underlying base table, supplemented with foreign-key validation logic used by the form layer.

Key Procedures and Functions

The documented package specification declares eight procedures and one function (the header comments identify eight documented procedures/functions, with GET_FK_IGS_AD_PRCS_CAT being the one referenced in the user's search):

• INSERT_ROW — Performs a direct insert into the qualifying type table, accepting the row identifier and the entity attributes along with a processing mode flag.
• LOCK_ROW — Acquires a row-level lock for the identified qualifying type record to support optimistic concurrency control during form-based editing.
• UPDATE_ROW — Applies modifications to an existing qualifying type record, keyed by the row identifier and attribute values.
• ADD_ROW — Inserts a new qualifying type row, returning the generated row identifier to the caller; typically used where the primary key is derived internally.
• DELETE_ROW — Removes the qualifying type record identified by the supplied row identifier.
• GET_PK_FOR_VALIDATION — A Boolean-returning validation function that confirms the combination of admission category, admission process type, and qualifying type code constitutes a valid existing primary key.
• GET_FK_IGS_AD_PRCS_CAT — Validates the foreign-key relationship to the admission process category entity. It confirms that the supplied admission category and admission process type combination exists in IGS_AD_PRCS_CAT, ensuring that a qualifying type is not created or updated against a non-existent parent category.
• BEFORE_DML — A central pre-DML hook that standardizes audit-column handling and row-level validation across insert, update, and delete operations before firing the actual DML against the base table.

Tables Accessed

The package operates against the IGS_AD_QUAL_TYPE table, accessed through its APPS synonym. This is the primary and only table documented as referenced by the package. Reads and writes against IGS_AD_QUAL_TYPE store and maintain the qualifying type definitions used by admission category setup. The foreign-key validation procedure additionally depends on the admission process category entity (IGS_AD_PRCS_CAT) to verify the parent relationship, although that table is not enumerated in the documented referenced-tables list. The package records no references from other packages, indicating it sits at the leaf of the dependency tree and is not itself a shared utility.

Usage Notes

IGS_AD_QUAL_TYPE_PKG is normally invoked from the Oracle Forms-based maintenance screen for admission qualifying types, where the standard table-handler pattern (INSERT_ROW, LOCK_ROW, UPDATE_ROW, DELETE_ROW, ADD_ROW) is called in response to the user's save, modify, and delete actions. BEFORE_DML is triggered internally by those routines to populate audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY, and to enforce validation prior to commit. GET_FK_IGS_AD_PRCS_CAT and GET_PK_FOR_VALIDATION are called during data entry to prevent orphaned or duplicate qualifying type records.

In Oracle EBS 12.1.1 and 12.2.2 deployments, the package should be treated as an internal, form-generated API. Custom code, interfaces, or concurrent programs that need to create qualifying type data may call the public procedures, but doing so bypasses the form's UI-level validation sequence and should replicate the call order (foreign-key and primary-key validation before DML). Because the package is classified as OTHER rather than a certified public API, Oracle does not guarantee backward compatibility of its signatures across patches, and integrators should prefer supported admission APIs where available.