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_SUMMARY_COLLECT dependencies on EDW_OWB_COLLECTION_UTIL

Line 36: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;

32: g_number_rows_updated number;
33: g_number_rows_processed number;
34: g_dim_count number;
35: g_big_table number;--simply to demarcate a big table from a small table
36: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
37: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_levels_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_levels_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 37: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;

33: g_number_rows_processed number;
34: g_dim_count number;
35: g_big_table number;--simply to demarcate a big table from a small table
36: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
37: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_levels_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_levels_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 38: g_levels_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

34: g_dim_count number;
35: g_big_table number;--simply to demarcate a big table from a small table
36: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
37: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_levels_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_levels_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 39: g_levels_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;

35: g_big_table number;--simply to demarcate a big table from a small table
36: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
37: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_levels_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_levels_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
43: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 40: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;

36: g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
37: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_levels_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_levels_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
43: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
44: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 41: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;

37: g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_levels_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_levels_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
43: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
44: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
45: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 42: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;

38: g_levels_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_levels_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
43: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
44: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
45: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
46: g_number_levels integer;

Line 43: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;

39: g_levels_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
43: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
44: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
45: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
46: g_number_levels integer;
47: /*

Line 44: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;

40: g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
43: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
44: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
45: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
46: g_number_levels integer;
47: /*
48: store the format of child level, its alias, fk, parent, its alias and its pk

Line 45: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

41: g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
43: g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
44: g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
45: g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
46: g_number_levels integer;
47: /*
48: store the format of child level, its alias, fk, parent, its alias and its pk
49: */

Line 50: g_fk_pk_child_level EDW_OWB_COLLECTION_UTIL.varcharTableType;

46: g_number_levels integer;
47: /*
48: store the format of child level, its alias, fk, parent, its alias and its pk
49: */
50: g_fk_pk_child_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
51: g_fk_pk_child_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
52: g_fk_pk_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
53: g_fk_pk_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
54: g_fk_pk_parent_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 51: g_fk_pk_child_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;

47: /*
48: store the format of child level, its alias, fk, parent, its alias and its pk
49: */
50: g_fk_pk_child_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
51: g_fk_pk_child_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
52: g_fk_pk_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
53: g_fk_pk_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
54: g_fk_pk_parent_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
55: g_fk_pk_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 52: g_fk_pk_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;

48: store the format of child level, its alias, fk, parent, its alias and its pk
49: */
50: g_fk_pk_child_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
51: g_fk_pk_child_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
52: g_fk_pk_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
53: g_fk_pk_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
54: g_fk_pk_parent_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
55: g_fk_pk_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_fk_pk_number number;

Line 53: g_fk_pk_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;

49: */
50: g_fk_pk_child_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
51: g_fk_pk_child_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
52: g_fk_pk_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
53: g_fk_pk_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
54: g_fk_pk_parent_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
55: g_fk_pk_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_fk_pk_number number;
57:

Line 54: g_fk_pk_parent_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;

50: g_fk_pk_child_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
51: g_fk_pk_child_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
52: g_fk_pk_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
53: g_fk_pk_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
54: g_fk_pk_parent_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
55: g_fk_pk_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_fk_pk_number number;
57:
58: g_level_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 55: g_fk_pk_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

51: g_fk_pk_child_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
52: g_fk_pk_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
53: g_fk_pk_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
54: g_fk_pk_parent_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
55: g_fk_pk_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_fk_pk_number number;
57:
58: g_level_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;
59: g_level_primary_src EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 58: g_level_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;

54: g_fk_pk_parent_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
55: g_fk_pk_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_fk_pk_number number;
57:
58: g_level_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;
59: g_level_primary_src EDW_OWB_COLLECTION_UTIL.numberTableType;
60: g_level_primary_target EDW_OWB_COLLECTION_UTIL.numberTableType;
61: g_dim_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_level_name EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 59: g_level_primary_src EDW_OWB_COLLECTION_UTIL.numberTableType;

55: g_fk_pk_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_fk_pk_number number;
57:
58: g_level_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;
59: g_level_primary_src EDW_OWB_COLLECTION_UTIL.numberTableType;
60: g_level_primary_target EDW_OWB_COLLECTION_UTIL.numberTableType;
61: g_dim_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_level_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_level_col EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 60: g_level_primary_target EDW_OWB_COLLECTION_UTIL.numberTableType;

56: g_fk_pk_number number;
57:
58: g_level_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;
59: g_level_primary_src EDW_OWB_COLLECTION_UTIL.numberTableType;
60: g_level_primary_target EDW_OWB_COLLECTION_UTIL.numberTableType;
61: g_dim_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_level_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_level_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
64: g_number_mapping number;

Line 61: g_dim_col EDW_OWB_COLLECTION_UTIL.varcharTableType;

57:
58: g_level_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;
59: g_level_primary_src EDW_OWB_COLLECTION_UTIL.numberTableType;
60: g_level_primary_target EDW_OWB_COLLECTION_UTIL.numberTableType;
61: g_dim_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_level_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_level_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
64: g_number_mapping number;
65: g_flag boolean;

Line 62: g_level_name EDW_OWB_COLLECTION_UTIL.varcharTableType;

58: g_level_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;
59: g_level_primary_src EDW_OWB_COLLECTION_UTIL.numberTableType;
60: g_level_primary_target EDW_OWB_COLLECTION_UTIL.numberTableType;
61: g_dim_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_level_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_level_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
64: g_number_mapping number;
65: g_flag boolean;
66: g_dim_empty_flag boolean;

Line 63: g_level_col EDW_OWB_COLLECTION_UTIL.varcharTableType;

59: g_level_primary_src EDW_OWB_COLLECTION_UTIL.numberTableType;
60: g_level_primary_target EDW_OWB_COLLECTION_UTIL.numberTableType;
61: g_dim_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_level_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_level_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
64: g_number_mapping number;
65: g_flag boolean;
66: g_dim_empty_flag boolean;
67: g_all_level varchar2(500);

Line 77: g_slow_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;

73: g_status boolean;
74: g_status_message varchar2(4000);
75:
76: G_SLOW_IMPLEMENTED boolean;
77: g_slow_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
78: g_slow_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
79: g_slow_level_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
80: g_slow_level_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
81: g_number_slow_cols number;

Line 78: g_slow_level EDW_OWB_COLLECTION_UTIL.varcharTableType;

74: g_status_message varchar2(4000);
75:
76: G_SLOW_IMPLEMENTED boolean;
77: g_slow_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
78: g_slow_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
79: g_slow_level_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
80: g_slow_level_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
81: g_number_slow_cols number;
82:

Line 79: g_slow_level_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;

75:
76: G_SLOW_IMPLEMENTED boolean;
77: g_slow_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
78: g_slow_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
79: g_slow_level_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
80: g_slow_level_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
81: g_number_slow_cols number;
82:
83: g_seq_name varchar2(400);

Line 80: g_slow_level_col EDW_OWB_COLLECTION_UTIL.varcharTableType;

76: G_SLOW_IMPLEMENTED boolean;
77: g_slow_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
78: g_slow_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
79: g_slow_level_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
80: g_slow_level_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
81: g_number_slow_cols number;
82:
83: g_seq_name varchar2(400);
84:

Line 98: g_consider_snapshot EDW_OWB_COLLECTION_UTIL.booleanTableType;

94: g_forall_size number;
95: g_conc_id number;
96: g_conc_name varchar2(400);
97: g_object_type varchar2(200);
98: g_consider_snapshot EDW_OWB_COLLECTION_UTIL.booleanTableType;
99: g_slow_is_name varchar2(400); --name of the itemset containing the columns for the slow change dim
100: g_lowest_level varchar2(400);
101: g_lowest_level_index number;
102: g_lowest_level_global varchar2(400);

Line 126: g_levels_I EDW_OWB_COLLECTION_UTIL.varcharTableType; /*to enhance perf of insert into ilog, we

122: g_where_snplog_stmt_ilog varchar2(30000);
123: g_update_star_flag boolean;
124: g_insert_star_flag boolean;
125:
126: g_levels_I EDW_OWB_COLLECTION_UTIL.varcharTableType; /*to enhance perf of insert into ilog, we
127: first create copy of the LTC table with only the rowid, pk and fk. these hold the names*/
128: g_levels_copy EDW_OWB_COLLECTION_UTIL.varcharTableType; /*these hold the changes records from the
129: level tables that need to be denormalized*/
130: g_snplogs_L EDW_OWB_COLLECTION_UTIL.varcharTableType;/* similarly for the snapshot logs*/

Line 128: g_levels_copy EDW_OWB_COLLECTION_UTIL.varcharTableType; /*these hold the changes records from the

124: g_insert_star_flag boolean;
125:
126: g_levels_I EDW_OWB_COLLECTION_UTIL.varcharTableType; /*to enhance perf of insert into ilog, we
127: first create copy of the LTC table with only the rowid, pk and fk. these hold the names*/
128: g_levels_copy EDW_OWB_COLLECTION_UTIL.varcharTableType; /*these hold the changes records from the
129: level tables that need to be denormalized*/
130: g_snplogs_L EDW_OWB_COLLECTION_UTIL.varcharTableType;/* similarly for the snapshot logs*/
131: g_snplogs_LT EDW_OWB_COLLECTION_UTIL.varcharTableType;/* similarly for the snapshot logs, temp*/
132: g_considered_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;/* If a parent level is considered to see if

Line 130: g_snplogs_L EDW_OWB_COLLECTION_UTIL.varcharTableType;/* similarly for the snapshot logs*/

126: g_levels_I EDW_OWB_COLLECTION_UTIL.varcharTableType; /*to enhance perf of insert into ilog, we
127: first create copy of the LTC table with only the rowid, pk and fk. these hold the names*/
128: g_levels_copy EDW_OWB_COLLECTION_UTIL.varcharTableType; /*these hold the changes records from the
129: level tables that need to be denormalized*/
130: g_snplogs_L EDW_OWB_COLLECTION_UTIL.varcharTableType;/* similarly for the snapshot logs*/
131: g_snplogs_LT EDW_OWB_COLLECTION_UTIL.varcharTableType;/* similarly for the snapshot logs, temp*/
132: g_considered_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;/* If a parent level is considered to see if
133: any rowids of the child need to go, it need not be considered in any other hierarchy again.*/
134: g_number_considered_parent number;

Line 131: g_snplogs_LT EDW_OWB_COLLECTION_UTIL.varcharTableType;/* similarly for the snapshot logs, temp*/

127: first create copy of the LTC table with only the rowid, pk and fk. these hold the names*/
128: g_levels_copy EDW_OWB_COLLECTION_UTIL.varcharTableType; /*these hold the changes records from the
129: level tables that need to be denormalized*/
130: g_snplogs_L EDW_OWB_COLLECTION_UTIL.varcharTableType;/* similarly for the snapshot logs*/
131: g_snplogs_LT EDW_OWB_COLLECTION_UTIL.varcharTableType;/* similarly for the snapshot logs, temp*/
132: g_considered_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;/* If a parent level is considered to see if
133: any rowids of the child need to go, it need not be considered in any other hierarchy again.*/
134: g_number_considered_parent number;
135: g_level_change boolean;--means the same as incremental collection

Line 132: g_considered_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;/* If a parent level is considered to see if

128: g_levels_copy EDW_OWB_COLLECTION_UTIL.varcharTableType; /*these hold the changes records from the
129: level tables that need to be denormalized*/
130: g_snplogs_L EDW_OWB_COLLECTION_UTIL.varcharTableType;/* similarly for the snapshot logs*/
131: g_snplogs_LT EDW_OWB_COLLECTION_UTIL.varcharTableType;/* similarly for the snapshot logs, temp*/
132: g_considered_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;/* If a parent level is considered to see if
133: any rowids of the child need to go, it need not be considered in any other hierarchy again.*/
134: g_number_considered_parent number;
135: g_level_change boolean;--means the same as incremental collection
136:

Line 138: g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;

134: g_number_considered_parent number;
135: g_level_change boolean;--means the same as incremental collection
136:
137: ------skipping-------------------------------------
138: g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
139: g_number_skip_cols number;
140: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;
141: ---------------------------------------------------
142: g_load_pk number;

Line 140: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;

136:
137: ------skipping-------------------------------------
138: g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
139: g_number_skip_cols number;
140: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;
141: ---------------------------------------------------
142: g_load_pk number;
143: g_dim_next_extent number;--storage parameter
144: g_fresh_restart boolean;

Line 147: g_dim_derv_col EDW_OWB_COLLECTION_UTIL.varcharTableType;

143: g_dim_next_extent number;--storage parameter
144: g_fresh_restart boolean;
145: g_op_table_space varchar2(400);
146: g_rollback varchar2(400);
147: g_dim_derv_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
148: g_dim_derv_col_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;--the corresponding ltc table
149: g_dim_derv_col_map EDW_OWB_COLLECTION_UTIL.numberTableType;
150: g_number_dim_derv_col number;
151: g_dim_derv_col_map_all EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 148: g_dim_derv_col_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;--the corresponding ltc table

144: g_fresh_restart boolean;
145: g_op_table_space varchar2(400);
146: g_rollback varchar2(400);
147: g_dim_derv_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
148: g_dim_derv_col_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;--the corresponding ltc table
149: g_dim_derv_col_map EDW_OWB_COLLECTION_UTIL.numberTableType;
150: g_number_dim_derv_col number;
151: g_dim_derv_col_map_all EDW_OWB_COLLECTION_UTIL.numberTableType;
152: g_num_dim_derv_col_map_all number;

Line 149: g_dim_derv_col_map EDW_OWB_COLLECTION_UTIL.numberTableType;

145: g_op_table_space varchar2(400);
146: g_rollback varchar2(400);
147: g_dim_derv_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
148: g_dim_derv_col_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;--the corresponding ltc table
149: g_dim_derv_col_map EDW_OWB_COLLECTION_UTIL.numberTableType;
150: g_number_dim_derv_col number;
151: g_dim_derv_col_map_all EDW_OWB_COLLECTION_UTIL.numberTableType;
152: g_num_dim_derv_col_map_all number;
153: g_dim_derv_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;--what pk_key is needed for higher levels.

Line 151: g_dim_derv_col_map_all EDW_OWB_COLLECTION_UTIL.numberTableType;

147: g_dim_derv_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
148: g_dim_derv_col_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;--the corresponding ltc table
149: g_dim_derv_col_map EDW_OWB_COLLECTION_UTIL.numberTableType;
150: g_number_dim_derv_col number;
151: g_dim_derv_col_map_all EDW_OWB_COLLECTION_UTIL.numberTableType;
152: g_num_dim_derv_col_map_all number;
153: g_dim_derv_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;--what pk_key is needed for higher levels.
154: g_number_dim_derv_pk_key number;
155: g_dim_derv_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 153: g_dim_derv_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;--what pk_key is needed for higher levels.

149: g_dim_derv_col_map EDW_OWB_COLLECTION_UTIL.numberTableType;
150: g_number_dim_derv_col number;
151: g_dim_derv_col_map_all EDW_OWB_COLLECTION_UTIL.numberTableType;
152: g_num_dim_derv_col_map_all number;
153: g_dim_derv_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;--what pk_key is needed for higher levels.
154: g_number_dim_derv_pk_key number;
155: g_dim_derv_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;
156: g_derv_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
157: g_derv_fact_full_id EDW_OWB_COLLECTION_UTIL.numberTableType;--for full refresh

Line 155: g_dim_derv_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;

151: g_dim_derv_col_map_all EDW_OWB_COLLECTION_UTIL.numberTableType;
152: g_num_dim_derv_col_map_all number;
153: g_dim_derv_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;--what pk_key is needed for higher levels.
154: g_number_dim_derv_pk_key number;
155: g_dim_derv_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;
156: g_derv_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
157: g_derv_fact_full_id EDW_OWB_COLLECTION_UTIL.numberTableType;--for full refresh
158: g_number_derv_fact_full_id number;
159: g_src_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 156: g_derv_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;

152: g_num_dim_derv_col_map_all number;
153: g_dim_derv_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;--what pk_key is needed for higher levels.
154: g_number_dim_derv_pk_key number;
155: g_dim_derv_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;
156: g_derv_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
157: g_derv_fact_full_id EDW_OWB_COLLECTION_UTIL.numberTableType;--for full refresh
158: g_number_derv_fact_full_id number;
159: g_src_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
160: g_dim_derv_map_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType;

Line 157: g_derv_fact_full_id EDW_OWB_COLLECTION_UTIL.numberTableType;--for full refresh

153: g_dim_derv_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;--what pk_key is needed for higher levels.
154: g_number_dim_derv_pk_key number;
155: g_dim_derv_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;
156: g_derv_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
157: g_derv_fact_full_id EDW_OWB_COLLECTION_UTIL.numberTableType;--for full refresh
158: g_number_derv_fact_full_id number;
159: g_src_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
160: g_dim_derv_map_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType;
161: g_dim_derv_map_full_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType; --does it need full refresh

Line 159: g_src_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;

155: g_dim_derv_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;
156: g_derv_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
157: g_derv_fact_full_id EDW_OWB_COLLECTION_UTIL.numberTableType;--for full refresh
158: g_number_derv_fact_full_id number;
159: g_src_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
160: g_dim_derv_map_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType;
161: g_dim_derv_map_full_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType; --does it need full refresh
162: g_number_dim_derv_map_id number;
163: g_before_update_table EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 160: g_dim_derv_map_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType;

156: g_derv_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
157: g_derv_fact_full_id EDW_OWB_COLLECTION_UTIL.numberTableType;--for full refresh
158: g_number_derv_fact_full_id number;
159: g_src_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
160: g_dim_derv_map_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType;
161: g_dim_derv_map_full_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType; --does it need full refresh
162: g_number_dim_derv_map_id number;
163: g_before_update_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
164: g_before_update_table_final varchar2(80);--passed to children

Line 161: g_dim_derv_map_full_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType; --does it need full refresh

157: g_derv_fact_full_id EDW_OWB_COLLECTION_UTIL.numberTableType;--for full refresh
158: g_number_derv_fact_full_id number;
159: g_src_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
160: g_dim_derv_map_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType;
161: g_dim_derv_map_full_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType; --does it need full refresh
162: g_number_dim_derv_map_id number;
163: g_before_update_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
164: g_before_update_table_final varchar2(80);--passed to children
165: g_number_before_update_table number;

Line 163: g_before_update_table EDW_OWB_COLLECTION_UTIL.varcharTableType;

159: g_src_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
160: g_dim_derv_map_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType;
161: g_dim_derv_map_full_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType; --does it need full refresh
162: g_number_dim_derv_map_id number;
163: g_before_update_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
164: g_before_update_table_final varchar2(80);--passed to children
165: g_number_before_update_table number;
166: g_before_update_table_name varchar2(200);
167: g_before_update_load_pk number;

Line 182: g_consider_level EDW_OWB_COLLECTION_UTIL.booleanTableType;

178: g_type_ilog_generation varchar2(400);
179: g_skip_ilog_update boolean;
180: g_ilog_small varchar2(400);
181: g_ll_snplog_has_pk boolean;--does the lowest level snapshot log have the pk_key column in it
182: g_consider_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
183: g_consider_col EDW_OWB_COLLECTION_UTIL.booleanTableType;--which cols in the dimension to consider.if there is
184: --no change to the levels, then why consider those cols
185: g_insert_stmt_nopk_ins varchar2(32000);--insert for all cols except the pk and user pk
186: g_select_stmt_ins varchar2(32000);

Line 183: g_consider_col EDW_OWB_COLLECTION_UTIL.booleanTableType;--which cols in the dimension to consider.if there is

179: g_skip_ilog_update boolean;
180: g_ilog_small varchar2(400);
181: g_ll_snplog_has_pk boolean;--does the lowest level snapshot log have the pk_key column in it
182: g_consider_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
183: g_consider_col EDW_OWB_COLLECTION_UTIL.booleanTableType;--which cols in the dimension to consider.if there is
184: --no change to the levels, then why consider those cols
185: g_insert_stmt_nopk_ins varchar2(32000);--insert for all cols except the pk and user pk
186: g_select_stmt_ins varchar2(32000);
187: g_select_stmt_nopk_ins varchar2(32000);--select from all ltc but no pk and user pk

Line 192: g_use_ltc_ilog EDW_OWB_COLLECTION_UTIL.booleanTableType;

188: g_from_stmt_ins varchar2(32000);
189: g_from_stmt_global_ins varchar2(32000);
190: g_where_stmt_ins varchar2(32000);
191: g_called_ltc_ilog_create boolean;
192: g_use_ltc_ilog EDW_OWB_COLLECTION_UTIL.booleanTableType;
193: g_src_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
194: g_src_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
195: g_number_src_fk_table number;
196: g_ltc_merge_use_nl boolean;

Line 193: g_src_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;

189: g_from_stmt_global_ins varchar2(32000);
190: g_where_stmt_ins varchar2(32000);
191: g_called_ltc_ilog_create boolean;
192: g_use_ltc_ilog EDW_OWB_COLLECTION_UTIL.booleanTableType;
193: g_src_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
194: g_src_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
195: g_number_src_fk_table number;
196: g_ltc_merge_use_nl boolean;
197: g_hold_insert_stmt_row varchar2(32000);

Line 194: g_src_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;

190: g_where_stmt_ins varchar2(32000);
191: g_called_ltc_ilog_create boolean;
192: g_use_ltc_ilog EDW_OWB_COLLECTION_UTIL.booleanTableType;
193: g_src_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
194: g_src_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
195: g_number_src_fk_table number;
196: g_ltc_merge_use_nl boolean;
197: g_hold_insert_stmt_row varchar2(32000);
198: g_from_stmt_hd_row varchar2(8000);

Line 204: g_objects_to_drop EDW_OWB_COLLECTION_UTIL.varcharTableType;

200: g_insert_stmt_star_row varchar2(32000);
201: g_from_stmt_ins_row varchar2(8000);
202: g_dim_inc_refresh_derv boolean;
203: g_check_fk_change boolean;
204: g_objects_to_drop EDW_OWB_COLLECTION_UTIL.varcharTableType;
205: g_number_objects_to_drop number;
206: g_ok_switch_update number; --when to swith to update for ok table
207: g_join_nl_percentage number;--below this %, create index to help NL
208: G_MIN_JOB_LOAD_SIZE number;

Line 213: g_level_count EDW_OWB_COLLECTION_UTIL.numberTableType;--number of rows in the level tables

209: G_SLEEP_TIME number;
210: G_HASH_AREA_SIZE number;
211: G_SORT_AREA_SIZE number;
212: G_TRACE boolean;
213: g_level_count EDW_OWB_COLLECTION_UTIL.numberTableType;--number of rows in the level tables
214: g_analyze_freq number;
215: g_parallel_drill_down boolean;
216: g_dd_status_table varchar2(100);
217: procedure collect_dimension(

Line 221: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,

217: procedure collect_dimension(
218: p_conc_id number,
219: p_conc_name varchar2,
220: p_dim_name varchar2,
221: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
222: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
223: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
224: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
225: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 222: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,

218: p_conc_id number,
219: p_conc_name varchar2,
220: p_dim_name varchar2,
221: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
222: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
223: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
224: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
225: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
226: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 223: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,

219: p_conc_name varchar2,
220: p_dim_name varchar2,
221: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
222: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
223: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
224: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
225: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
226: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
227: p_number_levels number,

Line 224: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,

220: p_dim_name varchar2,
221: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
222: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
223: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
224: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
225: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
226: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
227: p_number_levels number,
228: p_debug boolean,

Line 225: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,

221: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
222: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
223: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
224: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
225: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
226: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
227: p_number_levels number,
228: p_debug boolean,
229: p_exec_flag boolean,

Line 226: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,

222: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
223: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
224: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
225: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
226: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
227: p_number_levels number,
228: p_debug boolean,
229: p_exec_flag boolean,
230: p_bis_owner varchar2,

Line 236: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,

232: p_collection_size number,
233: p_table_owner varchar2,
234: p_forall_size number,
235: p_update_type varchar2,
236: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
237: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
238: p_number_skip_cols number,
239: p_load_pk number,
240: p_fresh_restart boolean,

Line 237: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

233: p_table_owner varchar2,
234: p_forall_size number,
235: p_update_type varchar2,
236: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
237: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
238: p_number_skip_cols number,
239: p_load_pk number,
240: p_fresh_restart boolean,
241: p_op_table_space varchar2,

Line 351: p_affected_levels out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,

347: function execute_insert_stmt return boolean ;
348: function reset_temp_opcode return boolean;
349: function find_all_affected_levels(
350: p_job_id number,
351: p_affected_levels out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
352: p_number_affected_levels out NOCOPY number) return boolean ;
353: function get_parent(p_child_level varchar2,p_parent_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType,
354: p_child_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType, p_number_hier number,
355: p_parent out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType, p_number_parent out NOCOPY number) return boolean ;

Line 353: function get_parent(p_child_level varchar2,p_parent_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType,

349: function find_all_affected_levels(
350: p_job_id number,
351: p_affected_levels out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
352: p_number_affected_levels out NOCOPY number) return boolean ;
353: function get_parent(p_child_level varchar2,p_parent_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType,
354: p_child_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType, p_number_hier number,
355: p_parent out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType, p_number_parent out NOCOPY number) return boolean ;
356: function set_g_type_ilog_generation return boolean;
357: function log_pk_into_insert_prot return boolean ;

Line 354: p_child_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType, p_number_hier number,

350: p_job_id number,
351: p_affected_levels out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
352: p_number_affected_levels out NOCOPY number) return boolean ;
353: function get_parent(p_child_level varchar2,p_parent_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType,
354: p_child_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType, p_number_hier number,
355: p_parent out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType, p_number_parent out NOCOPY number) return boolean ;
356: function set_g_type_ilog_generation return boolean;
357: function log_pk_into_insert_prot return boolean ;
358: function log_pk_into_bu_insert_prot return boolean ;

Line 355: p_parent out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType, p_number_parent out NOCOPY number) return boolean ;

351: p_affected_levels out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
352: p_number_affected_levels out NOCOPY number) return boolean ;
353: function get_parent(p_child_level varchar2,p_parent_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType,
354: p_child_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType, p_number_hier number,
355: p_parent out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType, p_number_parent out NOCOPY number) return boolean ;
356: function set_g_type_ilog_generation return boolean;
357: function log_pk_into_insert_prot return boolean ;
358: function log_pk_into_bu_insert_prot return boolean ;
359: function get_before_update_table_name return boolean;

Line 371: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,

367: procedure collect_dimension_main(
368: p_conc_id number,
369: p_conc_name varchar2,
370: p_dim_name varchar2,
371: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
372: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
373: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
374: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
375: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 372: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,

368: p_conc_id number,
369: p_conc_name varchar2,
370: p_dim_name varchar2,
371: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
372: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
373: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
374: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
375: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
376: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 373: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,

369: p_conc_name varchar2,
370: p_dim_name varchar2,
371: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
372: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
373: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
374: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
375: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
376: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
377: p_number_levels number,

Line 374: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,

370: p_dim_name varchar2,
371: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
372: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
373: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
374: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
375: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
376: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
377: p_number_levels number,
378: p_debug boolean,

Line 375: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,

371: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
372: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
373: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
374: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
375: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
376: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
377: p_number_levels number,
378: p_debug boolean,
379: p_exec_flag boolean,

Line 376: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,

372: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
373: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
374: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
375: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
376: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
377: p_number_levels number,
378: p_debug boolean,
379: p_exec_flag boolean,
380: p_bis_owner varchar2,

Line 386: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,

382: p_collection_size number,
383: p_table_owner varchar2,
384: p_forall_size number,
385: p_update_type varchar2,
386: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
387: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
388: p_number_skip_cols number,
389: p_load_pk number,
390: p_fresh_restart boolean,

Line 387: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

383: p_table_owner varchar2,
384: p_forall_size number,
385: p_update_type varchar2,
386: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
387: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
388: p_number_skip_cols number,
389: p_load_pk number,
390: p_fresh_restart boolean,
391: p_op_table_space varchar2,

Line 416: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,

412: procedure collect_dimension_multi_thread(
413: p_conc_id number,
414: p_conc_name varchar2,
415: p_dim_name varchar2,
416: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
417: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
418: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
419: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
420: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 417: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,

413: p_conc_id number,
414: p_conc_name varchar2,
415: p_dim_name varchar2,
416: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
417: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
418: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
419: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
420: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
421: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 418: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,

414: p_conc_name varchar2,
415: p_dim_name varchar2,
416: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
417: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
418: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
419: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
420: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
421: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
422: p_number_levels number,

Line 419: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,

415: p_dim_name varchar2,
416: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
417: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
418: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
419: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
420: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
421: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
422: p_number_levels number,
423: p_debug boolean,

Line 420: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,

416: p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
417: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
418: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
419: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
420: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
421: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
422: p_number_levels number,
423: p_debug boolean,
424: p_exec_flag boolean,

Line 421: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,

417: p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
418: p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
419: p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
420: p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
421: p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
422: p_number_levels number,
423: p_debug boolean,
424: p_exec_flag boolean,
425: p_bis_owner varchar2,

Line 431: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,

427: p_collection_size number,
428: p_table_owner varchar2,
429: p_forall_size number,
430: p_update_type varchar2,
431: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
432: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
433: p_number_skip_cols number,
434: p_load_pk number,
435: p_fresh_restart boolean,

Line 432: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

428: p_table_owner varchar2,
429: p_forall_size number,
430: p_update_type varchar2,
431: p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
432: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
433: p_number_skip_cols number,
434: p_load_pk number,
435: p_fresh_restart boolean,
436: p_op_table_space varchar2,