Results for “get_fk_igs_ad_room”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AD_PANEL_DTLS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Student System (IGS) product family in the "AD" (Admissions) module. Its business purpose is to encapsulate the persistence and validation logic for the IGS_AD_PANEL_DTLS entity, which stores panel detail records used during the admissions selection and interview process. In this context, a "panel" is a group of interviewers or evaluators assembled to assess applicants; the panel detail rows captured by this package define the individual components of those panels and their relationships to interviews, locations, rooms, and code classifications.

The package is documented with an OTHER API classification, indicating it is an internal processing package rather than a formally published public API. It follows the standard Oracle Forms-generated table handler pattern, combining data manipulation routines with foreign-key lookup helpers and a BEFORE_DML server-side trigger. The package is VALID in the ETRM 12.1.1 metadata and follows the same structure in 12.2.2, where it remains in the APPS schema and continues to be referenced by the same set of dependent packages.

Key Procedures and Functions

The documented API surface comprises twelve procedures and functions. INSERT_ROW, UPDATE_ROW and DELETE_ROW perform the core DML against the panel detail table, while ADD_ROW provides a combined insert path used by the Forms block. LOCK_ROW issues a SELECT FOR UPDATE against the target row to support optimistic concurrency control when a form user edits a panel detail. BEFORE_DML is the server-side trigger that fires prior to insert, update or delete, enforcing WHO-column stamping and validation rules.

• GET_PK_FOR_VALIDATION and GET_UK_FOR_VALIDATION resolve primary-key and unique-key values for validation purposes, allowing dependent packages to confirm the identity and uniqueness of a panel detail row.
• GET_FK_IGS_AD_INTVW_PNLS, GET_FK_IGS_AD_LOCATION and GET_FK_IGS_AD_ROOM return foreign-key descriptors for the interview panel, location and room entities respectively, supporting LOV and referential validation in the forms layer.
• GET_UFK_IGS_AD_CODE_CLASSES retrieves the unique foreign key associated with the code classification entity.

These routines are named according to the Oracle Application Object Library naming convention, so their intent can be inferred without exposing internal parameter lists.

Tables Accessed

The package reads and writes through APPS synonyms for IGS_AD_PANEL_DTLS and its sequence-like companion object IGS_AD_PANEL_DTLS_S. It validates against IGS_AD_CODE_CLASSES, IGS_AD_INTVW_PNLS, IGS_AD_LOCATION and IGS_AD_ROOM, all of which supply foreign-key reference data. Related hierarchical entities IGS_AD_PANEL_MEMBRS, IGS_AD_PNL_HIS_DTLS and IGS_AD_PNMEMBR_DTLS are also referenced, reflecting the parent/child structure of panels, members and historical detail records. The package itself depends only on SYS.STANDARD, confirming it is a pure PL/SQL table handler with no external service dependencies.

Usage Notes

IGS_AD_PANEL_DTLS_PKG is invoked primarily from Oracle Forms panels that maintain the panel detail block, and it is called programmatically by seven other packages in the Admissions module: IGS_AD_CODE_CLASSES_PKG, IGS_AD_INTVW_PNLS_PKG, IGS_AD_INT_RECONSIDER, IGS_AD_LOCATION_PKG, IGS_AD_PNL_HIS_DTLS_PKG, IGS_AD_PNMEMBR_DTLS_PKG, IGS_AD_ROOM_PKG and itself. Custom code should call the documented procedures rather than issuing direct DML, so that the BEFORE_DML trigger validation and WHO-audit columns are applied consistently. Because it is classified as OTHER rather than a public API, the package signature should be treated as internal and verified against the target instance before use in extensions or concurrent programs.