APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_DEPT_RES_INSTANCES

Line 2737: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPT_RES_INSTANCES', MSC_CL_COLLECTION.v_instance_id, -1);

2733: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2734:
2735: IF (((lv_bom = MSC_UTIL.SYS_YES) OR (lv_wip = MSC_UTIL.SYS_YES)) AND NOT MSC_CL_COLLECTION.v_is_legacy_refresh) THEN
2736: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2737: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPT_RES_INSTANCES', MSC_CL_COLLECTION.v_instance_id, -1);
2738: ELSE
2739: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2740: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPT_RES_INSTANCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str); /* ds change change */
2741: END IF;

Line 2740: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPT_RES_INSTANCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str); /* ds change change */

2736: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2737: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPT_RES_INSTANCES', MSC_CL_COLLECTION.v_instance_id, -1);
2738: ELSE
2739: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2740: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPT_RES_INSTANCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str); /* ds change change */
2741: END IF;
2742: END IF;
2743: /* ds change change end */
2744:

Line 3147: INSERT INTO MSC_DEPT_RES_INSTANCES

3143: so in increment its alwasy full refresh */
3144: BEGIN
3145: -- IF ((MSC_CL_COLLECTION.v_is_complete_refresh) OR (lv_res_partial_refresh)) THEN
3146:
3147: INSERT INTO MSC_DEPT_RES_INSTANCES
3148: ( PLAN_ID,
3149: DEPT_RESOURCE_INST_ID ,
3150: RESOURCE_ID,
3151: RES_INSTANCE_ID,

Line 3167: MSC_DEPT_RES_INSTANCES_S.NEXTVAL,

3163: CREATION_DATE,
3164: CREATED_BY)
3165: VALUES
3166: ( -1,
3167: MSC_DEPT_RES_INSTANCES_S.NEXTVAL,
3168: c_rec.RESOURCE_ID,
3169: c_rec.RES_INSTANCE_ID,
3170: c_rec.DEPARTMENT_ID,
3171: c_rec.ORGANIZATION_ID,

Line 3200: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');

3196:
3197: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3198: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3199: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3200: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3202:
3203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3204: RAISE;

Line 3212: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');

3208:
3209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3210: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3211: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE');
3212: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEPT_RES_INSTANCES');
3213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3214:
3215: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3216: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_ID');