APPS.AMS_UTILITY_PVT dependencies on FND_TIMEZONES_VL

Line 1021: -- 16-Dec-2005 prageorg Bug 4761850: Changed HZ_TIMEZONES_VL to FND_TIMEZONES_VL

1017: -- PURPOSE
1018: -- This procedure will return the timezone from the System Timezone profile option
1019: -- HISTORY created 04/24/2000 sugupta
1020: -- 17-May-2002 choang bug 2224836: changed to use SERVER_TIMEZONE_ID
1021: -- 16-Dec-2005 prageorg Bug 4761850: Changed HZ_TIMEZONES_VL to FND_TIMEZONES_VL
1022: ---------------------------------------------------------------------
1023: PROCEDURE get_System_Timezone(
1024:
1025: x_return_status OUT NOCOPY VARCHAR2,

Line 1035: from FND_TIMEZONES_VL

1031: l_sys_name VARCHAR2(80);
1032:
1033: cursor c_get_name(l_time_id IN NUMBER) is
1034: select NAME
1035: from FND_TIMEZONES_VL
1036: where UPGRADE_TZ_ID = l_time_id;
1037:
1038: BEGIN
1039: -- Initialize API return status to success

Line 1069: -- 16-Dec-2005 prageorg Bug 4761850: Changed HZ_TIMEZONES_VL to FND_TIMEZONES_VL

1065: -- PURPOSE
1066: -- This procedure will return the timezone from the User Timezone profile option
1067: -- HISTORY created 04/24/2000 sugupta
1068: -- 17-May-2002 choang bug 2224836: changed to use CLIENT_TIMEZONE_ID
1069: -- 16-Dec-2005 prageorg Bug 4761850: Changed HZ_TIMEZONES_VL to FND_TIMEZONES_VL
1070: ---------------------------------------------------------------------
1071: PROCEDURE get_User_Timezone(
1072:
1073: x_return_status OUT NOCOPY VARCHAR2,

Line 1083: from FND_TIMEZONES_VL

1079: l_user_time_name VARCHAR2(80);
1080:
1081: cursor get_name(l_time_id IN NUMBER) is
1082: select NAME
1083: from FND_TIMEZONES_VL
1084: where UPGRADE_TZ_ID = l_time_id;
1085:
1086: BEGIN
1087: -- Initialize API return status to success