APPS.RCV_SHIPMENT_HEADER_SV SQL Statements

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

Line: 23

            rcv_headers_interface_sv.insert_shipment_header(x_header_record);

Line: 26

    /* Check for test flag and make sure the records are not inserted for
       the test flag = 'Y' case */
    /* If no fatal errors were detected at the header_level and at least
       one line did not have fatal errors and TEST_FLAG = 'P', populate
       the RCV_SHIPMENT_HEADERS with the header info. */
   /* If type != ASBN set processing_status_code =
         "Not processable for invoice creation" */

   /* If type = ASBN and any lines fail validation then
        set processing_status_code =
          "Not processable for invoice creation" */
   EXCEPTION
      WHEN OTHERS THEN
         rcv_error_pkg.set_sql_error_message('create_shipment_header', '000');

Line: 72

            rcv_asn_trx_insert.insert_cancelled_asn_lines(x_header_record);