APPS.BIV_DBI_COLLECTION_INC dependencies on DBMS_UTILITY

Line 316: l_timer := dbms_utility.get_time;

312:
313: if p_staging_flag = 'N' then
314:
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;

Line 674: , staging_table_time = dbms_utility.get_time - l_timer

670:
671: update biv_dbi_collection_log
672: set staging_table_flag = 'Y'
673: , staging_table_count = l_rowcount
674: , staging_table_time = dbms_utility.get_time - l_timer
675: , staging_error_message = null
676: , last_update_date = sysdate
677: , last_updated_by = g_user_id
678: , last_update_login = g_login_id

Line 710: l_timer := dbms_utility.get_time;

706:
707: if p_activity_flag = 'N' then
708:
709: l_phase := 2;
710: l_timer := dbms_utility.get_time;
711: l_rowcount := 0;
712:
713: bis_collection_utilities.log('Starting Activity Incremental Load');
714:

Line 937: , activity_time = dbms_utility.get_time - l_timer

933:
934: update biv_dbi_collection_log
935: set activity_flag = 'Y'
936: , activity_count = l_rowcount
937: , activity_time = dbms_utility.get_time - l_timer
938: , activity_error_message = null
939: , last_update_date = sysdate
940: , last_updated_by = g_user_id
941: , last_update_login = g_login_id

Line 959: l_timer := dbms_utility.get_time;

955:
956: if p_closed_flag = 'N' then
957:
958: l_phase := 3;
959: l_timer := dbms_utility.get_time;
960: l_rowcount := 0;
961:
962: bis_collection_utilities.log('Starting Closed Incremental Load');
963:

Line 1101: , closed_time = dbms_utility.get_time - l_timer

1097:
1098: update biv_dbi_collection_log
1099: set closed_flag = 'Y'
1100: , closed_count = l_rowcount
1101: , closed_time = dbms_utility.get_time - l_timer
1102: , closed_error_message = null
1103: , last_update_date = sysdate
1104: , last_updated_by = g_user_id
1105: , last_update_login = g_login_id

Line 1123: l_timer := dbms_utility.get_time;

1119:
1120: if p_backlog_flag = 'N' then
1121:
1122: l_phase := 4;
1123: l_timer := dbms_utility.get_time;
1124: l_rowcount := 0;
1125:
1126: bis_collection_utilities.log('Starting Backlog Incremental Load');
1127:

Line 1291: , backlog_time = dbms_utility.get_time - l_timer

1287:
1288: update biv_dbi_collection_log
1289: set backlog_flag = 'Y'
1290: , backlog_count = l_rowcount
1291: , backlog_time = dbms_utility.get_time - l_timer
1292: , backlog_error_message = null
1293: , last_update_date = sysdate
1294: , last_updated_by = g_user_id
1295: , last_update_login = g_login_id

Line 1312: l_timer := dbms_utility.get_time;

1308:
1309: if p_resolution_flag = 'N' then
1310:
1311: l_phase := 5;
1312: l_timer := dbms_utility.get_time;
1313: l_rowcount := 0;
1314:
1315: bis_collection_utilities.log('Starting Resolution Incremental Load');
1316:

Line 1603: , resolution_time = dbms_utility.get_time - l_timer

1599:
1600: update biv_dbi_collection_log
1601: set resolution_flag = 'Y'
1602: , resolution_count = l_rowcount
1603: , resolution_time = dbms_utility.get_time - l_timer
1604: , resolution_error_message = null
1605: , last_update_date = sysdate
1606: , last_updated_by = g_user_id
1607: , last_update_login = g_login_id