APPS.PON_OPEN_INTERFACE_PVT dependencies on PON_AUCTION_ITEM_PRICES_EXT_TL

Line 3846: DELETE FROM pon_auction_item_prices_ext_tl WHERE auction_header_id = l_auction_header_id;

3842: DELETE FROM pon_auction_sections WHERE auction_header_id = l_auction_header_id;
3843: DELETE FROM pon_auction_headers_ext_b WHERE auction_header_id = l_auction_header_id;
3844: DELETE FROM pon_auction_headers_ext_tl WHERE auction_header_id = l_auction_header_id;
3845: DELETE FROM pon_auction_item_prices_ext_b WHERE auction_header_id = l_auction_header_id;
3846: DELETE FROM pon_auction_item_prices_ext_tl WHERE auction_header_id = l_auction_header_id;
3847: END IF;
3848: UPDATE pon_auction_headers_interface
3849: SET PROCESSING_STATUS_CODE = 'FAILED'
3850: WHERE batch_id = l_batch_id;

Line 7062: DELETE FROM pon_auction_item_prices_ext_tl WHERE auction_header_id = l_auction_header_id;

7058: DELETE FROM pon_auction_sections WHERE auction_header_id = l_auction_header_id;
7059: DELETE FROM pon_auction_headers_ext_b WHERE auction_header_id = l_auction_header_id;
7060: DELETE FROM pon_auction_headers_ext_tl WHERE auction_header_id = l_auction_header_id;
7061: DELETE FROM pon_auction_item_prices_ext_b WHERE auction_header_id = l_auction_header_id;
7062: DELETE FROM pon_auction_item_prices_ext_tl WHERE auction_header_id = l_auction_header_id;
7063: END IF;
7064: UPDATE pon_auction_headers_interface
7065: SET PROCESSING_STATUS_CODE = 'FAILED'
7066: WHERE batch_id = l_batch_id;