Search Results get_fk_igs_uc_crse_dets

Overview

The APPS.IGS_UC_CRSE_VAC_OPS_PKG package is a member of the Oracle E-Business Suite Student Systems / UK higher education (UCAS) integration layer, classified under the generic OTHER API category in ETRM. It encapsulates the database operations for the IGS_UC_CRSE_VAC_OPS entity, which stores course vacancy and "options" information exchanged between the institution and UCAS (the Universities and Colleges Admissions Service). The package provides the standard table-handler API pattern used extensively throughout the IGS (Student System) schema: paired insert/update/delete routines, a row-level locking procedure, an add-row wrapper, a primary-key validation function, a foreign-key lookup function, and a BEFORE_DML trigger helper. It is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the defining schema, which is typical of the APPS-owned, synonym-exposed IGS packages.

Key Procedures and Functions

• INSERT_ROW — Inserts a new course vacancy/options record. Accepts the rowid as an IN OUT NOCOPY parameter (returning the generated rowid) together with the business key columns and descriptive attributes, and a mode flag defaulting to 'R'.
• LOCK_ROW — Issues a row-level SELECT ... FOR UPDATE against the target record, using the business key columns, to provide pessimistic locking for concurrent updates.
• UPDATE_ROW — Updates an existing record identified by rowid, applying the supplied column values and returning through the standard mode flag.
• ADD_ROW — Convenience wrapper that combines validation and insertion semantics, returning the new rowid through the IN OUT NOCOPY parameter. Commonly used by Forms to create a row in a single call.
• DELETE_ROW — Deletes a single record identified solely by its rowid.
• GET_PK_FOR_VALIDATION — Validates the composite primary key (UCAS program code, institute, UCAS campus, option code, and system code) and returns the primary key value used by the API's validation logic.
• GET_FK_IGS_UC_CRSE_DETS — The foreign-key resolution function. It returns the corresponding key from the parent IGS_UC_CRSE_DETS (course details) entity for a given course vacancy/options row, enabling the API to enforce and expose the parent-child relationship between course details and their vacancy options.
• BEFORE_DML — The trigger-support routine invoked before INSERT, UPDATE, or DELETE to populate WHO columns (creation/update audit fields) and enforce standard row-level DML defaults.

Tables Accessed

The documented table reference is IGS_UC_CRSE_VAC_OPS, accessed through an APPS synonym. All insert, update, delete, lock, and validation operations in the package target this table, whose business key is the composite of UCAS program code, institute, UCAS campus, option code, and system code. The GET_FK_IGS_UC_CRSE_DETS function additionally resolves the foreign key toward the IGS_UC_CRSE_DETS parent entity, reflecting the referential relationship between course detail records and their associated vacancy/option records.

Usage Notes

The package is typically invoked from the Oracle Forms-based UCAS data entry and maintenance screens for course vacancy options, where ADD_ROW, UPDATE_ROW, and DELETE_ROW back the block-level DML, LOCK_ROW supports record locking on query, and BEFORE_DML fires from the table's database trigger. The GET_PK_FOR_VALIDATION and GET_FK_IGS_UC_CRSE_DETS functions are exposed for declarative and programmatic validation in custom extensions, concurrent programs, and inbound UCAS interface loads. ETRM records that the package is referenced by one other package, indicating a modest dependency footprint. Because it is an OTHER-classified API with no published interface guarantee, customizations should call the routines rather than manipulating IGS_UC_CRSE_VAC_OPS directly, and should observe the documented defaults for the mode and system code parameters.