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_FIND_NOTIFY_APRS_PKG

Line 1142: l_worker_full_name :=hxc_find_notify_aprs_pkg.get_name(l_resource_id,l_tc_stop_date);

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
1140: --for null, if it is null we need to fetch from the per tables.
1141: if l_worker_role is null then
1142: l_worker_full_name :=hxc_find_notify_aprs_pkg.get_name(l_resource_id,l_tc_stop_date);
1143: else
1144: l_worker_full_name := find_full_name_from_role(l_worker_role,l_tc_start_date);
1145: end if;
1146:

Line 1211: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));

1207: wf_engine.SetItemAttrText
1208: (itemtype => itemtype,
1209: itemkey => itemkey,
1210: aname => 'DESCRIPTION',
1211: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
1212: --set FYI_SUBJECT
1213: fnd_message.set_name('HXC','HXC_APPR_AUTO_WORKER');
1214: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1215: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

Line 1291: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));

1287: wf_engine.SetItemAttrText
1288: (itemtype => itemtype,
1289: itemkey => itemkey,
1290: aname => 'DESCRIPTION',
1291: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
1292:
1293: --set FYI_SUBJECT
1294: fnd_message.set_name('HXC','HXC_APPR_REJ_PREPARER');
1295: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);

Line 1364: avalue => hxc_find_notify_aprs_pkg.get_description_tc(l_timecard_id,l_timecard_ovn));

1360: --set DESCRIPTION
1361: wf_engine.SetItemAttrText(itemtype => itemtype,
1362: itemkey => itemkey,
1363: aname => 'DESCRIPTION',
1364: avalue => hxc_find_notify_aprs_pkg.get_description_tc(l_timecard_id,l_timecard_ovn));
1365: --set FYI_SUBJECT
1366: fnd_message.set_name('HXC','HXC_APPR_SUB_WORKER');
1367:
1368: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

Line 1456: avalue => hxc_find_notify_aprs_pkg.get_description_date(l_effective_start_date,l_effective_end_date,l_resource_id));

1452: wf_engine.SetItemAttrText
1453: (itemtype => itemtype,
1454: itemkey => itemkey,
1455: aname => 'DESCRIPTION',
1456: avalue => hxc_find_notify_aprs_pkg.get_description_date(l_effective_start_date,l_effective_end_date,l_resource_id));
1457:
1458: --set FYI_SUBJECT
1459: l_tc_to_role :=wf_engine.GetItemAttrText(
1460: itemtype => itemtype,

Line 1521: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));

1517: wf_engine.SetItemAttrText
1518: (itemtype => itemtype,
1519: itemkey => itemkey,
1520: aname => 'DESCRIPTION',
1521: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
1522:
1523: --set FYI_SUBJECT
1524: l_apr_person_id :=wf_engine.GetItemAttrText(
1525: itemtype => itemtype,

Line 1528: l_supervisor_id :=hxc_find_notify_aprs_pkg.get_supervisor(l_apr_person_id,SYSDATE);

1524: l_apr_person_id :=wf_engine.GetItemAttrText(
1525: itemtype => itemtype,
1526: itemkey => itemkey,
1527: aname => 'APR_PERSON_ID');
1528: l_supervisor_id :=hxc_find_notify_aprs_pkg.get_supervisor(l_apr_person_id,SYSDATE);
1529: l_supervisor_name :=hxc_find_notify_aprs_pkg.get_name(
1530: l_supervisor_id,SYSDATE);
1531: fnd_message.set_name('HXC','HXC_APPR_TRAN_APPROVER');
1532: fnd_message.set_token('APPROVER_FULL_NAME',l_preparer_full_name);

Line 1529: l_supervisor_name :=hxc_find_notify_aprs_pkg.get_name(

1525: itemtype => itemtype,
1526: itemkey => itemkey,
1527: aname => 'APR_PERSON_ID');
1528: l_supervisor_id :=hxc_find_notify_aprs_pkg.get_supervisor(l_apr_person_id,SYSDATE);
1529: l_supervisor_name :=hxc_find_notify_aprs_pkg.get_name(
1530: l_supervisor_id,SYSDATE);
1531: fnd_message.set_name('HXC','HXC_APPR_TRAN_APPROVER');
1532: fnd_message.set_token('APPROVER_FULL_NAME',l_preparer_full_name);
1533: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

Line 1545: l_tc_from_role :=hxc_find_notify_aprs_pkg.get_login(p_person_id => l_apr_person_id);

1541: itemkey => itemkey,
1542: aname => 'FYI_SUBJECT',
1543: avalue => l_fyi_subject);
1544: --set FYI_RECIPIENT_LOGIN
1545: l_tc_from_role :=hxc_find_notify_aprs_pkg.get_login(p_person_id => l_apr_person_id);
1546:
1547: wf_engine.SetItemAttrText(
1548: itemtype => itemtype,
1549: itemkey => itemkey,