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_RETRIEVE_ABSENCES dependencies on HXC_ABS_CO_DETAILS

Line 2145: INSERT INTO hxc_abs_co_details

2141:
2142: BEGIN
2143:
2144:
2145: INSERT INTO hxc_abs_co_details
2146: ( time_building_block_id ,
2147: object_version_number ,
2148: absence_type_id ,
2149: absence_attendance_id ,

Line 2228: FROM hxc_abs_co_details

2224: l_start,
2225: l_stop,
2226: l_element,
2227: l_transaction_id
2228: FROM hxc_abs_co_details
2229: WHERE time_building_block_id = p_old_bb_id
2230: AND resource_id = g_person_id
2231: AND start_time = g_start_time
2232: AND stage IN ('PREP','DEP','PREP-SS')

Line 2235: UPDATE hxc_abs_co_details

2231: AND start_time = g_start_time
2232: AND stage IN ('PREP','DEP','PREP-SS')
2233: AND TRUNC(stop_time) = TRUNC(g_stop_time);
2234:
2235: UPDATE hxc_abs_co_details
2236: SET time_building_block_id = p_new_bb_id,
2237: stage = 'DEP'
2238: WHERE ROWID = CHARTOROWID(l_rowid);
2239:

Line 2311: FROM hxc_abs_co_details

2307: l_start,
2308: l_stop,
2309: l_element,
2310: l_action
2311: FROM hxc_abs_co_details
2312: WHERE time_building_block_id = p_old_bb_id
2313: AND stage IN ('PREP','DEP');
2314:
2315:

Line 2316: UPDATE hxc_abs_co_details

2312: WHERE time_building_block_id = p_old_bb_id
2313: AND stage IN ('PREP','DEP');
2314:
2315:
2316: UPDATE hxc_abs_co_details
2317: SET object_version_number = p_new_ovn,
2318: stage = 'DEP'
2319: WHERE ROWID = chartorowid(l_rowid);
2320:

Line 2362: DELETE FROM hxc_abs_co_details

2358: BEGIN
2359:
2360: /*
2361:
2362: DELETE FROM hxc_abs_co_details
2363: WHERE resource_id = p_resource_id
2364: AND stage IN ( 'PREP','PREP-SS');
2365: */
2366:

Line 2367: DELETE FROM hxc_abs_co_details

2363: WHERE resource_id = p_resource_id
2364: AND stage IN ( 'PREP','PREP-SS');
2365: */
2366:
2367: DELETE FROM hxc_abs_co_details
2368: WHERE resource_id = p_resource_id
2369: AND start_time = p_start_time
2370: AND TRUNC(stop_time) = TRUNC(p_stop_time);
2371:

Line 2514: FROM hxc_abs_co_details abs

2510:
2511: CURSOR get_notifications
2512: IS SELECT transaction_id,
2513: ROWIDTOCHAR(abs.ROWID)
2514: FROM hxc_abs_co_details abs
2515: WHERE resource_id = p_resource_id
2516: AND start_time = p_start_time
2517: AND stop_time = p_stop_time
2518: AND transaction_id IS NOT NULL;

Line 2550: UPDATE hxc_abs_co_details

2546: END;
2547: END LOOP;
2548:
2549: FORALL i IN l_rowid_tab.FIRST..l_rowid_tab.LAST
2550: UPDATE hxc_abs_co_details
2551: SET transaction_id = NULL
2552: WHERE ROWID = CHARTOROWID(l_rowid_tab(i));
2553:
2554: END IF;

Line 2605: FROM hxc_abs_co_details

2601: DECODE(uom,'H',fnd_date.date_to_canonical(start_date),NULL) start_time,
2602: DECODE(uom,'H',fnd_date.date_to_canonical(end_date),NULL) stop_time,
2603: TRUNC(start_date) abs_date,
2604: 'N' validated
2605: FROM hxc_abs_co_details
2606: WHERE start_time = p_start_time
2607: AND resource_id = p_resource_id
2608: AND TRUNC(stop_time) = TRUNC(p_stop_time)
2609: AND stage IN ( 'PREP-SS', 'PREP','DEP');

Line 2619: FROM hxc_abs_co_details

2615: p_start_time IN DATE,
2616: p_stop_time IN DATE)
2617: IS SELECT time_building_block_id,
2618: action
2619: FROM hxc_abs_co_details
2620: WHERE resource_id = p_resource_id
2621: AND start_time = p_start_time
2622: AND TRUNC(stop_time) = TRUNC(p_stop_time)
2623: AND stage = 'PREP-SS';

Line 2638: FROM hxc_abs_co_details hxc,

2634: p_start_time IN DATE,
2635: p_stop_time IN DATE)
2636: IS SELECT /*+ LEADING(hxc) */
2637: time_building_block_id
2638: FROM hxc_abs_co_details hxc,
2639: per_absence_attendances per
2640: WHERE resource_id = p_resource_id
2641: AND start_time = p_start_time
2642: AND TRUNC(stop_time) = TRUNC(p_stop_time)

Line 2662: FROM hxc_abs_co_details

2658: DECODE(uom,'H',fnd_date.date_to_canonical(start_date),NULL) start_time,
2659: DECODE(uom,'H',fnd_date.date_to_canonical(end_date),NULL) stop_time,
2660: TRUNC(start_date) abs_date,
2661: 'N' validated
2662: FROM hxc_abs_co_details
2663: WHERE resource_id = p_resource_id
2664: AND start_time = p_start_time
2665: AND TRUNC(stop_time) = TRUNC(p_stop_time)
2666: AND stage in ('DEP','PREP-SS')

Line 2936: AND NOT EXISTS ( SELECT /* INDEX(tc HXC_ABS_CO_DETAILS_FK4) */

2932: FROM per_absence_attendances abs
2933: WHERE person_id = p_resource_id
2934: AND NVL(date_start,date_projected_start) <= p_stop_time
2935: AND NVL(date_end,date_projected_end) >= p_start_time
2936: AND NOT EXISTS ( SELECT /* INDEX(tc HXC_ABS_CO_DETAILS_FK4) */
2937: 1
2938: FROM hxc_abs_co_details tc
2939: WHERE tc.absence_attendance_id = abs.absence_attendance_id
2940: AND tc.stage = 'RET'

Line 2938: FROM hxc_abs_co_details tc

2934: AND NVL(date_start,date_projected_start) <= p_stop_time
2935: AND NVL(date_end,date_projected_end) >= p_start_time
2936: AND NOT EXISTS ( SELECT /* INDEX(tc HXC_ABS_CO_DETAILS_FK4) */
2937: 1
2938: FROM hxc_abs_co_details tc
2939: WHERE tc.absence_attendance_id = abs.absence_attendance_id
2940: AND tc.stage = 'RET'
2941: AND tc.resource_id = p_resource_id
2942: AND tc.start_time = p_start_time);

Line 2946: FROM hxc_abs_co_details

2942: AND tc.start_time = p_start_time);
2943:
2944: CURSOR get_pending_abs
2945: IS SELECT distinct TRUNC(start_date)
2946: FROM hxc_abs_co_details
2947: WHERE resource_id = p_resource_id
2948: AND start_time = p_start_time
2949: AND TRUNC(stop_time) = TRUNC(p_stop_time)
2950: AND stage in ('DEP','PREP-SS')

Line 4118: DELETE FROM hxc_abs_co_details

4114: PRAGMA AUTONOMOUS_TRANSACTION;
4115:
4116: BEGIN
4117:
4118: DELETE FROM hxc_abs_co_details
4119: WHERE resource_id = p_resource_id
4120: AND start_time = p_tc_start
4121: AND TRUNC(stop_time) = TRUNC(p_tc_stop);
4122: