DBA Data[Home] [Help]

APPS.PON_OA_UTIL_PKG dependencies on FND_TIMEZONES_VL

Line 450: v_time_zone_name FND_TIMEZONES_VL.NAME%TYPE := NULL;

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:

Line 467: from fnd_timezones_vl

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';

Line 711: v_time_zone_name FND_TIMEZONES_VL.NAME%TYPE := NULL;

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: