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 423: AND detail.date_to = hr_general.end_of_time

419:
420: AND DAY.parent_building_block_ovn = p_bb_ovn
421: /*ADVICE(512): Cursor references an external variable (use a parameter) [209] */
422:
423: AND detail.date_to = hr_general.end_of_time
424: AND detail.SCOPE = 'DETAIL'
425: AND detail.parent_building_block_id = DAY.time_building_block_id
426: AND detail.parent_building_block_ovn = DAY.object_version_number
427: AND DAY.SCOPE = 'DAY'

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

424: AND detail.SCOPE = 'DETAIL'
425: AND detail.parent_building_block_id = DAY.time_building_block_id
426: AND detail.parent_building_block_ovn = DAY.object_version_number
427: AND DAY.SCOPE = 'DAY'
428: AND DAY.date_to = hr_general.end_of_time;
429:
430: CURSOR c_get_warning_msg (
431: bb_id NUMBER,
432: bb_ovn NUMBER,

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

436: SELECT 'Y'
437: FROM hxc_errors
438: WHERE time_building_block_id = bb_id
439: AND time_building_block_ovn = bb_ovn
440: AND (date_to = hr_general.end_of_time OR date_to IS NULL)
441: AND message_level = DECODE (msg_type, 'ALL', message_level, NULL, message_level, msg_type)
442: AND message_name = DECODE (msg_text, NULL, message_name, msg_text);
443:
444: l_msg_flag VARCHAR2 (10) := NULL;

Line 502: AND detail.date_to = hr_general.end_of_time

498:
499: AND DAY.parent_building_block_ovn = p_bb_ovn
500: /*ADVICE(591): Cursor references an external variable (use a parameter) [209] */
501:
502: AND detail.date_to = hr_general.end_of_time
503: AND detail.SCOPE = 'DETAIL'
504: AND detail.parent_building_block_id = DAY.time_building_block_id
505: AND detail.parent_building_block_ovn = DAY.object_version_number
506: AND DAY.SCOPE = 'DAY'

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

503: AND detail.SCOPE = 'DETAIL'
504: AND detail.parent_building_block_id = DAY.time_building_block_id
505: AND detail.parent_building_block_ovn = DAY.object_version_number
506: AND DAY.SCOPE = 'DAY'
507: AND DAY.date_to = hr_general.end_of_time;
508:
509: CURSOR c_get_reason (
510: bb_id NUMBER,
511: bb_ovn NUMBER,

Line 4096: AND date_to = hr_general.end_of_time

4092: ) IS
4093: SELECT time_building_block_id, object_version_number, comment_text
4094: FROM hxc_time_building_blocks
4095: WHERE SCOPE = 'TIMECARD'
4096: AND date_to = hr_general.end_of_time
4097: AND resource_id = p_resource_id
4098: AND start_time = p_start_period
4099: AND stop_time = p_end_period;
4100:

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

4140: where resource_id=p_resource_id
4141: and scope='TIMECARD'
4142: and trunc(start_time)=trunc(p_start_date)
4143: and trunc(stop_time)=trunc(p_end_date)
4144: and (trunc(date_to) = hr_general.end_of_time or APPROVAL_STATUS='ERROR');
4145: /*end of senthil changes */
4146: l_tk_table_index NUMBER
4147: /*ADVICE(3566): NUMBER has no precision [315] */
4148: ;

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

4456:
4457: LOOP
4458: EXIT WHEN (NOT l_timecard.EXISTS (l_timecard_index));
4459: IF l_timecard (l_timecard_index).SCOPE = 'DETAIL' THEN
4460: IF fnd_date.canonical_to_date (l_timecard (l_timecard_index).date_to) = hr_general.end_of_time THEN
4461: l_delete := FALSE;
4462: EXIT;
4463: END IF;
4464: END IF;

Line 4468: hr_general.end_of_time

4464: END IF;
4465:
4466: IF l_timecard (l_timecard_index).SCOPE = 'TIMECARD' THEN
4467: IF fnd_date.canonical_to_date (l_timecard (l_timecard_index).date_to) =
4468: hr_general.end_of_time
4469: AND l_timecard (l_timecard_index).comment_text IS NOT NULL
4470: AND l_timecard (l_timecard_index).NEW = 'Y' THEN
4471: l_delete := FALSE;
4472: EXIT;

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

4941: where resource_id=p_resource_id
4942: and scope='TIMECARD'
4943: and trunc(start_time)=trunc(p_start_date)
4944: and trunc(stop_time)=trunc(p_end_date)
4945: and (trunc(date_to) = hr_general.end_of_time or APPROVAL_STATUS='ERROR');
4946: /*end of senthil changes */
4947:
4948: l_timecard hxc_block_table_type := hxc_block_table_type ();
4949: ord_timecard

Line 5353: AND date_to = hr_general.end_of_time

5349: approval_status, comment_text,application_set_id
5350: FROM hxc_time_building_blocks
5351: WHERE resource_id = p_resource_id
5352: AND SCOPE = 'TIMECARD'
5353: AND date_to = hr_general.end_of_time
5354: AND start_time = p_start_period
5355: AND stop_time = p_end_period;
5356:
5357: CURSOR c_day_info (

Line 5375: AND date_to = hr_general.end_of_time

5371: FROM hxc_time_building_blocks
5372: WHERE resource_id = p_resource_id
5373: AND parent_building_block_id = p_parent_building_block_id
5374: AND parent_building_block_ovn = p_parent_ovn
5375: AND date_to = hr_general.end_of_time
5376: AND SCOPE = 'DAY'
5377: AND start_time = p_start_period
5378: AND stop_time = p_end_period;
5379:

Line 5393: AND date_to = hr_general.end_of_time

5389: FROM hxc_time_building_blocks
5390: WHERE resource_id = p_resource_id
5391: AND parent_building_block_id = p_parent_building_block_id
5392: AND parent_building_block_ovn = p_parent_ovn
5393: AND date_to = hr_general.end_of_time
5394: AND SCOPE = 'DETAIL';
5395:
5396: l_find_day_also BOOLEAN := TRUE;
5397: l_index_day NUMBER

Line 5545: l_date_to := hr_general.end_of_time;

5541: -- if the timecard_id is null then we need to generate one
5542: IF l_timecard_id IS NULL then
5543: g_negative_index := g_negative_index - 1;
5544: l_timecard_id := g_negative_index;
5545: l_date_to := hr_general.end_of_time;
5546: l_date_from := SYSDATE;
5547: l_timecard_ovn := 1; --added for new deposit_wrapper null;
5548: l_find_day_also := FALSE;
5549: -- we will need to create the required attributes on the timecard as LAYOUT....

Line 5647: l_day_date_to := hr_general.end_of_time;

5643:
5644:
5645: IF c_day_info%NOTFOUND THEN
5646: g_negative_index := g_negative_index - 1;
5647: l_day_date_to := hr_general.end_of_time;
5648: l_day_date_from := SYSDATE;
5649: l_day_id := g_negative_index;
5650: l_day_ovn := 1;
5651: END IF;

Line 5656: l_day_date_to := hr_general.end_of_time;

5652:
5653: CLOSE c_day_info;
5654: ELSE
5655: g_negative_index := g_negative_index - 1;
5656: l_day_date_to := hr_general.end_of_time;
5657: l_day_date_from := SYSDATE;
5658: l_day_id := g_negative_index;
5659: l_day_ovn := 1;
5660: END IF;

Line 5842: AND date_to = hr_general.end_of_time

5838: SELECT comment_text
5839: FROM hxc_time_building_blocks
5840: WHERE resource_id = p_resource_id
5841: AND SCOPE = 'TIMECARD'
5842: AND date_to = hr_general.end_of_time
5843: AND start_time = p_start_period
5844: AND stop_time = p_end_period;
5845:
5846: c_row hxc_tk_detail_temp%ROWTYPE;

Line 6555: p_date_to => hr_general.end_of_time,

6551: p_parent_ovn => p_day_id_info_table (l_index_day).day_ovn,
6552: p_approval_style_id => p_approval_style_id,
6553: p_measure => l_measure,
6554: p_scope => 'DETAIL',
6555: p_date_to => hr_general.end_of_time,
6556: p_date_from => SYSDATE,
6557: p_start_period => l_detail_time_in,
6558: p_end_period => l_detail_time_out,
6559: p_resource_id => p_resource_id,

Line 6803: p_date_to => hr_general.end_of_time,

6799: p_parent_ovn => p_day_id_info_table (l_index_day).day_ovn,
6800: p_approval_style_id => p_approval_style_id,
6801: p_measure => l_measure,
6802: p_scope => 'DETAIL',
6803: p_date_to => hr_general.end_of_time,
6804: p_date_from => SYSDATE,
6805: p_start_period => l_detail_time_in,
6806: p_end_period => l_detail_time_out,
6807: p_resource_id => p_resource_id,

Line 6995: p_date_to => hr_general.end_of_time,

6991: p_parent_ovn => p_day_id_info_table (l_index_day).day_ovn,
6992: p_approval_style_id => p_approval_style_id,
6993: p_measure => l_measure,
6994: p_scope => 'DETAIL',
6995: p_date_to => hr_general.end_of_time,
6996: p_date_from => SYSDATE,
6997: p_start_period => l_detail_time_in,
6998: p_end_period => l_detail_time_out,
6999: p_resource_id => p_resource_id,