eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_DB_UTILS dependencies on MRP_ATP_PUB

Line 139: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,

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,

Line 140: x_inv_item_id 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,

Line 141: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement

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,

Line 142: x_atp_peg_items 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

Line 143: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,

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

Line 144: x_atp_peg_supplies 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
148: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191

Line 145: x_atp_peg_res_reqs 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
149: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS

Line 146: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191

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

Line 147: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191

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,

Line 148: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191

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

Line 149: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS

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

Line 150: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS

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:

Line 151: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,

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

Line 152: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr

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:

Line 226: p_identifiers IN MRP_ATP_PUB.Number_Arr,

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,

Line 227: p_plan_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

Line 229: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,

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

Line 230: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,

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

Line 231: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement

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,

Line 232: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement

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,

Line 235: p_del_atp_peg_items 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

Line 236: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,

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

Line 237: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,

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

Line 238: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,

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

Line 239: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro

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

Line 240: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

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

Line 241: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

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

Line 242: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

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

Line 243: p_del_ods_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

Line 244: p_del_ods_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

Line 245: p_del_ods_demand_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

Line 246: p_del_ods_cto_demand_ids 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

Line 247: p_del_ods_cto_inv_item_ids 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

Line 248: p_del_ods_cto_dem_src_type 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
252: );

Line 249: p_del_ods_atp_refresh_no 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: );
253:

Line 250: p_del_ods_cto_atp_refresh_no 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:
254: PROCEDURE DELETE_SUMMARY_ROW (p_identifier IN NUMBER,

Line 270: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_identifiers IN MRP_ATP_PUB.Number_Arr,

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,

Line 271: p_plan_ids 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,

Line 274: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_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,

Line 275: p_old_demand_date IN MRP_ATP_PUB.Date_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,
279: p_instance_id IN NUMBER);

Line 276: p_old_demand_quantity 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);
280:

Line 277: p_organization_id IN MRP_ATP_PUB.Number_Arr,

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,

Line 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,

Line 282: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_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);

Line 283: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,

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:

Line 284: p_organization_id IN MRP_ATP_PUB.Number_Arr,

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:

Line 285: p_plan_id IN MRP_ATP_PUB.Number_Arr,

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:

Line 320: p_future_pegging_tab IN MRP_ATP_PUB.Number_Arr

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(

Line 332: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr,

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

Line 333: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr,

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:

Line 354: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

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

Line 375: p_pegging_tab IN MRP_ATP_PUB.Number_Arr,

371: | o This procedure is called from Schedule to restore the
372: | demands/supplies for particular call of ATP_CHECK
373: +---------------------------------------------------------------*/
374: PROCEDURE Restore_SD_Rec(
375: p_pegging_tab IN MRP_ATP_PUB.Number_Arr,
376: x_return_status OUT NoCopy VARCHAR2
377: );
378:
379: /*--Delete_SD_Rec-----------------------------------------------

Line 385: p_pegging_tab IN MRP_ATP_PUB.Number_Arr,

381: | demands/supplies for particular call of ATP_CHECK
382: | 0 New Procedure needed as inventory item id is -ve.
383: +---------------------------------------------------------------*/
384: PROCEDURE Delete_SD_Rec(
385: p_pegging_tab IN MRP_ATP_PUB.Number_Arr,
386: x_return_status OUT NoCopy VARCHAR2
387: );
388:
389: END MSC_ATP_DB_UTILS;