446:
447:
448:
449: v_client_timezone VARCHAR2(50);
450: v_time_zone_name FND_TIMEZONES_VL.NAME%TYPE := NULL;
451:
452:
453: BEGIN
454:
463: -- instead of firing a sql to get the name for each table row
464: begin
465: select name
466: into v_time_zone_name
467: from fnd_timezones_vl
468: where upgrade_tz_id = to_number(v_client_timezone);
469: exception
470: WHEN NO_DATA_FOUND THEN
471: v_time_zone_name := 'Unknown Timezone';
707:
708: v_time_format VARCHAR2(20) := ' HH24:MI:SS'; -- time format is fixed
709: v_client_timezone VARCHAR2(50);
710: v_new_date DATE;
711: v_time_zone_name FND_TIMEZONES_VL.NAME%TYPE := NULL;
712: v_return_string VARCHAR2(1000);
713:
714: BEGIN
715: