Search Results get_description_date

Overview

HXC_FIND_NOTIFY_APRS_PKG is an Oracle E-Business Suite package in the APPS schema that supports the Oracle Time and Labor (HXC) approval workflow. Its primary responsibility is to identify the approval style required for a given timecard or application period, launch and manage the corresponding Oracle Workflow notification process, and capture the outcome of the approver's action. The package acts as the integration layer between the Time and Labor approval engine, the Workflow notification infrastructure, and the HR supervisor hierarchy. It is registered with an API classification of OTHER in ETRM and is referenced by ten other packages, confirming its role as a shared, low-level utility within the HXC module rather than a public application programming interface.

Key Procedures and Functions

The package exposes twenty-nine documented procedures and functions. The descriptive functions—GET_DESCRIPTION, GET_DESCRIPTION_TC, and GET_DESCRIPTION_DATE—return human-readable text describing an application period or timecard for display in workflow notification messages. The workflow callback procedures FIND_APR_STYLE, AUTO_APPROVAL, PERSON_APPROVAL, and HR_SUPERVISOR_APPROVAL each follow the standard Workflow PL/SQL callback signature, receiving item type, item key, activity ID, function mode, and a result value. FIND_APR_STYLE determines the approval style applicable to the item, AUTO_APPROVAL handles the automated approval path, PERSON_APPROVAL routes the notification to a named approver, and HR_SUPERVISOR_APPROVAL routes it through the supervisory hierarchy.

The capture procedures—CAPTURE_APPROVED_STATUS, CAPTURE_REJECTED_STATUS, CAPTURE_TIMEOUT_STATUS, CAPTURE_APR_COMMENT, and CAPTURE_REJECT_COMMENT—record the approver's decision and comments against the timecard or application period. IS_FINAL_APR evaluates whether the current approval step is the last in the chain. CHECK_USER_EXISTS validates the existence of a user prior to notification, while GET_LOGIN resolves login information. FORMULA_SELECTS_MECHANISM and SET_NEXT_APP_PERIOD support the rule-based selection of the approval mechanism and the advancement to the subsequent application period in a multi-period flow. LAUNCH_WF_PROCESS initiates the workflow process for the approval, and TEST_WF_RESULT evaluates the workflow's outcome. CANCEL_PREVIOUS_NOTIFICATIONS clears outstanding notifications when an approval is superseded or withdrawn.

Tables Accessed

The package reads and updates the HXC approval and timecard tables, including HXC_APP_PERIOD_SUMMARY, HXC_TIMECARD_SUMMARY, HXC_TIME_BUILDING_BLOCKS, HXC_APPROVAL_COMPS, HXC_APPROVAL_STYLES, and HXC_APPROVAL_WF_S, which hold the approval style definitions and workflow state. HXC_AP_DETAIL_LINKS and HXC_TC_AP_LINKS associate application periods with timecards. HXC_TIME_ATTRIBUTES, HXC_TIME_ATTRIBUTE_USAGES, HXC_TIME_CATEGORIES, and HXC_TIME_RECIPIENTS support rule evaluation and recipient determination. FND_NEW_MESSAGES and FND_USER are used for notification delivery and user validation. PER_ALL_ASSIGNMENTS_F supplies the HR assignment and supervisor information required by the HR_SUPERVISOR_APPROVAL logic.

Usage Notes

HXC_FIND_NOTIFY_APRS_PKG is normally invoked indirectly through the Time and Labor approval workflow rather than by direct user action. The callback procedures are configured as function activities within the workflow definition for the approval item type; Oracle Workflow invokes each callback as the process progresses from approval style selection through notification, response capture, and final status determination. Supporting Oracle Forms and concurrent programs in the Time and Labor module may call the descriptive and status functions to display approval information or summarize outcomes. Custom development that extends Time and Labor approvals should reference the documented functions without assuming stability of their internal logic, as the package underlies standard workflow processing in both EBS 12.1.1 and 12.2.2.