1229: --FYI Notification to PREPARER on timecard APPROVAL
1230: hxc_approval_wf_helper.set_notif_attribute_values
1231: (p_itemtype,
1232: p_itemkey,
1233: hxc_app_comp_notifications_api.c_action_approved,
1234: hxc_app_comp_notifications_api.c_recipient_preparer
1235: );
1236: --sb_msgs_pkg.trace('p_result>' || p_result || '<');
1237: --sb_msgs_pkg.end_call(l_proc);
1230: hxc_approval_wf_helper.set_notif_attribute_values
1231: (p_itemtype,
1232: p_itemkey,
1233: hxc_app_comp_notifications_api.c_action_approved,
1234: hxc_app_comp_notifications_api.c_recipient_preparer
1235: );
1236: --sb_msgs_pkg.trace('p_result>' || p_result || '<');
1237: --sb_msgs_pkg.end_call(l_proc);
1238: exception
1335: --FYI Notification to PREPARER on timecard REJECTION
1336: hxc_approval_wf_helper.set_notif_attribute_values
1337: (p_itemtype,
1338: p_itemkey,
1339: hxc_app_comp_notifications_api.c_action_rejected,
1340: hxc_app_comp_notifications_api.c_recipient_preparer
1341: );
1342:
1343: --sb_msgs_pkg.trace('p_result>' || p_result || '<');
1336: hxc_approval_wf_helper.set_notif_attribute_values
1337: (p_itemtype,
1338: p_itemkey,
1339: hxc_app_comp_notifications_api.c_action_rejected,
1340: hxc_app_comp_notifications_api.c_recipient_preparer
1341: );
1342:
1343: --sb_msgs_pkg.trace('p_result>' || p_result || '<');
1344: --sb_msgs_pkg.end_call(l_proc);
1691: --FYI Notification to WORKER on timecard AUTO APPROVAL
1692: HXC_APPROVAL_WF_HELPER.set_notif_attribute_values
1693: (p_itemtype,
1694: p_itemkey,
1695: hxc_app_comp_notifications_api.c_action_auto_approve,
1696: hxc_app_comp_notifications_api.c_recipient_worker
1697: );
1698:
1699: p_result := 'COMPLETE';
1692: HXC_APPROVAL_WF_HELPER.set_notif_attribute_values
1693: (p_itemtype,
1694: p_itemkey,
1695: hxc_app_comp_notifications_api.c_action_auto_approve,
1696: hxc_app_comp_notifications_api.c_recipient_worker
1697: );
1698:
1699: p_result := 'COMPLETE';
1700: end if;
2091: else
2092: HXC_APPROVAL_WF_HELPER.set_notif_attribute_values
2093: (p_itemtype,
2094: p_itemkey,
2095: hxc_app_comp_notifications_api.c_action_request_approval,
2096: hxc_app_comp_notifications_api.c_recipient_supervisor
2097: );
2098: end if;
2099:
2092: HXC_APPROVAL_WF_HELPER.set_notif_attribute_values
2093: (p_itemtype,
2094: p_itemkey,
2095: hxc_app_comp_notifications_api.c_action_request_approval,
2096: hxc_app_comp_notifications_api.c_recipient_supervisor
2097: );
2098: end if;
2099:
2100: p_result := 'COMPLETE';
3707: else
3708: hxc_approval_wf_helper.set_notif_attribute_values
3709: (p_itemtype,
3710: p_itemkey,
3711: hxc_app_comp_notifications_api.c_action_request_approval,
3712: hxc_app_comp_notifications_api.c_recipient_supervisor
3713: );
3714: end if;
3715:
3708: hxc_approval_wf_helper.set_notif_attribute_values
3709: (p_itemtype,
3710: p_itemkey,
3711: hxc_app_comp_notifications_api.c_action_request_approval,
3712: hxc_app_comp_notifications_api.c_recipient_supervisor
3713: );
3714: end if;
3715:
3716: --
3770: --FYI Notification to PREPARER on timecard APPROVAL
3771: hxc_approval_wf_helper.set_notif_attribute_values
3772: (p_itemtype,
3773: p_itemkey,
3774: hxc_app_comp_notifications_api.c_action_approved,
3775: hxc_app_comp_notifications_api.c_recipient_preparer
3776: );
3777: p_result := 'COMPLETE:APPROVED';
3778:
3771: hxc_approval_wf_helper.set_notif_attribute_values
3772: (p_itemtype,
3773: p_itemkey,
3774: hxc_app_comp_notifications_api.c_action_approved,
3775: hxc_app_comp_notifications_api.c_recipient_preparer
3776: );
3777: p_result := 'COMPLETE:APPROVED';
3778:
3779: elsif l_wf_apr_result = 'REJECTED' then
3781: --FYI Notification to PREPARER on timecard REJECTION
3782: hxc_approval_wf_helper.set_notif_attribute_values
3783: (p_itemtype,
3784: p_itemkey,
3785: hxc_app_comp_notifications_api.c_action_rejected,
3786: hxc_app_comp_notifications_api.c_recipient_preparer
3787: );
3788: p_result := 'COMPLETE:REJECTED';
3789:
3782: hxc_approval_wf_helper.set_notif_attribute_values
3783: (p_itemtype,
3784: p_itemkey,
3785: hxc_app_comp_notifications_api.c_action_rejected,
3786: hxc_app_comp_notifications_api.c_recipient_preparer
3787: );
3788: p_result := 'COMPLETE:REJECTED';
3789:
3790: else