4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_POOL_TYPES_V Record Spec
7: TYPE potv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,code OKL_POOL_TYPES_V.CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_POOL_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_POOL_TYPES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
5: ---------------------------------------------------------------------------
6: -- OKL_POOL_TYPES_V Record Spec
7: TYPE potv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,code OKL_POOL_TYPES_V.CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_POOL_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_POOL_TYPES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,from_date OKL_POOL_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
6: -- OKL_POOL_TYPES_V Record Spec
7: TYPE potv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,code OKL_POOL_TYPES_V.CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_POOL_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_POOL_TYPES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,from_date OKL_POOL_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,to_date OKL_POOL_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
7: TYPE potv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,code OKL_POOL_TYPES_V.CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_POOL_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_POOL_TYPES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,from_date OKL_POOL_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,to_date OKL_POOL_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,attribute_category OKL_POOL_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,code OKL_POOL_TYPES_V.CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_POOL_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_POOL_TYPES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,from_date OKL_POOL_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,to_date OKL_POOL_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,attribute_category OKL_POOL_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute1 OKL_POOL_TYPES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,code OKL_POOL_TYPES_V.CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_POOL_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_POOL_TYPES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,from_date OKL_POOL_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,to_date OKL_POOL_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,attribute_category OKL_POOL_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute1 OKL_POOL_TYPES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute2 OKL_POOL_TYPES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
10: ,code OKL_POOL_TYPES_V.CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_POOL_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_POOL_TYPES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,from_date OKL_POOL_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,to_date OKL_POOL_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,attribute_category OKL_POOL_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute1 OKL_POOL_TYPES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute2 OKL_POOL_TYPES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute3 OKL_POOL_TYPES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_POOL_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_POOL_TYPES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,from_date OKL_POOL_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,to_date OKL_POOL_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,attribute_category OKL_POOL_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute1 OKL_POOL_TYPES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute2 OKL_POOL_TYPES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute3 OKL_POOL_TYPES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute4 OKL_POOL_TYPES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_POOL_TYPES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,from_date OKL_POOL_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,to_date OKL_POOL_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,attribute_category OKL_POOL_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute1 OKL_POOL_TYPES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute2 OKL_POOL_TYPES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute3 OKL_POOL_TYPES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute4 OKL_POOL_TYPES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute5 OKL_POOL_TYPES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
13: ,from_date OKL_POOL_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,to_date OKL_POOL_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,attribute_category OKL_POOL_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute1 OKL_POOL_TYPES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute2 OKL_POOL_TYPES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute3 OKL_POOL_TYPES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute4 OKL_POOL_TYPES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute5 OKL_POOL_TYPES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute6 OKL_POOL_TYPES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
14: ,to_date OKL_POOL_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,attribute_category OKL_POOL_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute1 OKL_POOL_TYPES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute2 OKL_POOL_TYPES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute3 OKL_POOL_TYPES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute4 OKL_POOL_TYPES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute5 OKL_POOL_TYPES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute6 OKL_POOL_TYPES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute7 OKL_POOL_TYPES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
15: ,attribute_category OKL_POOL_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute1 OKL_POOL_TYPES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute2 OKL_POOL_TYPES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute3 OKL_POOL_TYPES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute4 OKL_POOL_TYPES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute5 OKL_POOL_TYPES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute6 OKL_POOL_TYPES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute7 OKL_POOL_TYPES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute8 OKL_POOL_TYPES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
16: ,attribute1 OKL_POOL_TYPES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute2 OKL_POOL_TYPES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute3 OKL_POOL_TYPES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute4 OKL_POOL_TYPES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute5 OKL_POOL_TYPES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute6 OKL_POOL_TYPES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute7 OKL_POOL_TYPES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute8 OKL_POOL_TYPES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute9 OKL_POOL_TYPES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute2 OKL_POOL_TYPES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute3 OKL_POOL_TYPES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute4 OKL_POOL_TYPES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute5 OKL_POOL_TYPES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute6 OKL_POOL_TYPES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute7 OKL_POOL_TYPES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute8 OKL_POOL_TYPES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute9 OKL_POOL_TYPES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute10 OKL_POOL_TYPES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute3 OKL_POOL_TYPES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute4 OKL_POOL_TYPES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute5 OKL_POOL_TYPES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute6 OKL_POOL_TYPES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute7 OKL_POOL_TYPES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute8 OKL_POOL_TYPES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute9 OKL_POOL_TYPES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute10 OKL_POOL_TYPES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute11 OKL_POOL_TYPES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute4 OKL_POOL_TYPES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute5 OKL_POOL_TYPES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute6 OKL_POOL_TYPES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute7 OKL_POOL_TYPES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute8 OKL_POOL_TYPES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute9 OKL_POOL_TYPES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute10 OKL_POOL_TYPES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute11 OKL_POOL_TYPES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute12 OKL_POOL_TYPES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute5 OKL_POOL_TYPES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute6 OKL_POOL_TYPES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute7 OKL_POOL_TYPES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute8 OKL_POOL_TYPES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute9 OKL_POOL_TYPES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute10 OKL_POOL_TYPES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute11 OKL_POOL_TYPES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute12 OKL_POOL_TYPES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute13 OKL_POOL_TYPES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute6 OKL_POOL_TYPES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute7 OKL_POOL_TYPES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute8 OKL_POOL_TYPES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute9 OKL_POOL_TYPES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute10 OKL_POOL_TYPES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute11 OKL_POOL_TYPES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute12 OKL_POOL_TYPES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute13 OKL_POOL_TYPES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute14 OKL_POOL_TYPES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute7 OKL_POOL_TYPES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute8 OKL_POOL_TYPES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute9 OKL_POOL_TYPES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute10 OKL_POOL_TYPES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute11 OKL_POOL_TYPES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute12 OKL_POOL_TYPES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute13 OKL_POOL_TYPES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute14 OKL_POOL_TYPES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute15 OKL_POOL_TYPES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute8 OKL_POOL_TYPES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute9 OKL_POOL_TYPES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute10 OKL_POOL_TYPES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute11 OKL_POOL_TYPES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute12 OKL_POOL_TYPES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute13 OKL_POOL_TYPES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute14 OKL_POOL_TYPES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute15 OKL_POOL_TYPES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
31: ,created_by NUMBER := OKC_API.G_MISS_NUM
24: ,attribute9 OKL_POOL_TYPES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute10 OKL_POOL_TYPES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute11 OKL_POOL_TYPES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute12 OKL_POOL_TYPES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute13 OKL_POOL_TYPES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute14 OKL_POOL_TYPES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute15 OKL_POOL_TYPES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
31: ,created_by NUMBER := OKC_API.G_MISS_NUM
32: ,creation_date OKL_POOL_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,attribute10 OKL_POOL_TYPES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute11 OKL_POOL_TYPES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute12 OKL_POOL_TYPES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute13 OKL_POOL_TYPES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute14 OKL_POOL_TYPES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute15 OKL_POOL_TYPES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
31: ,created_by NUMBER := OKC_API.G_MISS_NUM
32: ,creation_date OKL_POOL_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
26: ,attribute11 OKL_POOL_TYPES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute12 OKL_POOL_TYPES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute13 OKL_POOL_TYPES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute14 OKL_POOL_TYPES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute15 OKL_POOL_TYPES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
31: ,created_by NUMBER := OKC_API.G_MISS_NUM
32: ,creation_date OKL_POOL_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
34: ,last_update_date OKL_POOL_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,attribute12 OKL_POOL_TYPES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute13 OKL_POOL_TYPES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute14 OKL_POOL_TYPES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute15 OKL_POOL_TYPES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
31: ,created_by NUMBER := OKC_API.G_MISS_NUM
32: ,creation_date OKL_POOL_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
34: ,last_update_date OKL_POOL_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
28: ,attribute13 OKL_POOL_TYPES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute14 OKL_POOL_TYPES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute15 OKL_POOL_TYPES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
31: ,created_by NUMBER := OKC_API.G_MISS_NUM
32: ,creation_date OKL_POOL_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
34: ,last_update_date OKL_POOL_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: G_MISS_potv_rec potv_rec_type;
29: ,attribute14 OKL_POOL_TYPES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute15 OKL_POOL_TYPES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
31: ,created_by NUMBER := OKC_API.G_MISS_NUM
32: ,creation_date OKL_POOL_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
34: ,last_update_date OKL_POOL_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: G_MISS_potv_rec potv_rec_type;
37: TYPE potv_tbl_type IS TABLE OF potv_rec_type
30: ,attribute15 OKL_POOL_TYPES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
31: ,created_by NUMBER := OKC_API.G_MISS_NUM
32: ,creation_date OKL_POOL_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
34: ,last_update_date OKL_POOL_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: G_MISS_potv_rec potv_rec_type;
37: TYPE potv_tbl_type IS TABLE OF potv_rec_type
38: INDEX BY BINARY_INTEGER;
31: ,created_by NUMBER := OKC_API.G_MISS_NUM
32: ,creation_date OKL_POOL_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
34: ,last_update_date OKL_POOL_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: G_MISS_potv_rec potv_rec_type;
37: TYPE potv_tbl_type IS TABLE OF potv_rec_type
38: INDEX BY BINARY_INTEGER;
39: -- OKL_POOL_TYPES Record Spec
37: TYPE potv_tbl_type IS TABLE OF potv_rec_type
38: INDEX BY BINARY_INTEGER;
39: -- OKL_POOL_TYPES Record Spec
40: TYPE pot_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,code OKL_POOL_TYPES.CODE%TYPE := OKC_API.G_MISS_CHAR
44: ,description OKL_POOL_TYPES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
45: ,short_description OKL_POOL_TYPES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
38: INDEX BY BINARY_INTEGER;
39: -- OKL_POOL_TYPES Record Spec
40: TYPE pot_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,code OKL_POOL_TYPES.CODE%TYPE := OKC_API.G_MISS_CHAR
44: ,description OKL_POOL_TYPES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
45: ,short_description OKL_POOL_TYPES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,from_date OKL_POOL_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
39: -- OKL_POOL_TYPES Record Spec
40: TYPE pot_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,code OKL_POOL_TYPES.CODE%TYPE := OKC_API.G_MISS_CHAR
44: ,description OKL_POOL_TYPES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
45: ,short_description OKL_POOL_TYPES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,from_date OKL_POOL_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,to_date OKL_POOL_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
40: TYPE pot_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,code OKL_POOL_TYPES.CODE%TYPE := OKC_API.G_MISS_CHAR
44: ,description OKL_POOL_TYPES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
45: ,short_description OKL_POOL_TYPES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,from_date OKL_POOL_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,to_date OKL_POOL_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_POOL_TYPES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
41: id NUMBER := OKC_API.G_MISS_NUM
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,code OKL_POOL_TYPES.CODE%TYPE := OKC_API.G_MISS_CHAR
44: ,description OKL_POOL_TYPES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
45: ,short_description OKL_POOL_TYPES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,from_date OKL_POOL_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,to_date OKL_POOL_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_POOL_TYPES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_POOL_TYPES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,code OKL_POOL_TYPES.CODE%TYPE := OKC_API.G_MISS_CHAR
44: ,description OKL_POOL_TYPES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
45: ,short_description OKL_POOL_TYPES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,from_date OKL_POOL_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,to_date OKL_POOL_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_POOL_TYPES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_POOL_TYPES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_POOL_TYPES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
43: ,code OKL_POOL_TYPES.CODE%TYPE := OKC_API.G_MISS_CHAR
44: ,description OKL_POOL_TYPES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
45: ,short_description OKL_POOL_TYPES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,from_date OKL_POOL_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,to_date OKL_POOL_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_POOL_TYPES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_POOL_TYPES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_POOL_TYPES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_POOL_TYPES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
44: ,description OKL_POOL_TYPES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
45: ,short_description OKL_POOL_TYPES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,from_date OKL_POOL_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,to_date OKL_POOL_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_POOL_TYPES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_POOL_TYPES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_POOL_TYPES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_POOL_TYPES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_POOL_TYPES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
45: ,short_description OKL_POOL_TYPES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,from_date OKL_POOL_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,to_date OKL_POOL_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_POOL_TYPES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_POOL_TYPES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_POOL_TYPES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_POOL_TYPES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_POOL_TYPES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_POOL_TYPES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
46: ,from_date OKL_POOL_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,to_date OKL_POOL_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_POOL_TYPES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_POOL_TYPES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_POOL_TYPES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_POOL_TYPES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_POOL_TYPES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_POOL_TYPES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_POOL_TYPES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
47: ,to_date OKL_POOL_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_POOL_TYPES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_POOL_TYPES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_POOL_TYPES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_POOL_TYPES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_POOL_TYPES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_POOL_TYPES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_POOL_TYPES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_POOL_TYPES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute_category OKL_POOL_TYPES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_POOL_TYPES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_POOL_TYPES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_POOL_TYPES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_POOL_TYPES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_POOL_TYPES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_POOL_TYPES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_POOL_TYPES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_POOL_TYPES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_POOL_TYPES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_POOL_TYPES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_POOL_TYPES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_POOL_TYPES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_POOL_TYPES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_POOL_TYPES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_POOL_TYPES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_POOL_TYPES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_POOL_TYPES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_POOL_TYPES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_POOL_TYPES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_POOL_TYPES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_POOL_TYPES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_POOL_TYPES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_POOL_TYPES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_POOL_TYPES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_POOL_TYPES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_POOL_TYPES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_POOL_TYPES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_POOL_TYPES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_POOL_TYPES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_POOL_TYPES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_POOL_TYPES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_POOL_TYPES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_POOL_TYPES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_POOL_TYPES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_POOL_TYPES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_POOL_TYPES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_POOL_TYPES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_POOL_TYPES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_POOL_TYPES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_POOL_TYPES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_POOL_TYPES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_POOL_TYPES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_POOL_TYPES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_POOL_TYPES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_POOL_TYPES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_POOL_TYPES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_POOL_TYPES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_POOL_TYPES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_POOL_TYPES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_POOL_TYPES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_POOL_TYPES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_POOL_TYPES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_POOL_TYPES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_POOL_TYPES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_POOL_TYPES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_POOL_TYPES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_POOL_TYPES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_POOL_TYPES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_POOL_TYPES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_POOL_TYPES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_POOL_TYPES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_POOL_TYPES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_POOL_TYPES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_POOL_TYPES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_POOL_TYPES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_POOL_TYPES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_POOL_TYPES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_POOL_TYPES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_POOL_TYPES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_POOL_TYPES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_POOL_TYPES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_POOL_TYPES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_POOL_TYPES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_POOL_TYPES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_POOL_TYPES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_POOL_TYPES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_POOL_TYPES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_POOL_TYPES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_POOL_TYPES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,attribute9 OKL_POOL_TYPES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_POOL_TYPES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_POOL_TYPES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_POOL_TYPES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_POOL_TYPES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_POOL_TYPES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_POOL_TYPES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_POOL_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,attribute10 OKL_POOL_TYPES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_POOL_TYPES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_POOL_TYPES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_POOL_TYPES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_POOL_TYPES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_POOL_TYPES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_POOL_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,attribute11 OKL_POOL_TYPES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_POOL_TYPES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_POOL_TYPES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_POOL_TYPES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_POOL_TYPES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_POOL_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_POOL_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,attribute12 OKL_POOL_TYPES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_POOL_TYPES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_POOL_TYPES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_POOL_TYPES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_POOL_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_POOL_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
61: ,attribute13 OKL_POOL_TYPES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_POOL_TYPES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_POOL_TYPES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_POOL_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_POOL_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69: G_MISS_pot_rec pot_rec_type;
62: ,attribute14 OKL_POOL_TYPES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_POOL_TYPES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_POOL_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_POOL_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69: G_MISS_pot_rec pot_rec_type;
70: TYPE pot_tbl_type IS TABLE OF pot_rec_type
63: ,attribute15 OKL_POOL_TYPES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_POOL_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_POOL_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69: G_MISS_pot_rec pot_rec_type;
70: TYPE pot_tbl_type IS TABLE OF pot_rec_type
71: INDEX BY BINARY_INTEGER;
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_POOL_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_POOL_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69: G_MISS_pot_rec pot_rec_type;
70: TYPE pot_tbl_type IS TABLE OF pot_rec_type
71: INDEX BY BINARY_INTEGER;
72: ---------------------------------------------------------------------------
71: INDEX BY BINARY_INTEGER;
72: ---------------------------------------------------------------------------
73: -- GLOBAL MESSAGE CONSTANTS
74: ---------------------------------------------------------------------------
75: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
76: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
72: ---------------------------------------------------------------------------
73: -- GLOBAL MESSAGE CONSTANTS
74: ---------------------------------------------------------------------------
75: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
76: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
73: -- GLOBAL MESSAGE CONSTANTS
74: ---------------------------------------------------------------------------
75: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
76: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
74: ---------------------------------------------------------------------------
75: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
76: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
75: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
76: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
76: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
84: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
84: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
85: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
84: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
85: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
86: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
84: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
85: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
86: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
87: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
84: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
85: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
86: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
87: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
88: -- mvasudev, 11/08/2002
85: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
86: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
87: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
88: -- mvasudev, 11/08/2002
89: G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
90:
91: ---------------------------------------------------------------------------
92: -- GLOBAL EXCEPTIONS
93: ---------------------------------------------------------------------------
96: ---------------------------------------------------------------------------
97: -- GLOBAL VARIABLES
98: ---------------------------------------------------------------------------
99: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_POT_PVT';
100: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
101: ---------------------------------------------------------------------------
102: -- Procedures and Functions
103: ---------------------------------------------------------------------------
104:
106: PROCEDURE change_version;
107: PROCEDURE api_copy;
108: PROCEDURE insert_row(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_potv_rec IN potv_rec_type,
114: p_potv_rec IN potv_rec_type,
115: x_potv_rec OUT NOCOPY potv_rec_type);
116: PROCEDURE insert_row(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_potv_tbl IN potv_tbl_type,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_potv_tbl IN potv_tbl_type,
123: x_potv_tbl OUT NOCOPY potv_tbl_type,
124: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
125: PROCEDURE insert_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
123: x_potv_tbl OUT NOCOPY potv_tbl_type,
124: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
125: PROCEDURE insert_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_potv_tbl IN potv_tbl_type,
131: p_potv_tbl IN potv_tbl_type,
132: x_potv_tbl OUT NOCOPY potv_tbl_type);
133: PROCEDURE lock_row(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_potv_rec IN potv_rec_type);
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_potv_rec IN potv_rec_type);
140: PROCEDURE lock_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_potv_tbl IN potv_tbl_type,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_potv_tbl IN potv_tbl_type,
147: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
148: PROCEDURE lock_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
146: p_potv_tbl IN potv_tbl_type,
147: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
148: PROCEDURE lock_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_potv_tbl IN potv_tbl_type);
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_potv_tbl IN potv_tbl_type);
155: PROCEDURE update_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_potv_rec IN potv_rec_type,
161: p_potv_rec IN potv_rec_type,
162: x_potv_rec OUT NOCOPY potv_rec_type);
163: PROCEDURE update_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_potv_tbl IN potv_tbl_type,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_potv_tbl IN potv_tbl_type,
170: x_potv_tbl OUT NOCOPY potv_tbl_type,
171: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
172: PROCEDURE update_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
170: x_potv_tbl OUT NOCOPY potv_tbl_type,
171: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
172: PROCEDURE update_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_potv_tbl IN potv_tbl_type,
178: p_potv_tbl IN potv_tbl_type,
179: x_potv_tbl OUT NOCOPY potv_tbl_type);
180: PROCEDURE delete_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_potv_rec IN potv_rec_type);
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_potv_rec IN potv_rec_type);
187: PROCEDURE delete_row(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_potv_tbl IN potv_tbl_type,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_potv_tbl IN potv_tbl_type,
194: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
195: PROCEDURE delete_row(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198: x_return_status OUT NOCOPY VARCHAR2,
193: p_potv_tbl IN potv_tbl_type,
194: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
195: PROCEDURE delete_row(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_potv_tbl IN potv_tbl_type);
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_potv_tbl IN potv_tbl_type);
202: PROCEDURE validate_row(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_potv_rec IN potv_rec_type);
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_potv_rec IN potv_rec_type);
209: PROCEDURE validate_row(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_potv_tbl IN potv_tbl_type,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_potv_tbl IN potv_tbl_type,
216: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
217: PROCEDURE validate_row(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
215: p_potv_tbl IN potv_tbl_type,
216: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
217: PROCEDURE validate_row(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_potv_tbl IN potv_tbl_type);