Search Results igs_ad_appqual_code_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_AD_APPQUAL_CODE_PKG package is a table-handler (data manipulation) package within the Oracle E-Business Suite Student System (Oracle Student Information / Admissions) module. Its role is to encapsulate the create, read, update, and delete operations for the IGS_AD_APPQUAL_CODE entity, which stores the codes representing applicant qualification types used during the admissions process. By centralising DML logic for this validation-code entity, the package provides a stable API that other admissions packages and forms can call without embedding direct SQL against the underlying table. The package is classified as an OTHER API type (rather than a public or private API), and its status is VALID in the documented environment. It exists in both the 12.1.1 and 12.2.2 EBS releases as part of the APPS schema under the IGS (Student System) product family.

Key Procedures and Functions

The package exposes nine documented procedures and functions, structured around a conventional table-handler pattern:

  • INSERT_ROW — Inserts a new qualification-code record into IGS_AD_APPQUAL_CODE.
  • UPDATE_ROW — Updates an existing qualification-code record identified by its primary key.
  • DELETE_ROW — Removes a qualification-code record from the table.
  • LOCK_ROW — Acquires a row-level lock on an existing record, typically to enforce optimistic concurrency before an update.
  • ADD_ROW — A higher-level convenience routine that adds a new row, generally wrapping INSERT_ROW with additional defaulting or validation logic.
  • GET_PK_FOR_VALIDATION — Returns the primary key value(s) required for validation lookups of the qualification code.
  • GET_FK_IGS_AD_PS_APPL_INST — Retrieves foreign-key reference data related to the applicant instance (IGS_AD_PS_APPL_INST) context.
  • GET_FK_IGS_AD_CODE_CLASSES — Retrieves foreign-key reference data relating the qualification code to the IGS_AD_CODE_CLASSES classification hierarchy.
  • BEFORE_DML — A pre-DML trigger-style procedure invoked to apply WHO-column population and derived-attribute logic before insert or update operations execute.

No parameter lists are documented in the ETRM metadata; callers should reference the package specification in the database for exact signatures.

Tables Accessed

Per the documented metadata, the package references a single base table through an APPS synonym: IGS_AD_APPQUAL_CODE. All insert, update, delete, and lock operations target this table, and the primary-key and foreign-key helper functions derive their values from it. The FK helpers indicate associative relationships with IGS_AD_PS_APPL_INST (the applicant instance) and IGS_AD_CODE_CLASSES (the code classification structure), which are validated or referenced when the qualification code is created or modified.

Usage Notes

IGS_AD_APPQUAL_CODE_PKG is referenced by five other packages in the Student System, including IGS_ADMAPPLICATION_PUB, IGS_AD_CODE_CLASSES_PKG, IGS_AD_GEN_014, IGS_AD_INT_RECONSIDER, and IGS_AD_VAL_ACAI_FTR_OFFER. This dependency pattern demonstrates that the package is consumed internally by higher-level admissions business logic, validation routines, and concurrent programs rather than being called directly by end users. It also references itself, indicating recursive or internal helper invocation. Typical invocation contexts include:

  • Admissions setup and validation forms where qualification codes are maintained.
  • Validation routines executed during application processing and reconsideration workflows.
  • Concurrent programs that generate or reconcile admissions data (IGS_AD_GEN_014).
  • Public API calls issued through IGS_ADMAPPLICATION_PUB when an application record references a qualification code.

Custom code should not bypass this package and write directly to IGS_AD_APPQUAL_CODE, because BEFORE_DML enforces standard WHO-audit and validation behaviour. Callers are advised to respect the documented API boundaries and invoke the package procedures within a properly committed transaction scope.