Search Results verify_term_employee

Overview

PSP_WF_EFF_PKG is the Oracle Workflow integration package for the Oracle E-Business Suite effort reporting solution (Public Sector / Grants). Its header identifies it as PSPWFEFB.pls, version 120.0.12010000.4, last shipped in 2008. The package encapsulates the PL/SQL logic that drives the effort report approval and certification workflow item type PSPEFFWF. It creates workflow processes when effort reports are generated, populates workflow attributes, evaluates the eligibility of employees, supervisors, approvers, and certifiers, and writes status transitions back to the effort report records in response to workflow events. In release 12.1.1 and 12.2.2 the package is owned by APPS and is classified as an OTHER API; it is not a public, supported interface, and is referenced by one other package within the effort reporting module.

Key Procedures and Functions

• INIT_WORKFLOW — Invoked when an effort report is created (called from psp_efforts_pkg.crt). It derives the workflow item key, retrieves the maximum version number per effort report, gathers employee and period details, populates workflow attributes, and starts the PSPEFFWF process.
• OMIT_APPROVAL_STEP — Determines whether the approval step can be bypassed for a given effort report, allowing the workflow to route directly to certification.
• CAN_EMPLOYEE_APPROVE — Evaluates whether the employee identified on the effort report is permitted to perform the approval action.
• CAN_SUPERVISOR_CERTIFY — Evaluates whether the supervisor of the reporting employee is permitted to certify the effort report.
• VERIFY_EMPLOYEE and VERIFY_SUPERVISOR — Validate the employee and supervisor participants before notification delivery, confirming that the correct person is assigned to the workflow role.
• VERIFY_TERM_EMPLOYEE — The function matching the user search term; it validates a terminated employee during workflow processing, ensuring that separation does not leave an approval or certification step without a resolvable responder.
• SELECT_CERTIFIER and SELECT_APPROVER — Identify the appropriate certifier and approver for the effort report when an explicit participant is not already defined.
• GET_APPROVAL_RESPONDER and GET_CERTIFICATION_RESPONDER — Return the responder for the approval and certification notifications.
• STATUS_APPROVED, STATUS_REJECTED, STATUS_CERTIFIED, STATUS_SUPERSEDED — Thin wrappers that call the internal UPDATE_STATUS routine to update the effort report status when the corresponding workflow event occurs.

Tables Accessed

• PSP_EFFORT_REPORTS — Primary effort report records; read to obtain report identifiers, version numbers, and person identifiers, and updated by the status functions.
• PSP_EFFORT_REPORT_TEMPLATES — Supplies reporting period start and end dates and template-level configuration.
• PER_ALL_PEOPLE_F — Resolves employee, supervisor, approver, and certifier identities.
• WF_ITEM_ACTIVITY_STATUSES — Consulted for workflow activity state during status processing and responder resolution.
• WF_NOTIFICATIONS — Used to locate and manage the approval and certification notifications associated with the item.

Usage Notes

PSP_WF_EFF_PKG is invoked indirectly by the effort reporting business flow rather than by end users. INIT_WORKFLOW is called programmatically from psp_efforts_pkg when a report is generated, and the remaining functions execute as workflow function activities within the PSPEFFWF item type as approvers and certifiers act on notifications in the Workflow Notification worklist. Because the package is a private implementation detail of effort reporting, customization should be limited to the documented extension points; direct calls from custom forms or concurrent programs are not supported, and the VERIFY_TERM_EMPLOYEE and related validation functions inherit the terminated-employee handling introduced for the reporting module in the 12.1.1 and 12.2.2 code lines.