66: l_status_type OTA_BOOKING_STATUS_TYPES.TYPE%type;
67: l_date_booking_placed OTA_DELEGATE_BOOKINGS.DATE_BOOKING_PLACED%TYPE;
68: l_auto_transfer varchar2(4) := FND_PROFILE.VALUE('OTA_SSHR_AUTO_GL_TRANSFER');
69: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
70: l_finance_header_ovn OTA_FINANCE_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
71: l_finance_header_id OTA_FINANCE_HEADERS.FINANCE_HEADER_ID%TYPE;
72:
73: cursor cur_get_booking_id is
74: select
67: l_date_booking_placed OTA_DELEGATE_BOOKINGS.DATE_BOOKING_PLACED%TYPE;
68: l_auto_transfer varchar2(4) := FND_PROFILE.VALUE('OTA_SSHR_AUTO_GL_TRANSFER');
69: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
70: l_finance_header_ovn OTA_FINANCE_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
71: l_finance_header_id OTA_FINANCE_HEADERS.FINANCE_HEADER_ID%TYPE;
72:
73: cursor cur_get_booking_id is
74: select
75: max(booking_id) booking_id
132:
133: /* for Bug 2242840 */
134: cursor csr_finance_header(p_finance_header_id IN number) IS
135: select object_version_number from
136: ota_finance_headers
137: where finance_header_id = p_finance_header_id;
138:
139:
140: