Search Results igs_ps_govt_dscp_pkg

Overview

IGS_PS_GOVT_DSCP_PKG is a PL/SQL package owned by the APPS schema that forms part of the Oracle Student System (also known as Oracle iGS or the Higher Education product family) within Oracle E-Business Suite. Its name derives from "PS" (Post-Secondary / Student System), "GOVT" (government), and "DSCP" (discipline or discipline code), and it operates against the IGS_PS_GOVT_DSCP table. The package encapsulates the standard Oracle Forms–generated DML logic and validation rules required to maintain government-defined discipline classification records — data that higher-education institutions use to tag programs and offerings with statutory discipline codes for government reporting, funding, and compliance purposes. ETRM classifies the package as an "OTHER" API, indicating that it is not a formally published business API but rather a supporting, table-maintenance package typically invoked by the Oracle Forms user interface and by other iGS packages. Under both 12.1.1 and 12.2.2 the object is reported with VALID status in the APPS schema, albeit the ETRM excerpt shows only the header skeleton ("[Package]" and "[Package Body]" placeholders) without inline source. The package has eight documented procedures and is referenced by two other packages, confirming its role as a shared, low-level component in the Student System code stack.

Key Procedures and Functions

The package exposes a conventional Forms-style DML surface. The documented procedures are:

• INSERT_ROW — Inserts a new government discipline record into IGS_PS_GOVT_DSCP, populating the WHO columns and applying the package's defaulting and validation logic.
• LOCK_ROW — Acquires a row-level lock on the target record, typically issuing a SELECT ... FOR UPDATE, so that subsequent UPDATE_ROW or DELETE_ROW calls operate on a consistent, uncontested row.
• UPDATE_ROW — Applies changes to an existing government discipline record, re-validating the modified attributes and refreshing the WHO audit columns.
• DELETE_ROW — Physically removes a government discipline record from the base table, subject to any referential or business-rule checks enforced by the package.
• ADD_ROW — The Forms "create record" entry point, which performs pre-insert initialisation (defaults, sequence handling, mandatory attribute setup) before delegating to the insert logic.
• GET_PK_FOR_VALIDATION — A helper used by the validation framework to obtain the primary key of the record being validated, so that validation queries can exclude or include the current row correctly.
• CHECK_CONSTRAINTS — Enforces the package's declarative and business constraints against the current record, raising the standard Forms error when a rule is violated.
• BEFORE_DML — A pre-DML hook invoked ahead of INSERT_ROW, UPDATE_ROW, or DELETE_ROW to perform shared preparatory work such as key derivation, date stamping, and consistency checks.

No parameter signatures are documented in the ETRM extract, so only the behavioural roles above should be relied upon.

Tables Accessed

The single documented base object is IGS_PS_GOVT_DSCP, accessed through its APPS synonym. This table stores government discipline classification codes and their associated descriptive attributes. All eight procedures ultimately read from or write to this table: LOCK_ROW and GET_PK_FOR_VALIDATION read it, INSERT_ROW and ADD_ROW insert into it, UPDATE_ROW modifies it, DELETE_ROW removes rows, and CHECK_CONSTRAINTS and BEFORE_DML query it to validate referential integrity and maintain audit metadata. The ETRM dependency list also shows a dependency on SYS.STANDARD, which is the implicit PL/SQL package providing base language types and is present in every compiled package; this is not a business-table dependency.

Usage Notes

Because IGS_PS_GOVT_DSCP_PKG is an "OTHER"-classified package rather than a published API, it is normally invoked indirectly. Oracle Forms screens that maintain government discipline classifications call INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW through the standard Forms block triggers, with BEFORE_DML, CHECK_CONSTRAINTS, ADD_ROW, and GET_PK_FOR_VALIDATION firing at the corresponding trigger points. It is also referenced by IGS_FI_GV_DSP_HEC_CN_PKG and IGS_PS_DSCP_PKG, both of which build higher-level HEC (Higher Education Council) and discipline-processing logic on top of the low-level maintenance routines documented here; IGS_PS_DSCP_PKG in particular is listed among its own referencers, indicating internal recursion or self-referencing validation. Customisation and extension developers should treat the package as internal implementation detail: direct calls are possible from custom PL/SQL, but Oracle does not guarantee signature stability across patches or upgrades, so integrations should prefer supported iGS public APIs and concurrent programs wherever available. When debugging government discipline data issues in 12.1.1 or 12.2.2, this package and its base table are the correct starting point for tracing how a row was inserted, validated, or removed.