[Home] [Help]
69: p_value_date => l_navigation_rec.value_date,
70: p_value_number => l_navigation_rec.value_number,
71: p_to_region_appl_id => l_navigation_rec.to_region_appl_id,
72: p_to_region_code => l_navigation_rec.to_region_code,
73: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD )
74: then
75: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
76: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_DOWNLOADED');
77: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
87: else
88: l_databuffer_tbl(l_index) := ' ';
89: l_index := l_index + 1;
90: l_databuffer_tbl(l_index) := ' BEGIN ATTRIBUTE_NAVIGATION "' ||
91: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_navigation_rec.value_varchar2)
92: || '" "' ||
93: to_char(l_navigation_rec.value_date, AK_ON_OBJECTS_PUB.G_DATE_FORMAT)
94: || '" "' ||
95: nvl(to_char(l_navigation_rec.value_number),'') || '"';
99: (l_navigation_rec.to_region_code <> FND_API.G_MISS_CHAR)) then
100: l_index := l_index + 1;
101: l_databuffer_tbl(l_index) := ' TO_REGION = "' ||
102: nvl(to_char(l_navigation_rec.to_region_appl_id),'')||'" "'||
103: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_navigation_rec.to_region_code)
104: || '"';
105: end if;
106: -- Flex Fields
107: --
108: if ((l_navigation_rec.attribute_category IS NOT NULL) and
109: (l_navigation_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
110: l_index := l_index + 1;
111: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
112: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
113: l_navigation_rec.attribute_category) || '"';
114: end if;
115: if ((l_navigation_rec.attribute1 IS NOT NULL) and
116: (l_navigation_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
115: if ((l_navigation_rec.attribute1 IS NOT NULL) and
116: (l_navigation_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
117: l_index := l_index + 1;
118: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
119: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
120: l_navigation_rec.attribute1) || '"';
121: end if;
122: if ((l_navigation_rec.attribute2 IS NOT NULL) and
123: (l_navigation_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
122: if ((l_navigation_rec.attribute2 IS NOT NULL) and
123: (l_navigation_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
124: l_index := l_index + 1;
125: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
126: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
127: l_navigation_rec.attribute2) || '"';
128: end if;
129: if ((l_navigation_rec.attribute3 IS NOT NULL) and
130: (l_navigation_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
129: if ((l_navigation_rec.attribute3 IS NOT NULL) and
130: (l_navigation_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
131: l_index := l_index + 1;
132: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
133: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
134: l_navigation_rec.attribute3) || '"';
135: end if;
136: if ((l_navigation_rec.attribute4 IS NOT NULL) and
137: (l_navigation_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
136: if ((l_navigation_rec.attribute4 IS NOT NULL) and
137: (l_navigation_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
138: l_index := l_index + 1;
139: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
140: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
141: l_navigation_rec.attribute4) || '"';
142: end if;
143: if ((l_navigation_rec.attribute5 IS NOT NULL) and
144: (l_navigation_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
143: if ((l_navigation_rec.attribute5 IS NOT NULL) and
144: (l_navigation_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
145: l_index := l_index + 1;
146: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
147: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
148: l_navigation_rec.attribute5) || '"';
149: end if;
150: if ((l_navigation_rec.attribute6 IS NOT NULL) and
151: (l_navigation_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
150: if ((l_navigation_rec.attribute6 IS NOT NULL) and
151: (l_navigation_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
152: l_index := l_index + 1;
153: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
154: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
155: l_navigation_rec.attribute6) || '"';
156: end if;
157: if ((l_navigation_rec.attribute7 IS NOT NULL) and
158: (l_navigation_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
157: if ((l_navigation_rec.attribute7 IS NOT NULL) and
158: (l_navigation_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
159: l_index := l_index + 1;
160: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
161: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
162: l_navigation_rec.attribute7) || '"';
163: end if;
164: if ((l_navigation_rec.attribute8 IS NOT NULL) and
165: (l_navigation_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
164: if ((l_navigation_rec.attribute8 IS NOT NULL) and
165: (l_navigation_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
166: l_index := l_index + 1;
167: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
168: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
169: l_navigation_rec.attribute8) || '"';
170: end if;
171: if ((l_navigation_rec.attribute9 IS NOT NULL) and
172: (l_navigation_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
171: if ((l_navigation_rec.attribute9 IS NOT NULL) and
172: (l_navigation_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
173: l_index := l_index + 1;
174: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
175: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
176: l_navigation_rec.attribute9) || '"';
177: end if;
178: if ((l_navigation_rec.attribute10 IS NOT NULL) and
179: (l_navigation_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
178: if ((l_navigation_rec.attribute10 IS NOT NULL) and
179: (l_navigation_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
180: l_index := l_index + 1;
181: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
182: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
183: l_navigation_rec.attribute10) || '"';
184: end if;
185: if ((l_navigation_rec.attribute11 IS NOT NULL) and
186: (l_navigation_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
185: if ((l_navigation_rec.attribute11 IS NOT NULL) and
186: (l_navigation_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
187: l_index := l_index + 1;
188: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
189: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
190: l_navigation_rec.attribute11) || '"';
191: end if;
192: if ((l_navigation_rec.attribute12 IS NOT NULL) and
193: (l_navigation_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
192: if ((l_navigation_rec.attribute12 IS NOT NULL) and
193: (l_navigation_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
194: l_index := l_index + 1;
195: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
196: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
197: l_navigation_rec.attribute12) || '"';
198: end if;
199: if ((l_navigation_rec.attribute13 IS NOT NULL) and
200: (l_navigation_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
199: if ((l_navigation_rec.attribute13 IS NOT NULL) and
200: (l_navigation_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
201: l_index := l_index + 1;
202: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
203: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
204: l_navigation_rec.attribute13) || '"';
205: end if;
206: if ((l_navigation_rec.attribute14 IS NOT NULL) and
207: (l_navigation_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
206: if ((l_navigation_rec.attribute14 IS NOT NULL) and
207: (l_navigation_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
208: l_index := l_index + 1;
209: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
210: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
211: l_navigation_rec.attribute14) || '"';
212: end if;
213: if ((l_navigation_rec.attribute15 IS NOT NULL) and
214: (l_navigation_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
213: if ((l_navigation_rec.attribute15 IS NOT NULL) and
214: (l_navigation_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
215: l_index := l_index + 1;
216: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
217: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
218: l_navigation_rec.attribute15) || '"';
219: end if;
220: -- - Write out who columns
221: l_index := l_index + 1;
251:
252: -- write attribute navigation data to file
253: -- don't call write_file if there is no data to be written
254: if (l_databuffer_tbl.count > 0) then
255: AK_ON_OBJECTS_PVT.WRITE_FILE (
256: p_return_status => l_return_status,
257: p_buffer_tbl => l_databuffer_tbl,
258: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
259: );
390: p_validation_api_pkg => l_attributes_rec.validation_api_pkg,
391: p_validation_api_proc => l_attributes_rec.validation_api_proc,
392: p_attribute_label_long => l_attributes_tl_rec.attribute_label_long,
393: p_attribute_label_short=>l_attributes_tl_rec.attribute_label_short,
394: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
395: then
396: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
397: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_DOWNLOADED');
398: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
408: l_databuffer_tbl(l_index) := ' ';
409: l_index := l_index + 1;
410: l_databuffer_tbl(l_index) := ' BEGIN OBJECT_ATTRIBUTE "' ||
411: l_attributes_rec.attribute_application_id || '" "' ||
412: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_attributes_rec.attribute_code)
413: || '"';
414: --
415: -- check if all non-required columns are null or not, do not write out
416: -- those that are null
418: if ((l_attributes_rec.column_name IS NOT NULL) and
419: (l_attributes_rec.column_name <> FND_API.G_MISS_CHAR)) then
420: l_index := l_index + 1;
421: l_databuffer_tbl(l_index) := ' COLUMN_NAME = "' ||
422: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_attributes_rec.column_name)
423: || '"';
424: end if;
425: l_index := l_index + 1;
426: l_databuffer_tbl(l_index) := ' ATTRIBUTE_LABEL_LENGTH = "' ||
429: l_databuffer_tbl(l_index) := ' DISPLAY_VALUE_LENGTH = "' ||
430: nvl(to_char(l_attributes_rec.display_value_length),'') || '"';
431: l_index := l_index + 1;
432: l_databuffer_tbl(l_index) := ' BOLD = "' ||
433: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_attributes_rec.bold) || '"';
434: l_index := l_index + 1;
435: l_databuffer_tbl(l_index) := ' ITALIC = "' ||
436: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_attributes_rec.italic) || '"';
437: l_index := l_index + 1;
432: l_databuffer_tbl(l_index) := ' BOLD = "' ||
433: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_attributes_rec.bold) || '"';
434: l_index := l_index + 1;
435: l_databuffer_tbl(l_index) := ' ITALIC = "' ||
436: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_attributes_rec.italic) || '"';
437: l_index := l_index + 1;
438: l_databuffer_tbl(l_index) := ' VERTICAL_ALIGNMENT = "' ||
439: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
440: l_attributes_rec.vertical_alignment)|| '"';
435: l_databuffer_tbl(l_index) := ' ITALIC = "' ||
436: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_attributes_rec.italic) || '"';
437: l_index := l_index + 1;
438: l_databuffer_tbl(l_index) := ' VERTICAL_ALIGNMENT = "' ||
439: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
440: l_attributes_rec.vertical_alignment)|| '"';
441: l_index := l_index + 1;
442: l_databuffer_tbl(l_index) := ' HORIZONTAL_ALIGNMENT = "' ||
443: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
439: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
440: l_attributes_rec.vertical_alignment)|| '"';
441: l_index := l_index + 1;
442: l_databuffer_tbl(l_index) := ' HORIZONTAL_ALIGNMENT = "' ||
443: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
444: l_attributes_rec.horizontal_alignment)|| '"';
445: l_index := l_index + 1;
446: l_databuffer_tbl(l_index) := ' DATA_SOURCE_TYPE = "' ||
447: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
443: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
444: l_attributes_rec.horizontal_alignment)|| '"';
445: l_index := l_index + 1;
446: l_databuffer_tbl(l_index) := ' DATA_SOURCE_TYPE = "' ||
447: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
448: l_attributes_rec.data_source_type)|| '"';
449: l_index := l_index + 1;
450: if ((l_attributes_rec.data_storage_type IS NOT NULL) and
451: (l_attributes_rec.data_storage_type <> FND_API.G_MISS_CHAR)) then
449: l_index := l_index + 1;
450: if ((l_attributes_rec.data_storage_type IS NOT NULL) and
451: (l_attributes_rec.data_storage_type <> FND_API.G_MISS_CHAR)) then
452: l_databuffer_tbl(l_index) := ' DATA_STORAGE_TYPE = "' ||
453: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
454: l_attributes_rec.data_storage_type)|| '"';
455: end if;
456: if ((l_attributes_rec.table_name IS NOT NULL) and
457: (l_attributes_rec.table_name <> FND_API.G_MISS_CHAR)) then
456: if ((l_attributes_rec.table_name IS NOT NULL) and
457: (l_attributes_rec.table_name <> FND_API.G_MISS_CHAR)) then
458: l_index := l_index + 1;
459: l_databuffer_tbl(l_index) := ' TABLE_NAME = "' ||
460: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
461: l_attributes_rec.table_name)|| '"';
462: end if;
463: if ((l_attributes_rec.base_table_column_name IS NOT NULL) and
464: (l_attributes_rec.base_table_column_name <> FND_API.G_MISS_CHAR)) then
463: if ((l_attributes_rec.base_table_column_name IS NOT NULL) and
464: (l_attributes_rec.base_table_column_name <> FND_API.G_MISS_CHAR)) then
465: l_index := l_index + 1;
466: l_databuffer_tbl(l_index) := ' BASE_TABLE_COLUMN_NAME = "' ||
467: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
468: l_attributes_rec.base_table_column_name)|| '"';
469: end if;
470: l_index := l_index + 1;
471: l_databuffer_tbl(l_index) := ' REQUIRED_FLAG = "' ||
468: l_attributes_rec.base_table_column_name)|| '"';
469: end if;
470: l_index := l_index + 1;
471: l_databuffer_tbl(l_index) := ' REQUIRED_FLAG = "' ||
472: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
473: l_attributes_rec.required_flag)|| '"';
474: if ((l_attributes_rec.default_value_varchar2 IS NOT NULL) and
475: (l_attributes_rec.default_value_varchar2 <> FND_API.G_MISS_CHAR)) then
476: l_index := l_index + 1;
474: if ((l_attributes_rec.default_value_varchar2 IS NOT NULL) and
475: (l_attributes_rec.default_value_varchar2 <> FND_API.G_MISS_CHAR)) then
476: l_index := l_index + 1;
477: l_databuffer_tbl(l_index) := ' DEFAULT_VALUE_VARCHAR2 = "' ||
478: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
479: l_attributes_rec.default_value_varchar2) || '"';
480: end if;
481: if ((l_attributes_rec.default_value_number IS NOT NULL) and
482: (l_attributes_rec.default_value_number <> FND_API.G_MISS_NUM)) then
497: if ((l_attributes_rec.attribute_category IS NOT NULL) and
498: (l_attributes_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
499: l_index := l_index + 1;
500: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
501: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
502: l_attributes_rec.attribute_category) || '"';
503: end if;
504: if ((l_attributes_rec.attribute1 IS NOT NULL) and
505: (l_attributes_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
504: if ((l_attributes_rec.attribute1 IS NOT NULL) and
505: (l_attributes_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
506: l_index := l_index + 1;
507: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
508: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
509: l_attributes_rec.attribute1) || '"';
510: end if;
511: if ((l_attributes_rec.attribute2 IS NOT NULL) and
512: (l_attributes_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
511: if ((l_attributes_rec.attribute2 IS NOT NULL) and
512: (l_attributes_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
513: l_index := l_index + 1;
514: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
515: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
516: l_attributes_rec.attribute2) || '"';
517: end if;
518: if ((l_attributes_rec.attribute3 IS NOT NULL) and
519: (l_attributes_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
518: if ((l_attributes_rec.attribute3 IS NOT NULL) and
519: (l_attributes_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
520: l_index := l_index + 1;
521: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
522: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
523: l_attributes_rec.attribute3) || '"';
524: end if;
525: if ((l_attributes_rec.attribute4 IS NOT NULL) and
526: (l_attributes_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
525: if ((l_attributes_rec.attribute4 IS NOT NULL) and
526: (l_attributes_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
527: l_index := l_index + 1;
528: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
529: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
530: l_attributes_rec.attribute4) || '"';
531: end if;
532: if ((l_attributes_rec.attribute5 IS NOT NULL) and
533: (l_attributes_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
532: if ((l_attributes_rec.attribute5 IS NOT NULL) and
533: (l_attributes_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
534: l_index := l_index + 1;
535: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
536: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
537: l_attributes_rec.attribute5) || '"';
538: end if;
539: if ((l_attributes_rec.attribute6 IS NOT NULL) and
540: (l_attributes_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
539: if ((l_attributes_rec.attribute6 IS NOT NULL) and
540: (l_attributes_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
541: l_index := l_index + 1;
542: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
543: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
544: l_attributes_rec.attribute6) || '"';
545: end if;
546: if ((l_attributes_rec.attribute7 IS NOT NULL) and
547: (l_attributes_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
546: if ((l_attributes_rec.attribute7 IS NOT NULL) and
547: (l_attributes_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
548: l_index := l_index + 1;
549: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
550: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
551: l_attributes_rec.attribute7) || '"';
552: end if;
553: if ((l_attributes_rec.attribute8 IS NOT NULL) and
554: (l_attributes_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
553: if ((l_attributes_rec.attribute8 IS NOT NULL) and
554: (l_attributes_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
555: l_index := l_index + 1;
556: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
557: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
558: l_attributes_rec.attribute8) || '"';
559: end if;
560: if ((l_attributes_rec.attribute9 IS NOT NULL) and
561: (l_attributes_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
560: if ((l_attributes_rec.attribute9 IS NOT NULL) and
561: (l_attributes_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
562: l_index := l_index + 1;
563: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
564: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
565: l_attributes_rec.attribute9) || '"';
566: end if;
567: if ((l_attributes_rec.attribute10 IS NOT NULL) and
568: (l_attributes_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
567: if ((l_attributes_rec.attribute10 IS NOT NULL) and
568: (l_attributes_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
569: l_index := l_index + 1;
570: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
571: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
572: l_attributes_rec.attribute10) || '"';
573: end if;
574: if ((l_attributes_rec.attribute11 IS NOT NULL) and
575: (l_attributes_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
574: if ((l_attributes_rec.attribute11 IS NOT NULL) and
575: (l_attributes_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
576: l_index := l_index + 1;
577: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
578: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
579: l_attributes_rec.attribute11) || '"';
580: end if;
581: if ((l_attributes_rec.attribute12 IS NOT NULL) and
582: (l_attributes_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
581: if ((l_attributes_rec.attribute12 IS NOT NULL) and
582: (l_attributes_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
583: l_index := l_index + 1;
584: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
585: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
586: l_attributes_rec.attribute12) || '"';
587: end if;
588: if ((l_attributes_rec.attribute13 IS NOT NULL) and
589: (l_attributes_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
588: if ((l_attributes_rec.attribute13 IS NOT NULL) and
589: (l_attributes_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
590: l_index := l_index + 1;
591: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
592: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
593: l_attributes_rec.attribute13) || '"';
594: end if;
595: if ((l_attributes_rec.attribute14 IS NOT NULL) and
596: (l_attributes_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
595: if ((l_attributes_rec.attribute14 IS NOT NULL) and
596: (l_attributes_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
597: l_index := l_index + 1;
598: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
599: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
600: l_attributes_rec.attribute14) || '"';
601: end if;
602: if ((l_attributes_rec.attribute15 IS NOT NULL) and
603: (l_attributes_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
602: if ((l_attributes_rec.attribute15 IS NOT NULL) and
603: (l_attributes_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
604: l_index := l_index + 1;
605: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
606: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
607: l_attributes_rec.attribute15) || '"';
608: end if;
609: -- - Write out who columns
610: l_index := l_index + 1;
636: (l_attributes_rec.lov_region_code <> FND_API.G_MISS_CHAR)) then
637: l_index := l_index + 1;
638: l_databuffer_tbl(l_index) := ' LOV_REGION = "' ||
639: nvl(to_char(l_attributes_rec.lov_region_application_id),'')||'" "'||
640: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
641: l_attributes_rec.lov_region_code)|| '"';
642: end if;
643: if ((l_attributes_rec.lov_foreign_key_name IS NOT NULL) and
644: (l_attributes_rec.lov_foreign_key_name <> FND_API.G_MISS_CHAR)) then
643: if ((l_attributes_rec.lov_foreign_key_name IS NOT NULL) and
644: (l_attributes_rec.lov_foreign_key_name <> FND_API.G_MISS_CHAR)) then
645: l_index := l_index + 1;
646: l_databuffer_tbl(l_index) := ' LOV_FOREIGN_KEY_NAME = "' ||
647: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
648: l_attributes_rec.lov_foreign_key_name)|| '"';
649: end if;
650: if ((l_attributes_rec.lov_attribute_application_id IS NOT NULL) and
651: (l_attributes_rec.lov_attribute_application_id <> FND_API.G_MISS_NUM) and
653: (l_attributes_rec.lov_attribute_code <> FND_API.G_MISS_CHAR)) then
654: l_index := l_index + 1;
655: l_databuffer_tbl(l_index) := ' LOV_ATTRIBUTE = "' ||
656: nvl(to_char(l_attributes_rec.lov_attribute_application_id),'')||'" "'||
657: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
658: l_attributes_rec.lov_attribute_code)|| '"';
659: end if;
660: if ((l_attributes_rec.base_table_column_name IS NOT NULL) and
661: (l_attributes_rec.base_table_column_name <> FND_API.G_MISS_CHAR)) then
660: if ((l_attributes_rec.base_table_column_name IS NOT NULL) and
661: (l_attributes_rec.base_table_column_name <> FND_API.G_MISS_CHAR)) then
662: l_index := l_index + 1;
663: l_databuffer_tbl(l_index) := ' DEFAULTING_API_PKG = "' ||
664: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
665: l_attributes_rec.defaulting_api_pkg)|| '"';
666: end if;
667: if ((l_attributes_rec.defaulting_api_proc IS NOT NULL) and
668: (l_attributes_rec.defaulting_api_proc <> FND_API.G_MISS_CHAR)) then
667: if ((l_attributes_rec.defaulting_api_proc IS NOT NULL) and
668: (l_attributes_rec.defaulting_api_proc <> FND_API.G_MISS_CHAR)) then
669: l_index := l_index + 1;
670: l_databuffer_tbl(l_index) := ' DEFAULTING_API_PROC = "' ||
671: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
672: l_attributes_rec.defaulting_api_proc)|| '"';
673: end if;
674: if ((l_attributes_rec.validation_api_pkg IS NOT NULL) and
675: (l_attributes_rec.validation_api_pkg <> FND_API.G_MISS_CHAR)) then
674: if ((l_attributes_rec.validation_api_pkg IS NOT NULL) and
675: (l_attributes_rec.validation_api_pkg <> FND_API.G_MISS_CHAR)) then
676: l_index := l_index + 1;
677: l_databuffer_tbl(l_index) := ' VALIDATION_API_PKG = "' ||
678: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
679: l_attributes_rec.validation_api_pkg)|| '"';
680: end if;
681: if ((l_attributes_rec.validation_api_proc IS NOT NULL) and
682: (l_attributes_rec.validation_api_proc <> FND_API.G_MISS_CHAR)) then
681: if ((l_attributes_rec.validation_api_proc IS NOT NULL) and
682: (l_attributes_rec.validation_api_proc <> FND_API.G_MISS_CHAR)) then
683: l_index := l_index + 1;
684: l_databuffer_tbl(l_index) := ' VALIDATION_API_PROC = "' ||
685: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
686: l_attributes_rec.validation_api_proc)|| '"';
687: end if;
688:
689: -- TL table entries
690: if ((l_attributes_tl_rec.attribute_label_long IS NOT NULL) and
691: (l_attributes_tl_rec.attribute_label_long <> FND_API.G_MISS_CHAR)) then
692: l_index := l_index + 1;
693: l_databuffer_tbl(l_index) := ' ATTRIBUTE_LABEL_LONG = "' ||
694: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
695: l_attributes_tl_rec.attribute_label_long)||'"';
696: end if;
697: if ((l_attributes_tl_rec.attribute_label_short IS NOT NULL) and
698: (l_attributes_tl_rec.attribute_label_short <> FND_API.G_MISS_CHAR)) then
697: if ((l_attributes_tl_rec.attribute_label_short IS NOT NULL) and
698: (l_attributes_tl_rec.attribute_label_short <> FND_API.G_MISS_CHAR)) then
699: l_index := l_index + 1;
700: l_databuffer_tbl(l_index) := ' ATTRIBUTE_LABEL_SHORT = "' ||
701: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
702: l_attributes_tl_rec.attribute_label_short)||'"';
703: end if;
704:
705: -- write object attribute data to file
702: l_attributes_tl_rec.attribute_label_short)||'"';
703: end if;
704:
705: -- write object attribute data to file
706: AK_ON_OBJECTS_PVT.WRITE_FILE (
707: p_return_status => l_return_status,
708: p_buffer_tbl => l_databuffer_tbl,
709: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
710: );
740: l_databuffer_tbl(l_index) := ' ';
741: end if; -- validation OK
742:
743: -- write object attribute ending lines to file
744: AK_ON_OBJECTS_PVT.WRITE_FILE (
745: p_return_status => l_return_status,
746: p_buffer_tbl => l_databuffer_tbl,
747: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
748: );
862: p_from_to_name => l_foreign_keys_tl_rec.from_to_name,
863: p_from_to_description => l_foreign_keys_tl_rec.from_to_description,
864: p_to_from_name => l_foreign_keys_tl_rec.to_from_name,
865: p_to_from_description => l_foreign_keys_tl_rec.to_from_description,
866: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD )
867: then
868: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
869: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_DOWNLOADED');
870: FND_MESSAGE.SET_TOKEN('KEY', l_foreign_keys_rec.foreign_key_name);
873: else
874: l_databuffer_tbl(l_index) := ' ';
875: l_index := l_index + 1;
876: l_databuffer_tbl(l_index) := ' BEGIN FOREIGN_KEY "' ||
877: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_foreign_keys_rec.foreign_key_name)|| '"';
878: l_index := l_index + 1;
879: l_databuffer_tbl(l_index) := ' UNIQUE_KEY_NAME = "' ||
880: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_foreign_keys_rec.unique_key_name)|| '"';
881: l_index := l_index + 1;
876: l_databuffer_tbl(l_index) := ' BEGIN FOREIGN_KEY "' ||
877: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_foreign_keys_rec.foreign_key_name)|| '"';
878: l_index := l_index + 1;
879: l_databuffer_tbl(l_index) := ' UNIQUE_KEY_NAME = "' ||
880: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_foreign_keys_rec.unique_key_name)|| '"';
881: l_index := l_index + 1;
882: l_databuffer_tbl(l_index) := ' APPLICATION_ID = "' ||
883: nvl(to_char(l_foreign_keys_rec.application_id),'') || '"';
884: -- Flex Fields
886: if ((l_foreign_keys_rec.attribute_category IS NOT NULL) and
887: (l_foreign_keys_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
888: l_index := l_index + 1;
889: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
890: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
891: l_foreign_keys_rec.attribute_category) || '"';
892: end if;
893: if ((l_foreign_keys_rec.attribute1 IS NOT NULL) and
894: (l_foreign_keys_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
893: if ((l_foreign_keys_rec.attribute1 IS NOT NULL) and
894: (l_foreign_keys_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
895: l_index := l_index + 1;
896: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
897: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
898: l_foreign_keys_rec.attribute1) || '"';
899: end if;
900: if ((l_foreign_keys_rec.attribute2 IS NOT NULL) and
901: (l_foreign_keys_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
900: if ((l_foreign_keys_rec.attribute2 IS NOT NULL) and
901: (l_foreign_keys_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
902: l_index := l_index + 1;
903: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
904: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
905: l_foreign_keys_rec.attribute2) || '"';
906: end if;
907: if ((l_foreign_keys_rec.attribute3 IS NOT NULL) and
908: (l_foreign_keys_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
907: if ((l_foreign_keys_rec.attribute3 IS NOT NULL) and
908: (l_foreign_keys_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
909: l_index := l_index + 1;
910: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
911: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
912: l_foreign_keys_rec.attribute3) || '"';
913: end if;
914: if ((l_foreign_keys_rec.attribute4 IS NOT NULL) and
915: (l_foreign_keys_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
914: if ((l_foreign_keys_rec.attribute4 IS NOT NULL) and
915: (l_foreign_keys_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
916: l_index := l_index + 1;
917: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
918: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
919: l_foreign_keys_rec.attribute4) || '"';
920: end if;
921: if ((l_foreign_keys_rec.attribute5 IS NOT NULL) and
922: (l_foreign_keys_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
921: if ((l_foreign_keys_rec.attribute5 IS NOT NULL) and
922: (l_foreign_keys_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
923: l_index := l_index + 1;
924: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
925: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
926: l_foreign_keys_rec.attribute5) || '"';
927: end if;
928: if ((l_foreign_keys_rec.attribute6 IS NOT NULL) and
929: (l_foreign_keys_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
928: if ((l_foreign_keys_rec.attribute6 IS NOT NULL) and
929: (l_foreign_keys_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
930: l_index := l_index + 1;
931: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
932: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
933: l_foreign_keys_rec.attribute6) || '"';
934: end if;
935: if ((l_foreign_keys_rec.attribute7 IS NOT NULL) and
936: (l_foreign_keys_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
935: if ((l_foreign_keys_rec.attribute7 IS NOT NULL) and
936: (l_foreign_keys_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
937: l_index := l_index + 1;
938: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
939: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
940: l_foreign_keys_rec.attribute7) || '"';
941: end if;
942: if ((l_foreign_keys_rec.attribute8 IS NOT NULL) and
943: (l_foreign_keys_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
942: if ((l_foreign_keys_rec.attribute8 IS NOT NULL) and
943: (l_foreign_keys_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
944: l_index := l_index + 1;
945: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
946: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
947: l_foreign_keys_rec.attribute8) || '"';
948: end if;
949: if ((l_foreign_keys_rec.attribute9 IS NOT NULL) and
950: (l_foreign_keys_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
949: if ((l_foreign_keys_rec.attribute9 IS NOT NULL) and
950: (l_foreign_keys_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
951: l_index := l_index + 1;
952: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
953: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
954: l_foreign_keys_rec.attribute9) || '"';
955: end if;
956: if ((l_foreign_keys_rec.attribute10 IS NOT NULL) and
957: (l_foreign_keys_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
956: if ((l_foreign_keys_rec.attribute10 IS NOT NULL) and
957: (l_foreign_keys_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
958: l_index := l_index + 1;
959: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
960: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
961: l_foreign_keys_rec.attribute10) || '"';
962: end if;
963: if ((l_foreign_keys_rec.attribute11 IS NOT NULL) and
964: (l_foreign_keys_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
963: if ((l_foreign_keys_rec.attribute11 IS NOT NULL) and
964: (l_foreign_keys_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
965: l_index := l_index + 1;
966: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
967: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
968: l_foreign_keys_rec.attribute11) || '"';
969: end if;
970: if ((l_foreign_keys_rec.attribute12 IS NOT NULL) and
971: (l_foreign_keys_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
970: if ((l_foreign_keys_rec.attribute12 IS NOT NULL) and
971: (l_foreign_keys_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
972: l_index := l_index + 1;
973: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
974: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
975: l_foreign_keys_rec.attribute12) || '"';
976: end if;
977: if ((l_foreign_keys_rec.attribute13 IS NOT NULL) and
978: (l_foreign_keys_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
977: if ((l_foreign_keys_rec.attribute13 IS NOT NULL) and
978: (l_foreign_keys_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
979: l_index := l_index + 1;
980: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
981: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
982: l_foreign_keys_rec.attribute13) || '"';
983: end if;
984: if ((l_foreign_keys_rec.attribute14 IS NOT NULL) and
985: (l_foreign_keys_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
984: if ((l_foreign_keys_rec.attribute14 IS NOT NULL) and
985: (l_foreign_keys_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
986: l_index := l_index + 1;
987: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
988: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
989: l_foreign_keys_rec.attribute14) || '"';
990: end if;
991: if ((l_foreign_keys_rec.attribute15 IS NOT NULL) and
992: (l_foreign_keys_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
991: if ((l_foreign_keys_rec.attribute15 IS NOT NULL) and
992: (l_foreign_keys_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
993: l_index := l_index + 1;
994: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
995: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
996: l_foreign_keys_rec.attribute15) || '"';
997: end if;
998: -- - Write out who columns
999: l_index := l_index + 1;
1021: if ((l_foreign_keys_tl_rec.from_to_name IS NOT NULL) and
1022: (l_foreign_keys_tl_rec.from_to_name <> FND_API.G_MISS_CHAR)) then
1023: l_index := l_index + 1;
1024: l_databuffer_tbl(l_index) := ' FROM_TO_NAME = "' ||
1025: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_foreign_keys_tl_rec.from_to_name)|| '"';
1026: end if;
1027: if ((l_foreign_keys_tl_rec.from_to_description IS NOT NULL) and
1028: (l_foreign_keys_tl_rec.from_to_description <> FND_API.G_MISS_CHAR)) then
1029: l_index := l_index + 1;
1027: if ((l_foreign_keys_tl_rec.from_to_description IS NOT NULL) and
1028: (l_foreign_keys_tl_rec.from_to_description <> FND_API.G_MISS_CHAR)) then
1029: l_index := l_index + 1;
1030: l_databuffer_tbl(l_index) := ' FROM_TO_DESCRIPTION = "' ||
1031: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_foreign_keys_tl_rec.from_to_description)|| '"';
1032: end if;
1033: if ((l_foreign_keys_tl_rec.to_from_name IS NOT NULL) and
1034: (l_foreign_keys_tl_rec.to_from_name <> FND_API.G_MISS_CHAR)) then
1035: l_index := l_index + 1;
1033: if ((l_foreign_keys_tl_rec.to_from_name IS NOT NULL) and
1034: (l_foreign_keys_tl_rec.to_from_name <> FND_API.G_MISS_CHAR)) then
1035: l_index := l_index + 1;
1036: l_databuffer_tbl(l_index) := ' TO_FROM_NAME = "' ||
1037: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_foreign_keys_tl_rec.to_from_name)|| '"';
1038: end if;
1039: if ((l_foreign_keys_tl_rec.to_from_description IS NOT NULL) and
1040: (l_foreign_keys_tl_rec.to_from_description <> FND_API.G_MISS_CHAR)) then
1041: l_index := l_index + 1;
1039: if ((l_foreign_keys_tl_rec.to_from_description IS NOT NULL) and
1040: (l_foreign_keys_tl_rec.to_from_description <> FND_API.G_MISS_CHAR)) then
1041: l_index := l_index + 1;
1042: l_databuffer_tbl(l_index) := ' TO_FROM_DESCRIPTION = "' ||
1043: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_foreign_keys_tl_rec.to_from_description)|| '"';
1044: end if;
1045:
1046: -- Foreign Key columns
1047: open l_get_key_columns_csr(l_foreign_keys_rec.foreign_key_name);
1058: p_attribute_application_id =>
1059: l_key_columns_rec.attribute_application_id,
1060: p_attribute_code => l_key_columns_rec.attribute_code,
1061: p_foreign_key_sequence => l_key_columns_rec.foreign_key_sequence,
1062: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD )
1063: then
1064: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1065: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_DOWNLOADED');
1066: FND_MESSAGE.SET_TOKEN('KEY', l_key_columns_rec.foreign_key_name ||
1077: l_index := l_index + 1;
1078: l_databuffer_tbl(l_index) := ' BEGIN FOREIGN_KEY_COLUMN "' ||
1079: nvl(to_char(l_key_columns_rec.attribute_application_id),'') ||
1080: '" "' ||
1081: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1082: l_key_columns_rec.attribute_code) || '"';
1083: l_index := l_index + 1;
1084: l_databuffer_tbl(l_index) := ' FOREIGN_KEY_SEQUENCE = "' ||
1085: nvl(to_char(l_key_columns_rec.foreign_key_sequence),'') || '"';
1088: if ((l_key_columns_rec.attribute_category IS NOT NULL) and
1089: (l_key_columns_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
1090: l_index := l_index + 1;
1091: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
1092: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1093: l_key_columns_rec.attribute_category) || '"';
1094: end if;
1095: if ((l_key_columns_rec.attribute1 IS NOT NULL) and
1096: (l_key_columns_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
1095: if ((l_key_columns_rec.attribute1 IS NOT NULL) and
1096: (l_key_columns_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
1097: l_index := l_index + 1;
1098: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
1099: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1100: l_key_columns_rec.attribute1) || '"';
1101: end if;
1102: if ((l_key_columns_rec.attribute2 IS NOT NULL) and
1103: (l_key_columns_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
1102: if ((l_key_columns_rec.attribute2 IS NOT NULL) and
1103: (l_key_columns_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
1104: l_index := l_index + 1;
1105: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
1106: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1107: l_key_columns_rec.attribute2) || '"';
1108: end if;
1109: if ((l_key_columns_rec.attribute3 IS NOT NULL) and
1110: (l_key_columns_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
1109: if ((l_key_columns_rec.attribute3 IS NOT NULL) and
1110: (l_key_columns_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
1111: l_index := l_index + 1;
1112: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
1113: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1114: l_key_columns_rec.attribute3) || '"';
1115: end if;
1116: if ((l_key_columns_rec.attribute4 IS NOT NULL) and
1117: (l_key_columns_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
1116: if ((l_key_columns_rec.attribute4 IS NOT NULL) and
1117: (l_key_columns_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
1118: l_index := l_index + 1;
1119: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
1120: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1121: l_key_columns_rec.attribute4) || '"';
1122: end if;
1123: if ((l_key_columns_rec.attribute5 IS NOT NULL) and
1124: (l_key_columns_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
1123: if ((l_key_columns_rec.attribute5 IS NOT NULL) and
1124: (l_key_columns_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
1125: l_index := l_index + 1;
1126: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
1127: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1128: l_key_columns_rec.attribute5) || '"';
1129: end if;
1130: if ((l_key_columns_rec.attribute6 IS NOT NULL) and
1131: (l_key_columns_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
1130: if ((l_key_columns_rec.attribute6 IS NOT NULL) and
1131: (l_key_columns_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
1132: l_index := l_index + 1;
1133: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
1134: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1135: l_key_columns_rec.attribute6) || '"';
1136: end if;
1137: if ((l_key_columns_rec.attribute7 IS NOT NULL) and
1138: (l_key_columns_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
1137: if ((l_key_columns_rec.attribute7 IS NOT NULL) and
1138: (l_key_columns_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
1139: l_index := l_index + 1;
1140: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
1141: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1142: l_key_columns_rec.attribute7) || '"';
1143: end if;
1144: if ((l_key_columns_rec.attribute8 IS NOT NULL) and
1145: (l_key_columns_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
1144: if ((l_key_columns_rec.attribute8 IS NOT NULL) and
1145: (l_key_columns_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
1146: l_index := l_index + 1;
1147: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
1148: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1149: l_key_columns_rec.attribute8) || '"';
1150: end if;
1151: if ((l_key_columns_rec.attribute9 IS NOT NULL) and
1152: (l_key_columns_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
1151: if ((l_key_columns_rec.attribute9 IS NOT NULL) and
1152: (l_key_columns_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
1153: l_index := l_index + 1;
1154: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
1155: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1156: l_key_columns_rec.attribute9) || '"';
1157: end if;
1158: if ((l_key_columns_rec.attribute10 IS NOT NULL) and
1159: (l_key_columns_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
1158: if ((l_key_columns_rec.attribute10 IS NOT NULL) and
1159: (l_key_columns_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
1160: l_index := l_index + 1;
1161: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
1162: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1163: l_key_columns_rec.attribute10) || '"';
1164: end if;
1165: if ((l_key_columns_rec.attribute11 IS NOT NULL) and
1166: (l_key_columns_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
1165: if ((l_key_columns_rec.attribute11 IS NOT NULL) and
1166: (l_key_columns_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
1167: l_index := l_index + 1;
1168: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
1169: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1170: l_key_columns_rec.attribute11) || '"';
1171: end if;
1172: if ((l_key_columns_rec.attribute12 IS NOT NULL) and
1173: (l_key_columns_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
1172: if ((l_key_columns_rec.attribute12 IS NOT NULL) and
1173: (l_key_columns_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
1174: l_index := l_index + 1;
1175: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
1176: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1177: l_key_columns_rec.attribute12) || '"';
1178: end if;
1179: if ((l_key_columns_rec.attribute13 IS NOT NULL) and
1180: (l_key_columns_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
1179: if ((l_key_columns_rec.attribute13 IS NOT NULL) and
1180: (l_key_columns_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
1181: l_index := l_index + 1;
1182: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
1183: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1184: l_key_columns_rec.attribute13) || '"';
1185: end if;
1186: if ((l_key_columns_rec.attribute14 IS NOT NULL) and
1187: (l_key_columns_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
1186: if ((l_key_columns_rec.attribute14 IS NOT NULL) and
1187: (l_key_columns_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
1188: l_index := l_index + 1;
1189: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
1190: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1191: l_key_columns_rec.attribute14) || '"';
1192: end if;
1193: if ((l_key_columns_rec.attribute15 IS NOT NULL) and
1194: (l_key_columns_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
1193: if ((l_key_columns_rec.attribute15 IS NOT NULL) and
1194: (l_key_columns_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
1195: l_index := l_index + 1;
1196: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
1197: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1198: l_key_columns_rec.attribute15) || '"';
1199: end if;
1200: -- - Write out who columns
1201: l_index := l_index + 1;
1241:
1242: -- - Write foreign key data out to the specified file
1243: -- don't call write_file if there is no data to be written
1244: if (l_databuffer_tbl.count > 0) then
1245: AK_ON_OBJECTS_PVT.WRITE_FILE (
1246: p_return_status => l_return_status,
1247: p_buffer_tbl => l_databuffer_tbl,
1248: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1249: );
1365: p_return_status => l_return_status,
1366: p_unique_key_name => l_unique_keys_rec.unique_key_name,
1367: p_database_object_name => l_unique_keys_rec.database_object_name,
1368: p_application_id => l_unique_keys_rec.application_id,
1369: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD )
1370: then
1371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1372: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_DOWNLOADED');
1373: FND_MESSAGE.SET_TOKEN('KEY', l_unique_keys_rec.unique_key_name);
1376: else
1377: l_databuffer_tbl(l_index) := ' ';
1378: l_index := l_index + 1;
1379: l_databuffer_tbl(l_index) := ' BEGIN UNIQUE_KEY "' ||
1380: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_unique_keys_rec.unique_key_name)|| '"';
1381: l_index := l_index + 1;
1382: l_databuffer_tbl(l_index) := ' APPLICATION_ID = "' ||
1383: nvl(to_char(l_unique_keys_rec.application_id),'') || '"';
1384: -- Flex Fields
1386: if ((l_unique_keys_rec.attribute_category IS NOT NULL) and
1387: (l_unique_keys_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
1388: l_index := l_index + 1;
1389: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
1390: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1391: l_unique_keys_rec.attribute_category) || '"';
1392: end if;
1393: if ((l_unique_keys_rec.attribute1 IS NOT NULL) and
1394: (l_unique_keys_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
1393: if ((l_unique_keys_rec.attribute1 IS NOT NULL) and
1394: (l_unique_keys_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
1395: l_index := l_index + 1;
1396: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
1397: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1398: l_unique_keys_rec.attribute1) || '"';
1399: end if;
1400: if ((l_unique_keys_rec.attribute2 IS NOT NULL) and
1401: (l_unique_keys_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
1400: if ((l_unique_keys_rec.attribute2 IS NOT NULL) and
1401: (l_unique_keys_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
1402: l_index := l_index + 1;
1403: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
1404: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1405: l_unique_keys_rec.attribute2) || '"';
1406: end if;
1407: if ((l_unique_keys_rec.attribute3 IS NOT NULL) and
1408: (l_unique_keys_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
1407: if ((l_unique_keys_rec.attribute3 IS NOT NULL) and
1408: (l_unique_keys_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
1409: l_index := l_index + 1;
1410: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
1411: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1412: l_unique_keys_rec.attribute3) || '"';
1413: end if;
1414: if ((l_unique_keys_rec.attribute4 IS NOT NULL) and
1415: (l_unique_keys_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
1414: if ((l_unique_keys_rec.attribute4 IS NOT NULL) and
1415: (l_unique_keys_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
1416: l_index := l_index + 1;
1417: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
1418: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1419: l_unique_keys_rec.attribute4) || '"';
1420: end if;
1421: if ((l_unique_keys_rec.attribute5 IS NOT NULL) and
1422: (l_unique_keys_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
1421: if ((l_unique_keys_rec.attribute5 IS NOT NULL) and
1422: (l_unique_keys_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
1423: l_index := l_index + 1;
1424: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
1425: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1426: l_unique_keys_rec.attribute5) || '"';
1427: end if;
1428: if ((l_unique_keys_rec.attribute6 IS NOT NULL) and
1429: (l_unique_keys_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
1428: if ((l_unique_keys_rec.attribute6 IS NOT NULL) and
1429: (l_unique_keys_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
1430: l_index := l_index + 1;
1431: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
1432: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1433: l_unique_keys_rec.attribute6) || '"';
1434: end if;
1435: if ((l_unique_keys_rec.attribute7 IS NOT NULL) and
1436: (l_unique_keys_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
1435: if ((l_unique_keys_rec.attribute7 IS NOT NULL) and
1436: (l_unique_keys_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
1437: l_index := l_index + 1;
1438: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
1439: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1440: l_unique_keys_rec.attribute7) || '"';
1441: end if;
1442: if ((l_unique_keys_rec.attribute8 IS NOT NULL) and
1443: (l_unique_keys_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
1442: if ((l_unique_keys_rec.attribute8 IS NOT NULL) and
1443: (l_unique_keys_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
1444: l_index := l_index + 1;
1445: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
1446: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1447: l_unique_keys_rec.attribute8) || '"';
1448: end if;
1449: if ((l_unique_keys_rec.attribute9 IS NOT NULL) and
1450: (l_unique_keys_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
1449: if ((l_unique_keys_rec.attribute9 IS NOT NULL) and
1450: (l_unique_keys_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
1451: l_index := l_index + 1;
1452: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
1453: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1454: l_unique_keys_rec.attribute9) || '"';
1455: end if;
1456: if ((l_unique_keys_rec.attribute10 IS NOT NULL) and
1457: (l_unique_keys_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
1456: if ((l_unique_keys_rec.attribute10 IS NOT NULL) and
1457: (l_unique_keys_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
1458: l_index := l_index + 1;
1459: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
1460: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1461: l_unique_keys_rec.attribute10) || '"';
1462: end if;
1463: if ((l_unique_keys_rec.attribute11 IS NOT NULL) and
1464: (l_unique_keys_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
1463: if ((l_unique_keys_rec.attribute11 IS NOT NULL) and
1464: (l_unique_keys_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
1465: l_index := l_index + 1;
1466: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
1467: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1468: l_unique_keys_rec.attribute11) || '"';
1469: end if;
1470: if ((l_unique_keys_rec.attribute12 IS NOT NULL) and
1471: (l_unique_keys_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
1470: if ((l_unique_keys_rec.attribute12 IS NOT NULL) and
1471: (l_unique_keys_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
1472: l_index := l_index + 1;
1473: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
1474: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1475: l_unique_keys_rec.attribute12) || '"';
1476: end if;
1477: if ((l_unique_keys_rec.attribute13 IS NOT NULL) and
1478: (l_unique_keys_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
1477: if ((l_unique_keys_rec.attribute13 IS NOT NULL) and
1478: (l_unique_keys_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
1479: l_index := l_index + 1;
1480: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
1481: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1482: l_unique_keys_rec.attribute13) || '"';
1483: end if;
1484: if ((l_unique_keys_rec.attribute14 IS NOT NULL) and
1485: (l_unique_keys_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
1484: if ((l_unique_keys_rec.attribute14 IS NOT NULL) and
1485: (l_unique_keys_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
1486: l_index := l_index + 1;
1487: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
1488: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1489: l_unique_keys_rec.attribute14) || '"';
1490: end if;
1491: if ((l_unique_keys_rec.attribute15 IS NOT NULL) and
1492: (l_unique_keys_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
1491: if ((l_unique_keys_rec.attribute15 IS NOT NULL) and
1492: (l_unique_keys_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
1493: l_index := l_index + 1;
1494: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
1495: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1496: l_unique_keys_rec.attribute15) || '"';
1497: end if;
1498: -- - Write out who columns
1499: l_index := l_index + 1;
1532: p_attribute_application_id =>
1533: l_key_columns_rec.attribute_application_id,
1534: p_attribute_code => l_key_columns_rec.attribute_code,
1535: p_unique_key_sequence => l_key_columns_rec.unique_key_sequence,
1536: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD )
1537: then
1538: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1539: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_DOWNLOADED');
1540: FND_MESSAGE.SET_TOKEN('KEY', l_key_columns_rec.unique_key_name ||
1550: l_index := l_index + 1;
1551: l_databuffer_tbl(l_index) := ' BEGIN UNIQUE_KEY_COLUMN "' ||
1552: nvl(to_char(l_key_columns_rec.attribute_application_id),'') ||
1553: '" "' ||
1554: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1555: l_key_columns_rec.attribute_code) || '"';
1556: l_index := l_index + 1;
1557: l_databuffer_tbl(l_index) := ' UNIQUE_KEY_SEQUENCE = "' ||
1558: nvl(to_char(l_key_columns_rec.unique_key_sequence),'') || '"';
1561: if ((l_key_columns_rec.attribute_category IS NOT NULL) and
1562: (l_key_columns_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
1563: l_index := l_index + 1;
1564: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
1565: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1566: l_key_columns_rec.attribute_category) || '"';
1567: end if;
1568: if ((l_key_columns_rec.attribute1 IS NOT NULL) and
1569: (l_key_columns_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
1568: if ((l_key_columns_rec.attribute1 IS NOT NULL) and
1569: (l_key_columns_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
1570: l_index := l_index + 1;
1571: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
1572: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1573: l_key_columns_rec.attribute1) || '"';
1574: end if;
1575: if ((l_key_columns_rec.attribute2 IS NOT NULL) and
1576: (l_key_columns_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
1575: if ((l_key_columns_rec.attribute2 IS NOT NULL) and
1576: (l_key_columns_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
1577: l_index := l_index + 1;
1578: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
1579: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1580: l_key_columns_rec.attribute2) || '"';
1581: end if;
1582: if ((l_key_columns_rec.attribute3 IS NOT NULL) and
1583: (l_key_columns_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
1582: if ((l_key_columns_rec.attribute3 IS NOT NULL) and
1583: (l_key_columns_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
1584: l_index := l_index + 1;
1585: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
1586: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1587: l_key_columns_rec.attribute3) || '"';
1588: end if;
1589: if ((l_key_columns_rec.attribute4 IS NOT NULL) and
1590: (l_key_columns_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
1589: if ((l_key_columns_rec.attribute4 IS NOT NULL) and
1590: (l_key_columns_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
1591: l_index := l_index + 1;
1592: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
1593: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1594: l_key_columns_rec.attribute4) || '"';
1595: end if;
1596: if ((l_key_columns_rec.attribute5 IS NOT NULL) and
1597: (l_key_columns_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
1596: if ((l_key_columns_rec.attribute5 IS NOT NULL) and
1597: (l_key_columns_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
1598: l_index := l_index + 1;
1599: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
1600: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1601: l_key_columns_rec.attribute5) || '"';
1602: end if;
1603: if ((l_key_columns_rec.attribute6 IS NOT NULL) and
1604: (l_key_columns_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
1603: if ((l_key_columns_rec.attribute6 IS NOT NULL) and
1604: (l_key_columns_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
1605: l_index := l_index + 1;
1606: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
1607: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1608: l_key_columns_rec.attribute6) || '"';
1609: end if;
1610: if ((l_key_columns_rec.attribute7 IS NOT NULL) and
1611: (l_key_columns_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
1610: if ((l_key_columns_rec.attribute7 IS NOT NULL) and
1611: (l_key_columns_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
1612: l_index := l_index + 1;
1613: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
1614: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1615: l_key_columns_rec.attribute7) || '"';
1616: end if;
1617: if ((l_key_columns_rec.attribute8 IS NOT NULL) and
1618: (l_key_columns_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
1617: if ((l_key_columns_rec.attribute8 IS NOT NULL) and
1618: (l_key_columns_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
1619: l_index := l_index + 1;
1620: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
1621: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1622: l_key_columns_rec.attribute8) || '"';
1623: end if;
1624: if ((l_key_columns_rec.attribute9 IS NOT NULL) and
1625: (l_key_columns_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
1624: if ((l_key_columns_rec.attribute9 IS NOT NULL) and
1625: (l_key_columns_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
1626: l_index := l_index + 1;
1627: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
1628: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1629: l_key_columns_rec.attribute9) || '"';
1630: end if;
1631: if ((l_key_columns_rec.attribute10 IS NOT NULL) and
1632: (l_key_columns_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
1631: if ((l_key_columns_rec.attribute10 IS NOT NULL) and
1632: (l_key_columns_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
1633: l_index := l_index + 1;
1634: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
1635: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1636: l_key_columns_rec.attribute10) || '"';
1637: end if;
1638: if ((l_key_columns_rec.attribute11 IS NOT NULL) and
1639: (l_key_columns_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
1638: if ((l_key_columns_rec.attribute11 IS NOT NULL) and
1639: (l_key_columns_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
1640: l_index := l_index + 1;
1641: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
1642: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1643: l_key_columns_rec.attribute11) || '"';
1644: end if;
1645: if ((l_key_columns_rec.attribute12 IS NOT NULL) and
1646: (l_key_columns_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
1645: if ((l_key_columns_rec.attribute12 IS NOT NULL) and
1646: (l_key_columns_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
1647: l_index := l_index + 1;
1648: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
1649: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1650: l_key_columns_rec.attribute12) || '"';
1651: end if;
1652: if ((l_key_columns_rec.attribute13 IS NOT NULL) and
1653: (l_key_columns_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
1652: if ((l_key_columns_rec.attribute13 IS NOT NULL) and
1653: (l_key_columns_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
1654: l_index := l_index + 1;
1655: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
1656: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1657: l_key_columns_rec.attribute13) || '"';
1658: end if;
1659: if ((l_key_columns_rec.attribute14 IS NOT NULL) and
1660: (l_key_columns_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
1659: if ((l_key_columns_rec.attribute14 IS NOT NULL) and
1660: (l_key_columns_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
1661: l_index := l_index + 1;
1662: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
1663: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1664: l_key_columns_rec.attribute14) || '"';
1665: end if;
1666: if ((l_key_columns_rec.attribute15 IS NOT NULL) and
1667: (l_key_columns_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
1666: if ((l_key_columns_rec.attribute15 IS NOT NULL) and
1667: (l_key_columns_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
1668: l_index := l_index + 1;
1669: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
1670: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1671: l_key_columns_rec.attribute15) || '"';
1672: end if;
1673: -- - Write out who columns
1674: l_index := l_index + 1;
1710:
1711: -- - Write unique key data out to the specified file
1712: -- don't call write_file if there is no data to be written
1713: if (l_databuffer_tbl.count > 0) then
1714: AK_ON_OBJECTS_PVT.WRITE_FILE (
1715: p_return_status => l_return_status,
1716: p_buffer_tbl => l_databuffer_tbl,
1717: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1718: );
1832: p_defaulting_api_pkg => l_objects_rec.defaulting_api_pkg,
1833: p_defaulting_api_proc => l_objects_rec.defaulting_api_proc,
1834: p_validation_api_pkg => l_objects_rec.validation_api_pkg,
1835: p_validation_api_proc => l_objects_rec.validation_api_proc,
1836: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1837: then
1838: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1839: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
1840: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
1849: -- Write object into buffer
1850: l_index := 1;
1851:
1852: l_databuffer_tbl(l_index) := 'BEGIN OBJECT "' ||
1853: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_objects_rec.database_object_name) || '"';
1854: l_index := l_index + 1;
1855: l_databuffer_tbl(l_index) := ' APPLICATION_ID = "' ||
1856: nvl(to_char(l_objects_rec.application_id),'') || '"';
1857: if ((l_objects_rec.primary_key_name IS NOT NULL) and
1857: if ((l_objects_rec.primary_key_name IS NOT NULL) and
1858: (l_objects_rec.primary_key_name <> FND_API.G_MISS_CHAR)) then
1859: l_index := l_index + 1;
1860: l_databuffer_tbl(l_index) := ' PRIMARY_KEY_NAME = "' ||
1861: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_objects_rec.primary_key_name) ||
1862: '"';
1863: end if;
1864: if ((l_objects_rec.defaulting_api_pkg IS NOT NULL) and
1865: (l_objects_rec.defaulting_api_pkg <> FND_API.G_MISS_CHAR)) then
1864: if ((l_objects_rec.defaulting_api_pkg IS NOT NULL) and
1865: (l_objects_rec.defaulting_api_pkg <> FND_API.G_MISS_CHAR)) then
1866: l_index := l_index + 1;
1867: l_databuffer_tbl(l_index) := ' DEFAULTING_API_PKG = "' ||
1868: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_objects_rec.defaulting_api_pkg)
1869: || '"';
1870: end if;
1871: if ((l_objects_rec.defaulting_api_proc IS NOT NULL) and
1872: (l_objects_rec.defaulting_api_proc <> FND_API.G_MISS_CHAR)) then
1871: if ((l_objects_rec.defaulting_api_proc IS NOT NULL) and
1872: (l_objects_rec.defaulting_api_proc <> FND_API.G_MISS_CHAR)) then
1873: l_index := l_index + 1;
1874: l_databuffer_tbl(l_index) := ' DEFAULTING_API_PROC = "' ||
1875: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_objects_rec.defaulting_api_proc)
1876: || '"';
1877: end if;
1878: if ((l_objects_rec.validation_api_pkg IS NOT NULL) and
1879: (l_objects_rec.validation_api_pkg <> FND_API.G_MISS_CHAR)) then
1878: if ((l_objects_rec.validation_api_pkg IS NOT NULL) and
1879: (l_objects_rec.validation_api_pkg <> FND_API.G_MISS_CHAR)) then
1880: l_index := l_index + 1;
1881: l_databuffer_tbl(l_index) := ' VALIDATION_API_PKG = "' ||
1882: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_objects_rec.validation_api_pkg)
1883: || '"';
1884: end if;
1885: if ((l_objects_rec.validation_api_proc IS NOT NULL) and
1886: (l_objects_rec.validation_api_proc <> FND_API.G_MISS_CHAR)) then
1885: if ((l_objects_rec.validation_api_proc IS NOT NULL) and
1886: (l_objects_rec.validation_api_proc <> FND_API.G_MISS_CHAR)) then
1887: l_index := l_index + 1;
1888: l_databuffer_tbl(l_index) := ' VALIDATION_API_PROC = "' ||
1889: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_objects_rec.validation_api_proc)
1890: || '"';
1891: end if;
1892: -- Flex Fields
1893: --
1894: if ((l_objects_rec.attribute_category IS NOT NULL) and
1895: (l_objects_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
1896: l_index := l_index + 1;
1897: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
1898: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1899: l_objects_rec.attribute_category) || '"';
1900: end if;
1901: if ((l_objects_rec.attribute1 IS NOT NULL) and
1902: (l_objects_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
1901: if ((l_objects_rec.attribute1 IS NOT NULL) and
1902: (l_objects_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
1903: l_index := l_index + 1;
1904: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
1905: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1906: l_objects_rec.attribute1) || '"';
1907: end if;
1908: if ((l_objects_rec.attribute2 IS NOT NULL) and
1909: (l_objects_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
1908: if ((l_objects_rec.attribute2 IS NOT NULL) and
1909: (l_objects_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
1910: l_index := l_index + 1;
1911: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
1912: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1913: l_objects_rec.attribute2) || '"';
1914: end if;
1915: if ((l_objects_rec.attribute3 IS NOT NULL) and
1916: (l_objects_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
1915: if ((l_objects_rec.attribute3 IS NOT NULL) and
1916: (l_objects_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
1917: l_index := l_index + 1;
1918: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
1919: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1920: l_objects_rec.attribute3) || '"';
1921: end if;
1922: if ((l_objects_rec.attribute4 IS NOT NULL) and
1923: (l_objects_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
1922: if ((l_objects_rec.attribute4 IS NOT NULL) and
1923: (l_objects_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
1924: l_index := l_index + 1;
1925: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
1926: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1927: l_objects_rec.attribute4) || '"';
1928: end if;
1929: if ((l_objects_rec.attribute5 IS NOT NULL) and
1930: (l_objects_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
1929: if ((l_objects_rec.attribute5 IS NOT NULL) and
1930: (l_objects_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
1931: l_index := l_index + 1;
1932: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
1933: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1934: l_objects_rec.attribute5) || '"';
1935: end if;
1936: if ((l_objects_rec.attribute6 IS NOT NULL) and
1937: (l_objects_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
1936: if ((l_objects_rec.attribute6 IS NOT NULL) and
1937: (l_objects_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
1938: l_index := l_index + 1;
1939: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
1940: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1941: l_objects_rec.attribute6) || '"';
1942: end if;
1943: if ((l_objects_rec.attribute7 IS NOT NULL) and
1944: (l_objects_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
1943: if ((l_objects_rec.attribute7 IS NOT NULL) and
1944: (l_objects_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
1945: l_index := l_index + 1;
1946: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
1947: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1948: l_objects_rec.attribute7) || '"';
1949: end if;
1950: if ((l_objects_rec.attribute8 IS NOT NULL) and
1951: (l_objects_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
1950: if ((l_objects_rec.attribute8 IS NOT NULL) and
1951: (l_objects_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
1952: l_index := l_index + 1;
1953: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
1954: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1955: l_objects_rec.attribute8) || '"';
1956: end if;
1957: if ((l_objects_rec.attribute9 IS NOT NULL) and
1958: (l_objects_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
1957: if ((l_objects_rec.attribute9 IS NOT NULL) and
1958: (l_objects_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
1959: l_index := l_index + 1;
1960: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
1961: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1962: l_objects_rec.attribute9) || '"';
1963: end if;
1964: if ((l_objects_rec.attribute10 IS NOT NULL) and
1965: (l_objects_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
1964: if ((l_objects_rec.attribute10 IS NOT NULL) and
1965: (l_objects_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
1966: l_index := l_index + 1;
1967: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
1968: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1969: l_objects_rec.attribute10) || '"';
1970: end if;
1971: if ((l_objects_rec.attribute11 IS NOT NULL) and
1972: (l_objects_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
1971: if ((l_objects_rec.attribute11 IS NOT NULL) and
1972: (l_objects_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
1973: l_index := l_index + 1;
1974: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
1975: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1976: l_objects_rec.attribute11) || '"';
1977: end if;
1978: if ((l_objects_rec.attribute12 IS NOT NULL) and
1979: (l_objects_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
1978: if ((l_objects_rec.attribute12 IS NOT NULL) and
1979: (l_objects_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
1980: l_index := l_index + 1;
1981: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
1982: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1983: l_objects_rec.attribute12) || '"';
1984: end if;
1985: if ((l_objects_rec.attribute13 IS NOT NULL) and
1986: (l_objects_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
1985: if ((l_objects_rec.attribute13 IS NOT NULL) and
1986: (l_objects_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
1987: l_index := l_index + 1;
1988: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
1989: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1990: l_objects_rec.attribute13) || '"';
1991: end if;
1992: if ((l_objects_rec.attribute14 IS NOT NULL) and
1993: (l_objects_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
1992: if ((l_objects_rec.attribute14 IS NOT NULL) and
1993: (l_objects_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
1994: l_index := l_index + 1;
1995: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
1996: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1997: l_objects_rec.attribute14) || '"';
1998: end if;
1999: if ((l_objects_rec.attribute15 IS NOT NULL) and
2000: (l_objects_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
1999: if ((l_objects_rec.attribute15 IS NOT NULL) and
2000: (l_objects_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
2001: l_index := l_index + 1;
2002: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
2003: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2004: l_objects_rec.attribute15) || '"';
2005: end if;
2006: -- - Write out who columns
2007: l_index := l_index + 1;
2030: if ((l_objects_tl_rec.name IS NOT NULL) and
2031: (l_objects_tl_rec.name <> FND_API.G_MISS_CHAR)) then
2032: l_index := l_index + 1;
2033: l_databuffer_tbl(l_index) := ' NAME = "' ||
2034: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_objects_tl_rec.name) || '"';
2035: end if;
2036: if ((l_objects_tl_rec.description IS NOT NULL) and
2037: (l_objects_tl_rec.description <> FND_API.G_MISS_CHAR)) then
2038: l_index := l_index + 1;
2036: if ((l_objects_tl_rec.description IS NOT NULL) and
2037: (l_objects_tl_rec.description <> FND_API.G_MISS_CHAR)) then
2038: l_index := l_index + 1;
2039: l_databuffer_tbl(l_index) := ' DESCRIPTION = "' ||
2040: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_objects_tl_rec.description) ||
2041: '"';
2042: end if;
2043:
2044: -- - Write object data out to the specified file
2041: '"';
2042: end if;
2043:
2044: -- - Write object data out to the specified file
2045: AK_ON_OBJECTS_PVT.WRITE_FILE (
2046: p_return_status => l_return_status,
2047: p_buffer_tbl => l_databuffer_tbl,
2048: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
2049: );
2092: l_index := l_index + 1;
2093: l_databuffer_tbl(l_index) := ' ';
2094:
2095: -- - Finish up writing object data out to the specified file
2096: AK_ON_OBJECTS_PVT.WRITE_FILE (
2097: p_return_status => l_return_status,
2098: p_buffer_tbl => l_databuffer_tbl,
2099: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
2100: );