33: -- Version Initial version number = 1.0
34: -- History Current version number = 1.0
35: --=======================================================
36: procedure APPEND_OBJECT_PK_TABLES (
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: p_api_version_number IN NUMBER,
39: p_return_status OUT NOCOPY VARCHAR2,
40: p_from_table IN AK_OBJECT_PUB.Object_PK_Tbl_Type,
41: p_to_table IN OUT NOCOPY AK_OBJECT_PUB.Object_PK_Tbl_Type
135: p_database_object_name IN VARCHAR2,
136: p_attribute_application_id IN NUMBER,
137: p_attribute_code IN VARCHAR2,
138: p_key_value1 IN VARCHAR2,
139: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute_application_id IN NUMBER,
137: p_attribute_code IN VARCHAR2,
138: p_key_value1 IN VARCHAR2,
139: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute_code IN VARCHAR2,
138: p_key_value1 IN VARCHAR2,
139: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_key_value1 IN VARCHAR2,
139: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR
140: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR
148: ) return BOOLEAN;
141: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR
148: ) return BOOLEAN;
149:
142: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR
148: ) return BOOLEAN;
149:
150: -- CREATE came back to here
143: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR
148: ) return BOOLEAN;
149:
150: -- CREATE came back to here
151: --
239: -- Version Initial version number = 1.0
240: -- History Current version number = 1.0
241: --=======================================================
242: procedure DELETE_ATTRIBUTE (
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: p_api_version_number IN NUMBER,
245: p_init_msg_tbl IN BOOLEAN := FALSE,
246: p_msg_count OUT NOCOPY NUMBER,
247: p_msg_data OUT NOCOPY VARCHAR2,
284: -- Version Initial version number = 1.0
285: -- History Current version number = 1.0
286: --=======================================================
287: procedure DELETE_ATTRIBUTE_NAVIGATION (
288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
289: p_api_version_number IN NUMBER,
290: p_init_msg_tbl IN BOOLEAN := FALSE,
291: p_msg_count OUT NOCOPY NUMBER,
292: p_msg_data OUT NOCOPY VARCHAR2,
330: -- Version Initial version number = 1.0
331: -- History Current version number = 1.0
332: --=======================================================
333: procedure DELETE_ATTRIBUTE_VALUE (
334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
335: p_api_version_number IN NUMBER,
336: p_init_msg_tbl IN BOOLEAN := FALSE,
337: p_msg_count OUT NOCOPY NUMBER,
338: p_msg_data OUT NOCOPY VARCHAR2,
340: p_database_object_name IN VARCHAR2,
341: p_attribute_application_id IN NUMBER,
342: p_attribute_code IN VARCHAR2,
343: p_key_value1 IN VARCHAR2,
344: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
341: p_attribute_application_id IN NUMBER,
342: p_attribute_code IN VARCHAR2,
343: p_key_value1 IN VARCHAR2,
344: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_attribute_code IN VARCHAR2,
343: p_key_value1 IN VARCHAR2,
344: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_key_value1 IN VARCHAR2,
344: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
352: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
352: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
353: p_delete_cascade IN VARCHAR2 := 'N'
346: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
352: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
353: p_delete_cascade IN VARCHAR2 := 'N'
354: );
347: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
352: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
353: p_delete_cascade IN VARCHAR2 := 'N'
354: );
355:
348: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
352: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
353: p_delete_cascade IN VARCHAR2 := 'N'
354: );
355:
356: --=======================================================
378: -- Version Initial version number = 1.0
379: -- History Current version number = 1.0
380: --=======================================================
381: procedure DELETE_OBJECT (
382: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
383: p_api_version_number IN NUMBER,
384: p_init_msg_tbl IN BOOLEAN := FALSE,
385: p_msg_count OUT NOCOPY NUMBER,
386: p_msg_data OUT NOCOPY VARCHAR2,
420: -- Version Initial version number = 1.0
421: -- History Current version number = 1.0
422: --=======================================================
423: function VALIDATE_ATTRIBUTE (
424: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
425: p_api_version_number IN NUMBER,
426: p_return_status OUT NOCOPY VARCHAR2,
427: p_database_object_name IN VARCHAR2,
428: p_attribute_application_id IN NUMBER,
426: p_return_status OUT NOCOPY VARCHAR2,
427: p_database_object_name IN VARCHAR2,
428: p_attribute_application_id IN NUMBER,
429: p_attribute_code IN VARCHAR2,
430: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_database_object_name IN VARCHAR2,
428: p_attribute_application_id IN NUMBER,
429: p_attribute_code IN VARCHAR2,
430: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
428: p_attribute_application_id IN NUMBER,
429: p_attribute_code IN VARCHAR2,
430: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_attribute_code IN VARCHAR2,
430: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
430: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_caller IN VARCHAR2,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_caller IN VARCHAR2,
457: p_pass IN NUMBER := 2
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_caller IN VARCHAR2,
457: p_pass IN NUMBER := 2
458: ) return BOOLEAN;
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_caller IN VARCHAR2,
457: p_pass IN NUMBER := 2
458: ) return BOOLEAN;
459:
489: -- Version Initial version number = 1.0
490: -- History Current version number = 1.0
491: --==========================================================
492: function VALIDATE_ATTRIBUTE_NAVIGATION (
493: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
494: p_api_version_number IN NUMBER,
495: p_return_status OUT NOCOPY VARCHAR2,
496: p_database_object_name IN VARCHAR2,
497: p_attribute_application_id IN NUMBER,
498: p_attribute_code IN VARCHAR2,
499: p_value_varchar2 IN VARCHAR2,
500: p_value_date IN DATE,
501: p_value_number IN NUMBER,
502: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
503: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
504: p_caller IN VARCHAR2,
505: p_pass IN NUMBER := 2
506: ) return BOOLEAN;
499: p_value_varchar2 IN VARCHAR2,
500: p_value_date IN DATE,
501: p_value_number IN NUMBER,
502: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
503: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
504: p_caller IN VARCHAR2,
505: p_pass IN NUMBER := 2
506: ) return BOOLEAN;
507:
536: -- Version Initial version number = 1.0
537: -- History Current version number = 1.0
538: --=======================================================
539: function VALIDATE_ATTRIBUTE_VALUE (
540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
541: p_api_version_number IN NUMBER,
542: p_return_status OUT NOCOPY VARCHAR2,
543: p_database_object_name IN VARCHAR2,
544: p_attribute_application_id IN NUMBER,
543: p_database_object_name IN VARCHAR2,
544: p_attribute_application_id IN NUMBER,
545: p_attribute_code IN VARCHAR2,
546: p_key_value1 IN VARCHAR2,
547: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
548: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
549: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
544: p_attribute_application_id IN NUMBER,
545: p_attribute_code IN VARCHAR2,
546: p_key_value1 IN VARCHAR2,
547: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
548: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
549: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
552: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
545: p_attribute_code IN VARCHAR2,
546: p_key_value1 IN VARCHAR2,
547: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
548: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
549: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
552: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
553: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
546: p_key_value1 IN VARCHAR2,
547: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
548: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
549: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
552: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
553: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
547: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
548: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
549: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
552: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
553: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
548: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
549: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
552: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
553: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
549: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
552: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
553: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
557: p_value_date IN DATE := FND_API.G_MISS_DATE,
550: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
552: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
553: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
557: p_value_date IN DATE := FND_API.G_MISS_DATE,
558: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
551: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
552: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
553: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
557: p_value_date IN DATE := FND_API.G_MISS_DATE,
558: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
559: p_caller IN VARCHAR2
552: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
553: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
557: p_value_date IN DATE := FND_API.G_MISS_DATE,
558: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
559: p_caller IN VARCHAR2
560: ) return BOOLEAN;
553: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
557: p_value_date IN DATE := FND_API.G_MISS_DATE,
558: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
559: p_caller IN VARCHAR2
560: ) return BOOLEAN;
561:
554: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
557: p_value_date IN DATE := FND_API.G_MISS_DATE,
558: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
559: p_caller IN VARCHAR2
560: ) return BOOLEAN;
561:
562: --=======================================================
590: -- Version Initial version number = 1.0
591: -- History Current version number = 1.0
592: --=======================================================
593: function VALIDATE_OBJECT (
594: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
595: p_api_version_number IN NUMBER,
596: p_return_status OUT NOCOPY VARCHAR2,
597: p_database_object_name IN VARCHAR2,
598: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
594: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
595: p_api_version_number IN NUMBER,
596: p_return_status OUT NOCOPY VARCHAR2,
597: p_database_object_name IN VARCHAR2,
598: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
599: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
601: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
602: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
595: p_api_version_number IN NUMBER,
596: p_return_status OUT NOCOPY VARCHAR2,
597: p_database_object_name IN VARCHAR2,
598: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
599: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
601: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
602: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
603: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
596: p_return_status OUT NOCOPY VARCHAR2,
597: p_database_object_name IN VARCHAR2,
598: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
599: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
601: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
602: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
603: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
604: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
597: p_database_object_name IN VARCHAR2,
598: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
599: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
601: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
602: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
603: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
604: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
605: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
598: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
599: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
601: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
602: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
603: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
604: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
605: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
606: p_caller IN VARCHAR2,
599: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
601: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
602: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
603: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
604: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
605: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
606: p_caller IN VARCHAR2,
607: p_pass IN NUMBER := 2
600: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
601: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
602: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
603: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
604: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
605: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
606: p_caller IN VARCHAR2,
607: p_pass IN NUMBER := 2
608: ) return BOOLEAN;
601: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
602: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
603: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
604: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
605: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
606: p_caller IN VARCHAR2,
607: p_pass IN NUMBER := 2
608: ) return BOOLEAN;
609:
632: -- Version Initial version number = 1.0
633: -- History Current version number = 1.0
634: --=======================================================
635: procedure CREATE_ATTRIBUTE (
636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
637: p_api_version_number IN NUMBER,
638: p_init_msg_tbl IN BOOLEAN := FALSE,
639: p_msg_count OUT NOCOPY NUMBER,
640: p_msg_data OUT NOCOPY VARCHAR2,
641: p_return_status OUT NOCOPY VARCHAR2,
642: p_database_object_name IN VARCHAR2,
643: p_attribute_application_id IN NUMBER,
644: p_attribute_code IN VARCHAR2,
645: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
646: p_attribute_label_length IN NUMBER,
647: p_display_value_length IN NUMBER,
648: p_bold IN VARCHAR2,
649: p_italic IN VARCHAR2,
649: p_italic IN VARCHAR2,
650: p_vertical_alignment IN VARCHAR2,
651: p_horizontal_alignment IN VARCHAR2,
652: p_data_source_type IN VARCHAR2,
653: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
654: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
655: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_required_flag IN VARCHAR2,
657: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
650: p_vertical_alignment IN VARCHAR2,
651: p_horizontal_alignment IN VARCHAR2,
652: p_data_source_type IN VARCHAR2,
653: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
654: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
655: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_required_flag IN VARCHAR2,
657: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
651: p_horizontal_alignment IN VARCHAR2,
652: p_data_source_type IN VARCHAR2,
653: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
654: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
655: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_required_flag IN VARCHAR2,
657: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
659: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
653: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
654: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
655: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_required_flag IN VARCHAR2,
657: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
659: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
660: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
661: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
654: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
655: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_required_flag IN VARCHAR2,
657: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
659: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
660: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
661: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
662: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
655: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_required_flag IN VARCHAR2,
657: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
659: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
660: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
661: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
662: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
663: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
656: p_required_flag IN VARCHAR2,
657: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
659: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
660: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
661: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
662: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
663: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
664: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
657: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
659: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
660: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
661: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
662: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
663: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
664: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
665: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
659: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
660: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
661: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
662: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
663: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
664: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
665: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
666: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
659: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
660: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
661: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
662: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
663: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
664: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
665: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
666: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
667: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
660: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
661: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
662: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
663: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
664: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
665: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
666: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
667: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
668: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
661: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
662: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
663: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
664: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
665: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
666: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
667: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
668: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
669: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
662: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
663: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
664: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
665: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
666: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
667: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
668: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
669: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
670: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
663: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
664: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
665: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
666: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
667: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
668: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
669: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
670: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
671: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
664: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
665: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
666: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
667: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
668: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
669: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
670: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
671: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
672: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
665: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
666: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
667: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
668: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
669: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
670: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
671: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
672: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
673: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
666: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
667: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
668: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
669: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
670: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
671: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
672: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
673: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
674: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
667: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
668: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
669: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
670: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
671: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
672: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
673: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
674: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
675: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
668: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
669: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
670: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
671: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
672: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
673: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
674: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
675: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
669: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
670: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
671: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
672: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
673: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
674: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
675: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
670: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
671: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
672: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
673: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
674: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
675: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
678: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
671: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
672: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
673: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
674: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
675: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
678: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
679: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
672: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
673: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
674: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
675: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
678: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
679: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
673: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
674: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
675: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
678: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
679: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
674: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
675: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
678: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
679: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
675: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
678: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
679: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
683: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
678: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
679: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
683: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
677: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
678: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
679: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
683: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
678: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
679: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
683: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
679: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
683: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
687: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
680: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
683: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
687: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
688: p_creation_date IN DATE := FND_API.G_MISS_DATE,
681: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
683: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
687: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
688: p_creation_date IN DATE := FND_API.G_MISS_DATE,
689: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
682: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
683: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
687: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
688: p_creation_date IN DATE := FND_API.G_MISS_DATE,
689: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
690: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
683: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
687: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
688: p_creation_date IN DATE := FND_API.G_MISS_DATE,
689: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
690: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
691: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
684: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
685: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
687: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
688: p_creation_date IN DATE := FND_API.G_MISS_DATE,
689: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
690: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
691: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
692: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
685: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
687: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
688: p_creation_date IN DATE := FND_API.G_MISS_DATE,
689: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
690: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
691: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
692: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
693: p_pass IN NUMBER,
686: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
687: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
688: p_creation_date IN DATE := FND_API.G_MISS_DATE,
689: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
690: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
691: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
692: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
693: p_pass IN NUMBER,
694: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
687: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
688: p_creation_date IN DATE := FND_API.G_MISS_DATE,
689: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
690: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
691: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
692: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
693: p_pass IN NUMBER,
694: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
695: );
688: p_creation_date IN DATE := FND_API.G_MISS_DATE,
689: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
690: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
691: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
692: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
693: p_pass IN NUMBER,
694: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
695: );
696:
719: -- Version Initial version number = 1.0
720: -- History Current version number = 1.0
721: --=======================================================
722: procedure CREATE_ATTRIBUTE_NAVIGATION (
723: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
724: p_api_version_number IN NUMBER,
725: p_init_msg_tbl IN BOOLEAN := FALSE,
726: p_msg_count OUT NOCOPY NUMBER,
727: p_msg_data OUT NOCOPY VARCHAR2,
733: p_value_date IN DATE,
734: p_value_number IN NUMBER,
735: p_to_region_appl_id IN NUMBER,
736: p_to_region_code IN VARCHAR2,
737: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
738: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
739: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
740: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
741: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
734: p_value_number IN NUMBER,
735: p_to_region_appl_id IN NUMBER,
736: p_to_region_code IN VARCHAR2,
737: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
738: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
739: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
740: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
741: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
742: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
735: p_to_region_appl_id IN NUMBER,
736: p_to_region_code IN VARCHAR2,
737: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
738: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
739: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
740: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
741: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
742: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
743: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
736: p_to_region_code IN VARCHAR2,
737: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
738: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
739: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
740: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
741: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
742: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
743: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
744: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
737: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
738: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
739: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
740: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
741: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
742: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
743: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
744: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
745: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
738: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
739: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
740: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
741: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
742: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
743: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
744: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
745: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
746: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
739: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
740: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
741: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
742: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
743: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
744: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
745: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
746: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
747: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
740: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
741: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
742: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
743: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
744: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
745: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
746: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
747: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
748: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
741: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
742: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
743: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
744: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
745: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
746: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
747: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
748: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
749: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
742: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
743: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
744: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
745: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
746: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
747: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
748: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
749: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
750: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
743: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
744: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
745: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
746: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
747: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
748: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
749: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
750: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
744: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
745: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
746: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
747: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
748: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
749: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
750: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
745: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
746: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
747: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
748: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
749: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
750: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
746: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
747: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
748: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
749: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
750: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
754: p_creation_date IN DATE := FND_API.G_MISS_DATE,
747: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
748: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
749: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
750: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
754: p_creation_date IN DATE := FND_API.G_MISS_DATE,
755: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
748: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
749: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
750: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
754: p_creation_date IN DATE := FND_API.G_MISS_DATE,
755: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
756: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
749: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
750: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
754: p_creation_date IN DATE := FND_API.G_MISS_DATE,
755: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
756: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
757: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
750: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
754: p_creation_date IN DATE := FND_API.G_MISS_DATE,
755: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
756: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
757: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
758: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
751: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
754: p_creation_date IN DATE := FND_API.G_MISS_DATE,
755: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
756: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
757: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
758: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
759: p_pass IN NUMBER,
752: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
754: p_creation_date IN DATE := FND_API.G_MISS_DATE,
755: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
756: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
757: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
758: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
759: p_pass IN NUMBER,
760: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
753: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
754: p_creation_date IN DATE := FND_API.G_MISS_DATE,
755: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
756: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
757: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
758: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
759: p_pass IN NUMBER,
760: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
761: );
754: p_creation_date IN DATE := FND_API.G_MISS_DATE,
755: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
756: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
757: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
758: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
759: p_pass IN NUMBER,
760: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
761: );
762:
785: -- Version Initial version number = 1.0
786: -- History Current version number = 1.0
787: --=======================================================
788: procedure CREATE_ATTRIBUTE_VALUE (
789: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
790: p_api_version_number IN NUMBER,
791: p_init_msg_tbl IN BOOLEAN := FALSE,
792: p_msg_count OUT NOCOPY NUMBER,
793: p_msg_data OUT NOCOPY VARCHAR2,
795: p_database_object_name IN VARCHAR2,
796: p_attribute_application_id IN NUMBER,
797: p_attribute_code IN VARCHAR2,
798: p_key_value1 IN VARCHAR2,
799: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_attribute_application_id IN NUMBER,
797: p_attribute_code IN VARCHAR2,
798: p_key_value1 IN VARCHAR2,
799: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
797: p_attribute_code IN VARCHAR2,
798: p_key_value1 IN VARCHAR2,
799: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_key_value1 IN VARCHAR2,
799: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_value_date IN DATE := FND_API.G_MISS_DATE,
802: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_value_date IN DATE := FND_API.G_MISS_DATE,
810: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
803: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_value_date IN DATE := FND_API.G_MISS_DATE,
810: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
811: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
804: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_value_date IN DATE := FND_API.G_MISS_DATE,
810: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
811: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
812: p_creation_date IN DATE := FND_API.G_MISS_DATE,
805: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_value_date IN DATE := FND_API.G_MISS_DATE,
810: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
811: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
812: p_creation_date IN DATE := FND_API.G_MISS_DATE,
813: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
806: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_value_date IN DATE := FND_API.G_MISS_DATE,
810: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
811: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
812: p_creation_date IN DATE := FND_API.G_MISS_DATE,
813: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
814: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
807: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_value_date IN DATE := FND_API.G_MISS_DATE,
810: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
811: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
812: p_creation_date IN DATE := FND_API.G_MISS_DATE,
813: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
814: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
815: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
808: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_value_date IN DATE := FND_API.G_MISS_DATE,
810: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
811: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
812: p_creation_date IN DATE := FND_API.G_MISS_DATE,
813: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
814: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
815: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
816: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
809: p_value_date IN DATE := FND_API.G_MISS_DATE,
810: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
811: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
812: p_creation_date IN DATE := FND_API.G_MISS_DATE,
813: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
814: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
815: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
816: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
817: );
810: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
811: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
812: p_creation_date IN DATE := FND_API.G_MISS_DATE,
813: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
814: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
815: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
816: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
817: );
818:
811: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
812: p_creation_date IN DATE := FND_API.G_MISS_DATE,
813: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
814: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
815: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
816: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
817: );
818:
819: --=======================================================
812: p_creation_date IN DATE := FND_API.G_MISS_DATE,
813: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
814: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
815: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
816: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
817: );
818:
819: --=======================================================
820: -- Procedure CREATE_OBJECT
841: -- Version Initial version number = 1.0
842: -- History Current version number = 1.0
843: --=======================================================
844: procedure CREATE_OBJECT (
845: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
846: p_api_version_number IN NUMBER,
847: p_init_msg_tbl IN BOOLEAN := FALSE,
848: p_msg_count OUT NOCOPY NUMBER,
849: p_msg_data OUT NOCOPY VARCHAR2,
848: p_msg_count OUT NOCOPY NUMBER,
849: p_msg_data OUT NOCOPY VARCHAR2,
850: p_return_status OUT NOCOPY VARCHAR2,
851: p_database_object_name IN VARCHAR2,
852: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
853: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
854: p_application_id IN NUMBER,
855: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
856: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
849: p_msg_data OUT NOCOPY VARCHAR2,
850: p_return_status OUT NOCOPY VARCHAR2,
851: p_database_object_name IN VARCHAR2,
852: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
853: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
854: p_application_id IN NUMBER,
855: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
856: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
857: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
851: p_database_object_name IN VARCHAR2,
852: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
853: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
854: p_application_id IN NUMBER,
855: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
856: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
857: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
858: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
859: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
852: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
853: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
854: p_application_id IN NUMBER,
855: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
856: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
857: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
858: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
859: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
860: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
853: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
854: p_application_id IN NUMBER,
855: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
856: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
857: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
858: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
859: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
860: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
861: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
854: p_application_id IN NUMBER,
855: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
856: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
857: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
858: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
859: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
860: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
861: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
862: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
855: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
856: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
857: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
858: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
859: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
860: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
861: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
862: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
863: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
856: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
857: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
858: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
859: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
860: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
861: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
862: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
863: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
857: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
858: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
859: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
860: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
861: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
862: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
863: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
858: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
859: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
860: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
861: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
862: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
863: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
859: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
860: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
861: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
862: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
863: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
860: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
861: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
862: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
863: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
861: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
862: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
863: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
862: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
863: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
863: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
869: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
877: p_creation_date IN DATE := FND_API.G_MISS_DATE,
870: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
877: p_creation_date IN DATE := FND_API.G_MISS_DATE,
878: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
871: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
877: p_creation_date IN DATE := FND_API.G_MISS_DATE,
878: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
879: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
872: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
877: p_creation_date IN DATE := FND_API.G_MISS_DATE,
878: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
879: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
880: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
873: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
877: p_creation_date IN DATE := FND_API.G_MISS_DATE,
878: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
879: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
880: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
881: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
874: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
877: p_creation_date IN DATE := FND_API.G_MISS_DATE,
878: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
879: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
880: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
881: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
882: p_pass IN NUMBER,
875: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
877: p_creation_date IN DATE := FND_API.G_MISS_DATE,
878: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
879: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
880: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
881: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
882: p_pass IN NUMBER,
883: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
876: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
877: p_creation_date IN DATE := FND_API.G_MISS_DATE,
878: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
879: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
880: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
881: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
882: p_pass IN NUMBER,
883: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
884: );
877: p_creation_date IN DATE := FND_API.G_MISS_DATE,
878: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
879: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
880: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
881: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
882: p_pass IN NUMBER,
883: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
884: );
885: