Search Results get_fk_igs_ps_usec_occurs

Overview

The APPS.IGS_PS_USO_INSTRCTRS_PKG package is a component of the Oracle Student System (the IGS schema prefix denotes the "Integrated Student" family of modules delivered with Oracle E-Business Suite). It provides the canonical PL/SQL application programmatic interface (API) for maintaining the IGS_PS_USO_INSTRCTRS entity, which records the assignment of instructors to unit section occurrences. A unit section occurrence is the scheduled delivery of a course unit offering; the instructor record links that delivery to the individual (party) who teaches it. The package is declared AUTHID CURRENT_USER, so its unqualified references to tables resolve through the APPS synonyms in the caller's schema, which is the standard convention for EBS-supplied table-handler APIs. It was shipped at version 115.3 and is documented under ETRM 12.1.1 with an API classification of OTHER, indicating a generated table handler rather than a business-level API.

Key Procedures and Functions

• INSERT_ROW — inserts a new instructor assignment row, returning the generated ROWID and primary key through NOCOPY OUT parameters.
• LOCK_ROW — acquires a row-level lock on an existing assignment to support optimistic concurrency in a form.
• UPDATE_ROW — updates the mutable columns of an existing instructor assignment identified by ROWID.
• ADD_ROW — a combined insert-or-add entry point that returns the ROWID and primary key after creation.
• DELETE_ROW — deletes the assignment row identified by ROWID.
• GET_PK_FOR_VALIDATION — returns a Boolean indicating whether the supplied primary key (uso_instructor_id) exists.
• GET_UK_FOR_Validation — returns a Boolean indicating whether the unique combination of unit section occurrence and instructor already exists, preventing duplicates.
• GET_FK_IGS_PS_USEC_OCCURS — validates that the referenced unit section occurrence exists.
• GET_FK_HZ_PARTIES — validates that the party referenced as the instructor exists in the TCA registry. This is the procedure matched by the user's search term, and is the foreign-key check invoked before an instructor assignment may be persisted.
• BEFORE_DML — the central pre-DML hook that enforces WHO-column auditing, applies defaults, and performs validation for all insert, update, and delete actions.

Tables Accessed

• IGS_PS_USO_INSTRCTRS — the base table holding instructor-to-occurrence assignments; the primary subject of all DML.
• IGS_PS_USO_INSTRCTRS_S — the corresponding sequence used to populate the surrogate primary key.
• HZ_PARTIES — the TCA Trading Community Architecture party table, consulted by GET_FK_HZ_PARTIES to confirm the instructor is a registered party.
• DUAL — used for scalar lookups and sequence-style select constructs.

Usage Notes

Because this is a generated table handler, it is typically invoked from the Oracle Forms UI that maintains unit section occurrence instructor details, where LOCK_ROW, UPDATE_ROW, and DELETE_ROW back the standard form DML triggers, and BEFORE_DML is called from the block-level pre-insert/pre-update/pre-delete triggers. The GET_FK_HZ_PARTIES and GET_FK_IGS_PS_USEC_OCCURS validation routines are called during data entry to reject assignments whose instructor party or occurrence does not exist. The package is referenced by four other packages, which either call BEFORE_DML or reuse its validation functions. Custom code should call these procedures rather than manipulate IGS_PS_USO_INSTRCTRS directly, so that WHO-column auditing and referential integrity to HZ_PARTIES are preserved. No business-event subscriptions or concurrent program drivers are documented for this object.