DBA Data[Home] [Help]

APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_BEE_PREF_ADJ_LINES

Line 9038: -- HXC_BEE_PREF_ADJ_LINES.

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

Line 9048: DELETE FROM hxc_bee_pref_adj_lines

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')