[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;