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 447: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

443:
444: ) IS
445:
446: l_session_id NUMBER := 0;
447: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
448: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
449: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
450: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
451: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 448: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

444: ) IS
445:
446: l_session_id NUMBER := 0;
447: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
448: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
449: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
450: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
451: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
452: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 449: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

445:
446: l_session_id NUMBER := 0;
447: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
448: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
449: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
450: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
451: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
452: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
453: I NUMBER := 1;

Line 450: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

446: l_session_id NUMBER := 0;
447: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
448: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
449: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
450: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
451: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
452: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
453: I NUMBER := 1;
454:

Line 451: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

447: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
448: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
449: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
450: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
451: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
452: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
453: I NUMBER := 1;
454:
455:

Line 452: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

448: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
449: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
450: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
451: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
452: in_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
453: I NUMBER := 1;
454:
455:
456: --

Line 571: MRP_ATP_PUB.Call_ATP (

567: IF l_debug_level > 0 THEN
568: print_time('Calling MRP');
569: END IF;
570:
571: MRP_ATP_PUB.Call_ATP (
572: p_session_id => l_session_id
573: , p_atp_rec => in_atp_rec
574: , x_atp_rec => x_atp_rec
575: , x_atp_supply_demand => l_atp_supply_demand

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

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

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

6329: x_plan_name varchar2(300);
6330: x_ret_code varchar2(300);
6331: x_err_mesg varchar2(2000);
6332: l_session_id number;
6333: --l_item_arr mrp_atp_pub.number_arr := mrp_atp_pub.number_arr(1);
6334: l_organization_id number;
6335: x_sources mrp_atp_pvt.atp_source_typ;
6336: l_calling_module number;
6337: x_error_mesg varchar2(2000);