APPS.AD_MV dependencies on AD_MV

Line 1: package body ad_mv as

1: package body ad_mv as
2: /* $Header: admvb.pls 120.14 2011/09/22 19:12:51 mkumandu ship $*/
3:
4: gs_package_name_c CONSTANT VARCHAR2(30) := 'ad_mv';
5:

Line 4: gs_package_name_c CONSTANT VARCHAR2(30) := 'ad_mv';

1: package body ad_mv as
2: /* $Header: admvb.pls 120.14 2011/09/22 19:12:51 mkumandu ship $*/
3:
4: gs_package_name_c CONSTANT VARCHAR2(30) := 'ad_mv';
5:
6: ga_stmt dbms_sql.varchar2s;
7:
8: ga_c_stmt clob;

Line 313: IF (an_operation_i NOT IN (ad_mv.mv_create, ad_mv.mv_alter, ad_mv.mv_drop))

309: IS
310: BEGIN
311:
312: g_edition_enabled := is_edition_enabled;
313: IF (an_operation_i NOT IN (ad_mv.mv_create, ad_mv.mv_alter, ad_mv.mv_drop))
314: THEN
315: RAISE_APPLICATION_ERROR(-20003, 'do_mv_ddl: unsupported operation');
316: END IF;
317:

Line 328: IF (an_operation_i = ad_mv.mv_create)

324: END IF;
325:
326: IF (ab_execute_i IS NULL OR ab_execute_i)
327: THEN
328: IF (an_operation_i = ad_mv.mv_create)
329: THEN
330: create_mv(as_mview_name_i, as_stmt_i, ab_execute_i);
331: ELSIF (an_operation_i = ad_mv.mv_drop)
332: then

Line 331: ELSIF (an_operation_i = ad_mv.mv_drop)

327: THEN
328: IF (an_operation_i = ad_mv.mv_create)
329: THEN
330: create_mv(as_mview_name_i, as_stmt_i, ab_execute_i);
331: ELSIF (an_operation_i = ad_mv.mv_drop)
332: then
333: declare
334: e_mv_nofound exception;
335: PRAGMA EXCEPTION_INIT(e_mv_nofound, -12003);

Line 353: ELSIF (an_operation_i = ad_mv.mv_alter)

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
355: mv_ddl(as_mview_name_i, as_stmt_i, ab_execute_i);
356: END IF;
357: END IF;

Line 396: END ad_mv;

392: EXECUTE IMMEDIATE 'ALTER SESSION SET "_mv_refresh_selections"=TRUE';
393: END IF;
394: ad_tspace_util.get_tablespace_name('BIS','SUMMARY','Y',check_tspace_exist,g_mv_data_tablespace);
395: g_mv_index_tablespace := g_mv_data_tablespace;
396: END ad_mv;