PACKAGE: APPS.AD_MV

Source

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