APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_SIMULATION_SETS

Line 2753: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SIMULATION_SETS', MSC_CL_COLLECTION.v_instance_id,NULL);

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);
2757: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SIMULATION_SETS', MSC_CL_COLLECTION.v_instance_id,NULL,v_sub_str);

Line 2757: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SIMULATION_SETS', MSC_CL_COLLECTION.v_instance_id,NULL,v_sub_str);

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
2761:

Line 3254: UPDATE MSC_SIMULATION_SETS

3250: BEGIN
3251:
3252: IF (lv_res_incr_refresh) THEN
3253:
3254: UPDATE MSC_SIMULATION_SETS
3255: SET
3256: DESCRIPTION= c_rec.DESCRIPTION,
3257: USE_IN_WIP_FLAG= c_rec.USE_IN_WIP_FLAG,
3258: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

Line 3269: INSERT INTO MSC_SIMULATION_SETS

3265: END IF;
3266:
3267: IF ((MSC_CL_COLLECTION.v_is_complete_refresh) OR (lv_res_partial_refresh)) OR SQL%NOTFOUND THEN
3268:
3269: INSERT INTO MSC_SIMULATION_SETS
3270: ( ORGANIZATION_ID,
3271: SIMULATION_SET,
3272: DESCRIPTION,
3273: USE_IN_WIP_FLAG,

Line 3309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');

3305:
3306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3307: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3308: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3309: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3311:
3312: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3313: RAISE;

Line 3321: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');

3317:
3318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3319: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3320: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3321: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3322: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3323:
3324: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3325: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');