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_PROCESS dependencies on HR_GENERAL

Line 185: AND date_to = hr_general.end_of_time;

181: WHERE resource_id = p_resource_id
182: AND SCOPE = 'TIMECARD'
183: AND start_time = p_start_period
184: AND stop_time = p_end_period
185: AND date_to = hr_general.end_of_time;
186:
187: CURSOR c (
188: p_detailid NUMBER
189: ) IS

Line 206: AND detail.date_to = hr_general.end_of_time

202: detail.comment_text
203: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
204: WHERE DAY.parent_building_block_id = timecard_id
205: AND DAY.parent_building_block_ovn = timecard_ovn
206: AND detail.date_to = hr_general.end_of_time
207: AND detail.SCOPE = 'DETAIL'
208: AND detail.parent_building_block_id = DAY.time_building_block_id
209: AND detail.parent_building_block_ovn = DAY.object_version_number
210: AND DAY.SCOPE = 'DAY'

Line 211: AND DAY.date_to = hr_general.end_of_time

207: AND detail.SCOPE = 'DETAIL'
208: AND detail.parent_building_block_id = DAY.time_building_block_id
209: AND detail.parent_building_block_ovn = DAY.object_version_number
210: AND DAY.SCOPE = 'DAY'
211: AND DAY.date_to = hr_general.end_of_time
212: ORDER BY 4, 5, 1; --nitin
213:
214:
215: /* UNCOMMENT WHEN hxc_timecard_summary is enable

Line 448: AND detail.date_to = hr_general.end_of_time

444:
445: AND DAY.parent_building_block_ovn = p_bb_ovn
446: /*ADVICE(512): Cursor references an external variable (use a parameter) [209] */
447:
448: AND detail.date_to = hr_general.end_of_time
449: AND detail.SCOPE = 'DETAIL'
450: AND detail.parent_building_block_id = DAY.time_building_block_id
451: AND detail.parent_building_block_ovn = DAY.object_version_number
452: AND DAY.SCOPE = 'DAY'

Line 453: AND DAY.date_to = hr_general.end_of_time;

449: AND detail.SCOPE = 'DETAIL'
450: AND detail.parent_building_block_id = DAY.time_building_block_id
451: AND detail.parent_building_block_ovn = DAY.object_version_number
452: AND DAY.SCOPE = 'DAY'
453: AND DAY.date_to = hr_general.end_of_time;
454:
455: CURSOR c_get_warning_msg (
456: bb_id NUMBER,
457: bb_ovn NUMBER,

Line 465: AND (date_to = hr_general.end_of_time OR date_to IS NULL)

461: SELECT 'Y'
462: FROM hxc_errors
463: WHERE time_building_block_id = bb_id
464: AND time_building_block_ovn = bb_ovn
465: AND (date_to = hr_general.end_of_time OR date_to IS NULL)
466: AND message_level = DECODE (msg_type, 'ALL', message_level, NULL, message_level, msg_type)
467: AND message_name = DECODE (msg_text, NULL, message_name, msg_text);
468:
469: l_msg_flag VARCHAR2 (10) := NULL;

Line 527: AND detail.date_to = hr_general.end_of_time

523:
524: AND DAY.parent_building_block_ovn = p_bb_ovn
525: /*ADVICE(591): Cursor references an external variable (use a parameter) [209] */
526:
527: AND detail.date_to = hr_general.end_of_time
528: AND detail.SCOPE = 'DETAIL'
529: AND detail.parent_building_block_id = DAY.time_building_block_id
530: AND detail.parent_building_block_ovn = DAY.object_version_number
531: AND DAY.SCOPE = 'DAY'

Line 532: AND DAY.date_to = hr_general.end_of_time;

528: AND detail.SCOPE = 'DETAIL'
529: AND detail.parent_building_block_id = DAY.time_building_block_id
530: AND detail.parent_building_block_ovn = DAY.object_version_number
531: AND DAY.SCOPE = 'DAY'
532: AND DAY.date_to = hr_general.end_of_time;
533:
534: CURSOR c_get_reason (
535: bb_id NUMBER,
536: bb_ovn NUMBER,

Line 5092: AND date_to = hr_general.end_of_time

5088: ) IS
5089: SELECT time_building_block_id, object_version_number, comment_text
5090: FROM hxc_time_building_blocks
5091: WHERE SCOPE = 'TIMECARD'
5092: AND date_to = hr_general.end_of_time
5093: AND resource_id = p_resource_id
5094: AND start_time = p_start_period
5095: AND stop_time = p_end_period;
5096:

Line 5140: and (trunc(date_to) = hr_general.end_of_time or APPROVAL_STATUS='ERROR');

5136: where resource_id=p_resource_id
5137: and scope='TIMECARD'
5138: and trunc(start_time)=trunc(p_start_date)
5139: and trunc(stop_time)=trunc(p_end_date)
5140: and (trunc(date_to) = hr_general.end_of_time or APPROVAL_STATUS='ERROR');
5141: /*end of senthil changes */
5142: l_tk_table_index NUMBER
5143: /*ADVICE(3566): NUMBER has no precision [315] */
5144: ;

Line 5786: IF fnd_date.canonical_to_date (l_timecard (l_timecard_index).date_to) = hr_general.end_of_time THEN

5782:
5783: LOOP
5784: EXIT WHEN (NOT l_timecard.EXISTS (l_timecard_index));
5785: IF l_timecard (l_timecard_index).SCOPE = 'DETAIL' THEN
5786: IF fnd_date.canonical_to_date (l_timecard (l_timecard_index).date_to) = hr_general.end_of_time THEN
5787: l_delete := FALSE;
5788: EXIT;
5789: END IF;
5790: END IF;

Line 5794: hr_general.end_of_time

5790: END IF;
5791:
5792: IF l_timecard (l_timecard_index).SCOPE = 'TIMECARD' THEN
5793: IF fnd_date.canonical_to_date (l_timecard (l_timecard_index).date_to) =
5794: hr_general.end_of_time
5795: AND l_timecard (l_timecard_index).comment_text IS NOT NULL
5796: AND l_timecard (l_timecard_index).NEW = 'Y' THEN
5797: l_delete := FALSE;
5798: EXIT;

Line 6297: and (trunc(date_to) = hr_general.end_of_time or APPROVAL_STATUS='ERROR');

6293: where resource_id=p_resource_id
6294: and scope='TIMECARD'
6295: and trunc(start_time)=trunc(p_start_date)
6296: and trunc(stop_time)=trunc(p_end_date)
6297: and (trunc(date_to) = hr_general.end_of_time or APPROVAL_STATUS='ERROR');
6298: /*end of senthil changes */
6299:
6300: l_timecard hxc_block_table_type := hxc_block_table_type ();
6301: ord_timecard

Line 6705: AND date_to = hr_general.end_of_time

6701: approval_status, comment_text,application_set_id
6702: FROM hxc_time_building_blocks
6703: WHERE resource_id = p_resource_id
6704: AND SCOPE = 'TIMECARD'
6705: AND date_to = hr_general.end_of_time
6706: AND start_time = p_start_period
6707: AND stop_time = p_end_period;
6708:
6709: CURSOR c_day_info (

Line 6727: AND date_to = hr_general.end_of_time

6723: FROM hxc_time_building_blocks
6724: WHERE resource_id = p_resource_id
6725: AND parent_building_block_id = p_parent_building_block_id
6726: AND parent_building_block_ovn = p_parent_ovn
6727: AND date_to = hr_general.end_of_time
6728: AND SCOPE = 'DAY'
6729: AND start_time = p_start_period
6730: AND stop_time = p_end_period;
6731:

Line 6745: AND date_to = hr_general.end_of_time

6741: FROM hxc_time_building_blocks
6742: WHERE resource_id = p_resource_id
6743: AND parent_building_block_id = p_parent_building_block_id
6744: AND parent_building_block_ovn = p_parent_ovn
6745: AND date_to = hr_general.end_of_time
6746: AND SCOPE = 'DETAIL';
6747:
6748: l_find_day_also BOOLEAN := TRUE;
6749: l_index_day NUMBER

Line 6934: l_date_to := hr_general.end_of_time;

6930: hr_utility.trace('g_resource_prepop_count 1 ='||g_resource_prepop_count);
6931: end if;
6932:
6933: l_timecard_id := g_negative_index;
6934: l_date_to := hr_general.end_of_time;
6935: l_date_from := SYSDATE;
6936: l_timecard_ovn := 1; --added for new deposit_wrapper null;
6937: l_find_day_also := FALSE;
6938: -- we will need to create the required attributes on the timecard as LAYOUT....

Line 7091: l_day_date_to := hr_general.end_of_time;

7087: EXIT WHEN l_found = 'Y';
7088: END LOOP;
7089:
7090:
7091: l_day_date_to := hr_general.end_of_time;
7092: l_day_date_from := SYSDATE;
7093: l_day_id := g_negative_index;
7094: l_day_ovn := 1;
7095: END IF;

Line 7124: l_day_date_to := hr_general.end_of_time;

7120: END LOOP;
7121:
7122:
7123:
7124: l_day_date_to := hr_general.end_of_time;
7125: l_day_date_from := SYSDATE;
7126: l_day_id := g_negative_index;
7127: l_day_ovn := 1;
7128: END IF;

Line 7320: AND date_to = hr_general.end_of_time

7316: SELECT comment_text
7317: FROM hxc_time_building_blocks
7318: WHERE resource_id = p_resource_id
7319: AND SCOPE = 'TIMECARD'
7320: AND date_to = hr_general.end_of_time
7321: AND start_time = p_start_period
7322: AND stop_time = p_end_period;
7323:
7324: c_row hxc_tk_detail_temp%ROWTYPE;

Line 8055: p_date_to => hr_general.end_of_time,

8051: p_parent_ovn => p_day_id_info_table (l_index_day).day_ovn,
8052: p_approval_style_id => p_approval_style_id,
8053: p_measure => l_measure,
8054: p_scope => 'DETAIL',
8055: p_date_to => hr_general.end_of_time,
8056: p_date_from => SYSDATE,
8057: p_start_period => l_detail_time_in,
8058: p_end_period => l_detail_time_out,
8059: p_resource_id => p_resource_id,

Line 8393: p_date_to => hr_general.end_of_time,

8389: p_parent_ovn => p_day_id_info_table (l_index_day).day_ovn,
8390: p_approval_style_id => p_approval_style_id,
8391: p_measure => l_measure,
8392: p_scope => 'DETAIL',
8393: p_date_to => hr_general.end_of_time,
8394: p_date_from => SYSDATE,
8395: p_start_period => l_detail_time_in,
8396: p_end_period => l_detail_time_out,
8397: p_resource_id => p_resource_id,

Line 8682: p_date_to => hr_general.end_of_time,

8678: p_parent_ovn => p_day_id_info_table (l_index_day).day_ovn,
8679: p_approval_style_id => p_approval_style_id,
8680: p_measure => l_measure,
8681: p_scope => 'DETAIL',
8682: p_date_to => hr_general.end_of_time,
8683: p_date_from => SYSDATE,
8684: p_start_period => l_detail_time_in,
8685: p_end_period => l_detail_time_out,
8686: p_resource_id => p_resource_id,