APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_RESOURCE_SETUPS

Line 47: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_SETUPS', MSC_CL_COLLECTION.v_instance_id, -1);

43: BEGIN
44:
45: IF ((MSC_CL_COLLECTION.v_is_complete_refresh) OR (MSC_CL_COLLECTION.v_is_partial_refresh) OR (MSC_CL_COLLECTION.v_is_legacy_refresh)) THEN
46: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
47: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_SETUPS', MSC_CL_COLLECTION.v_instance_id, -1);
48: ELSE
49: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
50: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_RESOURCE_SETUPS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
51: END IF;

Line 50: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_RESOURCE_SETUPS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

46: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
47: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_SETUPS', MSC_CL_COLLECTION.v_instance_id, -1);
48: ELSE
49: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
50: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_RESOURCE_SETUPS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
51: END IF;
52:
53:
54: c_count := 0;

Line 58: INSERT INTO MSC_RESOURCE_SETUPS

54: c_count := 0;
55:
56: FOR c_rec IN res_setups LOOP
57: BEGIN
58: INSERT INTO MSC_RESOURCE_SETUPS
59: ( PLAN_ID,
60: RESOURCE_ID,
61: ORGANIZATION_ID ,
62: --DEPARTMENT_ID ,

Line 108: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');

104:
105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
106: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
107: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
108: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
110:
111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
112: RAISE;

Line 120: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');

116:
117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
118: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
119: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RESOURCE_SETUP');
120: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_SETUPS');
121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
122:
123: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
124: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');