APPS.WIP_INTERFACE_ERR_UTILS SQL Statements

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

Line: 7

procedure     insert_error(p_interface_id        IN number,
                           p_error_type          IN Varchar2,
                           p_error               IN Varchar2,
                           p_last_update_date    IN Date,
                           p_creation_date       IN Date,
                           p_created_by          IN Number,
                           p_last_update_login   IN Number,
                           p_updated_by          IN Number);

Line: 41

  l_last_update_login  number := fnd_global.login_id;

Line: 42

  l_last_updated_by    number := fnd_global.user_id;

Line: 67

       select last_update_login,
              last_updated_by,
              created_by
       into   l_last_update_login,
              l_last_updated_by,
              l_created_by
       from   wip_job_schedule_interface
       where  interface_id = current_errors(error_no).interface_id;

Line: 83

            select last_update_login,
                   last_updated_by,
                   created_by
            into   l_last_update_login,
                   l_last_updated_by,
                   l_created_by
            from   wip_job_dtls_interface
            where  interface_id = current_errors(error_no).interface_id;

Line: 105

     insert_error(p_interface_id => current_errors(error_no).interface_id,
                  p_error_type   => current_errors(error_no).error_type,
                  p_error        => current_errors(error_no).error,
                  p_last_update_date => sysdate,
                  p_creation_date    => sysdate,
                  p_created_by       => l_created_by,
                  p_last_update_login => l_last_update_login,
                  p_updated_by        => l_last_updated_by);

Line: 122

  current_errors.delete ;

Line: 133

 procedure     insert_error(p_interface_id        IN number,
                            p_error_type          IN Varchar2,
                            p_error               IN Varchar2,
                            p_last_update_date    IN Date,
                            p_creation_date       IN Date,
                            p_created_by          IN Number,
                            p_last_update_login   IN Number,
                            p_updated_by          IN Number) is
 PRAGMA AUTONOMOUS_TRANSACTION;

Line: 143

   insert into  wip_interface_errors
     (interface_id,
      error_type,
      error,
      last_update_date,
      creation_date,
      created_by,
      last_update_login,
      last_updated_by
    )
  Values
    (p_interface_id,
     p_error_type,
     p_error,
     p_last_update_date,
     p_creation_date,
     p_created_by,
     p_last_update_login,
     p_updated_by);

Line: 163

 End insert_error;