DBA Data[Home] [Help]

APPS.MRP_ATP_PUB dependencies on MRP_ATP_PUB

Line 1: PACKAGE BODY MRP_ATP_PUB AS

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.

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MRP_ATP_PUB';

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.

Line 16: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,

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,

Line 17: x_atp_rec OUT NoCopy MRP_ATP_PUB.ATP_Rec_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,

Line 18: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,

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,

Line 19: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

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

Line 20: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,

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

Line 130: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,

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,

Line 131: x_atp_rec OUT NoCopy MRP_ATP_PUB.ATP_Rec_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,

Line 132: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,

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,

Line 133: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

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

Line 134: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,

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

Line 223: END MRP_ATP_PUB;

219:
220: END Call_ATP_No_Commit;
221:
222:
223: END MRP_ATP_PUB;