1027: ) IS
1028: lv_p_plan_so number;
1029: lv_p_plan_type number;
1030: BEGIN
1031: /* DBMS_MVIEW.REFRESH ('MSC_ITEM_FCST_BOD_SR_LEVELS_MV','c');
1032: DBMS_MVIEW.REFRESH ('MSC_BOD_SO_SR_LEVELS_MV','c');
1033: */
1034: IF p_global_forecast = SYS_YES THEN
1035: DELETE MSC_ITEM_FCST_BOD_SR_LEVELS where plan_id = p_plan_id;
1031: /* DBMS_MVIEW.REFRESH ('MSC_ITEM_FCST_BOD_SR_LEVELS_MV','c');
1032: DBMS_MVIEW.REFRESH ('MSC_BOD_SO_SR_LEVELS_MV','c');
1033: */
1034: IF p_global_forecast = SYS_YES THEN
1035: DELETE MSC_ITEM_FCST_BOD_SR_LEVELS where plan_id = p_plan_id;
1036: COMMIT;
1037:
1038: INSERT /*+APPEND*/ INTO MSC_ITEM_FCST_BOD_SR_LEVELS
1039: (
1034: IF p_global_forecast = SYS_YES THEN
1035: DELETE MSC_ITEM_FCST_BOD_SR_LEVELS where plan_id = p_plan_id;
1036: COMMIT;
1037:
1038: INSERT /*+APPEND*/ INTO MSC_ITEM_FCST_BOD_SR_LEVELS
1039: (
1040: INVENTORY_ITEM_ID ,
1041: SR_INVENTORY_ITEM_ID ,
1042: ORGANIZATION_ID ,
1095: OWNING_ORG_ID ,
1096: CUSTOMER_ID ,
1097: CUSTOMER_SITE_ID ,
1098: ZONE_ID
1099: FROM MSC_ITEM_FCST_BOD_SR_LEVELS_V
1100: WHERE PLAN_ID = p_plan_id;
1101: COMMIT;
1102: END IF;
1103: