Search Results get_fk_igs_ps_unit

Overview

IGS_PS_UNIT_RU_PKG is a table-handler API package in the Oracle EBS Student Systems (IGS) product family, owned by the APPS schema and declared with AUTHID CURRENT_USER. It encapsulates the DML and validation logic for the IGS_PS_UNIT_RU entity, which associates a unit (course) definition with a rule-call construct — specifically the combination of a unit code, a system rule-call code, and a rule sequence number. In the Oracle Student System data model, such unit-to-rule relationships underpin enrollment, eligibility, and curriculum rules that drive whether a student may register for or continue in a given unit.

The package follows the standard Oracle Forms-generated table-handler pattern, providing the canonical INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW, and ADD_ROW entry points, together with secondary validation procedures (GET_FK_* and CHECK_CONSTRAINTS) and a central Before_DML trigger procedure. It is classified under ETRM as OTHER, i.e., a documented internal API rather than a public, customer-facing interface. The 12.1.1 documentation identifies the same eleven procedures carried forward into 12.2.2.

Key Procedures and Functions

• INSERT_ROW — Inserts a new IGS_PS_UNIT_RU row, returning the ROWID and accepting the unit code, rule-call code, and rule sequence number plus an optional mode flag.
• LOCK_ROW — Issues a locking read against the identified row, used by Forms to detect concurrent modification before an update.
• UPDATE_ROW — Updates the row identified by ROWID, applying the same key columns as insert.
• ADD_ROW — Attempts an update and falls back to insert, supporting Forms' commit-time row processing.
• DELETE_ROW — Removes the row for the supplied ROWID.
• GET_PK_FOR_VALIDATION — Boolean function validating that the primary key (unit code plus rule-call code) exists in the table.
• GET_FK_IGS_RU_CALL — Validates the rule-call code against the IGS_RU_CALL reference table.
• GET_FK_IGS_PS_UNIT — Validates the unit code against the IGS_PS_UNIT table. This is the routine referenced by the search term "get_fk_igs_ps_unit," confirming this object as the source of that foreign-key check.
• GET_FK_IGS_RU_RULE — Validates the rule sequence number against IGS_RU_RULE.
• CHECK_CONSTRAINTS — Generic constraint-checking routine taking a column name and value.
• BEFORE_DML — Central pre-DML hook that normalises who-columns (creation/update dates, user IDs, login IDs) and invokes the appropriate validation before insert, update, or delete.

Tables Accessed

The package primarily reads and writes IGS_PS_UNIT_RU via the APPS synonym — this is the sole documented table for the DML operations and holds the unit/rule-call/sequence relationship. The GET_FK_* routines imply read-only lookups against IGS_RU_CALL, IGS_PS_UNIT, and IGS_RU_RULE for foreign-key validation, though only IGS_PS_UNIT_RU is formally listed in the ETRM table metadata. Because it uses AUTHID CURRENT_USER, privilege resolution depends on the invoking schema's grants on the underlying objects.

Usage Notes

IGS_PS_UNIT_RU_PKG is invoked from the Oracle Forms-based Unit/Rule maintenance screens in the Student System, and is referenced by four other packages within the IGS schema set (notably the unit and rule-call APIs that need cross-entity validation). Custom extensions should call ADD_ROW or the GET_FK_* validators rather than issuing direct DML, so that the Before_DML who-column and constraint logic is preserved. Because the package is 12.1.1/12.2.2-era generated code with a 2002 header, it should be treated as stable but non-extensible; overlays belong in a custom package that delegates to it. Direct invocation from concurrent programs or ad hoc SQL is not recommended without replicating the Before_DML sequence.