APPS.PO_INTERFACE_ERRORS_PVT SQL Statements

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

Line: 59

PROCEDURE insert_row
( p_api_version   IN         NUMBER,
  p_init_msg_list IN         VARCHAR2,
  p_commit        IN         VARCHAR2,
  x_return_status OUT NOCOPY VARCHAR2,
  x_msg_count     OUT NOCOPY NUMBER,
  x_msg_data      OUT NOCOPY VARCHAR2,
  p_rec           IN         PO_INTERFACE_ERRORS%ROWTYPE,
  x_row_id        OUT NOCOPY ROWID
) IS

l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line: 97

        SELECT po_interface_errors_s.NEXTVAL
        INTO   l_interface_transaction_id
        FROM   DUAL;

Line: 104

    INSERT INTO po_interface_errors
    ( interface_type,
      interface_transaction_id,
      column_name,
      error_message,
      processing_date,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      error_message_name,
      table_name,
      batch_id,
      interface_header_id,
      interface_line_id,
      interface_distribution_id
    )
    VALUES
    ( NVL(p_rec.interface_type, 'UNKNOWN'),
      l_interface_transaction_id,
      p_rec.column_name,
      p_rec.error_message,
      p_rec.processing_date,
      SYSDATE,
      FND_GLOBAL.USER_ID,
      SYSDATE,
      FND_GLOBAL.USER_ID,
      FND_GLOBAL.LOGIN_ID,
      FND_GLOBAL.CONC_REQUEST_ID,
      FND_GLOBAL.PROG_APPL_ID,
      FND_GLOBAL.CONC_PROGRAM_ID,
      p_rec.program_update_date,
      p_rec.error_message_name,
      p_rec.table_name,
      p_rec.batch_id,
      p_rec.interface_header_id,
      p_rec.interface_line_id,
      p_rec.interface_distribution_id
    )
    RETURNING
      ROWID
    INTO
      x_row_id;

Line: 174

END insert_row;