APPS.PON_AWARD_PKG dependencies on PON_OPTIMIZE_SCENARIOS

Line 2295: FROM pon_optimize_scenarios

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
2298: x_status := 'FAILURE';
2299: RETURN;

Line 2338: UPDATE pon_optimize_scenarios

2334: RETURN;
2335: END IF;
2336:
2337: -- unset the accepted date of the previously accepted scenario
2338: UPDATE pon_optimize_scenarios
2339: SET accepted_date = NULL
2340: WHERE accepted_date IS NOT NULL
2341: AND auction_header_id= l_auction_header_id;
2342:

Line 2344: UPDATE pon_optimize_scenarios

2340: WHERE accepted_date IS NOT NULL
2341: AND auction_header_id= l_auction_header_id;
2342:
2343: -- set accepted date of the accepted scenario
2344: UPDATE pon_optimize_scenarios
2345: SET accepted_date = SYSDATE,
2346: last_update_date = SYSDATE,
2347: last_updated_by = p_auctioneer_id
2348: WHERE scenario_id = p_scenario_id;

Line 2523: from pon_optimize_scenarios

2519: END;
2520:
2521: -- derive auction_header_id
2522: select auction_header_id into l_auction_header_id
2523: from pon_optimize_scenarios
2524: where scenario_id = p_scenario_id;
2525:
2526: -- store the next scenario id in a local variable
2527: select pon_optimize_scenarios_s.nextval

Line 2527: select pon_optimize_scenarios_s.nextval

2523: from pon_optimize_scenarios
2524: where scenario_id = p_scenario_id;
2525:
2526: -- store the next scenario id in a local variable
2527: select pon_optimize_scenarios_s.nextval
2528: into l_new_scenario_id from dual;
2529:
2530: IF(p_cost_scenario_flag = 'Y') THEN
2531:

Line 2539: from pon_optimize_scenarios

2535:
2536: ELSE
2537: select max(scenario_number) + 1
2538: into l_next_scenario_number
2539: from pon_optimize_scenarios
2540: where auction_header_id = l_auction_header_id
2541: and (cost_scenario_flag is null or cost_scenario_flag <> 'Y');
2542:
2543: END IF;

Line 2546: INSERT INTO PON_OPTIMIZE_SCENARIOS(

2542:
2543: END IF;
2544:
2545: --first copy the scenario
2546: INSERT INTO PON_OPTIMIZE_SCENARIOS(
2547: auction_header_id,
2548: scenario_id,
2549: scenario_name,
2550: scenario_number,

Line 2583: FROM pon_optimize_scenarios

2579: l_fnd_user_id,
2580: p_cost_scenario_flag,
2581: decode(p_cost_scenario_flag, 'Y', p_scenario_id, to_number(null)),
2582: nvl(constraint_priority_type, 'MANDATORY')
2583: FROM pon_optimize_scenarios
2584: WHERE scenario_id = p_scenario_id;
2585:
2586: -- copy the constraints
2587:

Line 3488: pon_optimize_scenarios pos

3484: l_order_type_lookup_code,
3485: l_auction_qty
3486: FROM pon_auction_headers_all pah,
3487: pon_auction_item_prices_all pai,
3488: pon_optimize_scenarios pos
3489: WHERE pah.auction_header_id = pai.auction_header_id
3490: AND pah.auction_header_id = pos.auction_header_id
3491: AND pai.line_number = p_line_number
3492: AND pos.scenario_id = l_new_scenario_id;

Line 3814: FROM PON_OPTIMIZE_SCENARIOS COST_SCENARIO,

3810: SELECT (PARENT_SCENARIO.TOTAL_AWARD_AMOUNT - COST_SCENARIO.TOTAL_AWARD_AMOUNT),
3811: PARENT_SCENARIO.SCENARIO_ID
3812: INTO L_COST_OF_CONSTRAINT,
3813: L_PARENT_SCENARIO_ID
3814: FROM PON_OPTIMIZE_SCENARIOS COST_SCENARIO,
3815: PON_OPTIMIZE_SCENARIOS PARENT_SCENARIO
3816: WHERE COST_SCENARIO.SCENARIO_ID = p_scenario_id
3817: AND PARENT_SCENARIO.SCENARIO_ID = COST_SCENARIO.PARENT_SCENARIO_ID;
3818:

Line 3815: PON_OPTIMIZE_SCENARIOS PARENT_SCENARIO

3811: PARENT_SCENARIO.SCENARIO_ID
3812: INTO L_COST_OF_CONSTRAINT,
3813: L_PARENT_SCENARIO_ID
3814: FROM PON_OPTIMIZE_SCENARIOS COST_SCENARIO,
3815: PON_OPTIMIZE_SCENARIOS PARENT_SCENARIO
3816: WHERE COST_SCENARIO.SCENARIO_ID = p_scenario_id
3817: AND PARENT_SCENARIO.SCENARIO_ID = COST_SCENARIO.PARENT_SCENARIO_ID;
3818:
3819: IF (g_debug_mode = 'Y') THEN

Line 4121: DELETE FROM PON_OPTIMIZE_SCENARIOS WHERE SCENARIO_ID = P_SCENARIO_ID;

4117: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scneario with p_scenario_id: ' || p_scenario_id );
4118: END IF;
4119: END IF;
4120:
4121: DELETE FROM PON_OPTIMIZE_SCENARIOS WHERE SCENARIO_ID = P_SCENARIO_ID;
4122:
4123: -- do some basic initialization
4124:
4125: l_num_constraints := 0;

Line 4283: pon_optimize_scenarios pos,

4279: l_current_rebate_col
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