[Home] [Help]
686: PON_ATTRIBUTE_SCORES
687: PON_AUCTION_ATTRIBUTES
688: PON_PF_SUPPLIER_VALUES
689: PON_PRICE_ELEMENTS
690: PON_PRICE_DIFFERENTIALS
691: PON_AUCTION_SHIPMENTS_ALL
692: PON_PARTY_LINE_EXCLUSIONS
693: PON_AUC_PAYMENTS_SHIPMENTS
694: Attachments
834: and price_elements.line_number = p1.auction_line_number);
835: END IF;
836:
837:
838: --delete from PON_PRICE_DIFFERENTIALS
839: if(g_price_differentials_flag = 'Y') then
840: delete from pon_price_differentials price_differentials
841: where
842: auction_header_id = g_auction_header_id
836:
837:
838: --delete from PON_PRICE_DIFFERENTIALS
839: if(g_price_differentials_flag = 'Y') then
840: delete from pon_price_differentials price_differentials
841: where
842: auction_header_id = g_auction_header_id
843: and exists
844: (select
1249: PARAMETERS: NONE
1250:
1251: COMMENT : This procedure will add the price differentials corresponding
1252: to the new lines from the PON_AUC_PRICE_DIFFER_INT interface table
1253: to the PON_PRICE_DIFFERENTIALS transaction tables.
1254: ======================================================================*/
1255: PROCEDURE ADD_PRICE_DIFFERENTIALS is
1256:
1257: l_module CONSTANT VARCHAR2(23) := 'ADD_PRICE_DIFFERENTIALS';
1261: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1262: print_debug_log(l_module,'ADD_PRICE_DIFFERENTIALS START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1263: END IF;
1264:
1265: insert into PON_PRICE_DIFFERENTIALS
1266: fields
1267: (AUCTION_HEADER_ID,
1268: LINE_NUMBER,
1269: SHIPMENT_NUMBER,
1917: print_debug_log(l_module,'UPDATE_PRICE_DIFFERNTIALS START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1918: END IF;
1919:
1920: -- Delete existing price differentials for updated lines
1921: delete from PON_PRICE_DIFFERENTIALS price_differentials
1922: where
1923: auction_header_id = g_auction_header_id
1924: and
1925: LINE_NUMBER =
1932: and price_differentials.line_number = paip_int.auction_line_number
1933: and paip_int.action = g_update_action);
1934:
1935: -- Add price differentials from the spreadsheet.
1936: insert into pon_price_differentials
1937: fields
1938: (auction_header_id,
1939: line_number,
1940: shipment_number,