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_PKG dependencies on HXC_AP_DETAIL_LINKS

Line 351: from hxc_ap_detail_links

347: (p_app_id in hxc_time_building_blocks.time_building_block_id%TYPE,
348: p_block_id in hxc_time_building_blocks.time_building_block_id%TYPE
349: ) is
350: select max(time_building_block_ovn)
351: from hxc_ap_detail_links
352: where application_period_id = p_app_id
353: and time_building_block_id = p_block_id;
354:
355: cursor c_test_translation_key

Line 379: l_block_ovn hxc_ap_detail_links.time_building_block_ovn%type;

375: and nvl(tbb1.application_set_id,hr_api.g_number) = nvl(tbb1.application_set_id,hr_api.g_number)
376: and nvl(tbb1.data_set_id,hr_api.g_number) = nvl(tbb1.data_set_id,hr_api.g_number)
377: and nvl(tbb1.translation_display_key,hr_api.g_varchar2) <> nvl(tbb2.translation_display_key,hr_api.g_varchar2);
378:
379: l_block_ovn hxc_ap_detail_links.time_building_block_ovn%type;
380:
381: Begin
382: open c_block(p_app_id, p_block_id);
383: fetch c_block into l_block_ovn;

Line 423: FROM hxc_ap_detail_links apdetail

419: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
420: )
421: IS
422: SELECT count(p_app_id)
423: FROM hxc_ap_detail_links apdetail
424: ,hxc_time_building_blocks days
425: ,hxc_time_building_blocks details
426: WHERE apdetail.application_period_id = p_app_id
427: AND days.parent_building_block_id = p_timecard_id

Line 578: FROM hxc_ap_detail_links apdetail

574: )
575: IS
576: SELECT details.time_building_block_id
577: ,details.object_version_number
578: FROM hxc_ap_detail_links apdetail
579: ,hxc_time_building_blocks details
580: WHERE apdetail.application_period_id = p_app_period
581: AND apdetail.time_building_block_id = details.time_building_block_id
582: AND apdetail.time_building_block_ovn = details.object_version_number

Line 595: delete from hxc_ap_detail_links

591: LOOP
592: FETCH c_detail_blocks INTO l_detail_id, l_detail_ovn;
593: EXIT WHEN c_detail_blocks%NOTFOUND;
594:
595: delete from hxc_ap_detail_links
596: where time_building_block_id = l_detail_id
597: and time_building_block_ovn = l_detail_ovn
598: and application_period_id = p_app_id;
599:

Line 609: delete from hxc_ap_detail_links

605: LOOP
606: FETCH c_old_blocks INTO l_detail_id, l_detail_ovn;
607: EXIT WHEN c_old_blocks%NOTFOUND;
608:
609: delete from hxc_ap_detail_links
610: where time_building_block_id = l_detail_id
611: and time_building_block_ovn = l_detail_ovn
612: and application_period_id = p_app_id;
613: END LOOP;

Line 697: hxc_ap_detail_links_pkg.insert_summary_row(

693: --we use this flag to find all the category 0 blocks
694: p_detail_blocks(l_block_index).added := 'Y';
695:
696: --insert a line in hxc_detail_summary;
697: hxc_ap_detail_links_pkg.insert_summary_row(
698: p_app_id
699: ,p_detail_blocks(l_block_index).block_id
700: ,p_detail_blocks(l_block_index).block_ovn
701: );

Line 759: hxc_ap_detail_links_pkg.insert_summary_row(

755: p_detail_blocks(l_block_index).added := 'Y';
756:
757:
758: --insert a line in hxc_detail_summary;
759: hxc_ap_detail_links_pkg.insert_summary_row(
760: p_app_id
761: ,p_detail_blocks(l_block_index).block_id
762: ,p_detail_blocks(l_block_index).block_ovn
763: );

Line 887: from hxc_ap_detail_links

883:
884: cursor get_building_blocks(p_app_bb_id in number)
885: is
886: select time_building_block_id, time_building_block_ovn
887: from hxc_ap_detail_links
888: where application_period_id = p_app_bb_id;
889:
890: cursor get_app_period(p_bb_id in number, p_bb_ovn in number ,p_app_bb_id in number)
891: is

Line 893: from hxc_ap_detail_links adl,

889:
890: cursor get_app_period(p_bb_id in number, p_bb_ovn in number ,p_app_bb_id in number)
891: is
892: select adl.application_period_id
893: from hxc_ap_detail_links adl,
894: hxc_app_period_summary haps
895: where adl.time_building_block_id = p_bb_id
896: and adl.time_building_block_ovn = p_bb_ovn
897: and adl.application_period_id <> p_app_bb_id

Line 1208: FROM hxc_ap_detail_links

1204: )
1205: IS
1206: SELECT time_building_block_id
1207: ,time_building_block_ovn
1208: FROM hxc_ap_detail_links
1209: WHERE application_period_id = p_app_id;
1210:
1211:
1212: l_current_period hxc_app_period_summary%rowtype;

Line 1367: --populating hxc_ap_detail_links

1363: END LOOP;
1364:
1365: CLOSE c_timecards;
1366:
1367: --populating hxc_ap_detail_links
1368: OPEN c_ap_details(
1369: p_app_id => l_period_id
1370: );
1371:

Line 1377: INSERT INTO hxc_ap_detail_links

1373: FETCH c_ap_details INTO l_detail_id, l_detail_ovn;
1374:
1375: EXIT WHEN c_ap_details%NOTFOUND;
1376: /*
1377: INSERT INTO hxc_ap_detail_links
1378: (application_period_id,
1379: time_building_block_id,
1380: time_building_block_ovn)
1381: VALUES

Line 1384: hxc_ap_detail_links_pkg.insert_summary_row

1380: time_building_block_ovn)
1381: VALUES
1382: */
1383:
1384: hxc_ap_detail_links_pkg.insert_summary_row
1385: (l_new_appl_bb_id,
1386: l_detail_id,
1387: l_detail_ovn);
1388: END LOOP;

Line 1730: FROM hxc_ap_detail_links details

1726: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1727: )
1728: IS
1729: SELECT details.time_building_block_id
1730: FROM hxc_ap_detail_links details
1731: ,hxc_time_building_blocks blocks
1732: WHERE details.application_period_id = p_app_id
1733: AND details.time_building_block_id = blocks.time_building_block_id
1734: AND details.time_building_block_ovn = blocks.object_version_number

Line 1758: from hxc_ap_detail_links

1754: p_blocks out nocopy block_table )
1755: IS
1756: Cursor c_detail_links IS
1757: select time_building_block_id, time_building_block_ovn
1758: from hxc_ap_detail_links
1759: where application_period_id = p_app_id
1760: and time_building_block_id
1761: not in ( select detail.time_building_block_id
1762: from hxc_time_building_blocks detail,

Line 1794: from hxc_ap_detail_links

1790: Cursor c_detail_exists (p_app_id hxc_time_building_blocks.time_building_block_id%TYPE,
1791: p_time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE
1792: ) is
1793: select 1
1794: from hxc_ap_detail_links
1795: where application_period_id = p_app_id
1796: and time_building_block_id = p_time_building_block_id;
1797:
1798: l_block_index BINARY_INTEGER;

Line 1816: hxc_ap_detail_links_pkg.insert_summary_row(

1812: fetch c_detail_exists into l_dummy;
1813:
1814: if c_detail_exists%notfound then
1815: --insert a line in hxc_detail_summary;
1816: hxc_ap_detail_links_pkg.insert_summary_row(
1817: p_app_id
1818: ,p_removed_blocks(l_block_index).block_id
1819: ,p_removed_blocks(l_block_index).block_ovn
1820: );

Line 1919: from hxc_ap_detail_links adl

1915: CURSOR c_get_detail_blocks(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type)
1916: is
1917: select adl.time_building_block_id,
1918: adl.time_building_block_ovn
1919: from hxc_ap_detail_links adl
1920: where adl.application_period_id = p_application_period_id;
1921:
1922: cursor get_max_ovn(p_bb_id in hxc_time_building_blocks.time_building_block_id%type)
1923: is

Line 2038: --from hxc_tc_ap_links and hxc_ap_detail_links

2034:
2035: ELSE
2036: --should also end date them from hxc_time_building_blocks
2037: --remove them from hxc_app_period_summary
2038: --from hxc_tc_ap_links and hxc_ap_detail_links
2039: hxc_app_period_summary_api.app_period_delete(l_app_id_temp);
2040:
2041: END IF;
2042:

Line 2124: from hxc_ap_detail_links

2120: hr_utility.trace('changed is false');
2121: end if;
2122:
2123: select count(*) into l_number_of_details
2124: from hxc_ap_detail_links
2125: where application_period_id = l_app_id;
2126:
2127: hr_utility.trace('Count for '||l_app_id||' is:'||l_number_of_details);
2128:

Line 2344: hr_utility.trace('Populating hxc_ap_detail_links');

2340:
2341: END IF;
2342:
2343: if g_debug then
2344: hr_utility.trace('Populating hxc_ap_detail_links');
2345: end if;
2346: --populate hxc_ap_detail_links
2347: IF l_time_category_id IS NULL
2348: OR l_time_category_id = 0

Line 2346: --populate hxc_ap_detail_links

2342:
2343: if g_debug then
2344: hr_utility.trace('Populating hxc_ap_detail_links');
2345: end if;
2346: --populate hxc_ap_detail_links
2347: IF l_time_category_id IS NULL
2348: OR l_time_category_id = 0
2349: THEN
2350: g_trace := l_proc || '100';

Line 2387: hxc_ap_detail_links_pkg.insert_summary_row(l_app_id, l_tab_type_a(i).p_id, l_max_ovn);

2383: open get_max_ovn(l_tab_type_a(i).p_id);
2384: fetch get_max_ovn into l_max_ovn;
2385: close get_max_ovn;
2386:
2387: hxc_ap_detail_links_pkg.insert_summary_row(l_app_id, l_tab_type_a(i).p_id, l_max_ovn);
2388:
2389: END LOOP;
2390: END IF;
2391: