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_API

Line 8: id NUMBER := OKL_API.G_MISS_NUM

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
11: ,khr_id NUMBER := OKL_API.G_MISS_NUM
12: ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR

Line 9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

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

Line 10: ,pot_id NUMBER := OKL_API.G_MISS_NUM

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

Line 11: ,khr_id NUMBER := OKL_API.G_MISS_NUM

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

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 16: ,total_principal_amount 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
20: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE

Line 17: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM

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

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 41: ,org_id NUMBER := OKL_API.G_MISS_NUM

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
45: ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 42: ,request_id NUMBER := OKL_API.G_MISS_NUM

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
45: ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

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

Line 44: ,program_id NUMBER := OKL_API.G_MISS_NUM

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

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 46: ,created_by 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
50: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

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 48: ,last_updated_by 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
52: ,legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE :=OKL_API.G_MISS_NUM);

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 50: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

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;
54: TYPE polv_tbl_type IS TABLE OF 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 58: id NUMBER := OKL_API.G_MISS_NUM

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
61: ,khr_id NUMBER := OKL_API.G_MISS_NUM
62: ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR

Line 59: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

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

Line 60: ,pot_id NUMBER := OKL_API.G_MISS_NUM

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

Line 61: ,khr_id NUMBER := OKL_API.G_MISS_NUM

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

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 66: ,total_principal_amount 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
70: ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE

Line 67: ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM

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

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 91: ,org_id NUMBER := OKL_API.G_MISS_NUM

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
95: ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 92: ,request_id NUMBER := OKL_API.G_MISS_NUM

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
95: ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
96: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 93: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

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

Line 94: ,program_id NUMBER := OKL_API.G_MISS_NUM

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

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 96: ,created_by 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
100: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

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 98: ,last_updated_by 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
102: ,legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE :=OKL_API.G_MISS_NUM);

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 100: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

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;
104: TYPE pol_tbl_type IS TABLE OF 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: ---------------------------------------------------------------------------

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

105: INDEX BY BINARY_INTEGER;
106: ---------------------------------------------------------------------------
107: -- GLOBAL MESSAGE CONSTANTS
108: ---------------------------------------------------------------------------
109: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
110: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

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

106: ---------------------------------------------------------------------------
107: -- GLOBAL MESSAGE CONSTANTS
108: ---------------------------------------------------------------------------
109: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
110: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

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

107: -- GLOBAL MESSAGE CONSTANTS
108: ---------------------------------------------------------------------------
109: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
110: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

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

108: ---------------------------------------------------------------------------
109: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
110: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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

109: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
110: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
117: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

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

110: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
117: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
118: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

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

111: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
117: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
118: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
119: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

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

112: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
117: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
118: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
119: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
120: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

113: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
117: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
118: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
119: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
120: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
121: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

114: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
115: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
116: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
117: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
118: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
119: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
120: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
121: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
122:

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

120: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
121: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
122:
123: -- mvasudev, 11/08/2002
124: G_OKC_APP CONSTANT VARCHAR2(200) := OKL_API.G_APP_NAME;
125: G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
126: G_OKL_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
127: G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
128: G_OKL_UNQS CONSTANT VARCHAR2(200) := 'OKL_POL_NOT_UNIQUE';

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

139: ---------------------------------------------------------------------------
140: -- GLOBAL VARIABLES
141: ---------------------------------------------------------------------------
142: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_POL_PVT';
143: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
144: ---------------------------------------------------------------------------
145: -- Procedures and Functions
146: ---------------------------------------------------------------------------
147:

Line 153: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

149: PROCEDURE change_version;
150: PROCEDURE api_copy;
151: PROCEDURE insert_row(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_polv_rec IN polv_rec_type,

Line 161: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

157: p_polv_rec IN polv_rec_type,
158: x_polv_rec OUT NOCOPY polv_rec_type);
159: PROCEDURE insert_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_polv_tbl IN polv_tbl_type,

Line 167: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_polv_tbl IN polv_tbl_type,
166: x_polv_tbl OUT NOCOPY polv_tbl_type,
167: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
168: PROCEDURE insert_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,

Line 170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

166: x_polv_tbl OUT NOCOPY polv_tbl_type,
167: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
168: PROCEDURE insert_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_polv_tbl IN polv_tbl_type,

Line 178: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

174: p_polv_tbl IN polv_tbl_type,
175: x_polv_tbl OUT NOCOPY polv_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_polv_rec IN polv_rec_type);

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_polv_rec IN polv_rec_type);
183: PROCEDURE lock_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_polv_tbl IN polv_tbl_type,

Line 190: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_polv_tbl IN polv_tbl_type,
190: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
191: PROCEDURE lock_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,

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

189: p_polv_tbl IN polv_tbl_type,
190: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
191: PROCEDURE lock_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_polv_tbl IN polv_tbl_type);

Line 200: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_polv_tbl IN polv_tbl_type);
198: PROCEDURE update_row(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_polv_rec IN polv_rec_type,

Line 208: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

204: p_polv_rec IN polv_rec_type,
205: x_polv_rec OUT NOCOPY polv_rec_type);
206: PROCEDURE update_row(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_polv_tbl IN polv_tbl_type,

Line 214: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_polv_tbl IN polv_tbl_type,
213: x_polv_tbl OUT NOCOPY polv_tbl_type,
214: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
215: PROCEDURE update_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,

Line 217: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

213: x_polv_tbl OUT NOCOPY polv_tbl_type,
214: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
215: PROCEDURE update_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_polv_tbl IN polv_tbl_type,

Line 225: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

221: p_polv_tbl IN polv_tbl_type,
222: x_polv_tbl OUT NOCOPY polv_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_polv_rec IN polv_rec_type);

Line 232: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_polv_rec IN polv_rec_type);
230: PROCEDURE delete_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_polv_tbl IN polv_tbl_type,

Line 237: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
236: p_polv_tbl IN polv_tbl_type,
237: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
238: PROCEDURE delete_row(
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
241: x_return_status OUT NOCOPY VARCHAR2,

Line 240: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

236: p_polv_tbl IN polv_tbl_type,
237: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
238: PROCEDURE delete_row(
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,
244: p_polv_tbl IN polv_tbl_type);

Line 247: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

243: x_msg_data OUT NOCOPY VARCHAR2,
244: p_polv_tbl IN polv_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_polv_rec IN polv_rec_type);

Line 254: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_polv_rec IN polv_rec_type);
252: PROCEDURE validate_row(
253: p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_polv_tbl IN polv_tbl_type,

Line 259: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_polv_tbl IN polv_tbl_type,
259: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
260: PROCEDURE validate_row(
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
263: x_return_status OUT NOCOPY VARCHAR2,

Line 262: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

258: p_polv_tbl IN polv_tbl_type,
259: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
260: PROCEDURE validate_row(
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
266: p_polv_tbl IN polv_tbl_type);