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_ABS_RETRIEVAL_PKG dependencies on HXC_ABS_RET_TEMP

Line 49: FROM hxc_abs_ret_temp

45: retrieval_status,
46: absences_action,
47: element_type_id,
48: link_time_building_block_id
49: FROM hxc_abs_ret_temp
50: WHERE resource_id = c_resource_id
51: AND TRUNC (day_start) >= TRUNC (c_tc_start)
52: AND TRUNC (day_stop) <= TRUNC (c_tc_stop)
53: ORDER BY absences_action ASC,

Line 87: hxc_abs_ret_temp temp

83: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
84: 0 cost_allocation_keyflex_id
85: FROM hxc_time_attributes hta,
86: hxc_time_attribute_usages htau,
87: hxc_abs_ret_temp temp
88: WHERE temp.time_building_block_id = htau.time_building_block_id
89: AND temp.object_version_number = htau.time_building_block_ovn
90: AND htau.time_attribute_id = hta.time_attribute_id
91: AND hta.attribute_category = 'Dummy Cost Context';

Line 137: FROM hxc_abs_ret_temp

133: trunc(day_start) start_date,
134: trunc(day_stop) end_date,
135: time_building_block_id,
136: object_version_number
137: FROM hxc_abs_ret_temp
138: WHERE absence_attendance_id IS NOT NULL
139: AND absences_action = 'DELETE'
140: ORDER BY uom ASC, absence_attendance_id ASC, start_date ASC;
141:

Line 153: FROM hxc_abs_ret_temp temp,

149: temp.object_version_number,
150: latest.object_version_number,
151: temp.absences_action,
152: detail.date_to
153: FROM hxc_abs_ret_temp temp,
154: hxc_latest_details latest,
155: hxc_time_building_blocks detail
156: WHERE temp.resource_id = c_resource_id
157: AND TRUNC (temp.day_start) >= TRUNC (c_tc_start)

Line 186: l_temp_row hxc_abs_ret_temp%ROWTYPE;

182: hours_tab t_absences;
183: l_abs_retrieval_rule VARCHAR2 (50);
184: l_retrieval_rule_grp_id hxc_retrieval_rule_groups_v.retrieval_rule_group_id%TYPE;
185: l_emp_name per_all_people_f.full_name%TYPE;
186: l_temp_row hxc_abs_ret_temp%ROWTYPE;
187: l_count NUMBER;
188: l_days_ix NUMBER;
189: l_d_ix BINARY_INTEGER := 0;
190: l_h_ix BINARY_INTEGER := 0;

Line 372: INSERT INTO hxc_abs_ret_temp (

368:
369: -- Populate TEMP table with absences data that has to be created
370: -- Absences which are new and not yet retrieved
371:
372: INSERT INTO hxc_abs_ret_temp (
373: SELECT /*+ LEADING (latest HXC_LATEST_DETAILS_N1)
374: INDEX(detail HXC_TIME_BUILDING_BLOCKS_PK)
375: INDEX(htau HXC_TIME_ATTRIBUTE_USAGES_FK2)
376: INDEX(hta HXC_TIME_ATTRIBUTES_PK) */

Line 435: INSERT INTO hxc_abs_ret_temp (

431:
432: -- Populate TEMP table with updated/deleted absences data
433: -- This cursor returns Absences which were retrieved earlier and have undergone a change during
434: -- next retrieval
435: INSERT INTO hxc_abs_ret_temp (
436: SELECT detail.time_building_block_id , --time_building_block_id,
437: detail.object_version_number , --object_version_number,
438: detail.resource_id , --resource_id,
439: detail.start_time , --in_time,

Line 495: FROM hxc_abs_ret_temp );

491: DELETE FROM hxc_pay_latest_details
492: WHERE (time_building_block_id,object_version_number)
493: IN ( SELECT time_building_block_id,
494: object_version_number
495: FROM hxc_abs_ret_temp );
496:
497:
498:
499:

Line 581: UPDATE hxc_abs_ret_temp

577: THEN
578: populate_cost_keyflex (l_cost_segment);
579: FOR l_ix IN l_cost_segment.FIRST .. l_cost_segment.LAST
580: LOOP
581: UPDATE hxc_abs_ret_temp
582: SET cost_allocation_keyflex_id = l_cost_segment (l_ix).cost_allocation_keyflex_id
583: WHERE time_building_block_id = l_cost_segment (l_ix).time_building_block_id
584: AND object_version_number = l_cost_segment (l_ix).object_version_number;
585: END LOOP;

Line 665: DELETE FROM hxc_abs_ret_temp

661: IF (l_id_tab.COUNT > 0)
662: THEN
663:
664: FORALL l_ix IN l_id_tab.FIRST .. l_id_tab.LAST
665: DELETE FROM hxc_abs_ret_temp
666: WHERE time_building_block_id = l_id_tab(l_ix);
667:
668: FORALL l_ix IN l_ovn_tab.FIRST .. l_ovn_tab.LAST
669: UPDATE hxc_abs_co_details

Line 972: UPDATE hxc_abs_ret_temp

968: END IF;
969:
970: days_tab (l_days_ix + 1).day_start := days_tab (l_days_ix).day_start;
971:
972: UPDATE hxc_abs_ret_temp
973: SET link_time_building_block_id = days_tab (l_days_ix + 1).time_building_block_id
974: WHERE time_building_block_id = days_tab (l_days_ix).time_building_block_id
975: AND absences_action = 'CREATE';
976:

Line 1111: DELETE FROM hxc_abs_ret_temp

1107: hr_utility.TRACE ('ABS:COMPLETED create_transactions for CREATE records');
1108: END IF;
1109:
1110: FORALL l_tx_index IN l_create_id_tab.FIRST .. l_create_id_tab.LAST
1111: DELETE FROM hxc_abs_ret_temp
1112: WHERE time_building_block_id = l_create_id_tab(l_tx_index);
1113:
1114: IF g_debug THEN
1115: hr_utility.set_location('ABS:Processing '||l_proc, 170);

Line 1145: DELETE FROM hxc_abs_ret_temp

1141: hr_utility.TRACE ('ABS:COMPLETED create_transactions for DELETE records');
1142: END IF;
1143:
1144: FORALL l_tx_index IN l_delete_id_tab.FIRST .. l_delete_id_tab.LAST
1145: DELETE FROM hxc_abs_ret_temp
1146: WHERE time_building_block_id = l_delete_id_tab(l_tx_index);
1147:
1148: IF g_debug THEN
1149: hr_utility.set_location('ABS:Processing '||l_proc, 180);

Line 1258: DELETE FROM hxc_abs_ret_temp

1254: p_description => SUBSTR (SQLERRM, 1, 2000 ) || g_fail_create_msg
1255: );
1256:
1257:
1258: DELETE FROM hxc_abs_ret_temp
1259: WHERE resource_id = g_resource_id
1260: AND trunc(day_start) >= trunc(g_tc_start)
1261: AND trunc(day_stop) <= trunc(g_tc_stop);
1262:

Line 1298: FROM hxc_abs_ret_temp temp

1294: SELECT time_building_block_id,
1295: object_version_number,
1296: trunc(day_start) day_start,
1297: trunc(day_stop) day_stop
1298: FROM hxc_abs_ret_temp temp
1299: START WITH time_building_block_id = c_tbb_id
1300: CONNECT BY PRIOR time_building_block_id = link_time_building_block_id;
1301:
1302: l_id_tab NUMTAB;

Line 1450: UPDATE hxc_abs_ret_temp

1446: THEN
1447:
1448: -- update the absence_attendance_id column for the details sent as SINGLE continuous absence entry
1449: FORALL l_index IN l_id_tab.FIRST .. l_id_tab.LAST
1450: UPDATE hxc_abs_ret_temp
1451: SET retrieval_status = 'SUCCESS',
1452: absence_attendance_id = l_absence_attendance_id
1453: WHERE time_building_block_id = l_id_tab(l_index)
1454: AND absence_attendance_id IS NULL;

Line 1516: FROM hxc_abs_ret_temp temp

1512: 'RET',
1513: g_resource_id,
1514: g_tc_start,
1515: g_tc_stop
1516: FROM hxc_abs_ret_temp temp
1517: WHERE temp.absence_attendance_id = l_absence_attendance_id
1518: AND temp.retrieval_status = 'SUCCESS'
1519: AND NOT EXISTS (
1520: SELECT 1

Line 1743: AND NOT EXISTS(select 1 from hxc_abs_ret_temp temp

1739: stop_time
1740: FROM hxc_abs_co_details absco
1741: WHERE absco.absence_attendance_id = p_absence_attendance_id
1742: AND absco.time_building_block_id > 0
1743: AND NOT EXISTS(select 1 from hxc_abs_ret_temp temp
1744: where temp.time_building_block_id = absco.time_building_block_id)
1745: ORDER BY 1 asc ;
1746:
1747: TYPE t_co_details IS TABLE OF co_details_cur%ROWTYPE;

Line 1851: UPDATE hxc_abs_ret_temp

1847: IF g_debug THEN
1848: hr_utility.set_location('ABS:Processing '||l_proc, 420);
1849: END IF;
1850:
1851: UPDATE hxc_abs_ret_temp
1852: SET retrieval_status = 'SUCCESS'
1853: WHERE absence_attendance_id = p_absence_attendance_id;
1854:
1855:

Line 1884: UPDATE hxc_abs_ret_temp

1880: UPDATE hxc_abs_co_details
1881: SET absence_attendance_id = NULL
1882: WHERE absence_attendance_id = p_absence_attendance_id;
1883:
1884: UPDATE hxc_abs_ret_temp
1885: SET retrieval_status = 'SUCCESS'
1886: WHERE absence_attendance_id = p_absence_attendance_id;
1887:
1888: IF g_debug THEN

Line 2217: FROM hxc_abs_ret_temp

2213: UPDATE hxc_abs_co_details
2214: SET absence_attendance_id = NULL
2215: WHERE time_building_block_id IN (
2216: SELECT time_building_block_id
2217: FROM hxc_abs_ret_temp
2218: WHERE absence_attendance_id = p_absence_attendance_id
2219: AND absences_action = 'DELETE')
2220: OR time_building_block_id < 0
2221: AND absence_attendance_id = p_absence_attendance_id;

Line 2259: UPDATE hxc_abs_ret_temp

2255: END IF;
2256:
2257: END IF;
2258:
2259: UPDATE hxc_abs_ret_temp
2260: SET retrieval_status = 'SUCCESS'
2261: WHERE absence_attendance_id = p_absence_attendance_id;
2262:
2263: IF g_debug THEN

Line 2282: UPDATE hxc_abs_ret_temp

2278: UPDATE hxc_abs_co_details
2279: SET absence_attendance_id = NULL
2280: WHERE absence_attendance_id = p_absence_attendance_id;
2281:
2282: UPDATE hxc_abs_ret_temp
2283: SET retrieval_status = 'SUCCESS'
2284: WHERE absence_attendance_id = p_absence_attendance_id;
2285:
2286: IF g_debug THEN