APPS.BIV_DBI_COLLECTION_INIT dependencies on BIV_DBI_COLLECTION_LOG

Line 22: biv_dbi_collection_log

18: , closed_flag
19: , backlog_flag
20: , resolution_flag
21: from
22: biv_dbi_collection_log
23: where
24: rowid = p_rowid
25: for update of success_flag;
26:

Line 52: update biv_dbi_collection_log

48: l_closed_flag = 'Y' and
49: l_backlog_flag = 'Y' and
50: l_resolution_flag = 'Y' then
51:
52: update biv_dbi_collection_log
53: set success_flag = 'Y'
54: , last_update_date = sysdate
55: , last_updated_by = g_user_id
56: , last_update_login = g_login_id

Line 142: update biv_dbi_collection_log

138:
139: if nvl(l_success_flag,'Y') = 'Y' then
140:
141: if l_log_rowid is not null then
142: update biv_dbi_collection_log
143: set last_collection_flag = 'N'
144: , last_update_date = sysdate
145: , last_updated_by = g_user_id
146: , last_update_login = g_login_id

Line 247: insert into biv_dbi_collection_log

243:
244:
245: END IF;
246:
247: insert into biv_dbi_collection_log
248: ( last_collection_flag
249: , process_type
250: , collect_from_date
251: , collect_to_date

Line 492: update biv_dbi_collection_log

488: l_rowcount := sql%rowcount;
489:
490: bis_collection_utilities.log('Inserted ' || l_rowcount || ' rows');
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

Line 759: update biv_dbi_collection_log

755: l_rowcount := sql%rowcount;
756:
757: bis_collection_utilities.log('Inserted ' || l_rowcount || ' rows');
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

Line 1274: update biv_dbi_collection_log

1270: l_rowcount := sql%rowcount;
1271:
1272: bis_collection_utilities.log('Inserted ' || l_rowcount || ' rows');
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

Line 1603: update biv_dbi_collection_log

1599: l_rowcount := sql%rowcount;
1600:
1601: bis_collection_utilities.log('Inserted ' || l_rowcount || ' rows');
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