48: ,p_message out nocopy varchar2
49: ) is
50:
51: l_proc varchar2(72) := g_package||'upd_history.';
52: l_booking_id OTA_DELEGATE_BOOKINGS.BOOKING_ID%TYPE;
53: l_ovn OTA_DELEGATE_BOOKINGS.OBJECT_VERSION_NUMBER%TYPE;
54: l_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
55: l_tfl_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
56: l_sequence_number OTA_FINANCE_LINES.SEQUENCE_NUMBER%TYPE;
49: ) is
50:
51: l_proc varchar2(72) := g_package||'upd_history.';
52: l_booking_id OTA_DELEGATE_BOOKINGS.BOOKING_ID%TYPE;
53: l_ovn OTA_DELEGATE_BOOKINGS.OBJECT_VERSION_NUMBER%TYPE;
54: l_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
55: l_tfl_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
56: l_sequence_number OTA_FINANCE_LINES.SEQUENCE_NUMBER%TYPE;
57: l_fl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;
59: l_date_raised OTA_FINANCE_LINES.DATE_RAISED%TYPE;
60: l_booking_status_type_id OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID%TYPE;
61:
62: l_cur_booking_status_type_id OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID%TYPE;
63: l_cur_content_player_status OTA_DELEGATE_BOOKINGS.CONTENT_PLAYER_STATUS%TYPE;
64: l_cur_tdb_ovn OTA_DELEGATE_BOOKINGS.OBJECT_VERSION_NUMBER%TYPE;
65: l_cur_event_id OTA_DELEGATE_BOOKINGS.EVENT_ID%TYPE;
66: l_status_type OTA_BOOKING_STATUS_TYPES.TYPE%type;
67: l_date_booking_placed OTA_DELEGATE_BOOKINGS.DATE_BOOKING_PLACED%TYPE;
60: l_booking_status_type_id OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID%TYPE;
61:
62: l_cur_booking_status_type_id OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID%TYPE;
63: l_cur_content_player_status OTA_DELEGATE_BOOKINGS.CONTENT_PLAYER_STATUS%TYPE;
64: l_cur_tdb_ovn OTA_DELEGATE_BOOKINGS.OBJECT_VERSION_NUMBER%TYPE;
65: l_cur_event_id OTA_DELEGATE_BOOKINGS.EVENT_ID%TYPE;
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');
61:
62: l_cur_booking_status_type_id OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID%TYPE;
63: l_cur_content_player_status OTA_DELEGATE_BOOKINGS.CONTENT_PLAYER_STATUS%TYPE;
64: l_cur_tdb_ovn OTA_DELEGATE_BOOKINGS.OBJECT_VERSION_NUMBER%TYPE;
65: l_cur_event_id OTA_DELEGATE_BOOKINGS.EVENT_ID%TYPE;
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');
63: l_cur_content_player_status OTA_DELEGATE_BOOKINGS.CONTENT_PLAYER_STATUS%TYPE;
64: l_cur_tdb_ovn OTA_DELEGATE_BOOKINGS.OBJECT_VERSION_NUMBER%TYPE;
65: l_cur_event_id OTA_DELEGATE_BOOKINGS.EVENT_ID%TYPE;
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;
73: cursor cur_get_booking_id is
74: select
75: max(booking_id) booking_id
76: from
77: ota_delegate_bookings TDB,
78: ota_events EVT,
79: ota_activity_versions OAV
80: where
81: OAV.rco_id = p_rco_id and
92: object_version_number,
93: event_id,
94: date_booking_placed
95: from
96: ota_delegate_bookings
97: where
98: booking_id = l_booking_id;
99:
100: