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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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);
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);
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);
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);
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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);
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:
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
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:
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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;
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:
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:
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
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';