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 1135: l_worker_role :=find_role_for_recipient(hxc_app_comp_notifications_api.c_recipient_worker,l_timecard_id,l_timecard_ovn);

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

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

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

Line 1181: if(l_action_code=hxc_app_comp_notifications_api.c_action_auto_approve

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

Line 1182: and l_recipient_code=hxc_app_comp_notifications_api.c_recipient_worker) then

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

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

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

Line 1261: 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

1257: aname => '#HIDE_MOREINFO',
1258: avalue => 'Y');
1259:
1260:
1261: 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
1262: if g_debug then
1263: hr_utility.set_location(l_proc, 80);
1264: end if;
1265: --set TC_FROM_ROLE

Line 1326: 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

1322: itemkey => itemkey,
1323: aname => '#HIDE_MOREINFO',
1324: avalue => 'N');
1325:
1326: 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
1327: if g_debug then
1328: hr_utility.set_location(l_proc, 90);
1329: end if;
1330: -- We need to attach timecard Id to Application Id..it looks crazy...

Line 1422: 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

1418: itemkey => itemkey,
1419: aname => 'RESOURCE_ID',
1420: avalue => l_resource_id);
1421:
1422: 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
1423: if g_debug then
1424: hr_utility.set_location(l_proc, 100);
1425: end if;
1426: l_supervisor_role :=find_role_for_recipient('SUPERVISOR',l_timecard_id,l_timecard_ovn);

Line 1494: 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

1490: itemkey => itemkey,
1491: aname => '#HIDE_MOREINFO',
1492: avalue => 'N');
1493:
1494: 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
1495:
1496: if g_debug then
1497: hr_utility.set_location(l_proc, 110);
1498: end if;

Line 1570: 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

1566:
1567: result := 'COMPLETE:INCLUDE_TIMECARD_DETAILS';
1568:
1569: else
1570: 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
1571:
1572: if g_debug then
1573: hr_utility.set_location(l_proc, 120);
1574: end if;