49: INDEX BY BINARY_INTEGER;
50: TYPE asrv_rec_type IS RECORD (
51: id NUMBER := okl_api.G_MISS_NUM,
52: object_version_number NUMBER := okl_api.G_MISS_NUM,
53: sfwt_flag OKL_ANSR_SET_CRTRIA_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
54: ant_id NUMBER := okl_api.G_MISS_NUM,
55: qcn_id NUMBER := okl_api.G_MISS_NUM,
56: sort_sequence NUMBER := okl_api.G_MISS_NUM,
57: description OKL_ANSR_SET_CRTRIA_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
53: sfwt_flag OKL_ANSR_SET_CRTRIA_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
54: ant_id NUMBER := okl_api.G_MISS_NUM,
55: qcn_id NUMBER := okl_api.G_MISS_NUM,
56: sort_sequence NUMBER := okl_api.G_MISS_NUM,
57: description OKL_ANSR_SET_CRTRIA_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58: attribute_category OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
59: attribute1 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
60: attribute2 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
61: attribute3 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
54: ant_id NUMBER := okl_api.G_MISS_NUM,
55: qcn_id NUMBER := okl_api.G_MISS_NUM,
56: sort_sequence NUMBER := okl_api.G_MISS_NUM,
57: description OKL_ANSR_SET_CRTRIA_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58: attribute_category OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
59: attribute1 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
60: attribute2 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
61: attribute3 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
62: attribute4 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
55: qcn_id NUMBER := okl_api.G_MISS_NUM,
56: sort_sequence NUMBER := okl_api.G_MISS_NUM,
57: description OKL_ANSR_SET_CRTRIA_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58: attribute_category OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
59: attribute1 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
60: attribute2 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
61: attribute3 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
62: attribute4 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
63: attribute5 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
56: sort_sequence NUMBER := okl_api.G_MISS_NUM,
57: description OKL_ANSR_SET_CRTRIA_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58: attribute_category OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
59: attribute1 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
60: attribute2 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
61: attribute3 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
62: attribute4 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
63: attribute5 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
64: attribute6 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
57: description OKL_ANSR_SET_CRTRIA_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58: attribute_category OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
59: attribute1 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
60: attribute2 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
61: attribute3 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
62: attribute4 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
63: attribute5 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
64: attribute6 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
65: attribute7 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
58: attribute_category OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
59: attribute1 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
60: attribute2 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
61: attribute3 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
62: attribute4 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
63: attribute5 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
64: attribute6 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
65: attribute7 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
66: attribute8 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
59: attribute1 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
60: attribute2 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
61: attribute3 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
62: attribute4 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
63: attribute5 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
64: attribute6 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
65: attribute7 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
66: attribute8 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
67: attribute9 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
60: attribute2 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
61: attribute3 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
62: attribute4 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
63: attribute5 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
64: attribute6 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
65: attribute7 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
66: attribute8 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
67: attribute9 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
68: attribute10 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
61: attribute3 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
62: attribute4 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
63: attribute5 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
64: attribute6 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
65: attribute7 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
66: attribute8 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
67: attribute9 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
68: attribute10 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
69: attribute11 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
62: attribute4 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
63: attribute5 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
64: attribute6 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
65: attribute7 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
66: attribute8 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
67: attribute9 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
68: attribute10 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
69: attribute11 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
70: attribute12 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
63: attribute5 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
64: attribute6 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
65: attribute7 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
66: attribute8 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
67: attribute9 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
68: attribute10 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
69: attribute11 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
70: attribute12 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
71: attribute13 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
64: attribute6 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
65: attribute7 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
66: attribute8 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
67: attribute9 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
68: attribute10 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
69: attribute11 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
70: attribute12 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
71: attribute13 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
72: attribute14 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
65: attribute7 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
66: attribute8 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
67: attribute9 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
68: attribute10 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
69: attribute11 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
70: attribute12 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
71: attribute13 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
72: attribute14 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
73: attribute15 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
66: attribute8 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
67: attribute9 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
68: attribute10 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
69: attribute11 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
70: attribute12 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
71: attribute13 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
72: attribute14 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
73: attribute15 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
74: created_by NUMBER := okl_api.G_MISS_NUM,
67: attribute9 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
68: attribute10 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
69: attribute11 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
70: attribute12 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
71: attribute13 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
72: attribute14 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
73: attribute15 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
74: created_by NUMBER := okl_api.G_MISS_NUM,
75: creation_date OKL_ANSR_SET_CRTRIA_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
68: attribute10 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
69: attribute11 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
70: attribute12 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
71: attribute13 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
72: attribute14 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
73: attribute15 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
74: created_by NUMBER := okl_api.G_MISS_NUM,
75: creation_date OKL_ANSR_SET_CRTRIA_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
76: last_updated_by NUMBER := okl_api.G_MISS_NUM,
69: attribute11 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
70: attribute12 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
71: attribute13 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
72: attribute14 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
73: attribute15 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
74: created_by NUMBER := okl_api.G_MISS_NUM,
75: creation_date OKL_ANSR_SET_CRTRIA_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
76: last_updated_by NUMBER := okl_api.G_MISS_NUM,
77: last_update_date OKL_ANSR_SET_CRTRIA_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
71: attribute13 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
72: attribute14 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
73: attribute15 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
74: created_by NUMBER := okl_api.G_MISS_NUM,
75: creation_date OKL_ANSR_SET_CRTRIA_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
76: last_updated_by NUMBER := okl_api.G_MISS_NUM,
77: last_update_date OKL_ANSR_SET_CRTRIA_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
78: last_update_login NUMBER := okl_api.G_MISS_NUM);
79: g_miss_asrv_rec asrv_rec_type;
73: attribute15 OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
74: created_by NUMBER := okl_api.G_MISS_NUM,
75: creation_date OKL_ANSR_SET_CRTRIA_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
76: last_updated_by NUMBER := okl_api.G_MISS_NUM,
77: last_update_date OKL_ANSR_SET_CRTRIA_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
78: last_update_login NUMBER := okl_api.G_MISS_NUM);
79: g_miss_asrv_rec asrv_rec_type;
80: TYPE asrv_tbl_type IS TABLE OF asrv_rec_type
81: INDEX BY BINARY_INTEGER;
107: G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
108:
109:
110: --GLOBAL VARIABLES
111: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_ANSR_SET_CRTRIA_V';
112: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
113:
114: /****************END ADDITION AFTER TAPI, (05/23/2001)**************/
115: