[Home] [Help]
PACKAGE: APPS.CS_TIMEZONE_PVT
Source
1 Package CS_TIMEZONE_PVT AUTHID CURRENT_USER AS
2 /* $Header: cscttzos.pls 115.0 99/07/16 08:55:15 porting ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE TimeZone_Rec_Type IS RECORD (
7 time_zone_id NUMBER := NULL,
8 name CS_TIME_ZONES.NAME%TYPE := NULL,
9 description CS_TIME_ZONES.DESCRIPTION%TYPE := NULL,
10 offset_indicator CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := NULL,
11 offset_time CS_TIME_ZONES.OFFSET_TIME%TYPE := NULL,
12 last_update_date CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := NULL,
13 last_updated_by NUMBER := NULL,
14 creation_date CS_TIME_ZONES.CREATION_DATE%TYPE := NULL,
15 created_by NUMBER := NULL,
16 last_update_login NUMBER := NULL,
17 start_date_active CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := NULL,
18 end_date_active CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := NULL,
19 attribute1 CS_TIME_ZONES.ATTRIBUTE1%TYPE := NULL,
20 attribute2 CS_TIME_ZONES.ATTRIBUTE2%TYPE := NULL,
21 attribute3 CS_TIME_ZONES.ATTRIBUTE3%TYPE := NULL,
22 attribute4 CS_TIME_ZONES.ATTRIBUTE4%TYPE := NULL,
23 attribute5 CS_TIME_ZONES.ATTRIBUTE5%TYPE := NULL,
24 attribute6 CS_TIME_ZONES.ATTRIBUTE6%TYPE := NULL,
25 attribute7 CS_TIME_ZONES.ATTRIBUTE7%TYPE := NULL,
26 attribute8 CS_TIME_ZONES.ATTRIBUTE8%TYPE := NULL,
27 attribute9 CS_TIME_ZONES.ATTRIBUTE9%TYPE := NULL,
28 attribute10 CS_TIME_ZONES.ATTRIBUTE10%TYPE := NULL,
29 attribute11 CS_TIME_ZONES.ATTRIBUTE11%TYPE := NULL,
30 attribute12 CS_TIME_ZONES.ATTRIBUTE12%TYPE := NULL,
31 attribute13 CS_TIME_ZONES.ATTRIBUTE13%TYPE := NULL,
32 attribute14 CS_TIME_ZONES.ATTRIBUTE14%TYPE := NULL,
33 attribute15 CS_TIME_ZONES.ATTRIBUTE15%TYPE := NULL,
34 context CS_TIME_ZONES.CONTEXT%TYPE := NULL,
35 object_version_number NUMBER := NULL);
36 G_MISS_timezone_rec TimeZone_Rec_Type;
37 TYPE TimeZone_Val_Rec_Type IS RECORD (
38 time_zone_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
39 name CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
40 description CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
41 offset_indicator CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
42 offset_time CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
43 last_update_date CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
44 last_updated_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
45 creation_date CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
46 created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
47 last_update_login NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
48 start_date_active CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
49 end_date_active CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
50 attribute1 CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
51 attribute2 CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
52 attribute3 CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
53 attribute4 CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
54 attribute5 CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
55 attribute6 CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
56 attribute7 CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
57 attribute8 CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
58 attribute9 CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
59 attribute10 CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
60 attribute11 CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
61 attribute12 CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
62 attribute13 CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
63 attribute14 CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
64 attribute15 CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
65 context CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
66 object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
67 G_MISS_timezone_val_rec TimeZone_Val_Rec_Type;
68 ---------------------------------------------------------------------------
69 -- GLOBAL MESSAGE CONSTANTS
70 ---------------------------------------------------------------------------
71 G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
72 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
73 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
74 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
75 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
76 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
77 G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
78 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
79 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
80 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
81 ---------------------------------------------------------------------------
82 -- GLOBAL VARIABLES
83 ---------------------------------------------------------------------------
84 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_TIMEZONE_PVT';
85 G_APP_NAME CONSTANT VARCHAR2(3) := TAPI_DEV_KIT.G_APP_NAME;
86 ---------------------------------------------------------------------------
87 -- Procedures and Functions
88 ---------------------------------------------------------------------------
89
90 PROCEDURE insert_row
91 (
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
94 p_validation_level IN NUMBER,
95 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
96 x_return_status OUT VARCHAR2,
97 x_msg_count OUT NUMBER,
98 x_msg_data OUT VARCHAR2,
99 p_timezone_rec IN TimeZone_Rec_Type := G_MISS_TIMEZONE_REC,
100 x_time_zone_id OUT NUMBER,
101 x_object_version_number OUT NUMBER);
102 PROCEDURE insert_row
103 (
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
106 p_validation_level IN NUMBER,
107 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
108 x_return_status OUT VARCHAR2,
109 x_msg_count OUT NUMBER,
110 x_msg_data OUT VARCHAR2,
111 p_name IN CS_TIME_ZONES.NAME%TYPE := NULL,
112 p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := NULL,
113 p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := NULL,
114 p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := NULL,
115 p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := NULL,
116 p_last_updated_by IN NUMBER := NULL,
117 p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := NULL,
118 p_created_by IN NUMBER := NULL,
119 p_last_update_login IN NUMBER := NULL,
120 p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := NULL,
121 p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := NULL,
122 p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := NULL,
123 p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := NULL,
124 p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := NULL,
125 p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := NULL,
126 p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := NULL,
127 p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := NULL,
128 p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := NULL,
129 p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := NULL,
130 p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := NULL,
131 p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := NULL,
132 p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := NULL,
133 p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := NULL,
134 p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := NULL,
135 p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := NULL,
136 p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := NULL,
137 p_context IN CS_TIME_ZONES.CONTEXT%TYPE := NULL,
138 p_object_version_number IN NUMBER := NULL,
139 x_time_zone_id OUT NUMBER,
140 x_object_version_number OUT NUMBER);
141 Procedure lock_row
142 (
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
145 p_validation_level IN NUMBER,
146 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
147 x_return_status OUT VARCHAR2,
148 x_msg_count OUT NUMBER,
149 x_msg_data OUT VARCHAR2,
150 p_time_zone_id IN NUMBER,
151 p_object_version_number IN NUMBER);
152 Procedure update_row
153 (
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
156 p_validation_level IN NUMBER,
157 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
158 x_return_status OUT VARCHAR2,
159 x_msg_count OUT NUMBER,
160 x_msg_data OUT VARCHAR2,
161 p_timezone_val_rec IN TimeZone_Val_Rec_Type := G_MISS_TIMEZONE_VAL_REC,
162 x_object_version_number OUT NUMBER);
163 Procedure update_row
164 (
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
167 p_validation_level IN NUMBER,
168 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
169 x_return_status OUT VARCHAR2,
170 x_msg_count OUT NUMBER,
171 x_msg_data OUT VARCHAR2,
172 p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
173 p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
174 p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
175 p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
176 p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
177 p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
178 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
179 p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
180 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
181 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
182 p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
183 p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
184 p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
185 p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
186 p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
187 p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
188 p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
189 p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
190 p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
191 p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
192 p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
193 p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
194 p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
195 p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
196 p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
197 p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
198 p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
199 p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
200 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
201 x_object_version_number OUT NUMBER);
202 Procedure delete_row
203 (
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
206 p_validation_level IN NUMBER,
207 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
208 x_return_status OUT VARCHAR2,
209 x_msg_count OUT NUMBER,
210 x_msg_data OUT VARCHAR2,
211 p_time_zone_id IN NUMBER);
212 PROCEDURE validate_row
213 (
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
216 p_validation_level IN NUMBER,
217 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
218 x_return_status OUT VARCHAR2,
219 x_msg_count OUT NUMBER,
220 x_msg_data OUT VARCHAR2,
221 p_timezone_val_rec IN TimeZone_Val_Rec_Type := G_MISS_TIMEZONE_VAL_REC);
222 PROCEDURE validate_row
223 (
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
226 p_validation_level IN NUMBER,
227 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
228 x_return_status OUT VARCHAR2,
229 x_msg_count OUT NUMBER,
230 x_msg_data OUT VARCHAR2,
231 p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
232 p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
233 p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
234 p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
235 p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
236 p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
237 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
238 p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
239 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
240 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
241 p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
242 p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
243 p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
244 p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
245 p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
246 p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
247 p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
248 p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
249 p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
250 p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
251 p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
252 p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
253 p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
254 p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
255 p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
256 p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
257 p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
258 p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
259 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
260 END CS_TIMEZONE_PVT;