Search Results check_final_approver

Overview

APPS.HR_OFFER_WF is the PL/SQL workflow package that implements the Oracle HRMS Offer letter approval process within Oracle E-Business Suite 12.1.1 and 12.2.2. It is the application-side engine behind the seeded "HR Offer" workflow item type, coordinating the routing of an offer letter to the hiring manager and successive approvers, tracking the offer's status through its lifecycle, and generating the URLs and detail strings presented to approvers in the Worklist and notification e-mails.

The package is declared AUTHID CURRENT_USER and its header carries a legacy version marker (hrofwrwf.pkh 115.3, dated 2002), which reflects the long stability of the offering workflow that originates in the earlier Oracle HRMS releases and remains in place through the 12.x codeline. It exposes fifteen documented procedures, making it a composite API rather than a single-purpose utility: a mix of workflow-standard callbacks (used as node functions inside the process definition) and internal helper routines for status updates, URL construction, and candidate detail retrieval.

Key Procedures and Functions

The package is structured around the standard Oracle Workflow function-signature convention (itemtype, itemkey, actid, funmode, result OUT NOCOPY), which is visible in the header excerpt for several of its routines.

• START_HROFFER_PROCESS — Initiates the offer workflow for a given hiring manager and candidate assignment, accepting a process name and a read-parameters flag. This is the entry point that launches the workflow instance.
• INITIALIZE — Workflow-standard initialization callback that prepares and returns a result to the calling node.
• GET_NEXT_APPROVER — Determines the next approver in the chain and returns the outcome to the workflow engine; the header notes a global flag (g_bypass_next_apprvr) that records whether the hiring manager wishes to bypass the next approver.
• CHECK_FINAL_APPROVER — Evaluates whether the current approver is the last in the approval hierarchy, returning a result used to route the workflow to completion.
• SET_STATUS_TO_OFFER / SET_STATUS_TO_SENT — Move the offer record through its status states as the process advances.
• RESET_APPROVAL_CHAIN — Restores the approval chain, typically when a prior approval must be re-run.
• GET_SUMMARY_URL, GET_OFFER_URL, GET_LETTER_URL — Build the notification URLs for the summary page, the offer, and the generate-letter action.
• GET_HR_ROUTING_DETAILS, GET_HR_CANDIDATE_DETAILS — Return routing and candidate information for display in notifications.
• COPY_APPROVAL_COMMENT — Propagates an approval comment across workflow steps.
• CHECK_IF_BYPASS / SET_BYPASS_TO_NO — Read and clear the bypass-next-approver indicator.

Tables Accessed

• HR_ALL_ORGANIZATION_UNITS — source of organization and manager context for routing.
• PER_ASSIGN_PROPOSAL_ANSWERS — holds the offer and candidate proposal data driving the notification content.
• WF_ITEMS and WF_PROCESS_ACTIVITIES — the Oracle Workflow runtime tables read during execution.

Usage Notes

HR_OFFER_WF is invoked indirectly. The HRMS Offer workflow item type executes its procedures as node functions; the forms in the recruiting/offer functionality and the Worklist UI trigger and consume its results. No other package in the documented inventory references it, so it should be treated as a workflow-layer component. Customizations should extend through the workflow definition and Business Events rather than by modifying this seeded package, since it is shipped as an Oracle-owned object.