DBA Data[Home] [Help]

APPS.ISC_DBI_MSC_OBJECTS_C dependencies on ISC_DBI_PLAN_SETUP_UTIL_PKG

Line 2182: l_date := ISC_DBI_PLAN_SETUP_UTIL_PKG.get_next_collection_date(l_plan_name);

2178: IF Plan_List%ROWCOUNT <> 0 THEN
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

Line 2198: -- SET next_collection_date = ISC_DBI_PLAN_SETUP_UTIL_PKG.get_next_collection_date(plan_name)

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;
2202: FII_UTIL.Print_Timer('Updated the setup tables in');