[Home] [Help]
143: ,x_timezone_id OUT NOCOPY NUMBER)
144: IS
145: CURSOR c_timezone IS
146: SELECT timezone_id
147: FROM HZ_TIMEZONES
148: WHERE global_timezone_name = p_timezone_name;
149: BEGIN
150: OPEN c_timezone;
151: FETCH c_timezone INTO x_timezone_id;