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 2384: hxc_time_building_blocks detail,

2380: SELECT DISTINCT detail.time_building_block_id bb_id
2381: from hxc_time_attributes ta,
2382: hxc_time_attribute_usages tau,
2383: hxc_latest_details tbb_latest,
2384: hxc_time_building_blocks detail,
2385: hxc_time_building_blocks day
2386: where day.parent_building_block_id = :p_tbb_id
2387: and day.parent_building_block_ovn = :p_tbb_ovn
2388: and detail.parent_building_block_id =

Line 2385: hxc_time_building_blocks day

2381: from hxc_time_attributes ta,
2382: hxc_time_attribute_usages tau,
2383: hxc_latest_details tbb_latest,
2384: hxc_time_building_blocks detail,
2385: hxc_time_building_blocks day
2386: where day.parent_building_block_id = :p_tbb_id
2387: and day.parent_building_block_ovn = :p_tbb_ovn
2388: and detail.parent_building_block_id =
2389: day.time_building_block_id

Line 3173: FROM hxc_time_building_blocks tbb

3169: l_select VARCHAR2(450) := '
3170: SELECT SUM( DECODE( tbb.type, ''RANGE'',
3171: (((tbb.stop_time)-(tbb.start_time))*24),
3172: NVL(tbb.measure, 0) )) hrs
3173: FROM hxc_time_building_blocks tbb
3174: , hxc_latest_details hld
3175: WHERE tbb.time_building_block_id = hld.time_building_block_id
3176: AND tbb.object_version_number = hld.object_version_number
3177: AND hld.time_building_block_id IN ( ';

Line 3272: FROM hxc_time_building_blocks tbb

3268: (DECODE( tbb.type, ''RANGE'',
3269: (((tbb.stop_time)-(tbb.start_time))*24),
3270: NVL(tbb.measure, 0) ))
3271: )) hrs
3272: FROM hxc_time_building_blocks tbb
3273: , hxc_latest_details hld
3274: WHERE tbb.time_building_block_id = hld.time_building_block_id
3275: AND tbb.object_version_number = hld.object_version_number
3276: AND hld.time_building_block_id IN ( ';

Line 3387: hxc_time_building_blocks detail,

3383: CURSOR csr_get_live_tbbs ( p_bb_id NUMBER, p_bb_ovn NUMBER ) IS
3384: SELECT detail.time_building_block_id bb_id,
3385: detail.scope
3386: FROM hxc_latest_details tbb_latest,
3387: hxc_time_building_blocks detail,
3388: hxc_time_building_blocks day
3389: where day.parent_building_block_id = p_bb_id
3390: and day.parent_building_block_ovn = p_bb_ovn
3391: and detail.parent_building_block_id =

Line 3388: hxc_time_building_blocks day

3384: SELECT detail.time_building_block_id bb_id,
3385: detail.scope
3386: FROM hxc_latest_details tbb_latest,
3387: hxc_time_building_blocks detail,
3388: hxc_time_building_blocks day
3389: where day.parent_building_block_id = p_bb_id
3390: and day.parent_building_block_ovn = p_bb_ovn
3391: and detail.parent_building_block_id =
3392: day.time_building_block_id

Line 4851: hxc_time_building_blocks detail,

4847: SELECT SUM( DECODE( detail.type, 'RANGE',
4848: (((detail.stop_time)-(detail.start_time))*24),
4849: NVL(detail.measure, 0) )) hrs
4850: FROM hxc_latest_details tbb_latest,
4851: hxc_time_building_blocks detail,
4852: hxc_time_building_blocks day
4853: where day.parent_building_block_id = p_tbb_id
4854: and day.parent_building_block_ovn = p_tbb_ovn
4855: and detail.parent_building_block_id =

Line 4852: hxc_time_building_blocks day

4848: (((detail.stop_time)-(detail.start_time))*24),
4849: NVL(detail.measure, 0) )) hrs
4850: FROM hxc_latest_details tbb_latest,
4851: hxc_time_building_blocks detail,
4852: hxc_time_building_blocks day
4853: where day.parent_building_block_id = p_tbb_id
4854: and day.parent_building_block_ovn = p_tbb_ovn
4855: and detail.parent_building_block_id =
4856: day.time_building_block_id

Line 4944: hxc_time_building_blocks detail,

4940: SELECT DECODE( detail.type, 'RANGE',
4941: nvl((((detail.stop_time)-(detail.start_time))*24),0),
4942: NVL(detail.measure, 0) ) hrs
4943: FROM hxc_latest_details tbb_latest,
4944: hxc_time_building_blocks detail,
4945: hxc_time_building_blocks day
4946: where day.parent_building_block_id = p_tbb_id
4947: and day.parent_building_block_ovn = p_tbb_ovn
4948: and detail.parent_building_block_id =

Line 4945: hxc_time_building_blocks day

4941: nvl((((detail.stop_time)-(detail.start_time))*24),0),
4942: NVL(detail.measure, 0) ) hrs
4943: FROM hxc_latest_details tbb_latest,
4944: hxc_time_building_blocks detail,
4945: hxc_time_building_blocks day
4946: where day.parent_building_block_id = p_tbb_id
4947: and day.parent_building_block_ovn = p_tbb_ovn
4948: and detail.parent_building_block_id =
4949: day.time_building_block_id

Line 4957: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,

4953: and tbb_latest.object_version_number = detail.object_version_number
4954: and detail.date_to = hr_general.end_of_time;
4955:
4956: CURSOR c_tc_resource_id(
4957: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4958: p_tbb_ovn hxc_time_building_blocks.object_version_number%TYPE
4959: )IS
4960: SELECT tbb.resource_id
4961: FROM hxc_time_building_blocks tbb

Line 4958: p_tbb_ovn hxc_time_building_blocks.object_version_number%TYPE

4954: and detail.date_to = hr_general.end_of_time;
4955:
4956: CURSOR c_tc_resource_id(
4957: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4958: p_tbb_ovn hxc_time_building_blocks.object_version_number%TYPE
4959: )IS
4960: SELECT tbb.resource_id
4961: FROM hxc_time_building_blocks tbb
4962: WHERE tbb.time_building_block_id = p_tc_bbid

Line 4961: FROM hxc_time_building_blocks tbb

4957: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4958: p_tbb_ovn hxc_time_building_blocks.object_version_number%TYPE
4959: )IS
4960: SELECT tbb.resource_id
4961: FROM hxc_time_building_blocks tbb
4962: WHERE tbb.time_building_block_id = p_tc_bbid
4963: AND tbb.object_version_number = p_tbb_ovn;
4964:
4965: /* Bug fix for 5526281 */

Line 4967: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,

4963: AND tbb.object_version_number = p_tbb_ovn;
4964:
4965: /* Bug fix for 5526281 */
4966: CURSOR get_timecard_start_date(
4967: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4968: p_tc_ovnid hxc_time_building_blocks.object_version_number%TYPE
4969: ) IS
4970: SELECT tbb.start_time,tbb.stop_time
4971: FROM hxc_time_building_blocks tbb

Line 4968: p_tc_ovnid hxc_time_building_blocks.object_version_number%TYPE

4964:
4965: /* Bug fix for 5526281 */
4966: CURSOR get_timecard_start_date(
4967: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4968: p_tc_ovnid hxc_time_building_blocks.object_version_number%TYPE
4969: ) IS
4970: SELECT tbb.start_time,tbb.stop_time
4971: FROM hxc_time_building_blocks tbb
4972: WHERE tbb.time_building_block_id = p_tc_bbid

Line 4971: FROM hxc_time_building_blocks tbb

4967: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4968: p_tc_ovnid hxc_time_building_blocks.object_version_number%TYPE
4969: ) IS
4970: SELECT tbb.start_time,tbb.stop_time
4971: FROM hxc_time_building_blocks tbb
4972: WHERE tbb.time_building_block_id = p_tc_bbid
4973: AND tbb.object_version_number = p_tc_ovnid;
4974:
4975: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS

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

4971: FROM hxc_time_building_blocks tbb
4972: WHERE tbb.time_building_block_id = p_tc_bbid
4973: AND tbb.object_version_number = p_tc_ovnid;
4974:
4975: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
4976: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
4977: /* end of bug fix for 5526281 */
4978:
4979: l_timecard_hrs NUMBER := 0;

Line 5174: hxc_time_building_blocks tbb

5170: SELECT
5171: SUM(NVL(tbb.measure,0) +
5172: ((( NVL(tbb.stop_time,sysdate) - NVL(tbb.start_time,sysdate))*24)))
5173: FROM
5174: hxc_time_building_blocks tbb
5175: WHERE
5176: tbb.time_building_block_id = p_tbb_id AND
5177: tbb.object_version_number = p_tbb_ovn;
5178: