DBA Data[Home] [Help]

APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_PF_SUPPLIER_VALUES

Line 693: PON_PF_SUPPLIER_VALUES

689: be deleted from the tables in the following order. For LOTS and
690: GROUP marked as deleted the corresponding children are also deleted.
691: PON_ATTRIBUTE_SCORES
692: PON_AUCTION_ATTRIBUTES
693: PON_PF_SUPPLIER_VALUES
694: PON_PRICE_ELEMENTS
695: PON_PRICE_DIFFERENTIALS
696: PON_AUCTION_SHIPMENTS_ALL
697: PON_PARTY_LINE_EXCLUSIONS

Line 812: --delete from PON_PF_SUPPLIER_VALUES

808: OR paip.clm_base_line_num = p1.auction_line_number)
809: and auction_attributes.line_number = p1.auction_line_number);
810: END IF;
811:
812: --delete from PON_PF_SUPPLIER_VALUES
813: if(g_price_element_enabled_flag = 'Y') then
814: delete from pon_pf_supplier_values auction_pf_values
815: where
816: auction_pf_values.auction_header_id = g_auction_header_id

Line 814: delete from pon_pf_supplier_values auction_pf_values

810: END IF;
811:
812: --delete from PON_PF_SUPPLIER_VALUES
813: if(g_price_element_enabled_flag = 'Y') then
814: delete from pon_pf_supplier_values auction_pf_values
815: where
816: auction_pf_values.auction_header_id = g_auction_header_id
817: and exists
818: (select