Search Results raise_approval_event

Overview

The APPS.FUN_NET_APPROVAL_WF package body supports the Oracle Netting workflow within Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary responsibility is to raise the business event oracle.apps.fun.netting.batchApproval when a netting batch is submitted for approval, and to manage the associated workflow callbacks and status transitions for batch approval processing. The package bridges the Oracle Netting module (FUN) and the Oracle Workflow / Business Event subsystem, enabling batch approvers to act on netting batches and the system to advance or reject batches based on approval outcomes.

Key Procedures and Functions

• RAISE_APPROVAL_EVENT — Raises the oracle.apps.fun.netting.batchApproval business event for a given batch. It builds a workflow parameter list containing BATCH_ID and calls wf_event.Raise3 to publish the event. This is the entry point that initiates the approval workflow when a batch requires approval.
• INITIALIZE — A standard Workflow Function activity callback used to initialize the workflow process for a batch. It retrieves batch details through a cursor on fun_net_batches_all and sets the workflow result, typically returning a status that governs the subsequent workflow branching.
• VALIDATE_SETTLE_BATCH — Validates whether a batch is eligible for settlement. It is invoked as part of the approval workflow to confirm that the batch can proceed through settlement; the result governs whether the workflow continues or halts.
• GET_NORESPONSE_ACTION — Determines the action to take when an approver does not respond within a defined period. It supports timeout handling in the approval workflow.
• UPDATE_BATCH_STATUS_REJ — Updates the batch status to a rejected state, typically invoked when an approver rejects the batch or the workflow terminates unfavourably.
• UPDATE_BATCH_STATUS_ERR — Updates the batch status to an error state, invoked when the workflow or validation encounters an error condition.

Tables Accessed

• FUN_NET_BATCHES_ALL — The primary netting batch table. Read by INITIALIZE and other procedures to obtain batch attributes, and written to by the status update procedures (UPDATE_BATCH_STATUS_REJ and UPDATE_BATCH_STATUS_ERR) to reflect approval outcomes.
• FUN_NET_AGREEMENTS_ALL — Referenced for agreement-level context associated with batches, supporting validation of batch settlement eligibility.
• FND_USER — Used to resolve approver identity and response information.
• WF_PARAMETER_LIST_T — The workflow parameter list type populated with BATCH_ID when raising the approval event.
• PLITBLM — Standard Oracle-supplied PL/SQL table/index-by type used internally.

Usage Notes

This package is invoked indirectly through the Oracle Netting approval workflow rather than being called directly by end users. The RAISE_APPROVAL_EVENT procedure is triggered when a batch is submitted for approval, causing the business event to fire and the workflow to start. The remaining procedures are registered as Workflow Function activities and are called by the Workflow Engine as the approval process progresses. Because the package is documented in ETRM with a classification of OTHER and is referenced by one other package, customizations should avoid direct invocation and instead integrate through the standard business event or workflow infrastructure. Any modification of batch statuses must respect the constraints enforced by the Oracle Netting module to preserve data integrity.