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.
PACKAGE: APPS.EDW_DERIVED_FACT_COLLECT

Source


1 package EDW_DERIVED_FACT_COLLECT AUTHID CURRENT_USER AS
2 /*$Header: EDWFCOLS.pls 115.19 2003/07/29 00:22:43 vsurendr ship $*/
3 
4 Type varcharTableType is Table of varchar2(400) index by binary_integer;
5 Type numberTableType is Table of number index by binary_integer;
6 
7 g_temp_conc_name varchar2(400);
8 g_temp_exe_name varchar2(400);
9 g_debug boolean;
10 g_fact_name varchar2(400);
11 g_fact_id number;
12 g_temp_fact_name  varchar2(400);
13 g_fact_iv  varchar2(400);
14 g_stmt varchar2(32000);
15 g_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
16 g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
17 g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
18 g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
19 g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
20 g_level_prefix  EDW_OWB_COLLECTION_UTIL.varcharTableType;
21 g_level_pk  EDW_OWB_COLLECTION_UTIL.varcharTableType;
22 g_level_pk_key  EDW_OWB_COLLECTION_UTIL.varcharTableType;
23 g_dim_pk_key  EDW_OWB_COLLECTION_UTIL.varcharTableType;
24 g_number_fact_fks number;
25 g_forall_size number;
26 g_thread_type varchar2(40);
27 g_mapping_ids numberTableType;
28 g_number_mapping_ids number;
29 g_src_objects varcharTableType;
30 g_src_object_ids numberTableType;
31 g_src_object_type varcharTableType;
32 g_bis_owner varchar2(400);
33 g_table_owner varchar2(400);
34 g_status_message varchar2(20000);
35 
36 /*****************************************************************/
37 /**************Record the number of rows processed and errors*****/
38 g_ins_rows_processed number;
39 g_ins_rows_dangling number;
40 g_ins_rows_duplicate number;
41 g_ins_rows_error number;
42 g_collection_size number;
43 g_parallel  number;
44 g_ilog varchar2(400);
45 g_dlog varchar2(400);
46 g_fresh_restart boolean;
47 
48 /******************************************************************/
49 FUNCTION COLLECT_FACT(
50   p_fact_name varchar2,--derived fact
51   p_fact_id number,--derived fact
52   p_src_fact_name varchar2,
53   p_src_fact_id number,
54   p_map_id number,
55   p_conc_id in number,
56   p_conc_program_name in varchar2,
57   p_debug boolean,
58   p_collection_size number,
59   p_parallel  number,
60   p_bis_owner varchar2,
61   p_table_owner varchar2,
62   p_ins_rows_processed out NOCOPY number,
63   p_ilog varchar2,
64   p_dlog varchar2,
65   p_forall_size number,
66   p_update_type varchar2,
67   p_fact_dlog varchar2,
68   p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
69   p_number_skip_cols number,
70   p_load_fk number,
71   p_fresh_restart boolean,
72   p_op_table_space varchar2,
73   p_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType,--before update tables.prop dim change to derv
74   p_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType,
75   p_number_bu_tables number,
76   p_bu_src_fact varchar2,--what table to look at as the src fact. if null, scan the actual src fact
77   p_load_mode varchar2,
78   p_rollback varchar2,
79   p_src_join_nl_percentage number,
80   p_thread_type varchar2,
81   p_max_threads number,
82   p_min_job_load_size number,
83   p_sleep_time number,
84   p_hash_area_size number,
85   p_sort_area_size number,
86   p_trace boolean,
87   p_read_cfig_options boolean
88 ) return boolean;
89 FUNCTION COLLECT_FACT_INC(
90 p_src_fact_name varchar2,
91 p_src_fact_id number,
92 p_derived_facts EDW_OWB_COLLECTION_UTIL.varcharTableType,
93 p_derived_fact_ids EDW_OWB_COLLECTION_UTIL.numberTableType,
94 p_map_ids EDW_OWB_COLLECTION_UTIL.numberTableType,
95 p_number_derived_facts number,
96 p_conc_id in number,
97 p_conc_program_name in varchar2,
98 p_debug boolean,
99 p_collection_size number,
100 p_parallel  number,
101 p_bis_owner varchar2,
102 p_table_owner varchar2,--src fact owner
103 p_load_pk out nocopy EDW_OWB_COLLECTION_UTIL.numberTableType,
104 p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
105 p_status out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
106 p_message out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
107 p_number_derv_facts out nocopy number,
108 p_forall_size number,
109 p_update_type varchar2,
110 p_fact_dlog varchar2,
111 p_fresh_restart boolean,
112 p_op_table_space varchar2,
113 p_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType,--before update tables.prop dim change to derv
114 p_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType,
115 p_number_bu_tables number,
116 p_bu_src_fact varchar2,--what table to look at as the src fact. if null, scan the actual src fact
117 p_load_mode varchar2,
118 p_rollback varchar2,
119 p_src_join_nl_percentage number,
120 p_thread_type varchar2,
121 p_max_threads number,
122 p_min_job_load_size number,
123 p_sleep_time number,
124 p_hash_area_size number,
125 p_sort_area_size number,
126 p_trace boolean,
127 p_read_cfig_options boolean,
128 p_job_queue_processes number
129 )return boolean ;
130 FUNCTION COLLECT_FACT(
131 p_fact_name varchar2,
132 p_conc_id in number,
133 p_conc_program_name in varchar2,
134 p_debug boolean,
135 p_collection_size number,
136 p_parallel  number,
137 p_bis_owner varchar2,
138 p_table_owner varchar2,
139 p_ins_rows_processed out NOCOPY number,
140 p_forall_size number,
141 p_update_type varchar2,
142 p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
143 p_number_skip_cols number,
144 p_load_fk number,
145 p_fresh_restart boolean,
146 p_op_table_space varchar2,
147 p_rollback varchar2,
148 p_src_join_nl_percentage number,
149 p_thread_type varchar2,
150 p_max_threads number,
151 p_min_job_load_size number,
152 p_sleep_time number,
153 p_hash_area_size number,
154 p_sort_area_size number,
155 p_trace boolean,
156 p_read_cfig_options boolean
157 ) return boolean ;
158 procedure write_to_log_file(p_message varchar2) ;
159 procedure init_all;
160 function get_fact_fks return boolean ;
161 function get_fact_id return boolean ;
162 function get_fact_mappings return boolean;
163 function get_time return varchar2;
164 procedure write_to_log_file_n(p_message varchar2);
165 function get_status_message return varchar2;
166 function truncate_derived_fact return boolean ;
167 function wait_on_jobs(
168 p_job_id EDW_OWB_COLLECTION_UTIL.numberTableType,
169 p_job_status in out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
170 p_number_jobs number,
171 p_sleep_time number,
172 p_mode varchar2
173 ) return boolean ;
174 function get_temp_log_data(
175 p_object_name varchar2,
176 p_object_type varchar2,
177 p_load_pk number,
178 p_rows_processed out nocopy number
179 ) return boolean ;
180 function get_child_job_status(
181 p_job_status_table varchar2,
182 p_status out nocopy varchar2,
183 p_message out nocopy varchar2
184 ) return boolean;
185 function log_collection_detail(
186 p_object_name varchar2,
187 p_object_id number,
188 p_object_type varchar2,
189 p_conc_program_id number,
190 p_collection_start_date date,
191 p_collection_end_date date,
192 p_ins_rows_ready number,
193 p_ins_rows_processed number,
194 p_ins_rows_collected number,
195 p_ins_rows_insert number,
196 p_ins_rows_update number,
197 p_ins_rows_delete number,
198 p_message varchar2,
199 p_status varchar2,
200 p_load_pk number
201 ) return boolean;
202 function delete_object_log_tables(
203 p_src_fact varchar2,
204 p_table_owner varchar2,
205 p_bis_owner varchar2,
206 p_fact_dlog varchar2,
207 p_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType,
208 p_dlog EDW_OWB_COLLECTION_UTIL.varcharTableType,
209 p_number_derv_fact number
210 )return boolean ;
211 function drop_inp_status_table(
212 p_input_table varchar2,
213 p_job_status_table varchar2
214 )return boolean;
215 function create_conc_program(
216 p_temp_conc_name varchar2,
217 p_temp_conc_short_name varchar2,
218 p_temp_exe_name varchar2,
219 p_bis_short_name varchar2
220 ) return boolean ;
221 END;