1 PACKAGE Ibc_Validate_Pvt AUTHID CURRENT_USER AS
2 /* $Header: ibcvvlds.pls 115.15 2003/10/10 18:43:51 svatsa ship $ */
3
4 -----------------------------------------
5 -- Global Variables
6 -----------------------------------------
7 -- ************************************************************
8 -- The following global variables is used in validation procedures
9 -- -> validation_mode
10 -- ************************************************************
11 G_CREATE VARCHAR2(30) := 'CREATE';
12 G_UPDATE VARCHAR2(30) := 'UPDATE';
13
14
15 -----------------------------------------
16 -- FUNCTIONS
17 -----------------------------------------
18 -- --------------------------------------------------------------
19 -- IS APPROVED
20 --
21 -- Checks to see if content item version is approved
22 --
23 -- --------------------------------------------------------------
24 FUNCTION isApproved(
25 f_citem_ver_id IN NUMBER
26 )
27 RETURN VARCHAR2;
28
29
30 -- --------------------------------------------------------------
31 -- IS APPROVED ITEM
32 --
33 -- Checks to see if content item version is approved
34 --
35 -- --------------------------------------------------------------
36 FUNCTION isApprovedItem(
37 f_citem_id IN NUMBER
38 )
39 RETURN VARCHAR2;
40
41
42 -- --------------------------------------------------------------
43 -- IS BOOLEAN
44 --
45 -- Used to check if item is boolean
46 --
47 -- --------------------------------------------------------------
48 FUNCTION isBoolean(
49 f_boolean IN VARCHAR2
50 )
51 RETURN VARCHAR2;
52
53 -- --------------------------------------------------------------
54 -- IS DATE
55 --
56 -- Used to check if a string is actually a date
57 --
58 -- --------------------------------------------------------------
59 FUNCTION isDate(
60 f_date IN VARCHAR2
61 )
62 RETURN VARCHAR2;
63
64
65 -- --------------------------------------------------------------
66 -- IS NUMBER
67 --
68 -- Used to check if a string is actually a number
69 --
70 -- --------------------------------------------------------------
71 FUNCTION isNumber(
72 f_number IN VARCHAR2
73 )
74 RETURN VARCHAR2;
75
76
77 -- --------------------------------------------------------------
78 -- IS VALID ASSOCIATION
79 --
80 -- Used to check if the association exists
81 --
82 -- --------------------------------------------------------------
83 FUNCTION isValidAssoc(
84 f_assoc_id IN VARCHAR2
85 )
86 RETURN VARCHAR2;
87
88
89
90 -- --------------------------------------------------------------
91 -- IS VALID ASSOCIATION TYPE CODE
92 --
93 -- Used to check if the association type code exists
94 --
95 -- --------------------------------------------------------------
96 FUNCTION isValidAssocType(
97 f_assoc_code IN VARCHAR2
98 )
99 RETURN VARCHAR2;
100
101
102
103 -- --------------------------------------------------------------
104 -- IS VALID ATTRIBUTE CODE
105 --
106 -- Used to check if the directory node exists
107 --
108 -- --------------------------------------------------------------
109 FUNCTION isValidAttrCode(
110 f_attr_type_code IN VARCHAR2
111 ,f_ctype_code IN VARCHAR2
112 )
113 RETURN VARCHAR2;
114
115
116 -- --------------------------------------------------------------
117 -- IS VALID ATTACHMENT
118 --
119 -- Used to check if the attachment exists
120 --
121 -- --------------------------------------------------------------
122 FUNCTION isValidAttachment(
123 f_attach_id IN VARCHAR2
124 )
125 RETURN VARCHAR2;
126
127
128
129 -- --------------------------------------------------------------
130 -- IS VALID CITEM
131 --
132 -- Used to check if the content item version exists
133 --
134 -- --------------------------------------------------------------
135 FUNCTION isValidCitem(
136 f_citem_id IN VARCHAR2
137 )
138 RETURN VARCHAR2;
139
140
141
142 -- --------------------------------------------------------------
143 -- IS VALID CITEM VERSION
144 --
145 -- Used to check if the content item exists
146 --
147 -- --------------------------------------------------------------
148 FUNCTION isValidCitemVer(
149 f_citem_ver_id IN VARCHAR2
150 )
151 RETURN VARCHAR2;
152
153 -- --------------------------------------------------------------
154 -- IS VALID CITEM VERSION FOR CITEM
155 --
156 -- Used to check if the citem version id is valid and belongs to
157 -- a particular content item.
158 --
159 -- --------------------------------------------------------------
160 FUNCTION isValidCitemVerForCitem (
161 f_citem_id IN VARCHAR2
162 ,f_citem_ver_id IN VARCHAR2
163 )
164 RETURN VARCHAR2;
165
166 -- --------------------------------------------------------------
167 -- IS VALID LANGUAGE
168 --
169 -- Used to check if specified language exists in FND_LANGUAGES
170 --
171 -- --------------------------------------------------------------
172 FUNCTION isValidLanguage(
173 p_language IN VARCHAR2
174 )
175 RETURN VARCHAR2;
176
177
178 -- --------------------------------------------------------------
179 -- IS VALID CTYPE
180 --
181 -- Used to check if the content type code exists
182 --
183 -- --------------------------------------------------------------
184 FUNCTION isValidCType(
185 f_ctype_code IN VARCHAR2
186 )
187 RETURN VARCHAR2;
188
189
190 -- --------------------------------------------------------------
191 -- IS VALID DIRECTORY NODE
192 --
193 -- Used to check if the directory node exists
194 --
195 -- --------------------------------------------------------------
196 FUNCTION isValidDirNode(
197 f_node_id IN NUMBER
198 )
199 RETURN VARCHAR2;
200
201
202 -- --------------------------------------------------------------
203 -- IS VALID LOB
204 --
205 -- Used to check if the lob exists in fnd_lobs
206 --
207 -- --------------------------------------------------------------
208 FUNCTION isValidLob(
209 f_lob_id IN NUMBER
210 )
211 RETURN VARCHAR2;
212
213
214 -- --------------------------------------------------------------
215 -- IS VALID RESOURCE
216 --
217 -- Used to check if the resource exists
218 --
219 -- --------------------------------------------------------------
220 FUNCTION isValidResource(
221 f_resource_id IN NUMBER
222 ,f_resource_type IN VARCHAR2
223 )
224 RETURN VARCHAR2;
225
226 -- --------------------------------------------------------------
227 -- IS VALID USER
228 --
229 -- Used to check if the user exists in FND_USER
230 --
231 -- --------------------------------------------------------------
232 FUNCTION isValidUser(
233 f_user_id IN NUMBER
234 )
235 RETURN VARCHAR2;
236
237
238 -- --------------------------------------------------------------
239 -- IS VALID STATUS
240 --
241 -- Used to check if the status code exists
242 --
243 -- --------------------------------------------------------------
244 FUNCTION isValidStatus(
245 f_status IN VARCHAR2
246 )
247 RETURN VARCHAR2;
248
249
250 -- --------------------------------------------------------------
251 -- IS VALID LABEL
252 --
253 -- Used to check if the label exists
254 --
255 -- --------------------------------------------------------------
256 FUNCTION isValidLabel(
257 f_label IN VARCHAR2
258 )
259 RETURN VARCHAR2;
260
261
262
263 -----------------------------------------
264 -- PROCEDURES
265 -----------------------------------------
266 --
267
268 PROCEDURE Validate_NotNULL_NUMBER (
269 p_init_msg_list IN VARCHAR2,
270 p_column_name IN VARCHAR2,
271 p_notnull_column IN NUMBER,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2);
275
276 PROCEDURE Validate_NotNULL_VARCHAR2 (
277 p_init_msg_list IN VARCHAR2,
278 p_column_name IN VARCHAR2,
279 p_notnull_column IN VARCHAR2,
280 x_return_status OUT NOCOPY VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2);
283
284
285 PROCEDURE Validate_Content_Type_Status (
286 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
287 p_Content_Type_Status IN VARCHAR2,
288 X_Return_Status OUT NOCOPY VARCHAR2,
289 X_Msg_Count OUT NOCOPY NUMBER,
290 X_Msg_Data OUT NOCOPY VARCHAR2);
291
292 PROCEDURE Validate_appl_short_name (
293 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294 p_appl_short_name IN VARCHAR2,
295 x_application_id OUT NOCOPY NUMBER,
296 X_Return_Status OUT NOCOPY VARCHAR2,
297 X_Msg_Count OUT NOCOPY NUMBER,
298 X_Msg_Data OUT NOCOPY VARCHAR2);
299
300 PROCEDURE Validate_application_id (
301 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302 p_application_id IN NUMBER,
303 X_Return_Status OUT NOCOPY VARCHAR2,
304 X_Msg_Count OUT NOCOPY NUMBER,
305 X_Msg_Data OUT NOCOPY VARCHAR2);
306
307 PROCEDURE Validate_Content_Type_Code (
308 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
309 p_Content_type_Code IN VARCHAR2,
310 X_Return_Status OUT NOCOPY VARCHAR2,
311 X_Msg_Count OUT NOCOPY NUMBER,
312 X_Msg_Data OUT NOCOPY VARCHAR2);
313
314
315 PROCEDURE Validate_Data_Type_Code (
316 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
317 p_Data_type_Code IN VARCHAR2,
318 X_Return_Status OUT NOCOPY VARCHAR2,
319 X_Msg_Count OUT NOCOPY NUMBER,
320 X_Msg_Data OUT NOCOPY VARCHAR2);
321
322 PROCEDURE Validate_Default_value (
323 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
324 p_data_type_code IN VARCHAR2,
325 p_Default_value IN VARCHAR2,
326 X_Return_Status OUT NOCOPY VARCHAR2,
327 X_Msg_Count OUT NOCOPY NUMBER,
328 X_Msg_Data OUT NOCOPY VARCHAR2);
329
330 PROCEDURE Validate_Reference_Code (
331 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
332 p_data_type_code IN VARCHAR2,
333 p_Reference_Code IN VARCHAR2,
334 X_Return_Status OUT NOCOPY VARCHAR2,
335 X_Msg_Count OUT NOCOPY NUMBER,
336 X_Msg_Data OUT NOCOPY VARCHAR2);
337
338 PROCEDURE Validate_Min_Max_Instances (
339 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
340 p_Max_Instances IN NUMBER,
341 p_Min_Instances IN NUMBER,
342 X_Return_Status OUT NOCOPY VARCHAR2,
343 X_Msg_Count OUT NOCOPY NUMBER,
344 X_Msg_Data OUT NOCOPY VARCHAR2);
345
346
347 PROCEDURE Validate_Resource (
348 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
349 p_resource_id IN NUMBER,
350 p_resource_type IN VARCHAR2,
351 x_return_status OUT NOCOPY VARCHAR2,
352 x_msg_count OUT NOCOPY NUMBER,
353 x_msg_data OUT NOCOPY VARCHAR2);
354
355 /****************************************************
356 -------------FUNCTIONS--------------------------------------------------------------------------
357 ****************************************************/
358 -- --------------------------------------------------------------
359 -- IBC_VALIDATE_PVT.isTranslationApproved
360 --
361 -- Checks to see if content item version translation is approved
362 --
363 -- --------------------------------------------------------------
364 FUNCTION isTranslationApproved(f_citem_ver_id IN NUMBER
365 ,f_language IN VARCHAR2
366 )
367 RETURN VARCHAR2;
368
369 -- --------------------------------------------------------------
370 -- IBC_VALIDATE_PVT.getItemBaseLanguage
371 --
372 -- Get the base language for the content item
373 --
374 -- --------------------------------------------------------------
375 FUNCTION getItemBaseLanguage(f_content_item_id IN NUMBER)
376 RETURN VARCHAR2;
377
378
379 END Ibc_Validate_Pvt;
380