DBA Data[Home] [Help]

APPS.EDW_ALL_COLLECT dependencies on EDW_DERIVED_FACT_COLLECT

Line 1216: if EDW_DERIVED_FACT_COLLECT.COLLECT_FACT(

1212: --call the derived fact collection
1213: l_ins_rows_processed:=0;
1214: insert_into_load_progress(g_load_pk,g_object_name,g_object_id,'Derived Fact Collect',sysdate,null,'FACT',
1215: 'DERIVED-FACT-COLLECT',22,'I');
1216: if EDW_DERIVED_FACT_COLLECT.COLLECT_FACT(
1217: g_object_name,
1218: g_conc_program_id,
1219: g_conc_program_name,
1220: g_debug,

Line 1244: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('EDW_DERIVED_FACT_COLLECT.COLLECT_FACT returned with success '||get_time

1240: g_sort_area_size,
1241: g_trace,
1242: g_read_cfig_options
1243: ) = true then
1244: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('EDW_DERIVED_FACT_COLLECT.COLLECT_FACT returned with success '||get_time
1245: ,FND_LOG.LEVEL_PROCEDURE);
1246: insert_into_load_progress(g_load_pk,null,null,null,null,sysdate,null,null,22,'U');
1247: else
1248: g_status_message:=EDW_DERIVED_FACT_COLLECT.get_status_message;

Line 1248: g_status_message:=EDW_DERIVED_FACT_COLLECT.get_status_message;

1244: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('EDW_DERIVED_FACT_COLLECT.COLLECT_FACT returned with success '||get_time
1245: ,FND_LOG.LEVEL_PROCEDURE);
1246: insert_into_load_progress(g_load_pk,null,null,null,null,sysdate,null,null,22,'U');
1247: else
1248: g_status_message:=EDW_DERIVED_FACT_COLLECT.get_status_message;
1249: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n(g_status_message,FND_LOG.LEVEL_STATEMENT);
1250: insert_into_load_progress(g_load_pk,null,null,null,null,sysdate,null,null,22,'U');
1251: g_status:=false;
1252: errbuf:=g_status_message;

Line 1895: if EDW_DERIVED_FACT_COLLECT.COLLECT_FACT_INC(

1891: if l_date is null then
1892: EDW_OWB_COLLECTION_UTIL.analyze_table_stats(g_object_name,g_table_owner,1);
1893: end if;
1894: l_number_derived_facts:=0;
1895: if EDW_DERIVED_FACT_COLLECT.COLLECT_FACT_INC(
1896: g_object_name,
1897: g_fact_target,
1898: l_derived_facts,--dummy
1899: l_derived_fact_ids,--dummy

Line 1936: g_status_message:=EDW_DERIVED_FACT_COLLECT.get_status_message;

1932: g_trace,
1933: g_read_cfig_options,
1934: g_job_queue_processes
1935: )=false then
1936: g_status_message:=EDW_DERIVED_FACT_COLLECT.get_status_message;
1937: g_status:=false;
1938: return false;
1939: end if;
1940: return true;

Line 2311: if EDW_DERIVED_FACT_COLLECT.COLLECT_FACT(

2307: EDW_OWB_COLLECTION_UTIL.write_to_log_file('l_bu_tables='||l_bu_tables(z)||',l_bu_dimensions='||l_bu_dimensions(z),
2308: FND_LOG.LEVEL_STATEMENT);
2309: end loop;
2310: end if;
2311: if EDW_DERIVED_FACT_COLLECT.COLLECT_FACT(
2312: l_fact_name,
2313: g_derv_fact_id(i),
2314: l_src_fact_name,
2315: l_src_fact_id,

Line 2351: g_status_message:=EDW_DERIVED_FACT_COLLECT.g_status_message;

2347: g_sort_area_size,
2348: g_trace,
2349: g_read_cfig_options
2350: )=false then
2351: g_status_message:=EDW_DERIVED_FACT_COLLECT.g_status_message;
2352: g_status:=false;
2353: return false;
2354: end if;
2355: if l_load_mode='BU-DELETE' then

Line 2392: if EDW_DERIVED_FACT_COLLECT.COLLECT_FACT(

2388: l_number_skip_cols:=0;
2389: if EDW_OWB_COLLECTION_UTIL.find_skip_attributes(l_fact_name,'DERIVED FACT',l_skip_cols,l_number_skip_cols)=false then
2390: return false;
2391: end if;
2392: if EDW_DERIVED_FACT_COLLECT.COLLECT_FACT(
2393: l_fact_name,
2394: g_conc_program_id,
2395: g_conc_program_name,
2396: g_debug,

Line 2420: g_status_message:=EDW_DERIVED_FACT_COLLECT.get_status_message;

2416: g_sort_area_size,
2417: g_trace,
2418: g_read_cfig_options
2419: ) = false then
2420: g_status_message:=EDW_DERIVED_FACT_COLLECT.get_status_message;
2421: g_status:=false;
2422: return false;
2423: end if;
2424: if get_temp_log_data(l_fact_name, 'FACT')=false then