APPS.OTA_BOOKING_STATUS_TYPE_API SQL Statements

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

Line: 260

procedure UPDATE_BOOKING_STATUS_TYPE
  (p_validate                     in     boolean  default false
  ,p_effective_date                 in     date
  ,p_business_group_id              in     number
  ,p_active_flag                    in     varchar2 default hr_api.g_varchar2
  ,p_default_flag                   in     varchar2 default hr_api.g_varchar2
  ,p_name                           in     varchar2 default hr_api.g_varchar2
  ,p_type                           in     varchar2 default hr_api.g_varchar2
  ,p_place_used_flag                in     varchar2 default hr_api.g_varchar2
  ,p_comments                       in     varchar2 default hr_api.g_varchar2
  ,p_description                    in     varchar2 default hr_api.g_varchar2
  ,p_bst_information_category       in     varchar2 default hr_api.g_varchar2
  ,p_bst_information1               in     varchar2 default hr_api.g_varchar2
  ,p_bst_information2               in     varchar2 default hr_api.g_varchar2
  ,p_bst_information3               in     varchar2 default hr_api.g_varchar2
  ,p_bst_information4               in     varchar2 default hr_api.g_varchar2
  ,p_bst_information5               in     varchar2 default hr_api.g_varchar2
  ,p_bst_information6               in     varchar2 default hr_api.g_varchar2
  ,p_bst_information7               in     varchar2 default hr_api.g_varchar2
  ,p_bst_information8               in     varchar2 default hr_api.g_varchar2
  ,p_bst_information9               in     varchar2 default hr_api.g_varchar2
  ,p_bst_information10              in     varchar2 default hr_api.g_varchar2
  ,p_bst_information11              in     varchar2 default hr_api.g_varchar2
  ,p_bst_information12              in     varchar2 default hr_api.g_varchar2
  ,p_bst_information13              in     varchar2 default hr_api.g_varchar2
  ,p_bst_information14              in     varchar2 default hr_api.g_varchar2
  ,p_bst_information15              in     varchar2 default hr_api.g_varchar2
  ,p_bst_information16              in     varchar2 default hr_api.g_varchar2
  ,p_bst_information17              in     varchar2 default hr_api.g_varchar2
  ,p_bst_information18              in     varchar2 default hr_api.g_varchar2
  ,p_bst_information19              in     varchar2 default hr_api.g_varchar2
  ,p_bst_information20              in     varchar2 default hr_api.g_varchar2
  ,p_booking_status_type_id         in	   number default hr_api.g_number
  ,p_object_version_number          in out    nocopy number
--  ,p_data_source                    in     varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Update Training Plan';

Line: 308

  savepoint UPDATE_BOOKING_STATUS_TYPE;

Line: 319

    OTA_BOOKING_STATUS_TYPE_BK2.UPDATE_BOOKING_STATUS_TYPE_B
  (p_effective_date                 => l_effective_date
      ,p_business_group_id	        => p_business_group_id
      ,p_active_flag                    => p_active_flag
      ,p_default_flag                   => p_default_flag
      ,p_place_used_flag                => p_place_used_flag
      ,p_name                           => p_name
      ,p_type                           => p_type
      ,p_comments                       => p_comments
      ,p_description                    => p_description
      ,p_bst_information_category       => p_bst_information_category
      ,p_bst_information1		=> p_bst_information1
      ,p_bst_information2		=> p_bst_information2
      ,p_bst_information3		=> p_bst_information3
      ,p_bst_information4		=> p_bst_information4
      ,p_bst_information5		=> p_bst_information5
      ,p_bst_information6		=> p_bst_information6
      ,p_bst_information7		=> p_bst_information7
      ,p_bst_information8		=> p_bst_information8
      ,p_bst_information9		=> p_bst_information9
      ,p_bst_information10		=> p_bst_information10
      ,p_bst_information11		=> p_bst_information11
      ,p_bst_information12		=> p_bst_information12
      ,p_bst_information13		=> p_bst_information13
      ,p_bst_information14		=> p_bst_information14
      ,p_bst_information15		=> p_bst_information15
      ,p_bst_information16		=> p_bst_information16
      ,p_bst_information17		=> p_bst_information17
      ,p_bst_information18		=> p_bst_information18
      ,p_bst_information19		=> p_bst_information19
      ,p_bst_information20		=> p_bst_information20
      ,p_booking_status_type_id         => p_booking_status_type_id
      ,p_object_version_number          => p_object_version_number
 --   ,p_data_source           => p_data_source
  );

Line: 357

        (p_module_name => 'UPDATE_BOOKING_STATUS_TYPE'
        ,p_hook_type   => 'BP'
        );

Line: 413

  OTA_BOOKING_STATUS_TYPE_BK2.UPDATE_BOOKING_STATUS_TYPE_A
  (p_effective_date                 => l_effective_date
      ,p_business_group_id	        => p_business_group_id
      ,p_active_flag                    => p_active_flag
      ,p_default_flag                   => p_default_flag
      ,p_place_used_flag                => p_place_used_flag
      ,p_name                           => p_name
      ,p_type                           => p_type
      ,p_comments                       => p_comments
      ,p_description                    => p_description
      ,p_bst_information_category       => p_bst_information_category
      ,p_bst_information1		=> p_bst_information1
      ,p_bst_information2		=> p_bst_information2
      ,p_bst_information3		=> p_bst_information3
      ,p_bst_information4		=> p_bst_information4
      ,p_bst_information5		=> p_bst_information5
      ,p_bst_information6		=> p_bst_information6
      ,p_bst_information7		=> p_bst_information7
      ,p_bst_information8		=> p_bst_information8
      ,p_bst_information9		=> p_bst_information9
      ,p_bst_information10		=> p_bst_information10
      ,p_bst_information11		=> p_bst_information11
      ,p_bst_information12		=> p_bst_information12
      ,p_bst_information13		=> p_bst_information13
      ,p_bst_information14		=> p_bst_information14
      ,p_bst_information15		=> p_bst_information15
      ,p_bst_information16		=> p_bst_information16
      ,p_bst_information17		=> p_bst_information17
      ,p_bst_information18		=> p_bst_information18
      ,p_bst_information19		=> p_bst_information19
      ,p_bst_information20		=> p_bst_information20
      ,p_booking_status_type_id         => p_booking_status_type_id
      ,p_object_version_number          => p_object_version_number
 --     ,p_data_source           => p_data_source
  );

Line: 451

        (p_module_name => 'UPDATE_BOOKING_STATUS_TYPE'
        ,p_hook_type   => 'AP'
        );

Line: 472

    rollback to UPDATE_BOOKING_STATUS_TYPE;

Line: 484

    rollback to UPDATE_BOOKING_STATUS_TYPE;

Line: 488

end update_BOOKING_STATUS_TYPE;

Line: 494

procedure delete_BOOKING_STATUS_TYPE
  (p_validate                      in     boolean  default false
  ,p_booking_status_type_id                   in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Delete Training Plan';

Line: 511

  savepoint DELETE_BOOKING_STATUS_TYPE;

Line: 520

    OTA_BOOKING_STATUS_TYPE_BK3.DELETE_BOOKING_STATUS_TYPE_B
  (p_BOOKING_STATUS_TYPE_id            => p_BOOKING_STATUS_TYPE_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 527

        (p_module_name => 'DELETE_BOOKING_STATUS_TYPE'
        ,p_hook_type   => 'BP'
        );

Line: 551

  OTA_BOOKING_STATUS_TYPE_BK3.DELETE_BOOKING_STATUS_TYPE_A
  (P_BOOKING_STATUS_TYPE_ID            => P_BOOKING_STATUS_TYPE_ID
  ,p_object_version_number       => p_object_version_number
  );

Line: 558

        (p_module_name => 'DELETE_BOOKING_STATUS_TYPE'
        ,p_hook_type   => 'AP'
        );

Line: 580

    rollback to DELETE_BOOKING_STATUS_TYPE;

Line: 591

    rollback to DELETE_BOOKING_STATUS_TYPE;

Line: 594

end delete_BOOKING_STATUS_TYPE;