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:
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 (
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:
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 (
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: );
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:
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 (
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:
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 (
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:
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 (
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: );
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:
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 (
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: );
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:
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 (
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
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:
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,
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,
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,
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: );
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:
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(
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(
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:
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(