Search Results update_rejection_status

Overview

IGW_WORKFLOW is a PL/SQL package body owned by APPS in Oracle E-Business Suite 12.1.1 and 12.2.2. It implements the server-side workflow logic for the Oracle Grants/Projects proposal approval cycle, which is built on the Oracle Workflow engine (WF). The package is classified under the ETRM API classification OTHER, meaning it is not a published open interface but a supporting internal package invoked by workflow activity functions and by other Grants packages. The package header (igwwfrob.pls, version 120.7) defines the callable entry points that the workflow definition for proposal approval maps to when a notification is routed to an approver, when a role must be expired, and when approval or rejection status must be written back to the proposal mapping tables. The package does not perform the approval itself; instead, it supplies the decision logic that the workflow engine invokes at each node of the approval process.

Key Procedures and Functions

• START_WORKFLOW — Initiates the approval workflow for a given proposal and run. It is the entry point that launches the workflow process associated with a proposal submission.
• SELECT_PERSONS_TO_NOTIFY — Resolves the workflow roles that must be notified for a proposal run. Its internal cursor reads distinct role names from the proposal map and map stop tables, filtered by run, map type 'N', and stops not yet submitted.
• SELECT_APPROVER — Selects the approver or approver role to whom the current notification is routed during the approval chain.
• DISABLE_REASSIGN — Determines whether the reassignment (delegation) capability should be disabled for the current workflow item, typically when the user is not permitted to forward the approval.
• UPDATE_APPROVAL_STATUS — Writes the approval result back for a proposal run, synchronizing the workflow outcome with the Grants proposal mapping data.
• UPDATE_REJECTION_STATUS — Records rejection outcomes for the proposal approval path.
• LAST_APPROVER — Identifies the final approver in the approval hierarchy or chain, supporting the determination of completion for the proposal approval process.

Tables Accessed

Through APPS synonyms, IGW_WORKFLOW reads and writes the following documented tables:

• IGW_PROP_MAPS — The proposal map header table, storing the mapping of a proposal approval run and its map type; read during person/role selection.
• IGW_PROP_MAP_STOPS — The proposal map stop detail table, holding the sequence of approval stops and submission dates; joined to IGW_PROP_MAPS to determine which roles remain to be notified.
• WF_NOTIFICATIONS — The Oracle Workflow notification table, used to track and route the approval notifications raised for each approver.
• WF_NOTIFICATION_ATTRIBUTES — The notification attribute table, used to store and retrieve contextual attributes attached to each approval notification.

Usage Notes

IGW_WORKFLOW is not invoked directly by end users or through standard Oracle Forms. It is called by the Oracle Workflow engine when the proposal approval workflow definition executes the activity functions that reference each procedure. Because the routines carry the standard workflow signature (itemtype, itemkey, actid, funcmode, and an OUT result), they are configured as workflow function activities rather than as a typical PL/SQL API. The package is referenced by two other packages within the Grants schema, indicating use from additional Grants approval entry points. Customizations should avoid modifying this package body; instead, extensions to approval logic should be implemented through the workflow definition or through customer-owned wrapper packages to preserve upgrade compatibility across 12.1.1 and 12.2.2.