DBA Data[Home] [Help]

APPS.HXT_BATCH_PROCESS dependencies on HXC_RET_PAY_DETAILS

Line 704: UPDATE hxc_ret_pay_details

700: END IF;
701:
702: l_tc_tab := NUMTAB();
703:
704: UPDATE hxc_ret_pay_details
705: SET batch_id = l_temp_batch_upd_id
706: WHERE batch_id = p_merge_batches(l_loop_index1).batch_id
707: RETURNING timecard_id
708: BULK COLLECT INTO l_tc_tab;

Line 712: hr_utility.trace('List of timecards updated in hxc_ret_pay_details ');

708: BULK COLLECT INTO l_tc_tab;
709:
710: IF l_tc_tab.COUNT > 0
711: THEN
712: hr_utility.trace('List of timecards updated in hxc_ret_pay_details ');
713: FOR i IN l_tc_tab.FIRST..l_tc_tab.LAST
714: LOOP
715: hr_utility.trace(' Timecard id '||l_tc_tab(i));
716: END LOOP;