Results for “igs_ps_ref_cd_mandatory”

8 results




Overview
Explore in AI Chat

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

Overview

The APPS.IGS_PS_UNIT_REF_CD_PKG package body is a table-handler API within the Oracle E-Business Suite Student Systems product family, specifically the Institution of Higher Education (IGS) schema supporting the Oracle Student System. It encapsulates the DML logic for the IGS_PS_UNIT_REF_CD entity, which stores reference-code assignments for program/unit version records — the flexible key and descriptive attribute values that qualify a unit version (for example, awarding-body codes, delivery-mode codes, or mandatory reference-code indicators flagged through reference-code types such as the search term igs_ps_ref_cd_mandatory). The package centralises row-level validation, primary/foreign/unique key verification, constraint checking, and auditing column population so that Oracle Forms and other clients do not write directly against the base table.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new reference-code row into IGS_PS_UNIT_REF_CD after invoking BEFORE_DML and constraint checks.
  • UPDATE_ROW — Updates an existing row identified by ROWID, preserving audit columns such as CREATION_DATE and CREATED_BY from the old reference record.
  • ADD_ROW — Performs the combined insert/update logic used by the Forms block; branches on the current block status.
  • DELETE_ROW — Deletes a row and raises the standard FORM_RECORD_DELETED message if the target no longer exists.
  • LOCK_ROW — Issues a SELECT ... FOR UPDATE concurrency lock using the cached l_rowid.
  • GET_PK_FOR_VALIDATION — Retrieves the primary-key combination for validation at runtime.
  • GET_UK_FOR_VALIDATION — Retrieves the unique-key combination used for duplicate detection.
  • GET_FK_IGS_GE_REF_CD_TYPE and GET_UFK_IGS_GE_REF_CD — Resolve foreign/unique relationships against the reference-code type table, driving the reference-code type and value validation.
  • GET_FK_IGS_PS_UNIT_VER — Validates the parent unit version FK (UNIT_CD, VERSION_NUMBER).
  • CHECK_CONSTRAINTS — Executes the aggregate mandatory, FK, and check validations before DML.
  • BEFORE_DML — Populates audit and derived columns prior to insert or update.

Tables Accessed

  • IGS_PS_UNIT_REF_CD — The driving base table; source of old/new reference records.
  • IGS_GE_REF_CD_TYPE_ALL — Provides reference-code type definitions used for FK and unique-key validation.
  • DUAL — Utilised for generic single-row lookups and validation queries.

Usage Notes

The package is invoked from the Oracle Forms UI for the Reference Codes block, from concurrent programs performing bulk data loads, and from custom PL/SQL that must respect institutional validation while populating unit reference-code data. Because the ETRM classification is OTHER, callers should invoke procedures rather than raw DML to retain audit-column population, concurrency locking, and message-stack error handling. With 5 dependent packages, it is a stable architectural dependency in the IGS API tier, and any extension should wrap rather than duplicate its constraint logic. The header stamp IGSPI88B.pls 115.10 indicates maintenance through the 11.5.x code line (2003), consistent with the 12.1.1 metadata.