DBA Data[Home] [Help]

APPS.BIS_MV_REFRESH dependencies on DBMS_MVIEW

Line 380: DBMS_MVIEW.REFRESH(

376: -- Debug for performance check; remove after testing
377: -- temp_start_refresh := sysdate;
378: -- select value into l_star_transformation from v$parameter where name = 'star_transformation_enabled';
379: -- BIS_COLLECTION_UTILITIES.put_line('TESTING :: Value of star_transformation_enabled in V$parameter = '|| l_star_transformation);
380: DBMS_MVIEW.REFRESH(
381: list => mvname,
382: method => method,
383: parallelism => 0,
384: atomic_refresh => l_atomic_refresh);

Line 726: l_stmt:=' begin dbms_mview.purge_mview_from_log(:1); end;';

722: procedure purge_log (p_mview_id in number) is
723: l_stmt varchar2(1000);
724: l_prefix varchar2(30):=' ';
725: begin
726: l_stmt:=' begin dbms_mview.purge_mview_from_log(:1); end;';
727: -- logmsg(l_prefix||'Begin time '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
728: execute immediate l_stmt using p_mview_id;
729: -- logmsg(l_prefix||'End time '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
730: EXCEPTION WHEN OTHERS THEN

Line 1304: DBMS_MVIEW.REFRESH(

1300: BEGIN
1301: errbuf := NULL;
1302: retcode := '0';
1303:
1304: DBMS_MVIEW.REFRESH(
1305: list => p_mvname,
1306: method => P_REFRESHMODE);
1307:
1308: EXCEPTION