APPS.ISC_DBI_MSC_OBJECTS_C dependencies on ISC_DBI_PLAN_SCHEDULES

Line 306: 'FROM isc_dbi_plan_schedules isc, msc_plans' || g_db_link || ' plan ' ||

302: 'UNION ALL '||
303: 'SELECT plan.plan_id, isc.plan_name, plan.data_start_date, '||
304: '(CASE WHEN isc.last_collected_date < plan.data_start_date THEN 2
305: WHEN isc.last_collected_date is null THEN 2 ELSE 4 END) PLAN_USAGE '||
306: 'FROM isc_dbi_plan_schedules isc, msc_plans' || g_db_link || ' plan ' ||
307: 'WHERE isc.next_collection_date <= trunc(sysdate)'||
308: 'AND isc.plan_name = plan.compile_designator) setup '||
309: 'WHERE p.compile_designator(+) = setup.plan_name '||
310: -- 'AND p.complete_flag(+) = ''Y'' '||

Line 1327: UPDATE isc_dbi_plan_schedules

1323: -- --------------------------------------------
1324: -- Clean Up the Last Collected Date
1325: -- --------------------------------------------
1326:
1327: UPDATE isc_dbi_plan_schedules
1328: SET last_collected_date = NULL;
1329:
1330: BIS_COLLECTION_UTILITIES.Put_Line('Cleaned up the last collected date.');
1331:

Line 2147: FROM isc_dbi_tmp_plans tmp, isc_dbi_plan_schedules s

2143: WHERE bitand(plan_usage, 2) = 2;
2144: */
2145: CURSOR Plan_List IS
2146: SELECT tmp.plan_name
2147: FROM isc_dbi_tmp_plans tmp, isc_dbi_plan_schedules s
2148: WHERE (bitand(tmp.plan_usage, 2) = 2 or bitand(tmp.plan_usage, 4) = 4)
2149: AND tmp.plan_name = s.plan_name
2150: AND s.frequency <> 'ONCE';
2151:

Line 2162: DELETE from isc_dbi_plan_schedules

2158: BIS_COLLECTION_UTILITIES.Put_Line(' ');
2159: BIS_COLLECTION_UTILITIES.put_line('Begin to update the collection information.');
2160: FII_UTIL.Start_Timer;
2161:
2162: DELETE from isc_dbi_plan_schedules
2163: WHERE frequency = 'ONCE'
2164: AND next_collection_date <= g_snapshot_date
2165: AND plan_name IN (select plan_name from isc_dbi_tmp_plans tmp
2166: WHERE (bitand(tmp.plan_usage, 2) = 2 or bitand(tmp.plan_usage, 4) = 4));

Line 2168: UPDATE isc_dbi_plan_schedules

2164: AND next_collection_date <= g_snapshot_date
2165: AND plan_name IN (select plan_name from isc_dbi_tmp_plans tmp
2166: WHERE (bitand(tmp.plan_usage, 2) = 2 or bitand(tmp.plan_usage, 4) = 4));
2167:
2168: UPDATE isc_dbi_plan_schedules
2169: SET last_collected_date = g_snapshot_date
2170: WHERE plan_name IN (select plan_name from isc_dbi_tmp_plans tmp
2171: WHERE (bitand(tmp.plan_usage, 2) = 2 or bitand(tmp.plan_usage, 4) = 4));
2172:

Line 2183: UPDATE isc_dbi_plan_schedules

2179: WHILE Plan_List%FOUND LOOP
2180: BEGIN
2181: BIS_COLLECTION_UTILITIES.Put_Line('Populating the next collection date for plan '|| l_plan_name);
2182: l_date := ISC_DBI_PLAN_SETUP_UTIL_PKG.get_next_collection_date(l_plan_name);
2183: UPDATE isc_dbi_plan_schedules
2184: SET next_collection_date = l_date
2185: WHERE plan_name = l_plan_name;
2186: EXCEPTION
2187: WHEN no_data_found THEN

Line 2197: -- UPDATE isc_dbi_plan_schedules

2193:
2194: l_total := Plan_List%ROWCOUNT;
2195: CLOSE Plan_List;
2196:
2197: -- UPDATE isc_dbi_plan_schedules
2198: -- SET next_collection_date = ISC_DBI_PLAN_SETUP_UTIL_PKG.get_next_collection_date(plan_name)
2199: -- WHERE plan_name IN (select plan_name from isc_dbi_tmp_plans tmp WHERE bitand(tmp.plan_usage, 2) = 2);
2200:
2201: FII_UTIL.Stop_Timer;