1: PACKAGE BODY MRP_ATP_PUB AS
2: /* $Header: MRPEATPB.pls 115.55 2002/12/02 22:57:00 dsting ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MRP_ATP_PUB';
4:
5: -- This package contains 2 procedures : Call_ATP and Call_ATP_No_Commit.
1: PACKAGE BODY MRP_ATP_PUB AS
2: /* $Header: MRPEATPB.pls 115.55 2002/12/02 22:57:00 dsting ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MRP_ATP_PUB';
4:
5: -- This package contains 2 procedures : Call_ATP and Call_ATP_No_Commit.
6: -- Call_ATP and Call_ATP_No_Commit are almost the same except
7: -- Call ATP is a automonous transaction which will commit the data.
12: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
13:
14: PROCEDURE Call_ATP (
15: p_session_id IN OUT NoCopy NUMBER,
16: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
17: x_atp_rec OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
18: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
19: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
20: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
13:
14: PROCEDURE Call_ATP (
15: p_session_id IN OUT NoCopy NUMBER,
16: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
17: x_atp_rec OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
18: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
19: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
20: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
21: x_return_status OUT NoCopy VARCHAR2,
14: PROCEDURE Call_ATP (
15: p_session_id IN OUT NoCopy NUMBER,
16: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
17: x_atp_rec OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
18: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
19: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
20: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
21: x_return_status OUT NoCopy VARCHAR2,
22: x_msg_data OUT NoCopy VARCHAR2,
15: p_session_id IN OUT NoCopy NUMBER,
16: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
17: x_atp_rec OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
18: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
19: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
20: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
21: x_return_status OUT NoCopy VARCHAR2,
22: x_msg_data OUT NoCopy VARCHAR2,
23: x_msg_count OUT NoCopy NUMBER
16: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
17: x_atp_rec OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
18: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
19: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
20: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
21: x_return_status OUT NoCopy VARCHAR2,
22: x_msg_data OUT NoCopy VARCHAR2,
23: x_msg_count OUT NoCopy NUMBER
24: ) IS
126:
127:
128: PROCEDURE Call_ATP_No_Commit (
129: p_session_id IN OUT NoCopy NUMBER,
130: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
131: x_atp_rec OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
132: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
133: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
134: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
127:
128: PROCEDURE Call_ATP_No_Commit (
129: p_session_id IN OUT NoCopy NUMBER,
130: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
131: x_atp_rec OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
132: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
133: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
134: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
135: x_return_status OUT NoCopy VARCHAR2,
128: PROCEDURE Call_ATP_No_Commit (
129: p_session_id IN OUT NoCopy NUMBER,
130: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
131: x_atp_rec OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
132: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
133: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
134: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
135: x_return_status OUT NoCopy VARCHAR2,
136: x_msg_data OUT NoCopy VARCHAR2,
129: p_session_id IN OUT NoCopy NUMBER,
130: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
131: x_atp_rec OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
132: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
133: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
134: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
135: x_return_status OUT NoCopy VARCHAR2,
136: x_msg_data OUT NoCopy VARCHAR2,
137: x_msg_count OUT NoCopy NUMBER
130: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
131: x_atp_rec OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
132: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
133: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
134: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
135: x_return_status OUT NoCopy VARCHAR2,
136: x_msg_data OUT NoCopy VARCHAR2,
137: x_msg_count OUT NoCopy NUMBER
138: ) IS
219:
220: END Call_ATP_No_Commit;
221:
222:
223: END MRP_ATP_PUB;