[Home] [Help]
PACKAGE: APPS.EDW_DIM_SV
Source
1 Package EDW_DIM_SV AUTHID DEFINER AS
2 /* $Header: EDWVDIMS.pls 115.9 2003/02/25 23:36:30 arsantha ship $ */
3
4 g_log boolean := false;
5
6 Procedure getViewnameForFlexdim(dim_name in varchar2) ;
7 FUNCTION getIndepVSClause( p_dim_name in VARCHAR2, p_level IN VARCHAR2) RETURN VARCHAR2;
8 Function getTableValClause(dim_name in varchar2) return varchar2;
9 Function getNoneVSClause(p_dim_name in varchar2) return varchar2;
10 FUNCTION getDepVSClause(p_dim_name in varchar2) return VARCHAR2;
11
12 PROCEDURE getViewnamesForStdDim(dim_name in varchar2, level IN VARCHAR2) ;
13 PROCEDURE generateStdDimension(dim_name IN VARCHAR2);
14 FUNCTION getGeneratedViewnameForStdDim(dim_name IN VARCHAR2, level IN VARCHAR2) RETURN VARCHAR2;
15
16 Procedure generateViewForDimension(dim_name in varchar2);
17
18 END EDW_DIM_SV;