APPS.PON_AWARD_PKG dependencies on PON_OPTIMIZE_RESULTS

Line 2283: FROM pon_optimize_results por, pon_bid_headers pbh

2279: -- retrieve auction header id and batch id
2280: BEGIN
2281: SELECT COUNT(DISTINCT pbh.bid_number)
2282: INTO l_num_of_non_shortlisted_supp
2283: FROM pon_optimize_results por, pon_bid_headers pbh
2284: WHERE por.bid_number = pbh.bid_number
2285: AND pbh.shortlist_flag = 'N'
2286: AND por.scenario_id = p_scenario_id;
2287:

Line 2319: FROM pon_optimize_results por, pon_auction_item_prices_all paip,

2315: por.bid_number,
2316: por.line_number,
2317: por.award_quantity,
2318: por.award_shipment_number
2319: FROM pon_optimize_results por, pon_auction_item_prices_all paip,
2320: pon_auction_headers_all pah,
2321: pon_bid_item_prices pbip
2322: WHERE pah.auction_header_id = l_auction_header_id
2323: AND pah.auction_header_id = paip.auction_header_id

Line 4161: from pon_optimize_results

4157: DELETE FROM PON_OPTIMIZE_BID_CLASS WHERE SCENARIO_ID = P_SCENARIO_ID;
4158: END IF;
4159:
4160: select count(*) into l_num_results
4161: from pon_optimize_results
4162: where scenario_id = p_scenario_id;
4163:
4164: IF(l_num_results > 0) THEN
4165: IF (g_debug_mode = 'Y') THEN

Line 4167: 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 );

4163:
4164: IF(l_num_results > 0) THEN
4165: IF (g_debug_mode = 'Y') THEN
4166: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4167: 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 );
4168: END IF;
4169: END IF;
4170:
4171: DELETE FROM PON_OPTIMIZE_RESULTS WHERE SCENARIO_ID = P_SCENARIO_ID;

Line 4171: DELETE FROM PON_OPTIMIZE_RESULTS WHERE SCENARIO_ID = P_SCENARIO_ID;

4167: 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 );
4168: END IF;
4169: END IF;
4170:
4171: DELETE FROM PON_OPTIMIZE_RESULTS WHERE SCENARIO_ID = P_SCENARIO_ID;
4172:
4173: END IF;
4174:
4175: X_STATUS := 'SUCCESS';

Line 4284: pon_optimize_results por,

4280: FROM
4281: pon_bid_item_prices bi,
4282: pon_auction_item_prices_all ai,
4283: pon_optimize_scenarios pos,
4284: pon_optimize_results por,
4285: pon_bid_shipments pbs,
4286: pon_bid_headers pbh
4287: WHERE
4288: por.scenario_id = pos.scenario_id