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_GENERIC_RETRIEVAL_PKG dependencies on HXC_RET_PAY_DETAILS

Line 9712: -- HXC_RET_PAY_DETAILS is our Dump to hold all retrievals done ever

9708: FND_GLOBAL.conc_request_id,
9709: l_application_set_id(i));
9710:
9711: -- Bug 12919783
9712: -- HXC_RET_PAY_DETAILS is our Dump to hold all retrievals done ever
9713: -- Insert all the records there.
9714: FORALL i IN t_l_time_building_block_id.FIRST..t_l_time_building_block_id.LAST
9715: INSERT INTO hxc_ret_pay_details
9716: (resource_id,

Line 9715: INSERT INTO hxc_ret_pay_details

9711: -- Bug 12919783
9712: -- HXC_RET_PAY_DETAILS is our Dump to hold all retrievals done ever
9713: -- Insert all the records there.
9714: FORALL i IN t_l_time_building_block_id.FIRST..t_l_time_building_block_id.LAST
9715: INSERT INTO hxc_ret_pay_details
9716: (resource_id,
9717: time_building_block_id,
9718: approval_status,
9719: start_time,

Line 9782: UPDATE hxc_ret_pay_details

9778: AND object_version_number = l_rec_ovn(i);
9779:
9780: -- Bug 12919783
9781: FORALL i IN l_rec_bb_id.FIRST..l_rec_bb_id.LAST
9782: UPDATE hxc_ret_pay_details
9783: SET pbl_id = l_rec_id(i),
9784: batch_id = l_batch_id(i)
9785: WHERE time_building_block_id = l_rec_bb_id(i)
9786: AND object_version_number = l_rec_ovn(i);

Line 9841: UPDATE hxc_ret_pay_details

9837: AND old_ovn = l_rec_ovn(i);
9838:
9839: -- Bug 12919783
9840: FORALL i IN l_rec_bb_id.FIRST..l_rec_bb_id.LAST
9841: UPDATE hxc_ret_pay_details
9842: SET retro_pbl_id = l_rec_id(i),
9843: retro_batch_id = l_batch_id(i),
9844: old_ovn = l_rec_ovn(i)
9845: WHERE time_building_block_id = l_rec_bb_id(i)