eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_APPROVAL_WF_HELPER dependencies on HXC_APP_COMP_NOTIFICATIONS_API

Line 376: if(p_recipient_code = hxc_app_comp_notifications_api.c_recipient_admin) then

372: end if;
373: --This FUNCTION is essentially a switch on the recipient code, to call one of the private specific FUNCTIONs for
374: --that role, i.e. if recipient code is supervisor then fetch c_the role by calling find_supervisor_role etc.
375:
376: if(p_recipient_code = hxc_app_comp_notifications_api.c_recipient_admin) then
377:
378: if g_debug then
379: hr_utility.set_location(l_proc, 20);
380: end if;

Line 384: elsif ( p_recipient_code = hxc_app_comp_notifications_api.c_recipient_error_admin) then

380: end if;
381:
382: l_role := find_admin_role(p_timecard_id,p_timecard_ovn);
383:
384: elsif ( p_recipient_code = hxc_app_comp_notifications_api.c_recipient_error_admin) then
385:
386: if g_debug then
387: hr_utility.set_location(l_proc, 30);
388: end if;

Line 392: elsif (p_recipient_code = hxc_app_comp_notifications_api.c_recipient_preparer) then

388: end if;
389:
390: l_role :=find_error_admin_role(p_timecard_id,p_timecard_ovn);
391:
392: elsif (p_recipient_code = hxc_app_comp_notifications_api.c_recipient_preparer) then
393:
394: if g_debug then
395: hr_utility.set_location(l_proc, 40);
396: end if;

Line 400: elsif(p_recipient_code = hxc_app_comp_notifications_api.c_recipient_supervisor) then

396: end if;
397:
398: l_role :=find_preparer_role(p_timecard_id,p_timecard_ovn);
399:
400: elsif(p_recipient_code = hxc_app_comp_notifications_api.c_recipient_supervisor) then
401:
402: if g_debug then
403: hr_utility.set_location(l_proc, 50);
404: end if;

Line 407: elsif (p_recipient_code = hxc_app_comp_notifications_api.c_recipient_worker) then

403: hr_utility.set_location(l_proc, 50);
404: end if;
405:
406: l_role :=find_supervisor_role(p_timecard_id,p_timecard_ovn);
407: elsif (p_recipient_code = hxc_app_comp_notifications_api.c_recipient_worker) then
408:
409: if g_debug then
410: hr_utility.set_location(l_proc, 60);
411: end if;

Line 632: if(p_notif_action_code = hxc_app_comp_notifications_api.c_action_approved

628: return boolean is
629:
630: BEGIN
631:
632: if(p_notif_action_code = hxc_app_comp_notifications_api.c_action_approved
633: AND p_notif_recipient_code = hxc_app_comp_notifications_api.c_recipient_preparer)
634: then
635: return false;
636: else

Line 633: AND p_notif_recipient_code = hxc_app_comp_notifications_api.c_recipient_preparer)

629:
630: BEGIN
631:
632: if(p_notif_action_code = hxc_app_comp_notifications_api.c_action_approved
633: AND p_notif_recipient_code = hxc_app_comp_notifications_api.c_recipient_preparer)
634: then
635: return false;
636: else
637: return true;

Line 894: if p_action_code = hxc_app_comp_notifications_api.c_action_request_approval

890: fetch c_get_tc_dates into l_tc_start_date,l_tc_end_date;
891: close c_get_tc_dates;
892: --For the 'Notify supervisor on approval request' notification, since we are sending only once
893: --return false if we found out that notification has been sent.
894: if p_action_code = hxc_app_comp_notifications_api.c_action_request_approval
895: and p_recipient_code=hxc_app_comp_notifications_api.c_recipient_supervisor
896: and trunc(l_tc_end_date - l_tc_start_date) <= (l_app_end_date - l_app_start_date) then
897:
898: if g_debug then

Line 895: and p_recipient_code=hxc_app_comp_notifications_api.c_recipient_supervisor

891: close c_get_tc_dates;
892: --For the 'Notify supervisor on approval request' notification, since we are sending only once
893: --return false if we found out that notification has been sent.
894: if p_action_code = hxc_app_comp_notifications_api.c_action_request_approval
895: and p_recipient_code=hxc_app_comp_notifications_api.c_recipient_supervisor
896: and trunc(l_tc_end_date - l_tc_start_date) <= (l_app_end_date - l_app_start_date) then
897:
898: if g_debug then
899: hr_utility.set_location(l_proc, 40);

Line 970: if(p_action_code = hxc_app_comp_notifications_api.c_action_submission

966:
967:
968: --check for notify worker on timecard submission for TK
969:
970: if(p_action_code = hxc_app_comp_notifications_api.c_action_submission
971: and p_recipient_code=hxc_app_comp_notifications_api.c_recipient_worker and l_result = true) then
972:
973: if g_debug then
974: hr_utility.set_location(l_proc, 80);

Line 971: and p_recipient_code=hxc_app_comp_notifications_api.c_recipient_worker and l_result = true) then

967:
968: --check for notify worker on timecard submission for TK
969:
970: if(p_action_code = hxc_app_comp_notifications_api.c_action_submission
971: and p_recipient_code=hxc_app_comp_notifications_api.c_recipient_worker and l_result = true) then
972:
973: if g_debug then
974: hr_utility.set_location(l_proc, 80);
975: end if;

Line 990: if(p_action_code = hxc_app_comp_notifications_api.c_action_auto_approve and

986:
987: END if;
988: --check for notify worker on auto approval
989:
990: if(p_action_code = hxc_app_comp_notifications_api.c_action_auto_approve and
991: p_recipient_code=hxc_app_comp_notifications_api.c_recipient_worker and l_result = true) then
992:
993: if g_debug then
994: hr_utility.set_location(l_proc, 90);

Line 991: p_recipient_code=hxc_app_comp_notifications_api.c_recipient_worker and l_result = true) then

987: END if;
988: --check for notify worker on auto approval
989:
990: if(p_action_code = hxc_app_comp_notifications_api.c_action_auto_approve and
991: p_recipient_code=hxc_app_comp_notifications_api.c_recipient_worker and l_result = true) then
992:
993: if g_debug then
994: hr_utility.set_location(l_proc, 90);
995: end if;

Line 1136: l_worker_role :=find_role_for_recipient(hxc_app_comp_notifications_api.c_recipient_worker,l_timecard_id,l_timecard_ovn);

1132: itemtype => itemtype,
1133: itemkey => itemkey,
1134: aname => 'APP_START_DATE');
1135:
1136: l_worker_role :=find_role_for_recipient(hxc_app_comp_notifications_api.c_recipient_worker,l_timecard_id,l_timecard_ovn);
1137:
1138:
1139: --There is a possibility that worker may not be having SS login, in that case worker role will be null.
1140: --But we need to have worker full name for various notification purposes, hence we need to check worker role

Line 1148: l_preparer_role := find_role_for_recipient(hxc_app_comp_notifications_api.c_recipient_preparer,l_timecard_id,l_timecard_ovn);

1144: else
1145: l_worker_full_name := find_full_name_from_role(l_worker_role,l_tc_start_date);
1146: end if;
1147:
1148: l_preparer_role := find_role_for_recipient(hxc_app_comp_notifications_api.c_recipient_preparer,l_timecard_id,l_timecard_ovn);
1149:
1150: l_preparer_full_name := find_full_name_from_role(l_preparer_role,l_tc_start_date);
1151:
1152: if g_debug then

Line 1182: if(l_action_code=hxc_app_comp_notifications_api.c_action_auto_approve

1178: if g_debug then
1179: hr_utility.set_location(l_proc, 60);
1180: end if;
1181:
1182: if(l_action_code=hxc_app_comp_notifications_api.c_action_auto_approve
1183: and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_worker) then
1184: if g_debug then
1185: hr_utility.set_location(l_proc, 70);
1186: end if;

Line 1183: and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_worker) then

1179: hr_utility.set_location(l_proc, 60);
1180: end if;
1181:
1182: if(l_action_code=hxc_app_comp_notifications_api.c_action_auto_approve
1183: and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_worker) then
1184: if g_debug then
1185: hr_utility.set_location(l_proc, 70);
1186: end if;
1187:

Line 1189: l_tc_from_role :=find_role_for_recipient(hxc_app_comp_notifications_api.c_recipient_worker,l_timecard_id,l_timecard_ovn);

1185: hr_utility.set_location(l_proc, 70);
1186: end if;
1187:
1188: -- set FROM ROLE to Worker Role
1189: l_tc_from_role :=find_role_for_recipient(hxc_app_comp_notifications_api.c_recipient_worker,l_timecard_id,l_timecard_ovn);
1190: wf_engine.SetItemAttrText(itemtype => itemtype,
1191: itemkey => itemkey,
1192: aname => 'TC_FROM_ROLE',
1193: avalue => l_tc_from_role);

Line 1262: elsif(l_action_code=hxc_app_comp_notifications_api.c_action_rejected and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_preparer) then

1258: aname => '#HIDE_MOREINFO',
1259: avalue => 'Y');
1260:
1261:
1262: elsif(l_action_code=hxc_app_comp_notifications_api.c_action_rejected and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_preparer) then
1263: if g_debug then
1264: hr_utility.set_location(l_proc, 80);
1265: end if;
1266: --set TC_FROM_ROLE

Line 1327: elsif(l_action_code=hxc_app_comp_notifications_api.c_action_submission and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_worker) then

1323: itemkey => itemkey,
1324: aname => '#HIDE_MOREINFO',
1325: avalue => 'N');
1326:
1327: elsif(l_action_code=hxc_app_comp_notifications_api.c_action_submission and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_worker) then
1328: if g_debug then
1329: hr_utility.set_location(l_proc, 90);
1330: end if;
1331: -- We need to attach timecard Id to Application Id..it looks crazy...

Line 1439: elsif(l_action_code=hxc_app_comp_notifications_api.c_action_request_approval and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_supervisor) then

1435: itemkey => itemkey,
1436: aname => 'RESOURCE_ID',
1437: avalue => l_resource_id);
1438:
1439: elsif(l_action_code=hxc_app_comp_notifications_api.c_action_request_approval and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_supervisor) then
1440: if g_debug then
1441: hr_utility.set_location(l_proc, 100);
1442: end if;
1443: l_supervisor_role :=find_role_for_recipient('SUPERVISOR',l_timecard_id,l_timecard_ovn);

Line 1511: elsif(l_action_code=hxc_app_comp_notifications_api.c_action_transfer and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_preparer) then

1507: itemkey => itemkey,
1508: aname => '#HIDE_MOREINFO',
1509: avalue => 'N');
1510:
1511: elsif(l_action_code=hxc_app_comp_notifications_api.c_action_transfer and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_preparer) then
1512:
1513: if g_debug then
1514: hr_utility.set_location(l_proc, 110);
1515: end if;

Line 1587: if(l_action_code=hxc_app_comp_notifications_api.c_action_approved and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_preparer) then

1583:
1584: result := 'COMPLETE:INCLUDE_TIMECARD_DETAILS';
1585:
1586: else
1587: if(l_action_code=hxc_app_comp_notifications_api.c_action_approved and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_preparer) then
1588:
1589: if g_debug then
1590: hr_utility.set_location(l_proc, 120);
1591: end if;