2964: if eval(lv_existance_check) then
2965:
2966: lv_sql_stmt := 'DROP SNAPSHOT '||MSC_UTIL.G_APPS_SCHEMA||'.'||lv_snapshot_name;
2967:
2968: ad_mv.do_mv_ddl(
2969: an_operation_i => ad_mv.mv_drop,
2970: as_mview_name_i => lv_snapshot_name,
2971: as_stmt_i => lv_sql_stmt,
2972: ab_execute_i => TRUE
2965:
2966: lv_sql_stmt := 'DROP SNAPSHOT '||MSC_UTIL.G_APPS_SCHEMA||'.'||lv_snapshot_name;
2967:
2968: ad_mv.do_mv_ddl(
2969: an_operation_i => ad_mv.mv_drop,
2970: as_mview_name_i => lv_snapshot_name,
2971: as_stmt_i => lv_sql_stmt,
2972: ab_execute_i => TRUE
2973: );