APPS.PON_AWARD_PKG dependencies on PON_AUCTION_SUMMARY

Line 2293: SELECT auction_header_id, pon_auction_summary_s.NEXTVAL

2289: x_status := 'NOT_SHORTLISTED';
2290: RETURN;
2291: END IF;
2292:
2293: SELECT auction_header_id, pon_auction_summary_s.NEXTVAL
2294: INTO l_auction_header_id, l_batch_id
2295: FROM pon_optimize_scenarios
2296: WHERE scenario_id = p_scenario_id;
2297: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2305: INSERT into pon_auction_summary

2301:
2302: l_mode := g_AWARD_OPTIMIZATION;
2303:
2304: -- insert award results into interface table
2305: INSERT into pon_auction_summary
2306: (batch_id,
2307: auction_id,
2308: bid_number,
2309: line_number,

Line 2351: DELETE FROM pon_auction_summary

2347: last_updated_by = p_auctioneer_id
2348: WHERE scenario_id = p_scenario_id;
2349:
2350: -- clean up inteface table
2351: DELETE FROM pon_auction_summary
2352: WHERE batch_id = l_batch_id;
2353:
2354: END accept_award_scenario;
2355:

Line 2386: FROM pon_auction_summary pas

2382: pas.trading_partner_contact_id,
2383: pas.batch_id,
2384: ai.group_type,
2385: pas.award_shipment_number
2386: FROM pon_auction_summary pas
2387: , pon_auction_item_prices_all ai
2388: , pon_auction_headers_all ah
2389: WHERE
2390: pas.award_quantity >0