DBA Data[Home] [Help]

APPS.MSC_ATP_UTILS dependencies on MRP_ATP_PUB

Line 14: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

10:
11: PROCEDURE put_into_temp_table(
12: x_dblink IN VARCHAR2,
13: x_session_id IN NUMBER,
14: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
15: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
16: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
17: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
18: x_mode IN NUMBER,

Line 15: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,

11: PROCEDURE put_into_temp_table(
12: x_dblink IN VARCHAR2,
13: x_session_id IN NUMBER,
14: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
15: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
16: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
17: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
18: x_mode IN NUMBER,
19: x_return_status OUT NoCopy VARCHAR2,

Line 16: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

12: x_dblink IN VARCHAR2,
13: x_session_id IN NUMBER,
14: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
15: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
16: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
17: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
18: x_mode IN NUMBER,
19: x_return_status OUT NoCopy VARCHAR2,
20: x_msg_data OUT NoCopy VARCHAR2,

Line 17: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,

13: x_session_id IN NUMBER,
14: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
15: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
16: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
17: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
18: x_mode IN NUMBER,
19: x_return_status OUT NoCopy VARCHAR2,
20: x_msg_data OUT NoCopy VARCHAR2,
21: x_msg_count OUT NoCopy NUMBER

Line 27: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,

23:
24: PROCEDURE get_from_temp_table(
25: x_dblink IN VARCHAR2,
26: x_session_id IN NUMBER,
27: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
28: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
29: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
30: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
31: x_mode IN NUMBER,

Line 28: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,

24: PROCEDURE get_from_temp_table(
25: x_dblink IN VARCHAR2,
26: x_session_id IN NUMBER,
27: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
28: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
29: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
30: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
31: x_mode IN NUMBER,
32: x_return_status OUT NoCopy VARCHAR2,

Line 29: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

25: x_dblink IN VARCHAR2,
26: x_session_id IN NUMBER,
27: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
28: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
29: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
30: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
31: x_mode IN NUMBER,
32: x_return_status OUT NoCopy VARCHAR2,
33: x_msg_data OUT NoCopy VARCHAR2,

Line 30: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,

26: x_session_id IN NUMBER,
27: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
28: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
29: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
30: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
31: x_mode IN NUMBER,
32: x_return_status OUT NoCopy VARCHAR2,
33: x_msg_data OUT NoCopy VARCHAR2,
34: x_msg_count OUT NoCopy NUMBER,

Line 67: p_atp_bom_rec IN MRP_ATP_PUB.ATP_BOM_Rec_Typ,

63:
64: PROCEDURE put_into_bom_temp_table(
65: p_session_id IN NUMBER,
66: p_dblink IN VARCHAR2,
67: p_atp_bom_rec IN MRP_ATP_PUB.ATP_BOM_Rec_Typ,
68: x_return_status OUT NoCopy VARCHAR2,
69: x_msg_data OUT NoCopy VARCHAR2,
70: x_msg_count OUT NoCopy NUMBER);
71:

Line 73: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,

69: x_msg_data OUT NoCopy VARCHAR2,
70: x_msg_count OUT NoCopy NUMBER);
71:
72: PROCEDURE Put_SD_Data (
73: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
74: p_dblink IN VARCHAR2,
75: p_session_id IN NUMBER );
76:
77: PROCEDURE Put_Period_Data (

Line 78: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

74: p_dblink IN VARCHAR2,
75: p_session_id IN NUMBER );
76:
77: PROCEDURE Put_Period_Data (
78: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
79: p_dblink IN VARCHAR2,
80: p_session_id IN NUMBER );
81:
82: PROCEDURE Put_Pegging_data (p_session_id IN NUMBER,

Line 85: Procedure Put_Scheduling_data(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

81:
82: PROCEDURE Put_Pegging_data (p_session_id IN NUMBER,
83: p_dblink IN VARCHAR2);
84:
85: Procedure Put_Scheduling_data(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
86: p_mode IN NUMBER,
87: p_dblink IN VARCHAR2,
88: p_session_id IN NUMBER );
89:

Line 92: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ);

88: p_session_id IN NUMBER );
89:
90: Procedure Process_Supply_Demand_details( p_dblink IN varchar2,
91: p_session_id IN number,
92: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ);
93:
94: PROCEDURE Transfer_mrp_atp_details_temp(
95: p_dblink IN VARCHAR2,
96: p_session_id IN NUMBER

Line 101: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

97: );
98:
99: PROCEDURE Retrieve_Period_and_SD_Data(
100: p_session_id IN NUMBER,
101: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
102: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ
103: );
104:
105: PROCEDURE Copy_MRP_SD_Recs(

Line 102: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ

98:
99: PROCEDURE Retrieve_Period_and_SD_Data(
100: p_session_id IN NUMBER,
101: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
102: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ
103: );
104:
105: PROCEDURE Copy_MRP_SD_Recs(
106: p_old_pegging_id NUMBER,

Line 110: procedure Put_Sch_Data_Request_Mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

106: p_old_pegging_id NUMBER,
107: p_pegging_id NUMBER
108: );
109:
110: procedure Put_Sch_Data_Request_Mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
111: p_session_id IN NUMBER);
112:
113:
114: Procedure Put_Sch_data_result_mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

Line 114: Procedure Put_Sch_data_result_mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

110: procedure Put_Sch_Data_Request_Mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
111: p_session_id IN NUMBER);
112:
113:
114: Procedure Put_Sch_data_result_mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
115: p_dblink IN VARCHAR2,
116: p_session_id IN NUMBER);
117:
118: Procedure Transfer_Scheduling_data(p_session_id IN Number,