APPS.OTA_BKNG_JUSTIFICATION_API SQL Statements

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

Line: 143

procedure update_booking_justification
  (
  p_effective_date               in date,
  p_booking_justification_id     in number,
  p_object_version_number        in out nocopy number,
  p_priority_level               in varchar2,
  p_justification_text           in varchar2,
  p_start_date_active            in date,
  p_end_date_active              in date,
  p_business_group_id            in number,
  p_validate                     in boolean
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Update Booking Justification';

Line: 166

  savepoint UPDATE_BOOKING_JUSTIFICATION;

Line: 170

  ota_bkng_justification_bk2.update_booking_justification_b
  (p_effective_date               => p_effective_date
    ,p_booking_justification_id             => p_booking_justification_id
    ,p_object_version_number        => p_object_version_number
    ,p_priority_level     => p_priority_level
    ,p_start_date_active            => p_start_date_active
    ,p_end_date_active              => p_end_date_active
    ,p_business_group_id            => p_business_group_id
    ,p_justification_text            => p_justification_text
    ,p_validate                     => p_validate
    );

Line: 186

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

Line: 214

  ota_bkng_justification_bk2.update_booking_justification_a
  (p_effective_date               => p_effective_date
    ,p_booking_justification_id             => p_booking_justification_id
    ,p_object_version_number        => p_object_version_number
    ,p_priority_level     => p_priority_level
    ,p_start_date_active            => p_start_date_active
    ,p_end_date_active              => p_end_date_active
    ,p_business_group_id            => p_business_group_id
    ,p_justification_text            => p_justification_text
    ,p_validate                     => p_validate
    );

Line: 230

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

Line: 251

    rollback to UPDATE_BOOKING_JUSTIFICATION;

Line: 263

    rollback to UPDATE_BOOKING_JUSTIFICATION;

Line: 267

end update_booking_justification;

Line: 273

procedure delete_booking_justification
  (
  p_booking_justification_id                in number,
  p_object_version_number              in number,
  p_validate                           in boolean
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Delete Booking Justification';

Line: 290

  savepoint DELETE_BOOKING_JUSTIFICATION;

Line: 297

  ota_bkng_justification_bk3.delete_booking_justification_b
  (p_booking_justification_id             => p_booking_justification_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 304

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

Line: 324

  ota_bkng_justification_bk3.delete_booking_justification_a
  (p_booking_justification_id             => p_booking_justification_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 331

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

Line: 353

    rollback to DELETE_BOOKING_JUSTIFICATION;

Line: 364

    rollback to DELETE_BOOKING_JUSTIFICATION;

Line: 367

end delete_booking_justification;