DBA Data[Home] [Help]

APPS.MSC_ATP_PF dependencies on MRP_ATP_PUB

Line 142: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

138: p_default_atp_rule_id IN NUMBER,
139: p_default_dmd_class IN VARCHAR2,
140: p_itf IN DATE,
141: p_refresh_number IN NUMBER,
142: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
143: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
144: x_return_status OUT NOCOPY VARCHAR2
145: );
146:

Line 143: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

139: p_default_dmd_class IN VARCHAR2,
140: p_itf IN DATE,
141: p_refresh_number IN NUMBER,
142: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
143: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
144: x_return_status OUT NOCOPY VARCHAR2
145: );
146:
147: PROCEDURE Get_Mat_Avail_Pf_Dtls (

Line 187: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

183: p_level_id IN NUMBER,
184: p_itf IN DATE,
185: p_sys_next_date IN DATE, --bug3099066
186: p_atf_date IN DATE,
187: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
188: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
189: x_return_status OUT NOCOPY VARCHAR2
190: );
191:

Line 188: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

184: p_itf IN DATE,
185: p_sys_next_date IN DATE, --bug3099066
186: p_atf_date IN DATE,
187: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
188: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
189: x_return_status OUT NOCOPY VARCHAR2
190: );
191:
192: PROCEDURE Item_Alloc_Avail_Pf_Unalloc (

Line 203: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

199: p_level_id IN NUMBER,
200: p_itf IN DATE,
201: p_sys_next_date IN DATE, --bug3099066
202: p_atf_date IN DATE,
203: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
204: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
205: x_atp_unalloc_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
206: x_return_status OUT NOCOPY VARCHAR2
207: );

Line 204: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

200: p_itf IN DATE,
201: p_sys_next_date IN DATE, --bug3099066
202: p_atf_date IN DATE,
203: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
204: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
205: x_atp_unalloc_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
206: x_return_status OUT NOCOPY VARCHAR2
207: );
208:

Line 205: x_atp_unalloc_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

201: p_sys_next_date IN DATE, --bug3099066
202: p_atf_date IN DATE,
203: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
204: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
205: x_atp_unalloc_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
206: x_return_status OUT NOCOPY VARCHAR2
207: );
208:
209: PROCEDURE Item_Alloc_Avail_Pf_Dtls (

Line 237: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

233: p_instance_id IN NUMBER,
234: p_plan_id IN NUMBER,
235: p_demand_class IN VARCHAR2,
236: p_itf IN DATE,
237: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
238: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
239: x_return_status OUT NOCOPY VARCHAR2
240: );
241:

Line 238: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

234: p_plan_id IN NUMBER,
235: p_demand_class IN VARCHAR2,
236: p_itf IN DATE,
237: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
238: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
239: x_return_status OUT NOCOPY VARCHAR2
240: );
241:
242: PROCEDURE Item_Prealloc_Avail_Pf_Summ (

Line 251: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

247: p_plan_id IN NUMBER,
248: p_demand_class IN VARCHAR2,
249: p_itf IN DATE,
250: p_refresh_number IN NUMBER,
251: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
252: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
253: x_return_status OUT NOCOPY VARCHAR2
254: );
255:

Line 252: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

248: p_demand_class IN VARCHAR2,
249: p_itf IN DATE,
250: p_refresh_number IN NUMBER,
251: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
252: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
253: x_return_status OUT NOCOPY VARCHAR2
254: );
255:
256: PROCEDURE Item_Prealloc_Avail_Pf_Dtls (

Line 281: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

277: p_org_id IN NUMBER,
278: p_instance_id IN NUMBER,
279: p_plan_id IN NUMBER,
280: p_itf IN DATE,
281: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
282: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
283: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
284: x_return_status OUT NOCOPY VARCHAR2
285: );

Line 282: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

278: p_instance_id IN NUMBER,
279: p_plan_id IN NUMBER,
280: p_itf IN DATE,
281: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
282: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
283: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
284: x_return_status OUT NOCOPY VARCHAR2
285: );
286:

Line 283: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,

279: p_plan_id IN NUMBER,
280: p_itf IN DATE,
281: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
282: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
283: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
284: x_return_status OUT NOCOPY VARCHAR2
285: );
286:
287: PROCEDURE Get_Forward_Mat_Pf_Summ (

Line 295: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

291: p_instance_id IN NUMBER,
292: p_plan_id IN NUMBER,
293: p_itf IN DATE,
294: p_refresh_number IN NUMBER,
295: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
296: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
297: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
298: x_return_status OUT NOCOPY VARCHAR2
299: );

Line 296: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

292: p_plan_id IN NUMBER,
293: p_itf IN DATE,
294: p_refresh_number IN NUMBER,
295: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
296: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
297: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
298: x_return_status OUT NOCOPY VARCHAR2
299: );
300:

Line 297: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,

293: p_itf IN DATE,
294: p_refresh_number IN NUMBER,
295: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
296: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
297: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
298: x_return_status OUT NOCOPY VARCHAR2
299: );
300:
301: PROCEDURE Insert_SD_Into_Details_Temp (

Line 332: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,

328: x_return_status OUT NOCOPY VARCHAR2
329: );
330:
331: PROCEDURE PF_Atp_Consume(
332: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
333: x_return_status OUT NOCOPY VARCHAR2,
334: p_atp_period IN MRP_ATP_PUB.date_arr :=NULL,
335: p_consumption_type IN NUMBER := Bw_Fw_Cum,
336: p_atf_date IN DATE := NULL

Line 334: p_atp_period IN MRP_ATP_PUB.date_arr :=NULL,

330:
331: PROCEDURE PF_Atp_Consume(
332: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
333: x_return_status OUT NOCOPY VARCHAR2,
334: p_atp_period IN MRP_ATP_PUB.date_arr :=NULL,
335: p_consumption_type IN NUMBER := Bw_Fw_Cum,
336: p_atf_date IN DATE := NULL
337: );
338:

Line 340: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,

336: p_atf_date IN DATE := NULL
337: );
338:
339: PROCEDURE PF_Atp_Alloc_Consume(
340: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
341: p_atp_period IN MRP_ATP_PUB.date_arr,
342: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
343: p_atf_date IN DATE,
344: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,

Line 341: p_atp_period IN MRP_ATP_PUB.date_arr,

337: );
338:
339: PROCEDURE PF_Atp_Alloc_Consume(
340: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
341: p_atp_period IN MRP_ATP_PUB.date_arr,
342: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
343: p_atf_date IN DATE,
344: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
345: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,

Line 342: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,

338:
339: PROCEDURE PF_Atp_Alloc_Consume(
340: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
341: p_atp_period IN MRP_ATP_PUB.date_arr,
342: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
343: p_atf_date IN DATE,
344: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
345: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
346: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,

Line 344: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,

340: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
341: p_atp_period IN MRP_ATP_PUB.date_arr,
342: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
343: p_atf_date IN DATE,
344: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
345: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
346: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
347: x_return_status OUT NOCOPY VARCHAR2
348: );

Line 345: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,

341: p_atp_period IN MRP_ATP_PUB.date_arr,
342: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
343: p_atf_date IN DATE,
344: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
345: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
346: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
347: x_return_status OUT NOCOPY VARCHAR2
348: );
349:

Line 346: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,

342: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
343: p_atf_date IN DATE,
344: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
345: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
346: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
347: x_return_status OUT NOCOPY VARCHAR2
348: );
349:
350: PROCEDURE Get_Period_Data_From_Sd_Temp(

Line 351: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

347: x_return_status OUT NOCOPY VARCHAR2
348: );
349:
350: PROCEDURE Get_Period_Data_From_Sd_Temp(
351: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
352: x_return_status OUT NOCOPY VARCHAR2
353: );
354:
355: PROCEDURE Get_Unalloc_Data_From_Sd_Temp(

Line 356: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

352: x_return_status OUT NOCOPY VARCHAR2
353: );
354:
355: PROCEDURE Get_Unalloc_Data_From_Sd_Temp(
356: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
357: p_unallocated_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
358: x_return_status OUT NOCOPY VARCHAR2
359: );
360:

Line 370: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

366: p_scenario_id IN NUMBER,
367: p_level_id IN NUMBER,
368: p_record_type IN PLS_INTEGER,
369: p_session_id IN NUMBER,
370: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
371: x_return_status OUT NOCOPY VARCHAR2
372: );
373:
374: FUNCTION Get_Pf_Atp_Item_Id(