115: PlanIdOut OUT nocopy MscNumberArr
116: ) is
117:
118: sessionId NUMBER :=0;
119: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
120: ln NUMBER;
121: i NUMBER :=0;
122: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
123: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
118: sessionId NUMBER :=0;
119: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
120: ln NUMBER;
121: i NUMBER :=0;
122: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
123: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
124: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
125: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
126: x_return_status VARCHAR2(1);
119: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
120: ln NUMBER;
121: i NUMBER :=0;
122: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
123: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
124: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
125: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
126: x_return_status VARCHAR2(1);
127: x_msg_data VARCHAR2(200);
120: ln NUMBER;
121: i NUMBER :=0;
122: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
123: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
124: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
125: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
126: x_return_status VARCHAR2(1);
127: x_msg_data VARCHAR2(200);
128: x_msg_count NUMBER;
121: i NUMBER :=0;
122: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
123: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
124: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
125: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
126: x_return_status VARCHAR2(1);
127: x_msg_data VARCHAR2(200);
128: x_msg_count NUMBER;
129:
772: dbms_output.put_line('status = ' || status );
773: dbms_output.put_line('sessionId = ' || sessionId );*/
774:
775: ------- STEP 5 -- Call pl/sqlp ATP
776: MRP_ATP_PUB.Call_ATP(
777: sessionId,
778: p_atp_table,
779: x_atp_table,
780: x_atp_supply_demand,