Search Results igs_ps_dscp_pkg




Overview
Explore in AI Chat

Overview

IGS_PS_DSCP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Higher Education (Student System / IGS) product family. Its name follows the IGS convention: "PS" denotes the Person/Student and Program/Study areas, while "DSCP" abbreviates "Discipline." The package therefore underpins the maintenance of the IGS_PS_DSCP_ALL entity, which stores discipline records associated with academic programs and government reporting structures. The package is classified as OTHER under the ETRM API classification, indicating that it is a supporting data-maintenance package rather than a formal public API. It encapsulates the low-level DML, validation, and constraint-enforcement logic that surrounds the discipline table, and it is referenced by five sibling packages — IGS_AD_TER_ED_UNI_AT_PKG, IGS_PS_GOVT_DSCP_PKG, IGS_PS_UNIT_DSCP_PKG, IGS_PS_UNIT_LGCY_PKG, and IGS_PS_UNT_DSCP_HIST_PKG — reflecting its role as a shared utility for discipline processing across admissions, government reporting, unit, and history modules.

Key Procedures and Functions

The ETRM metadata documents nine callable units within the package, of which six are entry points and three are supporting validation/constraint routines.

  • INSERT_ROW — Inserts a new discipline row into the underlying table, applying the package's defaulting logic.
  • LOCK_ROW — Acquires a row-level lock on an existing discipline record, preventing lost updates during concurrent edits.
  • UPDATE_ROW — Modifies an existing discipline record, typically after LOCK_ROW has secured the row.
  • ADD_ROW — A higher-level convenience routine that combines validation with an insert into the discipline entity.
  • DELETE_ROW — Removes a discipline record, subject to referential checks against dependent packages.
  • GET_PK_FOR_VALIDATION — Returns the primary key of the discipline table so that foreign-key and cross-entity validations can be performed by calling packages.
  • GET_FK_IGS_PS_GOVT_DSCP — Resolves and validates the foreign key that links a discipline to the IGS_PS_GOVT_DSCP government discipline structure.
  • CHECK_CONSTRAINTS — Enforces business and integrity constraints before a DML operation is committed.
  • BEFORE_DML — A trigger-support routine that fires prior to insert, update, or delete to populate WHO columns, defaults, and audit attributes.

Tables Accessed

The package reads and writes IGS_PS_DSCP_ALL via its APPS synonym. INSERT_ROW, ADD_ROW, UPDATE_ROW, and DELETE_ROW operate directly on this table, while CHECK_CONSTRAINTS and the GET_FK/GET_PK routines query it to validate primary and foreign key values before DML. The _ALL suffix confirms the table is a multi-organization (multiple-org) or language-enabled entity, which explains the presence of BEFORE_DML logic to populate organizational and WHO audit columns.

Usage Notes

Because the package is an OTHER-classified API, it is not intended for direct customer invocation. It is typically called internally: by the IGS discipline maintenance forms (through the standard DML trigger pattern built on BEFORE_DML, CHECK_CONSTRAINTS, and the row-level routines), and by the five dependent packages listed in the ETRM dependency report. The government-discipline routine (GET_FK_IGS_PS_GOVT_DSCP) is consumed by IGS_PS_GOVT_DSCP_PKG, while unit and history packages (IGS_PS_UNIT_DSCP_PKG, IGS_PS_UNT_DSCP_HIST_PKG, IGS_PS_UNIT_LGCY_PKG) rely on it for cross-entity consistency. Custom extensions should call the documented procedures rather than issuing raw SQL against IGS_PS_DSCP_ALL, ensuring constraint enforcement and audit-column population remain consistent. There are no documented execution prerequisites beyond a valid APPS session and the standard IGS/Student System product installation.