eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on OTA_DELEGATE_BOOKINGS

Line 487: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

483:
484: l_eventid ota_events.event_id%TYPE;
485: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
486: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
487: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
488: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
489: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
490: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
491: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;

Line 489: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;

485: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
486: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
487: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
488: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
489: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
490: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
491: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
492: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
493: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

Line 491: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;

487: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
488: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
489: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
490: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
491: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
492: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
493: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
494: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
495: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

Line 492: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

488: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
489: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
490: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
491: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
492: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
493: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
494: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
495: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
496: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

Line 493: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

489: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
490: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
491: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
492: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
493: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
494: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
495: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
496: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
497: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

Line 494: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

490: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
491: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
492: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
493: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
494: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
495: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
496: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
497: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
498: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

Line 495: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

491: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
492: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
493: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
494: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
495: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
496: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
497: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
498: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
499: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

Line 496: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

492: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
493: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
494: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
495: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
496: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
497: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
498: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
499: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
500: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

Line 497: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

493: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
494: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
495: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
496: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
497: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
498: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
499: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
500: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
501: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

Line 498: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

494: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
495: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
496: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
497: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
498: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
499: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
500: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
501: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
502: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

Line 499: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

495: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
496: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
497: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
498: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
499: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
500: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
501: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
502: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
503: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

Line 500: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

496: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
497: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
498: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
499: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
500: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
501: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
502: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
503: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
504: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

Line 501: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

497: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
498: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
499: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
500: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
501: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
502: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
503: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
504: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
505: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

Line 502: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

498: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
499: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
500: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
501: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
502: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
503: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
504: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
505: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
506: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

Line 503: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

499: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
500: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
501: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
502: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
503: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
504: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
505: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
506: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
507: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

Line 504: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

500: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
501: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
502: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
503: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
504: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
505: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
506: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
507: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
508: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

Line 505: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

501: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
502: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
503: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
504: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
505: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
506: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
507: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
508: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
509: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

Line 506: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

502: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
503: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
504: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
505: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
506: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
507: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
508: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
509: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
510: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

Line 507: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

503: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
504: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
505: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
506: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
507: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
508: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
509: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
510: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
511: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

Line 508: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

504: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
505: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
506: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
507: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
508: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
509: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
510: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
511: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
512: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

Line 509: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

505: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
506: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
507: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
508: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
509: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
510: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
511: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
512: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
513: l_offering_id ota_offerings.offering_id%TYPE;

Line 510: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

506: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
507: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
508: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
509: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
510: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
511: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
512: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
513: l_offering_id ota_offerings.offering_id%TYPE;
514: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;

Line 511: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

507: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
508: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
509: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
510: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
511: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
512: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
513: l_offering_id ota_offerings.offering_id%TYPE;
514: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;
515: l_booking_justification ota_bkng_justifications_tl.justification_text%TYPE;

Line 512: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

508: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
509: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
510: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
511: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
512: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
513: l_offering_id ota_offerings.offering_id%TYPE;
514: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;
515: l_booking_justification ota_bkng_justifications_tl.justification_text%TYPE;
516: begin

Line 751: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

747: )
748: is
749:
750: l_eventid ota_events.event_id%TYPE;
751: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
752: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
753: l_ccselectiontext varchar2(2000);
754: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
755: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

Line 754: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

750: l_eventid ota_events.event_id%TYPE;
751: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
752: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
753: l_ccselectiontext varchar2(2000);
754: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
755: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
756: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
757: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
758: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

Line 755: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

751: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
752: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
753: l_ccselectiontext varchar2(2000);
754: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
755: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
756: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
757: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
758: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
759: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

Line 756: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

752: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
753: l_ccselectiontext varchar2(2000);
754: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
755: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
756: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
757: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
758: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
759: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
760: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

Line 757: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

753: l_ccselectiontext varchar2(2000);
754: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
755: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
756: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
757: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
758: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
759: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
760: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
761: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

Line 758: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

754: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
755: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
756: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
757: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
758: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
759: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
760: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
761: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
762: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

Line 759: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

755: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
756: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
757: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
758: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
759: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
760: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
761: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
762: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
763: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

Line 760: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

756: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
757: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
758: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
759: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
760: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
761: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
762: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
763: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
764: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

Line 761: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

757: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
758: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
759: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
760: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
761: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
762: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
763: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
764: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
765: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

Line 762: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

758: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
759: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
760: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
761: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
762: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
763: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
764: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
765: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
766: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

Line 763: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

759: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
760: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
761: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
762: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
763: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
764: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
765: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
766: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
767: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

Line 764: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

760: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
761: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
762: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
763: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
764: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
765: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
766: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
767: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
768: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

Line 765: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

761: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
762: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
763: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
764: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
765: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
766: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
767: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
768: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
769: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

Line 766: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

762: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
763: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
764: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
765: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
766: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
767: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
768: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
769: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
770: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

Line 767: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

763: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
764: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
765: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
766: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
767: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
768: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
769: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
770: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
771: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

Line 768: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

764: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
765: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
766: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
767: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
768: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
769: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
770: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
771: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
772: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

Line 769: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

765: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
766: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
767: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
768: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
769: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
770: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
771: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
772: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
773: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

Line 770: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

766: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
767: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
768: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
769: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
770: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
771: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
772: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
773: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
774: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

Line 771: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

767: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
768: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
769: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
770: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
771: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
772: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
773: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
774: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
775: l_trnorgnames varchar2(2000);

Line 772: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

768: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
769: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
770: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
771: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
772: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
773: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
774: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
775: l_trnorgnames varchar2(2000);
776: l_offering_id ota_offerings.offering_id%TYPE;

Line 773: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

769: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
770: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
771: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
772: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
773: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
774: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
775: l_trnorgnames varchar2(2000);
776: l_offering_id ota_offerings.offering_id%TYPE;
777: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;

Line 774: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

770: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
771: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
772: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
773: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
774: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
775: l_trnorgnames varchar2(2000);
776: l_offering_id ota_offerings.offering_id%TYPE;
777: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;
778: l_booking_justification ota_bkng_justifications_tl.justification_text%TYPE;

Line 965: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;

961: PROCEDURE process_api2
962: (p_validate IN BOOLEAN,p_transaction_step_id IN NUMBER
963: ,p_effective_date in varchar2) IS
964:
965: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
966: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
967: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
968: l_eventid ota_events.event_id%TYPE;
969: l_object_version_number number;

Line 971: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

967: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
968: l_eventid ota_events.event_id%TYPE;
969: l_object_version_number number;
970: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
971: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
972: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
973: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
974: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
975: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;

Line 1024: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

1020:
1021: l_business_group_id ota_events.business_group_id%type;
1022: l_standard_price ota_events.standard_price%type;
1023:
1024: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1025: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1026: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1027: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1028: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

Line 1025: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

1021: l_business_group_id ota_events.business_group_id%type;
1022: l_standard_price ota_events.standard_price%type;
1023:
1024: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1025: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1026: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1027: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1028: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1029: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

Line 1026: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

1022: l_standard_price ota_events.standard_price%type;
1023:
1024: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1025: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1026: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1027: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1028: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1029: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1030: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

Line 1027: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

1023:
1024: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1025: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1026: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1027: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1028: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1029: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1030: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1031: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

Line 1028: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

1024: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1025: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1026: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1027: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1028: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1029: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1030: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1031: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1032: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

Line 1029: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

1025: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1026: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1027: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1028: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1029: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1030: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1031: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1032: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1033: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

Line 1030: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

1026: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1027: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1028: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1029: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1030: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1031: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1032: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1033: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1034: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

Line 1031: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

1027: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1028: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1029: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1030: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1031: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1032: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1033: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1034: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1035: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

Line 1032: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

1028: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1029: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1030: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1031: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1032: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1033: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1034: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1035: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1036: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

Line 1033: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

1029: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1030: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1031: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1032: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1033: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1034: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1035: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1036: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1037: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

Line 1034: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

1030: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1031: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1032: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1033: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1034: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1035: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1036: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1037: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1038: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

Line 1035: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

1031: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1032: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1033: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1034: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1035: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1036: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1037: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1038: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1039: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

Line 1036: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

1032: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1033: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1034: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1035: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1036: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1037: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1038: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1039: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1040: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

Line 1037: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

1033: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1034: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1035: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1036: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1037: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1038: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1039: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1040: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1041: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

Line 1038: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

1034: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1035: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1036: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1037: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1038: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1039: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1040: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1041: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1042: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

Line 1039: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

1035: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1036: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1037: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1038: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1039: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1040: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1041: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1042: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1043: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

Line 1040: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

1036: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1037: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1038: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1039: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1040: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1041: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1042: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1043: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1044: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

Line 1041: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

1037: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1038: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1039: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1040: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1041: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1042: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1043: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1044: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1045:

Line 1042: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

1038: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1039: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1040: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1041: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1042: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1043: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1044: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1045:
1046: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;

Line 1043: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

1039: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1040: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1041: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1042: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1043: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1044: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1045:
1046: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;
1047: l_priority_level ota_delegate_bookings.booking_priority%TYPE;

Line 1044: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

1040: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1041: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1042: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1043: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1044: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1045:
1046: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;
1047: l_priority_level ota_delegate_bookings.booking_priority%TYPE;
1048:

Line 1047: l_priority_level ota_delegate_bookings.booking_priority%TYPE;

1043: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1044: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1045:
1046: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;
1047: l_priority_level ota_delegate_bookings.booking_priority%TYPE;
1048:
1049: l_timezone fnd_timezones_tl.name%TYPE;
1050: l_course_end_time ota_events.course_start_time%type;
1051: status_not_seeded exception;

Line 1092: FROM OTA_DELEGATE_BOOKINGS dbt,

1088: WHERE EVENT_ID = l_eventid;
1089:
1090: CURSOR get_existing_internal IS
1091: SELECT count(*)
1092: FROM OTA_DELEGATE_BOOKINGS dbt,
1093: OTA_BOOKING_STATUS_TYPES bst
1094: WHERE dbt.event_id = l_eventid
1095: AND dbt.internal_booking_flag = 'Y'
1096: AND dbt.booking_status_type_id = bst.booking_status_type_id

Line 1107: ota_delegate_bookings ov

1103: SELECT ov.booking_id,
1104: ov.date_booking_placed,
1105: ov.object_version_number
1106: FROM ota_booking_status_types os,
1107: ota_delegate_bookings ov
1108: WHERE ov.event_id = p_event_id
1109: AND ov.delegate_person_id = p_person_id
1110: AND os.booking_status_type_id = ov.booking_status_type_id
1111: AND os.type = 'R';

Line 1920: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;

1916: result out nocopy varchar2 ) is
1917:
1918: l_transaction_step_id number;
1919: l_eventid ota_events.event_id%TYPE;
1920: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1921: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
1922: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1923: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1924: l_object_version_number number;

Line 1921: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;

1917:
1918: l_transaction_step_id number;
1919: l_eventid ota_events.event_id%TYPE;
1920: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1921: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
1922: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1923: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1924: l_object_version_number number;
1925: l_date_booking_placed date;

Line 1940: ota_delegate_bookings ov

1936: ov.date_booking_placed,
1937: ov.object_version_number,
1938: ov.business_group_id
1939: FROM ota_booking_status_types os,
1940: ota_delegate_bookings ov
1941: WHERE ov.event_id = p_event_id
1942: AND ov.delegate_person_id = p_person_id
1943: AND os.booking_status_type_id = ov.booking_status_type_id
1944: AND os.type = 'R';

Line 2247: CURSOR csr_booking_status(p_booking_id ota_delegate_bookings.booking_id%type) IS

2243: usr.employee_id = evt.owner_id
2244: and trunc(sysdate) between usr.start_date and nvl(usr.end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
2245:
2246:
2247: CURSOR csr_booking_status(p_booking_id ota_delegate_bookings.booking_id%type) IS
2248: SELECT bst.Type
2249: FROM OTA_DELEGATE_BOOKINGS tdb,
2250: OTA_BOOKING_STATUS_TYPES bst
2251: WHERE tdb.booking_id = p_booking_id

Line 2249: FROM OTA_DELEGATE_BOOKINGS tdb,

2245:
2246:
2247: CURSOR csr_booking_status(p_booking_id ota_delegate_bookings.booking_id%type) IS
2248: SELECT bst.Type
2249: FROM OTA_DELEGATE_BOOKINGS tdb,
2250: OTA_BOOKING_STATUS_TYPES bst
2251: WHERE tdb.booking_id = p_booking_id
2252: AND bst.booking_status_type_id = tdb.booking_status_type_id;
2253:

Line 2265: l_booking_id ota_delegate_bookings.booking_id%type;

2261: And OEV.event_id = p_event_id;
2262:
2263: l_event_id NUMBER;
2264: l_user_name FND_USER.USER_NAME%TYPE;
2265: l_booking_id ota_delegate_bookings.booking_id%type;
2266: l_notification_text varchar2(2000);
2267: l_status_type ota_booking_status_types.type%type;
2268:
2269: l_synchronous_flag ota_category_usages.synchronous_flag%type;