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.HXT_HXC_RETRIEVAL_PROCESS dependencies on HR_GENERAL

Line 57: AND dyovn.date_to <> hr_general.end_of_time)

53: MAX (dyovn.object_version_number)
54: FROM hxc_time_building_blocks dyovn
55: WHERE dyovn.time_building_block_id =
56: tbb.time_building_block_id
57: AND dyovn.date_to <> hr_general.end_of_time)
58: AND tbb.date_to <> hr_general.end_of_time
59: AND EXISTS (
60: SELECT /*+ LEADING(txd)
61: INDEX(txd HXC_TRANSACTION_DETAILS_FK1)

Line 58: AND tbb.date_to <> hr_general.end_of_time

54: FROM hxc_time_building_blocks dyovn
55: WHERE dyovn.time_building_block_id =
56: tbb.time_building_block_id
57: AND dyovn.date_to <> hr_general.end_of_time)
58: AND tbb.date_to <> hr_general.end_of_time
59: AND EXISTS (
60: SELECT /*+ LEADING(txd)
61: INDEX(txd HXC_TRANSACTION_DETAILS_FK1)
62: INDEX(tx HXC_TRANSACTIONS_PK) */

Line 238: AND ( l_date_to = hr_general.end_of_time

234: AND l_start_time IS NOT NULL
235: AND l_stop_time IS NOT NULL
236: )
237: )
238: AND ( l_date_to = hr_general.end_of_time
239: OR (l_date_to <> hr_general.end_of_time AND l_new = 'N'
240: )
241: )
242: OR ( ( (l_type = 'MEASURE' AND l_measure IS NULL)

Line 239: OR (l_date_to <> hr_general.end_of_time AND l_new = 'N'

235: AND l_stop_time IS NOT NULL
236: )
237: )
238: AND ( l_date_to = hr_general.end_of_time
239: OR (l_date_to <> hr_general.end_of_time AND l_new = 'N'
240: )
241: )
242: OR ( ( (l_type = 'MEASURE' AND l_measure IS NULL)
243: OR ( l_type = 'RANGE'

Line 248: AND l_date_to <> hr_general.end_of_time

244: AND l_start_time IS NULL
245: AND l_stop_time IS NULL
246: )
247: )
248: AND l_date_to <> hr_general.end_of_time
249: AND l_new = 'N'
250: )
251: )
252: THEN

Line 449: AND date_to = hr_general.end_of_time;

445: FROM hxc_time_building_blocks
446: WHERE time_building_block_id = l_day_bb_id
447: AND ((measure = 0) or (start_time is not null and stop_time is not null))
448: AND scope = 'DETAIL'
449: AND date_to = hr_general.end_of_time;
450: END;
451: END IF;
452: --Bug 4890370 Fix Ends
453:

Line 881: ( l_date_to <> hr_general.end_of_time

877: AND l_stop_time IS NOT NULL
878: )
879: )
880: AND ( -- First process deleted detail records
881: ( l_date_to <> hr_general.end_of_time
882: AND l_new = 'N'
883: AND i = 1
884: )
885: -- Next process the updated detail records

Line 886: OR ( l_date_to = hr_general.end_of_time

882: AND l_new = 'N'
883: AND i = 1
884: )
885: -- Next process the updated detail records
886: OR ( l_date_to = hr_general.end_of_time
887: AND l_new = 'N'
888: AND i = 2
889: )
890: -- And the last to be processed are the Inserts

Line 891: OR ( l_date_to = hr_general.end_of_time

887: AND l_new = 'N'
888: AND i = 2
889: )
890: -- And the last to be processed are the Inserts
891: OR ( l_date_to = hr_general.end_of_time
892: AND l_new = 'Y'
893: AND i = 3
894: )
895: ) --2966729

Line 904: AND l_date_to <> hr_general.end_of_time

900: AND l_start_time IS NULL
901: AND l_stop_time IS NULL
902: )
903: )
904: AND l_date_to <> hr_general.end_of_time
905: AND l_new = 'N'
906: AND i = 1
907: )
908: -- bug 3650967

Line 912: -- (l_date_to = hr_general.end_of_time) THEN

908: -- bug 3650967
909: )
910: AND l_scope = 'DETAIL'
911: THEN
912: -- (l_date_to = hr_general.end_of_time) THEN
913:
914: --Bug 2770487 Sonarasi 04-Apr-2003
915: --Commented the above check l_date_to = hr_general.end_of_time because we need
916: --the deleted blocks also to be considered for explosion.

Line 915: --Commented the above check l_date_to = hr_general.end_of_time because we need

911: THEN
912: -- (l_date_to = hr_general.end_of_time) THEN
913:
914: --Bug 2770487 Sonarasi 04-Apr-2003
915: --Commented the above check l_date_to = hr_general.end_of_time because we need
916: --the deleted blocks also to be considered for explosion.
917: --Bug 2770487 Sonarasi Over
918:
919: --

Line 954: AND l_date_to <> hr_general.end_of_time

950: OR ( l_type = 'RANGE'
951: AND l_start_time IS NULL
952: AND l_stop_time IS NULL
953: )
954: AND l_date_to <> hr_general.end_of_time
955: AND l_new = 'N'
956: AND i = 1
957: ) -- end bug 3650967
958: THEN

Line 1292: IF (l_date_to = hr_general.end_of_time)

1288: END IF;
1289: END IF;
1290:
1291: --Bug 2770487 Sonarasi 04-Apr-2003
1292: IF (l_date_to = hr_general.end_of_time)
1293: THEN
1294: l_delete := 'N';
1295: ELSE
1296: l_delete := 'Y';

Line 2269: ( l_date_to <> hr_general.end_of_time

2265: AND l_stop_time IS NOT NULL
2266: )
2267: )
2268: AND ( -- First process deleted detail records
2269: ( l_date_to <> hr_general.end_of_time
2270: AND l_new = 'N'
2271: AND i = 1
2272: )
2273: -- Next process the updated detail records

Line 2274: OR ( l_date_to = hr_general.end_of_time

2270: AND l_new = 'N'
2271: AND i = 1
2272: )
2273: -- Next process the updated detail records
2274: OR ( l_date_to = hr_general.end_of_time
2275: AND l_new = 'N'
2276: AND i = 2
2277: )
2278: -- And the last to be processed are the Inserts

Line 2279: OR ( l_date_to = hr_general.end_of_time

2275: AND l_new = 'N'
2276: AND i = 2
2277: )
2278: -- And the last to be processed are the Inserts
2279: OR ( l_date_to = hr_general.end_of_time
2280: AND l_new = 'Y'
2281: AND i = 3
2282: )
2283: ) --2966729

Line 2292: AND l_date_to <> hr_general.end_of_time

2288: AND l_start_time IS NULL
2289: AND l_stop_time IS NULL
2290: )
2291: )
2292: AND l_date_to <> hr_general.end_of_time
2293: AND l_new = 'N'
2294: AND i = 1
2295: )
2296: -- end bug 3650967

Line 2300: -- (l_date_to = hr_general.end_of_time) THEN

2296: -- end bug 3650967
2297: )
2298: AND l_scope = 'DETAIL'
2299: THEN
2300: -- (l_date_to = hr_general.end_of_time) THEN
2301:
2302: --Bug 2770487 Sonarasi 04-Apr-2003
2303: --Commented the above check l_date_to = hr_general.end_of_time because we need
2304: --the deleted blocks also to be considered for explosion.

Line 2303: --Commented the above check l_date_to = hr_general.end_of_time because we need

2299: THEN
2300: -- (l_date_to = hr_general.end_of_time) THEN
2301:
2302: --Bug 2770487 Sonarasi 04-Apr-2003
2303: --Commented the above check l_date_to = hr_general.end_of_time because we need
2304: --the deleted blocks also to be considered for explosion.
2305: --Bug 2770487 Sonarasi Over
2306: --
2307: l_valid := 'Y';

Line 2323: AND l_date_to <> hr_general.end_of_time

2319: OR ( l_type = 'RANGE'
2320: AND l_start_time IS NULL
2321: AND l_stop_time IS NULL
2322: )
2323: AND l_date_to <> hr_general.end_of_time
2324: AND l_new = 'N'
2325: AND i = 1
2326: ) -- end bug 3650967
2327: THEN

Line 2729: IF (l_date_to = hr_general.end_of_time)

2725: hr_utility.set_location (l_proc, 69);
2726: END IF;
2727:
2728: --Bug 2770487 Sonarasi 04-Apr-2003
2729: IF (l_date_to = hr_general.end_of_time)
2730: THEN
2731: IF g_debug
2732: THEN
2733: hr_utility.set_location (l_proc, 70);

Line 3937: AND ( (p_time_building_blocks(l_cnt).DATE_TO <> hr_general.end_of_time)

3933: hr_utility.trace('stop_time '||p_time_building_blocks(l_cnt).stop_time);
3934: END IF;
3935: -- If its a DELETE or stop_time is missing
3936: IF (p_time_building_blocks(l_cnt).SCOPE = 'DETAIL' )
3937: AND ( (p_time_building_blocks(l_cnt).DATE_TO <> hr_general.end_of_time)
3938: OR ( p_time_building_blocks(l_cnt).type = 'RANGE'
3939: AND ( p_time_building_blocks(l_cnt).start_time IS NULL
3940: OR p_time_building_blocks(l_cnt).stop_time IS NULL)
3941: )