1 package AK_OBJECT_GRP as
2 /* $Header: akdgobjs.pls 120.3 2005/09/15 22:26:37 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_OBJECT_GRP';
8
9 /* Procedure specs */
10
11 --=======================================================
12 -- Procedure CREATE_ATTRIBUTE
13 --
14 -- Usage Group API for creating an object attribute
15 --
16 -- Desc Calls the private API to create an object attribute
17 -- using the given info
18 --
19 -- Results The API returns the standard p_return_status parameter
20 -- indicating one of the standard return statuses :
21 -- * Unexpected error
22 -- * Error
23 -- * Success
24 -- Parameters Object Attribute columns
25 --
26 -- Version Initial version number = 1.0
27 -- History Current version number = 1.0
28 --=======================================================
29 procedure CREATE_ATTRIBUTE (
30 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31 p_api_version_number IN NUMBER,
32 p_init_msg_tbl IN BOOLEAN := FALSE,
33 p_msg_count OUT NOCOPY NUMBER,
34 p_msg_data OUT NOCOPY VARCHAR2,
35 p_return_status OUT NOCOPY VARCHAR2,
36 p_database_object_name IN VARCHAR2,
37 p_attribute_application_id IN NUMBER,
38 p_attribute_code IN VARCHAR2,
39 p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
40 p_attribute_label_length IN NUMBER,
41 p_display_value_length IN NUMBER,
42 p_bold IN VARCHAR2,
43 p_italic IN VARCHAR2,
44 p_vertical_alignment IN VARCHAR2,
45 p_horizontal_alignment IN VARCHAR2,
46 p_data_source_type IN VARCHAR2,
47 p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48 p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
49 p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50 p_required_flag IN VARCHAR2,
51 p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52 p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
53 p_default_value_date IN DATE := FND_API.G_MISS_DATE,
54 p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
55 p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56 p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
57 p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
58 p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
59 p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60 p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61 p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
62 p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
63 p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
64 p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
65 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66 p_creation_date IN DATE := FND_API.G_MISS_DATE,
67 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
69 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
70 );
71
72 --=======================================================
73 -- Procedure CREATE_ATTRIBUTE_NAVIGATION
74 --
75 -- Usage Group API for creating an attribute
76 -- navigation record.
77 --
78 -- Desc Calls the private API to create an attribute
79 -- navigation record using the given info
80 --
81 -- Results The API returns the standard p_return_status parameter
82 -- indicating one of the standard return statuses :
83 -- * Unexpected error
84 -- * Error
85 -- * Success
86 -- Parameters Attribute Navigation columns
87 --
88 -- Version Initial version number = 1.0
89 -- History Current version number = 1.0
90 --=======================================================
91 procedure CREATE_ATTRIBUTE_NAVIGATION (
92 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93 p_api_version_number IN NUMBER,
94 p_init_msg_tbl IN BOOLEAN := FALSE,
95 p_msg_count OUT NOCOPY NUMBER,
96 p_msg_data OUT NOCOPY VARCHAR2,
97 p_return_status OUT NOCOPY VARCHAR2,
98 p_database_object_name IN VARCHAR2,
99 p_attribute_application_id IN NUMBER,
100 p_attribute_code IN VARCHAR2,
101 p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102 p_value_date IN DATE,
103 p_value_number IN NUMBER,
104 p_to_region_appl_id IN NUMBER,
105 p_to_region_code IN VARCHAR2,
106 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
107 p_creation_date IN DATE := FND_API.G_MISS_DATE,
108 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
109 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
110 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
111 );
112
113 --=======================================================
114 -- Procedure CREATE_ATTRIBUTE_VALUE
115 --
116 -- Usage Group API for creating an attribute value
117 -- record
118 --
119 -- Desc Calls the private API to create an attribute
120 -- value record using the given info
121 --
122 -- Results The API returns the standard p_return_status parameter
123 -- indicating one of the standard return statuses :
124 -- * Unexpected error
125 -- * Error
126 -- * Success
127 -- Parameters Attribute Value columns
128 --
129 -- Version Initial version number = 1.0
130 -- History Current version number = 1.0
131 --=======================================================
132 procedure CREATE_ATTRIBUTE_VALUE (
133 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134 p_api_version_number IN NUMBER,
135 p_init_msg_tbl IN BOOLEAN := FALSE,
136 p_msg_count OUT NOCOPY NUMBER,
137 p_msg_data OUT NOCOPY VARCHAR2,
138 p_return_status OUT NOCOPY VARCHAR2,
139 p_database_object_name IN VARCHAR2,
140 p_attribute_application_id IN NUMBER,
141 p_attribute_code IN VARCHAR2,
142 p_key_value1 IN VARCHAR2,
143 p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144 p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145 p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146 p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147 p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148 p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149 p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150 p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151 p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152 p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153 p_value_date IN DATE := FND_API.G_MISS_DATE,
154 p_value_number IN NUMBER := FND_API.G_MISS_NUM,
155 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156 p_creation_date IN DATE := FND_API.G_MISS_DATE,
157 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
158 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
159 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
160 );
161
162 --=======================================================
163 -- Procedure CREATE_OBJECT
164 --
165 -- Usage Group API for creating an object
166 --
167 -- Desc Calls the private API to create an object
168 --
169 -- Results The API returns the standard p_return_status parameter
170 -- indicating one of the standard return statuses :
171 -- * Unexpected error
172 -- * Error
173 -- * Success
174 -- Parameters Object columns
175 --
176 -- Version Initial version number = 1.0
177 -- History Current version number = 1.0
178 --=======================================================
179 procedure CREATE_OBJECT (
180 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181 p_api_version_number IN NUMBER,
182 p_init_msg_tbl IN BOOLEAN := FALSE,
183 p_msg_count OUT NOCOPY NUMBER,
184 p_msg_data OUT NOCOPY VARCHAR2,
185 p_return_status OUT NOCOPY VARCHAR2,
186 p_database_object_name IN VARCHAR2,
187 p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
188 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
189 p_application_id IN NUMBER,
190 p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
191 p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
192 p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
193 p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
194 p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
195 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
196 p_creation_date IN DATE := FND_API.G_MISS_DATE,
197 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
198 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
199 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
200 );
201
202 --=======================================================
203 -- Procedure DELETE_ATTRIBUTE
204 --
205 -- Usage Group API for deleting an object attribute
206 --
207 -- Desc Calls the private API to delete an object attribute
208 -- with the given key value.
209 --
210 -- Results The API returns the standard p_return_status parameter
211 -- indicating one of the standard return statuses :
212 -- * Unexpected error
213 -- * Error
214 -- * Success
215 -- Parameters p_database_object_name : IN required
216 -- p_attribute_application_id : IN required
217 -- p_attribute_code : IN required
218 -- Key value of the object attribute to be deleted.
219 -- p_delete_cascade : IN required
220 -- If p_delete_cascade flag is 'Y', also delete all
221 -- rows in other tables that references this record.
222 -- Otherwise, this record will not be deleted if there
223 -- are any other rows referencing it.
224 --
225 -- Version Initial version number = 1.0
226 -- History Current version number = 1.0
227 --=======================================================
228 procedure DELETE_ATTRIBUTE (
229 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
230 p_api_version_number IN NUMBER,
231 p_init_msg_tbl IN BOOLEAN := FALSE,
232 p_msg_count OUT NOCOPY NUMBER,
233 p_msg_data OUT NOCOPY VARCHAR2,
234 p_return_status OUT NOCOPY VARCHAR2,
235 p_database_object_name IN VARCHAR2,
236 p_attribute_application_id IN NUMBER,
237 p_attribute_code IN VARCHAR2,
238 p_delete_cascade IN VARCHAR2 := 'N'
239 );
240
241 --=======================================================
242 -- Procedure DELETE_ATTRIBUTE_NAVIGATION
243 --
244 -- Usage Group API for deleting an attribute navigation
245 -- record
246 --
247 -- Desc Calls the private API to delete an attribute
248 -- navigation record with the given key value.
249 --
250 -- Results The API returns the standard p_return_status parameter
251 -- indicating one of the standard return statuses :
252 -- * Unexpected error
253 -- * Error
254 -- * Success
255 -- Parameters p_database_object_name : IN required
256 -- p_attribute_application_id : IN required
257 -- p_attribute_code : IN required
258 -- p_value_varchar2 : IN required (can be null)
259 -- p_value_date : IN required (can be null)
260 -- p_value_number : IN required (can be null)
261 -- Key value of the attribute navigation record
262 -- to be deleted.
263 -- p_delete_cascade : IN required
264 -- If p_delete_cascade flag is 'Y', also delete all
265 -- rows in other tables that references this record.
266 -- Otherwise, this record will not be deleted if there
267 -- are any other rows referencing it.
268 --
269 -- Version Initial version number = 1.0
270 -- History Current version number = 1.0
271 --=======================================================
272 procedure DELETE_ATTRIBUTE_NAVIGATION (
273 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274 p_api_version_number IN NUMBER,
275 p_init_msg_tbl IN BOOLEAN := FALSE,
276 p_msg_count OUT NOCOPY NUMBER,
277 p_msg_data OUT NOCOPY VARCHAR2,
278 p_return_status OUT NOCOPY VARCHAR2,
279 p_database_object_name IN VARCHAR2,
280 p_attribute_application_id IN NUMBER,
281 p_attribute_code IN VARCHAR2,
282 p_value_varchar2 IN VARCHAR2,
283 p_value_date IN DATE,
284 p_value_number IN NUMBER,
285 p_delete_cascade IN VARCHAR2 := 'N'
286 );
287
288 --=======================================================
289 -- Procedure DELETE_ATTRIBUTE_VALUE
290 --
291 -- Usage Group API for deleting an attribute value
292 -- record
293 --
294 -- Desc Calls the private API to delete an attribute
295 -- value record with the given key value.
296 --
297 -- Results The API returns the standard p_return_status parameter
298 -- indicating one of the standard return statuses :
299 -- * Unexpected error
300 -- * Error
301 -- * Success
302 -- Parameters p_database_object_name : IN required
303 -- p_attribute_application_id : IN required
304 -- p_attribute_code : IN required
305 -- p_key_value1 : IN required
306 -- p_key_value2 thru p_key_value10 : IN optional
307 -- Key value of the attribute value record
308 -- to be deleted.
309 -- p_delete_cascade : IN required
310 -- If p_delete_cascade flag is 'Y', also delete all
311 -- rows in other tables that references this record.
312 -- Otherwise, this record will not be deleted if there
313 -- are any other rows referencing it.
314 --
315 -- Version Initial version number = 1.0
316 -- History Current version number = 1.0
317 --=======================================================
318 procedure DELETE_ATTRIBUTE_VALUE (
319 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
320 p_api_version_number IN NUMBER,
321 p_init_msg_tbl IN BOOLEAN := FALSE,
322 p_msg_count OUT NOCOPY NUMBER,
323 p_msg_data OUT NOCOPY VARCHAR2,
324 p_return_status OUT NOCOPY VARCHAR2,
325 p_database_object_name IN VARCHAR2,
326 p_attribute_application_id IN NUMBER,
327 p_attribute_code IN VARCHAR2,
328 p_key_value1 IN VARCHAR2,
329 p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
333 p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
330 p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
331 p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
332 p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
334 p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
335 p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336 p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337 p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338 p_delete_cascade IN VARCHAR2 := 'N'
339 );
340
341 --=======================================================
342 -- Procedure DELETE_OBJECT
343 --
344 -- Usage Group API for deleting an object
345 --
346 -- Desc Calls the private API to delete an object
347 -- with the given key value.
348 --
349 -- Results The API returns the standard p_return_status parameter
350 -- indicating one of the standard return statuses :
351 -- * Unexpected error
352 -- * Error
353 -- * Success
354 -- Parameters p_database_object_name : IN required
355 -- database object name of the object to be deleted
356 -- p_delete_cascade : IN required
357 -- If p_delete_cascade flag is 'Y', also delete all
358 -- rows in other tables that references this object.
359 -- Otherwise, this object will not be deleted if there
360 -- are any other rows referencing it.
361 --
362 -- Version Initial version number = 1.0
363 -- History Current version number = 1.0
364 --=======================================================
365 procedure DELETE_OBJECT (
366 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
367 p_api_version_number IN NUMBER,
368 p_init_msg_tbl IN BOOLEAN := FALSE,
369 p_msg_count OUT NOCOPY NUMBER,
370 p_msg_data OUT NOCOPY VARCHAR2,
371 p_return_status OUT NOCOPY VARCHAR2,
372 p_database_object_name IN VARCHAR2,
373 p_delete_cascade IN VARCHAR2 := 'N'
374 );
375
376 --===========================================================
377 -- Procedure DOWNLOAD_OBJECT
378 --
379 -- Usage Group API for downloading objects
380 --
381 -- Desc This API first write out standard loader
382 -- file header for objects to a flat file.
383 -- Then it calls the private API to extract the
384 -- objects selected by application ID or by
385 -- key values from the database to the output file.
386 -- If an object is selected for writing to the loader
387 -- file, all its children records (including object
388 -- attributes, foreign and unique key definitions,
389 -- attribute values, attribute navigation, and regions
390 -- that references this object) will also be written.
391 --
392 -- Results The API returns the standard p_return_status parameter
393 -- indicating one of the standard return statuses :
394 -- * Unexpected error
395 -- * Error
396 -- * Success
397 -- Parameters
398 -- p_nls_language : IN optional
399 -- NLS language for database. If none if given,
400 -- the current NLS language will be used.
401 --
402 -- One of the following three parameters must be given:
403 --
404 -- p_application_id : IN optional
405 -- If given, all attributes for this application ID
406 -- will be written to the output file.
407 -- p_application_short_name : IN optional
408 -- If given, all attributes for this application short
409 -- name will be written to the output file.
410 -- Application short name will be ignored if an
411 -- application ID is given.
412 -- p_object_pk_tbl : IN optional
413 -- If given, only objects whose key values are
414 -- included in this table will be written to the
415 -- output file.
416 --
417 --
418 -- Version Initial version number = 1.0
419 -- History Current version number = 1.0
420 --===========================================================
421 procedure DOWNLOAD_OBJECT (
422 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
423 p_api_version_number IN NUMBER,
424 p_init_msg_tbl IN BOOLEAN := FALSE,
425 p_msg_count OUT NOCOPY NUMBER,
426 p_msg_data OUT NOCOPY VARCHAR2,
427 p_return_status OUT NOCOPY VARCHAR2,
428 p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
429 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
430 p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431 p_object_pk_tbl IN AK_OBJECT_PUB.Object_PK_Tbl_Type
432 := AK_OBJECT_PUB.G_MISS_OBJECT_PK_TBL
433 );
434
435 --=======================================================
436 -- Procedure UPDATE_ATTRIBUTE
437 --
438 -- Usage Group API for updating an object attribute
439 --
440 -- Desc This API calls the private API to update
444 -- indicating one of the standard return statuses :
441 -- an object attribute using the given info
442 --
443 -- Results The API returns the standard p_return_status parameter
445 -- * Unexpected error
446 -- * Error
447 -- * Success
448 -- Parameters Object Attribute columns
449 --
450 -- Version Initial version number = 1.0
451 -- History Current version number = 1.0
452 --=======================================================
453 procedure UPDATE_ATTRIBUTE (
454 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
455 p_api_version_number IN NUMBER,
456 p_init_msg_tbl IN BOOLEAN := FALSE,
457 p_msg_count OUT NOCOPY NUMBER,
458 p_msg_data OUT NOCOPY VARCHAR2,
459 p_return_status OUT NOCOPY VARCHAR2,
460 p_database_object_name IN VARCHAR2,
461 p_attribute_application_id IN NUMBER,
462 p_attribute_code IN VARCHAR2,
463 p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464 p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
465 p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
466 p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
467 p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
468 p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
469 p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
470 p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
471 p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
472 p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
473 p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474 p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
475 p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
476 p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
477 p_default_value_date IN DATE := FND_API.G_MISS_DATE,
478 p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479 p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480 p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
481 p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
482 p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483 p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
484 p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
485 p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
486 p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
487 p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
488 p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
489 p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
490 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
491 p_creation_date IN DATE := FND_API.G_MISS_DATE,
492 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
493 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
494 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
495 );
496
497 --=======================================================
498 -- Procedure UPDATE_ATTRIBUTE_NAVIGATION
499 --
500 -- Usage Group API for updating an attribute navigation
501 -- record
502 --
503 -- Desc This API calls the private API to update
504 -- an attribute naviation record using the given info
505 --
506 -- Results The API returns the standard p_return_status parameter
507 -- indicating one of the standard return statuses :
508 -- * Unexpected error
509 -- * Error
510 -- * Success
511 -- Parameters Attribute Navigation columns
512 --
513 -- Version Initial version number = 1.0
514 -- History Current version number = 1.0
515 --=======================================================
516 procedure UPDATE_ATTRIBUTE_NAVIGATION (
517 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
518 p_api_version_number IN NUMBER,
519 p_init_msg_tbl IN BOOLEAN := FALSE,
520 p_msg_count OUT NOCOPY NUMBER,
521 p_msg_data OUT NOCOPY VARCHAR2,
522 p_return_status OUT NOCOPY VARCHAR2,
523 p_database_object_name IN VARCHAR2,
524 p_attribute_application_id IN NUMBER,
525 p_attribute_code IN VARCHAR2,
526 p_value_varchar2 IN VARCHAR2,
527 p_value_date IN DATE,
528 p_value_number IN NUMBER,
529 p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
530 p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
531 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
532 p_creation_date IN DATE := FND_API.G_MISS_DATE,
533 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
534 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
535 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
536 );
537
538 --=======================================================
539 -- Procedure UPDATE_ATTRIBUTE_VALUE
540 --
541 -- Usage Group API for updating an attribute value
542 -- record
543 --
544 -- Desc This API calls the private API to update
545 -- an attribute value record using the given info
546 --
550 -- * Error
547 -- Results The API returns the standard p_return_status parameter
548 -- indicating one of the standard return statuses :
549 -- * Unexpected error
551 -- * Success
552 -- Parameters Attribute Value columns
553 --
554 -- Version Initial version number = 1.0
555 -- History Current version number = 1.0
556 --=======================================================
557 procedure UPDATE_ATTRIBUTE_VALUE (
558 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
559 p_api_version_number IN NUMBER,
560 p_init_msg_tbl IN BOOLEAN := FALSE,
561 p_msg_count OUT NOCOPY NUMBER,
562 p_msg_data OUT NOCOPY VARCHAR2,
563 p_return_status OUT NOCOPY VARCHAR2,
564 p_database_object_name IN VARCHAR2,
565 p_attribute_application_id IN NUMBER,
566 p_attribute_code IN VARCHAR2,
567 p_key_value1 IN VARCHAR2,
568 p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
569 p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
570 p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
571 p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
572 p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
573 p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
574 p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
575 p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
576 p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
577 p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
578 p_value_date IN DATE := FND_API.G_MISS_DATE,
579 p_value_number IN NUMBER := FND_API.G_MISS_NUM,
580 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
581 p_creation_date IN DATE := FND_API.G_MISS_DATE,
582 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
583 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
584 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
585 );
586
587 --=======================================================
588 -- Procedure UPDATE_OBJECT
589 --
590 -- Usage Group API for updating an object
591 --
592 -- Desc This API calls the private API to update
593 -- an object using the given info
594 --
595 -- Results The API returns the standard p_return_status parameter
596 -- indicating one of the standard return statuses :
597 -- * Unexpected error
598 -- * Error
599 -- * Success
600 -- Parameters Object columns
601 --
602 -- Version Initial version number = 1.0
603 -- History Current version number = 1.0
604 --=======================================================
605 procedure UPDATE_OBJECT (
606 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
607 p_api_version_number IN NUMBER,
608 p_init_msg_tbl IN BOOLEAN := FALSE,
609 p_msg_count OUT NOCOPY NUMBER,
610 p_msg_data OUT NOCOPY VARCHAR2,
611 p_return_status OUT NOCOPY VARCHAR2,
612 p_database_object_name IN VARCHAR2,
613 p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
614 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
615 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
616 p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
617 p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
618 p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
619 p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
620 p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
621 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
622 p_creation_date IN DATE := FND_API.G_MISS_DATE,
623 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
624 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
625 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
626 );
627
628 end AK_OBJECT_GRP;