DBA Data[Home] [Help]

APPS.INV_CC_RESERVATIONS_PVT SQL Statements

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

Line: 16

PROCEDURE Delete_All_Reservation
(
   p_api_version_number      IN         NUMBER
,  p_init_msg_lst            IN         VARCHAR2 DEFAULT fnd_api.g_false
,  p_mtl_reservation_rec     IN         INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE
,  x_error_code              OUT NOCOPY NUMBER
,  x_return_status           OUT NOCOPY VARCHAR2
,  x_msg_count               OUT NOCOPY NUMBER
,  x_msg_data                OUT NOCOPY VARCHAR2
)

IS
   l_api_version_number   CONSTANT NUMBER      := 1.0;
Line: 30

   l_api_name             CONSTANT VARCHAR2(30) := 'INV_Delete_All_Reservations';
Line: 61

     inv_reservation_pub.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                => l_msg_count
      , x_msg_data                 => l_msg_data
      , p_rsv_rec                  => l_mtl_reservation_rec
      , p_serial_number            => l_serial_number
      );
Line: 98

            ,   'INV_Delete_All_Reservations'
            );