APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_RESOURCE_GROUPS

Line 2730: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_GROUPS', MSC_CL_COLLECTION.v_instance_id, NULL); /*No Organization_id Column */

2726:
2727: IF ((MSC_CL_COLLECTION.v_is_complete_refresh) OR (lv_res_partial_refresh)) THEN
2728:
2729:
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);

Line 3334: INSERT INTO MSC_RESOURCE_GROUPS

3330: FOR c_rec IN c4 LOOP
3331:
3332: BEGIN
3333:
3334: INSERT INTO MSC_RESOURCE_GROUPS
3335: ( GROUP_CODE,
3336: MEANING,
3337: DESCRIPTION,
3338: FROM_DATE,

Line 3375: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');

3371:
3372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3373: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3374: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3375: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3377:
3378: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3379: RAISE;

Line 3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');

3383:
3384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3385: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3387: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3389:
3390: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3391: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');