DBA Data[Home] [Help]

APPS.OE_OE_AVAILABILITY dependencies on MRP_ATP_PUB

Line 223: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

219: x_error_message out nocopy varchar2
220: ) IS
221:
222: l_session_id NUMBER := 0;
223: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
224: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
225: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
226: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
227: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 224: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

220: ) IS
221:
222: l_session_id NUMBER := 0;
223: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
224: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
225: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
226: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
227: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
228: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 225: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

221:
222: l_session_id NUMBER := 0;
223: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
224: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
225: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
226: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
227: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
228: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
229: I NUMBER := 1;

Line 226: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

222: l_session_id NUMBER := 0;
223: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
224: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
225: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
226: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
227: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
228: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
229: I NUMBER := 1;
230: l_mrp_calc_sd VARCHAR2(240);--bug14222176

Line 227: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

223: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
224: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
225: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
226: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
227: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
228: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
229: I NUMBER := 1;
230: l_mrp_calc_sd VARCHAR2(240);--bug14222176
231:

Line 228: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

224: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
225: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
226: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
227: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
228: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
229: I NUMBER := 1;
230: l_mrp_calc_sd VARCHAR2(240);--bug14222176
231:
232: --

Line 330: MRP_ATP_PUB.Call_ATP (

326: IF l_debug_level > 0 THEN
327: print_time('Calling MRP');
328: END IF;
329:
330: MRP_ATP_PUB.Call_ATP (
331: p_session_id => l_session_id
332: , p_atp_rec => in_atp_rec
333: , x_atp_rec => x_atp_rec
334: , x_atp_supply_demand => l_atp_supply_demand

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

343: print_time('After Calling MRP');
344: END IF;
345:
346: IF l_debug_level > 0 THEN
347: oe_debug_pub.add( 'AFTER CALL MRP_ATP_PUB.CALL_ATP STS='||X_RETURN_STATUS|| ' MSG COUNT='||X_MSG_COUNT);
348:
349: IF x_atp_rec.available_quantity.COUNT > 0 AND
350: x_atp_rec.source_organization_id.COUNT > 0 then
351: oe_debug_pub.add( ' MSG DATA='||X_MSG_DATA|| 'AVL QTY='|| X_ATP_REC.AVAILABLE_QUANTITY ( 1 ) ||

Line 820: ,p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ

816:
817:
818: Procedure Check_Results_from_rec (
819: in_global_orgs in varchar2
820: ,p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
821: ,x_return_status OUT NOCOPY VARCHAR2
822:
823: ,x_msg_count OUT NOCOPY NUMBER
824:

Line 1068: ( p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ

1064: END Check_Results_from_rec;
1065:
1066:
1067: Procedure Initialize_mrp_record
1068: ( p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
1069: ,l_count IN NUMBER) IS
1070:
1071: l_return_status varchar2(10);
1072:

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

4742: x_plan_name varchar2(300);
4743: x_ret_code varchar2(300);
4744: x_err_mesg varchar2(2000);
4745: l_session_id number;
4746: --l_item_arr mrp_atp_pub.number_arr := mrp_atp_pub.number_arr(1);
4747: l_organization_id number;
4748: x_sources mrp_atp_pvt.atp_source_typ;
4749: l_calling_module number;
4750: x_error_mesg varchar2(2000);