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

Line 28: g_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;

24: g_debug boolean;
25: g_ok_low_end number;
26: g_ok_high_end number;
27: g_main_ok_table_name varchar2(80);
28: g_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;
29: g_dimTableName_kl EDW_OWB_COLLECTION_UTIL.varcharTableType; --key lookup. used for representing the key look up
30: --table (facts and slowly changing dims)
31: g_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;
32: g_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 29: g_dimTableName_kl EDW_OWB_COLLECTION_UTIL.varcharTableType; --key lookup. used for representing the key look up

25: g_ok_low_end number;
26: g_ok_high_end number;
27: g_main_ok_table_name varchar2(80);
28: g_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;
29: g_dimTableName_kl EDW_OWB_COLLECTION_UTIL.varcharTableType; --key lookup. used for representing the key look up
30: --table (facts and slowly changing dims)
31: g_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;
32: g_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
33: g_dimActualPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 31: g_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;

27: g_main_ok_table_name varchar2(80);
28: g_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;
29: g_dimTableName_kl EDW_OWB_COLLECTION_UTIL.varcharTableType; --key lookup. used for representing the key look up
30: --table (facts and slowly changing dims)
31: g_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;
32: g_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
33: g_dimActualPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
34: g_job_status_table varchar2(80);--used to communicate between main thread and child threads
35: g_jobid_stmt varchar2(80);

Line 32: g_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;

28: g_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;
29: g_dimTableName_kl EDW_OWB_COLLECTION_UTIL.varcharTableType; --key lookup. used for representing the key look up
30: --table (facts and slowly changing dims)
31: g_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;
32: g_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
33: g_dimActualPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
34: g_job_status_table varchar2(80);--used to communicate between main thread and child threads
35: g_jobid_stmt varchar2(80);
36: --the sequences

Line 33: g_dimActualPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;

29: g_dimTableName_kl EDW_OWB_COLLECTION_UTIL.varcharTableType; --key lookup. used for representing the key look up
30: --table (facts and slowly changing dims)
31: g_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;
32: g_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
33: g_dimActualPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
34: g_job_status_table varchar2(80);--used to communicate between main thread and child threads
35: g_jobid_stmt varchar2(80);
36: --the sequences
37: g_sequence EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 37: g_sequence EDW_OWB_COLLECTION_UTIL.varcharTableType;

33: g_dimActualPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
34: g_job_status_table varchar2(80);--used to communicate between main thread and child threads
35: g_jobid_stmt varchar2(80);
36: --the sequences
37: g_sequence EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_sequence_id EDW_OWB_COLLECTION_UTIL.numberTableType;
39: g_number_sequence number:=1;
40:
41: g_fstgUserFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 38: g_sequence_id EDW_OWB_COLLECTION_UTIL.numberTableType;

34: g_job_status_table varchar2(80);--used to communicate between main thread and child threads
35: g_jobid_stmt varchar2(80);
36: --the sequences
37: g_sequence EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_sequence_id EDW_OWB_COLLECTION_UTIL.numberTableType;
39: g_number_sequence number:=1;
40:
41: g_fstgUserFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_fstgActualFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 41: g_fstgUserFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;

37: g_sequence EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_sequence_id EDW_OWB_COLLECTION_UTIL.numberTableType;
39: g_number_sequence number:=1;
40:
41: g_fstgUserFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_fstgActualFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
43: g_fstg_fk_direct_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if fk_key is populated by the push program,
44: g_fstg_all_fk_direct_load boolean; --true if all fks are direct load
45: --this is true else false and we need to look up and generate the surr key

Line 42: g_fstgActualFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;

38: g_sequence_id EDW_OWB_COLLECTION_UTIL.numberTableType;
39: g_number_sequence number:=1;
40:
41: g_fstgUserFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_fstgActualFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
43: g_fstg_fk_direct_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if fk_key is populated by the push program,
44: g_fstg_all_fk_direct_load boolean; --true if all fks are direct load
45: --this is true else false and we need to look up and generate the surr key
46: g_fstg_fk_value_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a value needs to be directly loaded like edwna

Line 43: g_fstg_fk_direct_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if fk_key is populated by the push program,

39: g_number_sequence number:=1;
40:
41: g_fstgUserFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_fstgActualFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
43: g_fstg_fk_direct_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if fk_key is populated by the push program,
44: g_fstg_all_fk_direct_load boolean; --true if all fks are direct load
45: --this is true else false and we need to look up and generate the surr key
46: g_fstg_fk_value_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a value needs to be directly loaded like edwna
47: g_fstg_fk_load_value EDW_OWB_COLLECTION_UTIL.varcharTableType;--the value to load

Line 46: g_fstg_fk_value_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a value needs to be directly loaded like edwna

42: g_fstgActualFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
43: g_fstg_fk_direct_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if fk_key is populated by the push program,
44: g_fstg_all_fk_direct_load boolean; --true if all fks are direct load
45: --this is true else false and we need to look up and generate the surr key
46: g_fstg_fk_value_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a value needs to be directly loaded like edwna
47: g_fstg_fk_load_value EDW_OWB_COLLECTION_UTIL.varcharTableType;--the value to load
48:
49: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a column needs to be skipped
50: --g_number_skip_item number;

Line 47: g_fstg_fk_load_value EDW_OWB_COLLECTION_UTIL.varcharTableType;--the value to load

43: g_fstg_fk_direct_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if fk_key is populated by the push program,
44: g_fstg_all_fk_direct_load boolean; --true if all fks are direct load
45: --this is true else false and we need to look up and generate the surr key
46: g_fstg_fk_value_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a value needs to be directly loaded like edwna
47: g_fstg_fk_load_value EDW_OWB_COLLECTION_UTIL.varcharTableType;--the value to load
48:
49: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a column needs to be skipped
50: --g_number_skip_item number;
51: g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 49: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a column needs to be skipped

45: --this is true else false and we need to look up and generate the surr key
46: g_fstg_fk_value_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a value needs to be directly loaded like edwna
47: g_fstg_fk_load_value EDW_OWB_COLLECTION_UTIL.varcharTableType;--the value to load
48:
49: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a column needs to be skipped
50: --g_number_skip_item number;
51: g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
52: g_number_skip_cols number;
53: g_fact_count number;

Line 51: g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;

47: g_fstg_fk_load_value EDW_OWB_COLLECTION_UTIL.varcharTableType;--the value to load
48:
49: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a column needs to be skipped
50: --g_number_skip_item number;
51: g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
52: g_number_skip_cols number;
53: g_fact_count number;
54: g_factFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
55: g_numberOfDimTables number:=1;

Line 54: g_factFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;

50: --g_number_skip_item number;
51: g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
52: g_number_skip_cols number;
53: g_fact_count number;
54: g_factFKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
55: g_numberOfDimTables number:=1;
56: --g_numberOfDimTables should be the number of
57: --fk mappings because even if we have 2 fks to time
58: --dim, there will be 2 usages of time dim

Line 61: g_fstg_mapping_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;

57: --fk mappings because even if we have 2 fks to time
58: --dim, there will be 2 usages of time dim
59:
60: --the mapping. only the measures. and PKs. FKs have already been taken care of...
61: g_fstg_mapping_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_fact_mapping_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_num_ff_map_cols number:=1;
64: g_number_groupby_cols number;
65: G_GROUPBY_COLS EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 62: g_fact_mapping_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;

58: --dim, there will be 2 usages of time dim
59:
60: --the mapping. only the measures. and PKs. FKs have already been taken care of...
61: g_fstg_mapping_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_fact_mapping_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_num_ff_map_cols number:=1;
64: g_number_groupby_cols number;
65: G_GROUPBY_COLS EDW_OWB_COLLECTION_UTIL.varcharTableType;
66: g_update_type varchar2(400);--what scheme should update follow...mass, row by row, delete insert...

Line 65: G_GROUPBY_COLS EDW_OWB_COLLECTION_UTIL.varcharTableType;

61: g_fstg_mapping_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;
62: g_fact_mapping_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_num_ff_map_cols number:=1;
64: g_number_groupby_cols number;
65: G_GROUPBY_COLS EDW_OWB_COLLECTION_UTIL.varcharTableType;
66: g_update_type varchar2(400);--what scheme should update follow...mass, row by row, delete insert...
67: g_mode varchar2(400);
68: g_instance_type varchar2(400);
69:

Line 125: g_drop_objects EDW_OWB_COLLECTION_UTIL.varcharTableType;

121: g_ok_rowid_number number; --number of rows in g_ok_rowid_table
122: g_dup_insert_number number;--number of rows inserted into g_dup_table
123: g_collections_done boolean;--maeks when the collections are done
124: g_err_rec_flag boolean;
125: g_drop_objects EDW_OWB_COLLECTION_UTIL.varcharTableType;
126: g_number_drop_objects number;
127:
128: g_status boolean;
129: g_status_message varchar2(4000);

Line 139: g_item_audit EDW_OWB_COLLECTION_UTIL.varcharTableType;--the columns that are in audit for the fac

135: g_number_rows_processed number;
136: g_number_rows_ready number; --how many ready in each cycle
137: g_fact_audit boolean;
138: g_fact_net_change boolean;
139: g_item_audit EDW_OWB_COLLECTION_UTIL.varcharTableType;--the columns that are in audit for the fac
140: g_item_audit_number number;
141: g_item_audit_all EDW_OWB_COLLECTION_UTIL.varcharTableType;
142: g_item_audit_number_all number;
143:

Line 141: g_item_audit_all EDW_OWB_COLLECTION_UTIL.varcharTableType;

137: g_fact_audit boolean;
138: g_fact_net_change boolean;
139: g_item_audit EDW_OWB_COLLECTION_UTIL.varcharTableType;--the columns that are in audit for the fac
140: g_item_audit_number number;
141: g_item_audit_all EDW_OWB_COLLECTION_UTIL.varcharTableType;
142: g_item_audit_number_all number;
143:
144: g_item_net_change EDW_OWB_COLLECTION_UTIL.varcharTableType;--the columns that are in audit for the fac
145: g_item_net_change_number number;

Line 144: g_item_net_change EDW_OWB_COLLECTION_UTIL.varcharTableType;--the columns that are in audit for the fac

140: g_item_audit_number number;
141: g_item_audit_all EDW_OWB_COLLECTION_UTIL.varcharTableType;
142: g_item_audit_number_all number;
143:
144: g_item_net_change EDW_OWB_COLLECTION_UTIL.varcharTableType;--the columns that are in audit for the fac
145: g_item_net_change_number number;
146: g_item_net_change_all EDW_OWB_COLLECTION_UTIL.varcharTableType;
147: g_item_net_change_number_all number;
148:

Line 146: g_item_net_change_all EDW_OWB_COLLECTION_UTIL.varcharTableType;

142: g_item_audit_number_all number;
143:
144: g_item_net_change EDW_OWB_COLLECTION_UTIL.varcharTableType;--the columns that are in audit for the fac
145: g_item_net_change_number number;
146: g_item_net_change_all EDW_OWB_COLLECTION_UTIL.varcharTableType;
147: g_item_net_change_number_all number;
148:
149: g_fact_audit_name varchar2(400);
150: g_fact_net_change_name varchar2(400);

Line 153: g_fact_rowid EDW_OWB_COLLECTION_UTIL.rowidTableType;

149: g_fact_audit_name varchar2(400);
150: g_fact_net_change_name varchar2(400);
151: g_fact_audit_is_name varchar2(400); --the name of the item set
152: g_fact_net_change_is_name varchar2(400); --the name of the item set
153: g_fact_rowid EDW_OWB_COLLECTION_UTIL.rowidTableType;
154: g_number_fact_rowid number;
155: g_groupby_on boolean;
156: g_groupby_stmt varchar2(10000);
157: g_request_id_stmt varchar2(10000);

Line 159: g_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType; --the request ids in this collection

155: g_groupby_on boolean;
156: g_groupby_stmt varchar2(10000);
157: g_request_id_stmt varchar2(10000);
158:
159: g_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType; --the request ids in this collection
160: g_request_id_count EDW_OWB_COLLECTION_UTIL.numberTableType;--the count(*) for the req ids
161: g_number_request_id_table number;
162: g_total_records number;--the grand total of all the records to collect
163: g_target_rec_count number;

Line 160: g_request_id_count EDW_OWB_COLLECTION_UTIL.numberTableType;--the count(*) for the req ids

156: g_groupby_stmt varchar2(10000);
157: g_request_id_stmt varchar2(10000);
158:
159: g_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType; --the request ids in this collection
160: g_request_id_count EDW_OWB_COLLECTION_UTIL.numberTableType;--the count(*) for the req ids
161: g_number_request_id_table number;
162: g_total_records number;--the grand total of all the records to collect
163: g_target_rec_count number;
164: g_stg_join_nl_percentage number;

Line 173: g_ins_rows_ready EDW_OWB_COLLECTION_UTIL.numberTableType;

169: g_stg_copy_table varchar2(200);
170: g_stg_copy_table_flag boolean;
171: /*******************************************************/
172: /**************Record the number of rows processed and errors*****/
173: g_ins_rows_ready EDW_OWB_COLLECTION_UTIL.numberTableType;
174: g_ins_rows_processed EDW_OWB_COLLECTION_UTIL.numberTableType;
175: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
176: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
177: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 174: g_ins_rows_processed EDW_OWB_COLLECTION_UTIL.numberTableType;

170: g_stg_copy_table_flag boolean;
171: /*******************************************************/
172: /**************Record the number of rows processed and errors*****/
173: g_ins_rows_ready EDW_OWB_COLLECTION_UTIL.numberTableType;
174: g_ins_rows_processed EDW_OWB_COLLECTION_UTIL.numberTableType;
175: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
176: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
177: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
178: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 175: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;

171: /*******************************************************/
172: /**************Record the number of rows processed and errors*****/
173: g_ins_rows_ready EDW_OWB_COLLECTION_UTIL.numberTableType;
174: g_ins_rows_processed EDW_OWB_COLLECTION_UTIL.numberTableType;
175: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
176: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
177: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
178: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;
179: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 176: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;

172: /**************Record the number of rows processed and errors*****/
173: g_ins_rows_ready EDW_OWB_COLLECTION_UTIL.numberTableType;
174: g_ins_rows_processed EDW_OWB_COLLECTION_UTIL.numberTableType;
175: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
176: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
177: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
178: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;
179: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
180: g_ins_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 177: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;

173: g_ins_rows_ready EDW_OWB_COLLECTION_UTIL.numberTableType;
174: g_ins_rows_processed EDW_OWB_COLLECTION_UTIL.numberTableType;
175: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
176: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
177: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
178: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;
179: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
180: g_ins_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType;
181: g_ins_collection_status EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 178: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;

174: g_ins_rows_processed EDW_OWB_COLLECTION_UTIL.numberTableType;
175: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
176: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
177: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
178: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;
179: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
180: g_ins_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType;
181: g_ins_collection_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
182: g_number_ins_req_coll number;

Line 179: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;

175: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
176: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
177: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
178: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;
179: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
180: g_ins_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType;
181: g_ins_collection_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
182: g_number_ins_req_coll number;
183: g_instance_column varchar2(400);--this is the col that is either instance_fk or instance or instance_code

Line 180: g_ins_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType;

176: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
177: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
178: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;
179: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
180: g_ins_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType;
181: g_ins_collection_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
182: g_number_ins_req_coll number;
183: g_instance_column varchar2(400);--this is the col that is either instance_fk or instance or instance_code
184: g_instance_dim_name varchar2(400); --the instance dimension name

Line 181: g_ins_collection_status EDW_OWB_COLLECTION_UTIL.varcharTableType;

177: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
178: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;
179: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
180: g_ins_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType;
181: g_ins_collection_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
182: g_number_ins_req_coll number;
183: g_instance_column varchar2(400);--this is the col that is either instance_fk or instance or instance_code
184: g_instance_dim_name varchar2(400); --the instance dimension name
185: /*******************************************************/

Line 203: g_slow_change_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;

199: g_delete_flag boolean;
200: g_creation_date_flag boolean;
201: g_last_update_date_flag boolean;
202:
203: g_slow_change_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
204: g_num_slow_change_tables number;
205: g_exp_operation EDW_OWB_COLLECTION_UTIL.varcharTableType;
206: g_exp_object_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
207: g_exp_options EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 205: g_exp_operation EDW_OWB_COLLECTION_UTIL.varcharTableType;

201: g_last_update_date_flag boolean;
202:
203: g_slow_change_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
204: g_num_slow_change_tables number;
205: g_exp_operation EDW_OWB_COLLECTION_UTIL.varcharTableType;
206: g_exp_object_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
207: g_exp_options EDW_OWB_COLLECTION_UTIL.varcharTableType;
208: g_exp_cardinality EDW_OWB_COLLECTION_UTIL.numberTableType;
209: g_number_exp_plan number;

Line 206: g_exp_object_name EDW_OWB_COLLECTION_UTIL.varcharTableType;

202:
203: g_slow_change_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
204: g_num_slow_change_tables number;
205: g_exp_operation EDW_OWB_COLLECTION_UTIL.varcharTableType;
206: g_exp_object_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
207: g_exp_options EDW_OWB_COLLECTION_UTIL.varcharTableType;
208: g_exp_cardinality EDW_OWB_COLLECTION_UTIL.numberTableType;
209: g_number_exp_plan number;
210: g_fts_tables EDW_OWB_COLLECTION_UTIL.varcharTableType; --full table scan tables

Line 207: g_exp_options EDW_OWB_COLLECTION_UTIL.varcharTableType;

203: g_slow_change_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
204: g_num_slow_change_tables number;
205: g_exp_operation EDW_OWB_COLLECTION_UTIL.varcharTableType;
206: g_exp_object_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
207: g_exp_options EDW_OWB_COLLECTION_UTIL.varcharTableType;
208: g_exp_cardinality EDW_OWB_COLLECTION_UTIL.numberTableType;
209: g_number_exp_plan number;
210: g_fts_tables EDW_OWB_COLLECTION_UTIL.varcharTableType; --full table scan tables
211: g_number_fts_tables number;

Line 208: g_exp_cardinality EDW_OWB_COLLECTION_UTIL.numberTableType;

204: g_num_slow_change_tables number;
205: g_exp_operation EDW_OWB_COLLECTION_UTIL.varcharTableType;
206: g_exp_object_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
207: g_exp_options EDW_OWB_COLLECTION_UTIL.varcharTableType;
208: g_exp_cardinality EDW_OWB_COLLECTION_UTIL.numberTableType;
209: g_number_exp_plan number;
210: g_fts_tables EDW_OWB_COLLECTION_UTIL.varcharTableType; --full table scan tables
211: g_number_fts_tables number;
212: g_plan_table varchar2(400);

Line 210: g_fts_tables EDW_OWB_COLLECTION_UTIL.varcharTableType; --full table scan tables

206: g_exp_object_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
207: g_exp_options EDW_OWB_COLLECTION_UTIL.varcharTableType;
208: g_exp_cardinality EDW_OWB_COLLECTION_UTIL.numberTableType;
209: g_number_exp_plan number;
210: g_fts_tables EDW_OWB_COLLECTION_UTIL.varcharTableType; --full table scan tables
211: g_number_fts_tables number;
212: g_plan_table varchar2(400);
213: g_explain_plan_check boolean;
214: g_fact_audit_net_table varchar2(400);

Line 226: g_surr_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;

222: g_is_source boolean;
223: g_is_custom_source boolean;
224: g_is_delete_trigger_imp boolean;
225:
226: g_surr_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
227: g_number_surr_tables number;
228: g_surr_tables_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;--what fk is each holding
229: g_surr_tables_count EDW_OWB_COLLECTION_UTIL.numberTableType;
230:

Line 228: g_surr_tables_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;--what fk is each holding

224: g_is_delete_trigger_imp boolean;
225:
226: g_surr_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
227: g_number_surr_tables number;
228: g_surr_tables_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;--what fk is each holding
229: g_surr_tables_count EDW_OWB_COLLECTION_UTIL.numberTableType;
230:
231: g_dlog_rowid_table varchar2(400);
232: --g_update_dlog_rowid_table varchar2(400);

Line 229: g_surr_tables_count EDW_OWB_COLLECTION_UTIL.numberTableType;

225:
226: g_surr_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
227: g_number_surr_tables number;
228: g_surr_tables_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;--what fk is each holding
229: g_surr_tables_count EDW_OWB_COLLECTION_UTIL.numberTableType;
230:
231: g_dlog_rowid_table varchar2(400);
232: --g_update_dlog_rowid_table varchar2(400);
233: --g_update_dlog_hold_table varchar2(400);

Line 246: g_dlog_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;

242: g_load_type varchar2(400);--INITIAL or INC
243: g_ok_rowid_table_prev varchar2(400);
244: g_type_ok_generation varchar2(400);
245: g_skip_ilog_update boolean;
246: g_dlog_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;
247: g_number_dlog_columns number;
248: g_dlog_has_data boolean;
249: g_fresh_restart boolean;
250: g_op_table_space varchar2(400);

Line 259: g_smart_update_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;

255: g_skip_delete boolean;
256: g_smart_update boolean;
257: g_hold_table_temp varchar2(400);
258: g_smart_update_name varchar2(400);
259: g_smart_update_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
260: g_number_smart_update_cols number;
261: g_fact_next_extent number;
262: g_hold_table_count number;
263: g_skip_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 263: g_skip_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;

259: g_smart_update_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
260: g_number_smart_update_cols number;
261: g_fact_next_extent number;
262: g_hold_table_count number;
263: g_skip_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
264: g_number_skip_levels number;
265: g_number_rows_dangling number;
266: g_max_round number;
267: g_fk_use_nl number;

Line 269: g_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;

265: g_number_rows_dangling number;
266: g_max_round number;
267: g_fk_use_nl number;
268: g_fact_use_nl boolean;
269: g_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;
270: g_fact_smart_update number;
271: g_fks_dang_load EDW_OWB_COLLECTION_UTIL.varcharTableType;
272: g_number_fks_dang_load number;
273: g_dim_auto_dang_table EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 271: g_fks_dang_load EDW_OWB_COLLECTION_UTIL.varcharTableType;

267: g_fk_use_nl number;
268: g_fact_use_nl boolean;
269: g_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;
270: g_fact_smart_update number;
271: g_fks_dang_load EDW_OWB_COLLECTION_UTIL.varcharTableType;
272: g_number_fks_dang_load number;
273: g_dim_auto_dang_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
274: g_dim_auto_dang_table_dim varchar2(200);
275: g_dim_lowest_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 273: g_dim_auto_dang_table EDW_OWB_COLLECTION_UTIL.varcharTableType;

269: g_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;
270: g_fact_smart_update number;
271: g_fks_dang_load EDW_OWB_COLLECTION_UTIL.varcharTableType;
272: g_number_fks_dang_load number;
273: g_dim_auto_dang_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
274: g_dim_auto_dang_table_dim varchar2(200);
275: g_dim_lowest_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
276: g_dim_lowest_ltc_id EDW_OWB_COLLECTION_UTIL.numberTableType;
277: g_auto_dang_table_extn varchar2(40);

Line 275: g_dim_lowest_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;

271: g_fks_dang_load EDW_OWB_COLLECTION_UTIL.varcharTableType;
272: g_number_fks_dang_load number;
273: g_dim_auto_dang_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
274: g_dim_auto_dang_table_dim varchar2(200);
275: g_dim_lowest_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
276: g_dim_lowest_ltc_id EDW_OWB_COLLECTION_UTIL.numberTableType;
277: g_auto_dang_table_extn varchar2(40);
278: g_log_dang_keys boolean;
279: g_create_parent_table_records boolean;--in test mode do we create parent table records?

Line 276: g_dim_lowest_ltc_id EDW_OWB_COLLECTION_UTIL.numberTableType;

272: g_number_fks_dang_load number;
273: g_dim_auto_dang_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
274: g_dim_auto_dang_table_dim varchar2(200);
275: g_dim_lowest_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
276: g_dim_lowest_ltc_id EDW_OWB_COLLECTION_UTIL.numberTableType;
277: g_auto_dang_table_extn varchar2(40);
278: g_log_dang_keys boolean;
279: g_create_parent_table_records boolean;--in test mode do we create parent table records?
280: g_check_fk_change boolean;

Line 282: g_dim_pk_structure EDW_OWB_COLLECTION_UTIL.varcharTableType;

278: g_log_dang_keys boolean;
279: g_create_parent_table_records boolean;--in test mode do we create parent table records?
280: g_check_fk_change boolean;
281: -----------------------------------------------------------
282: g_dim_pk_structure EDW_OWB_COLLECTION_UTIL.varcharTableType;
283: g_dim_pk_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
284: g_dim_pk_instance EDW_OWB_COLLECTION_UTIL.varcharTableType;
285: g_number_dim_pk_structure number;
286: g_dim_pk_structure_index EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 283: g_dim_pk_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;

279: g_create_parent_table_records boolean;--in test mode do we create parent table records?
280: g_check_fk_change boolean;
281: -----------------------------------------------------------
282: g_dim_pk_structure EDW_OWB_COLLECTION_UTIL.varcharTableType;
283: g_dim_pk_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
284: g_dim_pk_instance EDW_OWB_COLLECTION_UTIL.varcharTableType;
285: g_number_dim_pk_structure number;
286: g_dim_pk_structure_index EDW_OWB_COLLECTION_UTIL.numberTableType;
287: g_dim_pk_structure_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 284: g_dim_pk_instance EDW_OWB_COLLECTION_UTIL.varcharTableType;

280: g_check_fk_change boolean;
281: -----------------------------------------------------------
282: g_dim_pk_structure EDW_OWB_COLLECTION_UTIL.varcharTableType;
283: g_dim_pk_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
284: g_dim_pk_instance EDW_OWB_COLLECTION_UTIL.varcharTableType;
285: g_number_dim_pk_structure number;
286: g_dim_pk_structure_index EDW_OWB_COLLECTION_UTIL.numberTableType;
287: g_dim_pk_structure_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
288: g_number_dim_pk_structure_cols number;

Line 286: g_dim_pk_structure_index EDW_OWB_COLLECTION_UTIL.numberTableType;

282: g_dim_pk_structure EDW_OWB_COLLECTION_UTIL.varcharTableType;
283: g_dim_pk_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
284: g_dim_pk_instance EDW_OWB_COLLECTION_UTIL.varcharTableType;
285: g_number_dim_pk_structure number;
286: g_dim_pk_structure_index EDW_OWB_COLLECTION_UTIL.numberTableType;
287: g_dim_pk_structure_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
288: g_number_dim_pk_structure_cols number;
289: -----------------------------------------------------------
290:

Line 287: g_dim_pk_structure_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;

283: g_dim_pk_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
284: g_dim_pk_instance EDW_OWB_COLLECTION_UTIL.varcharTableType;
285: g_number_dim_pk_structure number;
286: g_dim_pk_structure_index EDW_OWB_COLLECTION_UTIL.numberTableType;
287: g_dim_pk_structure_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
288: g_number_dim_pk_structure_cols number;
289: -----------------------------------------------------------
290:
291: ---------data alignment----------

Line 292: g_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;

288: g_number_dim_pk_structure_cols number;
289: -----------------------------------------------------------
290:
291: ---------data alignment----------
292: g_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
293: g_number_da_cols number;
294: g_stg_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;--corresponding stg columns
295: g_da_table varchar2(400);
296: g_da_op_table varchar2(400);--mother of all da op tables

Line 294: g_stg_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;--corresponding stg columns

290:
291: ---------data alignment----------
292: g_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
293: g_number_da_cols number;
294: g_stg_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;--corresponding stg columns
295: g_da_table varchar2(400);
296: g_da_op_table varchar2(400);--mother of all da op tables
297: g_pp_table varchar2(400);
298: g_master_instance varchar2(400);

Line 303: g_dimTable_da_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is data alignment implemented

299: g_pk_key_seq varchar2(400);
300: g_pk_key_seq_pos number;--position in the mapping
301: g_dup_pp_row_id_table varchar2(400);--row_ids from g_dup_table. will be used to populate g_dup_pp_table.
302: g_dup_pp_table varchar2(400);--will contain the rejected dup rows. will be used to populate pp table
303: g_dimTable_da_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is data alignment implemented
304: g_dimTableName_pp EDW_OWB_COLLECTION_UTIL.varcharTableType;--the pp table for data alignment
305: g_dimTableName_da EDW_OWB_COLLECTION_UTIL.varcharTableType;--the DA table for data alignment
306: g_dimTable_slow_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--if slowly chaging dim is implemented or not
307: ---------------------------------

Line 304: g_dimTableName_pp EDW_OWB_COLLECTION_UTIL.varcharTableType;--the pp table for data alignment

300: g_pk_key_seq_pos number;--position in the mapping
301: g_dup_pp_row_id_table varchar2(400);--row_ids from g_dup_table. will be used to populate g_dup_pp_table.
302: g_dup_pp_table varchar2(400);--will contain the rejected dup rows. will be used to populate pp table
303: g_dimTable_da_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is data alignment implemented
304: g_dimTableName_pp EDW_OWB_COLLECTION_UTIL.varcharTableType;--the pp table for data alignment
305: g_dimTableName_da EDW_OWB_COLLECTION_UTIL.varcharTableType;--the DA table for data alignment
306: g_dimTable_slow_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--if slowly chaging dim is implemented or not
307: ---------------------------------
308: g_use_mti boolean;--perf improvement with multi table insert for 9i

Line 305: g_dimTableName_da EDW_OWB_COLLECTION_UTIL.varcharTableType;--the DA table for data alignment

301: g_dup_pp_row_id_table varchar2(400);--row_ids from g_dup_table. will be used to populate g_dup_pp_table.
302: g_dup_pp_table varchar2(400);--will contain the rejected dup rows. will be used to populate pp table
303: g_dimTable_da_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is data alignment implemented
304: g_dimTableName_pp EDW_OWB_COLLECTION_UTIL.varcharTableType;--the pp table for data alignment
305: g_dimTableName_da EDW_OWB_COLLECTION_UTIL.varcharTableType;--the DA table for data alignment
306: g_dimTable_slow_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--if slowly chaging dim is implemented or not
307: ---------------------------------
308: g_use_mti boolean;--perf improvement with multi table insert for 9i
309: g_user_measure_table varchar2(400);

Line 306: g_dimTable_slow_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--if slowly chaging dim is implemented or not

302: g_dup_pp_table varchar2(400);--will contain the rejected dup rows. will be used to populate pp table
303: g_dimTable_da_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is data alignment implemented
304: g_dimTableName_pp EDW_OWB_COLLECTION_UTIL.varcharTableType;--the pp table for data alignment
305: g_dimTableName_da EDW_OWB_COLLECTION_UTIL.varcharTableType;--the DA table for data alignment
306: g_dimTable_slow_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--if slowly chaging dim is implemented or not
307: ---------------------------------
308: g_use_mti boolean;--perf improvement with multi table insert for 9i
309: g_user_measure_table varchar2(400);
310: g_user_measure_table_count number;

Line 311: g_fstg_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;

307: ---------------------------------
308: g_use_mti boolean;--perf improvement with multi table insert for 9i
309: g_user_measure_table varchar2(400);
310: g_user_measure_table_count number;
311: g_fstg_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;
312: g_number_fstg_columns number;
313: g_data_type edw_owb_collection_util.varcharTableType;
314: g_data_length edw_owb_collection_util.varcharTableType;
315: g_num_distinct edw_owb_collection_util.numberTableType;

Line 313: g_data_type edw_owb_collection_util.varcharTableType;

309: g_user_measure_table varchar2(400);
310: g_user_measure_table_count number;
311: g_fstg_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;
312: g_number_fstg_columns number;
313: g_data_type edw_owb_collection_util.varcharTableType;
314: g_data_length edw_owb_collection_util.varcharTableType;
315: g_num_distinct edw_owb_collection_util.numberTableType;
316: g_num_nulls edw_owb_collection_util.numberTableType;
317: g_avg_col_length edw_owb_collection_util.numberTableType;

Line 314: g_data_length edw_owb_collection_util.varcharTableType;

310: g_user_measure_table_count number;
311: g_fstg_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;
312: g_number_fstg_columns number;
313: g_data_type edw_owb_collection_util.varcharTableType;
314: g_data_length edw_owb_collection_util.varcharTableType;
315: g_num_distinct edw_owb_collection_util.numberTableType;
316: g_num_nulls edw_owb_collection_util.numberTableType;
317: g_avg_col_length edw_owb_collection_util.numberTableType;
318: ---------------------------------

Line 315: g_num_distinct edw_owb_collection_util.numberTableType;

311: g_fstg_columns EDW_OWB_COLLECTION_UTIL.varcharTableType;
312: g_number_fstg_columns number;
313: g_data_type edw_owb_collection_util.varcharTableType;
314: g_data_length edw_owb_collection_util.varcharTableType;
315: g_num_distinct edw_owb_collection_util.numberTableType;
316: g_num_nulls edw_owb_collection_util.numberTableType;
317: g_avg_col_length edw_owb_collection_util.numberTableType;
318: ---------------------------------
319: g_surr_count number;

Line 316: g_num_nulls edw_owb_collection_util.numberTableType;

312: g_number_fstg_columns number;
313: g_data_type edw_owb_collection_util.varcharTableType;
314: g_data_length edw_owb_collection_util.varcharTableType;
315: g_num_distinct edw_owb_collection_util.numberTableType;
316: g_num_nulls edw_owb_collection_util.numberTableType;
317: g_avg_col_length edw_owb_collection_util.numberTableType;
318: ---------------------------------
319: g_surr_count number;
320: g_int_upd_status_table_name varchar2(40);

Line 317: g_avg_col_length edw_owb_collection_util.numberTableType;

313: g_data_type edw_owb_collection_util.varcharTableType;
314: g_data_length edw_owb_collection_util.varcharTableType;
315: g_num_distinct edw_owb_collection_util.numberTableType;
316: g_num_nulls edw_owb_collection_util.numberTableType;
317: g_avg_col_length edw_owb_collection_util.numberTableType;
318: ---------------------------------
319: g_surr_count number;
320: g_int_upd_status_table_name varchar2(40);
321: g_job_queue_processes number;

Line 361: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

357: p_fact_dlog varchar2,
358: p_key_set number,
359: p_instance_type varchar2,
360: p_load_pk number,
361: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
362: p_number_skip_cols number,
363: p_fresh_restart boolean,
364: p_op_table_space varchar2,
365: p_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 365: p_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

361: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
362: p_number_skip_cols number,
363: p_fresh_restart boolean,
364: p_op_table_space varchar2,
365: p_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
366: p_number_da_cols number,
367: p_da_table varchar2,
368: p_pp_table varchar2,
369: p_master_instance varchar2,

Line 371: p_skip_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,

367: p_da_table varchar2,
368: p_pp_table varchar2,
369: p_master_instance varchar2,
370: p_rollback varchar2,
371: p_skip_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
372: p_number_skip_levels number,
373: p_smart_update boolean,
374: p_fk_use_nl number,
375: p_fact_smart_update number,

Line 379: p_smart_update_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

375: p_fact_smart_update number,
376: p_auto_dang_table_extn varchar2,
377: p_log_dang_keys boolean,
378: p_create_parent_table_records boolean,
379: p_smart_update_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
380: p_number_smart_update_cols number,
381: p_check_fk_change boolean,
382: p_stg_join_nl_percentage number,
383: p_ok_switch_update number,

Line 432: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

428: p_fact_dlog varchar2,
429: p_key_set number,
430: p_instance_type varchar2,
431: p_load_pk number,
432: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
433: p_number_skip_cols number,
434: p_fresh_restart boolean,
435: p_op_table_space varchar2,
436: p_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 436: p_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

432: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
433: p_number_skip_cols number,
434: p_fresh_restart boolean,
435: p_op_table_space varchar2,
436: p_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
437: p_number_da_cols number,
438: p_da_table varchar2,
439: p_pp_table varchar2,
440: p_master_instance varchar2,

Line 442: p_skip_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,

438: p_da_table varchar2,
439: p_pp_table varchar2,
440: p_master_instance varchar2,
441: p_rollback varchar2,
442: p_skip_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
443: p_number_skip_levels number,
444: p_smart_update boolean,
445: p_fk_use_nl number,
446: p_fact_smart_update number,

Line 450: p_smart_update_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

446: p_fact_smart_update number,
447: p_auto_dang_table_extn varchar2,
448: p_log_dang_keys boolean,
449: p_create_parent_table_records boolean,
450: p_smart_update_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
451: p_number_smart_update_cols number,
452: p_check_fk_change boolean,
453: p_stg_join_nl_percentage number,
454: p_ok_switch_update number,

Line 503: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

499: p_fact_dlog varchar2,
500: p_key_set number,
501: p_instance_type varchar2,
502: p_load_pk number,
503: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
504: p_number_skip_cols number,
505: p_fresh_restart boolean,
506: p_op_table_space varchar2,
507: p_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 507: p_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

503: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
504: p_number_skip_cols number,
505: p_fresh_restart boolean,
506: p_op_table_space varchar2,
507: p_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
508: p_number_da_cols number,
509: p_da_table varchar2,
510: p_pp_table varchar2,
511: p_master_instance varchar2,

Line 513: p_skip_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,

509: p_da_table varchar2,
510: p_pp_table varchar2,
511: p_master_instance varchar2,
512: p_rollback varchar2,
513: p_skip_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
514: p_number_skip_levels number,
515: p_smart_update boolean,
516: p_fk_use_nl number,
517: p_fact_smart_update number,

Line 521: p_smart_update_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

517: p_fact_smart_update number,
518: p_auto_dang_table_extn varchar2,
519: p_log_dang_keys boolean,
520: p_create_parent_table_records boolean,
521: p_smart_update_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
522: p_number_smart_update_cols number,
523: p_check_fk_change boolean,
524: p_stg_join_nl_percentage number,
525: p_ok_switch_update number,

Line 578: p_ins_instance_name out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,

574: function calc_rows_processed_errors return boolean ;
575: function get_rows_processed_errored
576: (p_object_name out NOCOPY varchar2,
577: p_object_type out NOCOPY varchar2,
578: p_ins_instance_name out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
579: p_ins_request_id out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
580: p_ins_rows_ready out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
581: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
582: p_ins_rows_collected out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,

Line 579: p_ins_request_id out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,

575: function get_rows_processed_errored
576: (p_object_name out NOCOPY varchar2,
577: p_object_type out NOCOPY varchar2,
578: p_ins_instance_name out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
579: p_ins_request_id out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
580: p_ins_rows_ready out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
581: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
582: p_ins_rows_collected out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
583: p_ins_rows_dangling out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,

Line 580: p_ins_rows_ready out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,

576: (p_object_name out NOCOPY varchar2,
577: p_object_type out NOCOPY varchar2,
578: p_ins_instance_name out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
579: p_ins_request_id out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
580: p_ins_rows_ready out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
581: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
582: p_ins_rows_collected out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
583: p_ins_rows_dangling out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
584: p_ins_rows_duplicate out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,

Line 581: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,

577: p_object_type out NOCOPY varchar2,
578: p_ins_instance_name out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
579: p_ins_request_id out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
580: p_ins_rows_ready out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
581: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
582: p_ins_rows_collected out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
583: p_ins_rows_dangling out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
584: p_ins_rows_duplicate out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
585: p_ins_rows_error out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,

Line 582: p_ins_rows_collected out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,

578: p_ins_instance_name out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
579: p_ins_request_id out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
580: p_ins_rows_ready out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
581: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
582: p_ins_rows_collected out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
583: p_ins_rows_dangling out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
584: p_ins_rows_duplicate out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
585: p_ins_rows_error out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
586: p_number_ins_req_coll out NOCOPY number) return boolean ;

Line 583: p_ins_rows_dangling out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,

579: p_ins_request_id out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
580: p_ins_rows_ready out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
581: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
582: p_ins_rows_collected out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
583: p_ins_rows_dangling out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
584: p_ins_rows_duplicate out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
585: p_ins_rows_error out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
586: p_number_ins_req_coll out NOCOPY number) return boolean ;
587: function get_time return varchar2 ;

Line 584: p_ins_rows_duplicate out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,

580: p_ins_rows_ready out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
581: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
582: p_ins_rows_collected out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
583: p_ins_rows_dangling out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
584: p_ins_rows_duplicate out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
585: p_ins_rows_error out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
586: p_number_ins_req_coll out NOCOPY number) return boolean ;
587: function get_time return varchar2 ;
588: procedure write_to_debug(p_message varchar2) ;

Line 585: p_ins_rows_error out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,

581: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
582: p_ins_rows_collected out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
583: p_ins_rows_dangling out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
584: p_ins_rows_duplicate out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
585: p_ins_rows_error out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
586: p_number_ins_req_coll out NOCOPY number) return boolean ;
587: function get_time return varchar2 ;
588: procedure write_to_debug(p_message varchar2) ;
589: procedure write_to_debug_n(p_message varchar2);

Line 650: function move_dup_rowid_table_general(p_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_cols number)

646: p_start_date date,p_end_date date,p_category varchar2, p_operation varchar2,p_seq_id varchar2,p_flag varchar2);
647: function create_dlog_lookup_table return boolean ;
648: function insert_dlog_table(p_mode varchar2) return boolean;
649: procedure analyze_target_tables ;
650: function move_dup_rowid_table_general(p_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_cols number)
651: return number;
652: function create_da_pp_tables return boolean ;
653: function get_stg_da_columns return boolean ;
654: function populate_da_pp_tables return boolean ;

Line 655: function create_opcode_table(p_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_cols number) return boolean;

651: return number;
652: function create_da_pp_tables return boolean ;
653: function get_stg_da_columns return boolean ;
654: function populate_da_pp_tables return boolean ;
655: function create_opcode_table(p_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_cols number) return boolean;
656: function sync_da_pp_tables(p_table varchar2) return boolean ;
657: function move_dup_pp_future return boolean ;
658: function load_dup_coll_into_pp return boolean ;
659: function recreate_dlog_table return boolean ;

Line 666: p_dang_instance out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,

662: p_fk_name varchar2,
663: p_parent_table_id number,
664: p_parent_table_name varchar2,
665: p_dang_table varchar2,
666: p_dang_instance out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
667: p_number_dang_instance out NOCOPY number
668: ) return boolean;
669: function insert_into_parent_fk_log(
670: p_dang_instance EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 670: p_dang_instance EDW_OWB_COLLECTION_UTIL.varcharTableType,

666: p_dang_instance out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
667: p_number_dang_instance out NOCOPY number
668: ) return boolean;
669: function insert_into_parent_fk_log(
670: p_dang_instance EDW_OWB_COLLECTION_UTIL.varcharTableType,
671: p_number_dang_instance number,
672: p_fk_name varchar2,
673: p_parent_table_id number,
674: p_parent_table_name varchar2,

Line 678: p_dang_instance EDW_OWB_COLLECTION_UTIL.varcharTableType,

674: p_parent_table_name varchar2,
675: p_dim_auto_dang_table varchar2,
676: p_dim_lowest_ltc_id number) return boolean ;
677: function drop_fk_inst_tables(
678: p_dang_instance EDW_OWB_COLLECTION_UTIL.varcharTableType,
679: p_number_dang_instance number,
680: p_parent_table_id number) return boolean ;
681: function create_auto_dang_tables(
682: p_surr_table varchar2,

Line 900: p_pci_tables EDW_OWB_COLLECTION_UTIL.varcharTableType,

896: function merge_all_update_rowids(
897: p_ltc_id number,
898: p_ul_table varchar2,
899: p_ur_pattern varchar2,
900: p_pci_tables EDW_OWB_COLLECTION_UTIL.varcharTableType,
901: p_num_pci_tables number
902: )return boolean;
903: function merge_pci_snplog(
904: p_ltc varchar2,