Search Results approve_all_managers

Overview

BEN_CWB_APPROVALS is a PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the approval workflow of the Compensation Workbench (CWB) module within Oracle Advanced Benefits. Compensation Workbench allows managers to allocate compensation components such as salaries, bonuses, and stock grants across their direct and indirect reports within a defined worksheet cycle. Because allocations flow upward through the management hierarchy before final sign-off, CWB requires a structured approval mechanism. BEN_CWB_APPROVALS encapsulates the server-side logic that governs this mechanism, providing programmatic entry points to advance approvals through the organizational hierarchy and to resolve the identity of the next approver in a given plan and worksheet context. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the definer, consistent with standard EBS API security conventions.

Key Procedures and Functions

The package exposes two documented procedures, both central to the approval lifecycle:

• APPROVE_ALL_MANAGERS — This procedure processes the approval action for a manager group associated with a Compensation Workbench worksheet. It accepts identifiers for the person-in-lear (plan enrollment) record, the group plan, the group OIPL, the task, an effective date, and the logged-in person. Its purpose is to drive the approval of all managers associated with the specified group context, advancing the worksheet toward completion in a single call rather than requiring per-manager user intervention.
• GETNEXTAPPROVER — This procedure resolves the next approver in the workflow chain. Given a person-in-lear identifier and the display name of the applicable CWB profile, it returns the next approver's name and identifier, together with the name of the last approver. It functions as a lookup utility that determines routing at runtime, enabling the approval engine to identify who must act next based on the hierarchy and plan configuration.

Tables Accessed

The package operates against five documented tables accessed through APPS synonyms:

• BEN_CWB_GROUP_HRCHY — stores the group hierarchy that defines management relationships for approval routing.
• BEN_CWB_PERSON_GROUPS — associates persons with the worksheet groups subject to approval.
• BEN_CWB_PERSON_INFO — holds person-level worksheet information used during approval processing.
• BEN_CWB_PERSON_TASKS — records tasks assigned to persons, tracking approval obligations and status.
• BEN_CWB_WKSHT_GRP — defines worksheet groups that organize allocations and approvals.

Reads on the hierarchy and group tables drive approver resolution, while the person task and person info tables support status updates and task progression arising from approval actions.

Usage Notes

BEN_CWB_APPROVALS is typically invoked indirectly rather than called directly by end users. It is engaged from the Compensation Workbench approval pages and related self-service forms where managers submit or monitor worksheet approvals, and from concurrent programs and workflow background processes that propagate approvals automatically. The approve_all_managers routine suits batch or bulk approval scenarios, such as when an administrator needs to complete approvals for an entire management group. Because the ETRM records no dependent packages referencing it, integration is generally through these UI and workflow entry points. Custom extensions that automate CWB approvals should call the documented signatures only, honoring the effective date and login person parameters to preserve audit integrity and hierarchy correctness. Developers should treat the package as an internal API, controlling access through the standard APPS privilege model.