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.4 2006/06/01 19:18:16 vlim noship $*/
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.4 2006/06/01 19:18:16 vlim noship $*/
3:
4: gs_package_name_c CONSTANT VARCHAR2(30) := 'ad_mv';
5:
6: gn_timeout_c CONSTANT INTEGER := dbms_lock.maxwait;
7: gs_lockhandle_name_c CONSTANT VARCHAR2(12) := 'AD_MV_CREATE';
8:

Line 7: gs_lockhandle_name_c CONSTANT VARCHAR2(12) := 'AD_MV_CREATE';

3:
4: gs_package_name_c CONSTANT VARCHAR2(30) := 'ad_mv';
5:
6: gn_timeout_c CONSTANT INTEGER := dbms_lock.maxwait;
7: gs_lockhandle_name_c CONSTANT VARCHAR2(12) := 'AD_MV_CREATE';
8:
9: ga_stmt dbms_sql.varchar2s;
10:
11: check_tspace_exist varchar2(100);

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

266: l_chunk VARCHAR2(256);
267: l_index INTEGER := 1;
268: l_pointer INTEGER;
269: BEGIN
270: IF (an_operation_i NOT IN (ad_mv.mv_create, ad_mv.mv_alter, ad_mv.mv_drop))
271: THEN
272: RAISE_APPLICATION_ERROR(-20003, 'do_mv_ddl: unsupported operation');
273: END IF;
274: IF (ab_execute_i IS NOT NULL)

Line 287: IF (an_operation_i = ad_mv.mv_create)

283: END LOOP;
284: END IF;
285: IF (ab_execute_i IS NULL OR ab_execute_i)
286: THEN
287: IF (an_operation_i = ad_mv.mv_create)
288: THEN
289: create_mv(as_mview_name_i, as_stmt_i, ab_execute_i);
290: ELSIF (an_operation_i IN (ad_mv.mv_alter, ad_mv.mv_drop))
291: THEN

Line 290: ELSIF (an_operation_i IN (ad_mv.mv_alter, ad_mv.mv_drop))

286: THEN
287: IF (an_operation_i = ad_mv.mv_create)
288: THEN
289: create_mv(as_mview_name_i, as_stmt_i, ab_execute_i);
290: ELSIF (an_operation_i IN (ad_mv.mv_alter, ad_mv.mv_drop))
291: THEN
292: mv_ddl(as_mview_name_i, as_stmt_i, ab_execute_i);
293: END IF;
294: END IF;

Line 333: END ad_mv;

329: EXECUTE IMMEDIATE 'ALTER SESSION SET "_mv_refresh_selections"=TRUE';
330: END IF;
331: ad_tspace_util.get_tablespace_name('BIS','SUMMARY','Y',check_tspace_exist,g_mv_data_tablespace);
332: g_mv_index_tablespace := g_mv_data_tablespace;
333: END ad_mv;