DBA Data[Home] [Help]

APPS.MSC_ATP_REQ dependencies on MRP_ATP_PUB

Line 103: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

99:
100: --5216528/5216528 Start This record will out teh values from check_subs
101: --5081149 Initializing the collections
102: TYPE get_subs_out_rec IS RECORD(
103: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809

Line 104: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

100: --5216528/5216528 Start This record will out teh values from check_subs
101: --5081149 Initializing the collections
102: TYPE get_subs_out_rec IS RECORD(
103: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809
108: atf_date_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

101: --5081149 Initializing the collections
102: TYPE get_subs_out_rec IS RECORD(
103: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809
108: atf_date_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: quantity_ordered MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()

Line 106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

102: TYPE get_subs_out_rec IS RECORD(
103: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809
108: atf_date_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: quantity_ordered MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
110: );

Line 107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809

103: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809
108: atf_date_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: quantity_ordered MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
110: );
111: --5216528/5216528 End

Line 108: atf_date_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

104: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809
108: atf_date_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: quantity_ordered MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
110: );
111: --5216528/5216528 End
112: PROCEDURE Check_Substitutes(

Line 109: quantity_ordered MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()

105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809
108: atf_date_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: quantity_ordered MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
110: );
111: --5216528/5216528 End
112: PROCEDURE Check_Substitutes(
113: p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,

Line 124: l_supply_demand IN OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,

120: p_inventory_item_id IN NUMBER,
121: p_organization_id IN NUMBER,
122: p_quantity IN NUMBER,
123: l_net_demand IN OUT NoCopy NUMBER,
124: l_supply_demand IN OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
125: l_atp_period IN OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
126: l_substitutes_rec OUT NoCopy MSC_ATP_REQ.get_subs_out_rec, --5216528/5216528
127: l_return_status OUT NoCopy varchar2,
128: p_refresh_number IN NUMBER -- For summary enhancement

Line 125: l_atp_period IN OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

121: p_organization_id IN NUMBER,
122: p_quantity IN NUMBER,
123: l_net_demand IN OUT NoCopy NUMBER,
124: l_supply_demand IN OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
125: l_atp_period IN OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
126: l_substitutes_rec OUT NoCopy MSC_ATP_REQ.get_subs_out_rec, --5216528/5216528
127: l_return_status OUT NoCopy varchar2,
128: p_refresh_number IN NUMBER -- For summary enhancement
129: );

Line 136: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

132: /* time_phased_atp
133: Grouped various input parameters to this procedure in a new record Atp_Info_Rec*/
134: PROCEDURE Get_Material_Atp_Info (
135: p_mat_atp_info_rec IN OUT NOCOPY Atp_Info_Rec,
136: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
137: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
138: x_return_status OUT NoCopy VARCHAR2
139: );
140:

Line 137: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

133: Grouped various input parameters to this procedure in a new record Atp_Info_Rec*/
134: PROCEDURE Get_Material_Atp_Info (
135: p_mat_atp_info_rec IN OUT NOCOPY Atp_Info_Rec,
136: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
137: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
138: x_return_status OUT NoCopy VARCHAR2
139: );
140:
141:

Line 153: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

149: p_inventory_item_id IN NUMBER,
150: p_organization_id IN NUMBER,
151: p_demand_class IN VARCHAR2,
152: p_insert_flag IN NUMBER,
153: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
154: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
155: x_return_status OUT NoCopy VARCHAR2,
156: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
157: p_atf_date IN DATE -- For time_phased_atp

Line 154: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

150: p_organization_id IN NUMBER,
151: p_demand_class IN VARCHAR2,
152: p_insert_flag IN NUMBER,
153: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
154: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
155: x_return_status OUT NoCopy VARCHAR2,
156: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
157: p_atf_date IN DATE -- For time_phased_atp
158: );

Line 182: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

178: p_parent_ship_date IN DATE, -- Bug 2814872 Cut-off Date for Resource Check
179: p_line_identifier IN NUMBER, -- CTO ODR Identifies the line being processed.
180: x_avail_assembly_qty OUT NoCopy NUMBER,
181: x_atp_date OUT NoCopy DATE,
182: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
183: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
184: x_return_status OUT NoCopy VARCHAR2
185: );
186:

Line 183: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

179: p_line_identifier IN NUMBER, -- CTO ODR Identifies the line being processed.
180: x_avail_assembly_qty OUT NoCopy NUMBER,
181: x_atp_date OUT NoCopy DATE,
182: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
183: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
184: x_return_status OUT NoCopy VARCHAR2
185: );
186:
187: PROCEDURE Get_Comp_Requirements (

Line 210: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

206: p_atf_date IN DATE, -- For time_phased_atp
207: p_manufacturing_cal_code IN VARCHAR2, -- For ship_rec_cal
208: x_avail_assembly_qty OUT NoCopy NUMBER,
209: x_atp_date OUT NoCopy DATE,
210: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
211: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
212: x_return_status OUT NoCopy VARCHAR2,
213: p_comp_info_rec IN OUT NOCOPY MSC_ATP_REQ.get_comp_info_rec,
214: p_order_number IN NUMBER := NULL,

Line 211: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

207: p_manufacturing_cal_code IN VARCHAR2, -- For ship_rec_cal
208: x_avail_assembly_qty OUT NoCopy NUMBER,
209: x_atp_date OUT NoCopy DATE,
210: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
211: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
212: x_return_status OUT NoCopy VARCHAR2,
213: p_comp_info_rec IN OUT NOCOPY MSC_ATP_REQ.get_comp_info_rec,
214: p_order_number IN NUMBER := NULL,
215: p_op_seq_id IN NUMBER --4570421

Line 223: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

219:
220:
221: PROCEDURE Get_Supplier_Atp_Info (
222: p_sup_atp_info_rec IN OUT NOCOPY MSC_ATP_REQ.Atp_Info_Rec,
223: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
224: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
225: x_return_status OUT NOCOPY VARCHAR2
226: );
227:

Line 224: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

220:
221: PROCEDURE Get_Supplier_Atp_Info (
222: p_sup_atp_info_rec IN OUT NOCOPY MSC_ATP_REQ.Atp_Info_Rec,
223: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
224: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
225: x_return_status OUT NOCOPY VARCHAR2
226: );
227:
228:

Line 247: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

243: p_parent_pegging_id IN NUMBER,
244: x_requested_date_quantity OUT NoCopy NUMBER,
245: x_atp_date_this_level OUT NoCopy DATE,
246: x_atp_date_quantity_this_level OUT NoCopy NUMBER,
247: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
248: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
249: x_return_status OUT NoCopy VARCHAR2
250: );
251:

Line 248: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,

244: x_requested_date_quantity OUT NoCopy NUMBER,
245: x_atp_date_this_level OUT NoCopy DATE,
246: x_atp_date_quantity_this_level OUT NoCopy NUMBER,
247: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
248: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
249: x_return_status OUT NoCopy VARCHAR2
250: );
251:
252: --supplier_capacity changes