[Home] [Help]
2721: lv_res_incr_refresh:= TRUE;
2722: lv_res_partial_refresh := FALSE;
2723: end if;
2724: end if;
2725: /* Bug 2878327 - We will always delete msc_department_resources and insert
2726: into it as it uses no snapshots
2727: */
2728:
2729: /* ds change change start */
2748:
2749: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_GROUPS', MSC_CL_COLLECTION.v_instance_id, NULL); /*No Organization_id Column */
2750:
2751: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2752: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPARTMENT_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
2753: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SIMULATION_SETS', MSC_CL_COLLECTION.v_instance_id,NULL);
2754: ELSE
2755: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2756: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPARTMENT_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2752: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPARTMENT_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
2753: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SIMULATION_SETS', MSC_CL_COLLECTION.v_instance_id,NULL);
2754: ELSE
2755: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2756: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPARTMENT_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2757: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SIMULATION_SETS', MSC_CL_COLLECTION.v_instance_id,NULL,v_sub_str);
2758: END IF;
2759:
2760: ELSE
2763:
2764: /* Bug 3041176 - Delete Only Department resources in NetChange */
2765:
2766: p_instance_id := MSC_CL_COLLECTION.v_instance_id;
2767: p_table_name := 'MSC_DEPARTMENT_RESOURCES';
2768:
2769: lv_pbs:= TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
2770:
2771: lv_sql_stmt:= 'SELECT COUNT(*)'
2861:
2862: IF (lv_res_incr_refresh) THEN
2863: IF c_rec.DELETED_FLAG= MSC_UTIL.SYS_YES THEN
2864:
2865: UPDATE MSC_DEPARTMENT_RESOURCES
2866: SET CAPACITY_UNITS= 0,
2867: MAX_RATE= 0,
2868: MIN_RATE= 0,
2869: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
2875: AND RESOURCE_ID= c_rec.RESOURCE_ID
2876: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
2877:
2878: ELSE
2879: UPDATE MSC_DEPARTMENT_RESOURCES
2880: SET
2881: RESOURCE_CODE= c_rec.RESOURCE_CODE,
2882: DEPARTMENT_CODE= c_rec.DEPARTMENT_CODE,
2883: DEPARTMENT_DESCRIPTION= c_rec.DEPARTMENT_DESCRIPTION,
2945: END IF; -- refresh mode
2946:
2947: IF ((MSC_CL_COLLECTION.v_is_complete_refresh) OR (lv_res_partial_refresh)) OR
2948: (SQL%NOTFOUND) THEN
2949: INSERT INTO MSC_DEPARTMENT_RESOURCES
2950: ( PLAN_ID,
2951: RESOURCE_CODE,
2952: DEPARTMENT_CODE,
2953: DEPARTMENT_DESCRIPTION,
3093:
3094: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3095: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3096: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3097: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3099:
3100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3101: RAISE;
3105:
3106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3107: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3108: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3109: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPARTMENT_RESOURCES');
3110: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3111:
3112: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3113: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');