[Home] [Help]
PACKAGE: APPS.HZ_TIMEZONE_PUB
Source
1 package HZ_TIMEZONE_PUB AUTHID CURRENT_USER as
2 /*$Header: ARHTMZOS.pls 115.7 2003/10/13 21:50:33 awu ship $ */
3 Procedure Get_Timezone_ID (
4 p_api_version in number,
5 p_init_msg_list in varchar2,
6 p_postal_code in varchar2,
7 p_city in varchar2,
8 p_state in varchar2,
9 p_country in varchar2,
10 x_timezone_id out nocopy number,
11 x_return_status out nocopy varchar2,
12 x_msg_count out nocopy number,
13 x_msg_data out nocopy varchar2
14 );
15
16 /*===========================================================================+
17 | PROCEDURE |
18 | Get_Phone_Timezone_ID |
19 | |
20 | DESCRIPTION |
21 | Return timezone id by passing in area code and phone |
22 | country code. |
23 | parameter p_phone_prefix is for future use. No logic on it. |
24 | |
25 | SCOPE - PUBLIC |
26 | |
27 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
28 | |
29 | ARGUMENTS : IN: |
30 | p_api_version |
31 | p_init_msg_list |
32 | p_phone_country_code |
33 | p_area_code |
34 | p_phone_prefix (for future use) |
35 | p_country_code(only need to pass in if two countries |
36 | have same phone_country_code and no area code |
37 | passed in) |
38 | OUT: |
39 | x_return_status |
40 | x_msg_count |
41 | x_msg_data |
42 | x_timezone_id |
43 | IN/ OUT: |
44 | |
45 | RETURNS : NONE |
46 | |
47 | NOTES |
48 | |
49 | MODIFICATION HISTORY |
50 | AWU 19-AUG-03 Created |
51 | |
52 +===========================================================================*/
53
54 Procedure Get_Phone_Timezone_ID (
55 p_api_version in number,
56 p_init_msg_list in varchar2,
57 p_phone_country_code in varchar2,
58 p_area_code in varchar2,
59 p_phone_prefix in varchar2,
60 p_country_code in varchar2,
61 x_timezone_id out nocopy number,
62 x_return_status out nocopy varchar2,
63 x_msg_count out nocopy number,
64 x_msg_data out nocopy varchar2
65 );
66
67
68
69 Procedure Get_Timezone_GMT_Deviation (
70 p_api_version in number,
71 p_init_msg_list in varchar2,
72 p_timezone_id in number,
73 p_date in date,
74 x_GMT_deviation out nocopy number,
75 x_global_timezone_name out nocopy varchar2,
76 x_name out nocopy varchar2,
77 x_return_status out nocopy varchar2,
78 x_msg_count out nocopy number,
79 x_msg_data out nocopy varchar2
80 );
81
82 Function Convert_DateTime(
83 p_source_tz_id in number,
84 p_dest_tz_id in number,
85 p_source_day_time in date
86 ) RETURN DATE;
87
88 Procedure Get_Time (
89 p_api_version in number,
90 p_init_msg_list in varchar2,
91 p_source_tz_id in number,
92 p_dest_tz_id in number,
93 p_source_day_time in date,
94 x_dest_day_time out nocopy date,
95 x_return_status out nocopy varchar2,
96 x_msg_count out nocopy number,
97 x_msg_data out nocopy varchar2
98 );
99
100 Procedure Get_Time_and_Code (
101 p_api_version in number,
102 p_init_msg_list in varchar2,
103 p_source_tz_id in number,
104 p_dest_tz_id in number,
105 p_source_day_time in date,
106 x_dest_day_time out nocopy date,
107 x_dest_tz_code out nocopy varchar2,
108 x_dest_gmt_deviation out nocopy number,
109 x_return_status out nocopy varchar2,
110 x_msg_count out nocopy number,
111 x_msg_data out nocopy varchar2
112 );
113
114 PROCEDURE Get_Primary_Zone (
115 p_api_version in number,
116 p_init_msg_list in varchar2,
117 p_gmt_deviation_hours in number,
118 p_daylight_savings_time_flag in varchar2,
119 p_begin_dst_month in varchar2,
120 p_begin_dst_day in number,
121 p_begin_dst_week_of_month in number,
122 p_begin_dst_day_of_week in number,
123 p_begin_dst_hour in number,
124 p_end_dst_month in varchar2,
125 p_end_dst_day in number,
126 p_end_dst_week_of_month in number,
127 p_end_dst_day_of_week in number,
128 p_end_dst_hour in number,
129 x_timezone_id out nocopy number,
130 x_timezone_name out nocopy varchar2,
131 x_timezone_code out nocopy varchar2,
132 x_return_status out nocopy varchar2,
133 x_msg_count out nocopy number,
134 x_msg_data out nocopy varchar2
135 );
136
137 Procedure Get_Timezone_Short_Code (
138 p_api_version in number,
139 p_init_msg_list in varchar2,
140 p_timezone_id in number,
141 p_timezone_code in varchar2,
142 p_date in date,
143 x_gmt_deviation out nocopy number,
144 x_timezone_short_code out nocopy varchar2,
145 x_name out nocopy varchar2,
146 x_return_status out nocopy varchar2,
147 x_msg_count out nocopy number,
148 x_msg_data out nocopy varchar2
149 );
150
151 Procedure Get_begin_end_dst_day_time (
152 p_year in varchar2,
153 p_timezone_id in number,
154 x_begin_dst_date out nocopy date,
155 x_end_dst_date out nocopy date
156 );
157
158 Procedure Get_date_from_W_and_D
159 (
160 p_year in varchar2,
161 p_month in varchar2,
162 p_week in varchar2,
163 p_day in varchar2,
164 x_date out nocopy varchar2
165 );
166
167
168 END HZ_TIMEZONE_PUB;