PACKAGE: APPS.OKI_DBI_MV_UTIL_PVT

Source

1 PACKAGE oki_dbi_mv_util_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKIRIMUS.pls 115.5 2003/04/18 18:47:18 mezra noship $ */
3 
4   procedure drop_mv_log
5   (   p_mv_log IN VARCHAR2
6   ) ;
7 
8   procedure create_mv_log
9   (   p_base_table IN VARCHAR2
10    ,  p_column_list IN VARCHAR2
11    ,  p_sequence_flag IN VARCHAR2
12    ,  p_rowid IN VARCHAR2
13    ,  p_new_values IN VARCHAR2
14    ,  p_data_tablespace IN VARCHAR2
15    ,  p_index_tablespace IN VARCHAR2
16    ,  p_next_extent IN VARCHAR2
17   ) ;
18 
19   procedure drop_mv
20   (   p_mv IN VARCHAR2
21   ) ;
22 
23   procedure create_mv
24   (   p_mv_name IN VARCHAR2
25    ,  p_mv_sql IN VARCHAR2
26    ,  p_build_mode IN VARCHAR2  -- D = DEFERRED, I = IMMEDIATE
27    ,  p_refresh_mode IN VARCHAR2  -- F = FAST , C = COMPLETE
28    ,  p_enable_qrewrite IN VARCHAR2
29    ,  p_partition_flag IN VARCHAR2
30    ,  p_next_extent IN VARCHAR2
31   ) ;
32 
33   procedure create_mv_index
34   (   p_mv_name IN VARCHAR2
35    ,  p_ind_name IN VARCHAR2
36    ,  p_ind_col_list IN VARCHAR2
37    ,  p_unique_flag IN VARCHAR2
38    ,  p_ind_type IN VARCHAR2  -- B = BTree , M = BitMap
39    ,  p_next_extent IN VARCHAR2
40    ,  p_partition_type IN VARCHAR2
41   ) ;
42 
43   PROCEDURE drop_index
44   (   p_index_name IN VARCHAR2
45   ) ;
46 
47   PROCEDURE refresh
48   (  p_mv_name         IN  VARCHAR2
49    , p_parallel_degree IN  NUMBER
50 
51   ) ;
52 
53   PROCEDURE crt_mx
54   (  p_id       IN NUMBER
55    , p_user_id  IN NUMBER
56    , p_run_date IN DATE
57    , p_login_id IN NUMBER
58   ) ;
59 
60 END oki_dbi_mv_util_pvt ;