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_FINANCE_LINES

Line 81: l_tfl_ovn ota_finance_lines.object_version_number%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;
84:
85: l_cancel_hours number := FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_DAYS');

Line 82: l_new_fl ota_finance_lines.finance_line_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;
84:
85: l_cancel_hours number := FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_DAYS');
86:

Line 432: l_line_ovn ota_finance_lines.object_version_number%type;

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;
434: l_Finance_header_id ota_finance_lines.finance_header_id%type;
435: l_line_transfer_Status ota_finance_lines.transfer_status%type;
436: l_Sequence_Number ota_finance_lines.sequence_number%type;

Line 433: l_Finance_Line_id ota_finance_lines.finance_line_id%type;

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;
434: l_Finance_header_id ota_finance_lines.finance_header_id%type;
435: l_line_transfer_Status ota_finance_lines.transfer_status%type;
436: l_Sequence_Number ota_finance_lines.sequence_number%type;
437: l_Date_raised ota_finance_lines.date_raised%type;

Line 434: l_Finance_header_id ota_finance_lines.finance_header_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;
434: l_Finance_header_id ota_finance_lines.finance_header_id%type;
435: l_line_transfer_Status ota_finance_lines.transfer_status%type;
436: l_Sequence_Number ota_finance_lines.sequence_number%type;
437: l_Date_raised ota_finance_lines.date_raised%type;
438:

Line 435: l_line_transfer_Status ota_finance_lines.transfer_status%type;

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;
434: l_Finance_header_id ota_finance_lines.finance_header_id%type;
435: l_line_transfer_Status ota_finance_lines.transfer_status%type;
436: l_Sequence_Number ota_finance_lines.sequence_number%type;
437: l_Date_raised ota_finance_lines.date_raised%type;
438:
439: -- Define local variable for header;

Line 436: l_Sequence_Number ota_finance_lines.sequence_number%type;

432: l_line_ovn ota_finance_lines.object_version_number%type;
433: l_Finance_Line_id ota_finance_lines.finance_line_id%type;
434: l_Finance_header_id ota_finance_lines.finance_header_id%type;
435: l_line_transfer_Status ota_finance_lines.transfer_status%type;
436: l_Sequence_Number ota_finance_lines.sequence_number%type;
437: l_Date_raised ota_finance_lines.date_raised%type;
438:
439: -- Define local variable for header;
440: l_header_ovn ota_finance_headers.object_version_number%type;

Line 437: l_Date_raised ota_finance_lines.date_raised%type;

433: l_Finance_Line_id ota_finance_lines.finance_line_id%type;
434: l_Finance_header_id ota_finance_lines.finance_header_id%type;
435: l_line_transfer_Status ota_finance_lines.transfer_status%type;
436: l_Sequence_Number ota_finance_lines.sequence_number%type;
437: l_Date_raised ota_finance_lines.date_raised%type;
438:
439: -- Define local variable for header;
440: l_header_ovn ota_finance_headers.object_version_number%type;
441: l_header_Transfer_status ota_finance_headers.transfer_status%type;

Line 446: l_tfl_ovn ota_finance_lines.object_version_number%type;

442: -- Define local variable for other
443: l_auto_waitlist varchar2(1);
444: l_sysdate date;
445: l_count number(6);
446: l_tfl_ovn ota_finance_lines.object_version_number%type;
447: l_new_fl ota_finance_lines.finance_line_id%type;
448: l_return_status varchar2(1):= 'T';
449: e_validation_error exception;
450:

Line 447: l_new_fl ota_finance_lines.finance_line_id%type;

443: l_auto_waitlist varchar2(1);
444: l_sysdate date;
445: l_count number(6);
446: l_tfl_ovn ota_finance_lines.object_version_number%type;
447: l_new_fl ota_finance_lines.finance_line_id%type;
448: l_return_status varchar2(1):= 'T';
449: e_validation_error exception;
450:
451: l_cancel_hours number := FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_DAYS');

Line 514: OTA_FINANCE_LINES

510: Object_version_number,
511: Sequence_Number,
512: Date_raised
513: FROM
514: OTA_FINANCE_LINES
515: WHERE Booking_id = l_Booking_id;
516:
517: -- Define finance header cursor
518:

Line 535: ota_finance_lines

531: CURSOR c_count IS
532: SELECT
533: count(finance_line_id)
534: FROM
535: ota_finance_lines
536: WHERE
537: finance_header_id = l_finance_header_id;
538:
539: CURSOR c_sysdate IS

Line 1011: l_finance_line_id ota_finance_lines.finance_line_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;
1015: l_count number;

Line 1012: l_tfl_ovn ota_finance_lines.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;
1015: l_count number;
1016: l_proc varchar2(72) := g_package||'upd_max_attendee';

Line 1041: FROM OTA_FINANCE_LINES

1037:
1038: CURSOR c_tfl IS
1039: Select finance_line_id,
1040: object_version_number
1041: FROM OTA_FINANCE_LINES
1042: WHERE booking_id = l_booking_id;
1043:
1044:
1045: BEGIN