1422: p_time_phased_atp IN VARCHAR2, -- For time_phased_atp
1423: p_ato_model_line_id IN number,
1424: p_demand_source_type IN Number, --cmro
1425: p_source_organization_Id IN NUMBER, --Bug 7118988
1426: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1427: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1428: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
1429: -- CTO ODR and Simplified Pegging
1430: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1423: p_ato_model_line_id IN number,
1424: p_demand_source_type IN Number, --cmro
1425: p_source_organization_Id IN NUMBER, --Bug 7118988
1426: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1427: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1428: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
1429: -- CTO ODR and Simplified Pegging
1430: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1431: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1424: p_demand_source_type IN Number, --cmro
1425: p_source_organization_Id IN NUMBER, --Bug 7118988
1426: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1427: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1428: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
1429: -- CTO ODR and Simplified Pegging
1430: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1431: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1432: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1426: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1427: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1428: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
1429: -- CTO ODR and Simplified Pegging
1430: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1431: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1432: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1433: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1434: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1427: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
1428: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
1429: -- CTO ODR and Simplified Pegging
1430: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1431: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1432: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1433: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1434: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1435: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1428: x_copy_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr, -- For summary enhancement
1429: -- CTO ODR and Simplified Pegging
1430: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1431: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1432: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1433: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1434: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1435: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1436: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1429: -- CTO ODR and Simplified Pegging
1430: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1431: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1432: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1433: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1434: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1435: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1436: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1437: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1430: x_atp_peg_items OUT NoCopy MRP_ATP_PUB.Number_Arr,
1431: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1432: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1433: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1434: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1435: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1436: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1437: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1438: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1431: x_atp_peg_demands OUT NoCopy MRP_ATP_PUB.Number_Arr,
1432: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1433: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1434: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1435: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1436: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1437: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1438: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1439: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
1432: x_atp_peg_supplies OUT NoCopy MRP_ATP_PUB.Number_Arr,
1433: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1434: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1435: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1436: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1437: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1438: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1439: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
1440: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
1433: x_atp_peg_res_reqs OUT NoCopy MRP_ATP_PUB.Number_Arr,
1434: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1435: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1436: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1437: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1438: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1439: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
1440: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
1441: -- End CTO ODR and Simplified Pegging
1434: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1435: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1436: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1437: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1438: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1439: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
1440: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
1441: -- End CTO ODR and Simplified Pegging
1442: )
1435: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1436: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1437: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1438: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1439: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
1440: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
1441: -- End CTO ODR and Simplified Pegging
1442: )
1443:
1436: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
1437: x_ods_cto_demand_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1438: x_ods_cto_inv_item_ids OUT NoCopy MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
1439: x_ods_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr,
1440: x_ods_cto_atp_refresh_no OUT NoCopy MRP_ATP_PUB.Number_Arr
1441: -- End CTO ODR and Simplified Pegging
1442: )
1443:
1444: IS
1444: IS
1445: l_del_rows NUMBER;
1446: -- added for bug 2738280
1447: i PLS_INTEGER;
1448: l_old_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1449: l_old_demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1450: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1451: -- added for summary enhancement
1452: l_current_refresh_number NUMBER;
1445: l_del_rows NUMBER;
1446: -- added for bug 2738280
1447: i PLS_INTEGER;
1448: l_old_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1449: l_old_demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1450: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1451: -- added for summary enhancement
1452: l_current_refresh_number NUMBER;
1453: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1446: -- added for bug 2738280
1447: i PLS_INTEGER;
1448: l_old_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1449: l_old_demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1450: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1451: -- added for summary enhancement
1452: l_current_refresh_number NUMBER;
1453: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1454: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1449: l_old_demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1450: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1451: -- added for summary enhancement
1452: l_current_refresh_number NUMBER;
1453: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1454: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1455: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1456: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1457: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1450: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1451: -- added for summary enhancement
1452: l_current_refresh_number NUMBER;
1453: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1454: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1455: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1456: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1457: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1458: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1451: -- added for summary enhancement
1452: l_current_refresh_number NUMBER;
1453: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1454: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1455: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1456: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1457: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1458: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1459: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1452: l_current_refresh_number NUMBER;
1453: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1454: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1455: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1456: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1457: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1458: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1459: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1460: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1453: i_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1454: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1455: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1456: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1457: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1458: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1459: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1460: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1461: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1454: l_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1455: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1456: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1457: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1458: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1459: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1460: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1461: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1462: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1455: l_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1456: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1457: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1458: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1459: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1460: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1461: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1462: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1463: l_copy_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1456: l_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1457: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1458: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1459: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1460: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1461: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1462: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1463: l_copy_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1464: l_identifier_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1457: i_ins_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1458: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1459: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1460: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1461: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1462: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1463: l_copy_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1464: l_identifier_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1465:
1458: l_ins_org_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1459: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1460: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1461: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1462: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1463: l_copy_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1464: l_identifier_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1465:
1466: -- CTO ODR and Simplified Pegging
1459: l_ins_refresh_number_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1460: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1461: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1462: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1463: l_copy_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1464: l_identifier_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1465:
1466: -- CTO ODR and Simplified Pegging
1467: l_return_status VARCHAR2(1);
1460: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
1461: l_ins_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1462: l_ins_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
1463: l_copy_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1464: l_identifier_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1465:
1466: -- CTO ODR and Simplified Pegging
1467: l_return_status VARCHAR2(1);
1468: BEGIN
3824: -- preserved back, as it was updated to 0 in the begining in case of reschedule in case of PDS.
3825:
3826: -- RAJJAIN 11/01/2002, Now schedule procedure passes reference to del_demand_ids array to this
3827: -- procedure
3828: PROCEDURE Undo_Delete_Row(p_identifiers IN MRP_ATP_PUB.Number_Arr,
3829: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
3830: p_instance_id IN NUMBER,
3831: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
3832: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
3825:
3826: -- RAJJAIN 11/01/2002, Now schedule procedure passes reference to del_demand_ids array to this
3827: -- procedure
3828: PROCEDURE Undo_Delete_Row(p_identifiers IN MRP_ATP_PUB.Number_Arr,
3829: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
3830: p_instance_id IN NUMBER,
3831: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
3832: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
3833: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3827: -- procedure
3828: PROCEDURE Undo_Delete_Row(p_identifiers IN MRP_ATP_PUB.Number_Arr,
3829: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
3830: p_instance_id IN NUMBER,
3831: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
3832: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
3833: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3834: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3835: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3828: PROCEDURE Undo_Delete_Row(p_identifiers IN MRP_ATP_PUB.Number_Arr,
3829: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
3830: p_instance_id IN NUMBER,
3831: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
3832: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
3833: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3834: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3835: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3836: -- CTO ODR and Simplified Pegging
3829: p_plan_ids IN MRP_ATP_PUB.Number_Arr,
3830: p_instance_id IN NUMBER,
3831: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
3832: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
3833: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3834: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3835: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3836: -- CTO ODR and Simplified Pegging
3837: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3830: p_instance_id IN NUMBER,
3831: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
3832: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
3833: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3834: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3835: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3836: -- CTO ODR and Simplified Pegging
3837: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3838: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3833: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3834: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3835: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3836: -- CTO ODR and Simplified Pegging
3837: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3838: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3839: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3840: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3841: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3834: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr, -- For summary enhancement
3835: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3836: -- CTO ODR and Simplified Pegging
3837: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3838: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3839: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3840: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3841: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3842: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3835: p_time_phased_set IN VARCHAR2, -- For time_phased_atp
3836: -- CTO ODR and Simplified Pegging
3837: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3838: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3839: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3840: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3841: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3842: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3843: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3836: -- CTO ODR and Simplified Pegging
3837: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3838: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3839: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3840: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3841: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3842: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3843: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3844: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3837: p_del_atp_peg_items IN MRP_ATP_PUB.Number_Arr,
3838: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3839: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3840: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3841: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3842: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3843: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3844: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3845: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3838: p_del_atp_peg_demands IN MRP_ATP_PUB.Number_Arr,
3839: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3840: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3841: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3842: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3843: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3844: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3845: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3846: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3839: p_del_atp_peg_supplies IN MRP_ATP_PUB.Number_Arr,
3840: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3841: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3842: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3843: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3844: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3845: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3846: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3847: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3840: p_del_atp_peg_res_reqs IN MRP_ATP_PUB.Number_Arr,
3841: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3842: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3843: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3844: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3845: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3846: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3847: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3848: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3841: p_demand_source_type IN MRP_ATP_PUB.Number_Arr, --cmro
3842: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3843: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3844: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3845: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3846: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3847: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3848: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3849: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3842: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3843: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3844: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3845: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3846: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3847: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3848: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3849: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3850: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3843: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3844: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3845: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3846: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3847: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3848: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3849: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3850: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3851: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr,
3844: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
3845: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3846: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3847: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3848: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3849: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3850: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3851: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr,
3852: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr
3845: p_del_ods_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3846: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3847: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3848: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3849: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3850: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3851: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr,
3852: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr
3853: -- End CTO ODR and Simplified Pegging
3846: p_del_ods_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3847: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3848: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3849: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3850: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3851: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr,
3852: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr
3853: -- End CTO ODR and Simplified Pegging
3854: )
3847: p_del_ods_demand_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3848: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3849: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3850: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3851: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr,
3852: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr
3853: -- End CTO ODR and Simplified Pegging
3854: )
3855:
3848: p_del_ods_cto_demand_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3849: p_del_ods_cto_inv_item_ids IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3850: p_del_ods_cto_dem_src_type IN MRP_ATP_PUB.Number_Arr, --3720018, added for support of rescheduling in ODS
3851: p_del_ods_atp_refresh_no IN MRP_ATP_PUB.Number_Arr,
3852: p_del_ods_cto_atp_refresh_no IN MRP_ATP_PUB.Number_Arr
3853: -- End CTO ODR and Simplified Pegging
3854: )
3855:
3856: IS
3855:
3856: IS
3857: l_del_rows NUMBER;
3858: i NUMBER;
3859: --l_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3860: --l_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3861: --l_instance_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3862:
3863: --rajjain 11/01/2002
3856: IS
3857: l_del_rows NUMBER;
3858: i NUMBER;
3859: --l_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3860: --l_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3861: --l_instance_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3862:
3863: --rajjain 11/01/2002
3864: m PLS_INTEGER := 1;
3857: l_del_rows NUMBER;
3858: i NUMBER;
3859: --l_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3860: --l_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3861: --l_instance_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3862:
3863: --rajjain 11/01/2002
3864: m PLS_INTEGER := 1;
3865:
3863: --rajjain 11/01/2002
3864: m PLS_INTEGER := 1;
3865:
3866: -- For bug 2738280.
3867: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3868: l_using_assembly_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
3869: l_using_requirement_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3870: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3871: l_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3864: m PLS_INTEGER := 1;
3865:
3866: -- For bug 2738280.
3867: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3868: l_using_assembly_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
3869: l_using_requirement_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3870: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3871: l_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3872:
3865:
3866: -- For bug 2738280.
3867: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3868: l_using_assembly_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
3869: l_using_requirement_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3870: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3871: l_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3872:
3873: -- CTO ODR and Simplified Pegging
3866: -- For bug 2738280.
3867: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3868: l_using_assembly_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
3869: l_using_requirement_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3870: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3871: l_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3872:
3873: -- CTO ODR and Simplified Pegging
3874: l_return_status VARCHAR2(1);
3867: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3868: l_using_assembly_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
3869: l_using_requirement_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3870: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3871: l_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3872:
3873: -- CTO ODR and Simplified Pegging
3874: l_return_status VARCHAR2(1);
3875: l_alloc_atp VARCHAR2(1) := MSC_ATP_PVT.G_ALLOCATED_ATP; --ALLOC ATP CHANGES -12973673
4177: p_instance_id IN NUMBER,
4178: p_demand_source_type IN NUMBER) --cmro
4179:
4180: IS
4181: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4182: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4183: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4184: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4185: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4178: p_demand_source_type IN NUMBER) --cmro
4179:
4180: IS
4181: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4182: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4183: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4184: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4185: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4186: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4179:
4180: IS
4181: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4182: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4183: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4184: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4185: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4186: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4187: i number;
4180: IS
4181: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4182: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4183: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4184: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4185: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4186: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4187: i number;
4188: -- 5357370 changes, need user id/sysdate for insert/update
4181: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4182: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4183: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4184: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4185: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4186: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4187: i number;
4188: -- 5357370 changes, need user id/sysdate for insert/update
4189: l_user_id number;
4182: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4183: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4184: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4185: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4186: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4187: i number;
4188: -- 5357370 changes, need user id/sysdate for insert/update
4189: l_user_id number;
4190: l_sysdate date;
4354:
4355: END DELETE_SUMMARY_ROW;
4356:
4357: -- Bug 2738280. Change the body of procedure
4358: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4359: p_old_demand_date IN MRP_ATP_PUB.Date_Arr,
4360: p_old_demand_quantity IN MRP_ATP_PUB.Number_Arr,
4361: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4362: p_plan_id IN NUMBER,
4355: END DELETE_SUMMARY_ROW;
4356:
4357: -- Bug 2738280. Change the body of procedure
4358: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4359: p_old_demand_date IN MRP_ATP_PUB.Date_Arr,
4360: p_old_demand_quantity IN MRP_ATP_PUB.Number_Arr,
4361: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4362: p_plan_id IN NUMBER,
4363: p_instance_id IN NUMBER)
4356:
4357: -- Bug 2738280. Change the body of procedure
4358: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4359: p_old_demand_date IN MRP_ATP_PUB.Date_Arr,
4360: p_old_demand_quantity IN MRP_ATP_PUB.Number_Arr,
4361: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4362: p_plan_id IN NUMBER,
4363: p_instance_id IN NUMBER)
4364: IS
4357: -- Bug 2738280. Change the body of procedure
4358: PROCEDURE UPDATE_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4359: p_old_demand_date IN MRP_ATP_PUB.Date_Arr,
4360: p_old_demand_quantity IN MRP_ATP_PUB.Number_Arr,
4361: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4362: p_plan_id IN NUMBER,
4363: p_instance_id IN NUMBER)
4364: IS
4365: l_counter PLS_INTEGER;
4401:
4402: END UPDATE_PLAN_SUMMARY_ROW;
4403:
4404: -- Bug 2738280. Change the body of procedure
4405: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4406: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
4407: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
4408: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4409: p_plan_id IN MRP_ATP_PUB.Number_Arr,
4402: END UPDATE_PLAN_SUMMARY_ROW;
4403:
4404: -- Bug 2738280. Change the body of procedure
4405: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4406: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
4407: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
4408: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4409: p_plan_id IN MRP_ATP_PUB.Number_Arr,
4410: p_instance_id IN NUMBER)
4403:
4404: -- Bug 2738280. Change the body of procedure
4405: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4406: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
4407: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
4408: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4409: p_plan_id IN MRP_ATP_PUB.Number_Arr,
4410: p_instance_id IN NUMBER)
4411: IS
4404: -- Bug 2738280. Change the body of procedure
4405: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4406: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
4407: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
4408: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4409: p_plan_id IN MRP_ATP_PUB.Number_Arr,
4410: p_instance_id IN NUMBER)
4411: IS
4412: l_counter PLS_INTEGER;
4405: PROCEDURE UNDO_PLAN_SUMMARY_ROW (p_inventory_item_id IN MRP_ATP_PUB.Number_Arr,
4406: p_using_assembly_demand_date IN MRP_ATP_PUB.Date_Arr,
4407: p_using_requirement_quantity IN MRP_ATP_PUB.Number_Arr,
4408: p_organization_id IN MRP_ATP_PUB.Number_Arr,
4409: p_plan_id IN MRP_ATP_PUB.Number_Arr,
4410: p_instance_id IN NUMBER)
4411: IS
4412: l_counter PLS_INTEGER;
4413: BEGIN
4622: END Add_Stealing_Supply_Details;
4623:
4624:
4625: PROCEDURE Remove_Invalid_Future_SD(
4626: p_future_pegging_tab IN MRP_ATP_PUB.Number_Arr
4627: )
4628: IS
4629:
4630: CURSOR pegging(p_pegging_id IN NUMBER)
4834:
4835: -- new procedure for summary enhancement
4836: -- Delete the copy demands that were created in this transaction if refresh number has moved.
4837: PROCEDURE Delete_Copy_Demand (
4838: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr,
4839: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr,
4840: p_time_phased_set IN VARCHAR2,
4841: x_return_status OUT NOCOPY VARCHAR2)
4842: IS
4835: -- new procedure for summary enhancement
4836: -- Delete the copy demands that were created in this transaction if refresh number has moved.
4837: PROCEDURE Delete_Copy_Demand (
4838: p_copy_demand_ids IN MRP_ATP_PUB.Number_Arr,
4839: p_copy_plan_ids IN MRP_ATP_PUB.Number_Arr,
4840: p_time_phased_set IN VARCHAR2,
4841: x_return_status OUT NOCOPY VARCHAR2)
4842: IS
4843: BEGIN
5258:
5259: --3720018, new procedure to call delete row for line/set/request level.
5260: Procedure call_delete_row (
5261: p_instance_id IN NUMBER,
5262: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
5263: p_refresh_number IN NUMBER,
5264: x_delete_atp_rec OUT NoCopy MSC_ATP_PVT.DELETE_ATP_REC,
5265: x_return_status OUT NoCopy VARCHAR2
5266: ) IS
5269: l_count NUMBER;
5270: l_line_id_count NUMBER;
5271: l_so_tbl_status PLS_INTEGER;
5272: l_summary_flag number;
5273: l_old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5274: l_atf_dates MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5275: l_old_pf_item_id number;
5276: l_pf_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5277: l_plan_id NUMBER := -1;
5270: l_line_id_count NUMBER;
5271: l_so_tbl_status PLS_INTEGER;
5272: l_summary_flag number;
5273: l_old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5274: l_atf_dates MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5275: l_old_pf_item_id number;
5276: l_pf_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5277: l_plan_id NUMBER := -1;
5278: l_return_status VARCHAR2(10);
5272: l_summary_flag number;
5273: l_old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5274: l_atf_dates MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5275: l_old_pf_item_id number;
5276: l_pf_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5277: l_plan_id NUMBER := -1;
5278: l_return_status VARCHAR2(10);
5279: l_temp_assign_set_id NUMBER;
5280: l_time_phased_atp VARCHAR2(1) := 'N';
5278: l_return_status VARCHAR2(10);
5279: l_temp_assign_set_id NUMBER;
5280: l_time_phased_atp VARCHAR2(1) := 'N';
5281: l_time_phased_set VARCHAR2(1) := 'N';
5282: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5283: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5284: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
5285: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5286: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5279: l_temp_assign_set_id NUMBER;
5280: l_time_phased_atp VARCHAR2(1) := 'N';
5281: l_time_phased_set VARCHAR2(1) := 'N';
5282: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5283: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5284: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
5285: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5286: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5287: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5281: l_time_phased_set VARCHAR2(1) := 'N';
5282: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5283: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5284: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
5285: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5286: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5287: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5288: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5289: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5282: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5283: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5284: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
5285: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5286: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5287: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5288: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5289: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5290: l_delete_demand_flag PLS_INTEGER;
5283: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5284: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
5285: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5286: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5287: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5288: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5289: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5290: l_delete_demand_flag PLS_INTEGER;
5291: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5284: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
5285: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5286: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5287: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5288: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5289: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5290: l_delete_demand_flag PLS_INTEGER;
5291: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5292: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5285: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5286: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5287: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5288: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5289: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5290: l_delete_demand_flag PLS_INTEGER;
5291: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5292: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5293: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5287: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5288: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5289: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5290: l_delete_demand_flag PLS_INTEGER;
5291: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5292: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5293: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5294: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5295: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5288: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5289: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5290: l_delete_demand_flag PLS_INTEGER;
5291: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5292: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5293: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5294: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5295: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5296: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5289: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
5290: l_delete_demand_flag PLS_INTEGER;
5291: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5292: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5293: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5294: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5295: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5296: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5297: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5290: l_delete_demand_flag PLS_INTEGER;
5291: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5292: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5293: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5294: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5295: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5296: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5297: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5298: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5291: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5292: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5293: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5294: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5295: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5296: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5297: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5298: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5299: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5292: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5293: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5294: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5295: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5296: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5297: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5298: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5299: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5300: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5293: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
5294: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5295: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5296: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5297: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5298: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5299: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5300: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5301: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5294: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
5295: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5296: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5297: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5298: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5299: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5300: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5301: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5302: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5295: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
5296: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5297: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5298: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5299: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5300: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5301: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5302: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5303: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5296: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
5297: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5298: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5299: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5300: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5301: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5302: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5303: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5304: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5297: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
5298: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5299: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5300: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5301: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5302: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5303: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5304: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5305: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5298: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5299: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5300: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5301: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5302: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5303: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5304: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5305: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5306: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5299: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5300: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5301: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5302: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5303: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5304: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5305: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5306: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5307: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5300: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
5301: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5302: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5303: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5304: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5305: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5306: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5307: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5308: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5301: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5302: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5303: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5304: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5305: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5306: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5307: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5308: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5309: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5302: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5303: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5304: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5305: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5306: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5307: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5308: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5309: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5310: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5303: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5304: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5305: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5306: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5307: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5308: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5309: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5310: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5311: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5304: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5305: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5306: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5307: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5308: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5309: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5310: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5311: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5312: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5305: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5306: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5307: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5308: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5309: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5310: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5311: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5312: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5313: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5306: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5307: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5308: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5309: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5310: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5311: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5312: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5313: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5314: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5307: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5308: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5309: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5310: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5311: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5312: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5313: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5314: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5315: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5308: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5309: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5310: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5311: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5312: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5313: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5314: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5315: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5316: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5309: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5310: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5311: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5312: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5313: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5314: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5315: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5316: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5317: 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
5310: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
5311: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5312: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5313: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5314: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5315: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5316: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5317: 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
5318: 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
5311: l_del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5312: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5313: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5314: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5315: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5316: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5317: 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
5318: 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
5319: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5312: l_del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5313: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5314: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5315: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5316: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5317: 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
5318: 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
5319: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5320: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5313: l_del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5314: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5315: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5316: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5317: 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
5318: 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
5319: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5320: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5321: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5314: l_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5315: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5316: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5317: 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
5318: 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
5319: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5320: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5321: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5322: l_del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5315: l_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5316: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5317: 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
5318: 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
5319: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5320: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5321: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5322: l_del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5323: l_delete_atp_rec MSC_ATP_PVT.DELETE_ATP_REC;
5316: l_del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --3720018, added for support of rescheduling in ODS
5317: 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
5318: 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
5319: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5320: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5321: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5322: l_del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5323: l_delete_atp_rec MSC_ATP_PVT.DELETE_ATP_REC;
5324: l_attribute_07 MRP_ATP_PUB.char30_Arr := MRP_ATP_PUB.char30_Arr();
5317: 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
5318: 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
5319: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5320: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5321: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5322: l_del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5323: l_delete_atp_rec MSC_ATP_PVT.DELETE_ATP_REC;
5324: l_attribute_07 MRP_ATP_PUB.char30_Arr := MRP_ATP_PUB.char30_Arr();
5325: l_alloc_atp varchar2(1) := MSC_ATP_PVT.G_ALLOCATED_ATP; -- ALLOC ATP CHANGES, 12973673
5318: 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
5319: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5320: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5321: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5322: l_del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5323: l_delete_atp_rec MSC_ATP_PVT.DELETE_ATP_REC;
5324: l_attribute_07 MRP_ATP_PUB.char30_Arr := MRP_ATP_PUB.char30_Arr();
5325: l_alloc_atp varchar2(1) := MSC_ATP_PVT.G_ALLOCATED_ATP; -- ALLOC ATP CHANGES, 12973673
5326:
5320: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5321: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5322: l_del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5323: l_delete_atp_rec MSC_ATP_PVT.DELETE_ATP_REC;
5324: l_attribute_07 MRP_ATP_PUB.char30_Arr := MRP_ATP_PUB.char30_Arr();
5325: l_alloc_atp varchar2(1) := MSC_ATP_PVT.G_ALLOCATED_ATP; -- ALLOC ATP CHANGES, 12973673
5326:
5327: BEGIN
5328: IF PG_DEBUG in ('Y', 'C') THEN
5750: p_instance_id IN NUMBER,
5751: p_demand_source_type IN NUMBER)
5752:
5753: IS
5754: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5755: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5756: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5757: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5758: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5751: p_demand_source_type IN NUMBER)
5752:
5753: IS
5754: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5755: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5756: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5757: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5758: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5759: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5752:
5753: IS
5754: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5755: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5756: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5757: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5758: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5759: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5760: i number;
5753: IS
5754: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5755: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5756: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5757: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5758: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5759: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5760: i number;
5761: -- 5357370 changes, need user id/sysdate for insert/update
5754: l_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5755: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5756: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5757: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5758: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5759: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5760: i number;
5761: -- 5357370 changes, need user id/sysdate for insert/update
5762: l_user_id number;
5755: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5756: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5757: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5758: l_sd_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5759: l_sd_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
5760: i number;
5761: -- 5357370 changes, need user id/sysdate for insert/update
5762: l_user_id number;
5763: l_sysdate date;
6111: | demands/supplies for particular call of ATP_CHECK
6112: | 0 New Procedure needed as inventory item id is -ve.
6113: +---------------------------------------------------------------*/
6114: PROCEDURE Delete_SD_Rec(
6115: p_pegging_tab IN MRP_ATP_PUB.Number_Arr,
6116: x_return_status OUT NoCopy VARCHAR2
6117: )
6118: IS
6119:
6276: | o This procedure is called from Schedule to restore the
6277: | demands/supplies for particular call of ATP_CHECK
6278: +---------------------------------------------------------------*/
6279: PROCEDURE Restore_SD_Rec(
6280: p_pegging_tab IN MRP_ATP_PUB.Number_Arr,
6281: x_return_status OUT NoCopy VARCHAR2
6282: )
6283: IS
6284: