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_POL_PVT dependencies on OKL_POOLS

Line 6: -- OKL_POOLS_V Record Spec

2: /* $Header: OKLSPOLS.pls 120.4 2006/11/20 05:42:30 abhsaxen noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_POOLS_V Record Spec
7: TYPE polv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,pot_id NUMBER := OKL_API.G_MISS_NUM

Line 12: ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR

8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,pot_id NUMBER := OKL_API.G_MISS_NUM
11: ,khr_id NUMBER := OKL_API.G_MISS_NUM
12: ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
13: ,description OKL_POOLS.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM

Line 13: ,description OKL_POOLS.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,pot_id NUMBER := OKL_API.G_MISS_NUM
11: ,khr_id NUMBER := OKL_API.G_MISS_NUM
12: ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
13: ,description OKL_POOLS.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
17: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM

Line 14: ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

10: ,pot_id NUMBER := OKL_API.G_MISS_NUM
11: ,khr_id NUMBER := OKL_API.G_MISS_NUM
12: ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
13: ,description OKL_POOLS.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
17: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
18: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR

Line 15: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

11: ,khr_id NUMBER := OKL_API.G_MISS_NUM
12: ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
13: ,description OKL_POOLS.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
17: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
18: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
19: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE

Line 18: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR

14: ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
17: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
18: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
19: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
20: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
21: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
22: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE

Line 19: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE

15: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
17: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
18: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
19: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
20: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
21: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
22: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
23: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 20: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE

16: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
17: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
18: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
19: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
20: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
21: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
22: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
23: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR

Line 21: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE

17: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
18: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
19: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
20: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
21: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
22: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
23: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 22: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE

18: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
19: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
20: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
21: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
22: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
23: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 23: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR

19: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
20: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
21: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
22: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
23: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 24: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR

20: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
21: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
22: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
23: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 25: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

21: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
22: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
23: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 26: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

22: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
23: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 27: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

23: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 28: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

24: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 29: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

25: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

Line 30: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

26: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

Line 31: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

27: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

Line 32: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

28: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

Line 33: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

29: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

Line 34: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

30: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

Line 35: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

31: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

Line 36: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

32: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

Line 37: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

33: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41: ,org_id NUMBER := OKL_API.G_MISS_NUM

Line 38: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

34: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41: ,org_id NUMBER := OKL_API.G_MISS_NUM
42: ,request_id NUMBER := OKL_API.G_MISS_NUM

Line 39: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

35: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41: ,org_id NUMBER := OKL_API.G_MISS_NUM
42: ,request_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 40: ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

36: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41: ,org_id NUMBER := OKL_API.G_MISS_NUM
42: ,request_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 45: ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

41: ,org_id NUMBER := OKL_API.G_MISS_NUM
42: ,request_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_id NUMBER := OKL_API.G_MISS_NUM
45: ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,created_by NUMBER := OKL_API.G_MISS_NUM
47: ,creation_date OKL_POOLS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
49: ,last_update_date OKL_POOLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 47: ,creation_date OKL_POOLS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_id NUMBER := OKL_API.G_MISS_NUM
45: ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,created_by NUMBER := OKL_API.G_MISS_NUM
47: ,creation_date OKL_POOLS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
49: ,last_update_date OKL_POOLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
50: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
51: --added by abshaxen for legal entity uptake

Line 49: ,last_update_date OKL_POOLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

45: ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,created_by NUMBER := OKL_API.G_MISS_NUM
47: ,creation_date OKL_POOLS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
49: ,last_update_date OKL_POOLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
50: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
51: --added by abshaxen for legal entity uptake
52: ,legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE :=OKL_API.G_MISS_NUM);
53: G_MISS_polv_rec polv_rec_type;

Line 52: ,legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE :=OKL_API.G_MISS_NUM);

48: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
49: ,last_update_date OKL_POOLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
50: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
51: --added by abshaxen for legal entity uptake
52: ,legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE :=OKL_API.G_MISS_NUM);
53: G_MISS_polv_rec polv_rec_type;
54: TYPE polv_tbl_type IS TABLE OF polv_rec_type
55: INDEX BY BINARY_INTEGER;
56: -- OKL_POOLS Record Spec

Line 56: -- OKL_POOLS Record Spec

52: ,legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE :=OKL_API.G_MISS_NUM);
53: G_MISS_polv_rec polv_rec_type;
54: TYPE polv_tbl_type IS TABLE OF polv_rec_type
55: INDEX BY BINARY_INTEGER;
56: -- OKL_POOLS Record Spec
57: TYPE pol_rec_type IS RECORD (
58: id NUMBER := OKL_API.G_MISS_NUM
59: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
60: ,pot_id NUMBER := OKL_API.G_MISS_NUM

Line 62: ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR

58: id NUMBER := OKL_API.G_MISS_NUM
59: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
60: ,pot_id NUMBER := OKL_API.G_MISS_NUM
61: ,khr_id NUMBER := OKL_API.G_MISS_NUM
62: ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
63: ,description OKL_POOLS.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
64: ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
66: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM

Line 63: ,description OKL_POOLS.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

59: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
60: ,pot_id NUMBER := OKL_API.G_MISS_NUM
61: ,khr_id NUMBER := OKL_API.G_MISS_NUM
62: ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
63: ,description OKL_POOLS.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
64: ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
66: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
67: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM

Line 64: ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

60: ,pot_id NUMBER := OKL_API.G_MISS_NUM
61: ,khr_id NUMBER := OKL_API.G_MISS_NUM
62: ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
63: ,description OKL_POOLS.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
64: ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
66: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
67: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
68: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR

Line 65: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

61: ,khr_id NUMBER := OKL_API.G_MISS_NUM
62: ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
63: ,description OKL_POOLS.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
64: ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
66: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
67: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
68: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
69: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE

Line 68: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR

64: ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
65: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
66: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
67: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
68: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
69: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
70: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
71: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE

Line 69: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE

65: ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
66: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
67: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
68: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
69: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
70: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
71: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
73: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE

Line 70: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE

66: ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
67: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
68: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
69: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
70: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
71: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
73: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
74: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR

Line 71: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR

67: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
68: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
69: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
70: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
71: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
73: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
74: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 72: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE

68: ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
69: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
70: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
71: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
73: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
74: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 73: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE

69: ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
70: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
71: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
73: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
74: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 74: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR

70: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
71: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
73: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
74: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 75: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

71: ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
73: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
74: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 76: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

72: ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
73: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
74: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 77: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

73: ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
74: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 78: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

74: ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 79: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

75: ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

Line 80: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

76: ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

Line 81: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

77: ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

Line 82: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

78: ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

Line 83: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

79: ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

Line 84: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

80: ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

Line 85: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

81: ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

Line 86: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

82: ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

Line 87: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

83: ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
91: ,org_id NUMBER := OKL_API.G_MISS_NUM

Line 88: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

84: ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
91: ,org_id NUMBER := OKL_API.G_MISS_NUM
92: ,request_id NUMBER := OKL_API.G_MISS_NUM

Line 89: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

85: ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
91: ,org_id NUMBER := OKL_API.G_MISS_NUM
92: ,request_id NUMBER := OKL_API.G_MISS_NUM
93: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 90: ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

86: ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
91: ,org_id NUMBER := OKL_API.G_MISS_NUM
92: ,request_id NUMBER := OKL_API.G_MISS_NUM
93: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
94: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 95: ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

91: ,org_id NUMBER := OKL_API.G_MISS_NUM
92: ,request_id NUMBER := OKL_API.G_MISS_NUM
93: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
94: ,program_id NUMBER := OKL_API.G_MISS_NUM
95: ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
96: ,created_by NUMBER := OKL_API.G_MISS_NUM
97: ,creation_date OKL_POOLS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
98: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
99: ,last_update_date OKL_POOLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 97: ,creation_date OKL_POOLS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

93: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
94: ,program_id NUMBER := OKL_API.G_MISS_NUM
95: ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
96: ,created_by NUMBER := OKL_API.G_MISS_NUM
97: ,creation_date OKL_POOLS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
98: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
99: ,last_update_date OKL_POOLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
101: --added by abshaxen for legal entity uptake

Line 99: ,last_update_date OKL_POOLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

95: ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
96: ,created_by NUMBER := OKL_API.G_MISS_NUM
97: ,creation_date OKL_POOLS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
98: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
99: ,last_update_date OKL_POOLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
101: --added by abshaxen for legal entity uptake
102: ,legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE :=OKL_API.G_MISS_NUM);
103: G_MISS_pol_rec pol_rec_type;

Line 102: ,legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE :=OKL_API.G_MISS_NUM);

98: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
99: ,last_update_date OKL_POOLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
101: --added by abshaxen for legal entity uptake
102: ,legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE :=OKL_API.G_MISS_NUM);
103: G_MISS_pol_rec pol_rec_type;
104: TYPE pol_tbl_type IS TABLE OF pol_rec_type
105: INDEX BY BINARY_INTEGER;
106: ---------------------------------------------------------------------------