2: /* $Header: OKLSPOXS.pls 120.4 2007/12/07 09:05:40 sosharma noship $ */
3: ---------------------------------------------------------------------------
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: ---------------------------------------------------------------------------