DBA Data[Home] [Help]

APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_LD_ROLLBACK_TIMECARDS_ALL

Line 9899: UPDATE hxc_ld_rollback_timecards_all

9895: IF l_success_tc.COUNT > 0
9896: THEN
9897:
9898: FORALL rlbk IN l_success_tc.FIRST..l_success_tc.LAST
9899: UPDATE hxc_ld_rollback_timecards_all
9900: SET request_id = FND_Global.conc_request_id
9901: WHERE timecard_id = l_success_tc(rlbk)
9902: RETURNING timecard_id BULK COLLECT INTO l_rlbk_elig_tc1;
9903:

Line 9907: INSERT INTO hxc_ld_rollback_timecards_all

9903:
9904: l_rlbk_elig_tc2 := l_success_tc MULTISET EXCEPT l_rlbk_elig_tc1;
9905:
9906: FORALL rlbk IN l_rlbk_elig_tc2.FIRST..l_rlbk_elig_tc2.LAST
9907: INSERT INTO hxc_ld_rollback_timecards_all
9908: (timecard_id, request_id)
9909: VALUES (l_rlbk_elig_tc2(rlbk),FND_GLOBAL.conc_request_id);
9910:
9911: END IF;