DBA Data[Home] [Help]

APPS.OE_RELATED_ITEMS_PVT dependencies on MRP_ATP_PUB

Line 362: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

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

Line 363: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

359: ) IS
360:
361: l_session_id NUMBER := 0;
362: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
363: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
364: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
365: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
366: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
367: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 364: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

360:
361: l_session_id NUMBER := 0;
362: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
363: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
364: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
365: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
366: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
367: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
368: I NUMBER := 1;

Line 365: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

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

Line 366: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

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

Line 367: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

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

Line 451: MRP_ATP_PUB.Call_ATP (

447: IF l_debug_level > 0 THEN
448: print_time('Calling MRP');
449: END IF;
450:
451: MRP_ATP_PUB.Call_ATP (
452: p_session_id => l_session_id
453: , p_atp_rec => l_atp_rec
454: , x_atp_rec => x_atp_rec
455: , x_atp_supply_demand => l_atp_supply_demand

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

463: IF l_debug_level > 0 THEN
464: print_time('After Calling MRP');
465: END IF;
466: IF l_debug_level > 0 THEN
467: oe_debug_pub.add( 'AFTER CALL MRP_ATP_PUB.CALL_ATP STS='||
468: X_RETURN_STATUS|| ' MSG COUNT='||X_MSG_COUNT|| ' MSG DATA='||X_MSG_DATA||
469: 'AVL QTY='|| X_ATP_REC.AVAILABLE_QUANTITY ( 1 ) || 'SHIP_FROM_ORG_ID =' ||
470: X_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) ) ;
471: END IF;

Line 579: ( p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ

575: END Call_MRP_ATP;
576:
577:
578: Procedure Initialize_mrp_record
579: ( p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
580: ,l_count IN NUMBER) IS
581:
582: l_return_status varchar2(10);
583:

Line 612: ,p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ

608: END Initialize_mrp_record;
609:
610: Procedure Check_Results_from_rec (
611: p_global_orgs in varchar2
612: ,p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
613: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
614: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
615: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
616: ,x_error_message OUT NOCOPY /* file.sql.39 change */ varchar2