Search Results fch_check_approvals




Overview
Explore in AI Chat

Overview

APPS.GCS_ADJ_APPROVAL_WF_PKG is the workflow integration package responsible for driving the approval cycle of adjustments in the Oracle E-Business Suite Financial Consolidation Hub / Global Consolidation System (GCS). Consolidation adjustments captured as GCS entry headers frequently require review and sign-off before they are posted to a consolidation ledger. This package bridges the GCS adjustment entry data model and the Oracle Workflow engine, instantiating the GCSADJ item type, resolving the next eligible approver, evaluating approval outcomes, and writing the final status back to the adjustment record. It is classified in the ETRM repository as an OTHER API rather than a formally published public API, which indicates that it is intended for internal use by the workflow engine and by the GCS application forms rather than for direct customer invocation.

Key Procedures and Functions

  • create_gcsadj_process — Initiates the approval workflow for an adjustment. It receives the entry identifier, the requesting user, the originating entry, ledger, calendar period, conversion type, and writeback flag, and returns the generated workflow item key used to track the approval instance.
  • Get_Next_Approver — A workflow function activity that determines the next approver for a pending adjustment request based on the item type GCSADJ, the entry key, and the current activity. It signals activity completion through the result output.
  • process_approval — Executes the approval outcome path, advancing or completing the workflow when an approver approves the adjustment.
  • process_rejected — Handles the rejection outcome, returning the adjustment along the rejection branch of the workflow and updating related status.
  • update_adjustment — A workflow function activity invoked at the close of the approval cycle that writes the approval result back to the underlying GCS adjustment, synchronizing the database record with the workflow state.
  • Fch_Check_Approvals — A check function that evaluates whether required approvals have been obtained, allowing the workflow to branch conditionally.

Each procedure conventionally accepts the workflow item type, item key, activity identifier, and function mode, and returns a result value consumed by the Workflow engine. Parameter lists are not reproduced here as they are defined by the package specification.

Tables Accessed

The package operates across three logical data groups. Consolidation data is read and updated through GCS_ENTRY_HEADERS (the adjustment itself), GCS_HIERARCHIES_TL (hierarchy definitions for approver resolution and display), FEM_CAL_PERIODS_TL and FEM_ENTITIES_TL (period and entity validation). Workflow and security metadata are drawn from WF_ITEMS, FND_USER, FND_RESPONSIBILITY, FND_APPLICATION, and FND_ATTACHED_DOCUMENTS, supporting approver lookup and supporting documentation linkage. PLITBLM is used as the PL/SQL index-by table work area for list handling within the package.

Usage Notes

GCS_ADJ_APPROVAL_WF_PKG is normally invoked indirectly rather than called directly. The GCS adjustment entry form launches create_gcsadj_process when an adjustment is submitted for approval, after which the Oracle Workflow engine calls Get_Next_Approver, Fch_Check_Approvals, process_approval, process_rejected, and update_adjustment as the approval progresses. Notification responses routed through the Workflow notification system trigger the same procedures. Because the ETRM classifies this package as OTHER, it is not a supported public API; customizations should instead subscribe to workflow events or use the referenced-by packages rather than calling these procedures directly. The package is referenced by one other package within the APPS schema, reinforcing its role as an internal integration layer. On both 12.1.1 and 12.2.2 the workflow item type GCSADJ remains the controlling construct, and the header comment confirms the shipped version dates to 2007, with behavior stable across these releases.