Search Results before_insert_update

Overview

The APPS.IGS_PS_FAC_ASG_TASK_PKG package body is a generated table-handler API belonging to the Oracle E-Business Suite Student Systems (IGS) product family. It encapsulates the fundamental DML operations for the IGS_PS_FAC_ASG_TASK entity, which stores faculty assignment task records — the association between a faculty workload identifier and the task types that faculty member is expected to perform. In the Oracle EBS 12.1.1 and 12.2.2 environments, this package is classified under the API classification OTHER, indicating it is an internal supporting API rather than a public, supported integration interface.

The source header identifies the object as IGSPI3HB.pls version 115.5, dated 05-JUN-2003, authored initially by kkillams on 17-JAN-2002. This establishes the package as part of the original IGS foundation layer that has remained stable across releases. The package follows the standard Oracle Forms-generated table-handler pattern: it maintains package-level old_references and new_references records based on the IGS_PS_FAC_ASG_TASK%ROWTYPE, and uses a set_column_values helper to initialise these before each DML operation.

Key Procedures and Functions

Eight documented procedures and functions comprise the API surface:

• INSERT_ROW — Inserts a new faculty assignment task record into the base table, applying WHO columns and validating the new row before commit.
• UPDATE_ROW — Updates an existing record identified by ROWID, refreshing both old and new reference caches.
• DELETE_ROW — Removes a record from the base table after verifying existence.
• LOCK_ROW — Issues a SELECT ... FOR UPDATE against the supplied ROWID to obtain a row-level lock for concurrency control.
• ADD_ROW — Convenience wrapper that performs the combined add path, typically delegating to INSERT_ROW.
• GET_PK_FOR_VALIDATION — Returns the primary key of the entity so that dependent validation logic can be executed against it.
• GET_FK_IGS_PS_FAC_WL — Confirms the foreign key relationship to the parent faculty workload entity, ensuring referential integrity before DML.
• BEFORE_DML — A shared pre-processing hook invoked prior to every insert, update, or delete to enforce business rules and column defaults. This is the routine most closely related to the user search term before_insert_update, since it encapsulates the pre-insert and pre-update logic that generated Forms table handlers publish.

Tables Accessed

The package reads and writes IGS_PS_FAC_ASG_TASK (via the APPS synonym), the entity's base table, using a cursor cur_old_ref_values to fetch the current row for ROWID-based operations. It also consults IGS_PS_FAC_TASK_TYP, the lookup table of valid faculty task type codes, to validate the faculty_task_type column. The primary key is the fac_wl_id sequence, which links each task assignment to its parent faculty workload record.

Usage Notes

Because this is a generated table handler, it is normally invoked indirectly by the Oracle Forms UI (the Faculty Assignment maintenance form) and by two referencing packages within the IGS schema, rather than called directly by end users. The BEFORE_DML routine executes automatically within each DML operation, so customisations that must run before insert or update should be applied to that shared procedure rather than to INSERT_ROW and UPDATE_ROW individually. Direct calls from custom PL/SQL should supply the ROWID obtained from a prior LOCK_ROW, and callers must be prepared to handle app_exception raised when the target row has been deleted by another session.