APPS.AMW_PURGE_MVIEW_LOG dependencies on DBMS_MVIEW

Line 51: DBMS_MVIEW.REFRESH(p_mview_name , 'C');

47:
48: BEGIN
49:
50: IF (p_mview_name is not null) THEN
51: DBMS_MVIEW.REFRESH(p_mview_name , 'C');
52: ELSE
53: --OPEN C_mview;
54: --LOOP
55: -- FETCH C_mview INTO p_mview, p_owner;

Line 57: -- DBMS_MVIEW.REFRESH(p_owner||'.'|| p_mview, 'C');

53: --OPEN C_mview;
54: --LOOP
55: -- FETCH C_mview INTO p_mview, p_owner;
56: -- EXIT WHEN C_mview%NOTFOUND;
57: -- DBMS_MVIEW.REFRESH(p_owner||'.'|| p_mview, 'C');
58: -- COMMIT;
59: -- END LOOP;
60:
61: DBMS_MVIEW.REFRESH('AMW_OPINION_LOG_MV', 'C');

Line 61: DBMS_MVIEW.REFRESH('AMW_OPINION_LOG_MV', 'C');

57: -- DBMS_MVIEW.REFRESH(p_owner||'.'|| p_mview, 'C');
58: -- COMMIT;
59: -- END LOOP;
60:
61: DBMS_MVIEW.REFRESH('AMW_OPINION_LOG_MV', 'C');
62: DBMS_MVIEW.REFRESH('AMW_OPINION_MV', 'C');
63:
64: END IF;
65:

Line 62: DBMS_MVIEW.REFRESH('AMW_OPINION_MV', 'C');

58: -- COMMIT;
59: -- END LOOP;
60:
61: DBMS_MVIEW.REFRESH('AMW_OPINION_LOG_MV', 'C');
62: DBMS_MVIEW.REFRESH('AMW_OPINION_MV', 'C');
63:
64: END IF;
65:
66: