460: X_ATTRIBUTE12 in VARCHAR2,
461: X_ATTRIBUTE13 in VARCHAR2,
462: X_ATTRIBUTE14 in VARCHAR2,
463: X_ATTRIBUTE15 in VARCHAR2,
464: X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
465: X_ORDER_SEQUENCE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
466: X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR) is
467:
468: l_display_value_length number;
461: X_ATTRIBUTE13 in VARCHAR2,
462: X_ATTRIBUTE14 in VARCHAR2,
463: X_ATTRIBUTE15 in VARCHAR2,
464: X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
465: X_ORDER_SEQUENCE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
466: X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR) is
467:
468: l_display_value_length number;
469: l_attributeCount number;
462: X_ATTRIBUTE14 in VARCHAR2,
463: X_ATTRIBUTE15 in VARCHAR2,
464: X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
465: X_ORDER_SEQUENCE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
466: X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR) is
467:
468: l_display_value_length number;
469: l_attributeCount number;
470: l_attribute_rowid varchar2(50);
542: X_LAST_UPDATED_BY => X_USER_ID,
543: X_LAST_UPDATE_LOGIN => X_USER_ID);
544: end if;
545:
546: if X_URL <> BIS_COMMON_UTILS.G_DEF_CHAR then
547: l_url := x_url;
548: end if;
549:
550: l_nested_region_appl_id := x_nested_region_appl_id;
683: X_ATTRIBUTE12 in VARCHAR2,
684: X_ATTRIBUTE13 in VARCHAR2,
685: X_ATTRIBUTE14 in VARCHAR2,
686: X_ATTRIBUTE15 in VARCHAR2,
687: X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
688: X_ORDER_SEQUENCE in VARCHAR2 := NULL,
689: X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR)
690: is
691:
685: X_ATTRIBUTE14 in VARCHAR2,
686: X_ATTRIBUTE15 in VARCHAR2,
687: X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
688: X_ORDER_SEQUENCE in VARCHAR2 := NULL,
689: X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR)
690: is
691:
692: l_regionItem_rec AK_REGION_PUB.Item_Rec_Type;
693:
862: CLOSE cRegionItem;
863:
864: l_regionItem_rec.url := x_url;
865:
866: if X_ORDER_DIRECTION <> BIS_COMMON_UTILS.G_DEF_CHAR then
867: l_regionItem_rec.order_direction := x_ORDER_DIRECTION;
868: end if;
869:
870: AK_REGION_ITEMS_PKG.UPDATE_ROW (
1175: p_REGION_CODE in VARCHAR2
1176: ,p_REGION_APPLICATION_ID in NUMBER
1177: ,p_DATABASE_OBJECT_NAME in VARCHAR2
1178: ,p_NAME in VARCHAR2
1179: ,p_REGION_STYLE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1180: ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1181: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1182: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1183: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1176: ,p_REGION_APPLICATION_ID in NUMBER
1177: ,p_DATABASE_OBJECT_NAME in VARCHAR2
1178: ,p_NAME in VARCHAR2
1179: ,p_REGION_STYLE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1180: ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1181: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1182: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1183: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1184: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1177: ,p_DATABASE_OBJECT_NAME in VARCHAR2
1178: ,p_NAME in VARCHAR2
1179: ,p_REGION_STYLE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1180: ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1181: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1182: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1183: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1184: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1185: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1178: ,p_NAME in VARCHAR2
1179: ,p_REGION_STYLE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1180: ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1181: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1182: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1183: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1184: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1185: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1186: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1179: ,p_REGION_STYLE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1180: ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1181: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1182: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1183: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1184: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1185: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1186: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1187: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1180: ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1181: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1182: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1183: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1184: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1185: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1186: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1187: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1188: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1181: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1182: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1183: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1184: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1185: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1186: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1187: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1188: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1189: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1182: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1183: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1184: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1185: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1186: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1187: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1188: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1189: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1190: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1183: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1184: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1185: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1186: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1187: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1188: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1189: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1190: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1191: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1184: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1185: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1186: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1187: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1188: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1189: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1190: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1191: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1192: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1185: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1186: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1187: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1188: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1189: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1190: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1191: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1192: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1193: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1186: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1187: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1188: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1189: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1190: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1191: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1192: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1193: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1194: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1187: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1188: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1189: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1190: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1191: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1192: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1193: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1194: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1195: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1188: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1189: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1190: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1191: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1192: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1193: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1194: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1195: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1196: ,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1189: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1190: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1191: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1192: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1193: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1194: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1195: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1196: ,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1197: ,p_ATTRIBUTE15 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1190: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1191: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1192: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1193: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1194: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1195: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1196: ,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1197: ,p_ATTRIBUTE15 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1198: ,x_return_status OUT NOCOPY VARCHAR2
1191: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1192: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1193: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1194: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1195: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1196: ,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1197: ,p_ATTRIBUTE15 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1198: ,x_return_status OUT NOCOPY VARCHAR2
1199: ,x_msg_count OUT NOCOPY NUMBER
1192: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1193: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1194: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1195: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1196: ,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1197: ,p_ATTRIBUTE15 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1198: ,x_return_status OUT NOCOPY VARCHAR2
1199: ,x_msg_count OUT NOCOPY NUMBER
1200: ,x_msg_data OUT NOCOPY VARCHAR2
1193: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1194: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1195: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1196: ,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1197: ,p_ATTRIBUTE15 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
1198: ,x_return_status OUT NOCOPY VARCHAR2
1199: ,x_msg_count OUT NOCOPY NUMBER
1200: ,x_msg_data OUT NOCOPY VARCHAR2
1201: ) is
1305: l_region_rec.attribute14,
1306: l_region_rec.attribute15;
1307: CLOSE cRegion;
1308:
1309: if (p_region_style <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1310: l_region_rec.region_style := p_region_style;
1311: end if;
1312: IF (p_name <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1313: l_region_rec.name := p_name;
1308:
1309: if (p_region_style <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1310: l_region_rec.region_style := p_region_style;
1311: end if;
1312: IF (p_name <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1313: l_region_rec.name := p_name;
1314: END IF;
1315: if (p_description <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1316: l_region_rec.description := p_description;
1311: end if;
1312: IF (p_name <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1313: l_region_rec.name := p_name;
1314: END IF;
1315: if (p_description <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1316: l_region_rec.description := p_description;
1317: end if;
1318: if (p_appl_module_object_type <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1319: l_region_rec.applicationmodule_object_type := p_appl_module_object_type;
1314: END IF;
1315: if (p_description <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1316: l_region_rec.description := p_description;
1317: end if;
1318: if (p_appl_module_object_type <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1319: l_region_rec.applicationmodule_object_type := p_appl_module_object_type;
1320: end if;
1321: if (p_attribute_category <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1322: l_region_rec.attribute_category := p_attribute_category;
1317: end if;
1318: if (p_appl_module_object_type <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1319: l_region_rec.applicationmodule_object_type := p_appl_module_object_type;
1320: end if;
1321: if (p_attribute_category <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1322: l_region_rec.attribute_category := p_attribute_category;
1323: end if;
1324: if (p_attribute1 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1325: l_region_rec.attribute1 := p_attribute1;
1320: end if;
1321: if (p_attribute_category <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1322: l_region_rec.attribute_category := p_attribute_category;
1323: end if;
1324: if (p_attribute1 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1325: l_region_rec.attribute1 := p_attribute1;
1326: end if;
1327: if (p_attribute2 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1328: l_region_rec.attribute2 := p_attribute2;
1323: end if;
1324: if (p_attribute1 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1325: l_region_rec.attribute1 := p_attribute1;
1326: end if;
1327: if (p_attribute2 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1328: l_region_rec.attribute2 := p_attribute2;
1329: end if;
1330: if (p_attribute3 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1331: l_region_rec.attribute3 := p_attribute3;
1326: end if;
1327: if (p_attribute2 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1328: l_region_rec.attribute2 := p_attribute2;
1329: end if;
1330: if (p_attribute3 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1331: l_region_rec.attribute3 := p_attribute3;
1332: end if;
1333: if (p_attribute4 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1334: l_region_rec.attribute4 := p_attribute4;
1329: end if;
1330: if (p_attribute3 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1331: l_region_rec.attribute3 := p_attribute3;
1332: end if;
1333: if (p_attribute4 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1334: l_region_rec.attribute4 := p_attribute4;
1335: end if;
1336: if (p_attribute5 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1337: l_region_rec.attribute5 := p_attribute5;
1332: end if;
1333: if (p_attribute4 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1334: l_region_rec.attribute4 := p_attribute4;
1335: end if;
1336: if (p_attribute5 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1337: l_region_rec.attribute5 := p_attribute5;
1338: end if;
1339: if (p_attribute6 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1340: l_region_rec.attribute6 := p_attribute6;
1335: end if;
1336: if (p_attribute5 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1337: l_region_rec.attribute5 := p_attribute5;
1338: end if;
1339: if (p_attribute6 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1340: l_region_rec.attribute6 := p_attribute6;
1341: end if;
1342: if (p_attribute7 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1343: l_region_rec.attribute7 := p_attribute7;
1338: end if;
1339: if (p_attribute6 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1340: l_region_rec.attribute6 := p_attribute6;
1341: end if;
1342: if (p_attribute7 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1343: l_region_rec.attribute7 := p_attribute7;
1344: end if;
1345: if (p_attribute8 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1346: l_region_rec.attribute8 := p_attribute8;
1341: end if;
1342: if (p_attribute7 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1343: l_region_rec.attribute7 := p_attribute7;
1344: end if;
1345: if (p_attribute8 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1346: l_region_rec.attribute8 := p_attribute8;
1347: end if;
1348: if (p_attribute9 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1349: l_region_rec.attribute9 := p_attribute9;
1344: end if;
1345: if (p_attribute8 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1346: l_region_rec.attribute8 := p_attribute8;
1347: end if;
1348: if (p_attribute9 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1349: l_region_rec.attribute9 := p_attribute9;
1350: end if;
1351: if (p_attribute10 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1352: l_region_rec.attribute10 := p_attribute10;
1347: end if;
1348: if (p_attribute9 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1349: l_region_rec.attribute9 := p_attribute9;
1350: end if;
1351: if (p_attribute10 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1352: l_region_rec.attribute10 := p_attribute10;
1353: end if;
1354: if (p_attribute11 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1355: l_region_rec.attribute11 := p_attribute11;
1350: end if;
1351: if (p_attribute10 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1352: l_region_rec.attribute10 := p_attribute10;
1353: end if;
1354: if (p_attribute11 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1355: l_region_rec.attribute11 := p_attribute11;
1356: end if;
1357: if (p_attribute12 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1358: l_region_rec.attribute12 := p_attribute12;
1353: end if;
1354: if (p_attribute11 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1355: l_region_rec.attribute11 := p_attribute11;
1356: end if;
1357: if (p_attribute12 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1358: l_region_rec.attribute12 := p_attribute12;
1359: end if;
1360: if (p_attribute13 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1361: l_region_rec.attribute13 := p_attribute13;
1356: end if;
1357: if (p_attribute12 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1358: l_region_rec.attribute12 := p_attribute12;
1359: end if;
1360: if (p_attribute13 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1361: l_region_rec.attribute13 := p_attribute13;
1362: end if;
1363: if (p_attribute14 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1364: l_region_rec.attribute14 := p_attribute14;
1359: end if;
1360: if (p_attribute13 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1361: l_region_rec.attribute13 := p_attribute13;
1362: end if;
1363: if (p_attribute14 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1364: l_region_rec.attribute14 := p_attribute14;
1365: end if;
1366: if (p_attribute15 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1367: l_region_rec.attribute15 := p_attribute15;
1362: end if;
1363: if (p_attribute14 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1364: l_region_rec.attribute14 := p_attribute14;
1365: end if;
1366: if (p_attribute15 <> BIS_COMMON_UTILS.G_DEF_CHAR) then
1367: l_region_rec.attribute15 := p_attribute15;
1368: end if;
1369:
1370:
1555: l_region_rec.attribute14,
1556: l_region_rec.attribute15;
1557: CLOSE cRegion;
1558:
1559: IF (p_Report_Region_Rec.Region_Style <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1560: l_region_rec.region_style := p_Report_Region_Rec.Region_Style;
1561: END IF;
1562: IF (p_Report_Region_Rec.Region_Name <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1563: l_region_rec.name := p_Report_Region_Rec.Region_Name;
1558:
1559: IF (p_Report_Region_Rec.Region_Style <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1560: l_region_rec.region_style := p_Report_Region_Rec.Region_Style;
1561: END IF;
1562: IF (p_Report_Region_Rec.Region_Name <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1563: l_region_rec.name := p_Report_Region_Rec.Region_Name;
1564: END IF;
1565: IF (p_Report_Region_Rec.Display_Rows <> BIS_COMMON_UTILS.G_DEF_NUM) THEN
1566: l_region_rec.num_rows_display := p_Report_Region_Rec.Display_Rows;
1561: END IF;
1562: IF (p_Report_Region_Rec.Region_Name <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1563: l_region_rec.name := p_Report_Region_Rec.Region_Name;
1564: END IF;
1565: IF (p_Report_Region_Rec.Display_Rows <> BIS_COMMON_UTILS.G_DEF_NUM) THEN
1566: l_region_rec.num_rows_display := p_Report_Region_Rec.Display_Rows;
1567: END IF;
1568: IF (p_Report_Region_Rec.Region_Description <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1569: l_region_rec.description := p_Report_Region_Rec.Region_Description;
1564: END IF;
1565: IF (p_Report_Region_Rec.Display_Rows <> BIS_COMMON_UTILS.G_DEF_NUM) THEN
1566: l_region_rec.num_rows_display := p_Report_Region_Rec.Display_Rows;
1567: END IF;
1568: IF (p_Report_Region_Rec.Region_Description <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1569: l_region_rec.description := p_Report_Region_Rec.Region_Description;
1570: END IF;
1571: IF (p_Report_Region_Rec.Disable_View_By <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1572: l_region_rec.attribute1 := p_Report_Region_Rec.Disable_View_By;
1567: END IF;
1568: IF (p_Report_Region_Rec.Region_Description <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1569: l_region_rec.description := p_Report_Region_Rec.Region_Description;
1570: END IF;
1571: IF (p_Report_Region_Rec.Disable_View_By <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1572: l_region_rec.attribute1 := p_Report_Region_Rec.Disable_View_By;
1573: END IF;
1574: IF (p_Report_Region_Rec.No_Of_Portlet_Rows <> BIS_COMMON_UTILS.G_DEF_NUM) THEN
1575: l_region_rec.attribute2 := p_Report_Region_Rec.No_Of_Portlet_Rows;
1570: END IF;
1571: IF (p_Report_Region_Rec.Disable_View_By <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1572: l_region_rec.attribute1 := p_Report_Region_Rec.Disable_View_By;
1573: END IF;
1574: IF (p_Report_Region_Rec.No_Of_Portlet_Rows <> BIS_COMMON_UTILS.G_DEF_NUM) THEN
1575: l_region_rec.attribute2 := p_Report_Region_Rec.No_Of_Portlet_Rows;
1576: END IF;
1577: IF (p_Report_Region_Rec.Schedule <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1578: l_region_rec.attribute3 := p_Report_Region_Rec.Schedule;
1573: END IF;
1574: IF (p_Report_Region_Rec.No_Of_Portlet_Rows <> BIS_COMMON_UTILS.G_DEF_NUM) THEN
1575: l_region_rec.attribute2 := p_Report_Region_Rec.No_Of_Portlet_Rows;
1576: END IF;
1577: IF (p_Report_Region_Rec.Schedule <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1578: l_region_rec.attribute3 := p_Report_Region_Rec.Schedule;
1579: END IF;
1580: IF (p_Report_Region_Rec.Header_File_Procedure <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1581: l_region_rec.attribute4 := p_Report_Region_Rec.Header_File_Procedure;
1576: END IF;
1577: IF (p_Report_Region_Rec.Schedule <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1578: l_region_rec.attribute3 := p_Report_Region_Rec.Schedule;
1579: END IF;
1580: IF (p_Report_Region_Rec.Header_File_Procedure <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1581: l_region_rec.attribute4 := p_Report_Region_Rec.Header_File_Procedure;
1582: END IF;
1583: IF (p_Report_Region_Rec.Footer_File_Procedure <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1584: l_region_rec.attribute5 := p_Report_Region_Rec.Footer_File_Procedure;
1579: END IF;
1580: IF (p_Report_Region_Rec.Header_File_Procedure <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1581: l_region_rec.attribute4 := p_Report_Region_Rec.Header_File_Procedure;
1582: END IF;
1583: IF (p_Report_Region_Rec.Footer_File_Procedure <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1584: l_region_rec.attribute5 := p_Report_Region_Rec.Footer_File_Procedure;
1585: END IF;
1586: IF (p_Report_Region_Rec.Group_By <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1587: l_region_rec.attribute6 := p_Report_Region_Rec.Group_By;
1582: END IF;
1583: IF (p_Report_Region_Rec.Footer_File_Procedure <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1584: l_region_rec.attribute5 := p_Report_Region_Rec.Footer_File_Procedure;
1585: END IF;
1586: IF (p_Report_Region_Rec.Group_By <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1587: l_region_rec.attribute6 := p_Report_Region_Rec.Group_By;
1588: END IF;
1589: IF (p_Report_Region_Rec.Order_By <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1590: l_region_rec.attribute7 := p_Report_Region_Rec.Order_By;
1585: END IF;
1586: IF (p_Report_Region_Rec.Group_By <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1587: l_region_rec.attribute6 := p_Report_Region_Rec.Group_By;
1588: END IF;
1589: IF (p_Report_Region_Rec.Order_By <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1590: l_region_rec.attribute7 := p_Report_Region_Rec.Order_By;
1591: END IF;
1592: IF (p_Report_Region_Rec.Plsql_For_Report_Query <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1593: l_region_rec.attribute8 := p_Report_Region_Rec.Plsql_For_Report_Query;
1588: END IF;
1589: IF (p_Report_Region_Rec.Order_By <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1590: l_region_rec.attribute7 := p_Report_Region_Rec.Order_By;
1591: END IF;
1592: IF (p_Report_Region_Rec.Plsql_For_Report_Query <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1593: l_region_rec.attribute8 := p_Report_Region_Rec.Plsql_For_Report_Query;
1594: END IF;
1595: IF (p_Report_Region_Rec.Display_Subtotals <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1596: l_region_rec.attribute9 := p_Report_Region_Rec.Display_Subtotals;
1591: END IF;
1592: IF (p_Report_Region_Rec.Plsql_For_Report_Query <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1593: l_region_rec.attribute8 := p_Report_Region_Rec.Plsql_For_Report_Query;
1594: END IF;
1595: IF (p_Report_Region_Rec.Display_Subtotals <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1596: l_region_rec.attribute9 := p_Report_Region_Rec.Display_Subtotals;
1597: END IF;
1598: IF (p_Report_Region_Rec.Data_Source <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1599: l_region_rec.attribute10 := p_Report_Region_Rec.Data_Source;
1594: END IF;
1595: IF (p_Report_Region_Rec.Display_Subtotals <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1596: l_region_rec.attribute9 := p_Report_Region_Rec.Display_Subtotals;
1597: END IF;
1598: IF (p_Report_Region_Rec.Data_Source <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1599: l_region_rec.attribute10 := p_Report_Region_Rec.Data_Source;
1600: END IF;
1601: IF (p_Report_Region_Rec.Where_Clause <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1602: l_region_rec.attribute11 := p_Report_Region_Rec.Where_Clause;
1597: END IF;
1598: IF (p_Report_Region_Rec.Data_Source <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1599: l_region_rec.attribute10 := p_Report_Region_Rec.Data_Source;
1600: END IF;
1601: IF (p_Report_Region_Rec.Where_Clause <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1602: l_region_rec.attribute11 := p_Report_Region_Rec.Where_Clause;
1603: END IF;
1604: IF (p_Report_Region_Rec.Dimension_Group <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1605: l_region_rec.attribute12 := p_Report_Region_Rec.Dimension_Group;
1600: END IF;
1601: IF (p_Report_Region_Rec.Where_Clause <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1602: l_region_rec.attribute11 := p_Report_Region_Rec.Where_Clause;
1603: END IF;
1604: IF (p_Report_Region_Rec.Dimension_Group <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1605: l_region_rec.attribute12 := p_Report_Region_Rec.Dimension_Group;
1606: END IF;
1607: IF (p_Report_Region_Rec.Parameter_Layout <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1608: l_region_rec.attribute13 := p_Report_Region_Rec.Parameter_Layout;
1603: END IF;
1604: IF (p_Report_Region_Rec.Dimension_Group <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1605: l_region_rec.attribute12 := p_Report_Region_Rec.Dimension_Group;
1606: END IF;
1607: IF (p_Report_Region_Rec.Parameter_Layout <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1608: l_region_rec.attribute13 := p_Report_Region_Rec.Parameter_Layout;
1609: END IF;
1610:
1611: AK_REGIONS_PKG.UPDATE_ROW(