4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_POOL_TRANSACTIONS_V Record Spec
7: TYPE poxv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,pol_id NUMBER := OKL_API.G_MISS_NUM
11: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
12: ,transaction_date OKL_POOL_TRANSACTIONS_V.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
5: ---------------------------------------------------------------------------
6: -- OKL_POOL_TRANSACTIONS_V Record Spec
7: TYPE poxv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,pol_id NUMBER := OKL_API.G_MISS_NUM
11: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
12: ,transaction_date OKL_POOL_TRANSACTIONS_V.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
13: ,transaction_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
6: -- OKL_POOL_TRANSACTIONS_V Record Spec
7: TYPE poxv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,pol_id NUMBER := OKL_API.G_MISS_NUM
11: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
12: ,transaction_date OKL_POOL_TRANSACTIONS_V.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
13: ,transaction_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
14: ,transaction_sub_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
7: TYPE poxv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,pol_id NUMBER := OKL_API.G_MISS_NUM
11: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
12: ,transaction_date OKL_POOL_TRANSACTIONS_V.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
13: ,transaction_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
14: ,transaction_sub_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
15: ,date_effective OKL_POOL_TRANSACTIONS_V.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,pol_id NUMBER := OKL_API.G_MISS_NUM
11: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
12: ,transaction_date OKL_POOL_TRANSACTIONS_V.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
13: ,transaction_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
14: ,transaction_sub_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
15: ,date_effective OKL_POOL_TRANSACTIONS_V.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
16: ,currency_code OKL_POOL_TRANSACTIONS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,pol_id NUMBER := OKL_API.G_MISS_NUM
11: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
12: ,transaction_date OKL_POOL_TRANSACTIONS_V.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
13: ,transaction_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
14: ,transaction_sub_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
15: ,date_effective OKL_POOL_TRANSACTIONS_V.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
16: ,currency_code OKL_POOL_TRANSACTIONS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
17: ,currency_conversion_type OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
10: ,pol_id NUMBER := OKL_API.G_MISS_NUM
11: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
12: ,transaction_date OKL_POOL_TRANSACTIONS_V.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
13: ,transaction_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
14: ,transaction_sub_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
15: ,date_effective OKL_POOL_TRANSACTIONS_V.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
16: ,currency_code OKL_POOL_TRANSACTIONS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
17: ,currency_conversion_type OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_date OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
11: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
12: ,transaction_date OKL_POOL_TRANSACTIONS_V.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
13: ,transaction_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
14: ,transaction_sub_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
15: ,date_effective OKL_POOL_TRANSACTIONS_V.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
16: ,currency_code OKL_POOL_TRANSACTIONS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
17: ,currency_conversion_type OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_date OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
12: ,transaction_date OKL_POOL_TRANSACTIONS_V.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
13: ,transaction_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
14: ,transaction_sub_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
15: ,date_effective OKL_POOL_TRANSACTIONS_V.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
16: ,currency_code OKL_POOL_TRANSACTIONS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
17: ,currency_conversion_type OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_date OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
20: ,transaction_reason OKL_POOL_TRANSACTIONS_V.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
13: ,transaction_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
14: ,transaction_sub_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
15: ,date_effective OKL_POOL_TRANSACTIONS_V.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
16: ,currency_code OKL_POOL_TRANSACTIONS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
17: ,currency_conversion_type OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_date OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
20: ,transaction_reason OKL_POOL_TRANSACTIONS_V.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute_category OKL_POOL_TRANSACTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
14: ,transaction_sub_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
15: ,date_effective OKL_POOL_TRANSACTIONS_V.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
16: ,currency_code OKL_POOL_TRANSACTIONS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
17: ,currency_conversion_type OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_date OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
20: ,transaction_reason OKL_POOL_TRANSACTIONS_V.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute_category OKL_POOL_TRANSACTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute1 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
15: ,date_effective OKL_POOL_TRANSACTIONS_V.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
16: ,currency_code OKL_POOL_TRANSACTIONS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
17: ,currency_conversion_type OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_date OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
20: ,transaction_reason OKL_POOL_TRANSACTIONS_V.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute_category OKL_POOL_TRANSACTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute1 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute2 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
16: ,currency_code OKL_POOL_TRANSACTIONS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
17: ,currency_conversion_type OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_date OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
20: ,transaction_reason OKL_POOL_TRANSACTIONS_V.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute_category OKL_POOL_TRANSACTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute1 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute2 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute3 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
17: ,currency_conversion_type OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_date OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
20: ,transaction_reason OKL_POOL_TRANSACTIONS_V.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute_category OKL_POOL_TRANSACTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute1 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute2 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute3 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute4 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_date OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
20: ,transaction_reason OKL_POOL_TRANSACTIONS_V.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute_category OKL_POOL_TRANSACTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute1 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute2 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute3 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute4 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute5 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
19: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
20: ,transaction_reason OKL_POOL_TRANSACTIONS_V.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute_category OKL_POOL_TRANSACTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute1 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute2 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute3 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute4 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute5 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute6 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
20: ,transaction_reason OKL_POOL_TRANSACTIONS_V.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute_category OKL_POOL_TRANSACTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute1 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute2 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute3 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute4 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute5 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute6 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute7 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute_category OKL_POOL_TRANSACTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute1 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute2 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute3 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute4 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute5 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute6 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute7 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute8 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute1 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute2 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute3 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute4 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute5 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute6 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute7 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute8 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute9 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute2 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute3 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute4 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute5 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute6 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute7 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute8 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute9 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute10 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute3 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute4 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute5 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute6 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute7 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute8 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute9 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute10 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute11 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute4 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute5 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute6 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute7 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute8 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute9 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute10 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute11 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute12 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute5 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute6 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute7 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute8 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute9 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute10 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute11 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute12 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute13 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute6 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute7 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute8 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute9 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute10 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute11 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute12 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute13 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute14 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute7 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute8 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute9 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute10 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute11 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute12 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute13 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute14 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute15 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute8 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute9 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute10 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute11 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute12 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute13 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute14 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute15 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
37: ,request_id NUMBER := OKL_API.G_MISS_NUM
30: ,attribute9 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute10 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute11 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute12 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute13 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute14 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute15 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
37: ,request_id NUMBER := OKL_API.G_MISS_NUM
38: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
31: ,attribute10 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute11 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute12 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute13 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute14 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute15 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
37: ,request_id NUMBER := OKL_API.G_MISS_NUM
38: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
39: ,program_id NUMBER := OKL_API.G_MISS_NUM
32: ,attribute11 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute12 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute13 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute14 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute15 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
37: ,request_id NUMBER := OKL_API.G_MISS_NUM
38: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
39: ,program_id NUMBER := OKL_API.G_MISS_NUM
40: ,program_update_date OKL_POOL_TRANSACTIONS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,attribute12 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute13 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute14 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute15 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
37: ,request_id NUMBER := OKL_API.G_MISS_NUM
38: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
39: ,program_id NUMBER := OKL_API.G_MISS_NUM
40: ,program_update_date OKL_POOL_TRANSACTIONS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
34: ,attribute13 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute14 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute15 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
37: ,request_id NUMBER := OKL_API.G_MISS_NUM
38: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
39: ,program_id NUMBER := OKL_API.G_MISS_NUM
40: ,program_update_date OKL_POOL_TRANSACTIONS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_POOL_TRANSACTIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
35: ,attribute14 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute15 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
37: ,request_id NUMBER := OKL_API.G_MISS_NUM
38: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
39: ,program_id NUMBER := OKL_API.G_MISS_NUM
40: ,program_update_date OKL_POOL_TRANSACTIONS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_POOL_TRANSACTIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
36: ,attribute15 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
37: ,request_id NUMBER := OKL_API.G_MISS_NUM
38: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
39: ,program_id NUMBER := OKL_API.G_MISS_NUM
40: ,program_update_date OKL_POOL_TRANSACTIONS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_POOL_TRANSACTIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44: ,last_update_date OKL_POOL_TRANSACTIONS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,request_id NUMBER := OKL_API.G_MISS_NUM
38: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
39: ,program_id NUMBER := OKL_API.G_MISS_NUM
40: ,program_update_date OKL_POOL_TRANSACTIONS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_POOL_TRANSACTIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44: ,last_update_date OKL_POOL_TRANSACTIONS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
38: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
39: ,program_id NUMBER := OKL_API.G_MISS_NUM
40: ,program_update_date OKL_POOL_TRANSACTIONS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_POOL_TRANSACTIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44: ,last_update_date OKL_POOL_TRANSACTIONS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
46: --added by abhsaxen for Legal Entity Uptake
39: ,program_id NUMBER := OKL_API.G_MISS_NUM
40: ,program_update_date OKL_POOL_TRANSACTIONS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_POOL_TRANSACTIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44: ,last_update_date OKL_POOL_TRANSACTIONS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
46: --added by abhsaxen for Legal Entity Uptake
47: ,legal_entity_id OKL_POOL_TRANSACTIONS_V.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM
40: ,program_update_date OKL_POOL_TRANSACTIONS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_POOL_TRANSACTIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44: ,last_update_date OKL_POOL_TRANSACTIONS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
46: --added by abhsaxen for Legal Entity Uptake
47: ,legal_entity_id OKL_POOL_TRANSACTIONS_V.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM
48: -- sosharma 12/03/07 Added for enabling status on transactions
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_POOL_TRANSACTIONS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44: ,last_update_date OKL_POOL_TRANSACTIONS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
46: --added by abhsaxen for Legal Entity Uptake
47: ,legal_entity_id OKL_POOL_TRANSACTIONS_V.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM
48: -- sosharma 12/03/07 Added for enabling status on transactions
49: ,transaction_status OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE := OKL_API.G_MISS_CHAR );
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44: ,last_update_date OKL_POOL_TRANSACTIONS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
46: --added by abhsaxen for Legal Entity Uptake
47: ,legal_entity_id OKL_POOL_TRANSACTIONS_V.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM
48: -- sosharma 12/03/07 Added for enabling status on transactions
49: ,transaction_status OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE := OKL_API.G_MISS_CHAR );
50: G_MISS_poxv_rec poxv_rec_type;
51: TYPE poxv_tbl_type IS TABLE OF poxv_rec_type
45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
46: --added by abhsaxen for Legal Entity Uptake
47: ,legal_entity_id OKL_POOL_TRANSACTIONS_V.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM
48: -- sosharma 12/03/07 Added for enabling status on transactions
49: ,transaction_status OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE := OKL_API.G_MISS_CHAR );
50: G_MISS_poxv_rec poxv_rec_type;
51: TYPE poxv_tbl_type IS TABLE OF poxv_rec_type
52: INDEX BY BINARY_INTEGER;
53: -- OKL_POOL_TRANSACTIONS Record Spec
51: TYPE poxv_tbl_type IS TABLE OF poxv_rec_type
52: INDEX BY BINARY_INTEGER;
53: -- OKL_POOL_TRANSACTIONS Record Spec
54: TYPE pox_rec_type IS RECORD (
55: id NUMBER := OKL_API.G_MISS_NUM
56: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
57: ,pol_id NUMBER := OKL_API.G_MISS_NUM
58: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
59: ,transaction_date OKL_POOL_TRANSACTIONS.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
52: INDEX BY BINARY_INTEGER;
53: -- OKL_POOL_TRANSACTIONS Record Spec
54: TYPE pox_rec_type IS RECORD (
55: id NUMBER := OKL_API.G_MISS_NUM
56: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
57: ,pol_id NUMBER := OKL_API.G_MISS_NUM
58: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
59: ,transaction_date OKL_POOL_TRANSACTIONS.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,transaction_type OKL_POOL_TRANSACTIONS.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
53: -- OKL_POOL_TRANSACTIONS Record Spec
54: TYPE pox_rec_type IS RECORD (
55: id NUMBER := OKL_API.G_MISS_NUM
56: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
57: ,pol_id NUMBER := OKL_API.G_MISS_NUM
58: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
59: ,transaction_date OKL_POOL_TRANSACTIONS.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,transaction_type OKL_POOL_TRANSACTIONS.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
61: ,transaction_sub_type OKL_POOL_TRANSACTIONS.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
54: TYPE pox_rec_type IS RECORD (
55: id NUMBER := OKL_API.G_MISS_NUM
56: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
57: ,pol_id NUMBER := OKL_API.G_MISS_NUM
58: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
59: ,transaction_date OKL_POOL_TRANSACTIONS.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,transaction_type OKL_POOL_TRANSACTIONS.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
61: ,transaction_sub_type OKL_POOL_TRANSACTIONS.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
62: ,transaction_reason OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
55: id NUMBER := OKL_API.G_MISS_NUM
56: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
57: ,pol_id NUMBER := OKL_API.G_MISS_NUM
58: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
59: ,transaction_date OKL_POOL_TRANSACTIONS.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,transaction_type OKL_POOL_TRANSACTIONS.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
61: ,transaction_sub_type OKL_POOL_TRANSACTIONS.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
62: ,transaction_reason OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
63: ,date_effective OKL_POOL_TRANSACTIONS.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
56: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
57: ,pol_id NUMBER := OKL_API.G_MISS_NUM
58: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
59: ,transaction_date OKL_POOL_TRANSACTIONS.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,transaction_type OKL_POOL_TRANSACTIONS.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
61: ,transaction_sub_type OKL_POOL_TRANSACTIONS.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
62: ,transaction_reason OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
63: ,date_effective OKL_POOL_TRANSACTIONS.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
64: ,currency_code OKL_POOL_TRANSACTIONS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
57: ,pol_id NUMBER := OKL_API.G_MISS_NUM
58: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
59: ,transaction_date OKL_POOL_TRANSACTIONS.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,transaction_type OKL_POOL_TRANSACTIONS.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
61: ,transaction_sub_type OKL_POOL_TRANSACTIONS.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
62: ,transaction_reason OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
63: ,date_effective OKL_POOL_TRANSACTIONS.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
64: ,currency_code OKL_POOL_TRANSACTIONS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_conversion_type OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
58: ,transaction_number NUMBER := OKL_API.G_MISS_NUM
59: ,transaction_date OKL_POOL_TRANSACTIONS.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,transaction_type OKL_POOL_TRANSACTIONS.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
61: ,transaction_sub_type OKL_POOL_TRANSACTIONS.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
62: ,transaction_reason OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
63: ,date_effective OKL_POOL_TRANSACTIONS.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
64: ,currency_code OKL_POOL_TRANSACTIONS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_conversion_type OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
66: ,currency_conversion_date OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,transaction_date OKL_POOL_TRANSACTIONS.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,transaction_type OKL_POOL_TRANSACTIONS.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
61: ,transaction_sub_type OKL_POOL_TRANSACTIONS.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
62: ,transaction_reason OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
63: ,date_effective OKL_POOL_TRANSACTIONS.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
64: ,currency_code OKL_POOL_TRANSACTIONS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_conversion_type OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
66: ,currency_conversion_date OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
60: ,transaction_type OKL_POOL_TRANSACTIONS.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR
61: ,transaction_sub_type OKL_POOL_TRANSACTIONS.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
62: ,transaction_reason OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
63: ,date_effective OKL_POOL_TRANSACTIONS.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
64: ,currency_code OKL_POOL_TRANSACTIONS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_conversion_type OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
66: ,currency_conversion_date OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
68: ,attribute_category OKL_POOL_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
61: ,transaction_sub_type OKL_POOL_TRANSACTIONS.TRANSACTION_SUB_TYPE%TYPE := OKL_API.G_MISS_CHAR
62: ,transaction_reason OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
63: ,date_effective OKL_POOL_TRANSACTIONS.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
64: ,currency_code OKL_POOL_TRANSACTIONS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_conversion_type OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
66: ,currency_conversion_date OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
68: ,attribute_category OKL_POOL_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_POOL_TRANSACTIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
62: ,transaction_reason OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE := OKL_API.G_MISS_CHAR
63: ,date_effective OKL_POOL_TRANSACTIONS.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
64: ,currency_code OKL_POOL_TRANSACTIONS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_conversion_type OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
66: ,currency_conversion_date OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
68: ,attribute_category OKL_POOL_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_POOL_TRANSACTIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_POOL_TRANSACTIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
63: ,date_effective OKL_POOL_TRANSACTIONS.DATE_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE
64: ,currency_code OKL_POOL_TRANSACTIONS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_conversion_type OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
66: ,currency_conversion_date OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
68: ,attribute_category OKL_POOL_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_POOL_TRANSACTIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_POOL_TRANSACTIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_POOL_TRANSACTIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
64: ,currency_code OKL_POOL_TRANSACTIONS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_conversion_type OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
66: ,currency_conversion_date OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
68: ,attribute_category OKL_POOL_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_POOL_TRANSACTIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_POOL_TRANSACTIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_POOL_TRANSACTIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_POOL_TRANSACTIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_conversion_type OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
66: ,currency_conversion_date OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
68: ,attribute_category OKL_POOL_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_POOL_TRANSACTIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_POOL_TRANSACTIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_POOL_TRANSACTIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_POOL_TRANSACTIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_POOL_TRANSACTIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
66: ,currency_conversion_date OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
68: ,attribute_category OKL_POOL_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_POOL_TRANSACTIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_POOL_TRANSACTIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_POOL_TRANSACTIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_POOL_TRANSACTIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_POOL_TRANSACTIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_POOL_TRANSACTIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
67: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
68: ,attribute_category OKL_POOL_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_POOL_TRANSACTIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_POOL_TRANSACTIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_POOL_TRANSACTIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_POOL_TRANSACTIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_POOL_TRANSACTIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_POOL_TRANSACTIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_POOL_TRANSACTIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute_category OKL_POOL_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_POOL_TRANSACTIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_POOL_TRANSACTIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_POOL_TRANSACTIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_POOL_TRANSACTIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_POOL_TRANSACTIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_POOL_TRANSACTIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_POOL_TRANSACTIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_POOL_TRANSACTIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_POOL_TRANSACTIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_POOL_TRANSACTIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_POOL_TRANSACTIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_POOL_TRANSACTIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_POOL_TRANSACTIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_POOL_TRANSACTIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_POOL_TRANSACTIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_POOL_TRANSACTIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_POOL_TRANSACTIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_POOL_TRANSACTIONS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_POOL_TRANSACTIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_POOL_TRANSACTIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_POOL_TRANSACTIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_POOL_TRANSACTIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_POOL_TRANSACTIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_POOL_TRANSACTIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_POOL_TRANSACTIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_POOL_TRANSACTIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_POOL_TRANSACTIONS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_POOL_TRANSACTIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_POOL_TRANSACTIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_POOL_TRANSACTIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_POOL_TRANSACTIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_POOL_TRANSACTIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_POOL_TRANSACTIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_POOL_TRANSACTIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_POOL_TRANSACTIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_POOL_TRANSACTIONS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_POOL_TRANSACTIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_POOL_TRANSACTIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_POOL_TRANSACTIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_POOL_TRANSACTIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_POOL_TRANSACTIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_POOL_TRANSACTIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_POOL_TRANSACTIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_POOL_TRANSACTIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_POOL_TRANSACTIONS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_POOL_TRANSACTIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_POOL_TRANSACTIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_POOL_TRANSACTIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_POOL_TRANSACTIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_POOL_TRANSACTIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_POOL_TRANSACTIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_POOL_TRANSACTIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_POOL_TRANSACTIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_POOL_TRANSACTIONS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_POOL_TRANSACTIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_POOL_TRANSACTIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_POOL_TRANSACTIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_POOL_TRANSACTIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_POOL_TRANSACTIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_POOL_TRANSACTIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_POOL_TRANSACTIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_POOL_TRANSACTIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_POOL_TRANSACTIONS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_POOL_TRANSACTIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_POOL_TRANSACTIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_POOL_TRANSACTIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_POOL_TRANSACTIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_POOL_TRANSACTIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_POOL_TRANSACTIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_POOL_TRANSACTIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_POOL_TRANSACTIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_POOL_TRANSACTIONS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_POOL_TRANSACTIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_POOL_TRANSACTIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_POOL_TRANSACTIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_POOL_TRANSACTIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_POOL_TRANSACTIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_POOL_TRANSACTIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_POOL_TRANSACTIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,request_id NUMBER := OKL_API.G_MISS_NUM
77: ,attribute9 OKL_POOL_TRANSACTIONS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_POOL_TRANSACTIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_POOL_TRANSACTIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_POOL_TRANSACTIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_POOL_TRANSACTIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_POOL_TRANSACTIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_POOL_TRANSACTIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,request_id NUMBER := OKL_API.G_MISS_NUM
85: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
78: ,attribute10 OKL_POOL_TRANSACTIONS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_POOL_TRANSACTIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_POOL_TRANSACTIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_POOL_TRANSACTIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_POOL_TRANSACTIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_POOL_TRANSACTIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,request_id NUMBER := OKL_API.G_MISS_NUM
85: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
86: ,program_id NUMBER := OKL_API.G_MISS_NUM
79: ,attribute11 OKL_POOL_TRANSACTIONS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_POOL_TRANSACTIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_POOL_TRANSACTIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_POOL_TRANSACTIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_POOL_TRANSACTIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,request_id NUMBER := OKL_API.G_MISS_NUM
85: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
86: ,program_id NUMBER := OKL_API.G_MISS_NUM
87: ,program_update_date OKL_POOL_TRANSACTIONS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
80: ,attribute12 OKL_POOL_TRANSACTIONS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_POOL_TRANSACTIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_POOL_TRANSACTIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_POOL_TRANSACTIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,request_id NUMBER := OKL_API.G_MISS_NUM
85: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
86: ,program_id NUMBER := OKL_API.G_MISS_NUM
87: ,program_update_date OKL_POOL_TRANSACTIONS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
81: ,attribute13 OKL_POOL_TRANSACTIONS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_POOL_TRANSACTIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_POOL_TRANSACTIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,request_id NUMBER := OKL_API.G_MISS_NUM
85: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
86: ,program_id NUMBER := OKL_API.G_MISS_NUM
87: ,program_update_date OKL_POOL_TRANSACTIONS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_POOL_TRANSACTIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
82: ,attribute14 OKL_POOL_TRANSACTIONS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_POOL_TRANSACTIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,request_id NUMBER := OKL_API.G_MISS_NUM
85: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
86: ,program_id NUMBER := OKL_API.G_MISS_NUM
87: ,program_update_date OKL_POOL_TRANSACTIONS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_POOL_TRANSACTIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
83: ,attribute15 OKL_POOL_TRANSACTIONS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,request_id NUMBER := OKL_API.G_MISS_NUM
85: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
86: ,program_id NUMBER := OKL_API.G_MISS_NUM
87: ,program_update_date OKL_POOL_TRANSACTIONS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_POOL_TRANSACTIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91: ,last_update_date OKL_POOL_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
84: ,request_id NUMBER := OKL_API.G_MISS_NUM
85: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
86: ,program_id NUMBER := OKL_API.G_MISS_NUM
87: ,program_update_date OKL_POOL_TRANSACTIONS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_POOL_TRANSACTIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91: ,last_update_date OKL_POOL_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
85: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
86: ,program_id NUMBER := OKL_API.G_MISS_NUM
87: ,program_update_date OKL_POOL_TRANSACTIONS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_POOL_TRANSACTIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91: ,last_update_date OKL_POOL_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
93: --added by abhsaxen for Legal Entity Uptake
86: ,program_id NUMBER := OKL_API.G_MISS_NUM
87: ,program_update_date OKL_POOL_TRANSACTIONS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_POOL_TRANSACTIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91: ,last_update_date OKL_POOL_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
93: --added by abhsaxen for Legal Entity Uptake
94: ,legal_entity_id OKL_POOL_TRANSACTIONS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM
87: ,program_update_date OKL_POOL_TRANSACTIONS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_POOL_TRANSACTIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91: ,last_update_date OKL_POOL_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
93: --added by abhsaxen for Legal Entity Uptake
94: ,legal_entity_id OKL_POOL_TRANSACTIONS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM
95: -- sosharma 12/03/07 Added for enabling status on transactions
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_POOL_TRANSACTIONS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91: ,last_update_date OKL_POOL_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
93: --added by abhsaxen for Legal Entity Uptake
94: ,legal_entity_id OKL_POOL_TRANSACTIONS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM
95: -- sosharma 12/03/07 Added for enabling status on transactions
96: ,transaction_status OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE := OKL_API.G_MISS_CHAR );
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91: ,last_update_date OKL_POOL_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
93: --added by abhsaxen for Legal Entity Uptake
94: ,legal_entity_id OKL_POOL_TRANSACTIONS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM
95: -- sosharma 12/03/07 Added for enabling status on transactions
96: ,transaction_status OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE := OKL_API.G_MISS_CHAR );
97: G_MISS_pox_rec pox_rec_type;
98: TYPE pox_tbl_type IS TABLE OF pox_rec_type
92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
93: --added by abhsaxen for Legal Entity Uptake
94: ,legal_entity_id OKL_POOL_TRANSACTIONS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM
95: -- sosharma 12/03/07 Added for enabling status on transactions
96: ,transaction_status OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE := OKL_API.G_MISS_CHAR );
97: G_MISS_pox_rec pox_rec_type;
98: TYPE pox_tbl_type IS TABLE OF pox_rec_type
99: INDEX BY BINARY_INTEGER;
100: ---------------------------------------------------------------------------
99: INDEX BY BINARY_INTEGER;
100: ---------------------------------------------------------------------------
101: -- GLOBAL MESSAGE CONSTANTS
102: ---------------------------------------------------------------------------
103: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
104: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
105: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
106: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
107: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
100: ---------------------------------------------------------------------------
101: -- GLOBAL MESSAGE CONSTANTS
102: ---------------------------------------------------------------------------
103: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
104: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
105: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
106: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
107: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
101: -- GLOBAL MESSAGE CONSTANTS
102: ---------------------------------------------------------------------------
103: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
104: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
105: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
106: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
107: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
109: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
102: ---------------------------------------------------------------------------
103: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
104: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
105: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
106: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
107: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
109: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
110: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
103: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
104: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
105: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
106: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
107: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
109: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
110: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
111: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
104: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
105: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
106: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
107: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
109: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
110: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
111: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
112: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
105: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
106: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
107: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
109: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
110: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
111: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
112: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
113: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
106: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
107: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
109: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
110: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
111: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
112: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
113: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
114: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
107: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
109: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
110: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
111: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
112: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
113: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
114: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
115: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
109: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
110: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
111: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
112: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
113: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
114: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
115: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
116: -- mvasudev, 11/08/2002
113: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
114: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
115: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
116: -- mvasudev, 11/08/2002
117: G_OKC_APP CONSTANT VARCHAR2(200) := OKL_API.G_APP_NAME;
118: G_OKL_UNQS CONSTANT VARCHAR2(200) := 'OKL_POX_NOT_UNIQUE';
119: ---------------------------------------------------------------------------
120: -- GLOBAL EXCEPTIONS
121: ---------------------------------------------------------------------------
124: ---------------------------------------------------------------------------
125: -- GLOBAL VARIABLES
126: ---------------------------------------------------------------------------
127: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_POX_PVT';
128: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
129: ---------------------------------------------------------------------------
130: -- Procedures and Functions
131: ---------------------------------------------------------------------------
132:
134: PROCEDURE change_version;
135: PROCEDURE api_copy;
136: PROCEDURE insert_row(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_poxv_rec IN poxv_rec_type,
142: p_poxv_rec IN poxv_rec_type,
143: x_poxv_rec OUT NOCOPY poxv_rec_type);
144: PROCEDURE insert_row(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_poxv_tbl IN poxv_tbl_type,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_poxv_tbl IN poxv_tbl_type,
151: x_poxv_tbl OUT NOCOPY poxv_tbl_type,
152: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
153: PROCEDURE insert_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
151: x_poxv_tbl OUT NOCOPY poxv_tbl_type,
152: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
153: PROCEDURE insert_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_poxv_tbl IN poxv_tbl_type,
159: p_poxv_tbl IN poxv_tbl_type,
160: x_poxv_tbl OUT NOCOPY poxv_tbl_type);
161: PROCEDURE lock_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_poxv_rec IN poxv_rec_type);
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_poxv_rec IN poxv_rec_type);
168: PROCEDURE lock_row(
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_poxv_tbl IN poxv_tbl_type,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_poxv_tbl IN poxv_tbl_type,
175: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
176: PROCEDURE lock_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
174: p_poxv_tbl IN poxv_tbl_type,
175: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
176: PROCEDURE lock_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_poxv_tbl IN poxv_tbl_type);
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_poxv_tbl IN poxv_tbl_type);
183: PROCEDURE update_row(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_poxv_rec IN poxv_rec_type,
189: p_poxv_rec IN poxv_rec_type,
190: x_poxv_rec OUT NOCOPY poxv_rec_type);
191: PROCEDURE update_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_poxv_tbl IN poxv_tbl_type,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_poxv_tbl IN poxv_tbl_type,
198: x_poxv_tbl OUT NOCOPY poxv_tbl_type,
199: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
200: PROCEDURE update_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
198: x_poxv_tbl OUT NOCOPY poxv_tbl_type,
199: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
200: PROCEDURE update_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_poxv_tbl IN poxv_tbl_type,
206: p_poxv_tbl IN poxv_tbl_type,
207: x_poxv_tbl OUT NOCOPY poxv_tbl_type);
208: PROCEDURE delete_row(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_poxv_rec IN poxv_rec_type);
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_poxv_rec IN poxv_rec_type);
215: PROCEDURE delete_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_poxv_tbl IN poxv_tbl_type,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_poxv_tbl IN poxv_tbl_type,
222: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
223: PROCEDURE delete_row(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
221: p_poxv_tbl IN poxv_tbl_type,
222: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
223: PROCEDURE delete_row(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_poxv_tbl IN poxv_tbl_type);
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_poxv_tbl IN poxv_tbl_type);
230: PROCEDURE validate_row(
231: p_api_version IN NUMBER,
232: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
236: p_poxv_rec IN poxv_rec_type);
235: x_msg_data OUT NOCOPY VARCHAR2,
236: p_poxv_rec IN poxv_rec_type);
237: PROCEDURE validate_row(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_poxv_tbl IN poxv_tbl_type,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_poxv_tbl IN poxv_tbl_type,
244: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
245: PROCEDURE validate_row(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
248: x_return_status OUT NOCOPY VARCHAR2,
243: p_poxv_tbl IN poxv_tbl_type,
244: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
245: PROCEDURE validate_row(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_poxv_tbl IN poxv_tbl_type);