[Home] [Help]
20: -- validation tests are passed, or FALSE otherwise.
21: -- Parameters Region graph columns
22: -- p_caller : IN required
23: -- Must be one of the following values defined
24: -- in package AK_ON_OBJECTS_PVT:
25: -- - G_CREATE (if calling from the Create API)
26: -- - G_DOWNLOAD (if calling from the Download API)
27: -- - G_UPDATE (if calling from the Update API)
28: --
138: --** from UPDATE procedure, the columns are not missing **
139:
140: if ((p_graph_style is null) or
141: (p_graph_style = FND_API.G_MISS_NUM and
142: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
143: l_error := TRUE;
144: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
145: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
146: FND_MESSAGE.SET_TOKEN('COLUMN', 'GRAPH_STYLE');
149: end if;
150:
151: if ((p_display_flag is null) or
152: (p_display_flag = FND_API.G_MISS_CHAR and
153: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
154: l_error := TRUE;
155: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
156: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
157: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_FLAG');
163: --
164: -- display_flag
165: --
166: if (p_display_flag <> FND_API.G_MISS_CHAR) then
167: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_display_flag)) then
168: l_error := TRUE;
169: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
170: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
171: FND_MESSAGE.SET_TOKEN('COLUMN','DISPLAY_FLAG');
211: -- validation tests are passed, or FALSE otherwise.
212: -- Parameters Region item columns
213: -- p_caller : IN required
214: -- Must be one of the following values defined
215: -- in package AK_ON_OBJECTS_PVT:
216: -- - G_CREATE (if calling from the Create API)
217: -- - G_DOWNLOAD (if calling from the Download API)
218: -- - G_UPDATE (if calling from the Update API)
219: --
452: --** from UPDATE procedure, the columns are not missing **
453:
454: if ((p_display_sequence is null) or
455: (p_display_sequence = FND_API.G_MISS_NUM and
456: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
457: l_error := TRUE;
458: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
459: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
460: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_SEQUENCE');
463: end if;
464:
465: if ((p_node_display_flag is null) or
466: (p_node_display_flag = FND_API.G_MISS_CHAR and
467: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
468: l_error := TRUE;
469: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
470: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
471: FND_MESSAGE.SET_TOKEN('COLUMN', 'NODE_DISPLAY_FLAG');
474: end if;
475:
476: if ((p_node_query_flag is null) or
477: (p_node_query_flag = FND_API.G_MISS_CHAR and
478: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
479: l_error := TRUE;
480: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
481: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
482: FND_MESSAGE.SET_TOKEN('COLUMN', 'NODE_QUERY_FLAG');
485: end if;
486:
487: if ((p_attribute_label_length is null) or
488: (p_attribute_label_length = FND_API.G_MISS_NUM and
489: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
490: l_error := TRUE;
491: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
492: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
493: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_LABEL_LENGTH');
496: end if;
497:
498: if ((p_display_value_length is null) or
499: (p_display_value_length = FND_API.G_MISS_NUM and
500: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
501: l_error := TRUE;
502: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
503: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
504: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_VALUE_LENGTH');
507: end if;
508:
509: if ((p_bold is null) or
510: (p_bold = FND_API.G_MISS_CHAR and
511: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
512: l_error := TRUE;
513: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
514: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
515: FND_MESSAGE.SET_TOKEN('COLUMN', 'BOLD');
518: end if;
519:
520: if ((p_italic is null) or
521: (p_italic = FND_API.G_MISS_CHAR and
522: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
523: l_error := TRUE;
524: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
525: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
526: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');
529: end if;
530:
531: if ((p_vertical_alignment is null) or
532: (p_vertical_alignment = FND_API.G_MISS_CHAR and
533: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
534: l_error := TRUE;
535: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
536: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
537: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERTICAL_ALIGNMENT');
540: end if;
541:
542: if ((p_horizontal_alignment is null) or
543: (p_horizontal_alignment = FND_API.G_MISS_CHAR and
544: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
545: l_error := TRUE;
546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
547: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
548: FND_MESSAGE.SET_TOKEN('COLUMN', 'HORIZONTAL_ALIGNMENT');
551: end if;
552:
553: if ((p_item_style is null) or
554: (p_item_style = FND_API.G_MISS_CHAR and
555: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
556: l_error := TRUE;
557: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
558: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
559: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_SYTLE');
562: end if;
563:
564: if ((p_object_attribute_flag is null) or
565: (p_object_attribute_flag = FND_API.G_MISS_CHAR and
566: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
567: l_error := TRUE;
568: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
569: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
570: FND_MESSAGE.SET_TOKEN('COLUMN', 'OBJECT_ATTRIBUTE_FLAG');
573: end if;
574:
575: if ((p_update_flag is null) or
576: (p_update_flag = FND_API.G_MISS_CHAR and
577: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
578: l_error := TRUE;
579: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
580: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
581: FND_MESSAGE.SET_TOKEN('COLUMN', 'UPDATE_FLAG');
584: end if;
585:
586: if ((p_required_flag is null) or
587: (p_required_flag = FND_API.G_MISS_CHAR and
588: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
589: l_error := TRUE;
590: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
591: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
592: FND_MESSAGE.SET_TOKEN('COLUMN', 'REQUIRED_FLAG');
612: end if;
613:
614: -- - node_display_flag
615: if (p_node_display_flag <> FND_API.G_MISS_CHAR) then
616: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_node_display_flag)) then
617: l_error := TRUE;
618: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
619: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
620: FND_MESSAGE.SET_TOKEN('COLUMN','NODE_DISPLAY_FLAG');
624: end if;
625:
626: -- - node_query_flag
627: if (p_node_query_flag <> FND_API.G_MISS_CHAR) then
628: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_node_query_flag)) then
629: l_error := TRUE;
630: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
631: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
632: FND_MESSAGE.SET_TOKEN('COLUMN','NODE_QUERY_FLAG');
636: end if;
637:
638: -- - bold
639: if (p_bold <> FND_API.G_MISS_CHAR) then
640: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_bold)) then
641: l_error := TRUE;
642: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
643: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
644: FND_MESSAGE.SET_TOKEN('COLUMN','BOLD');
648: end if;
649:
650: -- - italic
651: if (p_italic <> FND_API.G_MISS_CHAR) then
652: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_italic)) then
653: l_error := TRUE;
654: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
655: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
656: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');
660: end if;
661:
662: -- - vertical alignment
663: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
664: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
665: p_api_version_number => 1.0,
666: p_return_status => l_return_status,
667: p_lookup_type => 'VERTICAL_ALIGNMENT',
668: p_lookup_code => p_vertical_alignment)) then
676: end if;
677:
678: -- - horizontal alignment
679: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
680: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
681: p_api_version_number => 1.0,
682: p_return_status => l_return_status,
683: p_lookup_type => 'HORIZONTAL_ALIGNMENT',
684: p_lookup_code => p_horizontal_alignment)) then
692: end if;
693:
694: -- - item style
695: if (p_item_style <> FND_API.G_MISS_CHAR) then
696: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
697: p_api_version_number => 1.0,
698: p_return_status => l_return_status,
699: p_lookup_type => 'ITEM_STYLE',
700: p_lookup_code => p_item_style)) then
708: end if;
709:
710: -- - object attribute flag
711: if (p_object_attribute_flag <> FND_API.G_MISS_CHAR) then
712: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_object_attribute_flag)) then
713: l_error := TRUE;
714: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
715: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
716: FND_MESSAGE.SET_TOKEN('COLUMN','OBJECT_ATTRIBUTE_FLAG');
720: end if;
721:
722: -- - update_flag
723: if (p_update_flag <> FND_API.G_MISS_CHAR) then
724: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_update_flag)) then
725: l_error := TRUE;
726: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
727: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
728: FND_MESSAGE.SET_TOKEN('COLUMN','UPDATE_FLAG');
732: end if;
733:
734: -- - required_flag
735: if (p_required_flag <> FND_API.G_MISS_CHAR) then
736: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_required_flag)) then
737: l_error := TRUE;
738: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
739: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
740: FND_MESSAGE.SET_TOKEN('COLUMN','REQUIRED_FLAG');
819: end if;
820:
821: -- - lov_default_flag
822: if (p_lov_default_flag <> FND_API.G_MISS_CHAR) then
823: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
824: p_api_version_number => 1.0,
825: p_return_status => l_return_status,
826: p_lookup_type => 'LOV_DEFAULT_FLAG',
827: p_lookup_code => p_lov_default_flag)) then
835: end if;
836:
837: -- - order_direction
838: if (p_order_direction <> FND_API.G_MISS_CHAR) then
839: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
840: p_api_version_number => 1.0,
841: p_return_status => l_return_status,
842: p_lookup_type => 'ORDER_DIRECTION',
843: p_lookup_code => p_order_direction)) then
912:
913: -- initial_sort_sequence
914: if (p_initial_sort_sequence <> FND_API.G_MISS_CHAR and
915: p_initial_sort_sequence is not null) then
916: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
917: p_api_version_number => 1.0,
918: p_return_status => l_return_status,
919: p_lookup_type => 'INIT_SORT_TYPE',
920: p_lookup_code => p_initial_sort_sequence)) then
963: -- validation tests are passed, or FALSE otherwise.
964: -- Parameters Region columns
965: -- p_caller : IN required
966: -- Must be one of the following values defined
967: -- in package AK_ON_OBJECTS_PVT:
968: -- - G_CREATE (if calling from the Create API)
969: -- - G_DOWNLOAD (if calling from the Download API)
970: -- - G_UPDATE (if calling from the Update API)
971: --
1040: --** check that required columns are not null and, unless calling **
1041: --** from UPDATE procedure, the columns are not missing **
1042: if ((p_database_object_name is null) or
1043: (p_database_object_name = FND_API.G_MISS_CHAR and
1044: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1045: l_error := TRUE;
1046: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1047: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1048: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
1051: end if;
1052:
1053: if (p_region_style is null) or
1054: ((p_region_style = FND_API.G_MISS_CHAR) and
1055: (p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1056: l_error := TRUE;
1057: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1058: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1059: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_STYLE');
1062: end if;
1063:
1064: if ((p_name is null) or
1065: (p_name = FND_API.G_MISS_CHAR and
1066: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1067: l_error := TRUE;
1068: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1069: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1070: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
1090: end if;
1091:
1092: -- - Region style
1093: if (p_region_style <> FND_API.G_MISS_CHAR) then
1094: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
1095: p_api_version_number => 1.0,
1096: p_return_status => l_return_status,
1097: p_lookup_type => 'REGION_STYLE',
1098: p_lookup_code => p_region_style)) then
1193: p_region_code => l_graph_columns_rec.region_code,
1194: p_attribute_application_id => l_graph_columns_rec.attribute_application_id,
1195: p_attribute_code => l_graph_columns_rec.attribute_code,
1196: p_graph_number => l_graph_columns_rec.graph_number,
1197: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1198: then
1199: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1200: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_NOT_DOWNLOADED');
1201: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1214: l_index := l_index + 1;
1215: l_databuffer_tbl(l_index) := ' BEGIN REGION_GRAPH_COLUMN "' ||
1216: nvl(to_char(l_graph_columns_rec.attribute_application_id), '')
1217: || '" "' ||
1218: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_graph_columns_rec.attribute_code) || '" ';
1219: -- - Write out who columns
1220: l_index := l_index + 1;
1221: l_databuffer_tbl(l_index) := ' CREATED_BY = "' ||
1222: nvl(to_char(l_graph_columns_rec.created_by),'') || '"';
1240: l_index := l_index + 1;
1241: l_databuffer_tbl(l_index) := ' ';
1242:
1243: -- - Write the 'END REGION_GRAPH_COLUMN' to the specified file
1244: AK_ON_OBJECTS_PVT.WRITE_FILE (
1245: p_return_status => l_return_status,
1246: p_buffer_tbl => l_databuffer_tbl,
1247: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1248: );
1356: p_category_name => l_category_usage_rec.category_name,
1357: p_category_id => l_category_usage_rec.category_id,
1358: p_application_id => l_category_usage_rec.application_id,
1359: p_show_all => l_category_usage_rec.show_all,
1360: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1361: then
1362: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1363: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_NOT_DOWNLOADED');
1364: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1387: if ((l_category_usage_rec.category_id IS NOT NULL) and
1388: (l_category_usage_rec.category_id <> FND_API.G_MISS_NUM)) then
1389: l_index := l_index + 1;
1390: l_databuffer_tbl(l_index) := ' CATEGORY_NAME = "' ||
1391: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_category_usage_rec.category_name)|| '"';
1392: end if;
1393: if ((l_category_usage_rec.show_all IS NOT NULL) and
1394: (l_category_usage_rec.show_all <> FND_API.G_MISS_CHAR)) then
1395: l_index := l_index + 1;
1393: if ((l_category_usage_rec.show_all IS NOT NULL) and
1394: (l_category_usage_rec.show_all <> FND_API.G_MISS_CHAR)) then
1395: l_index := l_index + 1;
1396: l_databuffer_tbl(l_index) := ' SHOW_ALL = "' ||
1397: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_category_usage_rec.show_all)|| '"';
1398: end if;
1399: -- - Write out who columns
1400: l_index := l_index + 1;
1401: l_databuffer_tbl(l_index) := ' CREATED_BY = "' ||
1423: l_index := l_index + 1;
1424: l_databuffer_tbl(l_index) := ' ';
1425:
1426: -- - Write the 'END CATEGORY_USAGE' to the specified file
1427: AK_ON_OBJECTS_PVT.WRITE_FILE (
1428: p_return_status => l_return_status,
1429: p_buffer_tbl => l_databuffer_tbl,
1430: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1431: );
1541: p_base_attribute_code => l_lov_relation_rec.base_attribute_code,
1542: p_direction_flag => l_lov_relation_rec.direction_flag,
1543: p_base_region_appl_id => l_lov_relation_rec.base_region_appl_id,
1544: p_base_region_code => l_lov_relation_rec.base_region_code,
1545: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1546: then
1547: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1548: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_NOT_DOWNLOADED');
1549: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1561: l_databuffer_tbl(l_index) := ' ';
1562: l_index := l_index + 1;
1563: l_databuffer_tbl(l_index) := ' BEGIN REGION_LOV_RELATION "' ||
1564: nvl(to_char(l_lov_relation_rec.lov_region_appl_id), '') || '" "' ||
1565: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.lov_region_code) || '" "'||
1566: nvl(to_char(l_lov_relation_rec.lov_attribute_appl_id), '') || '" "' ||
1567: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.lov_attribute_code) || '" "'||
1568: nvl(to_char(l_lov_relation_rec.base_attribute_appl_id), '') || '" "' ||
1569: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.base_attribute_code)|| '" "'||
1563: l_databuffer_tbl(l_index) := ' BEGIN REGION_LOV_RELATION "' ||
1564: nvl(to_char(l_lov_relation_rec.lov_region_appl_id), '') || '" "' ||
1565: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.lov_region_code) || '" "'||
1566: nvl(to_char(l_lov_relation_rec.lov_attribute_appl_id), '') || '" "' ||
1567: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.lov_attribute_code) || '" "'||
1568: nvl(to_char(l_lov_relation_rec.base_attribute_appl_id), '') || '" "' ||
1569: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.base_attribute_code)|| '" "'||
1570: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.direction_flag)|| '"';
1571: if ((l_lov_relation_rec.base_region_appl_id IS NOT NULL) and
1565: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.lov_region_code) || '" "'||
1566: nvl(to_char(l_lov_relation_rec.lov_attribute_appl_id), '') || '" "' ||
1567: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.lov_attribute_code) || '" "'||
1568: nvl(to_char(l_lov_relation_rec.base_attribute_appl_id), '') || '" "' ||
1569: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.base_attribute_code)|| '" "'||
1570: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.direction_flag)|| '"';
1571: if ((l_lov_relation_rec.base_region_appl_id IS NOT NULL) and
1572: (l_lov_relation_rec.base_region_appl_id <> FND_API.G_MISS_NUM)) then
1573: l_index := l_index + 1;
1566: nvl(to_char(l_lov_relation_rec.lov_attribute_appl_id), '') || '" "' ||
1567: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.lov_attribute_code) || '" "'||
1568: nvl(to_char(l_lov_relation_rec.base_attribute_appl_id), '') || '" "' ||
1569: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.base_attribute_code)|| '" "'||
1570: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.direction_flag)|| '"';
1571: if ((l_lov_relation_rec.base_region_appl_id IS NOT NULL) and
1572: (l_lov_relation_rec.base_region_appl_id <> FND_API.G_MISS_NUM)) then
1573: l_index := l_index + 1;
1574: l_databuffer_tbl(l_index) := ' BASE_REGION_APPL_ID = "' ||
1577: if ((l_lov_relation_rec.base_region_code IS NOT NULL) and
1578: (l_lov_relation_rec.base_region_code <> FND_API.G_MISS_CHAR)) then
1579: l_index := l_index + 1;
1580: l_databuffer_tbl(l_index) := ' BASE_REGION_CODE = "' ||
1581: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.base_region_code) || '"';
1582: end if;
1583: l_index := l_index + 1;
1584: l_databuffer_tbl(l_index) := ' REQUIRED_FLAG = "' ||
1585: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.required_flag) ||
1581: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.base_region_code) || '"';
1582: end if;
1583: l_index := l_index + 1;
1584: l_databuffer_tbl(l_index) := ' REQUIRED_FLAG = "' ||
1585: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_lov_relation_rec.required_flag) ||
1586: '"';
1587: -- - Write out who columns
1588: l_index := l_index + 1;
1589: l_databuffer_tbl(l_index) := ' CREATED_BY = "' ||
1611: l_index := l_index + 1;
1612: l_databuffer_tbl(l_index) := ' ';
1613:
1614: -- - Write the 'END REGION_LOV_RELATION' to the specified file
1615: AK_ON_OBJECTS_PVT.WRITE_FILE (
1616: p_return_status => l_return_status,
1617: p_buffer_tbl => l_databuffer_tbl,
1618: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1619: );
1745: p_display_flag => l_graphs_rec.display_flag,
1746: p_depth_radius => l_graphs_rec.depth_radius,
1747: p_graph_title => l_graphs_tl_rec.graph_title,
1748: p_y_axis_label => l_graphs_tl_rec.y_axis_label,
1749: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
1750: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1751: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_DOWNLOADED');
1752: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1753: ' ' || p_region_code ||
1769: if ((l_graphs_rec.display_flag IS NOT NULL) and
1770: (l_graphs_rec.display_flag <> FND_API.G_MISS_CHAR)) then
1771: l_index := l_index + 1;
1772: l_databuffer_tbl(l_index) := ' DISPLAY_FLAG = "' ||
1773: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_graphs_rec.display_flag)||
1774: '"';
1775: end if;
1776: if ((l_graphs_rec.depth_radius IS NOT NULL) and
1777: (l_graphs_rec.depth_radius <> FND_API.G_MISS_NUM)) then
1801: if ((l_graphs_tl_rec.graph_title IS NOT NULL) and
1802: (l_graphs_tl_rec.graph_title <> FND_API.G_MISS_CHAR)) then
1803: l_index := l_index + 1;
1804: l_databuffer_tbl(l_index) := ' GRAPH_TITLE = "'||
1805: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_graphs_tl_rec.graph_title)||
1806: '"';
1807: end if;
1808: if ((l_graphs_tl_rec.y_axis_label IS NOT NULL) and
1809: (l_graphs_tl_rec.graph_title <> FND_API.G_MISS_CHAR)) then
1808: if ((l_graphs_tl_rec.y_axis_label IS NOT NULL) and
1809: (l_graphs_tl_rec.graph_title <> FND_API.G_MISS_CHAR)) then
1810: l_index := l_index + 1;
1811: l_databuffer_tbl(l_index) := ' Y_AXIS_LABEL = "'||
1812: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_graphs_tl_rec.y_axis_label)||
1813: '"';
1814: end if;
1815:
1816: -- - Write the region graph data to the specified file
1813: '"';
1814: end if;
1815:
1816: -- - Write the region graph data to the specified file
1817: AK_ON_OBJECTS_PVT.WRITE_FILE (
1818: p_return_status => l_return_status,
1819: p_buffer_tbl => l_databuffer_tbl,
1820: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1821: );
1873: -- - Write region item data out to the specified file
1874: -- don't call write_file if there are no items for this region
1875:
1876: if (l_databuffer_tbl.count > 0) then
1877: AK_ON_OBJECTS_PVT.WRITE_FILE (
1878: p_return_status => l_return_status,
1879: p_buffer_tbl => l_databuffer_tbl,
1880: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1881: );
2076: p_customization_application_id => l_items_rec.customization_application_id,
2077: p_customization_code => l_items_rec.customization_code,
2078: p_attribute_label_long => l_items_tl_rec.attribute_label_long,
2079: p_attribute_label_short => l_items_tl_rec.attribute_label_short,
2080: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
2081: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2082: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_DOWNLOADED');
2083: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
2084: ' ' || p_region_code ||
2094: l_databuffer_tbl(l_index) := ' ';
2095: l_index := l_index + 1;
2096: l_databuffer_tbl(l_index) := ' BEGIN REGION_ITEM "' ||
2097: l_items_rec.attribute_application_id || '" "' ||
2098: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.attribute_code) ||
2099: '"';
2100: l_index := l_index + 1;
2101: l_databuffer_tbl(l_index) := ' DISPLAY_SEQUENCE = "' ||
2102: nvl(to_char(l_items_rec.display_sequence),'') || '"';
2101: l_databuffer_tbl(l_index) := ' DISPLAY_SEQUENCE = "' ||
2102: nvl(to_char(l_items_rec.display_sequence),'') || '"';
2103: l_index := l_index + 1;
2104: l_databuffer_tbl(l_index) := ' NODE_DISPLAY_FLAG = "' ||
2105: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.node_display_flag)||
2106: '"';
2107: l_index := l_index + 1;
2108: l_databuffer_tbl(l_index) := ' NODE_QUERY_FLAG = "' ||
2109: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.node_query_flag) ||
2105: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.node_display_flag)||
2106: '"';
2107: l_index := l_index + 1;
2108: l_databuffer_tbl(l_index) := ' NODE_QUERY_FLAG = "' ||
2109: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.node_query_flag) ||
2110: '"';
2111: l_index := l_index + 1;
2112: l_databuffer_tbl(l_index) := ' ATTRIBUTE_LABEL_LENGTH = "' ||
2113: nvl(to_char(l_items_rec.attribute_label_length),'') || '"';
2115: l_databuffer_tbl(l_index) := ' DISPLAY_VALUE_LENGTH = "' ||
2116: nvl(to_char(l_items_rec.display_value_length),'') || '"';
2117: l_index := l_index + 1;
2118: l_databuffer_tbl(l_index) := ' BOLD = "' ||
2119: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.bold) || '"';
2120: l_index := l_index + 1;
2121: l_databuffer_tbl(l_index) := ' ITALIC = "' ||
2122: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.italic) || '"';
2123: l_index := l_index + 1;
2118: l_databuffer_tbl(l_index) := ' BOLD = "' ||
2119: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.bold) || '"';
2120: l_index := l_index + 1;
2121: l_databuffer_tbl(l_index) := ' ITALIC = "' ||
2122: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.italic) || '"';
2123: l_index := l_index + 1;
2124: l_databuffer_tbl(l_index) := ' VERTICAL_ALIGNMENT = "' ||
2125: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.vertical_alignment)
2126: || '"';
2121: l_databuffer_tbl(l_index) := ' ITALIC = "' ||
2122: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.italic) || '"';
2123: l_index := l_index + 1;
2124: l_databuffer_tbl(l_index) := ' VERTICAL_ALIGNMENT = "' ||
2125: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.vertical_alignment)
2126: || '"';
2127: l_index := l_index + 1;
2128: l_databuffer_tbl(l_index) := ' HORIZONTAL_ALIGNMENT = "' ||
2129: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2125: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.vertical_alignment)
2126: || '"';
2127: l_index := l_index + 1;
2128: l_databuffer_tbl(l_index) := ' HORIZONTAL_ALIGNMENT = "' ||
2129: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2130: l_items_rec.horizontal_alignment)|| '"';
2131: l_index := l_index + 1;
2132: l_databuffer_tbl(l_index) := ' ITEM_STYLE = "' ||
2133: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.item_style) || '"';
2129: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2130: l_items_rec.horizontal_alignment)|| '"';
2131: l_index := l_index + 1;
2132: l_databuffer_tbl(l_index) := ' ITEM_STYLE = "' ||
2133: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.item_style) || '"';
2134: l_index := l_index + 1;
2135: l_databuffer_tbl(l_index) := ' OBJECT_ATTRIBUTE_FLAG = "' ||
2136: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2137: l_items_rec.object_attribute_flag) || '"';
2132: l_databuffer_tbl(l_index) := ' ITEM_STYLE = "' ||
2133: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_items_rec.item_style) || '"';
2134: l_index := l_index + 1;
2135: l_databuffer_tbl(l_index) := ' OBJECT_ATTRIBUTE_FLAG = "' ||
2136: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2137: l_items_rec.object_attribute_flag) || '"';
2138:
2139: if ((l_items_rec.icx_custom_call IS NOT NULL) and
2140: (l_items_rec.icx_custom_call <> FND_API.G_MISS_CHAR)) then
2139: if ((l_items_rec.icx_custom_call IS NOT NULL) and
2140: (l_items_rec.icx_custom_call <> FND_API.G_MISS_CHAR)) then
2141: l_index := l_index + 1;
2142: l_databuffer_tbl(l_index) := ' ICX_CUSTOM_CALL = "' ||
2143: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2144: l_items_rec.icx_custom_call) || '"';
2145: end if;
2146:
2147: l_index := l_index + 1;
2145: end if;
2146:
2147: l_index := l_index + 1;
2148: l_databuffer_tbl(l_index) := ' UPDATE_FLAG = "' ||
2149: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2150: l_items_rec.update_flag) || '"';
2151: l_index := l_index + 1;
2152: l_databuffer_tbl(l_index) := ' REQUIRED_FLAG = "' ||
2153: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2149: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2150: l_items_rec.update_flag) || '"';
2151: l_index := l_index + 1;
2152: l_databuffer_tbl(l_index) := ' REQUIRED_FLAG = "' ||
2153: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2154: l_items_rec.required_flag) || '"';
2155: if ((l_items_rec.security_code IS NOT NULL) and
2156: (l_items_rec.security_code <> FND_API.G_MISS_CHAR)) then
2157: l_index := l_index + 1;
2155: if ((l_items_rec.security_code IS NOT NULL) and
2156: (l_items_rec.security_code <> FND_API.G_MISS_CHAR)) then
2157: l_index := l_index + 1;
2158: l_databuffer_tbl(l_index) := ' SECURITY_CODE = "' ||
2159: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2160: l_items_rec.security_code) || '"';
2161: end if;
2162: if ((l_items_rec.default_value_varchar2 IS NOT NULL) and
2163: (l_items_rec.default_value_varchar2 <> FND_API.G_MISS_CHAR)) then
2162: if ((l_items_rec.default_value_varchar2 IS NOT NULL) and
2163: (l_items_rec.default_value_varchar2 <> FND_API.G_MISS_CHAR)) then
2164: l_index := l_index + 1;
2165: l_databuffer_tbl(l_index) := ' DEFAULT_VALUE_VARCHAR2 = "' ||
2166: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2167: l_items_rec.default_value_varchar2) || '"';
2168: end if;
2169: if ((l_items_rec.default_value_number IS NOT NULL) and
2170: (l_items_rec.default_value_number <> FND_API.G_MISS_NUM)) then
2185: (l_items_rec.lov_region_code <> FND_API.G_MISS_CHAR)) then
2186: l_index := l_index + 1;
2187: l_databuffer_tbl(l_index) := ' LOV_REGION = "' ||
2188: nvl(to_char(l_items_rec.lov_region_application_id),'')||'" "'||
2189: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2190: l_items_rec.lov_region_code)|| '"';
2191: end if;
2192: if ((l_items_rec.lov_foreign_key_name IS NOT NULL) and
2193: (l_items_rec.lov_foreign_key_name <> FND_API.G_MISS_CHAR)) then
2192: if ((l_items_rec.lov_foreign_key_name IS NOT NULL) and
2193: (l_items_rec.lov_foreign_key_name <> FND_API.G_MISS_CHAR)) then
2194: l_index := l_index + 1;
2195: l_databuffer_tbl(l_index) := ' LOV_FOREIGN_KEY_NAME = "' ||
2196: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2197: l_items_rec.lov_foreign_key_name)|| '"';
2198: end if;
2199: if ((l_items_rec.lov_attribute_application_id IS NOT NULL) and
2200: (l_items_rec.lov_attribute_application_id <> FND_API.G_MISS_NUM) and
2202: (l_items_rec.lov_attribute_code <> FND_API.G_MISS_CHAR)) then
2203: l_index := l_index + 1;
2204: l_databuffer_tbl(l_index) := ' LOV_ATTRIBUTE = "' ||
2205: nvl(to_char(l_items_rec.lov_attribute_application_id),'')||'" "'||
2206: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2207: l_items_rec.lov_attribute_code)|| '"';
2208: end if;
2209: if ((l_items_rec.lov_default_flag IS NOT NULL) and
2210: (l_items_rec.lov_default_flag <> FND_API.G_MISS_CHAR)) then
2209: if ((l_items_rec.lov_default_flag IS NOT NULL) and
2210: (l_items_rec.lov_default_flag <> FND_API.G_MISS_CHAR)) then
2211: l_index := l_index + 1;
2212: l_databuffer_tbl(l_index) := ' LOV_DEFAULT_FLAG = "' ||
2213: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2214: l_items_rec.lov_default_flag)|| '"';
2215: end if;
2216: if ((l_items_rec.region_defaulting_api_pkg IS NOT NULL) and
2217: (l_items_rec.region_defaulting_api_pkg <> FND_API.G_MISS_CHAR)) then
2216: if ((l_items_rec.region_defaulting_api_pkg IS NOT NULL) and
2217: (l_items_rec.region_defaulting_api_pkg <> FND_API.G_MISS_CHAR)) then
2218: l_index := l_index + 1;
2219: l_databuffer_tbl(l_index) := ' REGION_DEFAULTING_API_PKG = "' ||
2220: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2221: l_items_rec.region_defaulting_api_pkg)|| '"';
2222: end if;
2223: if ((l_items_rec.region_defaulting_api_proc IS NOT NULL) and
2224: (l_items_rec.region_defaulting_api_proc <> FND_API.G_MISS_CHAR)) then
2223: if ((l_items_rec.region_defaulting_api_proc IS NOT NULL) and
2224: (l_items_rec.region_defaulting_api_proc <> FND_API.G_MISS_CHAR)) then
2225: l_index := l_index + 1;
2226: l_databuffer_tbl(l_index) := ' REGION_DEFAULTING_API_PROC = "' ||
2227: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2228: l_items_rec.region_defaulting_api_proc)|| '"';
2229: end if;
2230: if ((l_items_rec.region_validation_api_pkg IS NOT NULL) and
2231: (l_items_rec.region_validation_api_pkg <> FND_API.G_MISS_CHAR)) then
2230: if ((l_items_rec.region_validation_api_pkg IS NOT NULL) and
2231: (l_items_rec.region_validation_api_pkg <> FND_API.G_MISS_CHAR)) then
2232: l_index := l_index + 1;
2233: l_databuffer_tbl(l_index) := ' REGION_VALIDATION_API_PKG = "' ||
2234: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2235: l_items_rec.region_validation_api_pkg)|| '"';
2236: end if;
2237: if ((l_items_rec.region_validation_api_proc IS NOT NULL) and
2238: (l_items_rec.region_validation_api_proc <> FND_API.G_MISS_CHAR)) then
2237: if ((l_items_rec.region_validation_api_proc IS NOT NULL) and
2238: (l_items_rec.region_validation_api_proc <> FND_API.G_MISS_CHAR)) then
2239: l_index := l_index + 1;
2240: l_databuffer_tbl(l_index) := ' REGION_VALIDATION_API_PROC = "' ||
2241: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2242: l_items_rec.region_validation_api_proc) || '"';
2243: end if;
2244: if ((l_items_rec.order_sequence IS NOT NULL) and
2245: (l_items_rec.order_sequence <> FND_API.G_MISS_NUM)) then
2250: if ((l_items_rec.order_direction IS NOT NULL) and
2251: (l_items_rec.order_direction <> FND_API.G_MISS_CHAR)) then
2252: l_index := l_index + 1;
2253: l_databuffer_tbl(l_index) := ' ORDER_DIRECTION = "' ||
2254: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2255: l_items_rec.order_direction)|| '"';
2256: end if;
2257:
2258: -- new columns for JSP renderer
2265: if ((l_items_rec.submit IS NOT NULL) and
2266: (l_items_rec.submit <> FND_API.G_MISS_CHAR)) then
2267: l_index := l_index + 1;
2268: l_databuffer_tbl(l_index) := ' SUBMIT = "' ||
2269: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2270: l_items_rec.submit)|| '"';
2271: end if;
2272: if ((l_items_rec.encrypt IS NOT NULL) and
2273: (l_items_rec.encrypt <> FND_API.G_MISS_CHAR)) then
2272: if ((l_items_rec.encrypt IS NOT NULL) and
2273: (l_items_rec.encrypt <> FND_API.G_MISS_CHAR)) then
2274: l_index := l_index + 1;
2275: l_databuffer_tbl(l_index) := ' ENCRYPT = "' ||
2276: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2277: l_items_rec.encrypt)|| '"';
2278: end if;
2279: if ((l_items_rec.css_class_name IS NOT NULL) and
2280: (l_items_rec.css_class_name <> FND_API.G_MISS_CHAR)) then
2279: if ((l_items_rec.css_class_name IS NOT NULL) and
2280: (l_items_rec.css_class_name <> FND_API.G_MISS_CHAR)) then
2281: l_index := l_index + 1;
2282: l_databuffer_tbl(l_index) := ' CSS_CLASS_NAME = "' ||
2283: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2284: l_items_rec.css_class_name)|| '"';
2285: end if;
2286: if ((l_items_rec.view_usage_name IS NOT NULL) and
2287: (l_items_rec.view_usage_name <> FND_API.G_MISS_CHAR)) then
2286: if ((l_items_rec.view_usage_name IS NOT NULL) and
2287: (l_items_rec.view_usage_name <> FND_API.G_MISS_CHAR)) then
2288: l_index := l_index + 1;
2289: l_databuffer_tbl(l_index) := ' VIEW_USAGE_NAME = "' ||
2290: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2291: l_items_rec.view_usage_name)|| '"';
2292: end if;
2293: if ((l_items_rec.view_attribute_name IS NOT NULL) and
2294: (l_items_rec.view_attribute_name <> FND_API.G_MISS_CHAR)) then
2293: if ((l_items_rec.view_attribute_name IS NOT NULL) and
2294: (l_items_rec.view_attribute_name <> FND_API.G_MISS_CHAR)) then
2295: l_index := l_index + 1;
2296: l_databuffer_tbl(l_index) := ' VIEW_ATTRIBUTE_NAME = "' ||
2297: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2298: l_items_rec.view_attribute_name)|| '"';
2299: end if;
2300: if ((l_items_rec.nested_region_application_id IS NOT NULL) and
2301: (l_items_rec.nested_region_application_id <> FND_API.G_MISS_NUM)) then
2306: if ((l_items_rec.nested_region_code IS NOT NULL) and
2307: (l_items_rec.nested_region_code <> FND_API.G_MISS_CHAR)) then
2308: l_index := l_index + 1;
2309: l_databuffer_tbl(l_index) := ' NESTED_REGION_CODE = "' ||
2310: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2311: l_items_rec.nested_region_code)|| '"';
2312: end if;
2313: if ((l_items_rec.url IS NOT NULL) and
2314: (l_items_rec.url <> FND_API.G_MISS_CHAR)) then
2313: if ((l_items_rec.url IS NOT NULL) and
2314: (l_items_rec.url <> FND_API.G_MISS_CHAR)) then
2315: l_index := l_index + 1;
2316: l_databuffer_tbl(l_index) := ' URL = "' ||
2317: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2318: l_items_rec.url)|| '"';
2319: end if;
2320: if ((l_items_rec.poplist_viewobject IS NOT NULL) and
2321: (l_items_rec.poplist_viewobject <> FND_API.G_MISS_CHAR)) then
2320: if ((l_items_rec.poplist_viewobject IS NOT NULL) and
2321: (l_items_rec.poplist_viewobject <> FND_API.G_MISS_CHAR)) then
2322: l_index := l_index + 1;
2323: l_databuffer_tbl(l_index) := ' POPLIST_VIEWOBJECT = "' ||
2324: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2325: l_items_rec.poplist_viewobject)|| '"';
2326: end if;
2327: if ((l_items_rec.poplist_display_attribute IS NOT NULL) and
2328: (l_items_rec.poplist_display_attribute <> FND_API.G_MISS_CHAR)) then
2327: if ((l_items_rec.poplist_display_attribute IS NOT NULL) and
2328: (l_items_rec.poplist_display_attribute <> FND_API.G_MISS_CHAR)) then
2329: l_index := l_index + 1;
2330: l_databuffer_tbl(l_index) := ' POPLIST_DISPLAY_ATTRIBUTE = "' ||
2331: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2332: l_items_rec.poplist_display_attribute)|| '"';
2333: end if;
2334: if ((l_items_rec.poplist_value_attribute IS NOT NULL) and
2335: (l_items_rec.poplist_value_attribute <> FND_API.G_MISS_CHAR)) then
2334: if ((l_items_rec.poplist_value_attribute IS NOT NULL) and
2335: (l_items_rec.poplist_value_attribute <> FND_API.G_MISS_CHAR)) then
2336: l_index := l_index + 1;
2337: l_databuffer_tbl(l_index) := ' POPLIST_VALUE_ATTRIBUTE = "' ||
2338: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2339: l_items_rec.poplist_value_attribute)|| '"';
2340: end if;
2341: if ((l_items_rec.image_file_name IS NOT NULL) and
2342: (l_items_rec.image_file_name <> FND_API.G_MISS_CHAR)) then
2341: if ((l_items_rec.image_file_name IS NOT NULL) and
2342: (l_items_rec.image_file_name <> FND_API.G_MISS_CHAR)) then
2343: l_index := l_index + 1;
2344: l_databuffer_tbl(l_index) := ' IMAGE_FILE_NAME = "' ||
2345: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2346: l_items_rec.image_file_name)|| '"';
2347: end if;
2348: if ((l_items_rec.item_name IS NOT NULL) and
2349: (l_items_rec.item_name <> FND_API.G_MISS_CHAR)) then
2348: if ((l_items_rec.item_name IS NOT NULL) and
2349: (l_items_rec.item_name <> FND_API.G_MISS_CHAR)) then
2350: l_index := l_index + 1;
2351: l_databuffer_tbl(l_index) := ' ITEM_NAME = "' ||
2352: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2353: l_items_rec.item_name)|| '"';
2354: end if;
2355: if ((l_items_rec.css_label_class_name IS NOT NULL) and
2356: (l_items_rec.css_label_class_name <> FND_API.G_MISS_CHAR)) then
2355: if ((l_items_rec.css_label_class_name IS NOT NULL) and
2356: (l_items_rec.css_label_class_name <> FND_API.G_MISS_CHAR)) then
2357: l_index := l_index + 1;
2358: l_databuffer_tbl(l_index) := ' CSS_LABEL_CLASS_NAME = "' ||
2359: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2360: l_items_rec.css_label_class_name)|| '"';
2361: end if;
2362: if ((l_items_rec.menu_name IS NOT NULL) and
2363: (l_items_rec.menu_name <> FND_API.G_MISS_CHAR)) then
2362: if ((l_items_rec.menu_name IS NOT NULL) and
2363: (l_items_rec.menu_name <> FND_API.G_MISS_CHAR)) then
2364: l_index := l_index + 1;
2365: l_databuffer_tbl(l_index) := ' MENU_NAME = "' ||
2366: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2367: l_items_rec.menu_name)|| '"';
2368: end if;
2369: -- Flexfield References for region items that point at flex definitions
2370: if ((l_items_rec.flexfield_name IS NOT NULL) and
2370: if ((l_items_rec.flexfield_name IS NOT NULL) and
2371: (l_items_rec.flexfield_name <> FND_API.G_MISS_CHAR)) then
2372: l_index := l_index + 1;
2373: l_databuffer_tbl(l_index) := ' FLEXFIELD_NAME = "' ||
2374: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2375: l_items_rec.flexfield_name)|| '"';
2376: end if;
2377: if ((l_items_rec.flexfield_application_id IS NOT NULL) and
2378: (l_items_rec.flexfield_application_id <> FND_API.G_MISS_NUM)) then
2385: if ((l_items_rec.tabular_function_code IS NOT NULL) and
2386: (l_items_rec.tabular_function_code <> FND_API.G_MISS_CHAR)) then
2387: l_index := l_index + 1;
2388: l_databuffer_tbl(l_index) := ' TABULAR_FUNCTION_CODE = "' ||
2389: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2390: l_items_rec.tabular_function_code)|| '"';
2391: end if;
2392:
2393: -- Tip Type
2394: if ((l_items_rec.tip_type IS NOT NULL) and
2395: (l_items_rec.tip_type <> FND_API.G_MISS_CHAR)) then
2396: l_index := l_index + 1;
2397: l_databuffer_tbl(l_index) := ' TIP_TYPE = "' ||
2398: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2399: l_items_rec.tip_type)|| '"';
2400: end if;
2401:
2402: -- Tip Message
2403: if ((l_items_rec.tip_message_name IS NOT NULL) and
2404: (l_items_rec.tip_message_name <> FND_API.G_MISS_CHAR)) then
2405: l_index := l_index + 1;
2406: l_databuffer_tbl(l_index) := ' TIP_MESSAGE_NAME = "' ||
2407: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2408: l_items_rec.tip_message_name)|| '"';
2409: end if;
2410: if ((l_items_rec.tip_message_application_id IS NOT NULL) and
2411: (l_items_rec.tip_message_application_id <> FND_API.G_MISS_NUM)) then
2418: if ((l_items_rec.flex_segment_list IS NOT NULL) and
2419: (l_items_rec.flex_segment_list <> FND_API.G_MISS_CHAR)) then
2420: l_index := l_index + 1;
2421: l_databuffer_tbl(l_index) := ' FLEX_SEGMENT_LIST = "' ||
2422: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2423: l_items_rec.flex_segment_list)|| '"';
2424: end if;
2425:
2426: -- Entity Id
2427: if ((l_items_rec.entity_id IS NOT NULL) and
2428: (l_items_rec.entity_id <> FND_API.G_MISS_CHAR)) then
2429: l_index := l_index + 1;
2430: l_databuffer_tbl(l_index) := ' ENTITY_ID = "' ||
2431: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2432: l_items_rec.entity_id)|| '"';
2433: end if;
2434:
2435: -- Anchor
2436: if ((l_items_rec.anchor IS NOT NULL) and
2437: (l_items_rec.anchor <> FND_API.G_MISS_CHAR)) then
2438: l_index := l_index + 1;
2439: l_databuffer_tbl(l_index) := ' ANCHOR = "' ||
2440: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2441: l_items_rec.anchor)|| '"';
2442: end if;
2443:
2444: -- Poplist view usage name
2445: if ((l_items_rec.poplist_view_usage_name IS NOT NULL) and
2446: (l_items_rec.poplist_view_usage_name <> FND_API.G_MISS_CHAR)) then
2447: l_index := l_index + 1;
2448: l_databuffer_tbl(l_index) := ' POPLIST_VIEW_USAGE_NAME = "' ||
2449: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2450: l_items_rec.poplist_view_usage_name)|| '"';
2451: end if;
2452:
2453: -- User Customizable
2454: if ((l_items_rec.user_customizable IS NOT NULL) and
2455: (l_items_rec.user_customizable <> FND_API.G_MISS_CHAR)) then
2456: l_index := l_index + 1;
2457: l_databuffer_tbl(l_index) := ' USER_CUSTOMIZABLE = "' ||
2458: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2459: l_items_rec.user_customizable)|| '"';
2460: end if;
2461:
2462: -- Sortby view attribute name
2463: if ((l_items_rec.sortby_view_attribute_name IS NOT NULL) and
2464: (l_items_rec.sortby_view_attribute_name <> FND_API.G_MISS_CHAR)) then
2465: l_index := l_index + 1;
2466: l_databuffer_tbl(l_index) := ' SORTBY_VIEW_ATTRIBUTE_NAME = "' ||
2467: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2468: l_items_rec.sortby_view_attribute_name)|| '"';
2469: end if;
2470:
2471: -- Admin Customizable
2472: if ((l_items_rec.admin_customizable IS NOT NULL) and
2473: (l_items_rec.admin_customizable <> FND_API.G_MISS_CHAR)) then
2474: l_index := l_index + 1;
2475: l_databuffer_tbl(l_index) := ' ADMIN_CUSTOMIZABLE = "' ||
2476: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2477: l_items_rec.admin_customizable)|| '"';
2478: end if;
2479:
2480: -- Invoke Function Name
2481: if ((l_items_rec.invoke_function_name IS NOT NULL) and
2482: (l_items_rec.invoke_function_name <> FND_API.G_MISS_CHAR)) then
2483: l_index := l_index + 1;
2484: l_databuffer_tbl(l_index) := ' INVOKE_FUNCTION_NAME = "' ||
2485: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2486: l_items_rec.invoke_function_name)|| '"';
2487: end if;
2488:
2489: -- Expansion
2506: if ((l_items_rec.initial_sort_sequence IS NOT NULL) and
2507: (l_items_rec.initial_sort_sequence <> FND_API.G_MISS_CHAR)) then
2508: l_index := l_index + 1;
2509: l_databuffer_tbl(l_index) := ' INITIAL_SORT_SEQUENCE = "' ||
2510: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2511: l_items_rec.initial_sort_sequence)|| '"';
2512: end if;
2513:
2514: -- CUSTOMIZATION_APPLICATION_ID
2523: if ((l_items_rec.customization_code IS NOT NULL) and
2524: (l_items_rec.customization_code <> FND_API.G_MISS_CHAR)) then
2525: l_index := l_index + 1;
2526: l_databuffer_tbl(l_index) := ' CUSTOMIZATION_CODE = "' ||
2527: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2528: l_items_rec.customization_code)|| '"';
2529: end if;
2530:
2531:
2534: if ((l_items_rec.attribute_category IS NOT NULL) and
2535: (l_items_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
2536: l_index := l_index + 1;
2537: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
2538: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2539: l_items_rec.attribute_category) || '"';
2540: end if;
2541: if ((l_items_rec.attribute1 IS NOT NULL) and
2542: (l_items_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
2541: if ((l_items_rec.attribute1 IS NOT NULL) and
2542: (l_items_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
2543: l_index := l_index + 1;
2544: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
2545: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2546: l_items_rec.attribute1) || '"';
2547: end if;
2548: if ((l_items_rec.attribute2 IS NOT NULL) and
2549: (l_items_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
2548: if ((l_items_rec.attribute2 IS NOT NULL) and
2549: (l_items_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
2550: l_index := l_index + 1;
2551: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
2552: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2553: l_items_rec.attribute2) || '"';
2554: end if;
2555: if ((l_items_rec.attribute3 IS NOT NULL) and
2556: (l_items_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
2555: if ((l_items_rec.attribute3 IS NOT NULL) and
2556: (l_items_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
2557: l_index := l_index + 1;
2558: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
2559: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2560: l_items_rec.attribute3) || '"';
2561: end if;
2562: if ((l_items_rec.attribute4 IS NOT NULL) and
2563: (l_items_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
2562: if ((l_items_rec.attribute4 IS NOT NULL) and
2563: (l_items_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
2564: l_index := l_index + 1;
2565: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
2566: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2567: l_items_rec.attribute4) || '"';
2568: end if;
2569: if ((l_items_rec.attribute5 IS NOT NULL) and
2570: (l_items_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
2569: if ((l_items_rec.attribute5 IS NOT NULL) and
2570: (l_items_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
2571: l_index := l_index + 1;
2572: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
2573: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2574: l_items_rec.attribute5) || '"';
2575: end if;
2576: if ((l_items_rec.attribute6 IS NOT NULL) and
2577: (l_items_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
2576: if ((l_items_rec.attribute6 IS NOT NULL) and
2577: (l_items_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
2578: l_index := l_index + 1;
2579: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
2580: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2581: l_items_rec.attribute6) || '"';
2582: end if;
2583: if ((l_items_rec.attribute7 IS NOT NULL) and
2584: (l_items_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
2583: if ((l_items_rec.attribute7 IS NOT NULL) and
2584: (l_items_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
2585: l_index := l_index + 1;
2586: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
2587: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2588: l_items_rec.attribute7) || '"';
2589: end if;
2590: if ((l_items_rec.attribute8 IS NOT NULL) and
2591: (l_items_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
2590: if ((l_items_rec.attribute8 IS NOT NULL) and
2591: (l_items_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
2592: l_index := l_index + 1;
2593: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
2594: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2595: l_items_rec.attribute8) || '"';
2596: end if;
2597: if ((l_items_rec.attribute9 IS NOT NULL) and
2598: (l_items_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
2597: if ((l_items_rec.attribute9 IS NOT NULL) and
2598: (l_items_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
2599: l_index := l_index + 1;
2600: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
2601: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2602: l_items_rec.attribute9) || '"';
2603: end if;
2604: if ((l_items_rec.attribute10 IS NOT NULL) and
2605: (l_items_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
2604: if ((l_items_rec.attribute10 IS NOT NULL) and
2605: (l_items_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
2606: l_index := l_index + 1;
2607: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
2608: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2609: l_items_rec.attribute10) || '"';
2610: end if;
2611: if ((l_items_rec.attribute11 IS NOT NULL) and
2612: (l_items_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
2611: if ((l_items_rec.attribute11 IS NOT NULL) and
2612: (l_items_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
2613: l_index := l_index + 1;
2614: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
2615: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2616: l_items_rec.attribute11) || '"';
2617: end if;
2618: if ((l_items_rec.attribute12 IS NOT NULL) and
2619: (l_items_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
2618: if ((l_items_rec.attribute12 IS NOT NULL) and
2619: (l_items_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
2620: l_index := l_index + 1;
2621: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
2622: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2623: l_items_rec.attribute12) || '"';
2624: end if;
2625: if ((l_items_rec.attribute13 IS NOT NULL) and
2626: (l_items_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
2625: if ((l_items_rec.attribute13 IS NOT NULL) and
2626: (l_items_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
2627: l_index := l_index + 1;
2628: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
2629: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2630: l_items_rec.attribute13) || '"';
2631: end if;
2632: if ((l_items_rec.attribute14 IS NOT NULL) and
2633: (l_items_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
2632: if ((l_items_rec.attribute14 IS NOT NULL) and
2633: (l_items_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
2634: l_index := l_index + 1;
2635: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
2636: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2637: l_items_rec.attribute14) || '"';
2638: end if;
2639: if ((l_items_rec.attribute15 IS NOT NULL) and
2640: (l_items_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
2639: if ((l_items_rec.attribute15 IS NOT NULL) and
2640: (l_items_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
2641: l_index := l_index + 1;
2642: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
2643: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2644: l_items_rec.attribute15) || '"';
2645: end if;
2646: -- - Write out who columns
2647: l_index := l_index + 1;
2669: if ((l_items_tl_rec.attribute_label_long IS NOT NULL) and
2670: (l_items_tl_rec.attribute_label_long <> FND_API.G_MISS_CHAR)) then
2671: l_index := l_index + 1;
2672: l_databuffer_tbl(l_index) := ' ATTRIBUTE_LABEL_LONG = "' ||
2673: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2674: l_items_tl_rec.attribute_label_long)|| '"';
2675: end if;
2676: if ((l_items_tl_rec.attribute_label_short IS NOT NULL) and
2677: (l_items_tl_rec.attribute_label_short <> FND_API.G_MISS_CHAR)) then
2676: if ((l_items_tl_rec.attribute_label_short IS NOT NULL) and
2677: (l_items_tl_rec.attribute_label_short <> FND_API.G_MISS_CHAR)) then
2678: l_index := l_index + 1;
2679: l_databuffer_tbl(l_index) := ' ATTRIBUTE_LABEL_SHORT = "' ||
2680: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2681: l_items_tl_rec.attribute_label_short)|| '"';
2682: end if;
2683: if ((l_items_tl_rec.description IS NOT NULL) and
2684: (l_items_tl_rec.description <> FND_API.G_MISS_CHAR)) then
2683: if ((l_items_tl_rec.description IS NOT NULL) and
2684: (l_items_tl_rec.description <> FND_API.G_MISS_CHAR)) then
2685: l_index := l_index + 1;
2686: l_databuffer_tbl(l_index) := ' DESCRIPTION = "' ||
2687: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2688: l_items_tl_rec.description)|| '"';
2689: end if;
2690:
2691: -- - Write the region item data to the specified file
2688: l_items_tl_rec.description)|| '"';
2689: end if;
2690:
2691: -- - Write the region item data to the specified file
2692: AK_ON_OBJECTS_PVT.WRITE_FILE (
2693: p_return_status => l_return_status,
2694: p_buffer_tbl => l_databuffer_tbl,
2695: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
2696: );
2769: -- - Write region item data out to the specified file
2770: -- don't call write_file if there are no items for this region
2771:
2772: if (l_databuffer_tbl.count > 0) then
2773: AK_ON_OBJECTS_PVT.WRITE_FILE (
2774: p_return_status => l_return_status,
2775: p_buffer_tbl => l_databuffer_tbl,
2776: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
2777: );
2904: p_region_validation_api_proc =>
2905: l_regions_rec.region_validation_api_proc,
2906: p_name => l_regions_tl_rec.name,
2907: p_description => l_regions_tl_rec.description,
2908: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
2909: then
2910: -- dbms_output.put_line('Region ' || p_region_code
2911: -- || ' not downloaded due to validation error');
2912: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2923: l_index := 1;
2924:
2925: l_databuffer_tbl(l_index) := 'BEGIN REGION "' ||
2926: nvl(to_char(p_region_application_id), '') || '" "' ||
2927: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_region_code) || '"';
2928: l_index := l_index + 1;
2929: l_databuffer_tbl(l_index) := ' DATABASE_OBJECT_NAME = "' ||
2930: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.database_object_name)
2931: || '"';
2926: nvl(to_char(p_region_application_id), '') || '" "' ||
2927: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_region_code) || '"';
2928: l_index := l_index + 1;
2929: l_databuffer_tbl(l_index) := ' DATABASE_OBJECT_NAME = "' ||
2930: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.database_object_name)
2931: || '"';
2932: l_index := l_index + 1;
2933: l_databuffer_tbl(l_index) := ' REGION_STYLE = "' ||
2934: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.region_style) || '"';
2930: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.database_object_name)
2931: || '"';
2932: l_index := l_index + 1;
2933: l_databuffer_tbl(l_index) := ' REGION_STYLE = "' ||
2934: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.region_style) || '"';
2935: if ((l_regions_rec.num_columns IS NOT NULL) and
2936: (l_regions_rec.num_columns <> FND_API.G_MISS_NUM)) then
2937: l_index := l_index + 1;
2938: l_databuffer_tbl(l_index) := ' NUM_COLUMNS = "' ||
2941: if ((l_regions_rec.icx_custom_call IS NOT NULL) and
2942: (l_regions_rec.icx_custom_call <> FND_API.G_MISS_CHAR)) then
2943: l_index := l_index + 1;
2944: l_databuffer_tbl(l_index) := ' ICX_CUSTOM_CALL = "' ||
2945: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_rec.icx_custom_call)||'"';
2946: end if;
2947: if ((l_regions_rec.region_defaulting_api_pkg IS NOT NULL) and
2948: (l_regions_rec.region_defaulting_api_pkg <> FND_API.G_MISS_CHAR)) then
2949: l_index := l_index + 1;
2947: if ((l_regions_rec.region_defaulting_api_pkg IS NOT NULL) and
2948: (l_regions_rec.region_defaulting_api_pkg <> FND_API.G_MISS_CHAR)) then
2949: l_index := l_index + 1;
2950: l_databuffer_tbl(l_index) := ' REGION_DEFAULTING_API_PKG = "' ||
2951: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2952: l_regions_rec.region_defaulting_api_pkg)|| '"';
2953: end if;
2954: if ((l_regions_rec.region_defaulting_api_proc IS NOT NULL) and
2955: (l_regions_rec.region_defaulting_api_proc <> FND_API.G_MISS_CHAR)) then
2954: if ((l_regions_rec.region_defaulting_api_proc IS NOT NULL) and
2955: (l_regions_rec.region_defaulting_api_proc <> FND_API.G_MISS_CHAR)) then
2956: l_index := l_index + 1;
2957: l_databuffer_tbl(l_index) := ' REGION_DEFAULTING_API_PROC = "' ||
2958: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2959: l_regions_rec.region_defaulting_api_proc)|| '"';
2960: end if;
2961: if ((l_regions_rec.region_validation_api_pkg IS NOT NULL) and
2962: (l_regions_rec.region_validation_api_pkg <> FND_API.G_MISS_CHAR)) then
2961: if ((l_regions_rec.region_validation_api_pkg IS NOT NULL) and
2962: (l_regions_rec.region_validation_api_pkg <> FND_API.G_MISS_CHAR)) then
2963: l_index := l_index + 1;
2964: l_databuffer_tbl(l_index) := ' REGION_VALIDATION_API_PKG = "' ||
2965: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2966: l_regions_rec.region_validation_api_pkg)|| '"';
2967: end if;
2968: if ((l_regions_rec.region_validation_api_proc IS NOT NULL) and
2969: (l_regions_rec.region_validation_api_proc <> FND_API.G_MISS_CHAR)) then
2968: if ((l_regions_rec.region_validation_api_proc IS NOT NULL) and
2969: (l_regions_rec.region_validation_api_proc <> FND_API.G_MISS_CHAR)) then
2970: l_index := l_index + 1;
2971: l_databuffer_tbl(l_index) := ' REGION_VALIDATION_API_PROC = "' ||
2972: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2973: l_regions_rec.region_validation_api_proc)|| '"';
2974: end if;
2975: if ((l_regions_rec.applicationmodule_object_type IS NOT NULL) and
2976: (l_regions_rec.applicationmodule_object_type <> FND_API.G_MISS_CHAR)) then
2975: if ((l_regions_rec.applicationmodule_object_type IS NOT NULL) and
2976: (l_regions_rec.applicationmodule_object_type <> FND_API.G_MISS_CHAR)) then
2977: l_index := l_index + 1;
2978: l_databuffer_tbl(l_index) := ' APPLICATIONMODULE_OBJECT_TYPE = "' ||
2979: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2980: l_regions_rec.applicationmodule_object_type)|| '"';
2981: end if;
2982: if ((l_regions_rec.num_rows_display IS NOT NULL) and
2983: (l_regions_rec.num_rows_display <> FND_API.G_MISS_NUM)) then
2988: if ((l_regions_rec.region_object_type IS NOT NULL) and
2989: (l_regions_rec.region_object_type <> FND_API.G_MISS_CHAR)) then
2990: l_index := l_index + 1;
2991: l_databuffer_tbl(l_index) := ' REGION_OBJECT_TYPE = "' ||
2992: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
2993: l_regions_rec.region_object_type)|| '"';
2994: end if;
2995: if ((l_regions_rec.image_file_name IS NOT NULL) and
2996: (l_regions_rec.image_file_name <> FND_API.G_MISS_CHAR)) then
2995: if ((l_regions_rec.image_file_name IS NOT NULL) and
2996: (l_regions_rec.image_file_name <> FND_API.G_MISS_CHAR)) then
2997: l_index := l_index + 1;
2998: l_databuffer_tbl(l_index) := ' IMAGE_FILE_NAME = "' ||
2999: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3000: l_regions_rec.image_file_name)|| '"';
3001: end if;
3002: if ((l_regions_rec.isform_flag IS NOT NULL) and
3003: (l_regions_rec.isform_flag <> FND_API.G_MISS_CHAR)) then
3002: if ((l_regions_rec.isform_flag IS NOT NULL) and
3003: (l_regions_rec.isform_flag <> FND_API.G_MISS_CHAR)) then
3004: l_index := l_index + 1;
3005: l_databuffer_tbl(l_index) := ' ISFORM_FLAG = "' ||
3006: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3007: l_regions_rec.isform_flag)|| '"';
3008: end if;
3009: if ((l_regions_rec.help_target IS NOT NULL) and
3010: (l_regions_rec.help_target <> FND_API.G_MISS_CHAR)) then
3009: if ((l_regions_rec.help_target IS NOT NULL) and
3010: (l_regions_rec.help_target <> FND_API.G_MISS_CHAR)) then
3011: l_index := l_index + 1;
3012: l_databuffer_tbl(l_index) := ' HELP_TARGET = "' ||
3013: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3014: l_regions_rec.help_target)|| '"';
3015: end if;
3016: if ((l_regions_rec.style_sheet_filename IS NOT NULL) and
3017: (l_regions_rec.style_sheet_filename <> FND_API.G_MISS_CHAR)) then
3016: if ((l_regions_rec.style_sheet_filename IS NOT NULL) and
3017: (l_regions_rec.style_sheet_filename <> FND_API.G_MISS_CHAR)) then
3018: l_index := l_index + 1;
3019: l_databuffer_tbl(l_index) := ' STYLE_SHEET_FILENAME = "' ||
3020: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3021: l_regions_rec.style_sheet_filename)|| '"';
3022: end if;
3023: if ((l_regions_rec.version IS NOT NULL) and
3024: (l_regions_rec.version <> FND_API.G_MISS_CHAR)) then
3023: if ((l_regions_rec.version IS NOT NULL) and
3024: (l_regions_rec.version <> FND_API.G_MISS_CHAR)) then
3025: l_index := l_index + 1;
3026: l_databuffer_tbl(l_index) := ' VERSION = "' ||
3027: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3028: l_regions_rec.version)|| '"';
3029: end if;
3030: if ((l_regions_rec.applicationmodule_usage_name IS NOT NULL) and
3031: (l_regions_rec.applicationmodule_usage_name <> FND_API.G_MISS_CHAR)) then
3030: if ((l_regions_rec.applicationmodule_usage_name IS NOT NULL) and
3031: (l_regions_rec.applicationmodule_usage_name <> FND_API.G_MISS_CHAR)) then
3032: l_index := l_index + 1;
3033: l_databuffer_tbl(l_index) := ' APPLICATIONMODULE_USAGE_NAME = "' ||
3034: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3035: l_regions_rec.applicationmodule_usage_name)|| '"';
3036: end if;
3037: if ((l_regions_rec.add_indexed_children IS NOT NULL) and
3038: (l_regions_rec.add_indexed_children <> FND_API.G_MISS_CHAR)) then
3037: if ((l_regions_rec.add_indexed_children IS NOT NULL) and
3038: (l_regions_rec.add_indexed_children <> FND_API.G_MISS_CHAR)) then
3039: l_index := l_index + 1;
3040: l_databuffer_tbl(l_index) := ' ADD_INDEXED_CHILDREN = "' ||
3041: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3042: l_regions_rec.add_indexed_children)|| '"';
3043: end if;
3044: if ((l_regions_rec.stateful_flag IS NOT NULL) and
3045: (l_regions_rec.stateful_flag <> FND_API.G_MISS_CHAR)) then
3044: if ((l_regions_rec.stateful_flag IS NOT NULL) and
3045: (l_regions_rec.stateful_flag <> FND_API.G_MISS_CHAR)) then
3046: l_index := l_index + 1;
3047: l_databuffer_tbl(l_index) := ' STATEFUL_FLAG = "' ||
3048: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3049: l_regions_rec.stateful_flag)|| '"';
3050: end if;
3051: if ((l_regions_rec.function_name IS NOT NULL) and
3052: (l_regions_rec.function_name <> FND_API.G_MISS_CHAR)) then
3051: if ((l_regions_rec.function_name IS NOT NULL) and
3052: (l_regions_rec.function_name <> FND_API.G_MISS_CHAR)) then
3053: l_index := l_index + 1;
3054: l_databuffer_tbl(l_index) := ' FUNCTION_NAME = "' ||
3055: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3056: l_regions_rec.function_name)|| '"';
3057: end if;
3058: if ((l_regions_rec.children_view_usage_name IS NOT NULL) and
3059: (l_regions_rec.children_view_usage_name <> FND_API.G_MISS_CHAR)) then
3058: if ((l_regions_rec.children_view_usage_name IS NOT NULL) and
3059: (l_regions_rec.children_view_usage_name <> FND_API.G_MISS_CHAR)) then
3060: l_index := l_index + 1;
3061: l_databuffer_tbl(l_index) := ' CHILDREN_VIEW_USAGE_NAME = "' ||
3062: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3063: l_regions_rec.children_view_usage_name)|| '"';
3064: end if;
3065: if ((l_regions_rec.search_panel IS NOT NULL) and
3066: (l_regions_rec.search_panel <> FND_API.G_MISS_CHAR)) then
3065: if ((l_regions_rec.search_panel IS NOT NULL) and
3066: (l_regions_rec.search_panel <> FND_API.G_MISS_CHAR)) then
3067: l_index := l_index + 1;
3068: l_databuffer_tbl(l_index) := ' SEARCH_PANEL = "' ||
3069: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3070: l_regions_rec.search_panel)|| '"';
3071: end if;
3072: if ((l_regions_rec.advanced_search_panel IS NOT NULL) and
3073: (l_regions_rec.advanced_search_panel <> FND_API.G_MISS_CHAR)) then
3072: if ((l_regions_rec.advanced_search_panel IS NOT NULL) and
3073: (l_regions_rec.advanced_search_panel <> FND_API.G_MISS_CHAR)) then
3074: l_index := l_index + 1;
3075: l_databuffer_tbl(l_index) := ' ADVANCED_SEARCH_PANEL = "' ||
3076: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3077: l_regions_rec.advanced_search_panel)|| '"';
3078: end if;
3079: if ((l_regions_rec.customize_panel IS NOT NULL) and
3080: (l_regions_rec.customize_panel <> FND_API.G_MISS_CHAR)) then
3079: if ((l_regions_rec.customize_panel IS NOT NULL) and
3080: (l_regions_rec.customize_panel <> FND_API.G_MISS_CHAR)) then
3081: l_index := l_index + 1;
3082: l_databuffer_tbl(l_index) := ' CUSTOMIZE_PANEL = "' ||
3083: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3084: l_regions_rec.customize_panel)|| '"';
3085: end if;
3086: if ((l_regions_rec.default_search_panel IS NOT NULL) and
3087: (l_regions_rec.default_search_panel <> FND_API.G_MISS_CHAR)) then
3086: if ((l_regions_rec.default_search_panel IS NOT NULL) and
3087: (l_regions_rec.default_search_panel <> FND_API.G_MISS_CHAR)) then
3088: l_index := l_index + 1;
3089: l_databuffer_tbl(l_index) := ' DEFAULT_SEARCH_PANEL = "' ||
3090: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3091: l_regions_rec.default_search_panel)|| '"';
3092: end if;
3093: if ((l_regions_rec.results_based_search IS NOT NULL) and
3094: (l_regions_rec.results_based_search <> FND_API.G_MISS_CHAR)) then
3093: if ((l_regions_rec.results_based_search IS NOT NULL) and
3094: (l_regions_rec.results_based_search <> FND_API.G_MISS_CHAR)) then
3095: l_index := l_index + 1;
3096: l_databuffer_tbl(l_index) := ' RESULTS_BASED_SEARCH = "' ||
3097: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3098: l_regions_rec.results_based_search)|| '"';
3099: end if;
3100: if ((l_regions_rec.display_graph_table IS NOT NULL) and
3101: (l_regions_rec.display_graph_table <> FND_API.G_MISS_CHAR)) then
3100: if ((l_regions_rec.display_graph_table IS NOT NULL) and
3101: (l_regions_rec.display_graph_table <> FND_API.G_MISS_CHAR)) then
3102: l_index := l_index + 1;
3103: l_databuffer_tbl(l_index) := ' DISPLAY_GRAPH_TABLE = "' ||
3104: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3105: l_regions_rec.display_graph_table)|| '"';
3106: end if;
3107: if ((l_regions_rec.disable_header IS NOT NULL) and
3108: (l_regions_rec.disable_header <> FND_API.G_MISS_CHAR)) then
3107: if ((l_regions_rec.disable_header IS NOT NULL) and
3108: (l_regions_rec.disable_header <> FND_API.G_MISS_CHAR)) then
3109: l_index := l_index + 1;
3110: l_databuffer_tbl(l_index) := ' DISABLE_HEADER = "' ||
3111: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3112: l_regions_rec.disable_header)|| '"';
3113: end if;
3114: if ((l_regions_rec.standalone IS NOT NULL) and
3115: (l_regions_rec.standalone <> FND_API.G_MISS_CHAR)) then
3114: if ((l_regions_rec.standalone IS NOT NULL) and
3115: (l_regions_rec.standalone <> FND_API.G_MISS_CHAR)) then
3116: l_index := l_index + 1;
3117: l_databuffer_tbl(l_index) := ' STANDALONE = "' ||
3118: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3119: l_regions_rec.standalone)|| '"';
3120: end if;
3121: if ((l_regions_rec.auto_customization_criteria IS NOT NULL) and
3122: (l_regions_rec.auto_customization_criteria <> FND_API.G_MISS_CHAR)) then
3121: if ((l_regions_rec.auto_customization_criteria IS NOT NULL) and
3122: (l_regions_rec.auto_customization_criteria <> FND_API.G_MISS_CHAR)) then
3123: l_index := l_index + 1;
3124: l_databuffer_tbl(l_index) := ' AUTO_CUSTOMIZATION_CRITERIA = "' ||
3125: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3126: l_regions_rec.auto_customization_criteria)|| '"';
3127: end if;
3128:
3129: -- Flex Fields
3131: if ((l_regions_rec.attribute_category IS NOT NULL) and
3132: (l_regions_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
3133: l_index := l_index + 1;
3134: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
3135: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3136: l_regions_rec.attribute_category) || '"';
3137: end if;
3138: if ((l_regions_rec.attribute1 IS NOT NULL) and
3139: (l_regions_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
3138: if ((l_regions_rec.attribute1 IS NOT NULL) and
3139: (l_regions_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
3140: l_index := l_index + 1;
3141: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
3142: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3143: l_regions_rec.attribute1) || '"';
3144: end if;
3145: if ((l_regions_rec.attribute2 IS NOT NULL) and
3146: (l_regions_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
3145: if ((l_regions_rec.attribute2 IS NOT NULL) and
3146: (l_regions_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
3147: l_index := l_index + 1;
3148: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
3149: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3150: l_regions_rec.attribute2) || '"';
3151: end if;
3152: if ((l_regions_rec.attribute3 IS NOT NULL) and
3153: (l_regions_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
3152: if ((l_regions_rec.attribute3 IS NOT NULL) and
3153: (l_regions_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
3154: l_index := l_index + 1;
3155: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
3156: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3157: l_regions_rec.attribute3) || '"';
3158: end if;
3159: if ((l_regions_rec.attribute4 IS NOT NULL) and
3160: (l_regions_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
3159: if ((l_regions_rec.attribute4 IS NOT NULL) and
3160: (l_regions_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
3161: l_index := l_index + 1;
3162: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
3163: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3164: l_regions_rec.attribute4) || '"';
3165: end if;
3166: if ((l_regions_rec.attribute5 IS NOT NULL) and
3167: (l_regions_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
3166: if ((l_regions_rec.attribute5 IS NOT NULL) and
3167: (l_regions_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
3168: l_index := l_index + 1;
3169: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
3170: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3171: l_regions_rec.attribute5) || '"';
3172: end if;
3173: if ((l_regions_rec.attribute6 IS NOT NULL) and
3174: (l_regions_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
3173: if ((l_regions_rec.attribute6 IS NOT NULL) and
3174: (l_regions_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
3175: l_index := l_index + 1;
3176: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
3177: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3178: l_regions_rec.attribute6) || '"';
3179: end if;
3180: if ((l_regions_rec.attribute7 IS NOT NULL) and
3181: (l_regions_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
3180: if ((l_regions_rec.attribute7 IS NOT NULL) and
3181: (l_regions_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
3182: l_index := l_index + 1;
3183: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
3184: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3185: l_regions_rec.attribute7) || '"';
3186: end if;
3187: if ((l_regions_rec.attribute8 IS NOT NULL) and
3188: (l_regions_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
3187: if ((l_regions_rec.attribute8 IS NOT NULL) and
3188: (l_regions_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
3189: l_index := l_index + 1;
3190: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
3191: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3192: l_regions_rec.attribute8) || '"';
3193: end if;
3194: if ((l_regions_rec.attribute9 IS NOT NULL) and
3195: (l_regions_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
3194: if ((l_regions_rec.attribute9 IS NOT NULL) and
3195: (l_regions_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
3196: l_index := l_index + 1;
3197: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
3198: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3199: l_regions_rec.attribute9) || '"';
3200: end if;
3201: if ((l_regions_rec.attribute10 IS NOT NULL) and
3202: (l_regions_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
3201: if ((l_regions_rec.attribute10 IS NOT NULL) and
3202: (l_regions_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
3203: l_index := l_index + 1;
3204: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
3205: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3206: l_regions_rec.attribute10) || '"';
3207: end if;
3208: if ((l_regions_rec.attribute11 IS NOT NULL) and
3209: (l_regions_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
3208: if ((l_regions_rec.attribute11 IS NOT NULL) and
3209: (l_regions_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
3210: l_index := l_index + 1;
3211: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
3212: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3213: l_regions_rec.attribute11) || '"';
3214: end if;
3215: if ((l_regions_rec.attribute12 IS NOT NULL) and
3216: (l_regions_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
3215: if ((l_regions_rec.attribute12 IS NOT NULL) and
3216: (l_regions_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
3217: l_index := l_index + 1;
3218: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
3219: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3220: l_regions_rec.attribute12) || '"';
3221: end if;
3222: if ((l_regions_rec.attribute13 IS NOT NULL) and
3223: (l_regions_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
3222: if ((l_regions_rec.attribute13 IS NOT NULL) and
3223: (l_regions_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
3224: l_index := l_index + 1;
3225: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
3226: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3227: l_regions_rec.attribute13) || '"';
3228: end if;
3229: if ((l_regions_rec.attribute14 IS NOT NULL) and
3230: (l_regions_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
3229: if ((l_regions_rec.attribute14 IS NOT NULL) and
3230: (l_regions_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
3231: l_index := l_index + 1;
3232: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
3233: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3234: l_regions_rec.attribute14) || '"';
3235: end if;
3236: if ((l_regions_rec.attribute15 IS NOT NULL) and
3237: (l_regions_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
3236: if ((l_regions_rec.attribute15 IS NOT NULL) and
3237: (l_regions_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
3238: l_index := l_index + 1;
3239: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
3240: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
3241: l_regions_rec.attribute15) || '"';
3242: end if;
3243: -- - Write out who columns
3244: l_index := l_index + 1;
3267: if ((l_regions_tl_rec.name IS NOT NULL) and
3268: (l_regions_tl_rec.name <> FND_API.G_MISS_CHAR)) then
3269: l_index := l_index + 1;
3270: l_databuffer_tbl(l_index) := ' NAME = "' ||
3271: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_tl_rec.name)||'"';
3272: end if;
3273: if ((l_regions_tl_rec.description IS NOT NULL) and
3274: (l_regions_tl_rec.description <> FND_API.G_MISS_CHAR)) then
3275: l_index := l_index + 1;
3273: if ((l_regions_tl_rec.description IS NOT NULL) and
3274: (l_regions_tl_rec.description <> FND_API.G_MISS_CHAR)) then
3275: l_index := l_index + 1;
3276: l_databuffer_tbl(l_index) := ' DESCRIPTION = "' ||
3277: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_tl_rec.description)||'"';
3278: end if;
3279:
3280: -- - Write the region data to the specified file
3281: AK_ON_OBJECTS_PVT.WRITE_FILE (
3277: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_regions_tl_rec.description)||'"';
3278: end if;
3279:
3280: -- - Write the region data to the specified file
3281: AK_ON_OBJECTS_PVT.WRITE_FILE (
3282: p_return_status => l_return_status,
3283: p_buffer_tbl => l_databuffer_tbl,
3284: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
3285: );
3326: l_index := l_index + 1;
3327: l_databuffer_tbl(l_index) := ' ';
3328:
3329: -- - Write the 'END REGION' to the specified file
3330: AK_ON_OBJECTS_PVT.WRITE_FILE (
3331: p_return_status => l_return_status,
3332: p_buffer_tbl => l_databuffer_tbl,
3333: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
3334: );
3473: p_display_flag => p_display_flag,
3474: p_depth_radius => p_depth_radius,
3475: p_graph_title => p_graph_title,
3476: p_y_axis_label => p_y_axis_label,
3477: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
3478: p_pass => p_pass
3479: ) then
3480: -- Do not raise an error if it's the first pass
3481: if (p_pass = 1) then
3502: -- Create record if no validation error was found
3503:
3504: -- Set WHO columns
3505: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
3506: AK_ON_OBJECTS_PVT.SET_WHO (
3507: p_return_status => l_return_status,
3508: p_loader_timestamp => p_loader_timestamp,
3509: p_created_by => l_created_by,
3510: p_creation_date => l_creation_date,
3986: p_customization_application_id => p_customization_application_id,
3987: p_customization_code => p_customization_code,
3988: p_attribute_label_long => p_attribute_label_long,
3989: p_attribute_label_short => p_attribute_label_short,
3990: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
3991: p_pass => p_pass
3992: ) then
3993: -- Do not raise an error if it's the first pass
3994: if (p_pass = 1) then
4334: -- old jlt files didn't have who columns and IS_UPDATEABLE
4335: -- calls SET_WHO which populates those columns, for later
4336: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
4337:
4338: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4339: p_loader_timestamp => p_loader_timestamp,
4340: p_created_by => l_created_by,
4341: p_creation_date => l_creation_date,
4342: p_last_updated_by => l_last_updated_by,
4951: p_region_validation_api_pkg => p_region_validation_api_pkg,
4952: p_region_validation_api_proc => p_region_validation_api_proc,
4953: p_name => p_name,
4954: p_description => p_description,
4955: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
4956: p_pass => p_pass
4957: ) then
4958: -- Do not raise an error if it's the first pass
4959: if (p_pass = 1) then
5173: -- old jlt files didn't have who columns and IS_UPDATEABLE
5174: -- calls SET_WHO which populates those columns, for later
5175: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
5176:
5177: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
5178: p_loader_timestamp => p_loader_timestamp,
5179: p_created_by => l_created_by,
5180: p_creation_date => l_creation_date,
5181: p_last_updated_by => l_last_updated_by,
7163: p_display_flag => p_display_flag,
7164: p_depth_radius => p_depth_radius,
7165: p_graph_title => p_graph_title,
7166: p_y_axis_label => p_y_axis_label,
7167: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
7168: p_pass => p_pass
7169: ) then
7170: --dbms_output.put_line(l_api_name || ' validation failed');
7171: -- Do not raise an error if it's the first pass
7207: end if;
7208:
7209: -- Set WHO columns
7210: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
7211: AK_ON_OBJECTS_PVT.SET_WHO (
7212: p_return_status => l_return_status,
7213: p_loader_timestamp => p_loader_timestamp,
7214: p_created_by => l_created_by,
7215: p_creation_date => l_creation_date,
7612: p_customization_application_id => p_customization_application_id,
7613: p_customization_code => p_customization_application_id,
7614: p_attribute_label_long => p_attribute_label_long,
7615: p_attribute_label_short => p_attribute_label_short,
7616: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
7617: p_pass => p_pass
7618: ) then
7619: --dbms_output.put_line(l_api_name || ' validation failed');
7620: -- Do not raise an error if it's the first pass
8058: else
8059: l_create_or_update := 'UPDATE';
8060: end if;
8061:
8062: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
8063: p_loader_timestamp => p_loader_timestamp,
8064: p_created_by => l_created_by,
8065: p_creation_date => l_creation_date,
8066: p_last_updated_by => l_last_updated_by,
8435: p_region_validation_api_pkg => p_region_validation_api_pkg,
8436: p_region_validation_api_proc => p_region_validation_api_proc,
8437: p_name => p_name,
8438: p_description => p_description,
8439: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
8440: p_pass => p_pass
8441: ) then
8442: --dbms_output.put_line(l_api_name || 'validation failed');
8443: -- Do not raise an error if it's the first pass
8668: end if;
8669:
8670: -- Set WHO columns
8671:
8672: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
8673: p_loader_timestamp => p_loader_timestamp,
8674: p_created_by => l_created_by,
8675: p_creation_date => l_creation_date,
8676: p_last_updated_by => l_last_updated_by,