DBA Data[Home] [Help]

PACKAGE: APPS.AD_MV

Source


1 PACKAGE ad_mv authid current_user AS
2 /* $Header: admvs.pls 120.2 2011/08/25 20:08:06 mkumandu ship $*/
3 
4    g_mv_data_tablespace            VARCHAR2(100);
5    g_mv_index_tablespace           VARCHAR2(100);
6    g_edition_enabled               VARCHAR2(1);
7 
8    mv_create                       CONSTANT PLS_INTEGER := 1;
9    mv_alter                        CONSTANT PLS_INTEGER := 2;
10    mv_drop                         CONSTANT PLS_INTEGER := 3;
11 
12    PROCEDURE alter_mv (
13      as_mview_name_i               VARCHAR2
14    , as_stmt_i                     VARCHAR2
15    );
16 
17    PROCEDURE create_mv (
18      as_mview_name_i               VARCHAR2
19    , as_stmt_i                     VARCHAR2
20    , ab_long_stmt_i                BOOLEAN DEFAULT FALSE
21    );
22 
23    PROCEDURE create_mv2 (
24      as_mview_name_i               VARCHAR2
25    , as_stmt_i                     VARCHAR2
26    , ab_long_stmt_i                INTEGER DEFAULT 0
27    );
28 
29    PROCEDURE drop_mv (
30      as_mview_name_i               VARCHAR2
31    , as_stmt_i                     VARCHAR2
32    );
33 
34    PROCEDURE do_mv_ddl2 (
35      an_operation_i                PLS_INTEGER
36    , as_mview_name_i               VARCHAR2
37    , as_stmt_i                     VARCHAR2
38    , ab_execute_i                  INTEGER DEFAULT NULL
39    );
40 
41    PROCEDURE do_mv_ddl (
42      an_operation_i                PLS_INTEGER
43    , as_mview_name_i               VARCHAR2
44    , as_stmt_i                     VARCHAR2
45    , ab_execute_i                  BOOLEAN DEFAULT NULL
46    );
47 
48 END ad_mv;