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 39: FROM hxc_time_building_blocks tbb

35: -- 'Transfer Time from OTL to BEE' process not run yet.
36: CURSOR c_get_day_bb_id (l_parent_start_time DATE, l_resource_id NUMBER)
37: IS
38: SELECT tbb.time_building_block_id
39: FROM hxc_time_building_blocks tbb
40: WHERE tbb.parent_building_block_id IN (
41: SELECT time_building_block_id
42: FROM hxc_time_building_blocks tbb1
43: WHERE tbb1.resource_id = l_resource_id

Line 42: FROM hxc_time_building_blocks tbb1

38: SELECT tbb.time_building_block_id
39: FROM hxc_time_building_blocks tbb
40: WHERE tbb.parent_building_block_id IN (
41: SELECT time_building_block_id
42: FROM hxc_time_building_blocks tbb1
43: WHERE tbb1.resource_id = l_resource_id
44: AND tbb1.resource_type = 'PERSON'
45: AND tbb1.start_time = l_parent_start_time
46: AND tbb1.SCOPE = 'DAY')

Line 50: FROM hxc_time_building_blocks dyovn

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

Line 86: l_measure hxc_time_building_blocks.measure%TYPE;

82: l_check_bb_id NUMBER (15);
83: l_check_bb_ovn NUMBER (9);
84: l_parent_bb_ovn NUMBER (9);
85: l_type VARCHAR2 (30);
86: l_measure hxc_time_building_blocks.measure%TYPE;
87: l_start_time DATE;
88: l_parent_start_time DATE;
89: l_stop_time DATE;
90: l_date_to DATE;

Line 327: from hxc_time_building_blocks

323: l_parent_start_time := l_start_time;
324: END IF;
325:
326: /* select start_time into l_parent_start_time
327: from hxc_time_building_blocks
328: where time_building_block_id = l_parent_bb_id
329: and object_version_number = l_parent_bb_ovn; */
330: IF g_debug
331: THEN

Line 434: FROM hxc_time_building_blocks

430: -- in case user has replaced straight hours with start/stop time
431: BEGIN
432: SELECT count(*)
433: INTO l_measure_count
434: FROM hxc_time_building_blocks
435: WHERE time_building_block_id = l_day_bb_id
436: AND ((measure = 0) or (start_time is not null and stop_time is not null))
437: AND scope = 'DETAIL'
438: AND date_to = hr_general.end_of_time;

Line 597: l_measure hxc_time_building_blocks.measure%TYPE;

593: l_segment hxt_otc_retrieval_interface.t_segment;
594: l_bb_id NUMBER (15);
595: l_ovn NUMBER (9);
596: l_type VARCHAR2 (30);
597: l_measure hxc_time_building_blocks.measure%TYPE;
598: l_start_time DATE;
599: l_stop_time DATE;
600: l_date_to DATE;
601: l_parent_bb_id NUMBER (15);

Line 1855: l_measure hxc_time_building_blocks.measure%TYPE;

1851: l_segment hxt_otc_retrieval_interface.t_segment;
1852: l_bb_id NUMBER (15);
1853: l_bb_ovn NUMBER (15);
1854: l_type VARCHAR2 (30);
1855: l_measure hxc_time_building_blocks.measure%TYPE;
1856: l_uom hxc_time_building_blocks.unit_of_measure%TYPE;
1857: l_start_time DATE;
1858: l_stop_time DATE;
1859: l_parent_bb_id NUMBER (15);

Line 1856: l_uom hxc_time_building_blocks.unit_of_measure%TYPE;

1852: l_bb_id NUMBER (15);
1853: l_bb_ovn NUMBER (15);
1854: l_type VARCHAR2 (30);
1855: l_measure hxc_time_building_blocks.measure%TYPE;
1856: l_uom hxc_time_building_blocks.unit_of_measure%TYPE;
1857: l_start_time DATE;
1858: l_stop_time DATE;
1859: l_parent_bb_id NUMBER (15);
1860: l_parent_bb_ovn NUMBER (15);

Line 1866: l_appr_status hxc_time_building_blocks.approval_status%TYPE;

1862: l_scope VARCHAR2 (30);
1863: l_resource_id NUMBER (15);
1864: l_resource_type VARCHAR2 (30);
1865: l_comment_text VARCHAR2 (2000);
1866: l_appr_status hxc_time_building_blocks.approval_status%TYPE;
1867: l_appr_style_id hxc_time_building_blocks.approval_style_id%TYPE;
1868: l_date_from hxc_time_building_blocks.date_from%TYPE;
1869: l_date_to hxc_time_building_blocks.date_to%TYPE;
1870: l_person_id NUMBER (9);

Line 1867: l_appr_style_id hxc_time_building_blocks.approval_style_id%TYPE;

1863: l_resource_id NUMBER (15);
1864: l_resource_type VARCHAR2 (30);
1865: l_comment_text VARCHAR2 (2000);
1866: l_appr_status hxc_time_building_blocks.approval_status%TYPE;
1867: l_appr_style_id hxc_time_building_blocks.approval_style_id%TYPE;
1868: l_date_from hxc_time_building_blocks.date_from%TYPE;
1869: l_date_to hxc_time_building_blocks.date_to%TYPE;
1870: l_person_id NUMBER (9);
1871: l_date_worked DATE;

Line 1868: l_date_from hxc_time_building_blocks.date_from%TYPE;

1864: l_resource_type VARCHAR2 (30);
1865: l_comment_text VARCHAR2 (2000);
1866: l_appr_status hxc_time_building_blocks.approval_status%TYPE;
1867: l_appr_style_id hxc_time_building_blocks.approval_style_id%TYPE;
1868: l_date_from hxc_time_building_blocks.date_from%TYPE;
1869: l_date_to hxc_time_building_blocks.date_to%TYPE;
1870: l_person_id NUMBER (9);
1871: l_date_worked DATE;
1872: l_effective_date DATE;

Line 1869: l_date_to hxc_time_building_blocks.date_to%TYPE;

1865: l_comment_text VARCHAR2 (2000);
1866: l_appr_status hxc_time_building_blocks.approval_status%TYPE;
1867: l_appr_style_id hxc_time_building_blocks.approval_style_id%TYPE;
1868: l_date_from hxc_time_building_blocks.date_from%TYPE;
1869: l_date_to hxc_time_building_blocks.date_to%TYPE;
1870: l_person_id NUMBER (9);
1871: l_date_worked DATE;
1872: l_effective_date DATE;
1873: l_assignment_id NUMBER (9);