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_TIME_CATEGORY_UTILS_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 31: TYPE rec_time_category_bb_ok_cache IS RECORD ( timecard_id hxc_time_building_blocks.time_building_block_id%TYPE

27: TYPE tab_time_category_component IS TABLE OF rec_time_category_component INDEX BY BINARY_INTEGER;
28:
29: g_tc_component_cache tab_time_category_component;
30:
31: TYPE rec_time_category_bb_ok_cache IS RECORD ( timecard_id hxc_time_building_blocks.time_building_block_id%TYPE
32: ,attribute_count NUMBER
33: ,bb_ok_string VARCHAR2(32000) );
34:
35: TYPE tab_time_category_bb_ok_cache IS TABLE OF rec_time_category_bb_ok_cache INDEX BY BINARY_INTEGER;

Line 41: TYPE tab_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;

37: g_tc_bb_ok_cache tab_time_category_bb_ok_cache;
38:
39: -- bld blk types
40:
41: TYPE tab_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
42: TYPE tab_measure IS TABLE OF hxc_time_building_blocks.measure%TYPE INDEX BY BINARY_INTEGER;
43: TYPE tab_type IS TABLE OF hxc_time_building_blocks.type%TYPE INDEX BY BINARY_INTEGER;
44: TYPE tab_start_time IS TABLE OF DATE INDEX BY BINARY_INTEGER;
45: TYPE tab_stop_time IS TABLE OF DATE INDEX BY BINARY_INTEGER;

Line 42: TYPE tab_measure IS TABLE OF hxc_time_building_blocks.measure%TYPE INDEX BY BINARY_INTEGER;

38:
39: -- bld blk types
40:
41: TYPE tab_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
42: TYPE tab_measure IS TABLE OF hxc_time_building_blocks.measure%TYPE INDEX BY BINARY_INTEGER;
43: TYPE tab_type IS TABLE OF hxc_time_building_blocks.type%TYPE INDEX BY BINARY_INTEGER;
44: TYPE tab_start_time IS TABLE OF DATE INDEX BY BINARY_INTEGER;
45: TYPE tab_stop_time IS TABLE OF DATE INDEX BY BINARY_INTEGER;
46: TYPE tab_scope IS TABLE OF hxc_time_building_blocks.scope%TYPE INDEX BY BINARY_INTEGER;

Line 43: TYPE tab_type IS TABLE OF hxc_time_building_blocks.type%TYPE INDEX BY BINARY_INTEGER;

39: -- bld blk types
40:
41: TYPE tab_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
42: TYPE tab_measure IS TABLE OF hxc_time_building_blocks.measure%TYPE INDEX BY BINARY_INTEGER;
43: TYPE tab_type IS TABLE OF hxc_time_building_blocks.type%TYPE INDEX BY BINARY_INTEGER;
44: TYPE tab_start_time IS TABLE OF DATE INDEX BY BINARY_INTEGER;
45: TYPE tab_stop_time IS TABLE OF DATE INDEX BY BINARY_INTEGER;
46: TYPE tab_scope IS TABLE OF hxc_time_building_blocks.scope%TYPE INDEX BY BINARY_INTEGER;
47: TYPE tab_comment_text IS TABLE OF hxc_time_building_blocks.comment_text%TYPE INDEX BY BINARY_INTEGER;

Line 46: TYPE tab_scope IS TABLE OF hxc_time_building_blocks.scope%TYPE INDEX BY BINARY_INTEGER;

42: TYPE tab_measure IS TABLE OF hxc_time_building_blocks.measure%TYPE INDEX BY BINARY_INTEGER;
43: TYPE tab_type IS TABLE OF hxc_time_building_blocks.type%TYPE INDEX BY BINARY_INTEGER;
44: TYPE tab_start_time IS TABLE OF DATE INDEX BY BINARY_INTEGER;
45: TYPE tab_stop_time IS TABLE OF DATE INDEX BY BINARY_INTEGER;
46: TYPE tab_scope IS TABLE OF hxc_time_building_blocks.scope%TYPE INDEX BY BINARY_INTEGER;
47: TYPE tab_comment_text IS TABLE OF hxc_time_building_blocks.comment_text%TYPE INDEX BY BINARY_INTEGER;
48:
49: -- attribute types
50:

Line 47: TYPE tab_comment_text IS TABLE OF hxc_time_building_blocks.comment_text%TYPE INDEX BY BINARY_INTEGER;

43: TYPE tab_type IS TABLE OF hxc_time_building_blocks.type%TYPE INDEX BY BINARY_INTEGER;
44: TYPE tab_start_time IS TABLE OF DATE INDEX BY BINARY_INTEGER;
45: TYPE tab_stop_time IS TABLE OF DATE INDEX BY BINARY_INTEGER;
46: TYPE tab_scope IS TABLE OF hxc_time_building_blocks.scope%TYPE INDEX BY BINARY_INTEGER;
47: TYPE tab_comment_text IS TABLE OF hxc_time_building_blocks.comment_text%TYPE INDEX BY BINARY_INTEGER;
48:
49: -- attribute types
50:
51: TYPE tab_time_attribute_id IS TABLE OF hxc_time_attributes.time_attribute_id%TYPE INDEX BY BINARY_INTEGER;

Line 62: , p_tbb_id hxc_time_building_blocks.time_building_block_id%TYPE

58: , p_use_tc_cache BOOLEAN
59: , p_use_tc_bb_cache BOOLEAN
60: , p_use_temp_table BOOLEAN
61: , p_scope VARCHAR2(10)
62: , p_tbb_id hxc_time_building_blocks.time_building_block_id%TYPE
63: , p_tbb_ovn hxc_time_building_blocks.object_version_number%TYPE );
64:
65: g_params eval_time_category_params;
66:

Line 63: , p_tbb_ovn hxc_time_building_blocks.object_version_number%TYPE );

59: , p_use_tc_bb_cache BOOLEAN
60: , p_use_temp_table BOOLEAN
61: , p_scope VARCHAR2(10)
62: , p_tbb_id hxc_time_building_blocks.time_building_block_id%TYPE
63: , p_tbb_ovn hxc_time_building_blocks.object_version_number%TYPE );
64:
65: g_params eval_time_category_params;
66:
67: /* Bug 5076837 used to store the time_categories along with the category component status

Line 2363: hxc_time_building_blocks detail,

2359: SELECT DISTINCT detail.time_building_block_id bb_id
2360: from hxc_time_attributes ta,
2361: hxc_time_attribute_usages tau,
2362: hxc_latest_details tbb_latest,
2363: hxc_time_building_blocks detail,
2364: hxc_time_building_blocks day
2365: where day.parent_building_block_id = :p_tbb_id
2366: and day.parent_building_block_ovn = :p_tbb_ovn
2367: and detail.parent_building_block_id =

Line 2364: hxc_time_building_blocks day

2360: from hxc_time_attributes ta,
2361: hxc_time_attribute_usages tau,
2362: hxc_latest_details tbb_latest,
2363: hxc_time_building_blocks detail,
2364: hxc_time_building_blocks day
2365: where day.parent_building_block_id = :p_tbb_id
2366: and day.parent_building_block_ovn = :p_tbb_ovn
2367: and detail.parent_building_block_id =
2368: day.time_building_block_id

Line 3056: FROM hxc_time_building_blocks tbb

3052: l_select VARCHAR2(450) := '
3053: SELECT SUM( DECODE( tbb.type, ''RANGE'',
3054: (((tbb.stop_time)-(tbb.start_time))*24),
3055: NVL(tbb.measure, 0) )) hrs
3056: FROM hxc_time_building_blocks tbb
3057: , hxc_latest_details hld
3058: WHERE tbb.time_building_block_id = hld.time_building_block_id
3059: AND tbb.object_version_number = hld.object_version_number
3060: AND hld.time_building_block_id IN ( ';

Line 3155: FROM hxc_time_building_blocks tbb

3151: (DECODE( tbb.type, ''RANGE'',
3152: (((tbb.stop_time)-(tbb.start_time))*24),
3153: NVL(tbb.measure, 0) ))
3154: )) hrs
3155: FROM hxc_time_building_blocks tbb
3156: , hxc_latest_details hld
3157: WHERE tbb.time_building_block_id = hld.time_building_block_id
3158: AND tbb.object_version_number = hld.object_version_number
3159: AND hld.time_building_block_id IN ( ';

Line 3270: hxc_time_building_blocks detail,

3266: CURSOR csr_get_live_tbbs ( p_bb_id NUMBER, p_bb_ovn NUMBER ) IS
3267: SELECT detail.time_building_block_id bb_id,
3268: detail.scope
3269: FROM hxc_latest_details tbb_latest,
3270: hxc_time_building_blocks detail,
3271: hxc_time_building_blocks day
3272: where day.parent_building_block_id = p_bb_id
3273: and day.parent_building_block_ovn = p_bb_ovn
3274: and detail.parent_building_block_id =

Line 3271: hxc_time_building_blocks day

3267: SELECT detail.time_building_block_id bb_id,
3268: detail.scope
3269: FROM hxc_latest_details tbb_latest,
3270: hxc_time_building_blocks detail,
3271: hxc_time_building_blocks day
3272: where day.parent_building_block_id = p_bb_id
3273: and day.parent_building_block_ovn = p_bb_ovn
3274: and detail.parent_building_block_id =
3275: day.time_building_block_id

Line 4734: hxc_time_building_blocks detail,

4730: SELECT SUM( DECODE( detail.type, 'RANGE',
4731: (((detail.stop_time)-(detail.start_time))*24),
4732: NVL(detail.measure, 0) )) hrs
4733: FROM hxc_latest_details tbb_latest,
4734: hxc_time_building_blocks detail,
4735: hxc_time_building_blocks day
4736: where day.parent_building_block_id = p_tbb_id
4737: and day.parent_building_block_ovn = p_tbb_ovn
4738: and detail.parent_building_block_id =

Line 4735: hxc_time_building_blocks day

4731: (((detail.stop_time)-(detail.start_time))*24),
4732: NVL(detail.measure, 0) )) hrs
4733: FROM hxc_latest_details tbb_latest,
4734: hxc_time_building_blocks detail,
4735: hxc_time_building_blocks day
4736: where day.parent_building_block_id = p_tbb_id
4737: and day.parent_building_block_ovn = p_tbb_ovn
4738: and detail.parent_building_block_id =
4739: day.time_building_block_id

Line 4827: hxc_time_building_blocks detail,

4823: SELECT DECODE( detail.type, 'RANGE',
4824: nvl((((detail.stop_time)-(detail.start_time))*24),0),
4825: NVL(detail.measure, 0) ) hrs
4826: FROM hxc_latest_details tbb_latest,
4827: hxc_time_building_blocks detail,
4828: hxc_time_building_blocks day
4829: where day.parent_building_block_id = p_tbb_id
4830: and day.parent_building_block_ovn = p_tbb_ovn
4831: and detail.parent_building_block_id =

Line 4828: hxc_time_building_blocks day

4824: nvl((((detail.stop_time)-(detail.start_time))*24),0),
4825: NVL(detail.measure, 0) ) hrs
4826: FROM hxc_latest_details tbb_latest,
4827: hxc_time_building_blocks detail,
4828: hxc_time_building_blocks day
4829: where day.parent_building_block_id = p_tbb_id
4830: and day.parent_building_block_ovn = p_tbb_ovn
4831: and detail.parent_building_block_id =
4832: day.time_building_block_id

Line 4840: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,

4836: and tbb_latest.object_version_number = detail.object_version_number
4837: and detail.date_to = hr_general.end_of_time;
4838:
4839: CURSOR c_tc_resource_id(
4840: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4841: p_tbb_ovn hxc_time_building_blocks.object_version_number%TYPE
4842: )IS
4843: SELECT tbb.resource_id
4844: FROM hxc_time_building_blocks tbb

Line 4841: p_tbb_ovn hxc_time_building_blocks.object_version_number%TYPE

4837: and detail.date_to = hr_general.end_of_time;
4838:
4839: CURSOR c_tc_resource_id(
4840: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4841: p_tbb_ovn hxc_time_building_blocks.object_version_number%TYPE
4842: )IS
4843: SELECT tbb.resource_id
4844: FROM hxc_time_building_blocks tbb
4845: WHERE tbb.time_building_block_id = p_tc_bbid

Line 4844: FROM hxc_time_building_blocks tbb

4840: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4841: p_tbb_ovn hxc_time_building_blocks.object_version_number%TYPE
4842: )IS
4843: SELECT tbb.resource_id
4844: FROM hxc_time_building_blocks tbb
4845: WHERE tbb.time_building_block_id = p_tc_bbid
4846: AND tbb.object_version_number = p_tbb_ovn;
4847:
4848: /* Bug fix for 5526281 */

Line 4850: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,

4846: AND tbb.object_version_number = p_tbb_ovn;
4847:
4848: /* Bug fix for 5526281 */
4849: CURSOR get_timecard_start_date(
4850: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4851: p_tc_ovnid hxc_time_building_blocks.object_version_number%TYPE
4852: ) IS
4853: SELECT tbb.start_time,tbb.stop_time
4854: FROM hxc_time_building_blocks tbb

Line 4851: p_tc_ovnid hxc_time_building_blocks.object_version_number%TYPE

4847:
4848: /* Bug fix for 5526281 */
4849: CURSOR get_timecard_start_date(
4850: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4851: p_tc_ovnid hxc_time_building_blocks.object_version_number%TYPE
4852: ) IS
4853: SELECT tbb.start_time,tbb.stop_time
4854: FROM hxc_time_building_blocks tbb
4855: WHERE tbb.time_building_block_id = p_tc_bbid

Line 4854: FROM hxc_time_building_blocks tbb

4850: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4851: p_tc_ovnid hxc_time_building_blocks.object_version_number%TYPE
4852: ) IS
4853: SELECT tbb.start_time,tbb.stop_time
4854: FROM hxc_time_building_blocks tbb
4855: WHERE tbb.time_building_block_id = p_tc_bbid
4856: AND tbb.object_version_number = p_tc_ovnid;
4857:
4858: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS

Line 4858: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS

4854: FROM hxc_time_building_blocks tbb
4855: WHERE tbb.time_building_block_id = p_tc_bbid
4856: AND tbb.object_version_number = p_tc_ovnid;
4857:
4858: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
4859: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
4860: /* end of bug fix for 5526281 */
4861:
4862: l_timecard_hrs NUMBER := 0;

Line 5057: hxc_time_building_blocks tbb

5053: SELECT
5054: SUM(NVL(tbb.measure,0) +
5055: ((( NVL(tbb.stop_time,sysdate) - NVL(tbb.start_time,sysdate))*24)))
5056: FROM
5057: hxc_time_building_blocks tbb
5058: WHERE
5059: tbb.time_building_block_id = p_tbb_id AND
5060: tbb.object_version_number = p_tbb_ovn;
5061: