Search Results get_fk_igs_ca_da_inst

Overview

IGS_CA_DA_INST_PAIR_PKG is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an OTHER API within the ETRM repository. It supports the Oracle Student System (formerly Oracle iLearning/Student Systems) calendar and delivery administration components, specifically managing records in the IGS_CA_DA_INST_PAIR table. That table holds pairings between date alias instances, recording relationships between a primary date alias instance and a related date alias instance, each qualified by calendar type, calendar instance sequence number, date alias, and date alias instance sequence number. The package follows the standard Oracle Forms-generated table handler pattern, declaring AUTHID CURRENT_USER and exposing a set of DML procedures, validation functions, and constraint-checking utilities that enforce referential integrity and uniqueness for the underlying entity. Because it is a generated handler, its principal purpose is to service the Oracle Forms UI layer that maintains delivery instance pairings, while still being callable from custom PL/SQL when inbound interfaces must populate or verify the same data.

Key Procedures and Functions

• INSERT_ROW — Inserts a new date alias instance pair row, accepting both the primary and related date alias instance identifiers plus a mode flag defaulting to 'R'. It returns the ROWID of the newly created record.
• LOCK_ROW — Obtains a row-level lock for the identified pairing to support pessimistic locking semantics during form-based updates.
• DELETE_ROW — Removes a pairing row identified by ROWID.
• GET_PK_FOR_VALIDATION — Returns a BOOLEAN indicating whether a complete set of primary and related key values resolves to an existing row, used for primary key validation.
• GET_UK_FOR_VALIDATION — Returns a BOOLEAN validating the unique key composed of the primary date alias instance attributes, ensuring no duplicate pairing exists.
• GET_FK_IGS_CA_DA_INST — The foreign key validation routine referenced by the search term "get_fk_igs_ca_da_inst". It verifies that the supplied date alias instance key values exist in the parent IGS_CA_DA_INST table, thereby enforcing the parent-child relationship before a pairing is written.
• CHECK_CONSTRAINTS — Validates column-level constraints, optionally scoped to a named column and value.
• BEFORE_DML — Central pre-DML hook that performs cross-field validation and prepares values before insert, update, or delete operations.

Tables Accessed

The documented base object is IGS_CA_DA_INST_PAIR, accessed through the APPS synonym. This is the package's primary read/write target: INSERT_ROW, DELETE_ROW, LOCK_ROW, and the validation functions all operate against it. The GET_FK_IGS_CA_DA_INST routine additionally validates against the parent date alias instance table, IGS_CA_DA_INST, consistent with its naming and referential purpose. Two other packages reference IGS_CA_DA_INST_PAIR_PKG, indicating the table and handler participate in a wider dependency chain within the calendar administration module.

Usage Notes

This package is typically invoked from the Oracle Forms application that maintains calendar and delivery date alias instance pairings, where the generated handler enforces locking, uniqueness, and foreign key checks transparently as users insert or modify records. It can also be called from custom PL/SQL or interface programs that load pairing data, provided the calling code supplies valid parent references so that GET_FK_IGS_CA_DA_INST succeeds. The header identifies the source as IGSCI07S.pls (version 115.3), reflecting its origin as a generated Forms table handler. Because the object is an OTHER-class API rather than a formally supported public API, modifications and direct calls should be undertaken with care. The GET_FK_IGS_CA_DA_INST procedure is the correct entry point whenever an application or script must confirm that a proposed related date alias instance exists before persisting a pairing row, and it is the specific routine users should reference when troubleshooting referential constraint errors on IGS_CA_DA_INST_PAIR.