APPS.PON_AWARD_PKG dependencies on PON_OPTIMIZE_RESULTS

Line 3480: FROM pon_optimize_results por, pon_bid_headers pbh

3476: -- retrieve auction header id and batch id
3477: BEGIN
3478: SELECT COUNT(DISTINCT pbh.bid_number)
3479: INTO l_num_of_non_shortlisted_supp
3480: FROM pon_optimize_results por, pon_bid_headers pbh
3481: WHERE por.bid_number = pbh.bid_number
3482: AND pbh.shortlist_flag = 'N'
3483: AND por.scenario_id = p_scenario_id;
3484:

Line 3516: FROM pon_optimize_results por, pon_auction_item_prices_all paip,

3512: por.bid_number,
3513: por.line_number,
3514: por.award_quantity,
3515: por.award_shipment_number
3516: FROM pon_optimize_results por, pon_auction_item_prices_all paip,
3517: pon_auction_headers_all pah,
3518: pon_bid_item_prices pbip
3519: WHERE pah.auction_header_id = l_auction_header_id
3520: AND pah.auction_header_id = paip.auction_header_id

Line 5377: from pon_optimize_results

5373: DELETE FROM PON_OPTIMIZE_BID_CLASS WHERE SCENARIO_ID = P_SCENARIO_ID;
5374: END IF;
5375:
5376: select count(*) into l_num_results
5377: from pon_optimize_results
5378: where scenario_id = p_scenario_id;
5379:
5380: IF(l_num_results > 0) THEN
5381: IF (g_debug_mode = 'Y') THEN

Line 5383: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario results from PON_OPTIMIZE_RESULTS for p_scenario_id: ' || p_scenario_id );

5379:
5380: IF(l_num_results > 0) THEN
5381: IF (g_debug_mode = 'Y') THEN
5382: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5383: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario results from PON_OPTIMIZE_RESULTS for p_scenario_id: ' || p_scenario_id );
5384: END IF;
5385: END IF;
5386:
5387: DELETE FROM PON_OPTIMIZE_RESULTS WHERE SCENARIO_ID = P_SCENARIO_ID;

Line 5387: DELETE FROM PON_OPTIMIZE_RESULTS WHERE SCENARIO_ID = P_SCENARIO_ID;

5383: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario results from PON_OPTIMIZE_RESULTS for p_scenario_id: ' || p_scenario_id );
5384: END IF;
5385: END IF;
5386:
5387: DELETE FROM PON_OPTIMIZE_RESULTS WHERE SCENARIO_ID = P_SCENARIO_ID;
5388:
5389: END IF;
5390:
5391: X_STATUS := 'SUCCESS';

Line 5500: pon_optimize_results por,

5496: FROM
5497: pon_bid_item_prices bi,
5498: pon_auction_item_prices_all ai,
5499: pon_optimize_scenarios pos,
5500: pon_optimize_results por,
5501: pon_bid_shipments pbs,
5502: pon_bid_headers pbh
5503: WHERE
5504: por.scenario_id = pos.scenario_id