53: CLOSE mv_exist;
54:
55: if (l_mv_exist = 1) then
56: -- msc_util.msc_log('Refreshing ' || l_mv_name);
57: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_PRE');
58: fnd_message.set_token('VIEW_NAME',l_mv_name);
59: msc_util.msc_log(fnd_message.get);
60: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
61: else
54:
55: if (l_mv_exist = 1) then
56: -- msc_util.msc_log('Refreshing ' || l_mv_name);
57: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_PRE');
58: fnd_message.set_token('VIEW_NAME',l_mv_name);
59: msc_util.msc_log(fnd_message.get);
60: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
61: else
62: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
55: if (l_mv_exist = 1) then
56: -- msc_util.msc_log('Refreshing ' || l_mv_name);
57: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_PRE');
58: fnd_message.set_token('VIEW_NAME',l_mv_name);
59: msc_util.msc_log(fnd_message.get);
60: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
61: else
62: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
63: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
59: msc_util.msc_log(fnd_message.get);
60: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
61: else
62: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
63: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
64: fnd_message.set_token('VIEW_NAME',l_mv_name);
65: fnd_message.set_token('SCHEMA_NAME',l_schema_name);
66: msc_util.msc_log(fnd_message.get);
67: RETCODE:= G_ERROR;
60: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
61: else
62: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
63: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
64: fnd_message.set_token('VIEW_NAME',l_mv_name);
65: fnd_message.set_token('SCHEMA_NAME',l_schema_name);
66: msc_util.msc_log(fnd_message.get);
67: RETCODE:= G_ERROR;
68: end if;
61: else
62: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
63: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
64: fnd_message.set_token('VIEW_NAME',l_mv_name);
65: fnd_message.set_token('SCHEMA_NAME',l_schema_name);
66: msc_util.msc_log(fnd_message.get);
67: RETCODE:= G_ERROR;
68: end if;
69:
62: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
63: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
64: fnd_message.set_token('VIEW_NAME',l_mv_name);
65: fnd_message.set_token('SCHEMA_NAME',l_schema_name);
66: msc_util.msc_log(fnd_message.get);
67: RETCODE:= G_ERROR;
68: end if;
69:
70: msc_util.msc_log('End REFRESH_MAT_VIEWS');