APPS.CAC_BOOKINGS_PUB SQL Statements

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

Line: 63

         p_date_selected => 'S',
		 p_show_on_calendar => 'Y',
		 p_entity           => 'BOOKING',
		 p_free_busy_type => l_booking_type_rec.freebusytype,
         p_enable_workflow	    => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
         p_abort_workflow	    => fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),
         p_reference_flag => 'N',
         p_task_confirmation_status => NULL,
         p_task_confirmation_counter => NULL,
         p_task_split_flag  => NULL,
		 x_return_status => x_return_status,
         x_msg_count => x_msg_count,
         x_msg_data => x_msg_data,
         x_task_id => x_booking_id
      );

Line: 112

   PROCEDURE update_booking (
      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_booking_rec        IN              cac_bookings_pub.booking_type,
      p_object_version_number   IN         NUMBER ,
      x_return_status      OUT NOCOPY      VARCHAR2,
      x_msg_count          OUT NOCOPY      NUMBER,
      x_msg_data           OUT NOCOPY      VARCHAR2
   )

   IS
      l_api_version   CONSTANT NUMBER
               := 1.0;

Line: 127

               := 'UPDATE_BOOKING';

Line: 132

      SAVEPOINT update_bookings_pub;

Line: 186

	 jtf_tasks_pvt.update_task (
         p_api_version    => 1.0,
         p_init_msg_list  => fnd_api.g_false,
         p_commit         => fnd_api.g_false,
         p_object_version_number => l_ovn,
         p_task_id        => l_booking_type_rec.booking_id,
         p_task_name      => l_booking_type_rec.booking_subject,
         p_task_type_id   => l_booking_type_rec.booking_type_id,
         p_description    => l_booking_type_rec.description,
         p_owner_type_code => l_booking_type_rec.resource_type_code,
         p_owner_id        => l_booking_type_rec.resource_id,
         p_source_object_type_code => l_booking_type_rec.source_object_type_code,
         p_source_object_id => l_booking_type_rec.source_object_id,
         p_scheduled_start_date => l_booking_type_rec.start_date,
         p_scheduled_end_date => l_booking_type_rec.end_date,
         p_show_on_calendar => 'Y',
		 p_date_selected    => 'S',
		 p_free_busy_type   => l_booking_type_rec.freebusytype,
         p_enable_workflow	  => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
	     p_abort_workflow	  => fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),
	     p_change_mode	      => JTF_TASK_REPEAT_APPT_PVT.G_ONE,
         p_task_confirmation_status	=> NULL,
         p_task_confirmation_counter	=> NULL,
         p_task_split_flag         =>  NULL,
		 x_return_status    => x_return_status,
         x_msg_count        => x_msg_count,
         x_msg_data         => x_msg_data
      );

Line: 229

         ROLLBACK TO update_bookings_pub;

Line: 237

         ROLLBACK TO update_bookings_pub;

Line: 401

   PROCEDURE delete_booking (
      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_booking_id      IN              NUMBER,
	  p_object_version_number   IN      NUMBER ,
      x_return_status   OUT NOCOPY      VARCHAR2,
      x_msg_count       OUT NOCOPY      NUMBER,
      x_msg_data        OUT NOCOPY      VARCHAR2
   )
   IS
      l_api_version   CONSTANT NUMBER
               := 1.0;

Line: 415

               := 'DELETE_BOOKING';

Line: 423

      SAVEPOINT delete_bookings_pub;

Line: 450

      jtf_tasks_pvt.delete_task (
         p_api_version => 1.0,
         p_init_msg_list => fnd_api.g_false,
         p_commit => fnd_api.g_false,
         p_object_version_number => l_ovn,
         p_task_id => l_task_id,
         x_return_status => x_return_status,
         x_msg_count => x_msg_count,
         x_msg_data => x_msg_data
      );

Line: 475

         ROLLBACK TO delete_bookings_pub;

Line: 483

         ROLLBACK TO delete_bookings_pub;