129: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
130: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
131: l_object_version_number BINARY_INTEGER;
132: l_tfl_ovn BINARY_INTEGER;
133: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
134: l_booking_type VARCHAR2(4000);
135: l_error_crypt VARCHAR2(4000);
136: --
137: l_mode VARCHAR2(200);
141: -- -------------------
142: -- Finance API Vars
143: -- -------------------
144: l_auto_create_finance VARCHAR2(40);
145: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
146: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
147: fapi_result VARCHAR2(40);
148: fapi_from VARCHAR2(5);
149: fapi_to VARCHAR2(5);
142: -- Finance API Vars
143: -- -------------------
144: l_auto_create_finance VARCHAR2(40);
145: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
146: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
147: fapi_result VARCHAR2(40);
148: fapi_from VARCHAR2(5);
149: fapi_to VARCHAR2(5);
150:
147: fapi_result VARCHAR2(40);
148: fapi_from VARCHAR2(5);
149: fapi_to VARCHAR2(5);
150:
151: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
152: result_create_finance_line VARCHAR2(5) := 'Y';
153: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
154:
155: l_logged_in_user NUMBER;
149: fapi_to VARCHAR2(5);
150:
151: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
152: result_create_finance_line VARCHAR2(5) := 'Y';
153: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
154:
155: l_logged_in_user NUMBER;
156: l_user NUMBER;
157: l_automatic_transfer_gl VARCHAR2(40);
715:
716:
717: IF l_automatic_transfer_gl = 'Y' AND l_finance_line_id IS NOT NULL AND l_offering_id is null THEN
718:
719: UPDATE ota_finance_lines SET transfer_status = 'AT'
720: WHERE finance_line_id = l_finance_line_id;
721:
722:
723: END IF;
853:
854: -- ------------------------
855: -- Finance_cur Variables
856: -- ------------------------
857: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
858: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
859: l_transfer_status ota_finance_lines.transfer_status%TYPE;
860: lf_booking_id ota_finance_lines.booking_id%TYPE;
861: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
854: -- ------------------------
855: -- Finance_cur Variables
856: -- ------------------------
857: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
858: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
859: l_transfer_status ota_finance_lines.transfer_status%TYPE;
860: lf_booking_id ota_finance_lines.booking_id%TYPE;
861: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
862: l_sequence_number ota_finance_lines.sequence_number%TYPE;
855: -- Finance_cur Variables
856: -- ------------------------
857: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
858: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
859: l_transfer_status ota_finance_lines.transfer_status%TYPE;
860: lf_booking_id ota_finance_lines.booking_id%TYPE;
861: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
862: l_sequence_number ota_finance_lines.sequence_number%TYPE;
863: l_raised_date date;
856: -- ------------------------
857: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
858: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
859: l_transfer_status ota_finance_lines.transfer_status%TYPE;
860: lf_booking_id ota_finance_lines.booking_id%TYPE;
861: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
862: l_sequence_number ota_finance_lines.sequence_number%TYPE;
863: l_raised_date date;
864: l_finance_count number(10);
857: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
858: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
859: l_transfer_status ota_finance_lines.transfer_status%TYPE;
860: lf_booking_id ota_finance_lines.booking_id%TYPE;
861: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
862: l_sequence_number ota_finance_lines.sequence_number%TYPE;
863: l_raised_date date;
864: l_finance_count number(10);
865: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
858: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
859: l_transfer_status ota_finance_lines.transfer_status%TYPE;
860: lf_booking_id ota_finance_lines.booking_id%TYPE;
861: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
862: l_sequence_number ota_finance_lines.sequence_number%TYPE;
863: l_raised_date date;
864: l_finance_count number(10);
865: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
866: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
861: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
862: l_sequence_number ota_finance_lines.sequence_number%TYPE;
863: l_raised_date date;
864: l_finance_count number(10);
865: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
866: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
867: -- ------------------------
868: -- header_cur Variables
869: -- ------------------------
871: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
872: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
873: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
874:
875: CURSOR finance (p_booking_id ota_finance_lines.booking_id%TYPE) IS
876: SELECT FLN.finance_line_id finance_line_id,
877: FLN.finance_header_id finance_header_id,
878: FLN.transfer_status transfer_status,
879: FLN.booking_id booking_id,
879: FLN.booking_id booking_id,
880: FLN.object_version_number object_version_number,
881: FLN.sequence_number sequence_number,
882: FLN.Cancelled_flag cancelled_flag
883: FROM OTA_FINANCE_LINES FLN
884: WHERE FLN.booking_id = p_booking_id;
885:
886: CURSOR finance_count (p_finance_header_id ota_finance_lines.finance_header_id%TYPE) IS
887: SELECT count(*)
882: FLN.Cancelled_flag cancelled_flag
883: FROM OTA_FINANCE_LINES FLN
884: WHERE FLN.booking_id = p_booking_id;
885:
886: CURSOR finance_count (p_finance_header_id ota_finance_lines.finance_header_id%TYPE) IS
887: SELECT count(*)
888: FROM OTA_FINANCE_LINES FLN
889: WHERE FLN.finance_header_id = p_finance_header_id;
890:
884: WHERE FLN.booking_id = p_booking_id;
885:
886: CURSOR finance_count (p_finance_header_id ota_finance_lines.finance_header_id%TYPE) IS
887: SELECT count(*)
888: FROM OTA_FINANCE_LINES FLN
889: WHERE FLN.finance_header_id = p_finance_header_id;
890:
891: CURSOR header (p_booking_id ota_finance_lines.booking_id%TYPE) IS
892: SELECT FLH.finance_header_id finance_header_id,
887: SELECT count(*)
888: FROM OTA_FINANCE_LINES FLN
889: WHERE FLN.finance_header_id = p_finance_header_id;
890:
891: CURSOR header (p_booking_id ota_finance_lines.booking_id%TYPE) IS
892: SELECT FLH.finance_header_id finance_header_id,
893: FLH.cancelled_flag cancelled_flag,
894: FLH.transfer_status transfer_status,
895: FLH.object_version_number object_version_number
893: FLH.cancelled_flag cancelled_flag,
894: FLH.transfer_status transfer_status,
895: FLH.object_version_number object_version_number
896: FROM OTA_FINANCE_HEADERS FLH,
897: OTA_FINANCE_LINES FLN
898: WHERE FLH.finance_header_id = FLN.finance_header_id
899: AND FLN.booking_id = p_booking_id;
900:
901: BEGIN