Search Results igs_ps_fac_asg_task_pkg

Overview

IGS_PS_FAC_ASG_TASK_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (E-Business Suite Technical Reference Manual) as an OTHER-type API. As its name indicates, the package belongs to the Student Systems (IGS) product family, specifically the Academic Planning and Scheduling (PS) module concerned with faculty assignment tasks. Its business purpose is to encapsulate the data manipulation logic that maintains the relationship between a faculty assignment and the individual tasks that the assigned faculty member is expected to perform. Rather than allowing forms or other callers to issue direct DML against the underlying faculty assignment task entity, this package centralises insert, update, delete, validation, and concurrency handling behind a stable procedural interface. In release 12.1.1 the object is documented as VALID, with eight documented procedures and functions, and it is referenced by two other packages in the same module, indicating that it acts as a shared low-level utility for faculty workload and task processing rather than as a top-level user-facing API.

Key Procedures and Functions

The package exposes eight documented procedures and functions, covering the standard table-handler pattern used widely throughout the IGS schemas:

• INSERT_ROW — Creates a new faculty assignment task record. It performs the base insertion of a row into the underlying entity.
• LOCK_ROW — Acquires a row-level lock on an existing faculty assignment task record, providing the concurrency control needed before an update or delete.
• UPDATE_ROW — Modifies an existing faculty assignment task record that has already been locked.
• ADD_ROW — Combines the lock-if-exists, insert-or-update semantics typical of the IGS table handlers, allowing a caller to add a task row without first determining whether it already exists.
• DELETE_ROW — Removes a faculty assignment task record.
• GET_PK_FOR_VALIDATION — Returns the primary key of the faculty assignment task record so that a calling process or form can validate the entity before proceeding with further processing.
• GET_FK_IGS_PS_FAC_WL — Retrieves the foreign key that links the faculty assignment task to the parent faculty workload record, supporting referential integrity and navigation between the two entities.
• BEFORE_DML — A pre-DML hook that applies standard column defaulting, WHO-column population, and other mandatory derivations before any insert or update is committed.

Because the ETRM documentation does not publish parameter signatures for these units, callers should obtain the exact argument lists from the package specification in the database rather than inferring them.

Tables Accessed

The package operates against two documented tables, reached through APPS synonyms:

• IGS_PS_FAC_ASG_TASK — The primary entity table holding faculty assignment task records. All insert, update, delete, lock, and primary-key retrieval operations target this table.
• IGS_PS_FAC_TASK_TYP — The faculty task type reference table, consulted to validate or resolve the type of task associated with a faculty assignment.

The package does not directly reference the faculty workload table documented as the source of the GET_FK_IGS_PS_FAC_WL foreign key, but the foreign key value it returns links back to that parent entity.

Usage Notes

This package is a lower-level utility invoked indirectly rather than a top-level integration point. According to the ETRM dependency listing, it is referenced by IGS_PS_FAC_WL_PKG (the faculty workload package) and IGS_PS_RLOVR_FAC_TSK (the faculty task rollover package), and it also references itself internally. Typical invocation therefore occurs when a faculty workload or faculty task rollover process manipulates assignment task data on behalf of a user-facing Oracle Forms session, a concurrent program, or custom extension code. Developers writing custom PL/SQL against the faculty assignment task entity should call these procedures rather than issuing direct INSERT, UPDATE, or DELETE statements, so that the BEFORE_DML defaulting, LOCK_ROW concurrency, and validation logic are consistently applied. Because the package resides in APPS and depends only on SYS.STANDARD, it is portable across both 12.1.1 and 12.2.2 environments, and its status remains VALID in the documented release.