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_ILEARNING2 dependencies on OTA_BOOKING_STATUS_TYPES

Line 60: l_booking_status_type_id OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID%TYPE;

56: l_sequence_number OTA_FINANCE_LINES.SEQUENCE_NUMBER%TYPE;
57: l_fl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;
58: l_tfl_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;

Line 62: l_cur_booking_status_type_id OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID%TYPE;

58: l_tfl_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;

Line 66: l_status_type OTA_BOOKING_STATUS_TYPES.TYPE%type;

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');
70: l_finance_header_ovn OTA_FINANCE_HEADERS.OBJECT_VERSION_NUMBER%TYPE;

Line 121: ota_booking_status_types

117: cursor cur_get_status_type_id is
118: select
119: booking_status_type_id
120: from
121: ota_booking_status_types
122: where
123: type = 'A' and
124: default_flag = 'Y' and
125: active_flag = 'Y' and

Line 130: from ota_booking_status_types

126: business_group_id = p_business_group_id;
127:
128: cursor csr_booking_status(p_status_type_id number) is
129: Select type
130: from ota_booking_status_types
131: where booking_status_type_id = p_status_type_id;
132:
133: /* for Bug 2242840 */
134: cursor csr_finance_header(p_finance_header_id IN number) IS