[Home] [Help]
76: l_booking_id ota_delegate_bookings.booking_id%type;
77: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;
78: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;
79: l_enr_ovn ota_delegate_bookings.object_version_number%type;
80: l_booking_status_type ota_booking_status_types.type%type;
81: l_tfl_ovn ota_finance_lines.object_version_number%type;
82: l_new_fl ota_finance_lines.finance_line_id%type;
83: l_user_name fnd_user.user_name%type;
84:
146: CURSOR C_BOOKING_STATUS IS
147: SELECT
148: Type
149: FROM
150: OTA_BOOKING_STATUS_TYPES
151: WHERE
152: booking_status_type_id = l_booking_status_type_id;
153: --bug # 5231470 first Date format changed to DD/MM/YYYY from DD-MON-YYYY
154: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS
416: l_booking_id ota_delegate_bookings.booking_id%type;
417: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%type;
418: l_enr_business_group_id ota_delegate_bookings.business_group_id%type;
419: l_enr_ovn ota_delegate_bookings.object_version_number%type;
420: l_booking_status_type ota_booking_status_types.type%type;
421: l_daemon_flag ota_delegate_bookings.daemon_flag%type;
422: l_daemon_type ota_delegate_bookings.daemon_type%type;
423: l_line_id ota_delegate_bookings.line_id%type;
424: l_event_title ota_events_tl.title%type; -- MLS change _tl added
485: CURSOR C_STATUS IS
486: SELECT
487: BOOKING_STATUS_TYPE_ID
488: FROM
489: OTA_BOOKING_STATUS_TYPES
490: WHERE
491: Name = l_status_name;
492:
493: -- Define booking status cursor
495: CURSOR C_BOOKING_STATUS IS
496: SELECT
497: name
498: FROM
499: OTA_BOOKING_STATUS_TYPES_TL -- MLS change _TL added
500: WHERE
501: booking_status_type_id = l_booking_status_type_id;
502:
503: -- Define finance line cursor