1 package AK_ATTRIBUTE_PVT AUTHID CURRENT_USER as
2 /* $Header: akdvatrs.pls 120.3 2005/09/15 22:26:45 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_ATTRIBUTE_PVT';
8
9 -- PL/SQL table for holding records that need to be processed
10 -- the second time in UPLOAD
11 G_ATTRIBUTE_REDO_TBL AK_ATTRIBUTE_PUB.Attribute_Tbl_Type;
12 G_ATTRIBUTE_TL_REDO_TBL AK_ATTRIBUTE_PUB.Attribute_Tl_Tbl_Type;
13 --
14 -- Pointer to redo table
15 G_ATTRIBUTE_REDO_INDEX NUMBER := 0;
16
17 -- Procedure specs
18
19 --=======================================================
20 -- Function ATTRIBUTE_EXISTS
21 --
22 -- Usage Private API for checking for the existence of
23 -- an attribute with the given key values. This
24 -- API should only be called by other APIs that are
25 -- owned by the Core Modules Team (AK).
26 --
27 -- Desc This API check to see if an attribute record
28 -- exists with the given key values.
29 --
30 -- Results The API returns the standard p_return_status parameter
31 -- indicating one of the standard return statuses :
32 -- * Unexpected error
33 -- * Error
34 -- * Success
35 -- This function will return TRUE if such an attribute
36 -- exists, or FALSE otherwise.
37 -- Parameters Attribute key columns
38 --
39 -- Version Initial version number = 1.0
40 -- History Current version number = 1.0
41 --=======================================================
42 function ATTRIBUTE_EXISTS (
43 p_api_version_number IN NUMBER,
44 p_return_status OUT NOCOPY VARCHAR2,
45 p_attribute_application_id IN NUMBER,
46 p_attribute_code IN VARCHAR2
47 ) return BOOLEAN;
48
49 --=======================================================
50 -- Procedure CREATE_ATTRIBUTE
51 --
52 -- Usage Private API for creating an attribute. This
53 -- API should only be called by other APIs that are
54 -- owned by the Core Modules Team (AK).
55 --
56 -- Desc Creates an attribute using the given info. This
57 -- API should only be called by other APIs that are
58 -- owned by the Core Modules Team (AK).
59 --
60 -- Results The API returns the standard p_return_status parameter
61 -- indicating one of the standard return statuses :
62 -- * Unexpected error
63 -- * Error
64 -- * Success
65 -- Parameters Attribute columns
66 -- p_loader_timestamp : IN optional
67 -- If a timestamp is passed, the API will create the
68 -- record using this timestamp. Only the upload API
69 -- should call with this parameter loaded.
70 --
71 -- Version Initial version number = 1.0
72 -- History Current version number = 1.0
73 --=======================================================
74 procedure CREATE_ATTRIBUTE (
75 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76 p_api_version_number IN NUMBER,
77 p_init_msg_tbl IN BOOLEAN := FALSE,
78 p_msg_count OUT NOCOPY NUMBER,
79 p_msg_data OUT NOCOPY VARCHAR2,
80 p_return_status OUT NOCOPY VARCHAR2,
81 p_attribute_application_id IN NUMBER,
82 p_attribute_code IN VARCHAR2,
83 p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
84 p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
85 p_bold IN VARCHAR2,
86 p_italic IN VARCHAR2,
87 p_vertical_alignment IN VARCHAR2,
88 p_horizontal_alignment IN VARCHAR2,
89 p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
90 p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91 p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92 p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
93 p_default_value_date IN DATE := FND_API.G_MISS_DATE,
94 p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
95 p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
96 p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
97 p_display_height IN NUMBER := FND_API.G_MISS_NUM,
98 p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
99 p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
100 p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
101 p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
102 p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103 p_precision IN NUMBER := FND_API.G_MISS_NUM,
104 p_expansion IN NUMBER := FND_API.G_MISS_NUM,
105 p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
106 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
107 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_name IN VARCHAR2,
123 p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
127 p_creation_date IN DATE := FND_API.G_MISS_DATE,
128 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
129 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
130 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
131 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
132 p_pass IN NUMBER,
133 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
134 );
135
136 --=======================================================
137 -- Procedure DELETE_ATTRIBUTE
138 --
139 -- Usage Private API for deleting an attribute. This
140 -- API should only be called by other APIs that are
141 -- owned by the Core Modules Team (AK).
142 --
143 -- Desc Deletes an attribute with the given key value.
144 --
145 -- Results The API returns the standard p_return_status parameter
146 -- indicating one of the standard return statuses :
147 -- * Unexpected error
148 -- * Error
149 -- * Success
150 -- Parameters p_attribute_application_id : IN required
151 -- p_attribute_code : IN required
152 -- Key value of the attribute to be deleted.
153 -- p_delete_cascade : IN required
154 -- If p_delete_cascade flag is 'Y', also delete all
155 -- rows in other tables that references this attribute.
156 -- Otherwise, this attribute will not be deleted if there
157 -- are any other rows referencing it.
158 --
159 -- Version Initial version number = 1.0
160 -- History Current version number = 1.0
161 --=======================================================
162 procedure DELETE_ATTRIBUTE (
163 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164 p_api_version_number IN NUMBER,
165 p_init_msg_tbl IN BOOLEAN := FALSE,
166 p_msg_count OUT NOCOPY NUMBER,
167 p_msg_data OUT NOCOPY VARCHAR2,
168 p_return_status OUT NOCOPY VARCHAR2,
169 p_attribute_application_id IN NUMBER,
170 p_attribute_code IN VARCHAR2,
171 p_delete_cascade IN VARCHAR2
172 );
173
174
175 --=======================================================
176 -- Procedure DOWNLOAD_ATTRIBUTE
177 --
178 -- Usage Private API for downloading attributes. This
179 -- API should only be called by other APIs that are
180 -- owned by the Core Modules Team (AK).
181 --
182 -- Desc This API will extract the attributes selected
183 -- by application ID or by key values from the
184 -- database to the output file.
185 --
186 -- Results The API returns the standard p_return_status parameter
187 -- indicating one of the standard return statuses :
188 -- * Unexpected error
189 -- * Error
190 -- * Success
191 -- Parameters
192 -- p_nls_language : IN optional
193 -- NLS language for database. If none if given,
194 -- the current NLS language will be used.
195 --
196 -- One of the following parameters must be provided:
197 --
198 -- p_application_id : IN optional
199 -- If given, all attributes for this application ID
200 -- will be written to the output file.
201 -- p_application_id will be ignored if a table is
202 -- given in p_attribute_pk_tbl.
203 -- p_attribute_pk_tbl : IN optional
204 -- If given, only attributes whose key values are
205 -- included in this table will be written to the
206 -- output file.
207 --
208 --
209 -- Version Initial version number = 1.0
210 -- History Current version number = 1.0
211 --=======================================================
212 procedure DOWNLOAD_ATTRIBUTE (
213 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214 p_api_version_number IN NUMBER,
215 p_return_status OUT NOCOPY VARCHAR2,
216 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
217 p_attribute_pk_tbl IN AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type
218 := AK_ATTRIBUTE_PUB.G_MISS_ATTRIBUTE_PK_TBL,
219 p_nls_language IN VARCHAR2
220 );
221
222 --=======================================================
223 -- Procedure INSERT_ATTRIBUTE_PK_TABLE
224 --
225 -- Usage Private API for inserting the given attribute's
226 -- primary key value into the given attribute
227 -- table.
228 -- This API should only be called by other APIs
229 -- that are owned by the Core Modules Team (AK).
230 --
231 -- Desc This API inserts the given attribute primary
232 -- key value into a given attribute table
233 -- (of type Attribute_PK_Tbl_Type) only if the
234 -- primary key does not already exist in the table.
235 --
236 -- Results The API returns the standard p_return_status parameter
237 -- indicating one of the standard return statuses :
238 -- * Unexpected error
239 -- * Error
240 -- * Success
241 -- Parameters Attribute key columns: IN required
242 -- p_attribute_pk_tbl : IN OUT
243 -- Attribute table to be updated.
244 --
245 -- Version Initial version number = 1.0
246 -- History Current version number = 1.0
247 --=======================================================
248 procedure INSERT_ATTRIBUTE_PK_TABLE (
249 p_return_status OUT NOCOPY VARCHAR2,
250 p_attribute_application_id IN NUMBER,
251 p_attribute_code IN VARCHAR2,
252 p_attribute_pk_tbl IN OUT NOCOPY AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type
253 );
254
255 --=======================================================
256 -- Procedure UPDATE_ATTRIBUTE
257 --
258 -- Usage Private API for updating an attribute.
259 -- This API should only be called by other APIs
260 -- that are owned by the Core Modules Team (AK).
261 --
262 -- Desc This API updates an attribute using the given info
263 --
264 -- Results The API returns the standard p_return_status parameter
265 -- indicating one of the standard return statuses :
266 -- * Unexpected error
267 -- * Error
268 -- * Success
269 -- Parameters Attribute columns
270 -- p_loader_timestamp : IN optional
271 -- If a timestamp is passed, the API will update the
272 -- record using this timestamp. Only the upload API
273 -- should call with this parameter loaded.
274 --
275 -- Version Initial version number = 1.0
276 -- History Current version number = 1.0
277 --=======================================================
278 procedure UPDATE_ATTRIBUTE (
279 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280 p_api_version_number IN NUMBER,
281 p_init_msg_tbl IN BOOLEAN := FALSE,
282 p_msg_count OUT NOCOPY NUMBER,
283 p_msg_data OUT NOCOPY VARCHAR2,
284 p_return_status OUT NOCOPY VARCHAR2,
285 p_attribute_application_id IN NUMBER,
286 p_attribute_code IN VARCHAR2,
287 p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
288 p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
289 p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
290 p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
291 p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
292 p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
293 p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
294 p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
295 p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296 p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
297 p_default_value_date IN DATE := FND_API.G_MISS_DATE,
298 p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
299 p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
300 p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
301 p_display_height IN NUMBER := FND_API.G_MISS_NUM,
302 p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303 p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
304 p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
305 p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
306 p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307 p_precision IN NUMBER := FND_API.G_MISS_NUM,
308 p_expansion IN NUMBER := FND_API.G_MISS_NUM,
309 p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
310 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
314 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
322 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
323 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
324 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
325 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
326 p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
327 p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
328 p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
329 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
330 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
331 p_creation_date IN DATE := FND_API.G_MISS_DATE,
332 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
333 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
334 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
335 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
336 p_pass IN NUMBER,
337 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
338 );
339
340 --=======================================================
341 -- Procedure UPLOAD_ATTRIBUTE
342 --
343 -- Usage Private API for loading attributes from a
344 -- loader file to the database.
345 -- This API should only be called by other APIs
346 -- that are owned by the Core Modules Team (AK).
347 --
348 -- Desc This API reads the attribute data stored in
349 -- the loader file currently being processed, parses
350 -- the data, and loads them to the database. The tables
351 -- are updated with the timestamp passed. This API
352 -- will process the file until the EOF is reached,
353 -- a parse error is encountered, or when data for
354 -- a different business object is read from the file.
355 --
356 -- Results The API returns the standard p_return_status parameter
357 -- indicating one of the standard return statuses :
358 -- * Unexpected error
359 -- * Error
360 -- * Success
361 -- Parameters p_index : IN OUT required
362 -- Index of PL/SQL file to be processed.
363 -- p_loader_timestamp : IN required
364 -- The timestamp to be used when creating or updating
365 -- records
366 -- p_line_num : IN optional
367 -- The first line number in the file to be processed.
368 -- It is used for keeping track of the line number
369 -- read so that this info can be included in the
370 -- error message when a parse error occurred.
371 -- p_buffer : IN required
372 -- The content of the first line to be processed.
373 -- The calling API has already read the first line
374 -- that needs to be parsed by this API, so this
375 -- line won't be read from the file again.
376 -- p_line_num_out : OUT
377 -- The number of the last line in the loader file
378 -- that is read by this API.
379 -- p_buffer_out : OUT
380 -- The content of the last line read by this API.
381 -- If an EOF has not reached, this line would
382 -- contain the beginning of another business object
383 -- that will need to be processed by another API.
384 --
385 -- Version Initial version number = 1.0
386 -- History Current version number = 1.0
387 --=======================================================
388 procedure UPLOAD_ATTRIBUTE (
389 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390 p_api_version_number IN NUMBER,
391 p_return_status OUT NOCOPY VARCHAR2,
392 p_index IN OUT NOCOPY NUMBER,
393 p_loader_timestamp IN DATE,
394 p_line_num IN NUMBER := FND_API.G_MISS_NUM,
395 p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
396 p_line_num_out OUT NOCOPY NUMBER,
397 p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
398 p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
399 p_pass IN NUMBER := 1
400 );
401
402 --=======================================================
403 -- Function VALIDATE_ATTRIBUTE
404 --
405 -- Usage Private API for validating an attribute. This
406 -- API should only be called by other APIs that are
407 -- owned by the Core Modules Team (AK).
408 --
409 -- Desc Perform validation on an attribute record.
410 --
411 -- Results The API returns the standard p_return_status parameter
415 -- * Success
412 -- indicating one of the standard return statuses :
413 -- * Unexpected error
414 -- * Error
416 -- In addition, this function returns TRUE if all
417 -- validation tests are passed, or FALSE otherwise.
418 -- Parameters Attribute columns
419 -- p_caller : IN required
420 -- Must be one of the following values defined
421 -- in package AK_ON_OBJECTS_PVT:
422 -- - G_CREATE (if calling from the Create API)
423 -- - G_DOWNLOAD (if calling from the Download API)
424 -- - G_UPDATE (if calling from the Update API)
425 --
426 -- Note This API is intended for performing record-level
427 -- validation. It is not designed for item-level
428 -- validation.
429 --
430 -- Version Initial version number = 1.0
431 -- History Current version number = 1.0
432 --=======================================================
433 function VALIDATE_ATTRIBUTE (
434 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
435 p_api_version_number IN NUMBER,
436 p_return_status OUT NOCOPY VARCHAR2,
437 p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
438 p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
439 p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
440 p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
441 p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
442 p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
443 p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
444 p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
445 p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
446 p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
447 p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448 p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
449 p_default_value_date IN DATE := FND_API.G_MISS_DATE,
450 p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
451 p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452 p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
453 p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
454 p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
455 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
456 p_caller IN VARCHAR2,
457 p_pass IN NUMBER := 2
458 ) return BOOLEAN;
459
460 --=======================================================
461 -- Procedure UPLOAD_ATTRIBUTE_SECOND
462 --
463 -- Usage Private API for loading attributes that were
464 -- failed during its first pass
465 -- This API should only be called by other APIs
466 -- that are owned by the Core Modules Team (AK).
467 --
468 -- Desc This API reads the attribute data from PL/SQL table
469 -- that was prepared during 1st pass, then processes
470 -- the data, and loads them to the database. The tables
471 -- are updated with the timestamp passed. This API
472 -- will process the file until the EOF is reached,
473 -- a parse error is encountered, or when data for
474 -- a different business object is read from the file.
475 --
476 -- Results The API returns the standard p_return_status parameter
477 -- indicating one of the standard return statuses :
478 -- * Unexpected error
479 -- * Error
480 -- * Success
481 -- Parameters p_validation_level : IN required
482 -- validation level
483 --
484 -- Version Initial version number = 1.0
485 -- History Current version number = 1.0
486 --=======================================================
487 procedure UPLOAD_ATTRIBUTE_SECOND (
488 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
489 p_return_status OUT NOCOPY VARCHAR2,
490 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
491 p_pass IN NUMBER := 2
492 );
493
494 end AK_Attribute_pvt;