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 291: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY

287: WHERE a.time_attribute_id = au.time_attribute_id
288: AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
289: AND (au.time_building_block_id, au.time_building_block_ovn) IN
290: (SELECT detail.time_building_block_id, detail.object_version_number
291: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
292: WHERE DAY.time_building_block_id = detail.parent_building_block_id
293: AND DAY.object_version_number = detail.parent_building_block_ovn
294: AND DAY.SCOPE = 'DAY'
295: AND detail.resource_id = l_resource_id

Line 315: FROM hxc_time_building_blocks DAY

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

Line 334: FROM hxc_time_building_blocks htbb

330: WHERE a.time_attribute_id = au.time_attribute_id
331: AND a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
332: AND (au.time_building_block_id, au.time_building_block_ovn) IN
333: (SELECT time_building_block_id, object_version_number
334: FROM hxc_time_building_blocks htbb
335: WHERE htbb.date_to = hr_general.end_of_time
336: AND htbb.SCOPE = 'TIMECARD'
337: AND htbb.time_building_block_id = timecard_id
338: AND htbb.object_version_number = timecard_ovn

Line 857: FROM hxc_time_building_blocks

853: p_tc_frdt DATE,
854: p_tc_todt DATE
855: ) IS
856: SELECT time_building_block_id tbbid, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')
857: FROM hxc_time_building_blocks
858: WHERE resource_id
859: /*ADVICE(829): Cursor references an external variable (use a parameter) [209] */
860: = p_resource_id
861: AND SCOPE = 'TIMECARD'

Line 867: FROM hxc_time_building_blocks

863: AND TO_DATE (p_tc_frdt, 'dd-mm-rrrr') BETWEEN TO_DATE (start_time, 'dd-mm-rrrr')
864: AND TO_DATE (stop_time, 'dd-mm-rrrr')
865: UNION
866: SELECT time_building_block_id, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')
867: FROM hxc_time_building_blocks
868: WHERE resource_id
869: /*ADVICE(839): Cursor references an external variable (use a parameter) [209] */
870: = p_resource_id
871: AND SCOPE = 'TIMECARD'

Line 877: FROM hxc_time_building_blocks

873: AND TO_DATE (p_tc_todt, 'dd-mm-rrrr') BETWEEN TO_DATE (start_time, 'dd-mm-rrrr')
874: AND TO_DATE (stop_time, 'dd-mm-rrrr')
875: UNION
876: SELECT time_building_block_id, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')
877: FROM hxc_time_building_blocks
878: WHERE resource_id
879: /*ADVICE(849): Cursor references an external variable (use a parameter) [209] */
880: = p_resource_id
881: AND SCOPE = 'TIMECARD'

Line 887: FROM hxc_time_building_blocks

883: AND TO_DATE (start_time, 'dd-mm-rrrr') >= TO_DATE (p_tc_frdt, 'dd-mm-rrrr')
884: AND TO_DATE (stop_time, 'dd-mm-rrrr') <= TO_DATE (p_tc_todt, 'dd-mm-rrrr')
885: MINUS
886: SELECT time_building_block_id, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')
887: FROM hxc_time_building_blocks
888: WHERE resource_id
889: /*ADVICE(859): Cursor references an external variable (use a parameter) [209] */
890: = p_resource_id
891: AND SCOPE = 'TIMECARD'

Line 937: from hxc_time_building_blocks

933: p_tc_todt DATE
934: ) IS
935: /*
936: select start_time,stop_time,to_date(start_time)
937: from hxc_time_building_blocks
938: where resource_id = p_resource_id
939: and scope='TIMECARD'
940: and date_to=hr_general.end_of_time
941: and to_date(start_time,'dd-mm-rrrr') >=to_date(p_tc_frdt,'dd-mm-rrrr') and

Line 950: FROM hxc_time_building_blocks

946: order by 3;
947: */
948: SELECT TO_DATE (start_time, 'dd-mm-rrrr hh24:mi:ss') start_time,
949: TO_DATE (stop_time, 'dd-mm-rrrr hh24:mi:ss') stop_time, TO_DATE (start_time, 'dd-mm-rrrr') orddt
950: FROM hxc_time_building_blocks
951: WHERE resource_id
952: /*ADVICE(922): Cursor references an external variable (use a parameter) [209] */
953: = p_resource_id
954: AND SCOPE = 'TIMECARD'

Line 1541: FROM hxc_time_building_blocks

1537: p_first_start_date IN DATE,
1538: p_last_end_date IN DATE
1539: ) IS
1540: SELECT TRUNC (start_time), TRUNC (stop_time)
1541: FROM hxc_time_building_blocks
1542: WHERE SCOPE = 'TIMECARD'
1543: AND date_to = hr_general.end_of_time
1544: AND resource_id = p_resource_id
1545: AND resource_type = p_resource_type

Line 1656: FROM hxc_time_building_blocks

1652: p_resource_id IN NUMBER,
1653: p_terminate_date IN DATE
1654: ) IS
1655: SELECT count(*)
1656: FROM hxc_time_building_blocks
1657: WHERE SCOPE = 'TIMECARD'
1658: AND (date_to = hr_general.end_of_time or APPROVAL_STATUS='ERROR')
1659: AND resource_id = p_resource_id
1660: AND p_terminate_date between start_time and stop_time;

Line 2068: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE

2064: END IF;
2065: END get_resource_time_periods;
2066:
2067: PROCEDURE tc_edit_allowed (
2068: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE
2069: /*ADVICE(1568): Mode of parameter is not specified with IN parameter [521] */
2070: ,
2071: p_timecard_ovn
2072: /*ADVICE(1571): Unreferenced parameter [552] */

Line 2073: hxc_time_building_blocks.object_version_number%TYPE

2069: /*ADVICE(1568): Mode of parameter is not specified with IN parameter [521] */
2070: ,
2071: p_timecard_ovn
2072: /*ADVICE(1571): Unreferenced parameter [552] */
2073: hxc_time_building_blocks.object_version_number%TYPE
2074: /*ADVICE(1573): Mode of parameter is not specified with IN parameter [521] */
2075: ,
2076: p_timecard_status VARCHAR2
2077: /*ADVICE(1576): Mode of parameter is not specified with IN parameter [521] */

Line 2099: l_tc_status hxc_time_building_blocks.approval_status%TYPE;

2095:
2096: l_proc
2097: /*ADVICE(1596): Unreferenced variable [553] */
2098: VARCHAR2 (72);
2099: l_tc_status hxc_time_building_blocks.approval_status%TYPE;
2100: l_dummy NUMBER (1);
2101: BEGIN
2102: g_debug :=hr_utility.debug_enabled;
2103: if g_debug then

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

2281: PROCEDURE manage_timeinfo (
2282: p_day_counter IN NUMBER,
2283: p_insert_detail IN hxc_timekeeper_process.t_time_info,
2284: p_measure IN OUT NOCOPY NUMBER,
2285: p_detail_id IN OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2286: p_detail_ovn IN OUT NOCOPY NUMBER,
2287: p_detail_time_in IN OUT NOCOPY DATE,
2288: p_detail_time_out IN OUT NOCOPY DATE
2289: ) IS

Line 2484: p_detail_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

2480: END IF;
2481: END;
2482:
2483: PROCEDURE manage_detaildffinfo (
2484: p_detail_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2485: p_detail_ovn IN NUMBER,
2486: p_det_details IN OUT NOCOPY hxc_timekeeper_process.g_detail_data%TYPE,
2487: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
2488: p_attribute_category IN VARCHAR2,

Line 3678: FROM hxc_time_building_blocks

3674: p_tc_frdt DATE,
3675: p_tc_todt DATE
3676: ) IS
3677: SELECT time_building_block_id tbbid, start_time, stop_time, TO_DATE (start_time, 'dd-mm-rrrr')
3678: FROM hxc_time_building_blocks
3679: WHERE resource_id
3680: /*ADVICE(3110): Cursor references an external variable (use a parameter) [209] */
3681: = p_resource_id
3682: AND SCOPE = 'TIMECARD'

Line 4704: l_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE;

4700: p_block_array HXC_BLOCK_TABLE_TYPE;
4701: p_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
4702:
4703: l_resp_id NUMBER;
4704: l_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE;
4705: l_resp_appl_id NUMBER;
4706:
4707: */
4708:

Line 5865: l_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE;

5861: p_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
5862: p_messages HXC_MESSAGE_TABLE_TYPE;
5863:
5864: l_resp_id NUMBER;
5865: l_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE;
5866: l_resp_appl_id NUMBER;
5867:
5868: l_index NUMBER;
5869: