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_EL_TRAINING_SS dependencies on OTA_DELEGATE_BOOKINGS

Line 629: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

625:
626: l_eventid ota_events.event_id%TYPE;
627: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
628: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
629: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
630: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
631: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
632: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
633: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;

Line 631: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;

627: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
628: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
629: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
630: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
631: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
632: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
633: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
634: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
635: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

Line 633: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;

629: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
630: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
631: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
632: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
633: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
634: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
635: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
636: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
637: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

Line 634: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

630: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
631: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
632: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
633: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
634: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
635: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
636: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
637: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
638: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

Line 635: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

631: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
632: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
633: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
634: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
635: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
636: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
637: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
638: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
639: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

Line 636: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

632: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
633: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
634: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
635: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
636: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
637: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
638: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
639: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
640: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

Line 637: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

633: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
634: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
635: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
636: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
637: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
638: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
639: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
640: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
641: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

Line 638: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

634: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
635: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
636: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
637: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
638: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
639: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
640: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
641: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
642: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

Line 639: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

635: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
636: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
637: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
638: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
639: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
640: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
641: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
642: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
643: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

Line 640: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

636: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
637: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
638: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
639: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
640: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
641: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
642: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
643: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
644: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

Line 641: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

637: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
638: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
639: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
640: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
641: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
642: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
643: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
644: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
645: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

Line 642: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

638: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
639: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
640: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
641: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
642: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
643: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
644: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
645: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
646: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

Line 643: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

639: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
640: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
641: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
642: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
643: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
644: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
645: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
646: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
647: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

Line 644: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

640: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
641: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
642: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
643: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
644: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
645: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
646: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
647: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
648: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

Line 645: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

641: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
642: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
643: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
644: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
645: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
646: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
647: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
648: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
649: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

Line 646: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

642: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
643: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
644: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
645: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
646: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
647: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
648: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
649: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
650: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

Line 647: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

643: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
644: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
645: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
646: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
647: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
648: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
649: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
650: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
651: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

Line 648: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

644: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
645: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
646: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
647: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
648: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
649: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
650: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
651: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
652: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

Line 649: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

645: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
646: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
647: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
648: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
649: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
650: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
651: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
652: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
653: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

Line 650: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

646: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
647: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
648: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
649: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
650: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
651: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
652: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
653: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
654: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

Line 651: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

647: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
648: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
649: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
650: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
651: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
652: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
653: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
654: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
655: l_oafunc varchar2(100);

Line 652: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

648: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
649: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
650: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
651: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
652: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
653: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
654: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
655: l_oafunc varchar2(100);
656: l_processname varchar2(100);

Line 653: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

649: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
650: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
651: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
652: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
653: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
654: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
655: l_oafunc varchar2(100);
656: l_processname varchar2(100);
657: l_calledfrom varchar2(100);

Line 654: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

650: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
651: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
652: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
653: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
654: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
655: l_oafunc varchar2(100);
656: l_processname varchar2(100);
657: l_calledfrom varchar2(100);
658: l_frommenu varchar2(100);

Line 891: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

887: )
888: is
889:
890: l_eventid ota_events.event_id%TYPE;
891: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
892: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
893: l_ccselectiontext varchar2(200);
894: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
895: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

Line 894: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

890: l_eventid ota_events.event_id%TYPE;
891: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
892: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
893: l_ccselectiontext varchar2(200);
894: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
895: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
896: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
897: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
898: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

Line 895: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

891: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
892: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
893: l_ccselectiontext varchar2(200);
894: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
895: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
896: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
897: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
898: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
899: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

Line 896: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

892: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
893: l_ccselectiontext varchar2(200);
894: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
895: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
896: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
897: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
898: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
899: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
900: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

Line 897: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

893: l_ccselectiontext varchar2(200);
894: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
895: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
896: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
897: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
898: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
899: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
900: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
901: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

Line 898: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

894: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
895: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
896: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
897: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
898: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
899: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
900: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
901: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
902: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

Line 899: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

895: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
896: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
897: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
898: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
899: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
900: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
901: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
902: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
903: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

Line 900: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

896: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
897: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
898: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
899: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
900: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
901: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
902: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
903: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
904: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

Line 901: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

897: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
898: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
899: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
900: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
901: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
902: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
903: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
904: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
905: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

Line 902: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

898: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
899: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
900: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
901: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
902: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
903: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
904: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
905: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
906: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

Line 903: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

899: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
900: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
901: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
902: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
903: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
904: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
905: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
906: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
907: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

Line 904: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

900: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
901: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
902: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
903: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
904: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
905: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
906: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
907: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
908: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

Line 905: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

901: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
902: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
903: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
904: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
905: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
906: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
907: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
908: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
909: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

Line 906: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

902: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
903: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
904: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
905: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
906: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
907: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
908: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
909: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
910: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

Line 907: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

903: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
904: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
905: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
906: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
907: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
908: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
909: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
910: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
911: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

Line 908: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

904: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
905: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
906: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
907: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
908: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
909: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
910: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
911: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
912: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

Line 909: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

905: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
906: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
907: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
908: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
909: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
910: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
911: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
912: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
913: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

Line 910: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

906: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
907: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
908: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
909: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
910: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
911: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
912: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
913: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
914: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

Line 911: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

907: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
908: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
909: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
910: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
911: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
912: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
913: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
914: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
915: l_trnorgnames varchar2(2000);

Line 912: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

908: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
909: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
910: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
911: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
912: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
913: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
914: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
915: l_trnorgnames varchar2(2000);
916:

Line 913: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

909: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
910: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
911: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
912: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
913: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
914: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
915: l_trnorgnames varchar2(2000);
916:
917: begin

Line 914: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

910: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
911: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
912: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
913: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
914: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
915: l_trnorgnames varchar2(2000);
916:
917: begin
918:

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

1078:
1079: PROCEDURE process_api2
1080: (p_validate IN BOOLEAN,p_transaction_step_id IN NUMBER) IS
1081:
1082: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1083: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1084: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1085: l_eventid ota_events.event_id%TYPE;
1086: l_object_version_number number;

Line 1088: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

1084: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1085: l_eventid ota_events.event_id%TYPE;
1086: l_object_version_number number;
1087: l_person_details OTA_EL_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
1088: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1089: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1090: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1091: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1092: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;

Line 1137: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

1133:
1134: l_business_group_id ota_events.business_group_id%type;
1135: l_standard_price ota_events.standard_price%type;
1136:
1137: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1138: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1139: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1140: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1141: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

Line 1138: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

1134: l_business_group_id ota_events.business_group_id%type;
1135: l_standard_price ota_events.standard_price%type;
1136:
1137: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1138: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1139: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1140: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1141: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1142: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

Line 1139: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

1135: l_standard_price ota_events.standard_price%type;
1136:
1137: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1138: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1139: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1140: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1141: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1142: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1143: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

Line 1140: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

1136:
1137: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1138: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1139: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1140: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1141: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1142: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1143: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1144: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

Line 1141: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

1137: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1138: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1139: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1140: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1141: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1142: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1143: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1144: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1145: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

Line 1142: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

1138: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1139: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1140: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1141: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1142: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1143: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1144: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1145: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1146: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

Line 1143: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

1139: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1140: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1141: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1142: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1143: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1144: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1145: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1146: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1147: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

Line 1144: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

1140: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1141: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1142: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1143: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1144: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1145: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1146: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1147: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1148: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

Line 1145: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

1141: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1142: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1143: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1144: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1145: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1146: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1147: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1148: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1149: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

Line 1146: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

1142: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1143: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1144: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1145: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1146: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1147: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1148: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1149: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1150: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

Line 1147: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

1143: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1144: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1145: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1146: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1147: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1148: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1149: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1150: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1151: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

Line 1148: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

1144: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1145: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1146: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1147: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1148: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1149: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1150: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1151: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1152: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

Line 1149: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

1145: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1146: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1147: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1148: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1149: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1150: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1151: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1152: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1153: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

Line 1150: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

1146: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1147: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1148: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1149: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1150: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1151: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1152: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1153: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1154: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

Line 1151: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

1147: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1148: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1149: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1150: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1151: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1152: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1153: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1154: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1155: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

Line 1152: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

1148: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1149: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1150: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1151: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1152: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1153: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1154: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1155: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1156: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

Line 1153: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

1149: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1150: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1151: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1152: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1153: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1154: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1155: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1156: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1157: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

Line 1154: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

1150: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1151: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1152: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1153: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1154: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1155: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1156: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1157: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1158:

Line 1155: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

1151: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1152: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1153: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1154: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1155: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1156: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1157: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1158:
1159: status_not_seeded exception;

Line 1156: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

1152: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1153: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1154: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1155: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1156: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1157: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1158:
1159: status_not_seeded exception;
1160:

Line 1157: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

1153: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1154: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1155: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1156: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1157: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1158:
1159: status_not_seeded exception;
1160:
1161:

Line 1192: FROM OTA_DELEGATE_BOOKINGS dbt,

1188: WHERE EVENT_ID = l_eventid;
1189:
1190: CURSOR get_existing_internal IS
1191: SELECT count(*)
1192: FROM OTA_DELEGATE_BOOKINGS dbt,
1193: OTA_BOOKING_STATUS_TYPES bst
1194: WHERE dbt.event_id = l_eventid
1195: AND dbt.internal_booking_flag = 'Y'
1196: AND dbt.booking_status_type_id = bst.booking_status_type_id

Line 1207: ota_delegate_bookings ov

1203: SELECT ov.booking_id,
1204: ov.date_booking_placed,
1205: ov.object_version_number
1206: FROM ota_booking_status_types os,
1207: ota_delegate_bookings ov
1208: WHERE ov.event_id = p_event_id
1209: AND ov.delegate_person_id = p_person_id
1210: AND os.booking_status_type_id = ov.booking_status_type_id
1211: AND os.type = 'R';