Search Results is_transfer

Overview

APPS.HXC_NOTIFICATION_PROCESS_PKG is a PL/SQL package belonging to the Oracle E-Business Suite Time and Labor (HXC) module. It encapsulates the notification-processing logic used by the Oracle Workflow engine when Time and Labor approval notifications are generated, routed, timed out, or restarted. In EBS 12.1.1 and 12.2.2 the package acts as a bridge between the Time and Labor approval model — stored in the HXC_APPROVAL_* and HXC_TIME_* tables — and the generic Workflow notification infrastructure in WF_ITEMS and related views. Its procedures are written in the standard Workflow callback signature (item type, item key, activity id, function mode, result), which allows them to be wired directly into workflow activity definitions as function-type activities. The package is owned by APPS and classified as OTHER in the ETRM registry, and it is referenced by one other package within the application schema.

Key Procedures and Functions

• APPROVED_BY — Determines and processes the approver associated with a given Time and Labor notification, supporting the routing of approval notifications to the correct respondent.
• TIMEOUTS_ENABLED — Evaluates whether timeout handling is active for the notification activity, governing whether escalation or expiry logic should proceed.
• RESET_FOR_NEXT_TIMEOUT — Re-arms timeout processing so that the next timeout interval can be applied to the workflow item, typically after a timeout action has fired.
• RESTART_WORKFLOW — Restarts workflow processing for the identified item, used when an approval flow must be re-initiated or resumed.
• IS_TRANSFER — The procedure matching the user's search term; it evaluates whether the notification activity represents a transfer event, allowing downstream logic to branch on transfer versus non-transfer cases.
• EXCLUDE_TOTAL_HOURS, EVALUATE_ABS_PREF, IS_TCOWNER_SAMEAS_APPROVER — Additional documented procedures supporting total-hours exclusion, absence-preference evaluation, and comparison of timecard owner against approver, respectively.

All procedures share the Workflow callback parameter pattern (item type, item key, activity id, function mode, result out), confirming they are invoked as workflow function activities rather than from ordinary forms logic.

Tables Accessed

The package reads and writes across approval, time, and workflow schemas via APPS synonyms:

• Workflow tables — WF_ITEMS, WF_ITEM_ACTIVITY_STATUSES, WF_LOCAL_ROLES support item status, activity state, and role resolution.
• Approval tables — HXC_APPROVAL_COMPS, HXC_APPROVAL_ITEM_KEY_S, HXC_APPROVAL_STYLES, HXC_APP_COMP_NOTIFICATIONS, HXC_APP_COMP_NOTIF_USAGES, HXC_APP_PERIOD_SUMMARY define approval components and their notification usages.
• Time setup tables — HXC_TIME_ATTRIBUTES, HXC_TIME_ATTRIBUTE_USAGES, HXC_TIME_BUILDING_BLOCKS, HXC_TIME_CATEGORIES provide the timecard structure and categorization needed for transfer and total-hours evaluation.
• Reference tables — PER_ALL_PEOPLE_F and FND_USER resolve person and user identities for approvers and timecard owners.

Usage Notes

HXC_NOTIFICATION_PROCESS_PKG is not typically invoked directly by end users or custom forms. It is called by the Oracle Workflow engine running within the Time and Labor notification workflow, whenever an approval notification activity executes. Because the procedures conform to the standard Workflow function-activity signature, they are registered on workflow activity definitions and executed at runtime by the Workflow background processes. Customizations that alter approval routing, timeout behavior, or transfer detection should extend rather than bypass this package, since modifying it can affect every Time and Labor approval notification in the instance. The presence of the IS_TRANSFER procedure, in particular, indicates that transfer-specific branching is a first-class concern in the Time and Labor notification model, and the result of that evaluation determines how the notification is subsequently processed.