DBA Data[Home] [Help]

APPS.AD_MV dependencies on AD_ZD_MVIEW

Line 174: ad_zd_mview.INSTALL_MVQ_ARCH(ga_c_stmt);

170: BEGIN
171: -- Install MV and MVQ
172: IF (ab_long_stmt_i)
173: THEN
174: ad_zd_mview.INSTALL_MVQ_ARCH(ga_c_stmt);
175: ELSE
176: ad_zd_mview.INSTALL_MVQ_ARCH(as_stmt_i);
177: END IF;
178:

Line 176: ad_zd_mview.INSTALL_MVQ_ARCH(as_stmt_i);

172: IF (ab_long_stmt_i)
173: THEN
174: ad_zd_mview.INSTALL_MVQ_ARCH(ga_c_stmt);
175: ELSE
176: ad_zd_mview.INSTALL_MVQ_ARCH(as_stmt_i);
177: END IF;
178:
179: ga_c_stmt := '';
180: EXCEPTION

Line 282: ad_zd_mview.drop_mvq(p_mvname=>as_mview_name_i);

278: exception when e_mv_nofound
279: then
280: if g_edition_enabled = 'Y'
281: then
282: ad_zd_mview.drop_mvq(p_mvname=>as_mview_name_i);
283: end if;
284: raise;
285: end;
286:

Line 289: ad_zd_mview.drop_mvq(p_mvname=>as_mview_name_i);

285: end;
286:
287: if g_edition_enabled = 'Y'
288: then
289: ad_zd_mview.drop_mvq(p_mvname=>as_mview_name_i);
290: end if;
291: END drop_mv;
292:
293: --

Line 344: ad_zd_mview.drop_mvq(p_mvname=>as_mview_name_i);

340: exception when e_mv_nofound
341: then
342: if g_edition_enabled = 'Y'
343: then
344: ad_zd_mview.drop_mvq(p_mvname=>as_mview_name_i);
345: end if;
346: raise;
347: end;
348: if g_edition_enabled = 'Y'

Line 350: ad_zd_mview.drop_mvq(p_mvname=>as_mview_name_i);

346: raise;
347: end;
348: if g_edition_enabled = 'Y'
349: then
350: ad_zd_mview.drop_mvq(p_mvname=>as_mview_name_i);
351: end if;
352: end;
353: ELSIF (an_operation_i = ad_mv.mv_alter)
354: THEN