APPS.HXT_RETRIEVAL_ROLLBACK dependencies on HXC_TRANSACTION_DETAILS

Line 3544: hxc_transaction_details htd,

3540: ret2.object_version_number,
3541: htd.transaction_detail_id
3542: FROM hxt_sum_hours_worked_f sum,
3543: hxc_ret_pay_details ret2,
3544: hxc_transaction_details htd,
3545: hxc_transactions ht
3546: WHERE sum.tim_id = p_tim_id
3547: AND sum.time_building_block_id = ret2.time_building_block_id
3548: AND sum.time_building_block_ovn = ret2.object_version_number

Line 3746: UPDATE hxc_transaction_details

3742: DELETE FROM hxc_ret_pay_details
3743: WHERE time_building_block_id = l_lines_time_building_block_id(i);
3744:
3745: FORALL i IN l_id_tab.FIRST..l_id_tab.LAST
3746: UPDATE hxc_transaction_details
3747: SET status = 'ROLLEDBACK'
3748: WHERE transaction_detail_id = l_lines_td_id(i);
3749: */
3750:

Line 3844: UPDATE hxc_transaction_details

3840: DELETE FROM hxc_ret_pay_details
3841: WHERE time_building_block_id = l_lines_time_building_block_id(i);
3842:
3843: FORALL i IN l_id_tab.FIRST..l_id_tab.LAST
3844: UPDATE hxc_transaction_details
3845: SET status = 'ROLLEDBACK',
3846: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id
3847: WHERE transaction_detail_id = l_lines_td_id(i);
3848: