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_CO_DETAILS

Line 106: FROM hxc_abs_co_details absco

102: trunc(absco.start_date) start_date,
103: trunc(absco.end_date) end_date,
104: absco.time_building_block_id,
105: absco.object_version_number
106: FROM hxc_abs_co_details absco
107: WHERE absco.resource_id = g_resource_id
108: AND TRUNC (absco.start_time) >= TRUNC (g_tc_start)
109: AND TRUNC (absco.stop_time) <= TRUNC (g_tc_stop)
110: AND absco.stage <> 'RET'

Line 206: l_absence_attendance_id hxc_abs_co_details.absence_attendance_id%TYPE;

202: l_latest_date_to_tab DATETAB;
203:
204: l_txn_index NUMBER := 0;
205: l_pref_table hxc_preference_evaluation.t_pref_table;
206: l_absence_attendance_id hxc_abs_co_details.absence_attendance_id%TYPE;
207: l_proc VARCHAR2(100);
208: l_ed_days_ix BINARY_INTEGER := 0;
209: l_call_delete BOOLEAN;
210: ret_rules_not_set EXCEPTION;

Line 304: FROM hxc_abs_co_details co,

300: DELETE FROM hxc_pay_latest_details
301: WHERE (time_building_block_id,object_version_number)
302: IN ( SELECT co.time_building_block_id,
303: co.object_version_number
304: FROM hxc_abs_co_details co,
305: hxc_transaction_details htd,
306: hxc_transactions ht
307: WHERE co.resource_id = g_resource_id
308: AND co.start_time = g_tc_start

Line 451: FROM hxc_abs_co_details absco,

447: NULL , --retrieval_status,
448: 'DELETE' , --absences_action,
449: absco.element_type_id , --element_type_id,
450: NULL --link_time_building_block_id
451: FROM hxc_abs_co_details absco,
452: hxc_time_building_blocks detail,
453: hxc_time_building_blocks DAY,
454: per_absence_attendances absatt
455: WHERE absco.resource_id = g_resource_id

Line 669: UPDATE hxc_abs_co_details

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
670: SET object_version_number = l_ovn_tab (l_ix)
671: WHERE time_building_block_id = l_id_tab(l_ix)
672: AND stage = 'RET';
673:

Line 1285: -- Procedure to Create Absences in HR module and update HXC_ABS_CO_DETAILS with the latest absence info.

1281:
1282: /*********CALLED PROCEDURES**********/
1283:
1284:
1285: -- Procedure to Create Absences in HR module and update HXC_ABS_CO_DETAILS with the latest absence info.
1286:
1287: PROCEDURE create_absences (
1288: p_absences IN hxc_abs_retrieval_pkg.t_absences,
1289: p_uom IN VARCHAR2

Line 1462: UPDATE hxc_abs_co_details

1458: END IF;
1459:
1460: -- update absence details if it is already present in CO table
1461: FORALL l_index IN l_id_tab.FIRST .. l_id_tab.LAST
1462: UPDATE hxc_abs_co_details
1463: SET object_version_number = l_ovn_tab(l_index),
1464: absence_type_id = l_absence_attendance_type_id,
1465: absence_attendance_id = l_absence_attendance_id,
1466: element_type_id = l_element_type_id,

Line 1476: UPDATE hxc_abs_co_details

1472: AND stage = 'RET';
1473:
1474:
1475: FORALL l_index IN l_id_tab.FIRST .. l_id_tab.LAST
1476: UPDATE hxc_abs_co_details
1477: SET absence_attendance_id = l_absence_attendance_id
1478: WHERE time_building_block_id = l_id_tab(l_index)
1479: AND stage <> 'RET';
1480:

Line 1482: hr_utility.TRACE ('ABS:Updated HXC_ABS_CO_DETAILS');

1478: WHERE time_building_block_id = l_id_tab(l_index)
1479: AND stage <> 'RET';
1480:
1481: IF g_debug THEN
1482: hr_utility.TRACE ('ABS:Updated HXC_ABS_CO_DETAILS');
1483: END IF;
1484:
1485: END IF;
1486:

Line 1487: -- HXC_ABS_CO_DETAILS should contain only unique records for each detail id belonging to the timecard

1483: END IF;
1484:
1485: END IF;
1486:
1487: -- HXC_ABS_CO_DETAILS should contain only unique records for each detail id belonging to the timecard
1488: -- inserting fresh unplanned absence records
1489: INSERT INTO hxc_abs_co_details
1490: (TIME_BUILDING_BLOCK_ID,
1491: OBJECT_VERSION_NUMBER ,

Line 1489: INSERT INTO hxc_abs_co_details

1485: END IF;
1486:
1487: -- HXC_ABS_CO_DETAILS should contain only unique records for each detail id belonging to the timecard
1488: -- inserting fresh unplanned absence records
1489: INSERT INTO hxc_abs_co_details
1490: (TIME_BUILDING_BLOCK_ID,
1491: OBJECT_VERSION_NUMBER ,
1492: ABSENCE_TYPE_ID ,
1493: ABSENCE_ATTENDANCE_ID ,

Line 1521: FROM hxc_abs_co_details absco

1517: WHERE temp.absence_attendance_id = l_absence_attendance_id
1518: AND temp.retrieval_status = 'SUCCESS'
1519: AND NOT EXISTS (
1520: SELECT 1
1521: FROM hxc_abs_co_details absco
1522: WHERE absco.time_building_block_id = temp.time_building_block_id));
1523:
1524: IF g_debug THEN
1525: hr_utility.TRACE ('ABS:Created new records in CO table = ' || SQL%ROWCOUNT);

Line 1691: UPDATE hxc_abs_co_details

1687:
1688: -- update the CO table with the new absence attendance id for those untouched absence details
1689: -- which are not edited but recreated
1690:
1691: UPDATE hxc_abs_co_details
1692: SET absence_attendance_id = l_new_absence_attendance_id
1693: WHERE TRUNC (start_date) BETWEEN TRUNC (l_date_start)
1694: AND TRUNC (l_date_end)
1695: AND absence_attendance_id = p_old_absence_attendance_id;

Line 1740: FROM hxc_abs_co_details absco

1736: to_char(start_date, 'HH24:MI') time_start,
1737: to_char(end_date, 'HH24:MI') time_end,
1738: start_time,
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)

Line 1839: UPDATE hxc_abs_co_details

1835: p_object_version_number => NULL,
1836: p_called_from => 809
1837: );
1838:
1839: UPDATE hxc_abs_co_details
1840: SET absence_attendance_id = NULL
1841: WHERE absence_attendance_id = p_absence_attendance_id;
1842:
1843: IF g_debug THEN

Line 1880: UPDATE hxc_abs_co_details

1876: IF g_debug THEN
1877: hr_utility.trace('ABS:These prepop absences are set to View Only and not deleted from HR on timecard delete');
1878: END IF;
1879:
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

Line 2213: UPDATE hxc_abs_co_details

2209: END IF;
2210:
2211:
2212: -- delete absences details from absco table which are updated/deleted from Timecard
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

Line 2278: UPDATE hxc_abs_co_details

2274: IF g_debug THEN
2275: hr_utility.trace('ABS:Absences with source HR are not allowed to be deleted on timecard delete');
2276: END IF;
2277:
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