APPS.BIV_DBI_COLLECTION_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 97

  update biv_dbi_collection_log
  set staging_error_message = decode(p_staging_error, null, staging_error_message
                                                      , p_staging_error)
    , activity_error_message = decode(p_activity_error, null, activity_error_message
                                                      , p_activity_error)
    , closed_error_message = decode(p_closed_error, null, closed_error_message
                                                    , p_closed_error)
    , backlog_error_message = decode(p_backlog_error, null, backlog_error_message
                                                    , p_backlog_error)
    , resolution_error_message = decode(p_resolution_error, null, resolution_error_message
                                                    , p_resolution_error)
    , last_update_date = sysdate
    , last_updated_by = g_user_id
    , last_update_login = g_login_id
  where rowid = p_rowid;

Line: 115

    bis_collection_utilities.log('Unable to update biv_dbi_collection_log with error:');

Line: 134

    select
      rowid
    , process_type
    , collect_from_date
    , collect_to_date
    , success_flag
    , staging_table_flag
    , activity_flag
    , closed_flag
    , backlog_flag
    , resolution_flag
    from
      biv_dbi_collection_log
    where
        last_collection_flag = 'Y';