APPS.OTA_TDB_INS SQL Statements

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

Line: 74

Procedure insert_dml(p_rec in out nocopy ota_tdb_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 86

  insert into ota_delegate_bookings
  (     booking_id,
        booking_status_type_id,
        delegate_person_id,
        contact_id,
        business_group_id,
        event_id,
        customer_id,
        authorizer_person_id,
        date_booking_placed,
        corespondent,
        internal_booking_flag,
        number_of_places,
        object_version_number,
        administrator,
        booking_priority,
        comments,
        contact_address_id,
        delegate_contact_phone,
        delegate_contact_fax,
        third_party_customer_id,
        third_party_contact_id,
        third_party_address_id,
        third_party_contact_phone,
        third_party_contact_fax,
        date_status_changed,
        failure_reason,
        attendance_result,
        language_id,
        source_of_booking,
        special_booking_instructions,
        successful_attendance_flag,
        tdb_information_category,
        tdb_information1,
        tdb_information2,
        tdb_information3,
        tdb_information4,
        tdb_information5,
        tdb_information6,
        tdb_information7,
        tdb_information8,
        tdb_information9,
        tdb_information10,
        tdb_information11,
        tdb_information12,
        tdb_information13,
        tdb_information14,
        tdb_information15,
        tdb_information16,
        tdb_information17,
        tdb_information18,
        tdb_information19,
        tdb_information20,
        organization_id,
        sponsor_person_id,
        sponsor_assignment_id,
        person_address_id,
        delegate_assignment_id,
        delegate_contact_id,
        delegate_contact_email,
        third_party_email,
        person_address_type,
        line_id,
        org_id,
        daemon_flag,
        daemon_type,
        old_event_id,
        quote_line_id,
        interface_source,
        total_training_time,
        content_player_status,
        score,
        completed_content,
        total_content    ,
	booking_justification_id,
	is_history_flag,
	is_mandatory_enrollment,
	sign_eval_status
  )
  Values
  (     p_rec.booking_id,
        p_rec.booking_status_type_id,
        p_rec.delegate_person_id,
        p_rec.contact_id,
        p_rec.business_group_id,
        p_rec.event_id,
        p_rec.customer_id,
        p_rec.authorizer_person_id,
        p_rec.date_booking_placed,
        p_rec.corespondent,
        p_rec.internal_booking_flag,
        p_rec.number_of_places,
        p_rec.object_version_number,
        p_rec.administrator,
        p_rec.booking_priority,
        p_rec.comments,
        p_rec.contact_address_id,
        p_rec.delegate_contact_phone,
        p_rec.delegate_contact_fax,
        p_rec.third_party_customer_id,
        p_rec.third_party_contact_id,
        p_rec.third_party_address_id,
        p_rec.third_party_contact_phone,
        p_rec.third_party_contact_fax,
        p_rec.date_status_changed,
        p_rec.failure_reason,
        p_rec.attendance_result,
        p_rec.language_id,
        p_rec.source_of_booking,
        p_rec.special_booking_instructions,
        p_rec.successful_attendance_flag,
        p_rec.tdb_information_category,
        p_rec.tdb_information1,
        p_rec.tdb_information2,
        p_rec.tdb_information3,
        p_rec.tdb_information4,
        p_rec.tdb_information5,
        p_rec.tdb_information6,
        p_rec.tdb_information7,
        p_rec.tdb_information8,
        p_rec.tdb_information9,
        p_rec.tdb_information10,
        p_rec.tdb_information11,
        p_rec.tdb_information12,
        p_rec.tdb_information13,
        p_rec.tdb_information14,
        p_rec.tdb_information15,
        p_rec.tdb_information16,
        p_rec.tdb_information17,
        p_rec.tdb_information18,
        p_rec.tdb_information19,
        p_rec.tdb_information20,
        p_rec.organization_id,
        p_rec.sponsor_person_id,
        p_rec.sponsor_assignment_id,
        p_rec.person_address_id,
        p_rec.delegate_assignment_id,
        p_rec.delegate_contact_id,
        p_rec.delegate_contact_email,
        p_rec.third_party_email,
        p_rec.person_address_type,
        p_rec.line_id,
        p_rec.org_id,
        p_rec.daemon_flag,
        p_rec.daemon_type,
        p_rec.old_event_id,
        p_rec.quote_line_id,
        p_rec.interface_source,
        p_rec.total_training_time,
      p_rec.content_player_status,
      p_rec.score,
      p_rec.completed_content,
      p_rec.total_content     ,
      p_rec.booking_justification_id,
      p_rec.is_history_flag,
      p_rec.is_mandatory_enrollment,
      p_rec.sign_eval_status
  );

Line: 267

End insert_dml;

Line: 306

Procedure pre_insert(p_rec  in out nocopy ota_tdb_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_insert';

Line: 310

  Cursor C_Sel1 is select ota_delegate_bookings_s.nextval from sys.dual;

Line: 314

    Select null
      from ota_delegate_bookings
     where booking_id =
             ota_tdb_ins.g_booking_id_i;

Line: 359

End pre_insert;

Line: 393

Procedure post_insert(p_rec                 in ota_tdb_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 402

  select line_id
  from ota_events
  where event_id = p_rec.event_id;

Line: 435

End post_insert;

Line: 473

  ota_tdb_bus.insert_validate(p_rec,p_enrollment_type);

Line: 477

  pre_insert(p_rec);

Line: 481

  insert_dml(p_rec);

Line: 485

  post_insert(p_rec);