135: p_time_phased_atp IN VARCHAR2, -- For time_phased_atp
136: p_ato_model_line_id IN number,
137: p_demand_source_type IN Number, --cmro
138: p_source_organization_Id IN NUMBER, --Bug 7118988
139: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
140: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
141: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
142: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
143: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
136: p_ato_model_line_id IN number,
137: p_demand_source_type IN Number, --cmro
138: p_source_organization_Id IN NUMBER, --Bug 7118988
139: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
140: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
141: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
142: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
143: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
144: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
137: p_demand_source_type IN Number, --cmro
138: p_source_organization_Id IN NUMBER, --Bug 7118988
139: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
140: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
141: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
142: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
143: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
144: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
145: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
138: p_source_organization_Id IN NUMBER, --Bug 7118988
139: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
140: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
141: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
142: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
143: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
144: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
145: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
146: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
139: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
140: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
141: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
142: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
143: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
144: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
145: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
146: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
147: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
140: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
141: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
142: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
143: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
144: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
145: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
146: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
147: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
148: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
141: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
142: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
143: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
144: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
145: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
146: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
147: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
148: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
149: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
142: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
143: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
144: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
145: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
146: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
147: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
148: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
149: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
150: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
143: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
144: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
145: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
146: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
147: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
148: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
149: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
150: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
151: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
144: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
145: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
146: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
147: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
148: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
149: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
150: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
151: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
152: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
145: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
146: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
147: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
148: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
149: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
150: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
151: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
152: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
153: -- End CTO ODR and Simplified Pegging
146: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
147: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
148: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
149: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
150: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
151: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
152: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
153: -- End CTO ODR and Simplified Pegging
154:
147: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
148: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
149: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
150: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
151: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
152: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
153: -- End CTO ODR and Simplified Pegging
154:
155: );
148: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
149: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
150: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
151: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
152: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
153: -- End CTO ODR and Simplified Pegging
154:
155: );
156:
222: -- RAJJAIN 11/01/2002, Now schedule procedure passes reference to del_demand_ids array to this
223: -- procedure
224:
225: PROCEDURE Undo_Delete_Row(
226: p_identifiers IN MRP_ATP_PUB.Number_Arr,
227: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
228: p_instance_id IN NUMBER,
229: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
230: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
223: -- procedure
224:
225: PROCEDURE Undo_Delete_Row(
226: p_identifiers IN MRP_ATP_PUB.Number_Arr,
227: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
228: p_instance_id IN NUMBER,
229: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
230: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
231: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
225: PROCEDURE Undo_Delete_Row(
226: p_identifiers IN MRP_ATP_PUB.Number_Arr,
227: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
228: p_instance_id IN NUMBER,
229: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
230: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
231: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
232: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
233: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
226: p_identifiers IN MRP_ATP_PUB.Number_Arr,
227: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
228: p_instance_id IN NUMBER,
229: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
230: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
231: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
232: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
233: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
234: -- CTO ODR and Simplified Pegging
227: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
228: p_instance_id IN NUMBER,
229: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
230: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
231: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
232: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
233: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
234: -- CTO ODR and Simplified Pegging
235: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
228: p_instance_id IN NUMBER,
229: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
230: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
231: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
232: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
233: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
234: -- CTO ODR and Simplified Pegging
235: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
236: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
231: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
232: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
233: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
234: -- CTO ODR and Simplified Pegging
235: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
236: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
237: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
238: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
239: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
232: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
233: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
234: -- CTO ODR and Simplified Pegging
235: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
236: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
237: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
238: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
239: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
240: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
233: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
234: -- CTO ODR and Simplified Pegging
235: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
236: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
237: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
238: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
239: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
240: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
241: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
234: -- CTO ODR and Simplified Pegging
235: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
236: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
237: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
238: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
239: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
240: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
241: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
242: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
235: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
236: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
237: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
238: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
239: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
240: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
241: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
242: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
243: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
236: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
237: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
238: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
239: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
240: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
241: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
242: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
243: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
244: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
237: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
238: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
239: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
240: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
241: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
242: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
243: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
244: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
245: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
238: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
239: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
240: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
241: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
242: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
243: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
244: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
245: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
246: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
239: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
240: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
241: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
242: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
243: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
244: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
245: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
246: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
247: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
240: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
241: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
242: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
243: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
244: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
245: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
246: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
247: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
248: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
241: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
242: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
243: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
244: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
245: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
246: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
247: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
248: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
249: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
242: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
243: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
244: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
245: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
246: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
247: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
248: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
249: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
250: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr --3720018, added for support of rescheduling in ODS
243: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
244: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
245: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
246: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
247: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
248: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
249: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
250: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr --3720018, added for support of rescheduling in ODS
251: -- End CTO ODR and Simplified Pegging
244: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
245: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
246: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
247: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
248: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
249: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
250: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr --3720018, added for support of rescheduling in ODS
251: -- End CTO ODR and Simplified Pegging
252: );
245: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
246: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
247: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
248: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
249: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
250: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr --3720018, added for support of rescheduling in ODS
251: -- End CTO ODR and Simplified Pegging
252: );
253:
246: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
247: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
248: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
249: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
250: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr --3720018, added for support of rescheduling in ODS
251: -- End CTO ODR and Simplified Pegging
252: );
253:
254: PROCEDURE DELETE_SUMMARY_ROW (p_identifier IN NUMBER,
266: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_identifier IN NUMBER,
267: p_plan_id IN NUMBER,
268: p_instance_id IN NUMBER);
269:
270: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_identifiers IN MRP_ATP_PUB.Number_Arr,
271: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
272: p_instance_id IN NUMBER);
273: */
274: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
267: p_plan_id IN NUMBER,
268: p_instance_id IN NUMBER);
269:
270: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_identifiers IN MRP_ATP_PUB.Number_Arr,
271: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
272: p_instance_id IN NUMBER);
273: */
274: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
275: p_old_demand_date IN MRP_ATP_PUB.Date_Arr,
270: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_identifiers IN MRP_ATP_PUB.Number_Arr,
271: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
272: p_instance_id IN NUMBER);
273: */
274: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
275: p_old_demand_date IN MRP_ATP_PUB.Date_Arr,
276: p_old_demand_quantity IN MRP_ATP_PUB.Number_Arr,
277: p_organization_id IN MRP_ATP_PUB.Number_Arr,
278: p_plan_id IN NUMBER,
271: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
272: p_instance_id IN NUMBER);
273: */
274: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
275: p_old_demand_date IN MRP_ATP_PUB.Date_Arr,
276: p_old_demand_quantity IN MRP_ATP_PUB.Number_Arr,
277: p_organization_id IN MRP_ATP_PUB.Number_Arr,
278: p_plan_id IN NUMBER,
279: p_instance_id IN NUMBER);
272: p_instance_id IN NUMBER);
273: */
274: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
275: p_old_demand_date IN MRP_ATP_PUB.Date_Arr,
276: p_old_demand_quantity IN MRP_ATP_PUB.Number_Arr,
277: p_organization_id IN MRP_ATP_PUB.Number_Arr,
278: p_plan_id IN NUMBER,
279: p_instance_id IN NUMBER);
280:
273: */
274: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
275: p_old_demand_date IN MRP_ATP_PUB.Date_Arr,
276: p_old_demand_quantity IN MRP_ATP_PUB.Number_Arr,
277: p_organization_id IN MRP_ATP_PUB.Number_Arr,
278: p_plan_id IN NUMBER,
279: p_instance_id IN NUMBER);
280:
281: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
277: p_organization_id IN MRP_ATP_PUB.Number_Arr,
278: p_plan_id IN NUMBER,
279: p_instance_id IN NUMBER);
280:
281: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
282: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
283: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
284: p_organization_id IN MRP_ATP_PUB.Number_Arr,
285: p_plan_id IN MRP_ATP_PUB.Number_Arr,
278: p_plan_id IN NUMBER,
279: p_instance_id IN NUMBER);
280:
281: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
282: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
283: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
284: p_organization_id IN MRP_ATP_PUB.Number_Arr,
285: p_plan_id IN MRP_ATP_PUB.Number_Arr,
286: p_instance_id IN NUMBER);
279: p_instance_id IN NUMBER);
280:
281: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
282: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
283: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
284: p_organization_id IN MRP_ATP_PUB.Number_Arr,
285: p_plan_id IN MRP_ATP_PUB.Number_Arr,
286: p_instance_id IN NUMBER);
287:
280:
281: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
282: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
283: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
284: p_organization_id IN MRP_ATP_PUB.Number_Arr,
285: p_plan_id IN MRP_ATP_PUB.Number_Arr,
286: p_instance_id IN NUMBER);
287:
288:
281: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
282: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
283: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
284: p_organization_id IN MRP_ATP_PUB.Number_Arr,
285: p_plan_id IN MRP_ATP_PUB.Number_Arr,
286: p_instance_id IN NUMBER);
287:
288:
289:
316: ); -- For summary enhancement
317:
318:
319: PROCEDURE Remove_Invalid_Future_SD(
320: p_future_pegging_tab IN MRP_ATP_PUB.Number_Arr
321: );
322:
323: -- supply/demand perf enh
324: PROCEDURE move_SD_temp_into_mrp_details(
328: PROCEDURE Clear_SD_Details_Temp;
329:
330: -- for summary enhancement
331: PROCEDURE Delete_Copy_Demand (
332: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr,
333: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr,
334: p_time_phased_set IN VARCHAR2,
335: x_return_status OUT NOCOPY VARCHAR2
336: );
329:
330: -- for summary enhancement
331: PROCEDURE Delete_Copy_Demand (
332: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr,
333: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr,
334: p_time_phased_set IN VARCHAR2,
335: x_return_status OUT NOCOPY VARCHAR2
336: );
337:
350:
351: --3720018, new procedure to call delete_row for set or request level.
352: Procedure call_delete_row (
353: p_instance_id IN NUMBER,
354: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
355: p_refresh_number IN NUMBER,
356: x_delete_atp_rec OUT NoCopy MSC_ATP_PVT.DELETE_ATP_REC,
357: x_return_status OUT NoCopy VARCHAR2
358: );