3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE awr_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: ant_id NUMBER := okl_api.G_MISS_NUM,
9: rul_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 awr_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: ant_id NUMBER := okl_api.G_MISS_NUM,
9: rul_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_ANSWERS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE awr_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: ant_id NUMBER := okl_api.G_MISS_NUM,
9: rul_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_ANSWERS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSWERS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
6: TYPE awr_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: ant_id NUMBER := okl_api.G_MISS_NUM,
9: rul_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_ANSWERS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSWERS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSWERS.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: rul_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_ANSWERS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSWERS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSWERS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSWERS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
8: ant_id NUMBER := okl_api.G_MISS_NUM,
9: rul_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_ANSWERS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSWERS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSWERS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSWERS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSWERS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
9: rul_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_ANSWERS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSWERS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSWERS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSWERS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSWERS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSWERS.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_ANSWERS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSWERS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSWERS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSWERS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSWERS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSWERS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSWERS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_ANSWERS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSWERS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSWERS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSWERS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSWERS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSWERS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSWERS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSWERS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
12: attribute_category OKL_ANSWERS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSWERS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSWERS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSWERS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSWERS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSWERS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSWERS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSWERS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSWERS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_ANSWERS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSWERS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSWERS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSWERS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSWERS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSWERS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSWERS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSWERS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSWERS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_ANSWERS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSWERS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSWERS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSWERS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSWERS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSWERS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSWERS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSWERS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSWERS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_ANSWERS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSWERS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSWERS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSWERS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSWERS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSWERS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSWERS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSWERS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSWERS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_ANSWERS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSWERS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSWERS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSWERS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSWERS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSWERS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSWERS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSWERS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSWERS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_ANSWERS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSWERS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSWERS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSWERS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSWERS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSWERS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSWERS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSWERS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSWERS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_ANSWERS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSWERS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSWERS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSWERS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSWERS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSWERS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSWERS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSWERS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSWERS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_ANSWERS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSWERS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSWERS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSWERS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSWERS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSWERS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSWERS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSWERS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSWERS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_ANSWERS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_ANSWERS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSWERS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSWERS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSWERS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSWERS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSWERS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSWERS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
21: attribute9 OKL_ANSWERS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_ANSWERS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSWERS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSWERS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSWERS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSWERS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSWERS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_ANSWERS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
22: attribute10 OKL_ANSWERS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_ANSWERS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSWERS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSWERS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSWERS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSWERS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_ANSWERS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
23: attribute11 OKL_ANSWERS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_ANSWERS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSWERS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSWERS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSWERS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_ANSWERS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_ANSWERS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
24: attribute12 OKL_ANSWERS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_ANSWERS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSWERS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSWERS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_ANSWERS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_ANSWERS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
25: attribute13 OKL_ANSWERS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_ANSWERS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSWERS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_ANSWERS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_ANSWERS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
33: g_miss_awr_rec awr_rec_type;
26: attribute14 OKL_ANSWERS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_ANSWERS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_ANSWERS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_ANSWERS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
33: g_miss_awr_rec awr_rec_type;
34: TYPE awr_tbl_type IS TABLE OF awr_rec_type
27: attribute15 OKL_ANSWERS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_ANSWERS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_ANSWERS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
33: g_miss_awr_rec awr_rec_type;
34: TYPE awr_tbl_type IS TABLE OF awr_rec_type
35: INDEX BY BINARY_INTEGER;
28: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: creation_date OKL_ANSWERS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_ANSWERS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
33: g_miss_awr_rec awr_rec_type;
34: TYPE awr_tbl_type IS TABLE OF awr_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE awrv_rec_type IS RECORD (
33: g_miss_awr_rec awr_rec_type;
34: TYPE awr_tbl_type IS TABLE OF awr_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE awrv_rec_type IS RECORD (
37: id NUMBER := okl_api.G_MISS_NUM,
38: object_version_number NUMBER := okl_api.G_MISS_NUM,
39: ant_id NUMBER := okl_api.G_MISS_NUM,
40: rul_id NUMBER := okl_api.G_MISS_NUM,
41: sort_sequence NUMBER := okl_api.G_MISS_NUM,
34: TYPE awr_tbl_type IS TABLE OF awr_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE awrv_rec_type IS RECORD (
37: id NUMBER := okl_api.G_MISS_NUM,
38: object_version_number NUMBER := okl_api.G_MISS_NUM,
39: ant_id NUMBER := okl_api.G_MISS_NUM,
40: rul_id NUMBER := okl_api.G_MISS_NUM,
41: sort_sequence NUMBER := okl_api.G_MISS_NUM,
42: attribute_category OKL_ANSWERS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
35: INDEX BY BINARY_INTEGER;
36: TYPE awrv_rec_type IS RECORD (
37: id NUMBER := okl_api.G_MISS_NUM,
38: object_version_number NUMBER := okl_api.G_MISS_NUM,
39: ant_id NUMBER := okl_api.G_MISS_NUM,
40: rul_id NUMBER := okl_api.G_MISS_NUM,
41: sort_sequence NUMBER := okl_api.G_MISS_NUM,
42: attribute_category OKL_ANSWERS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSWERS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
36: TYPE awrv_rec_type IS RECORD (
37: id NUMBER := okl_api.G_MISS_NUM,
38: object_version_number NUMBER := okl_api.G_MISS_NUM,
39: ant_id NUMBER := okl_api.G_MISS_NUM,
40: rul_id NUMBER := okl_api.G_MISS_NUM,
41: sort_sequence NUMBER := okl_api.G_MISS_NUM,
42: attribute_category OKL_ANSWERS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSWERS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSWERS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
37: id NUMBER := okl_api.G_MISS_NUM,
38: object_version_number NUMBER := okl_api.G_MISS_NUM,
39: ant_id NUMBER := okl_api.G_MISS_NUM,
40: rul_id NUMBER := okl_api.G_MISS_NUM,
41: sort_sequence NUMBER := okl_api.G_MISS_NUM,
42: attribute_category OKL_ANSWERS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSWERS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSWERS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSWERS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
38: object_version_number NUMBER := okl_api.G_MISS_NUM,
39: ant_id NUMBER := okl_api.G_MISS_NUM,
40: rul_id NUMBER := okl_api.G_MISS_NUM,
41: sort_sequence NUMBER := okl_api.G_MISS_NUM,
42: attribute_category OKL_ANSWERS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSWERS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSWERS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSWERS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSWERS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
39: ant_id NUMBER := okl_api.G_MISS_NUM,
40: rul_id NUMBER := okl_api.G_MISS_NUM,
41: sort_sequence NUMBER := okl_api.G_MISS_NUM,
42: attribute_category OKL_ANSWERS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSWERS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSWERS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSWERS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSWERS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSWERS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
40: rul_id NUMBER := okl_api.G_MISS_NUM,
41: sort_sequence NUMBER := okl_api.G_MISS_NUM,
42: attribute_category OKL_ANSWERS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSWERS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSWERS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSWERS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSWERS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSWERS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSWERS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
41: sort_sequence NUMBER := okl_api.G_MISS_NUM,
42: attribute_category OKL_ANSWERS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSWERS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSWERS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSWERS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSWERS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSWERS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSWERS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSWERS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
42: attribute_category OKL_ANSWERS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSWERS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSWERS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSWERS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSWERS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSWERS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSWERS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSWERS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSWERS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
43: attribute1 OKL_ANSWERS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSWERS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSWERS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSWERS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSWERS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSWERS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSWERS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSWERS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSWERS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
44: attribute2 OKL_ANSWERS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSWERS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSWERS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSWERS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSWERS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSWERS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSWERS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSWERS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSWERS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
45: attribute3 OKL_ANSWERS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSWERS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSWERS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSWERS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSWERS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSWERS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSWERS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSWERS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSWERS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
46: attribute4 OKL_ANSWERS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSWERS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSWERS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSWERS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSWERS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSWERS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSWERS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSWERS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSWERS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
47: attribute5 OKL_ANSWERS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSWERS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSWERS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSWERS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSWERS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSWERS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSWERS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSWERS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSWERS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
48: attribute6 OKL_ANSWERS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSWERS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSWERS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSWERS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSWERS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSWERS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSWERS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSWERS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSWERS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
49: attribute7 OKL_ANSWERS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSWERS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSWERS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSWERS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSWERS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSWERS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSWERS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSWERS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSWERS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
50: attribute8 OKL_ANSWERS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51: attribute9 OKL_ANSWERS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSWERS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSWERS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSWERS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSWERS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSWERS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSWERS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
51: attribute9 OKL_ANSWERS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52: attribute10 OKL_ANSWERS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSWERS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSWERS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSWERS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSWERS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSWERS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
59: creation_date OKL_ANSWERS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
52: attribute10 OKL_ANSWERS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53: attribute11 OKL_ANSWERS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSWERS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSWERS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSWERS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSWERS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
59: creation_date OKL_ANSWERS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_updated_by NUMBER := okl_api.G_MISS_NUM,
53: attribute11 OKL_ANSWERS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54: attribute12 OKL_ANSWERS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSWERS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSWERS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSWERS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
59: creation_date OKL_ANSWERS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_updated_by NUMBER := okl_api.G_MISS_NUM,
61: last_update_date OKL_ANSWERS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
54: attribute12 OKL_ANSWERS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55: attribute13 OKL_ANSWERS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSWERS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSWERS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
59: creation_date OKL_ANSWERS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_updated_by NUMBER := okl_api.G_MISS_NUM,
61: last_update_date OKL_ANSWERS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
62: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
55: attribute13 OKL_ANSWERS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56: attribute14 OKL_ANSWERS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSWERS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
59: creation_date OKL_ANSWERS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_updated_by NUMBER := okl_api.G_MISS_NUM,
61: last_update_date OKL_ANSWERS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
62: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
63: g_miss_awrv_rec awrv_rec_type;
56: attribute14 OKL_ANSWERS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57: attribute15 OKL_ANSWERS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
59: creation_date OKL_ANSWERS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_updated_by NUMBER := okl_api.G_MISS_NUM,
61: last_update_date OKL_ANSWERS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
62: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
63: g_miss_awrv_rec awrv_rec_type;
64: TYPE awrv_tbl_type IS TABLE OF awrv_rec_type
57: attribute15 OKL_ANSWERS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58: created_by NUMBER := okl_api.G_MISS_NUM,
59: creation_date OKL_ANSWERS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_updated_by NUMBER := okl_api.G_MISS_NUM,
61: last_update_date OKL_ANSWERS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
62: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
63: g_miss_awrv_rec awrv_rec_type;
64: TYPE awrv_tbl_type IS TABLE OF awrv_rec_type
65: INDEX BY BINARY_INTEGER;
58: created_by NUMBER := okl_api.G_MISS_NUM,
59: creation_date OKL_ANSWERS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_updated_by NUMBER := okl_api.G_MISS_NUM,
61: last_update_date OKL_ANSWERS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
62: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
63: g_miss_awrv_rec awrv_rec_type;
64: TYPE awrv_tbl_type IS TABLE OF awrv_rec_type
65: INDEX BY BINARY_INTEGER;
66: ---------------------------------------------------------------------------
65: INDEX BY BINARY_INTEGER;
66: ---------------------------------------------------------------------------
67: -- GLOBAL MESSAGE CONSTANTS
68: ---------------------------------------------------------------------------
69: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
66: ---------------------------------------------------------------------------
67: -- GLOBAL MESSAGE CONSTANTS
68: ---------------------------------------------------------------------------
69: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
67: -- GLOBAL MESSAGE CONSTANTS
68: ---------------------------------------------------------------------------
69: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
68: ---------------------------------------------------------------------------
69: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
69: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
70: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
71: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
79: ---------------------------------------------------------------------------
72: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
79: ---------------------------------------------------------------------------
80: -- GLOBAL VARIABLES
73: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
79: ---------------------------------------------------------------------------
80: -- GLOBAL VARIABLES
81: ---------------------------------------------------------------------------
74: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
76: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
77: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
78: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
79: ---------------------------------------------------------------------------
80: -- GLOBAL VARIABLES
81: ---------------------------------------------------------------------------
82: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AWR_PVT';
79: ---------------------------------------------------------------------------
80: -- GLOBAL VARIABLES
81: ---------------------------------------------------------------------------
82: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AWR_PVT';
83: G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
84:
85: /******************ADDED AFTER TAPI, (05/23/2001) ****************/
86: --GLOBAL MESSAGES
87: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
105: PROCEDURE change_version;
106: PROCEDURE api_copy;
107: PROCEDURE insert_row(
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_awrv_rec IN awrv_rec_type,
114: x_awrv_rec OUT NOCOPY awrv_rec_type);
115:
116: PROCEDURE insert_row(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_awrv_tbl IN awrv_tbl_type,
123: x_awrv_tbl OUT NOCOPY awrv_tbl_type);
124:
125: PROCEDURE lock_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_awrv_rec IN awrv_rec_type);
131: p_awrv_rec IN awrv_rec_type);
132:
133: PROCEDURE lock_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_awrv_tbl IN awrv_tbl_type);
139: p_awrv_tbl IN awrv_tbl_type);
140:
141: PROCEDURE update_row(
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_awrv_rec IN awrv_rec_type,
148: x_awrv_rec OUT NOCOPY awrv_rec_type);
149:
150: PROCEDURE update_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_awrv_tbl IN awrv_tbl_type,
157: x_awrv_tbl OUT NOCOPY awrv_tbl_type);
158:
159: PROCEDURE delete_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_awrv_rec IN awrv_rec_type);
165: p_awrv_rec IN awrv_rec_type);
166:
167: PROCEDURE delete_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_awrv_tbl IN awrv_tbl_type);
173: p_awrv_tbl IN awrv_tbl_type);
174:
175: PROCEDURE validate_row(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_awrv_rec IN awrv_rec_type);
181: p_awrv_rec IN awrv_rec_type);
182:
183: PROCEDURE validate_row(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_awrv_tbl IN awrv_tbl_type);