eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_FLOW2_PVT dependencies on AK_ON_OBJECTS_PVT

Line 86: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)

82: p_to_page_appl_id => l_items_rec.to_page_appl_id,
83: p_to_page_code => l_items_rec.to_page_code,
84: p_to_url_attribute_appl_id => l_items_rec.to_url_attribute_appl_id,
85: p_to_url_attribute_code => l_items_rec.to_url_attribute_code,
86: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
87: then
88: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
89: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_NOT_DOWNLOADED');
90: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

Line 107: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.attribute_code)

103: l_databuffer_tbl(l_index) := ' ';
104: l_index := l_index + 1;
105: l_databuffer_tbl(l_index) := ' BEGIN FLOW_PAGE_REGION_ITEM "' ||
106: nvl(to_char(l_items_rec.attribute_application_id),'') || '" "' ||
107: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.attribute_code)
108: || '"';
109: if ((l_items_rec.to_page_appl_id IS NOT NULL) and
110: (l_items_rec.to_page_appl_id <> FND_API.G_MISS_NUM) and
111: (l_items_rec.to_page_code IS NOT NULL) and

Line 116: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.to_page_code)

112: (l_items_rec.to_page_code <> FND_API.G_MISS_CHAR)) then
113: l_index := l_index + 1;
114: l_databuffer_tbl(l_index) := ' TO_PAGE = "' ||
115: nvl(to_char(l_items_rec.to_page_appl_id),'')||'" "'||
116: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.to_page_code)
117: || '"';
118: end if;
119: if (l_items_rec.to_url_attribute_appl_id IS NOT NULL) and
120: (l_items_rec.to_url_attribute_appl_id <> FND_API.G_MISS_NUM) and

Line 126: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

122: (l_items_rec.to_url_attribute_code <> FND_API.G_MISS_CHAR) then
123: l_index := l_index + 1;
124: l_databuffer_tbl(l_index) := ' TO_URL_ATTRIBUTE = "' ||
125: nvl(to_char(l_items_rec.to_url_attribute_appl_id),'')||'" "'||
126: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
127: l_items_rec.to_url_attribute_code)|| '"';
128: end if;
129: -- Flex Fields
130: --

Line 135: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

131: if ((l_items_rec.attribute_category IS NOT NULL) and
132: (l_items_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
133: l_index := l_index + 1;
134: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
135: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
136: l_items_rec.attribute_category) || '"';
137: end if;
138: if ((l_items_rec.attribute1 IS NOT NULL) and
139: (l_items_rec.attribute1 <> FND_API.G_MISS_CHAR)) then

Line 142: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

138: if ((l_items_rec.attribute1 IS NOT NULL) and
139: (l_items_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
140: l_index := l_index + 1;
141: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
142: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
143: l_items_rec.attribute1) || '"';
144: end if;
145: if ((l_items_rec.attribute2 IS NOT NULL) and
146: (l_items_rec.attribute2 <> FND_API.G_MISS_CHAR)) then

Line 149: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

145: if ((l_items_rec.attribute2 IS NOT NULL) and
146: (l_items_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
147: l_index := l_index + 1;
148: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
149: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
150: l_items_rec.attribute2) || '"';
151: end if;
152: if ((l_items_rec.attribute3 IS NOT NULL) and
153: (l_items_rec.attribute3 <> FND_API.G_MISS_CHAR)) then

Line 156: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

152: if ((l_items_rec.attribute3 IS NOT NULL) and
153: (l_items_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
154: l_index := l_index + 1;
155: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
156: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
157: l_items_rec.attribute3) || '"';
158: end if;
159: if ((l_items_rec.attribute4 IS NOT NULL) and
160: (l_items_rec.attribute4 <> FND_API.G_MISS_CHAR)) then

Line 163: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

159: if ((l_items_rec.attribute4 IS NOT NULL) and
160: (l_items_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
161: l_index := l_index + 1;
162: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
163: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
164: l_items_rec.attribute4) || '"';
165: end if;
166: if ((l_items_rec.attribute5 IS NOT NULL) and
167: (l_items_rec.attribute5 <> FND_API.G_MISS_CHAR)) then

Line 170: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

166: if ((l_items_rec.attribute5 IS NOT NULL) and
167: (l_items_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
168: l_index := l_index + 1;
169: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
170: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
171: l_items_rec.attribute5) || '"';
172: end if;
173: if ((l_items_rec.attribute6 IS NOT NULL) and
174: (l_items_rec.attribute6 <> FND_API.G_MISS_CHAR)) then

Line 177: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

173: if ((l_items_rec.attribute6 IS NOT NULL) and
174: (l_items_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
175: l_index := l_index + 1;
176: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
177: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
178: l_items_rec.attribute6) || '"';
179: end if;
180: if ((l_items_rec.attribute7 IS NOT NULL) and
181: (l_items_rec.attribute7 <> FND_API.G_MISS_CHAR)) then

Line 184: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

180: if ((l_items_rec.attribute7 IS NOT NULL) and
181: (l_items_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
182: l_index := l_index + 1;
183: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
184: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
185: l_items_rec.attribute7) || '"';
186: end if;
187: if ((l_items_rec.attribute8 IS NOT NULL) and
188: (l_items_rec.attribute8 <> FND_API.G_MISS_CHAR)) then

Line 191: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

187: if ((l_items_rec.attribute8 IS NOT NULL) and
188: (l_items_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
189: l_index := l_index + 1;
190: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
191: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
192: l_items_rec.attribute8) || '"';
193: end if;
194: if ((l_items_rec.attribute9 IS NOT NULL) and
195: (l_items_rec.attribute9 <> FND_API.G_MISS_CHAR)) then

Line 198: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

194: if ((l_items_rec.attribute9 IS NOT NULL) and
195: (l_items_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
196: l_index := l_index + 1;
197: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
198: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
199: l_items_rec.attribute9) || '"';
200: end if;
201: if ((l_items_rec.attribute10 IS NOT NULL) and
202: (l_items_rec.attribute10 <> FND_API.G_MISS_CHAR)) then

Line 205: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

201: if ((l_items_rec.attribute10 IS NOT NULL) and
202: (l_items_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
203: l_index := l_index + 1;
204: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
205: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
206: l_items_rec.attribute10) || '"';
207: end if;
208: if ((l_items_rec.attribute11 IS NOT NULL) and
209: (l_items_rec.attribute11 <> FND_API.G_MISS_CHAR)) then

Line 212: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

208: if ((l_items_rec.attribute11 IS NOT NULL) and
209: (l_items_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
210: l_index := l_index + 1;
211: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
212: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
213: l_items_rec.attribute11) || '"';
214: end if;
215: if ((l_items_rec.attribute12 IS NOT NULL) and
216: (l_items_rec.attribute12 <> FND_API.G_MISS_CHAR)) then

Line 219: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

215: if ((l_items_rec.attribute12 IS NOT NULL) and
216: (l_items_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
217: l_index := l_index + 1;
218: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
219: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
220: l_items_rec.attribute12) || '"';
221: end if;
222: if ((l_items_rec.attribute13 IS NOT NULL) and
223: (l_items_rec.attribute13 <> FND_API.G_MISS_CHAR)) then

Line 226: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

222: if ((l_items_rec.attribute13 IS NOT NULL) and
223: (l_items_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
224: l_index := l_index + 1;
225: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
226: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
227: l_items_rec.attribute13) || '"';
228: end if;
229: if ((l_items_rec.attribute14 IS NOT NULL) and
230: (l_items_rec.attribute14 <> FND_API.G_MISS_CHAR)) then

Line 233: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

229: if ((l_items_rec.attribute14 IS NOT NULL) and
230: (l_items_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
231: l_index := l_index + 1;
232: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
233: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
234: l_items_rec.attribute14) || '"';
235: end if;
236: if ((l_items_rec.attribute15 IS NOT NULL) and
237: (l_items_rec.attribute15 <> FND_API.G_MISS_CHAR)) then

Line 240: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

236: if ((l_items_rec.attribute15 IS NOT NULL) and
237: (l_items_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
238: l_index := l_index + 1;
239: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
240: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
241: l_items_rec.attribute15) || '"';
242: end if;
243: -- - Write out who columns
244: l_index := l_index + 1;

Line 280: AK_ON_OBJECTS_PVT.WRITE_FILE (

276:
277: -- - Write page region item data out to the specified file
278: -- don't call write_file if there is no data to be written
279: if (l_databuffer_tbl.count > 0) then
280: AK_ON_OBJECTS_PVT.WRITE_FILE (
281: p_return_status => l_return_status,
282: p_buffer_tbl => l_databuffer_tbl,
283: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
284: );

Line 431: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)

427: p_parent_region_application_id =>
428: l_regions_rec.parent_region_application_id,
429: p_parent_region_code => l_regions_rec.parent_region_code,
430: p_foreign_key_name => l_foreign_key_name,
431: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
432: then
433: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
434: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_NOT_DOWNLOADED');
435: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

Line 450: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.region_code)

446: l_databuffer_tbl(l_index) := ' ';
447: l_index := l_index + 1;
448: l_databuffer_tbl(l_index) := ' BEGIN FLOW_PAGE_REGION "' ||
449: nvl(to_char(l_regions_rec.region_application_id),'') || '" "' ||
450: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.region_code)
451: || '"';
452: l_index := l_index + 1;
453: l_databuffer_tbl(l_index) := ' DISPLAY_SEQUENCE = "' ||
454: nvl(to_char(l_regions_rec.display_sequence),'') || '"';

Line 457: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.region_style)

453: l_databuffer_tbl(l_index) := ' DISPLAY_SEQUENCE = "' ||
454: nvl(to_char(l_regions_rec.display_sequence),'') || '"';
455: l_index := l_index + 1;
456: l_databuffer_tbl(l_index) := ' REGION_STYLE = "' ||
457: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.region_style)
458: || '"';
459: if (l_regions_rec.num_columns IS NOT NULL) and
460: (l_regions_rec.num_columns <> FND_API.G_MISS_NUM) then
461: l_index := l_index + 1;

Line 469: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.icx_custom_call) ||'"';

465: if (l_regions_rec.icx_custom_call IS NOT NULL) and
466: (l_regions_rec.icx_custom_call <> FND_API.G_MISS_CHAR) then
467: l_index := l_index + 1;
468: l_databuffer_tbl(l_index) := ' ICX_CUSTOM_CALL = "' ||
469: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.icx_custom_call) ||'"';
470: end if;
471: if (l_regions_rec.parent_region_application_id IS NOT NULL) and
472: (l_regions_rec.parent_region_application_id <> FND_API.G_MISS_NUM) and
473: (l_regions_rec.parent_region_code IS NOT NULL) and

Line 478: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.parent_region_code)

474: (l_regions_rec.parent_region_code <> FND_API.G_MISS_CHAR) then
475: l_index := l_index + 1;
476: l_databuffer_tbl(l_index) := ' PARENT_REGION = "' ||
477: nvl(to_char(l_regions_rec.parent_region_application_id),'')||'" "'||
478: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.parent_region_code)
479: ||'"';
480: end if;
481: if (l_foreign_key_name IS NOT NULL) and
482: (l_foreign_key_name <> FND_API.G_MISS_CHAR) then

Line 485: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_foreign_key_name)

481: if (l_foreign_key_name IS NOT NULL) and
482: (l_foreign_key_name <> FND_API.G_MISS_CHAR) then
483: l_index := l_index + 1;
484: l_databuffer_tbl(l_index) := ' FOREIGN_KEY_NAME = "' ||
485: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_foreign_key_name)
486: ||'"';
487: end if;
488: -- Flex Fields
489: --

Line 494: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

490: if ((l_regions_rec.attribute_category IS NOT NULL) and
491: (l_regions_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
492: l_index := l_index + 1;
493: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
494: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
495: l_regions_rec.attribute_category) || '"';
496: end if;
497: if ((l_regions_rec.attribute1 IS NOT NULL) and
498: (l_regions_rec.attribute1 <> FND_API.G_MISS_CHAR)) then

Line 501: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

497: if ((l_regions_rec.attribute1 IS NOT NULL) and
498: (l_regions_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
499: l_index := l_index + 1;
500: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
501: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
502: l_regions_rec.attribute1) || '"';
503: end if;
504: if ((l_regions_rec.attribute2 IS NOT NULL) and
505: (l_regions_rec.attribute2 <> FND_API.G_MISS_CHAR)) then

Line 508: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

504: if ((l_regions_rec.attribute2 IS NOT NULL) and
505: (l_regions_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
506: l_index := l_index + 1;
507: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
508: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
509: l_regions_rec.attribute2) || '"';
510: end if;
511: if ((l_regions_rec.attribute3 IS NOT NULL) and
512: (l_regions_rec.attribute3 <> FND_API.G_MISS_CHAR)) then

Line 515: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

511: if ((l_regions_rec.attribute3 IS NOT NULL) and
512: (l_regions_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
513: l_index := l_index + 1;
514: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
515: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
516: l_regions_rec.attribute3) || '"';
517: end if;
518: if ((l_regions_rec.attribute4 IS NOT NULL) and
519: (l_regions_rec.attribute4 <> FND_API.G_MISS_CHAR)) then

Line 522: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

518: if ((l_regions_rec.attribute4 IS NOT NULL) and
519: (l_regions_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
520: l_index := l_index + 1;
521: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
522: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
523: l_regions_rec.attribute4) || '"';
524: end if;
525: if ((l_regions_rec.attribute5 IS NOT NULL) and
526: (l_regions_rec.attribute5 <> FND_API.G_MISS_CHAR)) then

Line 529: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

525: if ((l_regions_rec.attribute5 IS NOT NULL) and
526: (l_regions_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
527: l_index := l_index + 1;
528: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
529: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
530: l_regions_rec.attribute5) || '"';
531: end if;
532: if ((l_regions_rec.attribute6 IS NOT NULL) and
533: (l_regions_rec.attribute6 <> FND_API.G_MISS_CHAR)) then

Line 536: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

532: if ((l_regions_rec.attribute6 IS NOT NULL) and
533: (l_regions_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
534: l_index := l_index + 1;
535: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
536: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
537: l_regions_rec.attribute6) || '"';
538: end if;
539: if ((l_regions_rec.attribute7 IS NOT NULL) and
540: (l_regions_rec.attribute7 <> FND_API.G_MISS_CHAR)) then

Line 543: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

539: if ((l_regions_rec.attribute7 IS NOT NULL) and
540: (l_regions_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
541: l_index := l_index + 1;
542: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
543: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
544: l_regions_rec.attribute7) || '"';
545: end if;
546: if ((l_regions_rec.attribute8 IS NOT NULL) and
547: (l_regions_rec.attribute8 <> FND_API.G_MISS_CHAR)) then

Line 550: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

546: if ((l_regions_rec.attribute8 IS NOT NULL) and
547: (l_regions_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
548: l_index := l_index + 1;
549: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
550: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
551: l_regions_rec.attribute8) || '"';
552: end if;
553: if ((l_regions_rec.attribute9 IS NOT NULL) and
554: (l_regions_rec.attribute9 <> FND_API.G_MISS_CHAR)) then

Line 557: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

553: if ((l_regions_rec.attribute9 IS NOT NULL) and
554: (l_regions_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
555: l_index := l_index + 1;
556: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
557: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
558: l_regions_rec.attribute9) || '"';
559: end if;
560: if ((l_regions_rec.attribute10 IS NOT NULL) and
561: (l_regions_rec.attribute10 <> FND_API.G_MISS_CHAR)) then

Line 564: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

560: if ((l_regions_rec.attribute10 IS NOT NULL) and
561: (l_regions_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
562: l_index := l_index + 1;
563: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
564: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
565: l_regions_rec.attribute10) || '"';
566: end if;
567: if ((l_regions_rec.attribute11 IS NOT NULL) and
568: (l_regions_rec.attribute11 <> FND_API.G_MISS_CHAR)) then

Line 571: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

567: if ((l_regions_rec.attribute11 IS NOT NULL) and
568: (l_regions_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
569: l_index := l_index + 1;
570: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
571: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
572: l_regions_rec.attribute11) || '"';
573: end if;
574: if ((l_regions_rec.attribute12 IS NOT NULL) and
575: (l_regions_rec.attribute12 <> FND_API.G_MISS_CHAR)) then

Line 578: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

574: if ((l_regions_rec.attribute12 IS NOT NULL) and
575: (l_regions_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
576: l_index := l_index + 1;
577: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
578: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
579: l_regions_rec.attribute12) || '"';
580: end if;
581: if ((l_regions_rec.attribute13 IS NOT NULL) and
582: (l_regions_rec.attribute13 <> FND_API.G_MISS_CHAR)) then

Line 585: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

581: if ((l_regions_rec.attribute13 IS NOT NULL) and
582: (l_regions_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
583: l_index := l_index + 1;
584: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
585: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
586: l_regions_rec.attribute13) || '"';
587: end if;
588: if ((l_regions_rec.attribute14 IS NOT NULL) and
589: (l_regions_rec.attribute14 <> FND_API.G_MISS_CHAR)) then

Line 592: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

588: if ((l_regions_rec.attribute14 IS NOT NULL) and
589: (l_regions_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
590: l_index := l_index + 1;
591: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
592: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
593: l_regions_rec.attribute14) || '"';
594: end if;
595: if ((l_regions_rec.attribute15 IS NOT NULL) and
596: (l_regions_rec.attribute15 <> FND_API.G_MISS_CHAR)) then

Line 599: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

595: if ((l_regions_rec.attribute15 IS NOT NULL) and
596: (l_regions_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
597: l_index := l_index + 1;
598: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
599: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
600: l_regions_rec.attribute15) || '"';
601: end if;
602: -- - Write out who columns
603: l_index := l_index + 1;

Line 626: AK_ON_OBJECTS_PVT.WRITE_FILE (

622: nvl(to_char(l_regions_rec.last_update_login),'') || '"';
623:
624:
625: -- - Write flow page region data out to the specified file
626: AK_ON_OBJECTS_PVT.WRITE_FILE (
627: p_return_status => l_return_status,
628: p_buffer_tbl => l_databuffer_tbl,
629: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
630: );

Line 668: AK_ON_OBJECTS_PVT.WRITE_FILE (

664: l_databuffer_tbl(l_index) := ' ';
665: end if; -- validation OK
666:
667: -- - Finish up writing object data out to the specified file
668: AK_ON_OBJECTS_PVT.WRITE_FILE (
669: p_return_status => l_return_status,
670: p_buffer_tbl => l_databuffer_tbl,
671: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
672: );

Line 797: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)

793: p_primary_region_appl_id => l_pages_rec.primary_region_appl_id,
794: p_primary_region_code => l_pages_rec.primary_region_code,
795: p_name => l_pages_tl_rec.name,
796: p_description => l_pages_tl_rec.description,
797: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
798: then
799: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
800: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_NOT_DOWNLOADED');
801: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

Line 815: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_pages_rec.page_code)

811: l_databuffer_tbl(l_index) := ' ';
812: l_index := l_index + 1;
813: l_databuffer_tbl(l_index) := ' BEGIN FLOW_PAGE "' ||
814: nvl(to_char(l_pages_rec.page_application_id),'') || '" "' ||
815: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_pages_rec.page_code)
816: || '"';
817: l_index := l_index + 1;
818: l_databuffer_tbl(l_index) := ' PRIMARY_REGION = "' ||
819: nvl(to_char(l_pages_rec.primary_region_appl_id),'')||'" "'||

Line 820: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

816: || '"';
817: l_index := l_index + 1;
818: l_databuffer_tbl(l_index) := ' PRIMARY_REGION = "' ||
819: nvl(to_char(l_pages_rec.primary_region_appl_id),'')||'" "'||
820: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
821: l_pages_rec.primary_region_code) ||'"';
822: -- Flex Fields
823: --
824: if ((l_pages_rec.attribute_category IS NOT NULL) and

Line 828: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

824: if ((l_pages_rec.attribute_category IS NOT NULL) and
825: (l_pages_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
826: l_index := l_index + 1;
827: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
828: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
829: l_pages_rec.attribute_category) || '"';
830: end if;
831: if ((l_pages_rec.attribute1 IS NOT NULL) and
832: (l_pages_rec.attribute1 <> FND_API.G_MISS_CHAR)) then

Line 835: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

831: if ((l_pages_rec.attribute1 IS NOT NULL) and
832: (l_pages_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
833: l_index := l_index + 1;
834: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
835: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
836: l_pages_rec.attribute1) || '"';
837: end if;
838: if ((l_pages_rec.attribute2 IS NOT NULL) and
839: (l_pages_rec.attribute2 <> FND_API.G_MISS_CHAR)) then

Line 842: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

838: if ((l_pages_rec.attribute2 IS NOT NULL) and
839: (l_pages_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
840: l_index := l_index + 1;
841: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
842: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
843: l_pages_rec.attribute2) || '"';
844: end if;
845: if ((l_pages_rec.attribute3 IS NOT NULL) and
846: (l_pages_rec.attribute3 <> FND_API.G_MISS_CHAR)) then

Line 849: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

845: if ((l_pages_rec.attribute3 IS NOT NULL) and
846: (l_pages_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
847: l_index := l_index + 1;
848: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
849: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
850: l_pages_rec.attribute3) || '"';
851: end if;
852: if ((l_pages_rec.attribute4 IS NOT NULL) and
853: (l_pages_rec.attribute4 <> FND_API.G_MISS_CHAR)) then

Line 856: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

852: if ((l_pages_rec.attribute4 IS NOT NULL) and
853: (l_pages_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
854: l_index := l_index + 1;
855: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
856: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
857: l_pages_rec.attribute4) || '"';
858: end if;
859: if ((l_pages_rec.attribute5 IS NOT NULL) and
860: (l_pages_rec.attribute5 <> FND_API.G_MISS_CHAR)) then

Line 863: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

859: if ((l_pages_rec.attribute5 IS NOT NULL) and
860: (l_pages_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
861: l_index := l_index + 1;
862: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
863: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
864: l_pages_rec.attribute5) || '"';
865: end if;
866: if ((l_pages_rec.attribute6 IS NOT NULL) and
867: (l_pages_rec.attribute6 <> FND_API.G_MISS_CHAR)) then

Line 870: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

866: if ((l_pages_rec.attribute6 IS NOT NULL) and
867: (l_pages_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
868: l_index := l_index + 1;
869: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
870: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
871: l_pages_rec.attribute6) || '"';
872: end if;
873: if ((l_pages_rec.attribute7 IS NOT NULL) and
874: (l_pages_rec.attribute7 <> FND_API.G_MISS_CHAR)) then

Line 877: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

873: if ((l_pages_rec.attribute7 IS NOT NULL) and
874: (l_pages_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
875: l_index := l_index + 1;
876: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
877: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
878: l_pages_rec.attribute7) || '"';
879: end if;
880: if ((l_pages_rec.attribute8 IS NOT NULL) and
881: (l_pages_rec.attribute8 <> FND_API.G_MISS_CHAR)) then

Line 884: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

880: if ((l_pages_rec.attribute8 IS NOT NULL) and
881: (l_pages_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
882: l_index := l_index + 1;
883: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
884: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
885: l_pages_rec.attribute8) || '"';
886: end if;
887: if ((l_pages_rec.attribute9 IS NOT NULL) and
888: (l_pages_rec.attribute9 <> FND_API.G_MISS_CHAR)) then

Line 891: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

887: if ((l_pages_rec.attribute9 IS NOT NULL) and
888: (l_pages_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
889: l_index := l_index + 1;
890: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
891: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
892: l_pages_rec.attribute9) || '"';
893: end if;
894: if ((l_pages_rec.attribute10 IS NOT NULL) and
895: (l_pages_rec.attribute10 <> FND_API.G_MISS_CHAR)) then

Line 898: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

894: if ((l_pages_rec.attribute10 IS NOT NULL) and
895: (l_pages_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
896: l_index := l_index + 1;
897: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
898: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
899: l_pages_rec.attribute10) || '"';
900: end if;
901: if ((l_pages_rec.attribute11 IS NOT NULL) and
902: (l_pages_rec.attribute11 <> FND_API.G_MISS_CHAR)) then

Line 905: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

901: if ((l_pages_rec.attribute11 IS NOT NULL) and
902: (l_pages_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
903: l_index := l_index + 1;
904: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
905: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
906: l_pages_rec.attribute11) || '"';
907: end if;
908: if ((l_pages_rec.attribute12 IS NOT NULL) and
909: (l_pages_rec.attribute12 <> FND_API.G_MISS_CHAR)) then

Line 912: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

908: if ((l_pages_rec.attribute12 IS NOT NULL) and
909: (l_pages_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
910: l_index := l_index + 1;
911: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
912: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
913: l_pages_rec.attribute12) || '"';
914: end if;
915: if ((l_pages_rec.attribute13 IS NOT NULL) and
916: (l_pages_rec.attribute13 <> FND_API.G_MISS_CHAR)) then

Line 919: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

915: if ((l_pages_rec.attribute13 IS NOT NULL) and
916: (l_pages_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
917: l_index := l_index + 1;
918: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
919: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
920: l_pages_rec.attribute13) || '"';
921: end if;
922: if ((l_pages_rec.attribute14 IS NOT NULL) and
923: (l_pages_rec.attribute14 <> FND_API.G_MISS_CHAR)) then

Line 926: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

922: if ((l_pages_rec.attribute14 IS NOT NULL) and
923: (l_pages_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
924: l_index := l_index + 1;
925: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
926: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
927: l_pages_rec.attribute14) || '"';
928: end if;
929: if ((l_pages_rec.attribute15 IS NOT NULL) and
930: (l_pages_rec.attribute15 <> FND_API.G_MISS_CHAR)) then

Line 933: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

929: if ((l_pages_rec.attribute15 IS NOT NULL) and
930: (l_pages_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
931: l_index := l_index + 1;
932: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
933: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
934: l_pages_rec.attribute15) || '"';
935: end if;
936: -- - Write out who columns
937: l_index := l_index + 1;

Line 962: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_pages_tl_rec.name) || '"';

958: if ((l_pages_tl_rec.name IS NOT NULL) and
959: (l_pages_tl_rec.name <> FND_API.G_MISS_CHAR)) then
960: l_index := l_index + 1;
961: l_databuffer_tbl(l_index) := ' NAME = "' ||
962: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_pages_tl_rec.name) || '"';
963: end if;
964: if ((l_pages_tl_rec.description IS NOT NULL) and
965: (l_pages_tl_rec.description <> FND_API.G_MISS_CHAR)) then
966: l_index := l_index + 1;

Line 968: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_pages_tl_rec.description)

964: if ((l_pages_tl_rec.description IS NOT NULL) and
965: (l_pages_tl_rec.description <> FND_API.G_MISS_CHAR)) then
966: l_index := l_index + 1;
967: l_databuffer_tbl(l_index) := ' DESCRIPTION = "' ||
968: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_pages_tl_rec.description)
969: || '"';
970: end if;
971:
972: -- - Write flow page data out to the specified file

Line 973: AK_ON_OBJECTS_PVT.WRITE_FILE (

969: || '"';
970: end if;
971:
972: -- - Write flow page data out to the specified file
973: AK_ON_OBJECTS_PVT.WRITE_FILE (
974: p_return_status => l_return_status,
975: p_buffer_tbl => l_databuffer_tbl,
976: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
977: );

Line 1016: AK_ON_OBJECTS_PVT.WRITE_FILE (

1012: l_databuffer_tbl(l_index) := ' ';
1013: end if; -- validation OK --
1014:
1015: -- - Finish up writing flow page data out to the specified file
1016: AK_ON_OBJECTS_PVT.WRITE_FILE (
1017: p_return_status => l_return_status,
1018: p_buffer_tbl => l_databuffer_tbl,
1019: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1020: );

Line 1129: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)

1125: p_to_page_code => l_relations_rec.to_page_code,
1126: p_to_region_appl_id => l_relations_rec.to_region_appl_id,
1127: p_to_region_code => l_relations_rec.to_region_code,
1128: p_application_id => l_relations_rec.application_id,
1129: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1130: then
1131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1132: FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_DOWNLOADED');
1133: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

Line 1152: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.foreign_key_name)

1148: else
1149: l_databuffer_tbl(l_index) := ' ';
1150: l_index := l_index + 1;
1151: l_databuffer_tbl(l_index) := ' BEGIN FLOW_REGION_RELATION "' ||
1152: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.foreign_key_name)
1153: || '" "' ||
1154: nvl(to_char(l_relations_rec.from_page_appl_id),'') || '" "' ||
1155: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.from_page_code)
1156: || '" "' ||

Line 1155: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.from_page_code)

1151: l_databuffer_tbl(l_index) := ' BEGIN FLOW_REGION_RELATION "' ||
1152: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.foreign_key_name)
1153: || '" "' ||
1154: nvl(to_char(l_relations_rec.from_page_appl_id),'') || '" "' ||
1155: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.from_page_code)
1156: || '" "' ||
1157: nvl(to_char(l_relations_rec.from_region_appl_id),'') || '" "' ||
1158: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.from_region_code)
1159: || '" "' ||

Line 1158: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.from_region_code)

1154: nvl(to_char(l_relations_rec.from_page_appl_id),'') || '" "' ||
1155: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.from_page_code)
1156: || '" "' ||
1157: nvl(to_char(l_relations_rec.from_region_appl_id),'') || '" "' ||
1158: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.from_region_code)
1159: || '" "' ||
1160: nvl(to_char(l_relations_rec.to_page_appl_id),'') || '" "' ||
1161: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.to_page_code)
1162: || '" "' ||

Line 1161: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.to_page_code)

1157: nvl(to_char(l_relations_rec.from_region_appl_id),'') || '" "' ||
1158: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.from_region_code)
1159: || '" "' ||
1160: nvl(to_char(l_relations_rec.to_page_appl_id),'') || '" "' ||
1161: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.to_page_code)
1162: || '" "' ||
1163: nvl(to_char(l_relations_rec.to_region_appl_id),'') || '" "' ||
1164: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.to_region_code)
1165: || '"';

Line 1164: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.to_region_code)

1160: nvl(to_char(l_relations_rec.to_page_appl_id),'') || '" "' ||
1161: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.to_page_code)
1162: || '" "' ||
1163: nvl(to_char(l_relations_rec.to_region_appl_id),'') || '" "' ||
1164: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_relations_rec.to_region_code)
1165: || '"';
1166: l_index := l_index + 1;
1167: l_databuffer_tbl(l_index) := ' APPLICATION_ID = "' ||
1168: nvl(to_char(l_relations_rec.application_id),'') || '"';

Line 1175: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1171: if ((l_relations_rec.attribute_category IS NOT NULL) and
1172: (l_relations_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
1173: l_index := l_index + 1;
1174: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
1175: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1176: l_relations_rec.attribute_category) || '"';
1177: end if;
1178: if ((l_relations_rec.attribute1 IS NOT NULL) and
1179: (l_relations_rec.attribute1 <> FND_API.G_MISS_CHAR)) then

Line 1182: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1178: if ((l_relations_rec.attribute1 IS NOT NULL) and
1179: (l_relations_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
1180: l_index := l_index + 1;
1181: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
1182: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1183: l_relations_rec.attribute1) || '"';
1184: end if;
1185: if ((l_relations_rec.attribute2 IS NOT NULL) and
1186: (l_relations_rec.attribute2 <> FND_API.G_MISS_CHAR)) then

Line 1189: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1185: if ((l_relations_rec.attribute2 IS NOT NULL) and
1186: (l_relations_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
1187: l_index := l_index + 1;
1188: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
1189: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1190: l_relations_rec.attribute2) || '"';
1191: end if;
1192: if ((l_relations_rec.attribute3 IS NOT NULL) and
1193: (l_relations_rec.attribute3 <> FND_API.G_MISS_CHAR)) then

Line 1196: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1192: if ((l_relations_rec.attribute3 IS NOT NULL) and
1193: (l_relations_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
1194: l_index := l_index + 1;
1195: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
1196: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1197: l_relations_rec.attribute3) || '"';
1198: end if;
1199: if ((l_relations_rec.attribute4 IS NOT NULL) and
1200: (l_relations_rec.attribute4 <> FND_API.G_MISS_CHAR)) then

Line 1203: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1199: if ((l_relations_rec.attribute4 IS NOT NULL) and
1200: (l_relations_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
1201: l_index := l_index + 1;
1202: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
1203: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1204: l_relations_rec.attribute4) || '"';
1205: end if;
1206: if ((l_relations_rec.attribute5 IS NOT NULL) and
1207: (l_relations_rec.attribute5 <> FND_API.G_MISS_CHAR)) then

Line 1210: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1206: if ((l_relations_rec.attribute5 IS NOT NULL) and
1207: (l_relations_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
1208: l_index := l_index + 1;
1209: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
1210: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1211: l_relations_rec.attribute5) || '"';
1212: end if;
1213: if ((l_relations_rec.attribute6 IS NOT NULL) and
1214: (l_relations_rec.attribute6 <> FND_API.G_MISS_CHAR)) then

Line 1217: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1213: if ((l_relations_rec.attribute6 IS NOT NULL) and
1214: (l_relations_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
1215: l_index := l_index + 1;
1216: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
1217: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1218: l_relations_rec.attribute6) || '"';
1219: end if;
1220: if ((l_relations_rec.attribute7 IS NOT NULL) and
1221: (l_relations_rec.attribute7 <> FND_API.G_MISS_CHAR)) then

Line 1224: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1220: if ((l_relations_rec.attribute7 IS NOT NULL) and
1221: (l_relations_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
1222: l_index := l_index + 1;
1223: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
1224: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1225: l_relations_rec.attribute7) || '"';
1226: end if;
1227: if ((l_relations_rec.attribute8 IS NOT NULL) and
1228: (l_relations_rec.attribute8 <> FND_API.G_MISS_CHAR)) then

Line 1231: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1227: if ((l_relations_rec.attribute8 IS NOT NULL) and
1228: (l_relations_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
1229: l_index := l_index + 1;
1230: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
1231: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1232: l_relations_rec.attribute8) || '"';
1233: end if;
1234: if ((l_relations_rec.attribute9 IS NOT NULL) and
1235: (l_relations_rec.attribute9 <> FND_API.G_MISS_CHAR)) then

Line 1238: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1234: if ((l_relations_rec.attribute9 IS NOT NULL) and
1235: (l_relations_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
1236: l_index := l_index + 1;
1237: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
1238: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1239: l_relations_rec.attribute9) || '"';
1240: end if;
1241: if ((l_relations_rec.attribute10 IS NOT NULL) and
1242: (l_relations_rec.attribute10 <> FND_API.G_MISS_CHAR)) then

Line 1245: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1241: if ((l_relations_rec.attribute10 IS NOT NULL) and
1242: (l_relations_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
1243: l_index := l_index + 1;
1244: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
1245: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1246: l_relations_rec.attribute10) || '"';
1247: end if;
1248: if ((l_relations_rec.attribute11 IS NOT NULL) and
1249: (l_relations_rec.attribute11 <> FND_API.G_MISS_CHAR)) then

Line 1252: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1248: if ((l_relations_rec.attribute11 IS NOT NULL) and
1249: (l_relations_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
1250: l_index := l_index + 1;
1251: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
1252: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1253: l_relations_rec.attribute11) || '"';
1254: end if;
1255: if ((l_relations_rec.attribute12 IS NOT NULL) and
1256: (l_relations_rec.attribute12 <> FND_API.G_MISS_CHAR)) then

Line 1259: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1255: if ((l_relations_rec.attribute12 IS NOT NULL) and
1256: (l_relations_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
1257: l_index := l_index + 1;
1258: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
1259: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1260: l_relations_rec.attribute12) || '"';
1261: end if;
1262: if ((l_relations_rec.attribute13 IS NOT NULL) and
1263: (l_relations_rec.attribute13 <> FND_API.G_MISS_CHAR)) then

Line 1266: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1262: if ((l_relations_rec.attribute13 IS NOT NULL) and
1263: (l_relations_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
1264: l_index := l_index + 1;
1265: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
1266: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1267: l_relations_rec.attribute13) || '"';
1268: end if;
1269: if ((l_relations_rec.attribute14 IS NOT NULL) and
1270: (l_relations_rec.attribute14 <> FND_API.G_MISS_CHAR)) then

Line 1273: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1269: if ((l_relations_rec.attribute14 IS NOT NULL) and
1270: (l_relations_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
1271: l_index := l_index + 1;
1272: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
1273: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1274: l_relations_rec.attribute14) || '"';
1275: end if;
1276: if ((l_relations_rec.attribute15 IS NOT NULL) and
1277: (l_relations_rec.attribute15 <> FND_API.G_MISS_CHAR)) then

Line 1280: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1276: if ((l_relations_rec.attribute15 IS NOT NULL) and
1277: (l_relations_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
1278: l_index := l_index + 1;
1279: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
1280: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1281: l_relations_rec.attribute15) || '"';
1282: end if;
1283: -- - Write out who columns
1284: l_index := l_index + 1;

Line 1318: AK_ON_OBJECTS_PVT.WRITE_FILE (

1314:
1315: -- - Write relation data out to the specified file
1316: -- don't call write_file if there is no data to be written
1317: if (l_databuffer_tbl.count > 0) then
1318: AK_ON_OBJECTS_PVT.WRITE_FILE (
1319: p_return_status => l_return_status,
1320: p_buffer_tbl => l_databuffer_tbl,
1321: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1322: );

Line 1451: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)

1447: p_primary_page_appl_id => l_flows_rec.primary_page_appl_id,
1448: p_primary_page_code => l_flows_rec.primary_page_code,
1449: p_name => l_flows_tl_rec.name,
1450: p_description => l_flows_tl_rec.description,
1451: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1452: then
1453: raise FND_API.G_EXC_ERROR;
1454: end if;
1455: end if;

Line 1462: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_flows_rec.flow_code) || '"';

1458: l_index := 1;
1459:
1460: l_databuffer_tbl(l_index) := 'BEGIN FLOW "' ||
1461: nvl(to_char(l_flows_rec.flow_application_id),'') || '" "' ||
1462: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_flows_rec.flow_code) || '"';
1463: l_index := l_index + 1;
1464: l_databuffer_tbl(l_index) := ' PRIMARY_PAGE = "' ||
1465: nvl(to_char(l_flows_rec.primary_page_appl_id),'')||'" "'||
1466: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_flows_rec.primary_page_code)||'"';

Line 1466: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_flows_rec.primary_page_code)||'"';

1462: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_flows_rec.flow_code) || '"';
1463: l_index := l_index + 1;
1464: l_databuffer_tbl(l_index) := ' PRIMARY_PAGE = "' ||
1465: nvl(to_char(l_flows_rec.primary_page_appl_id),'')||'" "'||
1466: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_flows_rec.primary_page_code)||'"';
1467: -- Flex Fields
1468: --
1469: if ((l_flows_rec.attribute_category IS NOT NULL) and
1470: (l_flows_rec.attribute_category <> FND_API.G_MISS_CHAR)) then

Line 1473: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1469: if ((l_flows_rec.attribute_category IS NOT NULL) and
1470: (l_flows_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
1471: l_index := l_index + 1;
1472: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
1473: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1474: l_flows_rec.attribute_category) || '"';
1475: end if;
1476: if ((l_flows_rec.attribute1 IS NOT NULL) and
1477: (l_flows_rec.attribute1 <> FND_API.G_MISS_CHAR)) then

Line 1480: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1476: if ((l_flows_rec.attribute1 IS NOT NULL) and
1477: (l_flows_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
1478: l_index := l_index + 1;
1479: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
1480: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1481: l_flows_rec.attribute1) || '"';
1482: end if;
1483: if ((l_flows_rec.attribute2 IS NOT NULL) and
1484: (l_flows_rec.attribute2 <> FND_API.G_MISS_CHAR)) then

Line 1487: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1483: if ((l_flows_rec.attribute2 IS NOT NULL) and
1484: (l_flows_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
1485: l_index := l_index + 1;
1486: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
1487: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1488: l_flows_rec.attribute2) || '"';
1489: end if;
1490: if ((l_flows_rec.attribute3 IS NOT NULL) and
1491: (l_flows_rec.attribute3 <> FND_API.G_MISS_CHAR)) then

Line 1494: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1490: if ((l_flows_rec.attribute3 IS NOT NULL) and
1491: (l_flows_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
1492: l_index := l_index + 1;
1493: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
1494: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1495: l_flows_rec.attribute3) || '"';
1496: end if;
1497: if ((l_flows_rec.attribute4 IS NOT NULL) and
1498: (l_flows_rec.attribute4 <> FND_API.G_MISS_CHAR)) then

Line 1501: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1497: if ((l_flows_rec.attribute4 IS NOT NULL) and
1498: (l_flows_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
1499: l_index := l_index + 1;
1500: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
1501: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1502: l_flows_rec.attribute4) || '"';
1503: end if;
1504: if ((l_flows_rec.attribute5 IS NOT NULL) and
1505: (l_flows_rec.attribute5 <> FND_API.G_MISS_CHAR)) then

Line 1508: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1504: if ((l_flows_rec.attribute5 IS NOT NULL) and
1505: (l_flows_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
1506: l_index := l_index + 1;
1507: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
1508: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1509: l_flows_rec.attribute5) || '"';
1510: end if;
1511: if ((l_flows_rec.attribute6 IS NOT NULL) and
1512: (l_flows_rec.attribute6 <> FND_API.G_MISS_CHAR)) then

Line 1515: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1511: if ((l_flows_rec.attribute6 IS NOT NULL) and
1512: (l_flows_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
1513: l_index := l_index + 1;
1514: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
1515: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1516: l_flows_rec.attribute6) || '"';
1517: end if;
1518: if ((l_flows_rec.attribute7 IS NOT NULL) and
1519: (l_flows_rec.attribute7 <> FND_API.G_MISS_CHAR)) then

Line 1522: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1518: if ((l_flows_rec.attribute7 IS NOT NULL) and
1519: (l_flows_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
1520: l_index := l_index + 1;
1521: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
1522: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1523: l_flows_rec.attribute7) || '"';
1524: end if;
1525: if ((l_flows_rec.attribute8 IS NOT NULL) and
1526: (l_flows_rec.attribute8 <> FND_API.G_MISS_CHAR)) then

Line 1529: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1525: if ((l_flows_rec.attribute8 IS NOT NULL) and
1526: (l_flows_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
1527: l_index := l_index + 1;
1528: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
1529: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1530: l_flows_rec.attribute8) || '"';
1531: end if;
1532: if ((l_flows_rec.attribute9 IS NOT NULL) and
1533: (l_flows_rec.attribute9 <> FND_API.G_MISS_CHAR)) then

Line 1536: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1532: if ((l_flows_rec.attribute9 IS NOT NULL) and
1533: (l_flows_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
1534: l_index := l_index + 1;
1535: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
1536: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1537: l_flows_rec.attribute9) || '"';
1538: end if;
1539: if ((l_flows_rec.attribute10 IS NOT NULL) and
1540: (l_flows_rec.attribute10 <> FND_API.G_MISS_CHAR)) then

Line 1543: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1539: if ((l_flows_rec.attribute10 IS NOT NULL) and
1540: (l_flows_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
1541: l_index := l_index + 1;
1542: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
1543: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1544: l_flows_rec.attribute10) || '"';
1545: end if;
1546: if ((l_flows_rec.attribute11 IS NOT NULL) and
1547: (l_flows_rec.attribute11 <> FND_API.G_MISS_CHAR)) then

Line 1550: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1546: if ((l_flows_rec.attribute11 IS NOT NULL) and
1547: (l_flows_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
1548: l_index := l_index + 1;
1549: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
1550: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1551: l_flows_rec.attribute11) || '"';
1552: end if;
1553: if ((l_flows_rec.attribute12 IS NOT NULL) and
1554: (l_flows_rec.attribute12 <> FND_API.G_MISS_CHAR)) then

Line 1557: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1553: if ((l_flows_rec.attribute12 IS NOT NULL) and
1554: (l_flows_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
1555: l_index := l_index + 1;
1556: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
1557: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1558: l_flows_rec.attribute12) || '"';
1559: end if;
1560: if ((l_flows_rec.attribute13 IS NOT NULL) and
1561: (l_flows_rec.attribute13 <> FND_API.G_MISS_CHAR)) then

Line 1564: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1560: if ((l_flows_rec.attribute13 IS NOT NULL) and
1561: (l_flows_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
1562: l_index := l_index + 1;
1563: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
1564: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1565: l_flows_rec.attribute13) || '"';
1566: end if;
1567: if ((l_flows_rec.attribute14 IS NOT NULL) and
1568: (l_flows_rec.attribute14 <> FND_API.G_MISS_CHAR)) then

Line 1571: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1567: if ((l_flows_rec.attribute14 IS NOT NULL) and
1568: (l_flows_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
1569: l_index := l_index + 1;
1570: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
1571: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1572: l_flows_rec.attribute14) || '"';
1573: end if;
1574: if ((l_flows_rec.attribute15 IS NOT NULL) and
1575: (l_flows_rec.attribute15 <> FND_API.G_MISS_CHAR)) then

Line 1578: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1574: if ((l_flows_rec.attribute15 IS NOT NULL) and
1575: (l_flows_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
1576: l_index := l_index + 1;
1577: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
1578: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1579: l_flows_rec.attribute15) || '"';
1580: end if;
1581: -- - Write out who columns
1582: l_index := l_index + 1;

Line 1609: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_flows_tl_rec.name) || '"';

1605: if (l_flows_tl_rec.name IS NOT NULL) and
1606: (l_flows_tl_rec.name <> FND_API.G_MISS_CHAR) then
1607: l_index := l_index + 1;
1608: l_databuffer_tbl(l_index) := ' NAME = "' ||
1609: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_flows_tl_rec.name) || '"';
1610: end if;
1611: if ((l_flows_tl_rec.description IS NOT NULL) and
1612: (l_flows_tl_rec.description <> FND_API.G_MISS_CHAR)) then
1613: l_index := l_index + 1;

Line 1615: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_flows_tl_rec.description) || '"';

1611: if ((l_flows_tl_rec.description IS NOT NULL) and
1612: (l_flows_tl_rec.description <> FND_API.G_MISS_CHAR)) then
1613: l_index := l_index + 1;
1614: l_databuffer_tbl(l_index) := ' DESCRIPTION = "' ||
1615: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_flows_tl_rec.description) || '"';
1616: end if;
1617:
1618: -- - Write flow data out to the specified file
1619: AK_ON_OBJECTS_PVT.WRITE_FILE (

Line 1619: AK_ON_OBJECTS_PVT.WRITE_FILE (

1615: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_flows_tl_rec.description) || '"';
1616: end if;
1617:
1618: -- - Write flow data out to the specified file
1619: AK_ON_OBJECTS_PVT.WRITE_FILE (
1620: p_return_status => l_return_status,
1621: p_buffer_tbl => l_databuffer_tbl,
1622: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1623: );

Line 1662: AK_ON_OBJECTS_PVT.WRITE_FILE (

1658: l_index := l_index + 1;
1659: l_databuffer_tbl(l_index) := ' ';
1660:
1661: -- - Finish up writing flow data out to the specified file
1662: AK_ON_OBJECTS_PVT.WRITE_FILE (
1663: p_return_status => l_return_status,
1664: p_buffer_tbl => l_databuffer_tbl,
1665: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1666: );

Line 2049: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop

2045: else
2046: l_line_num := p_line_num;
2047: end if;
2048:
2049: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
2050: AK_ON_OBJECTS_PVT.READ_LINE (
2051: p_return_status => l_return_status,
2052: p_index => p_index,
2053: p_buffer => l_buffer,

Line 2050: AK_ON_OBJECTS_PVT.READ_LINE (

2046: l_line_num := p_line_num;
2047: end if;
2048:
2049: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
2050: AK_ON_OBJECTS_PVT.READ_LINE (
2051: p_return_status => l_return_status,
2052: p_index => p_index,
2053: p_buffer => l_buffer,
2054: p_lines_read => l_lines_read,

Line 2088: AK_ON_OBJECTS_PVT.GET_TOKEN(

2084:
2085: while (l_eof_flag = 'N') and (l_buffer is not null)
2086: and (l_more_flow) loop
2087:
2088: AK_ON_OBJECTS_PVT.GET_TOKEN(
2089: p_return_status => l_return_status,
2090: p_in_buf => l_buffer,
2091: p_token => l_token
2092: );

Line 2130: -- (ak_on_objects_pvt.upload).

2126: l_state := 2;
2127: else
2128: -- Found the beginning of a non-flow object,
2129: -- rebuild last line and pass it back to the caller
2130: -- (ak_on_objects_pvt.upload).
2131: p_buffer_out := 'BEGIN ' || l_token || ' ' || l_buffer;
2132: l_more_flow := FALSE;
2133: end if;
2134: elsif (l_state = 2) then

Line 3392: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop

3388: --
3389: -- Get the next non-blank, non-comment line if current line is
3390: -- fully parsed
3391: --
3392: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
3393: AK_ON_OBJECTS_PVT.READ_LINE (
3394: p_return_status => l_return_status,
3395: p_index => p_index,
3396: p_buffer => l_buffer,

Line 3393: AK_ON_OBJECTS_PVT.READ_LINE (

3389: -- Get the next non-blank, non-comment line if current line is
3390: -- fully parsed
3391: --
3392: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
3393: AK_ON_OBJECTS_PVT.READ_LINE (
3394: p_return_status => l_return_status,
3395: p_index => p_index,
3396: p_buffer => l_buffer,
3397: p_lines_read => l_lines_read,

Line 3636: if ((AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3632: and af.flow_application_id = aft.flow_application_id
3633: and aft.language = userenv('LANG');
3634: /*if ( ( ( l_user_id1 = 1 or l_user_id1 = 2 ) and
3635: ( l_user_id2 = 1 or l_user_id2 = 2 )) */
3636: if ((AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3637: p_loader_timestamp => p_loader_timestamp,
3638: p_created_by => l_flow_tbl(l_index).created_by,
3639: p_creation_date => l_flow_tbl(l_index).creation_date,
3640: p_last_updated_by => l_flow_tbl(l_index).last_updated_by,

Line 3647: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3643: p_db_last_update_date => l_update1,
3644: p_last_update_login => l_flow_tbl(l_index).last_update_login,
3645: p_create_or_update => 'UPDATE') and
3646:
3647: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3648: p_loader_timestamp => p_loader_timestamp,
3649: p_created_by => l_flow_tbl(l_index).created_by,
3650: p_creation_date => l_flow_tbl(l_index).creation_date,
3651: p_last_updated_by => l_flow_tbl(l_index).last_updated_by,

Line 3797: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3793: and region_code = l_region_tbl(l_index).region_code
3794: and region_application_id = l_region_tbl(l_index).region_application_id;
3795: /*if ( l_user_id1 = 1 or l_user_id1 = 2 ) then*/
3796:
3797: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3798: p_loader_timestamp => p_loader_timestamp,
3799: p_created_by => l_region_tbl(l_index).created_by,
3800: p_creation_date => l_region_tbl(l_index).creation_date,
3801: p_last_updated_by => l_region_tbl(l_index).last_updated_by,

Line 4069: if ((AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

4065: and afp.page_application_id = afpt.page_application_id
4066: and afpt.language = userenv('LANG');
4067: /*if ( ( ( l_user_id1 = 1 or l_user_id1 = 2) and
4068: (l_user_id2 = 1 or l_user_id2 = 2)) */
4069: if ((AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4070: p_loader_timestamp => p_loader_timestamp,
4071: p_created_by => l_page_tbl(l_index).created_by,
4072: p_creation_date => l_page_tbl(l_index).creation_date,
4073: p_last_updated_by => l_page_tbl(l_index).last_updated_by,

Line 4080: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

4076: p_db_last_update_date => l_update1,
4077: p_last_update_login => l_page_tbl(l_index).last_update_login,
4078: p_create_or_update => 'UPDATE') and
4079:
4080: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4081: p_loader_timestamp => p_loader_timestamp,
4082: p_created_by => l_page_tbl(l_index).created_by,
4083: p_creation_date => l_page_tbl(l_index).creation_date,
4084: p_last_updated_by => l_page_tbl(l_index).last_updated_by,

Line 4244: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

4240: and to_region_code = l_relation_tbl(l_index).to_region_code
4241: and to_region_appl_id = l_relation_tbl(l_index).to_region_appl_id;
4242:
4243: /*if ( l_user_id1 = 1 or l_user_id1 = 2) then*/
4244: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4245: p_loader_timestamp => p_loader_timestamp,
4246: p_created_by => l_relation_tbl(l_index).created_by,
4247: p_creation_date => l_relation_tbl(l_index).creation_date,
4248: p_last_updated_by => l_relation_tbl(l_index).last_updated_by,

Line 4456: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

4452: and region_application_id = l_item_tbl(l_index).region_application_id
4453: and attribute_code = l_item_tbl(l_index).attribute_code
4454: and attribute_application_id = l_item_tbl(l_index).attribute_application_id;
4455: /*if ( l_user_id1 = 1 or l_user_id1 = 2) then*/
4456: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4457: p_loader_timestamp => p_loader_timestamp,
4458: p_created_by => l_item_tbl(l_index).created_by,
4459: p_creation_date => l_item_tbl(l_index).creation_date,
4460: p_last_updated_by => l_item_tbl(l_index).last_updated_by,