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

Line 31: g_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;

27: g_src_object_ilog varchar2(400);
28: g_src_object_dlog varchar2(400);
29: g_src_object_dlog_count number;
30: g_src_object_id number;
31: g_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
32: g_fact_fks_mapped EDW_OWB_COLLECTION_UTIL.booleanTableType;
33: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
34: g_higher_level_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
35: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 32: g_fact_fks_mapped EDW_OWB_COLLECTION_UTIL.booleanTableType;

28: g_src_object_dlog varchar2(400);
29: g_src_object_dlog_count number;
30: g_src_object_id number;
31: g_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
32: g_fact_fks_mapped EDW_OWB_COLLECTION_UTIL.booleanTableType;
33: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
34: g_higher_level_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
35: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
36: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 33: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;

29: g_src_object_dlog_count number;
30: g_src_object_id number;
31: g_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
32: g_fact_fks_mapped EDW_OWB_COLLECTION_UTIL.booleanTableType;
33: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
34: g_higher_level_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
35: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
36: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
37: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 34: g_higher_level_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;

30: g_src_object_id number;
31: g_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
32: g_fact_fks_mapped EDW_OWB_COLLECTION_UTIL.booleanTableType;
33: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
34: g_higher_level_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
35: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
36: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
37: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 35: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;

31: g_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
32: g_fact_fks_mapped EDW_OWB_COLLECTION_UTIL.booleanTableType;
33: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
34: g_higher_level_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
35: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
36: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
37: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 36: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;

32: g_fact_fks_mapped EDW_OWB_COLLECTION_UTIL.booleanTableType;
33: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
34: g_higher_level_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
35: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
36: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
37: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 37: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;

33: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
34: g_higher_level_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
35: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
36: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
37: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 38: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;

34: g_higher_level_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;
35: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
36: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
37: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_number_fact_fks number;

Line 39: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

35: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
36: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
37: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_number_fact_fks number;
43: g_src_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 40: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;

36: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
37: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_number_fact_fks number;
43: g_src_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
44: g_number_src_fks number;

Line 41: g_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;

37: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
38: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
39: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_number_fact_fks number;
43: g_src_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
44: g_number_src_fks number;
45: g_filter_stmt varchar2(10000);

Line 43: g_src_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;

39: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
40: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
41: g_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
42: g_number_fact_fks number;
43: g_src_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
44: g_number_src_fks number;
45: g_filter_stmt varchar2(10000);
46: g_fact_dlog varchar2(400);
47:

Line 55: g_input_params EDW_OWB_COLLECTION_UTIL.varcharTableType;

51: g_exec_flag boolean;
52: g_groupby_stmt varchar2(10000);
53: g_update_type varchar2(400);--what scheme should update follow...mass, row by row, delete insert...
54:
55: g_input_params EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_output_params EDW_OWB_COLLECTION_UTIL.varcharTableType;
57: g_input_params_is_fk EDW_OWB_COLLECTION_UTIL.booleanTableType;
58: g_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_output_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;--in the derived summary fact

Line 56: g_output_params EDW_OWB_COLLECTION_UTIL.varcharTableType;

52: g_groupby_stmt varchar2(10000);
53: g_update_type varchar2(400);--what scheme should update follow...mass, row by row, delete insert...
54:
55: g_input_params EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_output_params EDW_OWB_COLLECTION_UTIL.varcharTableType;
57: g_input_params_is_fk EDW_OWB_COLLECTION_UTIL.booleanTableType;
58: g_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_output_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;--in the derived summary fact
60: g_number_group_by_cols number;

Line 57: g_input_params_is_fk EDW_OWB_COLLECTION_UTIL.booleanTableType;

53: g_update_type varchar2(400);--what scheme should update follow...mass, row by row, delete insert...
54:
55: g_input_params EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_output_params EDW_OWB_COLLECTION_UTIL.varcharTableType;
57: g_input_params_is_fk EDW_OWB_COLLECTION_UTIL.booleanTableType;
58: g_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_output_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;--in the derived summary fact
60: g_number_group_by_cols number;
61: g_number_input_params number;

Line 58: g_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;

54:
55: g_input_params EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_output_params EDW_OWB_COLLECTION_UTIL.varcharTableType;
57: g_input_params_is_fk EDW_OWB_COLLECTION_UTIL.booleanTableType;
58: g_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_output_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;--in the derived summary fact
60: g_number_group_by_cols number;
61: g_number_input_params number;
62: g_df_extra_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 59: g_output_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;--in the derived summary fact

55: g_input_params EDW_OWB_COLLECTION_UTIL.varcharTableType;
56: g_output_params EDW_OWB_COLLECTION_UTIL.varcharTableType;
57: g_input_params_is_fk EDW_OWB_COLLECTION_UTIL.booleanTableType;
58: g_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_output_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;--in the derived summary fact
60: g_number_group_by_cols number;
61: g_number_input_params number;
62: g_df_extra_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_fk_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is the output col a fk?

Line 62: g_df_extra_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;

58: g_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
59: g_output_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;--in the derived summary fact
60: g_number_group_by_cols number;
61: g_number_input_params number;
62: g_df_extra_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_fk_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is the output col a fk?
64: g_fk_off_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--turned off
65: g_groupby_col_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is the output col a group by col?
66: g_number_df_extra_fks number;

Line 63: g_fk_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is the output col a fk?

59: g_output_group_by_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;--in the derived summary fact
60: g_number_group_by_cols number;
61: g_number_input_params number;
62: g_df_extra_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_fk_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is the output col a fk?
64: g_fk_off_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--turned off
65: g_groupby_col_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is the output col a group by col?
66: g_number_df_extra_fks number;
67:

Line 64: g_fk_off_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--turned off

60: g_number_group_by_cols number;
61: g_number_input_params number;
62: g_df_extra_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_fk_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is the output col a fk?
64: g_fk_off_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--turned off
65: g_groupby_col_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is the output col a group by col?
66: g_number_df_extra_fks number;
67:
68: g_full_refresh boolean; --full refresh or not

Line 65: g_groupby_col_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is the output col a group by col?

61: g_number_input_params number;
62: g_df_extra_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
63: g_fk_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is the output col a fk?
64: g_fk_off_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--turned off
65: g_groupby_col_flag EDW_OWB_COLLECTION_UTIL.booleanTableType;--is the output col a group by col?
66: g_number_df_extra_fks number;
67:
68: g_full_refresh boolean; --full refresh or not
69: g_naedw_pk number; --for now, put this as 0

Line 74: g_hold_relation EDW_OWB_COLLECTION_UTIL.varcharTableType;

70:
71: /*************************************************************
72: some temp holders
73: **************************************************************/
74: g_hold_relation EDW_OWB_COLLECTION_UTIL.varcharTableType;
75: g_hold_item EDW_OWB_COLLECTION_UTIL.varcharTableType;
76: g_hold_number number;
77: /*************************************************************/
78:

Line 75: g_hold_item EDW_OWB_COLLECTION_UTIL.varcharTableType;

71: /*************************************************************
72: some temp holders
73: **************************************************************/
74: g_hold_relation EDW_OWB_COLLECTION_UTIL.varcharTableType;
75: g_hold_item EDW_OWB_COLLECTION_UTIL.varcharTableType;
76: g_hold_number number;
77: /*************************************************************/
78:
79: g_ins_rows_processed number;

Line 115: g_ins_rows_ready EDW_OWB_COLLECTION_UTIL.numberTableType;

111: g_err_rec_flag boolean;
112: g_err_rec_flag_d boolean;--for delete
113:
114: /**************Record the number of rows processed and errors*****/
115: g_ins_rows_ready EDW_OWB_COLLECTION_UTIL.numberTableType;
116: g_ins_rows_processed_tab EDW_OWB_COLLECTION_UTIL.numberTableType;
117: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
118: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
119: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 116: g_ins_rows_processed_tab EDW_OWB_COLLECTION_UTIL.numberTableType;

112: g_err_rec_flag_d boolean;--for delete
113:
114: /**************Record the number of rows processed and errors*****/
115: g_ins_rows_ready EDW_OWB_COLLECTION_UTIL.numberTableType;
116: g_ins_rows_processed_tab EDW_OWB_COLLECTION_UTIL.numberTableType;
117: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
118: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
119: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
120: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 117: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;

113:
114: /**************Record the number of rows processed and errors*****/
115: g_ins_rows_ready EDW_OWB_COLLECTION_UTIL.numberTableType;
116: g_ins_rows_processed_tab EDW_OWB_COLLECTION_UTIL.numberTableType;
117: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
118: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
119: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
120: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;
121: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 118: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;

114: /**************Record the number of rows processed and errors*****/
115: g_ins_rows_ready EDW_OWB_COLLECTION_UTIL.numberTableType;
116: g_ins_rows_processed_tab EDW_OWB_COLLECTION_UTIL.numberTableType;
117: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
118: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
119: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
120: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;
121: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
122: g_ins_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 119: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;

115: g_ins_rows_ready EDW_OWB_COLLECTION_UTIL.numberTableType;
116: g_ins_rows_processed_tab EDW_OWB_COLLECTION_UTIL.numberTableType;
117: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
118: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
119: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
120: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;
121: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
122: g_ins_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType;
123: g_number_ins_req_coll number;

Line 120: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;

116: g_ins_rows_processed_tab EDW_OWB_COLLECTION_UTIL.numberTableType;
117: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
118: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
119: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
120: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;
121: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
122: g_ins_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType;
123: g_number_ins_req_coll number;
124: g_total_insert number;

Line 121: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;

117: g_ins_rows_collected EDW_OWB_COLLECTION_UTIL.numberTableType;
118: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
119: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
120: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;
121: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
122: g_ins_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType;
123: g_number_ins_req_coll number;
124: g_total_insert number;
125: g_total_update number;

Line 122: g_ins_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType;

118: g_ins_rows_dangling EDW_OWB_COLLECTION_UTIL.numberTableType;
119: g_ins_rows_duplicate EDW_OWB_COLLECTION_UTIL.numberTableType;
120: g_ins_rows_error EDW_OWB_COLLECTION_UTIL.numberTableType;
121: g_ins_instance_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
122: g_ins_request_id_table EDW_OWB_COLLECTION_UTIL.numberTableType;
123: g_number_ins_req_coll number;
124: g_total_insert number;
125: g_total_update number;
126: g_total_delete number;

Line 129: g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;

125: g_total_update number;
126: g_total_delete number;
127: /*******************************************************/
128: g_load_fk number;
129: g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
130: g_number_skip_cols number;
131: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;
132: g_fk_value_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a value needs to be directly loaded like edwna
133: g_fk_load_value EDW_OWB_COLLECTION_UTIL.varcharTableType;--the value to load

Line 131: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;

127: /*******************************************************/
128: g_load_fk number;
129: g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
130: g_number_skip_cols number;
131: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;
132: g_fk_value_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a value needs to be directly loaded like edwna
133: g_fk_load_value EDW_OWB_COLLECTION_UTIL.varcharTableType;--the value to load
134: --------------------sec sources-----------------------
135: g_sec_sources EDW_OWB_COLLECTION_UTIL.varcharTableType;

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

128: g_load_fk number;
129: g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
130: g_number_skip_cols number;
131: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;
132: g_fk_value_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a value needs to be directly loaded like edwna
133: g_fk_load_value EDW_OWB_COLLECTION_UTIL.varcharTableType;--the value to load
134: --------------------sec sources-----------------------
135: g_sec_sources EDW_OWB_COLLECTION_UTIL.varcharTableType;
136: g_sec_sources_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 133: g_fk_load_value EDW_OWB_COLLECTION_UTIL.varcharTableType;--the value to load

129: g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
130: g_number_skip_cols number;
131: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;
132: g_fk_value_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a value needs to be directly loaded like edwna
133: g_fk_load_value EDW_OWB_COLLECTION_UTIL.varcharTableType;--the value to load
134: --------------------sec sources-----------------------
135: g_sec_sources EDW_OWB_COLLECTION_UTIL.varcharTableType;
136: g_sec_sources_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
137: g_number_sec_sources number;

Line 135: g_sec_sources EDW_OWB_COLLECTION_UTIL.varcharTableType;

131: g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;
132: g_fk_value_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a value needs to be directly loaded like edwna
133: g_fk_load_value EDW_OWB_COLLECTION_UTIL.varcharTableType;--the value to load
134: --------------------sec sources-----------------------
135: g_sec_sources EDW_OWB_COLLECTION_UTIL.varcharTableType;
136: g_sec_sources_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
137: g_number_sec_sources number;
138: g_sec_sources_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
139: g_sec_sources_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 136: g_sec_sources_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;

132: g_fk_value_load EDW_OWB_COLLECTION_UTIL.booleanTableType;--if a value needs to be directly loaded like edwna
133: g_fk_load_value EDW_OWB_COLLECTION_UTIL.varcharTableType;--the value to load
134: --------------------sec sources-----------------------
135: g_sec_sources EDW_OWB_COLLECTION_UTIL.varcharTableType;
136: g_sec_sources_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
137: g_number_sec_sources number;
138: g_sec_sources_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
139: g_sec_sources_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
140: g_number_sec_key number;

Line 138: g_sec_sources_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

134: --------------------sec sources-----------------------
135: g_sec_sources EDW_OWB_COLLECTION_UTIL.varcharTableType;
136: g_sec_sources_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
137: g_number_sec_sources number;
138: g_sec_sources_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
139: g_sec_sources_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
140: g_number_sec_key number;
141: --------------------sec sources-----------------------
142: g_mode varchar2(400);

Line 139: g_sec_sources_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;

135: g_sec_sources EDW_OWB_COLLECTION_UTIL.varcharTableType;
136: g_sec_sources_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
137: g_number_sec_sources number;
138: g_sec_sources_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
139: g_sec_sources_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
140: g_number_sec_key number;
141: --------------------sec sources-----------------------
142: g_mode varchar2(400);
143: g_skip_ilog boolean;--for performance

Line 148: g_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;--before update tables.prop dim change to derv fact.

144: g_fresh_restart boolean;
145: g_op_table_space varchar2(400);
146: g_rollback varchar2(400);
147: ----------propogate inc changes in dim to derv facts--------------------------------------
148: g_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;--before update tables.prop dim change to derv fact.
149: g_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType;--which are the dims with the before update tables
150: g_number_bu_tables number;
151: g_bu_src_fact varchar2(400);
152: g_load_mode varchar2(400);

Line 149: g_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType;--which are the dims with the before update tables

145: g_op_table_space varchar2(400);
146: g_rollback varchar2(400);
147: ----------propogate inc changes in dim to derv facts--------------------------------------
148: g_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;--before update tables.prop dim change to derv fact.
149: g_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType;--which are the dims with the before update tables
150: g_number_bu_tables number;
151: g_bu_src_fact varchar2(400);
152: g_load_mode varchar2(400);
153: g_skip_ilog_update boolean;

Line 189: p_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType,

185: p_fact_id number,
186: p_mapping_id number,
187: p_src_object varchar2,
188: p_src_object_id number,
189: p_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType,
190: p_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType,
191: p_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType,
192: p_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType,
193: p_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 190: p_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType,

186: p_mapping_id number,
187: p_src_object varchar2,
188: p_src_object_id number,
189: p_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType,
190: p_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType,
191: p_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType,
192: p_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType,
193: p_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType,
194: p_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 191: p_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType,

187: p_src_object varchar2,
188: p_src_object_id number,
189: p_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType,
190: p_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType,
191: p_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType,
192: p_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType,
193: p_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType,
194: p_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
195: p_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 192: p_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType,

188: p_src_object_id number,
189: p_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType,
190: p_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType,
191: p_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType,
192: p_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType,
193: p_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType,
194: p_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
195: p_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType,
196: p_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType,

Line 193: p_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType,

189: p_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType,
190: p_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType,
191: p_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType,
192: p_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType,
193: p_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType,
194: p_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
195: p_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType,
196: p_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType,
197: p_number_fact_fks number,

Line 194: p_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,

190: p_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType,
191: p_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType,
192: p_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType,
193: p_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType,
194: p_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
195: p_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType,
196: p_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType,
197: p_number_fact_fks number,
198: p_conc_id number,

Line 195: p_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType,

191: p_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType,
192: p_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType,
193: p_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType,
194: p_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
195: p_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType,
196: p_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType,
197: p_number_fact_fks number,
198: p_conc_id number,
199: p_conc_program_name varchar2,

Line 196: p_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType,

192: p_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType,
193: p_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType,
194: p_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
195: p_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType,
196: p_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType,
197: p_number_fact_fks number,
198: p_conc_id number,
199: p_conc_program_name varchar2,
200: p_debug boolean,

Line 212: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

208: p_dlog varchar2,
209: p_forall_size number,
210: p_update_type varchar2,
211: p_fact_dlog varchar2,
212: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
213: p_number_skip_cols number,
214: p_load_fk number,
215: p_fresh_restart boolean,
216: p_op_table_space varchar2,

Line 217: p_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType,

213: p_number_skip_cols number,
214: p_load_fk number,
215: p_fresh_restart boolean,
216: p_op_table_space varchar2,
217: p_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType,
218: --before update tables.prop dim change to derv
219: p_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType,
220: p_number_bu_tables number,
221: p_bu_src_fact varchar2,

Line 219: p_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType,

215: p_fresh_restart boolean,
216: p_op_table_space varchar2,
217: p_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType,
218: --before update tables.prop dim change to derv
219: p_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType,
220: p_number_bu_tables number,
221: p_bu_src_fact varchar2,
222: --what table to look at as the src fact. if null, scan full the src fact
223: p_load_mode varchar2,