7860:
7861: -- Bug 6914381
7862: -- If any transaction resulted in error, there is no need to
7863: -- do a reversal entry. Hence delete the same record from
7864: -- HXC_BEE_PREF_ADJ_LINES.
7865: -- Do it only for Xfer time from OTL to BEE.
7866:
7867: IF g_params.p_process IN ('BEE Retrieval Process', 'Apply Schedule Rules')
7868: THEN
7870: THEN
7871: FORALL i IN hxc_generic_retrieval_pkg.t_tx_detail_bb_id.FIRST..
7872: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.LAST
7873:
7874: DELETE FROM hxc_bee_pref_adj_lines
7875: WHERE detail_bb_id = t_tx_detail_bb_id(i)
7876: AND batch_source = DECODE(g_params.p_process,
7877: 'BEE Retrieval Process', 'OTM',
7878: 'Apply Schedule Rules' , 'Time Store')