APPS.BIV_DBI_COLLECTION_INIT dependencies on DBMS_UTILITY

Line 383: l_timer := dbms_utility.get_time;

379: end if;
380:
381: if l_activity_flag = 'N' then
382:
383: l_timer := dbms_utility.get_time;
384:
385: if biv_dbi_collection_util.get_schema_name
386: (l_biv_schema, l_error_message) <> 0 then
387: raise l_exception;

Line 495: , activity_time = dbms_utility.get_time - l_timer

491:
492: update biv_dbi_collection_log
493: set activity_flag = 'Y'
494: , activity_count = l_rowcount
495: , activity_time = dbms_utility.get_time - l_timer
496: , activity_error_message = null
497: , last_update_date = sysdate
498: , last_updated_by = g_user_id
499: , last_update_login = g_login_id

Line 612: l_timer := dbms_utility.get_time;

608: end if;
609:
610: if l_closed_flag = 'N' then
611:
612: l_timer := dbms_utility.get_time;
613:
614: if biv_dbi_collection_util.get_schema_name
615: (l_biv_schema, l_error_message) <> 0 then
616: raise l_exception;

Line 762: , closed_time = dbms_utility.get_time - l_timer

758:
759: update biv_dbi_collection_log
760: set closed_flag = 'Y'
761: , closed_count = l_rowcount
762: , closed_time = dbms_utility.get_time - l_timer
763: , closed_error_message = null
764: , last_update_date = sysdate
765: , last_updated_by = g_user_id
766: , last_update_login = g_login_id

Line 881: l_timer := dbms_utility.get_time;

877: end if;
878:
879: if l_backlog_flag = 'N' then
880:
881: l_timer := dbms_utility.get_time;
882:
883: if biv_dbi_collection_util.get_schema_name
884: (l_biv_schema, l_error_message) <> 0 then
885: raise l_exception;

Line 1277: , backlog_time = dbms_utility.get_time - l_timer

1273:
1274: update biv_dbi_collection_log
1275: set backlog_flag = 'Y'
1276: , backlog_count = l_rowcount
1277: , backlog_time = dbms_utility.get_time - l_timer
1278: , backlog_error_message = null
1279: , last_update_date = sysdate
1280: , last_updated_by = g_user_id
1281: , last_update_login = g_login_id

Line 1394: l_timer := dbms_utility.get_time;

1390: end if;
1391:
1392: if l_resolution_flag = 'N' then
1393:
1394: l_timer := dbms_utility.get_time;
1395:
1396: if biv_dbi_collection_util.get_schema_name
1397: (l_biv_schema, l_error_message) <> 0 then
1398: raise l_exception;

Line 1606: , resolution_time = dbms_utility.get_time - l_timer

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