[Home] [Help]
693: PON_PF_SUPPLIER_VALUES
694: PON_PRICE_ELEMENTS
695: PON_PRICE_DIFFERENTIALS
696: PON_AUCTION_SHIPMENTS_ALL
697: PON_PARTY_LINE_EXCLUSIONS
698: PON_AUC_PAYMENTS_SHIPMENTS
699: Attachments
700: Update backing requisitions for lines being deleted.
701: PON_AUCTION_ITEM_PRICES_ALL
898: OR paip.group_line_id = p1.auction_line_number
899: OR paip.clm_base_line_num = p1.auction_line_number)
900: and auction_shipments.line_number = p1.auction_line_number);
901:
902: --delete from PON_PARTY_LINE_EXCLUSIONS
903: delete from pon_party_line_exclusions supplier_line_exclusions
904: where
905: auction_header_id = g_auction_header_id
906: and exists
899: OR paip.clm_base_line_num = p1.auction_line_number)
900: and auction_shipments.line_number = p1.auction_line_number);
901:
902: --delete from PON_PARTY_LINE_EXCLUSIONS
903: delete from pon_party_line_exclusions supplier_line_exclusions
904: where
905: auction_header_id = g_auction_header_id
906: and exists
907: (select