eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_POX_PVT dependencies on OKL_API

Line 8: id NUMBER := OKL_API.G_MISS_NUM

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

Line 9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

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

Line 10: ,pol_id NUMBER := OKL_API.G_MISS_NUM

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

Line 11: ,transaction_number NUMBER := OKL_API.G_MISS_NUM

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

Line 12: ,transaction_date OKL_POOL_TRANSACTIONS_V.TRANSACTION_DATE%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

Line 13: ,transaction_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_TYPE%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

Line 14: ,transaction_sub_type OKL_POOL_TRANSACTIONS_V.TRANSACTION_SUB_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

Line 15: ,date_effective OKL_POOL_TRANSACTIONS_V.DATE_EFFECTIVE%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

Line 16: ,currency_code OKL_POOL_TRANSACTIONS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

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

Line 17: ,currency_conversion_type OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_TYPE%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

Line 18: ,currency_conversion_date OKL_POOL_TRANSACTIONS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 19: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM

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

Line 20: ,transaction_reason OKL_POOL_TRANSACTIONS_V.TRANSACTION_REASON%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

Line 21: ,attribute_category OKL_POOL_TRANSACTIONS_V.ATTRIBUTE_CATEGORY%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

Line 22: ,attribute1 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE1%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

Line 23: ,attribute2 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE2%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

Line 24: ,attribute3 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE3%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

Line 25: ,attribute4 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE4%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

Line 26: ,attribute5 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE5%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

Line 27: ,attribute6 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE6%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

Line 28: ,attribute7 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE7%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

Line 29: ,attribute8 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE8%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

Line 30: ,attribute9 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE9%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

Line 31: ,attribute10 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE10%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

Line 32: ,attribute11 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE11%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

Line 33: ,attribute12 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE12%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

Line 34: ,attribute13 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE13%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
38: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 35: ,attribute14 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE14%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
39: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 36: ,attribute15 OKL_POOL_TRANSACTIONS_V.ATTRIBUTE15%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
40: ,program_update_date OKL_POOL_TRANSACTIONS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 37: ,request_id NUMBER := OKL_API.G_MISS_NUM

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

Line 38: ,program_application_id 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

Line 39: ,program_id NUMBER := OKL_API.G_MISS_NUM

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

Line 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

Line 41: ,created_by NUMBER := OKL_API.G_MISS_NUM

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

Line 42: ,creation_date OKL_POOL_TRANSACTIONS_V.CREATION_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

Line 43: ,last_updated_by 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
47: ,legal_entity_id OKL_POOL_TRANSACTIONS_V.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM

Line 44: ,last_update_date OKL_POOL_TRANSACTIONS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

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 );

Line 47: ,legal_entity_id OKL_POOL_TRANSACTIONS_V.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM

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

Line 49: ,transaction_status OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE := OKL_API.G_MISS_CHAR );

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

Line 55: id NUMBER := OKL_API.G_MISS_NUM

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

Line 56: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

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

Line 57: ,pol_id NUMBER := OKL_API.G_MISS_NUM

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

Line 58: ,transaction_number NUMBER := OKL_API.G_MISS_NUM

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

Line 59: ,transaction_date OKL_POOL_TRANSACTIONS.TRANSACTION_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 60: ,transaction_type OKL_POOL_TRANSACTIONS.TRANSACTION_TYPE%TYPE := OKL_API.G_MISS_CHAR

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

Line 61: ,transaction_sub_type OKL_POOL_TRANSACTIONS.TRANSACTION_SUB_TYPE%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

Line 62: ,transaction_reason OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%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

Line 63: ,date_effective OKL_POOL_TRANSACTIONS.DATE_EFFECTIVE%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

Line 64: ,currency_code OKL_POOL_TRANSACTIONS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

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

Line 65: ,currency_conversion_type OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_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
69: ,attribute1 OKL_POOL_TRANSACTIONS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 66: ,currency_conversion_date OKL_POOL_TRANSACTIONS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 67: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM

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

Line 68: ,attribute_category OKL_POOL_TRANSACTIONS.ATTRIBUTE_CATEGORY%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

Line 69: ,attribute1 OKL_POOL_TRANSACTIONS.ATTRIBUTE1%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

Line 70: ,attribute2 OKL_POOL_TRANSACTIONS.ATTRIBUTE2%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

Line 71: ,attribute3 OKL_POOL_TRANSACTIONS.ATTRIBUTE3%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

Line 72: ,attribute4 OKL_POOL_TRANSACTIONS.ATTRIBUTE4%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

Line 73: ,attribute5 OKL_POOL_TRANSACTIONS.ATTRIBUTE5%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

Line 74: ,attribute6 OKL_POOL_TRANSACTIONS.ATTRIBUTE6%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

Line 75: ,attribute7 OKL_POOL_TRANSACTIONS.ATTRIBUTE7%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

Line 76: ,attribute8 OKL_POOL_TRANSACTIONS.ATTRIBUTE8%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

Line 77: ,attribute9 OKL_POOL_TRANSACTIONS.ATTRIBUTE9%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

Line 78: ,attribute10 OKL_POOL_TRANSACTIONS.ATTRIBUTE10%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

Line 79: ,attribute11 OKL_POOL_TRANSACTIONS.ATTRIBUTE11%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

Line 80: ,attribute12 OKL_POOL_TRANSACTIONS.ATTRIBUTE12%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

Line 81: ,attribute13 OKL_POOL_TRANSACTIONS.ATTRIBUTE13%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
85: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 82: ,attribute14 OKL_POOL_TRANSACTIONS.ATTRIBUTE14%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
86: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 83: ,attribute15 OKL_POOL_TRANSACTIONS.ATTRIBUTE15%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
87: ,program_update_date OKL_POOL_TRANSACTIONS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 84: ,request_id NUMBER := OKL_API.G_MISS_NUM

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

Line 85: ,program_application_id 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

Line 86: ,program_id NUMBER := OKL_API.G_MISS_NUM

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

Line 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

Line 88: ,created_by NUMBER := OKL_API.G_MISS_NUM

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

Line 89: ,creation_date OKL_POOL_TRANSACTIONS.CREATION_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

Line 90: ,last_updated_by 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
94: ,legal_entity_id OKL_POOL_TRANSACTIONS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM

Line 91: ,last_update_date OKL_POOL_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

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 );

Line 94: ,legal_entity_id OKL_POOL_TRANSACTIONS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM

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

Line 96: ,transaction_status OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE := OKL_API.G_MISS_CHAR );

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: ---------------------------------------------------------------------------

Line 103: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

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;

Line 104: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

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;

Line 105: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

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;

Line 106: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

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;

Line 107: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

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;

Line 108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

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;

Line 109: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

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';

Line 110: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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';

Line 111: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

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';

Line 112: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

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

Line 117: G_OKC_APP CONSTANT VARCHAR2(200) := OKL_API.G_APP_NAME;

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: ---------------------------------------------------------------------------

Line 128: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

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:

Line 138: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 146: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 152: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_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,

Line 155: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 163: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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);

Line 170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 175: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_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,

Line 178: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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);

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 199: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_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,

Line 202: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 210: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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);

Line 217: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 222: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_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,

Line 225: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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);

Line 232: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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);

Line 239: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 244: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_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,

Line 247: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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);