APPS.EDW_WH_DANG_RECOVERY dependencies on EDW_OWB_COLLECTION_UTIL

Line 10: g_fact_list edw_owb_collection_util.varchartabletype;

6: g_status BOOLEAN;
7: g_status_varchar VARCHAR2 (40);
8: g_status_message VARCHAR2 (4000);
9: g_debug BOOLEAN;
10: g_fact_list edw_owb_collection_util.varchartabletype;
11: g_number_fact_list PLS_INTEGER;
12: g_fact VARCHAR2 (400);
13: g_dim_list edw_owb_collection_util.varchartabletype;
14: g_dim_id_list edw_owb_collection_util.numbertabletype;

Line 13: g_dim_list edw_owb_collection_util.varchartabletype;

9: g_debug BOOLEAN;
10: g_fact_list edw_owb_collection_util.varchartabletype;
11: g_number_fact_list PLS_INTEGER;
12: g_fact VARCHAR2 (400);
13: g_dim_list edw_owb_collection_util.varchartabletype;
14: g_dim_id_list edw_owb_collection_util.numbertabletype;
15: g_number_dim_list PLS_INTEGER;
16: g_fstg_name VARCHAR2 (400);
17: g_fstg_op_table VARCHAR2 (400);

Line 14: g_dim_id_list edw_owb_collection_util.numbertabletype;

10: g_fact_list edw_owb_collection_util.varchartabletype;
11: g_number_fact_list PLS_INTEGER;
12: g_fact VARCHAR2 (400);
13: g_dim_list edw_owb_collection_util.varchartabletype;
14: g_dim_id_list edw_owb_collection_util.numbertabletype;
15: g_number_dim_list PLS_INTEGER;
16: g_fstg_name VARCHAR2 (400);
17: g_fstg_op_table VARCHAR2 (400);
18: g_fstg_id PLS_INTEGER;

Line 21: g_fstg_fk edw_owb_collection_util.varchartabletype;

17: g_fstg_op_table VARCHAR2 (400);
18: g_fstg_id PLS_INTEGER;
19: g_fstg_pk VARCHAR2 (400);
20: g_fact_id PLS_INTEGER;
21: g_fstg_fk edw_owb_collection_util.varchartabletype;
22: g_fstg_fk_id edw_owb_collection_util.numbertabletype;
23: g_number_fstg_fk PLS_INTEGER;
24: g_fstg_all_fk edw_owb_collection_util.varchartabletype;
25: g_number_fstg_all_fk PLS_INTEGER;

Line 22: g_fstg_fk_id edw_owb_collection_util.numbertabletype;

18: g_fstg_id PLS_INTEGER;
19: g_fstg_pk VARCHAR2 (400);
20: g_fact_id PLS_INTEGER;
21: g_fstg_fk edw_owb_collection_util.varchartabletype;
22: g_fstg_fk_id edw_owb_collection_util.numbertabletype;
23: g_number_fstg_fk PLS_INTEGER;
24: g_fstg_all_fk edw_owb_collection_util.varchartabletype;
25: g_number_fstg_all_fk PLS_INTEGER;
26: g_fstg_cols edw_owb_collection_util.varchartabletype;

Line 24: g_fstg_all_fk edw_owb_collection_util.varchartabletype;

20: g_fact_id PLS_INTEGER;
21: g_fstg_fk edw_owb_collection_util.varchartabletype;
22: g_fstg_fk_id edw_owb_collection_util.numbertabletype;
23: g_number_fstg_fk PLS_INTEGER;
24: g_fstg_all_fk edw_owb_collection_util.varchartabletype;
25: g_number_fstg_all_fk PLS_INTEGER;
26: g_fstg_cols edw_owb_collection_util.varchartabletype;
27: g_number_fstg_cols PLS_INTEGER;
28: g_fk_dim edw_owb_collection_util.varchartabletype;

Line 26: g_fstg_cols edw_owb_collection_util.varchartabletype;

22: g_fstg_fk_id edw_owb_collection_util.numbertabletype;
23: g_number_fstg_fk PLS_INTEGER;
24: g_fstg_all_fk edw_owb_collection_util.varchartabletype;
25: g_number_fstg_all_fk PLS_INTEGER;
26: g_fstg_cols edw_owb_collection_util.varchartabletype;
27: g_number_fstg_cols PLS_INTEGER;
28: g_fk_dim edw_owb_collection_util.varchartabletype;
29: g_bad_key_tables edw_owb_collection_util.varchartabletype;
30: g_bad_fk_tables edw_owb_collection_util.varchartabletype; --for each fk

Line 28: g_fk_dim edw_owb_collection_util.varchartabletype;

24: g_fstg_all_fk edw_owb_collection_util.varchartabletype;
25: g_number_fstg_all_fk PLS_INTEGER;
26: g_fstg_cols edw_owb_collection_util.varchartabletype;
27: g_number_fstg_cols PLS_INTEGER;
28: g_fk_dim edw_owb_collection_util.varchartabletype;
29: g_bad_key_tables edw_owb_collection_util.varchartabletype;
30: g_bad_fk_tables edw_owb_collection_util.varchartabletype; --for each fk
31: g_instance VARCHAR2 (400);
32: g_fstg_error_table VARCHAR2 (400);

Line 29: g_bad_key_tables edw_owb_collection_util.varchartabletype;

25: g_number_fstg_all_fk PLS_INTEGER;
26: g_fstg_cols edw_owb_collection_util.varchartabletype;
27: g_number_fstg_cols PLS_INTEGER;
28: g_fk_dim edw_owb_collection_util.varchartabletype;
29: g_bad_key_tables edw_owb_collection_util.varchartabletype;
30: g_bad_fk_tables edw_owb_collection_util.varchartabletype; --for each fk
31: g_instance VARCHAR2 (400);
32: g_fstg_error_table VARCHAR2 (400);
33: g_fstg_error_table_flag BOOLEAN;

Line 30: g_bad_fk_tables edw_owb_collection_util.varchartabletype; --for each fk

26: g_fstg_cols edw_owb_collection_util.varchartabletype;
27: g_number_fstg_cols PLS_INTEGER;
28: g_fk_dim edw_owb_collection_util.varchartabletype;
29: g_bad_key_tables edw_owb_collection_util.varchartabletype;
30: g_bad_fk_tables edw_owb_collection_util.varchartabletype; --for each fk
31: g_instance VARCHAR2 (400);
32: g_fstg_error_table VARCHAR2 (400);
33: g_fstg_error_table_flag BOOLEAN;
34: g_mode VARCHAR2 (200);