APPS.BIV_DBI_COLLECTION_INC dependencies on BIV_DBI_COLLECTION_LOG

Line 671: update biv_dbi_collection_log

667: (l_biv_schema, 'BIV_DBI_COLLECTION_STG', l_error_message) <> 0 then
668: raise l_exception;
669: end if;
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

Line 934: update biv_dbi_collection_log

930: bis_collection_utilities.log('Inserted ' || l_temp_rowcount || ' rows',2);
931:
932: end if;
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

Line 1098: update biv_dbi_collection_log

1094: l_rowcount := l_rowcount + l_temp_rowcount;
1095:
1096: bis_collection_utilities.log('Merged ' || l_temp_rowcount || ' rows',1);
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

Line 1288: update biv_dbi_collection_log

1284: l_rowcount := l_rowcount + l_temp_rowcount;
1285:
1286: bis_collection_utilities.log('Inserted ' || l_temp_rowcount || ' rows',2);
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

Line 1600: update biv_dbi_collection_log

1596: l_rowcount := l_rowcount + l_temp_rowcount;
1597:
1598: bis_collection_utilities.log('Merged ' || l_temp_rowcount || ' rows',1);
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

Line 1733: update biv_dbi_collection_log

1729: if l_process_success <> 0 then
1730: raise l_exception;
1731: end if;
1732:
1733: update biv_dbi_collection_log
1734: set success_flag = 'Y'
1735: , last_update_date = sysdate
1736: , last_updated_by = g_user_id
1737: , last_update_login = g_login_id

Line 1754: update biv_dbi_collection_log

1750: end if;
1751:
1752: end if;
1753:
1754: update biv_dbi_collection_log
1755: set last_collection_flag = 'N'
1756: , last_update_date = sysdate
1757: , last_updated_by = g_user_id
1758: , last_update_login = g_login_id

Line 1764: insert into biv_dbi_collection_log

1760:
1761: l_collect_from_date := l_collect_to_date + (1/86400);
1762: l_collect_to_date := l_target_date;
1763:
1764: insert into biv_dbi_collection_log
1765: ( last_collection_flag
1766: , process_type
1767: , collect_from_date
1768: , collect_to_date

Line 1821: update biv_dbi_collection_log

1817: if l_process_success <> 0 then
1818: raise l_exception;
1819: end if;
1820:
1821: update biv_dbi_collection_log
1822: set success_flag = 'Y'
1823: , last_update_date = sysdate
1824: , last_updated_by = g_user_id
1825: , last_update_login = g_login_id

Line 1867: -- refresh for biv_dbi_collection_log. this is because the

1863: begin
1864:
1865: -- this is a noop procedure.
1866: -- we need to register a concurrent program to run for incremental
1867: -- refresh for biv_dbi_collection_log. this is because the
1868: -- "Data Last Updated" calculation for reports checks the
1869: -- completion date for the object. without this, the completion
1870: -- date is always the initial load date.
1871: