DBA Data[Home] [Help]

APPS.EDW_DUPLICATE_CLEAN dependencies on EDW_OWB_COLLECTION_UTIL

Line 6: g_ltc_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;

2: /*$Header: EDWDCLNS.pls 115.7 2003/11/05 22:17:29 vsurendr noship $*/
3: g_dim_name varchar2(400);
4: g_dim_pk varchar2(400);
5: g_dim_pk_key varchar2(400);
6: g_ltc_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
7: g_ltc_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
8: g_ltc_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
9: g_number_ltc number;
10: g_bis_owner varchar2(100);

Line 7: g_ltc_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

3: g_dim_name varchar2(400);
4: g_dim_pk varchar2(400);
5: g_dim_pk_key varchar2(400);
6: g_ltc_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
7: g_ltc_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
8: g_ltc_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
9: g_number_ltc number;
10: g_bis_owner varchar2(100);
11: g_parallel number;

Line 8: g_ltc_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;

4: g_dim_pk varchar2(400);
5: g_dim_pk_key varchar2(400);
6: g_ltc_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
7: g_ltc_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
8: g_ltc_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
9: g_number_ltc number;
10: g_bis_owner varchar2(100);
11: g_parallel number;
12: g_fact_name varchar2(400);

Line 42: p_fact out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,

38: procedure clean_up_object(Errbuf out NOCOPY varchar2,Retcode out NOCOPY varchar2,p_object_name in varchar2);
39: function is_dimension(p_object_name varchar2) return boolean ;
40: function get_fact_fk_for_dim(
41: p_dim_name varchar2,
42: p_fact out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
43: p_fact_fk out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
44: p_number_fact_fk out nocopy number
45: )return boolean;
46: function delete_dim_duplicate_data(

Line 43: p_fact_fk out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,

39: function is_dimension(p_object_name varchar2) return boolean ;
40: function get_fact_fk_for_dim(
41: p_dim_name varchar2,
42: p_fact out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
43: p_fact_fk out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
44: p_number_fact_fk out nocopy number
45: )return boolean;
46: function delete_dim_duplicate_data(
47: p_dim_name varchar2,