1: PACKAGE BODY fnd_timezones AS
2: /* $Header: AFTZONEB.pls 115.3 2002/03/01 11:32:40 pkm ship $ */
3: function get_code(tz_id in number) return varchar2 is
4: cursor c1 is
5: select timezone_code
2: /* $Header: AFTZONEB.pls 115.3 2002/03/01 11:32:40 pkm ship $ */
3: function get_code(tz_id in number) return varchar2 is
4: cursor c1 is
5: select timezone_code
6: from fnd_timezones_b
7: where upgrade_tz_id = tz_id;
8: v_tz_code varchar2(50);
9: begin
10: if tz_id is not null then
18:
19: function get_name(tz_code in varchar2) return varchar2 is
20: cursor c1 is
21: select name
22: from fnd_timezones_vl
23: where timezone_code = tz_code;
24:
25: v_tz_name varchar2(80);
26: begin
60:
61: RETURN return_flag;
62: END timezones_enabled;
63:
64: END fnd_timezones;