APPS.ISC_DBI_MSC_OBJECTS_C dependencies on ISC_DBI_PLANS

Line 21: g_small_bases TableList := TableList('ISC_DBI_PLAN_ORGANIZATIONS', 'ISC_DBI_PLAN_BUCKETS', 'ISC_DBI_PLANS');

17: g_sec_global_rate_type VARCHAR2(15);
18: g_rebuild_snapshot_index VARCHAR2(1) := 'N';
19:
20: TYPE TableList IS TABLE OF VARCHAR2(80);
21: g_small_bases TableList := TableList('ISC_DBI_PLAN_ORGANIZATIONS', 'ISC_DBI_PLAN_BUCKETS', 'ISC_DBI_PLANS');
22: g_large_bases TableList := TableList('ISC_DBI_SUPPLIES_F','ISC_DBI_INV_DETAIL_F','ISC_DBI_RES_SUMMARY_F',
23: 'ISC_DBI_EXCEPTION_DETAILS_F','ISC_DBI_DEMANDS_F',
24: 'ISC_DBI_FULL_PEGGING_F');
25:

Line 294: 'FROM isc_dbi_plans p, isc_dbi_apps_instances inst, '||

290: 'PLAN_ID, PLAN_NAME, OLD_DATA_START_DATE, DATA_START_DATE, ' ||
291: 'INSTANCE_ID, PLAN_USAGE) ' ||
292: 'SELECT setup.plan_id, setup.plan_name, p.data_start_date, setup.data_start_date, inst.instance_id, '||
293: 'sum(plan_usage) '||
294: 'FROM isc_dbi_plans p, isc_dbi_apps_instances inst, '||
295: '(SELECT plan.plan_id, opi.plan_name, plan.data_start_date,1 PLAN_USAGE '||
296: 'FROM opi_dbi_baseline_schedules sched, opi_dbi_baseline_plans opi, '||
297: 'msc_plans' || g_db_link || ' plan '||
298: 'WHERE sched.baseline_id = opi.baseline_id '||

Line 424: 'INTO isc_dbi_plans ( ' ||

420: FII_UTIL.Start_Timer;
421:
422: l_insert_stmt := 'INSERT /*+ APPEND PARALLEL */ FIRST '||
423: 'WHEN union_flag = 1 THEN '||
424: 'INTO isc_dbi_plans ( ' ||
425: 'PLAN_ID,ORGANIZATION_ID,COMPILE_DESIGNATOR,CONSTRAINED_FLAG,CURR_CUTOFF_DATE,'||
426: 'CURR_PLAN_TYPE,CURR_START_DATE,CUTOFF_DATE,DATA_START_DATE,DESCRIPTION,COMPLETE_FLAG,'||
427: 'CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) '||
428: 'VALUES(plan_id,organization_id,compile_designator,constrained_flag, curr_cutoff_date,'||

Line 927: UPDATE isc_dbi_tmp_plans tmp SET constrained_flag = (select constrained_flag from isc_dbi_plans p where p.plan_id = tmp.plan_id);

923: FII_UTIL.Stop_Timer;
924: FII_UTIL.Print_Timer('Loaded the base tables in');
925: BIS_COLLECTION_UTILITIES.Put_Line(' ');
926:
927: UPDATE isc_dbi_tmp_plans tmp SET constrained_flag = (select constrained_flag from isc_dbi_plans p where p.plan_id = tmp.plan_id);
928: COMMIT;
929:
930: FII_UTIL.Start_Timer;
931:

Line 1012: FROM isc_dbi_plans p, isc_dbi_tmp_plans tmp

1008: FII_UTIL.Start_Timer;
1009:
1010: SELECT min(p.data_start_date),max(p.cutoff_date)
1011: INTO l_min, l_max
1012: FROM isc_dbi_plans p, isc_dbi_tmp_plans tmp
1013: WHERE p.plan_id = tmp.plan_id;
1014:
1015: FII_UTIL.Stop_Timer;
1016: FII_UTIL.Print_Timer('Retrieved the min and max date in ');

Line 1272: UPDATE isc_dbi_plans SET complete_flag = 'Y'

1268: IF (l_dangling = -999) THEN
1269: return(-1);
1270: END IF;
1271:
1272: UPDATE isc_dbi_plans SET complete_flag = 'Y'
1273: WHERE plan_id IN (select plan_id from isc_dbi_tmp_plans tmp);
1274: COMMIT;
1275:
1276: RETURN(1);

Line 1355: -- SELECT count(*) FROM isc_dbi_plans WHERE complete_flag = 'N';

1351: RAISE l_failure;
1352: END IF;
1353: END IF;
1354:
1355: -- SELECT count(*) FROM isc_dbi_plans WHERE complete_flag = 'N';
1356:
1357: IF (DANGLING_CHECK = -1) THEN
1358: RAISE l_failure;
1359: END IF;

Line 1419: -- SELECT count(*) FROM isc_dbi_plans WHERE complete_flag = 'N';

1415: RAISE l_failure;
1416: END IF;
1417: END IF;
1418:
1419: -- SELECT count(*) FROM isc_dbi_plans WHERE complete_flag = 'N';
1420:
1421: IF (DANGLING_CHECK = -1) THEN
1422: RAISE l_failure;
1423: END IF;

Line 1590: isc_dbi_plans ip,

1586: SELECT tmp.snapshot_id, ip.plan_id, ip.organization_id, ip.compile_designator, ip.constrained_flag,
1587: ip.curr_plan_type, ip.cutoff_date, ip.data_start_date,
1588: ip.description, count(*), g_snapshot_date
1589: FROM isc_dbi_tmp_plans tmp,
1590: isc_dbi_plans ip,
1591: isc_dbi_plan_organizations ipo
1592: WHERE tmp.plan_id = ip.plan_id
1593: AND bitand(tmp.plan_usage, 2) = 2
1594: AND ip.plan_id = ipo.plan_id