234: PROCEDURE put_into_temp_table
235: (
236: x_dblink IN VARCHAR2,
237: x_session_id IN NUMBER,
238: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
239: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
240: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
241: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
242: x_mode IN NUMBER,
235: (
236: x_dblink IN VARCHAR2,
237: x_session_id IN NUMBER,
238: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
239: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
240: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
241: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
242: x_mode IN NUMBER,
243: x_return_status OUT NoCopy VARCHAR2,
236: x_dblink IN VARCHAR2,
237: x_session_id IN NUMBER,
238: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
239: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
240: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
241: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
242: x_mode IN NUMBER,
243: x_return_status OUT NoCopy VARCHAR2,
244: x_msg_data OUT NoCopy VARCHAR2,
237: x_session_id IN NUMBER,
238: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
239: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
240: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
241: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
242: x_mode IN NUMBER,
243: x_return_status OUT NoCopy VARCHAR2,
244: x_msg_data OUT NoCopy VARCHAR2,
245: x_msg_count OUT NoCopy NUMBER
248: PROCEDURE get_from_temp_table
249: (
250: x_dblink IN VARCHAR2,
251: x_session_id IN NUMBER,
252: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
253: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
254: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
255: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
256: x_mode IN NUMBER,
249: (
250: x_dblink IN VARCHAR2,
251: x_session_id IN NUMBER,
252: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
253: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
254: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
255: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
256: x_mode IN NUMBER,
257: x_return_status OUT NoCopy VARCHAR2,
250: x_dblink IN VARCHAR2,
251: x_session_id IN NUMBER,
252: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
253: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
254: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
255: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
256: x_mode IN NUMBER,
257: x_return_status OUT NoCopy VARCHAR2,
258: x_msg_data OUT NoCopy VARCHAR2,
251: x_session_id IN NUMBER,
252: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
253: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
254: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
255: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
256: x_mode IN NUMBER,
257: x_return_status OUT NoCopy VARCHAR2,
258: x_msg_data OUT NoCopy VARCHAR2,
259: x_msg_count OUT NoCopy NUMBER