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_TRQ_PVT dependencies on OKL_API

Line 9: id NUMBER := OKL_API.G_MISS_NUM

5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: -- OKL_TRX_REQUESTS_V Record Spec
8: TYPE trqv_rec_type IS RECORD (
9: id NUMBER := OKL_API.G_MISS_NUM
10: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
11: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM

Line 10: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR

6: ---------------------------------------------------------------------------
7: -- OKL_TRX_REQUESTS_V Record Spec
8: TYPE trqv_rec_type IS RECORD (
9: id NUMBER := OKL_API.G_MISS_NUM
10: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
11: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
14: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 11: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR

7: -- OKL_TRX_REQUESTS_V Record Spec
8: TYPE trqv_rec_type IS RECORD (
9: id NUMBER := OKL_API.G_MISS_NUM
10: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
11: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
14: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 12: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR

8: TYPE trqv_rec_type IS RECORD (
9: id NUMBER := OKL_API.G_MISS_NUM
10: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
11: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
14: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE

Line 13: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM

9: id NUMBER := OKL_API.G_MISS_NUM
10: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
11: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
14: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE

Line 14: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR

10: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
11: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
14: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,term_duration NUMBER := OKL_API.G_MISS_NUM

Line 15: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR

11: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
14: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,term_duration NUMBER := OKL_API.G_MISS_NUM
19: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM

Line 16: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE

12: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
14: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,term_duration NUMBER := OKL_API.G_MISS_NUM
19: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
20: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 17: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE

13: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
14: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,term_duration NUMBER := OKL_API.G_MISS_NUM
19: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
20: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
21: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR

Line 18: ,term_duration NUMBER := OKL_API.G_MISS_NUM

14: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,term_duration NUMBER := OKL_API.G_MISS_NUM
19: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
20: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
21: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
22: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR

Line 19: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM

15: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
16: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,term_duration NUMBER := OKL_API.G_MISS_NUM
19: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
20: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
21: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
22: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
23: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

Line 20: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

16: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,term_duration NUMBER := OKL_API.G_MISS_NUM
19: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
20: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
21: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
22: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
23: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
24: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 21: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR

17: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,term_duration NUMBER := OKL_API.G_MISS_NUM
19: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
20: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
21: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
22: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
23: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
24: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 22: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR

18: ,term_duration NUMBER := OKL_API.G_MISS_NUM
19: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
20: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
21: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
22: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
23: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
24: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 23: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

19: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
20: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
21: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
22: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
23: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
24: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 24: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

20: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
21: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
22: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
23: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
24: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 25: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

21: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
22: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
23: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
24: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 26: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

22: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
23: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
24: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 27: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

23: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
24: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 28: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

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

Line 29: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

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

Line 30: ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

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

Line 31: ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

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

Line 32: ,attribute8 OKL_TRX_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

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

Line 33: ,attribute9 OKL_TRX_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

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

Line 34: ,attribute10 OKL_TRX_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

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

Line 35: ,attribute11 OKL_TRX_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

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

Line 36: ,attribute12 OKL_TRX_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

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

Line 37: ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

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

Line 38: ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

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

Line 39: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

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

Line 40: ,org_id NUMBER := OKL_API.G_MISS_NUM

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

Line 41: ,request_id NUMBER := OKL_API.G_MISS_NUM

37: ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
40: ,org_id NUMBER := OKL_API.G_MISS_NUM
41: ,request_id NUMBER := OKL_API.G_MISS_NUM
42: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 42: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

38: ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
40: ,org_id NUMBER := OKL_API.G_MISS_NUM
41: ,request_id NUMBER := OKL_API.G_MISS_NUM
42: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,created_by NUMBER := OKL_API.G_MISS_NUM
46: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 43: ,program_id NUMBER := OKL_API.G_MISS_NUM

39: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
40: ,org_id NUMBER := OKL_API.G_MISS_NUM
41: ,request_id NUMBER := OKL_API.G_MISS_NUM
42: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,created_by NUMBER := OKL_API.G_MISS_NUM
46: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 44: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 45: ,created_by NUMBER := OKL_API.G_MISS_NUM

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

Line 46: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

42: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,created_by NUMBER := OKL_API.G_MISS_NUM
46: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
48: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
50: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM

Line 47: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

43: ,program_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,created_by NUMBER := OKL_API.G_MISS_NUM
46: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
48: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
50: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
51: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM

Line 48: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

44: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,created_by NUMBER := OKL_API.G_MISS_NUM
46: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
48: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
50: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
51: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
52: ,tolerance NUMBER := OKL_API.G_MISS_NUM

Line 49: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

45: ,created_by NUMBER := OKL_API.G_MISS_NUM
46: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
48: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
50: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
51: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
52: ,tolerance NUMBER := OKL_API.G_MISS_NUM
53: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 50: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM

46: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
48: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
50: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
51: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
52: ,tolerance NUMBER := OKL_API.G_MISS_NUM
53: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
54: ,base_rate NUMBER := OKL_API.G_MISS_NUM

Line 51: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM

47: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
48: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
50: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
51: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
52: ,tolerance NUMBER := OKL_API.G_MISS_NUM
53: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
54: ,base_rate NUMBER := OKL_API.G_MISS_NUM
55: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR

Line 52: ,tolerance NUMBER := OKL_API.G_MISS_NUM

48: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
50: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
51: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
52: ,tolerance NUMBER := OKL_API.G_MISS_NUM
53: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
54: ,base_rate NUMBER := OKL_API.G_MISS_NUM
55: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
56: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 53: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

49: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
50: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
51: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
52: ,tolerance NUMBER := OKL_API.G_MISS_NUM
53: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
54: ,base_rate NUMBER := OKL_API.G_MISS_NUM
55: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
56: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
57: ,adder NUMBER := OKL_API.G_MISS_NUM

Line 54: ,base_rate NUMBER := OKL_API.G_MISS_NUM

50: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
51: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
52: ,tolerance NUMBER := OKL_API.G_MISS_NUM
53: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
54: ,base_rate NUMBER := OKL_API.G_MISS_NUM
55: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
56: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
57: ,adder NUMBER := OKL_API.G_MISS_NUM
58: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR

Line 55: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR

51: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
52: ,tolerance NUMBER := OKL_API.G_MISS_NUM
53: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
54: ,base_rate NUMBER := OKL_API.G_MISS_NUM
55: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
56: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
57: ,adder NUMBER := OKL_API.G_MISS_NUM
58: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
59: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR

Line 56: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR

52: ,tolerance NUMBER := OKL_API.G_MISS_NUM
53: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
54: ,base_rate NUMBER := OKL_API.G_MISS_NUM
55: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
56: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
57: ,adder NUMBER := OKL_API.G_MISS_NUM
58: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
59: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
60: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 57: ,adder NUMBER := OKL_API.G_MISS_NUM

53: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
54: ,base_rate NUMBER := OKL_API.G_MISS_NUM
55: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
56: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
57: ,adder NUMBER := OKL_API.G_MISS_NUM
58: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
59: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
60: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE

Line 58: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR

54: ,base_rate NUMBER := OKL_API.G_MISS_NUM
55: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
56: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
57: ,adder NUMBER := OKL_API.G_MISS_NUM
58: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
59: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
60: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 59: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR

55: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
56: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
57: ,adder NUMBER := OKL_API.G_MISS_NUM
58: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
59: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
60: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
63: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR

Line 60: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR

56: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
57: ,adder NUMBER := OKL_API.G_MISS_NUM
58: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
59: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
60: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
63: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
64: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE

Line 61: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE

57: ,adder NUMBER := OKL_API.G_MISS_NUM
58: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
59: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
60: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
63: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
64: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
65: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR

Line 62: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR

58: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
59: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
60: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
63: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
64: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
65: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
66: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 63: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR

59: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
60: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
63: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
64: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
65: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
66: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,yield NUMBER := OKL_API.G_MISS_NUM

Line 64: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE

60: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
63: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
64: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
65: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
66: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,yield NUMBER := OKL_API.G_MISS_NUM
68: ,residual NUMBER := OKL_API.G_MISS_NUM

Line 65: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR

61: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
63: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
64: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
65: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
66: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,yield NUMBER := OKL_API.G_MISS_NUM
68: ,residual NUMBER := OKL_API.G_MISS_NUM
69: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR

Line 66: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR

62: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
63: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
64: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
65: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
66: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,yield NUMBER := OKL_API.G_MISS_NUM
68: ,residual NUMBER := OKL_API.G_MISS_NUM
69: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
70: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 67: ,yield NUMBER := OKL_API.G_MISS_NUM

63: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
64: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
65: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
66: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,yield NUMBER := OKL_API.G_MISS_NUM
68: ,residual NUMBER := OKL_API.G_MISS_NUM
69: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
70: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 68: ,residual NUMBER := OKL_API.G_MISS_NUM

64: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
65: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
66: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,yield NUMBER := OKL_API.G_MISS_NUM
68: ,residual NUMBER := OKL_API.G_MISS_NUM
69: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
70: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR

Line 69: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR

65: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
66: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,yield NUMBER := OKL_API.G_MISS_NUM
68: ,residual NUMBER := OKL_API.G_MISS_NUM
69: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
70: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
73: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 70: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

66: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,yield NUMBER := OKL_API.G_MISS_NUM
68: ,residual NUMBER := OKL_API.G_MISS_NUM
69: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
70: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
73: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM

Line 71: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE

67: ,yield NUMBER := OKL_API.G_MISS_NUM
68: ,residual NUMBER := OKL_API.G_MISS_NUM
69: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
70: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
73: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
75: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR

Line 72: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR

68: ,residual NUMBER := OKL_API.G_MISS_NUM
69: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
70: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
73: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
75: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
76: ,payment_amount NUMBER := OKL_API.G_MISS_NUM

Line 73: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR

69: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
70: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
73: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
75: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
76: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
77: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE

Line 74: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM

70: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
73: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
75: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
76: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
77: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
78: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR

Line 75: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR

71: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
73: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
75: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
76: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
77: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
78: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
79: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR

Line 76: ,payment_amount NUMBER := OKL_API.G_MISS_NUM

72: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
73: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
75: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
76: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
77: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
78: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
79: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
80: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM

Line 77: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE

73: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
75: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
76: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
77: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
78: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
79: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
80: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
81: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE

Line 78: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR

74: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
75: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
76: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
77: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
78: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
79: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
80: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
81: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
82: ,lsm_id NUMBER := OKL_API.G_MISS_NUM

Line 79: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR

75: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
76: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
77: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
78: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
79: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
80: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
81: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
82: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
83: ,receipt_id NUMBER := OKL_API.G_MISS_NUM

Line 80: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM

76: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
77: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
78: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
79: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
80: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
81: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
82: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
83: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
84: ,tcn_id NUMBER := OKL_API.G_MISS_NUM

Line 81: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE

77: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
78: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
79: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
80: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
81: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
82: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
83: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
84: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
85: ,try_id NUMBER := OKL_API.G_MISS_NUM

Line 82: ,lsm_id NUMBER := OKL_API.G_MISS_NUM

78: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
79: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
80: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
81: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
82: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
83: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
84: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
85: ,try_id NUMBER := OKL_API.G_MISS_NUM
86: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM

Line 83: ,receipt_id NUMBER := OKL_API.G_MISS_NUM

79: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
80: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
81: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
82: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
83: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
84: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
85: ,try_id NUMBER := OKL_API.G_MISS_NUM
86: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
87: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM

Line 84: ,tcn_id NUMBER := OKL_API.G_MISS_NUM

80: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
81: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
82: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
83: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
84: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
85: ,try_id NUMBER := OKL_API.G_MISS_NUM
86: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
87: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM
88: ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);

Line 85: ,try_id NUMBER := OKL_API.G_MISS_NUM

81: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
82: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
83: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
84: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
85: ,try_id NUMBER := OKL_API.G_MISS_NUM
86: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
87: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM
88: ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);
89:

Line 86: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM

82: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
83: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
84: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
85: ,try_id NUMBER := OKL_API.G_MISS_NUM
86: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
87: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM
88: ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);
89:
90: G_MISS_trqv_rec trqv_rec_type;

Line 87: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM

83: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
84: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
85: ,try_id NUMBER := OKL_API.G_MISS_NUM
86: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
87: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM
88: ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);
89:
90: G_MISS_trqv_rec trqv_rec_type;
91:

Line 88: ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);

84: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
85: ,try_id NUMBER := OKL_API.G_MISS_NUM
86: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
87: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM
88: ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);
89:
90: G_MISS_trqv_rec trqv_rec_type;
91:
92: TYPE trqv_tbl_type IS TABLE OF trqv_rec_type

Line 97: id NUMBER := OKL_API.G_MISS_NUM

93: INDEX BY BINARY_INTEGER;
94:
95: -- OKL_TRX_REQUESTS Record Spec
96: TYPE trq_rec_type IS RECORD (
97: id NUMBER := OKL_API.G_MISS_NUM
98: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
99: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
100: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
101: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM

Line 98: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR

94:
95: -- OKL_TRX_REQUESTS Record Spec
96: TYPE trq_rec_type IS RECORD (
97: id NUMBER := OKL_API.G_MISS_NUM
98: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
99: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
100: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
101: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
102: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 99: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR

95: -- OKL_TRX_REQUESTS Record Spec
96: TYPE trq_rec_type IS RECORD (
97: id NUMBER := OKL_API.G_MISS_NUM
98: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
99: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
100: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
101: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
102: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
103: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 100: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR

96: TYPE trq_rec_type IS RECORD (
97: id NUMBER := OKL_API.G_MISS_NUM
98: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
99: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
100: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
101: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
102: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
103: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
104: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE

Line 101: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM

97: id NUMBER := OKL_API.G_MISS_NUM
98: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
99: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
100: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
101: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
102: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
103: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
104: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
105: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE

Line 102: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR

98: ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
99: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
100: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
101: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
102: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
103: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
104: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
105: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
106: ,term_duration NUMBER := OKL_API.G_MISS_NUM

Line 103: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR

99: ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
100: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
101: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
102: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
103: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
104: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
105: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
106: ,term_duration NUMBER := OKL_API.G_MISS_NUM
107: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM

Line 104: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE

100: ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
101: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
102: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
103: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
104: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
105: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
106: ,term_duration NUMBER := OKL_API.G_MISS_NUM
107: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
108: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 105: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE

101: ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
102: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
103: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
104: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
105: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
106: ,term_duration NUMBER := OKL_API.G_MISS_NUM
107: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
108: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
109: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR

Line 106: ,term_duration NUMBER := OKL_API.G_MISS_NUM

102: ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
103: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
104: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
105: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
106: ,term_duration NUMBER := OKL_API.G_MISS_NUM
107: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
108: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
109: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
110: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR

Line 107: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM

103: ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
104: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
105: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
106: ,term_duration NUMBER := OKL_API.G_MISS_NUM
107: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
108: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
109: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
110: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
111: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

Line 108: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

104: ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
105: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
106: ,term_duration NUMBER := OKL_API.G_MISS_NUM
107: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
108: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
109: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
110: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
111: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
112: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 109: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR

105: ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
106: ,term_duration NUMBER := OKL_API.G_MISS_NUM
107: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
108: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
109: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
110: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
111: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
112: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 110: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR

106: ,term_duration NUMBER := OKL_API.G_MISS_NUM
107: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
108: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
109: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
110: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
111: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
112: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 111: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

107: ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
108: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
109: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
110: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
111: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
112: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 112: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

108: ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
109: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
110: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
111: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
112: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 113: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

109: ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
110: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
111: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
112: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 114: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

110: ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
111: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
112: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
118: ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 115: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

111: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
112: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
118: ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
119: ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 116: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

112: ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
118: ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
119: ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
120: ,attribute8 OKL_TRX_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

Line 117: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

113: ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
118: ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
119: ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
120: ,attribute8 OKL_TRX_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
121: ,attribute9 OKL_TRX_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

Line 118: ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

114: ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
118: ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
119: ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
120: ,attribute8 OKL_TRX_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
121: ,attribute9 OKL_TRX_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
122: ,attribute10 OKL_TRX_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

Line 119: ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

115: ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
116: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
118: ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
119: ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
120: ,attribute8 OKL_TRX_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
121: ,attribute9 OKL_TRX_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
122: ,attribute10 OKL_TRX_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
123: ,attribute11 OKL_TRX_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

Line 120: ,attribute8 OKL_TRX_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

116: ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
117: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
118: ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
119: ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
120: ,attribute8 OKL_TRX_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
121: ,attribute9 OKL_TRX_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
122: ,attribute10 OKL_TRX_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
123: ,attribute11 OKL_TRX_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
124: ,attribute12 OKL_TRX_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

Line 121: ,attribute9 OKL_TRX_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

117: ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
118: ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
119: ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
120: ,attribute8 OKL_TRX_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
121: ,attribute9 OKL_TRX_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
122: ,attribute10 OKL_TRX_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
123: ,attribute11 OKL_TRX_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
124: ,attribute12 OKL_TRX_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
125: ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

Line 122: ,attribute10 OKL_TRX_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

118: ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
119: ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
120: ,attribute8 OKL_TRX_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
121: ,attribute9 OKL_TRX_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
122: ,attribute10 OKL_TRX_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
123: ,attribute11 OKL_TRX_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
124: ,attribute12 OKL_TRX_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
125: ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
126: ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

Line 123: ,attribute11 OKL_TRX_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

119: ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
120: ,attribute8 OKL_TRX_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
121: ,attribute9 OKL_TRX_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
122: ,attribute10 OKL_TRX_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
123: ,attribute11 OKL_TRX_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
124: ,attribute12 OKL_TRX_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
125: ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
126: ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
127: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

Line 124: ,attribute12 OKL_TRX_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

120: ,attribute8 OKL_TRX_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
121: ,attribute9 OKL_TRX_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
122: ,attribute10 OKL_TRX_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
123: ,attribute11 OKL_TRX_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
124: ,attribute12 OKL_TRX_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
125: ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
126: ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
127: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
128: ,org_id NUMBER := OKL_API.G_MISS_NUM

Line 125: ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

121: ,attribute9 OKL_TRX_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
122: ,attribute10 OKL_TRX_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
123: ,attribute11 OKL_TRX_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
124: ,attribute12 OKL_TRX_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
125: ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
126: ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
127: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
128: ,org_id NUMBER := OKL_API.G_MISS_NUM
129: ,request_id NUMBER := OKL_API.G_MISS_NUM

Line 126: ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

122: ,attribute10 OKL_TRX_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
123: ,attribute11 OKL_TRX_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
124: ,attribute12 OKL_TRX_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
125: ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
126: ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
127: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
128: ,org_id NUMBER := OKL_API.G_MISS_NUM
129: ,request_id NUMBER := OKL_API.G_MISS_NUM
130: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 127: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

123: ,attribute11 OKL_TRX_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
124: ,attribute12 OKL_TRX_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
125: ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
126: ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
127: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
128: ,org_id NUMBER := OKL_API.G_MISS_NUM
129: ,request_id NUMBER := OKL_API.G_MISS_NUM
130: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
131: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 128: ,org_id NUMBER := OKL_API.G_MISS_NUM

124: ,attribute12 OKL_TRX_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
125: ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
126: ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
127: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
128: ,org_id NUMBER := OKL_API.G_MISS_NUM
129: ,request_id NUMBER := OKL_API.G_MISS_NUM
130: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
131: ,program_id NUMBER := OKL_API.G_MISS_NUM
132: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 129: ,request_id NUMBER := OKL_API.G_MISS_NUM

125: ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
126: ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
127: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
128: ,org_id NUMBER := OKL_API.G_MISS_NUM
129: ,request_id NUMBER := OKL_API.G_MISS_NUM
130: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
131: ,program_id NUMBER := OKL_API.G_MISS_NUM
132: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
133: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 130: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

126: ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
127: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
128: ,org_id NUMBER := OKL_API.G_MISS_NUM
129: ,request_id NUMBER := OKL_API.G_MISS_NUM
130: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
131: ,program_id NUMBER := OKL_API.G_MISS_NUM
132: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
133: ,created_by NUMBER := OKL_API.G_MISS_NUM
134: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 131: ,program_id NUMBER := OKL_API.G_MISS_NUM

127: ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
128: ,org_id NUMBER := OKL_API.G_MISS_NUM
129: ,request_id NUMBER := OKL_API.G_MISS_NUM
130: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
131: ,program_id NUMBER := OKL_API.G_MISS_NUM
132: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
133: ,created_by NUMBER := OKL_API.G_MISS_NUM
134: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
135: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 132: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

128: ,org_id NUMBER := OKL_API.G_MISS_NUM
129: ,request_id NUMBER := OKL_API.G_MISS_NUM
130: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
131: ,program_id NUMBER := OKL_API.G_MISS_NUM
132: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
133: ,created_by NUMBER := OKL_API.G_MISS_NUM
134: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
135: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
136: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 133: ,created_by NUMBER := OKL_API.G_MISS_NUM

129: ,request_id NUMBER := OKL_API.G_MISS_NUM
130: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
131: ,program_id NUMBER := OKL_API.G_MISS_NUM
132: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
133: ,created_by NUMBER := OKL_API.G_MISS_NUM
134: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
135: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
136: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
137: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

Line 134: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

130: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
131: ,program_id NUMBER := OKL_API.G_MISS_NUM
132: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
133: ,created_by NUMBER := OKL_API.G_MISS_NUM
134: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
135: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
136: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
137: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
138: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM

Line 135: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

131: ,program_id NUMBER := OKL_API.G_MISS_NUM
132: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
133: ,created_by NUMBER := OKL_API.G_MISS_NUM
134: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
135: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
136: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
137: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
138: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
139: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM

Line 136: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

132: ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
133: ,created_by NUMBER := OKL_API.G_MISS_NUM
134: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
135: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
136: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
137: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
138: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
139: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
140: ,tolerance NUMBER := OKL_API.G_MISS_NUM

Line 137: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

133: ,created_by NUMBER := OKL_API.G_MISS_NUM
134: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
135: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
136: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
137: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
138: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
139: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
140: ,tolerance NUMBER := OKL_API.G_MISS_NUM
141: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 138: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM

134: ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
135: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
136: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
137: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
138: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
139: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
140: ,tolerance NUMBER := OKL_API.G_MISS_NUM
141: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
142: ,base_rate NUMBER := OKL_API.G_MISS_NUM

Line 139: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM

135: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
136: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
137: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
138: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
139: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
140: ,tolerance NUMBER := OKL_API.G_MISS_NUM
141: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
142: ,base_rate NUMBER := OKL_API.G_MISS_NUM
143: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR

Line 140: ,tolerance NUMBER := OKL_API.G_MISS_NUM

136: ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
137: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
138: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
139: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
140: ,tolerance NUMBER := OKL_API.G_MISS_NUM
141: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
142: ,base_rate NUMBER := OKL_API.G_MISS_NUM
143: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
144: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 141: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

137: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
138: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
139: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
140: ,tolerance NUMBER := OKL_API.G_MISS_NUM
141: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
142: ,base_rate NUMBER := OKL_API.G_MISS_NUM
143: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
144: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
145: ,adder NUMBER := OKL_API.G_MISS_NUM

Line 142: ,base_rate NUMBER := OKL_API.G_MISS_NUM

138: ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
139: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
140: ,tolerance NUMBER := OKL_API.G_MISS_NUM
141: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
142: ,base_rate NUMBER := OKL_API.G_MISS_NUM
143: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
144: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
145: ,adder NUMBER := OKL_API.G_MISS_NUM
146: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR

Line 143: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR

139: ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
140: ,tolerance NUMBER := OKL_API.G_MISS_NUM
141: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
142: ,base_rate NUMBER := OKL_API.G_MISS_NUM
143: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
144: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
145: ,adder NUMBER := OKL_API.G_MISS_NUM
146: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
147: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR

Line 144: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR

140: ,tolerance NUMBER := OKL_API.G_MISS_NUM
141: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
142: ,base_rate NUMBER := OKL_API.G_MISS_NUM
143: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
144: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
145: ,adder NUMBER := OKL_API.G_MISS_NUM
146: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
147: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
148: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 145: ,adder NUMBER := OKL_API.G_MISS_NUM

141: ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
142: ,base_rate NUMBER := OKL_API.G_MISS_NUM
143: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
144: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
145: ,adder NUMBER := OKL_API.G_MISS_NUM
146: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
147: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
148: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE

Line 146: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR

142: ,base_rate NUMBER := OKL_API.G_MISS_NUM
143: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
144: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
145: ,adder NUMBER := OKL_API.G_MISS_NUM
146: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
147: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
148: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 147: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR

143: ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
144: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
145: ,adder NUMBER := OKL_API.G_MISS_NUM
146: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
147: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
148: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR

Line 148: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR

144: ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
145: ,adder NUMBER := OKL_API.G_MISS_NUM
146: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
147: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
148: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
152: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE

Line 149: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE

145: ,adder NUMBER := OKL_API.G_MISS_NUM
146: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
147: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
148: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
152: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
153: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR

Line 150: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR

146: ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
147: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
148: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
152: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
153: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
154: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 151: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR

147: ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
148: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
152: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
153: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
154: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
155: ,yield NUMBER := OKL_API.G_MISS_NUM

Line 152: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE

148: ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
152: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
153: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
154: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
155: ,yield NUMBER := OKL_API.G_MISS_NUM
156: ,residual NUMBER := OKL_API.G_MISS_NUM

Line 153: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR

149: ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
152: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
153: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
154: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
155: ,yield NUMBER := OKL_API.G_MISS_NUM
156: ,residual NUMBER := OKL_API.G_MISS_NUM
157: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR

Line 154: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR

150: ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
152: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
153: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
154: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
155: ,yield NUMBER := OKL_API.G_MISS_NUM
156: ,residual NUMBER := OKL_API.G_MISS_NUM
157: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
158: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 155: ,yield NUMBER := OKL_API.G_MISS_NUM

151: ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
152: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
153: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
154: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
155: ,yield NUMBER := OKL_API.G_MISS_NUM
156: ,residual NUMBER := OKL_API.G_MISS_NUM
157: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
158: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
159: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 156: ,residual NUMBER := OKL_API.G_MISS_NUM

152: ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
153: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
154: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
155: ,yield NUMBER := OKL_API.G_MISS_NUM
156: ,residual NUMBER := OKL_API.G_MISS_NUM
157: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
158: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
159: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
160: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR

Line 157: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR

153: ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
154: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
155: ,yield NUMBER := OKL_API.G_MISS_NUM
156: ,residual NUMBER := OKL_API.G_MISS_NUM
157: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
158: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
159: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
160: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
161: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 158: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

154: ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
155: ,yield NUMBER := OKL_API.G_MISS_NUM
156: ,residual NUMBER := OKL_API.G_MISS_NUM
157: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
158: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
159: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
160: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
161: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
162: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM

Line 159: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE

155: ,yield NUMBER := OKL_API.G_MISS_NUM
156: ,residual NUMBER := OKL_API.G_MISS_NUM
157: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
158: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
159: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
160: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
161: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
162: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
163: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR

Line 160: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR

156: ,residual NUMBER := OKL_API.G_MISS_NUM
157: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
158: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
159: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
160: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
161: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
162: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
163: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
164: ,payment_amount NUMBER := OKL_API.G_MISS_NUM

Line 161: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR

157: ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
158: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
159: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
160: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
161: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
162: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
163: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
164: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
165: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE

Line 162: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM

158: ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
159: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
160: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
161: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
162: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
163: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
164: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
165: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
166: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR

Line 163: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR

159: ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
160: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
161: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
162: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
163: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
164: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
165: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
166: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
167: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR

Line 164: ,payment_amount NUMBER := OKL_API.G_MISS_NUM

160: ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
161: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
162: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
163: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
164: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
165: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
166: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
167: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
168: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM

Line 165: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE

161: ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
162: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
163: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
164: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
165: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
166: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
167: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
168: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
169: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE

Line 166: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR

162: ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
163: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
164: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
165: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
166: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
167: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
168: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
169: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
170: ,lsm_id NUMBER := OKL_API.G_MISS_NUM

Line 167: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR

163: ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
164: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
165: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
166: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
167: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
168: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
169: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
170: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
171: ,receipt_id NUMBER := OKL_API.G_MISS_NUM

Line 168: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM

164: ,payment_amount NUMBER := OKL_API.G_MISS_NUM
165: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
166: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
167: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
168: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
169: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
170: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
171: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
172: ,tcn_id NUMBER := OKL_API.G_MISS_NUM

Line 169: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE

165: ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
166: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
167: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
168: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
169: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
170: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
171: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
172: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
173: ,try_id NUMBER := OKL_API.G_MISS_NUM

Line 170: ,lsm_id NUMBER := OKL_API.G_MISS_NUM

166: ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
167: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
168: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
169: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
170: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
171: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
172: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
173: ,try_id NUMBER := OKL_API.G_MISS_NUM
174: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM

Line 171: ,receipt_id NUMBER := OKL_API.G_MISS_NUM

167: ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
168: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
169: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
170: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
171: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
172: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
173: ,try_id NUMBER := OKL_API.G_MISS_NUM
174: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
175: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM

Line 172: ,tcn_id NUMBER := OKL_API.G_MISS_NUM

168: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
169: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
170: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
171: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
172: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
173: ,try_id NUMBER := OKL_API.G_MISS_NUM
174: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
175: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM
176: ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);

Line 173: ,try_id NUMBER := OKL_API.G_MISS_NUM

169: ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
170: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
171: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
172: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
173: ,try_id NUMBER := OKL_API.G_MISS_NUM
174: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
175: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM
176: ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);
177:

Line 174: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM

170: ,lsm_id NUMBER := OKL_API.G_MISS_NUM
171: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
172: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
173: ,try_id NUMBER := OKL_API.G_MISS_NUM
174: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
175: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM
176: ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);
177:
178: G_MISS_trq_rec trq_rec_type;

Line 175: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM

171: ,receipt_id NUMBER := OKL_API.G_MISS_NUM
172: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
173: ,try_id NUMBER := OKL_API.G_MISS_NUM
174: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
175: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM
176: ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);
177:
178: G_MISS_trq_rec trq_rec_type;
179: TYPE trq_tbl_type IS TABLE OF trq_rec_type

Line 176: ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);

172: ,tcn_id NUMBER := OKL_API.G_MISS_NUM
173: ,try_id NUMBER := OKL_API.G_MISS_NUM
174: ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
175: ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM
176: ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);
177:
178: G_MISS_trq_rec trq_rec_type;
179: TYPE trq_tbl_type IS TABLE OF trq_rec_type
180: INDEX BY BINARY_INTEGER;

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

180: INDEX BY BINARY_INTEGER;
181: ---------------------------------------------------------------------------
182: -- GLOBAL MESSAGE CONSTANTS
183: ---------------------------------------------------------------------------
184: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
185: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
186: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
187: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
188: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

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

181: ---------------------------------------------------------------------------
182: -- GLOBAL MESSAGE CONSTANTS
183: ---------------------------------------------------------------------------
184: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
185: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
186: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
187: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
188: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
189: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

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

182: -- GLOBAL MESSAGE CONSTANTS
183: ---------------------------------------------------------------------------
184: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
185: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
186: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
187: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
188: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
189: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
190: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

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

183: ---------------------------------------------------------------------------
184: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
185: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
186: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
187: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
188: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
189: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
190: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
191: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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

184: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
185: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
186: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
187: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
188: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
189: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
190: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
191: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
192: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

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

185: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
186: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
187: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
188: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
189: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
190: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
191: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
192: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
193: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

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

186: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
187: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
188: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
189: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
190: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
191: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
192: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
193: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
194: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

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

187: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
188: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
189: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
190: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
191: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
192: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
193: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
194: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
195: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

188: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
189: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
190: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
191: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
192: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
193: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
194: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
195: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
196: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

189: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
190: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
191: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
192: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
193: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
194: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
195: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
196: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
197:

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

203: ---------------------------------------------------------------------------
204: -- GLOBAL VARIABLES
205: ---------------------------------------------------------------------------
206: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TRQ_PVT';
207: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
208: ---------------------------------------------------------------------------
209: -- Procedures and Functions
210: ---------------------------------------------------------------------------
211:

Line 217: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

213: PROCEDURE change_version;
214: PROCEDURE api_copy;
215: PROCEDURE insert_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_trqv_rec IN trqv_rec_type,

Line 225: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

221: p_trqv_rec IN trqv_rec_type,
222: x_trqv_rec OUT NOCOPY trqv_rec_type);
223: PROCEDURE insert_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_trqv_tbl IN trqv_tbl_type,

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

227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_trqv_tbl IN trqv_tbl_type,
230: x_trqv_tbl OUT NOCOPY trqv_tbl_type,
231: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
232: PROCEDURE insert_row(
233: p_api_version IN NUMBER,
234: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
235: x_return_status OUT NOCOPY VARCHAR2,

Line 234: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

230: x_trqv_tbl OUT NOCOPY trqv_tbl_type,
231: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
232: PROCEDURE insert_row(
233: p_api_version IN NUMBER,
234: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_count OUT NOCOPY NUMBER,
237: x_msg_data OUT NOCOPY VARCHAR2,
238: p_trqv_tbl IN trqv_tbl_type,

Line 242: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

238: p_trqv_tbl IN trqv_tbl_type,
239: x_trqv_tbl OUT NOCOPY trqv_tbl_type);
240: PROCEDURE lock_row(
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,
246: p_trqv_rec IN trqv_rec_type);

Line 249: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

245: x_msg_data OUT NOCOPY VARCHAR2,
246: p_trqv_rec IN trqv_rec_type);
247: PROCEDURE lock_row(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_trqv_tbl IN trqv_tbl_type,

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

250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_trqv_tbl IN trqv_tbl_type,
254: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
255: PROCEDURE lock_row(
256: p_api_version IN NUMBER,
257: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
258: x_return_status OUT NOCOPY VARCHAR2,

Line 257: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

253: p_trqv_tbl IN trqv_tbl_type,
254: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
255: PROCEDURE lock_row(
256: p_api_version IN NUMBER,
257: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,
261: p_trqv_tbl IN trqv_tbl_type);

Line 264: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

260: x_msg_data OUT NOCOPY VARCHAR2,
261: p_trqv_tbl IN trqv_tbl_type);
262: PROCEDURE update_row(
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_trqv_rec IN trqv_rec_type,

Line 272: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

268: p_trqv_rec IN trqv_rec_type,
269: x_trqv_rec OUT NOCOPY trqv_rec_type);
270: PROCEDURE update_row(
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
273: x_return_status OUT NOCOPY VARCHAR2,
274: x_msg_count OUT NOCOPY NUMBER,
275: x_msg_data OUT NOCOPY VARCHAR2,
276: p_trqv_tbl IN trqv_tbl_type,

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

274: x_msg_count OUT NOCOPY NUMBER,
275: x_msg_data OUT NOCOPY VARCHAR2,
276: p_trqv_tbl IN trqv_tbl_type,
277: x_trqv_tbl OUT NOCOPY trqv_tbl_type,
278: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
279: PROCEDURE update_row(
280: p_api_version IN NUMBER,
281: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
282: x_return_status OUT NOCOPY VARCHAR2,

Line 281: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

277: x_trqv_tbl OUT NOCOPY trqv_tbl_type,
278: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
279: PROCEDURE update_row(
280: p_api_version IN NUMBER,
281: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
285: p_trqv_tbl IN trqv_tbl_type,

Line 289: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

285: p_trqv_tbl IN trqv_tbl_type,
286: x_trqv_tbl OUT NOCOPY trqv_tbl_type);
287: PROCEDURE delete_row(
288: p_api_version IN NUMBER,
289: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_trqv_rec IN trqv_rec_type);

Line 296: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_trqv_rec IN trqv_rec_type);
294: PROCEDURE delete_row(
295: p_api_version IN NUMBER,
296: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
297: x_return_status OUT NOCOPY VARCHAR2,
298: x_msg_count OUT NOCOPY NUMBER,
299: x_msg_data OUT NOCOPY VARCHAR2,
300: p_trqv_tbl IN trqv_tbl_type,

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

297: x_return_status OUT NOCOPY VARCHAR2,
298: x_msg_count OUT NOCOPY NUMBER,
299: x_msg_data OUT NOCOPY VARCHAR2,
300: p_trqv_tbl IN trqv_tbl_type,
301: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
302: PROCEDURE delete_row(
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
305: x_return_status OUT NOCOPY VARCHAR2,

Line 304: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

300: p_trqv_tbl IN trqv_tbl_type,
301: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
302: PROCEDURE delete_row(
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
305: x_return_status OUT NOCOPY VARCHAR2,
306: x_msg_count OUT NOCOPY NUMBER,
307: x_msg_data OUT NOCOPY VARCHAR2,
308: p_trqv_tbl IN trqv_tbl_type);

Line 311: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

307: x_msg_data OUT NOCOPY VARCHAR2,
308: p_trqv_tbl IN trqv_tbl_type);
309: PROCEDURE validate_row(
310: p_api_version IN NUMBER,
311: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
312: x_return_status OUT NOCOPY VARCHAR2,
313: x_msg_count OUT NOCOPY NUMBER,
314: x_msg_data OUT NOCOPY VARCHAR2,
315: p_trqv_rec IN trqv_rec_type);

Line 318: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

314: x_msg_data OUT NOCOPY VARCHAR2,
315: p_trqv_rec IN trqv_rec_type);
316: PROCEDURE validate_row(
317: p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,
322: p_trqv_tbl IN trqv_tbl_type,

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

319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,
322: p_trqv_tbl IN trqv_tbl_type,
323: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
324: PROCEDURE validate_row(
325: p_api_version IN NUMBER,
326: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
327: x_return_status OUT NOCOPY VARCHAR2,

Line 326: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

322: p_trqv_tbl IN trqv_tbl_type,
323: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
324: PROCEDURE validate_row(
325: p_api_version IN NUMBER,
326: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
329: x_msg_data OUT NOCOPY VARCHAR2,
330: p_trqv_tbl IN trqv_tbl_type);