3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE pvn_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: name OKL_PROVISIONS.NAME%TYPE := Okc_Api.G_MISS_CHAR,
9: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE pvn_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: name OKL_PROVISIONS.NAME%TYPE := Okc_Api.G_MISS_CHAR,
9: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE pvn_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: name OKL_PROVISIONS.NAME%TYPE := Okc_Api.G_MISS_CHAR,
9: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
6: TYPE pvn_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: name OKL_PROVISIONS.NAME%TYPE := Okc_Api.G_MISS_CHAR,
9: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: name OKL_PROVISIONS.NAME%TYPE := Okc_Api.G_MISS_CHAR,
9: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: version OKL_PROVISIONS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
8: name OKL_PROVISIONS.NAME%TYPE := Okc_Api.G_MISS_CHAR,
9: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: version OKL_PROVISIONS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
16: description OKL_PROVISIONS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
9: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
10: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: version OKL_PROVISIONS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
16: description OKL_PROVISIONS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_PROVISIONS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
10: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
11: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: version OKL_PROVISIONS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
16: description OKL_PROVISIONS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_PROVISIONS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: TO_DATE OKL_PROVISIONS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
11: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
12: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: version OKL_PROVISIONS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
16: description OKL_PROVISIONS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_PROVISIONS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: TO_DATE OKL_PROVISIONS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: attribute_category OKL_PROVISIONS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
12: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
13: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: version OKL_PROVISIONS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
16: description OKL_PROVISIONS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_PROVISIONS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: TO_DATE OKL_PROVISIONS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: attribute_category OKL_PROVISIONS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute1 OKL_PROVISIONS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
13: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: version OKL_PROVISIONS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
16: description OKL_PROVISIONS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_PROVISIONS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: TO_DATE OKL_PROVISIONS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: attribute_category OKL_PROVISIONS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute1 OKL_PROVISIONS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute2 OKL_PROVISIONS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
14: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15: version OKL_PROVISIONS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
16: description OKL_PROVISIONS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_PROVISIONS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: TO_DATE OKL_PROVISIONS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: attribute_category OKL_PROVISIONS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute1 OKL_PROVISIONS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute2 OKL_PROVISIONS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute3 OKL_PROVISIONS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
15: version OKL_PROVISIONS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
16: description OKL_PROVISIONS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_PROVISIONS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: TO_DATE OKL_PROVISIONS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: attribute_category OKL_PROVISIONS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute1 OKL_PROVISIONS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute2 OKL_PROVISIONS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute3 OKL_PROVISIONS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute4 OKL_PROVISIONS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
16: description OKL_PROVISIONS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_PROVISIONS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: TO_DATE OKL_PROVISIONS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: attribute_category OKL_PROVISIONS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute1 OKL_PROVISIONS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute2 OKL_PROVISIONS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute3 OKL_PROVISIONS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute4 OKL_PROVISIONS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute5 OKL_PROVISIONS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
17: from_date OKL_PROVISIONS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: TO_DATE OKL_PROVISIONS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: attribute_category OKL_PROVISIONS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute1 OKL_PROVISIONS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute2 OKL_PROVISIONS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute3 OKL_PROVISIONS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute4 OKL_PROVISIONS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute5 OKL_PROVISIONS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute6 OKL_PROVISIONS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
18: TO_DATE OKL_PROVISIONS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: attribute_category OKL_PROVISIONS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute1 OKL_PROVISIONS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute2 OKL_PROVISIONS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute3 OKL_PROVISIONS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute4 OKL_PROVISIONS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute5 OKL_PROVISIONS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute6 OKL_PROVISIONS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute7 OKL_PROVISIONS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
19: attribute_category OKL_PROVISIONS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute1 OKL_PROVISIONS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute2 OKL_PROVISIONS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute3 OKL_PROVISIONS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute4 OKL_PROVISIONS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute5 OKL_PROVISIONS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute6 OKL_PROVISIONS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute7 OKL_PROVISIONS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute8 OKL_PROVISIONS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
20: attribute1 OKL_PROVISIONS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute2 OKL_PROVISIONS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute3 OKL_PROVISIONS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute4 OKL_PROVISIONS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute5 OKL_PROVISIONS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute6 OKL_PROVISIONS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute7 OKL_PROVISIONS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute8 OKL_PROVISIONS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute9 OKL_PROVISIONS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
21: attribute2 OKL_PROVISIONS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute3 OKL_PROVISIONS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute4 OKL_PROVISIONS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute5 OKL_PROVISIONS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute6 OKL_PROVISIONS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute7 OKL_PROVISIONS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute8 OKL_PROVISIONS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute9 OKL_PROVISIONS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute10 OKL_PROVISIONS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
22: attribute3 OKL_PROVISIONS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute4 OKL_PROVISIONS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute5 OKL_PROVISIONS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute6 OKL_PROVISIONS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute7 OKL_PROVISIONS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute8 OKL_PROVISIONS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute9 OKL_PROVISIONS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute10 OKL_PROVISIONS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute11 OKL_PROVISIONS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
23: attribute4 OKL_PROVISIONS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute5 OKL_PROVISIONS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute6 OKL_PROVISIONS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute7 OKL_PROVISIONS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute8 OKL_PROVISIONS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute9 OKL_PROVISIONS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute10 OKL_PROVISIONS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute11 OKL_PROVISIONS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute12 OKL_PROVISIONS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
24: attribute5 OKL_PROVISIONS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute6 OKL_PROVISIONS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute7 OKL_PROVISIONS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute8 OKL_PROVISIONS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute9 OKL_PROVISIONS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute10 OKL_PROVISIONS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute11 OKL_PROVISIONS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute12 OKL_PROVISIONS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute13 OKL_PROVISIONS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
25: attribute6 OKL_PROVISIONS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute7 OKL_PROVISIONS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute8 OKL_PROVISIONS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute9 OKL_PROVISIONS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute10 OKL_PROVISIONS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute11 OKL_PROVISIONS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute12 OKL_PROVISIONS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute13 OKL_PROVISIONS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute14 OKL_PROVISIONS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute7 OKL_PROVISIONS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute8 OKL_PROVISIONS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute9 OKL_PROVISIONS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute10 OKL_PROVISIONS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute11 OKL_PROVISIONS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute12 OKL_PROVISIONS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute13 OKL_PROVISIONS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute14 OKL_PROVISIONS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute15 OKL_PROVISIONS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute8 OKL_PROVISIONS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute9 OKL_PROVISIONS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute10 OKL_PROVISIONS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute11 OKL_PROVISIONS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute12 OKL_PROVISIONS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute13 OKL_PROVISIONS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute14 OKL_PROVISIONS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute15 OKL_PROVISIONS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
35: created_by NUMBER := Okc_Api.G_MISS_NUM,
28: attribute9 OKL_PROVISIONS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute10 OKL_PROVISIONS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute11 OKL_PROVISIONS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute12 OKL_PROVISIONS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute13 OKL_PROVISIONS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute14 OKL_PROVISIONS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute15 OKL_PROVISIONS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
35: created_by NUMBER := Okc_Api.G_MISS_NUM,
36: creation_date OKL_PROVISIONS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
29: attribute10 OKL_PROVISIONS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute11 OKL_PROVISIONS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute12 OKL_PROVISIONS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute13 OKL_PROVISIONS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute14 OKL_PROVISIONS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute15 OKL_PROVISIONS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
35: created_by NUMBER := Okc_Api.G_MISS_NUM,
36: creation_date OKL_PROVISIONS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
37: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
30: attribute11 OKL_PROVISIONS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute12 OKL_PROVISIONS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute13 OKL_PROVISIONS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute14 OKL_PROVISIONS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute15 OKL_PROVISIONS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
35: created_by NUMBER := Okc_Api.G_MISS_NUM,
36: creation_date OKL_PROVISIONS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
37: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
38: last_update_date OKL_PROVISIONS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
31: attribute12 OKL_PROVISIONS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute13 OKL_PROVISIONS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute14 OKL_PROVISIONS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute15 OKL_PROVISIONS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
35: created_by NUMBER := Okc_Api.G_MISS_NUM,
36: creation_date OKL_PROVISIONS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
37: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
38: last_update_date OKL_PROVISIONS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
39: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
32: attribute13 OKL_PROVISIONS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute14 OKL_PROVISIONS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute15 OKL_PROVISIONS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
35: created_by NUMBER := Okc_Api.G_MISS_NUM,
36: creation_date OKL_PROVISIONS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
37: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
38: last_update_date OKL_PROVISIONS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
39: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
40: g_miss_pvn_rec pvn_rec_type;
33: attribute14 OKL_PROVISIONS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute15 OKL_PROVISIONS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
35: created_by NUMBER := Okc_Api.G_MISS_NUM,
36: creation_date OKL_PROVISIONS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
37: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
38: last_update_date OKL_PROVISIONS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
39: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
40: g_miss_pvn_rec pvn_rec_type;
41: TYPE pvn_tbl_type IS TABLE OF pvn_rec_type
34: attribute15 OKL_PROVISIONS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
35: created_by NUMBER := Okc_Api.G_MISS_NUM,
36: creation_date OKL_PROVISIONS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
37: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
38: last_update_date OKL_PROVISIONS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
39: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
40: g_miss_pvn_rec pvn_rec_type;
41: TYPE pvn_tbl_type IS TABLE OF pvn_rec_type
42: INDEX BY BINARY_INTEGER;
35: created_by NUMBER := Okc_Api.G_MISS_NUM,
36: creation_date OKL_PROVISIONS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
37: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
38: last_update_date OKL_PROVISIONS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
39: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
40: g_miss_pvn_rec pvn_rec_type;
41: TYPE pvn_tbl_type IS TABLE OF pvn_rec_type
42: INDEX BY BINARY_INTEGER;
43: TYPE pvnv_rec_type IS RECORD (
40: g_miss_pvn_rec pvn_rec_type;
41: TYPE pvn_tbl_type IS TABLE OF pvn_rec_type
42: INDEX BY BINARY_INTEGER;
43: TYPE pvnv_rec_type IS RECORD (
44: id NUMBER := Okc_Api.G_MISS_NUM,
45: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
46: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
47: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
48: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
41: TYPE pvn_tbl_type IS TABLE OF pvn_rec_type
42: INDEX BY BINARY_INTEGER;
43: TYPE pvnv_rec_type IS RECORD (
44: id NUMBER := Okc_Api.G_MISS_NUM,
45: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
46: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
47: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
48: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
49: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
42: INDEX BY BINARY_INTEGER;
43: TYPE pvnv_rec_type IS RECORD (
44: id NUMBER := Okc_Api.G_MISS_NUM,
45: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
46: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
47: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
48: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
49: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
50: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
43: TYPE pvnv_rec_type IS RECORD (
44: id NUMBER := Okc_Api.G_MISS_NUM,
45: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
46: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
47: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
48: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
49: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
50: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: name OKL_PROVISIONS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
44: id NUMBER := Okc_Api.G_MISS_NUM,
45: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
46: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
47: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
48: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
49: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
50: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: name OKL_PROVISIONS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
52: description OKL_PROVISIONS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
45: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
46: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
47: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
48: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
49: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
50: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: name OKL_PROVISIONS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
52: description OKL_PROVISIONS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute_category OKL_PROVISIONS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
46: app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
47: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
48: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
49: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
50: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: name OKL_PROVISIONS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
52: description OKL_PROVISIONS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute_category OKL_PROVISIONS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute1 OKL_PROVISIONS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
47: rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
48: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
49: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
50: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: name OKL_PROVISIONS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
52: description OKL_PROVISIONS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute_category OKL_PROVISIONS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute1 OKL_PROVISIONS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute2 OKL_PROVISIONS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
48: rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
49: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
50: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: name OKL_PROVISIONS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
52: description OKL_PROVISIONS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute_category OKL_PROVISIONS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute1 OKL_PROVISIONS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute2 OKL_PROVISIONS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute3 OKL_PROVISIONS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
49: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
50: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: name OKL_PROVISIONS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
52: description OKL_PROVISIONS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute_category OKL_PROVISIONS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute1 OKL_PROVISIONS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute2 OKL_PROVISIONS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute3 OKL_PROVISIONS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute4 OKL_PROVISIONS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
50: app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
51: name OKL_PROVISIONS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
52: description OKL_PROVISIONS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute_category OKL_PROVISIONS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute1 OKL_PROVISIONS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute2 OKL_PROVISIONS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute3 OKL_PROVISIONS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute4 OKL_PROVISIONS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute5 OKL_PROVISIONS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
51: name OKL_PROVISIONS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
52: description OKL_PROVISIONS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute_category OKL_PROVISIONS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute1 OKL_PROVISIONS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute2 OKL_PROVISIONS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute3 OKL_PROVISIONS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute4 OKL_PROVISIONS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute5 OKL_PROVISIONS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute6 OKL_PROVISIONS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
52: description OKL_PROVISIONS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute_category OKL_PROVISIONS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute1 OKL_PROVISIONS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute2 OKL_PROVISIONS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute3 OKL_PROVISIONS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute4 OKL_PROVISIONS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute5 OKL_PROVISIONS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute6 OKL_PROVISIONS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute7 OKL_PROVISIONS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
53: attribute_category OKL_PROVISIONS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute1 OKL_PROVISIONS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute2 OKL_PROVISIONS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute3 OKL_PROVISIONS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute4 OKL_PROVISIONS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute5 OKL_PROVISIONS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute6 OKL_PROVISIONS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute7 OKL_PROVISIONS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute8 OKL_PROVISIONS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
54: attribute1 OKL_PROVISIONS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute2 OKL_PROVISIONS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute3 OKL_PROVISIONS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute4 OKL_PROVISIONS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute5 OKL_PROVISIONS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute6 OKL_PROVISIONS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute7 OKL_PROVISIONS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute8 OKL_PROVISIONS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute9 OKL_PROVISIONS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
55: attribute2 OKL_PROVISIONS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute3 OKL_PROVISIONS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute4 OKL_PROVISIONS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute5 OKL_PROVISIONS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute6 OKL_PROVISIONS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute7 OKL_PROVISIONS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute8 OKL_PROVISIONS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute9 OKL_PROVISIONS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute10 OKL_PROVISIONS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
56: attribute3 OKL_PROVISIONS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute4 OKL_PROVISIONS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute5 OKL_PROVISIONS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute6 OKL_PROVISIONS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute7 OKL_PROVISIONS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute8 OKL_PROVISIONS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute9 OKL_PROVISIONS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute10 OKL_PROVISIONS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute11 OKL_PROVISIONS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
57: attribute4 OKL_PROVISIONS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute5 OKL_PROVISIONS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute6 OKL_PROVISIONS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute7 OKL_PROVISIONS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute8 OKL_PROVISIONS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute9 OKL_PROVISIONS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute10 OKL_PROVISIONS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute11 OKL_PROVISIONS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute12 OKL_PROVISIONS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
58: attribute5 OKL_PROVISIONS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute6 OKL_PROVISIONS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute7 OKL_PROVISIONS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute8 OKL_PROVISIONS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute9 OKL_PROVISIONS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute10 OKL_PROVISIONS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute11 OKL_PROVISIONS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute12 OKL_PROVISIONS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute13 OKL_PROVISIONS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
59: attribute6 OKL_PROVISIONS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute7 OKL_PROVISIONS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute8 OKL_PROVISIONS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute9 OKL_PROVISIONS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute10 OKL_PROVISIONS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute11 OKL_PROVISIONS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute12 OKL_PROVISIONS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute13 OKL_PROVISIONS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute14 OKL_PROVISIONS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
60: attribute7 OKL_PROVISIONS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute8 OKL_PROVISIONS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute9 OKL_PROVISIONS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute10 OKL_PROVISIONS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute11 OKL_PROVISIONS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute12 OKL_PROVISIONS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute13 OKL_PROVISIONS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute14 OKL_PROVISIONS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute15 OKL_PROVISIONS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
61: attribute8 OKL_PROVISIONS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute9 OKL_PROVISIONS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute10 OKL_PROVISIONS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute11 OKL_PROVISIONS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute12 OKL_PROVISIONS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute13 OKL_PROVISIONS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute14 OKL_PROVISIONS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute15 OKL_PROVISIONS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
69: version OKL_PROVISIONS_V.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
62: attribute9 OKL_PROVISIONS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
63: attribute10 OKL_PROVISIONS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute11 OKL_PROVISIONS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute12 OKL_PROVISIONS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute13 OKL_PROVISIONS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute14 OKL_PROVISIONS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute15 OKL_PROVISIONS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
69: version OKL_PROVISIONS_V.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
70: from_date OKL_PROVISIONS_V.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
63: attribute10 OKL_PROVISIONS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
64: attribute11 OKL_PROVISIONS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute12 OKL_PROVISIONS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute13 OKL_PROVISIONS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute14 OKL_PROVISIONS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute15 OKL_PROVISIONS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
69: version OKL_PROVISIONS_V.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
70: from_date OKL_PROVISIONS_V.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
71: TO_DATE OKL_PROVISIONS_V.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
64: attribute11 OKL_PROVISIONS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
65: attribute12 OKL_PROVISIONS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute13 OKL_PROVISIONS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute14 OKL_PROVISIONS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute15 OKL_PROVISIONS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
69: version OKL_PROVISIONS_V.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
70: from_date OKL_PROVISIONS_V.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
71: TO_DATE OKL_PROVISIONS_V.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
72: created_by NUMBER := Okc_Api.G_MISS_NUM,
65: attribute12 OKL_PROVISIONS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
66: attribute13 OKL_PROVISIONS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute14 OKL_PROVISIONS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute15 OKL_PROVISIONS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
69: version OKL_PROVISIONS_V.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
70: from_date OKL_PROVISIONS_V.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
71: TO_DATE OKL_PROVISIONS_V.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
72: created_by NUMBER := Okc_Api.G_MISS_NUM,
73: creation_date OKL_PROVISIONS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
66: attribute13 OKL_PROVISIONS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
67: attribute14 OKL_PROVISIONS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute15 OKL_PROVISIONS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
69: version OKL_PROVISIONS_V.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
70: from_date OKL_PROVISIONS_V.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
71: TO_DATE OKL_PROVISIONS_V.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
72: created_by NUMBER := Okc_Api.G_MISS_NUM,
73: creation_date OKL_PROVISIONS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
74: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
67: attribute14 OKL_PROVISIONS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
68: attribute15 OKL_PROVISIONS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
69: version OKL_PROVISIONS_V.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
70: from_date OKL_PROVISIONS_V.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
71: TO_DATE OKL_PROVISIONS_V.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
72: created_by NUMBER := Okc_Api.G_MISS_NUM,
73: creation_date OKL_PROVISIONS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
74: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
75: last_update_date OKL_PROVISIONS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
68: attribute15 OKL_PROVISIONS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
69: version OKL_PROVISIONS_V.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
70: from_date OKL_PROVISIONS_V.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
71: TO_DATE OKL_PROVISIONS_V.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
72: created_by NUMBER := Okc_Api.G_MISS_NUM,
73: creation_date OKL_PROVISIONS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
74: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
75: last_update_date OKL_PROVISIONS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
69: version OKL_PROVISIONS_V.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
70: from_date OKL_PROVISIONS_V.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
71: TO_DATE OKL_PROVISIONS_V.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
72: created_by NUMBER := Okc_Api.G_MISS_NUM,
73: creation_date OKL_PROVISIONS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
74: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
75: last_update_date OKL_PROVISIONS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
77: g_miss_pvnv_rec pvnv_rec_type;
70: from_date OKL_PROVISIONS_V.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
71: TO_DATE OKL_PROVISIONS_V.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
72: created_by NUMBER := Okc_Api.G_MISS_NUM,
73: creation_date OKL_PROVISIONS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
74: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
75: last_update_date OKL_PROVISIONS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
77: g_miss_pvnv_rec pvnv_rec_type;
78: TYPE pvnv_tbl_type IS TABLE OF pvnv_rec_type
71: TO_DATE OKL_PROVISIONS_V.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
72: created_by NUMBER := Okc_Api.G_MISS_NUM,
73: creation_date OKL_PROVISIONS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
74: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
75: last_update_date OKL_PROVISIONS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
77: g_miss_pvnv_rec pvnv_rec_type;
78: TYPE pvnv_tbl_type IS TABLE OF pvnv_rec_type
79: INDEX BY BINARY_INTEGER;
72: created_by NUMBER := Okc_Api.G_MISS_NUM,
73: creation_date OKL_PROVISIONS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
74: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
75: last_update_date OKL_PROVISIONS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
76: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
77: g_miss_pvnv_rec pvnv_rec_type;
78: TYPE pvnv_tbl_type IS TABLE OF pvnv_rec_type
79: INDEX BY BINARY_INTEGER;
80: ---------------------------------------------------------------------------
79: INDEX BY BINARY_INTEGER;
80: ---------------------------------------------------------------------------
81: -- GLOBAL MESSAGE CONSTANTS
82: ---------------------------------------------------------------------------
83: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
80: ---------------------------------------------------------------------------
81: -- GLOBAL MESSAGE CONSTANTS
82: ---------------------------------------------------------------------------
83: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
81: -- GLOBAL MESSAGE CONSTANTS
82: ---------------------------------------------------------------------------
83: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
82: ---------------------------------------------------------------------------
83: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
83: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
93: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
93: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
94: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
93: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
94: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
95: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
93: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
94: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
95: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
96: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_PVN_ELEMENT_NOT_UNIQUE';
105: ---------------------------------------------------------------------------
106: -- GLOBAL VARIABLES
107: ---------------------------------------------------------------------------
108: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PVN_PVT';
109: G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
110: ---------------------------------------------------------------------------
111: -- Procedures and Functions
112: ---------------------------------------------------------------------------
113:
115: Procedure change_version;
116: Procedure api_copy;
117: Procedure insert_row(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_pvnv_rec IN pvnv_rec_type,
124: x_pvnv_rec OUT NOCOPY pvnv_rec_type);
125:
126: Procedure insert_row(
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_pvnv_tbl IN pvnv_tbl_type,
133: x_pvnv_tbl OUT NOCOPY pvnv_tbl_type);
134:
135: Procedure lock_row(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_pvnv_rec IN pvnv_rec_type);
141: p_pvnv_rec IN pvnv_rec_type);
142:
143: Procedure lock_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_pvnv_tbl IN pvnv_tbl_type);
149: p_pvnv_tbl IN pvnv_tbl_type);
150:
151: Procedure update_row(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_pvnv_rec IN pvnv_rec_type,
158: x_pvnv_rec OUT NOCOPY pvnv_rec_type);
159:
160: Procedure update_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_pvnv_tbl IN pvnv_tbl_type,
167: x_pvnv_tbl OUT NOCOPY pvnv_tbl_type);
168:
169: Procedure delete_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_pvnv_rec IN pvnv_rec_type);
175: p_pvnv_rec IN pvnv_rec_type);
176:
177: Procedure delete_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_pvnv_tbl IN pvnv_tbl_type);
183: p_pvnv_tbl IN pvnv_tbl_type);
184:
185: Procedure validate_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_pvnv_rec IN pvnv_rec_type);
191: p_pvnv_rec IN pvnv_rec_type);
192:
193: Procedure validate_row(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_pvnv_tbl IN pvnv_tbl_type);