eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_PUSH_DOWN_DIMS dependencies on EDW_OWB_COLLECTION_UTIL

Line 4: g_skip_ilog_update EDW_OWB_COLLECTION_UTIL.booleanTableType;

1: package EDW_PUSH_DOWN_DIMS AUTHID CURRENT_USER AS
2: /*$Header: EDWPSDNS.pls 115.8 2003/07/29 00:22:24 vsurendr ship $*/
3:
4: g_skip_ilog_update EDW_OWB_COLLECTION_UTIL.booleanTableType;
5: g_job_id number;
6: g_jobid_stmt varchar2(200);
7: g_log_file varchar2(2000);
8: g_input_table varchar2(200);

Line 23: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;

19: g_status boolean;
20: g_dim_name varchar2(400);
21: g_dim_id number;
22: g_lowest_level varchar2(400);
23: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
24: g_level_ids EDW_OWB_COLLECTION_UTIL.numberTableType;
25: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
26: g_level_seq EDW_OWB_COLLECTION_UTIL.varcharTableType;
27: --g_lstg_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 24: g_level_ids EDW_OWB_COLLECTION_UTIL.numberTableType;

20: g_dim_name varchar2(400);
21: g_dim_id number;
22: g_lowest_level varchar2(400);
23: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
24: g_level_ids EDW_OWB_COLLECTION_UTIL.numberTableType;
25: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
26: g_level_seq EDW_OWB_COLLECTION_UTIL.varcharTableType;
27: --g_lstg_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
28: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 25: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

21: g_dim_id number;
22: g_lowest_level varchar2(400);
23: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
24: g_level_ids EDW_OWB_COLLECTION_UTIL.numberTableType;
25: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
26: g_level_seq EDW_OWB_COLLECTION_UTIL.varcharTableType;
27: --g_lstg_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
28: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
29: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 26: g_level_seq EDW_OWB_COLLECTION_UTIL.varcharTableType;

22: g_lowest_level varchar2(400);
23: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
24: g_level_ids EDW_OWB_COLLECTION_UTIL.numberTableType;
25: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
26: g_level_seq EDW_OWB_COLLECTION_UTIL.varcharTableType;
27: --g_lstg_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
28: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
29: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
30: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 27: --g_lstg_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;

23: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
24: g_level_ids EDW_OWB_COLLECTION_UTIL.numberTableType;
25: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
26: g_level_seq EDW_OWB_COLLECTION_UTIL.varcharTableType;
27: --g_lstg_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
28: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
29: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
30: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
31: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 28: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;

24: g_level_ids EDW_OWB_COLLECTION_UTIL.numberTableType;
25: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
26: g_level_seq EDW_OWB_COLLECTION_UTIL.varcharTableType;
27: --g_lstg_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
28: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
29: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
30: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
31: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
32: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 29: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;

25: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
26: g_level_seq EDW_OWB_COLLECTION_UTIL.varcharTableType;
27: --g_lstg_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
28: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
29: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
30: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
31: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
32: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
33: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 30: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;

26: g_level_seq EDW_OWB_COLLECTION_UTIL.varcharTableType;
27: --g_lstg_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
28: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
29: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
30: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
31: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
32: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
33: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
34: g_level_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 31: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

27: --g_lstg_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
28: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
29: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
30: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
31: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
32: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
33: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
34: g_level_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType;
35: g_level_ilog_count EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 32: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;

28: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
29: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
30: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
31: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
32: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
33: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
34: g_level_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType;
35: g_level_ilog_count EDW_OWB_COLLECTION_UTIL.numberTableType;
36: g_level_ilog_name EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 33: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;

29: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
30: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
31: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
32: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
33: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
34: g_level_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType;
35: g_level_ilog_count EDW_OWB_COLLECTION_UTIL.numberTableType;
36: g_level_ilog_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
37: g_level_ilog_main EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 34: g_level_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType;

30: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
31: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
32: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
33: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
34: g_level_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType;
35: g_level_ilog_count EDW_OWB_COLLECTION_UTIL.numberTableType;
36: g_level_ilog_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
37: g_level_ilog_main EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_ilog_found EDW_OWB_COLLECTION_UTIL.booleanTableType;

Line 35: g_level_ilog_count EDW_OWB_COLLECTION_UTIL.numberTableType;

31: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
32: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
33: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
34: g_level_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType;
35: g_level_ilog_count EDW_OWB_COLLECTION_UTIL.numberTableType;
36: g_level_ilog_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
37: g_level_ilog_main EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_ilog_found EDW_OWB_COLLECTION_UTIL.booleanTableType;
39: g_level_full_insert EDW_OWB_COLLECTION_UTIL.booleanTableType;

Line 36: g_level_ilog_name EDW_OWB_COLLECTION_UTIL.varcharTableType;

32: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
33: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
34: g_level_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType;
35: g_level_ilog_count EDW_OWB_COLLECTION_UTIL.numberTableType;
36: g_level_ilog_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
37: g_level_ilog_main EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_ilog_found EDW_OWB_COLLECTION_UTIL.booleanTableType;
39: g_level_full_insert EDW_OWB_COLLECTION_UTIL.booleanTableType;
40: g_level_consider EDW_OWB_COLLECTION_UTIL.booleanTableType;

Line 37: g_level_ilog_main EDW_OWB_COLLECTION_UTIL.varcharTableType;

33: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
34: g_level_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType;
35: g_level_ilog_count EDW_OWB_COLLECTION_UTIL.numberTableType;
36: g_level_ilog_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
37: g_level_ilog_main EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_ilog_found EDW_OWB_COLLECTION_UTIL.booleanTableType;
39: g_level_full_insert EDW_OWB_COLLECTION_UTIL.booleanTableType;
40: g_level_consider EDW_OWB_COLLECTION_UTIL.booleanTableType;
41: g_insert_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 38: g_level_ilog_found EDW_OWB_COLLECTION_UTIL.booleanTableType;

34: g_level_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType;
35: g_level_ilog_count EDW_OWB_COLLECTION_UTIL.numberTableType;
36: g_level_ilog_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
37: g_level_ilog_main EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_ilog_found EDW_OWB_COLLECTION_UTIL.booleanTableType;
39: g_level_full_insert EDW_OWB_COLLECTION_UTIL.booleanTableType;
40: g_level_consider EDW_OWB_COLLECTION_UTIL.booleanTableType;
41: g_insert_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_update_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 39: g_level_full_insert EDW_OWB_COLLECTION_UTIL.booleanTableType;

35: g_level_ilog_count EDW_OWB_COLLECTION_UTIL.numberTableType;
36: g_level_ilog_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
37: g_level_ilog_main EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_ilog_found EDW_OWB_COLLECTION_UTIL.booleanTableType;
39: g_level_full_insert EDW_OWB_COLLECTION_UTIL.booleanTableType;
40: g_level_consider EDW_OWB_COLLECTION_UTIL.booleanTableType;
41: g_insert_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_update_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;
43: g_analyze_needed EDW_OWB_COLLECTION_UTIL.booleanTableType;

Line 40: g_level_consider EDW_OWB_COLLECTION_UTIL.booleanTableType;

36: g_level_ilog_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
37: g_level_ilog_main EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_ilog_found EDW_OWB_COLLECTION_UTIL.booleanTableType;
39: g_level_full_insert EDW_OWB_COLLECTION_UTIL.booleanTableType;
40: g_level_consider EDW_OWB_COLLECTION_UTIL.booleanTableType;
41: g_insert_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_update_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;
43: g_analyze_needed EDW_OWB_COLLECTION_UTIL.booleanTableType;
44: g_number_levels number;

Line 41: g_insert_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;

37: g_level_ilog_main EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_ilog_found EDW_OWB_COLLECTION_UTIL.booleanTableType;
39: g_level_full_insert EDW_OWB_COLLECTION_UTIL.booleanTableType;
40: g_level_consider EDW_OWB_COLLECTION_UTIL.booleanTableType;
41: g_insert_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_update_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;
43: g_analyze_needed EDW_OWB_COLLECTION_UTIL.booleanTableType;
44: g_number_levels number;
45: g_debug boolean;

Line 42: g_update_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;

38: g_level_ilog_found EDW_OWB_COLLECTION_UTIL.booleanTableType;
39: g_level_full_insert EDW_OWB_COLLECTION_UTIL.booleanTableType;
40: g_level_consider EDW_OWB_COLLECTION_UTIL.booleanTableType;
41: g_insert_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_update_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;
43: g_analyze_needed EDW_OWB_COLLECTION_UTIL.booleanTableType;
44: g_number_levels number;
45: g_debug boolean;
46: g_parallel number;

Line 43: g_analyze_needed EDW_OWB_COLLECTION_UTIL.booleanTableType;

39: g_level_full_insert EDW_OWB_COLLECTION_UTIL.booleanTableType;
40: g_level_consider EDW_OWB_COLLECTION_UTIL.booleanTableType;
41: g_insert_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_update_rowid EDW_OWB_COLLECTION_UTIL.varcharTableType;
43: g_analyze_needed EDW_OWB_COLLECTION_UTIL.booleanTableType;
44: g_number_levels number;
45: g_debug boolean;
46: g_parallel number;
47: g_collection_size number;

Line 52: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;

48: g_bis_owner varchar2(400);
49: g_table_owner varchar2(400);
50: g_full_refresh boolean;
51:
52: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
53: g_level_display_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
54:
55: g_final_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_final_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 53: g_level_display_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;

49: g_table_owner varchar2(400);
50: g_full_refresh boolean;
51:
52: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
53: g_level_display_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
54:
55: g_final_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_final_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
57: g_final_next_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 55: g_final_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;

51:
52: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
53: g_level_display_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
54:
55: g_final_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_final_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
57: g_final_next_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
58: g_final_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_final_next_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 56: g_final_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;

52: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
53: g_level_display_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
54:
55: g_final_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_final_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
57: g_final_next_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
58: g_final_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_final_next_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
60: g_final_pk_value EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 57: g_final_next_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;

53: g_level_display_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
54:
55: g_final_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_final_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
57: g_final_next_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
58: g_final_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_final_next_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
60: g_final_pk_value EDW_OWB_COLLECTION_UTIL.varcharTableType;
61: g_final_pk_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 58: g_final_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;

54:
55: g_final_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_final_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
57: g_final_next_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
58: g_final_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_final_next_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
60: g_final_pk_value EDW_OWB_COLLECTION_UTIL.varcharTableType;
61: g_final_pk_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_final_fk_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 59: g_final_next_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

55: g_final_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_final_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
57: g_final_next_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
58: g_final_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_final_next_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
60: g_final_pk_value EDW_OWB_COLLECTION_UTIL.varcharTableType;
61: g_final_pk_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_final_fk_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_number_final number;

Line 60: g_final_pk_value EDW_OWB_COLLECTION_UTIL.varcharTableType;

56: g_final_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
57: g_final_next_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
58: g_final_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_final_next_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
60: g_final_pk_value EDW_OWB_COLLECTION_UTIL.varcharTableType;
61: g_final_pk_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_final_fk_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_number_final number;
64: g_forall_size number;

Line 61: g_final_pk_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;

57: g_final_next_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
58: g_final_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_final_next_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
60: g_final_pk_value EDW_OWB_COLLECTION_UTIL.varcharTableType;
61: g_final_pk_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_final_fk_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_number_final number;
64: g_forall_size number;
65: g_update_type varchar2(400);

Line 62: g_final_fk_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;

58: g_final_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_final_next_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
60: g_final_pk_value EDW_OWB_COLLECTION_UTIL.varcharTableType;
61: g_final_pk_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_final_fk_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_number_final number;
64: g_forall_size number;
65: g_update_type varchar2(400);
66: g_join_nl_percentage number;

Line 70: g_insert_stmt EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;

66: g_join_nl_percentage number;
67:
68: --REMOVE
69: g_count number;
70: g_insert_stmt EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
71: g_insert_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
72: g_update_stmt EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
73: g_update_stmt_row EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
74: g_update_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;

Line 71: g_insert_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;

67:
68: --REMOVE
69: g_count number;
70: g_insert_stmt EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
71: g_insert_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
72: g_update_stmt EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
73: g_update_stmt_row EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
74: g_update_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
75: g_level_id number;

Line 72: g_update_stmt EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;

68: --REMOVE
69: g_count number;
70: g_insert_stmt EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
71: g_insert_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
72: g_update_stmt EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
73: g_update_stmt_row EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
74: g_update_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
75: g_level_id number;
76: g_load_pk number;

Line 73: g_update_stmt_row EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;

69: g_count number;
70: g_insert_stmt EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
71: g_insert_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
72: g_update_stmt EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
73: g_update_stmt_row EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
74: g_update_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
75: g_level_id number;
76: g_load_pk number;
77: g_op_table_space varchar2(400);

Line 74: g_update_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;

70: g_insert_stmt EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
71: g_insert_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
72: g_update_stmt EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
73: g_update_stmt_row EDW_OWB_COLLECTION_UTIL.LLL_varcharTableType;
74: g_update_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
75: g_level_id number;
76: g_load_pk number;
77: g_op_table_space varchar2(400);
78: g_rollback varchar2(400);

Line 79: g_snplog_has_pk EDW_OWB_COLLECTION_UTIL.booleanTableType;

75: g_level_id number;
76: g_load_pk number;
77: g_op_table_space varchar2(400);
78: g_rollback varchar2(400);
79: g_snplog_has_pk EDW_OWB_COLLECTION_UTIL.booleanTableType;
80: g_type_ilog_generation varchar2(200);
81: g_ltc_copy EDW_OWB_COLLECTION_UTIL.varcharTableType;
82: g_diamond_level EDW_OWB_COLLECTION_UTIL.varcharTableType;--levels that are at the head of a diamond
83: g_number_diamond_level number;

Line 81: g_ltc_copy EDW_OWB_COLLECTION_UTIL.varcharTableType;

77: g_op_table_space varchar2(400);
78: g_rollback varchar2(400);
79: g_snplog_has_pk EDW_OWB_COLLECTION_UTIL.booleanTableType;
80: g_type_ilog_generation varchar2(200);
81: g_ltc_copy EDW_OWB_COLLECTION_UTIL.varcharTableType;
82: g_diamond_level EDW_OWB_COLLECTION_UTIL.varcharTableType;--levels that are at the head of a diamond
83: g_number_diamond_level number;
84: g_parent_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
85: g_child_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 82: g_diamond_level EDW_OWB_COLLECTION_UTIL.varcharTableType;--levels that are at the head of a diamond

78: g_rollback varchar2(400);
79: g_snplog_has_pk EDW_OWB_COLLECTION_UTIL.booleanTableType;
80: g_type_ilog_generation varchar2(200);
81: g_ltc_copy EDW_OWB_COLLECTION_UTIL.varcharTableType;
82: g_diamond_level EDW_OWB_COLLECTION_UTIL.varcharTableType;--levels that are at the head of a diamond
83: g_number_diamond_level number;
84: g_parent_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
85: g_child_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
86: g_hier EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 84: g_parent_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;

80: g_type_ilog_generation varchar2(200);
81: g_ltc_copy EDW_OWB_COLLECTION_UTIL.varcharTableType;
82: g_diamond_level EDW_OWB_COLLECTION_UTIL.varcharTableType;--levels that are at the head of a diamond
83: g_number_diamond_level number;
84: g_parent_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
85: g_child_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
86: g_hier EDW_OWB_COLLECTION_UTIL.varcharTableType;
87: g_number_ltc number;
88: g_distinct_hier EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 85: g_child_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;

81: g_ltc_copy EDW_OWB_COLLECTION_UTIL.varcharTableType;
82: g_diamond_level EDW_OWB_COLLECTION_UTIL.varcharTableType;--levels that are at the head of a diamond
83: g_number_diamond_level number;
84: g_parent_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
85: g_child_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
86: g_hier EDW_OWB_COLLECTION_UTIL.varcharTableType;
87: g_number_ltc number;
88: g_distinct_hier EDW_OWB_COLLECTION_UTIL.varcharTableType;
89: g_number_distinct_hier number;

Line 86: g_hier EDW_OWB_COLLECTION_UTIL.varcharTableType;

82: g_diamond_level EDW_OWB_COLLECTION_UTIL.varcharTableType;--levels that are at the head of a diamond
83: g_number_diamond_level number;
84: g_parent_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
85: g_child_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
86: g_hier EDW_OWB_COLLECTION_UTIL.varcharTableType;
87: g_number_ltc number;
88: g_distinct_hier EDW_OWB_COLLECTION_UTIL.varcharTableType;
89: g_number_distinct_hier number;
90:

Line 88: g_distinct_hier EDW_OWB_COLLECTION_UTIL.varcharTableType;

84: g_parent_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
85: g_child_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
86: g_hier EDW_OWB_COLLECTION_UTIL.varcharTableType;
87: g_number_ltc number;
88: g_distinct_hier EDW_OWB_COLLECTION_UTIL.varcharTableType;
89: g_number_distinct_hier number;
90:
91: function push_down_all_levels(
92: p_dim_name varchar2,

Line 93: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,

89: g_number_distinct_hier number;
90:
91: function push_down_all_levels(
92: p_dim_name varchar2,
93: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
94: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
95: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
96: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
97: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 94: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,

90:
91: function push_down_all_levels(
92: p_dim_name varchar2,
93: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
94: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
95: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
96: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
97: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
98: p_number_levels number,

Line 95: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,

91: function push_down_all_levels(
92: p_dim_name varchar2,
93: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
94: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
95: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
96: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
97: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
98: p_number_levels number,
99: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 96: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,

92: p_dim_name varchar2,
93: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
94: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
95: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
96: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
97: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
98: p_number_levels number,
99: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
100: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 97: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,

93: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
94: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
95: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
96: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
97: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
98: p_number_levels number,
99: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
100: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
101: p_debug boolean,

Line 99: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,

95: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
96: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
97: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
98: p_number_levels number,
99: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
100: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
101: p_debug boolean,
102: p_parallel number,
103: p_collection_size number,

Line 100: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,

96: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
97: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
98: p_number_levels number,
99: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
100: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
101: p_debug boolean,
102: p_parallel number,
103: p_collection_size number,
104: p_bis_owner varchar2,

Line 172: p_fks_out out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_fks_out out NOCOPY number) return boolean ;

168: function set_gilog_status(p_ilog in out NOCOPY varchar2,p_index number) return number;
169: function check_levels_for_data return boolean;
170: function get_index_for_level(p_level varchar2) return number;
171: function get_fks_without_fk(p_level varchar2, p_fk varchar2,
172: p_fks_out out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_fks_out out NOCOPY number) return boolean ;
173: function make_sql_stmts(p_level varchar2) return boolean;
174: function get_level_seq return boolean ;
175: function find_lowest_level return boolean ;
176: procedure clean_up;

Line 192: function get_diamond_tops(p_parent_level varchar2,p_diamond_tops out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,

188: function find_ltc_to_push_down return number;
189: function make_and_exec_sql_stmts(p_parent_level varchar2,p_child_level varchar2,p_ilog varchar2) return boolean ;
190: function create_ilog_copy(p_ilog varchar2,p_ilog_copy varchar2) return boolean ;
191: function find_diamond_levels return boolean ;
192: function get_diamond_tops(p_parent_level varchar2,p_diamond_tops out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
193: p_number_diamond_tops out NOCOPY number) return boolean ;
194: function get_level_for_fk(p_child_level varchar2,p_fk varchar2) return varchar2 ;
195: function is_below_diamond_top(p_other_fk_level varchar2,p_diamond_tops varchar2) return boolean ;
196: function get_way_to_child(p_parent_level varchar2,p_child_level varchar2,

Line 197: p_parent_level_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,

193: p_number_diamond_tops out NOCOPY number) return boolean ;
194: function get_level_for_fk(p_child_level varchar2,p_fk varchar2) return varchar2 ;
195: function is_below_diamond_top(p_other_fk_level varchar2,p_diamond_tops varchar2) return boolean ;
196: function get_way_to_child(p_parent_level varchar2,p_child_level varchar2,
197: p_parent_level_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
198: p_child_level_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
199: p_parent_pk_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
200: p_child_fk_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
201: p_number_level_order out NOCOPY number) return boolean ;

Line 198: p_child_level_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,

194: function get_level_for_fk(p_child_level varchar2,p_fk varchar2) return varchar2 ;
195: function is_below_diamond_top(p_other_fk_level varchar2,p_diamond_tops varchar2) return boolean ;
196: function get_way_to_child(p_parent_level varchar2,p_child_level varchar2,
197: p_parent_level_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
198: p_child_level_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
199: p_parent_pk_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
200: p_child_fk_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
201: p_number_level_order out NOCOPY number) return boolean ;
202: function create_child_dia_fk_table(

Line 199: p_parent_pk_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,

195: function is_below_diamond_top(p_other_fk_level varchar2,p_diamond_tops varchar2) return boolean ;
196: function get_way_to_child(p_parent_level varchar2,p_child_level varchar2,
197: p_parent_level_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
198: p_child_level_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
199: p_parent_pk_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
200: p_child_fk_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
201: p_number_level_order out NOCOPY number) return boolean ;
202: function create_child_dia_fk_table(
203: p_parent_level varchar2,

Line 200: p_child_fk_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,

196: function get_way_to_child(p_parent_level varchar2,p_child_level varchar2,
197: p_parent_level_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
198: p_child_level_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
199: p_parent_pk_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
200: p_child_fk_order out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
201: p_number_level_order out NOCOPY number) return boolean ;
202: function create_child_dia_fk_table(
203: p_parent_level varchar2,
204: p_child_level varchar2,

Line 205: p_parent_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,

201: p_number_level_order out NOCOPY number) return boolean ;
202: function create_child_dia_fk_table(
203: p_parent_level varchar2,
204: p_child_level varchar2,
205: p_parent_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
206: p_child_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
207: p_parent_pk_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
208: p_child_fk_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
209: p_number_level_order number,

Line 206: p_child_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,

202: function create_child_dia_fk_table(
203: p_parent_level varchar2,
204: p_child_level varchar2,
205: p_parent_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
206: p_child_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
207: p_parent_pk_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
208: p_child_fk_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
209: p_number_level_order number,
210: p_ilog varchar2,

Line 207: p_parent_pk_order EDW_OWB_COLLECTION_UTIL.varcharTableType,

203: p_parent_level varchar2,
204: p_child_level varchar2,
205: p_parent_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
206: p_child_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
207: p_parent_pk_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
208: p_child_fk_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
209: p_number_level_order number,
210: p_ilog varchar2,
211: p_other_fks EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 208: p_child_fk_order EDW_OWB_COLLECTION_UTIL.varcharTableType,

204: p_child_level varchar2,
205: p_parent_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
206: p_child_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
207: p_parent_pk_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
208: p_child_fk_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
209: p_number_level_order number,
210: p_ilog varchar2,
211: p_other_fks EDW_OWB_COLLECTION_UTIL.varcharTableType,
212: p_below_diamond_flag EDW_OWB_COLLECTION_UTIL.booleanTableType,

Line 211: p_other_fks EDW_OWB_COLLECTION_UTIL.varcharTableType,

207: p_parent_pk_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
208: p_child_fk_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
209: p_number_level_order number,
210: p_ilog varchar2,
211: p_other_fks EDW_OWB_COLLECTION_UTIL.varcharTableType,
212: p_below_diamond_flag EDW_OWB_COLLECTION_UTIL.booleanTableType,
213: p_number_other_fks number,
214: p_diamond_fk_table out NOCOPY varchar2) return boolean ;
215: function check_level_for_column return boolean ;

Line 212: p_below_diamond_flag EDW_OWB_COLLECTION_UTIL.booleanTableType,

208: p_child_fk_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
209: p_number_level_order number,
210: p_ilog varchar2,
211: p_other_fks EDW_OWB_COLLECTION_UTIL.varcharTableType,
212: p_below_diamond_flag EDW_OWB_COLLECTION_UTIL.booleanTableType,
213: p_number_other_fks number,
214: p_diamond_fk_table out NOCOPY varchar2) return boolean ;
215: function check_level_for_column return boolean ;
216: function merge_all_ilog_tables return boolean ;