APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXC_RET_PAY_LATEST_DETAILS

Line 56: --- and inserted new records into hxc_ret_pay_latest_details

52: ---
53: --- Retro entries to each timecard has a retro batch. This retro batch is generated only
54: --- after explosion. Since the explosion happens at the end of the process, by that time
55: --- hxc_generic_retrieval_pkg.update_transaction_status would have updated all the existing
56: --- and inserted new records into hxc_ret_pay_latest_details
57: --- For all of these updated/inserted records, we need to mark batch_id column with the retro_batch_id
58: --- generated during explosion so that later, Xfer to BEE(Retro) correctly knows which records to
59: --- target.
60: ---

Line 151: UPDATE hxc_ret_pay_latest_details

147:
148: -- Updating records touched in this retrieval process here
149:
150: FORALL i IN l_bb_tab.FIRST..l_bb_tab.LAST
151: UPDATE hxc_ret_pay_latest_details
152: SET batch_id = l_ret_tab(i)
153: WHERE time_building_block_id = l_bb_tab(i)
154: AND object_version_number = l_ovn_tab(i)
155: AND request_id = FND_GLOBAL.CONC_request_id;

Line 169: UPDATE hxc_ret_pay_latest_details

165: -- but having un transferred retro batches.
166: -- We just move them to this retro batch.
167:
168: FORALL i IN l_bb_tab.FIRST..l_bb_tab.LAST
169: UPDATE hxc_ret_pay_latest_details
170: SET batch_id = l_ret_tab(i),
171: request_id = FND_GLOBAL.conc_request_id
172: WHERE time_building_block_id = l_bb_tab(i)
173: AND object_version_number = l_ovn_tab(i)

Line 354: UPDATE hxc_ret_pay_latest_details

350:
351: IF g_rdb_bb_tab.COUNT > 0
352: THEN
353: FORALL i IN g_rdb_bb_tab.FIRST..g_rdb_bb_tab.LAST
354: UPDATE hxc_ret_pay_latest_details
355: SET measure = old_measure,
356: attribute1 = old_attribute1,
357: attribute2 = old_attribute2,
358: attribute3 = old_attribute3,

Line 379: DELETE FROM hxc_ret_pay_latest_details

375: AND old_attribute3 IS NOT NULL;
376:
377:
378: FORALL i IN g_rdb_bb_tab.FIRST..g_rdb_bb_tab.LAST
379: DELETE FROM hxc_ret_pay_latest_details
380: WHERE time_building_block_id = g_rdb_bb_tab(i)
381: AND batch_id = g_rdb_retro_tab(i)
382: AND pbl_id IS NULL
383: AND old_measure IS NULL