Search Results get_fk_igs_ad_ss_appl_typ

Overview

The APPS.IGS_AD_SS_LOOKUPS_PKG package is a server-side PL/SQL API that manages the IGS_AD_SS_LOOKUPS entity within the Oracle E-Business Suite Advanced Admissions (Student Systems) module. It provides a controlled, encapsulated interface for maintaining self-service lookup configurations mapped to admission application types. Each record associates an ADMISSION_APPLICATION_TYPE with an SS_LOOKUP_TYPE and SS_LOOKUP_CODE, together with a CLOSED_FLAG that governs availability. The package encapsulates the insert, update, delete, locking, and validation logic for this intersection data, ensuring that referential integrity to admission application types is enforced and that standard WHO audit columns (creation and update metadata) are populated consistently. It belongs to the OTHER API classification, indicating it is a generated or supporting data-maintenance package rather than a fully independent business API. Its repository header identifies it as an Advanced Admissions component, conforming to the standard AOL table-handler pattern used throughout IGS modules.

Key Procedures and Functions

• INSERT_ROW — Inserts a new lookup association record, returning the ROWID and admission application type through IN OUT NOCOPY parameters.
• LOCK_ROW — Acquires a row-level lock for the specified combination of application type, lookup type, lookup code, and closed flag to support optimistic concurrency during updates.
• UPDATE_ROW — Modifies an existing record identified by its ROWID, refreshing the lookup attributes and closed flag.
• ADD_ROW — Combines the insert-or-update pattern, taking the ROWID and application type as IN OUT NOCOPY parameters to support forms-style block processing.
• DELETE_ROW — Removes the record identified by the supplied ROWID.
• GET_PK_FOR_VALIDATION — Boolean function verifying that a unique primary-key combination of application type, lookup type, and lookup code exists.
• GET_FK_IGS_AD_SS_APPL_TYP — Validates the foreign-key relationship to the admission application type (the object referenced in the user's search). It confirms that the supplied ADMISSION_APPLICATION_TYPE is a valid parent value, providing the checked side of the master-detail relationship.
• BEFORE_DML — Centralised pre-DML hook that normalises the action and populates the WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) prior to any insert or update.

Tables Accessed

The package reads and writes the IGS_AD_SS_LOOKUPS table, referenced through its APPS synonym. All DML is confined to this single table. Reads occur during lock, validation, and the GET_PK_FOR_VALIDATION and GET_FK_IGS_AD_SS_APPL_TYP checks, while inserts, updates, and deletes are performed by the corresponding handler procedures. The foreign-key validation procedure implicitly depends on the parent definition that owns the valid admission application type values.

Usage Notes

This package follows the standard Oracle Forms server-side table-handler archetype. It is typically invoked from the maintainable Advanced Admissions lookup form, where trigger code calls INSERT_ROW, UPDATE_ROW, LOCK_ROW, and DELETE_ROW in response to end-user actions on the block. The GET_FK_IGS_AD_SS_APPL_TYP and GET_PK_FOR_VALIDATION functions back the LOV and uniqueness validation triggers. Because the package is not referenced by any other documented package, direct programmatic reuse is limited; custom code that needs to maintain self-service lookup mappings should call these procedures rather than issuing direct DML, so that audit columns and integrity checks remain consistent. The package header dates to an early IGS release and remains applicable to Oracle EBS 12.1.1 and 12.2.2.