DBA Data[Home] [Help]

APPS.MSC_WS_ATP dependencies on MRP_ATP_PUB

Line 119: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

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;

Line 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);

Line 124: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_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);
128: x_msg_data VARCHAR2(200);

Line 125: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;

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;

Line 126: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;

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);

Line 430: MRP_ATP_PUB.Call_ATP(

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,