40: CLOSE mv_exist;
41:
42: if (l_mv_exist = 1) then
43: -- msc_util.msc_log('Refreshing ' || l_mv_name);
44: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_PRE');
45: fnd_message.set_token('VIEW_NAME',l_mv_name);
46: msc_util.msc_log(fnd_message.get);
47: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
48: else
41:
42: if (l_mv_exist = 1) then
43: -- msc_util.msc_log('Refreshing ' || l_mv_name);
44: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_PRE');
45: fnd_message.set_token('VIEW_NAME',l_mv_name);
46: msc_util.msc_log(fnd_message.get);
47: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
48: else
49: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
42: if (l_mv_exist = 1) then
43: -- msc_util.msc_log('Refreshing ' || l_mv_name);
44: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_PRE');
45: fnd_message.set_token('VIEW_NAME',l_mv_name);
46: msc_util.msc_log(fnd_message.get);
47: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
48: else
49: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
50: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
46: msc_util.msc_log(fnd_message.get);
47: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
48: else
49: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
50: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
51: fnd_message.set_token('VIEW_NAME',l_mv_name);
52: fnd_message.set_token('SCHEMA_NAME',l_schema_name);
53: msc_util.msc_log(fnd_message.get);
54: RETCODE:= G_ERROR;
47: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
48: else
49: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
50: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
51: fnd_message.set_token('VIEW_NAME',l_mv_name);
52: fnd_message.set_token('SCHEMA_NAME',l_schema_name);
53: msc_util.msc_log(fnd_message.get);
54: RETCODE:= G_ERROR;
55: end if;
48: else
49: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
50: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
51: fnd_message.set_token('VIEW_NAME',l_mv_name);
52: fnd_message.set_token('SCHEMA_NAME',l_schema_name);
53: msc_util.msc_log(fnd_message.get);
54: RETCODE:= G_ERROR;
55: end if;
56:
49: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
50: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
51: fnd_message.set_token('VIEW_NAME',l_mv_name);
52: fnd_message.set_token('SCHEMA_NAME',l_schema_name);
53: msc_util.msc_log(fnd_message.get);
54: RETCODE:= G_ERROR;
55: end if;
56:
57: msc_util.msc_log('End REFRESH_MAT_VIEWS');