APPS.OTA_FINANCE_LINE_SWI SQL Statements

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

Line: 52

  ,p_last_update_date             in     date
  ,p_last_updated_by              in     number
  ,p_last_update_login            in     number
  ,p_created_by                   in     number
  ,p_creation_date                in     date
  ,p_tfl_information_category     in     varchar2
  ,p_tfl_information1             in     varchar2
  ,p_tfl_information2             in     varchar2
  ,p_tfl_information3             in     varchar2
  ,p_tfl_information4             in     varchar2
  ,p_tfl_information5             in     varchar2
  ,p_tfl_information6             in     varchar2
  ,p_tfl_information7             in     varchar2
  ,p_tfl_information8             in     varchar2
  ,p_tfl_information9             in     varchar2
  ,p_tfl_information10            in     varchar2
  ,p_tfl_information11            in     varchar2
  ,p_tfl_information12            in     varchar2
  ,p_tfl_information13            in     varchar2
  ,p_tfl_information14            in     varchar2
  ,p_tfl_information15            in     varchar2
  ,p_tfl_information16            in     varchar2
  ,p_tfl_information17            in     varchar2
  ,p_tfl_information18            in     varchar2
  ,p_tfl_information19            in     varchar2
  ,p_tfl_information20            in     varchar2
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 162

    ,p_last_update_date             => p_last_update_date
    ,p_last_updated_by              => p_last_updated_by
    ,p_last_update_login            => p_last_update_login
    ,p_created_by                   => p_created_by
    ,p_creation_date                => p_creation_date
    ,p_tfl_information_category     => p_tfl_information_category
    ,p_tfl_information1             => p_tfl_information1
    ,p_tfl_information2             => p_tfl_information2
    ,p_tfl_information3             => p_tfl_information3
    ,p_tfl_information4             => p_tfl_information4
    ,p_tfl_information5             => p_tfl_information5
    ,p_tfl_information6             => p_tfl_information6
    ,p_tfl_information7             => p_tfl_information7
    ,p_tfl_information8             => p_tfl_information8
    ,p_tfl_information9             => p_tfl_information9
    ,p_tfl_information10            => p_tfl_information10
    ,p_tfl_information11            => p_tfl_information11
    ,p_tfl_information12            => p_tfl_information12
    ,p_tfl_information13            => p_tfl_information13
    ,p_tfl_information14            => p_tfl_information14
    ,p_tfl_information15            => p_tfl_information15
    ,p_tfl_information16            => p_tfl_information16
    ,p_tfl_information17            => p_tfl_information17
    ,p_tfl_information18            => p_tfl_information18
    ,p_tfl_information19            => p_tfl_information19
    ,p_tfl_information20            => p_tfl_information20
    ,p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    );

Line: 248

PROCEDURE update_finance_line
  (p_finance_line_id              in     number
  ,p_object_version_number        in out nocopy number
  ,p_new_object_version_number       out nocopy number
  ,p_finance_header_id            in     number
  ,p_cancelled_flag               in     varchar2
  ,p_date_raised                  in out nocopy date
  ,p_line_type                    in     varchar2
  ,p_sequence_number              in out nocopy number
  ,p_transfer_status              in     varchar2
  ,p_comments                     in     varchar2
  ,p_currency_code                in     varchar2
  ,p_money_amount                 in     number
  ,p_standard_amount              in     number
  ,p_trans_information_category   in     varchar2
  ,p_trans_information1           in     varchar2
  ,p_trans_information10          in     varchar2
  ,p_trans_information11          in     varchar2
  ,p_trans_information12          in     varchar2
  ,p_trans_information13          in     varchar2
  ,p_trans_information14          in     varchar2
  ,p_trans_information15          in     varchar2
  ,p_trans_information16          in     varchar2
  ,p_trans_information17          in     varchar2
  ,p_trans_information18          in     varchar2
  ,p_trans_information19          in     varchar2
  ,p_trans_information2           in     varchar2
  ,p_trans_information20          in     varchar2
  ,p_trans_information3           in     varchar2
  ,p_trans_information4           in     varchar2
  ,p_trans_information5           in     varchar2
  ,p_trans_information6           in     varchar2
  ,p_trans_information7           in     varchar2
  ,p_trans_information8           in     varchar2
  ,p_trans_information9           in     varchar2
  ,p_transfer_date                in     date
  ,p_transfer_message             in     varchar2
  ,p_unitary_amount               in     number
  ,p_booking_deal_id              in     number
  ,p_booking_id                   in     number
  ,p_resource_allocation_id       in     number
  ,p_resource_booking_id          in     number
  ,p_last_update_date             in     date
  ,p_last_updated_by              in     number
  ,p_last_update_login            in     number
  ,p_created_by                   in     number
  ,p_creation_date                in     date
  ,p_tfl_information_category     in     varchar2
  ,p_tfl_information1             in     varchar2
  ,p_tfl_information2             in     varchar2
  ,p_tfl_information3             in     varchar2
  ,p_tfl_information4             in     varchar2
  ,p_tfl_information5             in     varchar2
  ,p_tfl_information6             in     varchar2
  ,p_tfl_information7             in     varchar2
  ,p_tfl_information8             in     varchar2
  ,p_tfl_information9             in     varchar2
  ,p_tfl_information10            in     varchar2
  ,p_tfl_information11            in     varchar2
  ,p_tfl_information12            in     varchar2
  ,p_tfl_information13            in     varchar2
  ,p_tfl_information14            in     varchar2
  ,p_tfl_information15            in     varchar2
  ,p_tfl_information16            in     varchar2
  ,p_tfl_information17            in     varchar2
  ,p_tfl_information18            in     varchar2
  ,p_tfl_information19            in     varchar2
  ,p_tfl_information20            in     varchar2
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_transaction_type             in     varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 331

  l_proc    varchar2(72) := g_package ||'update_finance_line';

Line: 337

  savepoint update_finance_line_swi;

Line: 360

  ota_finance_line_api.update_finance_line
    (p_finance_line_id              => p_finance_line_id
    ,p_object_version_number        => p_object_version_number
    ,p_new_object_version_number    => p_new_object_version_number
    ,p_finance_header_id            => p_finance_header_id
    ,p_cancelled_flag               => p_cancelled_flag
    ,p_date_raised                  => p_date_raised
    ,p_line_type                    => p_line_type
    ,p_sequence_number              => p_sequence_number
    ,p_transfer_status              => p_transfer_status
    ,p_comments                     => p_comments
    ,p_currency_code                => p_currency_code
    ,p_money_amount                 => p_money_amount
    ,p_standard_amount              => p_standard_amount
    ,p_trans_information_category   => p_trans_information_category
    ,p_trans_information1           => p_trans_information1
    ,p_trans_information10          => p_trans_information10
    ,p_trans_information11          => p_trans_information11
    ,p_trans_information12          => p_trans_information12
    ,p_trans_information13          => p_trans_information13
    ,p_trans_information14          => p_trans_information14
    ,p_trans_information15          => p_trans_information15
    ,p_trans_information16          => p_trans_information16
    ,p_trans_information17          => p_trans_information17
    ,p_trans_information18          => p_trans_information18
    ,p_trans_information19          => p_trans_information19
    ,p_trans_information2           => p_trans_information2
    ,p_trans_information20          => p_trans_information20
    ,p_trans_information3           => p_trans_information3
    ,p_trans_information4           => p_trans_information4
    ,p_trans_information5           => p_trans_information5
    ,p_trans_information6           => p_trans_information6
    ,p_trans_information7           => p_trans_information7
    ,p_trans_information8           => p_trans_information8
    ,p_trans_information9           => p_trans_information9
    ,p_transfer_date                => p_transfer_date
    ,p_transfer_message             => p_transfer_message
    ,p_unitary_amount               => p_unitary_amount
    ,p_booking_deal_id              => p_booking_deal_id
    ,p_booking_id                   => p_booking_id
    ,p_resource_allocation_id       => p_resource_allocation_id
    ,p_resource_booking_id          => p_resource_booking_id
    ,p_last_update_date             => p_last_update_date
    ,p_last_updated_by              => p_last_updated_by
    ,p_last_update_login            => p_last_update_login
    ,p_created_by                   => p_created_by
    ,p_creation_date                => p_creation_date
    ,p_tfl_information_category     => p_tfl_information_category
    ,p_tfl_information1             => p_tfl_information1
    ,p_tfl_information2             => p_tfl_information2
    ,p_tfl_information3             => p_tfl_information3
    ,p_tfl_information4             => p_tfl_information4
    ,p_tfl_information5             => p_tfl_information5
    ,p_tfl_information6             => p_tfl_information6
    ,p_tfl_information7             => p_tfl_information7
    ,p_tfl_information8             => p_tfl_information8
    ,p_tfl_information9             => p_tfl_information9
    ,p_tfl_information10            => p_tfl_information10
    ,p_tfl_information11            => p_tfl_information11
    ,p_tfl_information12            => p_tfl_information12
    ,p_tfl_information13            => p_tfl_information13
    ,p_tfl_information14            => p_tfl_information14
    ,p_tfl_information15            => p_tfl_information15
    ,p_tfl_information16            => p_tfl_information16
    ,p_tfl_information17            => p_tfl_information17
    ,p_tfl_information18            => p_tfl_information18
    ,p_tfl_information19            => p_tfl_information19
    ,p_tfl_information20            => p_tfl_information20
    ,p_validate                     => l_validate
    ,p_transaction_type             => p_transaction_type
    ,p_effective_date               => p_effective_date
    );

Line: 454

    rollback to update_finance_line_swi;

Line: 472

    rollback to update_finance_line_swi;

Line: 486

end update_finance_line;

Line: 490

PROCEDURE delete_finance_line
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_finance_line_id              in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 503

  l_proc    varchar2(72) := g_package ||'delete_finance_line';

Line: 509

  savepoint delete_finance_line_swi;

Line: 529

  ota_finance_line_api.delete_finance_line
    (p_validate                     => l_validate
    ,p_finance_line_id              => p_finance_line_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 556

    rollback to delete_finance_line_swi;

Line: 570

    rollback to delete_finance_line_swi;

Line: 580

end delete_finance_line;