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

Line 445: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

441:
442: l_eventid ota_events.event_id%TYPE;
443: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
444: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
445: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
446: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
447: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
448: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
449: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;

Line 447: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;

443: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
444: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
445: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
446: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
447: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
448: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
449: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
450: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
451: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

Line 449: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;

445: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
446: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
447: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
448: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
449: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
450: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
451: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
452: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
453: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

Line 450: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

446: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
447: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
448: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
449: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
450: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
451: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
452: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
453: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
454: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

Line 451: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

447: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
448: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
449: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
450: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
451: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
452: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
453: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
454: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
455: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

Line 452: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

448: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
449: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
450: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
451: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
452: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
453: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
454: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
455: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
456: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

Line 453: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

449: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
450: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
451: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
452: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
453: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
454: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
455: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
456: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
457: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

Line 454: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

450: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
451: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
452: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
453: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
454: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
455: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
456: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
457: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
458: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

Line 455: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

451: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
452: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
453: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
454: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
455: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
456: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
457: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
458: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
459: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

Line 456: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

452: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
453: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
454: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
455: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
456: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
457: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
458: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
459: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
460: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

Line 457: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

453: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
454: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
455: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
456: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
457: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
458: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
459: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
460: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
461: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

Line 458: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

454: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
455: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
456: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
457: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
458: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
459: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
460: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
461: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
462: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

Line 459: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

455: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
456: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
457: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
458: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
459: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
460: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
461: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
462: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
463: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

Line 460: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

456: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
457: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
458: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
459: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
460: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
461: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
462: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
463: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
464: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

Line 461: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

457: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
458: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
459: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
460: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
461: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
462: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
463: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
464: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
465: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

Line 462: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

458: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
459: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
460: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
461: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
462: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
463: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
464: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
465: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
466: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

Line 463: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

459: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
460: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
461: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
462: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
463: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
464: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
465: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
466: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
467: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

Line 464: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

460: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
461: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
462: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
463: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
464: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
465: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
466: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
467: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
468: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

Line 465: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

461: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
462: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
463: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
464: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
465: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
466: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
467: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
468: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
469: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

Line 466: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

462: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
463: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
464: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
465: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
466: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
467: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
468: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
469: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
470: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

Line 467: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

463: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
464: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
465: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
466: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
467: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
468: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
469: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
470: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
471: l_oafunc varchar2(100);

Line 468: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

464: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
465: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
466: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
467: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
468: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
469: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
470: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
471: l_oafunc varchar2(100);
472: l_processname varchar2(100);

Line 469: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

465: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
466: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
467: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
468: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
469: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
470: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
471: l_oafunc varchar2(100);
472: l_processname varchar2(100);
473: l_calledfrom varchar2(100);

Line 470: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

466: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
467: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
468: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
469: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
470: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
471: l_oafunc varchar2(100);
472: l_processname varchar2(100);
473: l_calledfrom varchar2(100);
474: l_frommenu varchar2(100);

Line 695: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

691: )
692: is
693:
694: l_eventid ota_events.event_id%TYPE;
695: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
696: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
697: l_ccselectiontext varchar2(200);
698: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
699: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

Line 698: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

694: l_eventid ota_events.event_id%TYPE;
695: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
696: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
697: l_ccselectiontext varchar2(200);
698: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
699: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
700: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
701: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
702: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

Line 699: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

695: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
696: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
697: l_ccselectiontext varchar2(200);
698: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
699: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
700: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
701: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
702: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
703: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

Line 700: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

696: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
697: l_ccselectiontext varchar2(200);
698: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
699: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
700: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
701: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
702: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
703: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
704: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

Line 701: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

697: l_ccselectiontext varchar2(200);
698: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
699: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
700: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
701: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
702: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
703: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
704: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
705: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

Line 702: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

698: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
699: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
700: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
701: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
702: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
703: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
704: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
705: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
706: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

Line 703: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

699: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
700: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
701: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
702: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
703: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
704: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
705: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
706: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
707: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

Line 704: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

700: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
701: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
702: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
703: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
704: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
705: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
706: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
707: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
708: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

Line 705: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

701: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
702: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
703: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
704: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
705: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
706: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
707: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
708: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
709: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

Line 706: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

702: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
703: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
704: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
705: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
706: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
707: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
708: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
709: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
710: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

Line 707: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

703: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
704: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
705: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
706: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
707: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
708: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
709: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
710: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
711: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

Line 708: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

704: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
705: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
706: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
707: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
708: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
709: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
710: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
711: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
712: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

Line 709: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

705: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
706: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
707: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
708: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
709: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
710: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
711: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
712: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
713: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

Line 710: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

706: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
707: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
708: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
709: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
710: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
711: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
712: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
713: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
714: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

Line 711: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

707: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
708: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
709: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
710: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
711: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
712: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
713: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
714: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
715: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

Line 712: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

708: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
709: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
710: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
711: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
712: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
713: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
714: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
715: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
716: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

Line 713: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

709: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
710: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
711: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
712: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
713: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
714: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
715: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
716: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
717: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

Line 714: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

710: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
711: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
712: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
713: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
714: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
715: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
716: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
717: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
718: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

Line 715: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

711: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
712: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
713: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
714: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
715: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
716: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
717: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
718: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
719: l_trnorgnames varchar2(2000);

Line 716: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

712: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
713: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
714: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
715: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
716: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
717: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
718: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
719: l_trnorgnames varchar2(2000);
720:

Line 717: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

713: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
714: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
715: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
716: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
717: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
718: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
719: l_trnorgnames varchar2(2000);
720:
721: begin

Line 718: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

714: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
715: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
716: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
717: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
718: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
719: l_trnorgnames varchar2(2000);
720:
721: begin
722:

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

883:
884: PROCEDURE process_api2
885: (p_validate IN BOOLEAN,p_transaction_step_id IN NUMBER) IS
886:
887: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
888: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
889: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
890: l_eventid ota_events.event_id%TYPE;
891: l_object_version_number number;

Line 893: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

889: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
890: l_eventid ota_events.event_id%TYPE;
891: l_object_version_number number;
892: l_person_details OTA_trng_enroll_SS.csr_person_to_enroll_details%ROWTYPE;
893: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
894: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
895: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
896: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
897: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;

Line 942: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

938:
939: l_business_group_id ota_events.business_group_id%type;
940: l_standard_price ota_events.standard_price%type;
941:
942: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
943: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
944: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
945: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
946: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

Line 943: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

939: l_business_group_id ota_events.business_group_id%type;
940: l_standard_price ota_events.standard_price%type;
941:
942: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
943: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
944: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
945: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
946: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
947: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

Line 944: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

940: l_standard_price ota_events.standard_price%type;
941:
942: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
943: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
944: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
945: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
946: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
947: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
948: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

Line 945: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;

941:
942: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
943: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
944: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
945: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
946: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
947: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
948: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
949: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

Line 946: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;

942: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
943: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
944: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
945: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
946: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
947: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
948: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
949: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
950: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

Line 947: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;

943: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
944: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
945: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
946: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
947: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
948: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
949: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
950: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
951: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

Line 948: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;

944: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;
945: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
946: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
947: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
948: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
949: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
950: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
951: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
952: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

Line 949: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;

945: l_tdb_information3 ota_delegate_bookings.TDB_INFORMATION3%TYPE;
946: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
947: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
948: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
949: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
950: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
951: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
952: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
953: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

Line 950: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;

946: l_tdb_information4 ota_delegate_bookings.TDB_INFORMATION4%TYPE;
947: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
948: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
949: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
950: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
951: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
952: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
953: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
954: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

Line 951: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;

947: l_tdb_information5 ota_delegate_bookings.TDB_INFORMATION5%TYPE;
948: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
949: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
950: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
951: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
952: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
953: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
954: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
955: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

Line 952: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;

948: l_tdb_information6 ota_delegate_bookings.TDB_INFORMATION6%TYPE;
949: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
950: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
951: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
952: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
953: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
954: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
955: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
956: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

Line 953: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;

949: l_tdb_information7 ota_delegate_bookings.TDB_INFORMATION7%TYPE;
950: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
951: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
952: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
953: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
954: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
955: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
956: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
957: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

Line 954: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;

950: l_tdb_information8 ota_delegate_bookings.TDB_INFORMATION8%TYPE;
951: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
952: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
953: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
954: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
955: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
956: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
957: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
958: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

Line 955: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;

951: l_tdb_information9 ota_delegate_bookings.TDB_INFORMATION9%TYPE;
952: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
953: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
954: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
955: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
956: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
957: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
958: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
959: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

Line 956: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;

952: l_tdb_information10 ota_delegate_bookings.TDB_INFORMATION10%TYPE;
953: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
954: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
955: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
956: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
957: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
958: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
959: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
960: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

Line 957: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;

953: l_tdb_information11 ota_delegate_bookings.TDB_INFORMATION11%TYPE;
954: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
955: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
956: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
957: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
958: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
959: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
960: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
961: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

Line 958: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;

954: l_tdb_information12 ota_delegate_bookings.TDB_INFORMATION12%TYPE;
955: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
956: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
957: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
958: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
959: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
960: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
961: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
962: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

Line 959: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;

955: l_tdb_information13 ota_delegate_bookings.TDB_INFORMATION13%TYPE;
956: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
957: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
958: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
959: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
960: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
961: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
962: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
963:

Line 960: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;

956: l_tdb_information14 ota_delegate_bookings.TDB_INFORMATION14%TYPE;
957: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
958: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
959: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
960: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
961: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
962: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
963:
964: status_not_seeded exception;

Line 961: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;

957: l_tdb_information15 ota_delegate_bookings.TDB_INFORMATION15%TYPE;
958: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
959: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
960: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
961: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
962: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
963:
964: status_not_seeded exception;
965:

Line 962: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;

958: l_tdb_information16 ota_delegate_bookings.TDB_INFORMATION16%TYPE;
959: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
960: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
961: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
962: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
963:
964: status_not_seeded exception;
965:
966:

Line 993: FROM OTA_DELEGATE_BOOKINGS dbt,

989: WHERE EVENT_ID = l_eventid;
990:
991: CURSOR get_existing_internal IS
992: SELECT count(*)
993: FROM OTA_DELEGATE_BOOKINGS dbt,
994: OTA_BOOKING_STATUS_TYPES bst
995: WHERE dbt.event_id = l_eventid
996: AND dbt.internal_booking_flag = 'Y'
997: AND dbt.booking_status_type_id = bst.booking_status_type_id

Line 1008: ota_delegate_bookings ov

1004: SELECT ov.booking_id,
1005: ov.date_booking_placed,
1006: ov.object_version_number
1007: FROM ota_booking_status_types os,
1008: ota_delegate_bookings ov
1009: WHERE ov.event_id = p_event_id
1010: AND ov.delegate_person_id = p_person_id
1011: AND os.booking_status_type_id = ov.booking_status_type_id
1012: AND os.type = 'R';

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

1778: result out nocopy varchar2 ) is
1779:
1780: l_transaction_step_id number;
1781: l_eventid ota_events.event_id%TYPE;
1782: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1783: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
1784: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1785: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1786: l_object_version_number number;

Line 1783: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;

1779:
1780: l_transaction_step_id number;
1781: l_eventid ota_events.event_id%TYPE;
1782: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1783: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
1784: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1785: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1786: l_object_version_number number;
1787: l_date_booking_placed date;

Line 1802: ota_delegate_bookings ov

1798: ov.date_booking_placed,
1799: ov.object_version_number,
1800: ov.business_group_id
1801: FROM ota_booking_status_types os,
1802: ota_delegate_bookings ov
1803: WHERE ov.event_id = p_event_id
1804: AND ov.delegate_person_id = p_person_id
1805: AND os.booking_status_type_id = ov.booking_status_type_id
1806: AND os.type = 'R';