APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_RESOURCE_GROUPS

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

2745:
2746: IF ((MSC_CL_COLLECTION.v_is_complete_refresh) OR (lv_res_partial_refresh)) THEN
2747:
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);

Line 3353: INSERT INTO MSC_RESOURCE_GROUPS

3349: FOR c_rec IN c4 LOOP
3350:
3351: BEGIN
3352:
3353: INSERT INTO MSC_RESOURCE_GROUPS
3354: ( GROUP_CODE,
3355: MEANING,
3356: DESCRIPTION,
3357: FROM_DATE,

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

3390:
3391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3392: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3393: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3394: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3396:
3397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3398: RAISE;

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

3402:
3403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3404: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3405: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3406: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_GROUPS');
3407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3408:
3409: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3410: FND_MESSAGE.SET_TOKEN('COLUMN', 'GROUP_CODE');