APPS.MTL_CCEOI_ACTION_PVT SQL Statements

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

Line: 61

      MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
	p_interface_rec=> p_interface_rec,
	x_return_status => x_return_status);

Line: 89

   MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
     p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
     p_error_column_name => p_error_column_name,
     p_error_table_name => p_error_table_name,
     p_message_name => p_message_name );

Line: 225

       MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
          p_interface_rec.cc_entry_interface_id);

Line: 229

       MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
          p_interface_rec=> p_interface_rec,
          x_return_status => L_return_status);

Line: 391

     MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
       p_interface_rec.cc_entry_interface_id);

Line: 459

   	   MDEBUG( 'Create_CountRequest: Inserting CC Request');

Line: 469

	      -- insert count request into mtl_cycle_count_entries
	      MTL_CCEOI_PROCESS_PVT.Insert_CCEntry(
		p_interface_rec=> p_interface_rec);

Line: 495

		 -- update CCI entry with cycle count entry id
		 -- from that point no SKU changes can be made
		 MTL_CCEOI_PROCESS_PVT.Update_CCIEntry(l_interface_rec,
		   x_return_status);

Line: 508

		 update mtl_cc_entries_interface
		   set
		   cycle_count_entry_id =
		     l_cycle_count_entry_id
		   where cc_entry_interface_id =
		     l_interface_rec.cc_entry_interface_id;

Line: 685

      MDEBUG( 'Process: Delete all errors ');

Line: 688

   MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
     p_interface_rec.cc_entry_interface_id);

Line: 765

	      -- after insertion of errors
	      -- XXX this whole thing will have to go once
	      -- we verify that return status is working ok
	      L_err_count := 0;

Line: 770

		 select count(*)
		   into L_err_count
		   from mtl_cc_interface_errors
		   where cc_entry_interface_id =
		   p_interface_rec.cc_entry_interface_id;

Line: 839

		    MTL_CCEOI_PROCESS_PVT.Update_CCEntry(
		      MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID);

Line: 1014

          SELECT msi.tracking_quantity_ind
               , msi.secondary_default_ind
               , msi.secondary_uom_code
               , msi.process_costing_enabled_flag
               , mtp.process_enabled_flag
            FROM mtl_system_items msi, mtl_parameters mtp
           WHERE mtp.organization_id = cp_organization_id
             AND msi.organization_id = mtp.organization_id
             AND msi.inventory_item_id = cp_inventory_item_id;

Line: 1057

       MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
	 p_interface_rec.cc_entry_interface_id);

Line: 1061

          mdebug('Validate_CountRequest: Deleted errors');

Line: 1136

	    select next_user_count_sequence
	      into MTL_CCEOI_VAR_PVT.G_Seq_No
	      FROM mtl_cycle_count_headers where
	      cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID;

Line: 1151

	       select count(*)
		 into l_same_seq_not_closed_entries
		 from mtl_cycle_count_entries
		 where count_list_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No
		 and cycle_count_header_id =  MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID
		 and entry_status_code not in (4, 5);

Line: 1167

           update mtl_cycle_count_headers
           set next_user_count_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No + 1
           where cycle_count_header_id = p_interface_rec.cycle_count_header_id;

Line: 1502

   	     MDEBUG('Inserting interface entry');

Line: 1504

             MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
              p_interface_rec => p_interface_rec,
              x_return_status => L_return_status);

Line: 1649

       MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
          p_interface_rec.cc_entry_interface_id);

Line: 1667

	     MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
	       p_interface_rec => p_interface_rec,
	       x_return_status => L_return_status);

Line: 1743

  PROCEDURE Update_Insert_CountRequest(
  p_api_version IN NUMBER ,
  p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
  p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
  p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
  x_return_status OUT NOCOPY VARCHAR2 ,
  x_msg_count OUT NOCOPY NUMBER ,
  x_msg_data OUT NOCOPY VARCHAR2 ,
  p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
  IS
    l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line: 1802

       L_api_name CONSTANT VARCHAR2(30) := 'UpdateInsert_CountRequest';

Line: 1805

       SAVEPOINT UpdateInsert_CountRequest;

Line: 1835

       SELECT cc_entry_interface_id
       INTO
          L_dummy
       FROM
          mtl_cc_entries_interface
       WHERE
          cc_entry_interface_id =
          p_interface_rec.cc_entry_interface_id;

Line: 1845

       MTL_CCEOI_PROCESS_PVT.Update_CCIEntry(
          p_interface_rec => p_interface_rec
          , x_return_status => L_return_status);

Line: 1850

          FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_UPDATE_FAILED');

Line: 1858

          Mdebug('Before Insert_CCIEntry');

Line: 1861

       MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
          p_interface_rec => p_interface_rec
          , x_return_status => L_return_status);

Line: 1866

          Mdebug('After Insert_CCIEntry');

Line: 1869

          FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_INSERT_FAILED');