APPS.RCV_SHIPMENT_OBJECT_SV SQL Statements

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

Line: 99

               UPDATE rcv_headers_interface
                  SET processing_status_code = 'SUCCESS',
                      validation_flag = 'N',
                      receipt_header_id = x_header_record.header_record.receipt_header_id
                WHERE header_interface_id = x_header_record.header_record.header_interface_id;

Line: 124

               UPDATE rcv_headers_interface
                  SET processing_status_code = 'ERROR'
                WHERE header_interface_id = x_header_record.header_record.header_interface_id;

Line: 128

               UPDATE rcv_transactions_interface
                  SET processing_status_code = 'ERROR'
                WHERE header_interface_id = x_header_record.header_record.header_interface_id;

Line: 133

               /* WDK - we've already inserted an error into po_interface_errors. isn't this redundant? */
               x_header_record.error_record.error_status  := rcv_error_pkg.g_ret_sts_error;

Line: 168

               x_cascaded_table.DELETE;

Line: 289

                     DELETE FROM rcv_shipment_headers
                           WHERE shipment_header_id = x_header_record.header_record.receipt_header_id;

Line: 293

                  UPDATE rcv_headers_interface
                     SET processing_status_code = 'ERROR'
                   WHERE header_interface_id = x_header_record.header_record.header_interface_id;

Line: 297

                  UPDATE rcv_transactions_interface
                     SET processing_status_code = 'ERROR'
                   WHERE header_interface_id = x_header_record.header_record.header_interface_id;

Line: 308

                     rcv_asn_trx_insert.handle_rcv_asn_transactions(x_cascaded_table, x_header_record);

Line: 353

                     UPDATE rcv_headers_interface
                        SET invoice_status_code = 'RCV_ASBN_NO_AUTO_INVOICE',
                            processing_status_code = 'SUCCESS',
                            validation_flag = 'N',
                            receipt_header_id = x_header_record.header_record.receipt_header_id
                      WHERE header_interface_id = x_header_record.header_record.header_interface_id;

Line: 362

                     UPDATE rcv_shipment_headers
                        SET invoice_status_code = 'RCV_ASBN_NO_AUTO_INVOICE'
                      WHERE shipment_header_id = x_header_record.header_record.receipt_header_id;

Line: 366

                     UPDATE rcv_headers_interface
                        SET processing_status_code = 'SUCCESS',
                            validation_flag = 'N',
                            receipt_header_id = x_header_record.header_record.receipt_header_id
                      WHERE header_interface_id = x_header_record.header_record.header_interface_id;

Line: 395

               UPDATE rcv_headers_interface
                  SET processing_status_code = 'ERROR'
                WHERE header_interface_id = x_header_record.header_record.header_interface_id;

Line: 399

               UPDATE rcv_transactions_interface
                  SET processing_status_code = 'ERROR'
                WHERE header_interface_id = x_header_record.header_record.header_interface_id;

Line: 411

          * will insert records into ECE_ADVO_HEADERS and ECE_ADVO_DETAILS.
          */

         /* ksareddy call this for ASN or ASBNS */
         IF (x_header_record.header_record.asn_type IN('ASN', 'ASBN')) THEN
            IF g_is_edi_installed = 'I' THEN
               rcv_824_sv.rcv_824_insert(x_header_record, 'ASN');   /* NWANG: changed to two parameters for RCV824 */