eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RESERVATION_PUB SQL Statements

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

Line: 374


                mydebug('Need to update reservation record',l_api_name,9);

Line: 379


                mydebug('Reservation record that needs to be updated',l_api_name,9);

Line: 416


                  mydebug('Calling update reservations to update reservation record',l_api_name,9);

Line: 420


     inv_reservation_pub.update_reservation
     (p_api_version_number          => 1.0,
     p_init_msg_lst                => fnd_api.g_false,
     x_return_status               => l_return_status,
     x_msg_count                   => x_msg_count,
     x_msg_data                    => x_msg_data,
     x_quantity_reserved           => l_quantity_reserved,
     x_secondary_quantity_reserved => l_secondary_quantity_reserved,  -- INVCONV
     p_original_rsv_rec            => l_mtl_reservation_tbl(i),
     p_to_rsv_rec                  => l_to_rsv_rec,
     p_original_serial_number      => p_serial_number,
     p_to_serial_number            => p_serial_number,
     p_validation_flag             => fnd_api.g_true,
     p_partial_reservation_flag    => p_partial_reservation_flag,
     p_check_availability          => fnd_api.g_true
     );

Line: 467


            l_rsv_updated := TRUE;

Line: 481


   IF NOT l_rsv_updated  THEN

     --End. Commenting the code as this is moved to the private package
     ********************/
     /*** End R12 ***/

      l_progress := 180;

Line: 605


PROCEDURE update_reservation
  (
     p_api_version_number            IN  NUMBER
   , p_init_msg_lst                  IN  VARCHAR2 DEFAULT fnd_api.g_false
   , x_return_status                 OUT NOCOPY VARCHAR2
   , x_msg_count                     OUT NOCOPY NUMBER
   , x_msg_data                      OUT NOCOPY VARCHAR2
   , x_quantity_reserved             OUT NOCOPY NUMBER
   , x_secondary_quantity_reserved   OUT NOCOPY NUMBER
   , p_original_rsv_rec              IN  inv_reservation_global.mtl_reservation_rec_type
   , p_to_rsv_rec                    IN  inv_reservation_global.mtl_reservation_rec_type
   , p_original_serial_number        IN  inv_reservation_global.serial_number_tbl_type
   , p_to_serial_number              IN  inv_reservation_global.serial_number_tbl_type
   , p_validation_flag               IN  VARCHAR2 DEFAULT fnd_api.g_true
   , p_partial_reservation_flag      IN  VARCHAR2 DEFAULT fnd_api.g_false
   , p_check_availability            IN  VARCHAR2 DEFAULT fnd_api.g_false
   , p_over_reservation_flag         IN  NUMBER DEFAULT 0
   ) IS


     l_api_version_number 	 	CONSTANT NUMBER       := 1.0;

Line: 626


     l_api_name           	        CONSTANT VARCHAR2(30) := 'Update_Reservation';

Line: 662


   inv_reservation_pvt.update_reservation
     (
        p_api_version_number        => 1.0
      , p_init_msg_lst              => fnd_api.g_false
      , x_return_status             => l_return_status
      , x_msg_count                 => x_msg_count
      , x_msg_data                  => x_msg_data
      , x_quantity_reserved         => l_quantity_reserved
      , x_secondary_quantity_reserved => l_secondary_quantity_reserved
      , p_original_rsv_rec	         => p_original_rsv_rec
      , p_to_rsv_rec	               => p_to_rsv_rec
      , p_original_serial_number    => p_original_serial_number
      , p_to_serial_number	         => p_to_serial_number
      , p_validation_flag           => p_validation_flag
      , p_partial_reservation_flag  => p_partial_reservation_flag
      , p_check_availability        => p_check_availability
      , p_over_reservation_flag     => p_over_reservation_flag
      );

Line: 730


END update_reservation;

Line: 735


PROCEDURE update_reservation
  (
     p_api_version_number            IN  NUMBER
   , p_init_msg_lst                  IN  VARCHAR2 DEFAULT fnd_api.g_false
   , x_return_status                 OUT NOCOPY VARCHAR2
   , x_msg_count                     OUT NOCOPY NUMBER
   , x_msg_data                      OUT NOCOPY VARCHAR2
   , p_original_rsv_rec              IN  inv_reservation_global.mtl_reservation_rec_type
   , p_to_rsv_rec                    IN  inv_reservation_global.mtl_reservation_rec_type
   , p_original_serial_number        IN  inv_reservation_global.serial_number_tbl_type
   , p_to_serial_number              IN  inv_reservation_global.serial_number_tbl_type
   , p_validation_flag               IN  VARCHAR2 DEFAULT fnd_api.g_true
   , p_check_availability            IN  VARCHAR2 DEFAULT fnd_api.g_false
   , p_over_reservation_flag         IN  NUMBER DEFAULT 0
   ) IS


     l_api_version_number 	 CONSTANT NUMBER       :=  1.0;

Line: 753


     l_api_name           	 CONSTANT VARCHAR2(30) := 'Update_Reservation';

Line: 775


     mydebug('Calling the overloaded procedure update_reservation',l_api_name,9);

Line: 779


   inv_reservation_pub.update_reservation
     (p_api_version_number          => 1.0,
      p_init_msg_lst                => fnd_api.g_false,
      x_return_status               => l_return_status,
      x_msg_count                   => x_msg_count,
      x_msg_data                    => x_msg_data,
      x_quantity_reserved           => l_quantity_reserved,
      x_secondary_quantity_reserved => l_secondary_quantity_reserved,
      p_original_rsv_rec            => p_original_rsv_rec,
      p_to_rsv_rec                  => p_to_rsv_rec,
      p_original_serial_number      => p_original_serial_number ,
      p_to_serial_number            => p_to_serial_number,
      p_validation_flag             => p_validation_flag,
      p_partial_reservation_flag    => fnd_api.g_false,
      p_check_availability          => p_check_availability,
      p_over_reservation_flag       => p_over_reservation_flag
      );

Line: 858


END update_reservation;

Line: 1075


PROCEDURE delete_reservation
  (
     p_api_version_number       IN  NUMBER
   , p_init_msg_lst             IN  VARCHAR2 DEFAULT fnd_api.g_false
   , x_return_status            OUT NOCOPY VARCHAR2
   , x_msg_count                OUT NOCOPY NUMBER
   , x_msg_data                 OUT NOCOPY VARCHAR2
   , p_rsv_rec
            IN  inv_reservation_global.mtl_reservation_rec_type
   , p_serial_number
             IN  inv_reservation_global.serial_number_tbl_type
   )IS
     l_api_version_number 	 CONSTANT NUMBER       := 1.0;

Line: 1088


     l_api_name           	 CONSTANT VARCHAR2(30) := 'Delete_Reservation';

Line: 1105


   inv_reservation_pvt.delete_reservation
  (
     p_api_version_number       => 1.0
   , p_init_msg_lst             => fnd_api.g_false
   , x_return_status            => l_return_status
   , x_msg_count                => x_msg_count
   , x_msg_data                 => x_msg_data
   , p_rsv_rec			=> p_rsv_rec
   , p_original_serial_number	=> p_serial_number
   , p_validation_flag          => fnd_api.g_true
   );

Line: 1164


END delete_reservation;