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

Line 122: x_atp_table MRP_ATP_PUB.ATP_Rec_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);

Line 123: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

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

Line 124: x_atp_period MRP_ATP_PUB.ATP_Period_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);
128: x_msg_count NUMBER;

Line 125: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;

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:

Line 776: MRP_ATP_PUB.Call_ATP(

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,