Search Results igs_ad_program

Overview

IGS_AD_PS_APPL_PKG is a body of the Oracle E-Business Suite (EBS) Advanced Placement / Admissions module, an element of the Student Systems (IGS) schema shipped under the APPS database account. The package encapsulates the business logic that governs records held in the IGS_AD_PS_APPL_ALL table, which stores prospective-student admission applications. In Oracle EBS terms, this is a table-handler or "other" classification API, not a public transactional API. It exists primarily to support the Oracle Forms UI that maintains admission application data, and it is referenced by fifteen other packages throughout the Student Systems codebase.

In the context of the search term "igs_ad_program", it is worth noting that this package concerns the admission application (IGS_AD_PS_APPL) and not the program or course catalogue itself. Program-related data enters the package indirectly, through foreign-key validation procedures that reference course and program-attempt entities such as IGS_PS_COURSE and IGS_EN_STDNT_PS_ATT.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions. Their roles may be summarised as follows:

• INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW — the standard DML operations against IGS_AD_PS_APPL_ALL. INSERT_ROW and UPDATE_ROW assign column values through the internal SET_COLUMN_VALUES routine; DELETE_ROW removes an application row; LOCK_ROW provides a row-level locking cursor used by the calling form.
• ADD_ROW — a combined insert-and-update convenience routine.
• GET_PK_FOR_VALIDATION — resolves the primary key of the admission-application row for validation purposes.
• GET_FK_IGS_AD_APPL — foreign-key lookup against the admission application entity.
• GET_FK_IGS_AD_CD, GET_FK_IGS_AD_BASIS_FOR_AD — foreign-key lookups against admission code and basis-for-admission reference entities.
• GET_FK_IGS_PS_COURSE, GET_FK_IGS_EN_STDNT_PS_ATT — foreign-key lookups against the course catalogue and student program-attempt entities, supporting the nominated/transfer course columns of the application.
• CHECK_CONSTRAINTS — enforces referential and business validation before DML.
• BEFORE_DML — a pre-DML event hook that drives validation and column-value assignment.

Tables Accessed

The sole documented table is IGS_AD_PS_APPL_ALL, accessed through the APPS synonym. It is both read (via the cursor CUR_OLD_REF_VALUES, which selects using ROWID) and written by the DML routines. The all-rows designation indicates the table carries an ORG_ID column and is secured by Multi-Org (the SET_COLUMN_VALUES signature includes x_org_id). Foreign-key procedures additionally reference the admission application, admission code, basis-for-admission, course and student program-attempt entities, but these are read for validation.

Usage Notes

IGS_AD_PS_APPL_PKG is typically invoked from the Admissions Oracle Forms, which call BEFORE_DML, INSERT_ROW, UPDATE_ROW, DELETE_ROW and LOCK_ROW in response to user actions; the GET_FK_* and GET_PK_FOR_VALIDATION routines support LOV and FK field validation. Because it is classified as OTHER rather than a published API and carries no documented grant information, custom code should generally manipulate IGS_AD_PS_APPL_ALL through the admission application business API rather than calling these table-handler routines directly. The header comment ($Header: IGSAI16B.pls 120.1, dated 2005) indicates the object predates the 12.2 E-Business Tax and multi-org upgrades, though the code remains compatible with EBS 12.1.1 and 12.2.2.