APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_PROJECT_TASKS

Line 2435: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1);

2431: COMMIT;
2432:
2433: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2434:
2435: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1);
2436:
2437: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2438: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1);
2439: ELSE

Line 2438: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1);

2434:
2435: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1);
2436:
2437: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2438: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1);
2439: ELSE
2440: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2441: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
2442: END IF;

Line 2441: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);

2437: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2438: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1);
2439: ELSE
2440: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2441: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROJECT_TASKS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
2442: END IF;
2443:
2444: END IF;
2445:

Line 2454: UPDATE MSC_PROJECT_TASKS

2450: BEGIN
2451:
2452: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2453:
2454: UPDATE MSC_PROJECT_TASKS
2455: SET
2456: TASK_NUMBER= c_rec.TASK_NUMBER,
2457: TASK_NAME= c_rec.TASK_NAME,
2458: DESCRIPTION= c_rec.DESCRIPTION,

Line 2476: INSERT INTO MSC_PROJECT_TASKS

2472: END IF;
2473:
2474: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
2475:
2476: INSERT INTO MSC_PROJECT_TASKS
2477: ( PLAN_ID,
2478: PROJECT_ID,
2479: TASK_ID,
2480: ORGANIZATION_ID,

Line 2531: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');

2527:
2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2529: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2530: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2531: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2533:
2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2535: RAISE;

Line 2544: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');

2540:
2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2542: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2543: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2544: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2546:
2547: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2548: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');