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.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXC_TIME_BUILDING_BLOCKS

Line 42: FROM hxc_time_building_blocks tbb

38: -- Forced hints to get rid of perf issue.
39: CURSOR c_get_day_bb_id (l_parent_start_time DATE, l_resource_id NUMBER)
40: IS
41: SELECT tbb.time_building_block_id
42: FROM hxc_time_building_blocks tbb
43: WHERE tbb.parent_building_block_id IN (
44: SELECT /*+ INDEX( tbb1 HXC_TIME_BUILDING_BLOCKS_FK2)*/
45: time_building_block_id
46: FROM hxc_time_building_blocks tbb1

Line 44: SELECT /+ INDEX( tbb1 HXC_TIME_BUILDING_BLOCKS_FK2)/

40: IS
41: SELECT tbb.time_building_block_id
42: FROM hxc_time_building_blocks tbb
43: WHERE tbb.parent_building_block_id IN (
44: SELECT /*+ INDEX( tbb1 HXC_TIME_BUILDING_BLOCKS_FK2)*/
45: time_building_block_id
46: FROM hxc_time_building_blocks tbb1
47: WHERE tbb1.resource_id = l_resource_id
48: AND tbb1.resource_type = 'PERSON'

Line 46: FROM hxc_time_building_blocks tbb1

42: FROM hxc_time_building_blocks tbb
43: WHERE tbb.parent_building_block_id IN (
44: SELECT /*+ INDEX( tbb1 HXC_TIME_BUILDING_BLOCKS_FK2)*/
45: time_building_block_id
46: FROM hxc_time_building_blocks tbb1
47: WHERE tbb1.resource_id = l_resource_id
48: AND tbb1.resource_type = 'PERSON'
49: AND tbb1.start_time = l_parent_start_time
50: AND tbb1.SCOPE = 'DAY')

Line 54: FROM hxc_time_building_blocks dyovn

50: AND tbb1.SCOPE = 'DAY')
51: AND tbb.object_version_number =
52: (SELECT /*+ NO_UNNEST */
53: MAX (dyovn.object_version_number)
54: FROM hxc_time_building_blocks dyovn
55: WHERE dyovn.time_building_block_id =
56: tbb.time_building_block_id
57: AND dyovn.date_to <> hr_general.end_of_time)
58: AND tbb.date_to <> hr_general.end_of_time

Line 93: l_measure hxc_time_building_blocks.measure%TYPE;

89: l_check_bb_id NUMBER (15);
90: l_check_bb_ovn NUMBER (9);
91: l_parent_bb_ovn NUMBER (9);
92: l_type VARCHAR2 (30);
93: l_measure hxc_time_building_blocks.measure%TYPE;
94: l_start_time DATE;
95: l_parent_start_time DATE;
96: l_stop_time DATE;
97: l_date_to DATE;

Line 338: from hxc_time_building_blocks

334: l_parent_start_time := l_start_time;
335: END IF;
336:
337: /* select start_time into l_parent_start_time
338: from hxc_time_building_blocks
339: where time_building_block_id = l_parent_bb_id
340: and object_version_number = l_parent_bb_ovn; */
341: IF g_debug
342: THEN

Line 445: FROM hxc_time_building_blocks

441: -- in case user has replaced straight hours with start/stop time
442: BEGIN
443: SELECT count(*)
444: INTO l_measure_count
445: FROM hxc_time_building_blocks
446: WHERE time_building_block_id = l_day_bb_id
447: AND ((measure = 0) or (start_time is not null and stop_time is not null))
448: AND scope = 'DETAIL'
449: AND date_to = hr_general.end_of_time;

Line 608: l_measure hxc_time_building_blocks.measure%TYPE;

604: l_segment hxt_otc_retrieval_interface.t_segment;
605: l_bb_id NUMBER (15);
606: l_ovn NUMBER (9);
607: l_type VARCHAR2 (30);
608: l_measure hxc_time_building_blocks.measure%TYPE;
609: l_start_time DATE;
610: l_stop_time DATE;
611: l_date_to DATE;
612: l_parent_bb_id NUMBER (15);

Line 1895: l_measure hxc_time_building_blocks.measure%TYPE;

1891: l_segment hxt_otc_retrieval_interface.t_segment;
1892: l_bb_id NUMBER (15);
1893: l_bb_ovn NUMBER (15);
1894: l_type VARCHAR2 (30);
1895: l_measure hxc_time_building_blocks.measure%TYPE;
1896: l_uom hxc_time_building_blocks.unit_of_measure%TYPE;
1897: l_start_time DATE;
1898: l_stop_time DATE;
1899: l_parent_bb_id NUMBER (15);

Line 1896: l_uom hxc_time_building_blocks.unit_of_measure%TYPE;

1892: l_bb_id NUMBER (15);
1893: l_bb_ovn NUMBER (15);
1894: l_type VARCHAR2 (30);
1895: l_measure hxc_time_building_blocks.measure%TYPE;
1896: l_uom hxc_time_building_blocks.unit_of_measure%TYPE;
1897: l_start_time DATE;
1898: l_stop_time DATE;
1899: l_parent_bb_id NUMBER (15);
1900: l_parent_bb_ovn NUMBER (15);

Line 1906: l_appr_status hxc_time_building_blocks.approval_status%TYPE;

1902: l_scope VARCHAR2 (30);
1903: l_resource_id NUMBER (15);
1904: l_resource_type VARCHAR2 (30);
1905: l_comment_text VARCHAR2 (2000);
1906: l_appr_status hxc_time_building_blocks.approval_status%TYPE;
1907: l_appr_style_id hxc_time_building_blocks.approval_style_id%TYPE;
1908: l_date_from hxc_time_building_blocks.date_from%TYPE;
1909: l_date_to hxc_time_building_blocks.date_to%TYPE;
1910: l_person_id NUMBER (9);

Line 1907: l_appr_style_id hxc_time_building_blocks.approval_style_id%TYPE;

1903: l_resource_id NUMBER (15);
1904: l_resource_type VARCHAR2 (30);
1905: l_comment_text VARCHAR2 (2000);
1906: l_appr_status hxc_time_building_blocks.approval_status%TYPE;
1907: l_appr_style_id hxc_time_building_blocks.approval_style_id%TYPE;
1908: l_date_from hxc_time_building_blocks.date_from%TYPE;
1909: l_date_to hxc_time_building_blocks.date_to%TYPE;
1910: l_person_id NUMBER (9);
1911: l_date_worked DATE;

Line 1908: l_date_from hxc_time_building_blocks.date_from%TYPE;

1904: l_resource_type VARCHAR2 (30);
1905: l_comment_text VARCHAR2 (2000);
1906: l_appr_status hxc_time_building_blocks.approval_status%TYPE;
1907: l_appr_style_id hxc_time_building_blocks.approval_style_id%TYPE;
1908: l_date_from hxc_time_building_blocks.date_from%TYPE;
1909: l_date_to hxc_time_building_blocks.date_to%TYPE;
1910: l_person_id NUMBER (9);
1911: l_date_worked DATE;
1912: l_effective_date DATE;

Line 1909: l_date_to hxc_time_building_blocks.date_to%TYPE;

1905: l_comment_text VARCHAR2 (2000);
1906: l_appr_status hxc_time_building_blocks.approval_status%TYPE;
1907: l_appr_style_id hxc_time_building_blocks.approval_style_id%TYPE;
1908: l_date_from hxc_time_building_blocks.date_from%TYPE;
1909: l_date_to hxc_time_building_blocks.date_to%TYPE;
1910: l_person_id NUMBER (9);
1911: l_date_worked DATE;
1912: l_effective_date DATE;
1913: l_assignment_id NUMBER (9);