DBA Data[Home] [Help]

APPS.OE_OE_PRICING_AVAILABILITY dependencies on MRP_ATP_PUB

Line 127: ( p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ

123: END IS_PRICING_AVAILIBILITY; --End of bug#7380336
124:
125:
126: Procedure Initialize_mrp_record
127: ( p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
128: ,l_count IN NUMBER) IS
129:
130: l_return_status varchar2(10);
131:

Line 161: ,p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ

157:
158:
159: Procedure Check_Results_from_rec (
160: in_global_orgs in varchar2
161: ,p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
162: ,x_return_status OUT NOCOPY VARCHAR2
163:
164: ,x_msg_count OUT NOCOPY NUMBER
165:

Line 438: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

434: x_error_message out nocopy varchar2
435: ) IS
436:
437: l_session_id NUMBER := 0;
438: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
439: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
440: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
441: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
442: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 439: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

435: ) IS
436:
437: l_session_id NUMBER := 0;
438: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
439: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
440: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
441: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
442: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
443: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 440: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

436:
437: l_session_id NUMBER := 0;
438: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
439: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
440: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
441: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
442: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
443: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
444: I NUMBER := 1;

Line 441: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

437: l_session_id NUMBER := 0;
438: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
439: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
440: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
441: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
442: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
443: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
444: I NUMBER := 1;
445: l_mrp_calc_sd VARCHAR2(240);--bug14222176

Line 442: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

438: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
439: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
440: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
441: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
442: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
443: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
444: I NUMBER := 1;
445: l_mrp_calc_sd VARCHAR2(240);--bug14222176
446:

Line 443: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

439: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
440: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
441: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
442: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
443: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
444: I NUMBER := 1;
445: l_mrp_calc_sd VARCHAR2(240);--bug14222176
446:
447:

Line 575: MRP_ATP_PUB.Call_ATP (

571: IF l_debug_level > 0 THEN
572: print_time('Calling MRP');
573: END IF;
574:
575: MRP_ATP_PUB.Call_ATP (
576: p_session_id => l_session_id
577: , p_atp_rec => in_atp_rec
578: , x_atp_rec => x_atp_rec
579: , x_atp_supply_demand => l_atp_supply_demand

Line 592: oe_debug_pub.add( 'AFTER CALL MRP_ATP_PUB.CALL_ATP STS='||X_RETURN_STATUS|| ' MSG COUNT='||X_MSG_COUNT);

588: print_time('After Calling MRP');
589: END IF;
590:
591: IF l_debug_level > 0 THEN
592: oe_debug_pub.add( 'AFTER CALL MRP_ATP_PUB.CALL_ATP STS='||X_RETURN_STATUS|| ' MSG COUNT='||X_MSG_COUNT);
593:
594: IF x_atp_rec.available_quantity.COUNT > 0 AND
595: x_atp_rec.source_organization_id.COUNT > 0 then
596: oe_debug_pub.add( ' MSG DATA='||X_MSG_DATA|| 'AVL QTY='|| X_ATP_REC.AVAILABLE_QUANTITY ( 1 ) ||

Line 6358: --l_item_arr mrp_atp_pub.number_arr := mrp_atp_pub.number_arr(1);

6354: x_plan_name varchar2(300);
6355: x_ret_code varchar2(300);
6356: x_err_mesg varchar2(2000);
6357: l_session_id number;
6358: --l_item_arr mrp_atp_pub.number_arr := mrp_atp_pub.number_arr(1);
6359: l_organization_id number;
6360: x_sources mrp_atp_pvt.atp_source_typ;
6361: l_calling_module number;
6362: x_error_mesg varchar2(2000);