DBA Data[Home] [Help]

APPS.LNS_UTILITY_PUB dependencies on DBMS_MVIEW

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

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

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

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

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

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