1 PACKAGE CS_Core_UTIL AS
2 /* $Header: csucores.pls 120.2 2005/12/14 15:34:41 smisra noship $ */
3
4 -- ---------------------------------------------------------
5 -- Declare Data Types
6 -- ---------------------------------------------------------
7 TYPE DFF_Rec_Type IS RECORD
8 (
9 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
10 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
11 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
25 );
26
27
28 TYPE PRICE_ATT_Rec_Type IS RECORD
29 (
30 PRICING_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
31 PRICING_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32 PRICING_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33 PRICING_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34 PRICING_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35 PRICING_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36 PRICING_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37 PRICING_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38 PRICING_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39 PRICING_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40 PRICING_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41 PRICING_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42 PRICING_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43 PRICING_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44 PRICING_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45 PRICING_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46 PRICING_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47 PRICING_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48 PRICING_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49 PRICING_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50 PRICING_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51 PRICING_ATTRIBUTE21 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52 PRICING_ATTRIBUTE22 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53 PRICING_ATTRIBUTE23 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54 PRICING_ATTRIBUTE24 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55 PRICING_ATTRIBUTE25 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56 PRICING_ATTRIBUTE26 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57 PRICING_ATTRIBUTE27 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58 PRICING_ATTRIBUTE28 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59 PRICING_ATTRIBUTE29 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60 PRICING_ATTRIBUTE30 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61 PRICING_ATTRIBUTE31 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62 PRICING_ATTRIBUTE32 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63 PRICING_ATTRIBUTE33 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64 PRICING_ATTRIBUTE34 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65 PRICING_ATTRIBUTE35 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66 PRICING_ATTRIBUTE36 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67 PRICING_ATTRIBUTE37 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68 PRICING_ATTRIBUTE38 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69 PRICING_ATTRIBUTE39 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70 PRICING_ATTRIBUTE40 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71 PRICING_ATTRIBUTE41 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72 PRICING_ATTRIBUTE42 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73 PRICING_ATTRIBUTE43 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74 PRICING_ATTRIBUTE44 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75 PRICING_ATTRIBUTE45 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76 PRICING_ATTRIBUTE46 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77 PRICING_ATTRIBUTE47 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78 PRICING_ATTRIBUTE48 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79 PRICING_ATTRIBUTE49 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80 PRICING_ATTRIBUTE50 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81 PRICING_ATTRIBUTE51 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82 PRICING_ATTRIBUTE52 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83 PRICING_ATTRIBUTE53 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84 PRICING_ATTRIBUTE54 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85 PRICING_ATTRIBUTE55 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86 PRICING_ATTRIBUTE56 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87 PRICING_ATTRIBUTE57 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88 PRICING_ATTRIBUTE58 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89 PRICING_ATTRIBUTE59 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90 PRICING_ATTRIBUTE60 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91 PRICING_ATTRIBUTE61 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92 PRICING_ATTRIBUTE62 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93 PRICING_ATTRIBUTE63 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94 PRICING_ATTRIBUTE64 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95 PRICING_ATTRIBUTE65 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96 PRICING_ATTRIBUTE66 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97 PRICING_ATTRIBUTE67 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98 PRICING_ATTRIBUTE68 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99 PRICING_ATTRIBUTE69 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100 PRICING_ATTRIBUTE70 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101 PRICING_ATTRIBUTE71 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102 PRICING_ATTRIBUTE72 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103 PRICING_ATTRIBUTE73 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104 PRICING_ATTRIBUTE74 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105 PRICING_ATTRIBUTE75 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106 PRICING_ATTRIBUTE76 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107 PRICING_ATTRIBUTE77 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108 PRICING_ATTRIBUTE78 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109 PRICING_ATTRIBUTE79 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110 PRICING_ATTRIBUTE80 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111 PRICING_ATTRIBUTE81 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112 PRICING_ATTRIBUTE82 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113 PRICING_ATTRIBUTE83 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114 PRICING_ATTRIBUTE84 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115 PRICING_ATTRIBUTE85 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116 PRICING_ATTRIBUTE86 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
117 PRICING_ATTRIBUTE87 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
118 PRICING_ATTRIBUTE88 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
119 PRICING_ATTRIBUTE89 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
120 PRICING_ATTRIBUTE90 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
121 PRICING_ATTRIBUTE91 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
122 PRICING_ATTRIBUTE92 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
123 PRICING_ATTRIBUTE93 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
124 PRICING_ATTRIBUTE94 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
125 PRICING_ATTRIBUTE95 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
126 PRICING_ATTRIBUTE96 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
127 PRICING_ATTRIBUTE97 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
128 PRICING_ATTRIBUTE98 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129 PRICING_ATTRIBUTE99 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130 PRICING_ATTRIBUTE100 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
131 );
132
133 ------------------------------------------------------------------------------
134 -- Procedure : Add_Duplicate_Value_Msg
135 -- Description : Add the CS_API_ALL_DUPLICATE_VALUE message to the message
136 -- list.
137 -- Parameters :
138 -- IN : p_token_an IN VARCHAR2 Required
139 -- Value of the API_NAME token.
140 -- p_token_p IN VARCHAR2 Required
141 -- Value of the DUPLICATE_VAL_PARAM token.
142 ------------------------------------------------------------------------------
143
144 PROCEDURE Add_Duplicate_Value_Msg
145 ( p_token_an IN VARCHAR2,
146 p_token_p IN VARCHAR2 );
147
148 ------------------------------------------------------------------------------
149 -- Procedure : Add_Invalid_Argument_Msg
150 -- Description : Add the CS_API_ALL_INVALID_ARGUMENT message to the message
151 -- list.
152 -- Parameters :
153 -- IN : p_token_an IN VARCHAR2 Required
154 -- Value of the API_NAME token.
155 -- p_token_v IN VARCHAR2 Required
156 -- Value of the VALUE token.
157 -- p_token_p IN VARCHAR2 Required
158 -- Value of the PARAMETER token.
159 ------------------------------------------------------------------------------
160
161 PROCEDURE Add_Invalid_Argument_Msg
162 ( p_token_an IN VARCHAR2,
163 p_token_v IN VARCHAR2,
164 p_token_p IN VARCHAR2 );
165
166 ------------------------------------------------------------------------------
167 -- Procedure : Add_Missing_Param_Msg
168 -- Description : Add the CS_API_ALL_MISSING_PARAM message to the message
169 -- list.
170 -- Parameters :
171 -- p_token_an IN VARCHAR2 Required
172 -- Value of the API_NAME token.
173 -- p_token_mp IN VARCHAR2 Required
174 -- Value of the MISSING_PARAM token.
175 ------------------------------------------------------------------------------
176
177 PROCEDURE Add_Missing_Param_Msg
178 ( p_token_an IN VARCHAR2,
179 p_token_mp IN VARCHAR2 );
180
181 ------------------------------------------------------------------------------
182 -- Procedure : Add_Null_Parameter_Msg
183 -- Description : Add the CS_API_ALL_NULL_PARAMETER message to the message
184 -- list.
185 -- Parameters :
186 -- IN : p_token_an IN VARCHAR2 Required
187 -- Value of the API_NAME token.
188 -- p_token_np IN VARCHAR2 Required
189 -- Value of the NULL_PARAM token.
190 ------------------------------------------------------------------------------
191
192 PROCEDURE Add_Null_Parameter_Msg
193 ( p_token_an IN VARCHAR2,
194 p_token_np IN VARCHAR2 );
195
196 ------------------------------------------------------------------------------
197 -- Procedure : Add_Param_Ignored_Msg
198 -- Description : Add the CS_API_ALL_PARAM_IGNORED message to the message
199 -- list.
200 -- Parameters :
201 -- IN : p_token_an IN VARCHAR2 Required
202 -- Value of the API_NAME token.
203 -- p_token_ip IN VARCHAR2 Required
204 -- Value of the IGNORED_PARAM token.
205 ------------------------------------------------------------------------------
206
207 PROCEDURE Add_Param_Ignored_Msg
208 ( p_token_an IN VARCHAR2,
209 p_token_ip IN VARCHAR2 );
210
211 ------------------------------------------------------------------------------
212 -- Procedure : Add_Same_Val_Update_Msg
213 -- Description : Add the CS_API_ALL_SAME_VAL_UPDATE message to the message
214 -- list.
215 -- Parameters :
216 -- IN : p_token_an IN VARCHAR2 Required
217 -- Value of the API_NAME token.
218 -- p_token_p IN VARCHAR2 Required
219 -- Value of the SAME_VAL_PARAM token.
220 ------------------------------------------------------------------------------
221
222 PROCEDURE Add_Same_Val_Update_Msg
223 ( p_token_an IN VARCHAR2,
224 p_token_p IN VARCHAR2 );
225
226 ------------------------------------------------------------------------------
227 -- Procedure : Convert_Contact_To_ID
228 -- Description : Convert a contact last name and first name into the
229 -- corresponding internal ID.
230 -- Parameters :
231 -- IN : p_api_name IN VARCHAR2(30) Required
232 -- Name of the calling API (used for messages)
233 -- p_parameter_name_ln IN VARCHAR2(30) Required
234 -- Name of the first value-based parameter in the calling
235 -- API (e.g. 'p_contact_lastname')
236 -- p_parameter_name_fn IN VARCHAR2(30) Required
237 -- Name of the second value-based parameter in the
238 -- calling API (e.g. 'p_contact_firstname')
239 -- p_contact_lastname IN VARCHAR2(30) Required
240 -- Value of the contact last name to be converted
241 -- p_contact_firstname IN VARCHAR2(50) Optional
242 -- Value of the contact first name to be converted
243 -- OUT : x_contact_id OUT NUMBER
244 -- x_return_status OUT VARCHAR2(1)
245 -- FND_API.G_RET_STS_SUCCESS => conversion success
246 -- FND_API.G_RET_STS_ERROR => conversion failure
247 ------------------------------------------------------------------------------
248
249 PROCEDURE Convert_Contact_To_ID
250 ( p_api_name IN VARCHAR2,
251 p_parameter_name_ln IN VARCHAR2,
252 p_parameter_name_fn IN VARCHAR2,
253 p_contact_lastname IN VARCHAR2,
254 p_contact_firstname IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
255 x_contact_id OUT NOCOPY NUMBER,
256 x_return_status OUT NOCOPY VARCHAR2 );
257
258 ------------------------------------------------------------------------------
259 -- Procedure : Convert_Customer_To_ID
260 -- Description : Convert a customer name or a customer number into the
261 -- corresponding internal ID. Either p_customer_name or
262 -- p_customer_number must be passed. If both are passed,
263 -- p_customer_name will be ignored.
264 -- Parameters :
265 -- IN : p_api_name IN VARCHAR2(30) Required
266 -- Name of the calling API (used for messages)
267 -- p_parameter_name_nb IN VARCHAR2(30) Required
268 -- Name of the first value-based parameter in the calling
269 -- API (e.g. 'p_customer_number')
270 -- p_parameter_name_n IN VARCHAR2(30) Required
271 -- Name of the second value-based parameter in the
272 -- calling API (e.g. 'p_customer_name')
273 -- p_customer_number IN VARCHAR2(30) Optional
274 -- Value of the customer number to be converted
275 -- p_customer_name IN VARCHAR2(50) Optional
276 -- Value of the customer name to be converted
277 -- OUT : x_customer_id OUT NUMBER
278 -- x_return_status OUT VARCHAR2(1)
279 -- FND_API.G_RET_STS_SUCCESS => conversion success
280 -- FND_API.G_RET_STS_ERROR => conversion failure
281 ------------------------------------------------------------------------------
282
283 PROCEDURE Convert_Customer_To_ID
284 ( p_api_name IN VARCHAR2,
285 p_parameter_name_nb IN VARCHAR2,
286 p_parameter_name_n IN VARCHAR2,
287 p_customer_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
291
288 p_customer_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
289 x_customer_id OUT NOCOPY NUMBER,
290 x_return_status OUT NOCOPY VARCHAR2 );
292 ------------------------------------------------------------------------------
293 -- Procedure : Convert_Customer_To_Name
294 -- Description : Converts a customer ID to the customer name
295 -- Parameters :
296 -- IN : p_api_name IN VARCHAR2 Required
297 -- Name of the calling API (used for messages)
298 -- p_parameter_name IN VARCHAR2 Required
299 -- Name of the ID-based parameter in the calling API
300 -- (e.g. 'p_customer_id')
301 -- p_customer_id IN NUMBER Required
302 -- Value of the customer ID to be converted
303 -- OUT : x_customer_name OUT VARCHAR2(50)
304 -- x_return_status OUT VARCHAR2(1)
305 -- FND_API.G_RET_STS_SUCCESS => conversion success
306 -- FND_API.G_RET_STS_ERROR => conversion failure
307 ------------------------------------------------------------------------------
308
309 PROCEDURE Convert_Customer_To_Name
310 ( p_api_name IN VARCHAR2,
311 p_parameter_name IN VARCHAR2,
312 p_customer_id IN NUMBER,
313 x_customer_name OUT NOCOPY VARCHAR2,
314 x_return_status OUT NOCOPY VARCHAR2 );
315
316 ------------------------------------------------------------------------------
317 -- Procedure : Convert_Employee_To_ID
318 -- Description : Convert an employee name or an employee number into the
319 -- corresponding internal ID. Either p_employee_name or
320 -- p_employee_number must be passed. If both are passed,
321 -- p_employee_name will be ignored.
322 -- Parameters :
323 -- IN : p_api_name IN VARCHAR2(30) Required
324 -- Name of the calling API (used for messages)
325 -- p_parameter_name_nb IN VARCHAR2(30) Required
326 -- Name of the first value-based parameter in the calling
327 -- API (e.g. 'p_employee_number')
328 -- p_parameter_name_n IN VARCHAR2(30) Required
329 -- Name of the second value-based parameter in the
330 -- calling API (e.g. 'p_employee_name')
331 -- p_employee_number IN VARCHAR2(30) Optional
332 -- Value of the employee number to be converted
333 -- p_employee_name IN VARCHAR2(50) Optional
334 -- Value of the employee name to be converted
335 -- OUT : x_employee_id OUT NUMBER
336 -- x_return_status OUT VARCHAR2(1)
337 -- FND_API.G_RET_STS_SUCCESS => conversion success
338 -- FND_API.G_RET_STS_ERROR => conversion failure
339 ------------------------------------------------------------------------------
340
341 PROCEDURE Convert_Employee_To_ID
342 ( p_api_name IN VARCHAR2,
343 p_parameter_name_nb IN VARCHAR2,
344 p_parameter_name_n IN VARCHAR2,
345 p_employee_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
346 p_employee_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
347 x_employee_id OUT NOCOPY NUMBER,
348 x_return_status OUT NOCOPY VARCHAR2 );
349
350 ------------------------------------------------------------------------------
351 -- Procedure : Convert_Lookup_To_Code
352 -- Description : Convert a lookup meaning into the corresponding internal
353 -- code.
354 -- Parameters :
355 -- IN : p_api_name IN VARCHAR2(30) Required
356 -- Name of the calling API (used for messages)
357 -- p_parameter_name IN VARCHAR2(30) Required
358 -- Name of the value-based parameter in the calling API
359 -- p_meaning IN VARCHAR2(30) Required
360 -- Value of the lookup meaning to be converted
361 -- p_lookup_type IN VARCHAR2(30) Required
362 -- OUT : x_lookup_code OUT VARCHAR2(30)
363 -- x_return_status OUT VARCHAR2(1)
364 -- FND_API.G_RET_STS_SUCCESS => conversion success
365 -- FND_API.G_RET_STS_ERROR => conversion failure
366 ------------------------------------------------------------------------------
367
368 PROCEDURE Convert_Lookup_To_Code
369 ( p_api_name IN VARCHAR2,
370 p_parameter_name IN VARCHAR2,
371 p_meaning IN VARCHAR2,
372 p_lookup_type IN VARCHAR2,
373 x_lookup_code OUT NOCOPY VARCHAR2,
374 x_return_status OUT NOCOPY VARCHAR2 );
375
376 ------------------------------------------------------------------------------
377 -- Procedure : Convert_Org_To_ID
378 -- Description : Convert an operating unit name into the corresponding
379 -- internal ID.
380 -- Parameters :
381 -- IN : p_api_name IN VARCHAR2(30) Required
382 -- Name of the calling API (used for messages)
383 -- p_parameter_name IN VARCHAR2(30) Required
384 -- Name of the value-based parameter in the calling API
388 -- OUT : x_org_id OUT NUMBER
385 -- (e.g. 'p_org_name')
386 -- p_org_name IN VARCHAR2(60) Required
387 -- Value of the operating unit name to be converted
389 -- x_return_status OUT VARCHAR2(1)
390 -- FND_API.G_RET_STS_SUCCESS => conversion success
391 -- FND_API.G_RET_STS_ERROR => conversion failure
392 ------------------------------------------------------------------------------
393
394 PROCEDURE Convert_Org_To_ID
395 ( p_api_name IN VARCHAR2,
396 p_parameter_name IN VARCHAR2,
397 p_org_name IN VARCHAR2,
398 x_org_id OUT NOCOPY NUMBER,
399 x_return_status OUT NOCOPY VARCHAR2 );
400
401 ------------------------------------------------------------------------------
402 -- Procedure : Default_Common_Attributes
403 -- Description : Default application ID, responsibility ID, user ID, login
404 -- ID, operating unit ID and inventory organization ID.
405 -- If the parameter is FND_API.G_MISS_NUM, then the default
406 -- value for that attribute is returned. Else the passed value
407 -- is returned.
408 -- Parameters :
409 -- IN : p_api_name IN VARCHAR2(30) Required
410 -- Name of the calling API (used for messages)
411 -- IN OUT : p_resp_appl_id IN OUT NUMBER Required
412 -- p_resp_id IN OUT NUMBER Required
413 -- p_user_id IN OUT NUMBER Required
414 -- p_login_id IN OUT NUMBER Required
415 -- p_org_id IN OUT NUMBER Required
416 -- p_inventory_org_id IN OUT NUMBER Required
417 ------------------------------------------------------------------------------
418 /*
419 PROCEDURE Default_Common_Attributes
420 ( p_api_name IN VARCHAR2,
421 p_resp_appl_id IN OUT NUMBER,
422 p_resp_id IN OUT NUMBER,
423 p_user_id IN OUT NUMBER,
424 p_login_id IN OUT NUMBER,
425 p_org_id IN OUT NUMBER,
426 p_inventory_org_id IN OUT NUMBER );
427 */
428 ------------------------------------------------------------------------------
429 -- Function : Is_MultiOrg_Enabled
430 -- Description : Checks if the Multi-Org feature is enabled.
431 -- Parameters : None.
432 -- Return : BOOLEAN
433 -- Returns TRUE if Multi-Org is enabled; FALSE otherwise
434 ------------------------------------------------------------------------------
435
436 FUNCTION Is_MultiOrg_Enabled RETURN BOOLEAN;
437
438 ------------------------------------------------------------------------------
439 -- Procedure : Trunc_String_Length
440 -- Description : Verify that the string is shorter than the defined width of
441 -- the column. If the character value is longer than the
442 -- defined width of the VARCHAR2 column, truncate the value.
443 -- Parameters :
444 -- IN : p_api_name IN VARCHAR2(30) Required
445 -- Name of the calling API (used for messages)
446 -- p_parameter_name IN VARCHAR2(30) Required
447 -- Name of the parameter in the calling API
448 -- (e.g. 'p_notes')
449 -- p_str IN VARCHAR2 Required
450 -- Value of the VARCHAR2 parameter
451 -- p_len IN NUMBER Required
452 -- Length of the corresponding database column
453 -- OUT : x_str OUT VARCHAR2 Required
454 -- Value of the VARCHAR2 parameter (may be truncated)
455 ------------------------------------------------------------------------------
456
457 PROCEDURE Trunc_String_length
458 ( p_api_name IN VARCHAR2,
459 p_parameter_name IN VARCHAR2,
460 p_str IN VARCHAR2,
461 p_len IN NUMBER,
462 x_str OUT NOCOPY VARCHAR2 );
463
464 ------------------------------------------------------------------------------
465 -- Procedure : Validate_Bill_To_Site
466 -- Description : Verify that the given site is a valid billing site within
467 -- the given operating unit, and it belongs to the given
468 -- customer or a related customer.
469 -- Parameters :
470 -- IN : p_api_name IN VARCHAR2 Required
471 -- Name of the calling procedure
472 -- p_parameter_name IN VARCHAR2 Required
473 -- Name of the parameter in the calling API
474 -- (e.g. 'p_bill_to_site_use_id')
475 -- p_bill_to_site_id IN NUMBER Required
476 -- p_customer_id IN NUMBER Required
477 -- p_org_id IN NUMBER Optional
478 -- OUT : x_bill_to_customer_id OUT NUMBER
479 -- x_return_status OUT VARCHAR2(1)
480 -- FND_API.G_RET_STS_SUCCESS => site is valid
481 -- FND_API.G_RET_STS_ERROR => site is invalid
482 ------------------------------------------------------------------------------
483
487 p_bill_to_site_id IN NUMBER,
484 PROCEDURE Validate_Bill_To_Site
485 ( p_api_name IN VARCHAR2,
486 p_parameter_name IN VARCHAR2,
488 p_customer_id IN NUMBER,
489 p_org_id IN NUMBER := NULL,
490 x_bill_to_customer_id OUT NOCOPY NUMBER,
491 x_return_status OUT NOCOPY VARCHAR2 );
492
493 ------------------------------------------------------------------------------
494 -- Function : Validate_Comment
495 -- Description : Validate that the given comment is valid.
496 -- Parameters :
497 -- IN : p_api_name IN VARCHAR2(30) Required
498 -- Name of the calling API (used for messages)
499 -- p_parameter_name IN VARCHAR2(30) Required
500 -- Name of the parameter in the calling API
501 -- (e.g. 'p_comment_id')
502 -- p_comment_id IN NUMBER Required
503 -- Comment ID
504 -- OUT : x_return_status OUT VARCHAR2(1)
505 -- FND_API.G_RET_STS_SUCCESS => comment is valid
506 -- FND_API.G_RET_STS_ERROR => comment is invalid
507 /**** bug 4887572 smisra
508 Removed this procedure
509 ------------------------------------------------------------------------------
510
511 PROCEDURE Validate_Comment
512 ( p_api_name IN VARCHAR2,
513 p_parameter_name IN VARCHAR2,
514 p_comment_id IN NUMBER,
515 x_return_status OUT NOCOPY VARCHAR2 );
516
517 ------------------------------------------------------------------------------
518 ****/
519 -- Procedure : Validate_Customer
520 -- Description : Verify that the given customer is valid and active.
521 -- Parameters :
522 -- IN : p_api_name IN VARCHAR2 Required
523 -- Name of the calling API (used for messages)
524 -- p_parameter_name IN VARCHAR2 Required
525 -- Name of the parameter in the calling API
526 -- (e.g. 'p_customer_id')
527 -- p_customer_id IN NUMBER
528 -- OUT : x_return_status OUT VARCHAR2(1)
529 -- FND_API.G_RET_STS_SUCCESS => customer is valid
530 -- FND_API.G_RET_STS_ERROR => customer is invalid
531 ------------------------------------------------------------------------------
532
533 PROCEDURE Validate_Customer
534 ( p_api_name IN VARCHAR2,
535 p_parameter_name IN VARCHAR2,
536 p_customer_id IN NUMBER,
537 x_return_status OUT NOCOPY VARCHAR2 );
538
539 ------------------------------------------------------------------------------
540 -- Procedure : Validate_Customer_Contact
541 -- Description : Verify that the customer contact is valid and active and
542 -- belongs to the given customer or a related customer.
543 -- Parameters :
544 -- IN : p_api_name IN VARCHAR2 Required
545 -- Name of the calling API (used for messages)
546 -- p_parameter_name IN VARCHAR2 Required
547 -- Name of the parameter in the calling API
548 -- (e.g. 'p_contact_id').
549 -- p_customer_contact_id IN NUMBER Required
550 -- ID of the customer contact.
551 -- p_customer_id IN NUMBER Required
552 -- ID of the service request customer.
553 -- p_org_id IN NUMBER Optional
554 -- Value of the organization ID.
555 -- OUT : x_return_status OUT VARCHAR2(1)
556 -- FND_API.G_RET_STS_SUCCESS => contact is valid
557 -- FND_API.G_RET_STS_ERROR => contact is invalid
558 ------------------------------------------------------------------------------
559
560 PROCEDURE Validate_Customer_Contact
561 ( p_api_name IN VARCHAR2,
562 p_parameter_name IN VARCHAR2,
563 p_customer_contact_id IN NUMBER,
564 p_customer_id IN NUMBER,
565 p_org_id IN NUMBER := NULL,
566 x_return_status OUT NOCOPY VARCHAR2 );
567
568 ------------------------------------------------------------------------------
569 -- Procedure : Validate_Desc_Flex
570 -- Description : Validate descriptive flexfield information. Verify that none
571 -- of the values are invalid, disabled, expired or not
572 -- available for the current user because of value security
573 -- rules.
574 -- Parameters :
575 -- IN : p_api_name IN VARCHAR2(30) Required
576 -- Name of the calling API (used for messages)
577 -- p_appl_short_name IN VARCHAR2(30) Optional
578 -- Application short name of the descriptive flexfield
579 -- p_desc_flex_name IN VARCHAR2(30) Required
580 -- Name of the descriptive flexfield
581 -- p_column_name1-15 IN VARCHAR2(30) Required
582 -- Names of the 15 descriptive flexfield columns
583 -- p_column_value1-15 IN VARCHAR2(150) Required
587 -- column
584 -- Values of the 15 descriptive flexfield segments
585 -- p_context_value IN VARCHAR2(30) Required
586 -- Value of the descriptive flexfield structure defining
588 -- p_resp_appl_id IN NUMBER Optional
589 -- Application identifier
590 -- p_resp_id IN NUMBER Optional
591 -- Responsibility identifier
592 -- OUT : x_return_status OUT VARCHAR2(1)
593 -- FND_API.G_RET_STS_SUCCESS => values are valid
594 -- FND_API.G_RET_STS_ERROR => values are invalid
595 ------------------------------------------------------------------------------
596
597 PROCEDURE Validate_Desc_Flex
598 ( p_api_name IN VARCHAR2,
599 p_appl_short_name IN VARCHAR2 DEFAULT 'CS',
600 p_desc_flex_name IN VARCHAR2,
601 p_column_name1 IN VARCHAR2,
602 p_column_name2 IN VARCHAR2,
603 p_column_name3 IN VARCHAR2,
604 p_column_name4 IN VARCHAR2,
605 p_column_name5 IN VARCHAR2,
606 p_column_name6 IN VARCHAR2,
607 p_column_name7 IN VARCHAR2,
608 p_column_name8 IN VARCHAR2,
609 p_column_name9 IN VARCHAR2,
610 p_column_name10 IN VARCHAR2,
611 p_column_name11 IN VARCHAR2,
612 p_column_name12 IN VARCHAR2,
613 p_column_name13 IN VARCHAR2,
614 p_column_name14 IN VARCHAR2,
615 p_column_name15 IN VARCHAR2,
616 p_column_value1 IN VARCHAR2,
617 p_column_value2 IN VARCHAR2,
618 p_column_value3 IN VARCHAR2,
619 p_column_value4 IN VARCHAR2,
620 p_column_value5 IN VARCHAR2,
621 p_column_value6 IN VARCHAR2,
622 p_column_value7 IN VARCHAR2,
623 p_column_value8 IN VARCHAR2,
624 p_column_value9 IN VARCHAR2,
625 p_column_value10 IN VARCHAR2,
626 p_column_value11 IN VARCHAR2,
627 p_column_value12 IN VARCHAR2,
628 p_column_value13 IN VARCHAR2,
629 p_column_value14 IN VARCHAR2,
630 p_column_value15 IN VARCHAR2,
631 p_context_value IN VARCHAR2,
632 p_resp_appl_id IN NUMBER := NULL,
633 p_resp_id IN NUMBER := NULL,
634 x_return_status OUT NOCOPY VARCHAR2 );
635 ------------------------------------------------------------------------------
636 -- Procedure : Validate_Price_Attribs
637 -- Description : Validate Pricing attrib information. Verify that none
638 -- of the values are invalid, disabled, expired or not
639 -- available for the current user because of value security
640 -- rules.
641 -- Parameters :
642 -- IN : p_api_name IN VARCHAR2(30) Required
643 -- Name of the calling API (used for messages)
644 -- p_appl_short_name IN VARCHAR2(30) Optional
645 -- Application short name of the pricing attributes
646 -- p_price_attrib_name IN VARCHAR2(30) Required
647 -- Name of the pricing attributes
648 -- p_column_name1-15 IN VARCHAR2(30) Required
649 -- Names of the 15 pricing attributes columns
650 -- p_column_value1-15 IN VARCHAR2(150) Required
651 -- Values of the 15 pricing attributes segments
652 -- p_context_value IN VARCHAR2(30) Required
653 -- Value of the pricing attributes structure defining
654 -- column
655 -- p_resp_appl_id IN NUMBER Optional
656 -- Application identifier
657 -- p_resp_id IN NUMBER Optional
658 -- Responsibility identifier
659 -- OUT : x_return_status OUT VARCHAR2(1)
660 -- FND_API.G_RET_STS_SUCCESS => values are valid
661 -- FND_API.G_RET_STS_ERROR => values are invalid
662 ------------------------------------------------------------------------------
663
664 PROCEDURE Validate_Price_Attribs
665 ( p_api_name IN VARCHAR2,
666 p_appl_short_name IN VARCHAR2 DEFAULT 'CS',
667 p_desc_flex_name IN VARCHAR2,
668 p_column_name1 IN VARCHAR2,
669 p_column_name2 IN VARCHAR2,
670 p_column_name3 IN VARCHAR2,
671 p_column_name4 IN VARCHAR2,
672 p_column_name5 IN VARCHAR2,
673 p_column_name6 IN VARCHAR2,
674 p_column_name7 IN VARCHAR2,
675 p_column_name8 IN VARCHAR2,
676 p_column_name9 IN VARCHAR2,
677 p_column_name10 IN VARCHAR2,
678 p_column_name11 IN VARCHAR2,
679 p_column_name12 IN VARCHAR2,
680 p_column_name13 IN VARCHAR2,
681 p_column_name14 IN VARCHAR2,
682 p_column_name15 IN VARCHAR2,
683 p_column_name16 IN VARCHAR2,
684 p_column_name17 IN VARCHAR2,
685 p_column_name18 IN VARCHAR2,
686 p_column_name19 IN VARCHAR2,
687 p_column_name20 IN VARCHAR2,
688 p_column_name21 IN VARCHAR2,
689 p_column_name22 IN VARCHAR2,
690 p_column_name23 IN VARCHAR2,
691 p_column_name24 IN VARCHAR2,
692 p_column_name25 IN VARCHAR2,
696 p_column_name29 IN VARCHAR2,
693 p_column_name26 IN VARCHAR2,
694 p_column_name27 IN VARCHAR2,
695 p_column_name28 IN VARCHAR2,
697 p_column_name30 IN VARCHAR2,
698 p_column_name31 IN VARCHAR2,
699 p_column_name32 IN VARCHAR2,
700 p_column_name33 IN VARCHAR2,
701 p_column_name34 IN VARCHAR2,
702 p_column_name35 IN VARCHAR2,
703 p_column_name36 IN VARCHAR2,
704 p_column_name37 IN VARCHAR2,
705 p_column_name38 IN VARCHAR2,
706 p_column_name39 IN VARCHAR2,
707 p_column_name40 IN VARCHAR2,
708 p_column_name41 IN VARCHAR2,
709 p_column_name42 IN VARCHAR2,
710 p_column_name43 IN VARCHAR2,
711 p_column_name44 IN VARCHAR2,
712 p_column_name45 IN VARCHAR2,
713 p_column_name46 IN VARCHAR2,
714 p_column_name47 IN VARCHAR2,
715 p_column_name48 IN VARCHAR2,
716 p_column_name49 IN VARCHAR2,
717 p_column_name50 IN VARCHAR2,
718 p_column_name51 IN VARCHAR2,
719 p_column_name52 IN VARCHAR2,
720 p_column_name53 IN VARCHAR2,
721 p_column_name54 IN VARCHAR2,
722 p_column_name55 IN VARCHAR2,
723 p_column_name56 IN VARCHAR2,
724 p_column_name57 IN VARCHAR2,
725 p_column_name58 IN VARCHAR2,
726 p_column_name59 IN VARCHAR2,
727 p_column_name60 IN VARCHAR2,
728 p_column_name61 IN VARCHAR2,
729 p_column_name62 IN VARCHAR2,
730 p_column_name63 IN VARCHAR2,
731 p_column_name64 IN VARCHAR2,
732 p_column_name65 IN VARCHAR2,
733 p_column_name66 IN VARCHAR2,
734 p_column_name67 IN VARCHAR2,
735 p_column_name68 IN VARCHAR2,
736 p_column_name69 IN VARCHAR2,
737 p_column_name70 IN VARCHAR2,
738 p_column_name71 IN VARCHAR2,
739 p_column_name72 IN VARCHAR2,
740 p_column_name73 IN VARCHAR2,
741 p_column_name74 IN VARCHAR2,
742 p_column_name75 IN VARCHAR2,
743 p_column_name76 IN VARCHAR2,
744 p_column_name77 IN VARCHAR2,
745 p_column_name78 IN VARCHAR2,
746 p_column_name79 IN VARCHAR2,
747 p_column_name80 IN VARCHAR2,
748 p_column_name81 IN VARCHAR2,
749 p_column_name82 IN VARCHAR2,
750 p_column_name83 IN VARCHAR2,
751 p_column_name84 IN VARCHAR2,
752 p_column_name85 IN VARCHAR2,
753 p_column_name86 IN VARCHAR2,
754 p_column_name87 IN VARCHAR2,
755 p_column_name88 IN VARCHAR2,
756 p_column_name89 IN VARCHAR2,
757 p_column_name90 IN VARCHAR2,
758 p_column_name91 IN VARCHAR2,
759 p_column_name92 IN VARCHAR2,
760 p_column_name93 IN VARCHAR2,
761 p_column_name94 IN VARCHAR2,
762 p_column_name95 IN VARCHAR2,
763 p_column_name96 IN VARCHAR2,
764 p_column_name97 IN VARCHAR2,
765 p_column_name98 IN VARCHAR2,
766 p_column_name99 IN VARCHAR2,
767 p_column_name100 IN VARCHAR2,
768 p_column_value1 IN VARCHAR2,
769 p_column_value2 IN VARCHAR2,
770 p_column_value3 IN VARCHAR2,
771 p_column_value4 IN VARCHAR2,
772 p_column_value5 IN VARCHAR2,
773 p_column_value6 IN VARCHAR2,
774 p_column_value7 IN VARCHAR2,
775 p_column_value8 IN VARCHAR2,
776 p_column_value9 IN VARCHAR2,
777 p_column_value10 IN VARCHAR2,
778 p_column_value11 IN VARCHAR2,
779 p_column_value12 IN VARCHAR2,
780 p_column_value13 IN VARCHAR2,
781 p_column_value14 IN VARCHAR2,
782 p_column_value15 IN VARCHAR2,
783 p_column_value16 IN VARCHAR2,
784 p_column_value17 IN VARCHAR2,
785 p_column_value18 IN VARCHAR2,
789 p_column_value22 IN VARCHAR2,
786 p_column_value19 IN VARCHAR2,
787 p_column_value20 IN VARCHAR2,
788 p_column_value21 IN VARCHAR2,
790 p_column_value23 IN VARCHAR2,
791 p_column_value24 IN VARCHAR2,
792 p_column_value25 IN VARCHAR2,
793 p_column_value26 IN VARCHAR2,
794 p_column_value27 IN VARCHAR2,
795 p_column_value28 IN VARCHAR2,
796 p_column_value29 IN VARCHAR2,
797 p_column_value30 IN VARCHAR2,
798 p_column_value31 IN VARCHAR2,
799 p_column_value32 IN VARCHAR2,
800 p_column_value33 IN VARCHAR2,
801 p_column_value34 IN VARCHAR2,
802 p_column_value35 IN VARCHAR2,
803 p_column_value36 IN VARCHAR2,
804 p_column_value37 IN VARCHAR2,
805 p_column_value38 IN VARCHAR2,
806 p_column_value39 IN VARCHAR2,
807 p_column_value40 IN VARCHAR2,
808 p_column_value41 IN VARCHAR2,
809 p_column_value42 IN VARCHAR2,
810 p_column_value43 IN VARCHAR2,
811 p_column_value44 IN VARCHAR2,
812 p_column_value45 IN VARCHAR2,
813 p_column_value46 IN VARCHAR2,
814 p_column_value47 IN VARCHAR2,
815 p_column_value48 IN VARCHAR2,
816 p_column_value49 IN VARCHAR2,
817 p_column_value50 IN VARCHAR2,
818 p_column_value51 IN VARCHAR2,
819 p_column_value52 IN VARCHAR2,
820 p_column_value53 IN VARCHAR2,
821 p_column_value54 IN VARCHAR2,
822 p_column_value55 IN VARCHAR2,
823 p_column_value56 IN VARCHAR2,
824 p_column_value57 IN VARCHAR2,
825 p_column_value58 IN VARCHAR2,
826 p_column_value59 IN VARCHAR2,
827 p_column_value60 IN VARCHAR2,
828 p_column_value61 IN VARCHAR2,
829 p_column_value62 IN VARCHAR2,
830 p_column_value63 IN VARCHAR2,
831 p_column_value64 IN VARCHAR2,
832 p_column_value65 IN VARCHAR2,
833 p_column_value66 IN VARCHAR2,
834 p_column_value67 IN VARCHAR2,
835 p_column_value68 IN VARCHAR2,
836 p_column_value69 IN VARCHAR2,
837 p_column_value70 IN VARCHAR2,
838 p_column_value71 IN VARCHAR2,
839 p_column_value72 IN VARCHAR2,
840 p_column_value73 IN VARCHAR2,
841 p_column_value74 IN VARCHAR2,
842 p_column_value75 IN VARCHAR2,
843 p_column_value76 IN VARCHAR2,
844 p_column_value77 IN VARCHAR2,
845 p_column_value78 IN VARCHAR2,
846 p_column_value79 IN VARCHAR2,
847 p_column_value80 IN VARCHAR2,
848 p_column_value81 IN VARCHAR2,
849 p_column_value82 IN VARCHAR2,
850 p_column_value83 IN VARCHAR2,
851 p_column_value84 IN VARCHAR2,
852 p_column_value85 IN VARCHAR2,
853 p_column_value86 IN VARCHAR2,
854 p_column_value87 IN VARCHAR2,
855 p_column_value88 IN VARCHAR2,
856 p_column_value89 IN VARCHAR2,
857 p_column_value90 IN VARCHAR2,
858 p_column_value91 IN VARCHAR2,
859 p_column_value92 IN VARCHAR2,
860 p_column_value93 IN VARCHAR2,
861 p_column_value94 IN VARCHAR2,
862 p_column_value95 IN VARCHAR2,
863 p_column_value96 IN VARCHAR2,
864 p_column_value97 IN VARCHAR2,
865 p_column_value98 IN VARCHAR2,
866 p_column_value99 IN VARCHAR2,
867 p_column_value100 IN VARCHAR2,
868 p_context_value IN VARCHAR2,
869 p_resp_appl_id IN NUMBER := NULL,
870 p_resp_id IN NUMBER := NULL,
871 x_return_status OUT NOCOPY VARCHAR2 );
872
873 ------------------------------------------------------------------------------
874 -- Procedure : Validate_Employee
875 -- Description : Verify that the employee ID is a valid and active employee
876 -- assigned to the Oracle Personnel business group ID stored in
877 -- FINANCIALS_SYSTEM_PARAMETERS.
878 -- Parameters :
879 -- IN : p_api_name IN VARCHAR2 Required
880 -- Name of the calling API (used for messages)
881 -- p_parameter_name IN VARCHAR2 Required
882 -- Name of the parameter in the calling API
883 -- p_employee_id IN NUMBER Required
884 -- p_org_id IN NUMBER Optional
885 -- If Multi-Org is enabled, this value cannot be null;
886 -- otherwise this validation routine will fail.
887 -- OUT : x_return_status OUT VARCHAR2(1)
888 -- FND_API.G_RET_STS_SUCCESS => employee is valid
889 -- FND_API.G_RET_STS_ERROR => employee is invalid
890 ------------------------------------------------------------------------------
891
892 PROCEDURE Validate_Employee
896 p_org_id IN NUMBER := NULL,
893 ( p_api_name IN VARCHAR2,
894 p_parameter_name IN VARCHAR2,
895 p_employee_id IN NUMBER,
897 x_return_status OUT NOCOPY VARCHAR2 );
898
899 ------------------------------------------------------------------------------
900 -- Procedure : Validate_Later_Date
901 -- Description : Verify that the later date is later than the earlier date.
902 -- Parameters :
903 -- IN : p_api_name IN VARCHAR2 Required
904 -- Name of the calling API (used for messages)
905 -- p_parameter_name IN VARCHAR2 Required
906 -- Name of the parameter in the calling API
907 -- p_later_date IN DATE Required
908 -- p_earlier_date IN DATE Required
909 -- OUT : x_return_status OUT VARCHAR2(1)
910 -- FND_API.G_RET_STS_SUCCESS => date is valid
911 -- FND_API.G_RET_STS_ERROR => date is invalid
912 ------------------------------------------------------------------------------
913
914 PROCEDURE Validate_Later_Date
915 ( p_api_name IN VARCHAR2,
916 p_parameter_name IN VARCHAR2,
917 p_later_date IN DATE,
918 p_earlier_date IN DATE,
919 x_return_status OUT NOCOPY VARCHAR2 );
920
921 ------------------------------------------------------------------------------
922 -- Procedure : Validate_Lookup_Code
923 -- Description : Validate that the lookup code is valid, enabled and active.
924 -- Parameters :
925 -- IN : p_api_name IN VARCHAR2 Required
926 -- Name of the calling API (used for messages)
927 -- p_parameter_name IN VARCHAR2 Required
928 -- Name of the parameter in the calling API
929 -- p_lookup_code IN VARCHAR2 Required
930 -- Lookup code to be validated
931 -- p_lookup_type IN VARCHAR2 Required
932 -- Type of the lookup code
933 -- OUT : x_return_status OUT VARCHAR2(1)
934 -- FND_API.G_RET_STS_SUCCESS => code is valid
935 -- FND_API.G_RET_STS_ERROR => code is invalid
936 ------------------------------------------------------------------------------
937
938 PROCEDURE Validate_Lookup_Code
939 ( p_api_name IN VARCHAR2,
940 p_parameter_name IN VARCHAR2,
941 p_lookup_code IN VARCHAR2,
942 p_lookup_type IN VARCHAR2,
943 x_return_status OUT NOCOPY VARCHAR2 );
944
945 ------------------------------------------------------------------------------
946 -- Function : Validate_Operating_Unit
947 -- Description : Validate that the org ID identifies a valid operating unit
948 -- Parameters :
949 -- IN : p_api_name IN VARCHAR2(30) Required
950 -- Name of the calling API (used for messages)
951 -- p_parameter_name IN VARCHAR2(30) Required
952 -- Name of the parameter in the calling API
953 -- (e.g. 'p_org_id')
954 -- p_org_id IN NUMBER Required
955 -- Operating Unit ID
956 -- OUT : x_return_status OUT VARCHAR2(1)
957 -- FND_API.G_RET_STS_SUCCESS => org ID is valid
958 -- FND_API.G_RET_STS_ERROR => org ID is invalid
959 ------------------------------------------------------------------------------
960
961 PROCEDURE Validate_Operating_Unit
962 ( p_api_name IN VARCHAR2,
963 p_parameter_name IN VARCHAR2,
964 p_org_id IN NUMBER,
965 x_return_status OUT NOCOPY VARCHAR2 );
966
967 ------------------------------------------------------------------------------
968 -- Function : Validate_Person
969 -- Description : Validate that the given person is a valid and active
970 -- employee assigned to any business group.
971 -- Parameters :
972 -- IN : p_api_name IN VARCHAR2(30) Required
973 -- Name of the calling API (used for messages)
974 -- p_parameter_name IN VARCHAR2(30) Required
975 -- Name of the parameter in the calling API
976 -- (e.g. 'p_person_id')
977 -- p_person_id IN NUMBER Required
978 -- Person ID
979 -- OUT : x_return_status OUT VARCHAR2(1)
980 -- FND_API.G_RET_STS_SUCCESS => person is valid
981 -- FND_API.G_RET_STS_ERROR => person is invalid
982 ------------------------------------------------------------------------------
983
984 PROCEDURE Validate_Person
985 ( p_api_name IN VARCHAR2,
986 p_parameter_name IN VARCHAR2,
987 p_person_id IN NUMBER,
988 x_return_status OUT NOCOPY VARCHAR2 );
989
990 ------------------------------------------------------------------------------
991 -- Procedure : Validate_Ship_To_Site
992 -- Description : Verify that the given site is a valid shipping site within
993 -- the given operating unit, and it belongs to the given
994 -- customer or a related customer.
998 -- p_parameter_name IN VARCHAR2 Required
995 -- Parameters :
996 -- IN : p_api_name IN VARCHAR2 Required
997 -- Name of the calling API (used for messages)
999 -- Name of the parameter in the calling API
1000 -- (e.g. 'p_ship_to_site_use_id').
1001 -- p_ship_to_site_use_id IN NUMBER Required
1002 -- Location ID of the customer site.
1003 -- p_customer_id IN NUMBER Required
1004 -- ID of the service request customer.
1005 -- p_org_id IN NUMBER Optional
1006 -- Value of the organization ID.
1007 -- OUT : x_ship_to_customer_id OUT NUMBER
1008 -- x_return_status OUT VARCHAR2(1)
1009 -- FND_API.G_RET_STS_SUCCESS => site is valid
1010 -- FND_API.G_RET_STS_ERROR => site is invalid
1011 ------------------------------------------------------------------------------
1012
1013 PROCEDURE Validate_Ship_To_Site
1014 ( p_api_name IN VARCHAR2,
1015 p_parameter_name IN VARCHAR2,
1016 p_ship_to_site_use_id IN NUMBER,
1017 p_customer_id IN NUMBER,
1018 p_org_id IN NUMBER := NULL,
1019 x_ship_to_customer_id OUT NOCOPY NUMBER,
1020 x_return_status OUT NOCOPY VARCHAR2 );
1021
1022 -------------------------------------------------------------------------------
1023 -- Procedure : Validate_Source_Object_ID
1024 -- Description : Validate that the given source object ID identifies a valid
1025 -- record for the given source object type.
1026 -- Parameters :
1027 -- IN : p_api_name IN VARCHAR2(30) Required
1028 -- Name of the calling API (used for messages)
1029 -- p_parameter_name IN VARCHAR2(30) Required
1030 -- Name of the parameter in the calling API
1031 -- (e.g. 'p_source_object_id')
1032 -- p_source_object_id IN NUMBER Required
1033 -- Source object identifier
1034 -- p_source_object_code IN VARCHAR2(30) Required
1035 -- Lookup code for the source object type
1036 -- p_org_id IN NUMBER Optional
1037 -- Value of the organization ID.
1038 -- OUT : x_return_status OUT VARCHAR2(1)
1039 -- FND_API.G_RET_STS_SUCCESS => comment is valid
1040 -- FND_API.G_RET_STS_ERROR => comment is invalid
1041 -------------------------------------------------------------------------------
1042
1043 PROCEDURE Validate_Source_Object_ID
1044 ( p_api_name IN VARCHAR2,
1045 p_parameter_name IN VARCHAR2,
1046 p_source_object_id IN NUMBER,
1047 p_source_object_code IN VARCHAR2 := 'INC',
1048 p_org_id IN NUMBER := NULL,
1049 x_return_status OUT NOCOPY VARCHAR2 );
1050
1051 ------------------------------------------------------------------------------
1052 -- Procedure : Validate_Who_Info
1053 -- Description : Verify that the user and login session are valid and active
1054 -- Parameters :
1055 -- IN : p_api_name IN VARCHAR2 Required
1056 -- Name of the calling API (used for messages)
1057 -- p_parameter_name_usr IN VARCHAR2 Required
1058 -- Name of the user id parameter in the calling API
1059 -- (e.g. 'p_user_id')
1060 -- p_parameter_name_log IN VARCHAR2 Required
1061 -- Name of the login id parameter in the calling API
1062 -- (e.g. 'p_login_id')
1063 -- p_user_id IN NUMBER
1064 -- p_login_id IN NUMBER
1065 -- p_resp_id IN NUMBER Optional
1066 -- p_resp_appl_id IN NUMBER Optional
1067 -- OUT : x_return_status OUT VARCHAR2(1)
1068 -- FND_API.G_RET_STS_SUCCESS => IDs are valid
1069 -- FND_API.G_RET_STS_ERROR => IDs are invalid
1070 ------------------------------------------------------------------------------
1071
1072 PROCEDURE Validate_Who_Info
1073 ( p_api_name IN VARCHAR2,
1074 p_parameter_name_usr IN VARCHAR2,
1075 p_parameter_name_log IN VARCHAR2,
1076 p_user_id IN NUMBER,
1077 p_login_id IN NUMBER,
1078 p_resp_id IN NUMBER := NULL,
1079 p_resp_appl_id IN NUMBER := NULL,
1080 x_return_status OUT NOCOPY VARCHAR2 );
1081
1082 PROCEDURE Is_DescFlex_Valid
1083 (
1084 p_api_name IN VARCHAR2,
1085 p_appl_short_name IN VARCHAR2 DEFAULT 'CS',
1086 p_desc_flex_name IN VARCHAR2,
1087 p_seg_partial_name IN VARCHAR2,
1088 p_num_of_attributes IN NUMBER,
1089 p_seg_values IN DFF_Rec_Type,
1090 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
1091 );
1092
1093 PROCEDURE Is_PriceAttribs_Valid
1094 (
1095 p_api_name IN VARCHAR2,
1099 p_seg_values IN PRICE_ATT_Rec_Type,
1096 p_appl_short_name IN VARCHAR2 DEFAULT 'CS',
1097 p_price_attrib_name IN VARCHAR2,
1098 p_seg_partial_name IN VARCHAR2,
1100 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
1101 );
1102 ------------------------------------------------------------------------------
1103 -- Function : get_g_false
1104 -- Description : Used as a wrapper function to get FND_API.G_FALSE.
1105 -- Parameters :
1106 -- IN : None
1107 -- OUT : None
1108 -- RETURN : FND_API.G_FALSE VARCHAR2
1109 ------------------------------------------------------------------------------
1110
1111 FUNCTION get_g_false return varchar2;
1112
1113 ------------------------------------------------------------------------------
1114 -- Function : get_g_true
1115 -- Description : Used as a wrapper function to get FND_API.G_TRUE.
1116 -- Parameters :
1117 -- IN : None
1118 -- OUT : None
1119 -- RETURN : FND_API.G_TRUE VARCHAR2
1120 ------------------------------------------------------------------------------
1121
1122 FUNCTION get_g_true return varchar2;
1123
1124 ------------------------------------------------------------------------------
1125 -- Function : get_g_valid_level_full
1126 -- Description : Used as a wrapper function to get FND_API.G_VALID_LEVEL_FULL.
1127 -- Parameters :
1128 -- IN : None
1129 -- OUT : None
1130 -- RETURN : FND_API.G_VALID_LEVEL_FULL VARCHAR2
1131 ------------------------------------------------------------------------------
1132
1133 FUNCTION get_g_valid_level_full return varchar2;
1134
1135 ------------------------------------------------------------------------------
1136 -- Function : get_g_miss_num
1137 -- Description : Used as a wrapper function to get FND_API.G_MISS_NUM.
1138 -- Parameters :
1139 -- IN : None
1140 -- OUT : None
1141 -- RETURN : FND_API.G_MISS_NUM NUMBER
1142 ------------------------------------------------------------------------------
1143
1144 FUNCTION get_g_miss_num return number;
1145
1146 ------------------------------------------------------------------------------
1147 -- Function : get_g_miss_char
1148 -- Description : Used as a wrapper function to get FND_API.G_MISS_CHAR.
1149 -- Parameters :
1150 -- IN : None
1151 -- OUT : None
1152 -- RETURN : FND_API.G_MISS_CHAR VARCHAR2
1153 ------------------------------------------------------------------------------
1154
1155 FUNCTION get_g_miss_char return varchar2;
1156
1157 ------------------------------------------------------------------------------
1158 -- Function : get_g_MISS_DATE
1159 -- Description : Used as a wrapper function to get FND_API.G_MISS_DATE.
1160 -- Parameters :
1161 -- IN : None
1162 -- OUT : None
1163 -- RETURN : FND_API.G_MISS_DATE DATE
1164 ------------------------------------------------------------------------------
1165
1166 FUNCTION get_g_miss_date return date;
1167
1168 ---------------------------- End of Code -----------------------------
1169
1170 END CS_CORE_UTIL;