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

Line 76: l_booking_id ota_delegate_bookings.booking_id%type;

72: l_type varchar2(4);
73: l_event_ovn ota_events.object_version_number%type;
74: l_full_name per_people_f.full_name%type;
75:
76: l_booking_id ota_delegate_bookings.booking_id%type;
77: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;
78: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;
79: l_enr_ovn ota_delegate_bookings.object_version_number%type;
80: l_booking_status_type ota_booking_status_types.type%type;

Line 77: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;

73: l_event_ovn ota_events.object_version_number%type;
74: l_full_name per_people_f.full_name%type;
75:
76: l_booking_id ota_delegate_bookings.booking_id%type;
77: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;
78: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;
79: l_enr_ovn ota_delegate_bookings.object_version_number%type;
80: l_booking_status_type ota_booking_status_types.type%type;
81: l_tfl_ovn ota_finance_lines.object_version_number%type;

Line 78: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;

74: l_full_name per_people_f.full_name%type;
75:
76: l_booking_id ota_delegate_bookings.booking_id%type;
77: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;
78: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;
79: l_enr_ovn ota_delegate_bookings.object_version_number%type;
80: l_booking_status_type ota_booking_status_types.type%type;
81: l_tfl_ovn ota_finance_lines.object_version_number%type;
82: l_new_fl ota_finance_lines.finance_line_id%type;

Line 79: l_enr_ovn ota_delegate_bookings.object_version_number%type;

75:
76: l_booking_id ota_delegate_bookings.booking_id%type;
77: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;
78: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;
79: l_enr_ovn ota_delegate_bookings.object_version_number%type;
80: l_booking_status_type ota_booking_status_types.type%type;
81: l_tfl_ovn ota_finance_lines.object_version_number%type;
82: l_new_fl ota_finance_lines.finance_line_id%type;
83: l_user_name fnd_user.user_name%type;

Line 138: OTA_DELEGATE_BOOKINGS tdb,

134: tdb.Object_version_number,
135: tdb.event_id,
136: evt.title
137: FROM
138: OTA_DELEGATE_BOOKINGS tdb,
139: OTA_EVENTS_tl evt -- MLS change _tl added
140: WHERE
141: tdb.Line_id = p_line_id and
142: evt.event_id = tdb.event_id;

Line 411: l_status_id ota_delegate_bookings.booking_status_type_id%type;

407: p_login_id in number)IS
408:
409:
410: l_status_name varchar2(80);
411: l_status_id ota_delegate_bookings.booking_status_type_id%type;
412: -- Define Local variable for booking
413:
414: l_event_id ota_delegate_bookings.event_id%type;
415: l_old_event_id ota_delegate_bookings.event_id%type; -- added for bug #1632104

Line 414: l_event_id ota_delegate_bookings.event_id%type;

410: l_status_name varchar2(80);
411: l_status_id ota_delegate_bookings.booking_status_type_id%type;
412: -- Define Local variable for booking
413:
414: l_event_id ota_delegate_bookings.event_id%type;
415: l_old_event_id ota_delegate_bookings.event_id%type; -- added for bug #1632104
416: l_booking_id ota_delegate_bookings.booking_id%type;
417: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;
418: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;

Line 415: l_old_event_id ota_delegate_bookings.event_id%type; -- added for bug #1632104

411: l_status_id ota_delegate_bookings.booking_status_type_id%type;
412: -- Define Local variable for booking
413:
414: l_event_id ota_delegate_bookings.event_id%type;
415: l_old_event_id ota_delegate_bookings.event_id%type; -- added for bug #1632104
416: l_booking_id ota_delegate_bookings.booking_id%type;
417: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;
418: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;
419: l_enr_ovn ota_delegate_bookings.object_version_number%type;

Line 416: l_booking_id ota_delegate_bookings.booking_id%type;

412: -- Define Local variable for booking
413:
414: l_event_id ota_delegate_bookings.event_id%type;
415: l_old_event_id ota_delegate_bookings.event_id%type; -- added for bug #1632104
416: l_booking_id ota_delegate_bookings.booking_id%type;
417: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;
418: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;
419: l_enr_ovn ota_delegate_bookings.object_version_number%type;
420: l_booking_status_type ota_booking_status_types.type%type;

Line 417: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;

413:
414: l_event_id ota_delegate_bookings.event_id%type;
415: l_old_event_id ota_delegate_bookings.event_id%type; -- added for bug #1632104
416: l_booking_id ota_delegate_bookings.booking_id%type;
417: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;
418: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;
419: l_enr_ovn ota_delegate_bookings.object_version_number%type;
420: l_booking_status_type ota_booking_status_types.type%type;
421: l_daemon_flag ota_delegate_bookings.daemon_flag%type;

Line 418: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;

414: l_event_id ota_delegate_bookings.event_id%type;
415: l_old_event_id ota_delegate_bookings.event_id%type; -- added for bug #1632104
416: l_booking_id ota_delegate_bookings.booking_id%type;
417: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;
418: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;
419: l_enr_ovn ota_delegate_bookings.object_version_number%type;
420: l_booking_status_type ota_booking_status_types.type%type;
421: l_daemon_flag ota_delegate_bookings.daemon_flag%type;
422: l_daemon_type ota_delegate_bookings.daemon_type%type;

Line 419: l_enr_ovn ota_delegate_bookings.object_version_number%type;

415: l_old_event_id ota_delegate_bookings.event_id%type; -- added for bug #1632104
416: l_booking_id ota_delegate_bookings.booking_id%type;
417: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;
418: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;
419: l_enr_ovn ota_delegate_bookings.object_version_number%type;
420: l_booking_status_type ota_booking_status_types.type%type;
421: l_daemon_flag ota_delegate_bookings.daemon_flag%type;
422: l_daemon_type ota_delegate_bookings.daemon_type%type;
423: l_line_id ota_delegate_bookings.line_id%type;

Line 421: l_daemon_flag ota_delegate_bookings.daemon_flag%type;

417: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;
418: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;
419: l_enr_ovn ota_delegate_bookings.object_version_number%type;
420: l_booking_status_type ota_booking_status_types.type%type;
421: l_daemon_flag ota_delegate_bookings.daemon_flag%type;
422: l_daemon_type ota_delegate_bookings.daemon_type%type;
423: l_line_id ota_delegate_bookings.line_id%type;
424: l_event_title ota_events_tl.title%type; -- MLS change _tl added
425: l_business_group_id ota_delegate_bookings.business_group_id%type;

Line 422: l_daemon_type ota_delegate_bookings.daemon_type%type;

418: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;
419: l_enr_ovn ota_delegate_bookings.object_version_number%type;
420: l_booking_status_type ota_booking_status_types.type%type;
421: l_daemon_flag ota_delegate_bookings.daemon_flag%type;
422: l_daemon_type ota_delegate_bookings.daemon_type%type;
423: l_line_id ota_delegate_bookings.line_id%type;
424: l_event_title ota_events_tl.title%type; -- MLS change _tl added
425: l_business_group_id ota_delegate_bookings.business_group_id%type;
426: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=

Line 423: l_line_id ota_delegate_bookings.line_id%type;

419: l_enr_ovn ota_delegate_bookings.object_version_number%type;
420: l_booking_status_type ota_booking_status_types.type%type;
421: l_daemon_flag ota_delegate_bookings.daemon_flag%type;
422: l_daemon_type ota_delegate_bookings.daemon_type%type;
423: l_line_id ota_delegate_bookings.line_id%type;
424: l_event_title ota_events_tl.title%type; -- MLS change _tl added
425: l_business_group_id ota_delegate_bookings.business_group_id%type;
426: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
427: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

Line 425: l_business_group_id ota_delegate_bookings.business_group_id%type;

421: l_daemon_flag ota_delegate_bookings.daemon_flag%type;
422: l_daemon_type ota_delegate_bookings.daemon_type%type;
423: l_line_id ota_delegate_bookings.line_id%type;
424: l_event_title ota_events_tl.title%type; -- MLS change _tl added
425: l_business_group_id ota_delegate_bookings.business_group_id%type;
426: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
427: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
428: -- Define local variable for status
429: l_status_type_id ota_delegate_bookings.booking_status_type_id%type;

Line 426: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=

422: l_daemon_type ota_delegate_bookings.daemon_type%type;
423: l_line_id ota_delegate_bookings.line_id%type;
424: l_event_title ota_events_tl.title%type; -- MLS change _tl added
425: l_business_group_id ota_delegate_bookings.business_group_id%type;
426: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
427: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
428: -- Define local variable for status
429: l_status_type_id ota_delegate_bookings.booking_status_type_id%type;
430:

Line 429: l_status_type_id ota_delegate_bookings.booking_status_type_id%type;

425: l_business_group_id ota_delegate_bookings.business_group_id%type;
426: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
427: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
428: -- Define local variable for status
429: l_status_type_id ota_delegate_bookings.booking_status_type_id%type;
430:
431: -- Define local variable for lines
432: l_line_ovn ota_finance_lines.object_version_number%type;
433: l_Finance_Line_id ota_finance_lines.finance_line_id%type;

Line 475: OTA_DELEGATE_BOOKINGS

471: line_id,
472: old_event_id, -- added for bug #1632104
473: date_booking_placed -- Added for bug 1708632
474: FROM
475: OTA_DELEGATE_BOOKINGS
476: WHERE
477: (daemon_flag = 'Y' OR daemon_flag IS NULL) and
478: daemon_type is not null and
479: business_group_id = l_business_group_id;

Line 1010: l_booking_ovn ota_delegate_bookings.object_version_number%type;

1006: l_event_business_group_id ota_events.business_group_id%type;
1007: l_event_ovn ota_events.object_version_number%type;
1008: l_max_attendee ota_events.maximum_attendees%type;
1009: l_return_status varchar2(1) := 'S';
1010: l_booking_ovn ota_delegate_bookings.object_version_number%type;
1011: l_finance_line_id ota_finance_lines.finance_line_id%type;
1012: l_tfl_ovn ota_finance_lines.object_version_number%type;
1013: l_update_finance varchar2(1);
1014: l_booking_id ota_delegate_bookings.booking_id%type;

Line 1014: l_booking_id ota_delegate_bookings.booking_id%type;

1010: l_booking_ovn ota_delegate_bookings.object_version_number%type;
1011: l_finance_line_id ota_finance_lines.finance_line_id%type;
1012: l_tfl_ovn ota_finance_lines.object_version_number%type;
1013: l_update_finance varchar2(1);
1014: l_booking_id ota_delegate_bookings.booking_id%type;
1015: l_count number;
1016: l_proc varchar2(72) := g_package||'upd_max_attendee';
1017:
1018: CURSOR C_event IS

Line 1034: FROM OTA_Delegate_bookings

1030: booking_id,
1031: Object_Version_number,
1032: business_group_id,
1033: booking_status_type_id
1034: FROM OTA_Delegate_bookings
1035: WHERE event_Id = l_event_id and
1036: number_of_places = l_max_attendee;
1037:
1038: CURSOR c_tfl IS

Line 1069: from ota_delegate_bookings

1065: /* For bug 1819473 */
1066: For db in c_booking
1067: LOOP
1068: select count(*) into l_count
1069: from ota_delegate_bookings
1070: where event_id = l_event_id;
1071: if l_count = 1 then
1072: l_booking_id := db.booking_id;
1073: FOR r_tfl in c_tfl