DBA Data[Home] [Help]

APPS.MRP_ATP_UTILS dependencies on MRP_ATP_PUB

Line 9: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

5:
6: PROCEDURE put_into_temp_table(
7: x_dblink IN VARCHAR2,
8: x_session_id IN NUMBER,
9: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
10: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
11: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
12: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
13: x_mode IN NUMBER,

Line 10: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,

6: PROCEDURE put_into_temp_table(
7: x_dblink IN VARCHAR2,
8: x_session_id IN NUMBER,
9: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
10: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
11: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
12: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
13: x_mode IN NUMBER,
14: x_return_status OUT NoCopy VARCHAR2,

Line 11: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

7: x_dblink IN VARCHAR2,
8: x_session_id IN NUMBER,
9: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
10: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
11: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
12: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
13: x_mode IN NUMBER,
14: x_return_status OUT NoCopy VARCHAR2,
15: x_msg_data OUT NoCopy VARCHAR2,

Line 12: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,

8: x_session_id IN NUMBER,
9: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
10: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
11: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
12: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
13: x_mode IN NUMBER,
14: x_return_status OUT NoCopy VARCHAR2,
15: x_msg_data OUT NoCopy VARCHAR2,
16: x_msg_count OUT NoCopy NUMBER

Line 44: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,

40:
41: PROCEDURE get_from_temp_table(
42: x_dblink IN VARCHAR2,
43: x_session_id IN NUMBER,
44: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
45: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
46: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
47: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
48: x_mode IN NUMBER,

Line 45: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,

41: PROCEDURE get_from_temp_table(
42: x_dblink IN VARCHAR2,
43: x_session_id IN NUMBER,
44: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
45: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
46: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
47: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
48: x_mode IN NUMBER,
49: x_return_status OUT NoCopy VARCHAR2,

Line 46: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

42: x_dblink IN VARCHAR2,
43: x_session_id IN NUMBER,
44: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
45: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
46: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
47: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
48: x_mode IN NUMBER,
49: x_return_status OUT NoCopy VARCHAR2,
50: x_msg_data OUT NoCopy VARCHAR2,

Line 47: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,

43: x_session_id IN NUMBER,
44: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
45: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
46: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
47: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
48: x_mode IN NUMBER,
49: x_return_status OUT NoCopy VARCHAR2,
50: x_msg_data OUT NoCopy VARCHAR2,
51: x_msg_count OUT NoCopy NUMBER

Line 80: x_atp_rec MRP_ATP_PUB.atp_rec_typ;

76: p_err_message IN OUT NoCopy VARCHAR2)
77: RETURN NUMBER is
78:
79: v_dummy NUMBER := 0;
80: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
81: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
82: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
83: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
84: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 81: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;

77: RETURN NUMBER is
78:
79: v_dummy NUMBER := 0;
80: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
81: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
82: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
83: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
84: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
85: x_return_status VARCHAR2(1);

Line 82: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

78:
79: v_dummy NUMBER := 0;
80: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
81: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
82: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
83: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
84: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
85: x_return_status VARCHAR2(1);
86: x_msg_data VARCHAR2(200);

Line 83: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;

79: v_dummy NUMBER := 0;
80: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
81: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
82: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
83: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
84: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
85: x_return_status VARCHAR2(1);
86: x_msg_data VARCHAR2(200);
87: x_msg_count NUMBER;

Line 84: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;

80: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
81: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
82: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
83: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
84: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
85: x_return_status VARCHAR2(1);
86: x_msg_data VARCHAR2(200);
87: x_msg_count NUMBER;
88: x_session_id NUMBER;