APPS.CSD_BULK_RECEIVE_PVT SQL Statements

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

Line: 21

  Select *
  from csd_bulk_receive_items_b
  where transaction_number = p_transaction_number
  and incident_id is null
  and repair_line_id is null
  and internal_sr_flag = 'N'
  and change_owner_flag = 'N'
  and status  = 'NEW';

Line: 32

  select *
  from csd_bulk_receive_items_b
  where transaction_number = p_transaction_number
  and  status in ('NEW','ERRORED')
  and  change_owner_flag = 'Y'
  and  party_id is null
  and  internal_sr_flag = 'N';

Line: 42

  select *
  from csd_bulk_receive_items_b
  where transaction_number = p_transaction_number
  and  status in ('NEW','ERRORED')
  and  incident_id is null
  and  internal_sr_flag = 'Y';

Line: 51

  select csi.internal_party_id,
         hca.cust_account_id
  from csi_install_parameters csi,
       hz_cust_accounts hca
  where csi.internal_party_id = hca.party_id(+)
  and   hca.status(+) = 'A';

Line: 60

  select distinct party_id,cust_account_id
  from csd_bulk_receive_items_b
  where transaction_number = p_transaction_number
  and   status in ('NEW','ERRORED')
  and  incident_id is null
  and  party_id is not null
  and  internal_sr_flag = 'N';

Line: 70

  select *
  from  csd_bulk_receive_items_b
  where transaction_number = p_transaction_number
  and   incident_id = p_incident_id
  and   repair_line_id is null
  and   internal_sr_flag = 'N';

Line: 79

  select *
  from  csd_bulk_receive_items_b
  where transaction_number = p_transaction_number
  and   status = 'ERRORED'
  and   incident_id is not null
  and   repair_line_id is null
  and   internal_sr_flag = 'N';

Line: 89

  select *
  from csd_bulk_receive_items_b
  where transaction_number = p_transaction_number
  and status in ('NEW','ERRORED')
  and repair_line_id is not null
  and internal_sr_flag = 'N';

Line: 98

  select  dpt.prod_txn_status,
          edt.order_line_id,
	     edt.order_header_id,
	     dpt.source_serial_number
  from    csd_product_transactions dpt,
 		cs_estimate_details edt
  where   dpt.repair_line_id = p_repair_line_id
  and     dpt.action_type = 'RMA'
  and     dpt.prod_txn_status = 'BOOKED'
  and     dpt.estimate_detail_id = edt.estimate_detail_id
  and     edt.source_code = 'DR';

Line: 121

  Select comms_nl_trackable_flag,
         concatenated_segments,
         serial_number_control_code
  from mtl_system_items_kfv
  where inventory_item_id = p_inventory_item_id
  and organization_id = cs_std.get_item_valdn_orgzn_id;

Line: 130

  Select owner_party_id,
         owner_party_account_id
  from csi_item_instances
  where inventory_item_id = p_inventory_item_id
  and serial_number = p_serial_number;

Line: 138

  Select description
  from fnd_lookup_values_vl
  where lookup_type = 'CSD_BULK_RECEIVE_WARNINGS'
  and lookup_code = p_warning_code
  and enabled_flag = 'Y'
  and trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
      and trunc(nvl(end_date_active,sysdate));

Line: 315

	                    'Update: bulk_receive_id[' || c_set_party_rec.bulk_receive_id ||
	                    '] with IB owner party id - '||l_ib_owner_id);

Line: 319

            Update csd_bulk_receive_items_b
            set party_id = l_ib_owner_id,
                cust_account_id = l_ib_owner_acct_id
            where bulk_receive_id = c_set_party_rec.bulk_receive_id;

Line: 362

	              'Change IB owner,Update : bulk_receive_id['
	               || c_change_owner_rec.bulk_receive_id ||
	              '] party id with orig party id');

Line: 367

      Update csd_bulk_receive_items_b
      set party_id = orig_party_id
         ,cust_account_id = orig_cust_account_id
         ,status = 'NEW'
      where bulk_receive_id = c_change_owner_rec.bulk_receive_id;

Line: 481

      Update csd_bulk_receive_items_b
      set incident_id = l_incident_id,
          status = 'PROCESSED',
          party_id = l_intr_party_id,
          cust_account_id = l_intr_cust_acct_id
      where transaction_number = p_transaction_number
      and incident_id is null
      and internal_sr_flag = 'Y';

Line: 494

      Update csd_bulk_receive_items_b
      set status = 'ERRORED'
      where transaction_number = p_transaction_number
      and incident_id is null
      and internal_sr_flag = 'Y';

Line: 559

        Update csd_bulk_receive_items_b
        set repair_line_id = l_repair_line_id,
            status = 'PROCESSED'
        where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;

Line: 567

        Update csd_bulk_receive_items_b
        set repair_line_id = l_repair_line_id,
            status = 'NEW'
        where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;

Line: 593

	  Update csd_bulk_receive_items_b
	  set status = 'ERRORED'
	  where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;

Line: 637

      Update csd_bulk_receive_items_b
      set status = 'ERRORED'
      where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;

Line: 666

      for bk_rcv_rec in (select * from csd_bulk_receive_items_b
                where transaction_number = p_transaction_number)
      loop
        -- find out if the line is ready to be received.
        l_continue_further := true;

Line: 679

										'Calling csd_bulk_receive_util.update_external_reference');

Line: 681

             		  csd_repair_manager_util.update_external_reference(p_external_reference => bk_rcv_rec.external_reference,
					  	                        p_instance_id        => bk_rcv_rec.instance_id,
					  	                        x_return_status      => l_return_status,
					  							x_msg_count          => l_msg_count,
  							  					x_msg_data           => l_msg_data);

Line: 690

						select instance_id
						into bk_rcv_rec.instance_id
						from csd_repairs
						where repair_line_id = bk_rcv_rec.repair_line_id;

Line: 704

							Select ship_to_site_use_id
							into   l_instance_rec.party_site_use_id
							from  cs_incidents_all_b
							where incident_id = bk_rcv_rec.incident_id;

Line: 748

							    		   'Calling csd_mass_rcv_pvt.update_external_reference');

Line: 750

      				 	csd_repair_manager_util.update_external_reference(p_external_reference => bk_rcv_rec.external_reference,
											  	  p_instance_id        => bk_rcv_rec.instance_id,
											  	  x_return_status      => l_return_status,
												  x_msg_count          => l_msg_count,
  							  					  x_msg_data           => l_msg_data);

Line: 772

		    -- update the bulk receive record as errored.
		    update csd_bulk_receive_items_b
		    set    status = 'ERRORED'
		    where bulk_receive_id = bk_rcv_rec.bulk_receive_id;

Line: 852

             update csd_bulk_receive_items_b
             set    status = 'ERRORED'
             where  bulk_receive_id = bk_rcv_rec.bulk_receive_id;

Line: 993

					    -- update the bulk receive record as errored.
					    update csd_bulk_receive_items_b
					    set    status = 'ERRORED'
					    where bulk_receive_id = bk_rcv_rec.bulk_receive_id;

Line: 1044

             		  csd_repair_manager_util.update_external_reference(p_external_reference => bk_rcv_rec.external_reference,
					  	                        p_instance_id        => bk_rcv_rec.instance_id,
					  	                        x_return_status      => l_return_status,
					  							x_msg_count          => l_msg_count,
  							  					x_msg_data           => l_msg_data);

Line: 1053

						select instance_id
						into bk_rcv_rec.instance_id
						from csd_repairs
						where repair_line_id = bk_rcv_rec.repair_line_id;

Line: 1067

							Select ship_to_site_use_id
							into   l_instance_rec.party_site_use_id
							from  cs_incidents_all_b
							where incident_id = bk_rcv_rec.incident_id;

Line: 1104

      				 	csd_repair_manager_util.update_external_reference(p_external_reference => bk_rcv_rec.external_reference,
											  	  p_instance_id        => bk_rcv_rec.instance_id,
											  	  x_return_status      => l_return_status,
												  x_msg_count          => l_msg_count,
  							  					  x_msg_data           => l_msg_data);

Line: 1135

               update csd_bulk_receive_items_b
               set    status = 'ERRORED'
               where  bulk_receive_id = bk_rcv_rec.bulk_receive_id;

Line: 1142

	       -- update the csd_product_transactions table to mark it as unplanned.

            update csd_product_transactions
            set unplanned_receipt_flag = 'Y'
            where repair_line_id    = bk_rcv_rec.repair_line_id
            and   action_type = 'RMA';

Line: 1176

               	update csd_bulk_receive_items_b
               	set    status = 'ERRORED'
               	where  bulk_receive_id = bk_rcv_rec.bulk_receive_id;

Line: 1185

             update csd_bulk_receive_items_b
             set repair_line_id = l_repair_line_id
             where bulk_receive_id = bk_rcv_rec.bulk_receive_id;

Line: 1196

				update csd_bulk_receive_items_b
				set  status = 'PROCESSED'
				where bulk_receive_id = bk_rcv_rec.bulk_receive_id;

Line: 1224

				   update csd_bulk_receive_items_b
				   set    status = 'ERRORED'
				   where  bulk_receive_id = bk_rcv_rec.bulk_receive_id;

Line: 1232

					select ced.order_header_id,ced.order_line_id
					into bk_rcv_rec.order_header_id,bk_rcv_rec.order_line_id
					from csd_product_transactions cpt,
						 cs_estimate_details ced
					where cpt.repair_line_id = l_repair_line_id
					and   ced.estimate_detail_id = cpt.estimate_detail_id
					and   cpt.action_type = 'RMA';

Line: 1268

				 -- update product transactions and mark it as unplanned.
				 update csd_product_transactions
				 set unplanned_receipt_flag = 'Y'
				 where repair_line_id    = l_repair_line_id
				 and   action_type = 'RMA';

Line: 1377

      Update csd_bulk_receive_items_b
      set incident_id = l_incident_id,
          status = 'NEW'
      where transaction_number = p_transaction_number
      and party_id = c_create_sr_rec.party_id
      and cust_account_id = c_create_sr_rec.cust_account_id
      and incident_id is null
      and internal_sr_flag = 'N';

Line: 1392

      Update csd_bulk_receive_items_b
      set status = 'ERRORED'
      where party_id = c_create_sr_rec.party_id
      and cust_account_id = c_create_sr_rec.cust_account_id
      and incident_id is null
      and internal_sr_flag = 'N';

Line: 1454

            Update csd_bulk_receive_items_b
	    	  set repair_line_id = l_repair_line_id,
	    	  status = 'PROCESSED'
	    where bulk_receive_id = c_create_ro_rec.bulk_receive_id;

Line: 1462

            Update csd_bulk_receive_items_b
            set repair_line_id = l_repair_line_id,
                status = 'NEW'
            where bulk_receive_id = c_create_ro_rec.bulk_receive_id;

Line: 1490

	      Update csd_bulk_receive_items_b
	      set status = 'ERRORED'
	      where bulk_receive_id = c_create_ro_rec.bulk_receive_id;

Line: 1536

	  Update csd_bulk_receive_items_b
          set status = 'ERRORED'
	  where bulk_receive_id = c_create_ro_rec.bulk_receive_id;

Line: 1552

		    update csd_product_transactions
		    set unplanned_receipt_flag = 'Y'
		    where repair_line_id    = l_repair_line_id
		    and   action_type = 'RMA';