3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE clg_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: org_id NUMBER := Okc_Api.G_MISS_NUM,
9: currency_code OKL_CNTR_LVLNG_GRPS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: inf_id NUMBER := Okc_Api.G_MISS_NUM,
11: ica_id NUMBER := Okc_Api.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE clg_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: org_id NUMBER := Okc_Api.G_MISS_NUM,
9: currency_code OKL_CNTR_LVLNG_GRPS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: inf_id NUMBER := Okc_Api.G_MISS_NUM,
11: ica_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE clg_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: org_id NUMBER := Okc_Api.G_MISS_NUM,
9: currency_code OKL_CNTR_LVLNG_GRPS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: inf_id NUMBER := Okc_Api.G_MISS_NUM,
11: ica_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: irm_id NUMBER := Okc_Api.G_MISS_NUM,
6: TYPE clg_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: org_id NUMBER := Okc_Api.G_MISS_NUM,
9: currency_code OKL_CNTR_LVLNG_GRPS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: inf_id NUMBER := Okc_Api.G_MISS_NUM,
11: ica_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: irm_id NUMBER := Okc_Api.G_MISS_NUM,
14: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: org_id NUMBER := Okc_Api.G_MISS_NUM,
9: currency_code OKL_CNTR_LVLNG_GRPS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: inf_id NUMBER := Okc_Api.G_MISS_NUM,
11: ica_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: irm_id NUMBER := Okc_Api.G_MISS_NUM,
14: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
8: org_id NUMBER := Okc_Api.G_MISS_NUM,
9: currency_code OKL_CNTR_LVLNG_GRPS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: inf_id NUMBER := Okc_Api.G_MISS_NUM,
11: ica_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: irm_id NUMBER := Okc_Api.G_MISS_NUM,
14: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: attribute_category OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
9: currency_code OKL_CNTR_LVLNG_GRPS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: inf_id NUMBER := Okc_Api.G_MISS_NUM,
11: ica_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: irm_id NUMBER := Okc_Api.G_MISS_NUM,
14: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: attribute_category OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
17: attribute1 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
10: inf_id NUMBER := Okc_Api.G_MISS_NUM,
11: ica_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: irm_id NUMBER := Okc_Api.G_MISS_NUM,
14: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: attribute_category OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
17: attribute1 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
18: attribute2 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
11: ica_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: irm_id NUMBER := Okc_Api.G_MISS_NUM,
14: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: attribute_category OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
17: attribute1 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
18: attribute2 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute3 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: irm_id NUMBER := Okc_Api.G_MISS_NUM,
14: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: attribute_category OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
17: attribute1 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
18: attribute2 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute3 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute4 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
13: irm_id NUMBER := Okc_Api.G_MISS_NUM,
14: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: attribute_category OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
17: attribute1 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
18: attribute2 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute3 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute4 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute5 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
14: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: attribute_category OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
17: attribute1 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
18: attribute2 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute3 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute4 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute5 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute6 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: attribute_category OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
17: attribute1 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
18: attribute2 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute3 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute4 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute5 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute6 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute7 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
16: attribute_category OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
17: attribute1 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
18: attribute2 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute3 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute4 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute5 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute6 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute7 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute8 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
17: attribute1 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
18: attribute2 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute3 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute4 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute5 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute6 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute7 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute8 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute9 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
18: attribute2 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute3 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute4 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute5 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute6 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute7 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute8 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute9 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute10 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute3 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute4 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute5 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute6 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute7 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute8 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute9 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute10 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute11 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute4 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute5 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute6 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute7 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute8 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute9 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute10 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute11 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute12 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute5 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute6 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute7 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute8 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute9 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute10 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute11 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute12 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute13 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute6 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute7 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute8 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute9 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute10 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute11 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute12 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute13 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute14 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute7 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute8 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute9 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute10 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute11 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute12 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute13 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute14 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute15 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute8 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute9 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute10 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute11 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute12 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute13 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute14 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute15 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
32: created_by NUMBER := Okc_Api.G_MISS_NUM,
25: attribute9 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute10 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute11 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute12 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute13 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute14 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute15 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
32: created_by NUMBER := Okc_Api.G_MISS_NUM,
33: creation_date OKL_CNTR_LVLNG_GRPS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
26: attribute10 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute11 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute12 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute13 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute14 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute15 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
32: created_by NUMBER := Okc_Api.G_MISS_NUM,
33: creation_date OKL_CNTR_LVLNG_GRPS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
27: attribute11 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute12 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute13 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute14 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute15 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
32: created_by NUMBER := Okc_Api.G_MISS_NUM,
33: creation_date OKL_CNTR_LVLNG_GRPS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
35: last_update_date OKL_CNTR_LVLNG_GRPS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
28: attribute12 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute13 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute14 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute15 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
32: created_by NUMBER := Okc_Api.G_MISS_NUM,
33: creation_date OKL_CNTR_LVLNG_GRPS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
35: last_update_date OKL_CNTR_LVLNG_GRPS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
29: attribute13 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute14 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute15 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
32: created_by NUMBER := Okc_Api.G_MISS_NUM,
33: creation_date OKL_CNTR_LVLNG_GRPS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
35: last_update_date OKL_CNTR_LVLNG_GRPS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
37: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
30: attribute14 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute15 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
32: created_by NUMBER := Okc_Api.G_MISS_NUM,
33: creation_date OKL_CNTR_LVLNG_GRPS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
35: last_update_date OKL_CNTR_LVLNG_GRPS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
37: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
38: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
31: attribute15 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
32: created_by NUMBER := Okc_Api.G_MISS_NUM,
33: creation_date OKL_CNTR_LVLNG_GRPS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
35: last_update_date OKL_CNTR_LVLNG_GRPS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
37: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
38: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
39: ipl_id NUMBER := Okc_Api.G_MISS_NUM,
32: created_by NUMBER := Okc_Api.G_MISS_NUM,
33: creation_date OKL_CNTR_LVLNG_GRPS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
35: last_update_date OKL_CNTR_LVLNG_GRPS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
37: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
38: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
39: ipl_id NUMBER := Okc_Api.G_MISS_NUM,
40: legal_entity_id OKL_CNTR_LVLNG_GRPS_B.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
33: creation_date OKL_CNTR_LVLNG_GRPS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
35: last_update_date OKL_CNTR_LVLNG_GRPS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
37: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
38: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
39: ipl_id NUMBER := Okc_Api.G_MISS_NUM,
40: legal_entity_id OKL_CNTR_LVLNG_GRPS_B.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
41: g_miss_clg_rec clg_rec_type;
34: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
35: last_update_date OKL_CNTR_LVLNG_GRPS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
37: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
38: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
39: ipl_id NUMBER := Okc_Api.G_MISS_NUM,
40: legal_entity_id OKL_CNTR_LVLNG_GRPS_B.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
41: g_miss_clg_rec clg_rec_type;
42: TYPE clg_tbl_type IS TABLE OF clg_rec_type
35: last_update_date OKL_CNTR_LVLNG_GRPS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
37: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
38: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
39: ipl_id NUMBER := Okc_Api.G_MISS_NUM,
40: legal_entity_id OKL_CNTR_LVLNG_GRPS_B.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
41: g_miss_clg_rec clg_rec_type;
42: TYPE clg_tbl_type IS TABLE OF clg_rec_type
43: INDEX BY BINARY_INTEGER;
36: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
37: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
38: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
39: ipl_id NUMBER := Okc_Api.G_MISS_NUM,
40: legal_entity_id OKL_CNTR_LVLNG_GRPS_B.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
41: g_miss_clg_rec clg_rec_type;
42: TYPE clg_tbl_type IS TABLE OF clg_rec_type
43: INDEX BY BINARY_INTEGER;
44: TYPE OklCntrLvlngGrpsTlRecType IS RECORD (
41: g_miss_clg_rec clg_rec_type;
42: TYPE clg_tbl_type IS TABLE OF clg_rec_type
43: INDEX BY BINARY_INTEGER;
44: TYPE OklCntrLvlngGrpsTlRecType IS RECORD (
45: id NUMBER := Okc_Api.G_MISS_NUM,
46: LANGUAGE OKL_CNTR_LVLNG_GRPS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
47: source_lang OKL_CNTR_LVLNG_GRPS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
48: sfwt_flag OKL_CNTR_LVLNG_GRPS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
49: name OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okc_Api.G_MISS_CHAR,
42: TYPE clg_tbl_type IS TABLE OF clg_rec_type
43: INDEX BY BINARY_INTEGER;
44: TYPE OklCntrLvlngGrpsTlRecType IS RECORD (
45: id NUMBER := Okc_Api.G_MISS_NUM,
46: LANGUAGE OKL_CNTR_LVLNG_GRPS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
47: source_lang OKL_CNTR_LVLNG_GRPS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
48: sfwt_flag OKL_CNTR_LVLNG_GRPS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
49: name OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okc_Api.G_MISS_CHAR,
50: description OKL_CNTR_LVLNG_GRPS_TL.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
43: INDEX BY BINARY_INTEGER;
44: TYPE OklCntrLvlngGrpsTlRecType IS RECORD (
45: id NUMBER := Okc_Api.G_MISS_NUM,
46: LANGUAGE OKL_CNTR_LVLNG_GRPS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
47: source_lang OKL_CNTR_LVLNG_GRPS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
48: sfwt_flag OKL_CNTR_LVLNG_GRPS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
49: name OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okc_Api.G_MISS_CHAR,
50: description OKL_CNTR_LVLNG_GRPS_TL.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
51: private_label_logo_url OKL_CNTR_LVLNG_GRPS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
44: TYPE OklCntrLvlngGrpsTlRecType IS RECORD (
45: id NUMBER := Okc_Api.G_MISS_NUM,
46: LANGUAGE OKL_CNTR_LVLNG_GRPS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
47: source_lang OKL_CNTR_LVLNG_GRPS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
48: sfwt_flag OKL_CNTR_LVLNG_GRPS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
49: name OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okc_Api.G_MISS_CHAR,
50: description OKL_CNTR_LVLNG_GRPS_TL.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
51: private_label_logo_url OKL_CNTR_LVLNG_GRPS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
52: created_by NUMBER := Okc_Api.G_MISS_NUM,
45: id NUMBER := Okc_Api.G_MISS_NUM,
46: LANGUAGE OKL_CNTR_LVLNG_GRPS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
47: source_lang OKL_CNTR_LVLNG_GRPS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
48: sfwt_flag OKL_CNTR_LVLNG_GRPS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
49: name OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okc_Api.G_MISS_CHAR,
50: description OKL_CNTR_LVLNG_GRPS_TL.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
51: private_label_logo_url OKL_CNTR_LVLNG_GRPS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
52: created_by NUMBER := Okc_Api.G_MISS_NUM,
53: creation_date OKL_CNTR_LVLNG_GRPS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: LANGUAGE OKL_CNTR_LVLNG_GRPS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
47: source_lang OKL_CNTR_LVLNG_GRPS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
48: sfwt_flag OKL_CNTR_LVLNG_GRPS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
49: name OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okc_Api.G_MISS_CHAR,
50: description OKL_CNTR_LVLNG_GRPS_TL.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
51: private_label_logo_url OKL_CNTR_LVLNG_GRPS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
52: created_by NUMBER := Okc_Api.G_MISS_NUM,
53: creation_date OKL_CNTR_LVLNG_GRPS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
54: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
47: source_lang OKL_CNTR_LVLNG_GRPS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
48: sfwt_flag OKL_CNTR_LVLNG_GRPS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
49: name OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okc_Api.G_MISS_CHAR,
50: description OKL_CNTR_LVLNG_GRPS_TL.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
51: private_label_logo_url OKL_CNTR_LVLNG_GRPS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
52: created_by NUMBER := Okc_Api.G_MISS_NUM,
53: creation_date OKL_CNTR_LVLNG_GRPS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
54: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
55: last_update_date OKL_CNTR_LVLNG_GRPS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
48: sfwt_flag OKL_CNTR_LVLNG_GRPS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
49: name OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okc_Api.G_MISS_CHAR,
50: description OKL_CNTR_LVLNG_GRPS_TL.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
51: private_label_logo_url OKL_CNTR_LVLNG_GRPS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
52: created_by NUMBER := Okc_Api.G_MISS_NUM,
53: creation_date OKL_CNTR_LVLNG_GRPS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
54: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
55: last_update_date OKL_CNTR_LVLNG_GRPS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
56: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
49: name OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okc_Api.G_MISS_CHAR,
50: description OKL_CNTR_LVLNG_GRPS_TL.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
51: private_label_logo_url OKL_CNTR_LVLNG_GRPS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
52: created_by NUMBER := Okc_Api.G_MISS_NUM,
53: creation_date OKL_CNTR_LVLNG_GRPS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
54: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
55: last_update_date OKL_CNTR_LVLNG_GRPS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
56: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
57: GMissOklCntrLvlngGrpsTlRec OklCntrLvlngGrpsTlRecType;
50: description OKL_CNTR_LVLNG_GRPS_TL.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
51: private_label_logo_url OKL_CNTR_LVLNG_GRPS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
52: created_by NUMBER := Okc_Api.G_MISS_NUM,
53: creation_date OKL_CNTR_LVLNG_GRPS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
54: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
55: last_update_date OKL_CNTR_LVLNG_GRPS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
56: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
57: GMissOklCntrLvlngGrpsTlRec OklCntrLvlngGrpsTlRecType;
58: TYPE OklCntrLvlngGrpsTlTblType IS TABLE OF OklCntrLvlngGrpsTlRecType
51: private_label_logo_url OKL_CNTR_LVLNG_GRPS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
52: created_by NUMBER := Okc_Api.G_MISS_NUM,
53: creation_date OKL_CNTR_LVLNG_GRPS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
54: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
55: last_update_date OKL_CNTR_LVLNG_GRPS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
56: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
57: GMissOklCntrLvlngGrpsTlRec OklCntrLvlngGrpsTlRecType;
58: TYPE OklCntrLvlngGrpsTlTblType IS TABLE OF OklCntrLvlngGrpsTlRecType
59: INDEX BY BINARY_INTEGER;
52: created_by NUMBER := Okc_Api.G_MISS_NUM,
53: creation_date OKL_CNTR_LVLNG_GRPS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
54: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
55: last_update_date OKL_CNTR_LVLNG_GRPS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
56: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
57: GMissOklCntrLvlngGrpsTlRec OklCntrLvlngGrpsTlRecType;
58: TYPE OklCntrLvlngGrpsTlTblType IS TABLE OF OklCntrLvlngGrpsTlRecType
59: INDEX BY BINARY_INTEGER;
60: TYPE clgv_rec_type IS RECORD (
57: GMissOklCntrLvlngGrpsTlRec OklCntrLvlngGrpsTlRecType;
58: TYPE OklCntrLvlngGrpsTlTblType IS TABLE OF OklCntrLvlngGrpsTlRecType
59: INDEX BY BINARY_INTEGER;
60: TYPE clgv_rec_type IS RECORD (
61: id NUMBER := Okc_Api.G_MISS_NUM,
62: org_id NUMBER := Okc_Api.G_MISS_NUM,
63: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
64: sfwt_flag OKL_CNTR_LVLNG_GRPS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
65: inf_id NUMBER := Okc_Api.G_MISS_NUM,
58: TYPE OklCntrLvlngGrpsTlTblType IS TABLE OF OklCntrLvlngGrpsTlRecType
59: INDEX BY BINARY_INTEGER;
60: TYPE clgv_rec_type IS RECORD (
61: id NUMBER := Okc_Api.G_MISS_NUM,
62: org_id NUMBER := Okc_Api.G_MISS_NUM,
63: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
64: sfwt_flag OKL_CNTR_LVLNG_GRPS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
65: inf_id NUMBER := Okc_Api.G_MISS_NUM,
66: ica_id NUMBER := Okc_Api.G_MISS_NUM,
59: INDEX BY BINARY_INTEGER;
60: TYPE clgv_rec_type IS RECORD (
61: id NUMBER := Okc_Api.G_MISS_NUM,
62: org_id NUMBER := Okc_Api.G_MISS_NUM,
63: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
64: sfwt_flag OKL_CNTR_LVLNG_GRPS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
65: inf_id NUMBER := Okc_Api.G_MISS_NUM,
66: ica_id NUMBER := Okc_Api.G_MISS_NUM,
67: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
60: TYPE clgv_rec_type IS RECORD (
61: id NUMBER := Okc_Api.G_MISS_NUM,
62: org_id NUMBER := Okc_Api.G_MISS_NUM,
63: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
64: sfwt_flag OKL_CNTR_LVLNG_GRPS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
65: inf_id NUMBER := Okc_Api.G_MISS_NUM,
66: ica_id NUMBER := Okc_Api.G_MISS_NUM,
67: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
68: currency_code OKL_CNTR_LVLNG_GRPS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
61: id NUMBER := Okc_Api.G_MISS_NUM,
62: org_id NUMBER := Okc_Api.G_MISS_NUM,
63: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
64: sfwt_flag OKL_CNTR_LVLNG_GRPS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
65: inf_id NUMBER := Okc_Api.G_MISS_NUM,
66: ica_id NUMBER := Okc_Api.G_MISS_NUM,
67: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
68: currency_code OKL_CNTR_LVLNG_GRPS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
69: irm_id NUMBER := Okc_Api.G_MISS_NUM,
62: org_id NUMBER := Okc_Api.G_MISS_NUM,
63: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
64: sfwt_flag OKL_CNTR_LVLNG_GRPS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
65: inf_id NUMBER := Okc_Api.G_MISS_NUM,
66: ica_id NUMBER := Okc_Api.G_MISS_NUM,
67: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
68: currency_code OKL_CNTR_LVLNG_GRPS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
69: irm_id NUMBER := Okc_Api.G_MISS_NUM,
70: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
63: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
64: sfwt_flag OKL_CNTR_LVLNG_GRPS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
65: inf_id NUMBER := Okc_Api.G_MISS_NUM,
66: ica_id NUMBER := Okc_Api.G_MISS_NUM,
67: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
68: currency_code OKL_CNTR_LVLNG_GRPS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
69: irm_id NUMBER := Okc_Api.G_MISS_NUM,
70: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
71: name OKL_CNTR_LVLNG_GRPS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
64: sfwt_flag OKL_CNTR_LVLNG_GRPS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
65: inf_id NUMBER := Okc_Api.G_MISS_NUM,
66: ica_id NUMBER := Okc_Api.G_MISS_NUM,
67: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
68: currency_code OKL_CNTR_LVLNG_GRPS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
69: irm_id NUMBER := Okc_Api.G_MISS_NUM,
70: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
71: name OKL_CNTR_LVLNG_GRPS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
72: description OKL_CNTR_LVLNG_GRPS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
65: inf_id NUMBER := Okc_Api.G_MISS_NUM,
66: ica_id NUMBER := Okc_Api.G_MISS_NUM,
67: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
68: currency_code OKL_CNTR_LVLNG_GRPS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
69: irm_id NUMBER := Okc_Api.G_MISS_NUM,
70: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
71: name OKL_CNTR_LVLNG_GRPS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
72: description OKL_CNTR_LVLNG_GRPS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
73: private_label_logo_url OKL_CNTR_LVLNG_GRPS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
66: ica_id NUMBER := Okc_Api.G_MISS_NUM,
67: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
68: currency_code OKL_CNTR_LVLNG_GRPS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
69: irm_id NUMBER := Okc_Api.G_MISS_NUM,
70: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
71: name OKL_CNTR_LVLNG_GRPS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
72: description OKL_CNTR_LVLNG_GRPS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
73: private_label_logo_url OKL_CNTR_LVLNG_GRPS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
74: attribute_category OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
67: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
68: currency_code OKL_CNTR_LVLNG_GRPS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
69: irm_id NUMBER := Okc_Api.G_MISS_NUM,
70: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
71: name OKL_CNTR_LVLNG_GRPS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
72: description OKL_CNTR_LVLNG_GRPS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
73: private_label_logo_url OKL_CNTR_LVLNG_GRPS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
74: attribute_category OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
75: attribute1 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
68: currency_code OKL_CNTR_LVLNG_GRPS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
69: irm_id NUMBER := Okc_Api.G_MISS_NUM,
70: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
71: name OKL_CNTR_LVLNG_GRPS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
72: description OKL_CNTR_LVLNG_GRPS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
73: private_label_logo_url OKL_CNTR_LVLNG_GRPS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
74: attribute_category OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
75: attribute1 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
76: attribute2 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
69: irm_id NUMBER := Okc_Api.G_MISS_NUM,
70: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
71: name OKL_CNTR_LVLNG_GRPS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
72: description OKL_CNTR_LVLNG_GRPS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
73: private_label_logo_url OKL_CNTR_LVLNG_GRPS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
74: attribute_category OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
75: attribute1 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
76: attribute2 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
77: attribute3 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
70: iuv_id NUMBER := Okc_Api.G_MISS_NUM,
71: name OKL_CNTR_LVLNG_GRPS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
72: description OKL_CNTR_LVLNG_GRPS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
73: private_label_logo_url OKL_CNTR_LVLNG_GRPS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
74: attribute_category OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
75: attribute1 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
76: attribute2 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
77: attribute3 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
78: attribute4 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
71: name OKL_CNTR_LVLNG_GRPS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
72: description OKL_CNTR_LVLNG_GRPS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
73: private_label_logo_url OKL_CNTR_LVLNG_GRPS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
74: attribute_category OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
75: attribute1 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
76: attribute2 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
77: attribute3 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
78: attribute4 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
79: attribute5 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
72: description OKL_CNTR_LVLNG_GRPS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
73: private_label_logo_url OKL_CNTR_LVLNG_GRPS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
74: attribute_category OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
75: attribute1 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
76: attribute2 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
77: attribute3 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
78: attribute4 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
79: attribute5 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
80: attribute6 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
73: private_label_logo_url OKL_CNTR_LVLNG_GRPS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
74: attribute_category OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
75: attribute1 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
76: attribute2 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
77: attribute3 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
78: attribute4 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
79: attribute5 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
80: attribute6 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
81: attribute7 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
74: attribute_category OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
75: attribute1 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
76: attribute2 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
77: attribute3 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
78: attribute4 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
79: attribute5 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
80: attribute6 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
81: attribute7 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
82: attribute8 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
75: attribute1 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
76: attribute2 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
77: attribute3 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
78: attribute4 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
79: attribute5 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
80: attribute6 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
81: attribute7 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
82: attribute8 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute9 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
76: attribute2 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
77: attribute3 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
78: attribute4 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
79: attribute5 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
80: attribute6 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
81: attribute7 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
82: attribute8 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute9 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute10 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
77: attribute3 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
78: attribute4 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
79: attribute5 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
80: attribute6 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
81: attribute7 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
82: attribute8 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute9 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute10 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute11 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
78: attribute4 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
79: attribute5 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
80: attribute6 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
81: attribute7 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
82: attribute8 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute9 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute10 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute11 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute12 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
79: attribute5 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
80: attribute6 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
81: attribute7 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
82: attribute8 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute9 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute10 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute11 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute12 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute13 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
80: attribute6 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
81: attribute7 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
82: attribute8 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute9 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute10 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute11 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute12 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute13 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute14 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
81: attribute7 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
82: attribute8 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute9 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute10 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute11 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute12 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute13 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute14 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute15 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
82: attribute8 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute9 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute10 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute11 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute12 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute13 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute14 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute15 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
90: created_by NUMBER := Okc_Api.G_MISS_NUM,
83: attribute9 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute10 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute11 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute12 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute13 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute14 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute15 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
90: created_by NUMBER := Okc_Api.G_MISS_NUM,
91: creation_date OKL_CNTR_LVLNG_GRPS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
84: attribute10 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute11 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute12 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute13 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute14 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute15 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
90: created_by NUMBER := Okc_Api.G_MISS_NUM,
91: creation_date OKL_CNTR_LVLNG_GRPS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
92: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
85: attribute11 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute12 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute13 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute14 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute15 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
90: created_by NUMBER := Okc_Api.G_MISS_NUM,
91: creation_date OKL_CNTR_LVLNG_GRPS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
92: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
93: last_update_date OKL_CNTR_LVLNG_GRPS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
86: attribute12 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute13 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute14 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute15 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
90: created_by NUMBER := Okc_Api.G_MISS_NUM,
91: creation_date OKL_CNTR_LVLNG_GRPS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
92: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
93: last_update_date OKL_CNTR_LVLNG_GRPS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
94: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
87: attribute13 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute14 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute15 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
90: created_by NUMBER := Okc_Api.G_MISS_NUM,
91: creation_date OKL_CNTR_LVLNG_GRPS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
92: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
93: last_update_date OKL_CNTR_LVLNG_GRPS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
94: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
95: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
88: attribute14 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute15 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
90: created_by NUMBER := Okc_Api.G_MISS_NUM,
91: creation_date OKL_CNTR_LVLNG_GRPS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
92: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
93: last_update_date OKL_CNTR_LVLNG_GRPS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
94: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
95: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
96: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
89: attribute15 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
90: created_by NUMBER := Okc_Api.G_MISS_NUM,
91: creation_date OKL_CNTR_LVLNG_GRPS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
92: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
93: last_update_date OKL_CNTR_LVLNG_GRPS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
94: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
95: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
96: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
97: ipl_id NUMBER := Okc_Api.G_MISS_NUM,
90: created_by NUMBER := Okc_Api.G_MISS_NUM,
91: creation_date OKL_CNTR_LVLNG_GRPS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
92: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
93: last_update_date OKL_CNTR_LVLNG_GRPS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
94: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
95: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
96: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
97: ipl_id NUMBER := Okc_Api.G_MISS_NUM,
98: legal_entity_id OKL_CNTR_LVLNG_GRPS_V.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
91: creation_date OKL_CNTR_LVLNG_GRPS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
92: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
93: last_update_date OKL_CNTR_LVLNG_GRPS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
94: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
95: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
96: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
97: ipl_id NUMBER := Okc_Api.G_MISS_NUM,
98: legal_entity_id OKL_CNTR_LVLNG_GRPS_V.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
99: g_miss_clgv_rec clgv_rec_type;
92: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
93: last_update_date OKL_CNTR_LVLNG_GRPS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
94: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
95: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
96: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
97: ipl_id NUMBER := Okc_Api.G_MISS_NUM,
98: legal_entity_id OKL_CNTR_LVLNG_GRPS_V.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
99: g_miss_clgv_rec clgv_rec_type;
100: TYPE clgv_tbl_type IS TABLE OF clgv_rec_type
93: last_update_date OKL_CNTR_LVLNG_GRPS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
94: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
95: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
96: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
97: ipl_id NUMBER := Okc_Api.G_MISS_NUM,
98: legal_entity_id OKL_CNTR_LVLNG_GRPS_V.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
99: g_miss_clgv_rec clgv_rec_type;
100: TYPE clgv_tbl_type IS TABLE OF clgv_rec_type
101: INDEX BY BINARY_INTEGER;
94: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
95: effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
96: effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
97: ipl_id NUMBER := Okc_Api.G_MISS_NUM,
98: legal_entity_id OKL_CNTR_LVLNG_GRPS_V.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
99: g_miss_clgv_rec clgv_rec_type;
100: TYPE clgv_tbl_type IS TABLE OF clgv_rec_type
101: INDEX BY BINARY_INTEGER;
102: ---------------------------------------------------------------------------
101: INDEX BY BINARY_INTEGER;
102: ---------------------------------------------------------------------------
103: -- GLOBAL MESSAGE CONSTANTS
104: ---------------------------------------------------------------------------
105: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
106: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
102: ---------------------------------------------------------------------------
103: -- GLOBAL MESSAGE CONSTANTS
104: ---------------------------------------------------------------------------
105: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
106: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
103: -- GLOBAL MESSAGE CONSTANTS
104: ---------------------------------------------------------------------------
105: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
106: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
104: ---------------------------------------------------------------------------
105: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
106: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
105: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
106: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
113: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
106: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
113: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
114: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
113: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
114: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
115:
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
113: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
114: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
115:
116: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
113: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
114: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
115:
116: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
117: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
113: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
114: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
115:
116: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
117: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
118: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
138: PROCEDURE api_copy;
139: PROCEDURE add_language;
140: PROCEDURE insert_row(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_clgv_rec IN clgv_rec_type,
147: x_clgv_rec OUT NOCOPY clgv_rec_type);
148:
149: PROCEDURE insert_row(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_clgv_tbl IN clgv_tbl_type,
156: x_clgv_tbl OUT NOCOPY clgv_tbl_type);
157:
158: PROCEDURE lock_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT Okc_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_clgv_rec IN clgv_rec_type);
164: p_clgv_rec IN clgv_rec_type);
165:
166: PROCEDURE lock_row(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_clgv_tbl IN clgv_tbl_type);
172: p_clgv_tbl IN clgv_tbl_type);
173:
174: PROCEDURE update_row(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_clgv_rec IN clgv_rec_type,
181: x_clgv_rec OUT NOCOPY clgv_rec_type);
182:
183: PROCEDURE update_row(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT Okc_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_clgv_tbl IN clgv_tbl_type,
190: x_clgv_tbl OUT NOCOPY clgv_tbl_type);
191:
192: PROCEDURE delete_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT Okc_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_clgv_rec IN clgv_rec_type);
198: p_clgv_rec IN clgv_rec_type);
199:
200: PROCEDURE delete_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT Okc_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_clgv_tbl IN clgv_tbl_type);
206: p_clgv_tbl IN clgv_tbl_type);
207:
208: PROCEDURE validate_row(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_clgv_rec IN clgv_rec_type);
214: p_clgv_rec IN clgv_rec_type);
215:
216: PROCEDURE validate_row(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_clgv_tbl IN clgv_tbl_type);