eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AWARD_PKG dependencies on PON_AUCTION_SUMMARY

Line 3490: SELECT auction_header_id, pon_auction_summary_s.NEXTVAL

3486: x_status := 'NOT_SHORTLISTED';
3487: RETURN;
3488: END IF;
3489:
3490: SELECT auction_header_id, pon_auction_summary_s.NEXTVAL
3491: INTO l_auction_header_id, l_batch_id
3492: FROM pon_optimize_scenarios
3493: WHERE scenario_id = p_scenario_id;
3494: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 3502: INSERT into pon_auction_summary

3498:
3499: l_mode := g_AWARD_OPTIMIZATION;
3500:
3501: -- insert award results into interface table
3502: INSERT into pon_auction_summary
3503: (batch_id,
3504: auction_id,
3505: bid_number,
3506: line_number,

Line 3548: DELETE FROM pon_auction_summary

3544: last_updated_by = p_auctioneer_id
3545: WHERE scenario_id = p_scenario_id;
3546:
3547: -- clean up inteface table
3548: DELETE FROM pon_auction_summary
3549: WHERE batch_id = l_batch_id;
3550:
3551: END accept_award_scenario;
3552:

Line 3583: FROM pon_auction_summary pas

3579: pas.trading_partner_contact_id,
3580: pas.batch_id,
3581: ai.group_type,
3582: pas.award_shipment_number
3583: FROM pon_auction_summary pas
3584: , pon_auction_item_prices_all ai
3585: , pon_auction_headers_all ah
3586: WHERE
3587: pas.award_quantity >0