DBA Data[Home] [Help]

APPS.BIV_DBI_COLLECTION_INIT dependencies on BIV_DBI_CLOSED_SUM_F

Line 623: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_CLOSED_SUM_F');

619: bis_collection_utilities.log('Starting Closed Initial Load');
620: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
621: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
622:
623: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_CLOSED_SUM_F');
624:
625: if biv_dbi_collection_util.truncate_table
626: (l_biv_schema, 'BIV_DBI_CLOSED_SUM_F', l_error_message) <> 0 then
627: raise l_exception;

Line 626: (l_biv_schema, 'BIV_DBI_CLOSED_SUM_F', l_error_message) <> 0 then

622:
623: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_CLOSED_SUM_F');
624:
625: if biv_dbi_collection_util.truncate_table
626: (l_biv_schema, 'BIV_DBI_CLOSED_SUM_F', l_error_message) <> 0 then
627: raise l_exception;
628: end if;
629:
630: bis_collection_utilities.log('Inserting rows into BIV_DBI_CLOSED_SUM_F');

Line 630: bis_collection_utilities.log('Inserting rows into BIV_DBI_CLOSED_SUM_F');

626: (l_biv_schema, 'BIV_DBI_CLOSED_SUM_F', l_error_message) <> 0 then
627: raise l_exception;
628: end if;
629:
630: bis_collection_utilities.log('Inserting rows into BIV_DBI_CLOSED_SUM_F');
631:
632: insert /*+ APPEND parallel(csf)*/
633: into biv_dbi_closed_sum_f csf
634: (

Line 633: into biv_dbi_closed_sum_f csf

629:
630: bis_collection_utilities.log('Inserting rows into BIV_DBI_CLOSED_SUM_F');
631:
632: insert /*+ APPEND parallel(csf)*/
633: into biv_dbi_closed_sum_f csf
634: (
635: report_date
636: , incident_id
637: , incident_type_id