eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_PROJECTS

Line 2286: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1);

2282: BEGIN
2283:
2284: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2285:
2286: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1);
2287:
2288: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2289: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1);
2290: ELSE

Line 2289: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1);

2285:
2286: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1);
2287:
2288: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2289: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1);
2290: ELSE
2291: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2292: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
2293: END IF;

Line 2292: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);

2288: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2289: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1);
2290: ELSE
2291: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2292: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECTS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
2293: END IF;
2294:
2295: END IF;
2296:

Line 2305: UPDATE MSC_PROJECTS

2301: BEGIN
2302:
2303: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2304:
2305: UPDATE MSC_PROJECTS
2306: SET
2307: PLANNING_GROUP= c_rec.PLANNING_GROUP,
2308: COSTING_GROUP_ID= c_rec.COSTING_GROUP_ID,
2309: MATERIAL_ACCOUNT= c_rec.MATERIAL_ACCOUNT,

Line 2332: INSERT INTO MSC_PROJECTS

2328: END IF;
2329:
2330: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
2331:
2332: INSERT INTO MSC_PROJECTS
2333: ( PLAN_ID,
2334: PROJECT_ID,
2335: ORGANIZATION_ID,
2336: PLANNING_GROUP,

Line 2396: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');

2392:
2393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2394: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2395: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2396: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2398:
2399: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2400: RAISE;

Line 2409: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');

2405:
2406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2407: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2408: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2409: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2411:
2412: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2413: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');