APPS.OTA_ILEARNING2 dependencies on OTA_DELEGATE_BOOKINGS

Line 52: l_booking_id OTA_DELEGATE_BOOKINGS.BOOKING_ID%TYPE;

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;

Line 53: l_ovn OTA_DELEGATE_BOOKINGS.OBJECT_VERSION_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;

Line 63: l_cur_content_player_status OTA_DELEGATE_BOOKINGS.CONTENT_PLAYER_STATUS%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;

Line 64: l_cur_tdb_ovn OTA_DELEGATE_BOOKINGS.OBJECT_VERSION_NUMBER%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');

Line 65: l_cur_event_id OTA_DELEGATE_BOOKINGS.EVENT_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');
69: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');

Line 67: l_date_booking_placed OTA_DELEGATE_BOOKINGS.DATE_BOOKING_PLACED%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');
70: l_finance_header_ovn OTA_FINANCE_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
71: l_finance_header_id OTA_FINANCE_HEADERS.FINANCE_HEADER_ID%TYPE;

Line 77: ota_delegate_bookings TDB,

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

Line 96: ota_delegate_bookings

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: