PACKAGE: APPS.AD_ZD_MVIEW

Source

1 PACKAGE AD_ZD_MVIEW AUTHID CURRENT_USER AS
2 -- $Header: ADZDMVS.pls 120.16.12020000.2 2012/12/12 16:14:12 asutrala ship $
3 
4 /*=================================================================*
5  *                     Below apis needed for xdf                   *
6  *=================================================================*/
7 
8 procedure PATCH(p_mvdef CLOB);
9 
10 procedure PATCH(p_owner varchar2,
11                 p_name varchar2,
12                 p_type varchar2 default null);
13 
14 
15 /*=================================================================*
16  *                     Below apis needed for ad_mv                 *
17  *=================================================================*/
18 
19 procedure DROP_MVQ(p_owner varchar2 default ' ',
20                    p_mvname varchar2);
21 
22 procedure INSTALL_MVQ_ARCH(p_mvdef CLOB,
23                            p_skipmv number default 0);
24 
25 procedure DROP_MV (
26               X_MVIEW_OWNER    in  varchar2,
27               X_MVIEW_NAME     in  varchar2,
28               X_DROP_STMT      in  varchar2,
29               X_UPD_STMT       in  varchar2,
30               X_DROPPED        out nocopy varchar2 );
31 
32 /*=================================================================*
33  *                     Below apis given by GB                      *
34  *=================================================================*/
35 
36 procedure UPGRADE(p_owner varchar2,
37                   p_mview_name varchar2);
38 
39 procedure UPGRADE_DB(x_execute number default 1);
40 
41 function GENERATE(p_owner varchar2,
42                   p_mvname varchar2)
43 return clob;
44 
45 function GET_MVQ_NAME(name varchar2, ext varchar2 default ' ')
46 return varchar2;
47 
48 function GET_MV_NAME(name varchar2, ext varchar2 default ' ')
49 return varchar2;
50 
51 procedure FINALIZE;
52 
53 procedure CUTOVER(x_execute number default 0);
54 
55 procedure PATCH_LOG(p_owner varchar2,
56                     p_tabname varchar2);
57 
58 /*=================================================================*
59  *                     Global Constant Variables                   *
60  *=================================================================*/
61 
62 -- For MVQ View
63 g_mvq_char constant varchar2(1) := '#';
64 
65 -- For MVLog View
66 g_mvl_char constant varchar2(1) := '~';
67 g_mvm_char constant varchar2(1) := '-';
68 
69 end AD_ZD_MVIEW;