APPS.BIV_DBI_COLLECTION_INC dependencies on BIV_DBI_COLLECTION_UTIL

Line 305: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;

301:
302: l_from_party_tab t_number_tab;
303: l_to_party_tab t_number_tab;
304:
305: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
306: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
307: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
308:
309: l_max_date date := to_date('4712/12/31','yyyy/mm/dd');

Line 306: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;

302: l_from_party_tab t_number_tab;
303: l_to_party_tab t_number_tab;
304:
305: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
306: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
307: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
308:
309: l_max_date date := to_date('4712/12/31','yyyy/mm/dd');
310:

Line 307: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;

303: l_to_party_tab t_number_tab;
304:
305: l_missing_owner_group_id number := biv_dbi_collection_util.get_missing_owner_group_id;
306: l_missing_inventory_item_id number := biv_dbi_collection_util.get_missing_inventory_item_id;
307: l_missing_organization_id number := biv_dbi_collection_util.get_missing_organization_id;
308:
309: l_max_date date := to_date('4712/12/31','yyyy/mm/dd');
310:
311: begin

Line 319: if biv_dbi_collection_util.get_schema_name(l_biv_schema, l_error_message) <> 0 then

315: l_phase := 1;
316: l_timer := dbms_utility.get_time;
317: l_rowcount := 0;
318:
319: if biv_dbi_collection_util.get_schema_name(l_biv_schema, l_error_message) <> 0 then
320: raise l_exception;
321: end if;
322:
323: bis_collection_utilities.log('Truncating table staging table');

Line 325: if biv_dbi_collection_util.truncate_table

321: end if;
322:
323: bis_collection_utilities.log('Truncating table staging table');
324:
325: if biv_dbi_collection_util.truncate_table
326: (l_biv_schema, 'BIV_DBI_COLLECTION_STG', l_error_message) <> 0 then
327: raise l_exception;
328: end if;
329:

Line 336: if biv_dbi_collection_util.correct_bad_audit(l_error_message) <> 0 then

332: /* this is a temporary workaround to bad audit data cause by:
333: - bug 3050727 - fixed
334: */
335:
336: if biv_dbi_collection_util.correct_bad_audit(l_error_message) <> 0 then
337: raise l_exception;
338: end if;
339:
340: bis_collection_utilities.log('insert rows for previous backlog into staging table',1);

Line 666: if biv_dbi_collection_util.gather_statistics

662: commit;
663:
664: bis_collection_utilities.log('Gathering Statistics for staging table');
665:
666: if biv_dbi_collection_util.gather_statistics
667: (l_biv_schema, 'BIV_DBI_COLLECTION_STG', l_error_message) <> 0 then
668: raise l_exception;
669: end if;
670:

Line 1636: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid

1632: l_error_message := substr(sqlerrm,1,4000);
1633: end if;
1634: x_error_message := l_error_message;
1635: if l_phase = 1 then
1636: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid
1637: , p_staging_error => l_error_message
1638: );
1639: elsif l_phase = 2 then
1640: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid

Line 1640: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid

1636: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid
1637: , p_staging_error => l_error_message
1638: );
1639: elsif l_phase = 2 then
1640: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid
1641: , p_activity_error => l_error_message
1642: );
1643: elsif l_phase = 3 then
1644: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid

Line 1644: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid

1640: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid
1641: , p_activity_error => l_error_message
1642: );
1643: elsif l_phase = 3 then
1644: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid
1645: , p_closed_error => l_error_message
1646: );
1647: elsif l_phase = 4 then
1648: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid

Line 1648: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid

1644: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid
1645: , p_closed_error => l_error_message
1646: );
1647: elsif l_phase = 4 then
1648: biv_dbi_collection_util.set_log_error( p_rowid => p_log_rowid
1649: , p_backlog_error => l_error_message
1650: );
1651: end if;
1652:

Line 1688: biv_dbi_collection_util.get_last_log

1684: if not bis_collection_utilities.setup( 'BIV_DBI_COLLECTION' ) then
1685: raise g_bis_setup_exception;
1686: end if;
1687:
1688: biv_dbi_collection_util.get_last_log
1689: ( l_log_rowid
1690: , l_process_type
1691: , l_collect_from_date
1692: , l_collect_to_date