DBA Data[Home] [Help]

APPS.JG_ZZ_AUTO_INVOICE SQL Statements

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

Line: 24

  INSERT INTO ra_interface_errors
             (interface_line_id,
              message_text,
              org_id,
              invalid_value)
  VALUES     (p_interface_line_id,
              message_text,
              l_org_id,
              p_invalid_value);
Line: 64

  INSERT
    INTO ra_interface_errors
        (interface_line_id
       , message_text
       , org_id
       , invalid_value)
  VALUES
        (l_interface_line_id
       , l_message_text
       , l_org_id
       , l_invalid_value);
Line: 80

    arp_standard.debug('-- Cannot insert error messages '
                    || 'into ra_interface_errors.');
Line: 102

   INSERT INTO jl_autoinv_int_lines
                      (interface_line_ref,
                       message_text,
                       invalid_value,
                       org_id)
           VALUES     (p_interface_line_ref,
                       message_text,
                       p_invalid_value,
                       l_org_id);