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