APPS.OTA_DELEGATE_BOOKING_BE2 SQL Statements

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

Line: 4

procedure update_delegate_booking_a (
p_effective_date               date,
p_booking_id                   number,
p_booking_status_type_id       number,
p_delegate_person_id           number,
p_contact_id                   number,
p_business_group_id            number,
p_event_id                     number,
p_customer_id                  number,
p_authorizer_person_id         number,
p_date_booking_placed          date,
p_corespondent                 varchar2,
p_internal_booking_flag        varchar2,
p_number_of_places             number,
p_object_version_number        number,
p_administrator                number,
p_booking_priority             varchar2,
p_comments                     varchar2,
p_contact_address_id           number,
p_delegate_contact_phone       varchar2,
p_delegate_contact_fax         varchar2,
p_third_party_customer_id      number,
p_third_party_contact_id       number,
p_third_party_address_id       number,
p_third_party_contact_phone    varchar2,
p_third_party_contact_fax      varchar2,
p_date_status_changed          date,
p_status_change_comments       varchar2,
p_failure_reason               varchar2,
p_attendance_result            varchar2,
p_language_id                  number,
p_source_of_booking            varchar2,
p_special_booking_instructions varchar2,
p_successful_attendance_flag   varchar2,
p_tdb_information_category     varchar2,
p_tdb_information1             varchar2,
p_tdb_information2             varchar2,
p_tdb_information3             varchar2,
p_tdb_information4             varchar2,
p_tdb_information5             varchar2,
p_tdb_information6             varchar2,
p_tdb_information7             varchar2,
p_tdb_information8             varchar2,
p_tdb_information9             varchar2,
p_tdb_information10            varchar2,
p_tdb_information11            varchar2,
p_tdb_information12            varchar2,
p_tdb_information13            varchar2,
p_tdb_information14            varchar2,
p_tdb_information15            varchar2,
p_tdb_information16            varchar2,
p_tdb_information17            varchar2,
p_tdb_information18            varchar2,
p_tdb_information19            varchar2,
p_tdb_information20            varchar2,
p_update_finance_line          varchar2,
p_tfl_object_version_number    number,
p_finance_header_id            number,
p_currency_code                varchar2,
p_standard_amount              number,
p_unitary_amount               number,
p_money_amount                 number,
p_booking_deal_id              number,
p_booking_deal_type            varchar2,
p_finance_line_id              number,
p_enrollment_type              varchar2,
p_organization_id              number,
p_sponsor_person_id            number,
p_sponsor_assignment_id        number,
p_person_address_id            number,
p_delegate_assignment_id       number,
p_delegate_contact_id          number,
p_delegate_contact_email       varchar2,
p_third_party_email            varchar2,
p_person_address_type          varchar2,
p_line_id                      number,
p_org_id                       number,
p_daemon_flag                  varchar2,
p_daemon_type                  varchar2,
p_old_event_id                 number,
p_quote_line_id                number,
p_interface_source             varchar2,
p_total_training_time          varchar2,
p_content_player_status        varchar2,
p_score                        number,
p_completed_content            number,
p_total_content                number,
p_booking_justification_id     number,
p_is_history_flag              varchar2) is
  l_event_key number;

Line: 100

  select per_wf_events_s.nextval from dual;

Line: 102

  l_proc varchar2(72):='  ota_delegate_booking_be2.update_delegate_booking_a';

Line: 106

  l_event_name:='oracle.apps.ota.api.delegate_booking.update_delegate_booking';

Line: 342

    l_text:='';

Line: 343

    l_text:=l_text||irc_utilities_pkg.removeTags(p_update_finance_line);

Line: 344

    l_text:=l_text||'';

Line: 502

end update_delegate_booking_a;