Search Results capture_timeout_status

Overview

The APPS.HXC_TIMEKEEPER_WF_PKG package is the Workflow integration layer for Oracle E-Business Suite timekeeping and timecard approval processing. It bridges the Oracle Time and Labor (OTL) transaction model with the Oracle Workflow engine (WF), enabling timecard submission, approval routing, notification delivery, and status capture to be driven through Workflow item types and activities rather than through conventional form-based processing. The package is declared AUTHID CURRENT_USER and executes under the privileges of the calling APPS schema.

The package operates by launching workflow processes for a timekeeper notification or approval cycle, resolving the correct recipient, delivering notifications, and then capturing the outcome of that notification — approval, rejection, or timeout — back into the OTL transaction structures. Among the documented routines, CAPTURE_TIMEOUT_STATUS is the procedure that handles the case where a timecard approval notification expires or is not answered within the configured window, ensuring the underlying transaction reflects the timeout condition rather than remaining in a pending state.

Key Procedures and Functions

• GET_ITEM_KEY — Returns a numeric item key used to uniquely identify a workflow item instance.
• GET_NAME — Returns a formatted name for a given person and effective date, typically for use in notification text and recipient resolution.
• START_CHILD_PROCESS — Launches a subordinate workflow process from within a parent timekeeper flow, carrying transaction context such as building block, resource, and timekeeper identifiers.
• START_TK_WF_PROCESS — Initiates the top-level timekeeper workflow process for a transaction.
• START_TK_NOTIFICATION — Entry point that begins the notification cycle for a timekeeper approval event.
• FIND_NTF_TO — Resolves the notification recipient (timekeeper, person, or supervisor) based on workflow context.
• PERSON_NOTIFY — Directs the timecard notification to the person associated with the transaction.
• SUPERVISOR_NOTIFY — Directs the notification to the supervisor for approval action.
• CAPTURE_APPROVED_STATUS — Records an approved outcome from the notification back to the OTL transaction.
• CAPTURE_REJECTED_STATUS — Records a rejected outcome from the notification.
• CAPTURE_TIMEOUT_STATUS — Records a timeout outcome when the approval notification is not acted upon within the allowed period.
• UPDATE_TK_NTF_RESULT — Persists the result of the timekeeper notification to the underlying tables.
• CANCEL_PREVIOUS_NOTIFICATIONS — Cancels outstanding notifications when a transaction is superseded or withdrawn.
• BEGIN_AUDIT_PROCESS — Initiates audit processing for the approval cycle.

Tables Accessed

The package reads and writes HXC_TIME_BUILDING_BLOCKS and HXC_TRANSACTION_DETAILS for transaction context and status, and HXC_APPROVAL_ITEM_KEY_S for approval item key sequencing. HXC_ERRORS stores processing errors. Person and assignment data are drawn from PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F, with FND_USER used for recipient resolution. Workflow state is maintained through WF_ITEMS, WF_ITEM_ACTIVITY_STATUSES, and WF_NOTIFICATIONS. DUAL supports simple scalar queries.

Usage Notes

This package is invoked primarily by the Oracle Time and Labor workflow item type as activity function code, and secondarily by Oracle Forms and custom code that need to start, route, or resolve timekeeper notifications. The CAPTURE_*_STATUS procedures follow the standard Workflow function signature and are configured on the workflow activity that evaluates the notification result. Customizations should call these procedures rather than updating the workflow or OTL tables directly, so that notification state and transaction status remain synchronized.