1: package EDW_NAEDW_PUSH AUTHID CURRENT_USER AS
2: /*$Header: EDWNAEDS.pls 115.15 2002/11/23 00:09:31 vsurendr ship $*/
3:
4: g_dim_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
5: g_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
6: g_number_dims number;
7:
8: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
1: package EDW_NAEDW_PUSH AUTHID CURRENT_USER AS
2: /*$Header: EDWNAEDS.pls 115.15 2002/11/23 00:09:31 vsurendr ship $*/
3:
4: g_dim_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
5: g_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
6: g_number_dims number;
7:
8: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
9: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
4: g_dim_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
5: g_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
6: g_number_dims number;
7:
8: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
9: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
10: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
11: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
12: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
5: g_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
6: g_number_dims number;
7:
8: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
9: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
10: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
11: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
12: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
13: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
6: g_number_dims number;
7:
8: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
9: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
10: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
11: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
12: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
13: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
14: g_number_levels integer;
7:
8: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
9: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
10: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
11: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
12: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
13: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
14: g_number_levels integer;
15:
8: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
9: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
10: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
11: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
12: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
13: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
14: g_number_levels integer;
15:
16: g_level_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
9: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
10: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
11: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
12: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
13: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
14: g_number_levels integer;
15:
16: g_level_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
17: g_level_fk_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
12: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
13: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
14: g_number_levels integer;
15:
16: g_level_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
17: g_level_fk_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
18: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
19: g_level_pk_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
20: g_varchar_pk_index number;
13: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
14: g_number_levels integer;
15:
16: g_level_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
17: g_level_fk_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
18: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
19: g_level_pk_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
20: g_varchar_pk_index number;
21: g_level_pk_number number;
14: g_number_levels integer;
15:
16: g_level_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
17: g_level_fk_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
18: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
19: g_level_pk_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
20: g_varchar_pk_index number;
21: g_level_pk_number number;
22: g_level_fk_number number;
15:
16: g_level_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
17: g_level_fk_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
18: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
19: g_level_pk_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
20: g_varchar_pk_index number;
21: g_level_pk_number number;
22: g_level_fk_number number;
23: g_level_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
19: g_level_pk_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
20: g_varchar_pk_index number;
21: g_level_pk_number number;
22: g_level_fk_number number;
23: g_level_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
24: g_level_cols_length EDW_OWB_COLLECTION_UTIL.varcharTableType;
25: g_level_cols_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
26: g_level_col_number number;
27:
20: g_varchar_pk_index number;
21: g_level_pk_number number;
22: g_level_fk_number number;
23: g_level_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
24: g_level_cols_length EDW_OWB_COLLECTION_UTIL.varcharTableType;
25: g_level_cols_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
26: g_level_col_number number;
27:
28: g_unassigned varchar2(3000);
21: g_level_pk_number number;
22: g_level_fk_number number;
23: g_level_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
24: g_level_cols_length EDW_OWB_COLLECTION_UTIL.varcharTableType;
25: g_level_cols_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
26: g_level_col_number number;
27:
28: g_unassigned varchar2(3000);
29: g_unassigned_length number;
62: g_naedw_in boolean;
63: g_err_in boolean;
64: g_dim_pk varchar2(400);
65: g_coll_engine_call boolean;
66: g_level_fk_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
67: g_all_level varchar2(400);
68: PROCEDURE PUSH (Errbuf out NOCOPY varchar2,
69: retcode out NOCOPY varchar2);
70: PROCEDURE PUSH(Errbuf out NOCOPY varchar2,