APPS.PON_AWARD_PKG dependencies on PON_OPTIMIZE_SCENARIOS

Line 3492: FROM pon_optimize_scenarios

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
3495: x_status := 'FAILURE';
3496: RETURN;

Line 3535: UPDATE pon_optimize_scenarios

3531: RETURN;
3532: END IF;
3533:
3534: -- unset the accepted date of the previously accepted scenario
3535: UPDATE pon_optimize_scenarios
3536: SET accepted_date = NULL
3537: WHERE accepted_date IS NOT NULL
3538: AND auction_header_id= l_auction_header_id;
3539:

Line 3541: UPDATE pon_optimize_scenarios

3537: WHERE accepted_date IS NOT NULL
3538: AND auction_header_id= l_auction_header_id;
3539:
3540: -- set accepted date of the accepted scenario
3541: UPDATE pon_optimize_scenarios
3542: SET accepted_date = SYSDATE,
3543: last_update_date = SYSDATE,
3544: last_updated_by = p_auctioneer_id
3545: WHERE scenario_id = p_scenario_id;

Line 3720: from pon_optimize_scenarios

3716: END;
3717:
3718: -- derive auction_header_id
3719: select auction_header_id into l_auction_header_id
3720: from pon_optimize_scenarios
3721: where scenario_id = p_scenario_id;
3722:
3723: -- store the next scenario id in a local variable
3724: select pon_optimize_scenarios_s.nextval

Line 3724: select pon_optimize_scenarios_s.nextval

3720: from pon_optimize_scenarios
3721: where scenario_id = p_scenario_id;
3722:
3723: -- store the next scenario id in a local variable
3724: select pon_optimize_scenarios_s.nextval
3725: into l_new_scenario_id from dual;
3726:
3727: IF(p_cost_scenario_flag = 'Y') THEN
3728:

Line 3736: from pon_optimize_scenarios

3732:
3733: ELSE
3734: select max(scenario_number) + 1
3735: into l_next_scenario_number
3736: from pon_optimize_scenarios
3737: where auction_header_id = l_auction_header_id
3738: and (cost_scenario_flag is null or cost_scenario_flag <> 'Y');
3739:
3740: END IF;

Line 3743: INSERT INTO PON_OPTIMIZE_SCENARIOS(

3739:
3740: END IF;
3741:
3742: --first copy the scenario
3743: INSERT INTO PON_OPTIMIZE_SCENARIOS(
3744: auction_header_id,
3745: scenario_id,
3746: scenario_name,
3747: scenario_number,

Line 3780: FROM pon_optimize_scenarios

3776: l_fnd_user_id,
3777: p_cost_scenario_flag,
3778: decode(p_cost_scenario_flag, 'Y', p_scenario_id, to_number(null)),
3779: nvl(constraint_priority_type, 'MANDATORY')
3780: FROM pon_optimize_scenarios
3781: WHERE scenario_id = p_scenario_id;
3782:
3783: -- copy the constraints
3784:

Line 4704: pon_optimize_scenarios pos

4700: l_order_type_lookup_code,
4701: l_auction_qty
4702: FROM pon_auction_headers_all pah,
4703: pon_auction_item_prices_all pai,
4704: pon_optimize_scenarios pos
4705: WHERE pah.auction_header_id = pai.auction_header_id
4706: AND pah.auction_header_id = pos.auction_header_id
4707: AND pai.line_number = p_line_number
4708: AND pos.scenario_id = l_new_scenario_id;

Line 5030: FROM PON_OPTIMIZE_SCENARIOS COST_SCENARIO,

5026: SELECT (PARENT_SCENARIO.TOTAL_AWARD_AMOUNT - COST_SCENARIO.TOTAL_AWARD_AMOUNT),
5027: PARENT_SCENARIO.SCENARIO_ID
5028: INTO L_COST_OF_CONSTRAINT,
5029: L_PARENT_SCENARIO_ID
5030: FROM PON_OPTIMIZE_SCENARIOS COST_SCENARIO,
5031: PON_OPTIMIZE_SCENARIOS PARENT_SCENARIO
5032: WHERE COST_SCENARIO.SCENARIO_ID = p_scenario_id
5033: AND PARENT_SCENARIO.SCENARIO_ID = COST_SCENARIO.PARENT_SCENARIO_ID;
5034:

Line 5031: PON_OPTIMIZE_SCENARIOS PARENT_SCENARIO

5027: PARENT_SCENARIO.SCENARIO_ID
5028: INTO L_COST_OF_CONSTRAINT,
5029: L_PARENT_SCENARIO_ID
5030: FROM PON_OPTIMIZE_SCENARIOS COST_SCENARIO,
5031: PON_OPTIMIZE_SCENARIOS PARENT_SCENARIO
5032: WHERE COST_SCENARIO.SCENARIO_ID = p_scenario_id
5033: AND PARENT_SCENARIO.SCENARIO_ID = COST_SCENARIO.PARENT_SCENARIO_ID;
5034:
5035: IF (g_debug_mode = 'Y') THEN

Line 5337: DELETE FROM PON_OPTIMIZE_SCENARIOS WHERE SCENARIO_ID = P_SCENARIO_ID;

5333: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scneario with p_scenario_id: ' || p_scenario_id );
5334: END IF;
5335: END IF;
5336:
5337: DELETE FROM PON_OPTIMIZE_SCENARIOS WHERE SCENARIO_ID = P_SCENARIO_ID;
5338:
5339: -- do some basic initialization
5340:
5341: l_num_constraints := 0;

Line 5499: pon_optimize_scenarios pos,

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