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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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);
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:
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;
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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);
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:
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;
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
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;
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;
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;
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;
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;
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;
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;
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';
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';
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';
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:
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:
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,
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,
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,
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,
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);
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,
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,
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);
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,
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,
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,
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,
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);
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,
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,
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);
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);
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,
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,
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);