DBA Data[Home] [Help]

APPS.BIV_DBI_COLLECTION_INIT dependencies on BIV_DBI_RESOLUTION_SUM_F

Line 1405: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_RESOLUTION_SUM_F');

1401: bis_collection_utilities.log('Starting Resolution Initial Load');
1402: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
1403: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
1404:
1405: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_RESOLUTION_SUM_F');
1406:
1407: if biv_dbi_collection_util.truncate_table
1408: (l_biv_schema, 'BIV_DBI_RESOLUTION_SUM_F', l_error_message) <> 0 then
1409: raise l_exception;

Line 1408: (l_biv_schema, 'BIV_DBI_RESOLUTION_SUM_F', l_error_message) <> 0 then

1404:
1405: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_RESOLUTION_SUM_F');
1406:
1407: if biv_dbi_collection_util.truncate_table
1408: (l_biv_schema, 'BIV_DBI_RESOLUTION_SUM_F', l_error_message) <> 0 then
1409: raise l_exception;
1410: end if;
1411:
1412: bis_collection_utilities.log('Inserting rows into BIV_DBI_RESOLUTION_SUM_F');

Line 1412: bis_collection_utilities.log('Inserting rows into BIV_DBI_RESOLUTION_SUM_F');

1408: (l_biv_schema, 'BIV_DBI_RESOLUTION_SUM_F', l_error_message) <> 0 then
1409: raise l_exception;
1410: end if;
1411:
1412: bis_collection_utilities.log('Inserting rows into BIV_DBI_RESOLUTION_SUM_F');
1413:
1414: insert /*+ APPEND parallel(rsf)*/
1415: into biv_dbi_resolution_sum_f rsf
1416: (

Line 1415: into biv_dbi_resolution_sum_f rsf

1411:
1412: bis_collection_utilities.log('Inserting rows into BIV_DBI_RESOLUTION_SUM_F');
1413:
1414: insert /*+ APPEND parallel(rsf)*/
1415: into biv_dbi_resolution_sum_f rsf
1416: (
1417: report_date
1418: , incident_id
1419: , incident_type_id