DBA Data[Home] [Help]

APPS.BIV_DBI_COLLECTION_AGE dependencies on BIV_DBI_COLLECTION_UTIL

Line 41: biv_dbi_collection_util.get_last_log( l_log_rowid

37: if not bis_collection_utilities.setup( 'BIV_BAC_AGE_SUM_F' ) then
38: raise g_bis_setup_exception;
39: end if;
40:
41: biv_dbi_collection_util.get_last_log( l_log_rowid
42: , l_process_type
43: , l_collect_from_date
44: , l_collect_to_date
45: , l_success_flag

Line 77: if biv_dbi_collection_util.get_schema_name

73:
74: bis_collection_utilities.log('Starting Backlog Aging Load, aging As At ' ||
75: fnd_date.date_to_displaydt(l_collect_to_date));
76:
77: if biv_dbi_collection_util.get_schema_name
78: ( l_biv_schema
79: , l_error_message ) <> 0 then
80: raise l_exception;
81: end if;

Line 85: if biv_dbi_collection_util.truncate_table

81: end if;
82:
83: bis_collection_utilities.log('truncating dates table',1);
84:
85: if biv_dbi_collection_util.truncate_table
86: ( l_biv_schema
87: , 'BIV_DBI_BACKLOG_AGE_DATES'
88: , l_error_message ) <> 0 then
89: raise l_exception;

Line 295: if biv_dbi_collection_util.gather_statistics

291: bis_collection_utilities.log(l_rowcount || ' rows inserted',2);
292:
293: bis_collection_utilities.log('gathering stats on dates table',1);
294:
295: if biv_dbi_collection_util.gather_statistics
296: ( l_biv_schema
297: , 'BIV_DBI_BACKLOG_AGE_DATES'
298: , l_error_message ) <> 0 then
299: raise l_exception;

Line 304: if biv_dbi_collection_util.truncate_table

300: end if;
301:
302: bis_collection_utilities.log('truncating Backlog Aging table',1);
303:
304: if biv_dbi_collection_util.truncate_table
305: ( l_biv_schema
306: , 'BIV_BAC_AGE_SUM_F'
307: , l_error_message ) <> 0 then
308: raise l_exception;

Line 633: if biv_dbi_collection_util.gather_statistics

629: commit;
630:
631: --
632: bis_collection_utilities.log('gathering stats on Backlog Aging table',2);
633: if biv_dbi_collection_util.gather_statistics
634: ( l_biv_schema
635: , 'BIV_BAC_AGE_SUM_F'
636: , l_error_message ) <> 0 then
637: raise l_exception;