DBA Data[Home] [Help]

APPS.LNS_UTILITY_PUB dependencies on DBMS_MVIEW

Line 1015: 'Begin dbms_mview.refresh call to refresh data in '|| l_entity_name);

1011:
1012: if (l_mv_name is not null) then
1013:
1014: fnd_file.put_line(FND_FILE.LOG,
1015: 'Begin dbms_mview.refresh call to refresh data in '|| l_entity_name);
1016: dbms_mview.refresh(l_entity_name, 'C', '', TRUE, FALSE, 0,0,0, TRUE);
1017:
1018: fnd_file.put_line(FND_FILE.LOG,
1019: 'Completed dbms_mview.refresh call to refresh data in '|| l_entity_name);

Line 1016: dbms_mview.refresh(l_entity_name, 'C', '', TRUE, FALSE, 0,0,0, TRUE);

1012: if (l_mv_name is not null) then
1013:
1014: fnd_file.put_line(FND_FILE.LOG,
1015: 'Begin dbms_mview.refresh call to refresh data in '|| l_entity_name);
1016: dbms_mview.refresh(l_entity_name, 'C', '', TRUE, FALSE, 0,0,0, TRUE);
1017:
1018: fnd_file.put_line(FND_FILE.LOG,
1019: 'Completed dbms_mview.refresh call to refresh data in '|| l_entity_name);
1020:

Line 1019: 'Completed dbms_mview.refresh call to refresh data in '|| l_entity_name);

1015: 'Begin dbms_mview.refresh call to refresh data in '|| l_entity_name);
1016: dbms_mview.refresh(l_entity_name, 'C', '', TRUE, FALSE, 0,0,0, TRUE);
1017:
1018: fnd_file.put_line(FND_FILE.LOG,
1019: 'Completed dbms_mview.refresh call to refresh data in '|| l_entity_name);
1020:
1021: --This statement added as workaround for bug#2695199/2639679
1022: --MATERIALIZED VIEWS BECOME INVALID AFTER ALTER OR REFRESH
1023: if (l_compile_state <> 'VALID') then