[Home] [Help]
1269: p_time_phased_atp IN VARCHAR2, -- For time_phased_atp
1270: p_ato_model_line_id IN number,
1271: p_demand_source_type IN Number, --cmro
1272: p_source_organization_Id IN NUMBER, --Bug 7118988
1273: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1274: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1275: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
1276: -- CTO ODR and Simplified Pegging
1277: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1270: p_ato_model_line_id IN number,
1271: p_demand_source_type IN Number, --cmro
1272: p_source_organization_Id IN NUMBER, --Bug 7118988
1273: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1274: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1275: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
1276: -- CTO ODR and Simplified Pegging
1277: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1278: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1271: p_demand_source_type IN Number, --cmro
1272: p_source_organization_Id IN NUMBER, --Bug 7118988
1273: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1274: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1275: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
1276: -- CTO ODR and Simplified Pegging
1277: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1278: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1279: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1273: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1274: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1275: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
1276: -- CTO ODR and Simplified Pegging
1277: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1278: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1279: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1280: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1281: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1274: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1275: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
1276: -- CTO ODR and Simplified Pegging
1277: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1278: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1279: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1280: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1281: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1282: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1275: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
1276: -- CTO ODR and Simplified Pegging
1277: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1278: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1279: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1280: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1281: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1282: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1283: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1276: -- CTO ODR and Simplified Pegging
1277: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1278: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1279: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1280: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1281: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1282: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1283: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1284: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1277: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1278: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1279: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1280: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1281: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1282: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1283: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1284: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1285: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1278: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1279: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1280: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1281: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1282: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1283: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1284: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1285: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1286: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
1279: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1280: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1281: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1282: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1283: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1284: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1285: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1286: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
1287: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
1280: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1281: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1282: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1283: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1284: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1285: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1286: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
1287: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
1288: -- End CTO ODR and Simplified Pegging
1281: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1282: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1283: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1284: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1285: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1286: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
1287: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
1288: -- End CTO ODR and Simplified Pegging
1289: )
1282: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1283: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1284: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1285: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1286: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
1287: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
1288: -- End CTO ODR and Simplified Pegging
1289: )
1290:
1283: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1284: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1285: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1286: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
1287: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
1288: -- End CTO ODR and Simplified Pegging
1289: )
1290:
1291: IS
1291: IS
1292: l_del_rows NUMBER;
1293: -- added for bug 2738280
1294: i PLS_INTEGER;
1295: l_old_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1296: l_old_demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1297: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1298: -- added for summary enhancement
1299: l_current_refresh_number NUMBER;
1292: l_del_rows NUMBER;
1293: -- added for bug 2738280
1294: i PLS_INTEGER;
1295: l_old_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1296: l_old_demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1297: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1298: -- added for summary enhancement
1299: l_current_refresh_number NUMBER;
1300: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1293: -- added for bug 2738280
1294: i PLS_INTEGER;
1295: l_old_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1296: l_old_demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1297: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1298: -- added for summary enhancement
1299: l_current_refresh_number NUMBER;
1300: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1301: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1296: l_old_demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1297: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1298: -- added for summary enhancement
1299: l_current_refresh_number NUMBER;
1300: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1301: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1302: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1303: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1304: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1297: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1298: -- added for summary enhancement
1299: l_current_refresh_number NUMBER;
1300: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1301: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1302: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1303: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1304: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1305: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1298: -- added for summary enhancement
1299: l_current_refresh_number NUMBER;
1300: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1301: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1302: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1303: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1304: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1305: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1306: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1299: l_current_refresh_number NUMBER;
1300: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1301: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1302: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1303: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1304: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1305: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1306: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1307: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1300: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1301: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1302: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1303: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1304: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1305: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1306: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1307: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1308: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1301: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1302: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1303: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1304: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1305: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1306: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1307: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1308: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1309: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1302: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1303: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1304: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1305: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1306: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1307: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1308: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1309: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1310: l_copy_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1303: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1304: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1305: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1306: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1307: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1308: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1309: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1310: l_copy_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1311: l_identifier_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1304: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1305: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1306: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1307: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1308: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1309: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1310: l_copy_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1311: l_identifier_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1312:
1305: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1306: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1307: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1308: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1309: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1310: l_copy_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1311: l_identifier_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1312:
1313: -- CTO ODR and Simplified Pegging
1306: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1307: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1308: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1309: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1310: l_copy_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1311: l_identifier_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1312:
1313: -- CTO ODR and Simplified Pegging
1314: l_return_status VARCHAR2(1);
1307: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1308: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1309: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1310: l_copy_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1311: l_identifier_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1312:
1313: -- CTO ODR and Simplified Pegging
1314: l_return_status VARCHAR2(1);
1315: BEGIN
3654: -- preserved back, as it was updated to 0 in the begining in case of reschedule in case of PDS.
3655:
3656: -- RAJJAIN 11/01/2002, Now schedule procedure passes reference to del_demand_ids array to this
3657: -- procedure
3658: PROCEDURE Undo_Delete_Row(p_identifiers IN MRP_ATP_PUB.Number_Arr,
3659: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
3660: p_instance_id IN NUMBER,
3661: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
3662: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
3655:
3656: -- RAJJAIN 11/01/2002, Now schedule procedure passes reference to del_demand_ids array to this
3657: -- procedure
3658: PROCEDURE Undo_Delete_Row(p_identifiers IN MRP_ATP_PUB.Number_Arr,
3659: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
3660: p_instance_id IN NUMBER,
3661: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
3662: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
3663: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3657: -- procedure
3658: PROCEDURE Undo_Delete_Row(p_identifiers IN MRP_ATP_PUB.Number_Arr,
3659: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
3660: p_instance_id IN NUMBER,
3661: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
3662: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
3663: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3664: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3665: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3658: PROCEDURE Undo_Delete_Row(p_identifiers IN MRP_ATP_PUB.Number_Arr,
3659: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
3660: p_instance_id IN NUMBER,
3661: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
3662: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
3663: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3664: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3665: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3666: -- CTO ODR and Simplified Pegging
3659: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
3660: p_instance_id IN NUMBER,
3661: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
3662: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
3663: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3664: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3665: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3666: -- CTO ODR and Simplified Pegging
3667: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3660: p_instance_id IN NUMBER,
3661: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
3662: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
3663: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3664: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3665: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3666: -- CTO ODR and Simplified Pegging
3667: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3668: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3663: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3664: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3665: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3666: -- CTO ODR and Simplified Pegging
3667: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3668: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3669: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3670: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3671: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3664: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3665: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3666: -- CTO ODR and Simplified Pegging
3667: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3668: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3669: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3670: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3671: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3672: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3665: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3666: -- CTO ODR and Simplified Pegging
3667: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3668: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3669: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3670: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3671: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3672: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3673: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3666: -- CTO ODR and Simplified Pegging
3667: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3668: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3669: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3670: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3671: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3672: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3673: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3674: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3667: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3668: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3669: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3670: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3671: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3672: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3673: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3674: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3675: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3668: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3669: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3670: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3671: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3672: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3673: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3674: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3675: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3676: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3669: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3670: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3671: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3672: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3673: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3674: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3675: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3676: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3677: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3670: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3671: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3672: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3673: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3674: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3675: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3676: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3677: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3678: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3671: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3672: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3673: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3674: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3675: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3676: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3677: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3678: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3679: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3672: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3673: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3674: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3675: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3676: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3677: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3678: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3679: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3680: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3673: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3674: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3675: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3676: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3677: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3678: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3679: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3680: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3681: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr,
3674: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3675: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3676: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3677: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3678: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3679: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3680: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3681: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr,
3682: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr
3675: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3676: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3677: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3678: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3679: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3680: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3681: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr,
3682: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr
3683: -- End CTO ODR and Simplified Pegging
3676: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3677: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3678: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3679: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3680: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3681: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr,
3682: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr
3683: -- End CTO ODR and Simplified Pegging
3684: )
3677: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3678: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3679: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3680: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3681: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr,
3682: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr
3683: -- End CTO ODR and Simplified Pegging
3684: )
3685:
3678: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3679: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3680: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3681: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr,
3682: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr
3683: -- End CTO ODR and Simplified Pegging
3684: )
3685:
3686: IS
3685:
3686: IS
3687: l_del_rows NUMBER;
3688: i NUMBER;
3689: --l_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3690: --l_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3691: --l_instance_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3692:
3693: --rajjain 11/01/2002
3686: IS
3687: l_del_rows NUMBER;
3688: i NUMBER;
3689: --l_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3690: --l_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3691: --l_instance_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3692:
3693: --rajjain 11/01/2002
3694: m PLS_INTEGER := 1;
3687: l_del_rows NUMBER;
3688: i NUMBER;
3689: --l_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3690: --l_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3691: --l_instance_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3692:
3693: --rajjain 11/01/2002
3694: m PLS_INTEGER := 1;
3695:
3693: --rajjain 11/01/2002
3694: m PLS_INTEGER := 1;
3695:
3696: -- For bug 2738280.
3697: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3698: l_using_assembly_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
3699: l_using_requirement_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3700: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3701: l_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3694: m PLS_INTEGER := 1;
3695:
3696: -- For bug 2738280.
3697: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3698: l_using_assembly_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
3699: l_using_requirement_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3700: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3701: l_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3702:
3695:
3696: -- For bug 2738280.
3697: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3698: l_using_assembly_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
3699: l_using_requirement_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3700: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3701: l_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3702:
3703: -- CTO ODR and Simplified Pegging
3696: -- For bug 2738280.
3697: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3698: l_using_assembly_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
3699: l_using_requirement_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3700: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3701: l_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3702:
3703: -- CTO ODR and Simplified Pegging
3704: l_return_status VARCHAR2(1);
3697: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3698: l_using_assembly_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
3699: l_using_requirement_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3700: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3701: l_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3702:
3703: -- CTO ODR and Simplified Pegging
3704: l_return_status VARCHAR2(1);
3705:
3995: p_instance_id IN NUMBER,
3996: p_demand_source_type IN NUMBER) --cmro
3997:
3998: IS
3999: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4000: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4001: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4002: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4003: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
3996: p_demand_source_type IN NUMBER) --cmro
3997:
3998: IS
3999: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4000: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4001: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4002: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4003: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4004: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3997:
3998: IS
3999: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4000: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4001: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4002: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4003: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4004: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4005: i number;
3998: IS
3999: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4000: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4001: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4002: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4003: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4004: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4005: i number;
4006: -- 5357370 changes, need user id/sysdate for insert/update
3999: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4000: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4001: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4002: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4003: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4004: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4005: i number;
4006: -- 5357370 changes, need user id/sysdate for insert/update
4007: l_user_id number;
4000: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4001: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4002: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4003: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4004: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4005: i number;
4006: -- 5357370 changes, need user id/sysdate for insert/update
4007: l_user_id number;
4008: l_sysdate date;
4172:
4173: END DELETE_SUMMARY_ROW;
4174:
4175: -- Bug 2738280. Change the body of procedure
4176: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4177: p_old_demand_date IN MRP_ATP_PUB.Date_Arr,
4178: p_old_demand_quantity IN MRP_ATP_PUB.Number_Arr,
4179: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4180: p_plan_id IN NUMBER,
4173: END DELETE_SUMMARY_ROW;
4174:
4175: -- Bug 2738280. Change the body of procedure
4176: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4177: p_old_demand_date IN MRP_ATP_PUB.Date_Arr,
4178: p_old_demand_quantity IN MRP_ATP_PUB.Number_Arr,
4179: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4180: p_plan_id IN NUMBER,
4181: p_instance_id IN NUMBER)
4174:
4175: -- Bug 2738280. Change the body of procedure
4176: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4177: p_old_demand_date IN MRP_ATP_PUB.Date_Arr,
4178: p_old_demand_quantity IN MRP_ATP_PUB.Number_Arr,
4179: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4180: p_plan_id IN NUMBER,
4181: p_instance_id IN NUMBER)
4182: IS
4175: -- Bug 2738280. Change the body of procedure
4176: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4177: p_old_demand_date IN MRP_ATP_PUB.Date_Arr,
4178: p_old_demand_quantity IN MRP_ATP_PUB.Number_Arr,
4179: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4180: p_plan_id IN NUMBER,
4181: p_instance_id IN NUMBER)
4182: IS
4183: l_counter PLS_INTEGER;
4219:
4220: END UPDATE_PLAN_SUMMARY_ROW;
4221:
4222: -- Bug 2738280. Change the body of procedure
4223: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4224: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
4225: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
4226: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4227: p_plan_id IN MRP_ATP_PUB.Number_Arr,
4220: END UPDATE_PLAN_SUMMARY_ROW;
4221:
4222: -- Bug 2738280. Change the body of procedure
4223: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4224: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
4225: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
4226: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4227: p_plan_id IN MRP_ATP_PUB.Number_Arr,
4228: p_instance_id IN NUMBER)
4221:
4222: -- Bug 2738280. Change the body of procedure
4223: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4224: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
4225: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
4226: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4227: p_plan_id IN MRP_ATP_PUB.Number_Arr,
4228: p_instance_id IN NUMBER)
4229: IS
4222: -- Bug 2738280. Change the body of procedure
4223: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4224: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
4225: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
4226: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4227: p_plan_id IN MRP_ATP_PUB.Number_Arr,
4228: p_instance_id IN NUMBER)
4229: IS
4230: l_counter PLS_INTEGER;
4223: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4224: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
4225: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
4226: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4227: p_plan_id IN MRP_ATP_PUB.Number_Arr,
4228: p_instance_id IN NUMBER)
4229: IS
4230: l_counter PLS_INTEGER;
4231: BEGIN
4440: END Add_Stealing_Supply_Details;
4441:
4442:
4443: PROCEDURE Remove_Invalid_Future_SD(
4444: p_future_pegging_tab IN MRP_ATP_PUB.Number_Arr
4445: )
4446: IS
4447:
4448: CURSOR pegging(p_pegging_id IN NUMBER)
4652:
4653: -- new procedure for summary enhancement
4654: -- Delete the copy demands that were created in this transaction if refresh number has moved.
4655: PROCEDURE Delete_Copy_Demand (
4656: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr,
4657: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr,
4658: p_time_phased_set IN VARCHAR2,
4659: x_return_status OUT NOCOPY VARCHAR2)
4660: IS
4653: -- new procedure for summary enhancement
4654: -- Delete the copy demands that were created in this transaction if refresh number has moved.
4655: PROCEDURE Delete_Copy_Demand (
4656: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr,
4657: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr,
4658: p_time_phased_set IN VARCHAR2,
4659: x_return_status OUT NOCOPY VARCHAR2)
4660: IS
4661: BEGIN
5076:
5077: --3720018, new procedure to call delete row for line/set/request level.
5078: Procedure call_delete_row (
5079: p_instance_id IN NUMBER,
5080: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
5081: p_refresh_number IN NUMBER,
5082: x_delete_atp_rec OUT NoCopy MSC_ATP_PVT.DELETE_ATP_REC,
5083: x_return_status OUT NoCopy VARCHAR2
5084: ) IS
5087: l_count NUMBER;
5088: l_line_id_count NUMBER;
5089: l_so_tbl_status PLS_INTEGER;
5090: l_summary_flag number;
5091: l_old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5092: l_atf_dates MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5093: l_old_pf_item_id number;
5094: l_pf_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5095: l_plan_id NUMBER := -1;
5088: l_line_id_count NUMBER;
5089: l_so_tbl_status PLS_INTEGER;
5090: l_summary_flag number;
5091: l_old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5092: l_atf_dates MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5093: l_old_pf_item_id number;
5094: l_pf_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5095: l_plan_id NUMBER := -1;
5096: l_return_status VARCHAR2(10);
5090: l_summary_flag number;
5091: l_old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5092: l_atf_dates MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5093: l_old_pf_item_id number;
5094: l_pf_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5095: l_plan_id NUMBER := -1;
5096: l_return_status VARCHAR2(10);
5097: l_temp_assign_set_id NUMBER;
5098: l_time_phased_atp VARCHAR2(1) := 'N';
5096: l_return_status VARCHAR2(10);
5097: l_temp_assign_set_id NUMBER;
5098: l_time_phased_atp VARCHAR2(1) := 'N';
5099: l_time_phased_set VARCHAR2(1) := 'N';
5100: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5101: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5102: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
5103: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5104: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5097: l_temp_assign_set_id NUMBER;
5098: l_time_phased_atp VARCHAR2(1) := 'N';
5099: l_time_phased_set VARCHAR2(1) := 'N';
5100: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5101: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5102: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
5103: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5104: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5105: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5099: l_time_phased_set VARCHAR2(1) := 'N';
5100: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5101: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5102: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
5103: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5104: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5105: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5106: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5107: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5100: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5101: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5102: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
5103: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5104: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5105: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5106: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5107: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5108: l_delete_demand_flag PLS_INTEGER;
5101: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5102: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
5103: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5104: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5105: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5106: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5107: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5108: l_delete_demand_flag PLS_INTEGER;
5109: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5102: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
5103: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5104: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5105: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5106: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5107: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5108: l_delete_demand_flag PLS_INTEGER;
5109: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5110: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5103: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5104: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5105: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5106: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5107: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5108: l_delete_demand_flag PLS_INTEGER;
5109: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5110: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5111: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5105: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5106: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5107: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5108: l_delete_demand_flag PLS_INTEGER;
5109: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5110: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5111: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5112: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5113: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5106: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5107: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5108: l_delete_demand_flag PLS_INTEGER;
5109: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5110: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5111: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5112: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5113: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5114: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5107: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5108: l_delete_demand_flag PLS_INTEGER;
5109: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5110: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5111: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5112: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5113: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5114: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5115: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5108: l_delete_demand_flag PLS_INTEGER;
5109: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5110: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5111: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5112: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5113: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5114: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5115: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5116: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5109: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5110: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5111: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5112: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5113: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5114: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5115: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5116: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5117: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5110: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5111: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5112: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5113: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5114: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5115: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5116: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5117: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5118: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5111: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5112: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5113: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5114: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5115: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5116: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5117: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5118: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5119: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5112: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5113: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5114: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5115: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5116: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5117: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5118: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5119: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5120: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5113: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5114: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5115: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5116: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5117: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5118: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5119: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5120: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5121: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5114: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5115: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5116: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5117: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5118: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5119: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5120: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5121: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5122: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5115: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5116: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5117: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5118: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5119: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5120: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5121: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5122: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5123: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5116: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5117: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5118: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5119: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5120: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5121: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5122: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5123: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5124: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5117: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5118: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5119: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5120: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5121: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5122: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5123: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5124: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5125: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5118: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5119: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5120: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5121: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5122: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5123: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5124: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5125: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5126: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5119: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5120: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5121: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5122: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5123: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5124: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5125: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5126: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5127: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5120: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5121: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5122: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5123: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5124: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5125: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5126: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5127: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5128: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5121: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5122: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5123: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5124: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5125: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5126: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5127: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5128: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5129: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5122: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5123: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5124: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5125: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5126: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5127: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5128: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5129: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5130: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5123: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5124: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5125: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5126: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5127: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5128: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5129: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5130: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5131: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5124: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5125: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5126: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5127: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5128: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5129: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5130: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5131: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5132: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5125: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5126: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5127: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5128: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5129: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5130: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5131: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5132: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5133: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5126: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5127: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5128: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5129: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5130: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5131: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5132: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5133: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5134: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5127: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5128: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5129: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5130: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5131: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5132: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5133: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5134: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5135: l_del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5128: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5129: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5130: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5131: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5132: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5133: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5134: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5135: l_del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5136: l_del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5129: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5130: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5131: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5132: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5133: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5134: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5135: l_del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5136: l_del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5137: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5130: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5131: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5132: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5133: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5134: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5135: l_del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5136: l_del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5137: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5138: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5131: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5132: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5133: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5134: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5135: l_del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5136: l_del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5137: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5138: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5139: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5132: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5133: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5134: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5135: l_del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5136: l_del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5137: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5138: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5139: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5140: l_del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5133: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5134: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5135: l_del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5136: l_del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5137: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5138: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5139: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5140: l_del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5141: l_delete_atp_rec MSC_ATP_PVT.DELETE_ATP_REC;
5134: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5135: l_del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5136: l_del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5137: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5138: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5139: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5140: l_del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5141: l_delete_atp_rec MSC_ATP_PVT.DELETE_ATP_REC;
5142: l_attribute_07 MRP_ATP_PUB.char30_Arr := MRP_ATP_PUB.char30_Arr();
5135: l_del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5136: l_del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5137: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5138: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5139: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5140: l_del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5141: l_delete_atp_rec MSC_ATP_PVT.DELETE_ATP_REC;
5142: l_attribute_07 MRP_ATP_PUB.char30_Arr := MRP_ATP_PUB.char30_Arr();
5143:
5136: l_del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5137: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5138: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5139: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5140: l_del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5141: l_delete_atp_rec MSC_ATP_PVT.DELETE_ATP_REC;
5142: l_attribute_07 MRP_ATP_PUB.char30_Arr := MRP_ATP_PUB.char30_Arr();
5143:
5144: BEGIN
5138: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5139: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5140: l_del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5141: l_delete_atp_rec MSC_ATP_PVT.DELETE_ATP_REC;
5142: l_attribute_07 MRP_ATP_PUB.char30_Arr := MRP_ATP_PUB.char30_Arr();
5143:
5144: BEGIN
5145: IF PG_DEBUG in ('Y', 'C') THEN
5146: msc_sch_wb.atp_debug('*** Begin Call_delete_row ***');
5546: p_instance_id IN NUMBER,
5547: p_demand_source_type IN NUMBER)
5548:
5549: IS
5550: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5551: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5552: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5553: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5554: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5547: p_demand_source_type IN NUMBER)
5548:
5549: IS
5550: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5551: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5552: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5553: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5554: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5555: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5548:
5549: IS
5550: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5551: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5552: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5553: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5554: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5555: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5556: i number;
5549: IS
5550: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5551: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5552: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5553: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5554: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5555: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5556: i number;
5557: -- 5357370 changes, need user id/sysdate for insert/update
5550: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5551: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5552: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5553: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5554: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5555: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5556: i number;
5557: -- 5357370 changes, need user id/sysdate for insert/update
5558: l_user_id number;
5551: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5552: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5553: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5554: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5555: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5556: i number;
5557: -- 5357370 changes, need user id/sysdate for insert/update
5558: l_user_id number;
5559: l_sysdate date;