1 package AK_KEY_PVT as
2 /* $Header: akdvkeys.pls 120.2 2005/09/15 22:26:54 tshort ship $ */
3
4 -- Global constants holding the package and file names to be used by
5 -- messaging routines in the case of an unexpected error.
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AK_KEY_PVT';
8
9 -- Procedure specs
10
11 --=======================================================
12 -- Procedure CREATE_FOREIGN_KEY
13 --
14 -- Usage Private API for creating a foreign key. This
15 -- API should only be called by other APIs that are
16 -- owned by the Core Modules Team (AK).
17 --
18 -- Desc Creates a foreign key using the given info. This
19 -- API should only be called by other APIs that are
20 -- owned by the Core Modules Team (AK).
21 --
22 -- Results The API returns the standard p_return_status parameter
23 -- indicating one of the standard return statuses :
24 -- * Unexpected error
25 -- * Error
26 -- * Success
27 -- Parameters Foreign Key columns
28 -- p_loader_timestamp : IN optional
29 -- If a timestamp is passed, the API will create the
30 -- record using this timestamp. Only the upload API
31 -- should call with this parameter loaded.
32 --
33 -- Version Initial version number = 1.0
34 -- History Current version number = 1.0
35 --=======================================================
36 procedure CREATE_FOREIGN_KEY (
37 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38 p_api_version_number IN NUMBER,
39 p_init_msg_tbl IN BOOLEAN := FALSE,
40 p_msg_count OUT NOCOPY NUMBER,
41 p_msg_data OUT NOCOPY VARCHAR2,
42 p_return_status OUT NOCOPY VARCHAR2,
43 p_foreign_key_name IN VARCHAR2,
44 p_database_object_name IN VARCHAR2,
45 p_unique_key_name IN VARCHAR2,
46 p_application_id IN NUMBER,
47 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
48 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63 p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
64 p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65 p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
66 p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
67 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
68 p_creation_date IN DATE := FND_API.G_MISS_DATE,
69 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
70 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
71 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
72 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
73 p_pass IN NUMBER,
74 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
75
76 );
77
78 --=======================================================
79 -- Procedure CREATE_FOREIGN_KEY_COLUMN
80 --
81 -- Usage Private API for creating a foreign key column record.
82 -- This API should only be called by other APIs that are
83 -- owned by the Core Modules Team (AK).
84 --
85 -- Desc Creates a foreign key column record using the given info.
86 -- This API should only be called by other APIs that are
87 -- owned by the Core Modules Team (AK).
88 --
89 -- Results The API returns the standard p_return_status parameter
90 -- indicating one of the standard return statuses :
91 -- * Unexpected error
92 -- * Error
93 -- * Success
94 -- Parameters Foreign Key Column columns
95 -- p_loader_timestamp : IN optional
96 -- If a timestamp is passed, the API will create the
97 -- record using this timestamp. Only the upload API
98 -- should call with this parameter loaded.
99 --
100 -- Version Initial version number = 1.0
101 -- History Current version number = 1.0
102 --=======================================================
103 procedure CREATE_FOREIGN_KEY_COLUMN (
104 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105 p_api_version_number IN NUMBER,
106 p_init_msg_tbl IN BOOLEAN := FALSE,
107 p_msg_count OUT NOCOPY NUMBER,
108 p_msg_data OUT NOCOPY VARCHAR2,
109 p_return_status OUT NOCOPY VARCHAR2,
110 p_foreign_key_name IN VARCHAR2,
111 p_attribute_application_id IN NUMBER,
112 p_attribute_code IN VARCHAR2,
113 p_foreign_key_sequence IN NUMBER,
114 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
115 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
131 p_creation_date IN DATE := FND_API.G_MISS_DATE,
132 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
133 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
134 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
135 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
136 p_pass IN NUMBER,
137 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
138 );
139
140 --=======================================================
141 -- Procedure CREATE_UNIQUE_KEY
142 --
143 -- Usage Private API for creating a unique key. This
144 -- API should only be called by other APIs that are
145 -- owned by the Core Modules Team (AK).
146 --
147 -- Desc Creates a unique key using the given info. This
148 -- API should only be called by other APIs that are
149 -- owned by the Core Modules Team (AK).
150 --
151 -- Results The API returns the standard p_return_status parameter
152 -- indicating one of the standard return statuses :
153 -- * Unexpected error
154 -- * Error
155 -- * Success
156 -- Parameters Unique Key columns
157 -- p_loader_timestamp : IN optional
158 -- If a timestamp is passed, the API will create the
159 -- record using this timestamp. Only the upload API
160 -- should call with this parameter loaded.
161 --
162 -- Version Initial version number = 1.0
163 -- History Current version number = 1.0
164 --=======================================================
165 procedure CREATE_UNIQUE_KEY (
166 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167 p_api_version_number IN NUMBER,
168 p_init_msg_tbl IN BOOLEAN := FALSE,
169 p_msg_count OUT NOCOPY NUMBER,
170 p_msg_data OUT NOCOPY VARCHAR2,
171 p_return_status OUT NOCOPY VARCHAR2,
172 p_unique_key_name IN VARCHAR2,
173 p_database_object_name IN VARCHAR2,
174 p_application_id IN NUMBER,
175 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
176 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
177 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
178 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
179 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
180 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
192 p_creation_date IN DATE := FND_API.G_MISS_DATE,
193 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
194 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
195 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
196 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
197 p_pass IN NUMBER,
198 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
199 );
200
201 --=======================================================
202 -- Procedure CREATE_UNIQUE_KEY_COLUMN
203 --
204 -- Usage Private API for creating a unique key column record.
205 -- This API should only be called by other APIs that are
206 -- owned by the Core Modules Team (AK).
207 --
208 -- Desc Creates a unique key column record using the given info.
209 -- This API should only be called by other APIs that are
210 -- owned by the Core Modules Team (AK).
211 --
212 -- Results The API returns the standard p_return_status parameter
213 -- indicating one of the standard return statuses :
214 -- * Unexpected error
215 -- * Error
216 -- * Success
217 -- Parameters Unique Key Column columns
218 -- p_loader_timestamp : IN optional
219 -- If a timestamp is passed, the API will create the
220 -- record using this timestamp. Only the upload API
221 -- should call with this parameter loaded.
222 --
223 -- Version Initial version number = 1.0
224 -- History Current version number = 1.0
225 --=======================================================
226 procedure CREATE_UNIQUE_KEY_COLUMN (
227 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228 p_api_version_number IN NUMBER,
229 p_init_msg_tbl IN BOOLEAN := FALSE,
230 p_msg_count OUT NOCOPY NUMBER,
231 p_msg_data OUT NOCOPY VARCHAR2,
232 p_return_status OUT NOCOPY VARCHAR2,
233 p_unique_key_name IN VARCHAR2,
234 p_attribute_application_id IN NUMBER,
235 p_attribute_code IN VARCHAR2,
236 p_unique_key_sequence IN NUMBER,
237 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
238 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
239 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
240 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
241 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
242 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
243 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
244 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
245 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
246 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
247 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
248 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
249 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
250 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
251 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
252 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
253 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
254 p_creation_date IN DATE := FND_API.G_MISS_DATE,
255 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
256 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
257 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
258 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
259 p_pass IN NUMBER,
260 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
261 );
262
263 --=======================================================
264 -- Procedure DELETE_FOREIGN_KEY
265 --
266 -- Usage Private API for deleting a foreign key. This
267 -- API should only be called by other APIs that are
268 -- owned by the Core Modules Team (AK).
269 --
270 -- Desc Deletes a foreign key with the given key value.
271 --
272 -- Results The API returns the standard p_return_status parameter
273 -- indicating one of the standard return statuses :
274 -- * Unexpected error
275 -- * Error
276 -- * Success
277 -- Parameters p_foreign_key_name : IN required
278 -- The name of the foreign key to be deleted.
279 -- p_delete_cascade : IN required
280 -- If p_delete_cascade flag is 'Y', also delete all
281 -- rows in other tables that references this record.
282 -- Otherwise, this record will not be deleted if there
283 -- are any other rows referencing it.
284 --
285 -- Version Initial version number = 1.0
286 -- History Current version number = 1.0
287 --=======================================================
288 procedure DELETE_FOREIGN_KEY (
289 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
290 p_api_version_number IN NUMBER,
291 p_init_msg_tbl IN BOOLEAN := FALSE,
292 p_msg_count OUT NOCOPY NUMBER,
293 p_msg_data OUT NOCOPY VARCHAR2,
294 p_return_status OUT NOCOPY VARCHAR2,
295 p_foreign_key_name IN VARCHAR2,
296 p_delete_cascade IN VARCHAR2
297 );
298
299 --=======================================================
300 -- Procedure DELETE_FOREIGN_KEY_COLUMN
301 --
302 -- Usage Private API for deleting a foreign key column record.
303 -- This API should only be called by other APIs that are
304 -- owned by the Core Modules Team (AK).
305 --
306 -- Desc Deletes a foreign key column record with the given key value.
307 --
308 -- Results The API returns the standard p_return_status parameter
309 -- indicating one of the standard return statuses :
310 -- * Unexpected error
311 -- * Error
312 -- * Success
313 -- Parameters p_foreign_key_name : IN required
317 -- p_delete_cascade : IN required
314 -- p_attribute_application_id : IN required
315 -- p_attribute_code : IN required
316 -- The key of the foreign key column record to be deleted.
318 -- If p_delete_cascade flag is 'Y', also delete all
319 -- rows in other tables that references this record.
320 -- Otherwise, this record will not be deleted if there
321 -- are any other rows referencing it.
322 --
323 -- Version Initial version number = 1.0
324 -- History Current version number = 1.0
325 --=======================================================
326 procedure DELETE_FOREIGN_KEY_COLUMN (
327 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
328 p_api_version_number IN NUMBER,
329 p_init_msg_tbl IN BOOLEAN := FALSE,
330 p_msg_count OUT NOCOPY NUMBER,
331 p_msg_data OUT NOCOPY VARCHAR2,
332 p_return_status OUT NOCOPY VARCHAR2,
333 p_foreign_key_name IN VARCHAR2,
334 p_attribute_application_id IN NUMBER,
335 p_attribute_code IN VARCHAR2,
336 p_delete_cascade IN VARCHAR2
337 );
338
339 --=======================================================
340 -- Procedure DELETE_UNIQUE_KEY
341 --
342 -- Usage Private API for deleting a unique key. This
343 -- API should only be called by other APIs that are
344 -- owned by the Core Modules Team (AK).
345 --
346 -- Desc Deletes a unique key with the given key value.
347 --
348 -- Results The API returns the standard p_return_status parameter
349 -- indicating one of the standard return statuses :
350 -- * Unexpected error
351 -- * Error
352 -- * Success
353 -- Parameters p_unique_key_name : IN required
354 -- The name of the unique key to be deleted.
355 -- p_delete_cascade : IN required
356 -- If p_delete_cascade flag is 'Y', also delete all
357 -- rows in other tables that references this record.
358 -- Otherwise, this record will not be deleted if there
359 -- are any other rows referencing it.
360 --
361 -- Version Initial version number = 1.0
362 -- History Current version number = 1.0
363 --=======================================================
364 procedure DELETE_UNIQUE_KEY (
365 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366 p_api_version_number IN NUMBER,
367 p_init_msg_tbl IN BOOLEAN := FALSE,
368 p_msg_count OUT NOCOPY NUMBER,
369 p_msg_data OUT NOCOPY VARCHAR2,
370 p_return_status OUT NOCOPY VARCHAR2,
371 p_unique_key_name IN VARCHAR2,
372 p_delete_cascade IN VARCHAR2
373 );
374
375 --=======================================================
376 -- Procedure DELETE_UNIQUE_KEY_COLUMN
377 --
378 -- Usage Private API for deleting a unique key column record.
379 -- This API should only be called by other APIs that are
380 -- owned by the Core Modules Team (AK).
381 --
382 -- Desc Deletes a unique key column record with the given key value.
383 --
384 -- Results The API returns the standard p_return_status parameter
385 -- indicating one of the standard return statuses :
386 -- * Unexpected error
387 -- * Error
388 -- * Success
389 -- Parameters p_unique_key_name : IN required
390 -- p_attribute_application_id : IN required
391 -- p_attribute_code : IN required
392 -- The key of the unique key column record to be deleted.
393 -- p_delete_cascade : IN required
394 -- If p_delete_cascade flag is 'Y', also delete all
395 -- rows in other tables that references this record.
396 -- Otherwise, this record will not be deleted if there
397 -- are any other rows referencing it.
398 --
399 -- Version Initial version number = 1.0
400 -- History Current version number = 1.0
401 --=======================================================
402 procedure DELETE_UNIQUE_KEY_COLUMN (
403 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
404 p_api_version_number IN NUMBER,
405 p_init_msg_tbl IN BOOLEAN := FALSE,
406 p_msg_count OUT NOCOPY NUMBER,
407 p_msg_data OUT NOCOPY VARCHAR2,
408 p_return_status OUT NOCOPY VARCHAR2,
409 p_unique_key_name IN VARCHAR2,
410 p_attribute_application_id IN NUMBER,
411 p_attribute_code IN VARCHAR2,
412 p_delete_cascade IN VARCHAR2,
413 p_override IN VARCHAR2 := 'N'
414 );
415
416 --=======================================================
417 -- Function FOREIGN_KEY_EXISTS
418 --
419 -- Usage Private API for checking for the existence of
420 -- a foreign key with the given key values. This
421 -- API should only be called by other APIs that are
422 -- owned by the Core Modules Team (AK).
423 --
424 -- Desc This API check to see if a foreign key record
425 -- exists with the given key values.
426 --
430 -- * Error
427 -- Results The API returns the standard p_return_status parameter
428 -- indicating one of the standard return statuses :
429 -- * Unexpected error
431 -- * Success
432 -- This function will return TRUE if such a foreign key
433 -- exists, or FALSE otherwise.
434 -- Parameters Foreign Key key columns
435 --
436 -- Version Initial version number = 1.0
437 -- History Current version number = 1.0
438 --=======================================================
439 function FOREIGN_KEY_EXISTS (
440 p_api_version_number IN NUMBER,
441 p_return_status OUT NOCOPY VARCHAR2,
442 p_foreign_key_name IN VARCHAR2
443 ) return BOOLEAN;
444
445 --=======================================================
446 -- Function FOREIGN_KEY_COLUMN_EXISTS
447 --
448 -- Usage Private API for checking for the existence of
449 -- a foreign key column record with the given key values.
450 -- This API should only be called by other APIs that are
451 -- owned by the Core Modules Team (AK).
452 --
453 -- Desc This API check to see if a foreign key column record
454 -- exists with the given key values.
455 --
456 -- Results The API returns the standard p_return_status parameter
457 -- indicating one of the standard return statuses :
458 -- * Unexpected error
459 -- * Error
460 -- * Success
461 -- This function will return TRUE if such a foreign key
462 -- exists, or FALSE otherwise.
463 -- Parameters Foreign Key Column key columns
464 --
465 -- Version Initial version number = 1.0
466 -- History Current version number = 1.0
467 --=======================================================
468 function FOREIGN_KEY_COLUMN_EXISTS (
469 p_api_version_number IN NUMBER,
470 p_return_status OUT NOCOPY VARCHAR2,
471 p_foreign_key_name IN VARCHAR2,
472 p_attribute_application_id IN NUMBER,
473 p_attribute_code IN VARCHAR2
474 ) return BOOLEAN;
475
476 --=======================================================
477 -- Function UNIQUE_KEY_EXISTS
478 --
479 -- Usage Private API for checking for the existence of
480 -- a unique key with the given key values. This
481 -- API should only be called by other APIs that are
482 -- owned by the Core Modules Team (AK).
483 --
484 -- Desc This API check to see if a unique key record
485 -- exists with the given key values.
486 --
487 -- Results The API returns the standard p_return_status parameter
488 -- indicating one of the standard return statuses :
489 -- * Unexpected error
490 -- * Error
491 -- * Success
492 -- This function will return TRUE if such a foreign key
493 -- exists, or FALSE otherwise.
494 -- Parameters Unique Key key columns
495 --
496 -- Version Initial version number = 1.0
497 -- History Current version number = 1.0
498 --=======================================================
499 function UNIQUE_KEY_EXISTS (
500 p_api_version_number IN NUMBER,
501 p_return_status OUT NOCOPY VARCHAR2,
502 p_unique_key_name IN VARCHAR2
503 ) return BOOLEAN;
504
505 --=======================================================
506 -- Function UNIQUE_KEY_COLUMN_EXISTS
507 --
508 -- Usage Private API for checking for the existence of
509 -- a unique key column record with the given key values.
510 -- This API should only be called by other APIs that are
511 -- owned by the Core Modules Team (AK).
512 --
513 -- Desc This API check to see if a unique key column record
514 -- exists with the given key values.
515 --
516 -- Results The API returns the standard p_return_status parameter
517 -- indicating one of the standard return statuses :
518 -- * Unexpected error
519 -- * Error
520 -- * Success
521 -- This function will return TRUE if such a unique key
522 -- exists, or FALSE otherwise.
523 -- Parameters Unique Key Column key columns
524 --
525 -- Version Initial version number = 1.0
526 -- History Current version number = 1.0
527 --=======================================================
528 function UNIQUE_KEY_COLUMN_EXISTS (
529 p_api_version_number IN NUMBER,
530 p_return_status OUT NOCOPY VARCHAR2,
531 p_unique_key_name IN VARCHAR2,
532 p_attribute_application_id IN NUMBER,
533 p_attribute_code IN VARCHAR2
534 ) return BOOLEAN;
535
536 --=======================================================
537 -- Procedure UPDATE_FOREIGN_KEY
538 --
539 -- Usage Private API for updating a foreign key.
540 -- This API should only be called by other APIs
541 -- that are owned by the Core Modules Team (AK).
542 --
543 -- Desc This API updates a foreign key using the given info
544 --
545 -- Results The API returns the standard p_return_status parameter
546 -- indicating one of the standard return statuses :
550 -- Parameters Foreign Key columns
547 -- * Unexpected error
548 -- * Error
549 -- * Success
551 -- p_loader_timestamp : IN optional
552 -- If a timestamp is passed, the API will update the
553 -- record using this timestamp. Only the upload API
554 -- should call with this parameter loaded.
555 --
556 -- Version Initial version number = 1.0
557 -- History Current version number = 1.0
558 --=======================================================
559 procedure UPDATE_FOREIGN_KEY (
560 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
561 p_api_version_number IN NUMBER,
562 p_init_msg_tbl IN BOOLEAN := FALSE,
563 p_msg_count OUT NOCOPY NUMBER,
564 p_msg_data OUT NOCOPY VARCHAR2,
565 p_return_status OUT NOCOPY VARCHAR2,
566 p_foreign_key_name IN VARCHAR2,
567 p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
568 p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
569 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
570 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
571 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
579 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
580 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
581 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
582 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
583 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
584 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
585 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
586 p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
587 p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
588 p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
589 p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
590 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
591 p_creation_date IN DATE := FND_API.G_MISS_DATE,
592 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
593 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
594 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
595 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
596 p_pass IN NUMBER,
597 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
598 );
599
600 --=======================================================
601 -- Procedure UPDATE_FOREIGN_KEY_COLUMN
602 --
603 -- Usage Private API for updating a foreign key column.
604 -- This API should only be called by other APIs
605 -- that are owned by the Core Modules Team (AK).
606 --
607 -- Desc This API updates a foreign key column using the given info
608 --
609 -- Results The API returns the standard p_return_status parameter
610 -- indicating one of the standard return statuses :
611 -- * Unexpected error
612 -- * Error
613 -- * Success
614 -- Parameters Foreign Key Column columns
615 -- p_loader_timestamp : IN optional
616 -- If a timestamp is passed, the API will update the
617 -- record using this timestamp. Only the upload API
618 -- should call with this parameter loaded.
619 --
620 -- Version Initial version number = 1.0
621 -- History Current version number = 1.0
622 --=======================================================
623 procedure UPDATE_FOREIGN_KEY_COLUMN (
624 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
625 p_api_version_number IN NUMBER,
626 p_init_msg_tbl IN BOOLEAN := FALSE,
627 p_msg_count OUT NOCOPY NUMBER,
628 p_msg_data OUT NOCOPY VARCHAR2,
629 p_return_status OUT NOCOPY VARCHAR2,
630 p_foreign_key_name IN VARCHAR2,
631 p_attribute_application_id IN NUMBER,
632 p_attribute_code IN VARCHAR2,
633 p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
634 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
635 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
636 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
637 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
638 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
639 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
640 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
641 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
642 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
643 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
644 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
648 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
645 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
646 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
647 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
649 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
650 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
651 p_creation_date IN DATE := FND_API.G_MISS_DATE,
652 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
653 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
654 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
655 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
656 p_pass IN NUMBER,
657 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
658 );
659
660 --=======================================================
661 -- Procedure UPDATE_UNIQUE_KEY
662 --
663 -- Usage Private API for updating a unique key.
664 -- This API should only be called by other APIs
665 -- that are owned by the Core Modules Team (AK).
666 --
667 -- Desc This API updates a unique key using the given info
668 --
669 -- Results The API returns the standard p_return_status parameter
670 -- indicating one of the standard return statuses :
671 -- * Unexpected error
672 -- * Error
673 -- * Success
674 -- Parameters Unique Key columns
675 -- p_loader_timestamp : IN optional
676 -- If a timestamp is passed, the API will update the
677 -- record using this timestamp. Only the upload API
678 -- should call with this parameter loaded.
679 --
680 -- Version Initial version number = 1.0
681 -- History Current version number = 1.0
682 --=======================================================
683 procedure UPDATE_UNIQUE_KEY (
684 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
685 p_api_version_number IN NUMBER,
686 p_init_msg_tbl IN BOOLEAN := FALSE,
687 p_msg_count OUT NOCOPY NUMBER,
688 p_msg_data OUT NOCOPY VARCHAR2,
689 p_return_status OUT NOCOPY VARCHAR2,
690 p_unique_key_name IN VARCHAR2,
691 p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
692 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
693 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
694 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
695 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
696 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
697 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
698 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
699 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
700 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
701 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
703 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
705 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
707 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
709 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
710 p_creation_date IN DATE := FND_API.G_MISS_DATE,
711 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
712 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
713 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
714 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
715 p_pass IN NUMBER,
716 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
717 );
718
719 --=======================================================
720 -- Procedure UPDATE_UNIQUE_KEY_COLUMN
721 --
722 -- Usage Private API for updating a unique key column.
723 -- This API should only be called by other APIs
724 -- that are owned by the Core Modules Team (AK).
725 --
726 -- Desc This API updates a unique key column using the given info
727 --
728 -- Results The API returns the standard p_return_status parameter
729 -- indicating one of the standard return statuses :
730 -- * Unexpected error
731 -- * Error
732 -- * Success
733 -- Parameters Unique Key Column columns
734 -- p_loader_timestamp : IN optional
735 -- If a timestamp is passed, the API will update the
736 -- record using this timestamp. Only the upload API
737 -- should call with this parameter loaded.
738 --
739 -- Version Initial version number = 1.0
740 -- History Current version number = 1.0
741 --=======================================================
742 procedure UPDATE_UNIQUE_KEY_COLUMN (
743 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
744 p_api_version_number IN NUMBER,
745 p_init_msg_tbl IN BOOLEAN := FALSE,
746 p_msg_count OUT NOCOPY NUMBER,
750 p_attribute_application_id IN NUMBER,
747 p_msg_data OUT NOCOPY VARCHAR2,
748 p_return_status OUT NOCOPY VARCHAR2,
749 p_unique_key_name IN VARCHAR2,
751 p_attribute_code IN VARCHAR2,
752 p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
753 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
754 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
755 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
756 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
757 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
758 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
759 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
760 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
761 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
762 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
763 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
764 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
766 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
767 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
768 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
769 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
770 p_creation_date IN DATE := FND_API.G_MISS_DATE,
771 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
772 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
773 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
774 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
775 p_pass IN NUMBER,
776 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
777 );
778
779 --========================================================
780 -- Function VALIDATE_FOREIGN_KEY
781 --
782 -- Usage Private API for validating a foreign key. This
783 -- API should only be called by other APIs that are
784 -- owned by the Core Modules Team (AK).
785 --
786 -- Desc Perform validation on a foreign key record.
787 --
788 -- Results The API returns the standard p_return_status parameter
789 -- indicating one of the standard return statuses :
790 -- * Unexpected error
791 -- * Error
792 -- * Success
793 -- In addition, this function returns TRUE if all
794 -- validation tests are passed, or FALSE otherwise.
795 -- Parameters Foreign Key columns
796 -- p_caller : IN required
797 -- Must be one of the following values defined
798 -- in package AK_ON_OBJECTS_PVT:
799 -- - G_CREATE (if calling from the Create API)
800 -- - G_DOWNLOAD (if calling from the Download API)
801 -- - G_UPDATE (if calling from the Update API)
802 --
803 -- Note This API is intended for performing record-level
804 -- validation. It is not designed for item-level
805 -- validation.
806 --
807 -- Version Initial version number = 1.0
808 -- History Current version number = 1.0
809 --========================================================
810 function VALIDATE_FOREIGN_KEY (
811 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
812 p_api_version_number IN NUMBER,
813 p_return_status OUT NOCOPY VARCHAR2,
814 p_foreign_key_name IN VARCHAR2,
815 p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
816 p_unique_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
817 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
818 p_from_to_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
819 p_from_to_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
820 p_to_from_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
821 p_to_from_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
822 p_caller IN VARCHAR2,
823 p_pass IN NUMBER := 2
824 ) return BOOLEAN;
825
826 --========================================================
827 -- Function VALIDATE_FOREIGN_KEY_COLUMN
828 --
829 -- Usage Private API for validating a foreign key column record.
830 -- This API should only be called by other APIs that are
831 -- owned by the Core Modules Team (AK).
832 --
833 -- Desc Perform validation on a foreign key column record.
834 --
835 -- Results The API returns the standard p_return_status parameter
836 -- indicating one of the standard return statuses :
837 -- * Unexpected error
838 -- * Error
839 -- * Success
840 -- In addition, this function returns TRUE if all
841 -- validation tests are passed, or FALSE otherwise.
842 -- Parameters Foreign Key Column columns
843 -- p_caller : IN required
844 -- Must be one of the following values defined
845 -- in package AK_ON_OBJECTS_PVT:
846 -- - G_CREATE (if calling from the Create API)
847 -- - G_DOWNLOAD (if calling from the Download API)
848 -- - G_UPDATE (if calling from the Update API)
849 --
850 -- Note This API is intended for performing record-level
854 -- Version Initial version number = 1.0
851 -- validation. It is not designed for item-level
852 -- validation.
853 --
855 -- History Current version number = 1.0
856 --========================================================
857 function VALIDATE_FOREIGN_KEY_COLUMN (
858 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
859 p_api_version_number IN NUMBER,
860 p_return_status OUT NOCOPY VARCHAR2,
861 p_foreign_key_name IN VARCHAR2,
862 p_attribute_application_id IN NUMBER,
863 p_attribute_code IN VARCHAR2,
864 p_foreign_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
865 p_caller IN VARCHAR2,
866 p_pass IN NUMBER := 2
867 ) return BOOLEAN;
868
869 --========================================================
870 -- Function VALIDATE_UNIQUE_KEY
871 --
872 -- Usage Private API for validating a unique key. This
873 -- API should only be called by other APIs that are
874 -- owned by the Core Modules Team (AK).
875 --
876 -- Desc Perform validation on a unique key record.
877 --
878 -- Results The API returns the standard p_return_status parameter
879 -- indicating one of the standard return statuses :
880 -- * Unexpected error
881 -- * Error
882 -- * Success
883 -- In addition, this function returns TRUE if all
884 -- validation tests are passed, or FALSE otherwise.
885 -- Parameters Unique Key columns
886 -- p_caller : IN required
887 -- Must be one of the following values defined
888 -- in package AK_ON_OBJECTS_PVT:
889 -- - G_CREATE (if calling from the Create API)
890 -- - G_DOWNLOAD (if calling from the Download API)
891 -- - G_UPDATE (if calling from the Update API)
892 --
893 -- Note This API is intended for performing record-level
894 -- validation. It is not designed for item-level
895 -- validation.
896 --
897 -- Version Initial version number = 1.0
898 -- History Current version number = 1.0
899 --========================================================
900 function VALIDATE_UNIQUE_KEY (
901 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
902 p_api_version_number IN NUMBER,
903 p_return_status OUT NOCOPY VARCHAR2,
904 p_unique_key_name IN VARCHAR2,
905 p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
906 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
907 p_caller IN VARCHAR2,
908 p_pass IN NUMBER := 2
909 ) return BOOLEAN;
910
911 --========================================================
912 -- Function VALIDATE_UNIQUE_KEY_COLUMN
913 --
914 -- Usage Private API for validating a unique key column record.
915 -- This API should only be called by other APIs that are
916 -- owned by the Core Modules Team (AK).
917 --
918 -- Desc Perform validation on a unique key column record.
919 --
920 -- Results The API returns the standard p_return_status parameter
921 -- indicating one of the standard return statuses :
922 -- * Unexpected error
923 -- * Error
924 -- * Success
925 -- In addition, this function returns TRUE if all
926 -- validation tests are passed, or FALSE otherwise.
927 -- Parameters Unique Key Column columns
928 -- p_caller : IN required
929 -- Must be one of the following values defined
930 -- in package AK_ON_OBJECTS_PVT:
931 -- - G_CREATE (if calling from the Create API)
932 -- - G_DOWNLOAD (if calling from the Download API)
933 -- - G_UPDATE (if calling from the Update API)
934 --
935 -- Note This API is intended for performing record-level
936 -- validation. It is not designed for item-level
937 -- validation.
938 --
939 -- Version Initial version number = 1.0
940 -- History Current version number = 1.0
941 --========================================================
942 function VALIDATE_UNIQUE_KEY_COLUMN (
943 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
944 p_api_version_number IN NUMBER,
945 p_return_status OUT NOCOPY VARCHAR2,
946 p_unique_key_name IN VARCHAR2,
947 p_attribute_application_id IN NUMBER,
948 p_attribute_code IN VARCHAR2,
949 p_unique_key_sequence IN NUMBER := FND_API.G_MISS_NUM,
950 p_caller IN VARCHAR2,
951 p_pass IN NUMBER := 2
952 ) return BOOLEAN;
953
954 --=======================================================
955 -- Procedure CHECK_FOREIGN_KEY_SEQUENCE
956 --
957 -- Usage Private API for checking for the existence of
958 -- a foreign key column record with the given foreign_
959 -- key_name and foreign_key_sequence. If such a record
960 -- exists but has attribute_codes or attribute_application
961 -- id values different from the parameters, the record
962 -- will be deleted
963 -- owned by the Core Modules Team (AK).
964 --
968 -- Results The API returns the standard p_return_status parameter
965 -- Desc This API check to see if a foreign key column record
966 -- exists with the given key values.
967 --
969 -- indicating one of the standard return statuses :
970 -- * Unexpected error
971 -- * Error
972 -- * Success
973 -- Parameters Foreign Key Column key columns
974 --
975 -- Version Initial version number = 1.0
976 -- History Current version number = 1.0
977 --=======================================================
978 procedure CHECK_FOREIGN_KEY_SEQUENCE (
979 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
980 p_api_version_number IN NUMBER,
981 p_return_status OUT NOCOPY VARCHAR2,
982 p_foreign_key_name IN VARCHAR2,
983 p_attribute_application_id IN NUMBER,
984 p_attribute_code IN VARCHAR2,
985 p_foreign_key_sequence IN NUMBER
986 );
987
988 --=======================================================
989 -- Procedure DELETE_RELATED_FOREIGN_KEY_COL
990 --
991 -- Usage Private API for deleting foreign key columns.
992 -- This API should only be called by other APIs
993 -- that are owned by the Core Modules Team (AK).
994 --
995 -- Desc This API deletes foreign key columns from a
996 -- given foreign_key_name.
997 --
998 -- Results The API returns the standard p_return_status parameter
999 -- indicating one of the standard return statuses :
1000 -- * Unexpected error
1001 -- * Error
1002 -- * Success
1003 -- Parameters Foreign Key columns
1004 --
1005 -- Version Initial version number = 1.0
1006 -- History Current version number = 1.0
1007 --=======================================================
1008 procedure DELETE_RELATED_FOREIGN_KEY_COL (
1009 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1010 p_api_version_number IN NUMBER,
1011 p_msg_count OUT NOCOPY NUMBER,
1012 p_msg_data OUT NOCOPY VARCHAR2,
1013 p_return_status OUT NOCOPY VARCHAR2,
1014 p_foreign_key_name IN VARCHAR2
1015 );
1016
1017 --=======================================================
1018 -- Procedure DELETE_RELATED_UNIQUE_KEY_COL
1019 --
1020 -- Usage Private API for deleting unique key columns.
1021 -- This API should only be called by other APIs
1022 -- that are owned by the Core Modules Team (AK).
1023 --
1024 -- Desc This API deletes unique key columns from a
1025 -- given unique_key_name.
1026 --
1027 -- Results The API returns the standard p_return_status parameter
1028 -- indicating one of the standard return statuses :
1029 -- * Unexpected error
1030 -- * Error
1031 -- * Success
1032 -- Parameters Foreign Key columns
1033 --
1034 -- Version Initial version number = 1.0
1035 -- History Current version number = 1.0
1036 --=======================================================
1037 procedure DELETE_RELATED_UNIQUE_KEY_COL (
1038 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1039 p_api_version_number IN NUMBER,
1040 p_msg_count OUT NOCOPY NUMBER,
1041 p_msg_data OUT NOCOPY VARCHAR2,
1042 p_return_status OUT NOCOPY VARCHAR2,
1043 p_unique_key_name IN VARCHAR2
1044 );
1045
1046 end AK_KEY_PVT;