2: /* $Header: OKLSCLLS.pls 115.2 2002/08/02 23:03:50 sanahuja noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_CNTR_LVLNG_LNS_V Record Spec
7: TYPE cllv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,kle_id NUMBER := OKC_API.G_MISS_NUM
10: ,clg_id NUMBER := OKC_API.G_MISS_NUM
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,kle_id NUMBER := OKC_API.G_MISS_NUM
10: ,clg_id NUMBER := OKC_API.G_MISS_NUM
11: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12: ,attribute_category OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
13: ,attribute1 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute2 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute3 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute4 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
9: ,kle_id NUMBER := OKC_API.G_MISS_NUM
10: ,clg_id NUMBER := OKC_API.G_MISS_NUM
11: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12: ,attribute_category OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
13: ,attribute1 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute2 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute3 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute4 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute5 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
10: ,clg_id NUMBER := OKC_API.G_MISS_NUM
11: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12: ,attribute_category OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
13: ,attribute1 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute2 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute3 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute4 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute5 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute6 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
11: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12: ,attribute_category OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
13: ,attribute1 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute2 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute3 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute4 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute5 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute6 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute7 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
12: ,attribute_category OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
13: ,attribute1 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute2 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute3 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute4 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute5 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute6 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute7 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute8 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
13: ,attribute1 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute2 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute3 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute4 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute5 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute6 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute7 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute8 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute9 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
14: ,attribute2 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute3 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute4 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute5 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute6 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute7 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute8 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute9 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute10 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute3 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute4 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute5 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute6 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute7 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute8 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute9 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute10 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute11 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute4 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute5 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute6 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute7 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute8 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute9 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute10 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute11 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute12 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute5 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute6 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute7 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute8 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute9 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute10 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute11 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute12 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute13 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute6 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute7 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute8 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute9 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute10 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute11 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute12 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute13 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute14 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute7 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute8 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute9 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute10 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute11 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute12 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute13 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute14 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute15 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute8 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute9 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute10 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute11 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute12 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute13 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute14 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute15 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
28: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,attribute9 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute10 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute11 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute12 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute13 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute14 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute15 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
28: ,created_by NUMBER := OKC_API.G_MISS_NUM
29: ,creation_date OKL_CNTR_LVLNG_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,attribute10 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute11 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute12 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute13 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute14 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute15 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
28: ,created_by NUMBER := OKC_API.G_MISS_NUM
29: ,creation_date OKL_CNTR_LVLNG_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,attribute11 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute12 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute13 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute14 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute15 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
28: ,created_by NUMBER := OKC_API.G_MISS_NUM
29: ,creation_date OKL_CNTR_LVLNG_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
31: ,last_update_date OKL_CNTR_LVLNG_LNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,attribute13 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute14 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute15 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
28: ,created_by NUMBER := OKC_API.G_MISS_NUM
29: ,creation_date OKL_CNTR_LVLNG_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
31: ,last_update_date OKL_CNTR_LVLNG_LNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
33: G_MISS_cllv_rec cllv_rec_type;
27: ,attribute15 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
28: ,created_by NUMBER := OKC_API.G_MISS_NUM
29: ,creation_date OKL_CNTR_LVLNG_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
31: ,last_update_date OKL_CNTR_LVLNG_LNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
33: G_MISS_cllv_rec cllv_rec_type;
34: TYPE cllv_tbl_type IS TABLE OF cllv_rec_type
35: INDEX BY BINARY_INTEGER;