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

Line 556: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;

552: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
553: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
554: l_object_version_number BINARY_INTEGER;
555: l_tfl_ovn BINARY_INTEGER;
556: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
557: l_booking_type VARCHAR2(4000);
558: l_error_crypt VARCHAR2(4000);
559: --
560: l_mode VARCHAR2(200);

Line 569: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;

565: -- -------------------
566: -- Finance API Vars
567: -- -------------------
568: l_auto_create_finance VARCHAR2(40);
569: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
570: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
571: fapi_result VARCHAR2(40);
572: fapi_from VARCHAR2(5);
573: fapi_to VARCHAR2(5);

Line 570: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

566: -- Finance API Vars
567: -- -------------------
568: l_auto_create_finance VARCHAR2(40);
569: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
570: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
571: fapi_result VARCHAR2(40);
572: fapi_from VARCHAR2(5);
573: fapi_to VARCHAR2(5);
574:

Line 575: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;

571: fapi_result VARCHAR2(40);
572: fapi_from VARCHAR2(5);
573: fapi_to VARCHAR2(5);
574:
575: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
576: result_create_finance_line VARCHAR2(5) := 'Y';
577: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
578:
579: l_logged_in_user NUMBER;

Line 577: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

573: fapi_to VARCHAR2(5);
574:
575: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
576: result_create_finance_line VARCHAR2(5) := 'Y';
577: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
578:
579: l_logged_in_user NUMBER;
580: l_user NUMBER;
581: l_automatic_transfer_gl VARCHAR2(40);

Line 1034: UPDATE ota_finance_lines SET transfer_status = 'AT'

1030:
1031:
1032: IF l_automatic_transfer_gl = 'Y' AND l_finance_line_id IS NOT NULL AND l_offering_id is null THEN
1033:
1034: UPDATE ota_finance_lines SET transfer_status = 'AT'
1035: WHERE finance_line_id = l_finance_line_id;
1036:
1037:
1038:

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

2187: SELECT b.object_version_number
2188: FROM ota_delegate_bookings b
2189: WHERE b.booking_id = p_booking_id;
2190:
2191: CURSOR finance_csr (p_booking_id ota_finance_lines.booking_id%TYPE)
2192: IS
2193: SELECT fln.finance_line_id finance_line_id,
2194: fln.object_version_number object_version_number
2195: FROM ota_finance_lines fln

Line 2195: FROM ota_finance_lines fln

2191: CURSOR finance_csr (p_booking_id ota_finance_lines.booking_id%TYPE)
2192: IS
2193: SELECT fln.finance_line_id finance_line_id,
2194: fln.object_version_number object_version_number
2195: FROM ota_finance_lines fln
2196: WHERE fln.booking_id = p_booking_id;
2197:
2198: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
2199: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;