Search Results verify_supervisor

Overview

PSP_WF_EFF_PKG is an Oracle EBS Application Object Library package owned by the APPS schema, classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API. It forms part of the Oracle Project Resource Management (PSP) subsystem, specifically supporting the effort reporting and workflow approval infrastructure used by Oracle Project Management and Oracle Time and Labor. The package encapsulates the workflow-facing logic required to certify and approve effort reports: it determines eligibility for approval and certification, selects the appropriate responder (approver or certifier), and processes status transitions such as approved, superseded, certified, and rejected. In Oracle EBS 12.1.1 and 12.2.2, the package status is VALID, and its metadata is documented in the ETRM for release 12.2.2. Because it is a private supporting package rather than a public, published API, it is not intended for direct customer invocation; it is invoked internally by Oracle Workflow and by other PSP packages.

Key Procedures and Functions

The package exposes 15 documented procedures/functions, which cluster into four functional groups:

• Workflow initialization and control: INIT_WORKFLOW, OMIT_APPROVAL_STEP, GET_APPROVAL_RESPONDER, GET_CERTIFICATION_RESPONDER — these initialize the effort reporting workflow process and resolve the notification recipient for approval or certification steps.
• Eligibility checks: CAN_EMPLOYEE_APPROVE, CAN_SUPERVISOR_CERTIFY, VERIFY_EMPLOYEE, VERIFY_SUPERVISOR, VERIFY_TERM_EMPLOYEE — these validate whether a given employee or supervisor is permitted to approve or certify an effort report, including handling of terminated employees.
• Responder selection: SELECT_CERTIFIER, SELECT_APPROVER — these apply the business rules governing who should be designated as the certifier or approver for a given effort report or template.
• Status transitions: STATUS_APPROVED, STATUS_SUPERSEDED, STATUS_CERTIFIED, STATUS_REJECTED — these record the outcome of the approval or certification workflow by updating the effort report's status accordingly.

The procedures are declared in the package specification and implemented in the package body; the ETRM documents both a specification and a body entry.

Tables Accessed

PSP_WF_EFF_PKG accesses the following tables through APPS synonyms:

• PER_ALL_PEOPLE_F — the HR people table, used to resolve employee/supervisor identity and employment status during eligibility and responder checks.
• PSP_EFFORT_REPORTS — the effort report header records whose status is set and whose approver/certifier is selected.
• PSP_EFFORT_REPORT_TEMPLATES — the template definitions that govern approval and certification rules.
• WF_ITEM_ACTIVITY_STATUSES — the Oracle Workflow activity status table, used to read or update the workflow state associated with an effort report.
• WF_NOTIFICATIONS — the Workflow notifications table, used to create or query approval and certification notifications sent to responders.

These accesses are consistent with a workflow-integrated approval engine rather than a purely data-maintenance package.

Usage Notes

PSP_WF_EFF_PKG is referenced by the package PSP_EFFORTS_PKG and by itself (internal calls), confirming that it is a lower-level procedural component invoked within the effort reporting flow. It is generally called from Oracle Workflow function activities and from PSP_EFFORTS_PKG during the effort report approval and certification cycle in Oracle Project Management. Because the ETRM classifies it as an "OTHER" API, it is not a supported public interface for customer extensions; custom code should avoid direct invocation and instead operate through the documented workflow events or through PSP_EFFORTS_PKG. The 1:1 reference count recorded in the ETRM further indicates a narrow, tightly coupled dependency footprint. The absence of a documented PL/SQL block in the excerpt means callers rely on Oracle-supplied internal behavior rather than on a published parameter contract.