[Home] [Help]
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
698: PON_AUC_PAYMENTS_SHIPMENTS
699: Attachments
854: and price_elements.line_number = p1.auction_line_number);
855: END IF;
856:
857:
858: --delete from PON_PRICE_DIFFERENTIALS
859: if(g_price_differentials_flag = 'Y') then
860: delete from pon_price_differentials price_differentials
861: where
862: auction_header_id = g_auction_header_id
856:
857:
858: --delete from PON_PRICE_DIFFERENTIALS
859: if(g_price_differentials_flag = 'Y') then
860: delete from pon_price_differentials price_differentials
861: where
862: auction_header_id = g_auction_header_id
863: and exists
864: (select
1470: PARAMETERS: NONE
1471:
1472: COMMENT : This procedure will add the price differentials corresponding
1473: to the new lines from the PON_AUC_PRICE_DIFFER_INT interface table
1474: to the PON_PRICE_DIFFERENTIALS transaction tables.
1475: ======================================================================*/
1476: PROCEDURE ADD_PRICE_DIFFERENTIALS is
1477:
1478: l_module CONSTANT VARCHAR2(23) := 'ADD_PRICE_DIFFERENTIALS';
1482: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1483: print_debug_log(l_module,'ADD_PRICE_DIFFERENTIALS START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
1484: END IF;
1485:
1486: insert into PON_PRICE_DIFFERENTIALS
1487: fields
1488: (AUCTION_HEADER_ID,
1489: LINE_NUMBER,
1490: SHIPMENT_NUMBER,
2177: print_debug_log(l_module,'UPDATE_PRICE_DIFFERNTIALS START g_batch_id = '||g_batch_id ||' g_auction_header_id '||g_auction_header_id);
2178: END IF;
2179:
2180: -- Delete existing price differentials for updated lines
2181: delete from PON_PRICE_DIFFERENTIALS price_differentials
2182: where
2183: auction_header_id = g_auction_header_id
2184: and
2185: LINE_NUMBER =
2192: and price_differentials.line_number = paip_int.auction_line_number
2193: and paip_int.action = g_update_action);
2194:
2195: -- Add price differentials from the spreadsheet.
2196: insert into pon_price_differentials
2197: fields
2198: (auction_header_id,
2199: line_number,
2200: shipment_number,