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

Line 883: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

879:
880: l_eventid ota_events.event_id%TYPE;
881: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
882: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
883: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
884: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
885: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
886: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
887: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;

Line 885: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;

881: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
882: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
883: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
884: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
885: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
886: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
887: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
888: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
889: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

Line 887: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;

883: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
884: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
885: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
886: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
887: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
888: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
889: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
890: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
891: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

Line 888: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

884: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
885: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
886: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
887: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
888: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
889: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
890: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
891: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
892: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

Line 889: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

885: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
886: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
887: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
888: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
889: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
890: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
891: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
892: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
893: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

Line 890: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

886: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
887: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
888: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
889: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
890: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
891: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
892: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
893: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
894: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

Line 891: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

887: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
888: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
889: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
890: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
891: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
892: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
893: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
894: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
895: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

Line 892: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

888: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
889: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
890: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
891: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
892: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
893: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
894: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
895: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
896: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

Line 893: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

889: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
890: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
891: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
892: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
893: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
894: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
895: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
896: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
897: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

Line 894: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

890: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
891: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
892: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
893: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
894: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
895: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
896: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
897: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
898: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

Line 895: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

891: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
892: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
893: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
894: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
895: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
896: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
897: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
898: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
899: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

Line 896: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

892: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
893: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
894: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
895: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
896: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
897: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
898: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
899: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
900: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

Line 897: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

893: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
894: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
895: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
896: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
897: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
898: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
899: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
900: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
901: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

Line 898: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

894: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
895: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
896: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
897: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
898: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
899: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
900: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
901: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
902: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

Line 899: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

895: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
896: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
897: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
898: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
899: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
900: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
901: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
902: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
903: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

Line 900: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

896: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
897: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
898: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
899: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
900: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
901: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
902: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
903: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
904: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

Line 901: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

897: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
898: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
899: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
900: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
901: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
902: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
903: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
904: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
905: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

Line 902: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

898: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
899: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
900: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
901: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
902: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
903: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
904: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
905: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
906: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

Line 903: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

899: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
900: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
901: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
902: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
903: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
904: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
905: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
906: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
907: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

Line 904: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

900: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
901: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
902: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
903: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
904: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
905: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
906: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
907: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
908: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

Line 905: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

901: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
902: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
903: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
904: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
905: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
906: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
907: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
908: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
909: l_oafunc varchar2(100);

Line 906: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

902: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
903: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
904: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
905: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
906: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
907: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
908: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
909: l_oafunc varchar2(100);
910: l_processname varchar2(100);

Line 907: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

903: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
904: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
905: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
906: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
907: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
908: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
909: l_oafunc varchar2(100);
910: l_processname varchar2(100);
911: l_calledfrom varchar2(100);

Line 908: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

904: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
905: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
906: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
907: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
908: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
909: l_oafunc varchar2(100);
910: l_processname varchar2(100);
911: l_calledfrom varchar2(100);
912: l_frommenu varchar2(100);

Line 1145: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

1141: )
1142: is
1143:
1144: l_eventid ota_events.event_id%TYPE;
1145: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1146: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
1147: l_ccselectiontext varchar2(200);
1148: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1149: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

Line 1148: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

1144: l_eventid ota_events.event_id%TYPE;
1145: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1146: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
1147: l_ccselectiontext varchar2(200);
1148: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1149: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1150: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1151: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1152: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

Line 1149: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

1145: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1146: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
1147: l_ccselectiontext varchar2(200);
1148: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1149: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1150: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1151: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1152: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1153: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

Line 1150: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

1146: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
1147: l_ccselectiontext varchar2(200);
1148: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1149: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1150: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1151: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1152: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1153: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1154: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

Line 1151: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

1147: l_ccselectiontext varchar2(200);
1148: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1149: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1150: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1151: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1152: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1153: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1154: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1155: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

Line 1152: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

1148: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1149: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1150: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1151: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1152: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1153: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1154: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1155: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1156: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

Line 1153: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

1149: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1150: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1151: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1152: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1153: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1154: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1155: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1156: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1157: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

Line 1154: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

1150: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1151: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1152: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1153: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1154: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1155: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1156: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1157: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1158: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

Line 1155: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

1151: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1152: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1153: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1154: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1155: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1156: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1157: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1158: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1159: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

Line 1156: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

1152: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1153: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1154: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1155: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1156: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1157: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1158: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1159: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1160: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

Line 1157: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

1153: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1154: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1155: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1156: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1157: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1158: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1159: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1160: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1161: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

Line 1158: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

1154: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1155: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1156: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1157: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1158: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1159: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1160: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1161: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1162: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

Line 1159: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

1155: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1156: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1157: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1158: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1159: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1160: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1161: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1162: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1163: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

Line 1160: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

1156: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1157: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1158: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1159: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1160: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1161: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1162: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1163: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1164: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

Line 1161: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

1157: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1158: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1159: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1160: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1161: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1162: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1163: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1164: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1165: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

Line 1162: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

1158: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1159: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1160: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1161: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1162: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1163: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1164: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1165: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1166: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

Line 1163: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

1159: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1160: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1161: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1162: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1163: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1164: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1165: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1166: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1167: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

Line 1164: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

1160: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1161: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1162: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1163: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1164: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1165: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1166: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1167: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1168: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

Line 1165: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

1161: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1162: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1163: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1164: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1165: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1166: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1167: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1168: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1169: l_trnorgnames varchar2(2000);

Line 1166: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

1162: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1163: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1164: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1165: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1166: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1167: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1168: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1169: l_trnorgnames varchar2(2000);
1170:

Line 1167: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

1163: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1164: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1165: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1166: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1167: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1168: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1169: l_trnorgnames varchar2(2000);
1170:
1171: begin

Line 1168: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

1164: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1165: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1166: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1167: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1168: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1169: l_trnorgnames varchar2(2000);
1170:
1171: begin
1172:

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

1333:
1334: PROCEDURE process_api2
1335: (p_validate IN BOOLEAN,p_transaction_step_id IN NUMBER, p_effective_date in varchar2 ) IS
1336:
1337: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1338: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1339: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1340: l_eventid ota_events.event_id%TYPE;
1341: l_object_version_number number;

Line 1343: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

1339: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1340: l_eventid ota_events.event_id%TYPE;
1341: l_object_version_number number;
1342: l_person_details OTA_ENROLL_IN_TRAINING_SS.csr_person_to_enroll_details%ROWTYPE;
1343: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1344: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1345: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1346: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1347: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;

Line 1392: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

1388:
1389: l_business_group_id ota_events.business_group_id%type;
1390: l_standard_price ota_events.standard_price%type;
1391:
1392: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1393: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1394: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1395: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1396: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

Line 1393: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

1389: l_business_group_id ota_events.business_group_id%type;
1390: l_standard_price ota_events.standard_price%type;
1391:
1392: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1393: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1394: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1395: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1396: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1397: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

Line 1394: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

1390: l_standard_price ota_events.standard_price%type;
1391:
1392: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1393: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1394: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1395: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1396: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1397: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1398: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

Line 1395: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

1391:
1392: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1393: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1394: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1395: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1396: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1397: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1398: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1399: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

Line 1396: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

1392: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1393: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1394: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1395: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1396: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1397: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1398: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1399: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1400: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

Line 1397: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

1393: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1394: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1395: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1396: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1397: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1398: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1399: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1400: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1401: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

Line 1398: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

1394: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
1395: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1396: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1397: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1398: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1399: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1400: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1401: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1402: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

Line 1399: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

1395: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
1396: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1397: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1398: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1399: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1400: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1401: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1402: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1403: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

Line 1400: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

1396: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
1397: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1398: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1399: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1400: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1401: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1402: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1403: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1404: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

Line 1401: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

1397: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
1398: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1399: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1400: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1401: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1402: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1403: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1404: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1405: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

Line 1402: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

1398: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
1399: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1400: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1401: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1402: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1403: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1404: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1405: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1406: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

Line 1403: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

1399: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
1400: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1401: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1402: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1403: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1404: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1405: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1406: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1407: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

Line 1404: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

1400: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
1401: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1402: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1403: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1404: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1405: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1406: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1407: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1408: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

Line 1405: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

1401: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
1402: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1403: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1404: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1405: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1406: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1407: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1408: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1409: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

Line 1406: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

1402: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
1403: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1404: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1405: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1406: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1407: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1408: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1409: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1410: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

Line 1407: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

1403: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
1404: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1405: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1406: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1407: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1408: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1409: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1410: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1411: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

Line 1408: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

1404: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
1405: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1406: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1407: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1408: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1409: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1410: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1411: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1412: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

Line 1409: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

1405: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
1406: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1407: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1408: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1409: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1410: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1411: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1412: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1413:

Line 1410: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

1406: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
1407: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1408: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1409: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1410: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1411: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1412: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1413:
1414: status_not_seeded exception;

Line 1411: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

1407: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
1408: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1409: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1410: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1411: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1412: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1413:
1414: status_not_seeded exception;
1415:

Line 1412: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

1408: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
1409: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
1410: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1411: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1412: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1413:
1414: status_not_seeded exception;
1415:
1416:

Line 1443: FROM OTA_DELEGATE_BOOKINGS dbt,

1439: WHERE EVENT_ID = l_eventid;
1440:
1441: CURSOR get_existing_internal IS
1442: SELECT count(*)
1443: FROM OTA_DELEGATE_BOOKINGS dbt,
1444: OTA_BOOKING_STATUS_TYPES bst
1445: WHERE dbt.event_id = l_eventid
1446: AND dbt.internal_booking_flag = 'Y'
1447: AND dbt.booking_status_type_id = bst.booking_status_type_id

Line 1458: ota_delegate_bookings ov

1454: SELECT ov.booking_id,
1455: ov.date_booking_placed,
1456: ov.object_version_number
1457: FROM ota_booking_status_types os,
1458: ota_delegate_bookings ov
1459: WHERE ov.event_id = p_event_id
1460: AND ov.delegate_person_id = p_person_id
1461: AND os.booking_status_type_id = ov.booking_status_type_id
1462: AND os.type = 'R';

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

2252: result out nocopy varchar2 ) is
2253:
2254: l_transaction_step_id number;
2255: l_eventid ota_events.event_id%TYPE;
2256: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
2257: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
2258: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
2259: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
2260: l_object_version_number number;

Line 2257: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;

2253:
2254: l_transaction_step_id number;
2255: l_eventid ota_events.event_id%TYPE;
2256: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
2257: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
2258: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
2259: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
2260: l_object_version_number number;
2261: l_date_booking_placed date;

Line 2276: ota_delegate_bookings ov

2272: ov.date_booking_placed,
2273: ov.object_version_number,
2274: ov.business_group_id
2275: FROM ota_booking_status_types os,
2276: ota_delegate_bookings ov
2277: WHERE ov.event_id = p_event_id
2278: AND ov.delegate_person_id = p_person_id
2279: AND os.booking_status_type_id = ov.booking_status_type_id
2280: AND os.type = 'R';