APPS.OE_RELATED_ITEMS_PVT dependencies on MRP_ATP_PUB

Line 366: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

362: x_error_message out NOCOPY /* file.sql.39 change */ varchar2
363: ) IS
364:
365: l_session_id NUMBER := 0;
366: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
367: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
368: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
369: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
370: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 367: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

363: ) IS
364:
365: l_session_id NUMBER := 0;
366: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
367: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
368: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
369: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
370: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
371: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 368: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

364:
365: l_session_id NUMBER := 0;
366: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
367: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
368: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
369: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
370: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
371: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
372: I NUMBER := 1;

Line 369: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

365: l_session_id NUMBER := 0;
366: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
367: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
368: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
369: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
370: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
371: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
372: I NUMBER := 1;
373: l_mrp_calc_sd VARCHAR2(240);--bug14222176

Line 370: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

366: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
367: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
368: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
369: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
370: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
371: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
372: I NUMBER := 1;
373: l_mrp_calc_sd VARCHAR2(240);--bug14222176
374:

Line 371: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

367: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
368: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
369: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
370: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
371: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
372: I NUMBER := 1;
373: l_mrp_calc_sd VARCHAR2(240);--bug14222176
374:
375:

Line 484: MRP_ATP_PUB.Call_ATP (

480: IF l_debug_level > 0 THEN
481: print_time('Calling MRP');
482: END IF;
483:
484: MRP_ATP_PUB.Call_ATP (
485: p_session_id => l_session_id
486: , p_atp_rec => l_atp_rec
487: , x_atp_rec => x_atp_rec
488: , x_atp_supply_demand => l_atp_supply_demand

Line 500: oe_debug_pub.add( 'AFTER CALL MRP_ATP_PUB.CALL_ATP STS='||

496: IF l_debug_level > 0 THEN
497: print_time('After Calling MRP');
498: END IF;
499: IF l_debug_level > 0 THEN
500: oe_debug_pub.add( 'AFTER CALL MRP_ATP_PUB.CALL_ATP STS='||
501: X_RETURN_STATUS|| ' MSG COUNT='||X_MSG_COUNT|| ' MSG DATA='||X_MSG_DATA||
502: 'AVL QTY='|| X_ATP_REC.AVAILABLE_QUANTITY ( 1 ) || 'SHIP_FROM_ORG_ID =' ||
503: X_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) ) ;
504: END IF;

Line 612: ( p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ

608: END Call_MRP_ATP;
609:
610:
611: Procedure Initialize_mrp_record
612: ( p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
613: ,l_count IN NUMBER) IS
614:
615: l_return_status varchar2(10);
616:

Line 645: ,p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ

641: END Initialize_mrp_record;
642:
643: Procedure Check_Results_from_rec (
644: p_global_orgs in varchar2
645: ,p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
646: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
647: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
648: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
649: ,x_error_message OUT NOCOPY /* file.sql.39 change */ varchar2