3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cls_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: crn_id NUMBER := okl_api.G_MISS_NUM,
9: lse_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_CRTRN_LNSTYLS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cls_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: crn_id NUMBER := okl_api.G_MISS_NUM,
9: lse_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_CRTRN_LNSTYLS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_CRTRN_LNSTYLS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE cls_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: crn_id NUMBER := okl_api.G_MISS_NUM,
9: lse_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_CRTRN_LNSTYLS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_CRTRN_LNSTYLS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_CRTRN_LNSTYLS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
6: TYPE cls_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: crn_id NUMBER := okl_api.G_MISS_NUM,
9: lse_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_CRTRN_LNSTYLS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_CRTRN_LNSTYLS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_CRTRN_LNSTYLS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_CRTRN_LNSTYLS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
7: id NUMBER := okl_api.G_MISS_NUM,
8: crn_id NUMBER := okl_api.G_MISS_NUM,
9: lse_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_CRTRN_LNSTYLS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_CRTRN_LNSTYLS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_CRTRN_LNSTYLS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_CRTRN_LNSTYLS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_CRTRN_LNSTYLS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
8: crn_id NUMBER := okl_api.G_MISS_NUM,
9: lse_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_CRTRN_LNSTYLS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_CRTRN_LNSTYLS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_CRTRN_LNSTYLS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_CRTRN_LNSTYLS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_CRTRN_LNSTYLS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_CRTRN_LNSTYLS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
9: lse_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_CRTRN_LNSTYLS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_CRTRN_LNSTYLS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_CRTRN_LNSTYLS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_CRTRN_LNSTYLS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_CRTRN_LNSTYLS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_CRTRN_LNSTYLS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_CRTRN_LNSTYLS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_CRTRN_LNSTYLS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_CRTRN_LNSTYLS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_CRTRN_LNSTYLS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_CRTRN_LNSTYLS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_CRTRN_LNSTYLS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_CRTRN_LNSTYLS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_CRTRN_LNSTYLS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_CRTRN_LNSTYLS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
11: attribute_category OKL_CRTRN_LNSTYLS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_CRTRN_LNSTYLS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_CRTRN_LNSTYLS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_CRTRN_LNSTYLS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_CRTRN_LNSTYLS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_CRTRN_LNSTYLS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_CRTRN_LNSTYLS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_CRTRN_LNSTYLS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_CRTRN_LNSTYLS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_CRTRN_LNSTYLS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_CRTRN_LNSTYLS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_CRTRN_LNSTYLS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_CRTRN_LNSTYLS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_CRTRN_LNSTYLS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_CRTRN_LNSTYLS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_CRTRN_LNSTYLS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_CRTRN_LNSTYLS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_CRTRN_LNSTYLS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_CRTRN_LNSTYLS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_CRTRN_LNSTYLS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_CRTRN_LNSTYLS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_CRTRN_LNSTYLS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_CRTRN_LNSTYLS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_CRTRN_LNSTYLS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_CRTRN_LNSTYLS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_CRTRN_LNSTYLS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_CRTRN_LNSTYLS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_CRTRN_LNSTYLS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_CRTRN_LNSTYLS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_CRTRN_LNSTYLS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_CRTRN_LNSTYLS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_CRTRN_LNSTYLS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_CRTRN_LNSTYLS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_CRTRN_LNSTYLS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_CRTRN_LNSTYLS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_CRTRN_LNSTYLS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_CRTRN_LNSTYLS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_CRTRN_LNSTYLS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_CRTRN_LNSTYLS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_CRTRN_LNSTYLS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_CRTRN_LNSTYLS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_CRTRN_LNSTYLS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_CRTRN_LNSTYLS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_CRTRN_LNSTYLS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_CRTRN_LNSTYLS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_CRTRN_LNSTYLS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_CRTRN_LNSTYLS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_CRTRN_LNSTYLS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_CRTRN_LNSTYLS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_CRTRN_LNSTYLS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_CRTRN_LNSTYLS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_CRTRN_LNSTYLS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_CRTRN_LNSTYLS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
24: attribute13 OKL_CRTRN_LNSTYLS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_CRTRN_LNSTYLS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_CRTRN_LNSTYLS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_CRTRN_LNSTYLS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_CRTRN_LNSTYLS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_CRTRN_LNSTYLS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_CRTRN_LNSTYLS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_CRTRN_LNSTYLS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
24: attribute13 OKL_CRTRN_LNSTYLS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
25: attribute14 OKL_CRTRN_LNSTYLS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_CRTRN_LNSTYLS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_CRTRN_LNSTYLS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_CRTRN_LNSTYLS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_CRTRN_LNSTYLS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_CRTRN_LNSTYLS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_CRTRN_LNSTYLS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
24: attribute13 OKL_CRTRN_LNSTYLS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
25: attribute14 OKL_CRTRN_LNSTYLS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_CRTRN_LNSTYLS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_CRTRN_LNSTYLS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_CRTRN_LNSTYLS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_CRTRN_LNSTYLS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_CRTRN_LNSTYLS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_CRTRN_LNSTYLS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
24: attribute13 OKL_CRTRN_LNSTYLS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
25: attribute14 OKL_CRTRN_LNSTYLS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_CRTRN_LNSTYLS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := okl_api.G_MISS_NUM,
20: attribute9 OKL_CRTRN_LNSTYLS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_CRTRN_LNSTYLS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_CRTRN_LNSTYLS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_CRTRN_LNSTYLS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
24: attribute13 OKL_CRTRN_LNSTYLS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
25: attribute14 OKL_CRTRN_LNSTYLS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_CRTRN_LNSTYLS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := okl_api.G_MISS_NUM,
28: creation_date OKL_CRTRN_LNSTYLS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
21: attribute10 OKL_CRTRN_LNSTYLS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_CRTRN_LNSTYLS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_CRTRN_LNSTYLS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
24: attribute13 OKL_CRTRN_LNSTYLS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
25: attribute14 OKL_CRTRN_LNSTYLS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_CRTRN_LNSTYLS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := okl_api.G_MISS_NUM,
28: creation_date OKL_CRTRN_LNSTYLS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
22: attribute11 OKL_CRTRN_LNSTYLS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_CRTRN_LNSTYLS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
24: attribute13 OKL_CRTRN_LNSTYLS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
25: attribute14 OKL_CRTRN_LNSTYLS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_CRTRN_LNSTYLS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := okl_api.G_MISS_NUM,
28: creation_date OKL_CRTRN_LNSTYLS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
30: last_update_date OKL_CRTRN_LNSTYLS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
23: attribute12 OKL_CRTRN_LNSTYLS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
24: attribute13 OKL_CRTRN_LNSTYLS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
25: attribute14 OKL_CRTRN_LNSTYLS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_CRTRN_LNSTYLS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := okl_api.G_MISS_NUM,
28: creation_date OKL_CRTRN_LNSTYLS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
30: last_update_date OKL_CRTRN_LNSTYLS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
31: last_update_login NUMBER := okl_api.G_MISS_NUM);
24: attribute13 OKL_CRTRN_LNSTYLS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
25: attribute14 OKL_CRTRN_LNSTYLS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_CRTRN_LNSTYLS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := okl_api.G_MISS_NUM,
28: creation_date OKL_CRTRN_LNSTYLS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
30: last_update_date OKL_CRTRN_LNSTYLS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
31: last_update_login NUMBER := okl_api.G_MISS_NUM);
32: g_miss_cls_rec cls_rec_type;
25: attribute14 OKL_CRTRN_LNSTYLS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_CRTRN_LNSTYLS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := okl_api.G_MISS_NUM,
28: creation_date OKL_CRTRN_LNSTYLS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
30: last_update_date OKL_CRTRN_LNSTYLS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
31: last_update_login NUMBER := okl_api.G_MISS_NUM);
32: g_miss_cls_rec cls_rec_type;
33: TYPE cls_tbl_type IS TABLE OF cls_rec_type
26: attribute15 OKL_CRTRN_LNSTYLS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := okl_api.G_MISS_NUM,
28: creation_date OKL_CRTRN_LNSTYLS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
30: last_update_date OKL_CRTRN_LNSTYLS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
31: last_update_login NUMBER := okl_api.G_MISS_NUM);
32: g_miss_cls_rec cls_rec_type;
33: TYPE cls_tbl_type IS TABLE OF cls_rec_type
34: INDEX BY BINARY_INTEGER;
27: created_by NUMBER := okl_api.G_MISS_NUM,
28: creation_date OKL_CRTRN_LNSTYLS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
30: last_update_date OKL_CRTRN_LNSTYLS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
31: last_update_login NUMBER := okl_api.G_MISS_NUM);
32: g_miss_cls_rec cls_rec_type;
33: TYPE cls_tbl_type IS TABLE OF cls_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE clsv_rec_type IS RECORD (
32: g_miss_cls_rec cls_rec_type;
33: TYPE cls_tbl_type IS TABLE OF cls_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE clsv_rec_type IS RECORD (
36: id NUMBER := okl_api.G_MISS_NUM,
37: object_version_number NUMBER := okl_api.G_MISS_NUM,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: lse_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_CRTRN_LNSTYLS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
33: TYPE cls_tbl_type IS TABLE OF cls_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE clsv_rec_type IS RECORD (
36: id NUMBER := okl_api.G_MISS_NUM,
37: object_version_number NUMBER := okl_api.G_MISS_NUM,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: lse_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_CRTRN_LNSTYLS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
34: INDEX BY BINARY_INTEGER;
35: TYPE clsv_rec_type IS RECORD (
36: id NUMBER := okl_api.G_MISS_NUM,
37: object_version_number NUMBER := okl_api.G_MISS_NUM,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: lse_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_CRTRN_LNSTYLS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
35: TYPE clsv_rec_type IS RECORD (
36: id NUMBER := okl_api.G_MISS_NUM,
37: object_version_number NUMBER := okl_api.G_MISS_NUM,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: lse_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_CRTRN_LNSTYLS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
36: id NUMBER := okl_api.G_MISS_NUM,
37: object_version_number NUMBER := okl_api.G_MISS_NUM,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: lse_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_CRTRN_LNSTYLS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
37: object_version_number NUMBER := okl_api.G_MISS_NUM,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: lse_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_CRTRN_LNSTYLS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: lse_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_CRTRN_LNSTYLS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
39: lse_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_CRTRN_LNSTYLS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
40: attribute_category OKL_CRTRN_LNSTYLS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := okl_api.G_MISS_NUM,
49: attribute9 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := okl_api.G_MISS_NUM,
57: creation_date OKL_CRTRN_LNSTYLS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
50: attribute10 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := okl_api.G_MISS_NUM,
57: creation_date OKL_CRTRN_LNSTYLS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
51: attribute11 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := okl_api.G_MISS_NUM,
57: creation_date OKL_CRTRN_LNSTYLS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
59: last_update_date OKL_CRTRN_LNSTYLS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
52: attribute12 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := okl_api.G_MISS_NUM,
57: creation_date OKL_CRTRN_LNSTYLS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
59: last_update_date OKL_CRTRN_LNSTYLS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_update_login NUMBER := okl_api.G_MISS_NUM);
53: attribute13 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := okl_api.G_MISS_NUM,
57: creation_date OKL_CRTRN_LNSTYLS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
59: last_update_date OKL_CRTRN_LNSTYLS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_update_login NUMBER := okl_api.G_MISS_NUM);
61: g_miss_clsv_rec clsv_rec_type;
54: attribute14 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := okl_api.G_MISS_NUM,
57: creation_date OKL_CRTRN_LNSTYLS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
59: last_update_date OKL_CRTRN_LNSTYLS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_update_login NUMBER := okl_api.G_MISS_NUM);
61: g_miss_clsv_rec clsv_rec_type;
62: TYPE clsv_tbl_type IS TABLE OF clsv_rec_type
55: attribute15 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := okl_api.G_MISS_NUM,
57: creation_date OKL_CRTRN_LNSTYLS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
59: last_update_date OKL_CRTRN_LNSTYLS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_update_login NUMBER := okl_api.G_MISS_NUM);
61: g_miss_clsv_rec clsv_rec_type;
62: TYPE clsv_tbl_type IS TABLE OF clsv_rec_type
63: INDEX BY BINARY_INTEGER;
56: created_by NUMBER := okl_api.G_MISS_NUM,
57: creation_date OKL_CRTRN_LNSTYLS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
59: last_update_date OKL_CRTRN_LNSTYLS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_update_login NUMBER := okl_api.G_MISS_NUM);
61: g_miss_clsv_rec clsv_rec_type;
62: TYPE clsv_tbl_type IS TABLE OF clsv_rec_type
63: INDEX BY BINARY_INTEGER;
64: ---------------------------------------------------------------------------
63: INDEX BY BINARY_INTEGER;
64: ---------------------------------------------------------------------------
65: -- GLOBAL MESSAGE CONSTANTS
66: ---------------------------------------------------------------------------
67: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
64: ---------------------------------------------------------------------------
65: -- GLOBAL MESSAGE CONSTANTS
66: ---------------------------------------------------------------------------
67: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
65: -- GLOBAL MESSAGE CONSTANTS
66: ---------------------------------------------------------------------------
67: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
66: ---------------------------------------------------------------------------
67: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
67: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
77: ---------------------------------------------------------------------------
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
77: ---------------------------------------------------------------------------
78: -- GLOBAL VARIABLES
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
77: ---------------------------------------------------------------------------
78: -- GLOBAL VARIABLES
79: ---------------------------------------------------------------------------
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
77: ---------------------------------------------------------------------------
78: -- GLOBAL VARIABLES
79: ---------------------------------------------------------------------------
80: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CLS_PVT';
77: ---------------------------------------------------------------------------
78: -- GLOBAL VARIABLES
79: ---------------------------------------------------------------------------
80: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CLS_PVT';
81: G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
82:
83: /******************ADDED AFTER TAPI, (05/23/2001) ****************/
84: --GLOBAL MESSAGES
85: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
103: PROCEDURE change_version;
104: PROCEDURE api_copy;
105: PROCEDURE insert_row(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_clsv_rec IN clsv_rec_type,
112: x_clsv_rec OUT NOCOPY clsv_rec_type);
113:
114: PROCEDURE insert_row(
115: p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_clsv_tbl IN clsv_tbl_type,
121: x_clsv_tbl OUT NOCOPY clsv_tbl_type);
122:
123: PROCEDURE lock_row(
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_clsv_rec IN clsv_rec_type);
129: p_clsv_rec IN clsv_rec_type);
130:
131: PROCEDURE lock_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_clsv_tbl IN clsv_tbl_type);
137: p_clsv_tbl IN clsv_tbl_type);
138:
139: PROCEDURE update_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_clsv_rec IN clsv_rec_type,
146: x_clsv_rec OUT NOCOPY clsv_rec_type);
147:
148: PROCEDURE update_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_clsv_tbl IN clsv_tbl_type,
155: x_clsv_tbl OUT NOCOPY clsv_tbl_type);
156:
157: PROCEDURE delete_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_clsv_rec IN clsv_rec_type);
163: p_clsv_rec IN clsv_rec_type);
164:
165: PROCEDURE delete_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_clsv_tbl IN clsv_tbl_type);
171: p_clsv_tbl IN clsv_tbl_type);
172:
173: PROCEDURE validate_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_clsv_rec IN clsv_rec_type);
179: p_clsv_rec IN clsv_rec_type);
180:
181: PROCEDURE validate_row(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_clsv_tbl IN clsv_tbl_type);