9034:
9035: -- Bug 6914381
9036: -- If any transaction resulted in error, there is no need to
9037: -- do a reversal entry. Hence delete the same record from
9038: -- HXC_BEE_PREF_ADJ_LINES.
9039: -- Do it only for Xfer time from OTL to BEE.
9040:
9041: IF g_params.p_process IN ('BEE Retrieval Process', 'Apply Schedule Rules')
9042: THEN
9044: THEN
9045: FORALL i IN hxc_generic_retrieval_pkg.t_tx_detail_bb_id.FIRST..
9046: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.LAST
9047:
9048: DELETE FROM hxc_bee_pref_adj_lines
9049: WHERE detail_bb_id = t_tx_detail_bb_id(i)
9050: AND batch_source = DECODE(g_params.p_process,
9051: 'BEE Retrieval Process', 'OTM',
9052: 'Apply Schedule Rules' , 'Time Store')