APPS.PON_OPEN_INTERFACE_PVT dependencies on PON_AUCTION_ITEM_PRICES_EXT_B

Line 3845: DELETE FROM pon_auction_item_prices_ext_b WHERE auction_header_id = l_auction_header_id;

3841: DELETE FROM pon_attribute_scores 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'

Line 7061: DELETE FROM pon_auction_item_prices_ext_b WHERE auction_header_id = l_auction_header_id;

7057: DELETE FROM pon_attribute_scores 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'