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

Line 344: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;

340: -- ------------------------
341: -- Finance_csr Variables
342: -- ------------------------
343: --
344: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
345: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
346: l_transfer_status ota_finance_lines.transfer_status%TYPE;
347: lf_booking_id ota_finance_lines.booking_id%TYPE;
348: lf_object_version_number ota_finance_lines.object_version_number%TYPE;

Line 345: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;

341: -- Finance_csr Variables
342: -- ------------------------
343: --
344: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
345: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
346: l_transfer_status ota_finance_lines.transfer_status%TYPE;
347: lf_booking_id ota_finance_lines.booking_id%TYPE;
348: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
349: l_sequence_number ota_finance_lines.sequence_number%TYPE;

Line 346: l_transfer_status ota_finance_lines.transfer_status%TYPE;

342: -- ------------------------
343: --
344: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
345: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
346: l_transfer_status ota_finance_lines.transfer_status%TYPE;
347: lf_booking_id ota_finance_lines.booking_id%TYPE;
348: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
349: l_sequence_number ota_finance_lines.sequence_number%TYPE;
350: l_finance_count number(10);

Line 347: lf_booking_id ota_finance_lines.booking_id%TYPE;

343: --
344: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
345: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
346: l_transfer_status ota_finance_lines.transfer_status%TYPE;
347: lf_booking_id ota_finance_lines.booking_id%TYPE;
348: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
349: l_sequence_number ota_finance_lines.sequence_number%TYPE;
350: l_finance_count number(10);
351: l_cancelled_flag ota_finance_lines.cancelled_flag%type;

Line 348: lf_object_version_number ota_finance_lines.object_version_number%TYPE;

344: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
345: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
346: l_transfer_status ota_finance_lines.transfer_status%TYPE;
347: lf_booking_id ota_finance_lines.booking_id%TYPE;
348: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
349: l_sequence_number ota_finance_lines.sequence_number%TYPE;
350: l_finance_count number(10);
351: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
352: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;

Line 349: l_sequence_number ota_finance_lines.sequence_number%TYPE;

345: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
346: l_transfer_status ota_finance_lines.transfer_status%TYPE;
347: lf_booking_id ota_finance_lines.booking_id%TYPE;
348: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
349: l_sequence_number ota_finance_lines.sequence_number%TYPE;
350: l_finance_count number(10);
351: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
352: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
353: --

Line 351: l_cancelled_flag ota_finance_lines.cancelled_flag%type;

347: lf_booking_id ota_finance_lines.booking_id%TYPE;
348: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
349: l_sequence_number ota_finance_lines.sequence_number%TYPE;
350: l_finance_count number(10);
351: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
352: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
353: --
354: -- ------------------------
355: -- header_csr Variables

Line 404: CURSOR finance_csr (p_booking_id ota_finance_lines.booking_id%TYPE)

400: SELECT b.date_booking_placed, b.content_player_status, b.object_version_number
401: FROM ota_delegate_bookings b
402: WHERE b.booking_id = p_booking_id;
403: --
404: CURSOR finance_csr (p_booking_id ota_finance_lines.booking_id%TYPE)
405: IS
406: SELECT fln.finance_line_id finance_line_id,
407: fln.finance_header_id finance_header_id,
408: fln.transfer_status transfer_status,

Line 413: FROM ota_finance_lines fln

409: fln.booking_id booking_id,
410: fln.object_version_number object_version_number,
411: fln.sequence_number sequence_number,
412: fln.Cancelled_flag cancelled_flag
413: FROM ota_finance_lines fln
414: WHERE fln.booking_id = p_booking_id;
415: --
416: CURSOR finance_count_csr (p_finance_header_id ota_finance_lines.finance_header_id%TYPE)
417: IS

Line 416: CURSOR finance_count_csr (p_finance_header_id ota_finance_lines.finance_header_id%TYPE)

412: fln.Cancelled_flag cancelled_flag
413: FROM ota_finance_lines fln
414: WHERE fln.booking_id = p_booking_id;
415: --
416: CURSOR finance_count_csr (p_finance_header_id ota_finance_lines.finance_header_id%TYPE)
417: IS
418: SELECT COUNT(*)
419: FROM ota_finance_lines fln
420: WHERE fln.finance_header_id = p_finance_header_id;

Line 419: FROM ota_finance_lines fln

415: --
416: CURSOR finance_count_csr (p_finance_header_id ota_finance_lines.finance_header_id%TYPE)
417: IS
418: SELECT COUNT(*)
419: FROM ota_finance_lines fln
420: WHERE fln.finance_header_id = p_finance_header_id;
421: --
422: CURSOR header_csr (p_booking_id ota_finance_lines.booking_id%TYPE)
423: IS

Line 422: CURSOR header_csr (p_booking_id ota_finance_lines.booking_id%TYPE)

418: SELECT COUNT(*)
419: FROM ota_finance_lines fln
420: WHERE fln.finance_header_id = p_finance_header_id;
421: --
422: CURSOR header_csr (p_booking_id ota_finance_lines.booking_id%TYPE)
423: IS
424: SELECT flh.finance_header_id finance_header_id,
425: flh.cancelled_flag cancelled_flag,
426: flh.transfer_status transfer_status,

Line 429: ota_finance_lines fln

425: flh.cancelled_flag cancelled_flag,
426: flh.transfer_status transfer_status,
427: flh.object_version_number object_version_number
428: FROM ota_finance_headers flh,
429: ota_finance_lines fln
430: WHERE flh.finance_header_id = fln.finance_header_id
431: AND fln.booking_id = p_booking_id;
432: --
433: --