[Home] [Help]
APPS.MSD_WS_DEM_RENAME_FORECAST dependencies on DBMS_MVIEW
Line 341: dbms_mview.refresh(upper(mviewname), 'C');
337: x_small_sql := 'alter session set current_schema = APPS';
338: EXECUTE IMMEDIATE x_small_sql;
339:
340: /*Refresh the mview */
341: dbms_mview.refresh(upper(mviewname), 'C');
342:
343: /* Alter session to demantra schema */
344: x_small_sql := 'alter session set current_schema = ' || x_schema;
345: EXECUTE IMMEDIATE x_small_sql;