Search Results igs_ad_panel_dtls_pkg




Overview
Explore in AI Chat

Overview

The package body APPS.IGS_AD_PANEL_DTLS_PKG is a server-side PL/SQL component within the Oracle E-Business Suite Admissions (IGS) product family. Its name reflects the entity it manages: panel details associated with the admissions interview and selection process. In Oracle EBS 12.1.1 and 12.2.2, the IGS_AD schema area supports the academic admissions lifecycle, including applicant tracking, interview panel composition, member appointments, room and location allocation, and historical audit of panel activity. This package encapsulates the data manipulation and validation logic required to maintain records in the IGS_AD_PANEL_DTLS entity and its closely related child and history tables.

As a generated-style package body with classification OTHER, its role is primarily CRUD-oriented. It provides the interface layer through which forms, concurrent processes, and other packages interact with panel detail data without embedding raw DML in every consumer. It is referenced by seven other packages, indicating it sits centrally in the admissions panel processing chain.

Key Procedures and Functions

The ETRM metadata documents twelve procedures and functions, spanning row operations, key derivation, foreign key verification, and DML event handling.

  • INSERT_ROW — Inserts a new panel detail row, applying defaulting and derived column logic.
  • LOCK_ROW — Acquires a row-level lock on an existing panel detail record to enforce concurrency control.
  • UPDATE_ROW — Modifies attributes of an existing panel detail record.
  • ADD_ROW — Combines validation and insertion for new records, typically invoked from entry forms.
  • DELETE_ROW — Removes a panel detail record, respecting dependent child data.
  • GET_PK_FOR_VALIDATION — Returns the primary key value used for uniqueness and existence validation.
  • GET_UK_FOR_VALIDATION — Returns the unique key value used for duplicate detection during validation.
  • GET_FK_IGS_AD_INTVW_PNLS — Resolves the foreign key relationship to the interview panel master.
  • GET_FK_IGS_AD_LOCATION — Resolves the foreign key to the location entity.
  • GET_FK_IGS_AD_ROOM — Resolves the foreign key to the room entity.
  • GET_UFK_IGS_AD_CODE_CLASSES — Resolves the unvalidated foreign key to admissions code classes.
  • BEFORE_DML — Trigger-equivalent logic that executes before insert, update, or delete, populating WHO columns and enforcing business rules.

Tables Accessed

The package references seven application tables via APPS synonyms, in addition to utility packages and SYS.STANDARD. The primary entity is IGS_AD_PANEL_DTLS, with the _S suffix table (IGS_AD_PANEL_DTLS_S) providing intersection or secondary relationship storage. Related child and history tables include IGS_AD_PANEL_MEMBRS (panel membership), IGS_AD_PNL_HIS_DTLS (panel detail history), and IGS_AD_PNMEMBR_DTLS (panel member details). Validation lookups draw on IGS_AD_CODE_CLASSES and the interview panel master IGS_AD_INTVW_PNLS. Foreign key resolution procedures confirm the linkage to location and room definitions used for scheduling physical panel meetings.

Usage Notes

This package is invoked whenever panel detail records must be created, modified, or removed within the admissions process. Typical callers include the Admissions forms built on IGS_AD_SS_APPL_UPD_PAGE and the processing category step logic in IGS_AD_PRCS_CAT_STEP. It also participates in the broader dependency web alongside IGS_AD_INTVW_PNLS_PKG, IGS_AD_PNMEMBR_DTLS_PKG, IGS_AD_PNL_HIS_DTLS_PKG, IGS_AD_LOCATION_PKG, and IGS_AD_ROOM_PKG, which call it for foreign key and row validation. Error handling uses APP_EXCEPTION, FND_MESSAGE, and IGS_GE_MSG_STACK, so exceptions surface through the standard EBS message stack. Because it is not referenced by any database object, direct invocation is expected only from PL/SQL code, forms triggers, or concurrent program logic.