115: RespId IN NUMBER,
116: AppId IN NUMBER
117: ) is
118:
119: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
120: ln NUMBER;
121: l_session_id NUMBER :=0;
122: i NUMBER :=0;
123: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
119: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
120: ln NUMBER;
121: l_session_id NUMBER :=0;
122: i NUMBER :=0;
123: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
124: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
125: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
126: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
127: x_return_status VARCHAR2(1);
120: ln NUMBER;
121: l_session_id NUMBER :=0;
122: i NUMBER :=0;
123: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
124: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
125: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
126: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
127: x_return_status VARCHAR2(1);
128: x_msg_data VARCHAR2(200);
121: l_session_id NUMBER :=0;
122: i NUMBER :=0;
123: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
124: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
125: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
126: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
127: x_return_status VARCHAR2(1);
128: x_msg_data VARCHAR2(200);
129: x_msg_count NUMBER;
122: i NUMBER :=0;
123: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
124: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
125: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
126: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
127: x_return_status VARCHAR2(1);
128: x_msg_data VARCHAR2(200);
129: x_msg_count NUMBER;
130: temp_status Varchar2(40);
426: l_session_id := SessionId;
427: error_tracking_number:= 1190;
428:
429: ------- STEP 4 -- Call pl/sqlp ATP
430: MRP_ATP_PUB.Call_ATP(
431: l_session_id,
432: p_atp_table,
433: x_atp_table,
434: x_atp_supply_demand,