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_TIMEZONE_UPGRADE

Line 1: PACKAGE BODY ota_timezone_upgrade AS

1: PACKAGE BODY ota_timezone_upgrade AS
2: /* $Header: ottznupg.pkb 120.10 2006/09/04 11:38:45 niarora noship $ */
3: l_upgrade_name constant VARCHAR2(30) := 'OTTZUPG';
4: log_type_i constant VARCHAR2(30) := 'I';
5: -- log type is Information

Line 174: ota_timezone_upgrade.l_upgrade_status := FALSE;

170: p_upgrade_id => l_upgrade_id,
171: p_process_date => sysdate,
172: p_log_type => log_type_e,
173: p_upgrade_name => l_upgrade_name);
174: ota_timezone_upgrade.l_upgrade_status := FALSE;
175: write_log(l_err_msg);
176: END;
177:
178: FUNCTION get_msg_text(l_msg_name IN VARCHAR2) RETURN VARCHAR2 IS l_msg_text VARCHAR2(2000);

Line 313: ota_timezone_upgrade.l_upgrade_status := FALSE;

309: p_upgrade_id => l_upgrade_id,
310: p_process_date => sysdate,
311: p_log_type => log_type_e,
312: p_upgrade_name => l_upgrade_name);
313: ota_timezone_upgrade.l_upgrade_status := FALSE;
314: write_log('Resource_booking_id: ' || p_res_bkng_id);
315: write_log(l_err_msg);
316:
317: BEGIN

Line 337: ota_timezone_upgrade.l_upgrade_status := FALSE;

333: p_upgrade_id => l_upgrade_id,
334: p_process_date => sysdate,
335: p_log_type => log_type_e,
336: p_upgrade_name => l_upgrade_name);
337: ota_timezone_upgrade.l_upgrade_status := FALSE;
338: write_log('Resource_booking_id: ' || p_res_bkng_id);
339: write_log(l_err_msg);
340: END;
341: END;*/

Line 382: ota_timezone_upgrade.l_upgrade_status := FALSE;

378: p_upgrade_id => l_upgrade_id,
379: p_process_date => sysdate,
380: p_log_type => log_type_e,
381: p_upgrade_name => l_upgrade_name);
382: ota_timezone_upgrade.l_upgrade_status := FALSE;
383: write_log(l_err_msg);
384: END;
385:
386: /*FOR row_event_res_bkng IN csr_event_res_bkng (event_sess_row.event_id)

Line 476: ota_timezone_upgrade.l_upgrade_status := FALSE;

472: p_upgrade_id => l_upgrade_id,
473: p_process_date => sysdate,
474: p_log_type => log_type_e,
475: p_upgrade_name => l_upgrade_name);
476: ota_timezone_upgrade.l_upgrade_status := FALSE;
477: write_log(l_err_msg);
478: END;
479:
480: /* FOR row_cls_cha_res_bkng IN csr_cls_cha_res_bkng (chats_row.chat_id)

Line 524: ota_timezone_upgrade.l_upgrade_status := FALSE;

520: p_upgrade_id => l_upgrade_id,
521: p_process_date => sysdate,
522: p_log_type => log_type_i,
523: p_upgrade_name => l_upgrade_name);
524: ota_timezone_upgrade.l_upgrade_status := FALSE;
525: write_log(l_default_msg);
526: ELSE
527: l_time_zone := p_default_timezone;
528:

Line 550: ota_timezone_upgrade.l_upgrade_status := FALSE;

546: p_upgrade_id => l_upgrade_id,
547: p_process_date => sysdate,
548: p_log_type => log_type_e,
549: p_upgrade_name => l_upgrade_name);
550: ota_timezone_upgrade.l_upgrade_status := FALSE;
551: write_log(l_err_msg);
552: END;
553:
554: /* FOR row_cat_chat_res_bkng IN

Line 585: ota_timezone_upgrade.l_upgrade_status := FALSE;

581: p_upgrade_id => l_upgrade_id,
582: p_process_date => sysdate,
583: p_log_type => log_type_e,
584: p_upgrade_name => l_upgrade_name);
585: ota_timezone_upgrade.l_upgrade_status := FALSE;
586: write_log(l_err_msg);
587: END upd_cat_chat_bkng;
588:
589: PROCEDURE upd_cat_frm_bkng(p_default_timezone IN VARCHAR2, l_upgrade_id IN NUMBER)

Line 710: ota_timezone_upgrade.l_upgrade_status := FALSE;

706: p_upgrade_id => l_upgrade_id,
707: p_process_date => sysdate,
708: p_log_type => log_type_i,
709: p_upgrade_name => l_upgrade_name);
710: ota_timezone_upgrade.l_upgrade_status := FALSE;
711: write_log(l_default_msg);
712: ELSE
713: l_time_zone := p_default_timezone;
714: END IF;

Line 745: ota_timezone_upgrade.l_upgrade_status := FALSE;

741: p_upgrade_id => l_upgrade_id,
742: p_process_date => sysdate,
743: p_log_type => log_type_e,
744: p_upgrade_name => l_upgrade_name);
745: ota_timezone_upgrade.l_upgrade_status := FALSE;
746: write_log(l_err_msg);
747: END upd_class_ses_res_bkng;
748:
749: PROCEDURE upd_ind_res_bookings(p_default_timezone IN VARCHAR2, l_upgrade_id IN NUMBER)

Line 798: ota_timezone_upgrade.l_upgrade_status := FALSE;

794: p_upgrade_id => l_upgrade_id,
795: p_process_date => sysdate,
796: p_log_type => log_type_i,
797: p_upgrade_name => l_upgrade_name);
798: ota_timezone_upgrade.l_upgrade_status := FALSE;
799: write_log(l_default_msg);
800: ELSE
801: l_time_zone := p_default_timezone;
802: END IF;

Line 836: ota_timezone_upgrade.l_upgrade_status := FALSE;

832: p_upgrade_id => l_upgrade_id,
833: p_process_date => sysdate,
834: p_log_type => log_type_e,
835: p_upgrade_name => l_upgrade_name);
836: ota_timezone_upgrade.l_upgrade_status := FALSE;
837: write_log(l_err_msg);
838: END upd_ind_res_bookings;
839:
840: PROCEDURE run_timezone_upgrade(errbuf OUT nocopy VARCHAR2, retcode OUT nocopy VARCHAR2)

Line 868: ota_timezone_upgrade.l_upgrade_status := TRUE;

864: order by resource_booking_id;
865:
866:
867: BEGIN
868: ota_timezone_upgrade.l_upgrade_status := TRUE;
869: SELECT MAX(upgrade_id)
870: INTO l_upgrade_id
871: FROM ota_upgrade_log
872: WHERE upgrade_name = l_upgrade_name;

Line 943: ota_timezone_upgrade.l_upgrade_status := FALSE;

939: p_log_type => log_type_e,
940: p_upgrade_name => l_upgrade_name);
941: write_log('Resource_booking_id: ' || get_resource_bookings_row.resource_booking_id);
942: write_log(l_err_msg);
943: ota_timezone_upgrade.l_upgrade_status := FALSE;
944: END;
945: END IF;
946: l_loop_counter:=l_loop_counter+1;
947: if l_loop_counter >=1000 then

Line 964: IF ota_timezone_upgrade.l_upgrade_status = FALSE THEN

960: END LOOP;
961:
962:
963:
964: IF ota_timezone_upgrade.l_upgrade_status = FALSE THEN
965: write_log('Errors have been encountered during this Upgrade process');
966: ELSE
967: write_log('No errors have been encountered during this Upgrade process');
968: END IF;

Line 987: END ota_timezone_upgrade;

983:
984: write_log(l_err_msg);
985: END run_timezone_upgrade;
986:
987: END ota_timezone_upgrade;
988: