3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE asr_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: ant_id NUMBER := okl_api.G_MISS_NUM,
9: qcn_id NUMBER := okl_api.G_MISS_NUM,
10: sort_sequence NUMBER := okl_api.G_MISS_NUM,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE asr_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: ant_id NUMBER := okl_api.G_MISS_NUM,
9: qcn_id NUMBER := okl_api.G_MISS_NUM,
10: sort_sequence NUMBER := okl_api.G_MISS_NUM,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE asr_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: ant_id NUMBER := okl_api.G_MISS_NUM,
9: qcn_id NUMBER := okl_api.G_MISS_NUM,
10: sort_sequence NUMBER := okl_api.G_MISS_NUM,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
6: TYPE asr_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: ant_id NUMBER := okl_api.G_MISS_NUM,
9: qcn_id NUMBER := okl_api.G_MISS_NUM,
10: sort_sequence NUMBER := okl_api.G_MISS_NUM,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
7: id NUMBER := okl_api.G_MISS_NUM,
8: ant_id NUMBER := okl_api.G_MISS_NUM,
9: qcn_id NUMBER := okl_api.G_MISS_NUM,
10: sort_sequence NUMBER := okl_api.G_MISS_NUM,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
8: ant_id NUMBER := okl_api.G_MISS_NUM,
9: qcn_id NUMBER := okl_api.G_MISS_NUM,
10: sort_sequence NUMBER := okl_api.G_MISS_NUM,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
9: qcn_id NUMBER := okl_api.G_MISS_NUM,
10: sort_sequence NUMBER := okl_api.G_MISS_NUM,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
10: sort_sequence NUMBER := okl_api.G_MISS_NUM,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
12: attribute_category OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
21: attribute9 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_ANSR_SET_CRTRIA_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
22: attribute10 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_ANSR_SET_CRTRIA_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
23: attribute11 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_ANSR_SET_CRTRIA_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_ANSR_SET_CRTRIA_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
24: attribute12 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_ANSR_SET_CRTRIA_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_ANSR_SET_CRTRIA_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
25: attribute13 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_ANSR_SET_CRTRIA_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_ANSR_SET_CRTRIA_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
33: g_miss_asr_rec asr_rec_type;
26: attribute14 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_ANSR_SET_CRTRIA_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_ANSR_SET_CRTRIA_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
33: g_miss_asr_rec asr_rec_type;
34: TYPE asr_tbl_type IS TABLE OF asr_rec_type
27: attribute15 OKL_ANSR_SET_CRTRIA_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_ANSR_SET_CRTRIA_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_ANSR_SET_CRTRIA_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
33: g_miss_asr_rec asr_rec_type;
34: TYPE asr_tbl_type IS TABLE OF asr_rec_type
35: INDEX BY BINARY_INTEGER;
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_ANSR_SET_CRTRIA_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_ANSR_SET_CRTRIA_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
33: g_miss_asr_rec asr_rec_type;
34: TYPE asr_tbl_type IS TABLE OF asr_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE OklAnsrSetCrtriaTlRecType IS RECORD (
33: g_miss_asr_rec asr_rec_type;
34: TYPE asr_tbl_type IS TABLE OF asr_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE OklAnsrSetCrtriaTlRecType IS RECORD (
37: id NUMBER := okl_api.G_MISS_NUM,
38: LANGUAGE OKL_ANSR_SET_CRTRIA_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
39: source_lang OKL_ANSR_SET_CRTRIA_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_ANSR_SET_CRTRIA_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: description OKL_ANSR_SET_CRTRIA_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
34: TYPE asr_tbl_type IS TABLE OF asr_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE OklAnsrSetCrtriaTlRecType IS RECORD (
37: id NUMBER := okl_api.G_MISS_NUM,
38: LANGUAGE OKL_ANSR_SET_CRTRIA_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
39: source_lang OKL_ANSR_SET_CRTRIA_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_ANSR_SET_CRTRIA_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: description OKL_ANSR_SET_CRTRIA_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
42: created_by NUMBER := okl_api.G_MISS_NUM,
35: INDEX BY BINARY_INTEGER;
36: TYPE OklAnsrSetCrtriaTlRecType IS RECORD (
37: id NUMBER := okl_api.G_MISS_NUM,
38: LANGUAGE OKL_ANSR_SET_CRTRIA_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
39: source_lang OKL_ANSR_SET_CRTRIA_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_ANSR_SET_CRTRIA_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: description OKL_ANSR_SET_CRTRIA_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
42: created_by NUMBER := okl_api.G_MISS_NUM,
43: creation_date OKL_ANSR_SET_CRTRIA_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
36: TYPE OklAnsrSetCrtriaTlRecType IS RECORD (
37: id NUMBER := okl_api.G_MISS_NUM,
38: LANGUAGE OKL_ANSR_SET_CRTRIA_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
39: source_lang OKL_ANSR_SET_CRTRIA_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_ANSR_SET_CRTRIA_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: description OKL_ANSR_SET_CRTRIA_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
42: created_by NUMBER := okl_api.G_MISS_NUM,
43: creation_date OKL_ANSR_SET_CRTRIA_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
44: last_updated_by NUMBER := okl_api.G_MISS_NUM,
37: id NUMBER := okl_api.G_MISS_NUM,
38: LANGUAGE OKL_ANSR_SET_CRTRIA_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
39: source_lang OKL_ANSR_SET_CRTRIA_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_ANSR_SET_CRTRIA_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: description OKL_ANSR_SET_CRTRIA_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
42: created_by NUMBER := okl_api.G_MISS_NUM,
43: creation_date OKL_ANSR_SET_CRTRIA_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
44: last_updated_by NUMBER := okl_api.G_MISS_NUM,
45: last_update_date OKL_ANSR_SET_CRTRIA_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
38: LANGUAGE OKL_ANSR_SET_CRTRIA_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
39: source_lang OKL_ANSR_SET_CRTRIA_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_ANSR_SET_CRTRIA_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: description OKL_ANSR_SET_CRTRIA_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
42: created_by NUMBER := okl_api.G_MISS_NUM,
43: creation_date OKL_ANSR_SET_CRTRIA_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
44: last_updated_by NUMBER := okl_api.G_MISS_NUM,
45: last_update_date OKL_ANSR_SET_CRTRIA_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
46: last_update_login NUMBER := okl_api.G_MISS_NUM);
39: source_lang OKL_ANSR_SET_CRTRIA_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_ANSR_SET_CRTRIA_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: description OKL_ANSR_SET_CRTRIA_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
42: created_by NUMBER := okl_api.G_MISS_NUM,
43: creation_date OKL_ANSR_SET_CRTRIA_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
44: last_updated_by NUMBER := okl_api.G_MISS_NUM,
45: last_update_date OKL_ANSR_SET_CRTRIA_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
46: last_update_login NUMBER := okl_api.G_MISS_NUM);
47: GMissOklAnsrSetCrtriaTlRec OklAnsrSetCrtriaTlRecType;
40: sfwt_flag OKL_ANSR_SET_CRTRIA_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: description OKL_ANSR_SET_CRTRIA_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
42: created_by NUMBER := okl_api.G_MISS_NUM,
43: creation_date OKL_ANSR_SET_CRTRIA_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
44: last_updated_by NUMBER := okl_api.G_MISS_NUM,
45: last_update_date OKL_ANSR_SET_CRTRIA_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
46: last_update_login NUMBER := okl_api.G_MISS_NUM);
47: GMissOklAnsrSetCrtriaTlRec OklAnsrSetCrtriaTlRecType;
48: TYPE OklAnsrSetCrtriaTlTblType IS TABLE OF OklAnsrSetCrtriaTlRecType
41: description OKL_ANSR_SET_CRTRIA_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
42: created_by NUMBER := okl_api.G_MISS_NUM,
43: creation_date OKL_ANSR_SET_CRTRIA_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
44: last_updated_by NUMBER := okl_api.G_MISS_NUM,
45: last_update_date OKL_ANSR_SET_CRTRIA_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
46: last_update_login NUMBER := okl_api.G_MISS_NUM);
47: GMissOklAnsrSetCrtriaTlRec OklAnsrSetCrtriaTlRecType;
48: TYPE OklAnsrSetCrtriaTlTblType IS TABLE OF OklAnsrSetCrtriaTlRecType
49: INDEX BY BINARY_INTEGER;
42: created_by NUMBER := okl_api.G_MISS_NUM,
43: creation_date OKL_ANSR_SET_CRTRIA_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
44: last_updated_by NUMBER := okl_api.G_MISS_NUM,
45: last_update_date OKL_ANSR_SET_CRTRIA_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
46: last_update_login NUMBER := okl_api.G_MISS_NUM);
47: GMissOklAnsrSetCrtriaTlRec OklAnsrSetCrtriaTlRecType;
48: TYPE OklAnsrSetCrtriaTlTblType IS TABLE OF OklAnsrSetCrtriaTlRecType
49: INDEX BY BINARY_INTEGER;
50: TYPE asrv_rec_type IS RECORD (
47: GMissOklAnsrSetCrtriaTlRec OklAnsrSetCrtriaTlRecType;
48: TYPE OklAnsrSetCrtriaTlTblType IS TABLE OF OklAnsrSetCrtriaTlRecType
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,
48: TYPE OklAnsrSetCrtriaTlTblType IS TABLE OF OklAnsrSetCrtriaTlRecType
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,
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,
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,
58: attribute_category OKL_ANSR_SET_CRTRIA_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
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,
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,
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,
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,
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,
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,
78: last_update_login NUMBER := okl_api.G_MISS_NUM);
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;
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;
80: TYPE asrv_tbl_type IS TABLE OF 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;
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;
82: ---------------------------------------------------------------------------
81: INDEX BY BINARY_INTEGER;
82: ---------------------------------------------------------------------------
83: -- GLOBAL MESSAGE CONSTANTS
84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
82: ---------------------------------------------------------------------------
83: -- GLOBAL MESSAGE CONSTANTS
84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
83: -- GLOBAL MESSAGE CONSTANTS
84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
84: ---------------------------------------------------------------------------
85: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
85: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
86: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
87: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
95: ---------------------------------------------------------------------------
88: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
95: ---------------------------------------------------------------------------
96: -- GLOBAL VARIABLES
89: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
95: ---------------------------------------------------------------------------
96: -- GLOBAL VARIABLES
97: ---------------------------------------------------------------------------
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
91: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
92: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
93: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
94: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
95: ---------------------------------------------------------------------------
96: -- GLOBAL VARIABLES
97: ---------------------------------------------------------------------------
98: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ASR_PVT';
95: ---------------------------------------------------------------------------
96: -- GLOBAL VARIABLES
97: ---------------------------------------------------------------------------
98: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ASR_PVT';
99: G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
100:
101: /******************ADDED AFTER TAPI, (05/23/2001) ****************/
102: --GLOBAL MESSAGES
103: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
122: PROCEDURE api_copy;
123: PROCEDURE add_language;
124: PROCEDURE insert_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_asrv_rec IN asrv_rec_type,
131: x_asrv_rec OUT NOCOPY asrv_rec_type);
132:
133: PROCEDURE insert_row(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_asrv_tbl IN asrv_tbl_type,
140: x_asrv_tbl OUT NOCOPY asrv_tbl_type);
141:
142: PROCEDURE lock_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_asrv_rec IN asrv_rec_type);
148: p_asrv_rec IN asrv_rec_type);
149:
150: PROCEDURE lock_row(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_asrv_tbl IN asrv_tbl_type);
156: p_asrv_tbl IN asrv_tbl_type);
157:
158: PROCEDURE update_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_asrv_rec IN asrv_rec_type,
165: x_asrv_rec OUT NOCOPY asrv_rec_type);
166:
167: PROCEDURE update_row(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_asrv_tbl IN asrv_tbl_type,
174: x_asrv_tbl OUT NOCOPY asrv_tbl_type);
175:
176: PROCEDURE delete_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_asrv_rec IN asrv_rec_type);
182: p_asrv_rec IN asrv_rec_type);
183:
184: PROCEDURE delete_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_asrv_tbl IN asrv_tbl_type);
190: p_asrv_tbl IN asrv_tbl_type);
191:
192: PROCEDURE validate_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_asrv_rec IN asrv_rec_type);
198: p_asrv_rec IN asrv_rec_type);
199:
200: PROCEDURE validate_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_asrv_tbl IN asrv_tbl_type);