268: p_REGION_CODE in VARCHAR2
269: ,p_REGION_APPLICATION_ID in NUMBER
270: ,p_DATABASE_OBJECT_NAME in VARCHAR2
271: ,p_NAME in VARCHAR2
272: ,p_REGION_STYLE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
273: ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
274: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
275: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
276: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
269: ,p_REGION_APPLICATION_ID in NUMBER
270: ,p_DATABASE_OBJECT_NAME in VARCHAR2
271: ,p_NAME in VARCHAR2
272: ,p_REGION_STYLE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
273: ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
274: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
275: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
276: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
277: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
270: ,p_DATABASE_OBJECT_NAME in VARCHAR2
271: ,p_NAME in VARCHAR2
272: ,p_REGION_STYLE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
273: ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
274: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
275: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
276: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
277: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
278: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
271: ,p_NAME in VARCHAR2
272: ,p_REGION_STYLE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
273: ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
274: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
275: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
276: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
277: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
278: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
279: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
272: ,p_REGION_STYLE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
273: ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
274: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
275: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
276: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
277: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
278: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
279: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
280: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
273: ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
274: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
275: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
276: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
277: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
278: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
279: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
280: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
274: ,p_APPL_MODULE_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
275: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
276: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
277: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
278: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
279: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
280: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
275: ,p_ATTRIBUTE_CATEGORY in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
276: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
277: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
278: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
279: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
280: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
276: ,p_ATTRIBUTE1 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
277: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
278: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
279: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
280: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
277: ,p_ATTRIBUTE2 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
278: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
279: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
280: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
285: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
278: ,p_ATTRIBUTE3 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
279: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
280: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
285: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
279: ,p_ATTRIBUTE4 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
280: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
285: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
287: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
280: ,p_ATTRIBUTE5 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
285: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
287: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
288: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_ATTRIBUTE6 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
285: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
287: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
288: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
289: ,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_ATTRIBUTE7 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
285: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
287: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
288: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
289: ,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
290: ,p_ATTRIBUTE15 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_ATTRIBUTE8 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
285: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
287: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
288: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
289: ,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
290: ,p_ATTRIBUTE15 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
291: ,x_return_status OUT NOCOPY VARCHAR2
284: ,p_ATTRIBUTE9 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
285: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
287: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
288: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
289: ,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
290: ,p_ATTRIBUTE15 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
291: ,x_return_status OUT NOCOPY VARCHAR2
292: ,x_msg_count OUT NOCOPY NUMBER
285: ,p_ATTRIBUTE10 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
287: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
288: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
289: ,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
290: ,p_ATTRIBUTE15 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
291: ,x_return_status OUT NOCOPY VARCHAR2
292: ,x_msg_count OUT NOCOPY NUMBER
293: ,x_msg_data OUT NOCOPY VARCHAR2
286: ,p_ATTRIBUTE11 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
287: ,p_ATTRIBUTE12 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
288: ,p_ATTRIBUTE13 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
289: ,p_ATTRIBUTE14 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
290: ,p_ATTRIBUTE15 in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
291: ,x_return_status OUT NOCOPY VARCHAR2
292: ,x_msg_count OUT NOCOPY NUMBER
293: ,x_msg_data OUT NOCOPY VARCHAR2
294: );
336: X_ATTRIBUTE12 in VARCHAR2,
337: X_ATTRIBUTE13 in VARCHAR2,
338: X_ATTRIBUTE14 in VARCHAR2,
339: X_ATTRIBUTE15 in VARCHAR2,
340: X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
341: X_ORDER_SEQUENCE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
342: X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR);
343:
344: -- mdamle 12/25/2003 - overloaded for additional functionality & error messaging
337: X_ATTRIBUTE13 in VARCHAR2,
338: X_ATTRIBUTE14 in VARCHAR2,
339: X_ATTRIBUTE15 in VARCHAR2,
340: X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
341: X_ORDER_SEQUENCE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
342: X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR);
343:
344: -- mdamle 12/25/2003 - overloaded for additional functionality & error messaging
345: procedure INSERT_REGION_ITEM_ROW (
338: X_ATTRIBUTE14 in VARCHAR2,
339: X_ATTRIBUTE15 in VARCHAR2,
340: X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
341: X_ORDER_SEQUENCE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
342: X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR);
343:
344: -- mdamle 12/25/2003 - overloaded for additional functionality & error messaging
345: procedure INSERT_REGION_ITEM_ROW (
346: p_REGION_CODE in VARCHAR2
419: X_ATTRIBUTE12 in VARCHAR2,
420: X_ATTRIBUTE13 in VARCHAR2,
421: X_ATTRIBUTE14 in VARCHAR2,
422: X_ATTRIBUTE15 in VARCHAR2,
423: X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
424: X_ORDER_SEQUENCE in VARCHAR2 := NULL,
425: X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR);
426:
427:
421: X_ATTRIBUTE14 in VARCHAR2,
422: X_ATTRIBUTE15 in VARCHAR2,
423: X_URL in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR,
424: X_ORDER_SEQUENCE in VARCHAR2 := NULL,
425: X_ORDER_DIRECTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR);
426:
427:
428: -- nbarik 02/10/04 - overloaded for region record type
429: PROCEDURE UPDATE_REGION_ITEM_ROW