APPS.MTH_UTIL_PKG dependencies on DBMS_MVIEW

Line 1192: * Description :This procedure is used to call DBMS_MVIEW.REFRESH *

1188: END;
1189:
1190: /* ****************************************************************************
1191: * Procedure :REFRESH_MV *
1192: * Description :This procedure is used to call DBMS_MVIEW.REFRESH *
1193: * procedure to refresh MVs. *
1194: * File Name :MTHUTILB.PLS *
1195: * Visibility :Public *
1196: * Parameters *

Line 1231: DBMS_MVIEW.REFRESH(p_list, p_method, p_rollback_seg, p_push_deferred_rpc,

1227: p_atomic_refresh IN BOOLEAN := true
1228: )
1229: IS
1230: BEGIN
1231: DBMS_MVIEW.REFRESH(p_list, p_method, p_rollback_seg, p_push_deferred_rpc,
1232: p_refresh_after_errors, p_purge_option,
1233: p_parallelism, p_heap_size, p_atomic_refresh);
1234: END REFRESH_MV;
1235:

Line 1238: * Description :This procedure is used to call DBMS_MVIEW.REFRESH *

1234: END REFRESH_MV;
1235:
1236: /* ****************************************************************************
1237: * Procedure :REFRESH_MV_ONE_ALL *
1238: * Description :This procedure is used to call DBMS_MVIEW.REFRESH *
1239: * procedure to refresh MVs. *
1240: * File Name :MTHUTILB.PLS *
1241: * Visibility :Public *
1242: * Parameters *

Line 1272: DBMS_MVIEW.REFRESH(p_list, p_method, p_rollback_seg, p_push_deferred_rpc,

1268:
1269: IF(p_mview_name = 'ALL')
1270: THEN
1271:
1272: DBMS_MVIEW.REFRESH(p_list, p_method, p_rollback_seg, p_push_deferred_rpc,
1273: p_refresh_after_errors, p_purge_option,
1274: p_parallelism, p_heap_size, p_atomic_refresh);
1275:
1276: ELSE

Line 1277: DBMS_MVIEW.REFRESH(p_mview_name,p_method);

1273: p_refresh_after_errors, p_purge_option,
1274: p_parallelism, p_heap_size, p_atomic_refresh);
1275:
1276: ELSE
1277: DBMS_MVIEW.REFRESH(p_mview_name,p_method);
1278: END IF;
1279: END REFRESH_MV_ONE_ALL;
1280:
1281:

Line 1363: DBMS_MVIEW.REFRESH(v_mv_name, p_method, p_rollback_seg);

1359: END IF;
1360: END IF;
1361:
1362: IF v_bneed_refresh THEN
1363: DBMS_MVIEW.REFRESH(v_mv_name, p_method, p_rollback_seg);
1364: END IF;
1365: END REFRESH_ONE_MV;
1366:
1367: /* *****************************************************************************

Line 3017: DBMS_MVIEW.REFRESH('MTH_SHIFT_REFERENCE_MV','C');

3013: BEGIN
3014:
3015:
3016:
3017: DBMS_MVIEW.REFRESH('MTH_SHIFT_REFERENCE_MV','C');
3018:
3019: OPEN c_check_compile_state;
3020: FETCH c_check_compile_state INTO l_comp_state;
3021: CLOSE c_check_compile_state;

Line 4749: Dbms_Mview.REFRESH(r_mv.LOOKUP_CODE, 'C', '', FALSE, FALSE, 0, 0, 0, TRUE);

4745: END LOOP;
4746:
4747: FOR r_mv IN c_mvs(v_lookup_type) LOOP
4748:
4749: Dbms_Mview.REFRESH(r_mv.LOOKUP_CODE, 'C', '', FALSE, FALSE, 0, 0, 0, TRUE);
4750:
4751: END LOOP;
4752:
4753: DELETE FROM MTH_RUN_LOG rl