APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_SIMULATION_SETS

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

2730: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_GROUPS', MSC_CL_COLLECTION.v_instance_id, NULL); /*No Organization_id Column */
2731:
2732: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2733: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPARTMENT_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
2734: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SIMULATION_SETS', MSC_CL_COLLECTION.v_instance_id,NULL);
2735: ELSE
2736: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2737: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPARTMENT_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2738: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SIMULATION_SETS', MSC_CL_COLLECTION.v_instance_id,NULL,v_sub_str);

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

2734: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SIMULATION_SETS', MSC_CL_COLLECTION.v_instance_id,NULL);
2735: ELSE
2736: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2737: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPARTMENT_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2738: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SIMULATION_SETS', MSC_CL_COLLECTION.v_instance_id,NULL,v_sub_str);
2739: END IF;
2740:
2741: ELSE
2742:

Line 3235: UPDATE MSC_SIMULATION_SETS

3231: BEGIN
3232:
3233: IF (lv_res_incr_refresh) THEN
3234:
3235: UPDATE MSC_SIMULATION_SETS
3236: SET
3237: DESCRIPTION= c_rec.DESCRIPTION,
3238: USE_IN_WIP_FLAG= c_rec.USE_IN_WIP_FLAG,
3239: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

Line 3250: INSERT INTO MSC_SIMULATION_SETS

3246: END IF;
3247:
3248: IF ((MSC_CL_COLLECTION.v_is_complete_refresh) OR (lv_res_partial_refresh)) OR SQL%NOTFOUND THEN
3249:
3250: INSERT INTO MSC_SIMULATION_SETS
3251: ( ORGANIZATION_ID,
3252: SIMULATION_SET,
3253: DESCRIPTION,
3254: USE_IN_WIP_FLAG,

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

3286:
3287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3288: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3289: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3290: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3292:
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3294: RAISE;

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

3298:
3299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3300: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3301: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3302: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SIMULATION_SETS');
3303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3304:
3305: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3306: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');