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_TIMEZONE_UPGRADE dependencies on OTA_RESOURCE_BOOKINGS

Line 203: FUNCTION get_primary_venue_id(l_event_id IN ota_resource_bookings.event_id%TYPE)

199:
200: RETURN l_msg_text;
201: END;
202:
203: FUNCTION get_primary_venue_id(l_event_id IN ota_resource_bookings.event_id%TYPE)
204: RETURN NUMBER
205: IS
206: l_primary_venue ota_suppliable_resources.supplied_resource_id%TYPE;
207:

Line 210: FROM ota_resource_bookings resbkng

206: l_primary_venue ota_suppliable_resources.supplied_resource_id%TYPE;
207:
208: CURSOR csr_pri_ven(p_event_id NUMBER) IS
209: SELECT resbkng.supplied_resource_id
210: FROM ota_resource_bookings resbkng
211: WHERE resbkng.event_id = p_event_id
212: AND resbkng.primary_venue_flag = 'Y';
213: BEGIN
214:

Line 304: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',

300: ELSE
301: l_err_msg := nvl(l_err, l_msg);
302: END IF;
303:
304: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',
305: p_business_group_id => NULL,
306: p_source_primary_key => p_res_bkng_id,
307: p_object_value => l_upgrade_name,
308: p_message_text => l_err_msg,

Line 319: UPDATE ota_resource_bookings

315: write_log(l_err_msg);
316:
317: BEGIN
318:
319: UPDATE ota_resource_bookings
320: SET timezone_code = p_time_zone
321: WHERE resource_booking_id = p_res_bkng_id
322: AND object_version_number = p_obj_ver_number
323: AND timezone_code IS NULL;

Line 328: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',

324:
325: EXCEPTION
326: WHEN others THEN
327: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_msg);
328: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',
329: p_business_group_id => NULL,
330: p_source_primary_key => p_res_bkng_id,
331: p_object_value => l_upgrade_name,
332: p_message_text => l_err_msg,

Line 354: FROM ota_resource_bookings

350:
351: CURSOR csr_event_res_bkng(p_event_id NUMBER) IS
352: SELECT resource_booking_id,
353: object_version_number
354: FROM ota_resource_bookings
355: WHERE event_id = p_event_id
356: AND timezone_code IS NULL;
357: BEGIN
358: l_msg := 'Error occurred while upgrading the timezone of events';

Line 394: UPDATE ota_resource_bookings

390: l_time_zone,
391: l_upgrade_id
392: );
393: END LOOP;*/
394: UPDATE ota_resource_bookings
395: SET timezone_code = p_time_zone
396: WHERE event_id in (SELECT event_id
397: FROM ota_events
398: WHERE event_id = p_event_id OR parent_event_id = p_event_id)

Line 409: FROM ota_resource_bookings

405: AS
406: CURSOR csr_cls_frm_res_bkng IS
407: SELECT resource_booking_id,
408: object_version_number
409: FROM ota_resource_bookings
410: WHERE forum_id IN
411: (SELECT forum_id
412: FROM ota_frm_obj_inclusions
413: WHERE object_type = 'E'

Line 427: UPDATE ota_resource_bookings

423: l_upgrade_id
424: );
425: END LOOP;*/
426:
427: UPDATE ota_resource_bookings
428: SET timezone_code = p_time_zone
429: WHERE forum_id IN
430: (SELECT forum_id
431: FROM ota_frm_obj_inclusions

Line 449: FROM ota_resource_bookings

445:
446: CURSOR csr_cls_cha_res_bkng(p_chat_id NUMBER) IS
447: SELECT resource_booking_id,
448: object_version_number
449: FROM ota_resource_bookings
450: WHERE chat_id = p_chat_id
451: AND timezone_code IS NULL;
452: BEGIN
453: l_msg := 'Error occurred while upgrading the timezone of class chats';

Line 489: UPDATE ota_resource_bookings

485: l_upgrade_id
486: );
487: END LOOP;*/
488:
489: UPDATE ota_resource_bookings
490: SET timezone_code = p_time_zone
491: WHERE chat_id = chats_row.chat_id
492: AND timezone_code IS NULL;
493:

Line 508: FROM ota_resource_bookings

504:
505: CURSOR csr_cat_chat_res_bkng(p_chat_id NUMBER) IS
506: SELECT resource_booking_id,
507: object_version_number
508: FROM ota_resource_bookings
509: WHERE chat_id = p_chat_id
510: AND timezone_code IS NULL;
511: BEGIN
512: l_others_msg := 'Error occurred while upgrading the timezone of category chats ';

Line 564: UPDATE ota_resource_bookings

560: l_upgrade_id
561: );
562: END LOOP;*/
563:
564: UPDATE ota_resource_bookings
565: SET timezone_code = l_time_zone
566: WHERE chat_id = cat_chat_bkng_row.chat_id
567: AND timezone_code IS NULL;
568:

Line 594: FROM ota_resource_bookings

590: IS
591: CURSOR csr_cat_frm_res_bkng IS
592: SELECT resource_booking_id,
593: object_version_number
594: FROM ota_resource_bookings
595: WHERE forum_id IN
596: (SELECT forum_id
597: FROM ota_frm_obj_inclusions
598: WHERE primary_flag = 'Y'

Line 605: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',

601: BEGIN
602: l_msg := 'Error occurred while upgrading timezone of category forum resource booking';
603:
604: IF p_default_timezone IS NULL THEN
605: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',
606: p_business_group_id => NULL,
607: p_source_primary_key => l_upgrade_id,
608: p_object_value => 'Timezone',
609: p_message_text => l_default_msg,

Line 628: UPDATE ota_resource_bookings

624: l_upgrade_id
625: );
626: END LOOP;*/
627:
628: UPDATE ota_resource_bookings
629: SET timezone_code = l_time_zone
630: WHERE forum_id IN
631: (SELECT forum_id
632: FROM ota_frm_obj_inclusions

Line 642: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',

638: EXCEPTION
639: WHEN others THEN
640: l_err_code := SQLCODE;
641: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_msg);
642: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',
643: p_business_group_id => NULL,
644: p_source_primary_key => -1,
645: p_object_value => l_upgrade_name,
646: p_message_text => l_err_msg,

Line 753: FROM ota_resource_bookings

749: PROCEDURE upd_ind_res_bookings(p_default_timezone IN VARCHAR2, l_upgrade_id IN NUMBER)
750: IS
751: CURSOR csr_ind_res_bookings IS
752: SELECT supplied_resource_id
753: FROM ota_resource_bookings
754: WHERE event_id IS NULL
755: AND forum_id IS NULL
756: AND chat_id IS NULL
757: AND timezone_code IS NULL

Line 763: FROM ota_resource_bookings

759:
760: CURSOR csr_ind_res_bkng(p_res_id NUMBER) IS
761: SELECT resource_booking_id,
762: object_version_number
763: FROM ota_resource_bookings
764: WHERE supplied_resource_id = p_res_id
765: AND timezone_code IS NULL;
766: BEGIN
767: l_msg := 'Error occurred while upgrading the timezone of independent resources';

Line 789: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',

785:
786: IF(l_time_zone IS NULL) THEN
787:
788: IF p_default_timezone IS NULL THEN
789: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',
790: p_business_group_id => NULL,
791: p_source_primary_key => ind_res_bookings_row.supplied_resource_id,
792: p_object_value => 'Timezone',
793: p_message_text => l_default_msg,

Line 816: UPDATE ota_resource_bookings

812: l_upgrade_id
813: );
814: END LOOP;*/
815:
816: UPDATE ota_resource_bookings
817: SET timezone_code = l_time_zone
818: WHERE supplied_resource_id = ind_res_bookings_row.supplied_resource_id
819: AND timezone_code IS NULL;
820:

Line 859: FROM ota_resource_bookings trb,ota_suppliable_resources res

855: trb.resource_booking_id,
856: trb.timezone_code,
857: trb.book_entire_period_flag,
858: res.resource_type
859: FROM ota_resource_bookings trb,ota_suppliable_resources res
860: WHERE trb.status = 'C'
861: and res.resource_type in ('T','V')
862: and trb.required_date_to >=(trunc(sysdate)-14)
863: and trb.supplied_resource_id=res.supplied_resource_id

Line 932: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',

928: else
929: l_err_msg:=nvl(l_err_msg,l_others_msg);
930: end if;
931:
932: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_RESOURCE_BOOKINGS',
933: p_business_group_id => NULL,
934: p_source_primary_key => get_resource_bookings_row.resource_booking_id,
935: p_object_value => l_upgrade_name,
936: p_message_text => l_err_msg,