38: object_version_number NUMBER := okl_api.G_MISS_NUM,
39: awr_id NUMBER := okl_api.G_MISS_NUM,
40: asv_id NUMBER := okl_api.G_MISS_NUM,
41: asr_id NUMBER := okl_api.G_MISS_NUM,
42: attribute_category OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
39: awr_id NUMBER := okl_api.G_MISS_NUM,
40: asv_id NUMBER := okl_api.G_MISS_NUM,
41: asr_id NUMBER := okl_api.G_MISS_NUM,
42: attribute_category OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
40: asv_id NUMBER := okl_api.G_MISS_NUM,
41: asr_id NUMBER := okl_api.G_MISS_NUM,
42: attribute_category OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
41: asr_id NUMBER := okl_api.G_MISS_NUM,
42: attribute_category OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
42: attribute_category OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
51: attribute9 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
59: creation_date OKL_ANSR_CRTRN_VALS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
52: attribute10 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
59: creation_date OKL_ANSR_CRTRN_VALS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_updated_by NUMBER := okl_api.G_MISS_NUM,
53: attribute11 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
59: creation_date OKL_ANSR_CRTRN_VALS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_updated_by NUMBER := okl_api.G_MISS_NUM,
61: last_update_date OKL_ANSR_CRTRN_VALS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
55: attribute13 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
59: creation_date OKL_ANSR_CRTRN_VALS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_updated_by NUMBER := okl_api.G_MISS_NUM,
61: last_update_date OKL_ANSR_CRTRN_VALS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
62: last_update_login NUMBER := okl_api.G_MISS_NUM);
63: g_miss_acvv_rec acvv_rec_type;
57: attribute15 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
59: creation_date OKL_ANSR_CRTRN_VALS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_updated_by NUMBER := okl_api.G_MISS_NUM,
61: last_update_date OKL_ANSR_CRTRN_VALS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
62: last_update_login NUMBER := okl_api.G_MISS_NUM);
63: g_miss_acvv_rec acvv_rec_type;
64: TYPE acvv_tbl_type IS TABLE OF acvv_rec_type
65: INDEX BY BINARY_INTEGER;
91: G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
92:
93:
94: --GLOBAL VARIABLES
95: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_ANSR_CRTRN_VALS_V';
96: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
97:
98: ---------------------------------------------------------------------------
99: -- validation Procedures and Functions