Search Results get_fk_igs_gr_crmn_round

Overview

IGS_GR_CRM_ROUND_PRD_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM repository as an "OTHER" API. It belongs to the Student System / Graduation Management functional area, as indicated by the IGS_GR naming prefix, which denotes Graduation (GR) components within the Oracle iGS (Integrated Graduate System) module family. The package encapsulates the table-handling logic for the IGS_GR_CRM_ROUND_PRD entity, which stores the relationship between graduation round definitions and the completion periods (years and periods) associated with those rounds. Its primary role is to provide a consistent, encapsulated interface for creating, maintaining, validating, and deleting records in this relationship table, shielding callers from direct DML and enforcing the row-level locking and foreign-key referential integrity rules that the Graduation forms and concurrent processes rely upon.

Key Procedures and Functions

The package exposes seven documented program units corresponding to a standard Oracle Forms-generated table handler:

• INSERT_ROW — Inserts a new row into IGS_GR_CRM_ROUND_PRD, accepting the graduation calendar type, calendar instance sequence number, completion year, and completion period, and returning the generated ROWID.
• LOCK_ROW — Acquires a row-level lock on an existing record keyed by ROWID and the primary key columns, preventing concurrent modification during an update or delete.
• DELETE_ROW — Deletes the identified row from the table by ROWID.
• GET_PK_FOR_VALIDATION — A boolean function that validates the existence of the primary key combination (calendar type, instance sequence number, completion year, and period) before a DML operation is attempted.
• GET_FK_IGS_GR_CRMN_ROUND — Enforces the foreign-key relationship to the parent graduation round entity (IGS_GR_CRMN_ROUND), validating that the referenced round exists for the supplied calendar type and calendar instance sequence number. This is the program unit referenced in the user's search term.
• CHECK_CONSTRAINTS — Validates column-level constraints, optionally scoped to a specific column name and value.
• BEFORE_DML — A central pre-DML hook that performs cross-cutting validations, derives audit columns, and orchestrates the appropriate key and constraint checks prior to insert, update, or delete.

Tables Accessed

The package operates against a single documented table, referenced through an APPS synonym: IGS_GR_CRM_ROUND_PRD. This table is the persistence target for all INSERT_ROW, LOCK_ROW, and DELETE_ROW activity, and the source for GET_PK_FOR_VALIDATION and CHECK_CONSTRAINTS queries. The GET_FK_IGS_GR_CRMN_ROUND procedure validates against the parent round table (IGS_GR_CRMN_ROUND) to confirm referential integrity before a dependent record is written. No other tables are documented in the ETRM metadata for this package.

Usage Notes

This package is a Forms-generated table handler, meaning it is typically invoked by the Oracle Forms user interface layer when a user creates or maintains graduation round completion-period records. It is not normally called directly from SQL*Plus or ad-hoc scripts. The documented reference from one other package confirms that at least one additional iGS Graduation package depends on its key-validation or foreign-key logic. Customizations should respect the package's contract: call BEFORE_DML for validation, use GET_FK_IGS_GR_CRMN_ROUND to verify parent round existence, and rely on INSERT_ROW, LOCK_ROW, and DELETE_ROW rather than issuing direct DML against IGS_GR_CRM_ROUND_PRD. The package header dates to release 12.0 and remains valid across EBS 12.1.1 and 12.2.2, as its implementation is unaffected by the Online Patching editioning model changes.