DBA Data[Home] [Help]

APPS.PON_OPEN_INTERFACE_PVT dependencies on PON_PRICE_ELEMENTS

Line 3835: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;

3831: --ROLLBACK TO NEG_CREATION;
3832: IF ( l_auction_header_id IS NOT NULL ) THEN
3833: DELETE FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
3834: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;
3835: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;
3836: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
3837: DELETE FROM pon_auc_payments_shipments WHERE auction_header_id = l_auction_header_id;
3838: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;
3839: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;

Line 7052: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;

7048: --ROLLBACK TO NEG_CREATION;
7049: IF ( l_auction_header_id IS NOT NULL ) THEN
7050: DELETE FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
7051: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;
7052: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;
7053: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
7054: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;
7055: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;
7056: DELETE FROM pon_bidding_parties WHERE auction_header_id = l_auction_header_id;