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

Line 24: p_application_set_id IN hxc_time_building_blocks.application_set_id%type,

20: p_resource_id IN NUMBER,
21: p_changed IN VARCHAR2,
22: p_comment_text IN VARCHAR2,
23: p_submit_flg IN BOOLEAN,
24: p_application_set_id IN hxc_time_building_blocks.application_set_id%type,
25: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info
26: ) IS
27: l_type hxc_time_building_blocks.TYPE%TYPE;
28: l_parent_is_new VARCHAR2 (1);

Line 27: l_type hxc_time_building_blocks.TYPE%TYPE;

23: p_submit_flg IN BOOLEAN,
24: p_application_set_id IN hxc_time_building_blocks.application_set_id%type,
25: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info
26: ) IS
27: l_type hxc_time_building_blocks.TYPE%TYPE;
28: l_parent_is_new VARCHAR2 (1);
29: l_approval_status hxc_time_building_blocks.approval_status%TYPE;
30: l_new VARCHAR2 (1);
31: l_block_index NUMBER

Line 29: l_approval_status hxc_time_building_blocks.approval_status%TYPE;

25: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info
26: ) IS
27: l_type hxc_time_building_blocks.TYPE%TYPE;
28: l_parent_is_new VARCHAR2 (1);
29: l_approval_status hxc_time_building_blocks.approval_status%TYPE;
30: l_new VARCHAR2 (1);
31: l_block_index NUMBER
32: /*ADVICE(99): NUMBER has no precision [315] */
33: := 0;

Line 38: l_application_set_id HXC_TIME_BUILDING_BLOCKS.APPLICATION_SET_ID%TYPE;

34: l_date_from VARCHAR2 (50);
35: l_date_to VARCHAR2 (50);
36:
37: l_changed VARCHAR2(1);
38: l_application_set_id HXC_TIME_BUILDING_BLOCKS.APPLICATION_SET_ID%TYPE;
39: cursor c_app_set_id(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
40: p_ovn in hxc_time_building_blocks.object_version_number%type)
41: is
42: select

Line 39: cursor c_app_set_id(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,

35: l_date_to VARCHAR2 (50);
36:
37: l_changed VARCHAR2(1);
38: l_application_set_id HXC_TIME_BUILDING_BLOCKS.APPLICATION_SET_ID%TYPE;
39: cursor c_app_set_id(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
40: p_ovn in hxc_time_building_blocks.object_version_number%type)
41: is
42: select
43: application_set_id

Line 40: p_ovn in hxc_time_building_blocks.object_version_number%type)

36:
37: l_changed VARCHAR2(1);
38: l_application_set_id HXC_TIME_BUILDING_BLOCKS.APPLICATION_SET_ID%TYPE;
39: cursor c_app_set_id(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
40: p_ovn in hxc_time_building_blocks.object_version_number%type)
41: is
42: select
43: application_set_id
44: from

Line 45: hxc_time_building_blocks

41: is
42: select
43: application_set_id
44: from
45: hxc_time_building_blocks
46: where
47: time_building_block_id = p_timecard_id
48: and
49: object_version_number=p_ovn;

Line 273: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY

269: WHERE a.time_attribute_id = au.time_attribute_id
270: AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
271: AND (au.time_building_block_id, au.time_building_block_ovn) IN
272: (SELECT detail.time_building_block_id, detail.object_version_number
273: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
274: WHERE DAY.time_building_block_id = detail.parent_building_block_id
275: AND DAY.object_version_number = detail.parent_building_block_ovn
276: AND DAY.SCOPE = 'DAY'
277: AND detail.resource_id = l_resource_id

Line 297: FROM hxc_time_building_blocks DAY

293: WHERE a.time_attribute_id = au.time_attribute_id
294: AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
295: AND (au.time_building_block_id, au.time_building_block_ovn) IN
296: (SELECT DAY.time_building_block_id, DAY.object_version_number
297: FROM hxc_time_building_blocks DAY
298: WHERE DAY.date_to = hr_general.end_of_time
299: AND DAY.SCOPE = 'DAY'
300: AND DAY.parent_building_block_id = timecard_id
301: AND DAY.parent_building_block_ovn = timecard_ovn

Line 316: FROM hxc_time_building_blocks htbb

312: WHERE a.time_attribute_id = au.time_attribute_id
313: AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
314: AND (au.time_building_block_id, au.time_building_block_ovn) IN
315: (SELECT time_building_block_id, object_version_number
316: FROM hxc_time_building_blocks htbb
317: WHERE htbb.date_to = hr_general.end_of_time
318: AND htbb.SCOPE = 'TIMECARD'
319: AND htbb.time_building_block_id = timecard_id
320: AND htbb.object_version_number = timecard_ovn

Line 839: FROM hxc_time_building_blocks

835: p_tc_frdt DATE,
836: p_tc_todt DATE
837: ) IS
838: SELECT time_building_block_id tbbid, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')
839: FROM hxc_time_building_blocks
840: WHERE resource_id
841: /*ADVICE(829): Cursor references an external variable (use a parameter) [209] */
842: = p_resource_id
843: AND SCOPE = 'TIMECARD'

Line 849: FROM hxc_time_building_blocks

845: AND TO_DATE (p_tc_frdt, 'dd-mm-rrrr') BETWEEN TO_DATE (start_time, 'dd-mm-rrrr')
846: AND TO_DATE (stop_time, 'dd-mm-rrrr')
847: UNION
848: SELECT time_building_block_id, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')
849: FROM hxc_time_building_blocks
850: WHERE resource_id
851: /*ADVICE(839): Cursor references an external variable (use a parameter) [209] */
852: = p_resource_id
853: AND SCOPE = 'TIMECARD'

Line 859: FROM hxc_time_building_blocks

855: AND TO_DATE (p_tc_todt, 'dd-mm-rrrr') BETWEEN TO_DATE (start_time, 'dd-mm-rrrr')
856: AND TO_DATE (stop_time, 'dd-mm-rrrr')
857: UNION
858: SELECT time_building_block_id, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')
859: FROM hxc_time_building_blocks
860: WHERE resource_id
861: /*ADVICE(849): Cursor references an external variable (use a parameter) [209] */
862: = p_resource_id
863: AND SCOPE = 'TIMECARD'

Line 869: FROM hxc_time_building_blocks

865: AND TO_DATE (start_time, 'dd-mm-rrrr') >= TO_DATE (p_tc_frdt, 'dd-mm-rrrr')
866: AND TO_DATE (stop_time, 'dd-mm-rrrr') <= TO_DATE (p_tc_todt, 'dd-mm-rrrr')
867: MINUS
868: SELECT time_building_block_id, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')
869: FROM hxc_time_building_blocks
870: WHERE resource_id
871: /*ADVICE(859): Cursor references an external variable (use a parameter) [209] */
872: = p_resource_id
873: AND SCOPE = 'TIMECARD'

Line 919: from hxc_time_building_blocks

915: p_tc_todt DATE
916: ) IS
917: /*
918: select start_time,stop_time,to_date(start_time)
919: from hxc_time_building_blocks
920: where resource_id = p_resource_id
921: and scope='TIMECARD'
922: and date_to=hr_general.end_of_time
923: and to_date(start_time,'dd-mm-rrrr') >=to_date(p_tc_frdt,'dd-mm-rrrr') and

Line 932: FROM hxc_time_building_blocks

928: order by 3;
929: */
930: SELECT TO_DATE (start_time, 'dd-mm-rrrr hh24:mi:ss') start_time,
931: TO_DATE (stop_time, 'dd-mm-rrrr hh24:mi:ss') stop_time, TO_DATE (start_time, 'dd-mm-rrrr') orddt
932: FROM hxc_time_building_blocks
933: WHERE resource_id
934: /*ADVICE(922): Cursor references an external variable (use a parameter) [209] */
935: = p_resource_id
936: AND SCOPE = 'TIMECARD'

Line 1523: FROM hxc_time_building_blocks

1519: p_first_start_date IN DATE,
1520: p_last_end_date IN DATE
1521: ) IS
1522: SELECT TRUNC (start_time), TRUNC (stop_time)
1523: FROM hxc_time_building_blocks
1524: WHERE SCOPE = 'TIMECARD'
1525: AND date_to = hr_general.end_of_time
1526: AND resource_id = p_resource_id
1527: AND resource_type = p_resource_type

Line 1638: FROM hxc_time_building_blocks

1634: p_resource_id IN NUMBER,
1635: p_terminate_date IN DATE
1636: ) IS
1637: SELECT count(*)
1638: FROM hxc_time_building_blocks
1639: WHERE SCOPE = 'TIMECARD'
1640: AND (date_to = hr_general.end_of_time or APPROVAL_STATUS='ERROR')
1641: AND resource_id = p_resource_id
1642: AND p_terminate_date between start_time and stop_time;

Line 2050: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE

2046: END IF;
2047: END get_resource_time_periods;
2048:
2049: PROCEDURE tc_edit_allowed (
2050: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE
2051: /*ADVICE(1568): Mode of parameter is not specified with IN parameter [521] */
2052: ,
2053: p_timecard_ovn
2054: /*ADVICE(1571): Unreferenced parameter [552] */

Line 2055: hxc_time_building_blocks.object_version_number%TYPE

2051: /*ADVICE(1568): Mode of parameter is not specified with IN parameter [521] */
2052: ,
2053: p_timecard_ovn
2054: /*ADVICE(1571): Unreferenced parameter [552] */
2055: hxc_time_building_blocks.object_version_number%TYPE
2056: /*ADVICE(1573): Mode of parameter is not specified with IN parameter [521] */
2057: ,
2058: p_timecard_status VARCHAR2
2059: /*ADVICE(1576): Mode of parameter is not specified with IN parameter [521] */

Line 2081: l_tc_status hxc_time_building_blocks.approval_status%TYPE;

2077:
2078: l_proc
2079: /*ADVICE(1596): Unreferenced variable [553] */
2080: VARCHAR2 (72);
2081: l_tc_status hxc_time_building_blocks.approval_status%TYPE;
2082: l_dummy NUMBER (1);
2083: BEGIN
2084: g_debug :=hr_utility.debug_enabled;
2085: if g_debug then

Line 2267: p_detail_id IN OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

2263: PROCEDURE manage_timeinfo (
2264: p_day_counter IN NUMBER,
2265: p_insert_detail IN hxc_timekeeper_process.t_time_info,
2266: p_measure IN OUT NOCOPY NUMBER,
2267: p_detail_id IN OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2268: p_detail_ovn IN OUT NOCOPY NUMBER,
2269: p_detail_time_in IN OUT NOCOPY DATE,
2270: p_detail_time_out IN OUT NOCOPY DATE
2271: ) IS

Line 2466: p_detail_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

2462: END IF;
2463: END;
2464:
2465: PROCEDURE manage_detaildffinfo (
2466: p_detail_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2467: p_detail_ovn IN NUMBER,
2468: p_det_details IN OUT NOCOPY hxc_timekeeper_process.g_detail_data%TYPE,
2469: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
2470: p_attribute_category IN VARCHAR2,

Line 3639: FROM hxc_time_building_blocks

3635: p_tc_frdt DATE,
3636: p_tc_todt DATE
3637: ) IS
3638: SELECT time_building_block_id tbbid, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')
3639: FROM hxc_time_building_blocks
3640: WHERE resource_id
3641: /*ADVICE(3110): Cursor references an external variable (use a parameter) [209] */
3642: = p_resource_id
3643: AND SCOPE = 'TIMECARD'