3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE qte_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: qrs_code OKL_TRX_QUOTES_B.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
11: khr_id NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE qte_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: qrs_code OKL_TRX_QUOTES_B.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
11: khr_id NUMBER := OKC_API.G_MISS_NUM,
12: art_id NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE qte_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: qrs_code OKL_TRX_QUOTES_B.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
11: khr_id NUMBER := OKC_API.G_MISS_NUM,
12: art_id NUMBER := OKC_API.G_MISS_NUM,
13: qtp_code OKL_TRX_QUOTES_B.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
6: TYPE qte_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: qrs_code OKL_TRX_QUOTES_B.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
11: khr_id NUMBER := OKC_API.G_MISS_NUM,
12: art_id NUMBER := OKC_API.G_MISS_NUM,
13: qtp_code OKL_TRX_QUOTES_B.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: trn_code OKL_TRX_QUOTES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: qrs_code OKL_TRX_QUOTES_B.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
11: khr_id NUMBER := OKC_API.G_MISS_NUM,
12: art_id NUMBER := OKC_API.G_MISS_NUM,
13: qtp_code OKL_TRX_QUOTES_B.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: trn_code OKL_TRX_QUOTES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: pop_code_end OKL_TRX_QUOTES_B.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
8: qrs_code OKL_TRX_QUOTES_B.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
11: khr_id NUMBER := OKC_API.G_MISS_NUM,
12: art_id NUMBER := OKC_API.G_MISS_NUM,
13: qtp_code OKL_TRX_QUOTES_B.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: trn_code OKL_TRX_QUOTES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: pop_code_end OKL_TRX_QUOTES_B.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
16: pop_code_early OKL_TRX_QUOTES_B.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
9: qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
11: khr_id NUMBER := OKC_API.G_MISS_NUM,
12: art_id NUMBER := OKC_API.G_MISS_NUM,
13: qtp_code OKL_TRX_QUOTES_B.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: trn_code OKL_TRX_QUOTES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: pop_code_end OKL_TRX_QUOTES_B.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
16: pop_code_early OKL_TRX_QUOTES_B.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
17: pdt_id NUMBER := OKC_API.G_MISS_NUM,
10: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
11: khr_id NUMBER := OKC_API.G_MISS_NUM,
12: art_id NUMBER := OKC_API.G_MISS_NUM,
13: qtp_code OKL_TRX_QUOTES_B.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: trn_code OKL_TRX_QUOTES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: pop_code_end OKL_TRX_QUOTES_B.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
16: pop_code_early OKL_TRX_QUOTES_B.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
17: pdt_id NUMBER := OKC_API.G_MISS_NUM,
18: date_effective_from OKL_TRX_QUOTES_B.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
11: khr_id NUMBER := OKC_API.G_MISS_NUM,
12: art_id NUMBER := OKC_API.G_MISS_NUM,
13: qtp_code OKL_TRX_QUOTES_B.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: trn_code OKL_TRX_QUOTES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: pop_code_end OKL_TRX_QUOTES_B.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
16: pop_code_early OKL_TRX_QUOTES_B.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
17: pdt_id NUMBER := OKC_API.G_MISS_NUM,
18: date_effective_from OKL_TRX_QUOTES_B.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
19: quote_number NUMBER := OKC_API.G_MISS_NUM,
12: art_id NUMBER := OKC_API.G_MISS_NUM,
13: qtp_code OKL_TRX_QUOTES_B.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: trn_code OKL_TRX_QUOTES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: pop_code_end OKL_TRX_QUOTES_B.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
16: pop_code_early OKL_TRX_QUOTES_B.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
17: pdt_id NUMBER := OKC_API.G_MISS_NUM,
18: date_effective_from OKL_TRX_QUOTES_B.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
19: quote_number NUMBER := OKC_API.G_MISS_NUM,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: qtp_code OKL_TRX_QUOTES_B.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: trn_code OKL_TRX_QUOTES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: pop_code_end OKL_TRX_QUOTES_B.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
16: pop_code_early OKL_TRX_QUOTES_B.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
17: pdt_id NUMBER := OKC_API.G_MISS_NUM,
18: date_effective_from OKL_TRX_QUOTES_B.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
19: quote_number NUMBER := OKC_API.G_MISS_NUM,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
14: trn_code OKL_TRX_QUOTES_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: pop_code_end OKL_TRX_QUOTES_B.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
16: pop_code_early OKL_TRX_QUOTES_B.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
17: pdt_id NUMBER := OKC_API.G_MISS_NUM,
18: date_effective_from OKL_TRX_QUOTES_B.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
19: quote_number NUMBER := OKC_API.G_MISS_NUM,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
22: term NUMBER := OKC_API.G_MISS_NUM,
15: pop_code_end OKL_TRX_QUOTES_B.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
16: pop_code_early OKL_TRX_QUOTES_B.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
17: pdt_id NUMBER := OKC_API.G_MISS_NUM,
18: date_effective_from OKL_TRX_QUOTES_B.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
19: quote_number NUMBER := OKC_API.G_MISS_NUM,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
22: term NUMBER := OKC_API.G_MISS_NUM,
23: date_restructure_start OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
16: pop_code_early OKL_TRX_QUOTES_B.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
17: pdt_id NUMBER := OKC_API.G_MISS_NUM,
18: date_effective_from OKL_TRX_QUOTES_B.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
19: quote_number NUMBER := OKC_API.G_MISS_NUM,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
22: term NUMBER := OKC_API.G_MISS_NUM,
23: date_restructure_start OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
24: date_due OKL_TRX_QUOTES_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
17: pdt_id NUMBER := OKC_API.G_MISS_NUM,
18: date_effective_from OKL_TRX_QUOTES_B.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
19: quote_number NUMBER := OKC_API.G_MISS_NUM,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
22: term NUMBER := OKC_API.G_MISS_NUM,
23: date_restructure_start OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
24: date_due OKL_TRX_QUOTES_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
25: date_approved OKL_TRX_QUOTES_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
18: date_effective_from OKL_TRX_QUOTES_B.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
19: quote_number NUMBER := OKC_API.G_MISS_NUM,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
22: term NUMBER := OKC_API.G_MISS_NUM,
23: date_restructure_start OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
24: date_due OKL_TRX_QUOTES_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
25: date_approved OKL_TRX_QUOTES_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
26: date_restructure_end OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
19: quote_number NUMBER := OKC_API.G_MISS_NUM,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
22: term NUMBER := OKC_API.G_MISS_NUM,
23: date_restructure_start OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
24: date_due OKL_TRX_QUOTES_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
25: date_approved OKL_TRX_QUOTES_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
26: date_restructure_end OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
27: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
22: term NUMBER := OKC_API.G_MISS_NUM,
23: date_restructure_start OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
24: date_due OKL_TRX_QUOTES_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
25: date_approved OKL_TRX_QUOTES_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
26: date_restructure_end OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
27: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
28: rent_amount NUMBER := OKC_API.G_MISS_NUM,
21: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
22: term NUMBER := OKC_API.G_MISS_NUM,
23: date_restructure_start OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
24: date_due OKL_TRX_QUOTES_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
25: date_approved OKL_TRX_QUOTES_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
26: date_restructure_end OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
27: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
28: rent_amount NUMBER := OKC_API.G_MISS_NUM,
29: yield NUMBER := OKC_API.G_MISS_NUM,
22: term NUMBER := OKC_API.G_MISS_NUM,
23: date_restructure_start OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
24: date_due OKL_TRX_QUOTES_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
25: date_approved OKL_TRX_QUOTES_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
26: date_restructure_end OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
27: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
28: rent_amount NUMBER := OKC_API.G_MISS_NUM,
29: yield NUMBER := OKC_API.G_MISS_NUM,
30: residual_amount NUMBER := OKC_API.G_MISS_NUM,
23: date_restructure_start OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
24: date_due OKL_TRX_QUOTES_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
25: date_approved OKL_TRX_QUOTES_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
26: date_restructure_end OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
27: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
28: rent_amount NUMBER := OKC_API.G_MISS_NUM,
29: yield NUMBER := OKC_API.G_MISS_NUM,
30: residual_amount NUMBER := OKC_API.G_MISS_NUM,
31: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
24: date_due OKL_TRX_QUOTES_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
25: date_approved OKL_TRX_QUOTES_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
26: date_restructure_end OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
27: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
28: rent_amount NUMBER := OKC_API.G_MISS_NUM,
29: yield NUMBER := OKC_API.G_MISS_NUM,
30: residual_amount NUMBER := OKC_API.G_MISS_NUM,
31: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
32: payment_frequency OKL_TRX_QUOTES_B.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
25: date_approved OKL_TRX_QUOTES_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
26: date_restructure_end OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
27: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
28: rent_amount NUMBER := OKC_API.G_MISS_NUM,
29: yield NUMBER := OKC_API.G_MISS_NUM,
30: residual_amount NUMBER := OKC_API.G_MISS_NUM,
31: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
32: payment_frequency OKL_TRX_QUOTES_B.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
33: early_termination_yn OKL_TRX_QUOTES_B.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
26: date_restructure_end OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
27: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
28: rent_amount NUMBER := OKC_API.G_MISS_NUM,
29: yield NUMBER := OKC_API.G_MISS_NUM,
30: residual_amount NUMBER := OKC_API.G_MISS_NUM,
31: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
32: payment_frequency OKL_TRX_QUOTES_B.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
33: early_termination_yn OKL_TRX_QUOTES_B.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
34: partial_yn OKL_TRX_QUOTES_B.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
27: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
28: rent_amount NUMBER := OKC_API.G_MISS_NUM,
29: yield NUMBER := OKC_API.G_MISS_NUM,
30: residual_amount NUMBER := OKC_API.G_MISS_NUM,
31: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
32: payment_frequency OKL_TRX_QUOTES_B.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
33: early_termination_yn OKL_TRX_QUOTES_B.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
34: partial_yn OKL_TRX_QUOTES_B.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
35: preproceeds_yn OKL_TRX_QUOTES_B.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
28: rent_amount NUMBER := OKC_API.G_MISS_NUM,
29: yield NUMBER := OKC_API.G_MISS_NUM,
30: residual_amount NUMBER := OKC_API.G_MISS_NUM,
31: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
32: payment_frequency OKL_TRX_QUOTES_B.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
33: early_termination_yn OKL_TRX_QUOTES_B.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
34: partial_yn OKL_TRX_QUOTES_B.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
35: preproceeds_yn OKL_TRX_QUOTES_B.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
36: summary_format_yn OKL_TRX_QUOTES_B.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
29: yield NUMBER := OKC_API.G_MISS_NUM,
30: residual_amount NUMBER := OKC_API.G_MISS_NUM,
31: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
32: payment_frequency OKL_TRX_QUOTES_B.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
33: early_termination_yn OKL_TRX_QUOTES_B.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
34: partial_yn OKL_TRX_QUOTES_B.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
35: preproceeds_yn OKL_TRX_QUOTES_B.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
36: summary_format_yn OKL_TRX_QUOTES_B.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
37: consolidated_yn OKL_TRX_QUOTES_B.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
30: residual_amount NUMBER := OKC_API.G_MISS_NUM,
31: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
32: payment_frequency OKL_TRX_QUOTES_B.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
33: early_termination_yn OKL_TRX_QUOTES_B.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
34: partial_yn OKL_TRX_QUOTES_B.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
35: preproceeds_yn OKL_TRX_QUOTES_B.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
36: summary_format_yn OKL_TRX_QUOTES_B.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
37: consolidated_yn OKL_TRX_QUOTES_B.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
38: date_requested OKL_TRX_QUOTES_B.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
31: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
32: payment_frequency OKL_TRX_QUOTES_B.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
33: early_termination_yn OKL_TRX_QUOTES_B.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
34: partial_yn OKL_TRX_QUOTES_B.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
35: preproceeds_yn OKL_TRX_QUOTES_B.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
36: summary_format_yn OKL_TRX_QUOTES_B.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
37: consolidated_yn OKL_TRX_QUOTES_B.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
38: date_requested OKL_TRX_QUOTES_B.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
39: date_proposal OKL_TRX_QUOTES_B.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
32: payment_frequency OKL_TRX_QUOTES_B.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
33: early_termination_yn OKL_TRX_QUOTES_B.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
34: partial_yn OKL_TRX_QUOTES_B.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
35: preproceeds_yn OKL_TRX_QUOTES_B.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
36: summary_format_yn OKL_TRX_QUOTES_B.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
37: consolidated_yn OKL_TRX_QUOTES_B.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
38: date_requested OKL_TRX_QUOTES_B.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
39: date_proposal OKL_TRX_QUOTES_B.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
40: date_effective_to OKL_TRX_QUOTES_B.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
33: early_termination_yn OKL_TRX_QUOTES_B.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
34: partial_yn OKL_TRX_QUOTES_B.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
35: preproceeds_yn OKL_TRX_QUOTES_B.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
36: summary_format_yn OKL_TRX_QUOTES_B.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
37: consolidated_yn OKL_TRX_QUOTES_B.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
38: date_requested OKL_TRX_QUOTES_B.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
39: date_proposal OKL_TRX_QUOTES_B.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
40: date_effective_to OKL_TRX_QUOTES_B.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
41: date_accepted OKL_TRX_QUOTES_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
34: partial_yn OKL_TRX_QUOTES_B.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
35: preproceeds_yn OKL_TRX_QUOTES_B.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
36: summary_format_yn OKL_TRX_QUOTES_B.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
37: consolidated_yn OKL_TRX_QUOTES_B.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
38: date_requested OKL_TRX_QUOTES_B.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
39: date_proposal OKL_TRX_QUOTES_B.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
40: date_effective_to OKL_TRX_QUOTES_B.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
41: date_accepted OKL_TRX_QUOTES_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
42: payment_received_yn OKL_TRX_QUOTES_B.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
35: preproceeds_yn OKL_TRX_QUOTES_B.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
36: summary_format_yn OKL_TRX_QUOTES_B.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
37: consolidated_yn OKL_TRX_QUOTES_B.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
38: date_requested OKL_TRX_QUOTES_B.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
39: date_proposal OKL_TRX_QUOTES_B.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
40: date_effective_to OKL_TRX_QUOTES_B.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
41: date_accepted OKL_TRX_QUOTES_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
42: payment_received_yn OKL_TRX_QUOTES_B.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
43: requested_by NUMBER := OKC_API.G_MISS_NUM,
36: summary_format_yn OKL_TRX_QUOTES_B.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
37: consolidated_yn OKL_TRX_QUOTES_B.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
38: date_requested OKL_TRX_QUOTES_B.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
39: date_proposal OKL_TRX_QUOTES_B.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
40: date_effective_to OKL_TRX_QUOTES_B.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
41: date_accepted OKL_TRX_QUOTES_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
42: payment_received_yn OKL_TRX_QUOTES_B.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
43: requested_by NUMBER := OKC_API.G_MISS_NUM,
44: approved_yn OKL_TRX_QUOTES_B.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
37: consolidated_yn OKL_TRX_QUOTES_B.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
38: date_requested OKL_TRX_QUOTES_B.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
39: date_proposal OKL_TRX_QUOTES_B.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
40: date_effective_to OKL_TRX_QUOTES_B.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
41: date_accepted OKL_TRX_QUOTES_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
42: payment_received_yn OKL_TRX_QUOTES_B.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
43: requested_by NUMBER := OKC_API.G_MISS_NUM,
44: approved_yn OKL_TRX_QUOTES_B.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: accepted_yn OKL_TRX_QUOTES_B.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
38: date_requested OKL_TRX_QUOTES_B.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
39: date_proposal OKL_TRX_QUOTES_B.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
40: date_effective_to OKL_TRX_QUOTES_B.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
41: date_accepted OKL_TRX_QUOTES_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
42: payment_received_yn OKL_TRX_QUOTES_B.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
43: requested_by NUMBER := OKC_API.G_MISS_NUM,
44: approved_yn OKL_TRX_QUOTES_B.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: accepted_yn OKL_TRX_QUOTES_B.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
46: date_payment_received OKL_TRX_QUOTES_B.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
39: date_proposal OKL_TRX_QUOTES_B.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
40: date_effective_to OKL_TRX_QUOTES_B.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
41: date_accepted OKL_TRX_QUOTES_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
42: payment_received_yn OKL_TRX_QUOTES_B.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
43: requested_by NUMBER := OKC_API.G_MISS_NUM,
44: approved_yn OKL_TRX_QUOTES_B.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: accepted_yn OKL_TRX_QUOTES_B.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
46: date_payment_received OKL_TRX_QUOTES_B.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
47: approved_by NUMBER := OKC_API.G_MISS_NUM,
40: date_effective_to OKL_TRX_QUOTES_B.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
41: date_accepted OKL_TRX_QUOTES_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
42: payment_received_yn OKL_TRX_QUOTES_B.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
43: requested_by NUMBER := OKC_API.G_MISS_NUM,
44: approved_yn OKL_TRX_QUOTES_B.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: accepted_yn OKL_TRX_QUOTES_B.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
46: date_payment_received OKL_TRX_QUOTES_B.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
47: approved_by NUMBER := OKC_API.G_MISS_NUM,
48: org_id NUMBER := OKC_API.G_MISS_NUM,
41: date_accepted OKL_TRX_QUOTES_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
42: payment_received_yn OKL_TRX_QUOTES_B.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
43: requested_by NUMBER := OKC_API.G_MISS_NUM,
44: approved_yn OKL_TRX_QUOTES_B.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: accepted_yn OKL_TRX_QUOTES_B.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
46: date_payment_received OKL_TRX_QUOTES_B.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
47: approved_by NUMBER := OKC_API.G_MISS_NUM,
48: org_id NUMBER := OKC_API.G_MISS_NUM,
49: request_id NUMBER := OKC_API.G_MISS_NUM,
42: payment_received_yn OKL_TRX_QUOTES_B.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
43: requested_by NUMBER := OKC_API.G_MISS_NUM,
44: approved_yn OKL_TRX_QUOTES_B.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: accepted_yn OKL_TRX_QUOTES_B.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
46: date_payment_received OKL_TRX_QUOTES_B.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
47: approved_by NUMBER := OKC_API.G_MISS_NUM,
48: org_id NUMBER := OKC_API.G_MISS_NUM,
49: request_id NUMBER := OKC_API.G_MISS_NUM,
50: program_application_id NUMBER := OKC_API.G_MISS_NUM,
43: requested_by NUMBER := OKC_API.G_MISS_NUM,
44: approved_yn OKL_TRX_QUOTES_B.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: accepted_yn OKL_TRX_QUOTES_B.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
46: date_payment_received OKL_TRX_QUOTES_B.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
47: approved_by NUMBER := OKC_API.G_MISS_NUM,
48: org_id NUMBER := OKC_API.G_MISS_NUM,
49: request_id NUMBER := OKC_API.G_MISS_NUM,
50: program_application_id NUMBER := OKC_API.G_MISS_NUM,
51: program_id NUMBER := OKC_API.G_MISS_NUM,
44: approved_yn OKL_TRX_QUOTES_B.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: accepted_yn OKL_TRX_QUOTES_B.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
46: date_payment_received OKL_TRX_QUOTES_B.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
47: approved_by NUMBER := OKC_API.G_MISS_NUM,
48: org_id NUMBER := OKC_API.G_MISS_NUM,
49: request_id NUMBER := OKC_API.G_MISS_NUM,
50: program_application_id NUMBER := OKC_API.G_MISS_NUM,
51: program_id NUMBER := OKC_API.G_MISS_NUM,
52: program_update_date OKL_TRX_QUOTES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: accepted_yn OKL_TRX_QUOTES_B.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
46: date_payment_received OKL_TRX_QUOTES_B.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
47: approved_by NUMBER := OKC_API.G_MISS_NUM,
48: org_id NUMBER := OKC_API.G_MISS_NUM,
49: request_id NUMBER := OKC_API.G_MISS_NUM,
50: program_application_id NUMBER := OKC_API.G_MISS_NUM,
51: program_id NUMBER := OKC_API.G_MISS_NUM,
52: program_update_date OKL_TRX_QUOTES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53: attribute_category OKL_TRX_QUOTES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
46: date_payment_received OKL_TRX_QUOTES_B.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
47: approved_by NUMBER := OKC_API.G_MISS_NUM,
48: org_id NUMBER := OKC_API.G_MISS_NUM,
49: request_id NUMBER := OKC_API.G_MISS_NUM,
50: program_application_id NUMBER := OKC_API.G_MISS_NUM,
51: program_id NUMBER := OKC_API.G_MISS_NUM,
52: program_update_date OKL_TRX_QUOTES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53: attribute_category OKL_TRX_QUOTES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
54: attribute1 OKL_TRX_QUOTES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
47: approved_by NUMBER := OKC_API.G_MISS_NUM,
48: org_id NUMBER := OKC_API.G_MISS_NUM,
49: request_id NUMBER := OKC_API.G_MISS_NUM,
50: program_application_id NUMBER := OKC_API.G_MISS_NUM,
51: program_id NUMBER := OKC_API.G_MISS_NUM,
52: program_update_date OKL_TRX_QUOTES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53: attribute_category OKL_TRX_QUOTES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
54: attribute1 OKL_TRX_QUOTES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
55: attribute2 OKL_TRX_QUOTES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
48: org_id NUMBER := OKC_API.G_MISS_NUM,
49: request_id NUMBER := OKC_API.G_MISS_NUM,
50: program_application_id NUMBER := OKC_API.G_MISS_NUM,
51: program_id NUMBER := OKC_API.G_MISS_NUM,
52: program_update_date OKL_TRX_QUOTES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53: attribute_category OKL_TRX_QUOTES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
54: attribute1 OKL_TRX_QUOTES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
55: attribute2 OKL_TRX_QUOTES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
56: attribute3 OKL_TRX_QUOTES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
49: request_id NUMBER := OKC_API.G_MISS_NUM,
50: program_application_id NUMBER := OKC_API.G_MISS_NUM,
51: program_id NUMBER := OKC_API.G_MISS_NUM,
52: program_update_date OKL_TRX_QUOTES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53: attribute_category OKL_TRX_QUOTES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
54: attribute1 OKL_TRX_QUOTES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
55: attribute2 OKL_TRX_QUOTES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
56: attribute3 OKL_TRX_QUOTES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
57: attribute4 OKL_TRX_QUOTES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
50: program_application_id NUMBER := OKC_API.G_MISS_NUM,
51: program_id NUMBER := OKC_API.G_MISS_NUM,
52: program_update_date OKL_TRX_QUOTES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53: attribute_category OKL_TRX_QUOTES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
54: attribute1 OKL_TRX_QUOTES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
55: attribute2 OKL_TRX_QUOTES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
56: attribute3 OKL_TRX_QUOTES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
57: attribute4 OKL_TRX_QUOTES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
58: attribute5 OKL_TRX_QUOTES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
51: program_id NUMBER := OKC_API.G_MISS_NUM,
52: program_update_date OKL_TRX_QUOTES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53: attribute_category OKL_TRX_QUOTES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
54: attribute1 OKL_TRX_QUOTES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
55: attribute2 OKL_TRX_QUOTES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
56: attribute3 OKL_TRX_QUOTES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
57: attribute4 OKL_TRX_QUOTES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
58: attribute5 OKL_TRX_QUOTES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
59: attribute6 OKL_TRX_QUOTES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
52: program_update_date OKL_TRX_QUOTES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53: attribute_category OKL_TRX_QUOTES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
54: attribute1 OKL_TRX_QUOTES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
55: attribute2 OKL_TRX_QUOTES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
56: attribute3 OKL_TRX_QUOTES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
57: attribute4 OKL_TRX_QUOTES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
58: attribute5 OKL_TRX_QUOTES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
59: attribute6 OKL_TRX_QUOTES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
60: attribute7 OKL_TRX_QUOTES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
53: attribute_category OKL_TRX_QUOTES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
54: attribute1 OKL_TRX_QUOTES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
55: attribute2 OKL_TRX_QUOTES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
56: attribute3 OKL_TRX_QUOTES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
57: attribute4 OKL_TRX_QUOTES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
58: attribute5 OKL_TRX_QUOTES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
59: attribute6 OKL_TRX_QUOTES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
60: attribute7 OKL_TRX_QUOTES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
61: attribute8 OKL_TRX_QUOTES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
54: attribute1 OKL_TRX_QUOTES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
55: attribute2 OKL_TRX_QUOTES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
56: attribute3 OKL_TRX_QUOTES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
57: attribute4 OKL_TRX_QUOTES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
58: attribute5 OKL_TRX_QUOTES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
59: attribute6 OKL_TRX_QUOTES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
60: attribute7 OKL_TRX_QUOTES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
61: attribute8 OKL_TRX_QUOTES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
62: attribute9 OKL_TRX_QUOTES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
55: attribute2 OKL_TRX_QUOTES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
56: attribute3 OKL_TRX_QUOTES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
57: attribute4 OKL_TRX_QUOTES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
58: attribute5 OKL_TRX_QUOTES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
59: attribute6 OKL_TRX_QUOTES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
60: attribute7 OKL_TRX_QUOTES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
61: attribute8 OKL_TRX_QUOTES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
62: attribute9 OKL_TRX_QUOTES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
63: attribute10 OKL_TRX_QUOTES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
56: attribute3 OKL_TRX_QUOTES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
57: attribute4 OKL_TRX_QUOTES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
58: attribute5 OKL_TRX_QUOTES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
59: attribute6 OKL_TRX_QUOTES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
60: attribute7 OKL_TRX_QUOTES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
61: attribute8 OKL_TRX_QUOTES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
62: attribute9 OKL_TRX_QUOTES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
63: attribute10 OKL_TRX_QUOTES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
64: attribute11 OKL_TRX_QUOTES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
57: attribute4 OKL_TRX_QUOTES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
58: attribute5 OKL_TRX_QUOTES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
59: attribute6 OKL_TRX_QUOTES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
60: attribute7 OKL_TRX_QUOTES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
61: attribute8 OKL_TRX_QUOTES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
62: attribute9 OKL_TRX_QUOTES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
63: attribute10 OKL_TRX_QUOTES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
64: attribute11 OKL_TRX_QUOTES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
65: attribute12 OKL_TRX_QUOTES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
58: attribute5 OKL_TRX_QUOTES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
59: attribute6 OKL_TRX_QUOTES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
60: attribute7 OKL_TRX_QUOTES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
61: attribute8 OKL_TRX_QUOTES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
62: attribute9 OKL_TRX_QUOTES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
63: attribute10 OKL_TRX_QUOTES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
64: attribute11 OKL_TRX_QUOTES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
65: attribute12 OKL_TRX_QUOTES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
66: attribute13 OKL_TRX_QUOTES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
59: attribute6 OKL_TRX_QUOTES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
60: attribute7 OKL_TRX_QUOTES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
61: attribute8 OKL_TRX_QUOTES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
62: attribute9 OKL_TRX_QUOTES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
63: attribute10 OKL_TRX_QUOTES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
64: attribute11 OKL_TRX_QUOTES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
65: attribute12 OKL_TRX_QUOTES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
66: attribute13 OKL_TRX_QUOTES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
67: attribute14 OKL_TRX_QUOTES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
60: attribute7 OKL_TRX_QUOTES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
61: attribute8 OKL_TRX_QUOTES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
62: attribute9 OKL_TRX_QUOTES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
63: attribute10 OKL_TRX_QUOTES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
64: attribute11 OKL_TRX_QUOTES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
65: attribute12 OKL_TRX_QUOTES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
66: attribute13 OKL_TRX_QUOTES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
67: attribute14 OKL_TRX_QUOTES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
68: attribute15 OKL_TRX_QUOTES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
61: attribute8 OKL_TRX_QUOTES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
62: attribute9 OKL_TRX_QUOTES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
63: attribute10 OKL_TRX_QUOTES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
64: attribute11 OKL_TRX_QUOTES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
65: attribute12 OKL_TRX_QUOTES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
66: attribute13 OKL_TRX_QUOTES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
67: attribute14 OKL_TRX_QUOTES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
68: attribute15 OKL_TRX_QUOTES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
69: created_by NUMBER := OKC_API.G_MISS_NUM,
62: attribute9 OKL_TRX_QUOTES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
63: attribute10 OKL_TRX_QUOTES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
64: attribute11 OKL_TRX_QUOTES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
65: attribute12 OKL_TRX_QUOTES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
66: attribute13 OKL_TRX_QUOTES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
67: attribute14 OKL_TRX_QUOTES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
68: attribute15 OKL_TRX_QUOTES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
69: created_by NUMBER := OKC_API.G_MISS_NUM,
70: creation_date OKL_TRX_QUOTES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
63: attribute10 OKL_TRX_QUOTES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
64: attribute11 OKL_TRX_QUOTES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
65: attribute12 OKL_TRX_QUOTES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
66: attribute13 OKL_TRX_QUOTES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
67: attribute14 OKL_TRX_QUOTES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
68: attribute15 OKL_TRX_QUOTES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
69: created_by NUMBER := OKC_API.G_MISS_NUM,
70: creation_date OKL_TRX_QUOTES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
64: attribute11 OKL_TRX_QUOTES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
65: attribute12 OKL_TRX_QUOTES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
66: attribute13 OKL_TRX_QUOTES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
67: attribute14 OKL_TRX_QUOTES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
68: attribute15 OKL_TRX_QUOTES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
69: created_by NUMBER := OKC_API.G_MISS_NUM,
70: creation_date OKL_TRX_QUOTES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: last_update_date OKL_TRX_QUOTES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
65: attribute12 OKL_TRX_QUOTES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
66: attribute13 OKL_TRX_QUOTES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
67: attribute14 OKL_TRX_QUOTES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
68: attribute15 OKL_TRX_QUOTES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
69: created_by NUMBER := OKC_API.G_MISS_NUM,
70: creation_date OKL_TRX_QUOTES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: last_update_date OKL_TRX_QUOTES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_login NUMBER := OKC_API.G_MISS_NUM,
66: attribute13 OKL_TRX_QUOTES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
67: attribute14 OKL_TRX_QUOTES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
68: attribute15 OKL_TRX_QUOTES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
69: created_by NUMBER := OKC_API.G_MISS_NUM,
70: creation_date OKL_TRX_QUOTES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: last_update_date OKL_TRX_QUOTES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_login NUMBER := OKC_API.G_MISS_NUM,
74: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
67: attribute14 OKL_TRX_QUOTES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
68: attribute15 OKL_TRX_QUOTES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
69: created_by NUMBER := OKC_API.G_MISS_NUM,
70: creation_date OKL_TRX_QUOTES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: last_update_date OKL_TRX_QUOTES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_login NUMBER := OKC_API.G_MISS_NUM,
74: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
75: purchase_formula OKL_TRX_QUOTES_B.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
68: attribute15 OKL_TRX_QUOTES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
69: created_by NUMBER := OKC_API.G_MISS_NUM,
70: creation_date OKL_TRX_QUOTES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: last_update_date OKL_TRX_QUOTES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_login NUMBER := OKC_API.G_MISS_NUM,
74: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
75: purchase_formula OKL_TRX_QUOTES_B.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
76: asset_value NUMBER := OKC_API.G_MISS_NUM,
69: created_by NUMBER := OKC_API.G_MISS_NUM,
70: creation_date OKL_TRX_QUOTES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: last_update_date OKL_TRX_QUOTES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_login NUMBER := OKC_API.G_MISS_NUM,
74: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
75: purchase_formula OKL_TRX_QUOTES_B.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
76: asset_value NUMBER := OKC_API.G_MISS_NUM,
77: residual_value NUMBER := OKC_API.G_MISS_NUM,
70: creation_date OKL_TRX_QUOTES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: last_update_date OKL_TRX_QUOTES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_login NUMBER := OKC_API.G_MISS_NUM,
74: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
75: purchase_formula OKL_TRX_QUOTES_B.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
76: asset_value NUMBER := OKC_API.G_MISS_NUM,
77: residual_value NUMBER := OKC_API.G_MISS_NUM,
78: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: last_update_date OKL_TRX_QUOTES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_login NUMBER := OKC_API.G_MISS_NUM,
74: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
75: purchase_formula OKL_TRX_QUOTES_B.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
76: asset_value NUMBER := OKC_API.G_MISS_NUM,
77: residual_value NUMBER := OKC_API.G_MISS_NUM,
78: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
79: gain_loss NUMBER := OKC_API.G_MISS_NUM,
72: last_update_date OKL_TRX_QUOTES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
73: last_update_login NUMBER := OKC_API.G_MISS_NUM,
74: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
75: purchase_formula OKL_TRX_QUOTES_B.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
76: asset_value NUMBER := OKC_API.G_MISS_NUM,
77: residual_value NUMBER := OKC_API.G_MISS_NUM,
78: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
79: gain_loss NUMBER := OKC_API.G_MISS_NUM,
80: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
73: last_update_login NUMBER := OKC_API.G_MISS_NUM,
74: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
75: purchase_formula OKL_TRX_QUOTES_B.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
76: asset_value NUMBER := OKC_API.G_MISS_NUM,
77: residual_value NUMBER := OKC_API.G_MISS_NUM,
78: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
79: gain_loss NUMBER := OKC_API.G_MISS_NUM,
80: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
81: -- BAKUCHIB - 2667636 - start
74: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
75: purchase_formula OKL_TRX_QUOTES_B.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
76: asset_value NUMBER := OKC_API.G_MISS_NUM,
77: residual_value NUMBER := OKC_API.G_MISS_NUM,
78: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
79: gain_loss NUMBER := OKC_API.G_MISS_NUM,
80: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
81: -- BAKUCHIB - 2667636 - start
82: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
75: purchase_formula OKL_TRX_QUOTES_B.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
76: asset_value NUMBER := OKC_API.G_MISS_NUM,
77: residual_value NUMBER := OKC_API.G_MISS_NUM,
78: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
79: gain_loss NUMBER := OKC_API.G_MISS_NUM,
80: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
81: -- BAKUCHIB - 2667636 - start
82: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
76: asset_value NUMBER := OKC_API.G_MISS_NUM,
77: residual_value NUMBER := OKC_API.G_MISS_NUM,
78: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
79: gain_loss NUMBER := OKC_API.G_MISS_NUM,
80: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
81: -- BAKUCHIB - 2667636 - start
82: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
84: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
78: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
79: gain_loss NUMBER := OKC_API.G_MISS_NUM,
80: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
81: -- BAKUCHIB - 2667636 - start
82: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
84: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
85: currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
86: currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
79: gain_loss NUMBER := OKC_API.G_MISS_NUM,
80: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
81: -- BAKUCHIB - 2667636 - start
82: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
84: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
85: currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
86: currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
87: -- BAKUCHIB - 2667636 - End
80: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
81: -- BAKUCHIB - 2667636 - start
82: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
84: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
85: currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
86: currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
87: -- BAKUCHIB - 2667636 - End
88: legal_entity_id OKL_TRX_QUOTES_B.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM, --dkagrawa for LE Uptake
81: -- BAKUCHIB - 2667636 - start
82: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
84: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
85: currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
86: currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
87: -- BAKUCHIB - 2667636 - End
88: legal_entity_id OKL_TRX_QUOTES_B.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM, --dkagrawa for LE Uptake
89: repo_quote_indicator_yn OKL_TRX_QUOTES_B.REPO_QUOTE_INDICATOR_YN%TYPE := OKL_API.G_MISS_CHAR -- AKP:REPO-QUOTE-START-END 6599890
82: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
84: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
85: currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
86: currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
87: -- BAKUCHIB - 2667636 - End
88: legal_entity_id OKL_TRX_QUOTES_B.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM, --dkagrawa for LE Uptake
89: repo_quote_indicator_yn OKL_TRX_QUOTES_B.REPO_QUOTE_INDICATOR_YN%TYPE := OKL_API.G_MISS_CHAR -- AKP:REPO-QUOTE-START-END 6599890
90: );
92: g_miss_qte_rec qte_rec_type;
93: TYPE qte_tbl_type IS TABLE OF qte_rec_type
94: INDEX BY BINARY_INTEGER;
95: TYPE okl_trx_quotes_tl_rec_type IS RECORD (
96: id NUMBER := OKC_API.G_MISS_NUM,
97: language OKL_TRX_QUOTES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
98: source_lang OKL_TRX_QUOTES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
99: sfwt_flag OKL_TRX_QUOTES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
100: comments OKL_TRX_QUOTES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
93: TYPE qte_tbl_type IS TABLE OF qte_rec_type
94: INDEX BY BINARY_INTEGER;
95: TYPE okl_trx_quotes_tl_rec_type IS RECORD (
96: id NUMBER := OKC_API.G_MISS_NUM,
97: language OKL_TRX_QUOTES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
98: source_lang OKL_TRX_QUOTES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
99: sfwt_flag OKL_TRX_QUOTES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
100: comments OKL_TRX_QUOTES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
101: created_by NUMBER := OKC_API.G_MISS_NUM,
94: INDEX BY BINARY_INTEGER;
95: TYPE okl_trx_quotes_tl_rec_type IS RECORD (
96: id NUMBER := OKC_API.G_MISS_NUM,
97: language OKL_TRX_QUOTES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
98: source_lang OKL_TRX_QUOTES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
99: sfwt_flag OKL_TRX_QUOTES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
100: comments OKL_TRX_QUOTES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
101: created_by NUMBER := OKC_API.G_MISS_NUM,
102: creation_date OKL_TRX_QUOTES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
95: TYPE okl_trx_quotes_tl_rec_type IS RECORD (
96: id NUMBER := OKC_API.G_MISS_NUM,
97: language OKL_TRX_QUOTES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
98: source_lang OKL_TRX_QUOTES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
99: sfwt_flag OKL_TRX_QUOTES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
100: comments OKL_TRX_QUOTES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
101: created_by NUMBER := OKC_API.G_MISS_NUM,
102: creation_date OKL_TRX_QUOTES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
103: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
96: id NUMBER := OKC_API.G_MISS_NUM,
97: language OKL_TRX_QUOTES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
98: source_lang OKL_TRX_QUOTES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
99: sfwt_flag OKL_TRX_QUOTES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
100: comments OKL_TRX_QUOTES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
101: created_by NUMBER := OKC_API.G_MISS_NUM,
102: creation_date OKL_TRX_QUOTES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
103: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
104: last_update_date OKL_TRX_QUOTES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97: language OKL_TRX_QUOTES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
98: source_lang OKL_TRX_QUOTES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
99: sfwt_flag OKL_TRX_QUOTES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
100: comments OKL_TRX_QUOTES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
101: created_by NUMBER := OKC_API.G_MISS_NUM,
102: creation_date OKL_TRX_QUOTES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
103: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
104: last_update_date OKL_TRX_QUOTES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
105: last_update_login NUMBER := OKC_API.G_MISS_NUM);
98: source_lang OKL_TRX_QUOTES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
99: sfwt_flag OKL_TRX_QUOTES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
100: comments OKL_TRX_QUOTES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
101: created_by NUMBER := OKC_API.G_MISS_NUM,
102: creation_date OKL_TRX_QUOTES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
103: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
104: last_update_date OKL_TRX_QUOTES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
105: last_update_login NUMBER := OKC_API.G_MISS_NUM);
106: g_miss_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
99: sfwt_flag OKL_TRX_QUOTES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
100: comments OKL_TRX_QUOTES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
101: created_by NUMBER := OKC_API.G_MISS_NUM,
102: creation_date OKL_TRX_QUOTES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
103: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
104: last_update_date OKL_TRX_QUOTES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
105: last_update_login NUMBER := OKC_API.G_MISS_NUM);
106: g_miss_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
107: TYPE okl_trx_quotes_tl_tbl_type IS TABLE OF okl_trx_quotes_tl_rec_type
100: comments OKL_TRX_QUOTES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
101: created_by NUMBER := OKC_API.G_MISS_NUM,
102: creation_date OKL_TRX_QUOTES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
103: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
104: last_update_date OKL_TRX_QUOTES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
105: last_update_login NUMBER := OKC_API.G_MISS_NUM);
106: g_miss_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
107: TYPE okl_trx_quotes_tl_tbl_type IS TABLE OF okl_trx_quotes_tl_rec_type
108: INDEX BY BINARY_INTEGER;
101: created_by NUMBER := OKC_API.G_MISS_NUM,
102: creation_date OKL_TRX_QUOTES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
103: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
104: last_update_date OKL_TRX_QUOTES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
105: last_update_login NUMBER := OKC_API.G_MISS_NUM);
106: g_miss_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
107: TYPE okl_trx_quotes_tl_tbl_type IS TABLE OF okl_trx_quotes_tl_rec_type
108: INDEX BY BINARY_INTEGER;
109: TYPE qtev_rec_type IS RECORD (
106: g_miss_okl_trx_quotes_tl_rec okl_trx_quotes_tl_rec_type;
107: TYPE okl_trx_quotes_tl_tbl_type IS TABLE OF okl_trx_quotes_tl_rec_type
108: INDEX BY BINARY_INTEGER;
109: TYPE qtev_rec_type IS RECORD (
110: id NUMBER := OKC_API.G_MISS_NUM,
111: object_version_number NUMBER := OKC_API.G_MISS_NUM,
112: sfwt_flag OKL_TRX_QUOTES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
113: qrs_code OKL_TRX_QUOTES_V.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
114: qst_code OKL_TRX_QUOTES_V.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
107: TYPE okl_trx_quotes_tl_tbl_type IS TABLE OF okl_trx_quotes_tl_rec_type
108: INDEX BY BINARY_INTEGER;
109: TYPE qtev_rec_type IS RECORD (
110: id NUMBER := OKC_API.G_MISS_NUM,
111: object_version_number NUMBER := OKC_API.G_MISS_NUM,
112: sfwt_flag OKL_TRX_QUOTES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
113: qrs_code OKL_TRX_QUOTES_V.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
114: qst_code OKL_TRX_QUOTES_V.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
115: qtp_code OKL_TRX_QUOTES_V.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
108: INDEX BY BINARY_INTEGER;
109: TYPE qtev_rec_type IS RECORD (
110: id NUMBER := OKC_API.G_MISS_NUM,
111: object_version_number NUMBER := OKC_API.G_MISS_NUM,
112: sfwt_flag OKL_TRX_QUOTES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
113: qrs_code OKL_TRX_QUOTES_V.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
114: qst_code OKL_TRX_QUOTES_V.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
115: qtp_code OKL_TRX_QUOTES_V.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
116: trn_code OKL_TRX_QUOTES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
109: TYPE qtev_rec_type IS RECORD (
110: id NUMBER := OKC_API.G_MISS_NUM,
111: object_version_number NUMBER := OKC_API.G_MISS_NUM,
112: sfwt_flag OKL_TRX_QUOTES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
113: qrs_code OKL_TRX_QUOTES_V.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
114: qst_code OKL_TRX_QUOTES_V.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
115: qtp_code OKL_TRX_QUOTES_V.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
116: trn_code OKL_TRX_QUOTES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
117: pop_code_end OKL_TRX_QUOTES_V.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
110: id NUMBER := OKC_API.G_MISS_NUM,
111: object_version_number NUMBER := OKC_API.G_MISS_NUM,
112: sfwt_flag OKL_TRX_QUOTES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
113: qrs_code OKL_TRX_QUOTES_V.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
114: qst_code OKL_TRX_QUOTES_V.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
115: qtp_code OKL_TRX_QUOTES_V.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
116: trn_code OKL_TRX_QUOTES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
117: pop_code_end OKL_TRX_QUOTES_V.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
118: pop_code_early OKL_TRX_QUOTES_V.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
111: object_version_number NUMBER := OKC_API.G_MISS_NUM,
112: sfwt_flag OKL_TRX_QUOTES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
113: qrs_code OKL_TRX_QUOTES_V.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
114: qst_code OKL_TRX_QUOTES_V.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
115: qtp_code OKL_TRX_QUOTES_V.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
116: trn_code OKL_TRX_QUOTES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
117: pop_code_end OKL_TRX_QUOTES_V.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
118: pop_code_early OKL_TRX_QUOTES_V.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
119: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
112: sfwt_flag OKL_TRX_QUOTES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
113: qrs_code OKL_TRX_QUOTES_V.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
114: qst_code OKL_TRX_QUOTES_V.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
115: qtp_code OKL_TRX_QUOTES_V.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
116: trn_code OKL_TRX_QUOTES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
117: pop_code_end OKL_TRX_QUOTES_V.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
118: pop_code_early OKL_TRX_QUOTES_V.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
119: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
120: khr_id NUMBER := OKC_API.G_MISS_NUM,
113: qrs_code OKL_TRX_QUOTES_V.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
114: qst_code OKL_TRX_QUOTES_V.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
115: qtp_code OKL_TRX_QUOTES_V.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
116: trn_code OKL_TRX_QUOTES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
117: pop_code_end OKL_TRX_QUOTES_V.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
118: pop_code_early OKL_TRX_QUOTES_V.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
119: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
120: khr_id NUMBER := OKC_API.G_MISS_NUM,
121: art_id NUMBER := OKC_API.G_MISS_NUM,
114: qst_code OKL_TRX_QUOTES_V.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,
115: qtp_code OKL_TRX_QUOTES_V.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
116: trn_code OKL_TRX_QUOTES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
117: pop_code_end OKL_TRX_QUOTES_V.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
118: pop_code_early OKL_TRX_QUOTES_V.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
119: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
120: khr_id NUMBER := OKC_API.G_MISS_NUM,
121: art_id NUMBER := OKC_API.G_MISS_NUM,
122: pdt_id NUMBER := OKC_API.G_MISS_NUM,
115: qtp_code OKL_TRX_QUOTES_V.QTP_CODE%TYPE := OKC_API.G_MISS_CHAR,
116: trn_code OKL_TRX_QUOTES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
117: pop_code_end OKL_TRX_QUOTES_V.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
118: pop_code_early OKL_TRX_QUOTES_V.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
119: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
120: khr_id NUMBER := OKC_API.G_MISS_NUM,
121: art_id NUMBER := OKC_API.G_MISS_NUM,
122: pdt_id NUMBER := OKC_API.G_MISS_NUM,
123: early_termination_yn OKL_TRX_QUOTES_V.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
116: trn_code OKL_TRX_QUOTES_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
117: pop_code_end OKL_TRX_QUOTES_V.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
118: pop_code_early OKL_TRX_QUOTES_V.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
119: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
120: khr_id NUMBER := OKC_API.G_MISS_NUM,
121: art_id NUMBER := OKC_API.G_MISS_NUM,
122: pdt_id NUMBER := OKC_API.G_MISS_NUM,
123: early_termination_yn OKL_TRX_QUOTES_V.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
124: partial_yn OKL_TRX_QUOTES_V.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
117: pop_code_end OKL_TRX_QUOTES_V.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,
118: pop_code_early OKL_TRX_QUOTES_V.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
119: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
120: khr_id NUMBER := OKC_API.G_MISS_NUM,
121: art_id NUMBER := OKC_API.G_MISS_NUM,
122: pdt_id NUMBER := OKC_API.G_MISS_NUM,
123: early_termination_yn OKL_TRX_QUOTES_V.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
124: partial_yn OKL_TRX_QUOTES_V.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
125: preproceeds_yn OKL_TRX_QUOTES_V.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
118: pop_code_early OKL_TRX_QUOTES_V.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,
119: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
120: khr_id NUMBER := OKC_API.G_MISS_NUM,
121: art_id NUMBER := OKC_API.G_MISS_NUM,
122: pdt_id NUMBER := OKC_API.G_MISS_NUM,
123: early_termination_yn OKL_TRX_QUOTES_V.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
124: partial_yn OKL_TRX_QUOTES_V.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
125: preproceeds_yn OKL_TRX_QUOTES_V.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
126: date_requested OKL_TRX_QUOTES_V.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
119: consolidated_qte_id NUMBER := OKC_API.G_MISS_NUM,
120: khr_id NUMBER := OKC_API.G_MISS_NUM,
121: art_id NUMBER := OKC_API.G_MISS_NUM,
122: pdt_id NUMBER := OKC_API.G_MISS_NUM,
123: early_termination_yn OKL_TRX_QUOTES_V.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
124: partial_yn OKL_TRX_QUOTES_V.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
125: preproceeds_yn OKL_TRX_QUOTES_V.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
126: date_requested OKL_TRX_QUOTES_V.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
127: date_proposal OKL_TRX_QUOTES_V.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
120: khr_id NUMBER := OKC_API.G_MISS_NUM,
121: art_id NUMBER := OKC_API.G_MISS_NUM,
122: pdt_id NUMBER := OKC_API.G_MISS_NUM,
123: early_termination_yn OKL_TRX_QUOTES_V.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
124: partial_yn OKL_TRX_QUOTES_V.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
125: preproceeds_yn OKL_TRX_QUOTES_V.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
126: date_requested OKL_TRX_QUOTES_V.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
127: date_proposal OKL_TRX_QUOTES_V.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
128: date_effective_to OKL_TRX_QUOTES_V.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
121: art_id NUMBER := OKC_API.G_MISS_NUM,
122: pdt_id NUMBER := OKC_API.G_MISS_NUM,
123: early_termination_yn OKL_TRX_QUOTES_V.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
124: partial_yn OKL_TRX_QUOTES_V.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
125: preproceeds_yn OKL_TRX_QUOTES_V.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
126: date_requested OKL_TRX_QUOTES_V.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
127: date_proposal OKL_TRX_QUOTES_V.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
128: date_effective_to OKL_TRX_QUOTES_V.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
129: date_accepted OKL_TRX_QUOTES_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
122: pdt_id NUMBER := OKC_API.G_MISS_NUM,
123: early_termination_yn OKL_TRX_QUOTES_V.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
124: partial_yn OKL_TRX_QUOTES_V.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
125: preproceeds_yn OKL_TRX_QUOTES_V.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
126: date_requested OKL_TRX_QUOTES_V.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
127: date_proposal OKL_TRX_QUOTES_V.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
128: date_effective_to OKL_TRX_QUOTES_V.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
129: date_accepted OKL_TRX_QUOTES_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
130: summary_format_yn OKL_TRX_QUOTES_V.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
123: early_termination_yn OKL_TRX_QUOTES_V.EARLY_TERMINATION_YN%TYPE := OKC_API.G_MISS_CHAR,
124: partial_yn OKL_TRX_QUOTES_V.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
125: preproceeds_yn OKL_TRX_QUOTES_V.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
126: date_requested OKL_TRX_QUOTES_V.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
127: date_proposal OKL_TRX_QUOTES_V.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
128: date_effective_to OKL_TRX_QUOTES_V.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
129: date_accepted OKL_TRX_QUOTES_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
130: summary_format_yn OKL_TRX_QUOTES_V.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
131: consolidated_yn OKL_TRX_QUOTES_V.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
124: partial_yn OKL_TRX_QUOTES_V.PARTIAL_YN%TYPE := OKC_API.G_MISS_CHAR,
125: preproceeds_yn OKL_TRX_QUOTES_V.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
126: date_requested OKL_TRX_QUOTES_V.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
127: date_proposal OKL_TRX_QUOTES_V.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
128: date_effective_to OKL_TRX_QUOTES_V.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
129: date_accepted OKL_TRX_QUOTES_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
130: summary_format_yn OKL_TRX_QUOTES_V.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
131: consolidated_yn OKL_TRX_QUOTES_V.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
132: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
125: preproceeds_yn OKL_TRX_QUOTES_V.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,
126: date_requested OKL_TRX_QUOTES_V.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
127: date_proposal OKL_TRX_QUOTES_V.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
128: date_effective_to OKL_TRX_QUOTES_V.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
129: date_accepted OKL_TRX_QUOTES_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
130: summary_format_yn OKL_TRX_QUOTES_V.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
131: consolidated_yn OKL_TRX_QUOTES_V.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
132: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
133: residual_amount NUMBER := OKC_API.G_MISS_NUM,
126: date_requested OKL_TRX_QUOTES_V.DATE_REQUESTED%TYPE := OKC_API.G_MISS_DATE,
127: date_proposal OKL_TRX_QUOTES_V.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
128: date_effective_to OKL_TRX_QUOTES_V.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
129: date_accepted OKL_TRX_QUOTES_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
130: summary_format_yn OKL_TRX_QUOTES_V.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
131: consolidated_yn OKL_TRX_QUOTES_V.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
132: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
133: residual_amount NUMBER := OKC_API.G_MISS_NUM,
134: yield NUMBER := OKC_API.G_MISS_NUM,
127: date_proposal OKL_TRX_QUOTES_V.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,
128: date_effective_to OKL_TRX_QUOTES_V.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
129: date_accepted OKL_TRX_QUOTES_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
130: summary_format_yn OKL_TRX_QUOTES_V.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
131: consolidated_yn OKL_TRX_QUOTES_V.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
132: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
133: residual_amount NUMBER := OKC_API.G_MISS_NUM,
134: yield NUMBER := OKC_API.G_MISS_NUM,
135: rent_amount NUMBER := OKC_API.G_MISS_NUM,
128: date_effective_to OKL_TRX_QUOTES_V.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,
129: date_accepted OKL_TRX_QUOTES_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
130: summary_format_yn OKL_TRX_QUOTES_V.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
131: consolidated_yn OKL_TRX_QUOTES_V.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
132: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
133: residual_amount NUMBER := OKC_API.G_MISS_NUM,
134: yield NUMBER := OKC_API.G_MISS_NUM,
135: rent_amount NUMBER := OKC_API.G_MISS_NUM,
136: date_restructure_end OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
129: date_accepted OKL_TRX_QUOTES_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,
130: summary_format_yn OKL_TRX_QUOTES_V.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
131: consolidated_yn OKL_TRX_QUOTES_V.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
132: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
133: residual_amount NUMBER := OKC_API.G_MISS_NUM,
134: yield NUMBER := OKC_API.G_MISS_NUM,
135: rent_amount NUMBER := OKC_API.G_MISS_NUM,
136: date_restructure_end OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
137: date_restructure_start OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
130: summary_format_yn OKL_TRX_QUOTES_V.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,
131: consolidated_yn OKL_TRX_QUOTES_V.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
132: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
133: residual_amount NUMBER := OKC_API.G_MISS_NUM,
134: yield NUMBER := OKC_API.G_MISS_NUM,
135: rent_amount NUMBER := OKC_API.G_MISS_NUM,
136: date_restructure_end OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
137: date_restructure_start OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
138: term NUMBER := OKC_API.G_MISS_NUM,
131: consolidated_yn OKL_TRX_QUOTES_V.CONSOLIDATED_YN%TYPE := OKC_API.G_MISS_CHAR,
132: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
133: residual_amount NUMBER := OKC_API.G_MISS_NUM,
134: yield NUMBER := OKC_API.G_MISS_NUM,
135: rent_amount NUMBER := OKC_API.G_MISS_NUM,
136: date_restructure_end OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
137: date_restructure_start OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
138: term NUMBER := OKC_API.G_MISS_NUM,
139: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
132: principal_paydown_amount NUMBER := OKC_API.G_MISS_NUM,
133: residual_amount NUMBER := OKC_API.G_MISS_NUM,
134: yield NUMBER := OKC_API.G_MISS_NUM,
135: rent_amount NUMBER := OKC_API.G_MISS_NUM,
136: date_restructure_end OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
137: date_restructure_start OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
138: term NUMBER := OKC_API.G_MISS_NUM,
139: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
140: comments OKL_TRX_QUOTES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
133: residual_amount NUMBER := OKC_API.G_MISS_NUM,
134: yield NUMBER := OKC_API.G_MISS_NUM,
135: rent_amount NUMBER := OKC_API.G_MISS_NUM,
136: date_restructure_end OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
137: date_restructure_start OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
138: term NUMBER := OKC_API.G_MISS_NUM,
139: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
140: comments OKL_TRX_QUOTES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
141: date_due OKL_TRX_QUOTES_V.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
134: yield NUMBER := OKC_API.G_MISS_NUM,
135: rent_amount NUMBER := OKC_API.G_MISS_NUM,
136: date_restructure_end OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
137: date_restructure_start OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
138: term NUMBER := OKC_API.G_MISS_NUM,
139: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
140: comments OKL_TRX_QUOTES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
141: date_due OKL_TRX_QUOTES_V.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
142: payment_frequency OKL_TRX_QUOTES_V.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
135: rent_amount NUMBER := OKC_API.G_MISS_NUM,
136: date_restructure_end OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
137: date_restructure_start OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
138: term NUMBER := OKC_API.G_MISS_NUM,
139: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
140: comments OKL_TRX_QUOTES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
141: date_due OKL_TRX_QUOTES_V.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
142: payment_frequency OKL_TRX_QUOTES_V.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
143: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
136: date_restructure_end OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,
137: date_restructure_start OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
138: term NUMBER := OKC_API.G_MISS_NUM,
139: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
140: comments OKL_TRX_QUOTES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
141: date_due OKL_TRX_QUOTES_V.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
142: payment_frequency OKL_TRX_QUOTES_V.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
143: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
144: date_effective_from OKL_TRX_QUOTES_V.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
137: date_restructure_start OKL_TRX_QUOTES_V.DATE_RESTRUCTURE_START%TYPE := OKC_API.G_MISS_DATE,
138: term NUMBER := OKC_API.G_MISS_NUM,
139: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
140: comments OKL_TRX_QUOTES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
141: date_due OKL_TRX_QUOTES_V.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
142: payment_frequency OKL_TRX_QUOTES_V.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
143: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
144: date_effective_from OKL_TRX_QUOTES_V.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
145: quote_number NUMBER := OKC_API.G_MISS_NUM,
138: term NUMBER := OKC_API.G_MISS_NUM,
139: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
140: comments OKL_TRX_QUOTES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
141: date_due OKL_TRX_QUOTES_V.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
142: payment_frequency OKL_TRX_QUOTES_V.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
143: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
144: date_effective_from OKL_TRX_QUOTES_V.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
145: quote_number NUMBER := OKC_API.G_MISS_NUM,
146: requested_by NUMBER := OKC_API.G_MISS_NUM,
139: purchase_percent NUMBER := OKC_API.G_MISS_NUM,
140: comments OKL_TRX_QUOTES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
141: date_due OKL_TRX_QUOTES_V.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
142: payment_frequency OKL_TRX_QUOTES_V.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
143: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
144: date_effective_from OKL_TRX_QUOTES_V.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
145: quote_number NUMBER := OKC_API.G_MISS_NUM,
146: requested_by NUMBER := OKC_API.G_MISS_NUM,
147: approved_yn OKL_TRX_QUOTES_V.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
140: comments OKL_TRX_QUOTES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
141: date_due OKL_TRX_QUOTES_V.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
142: payment_frequency OKL_TRX_QUOTES_V.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
143: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
144: date_effective_from OKL_TRX_QUOTES_V.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
145: quote_number NUMBER := OKC_API.G_MISS_NUM,
146: requested_by NUMBER := OKC_API.G_MISS_NUM,
147: approved_yn OKL_TRX_QUOTES_V.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
148: accepted_yn OKL_TRX_QUOTES_V.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
141: date_due OKL_TRX_QUOTES_V.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
142: payment_frequency OKL_TRX_QUOTES_V.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
143: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
144: date_effective_from OKL_TRX_QUOTES_V.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
145: quote_number NUMBER := OKC_API.G_MISS_NUM,
146: requested_by NUMBER := OKC_API.G_MISS_NUM,
147: approved_yn OKL_TRX_QUOTES_V.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
148: accepted_yn OKL_TRX_QUOTES_V.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
149: payment_received_yn OKL_TRX_QUOTES_V.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
142: payment_frequency OKL_TRX_QUOTES_V.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
143: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
144: date_effective_from OKL_TRX_QUOTES_V.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
145: quote_number NUMBER := OKC_API.G_MISS_NUM,
146: requested_by NUMBER := OKC_API.G_MISS_NUM,
147: approved_yn OKL_TRX_QUOTES_V.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
148: accepted_yn OKL_TRX_QUOTES_V.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
149: payment_received_yn OKL_TRX_QUOTES_V.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: date_payment_received OKL_TRX_QUOTES_V.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
143: remaining_payments NUMBER := OKC_API.G_MISS_NUM,
144: date_effective_from OKL_TRX_QUOTES_V.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
145: quote_number NUMBER := OKC_API.G_MISS_NUM,
146: requested_by NUMBER := OKC_API.G_MISS_NUM,
147: approved_yn OKL_TRX_QUOTES_V.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
148: accepted_yn OKL_TRX_QUOTES_V.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
149: payment_received_yn OKL_TRX_QUOTES_V.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: date_payment_received OKL_TRX_QUOTES_V.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
151: attribute_category OKL_TRX_QUOTES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
144: date_effective_from OKL_TRX_QUOTES_V.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,
145: quote_number NUMBER := OKC_API.G_MISS_NUM,
146: requested_by NUMBER := OKC_API.G_MISS_NUM,
147: approved_yn OKL_TRX_QUOTES_V.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
148: accepted_yn OKL_TRX_QUOTES_V.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
149: payment_received_yn OKL_TRX_QUOTES_V.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: date_payment_received OKL_TRX_QUOTES_V.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
151: attribute_category OKL_TRX_QUOTES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
152: attribute1 OKL_TRX_QUOTES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
145: quote_number NUMBER := OKC_API.G_MISS_NUM,
146: requested_by NUMBER := OKC_API.G_MISS_NUM,
147: approved_yn OKL_TRX_QUOTES_V.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
148: accepted_yn OKL_TRX_QUOTES_V.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
149: payment_received_yn OKL_TRX_QUOTES_V.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: date_payment_received OKL_TRX_QUOTES_V.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
151: attribute_category OKL_TRX_QUOTES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
152: attribute1 OKL_TRX_QUOTES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
153: attribute2 OKL_TRX_QUOTES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
146: requested_by NUMBER := OKC_API.G_MISS_NUM,
147: approved_yn OKL_TRX_QUOTES_V.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
148: accepted_yn OKL_TRX_QUOTES_V.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
149: payment_received_yn OKL_TRX_QUOTES_V.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: date_payment_received OKL_TRX_QUOTES_V.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
151: attribute_category OKL_TRX_QUOTES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
152: attribute1 OKL_TRX_QUOTES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
153: attribute2 OKL_TRX_QUOTES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
154: attribute3 OKL_TRX_QUOTES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
147: approved_yn OKL_TRX_QUOTES_V.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,
148: accepted_yn OKL_TRX_QUOTES_V.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
149: payment_received_yn OKL_TRX_QUOTES_V.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: date_payment_received OKL_TRX_QUOTES_V.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
151: attribute_category OKL_TRX_QUOTES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
152: attribute1 OKL_TRX_QUOTES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
153: attribute2 OKL_TRX_QUOTES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
154: attribute3 OKL_TRX_QUOTES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
155: attribute4 OKL_TRX_QUOTES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
148: accepted_yn OKL_TRX_QUOTES_V.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
149: payment_received_yn OKL_TRX_QUOTES_V.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: date_payment_received OKL_TRX_QUOTES_V.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
151: attribute_category OKL_TRX_QUOTES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
152: attribute1 OKL_TRX_QUOTES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
153: attribute2 OKL_TRX_QUOTES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
154: attribute3 OKL_TRX_QUOTES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
155: attribute4 OKL_TRX_QUOTES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
156: attribute5 OKL_TRX_QUOTES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
149: payment_received_yn OKL_TRX_QUOTES_V.PAYMENT_RECEIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
150: date_payment_received OKL_TRX_QUOTES_V.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
151: attribute_category OKL_TRX_QUOTES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
152: attribute1 OKL_TRX_QUOTES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
153: attribute2 OKL_TRX_QUOTES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
154: attribute3 OKL_TRX_QUOTES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
155: attribute4 OKL_TRX_QUOTES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
156: attribute5 OKL_TRX_QUOTES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
157: attribute6 OKL_TRX_QUOTES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
150: date_payment_received OKL_TRX_QUOTES_V.DATE_PAYMENT_RECEIVED%TYPE := OKC_API.G_MISS_DATE,
151: attribute_category OKL_TRX_QUOTES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
152: attribute1 OKL_TRX_QUOTES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
153: attribute2 OKL_TRX_QUOTES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
154: attribute3 OKL_TRX_QUOTES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
155: attribute4 OKL_TRX_QUOTES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
156: attribute5 OKL_TRX_QUOTES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
157: attribute6 OKL_TRX_QUOTES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
158: attribute7 OKL_TRX_QUOTES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
151: attribute_category OKL_TRX_QUOTES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
152: attribute1 OKL_TRX_QUOTES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
153: attribute2 OKL_TRX_QUOTES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
154: attribute3 OKL_TRX_QUOTES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
155: attribute4 OKL_TRX_QUOTES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
156: attribute5 OKL_TRX_QUOTES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
157: attribute6 OKL_TRX_QUOTES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
158: attribute7 OKL_TRX_QUOTES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
159: attribute8 OKL_TRX_QUOTES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
152: attribute1 OKL_TRX_QUOTES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
153: attribute2 OKL_TRX_QUOTES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
154: attribute3 OKL_TRX_QUOTES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
155: attribute4 OKL_TRX_QUOTES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
156: attribute5 OKL_TRX_QUOTES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
157: attribute6 OKL_TRX_QUOTES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
158: attribute7 OKL_TRX_QUOTES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
159: attribute8 OKL_TRX_QUOTES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
160: attribute9 OKL_TRX_QUOTES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
153: attribute2 OKL_TRX_QUOTES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
154: attribute3 OKL_TRX_QUOTES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
155: attribute4 OKL_TRX_QUOTES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
156: attribute5 OKL_TRX_QUOTES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
157: attribute6 OKL_TRX_QUOTES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
158: attribute7 OKL_TRX_QUOTES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
159: attribute8 OKL_TRX_QUOTES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
160: attribute9 OKL_TRX_QUOTES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
161: attribute10 OKL_TRX_QUOTES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
154: attribute3 OKL_TRX_QUOTES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
155: attribute4 OKL_TRX_QUOTES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
156: attribute5 OKL_TRX_QUOTES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
157: attribute6 OKL_TRX_QUOTES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
158: attribute7 OKL_TRX_QUOTES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
159: attribute8 OKL_TRX_QUOTES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
160: attribute9 OKL_TRX_QUOTES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
161: attribute10 OKL_TRX_QUOTES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
162: attribute11 OKL_TRX_QUOTES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
155: attribute4 OKL_TRX_QUOTES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
156: attribute5 OKL_TRX_QUOTES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
157: attribute6 OKL_TRX_QUOTES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
158: attribute7 OKL_TRX_QUOTES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
159: attribute8 OKL_TRX_QUOTES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
160: attribute9 OKL_TRX_QUOTES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
161: attribute10 OKL_TRX_QUOTES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
162: attribute11 OKL_TRX_QUOTES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
163: attribute12 OKL_TRX_QUOTES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
156: attribute5 OKL_TRX_QUOTES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
157: attribute6 OKL_TRX_QUOTES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
158: attribute7 OKL_TRX_QUOTES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
159: attribute8 OKL_TRX_QUOTES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
160: attribute9 OKL_TRX_QUOTES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
161: attribute10 OKL_TRX_QUOTES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
162: attribute11 OKL_TRX_QUOTES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
163: attribute12 OKL_TRX_QUOTES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
164: attribute13 OKL_TRX_QUOTES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
157: attribute6 OKL_TRX_QUOTES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
158: attribute7 OKL_TRX_QUOTES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
159: attribute8 OKL_TRX_QUOTES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
160: attribute9 OKL_TRX_QUOTES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
161: attribute10 OKL_TRX_QUOTES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
162: attribute11 OKL_TRX_QUOTES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
163: attribute12 OKL_TRX_QUOTES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
164: attribute13 OKL_TRX_QUOTES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
165: attribute14 OKL_TRX_QUOTES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
158: attribute7 OKL_TRX_QUOTES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
159: attribute8 OKL_TRX_QUOTES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
160: attribute9 OKL_TRX_QUOTES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
161: attribute10 OKL_TRX_QUOTES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
162: attribute11 OKL_TRX_QUOTES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
163: attribute12 OKL_TRX_QUOTES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
164: attribute13 OKL_TRX_QUOTES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
165: attribute14 OKL_TRX_QUOTES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
166: attribute15 OKL_TRX_QUOTES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
159: attribute8 OKL_TRX_QUOTES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
160: attribute9 OKL_TRX_QUOTES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
161: attribute10 OKL_TRX_QUOTES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
162: attribute11 OKL_TRX_QUOTES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
163: attribute12 OKL_TRX_QUOTES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
164: attribute13 OKL_TRX_QUOTES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
165: attribute14 OKL_TRX_QUOTES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
166: attribute15 OKL_TRX_QUOTES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
167: date_approved OKL_TRX_QUOTES_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
160: attribute9 OKL_TRX_QUOTES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
161: attribute10 OKL_TRX_QUOTES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
162: attribute11 OKL_TRX_QUOTES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
163: attribute12 OKL_TRX_QUOTES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
164: attribute13 OKL_TRX_QUOTES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
165: attribute14 OKL_TRX_QUOTES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
166: attribute15 OKL_TRX_QUOTES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
167: date_approved OKL_TRX_QUOTES_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
168: approved_by NUMBER := OKC_API.G_MISS_NUM,
161: attribute10 OKL_TRX_QUOTES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
162: attribute11 OKL_TRX_QUOTES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
163: attribute12 OKL_TRX_QUOTES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
164: attribute13 OKL_TRX_QUOTES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
165: attribute14 OKL_TRX_QUOTES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
166: attribute15 OKL_TRX_QUOTES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
167: date_approved OKL_TRX_QUOTES_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
168: approved_by NUMBER := OKC_API.G_MISS_NUM,
169: org_id NUMBER := OKC_API.G_MISS_NUM,
162: attribute11 OKL_TRX_QUOTES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
163: attribute12 OKL_TRX_QUOTES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
164: attribute13 OKL_TRX_QUOTES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
165: attribute14 OKL_TRX_QUOTES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
166: attribute15 OKL_TRX_QUOTES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
167: date_approved OKL_TRX_QUOTES_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
168: approved_by NUMBER := OKC_API.G_MISS_NUM,
169: org_id NUMBER := OKC_API.G_MISS_NUM,
170: request_id NUMBER := OKC_API.G_MISS_NUM,
163: attribute12 OKL_TRX_QUOTES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
164: attribute13 OKL_TRX_QUOTES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
165: attribute14 OKL_TRX_QUOTES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
166: attribute15 OKL_TRX_QUOTES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
167: date_approved OKL_TRX_QUOTES_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
168: approved_by NUMBER := OKC_API.G_MISS_NUM,
169: org_id NUMBER := OKC_API.G_MISS_NUM,
170: request_id NUMBER := OKC_API.G_MISS_NUM,
171: program_application_id NUMBER := OKC_API.G_MISS_NUM,
164: attribute13 OKL_TRX_QUOTES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
165: attribute14 OKL_TRX_QUOTES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
166: attribute15 OKL_TRX_QUOTES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
167: date_approved OKL_TRX_QUOTES_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
168: approved_by NUMBER := OKC_API.G_MISS_NUM,
169: org_id NUMBER := OKC_API.G_MISS_NUM,
170: request_id NUMBER := OKC_API.G_MISS_NUM,
171: program_application_id NUMBER := OKC_API.G_MISS_NUM,
172: program_id NUMBER := OKC_API.G_MISS_NUM,
165: attribute14 OKL_TRX_QUOTES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
166: attribute15 OKL_TRX_QUOTES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
167: date_approved OKL_TRX_QUOTES_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
168: approved_by NUMBER := OKC_API.G_MISS_NUM,
169: org_id NUMBER := OKC_API.G_MISS_NUM,
170: request_id NUMBER := OKC_API.G_MISS_NUM,
171: program_application_id NUMBER := OKC_API.G_MISS_NUM,
172: program_id NUMBER := OKC_API.G_MISS_NUM,
173: program_update_date OKL_TRX_QUOTES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
166: attribute15 OKL_TRX_QUOTES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
167: date_approved OKL_TRX_QUOTES_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
168: approved_by NUMBER := OKC_API.G_MISS_NUM,
169: org_id NUMBER := OKC_API.G_MISS_NUM,
170: request_id NUMBER := OKC_API.G_MISS_NUM,
171: program_application_id NUMBER := OKC_API.G_MISS_NUM,
172: program_id NUMBER := OKC_API.G_MISS_NUM,
173: program_update_date OKL_TRX_QUOTES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
174: created_by NUMBER := OKC_API.G_MISS_NUM,
167: date_approved OKL_TRX_QUOTES_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
168: approved_by NUMBER := OKC_API.G_MISS_NUM,
169: org_id NUMBER := OKC_API.G_MISS_NUM,
170: request_id NUMBER := OKC_API.G_MISS_NUM,
171: program_application_id NUMBER := OKC_API.G_MISS_NUM,
172: program_id NUMBER := OKC_API.G_MISS_NUM,
173: program_update_date OKL_TRX_QUOTES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
174: created_by NUMBER := OKC_API.G_MISS_NUM,
175: creation_date OKL_TRX_QUOTES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
168: approved_by NUMBER := OKC_API.G_MISS_NUM,
169: org_id NUMBER := OKC_API.G_MISS_NUM,
170: request_id NUMBER := OKC_API.G_MISS_NUM,
171: program_application_id NUMBER := OKC_API.G_MISS_NUM,
172: program_id NUMBER := OKC_API.G_MISS_NUM,
173: program_update_date OKL_TRX_QUOTES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
174: created_by NUMBER := OKC_API.G_MISS_NUM,
175: creation_date OKL_TRX_QUOTES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
176: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
169: org_id NUMBER := OKC_API.G_MISS_NUM,
170: request_id NUMBER := OKC_API.G_MISS_NUM,
171: program_application_id NUMBER := OKC_API.G_MISS_NUM,
172: program_id NUMBER := OKC_API.G_MISS_NUM,
173: program_update_date OKL_TRX_QUOTES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
174: created_by NUMBER := OKC_API.G_MISS_NUM,
175: creation_date OKL_TRX_QUOTES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
176: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
177: last_update_date OKL_TRX_QUOTES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
170: request_id NUMBER := OKC_API.G_MISS_NUM,
171: program_application_id NUMBER := OKC_API.G_MISS_NUM,
172: program_id NUMBER := OKC_API.G_MISS_NUM,
173: program_update_date OKL_TRX_QUOTES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
174: created_by NUMBER := OKC_API.G_MISS_NUM,
175: creation_date OKL_TRX_QUOTES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
176: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
177: last_update_date OKL_TRX_QUOTES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
178: last_update_login NUMBER := OKC_API.G_MISS_NUM,
171: program_application_id NUMBER := OKC_API.G_MISS_NUM,
172: program_id NUMBER := OKC_API.G_MISS_NUM,
173: program_update_date OKL_TRX_QUOTES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
174: created_by NUMBER := OKC_API.G_MISS_NUM,
175: creation_date OKL_TRX_QUOTES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
176: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
177: last_update_date OKL_TRX_QUOTES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
178: last_update_login NUMBER := OKC_API.G_MISS_NUM,
179: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
172: program_id NUMBER := OKC_API.G_MISS_NUM,
173: program_update_date OKL_TRX_QUOTES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
174: created_by NUMBER := OKC_API.G_MISS_NUM,
175: creation_date OKL_TRX_QUOTES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
176: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
177: last_update_date OKL_TRX_QUOTES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
178: last_update_login NUMBER := OKC_API.G_MISS_NUM,
179: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
180: purchase_formula OKL_TRX_QUOTES_V.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
173: program_update_date OKL_TRX_QUOTES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
174: created_by NUMBER := OKC_API.G_MISS_NUM,
175: creation_date OKL_TRX_QUOTES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
176: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
177: last_update_date OKL_TRX_QUOTES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
178: last_update_login NUMBER := OKC_API.G_MISS_NUM,
179: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
180: purchase_formula OKL_TRX_QUOTES_V.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
181: asset_value NUMBER := OKC_API.G_MISS_NUM,
174: created_by NUMBER := OKC_API.G_MISS_NUM,
175: creation_date OKL_TRX_QUOTES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
176: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
177: last_update_date OKL_TRX_QUOTES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
178: last_update_login NUMBER := OKC_API.G_MISS_NUM,
179: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
180: purchase_formula OKL_TRX_QUOTES_V.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
181: asset_value NUMBER := OKC_API.G_MISS_NUM,
182: residual_value NUMBER := OKC_API.G_MISS_NUM,
175: creation_date OKL_TRX_QUOTES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
176: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
177: last_update_date OKL_TRX_QUOTES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
178: last_update_login NUMBER := OKC_API.G_MISS_NUM,
179: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
180: purchase_formula OKL_TRX_QUOTES_V.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
181: asset_value NUMBER := OKC_API.G_MISS_NUM,
182: residual_value NUMBER := OKC_API.G_MISS_NUM,
183: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
176: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
177: last_update_date OKL_TRX_QUOTES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
178: last_update_login NUMBER := OKC_API.G_MISS_NUM,
179: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
180: purchase_formula OKL_TRX_QUOTES_V.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
181: asset_value NUMBER := OKC_API.G_MISS_NUM,
182: residual_value NUMBER := OKC_API.G_MISS_NUM,
183: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
184: gain_loss NUMBER := OKC_API.G_MISS_NUM,
177: last_update_date OKL_TRX_QUOTES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
178: last_update_login NUMBER := OKC_API.G_MISS_NUM,
179: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
180: purchase_formula OKL_TRX_QUOTES_V.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
181: asset_value NUMBER := OKC_API.G_MISS_NUM,
182: residual_value NUMBER := OKC_API.G_MISS_NUM,
183: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
184: gain_loss NUMBER := OKC_API.G_MISS_NUM,
185: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
178: last_update_login NUMBER := OKC_API.G_MISS_NUM,
179: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
180: purchase_formula OKL_TRX_QUOTES_V.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
181: asset_value NUMBER := OKC_API.G_MISS_NUM,
182: residual_value NUMBER := OKC_API.G_MISS_NUM,
183: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
184: gain_loss NUMBER := OKC_API.G_MISS_NUM,
185: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
186: -- BAKUCHIB - 2667636 - start
179: purchase_amount NUMBER := OKC_API.G_MISS_NUM,
180: purchase_formula OKL_TRX_QUOTES_V.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
181: asset_value NUMBER := OKC_API.G_MISS_NUM,
182: residual_value NUMBER := OKC_API.G_MISS_NUM,
183: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
184: gain_loss NUMBER := OKC_API.G_MISS_NUM,
185: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
186: -- BAKUCHIB - 2667636 - start
187: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
180: purchase_formula OKL_TRX_QUOTES_V.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,
181: asset_value NUMBER := OKC_API.G_MISS_NUM,
182: residual_value NUMBER := OKC_API.G_MISS_NUM,
183: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
184: gain_loss NUMBER := OKC_API.G_MISS_NUM,
185: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
186: -- BAKUCHIB - 2667636 - start
187: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
188: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
181: asset_value NUMBER := OKC_API.G_MISS_NUM,
182: residual_value NUMBER := OKC_API.G_MISS_NUM,
183: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
184: gain_loss NUMBER := OKC_API.G_MISS_NUM,
185: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
186: -- BAKUCHIB - 2667636 - start
187: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
188: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
189: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
183: unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
184: gain_loss NUMBER := OKC_API.G_MISS_NUM,
185: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
186: -- BAKUCHIB - 2667636 - start
187: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
188: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
189: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190: currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
191: currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
184: gain_loss NUMBER := OKC_API.G_MISS_NUM,
185: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
186: -- BAKUCHIB - 2667636 - start
187: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
188: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
189: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190: currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
191: currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
192: -- BAKUCHIB - 2667636 - end
185: PERDIEM_AMOUNT NUMBER := OKC_API.G_MISS_NUM, -- SANAHUJA -- LOANS_ENHACEMENTS -- start -- end
186: -- BAKUCHIB - 2667636 - start
187: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
188: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
189: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190: currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
191: currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
192: -- BAKUCHIB - 2667636 - end
193: legal_entity_id OKL_TRX_QUOTES_B.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM, --dkagrawa for LE Uptake
186: -- BAKUCHIB - 2667636 - start
187: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
188: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
189: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190: currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
191: currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
192: -- BAKUCHIB - 2667636 - end
193: legal_entity_id OKL_TRX_QUOTES_B.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM, --dkagrawa for LE Uptake
194: repo_quote_indicator_yn OKL_TRX_QUOTES_B.REPO_QUOTE_INDICATOR_YN%TYPE := OKL_API.G_MISS_CHAR -- AKP:REPO-QUOTE-START-END 6599890
187: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
188: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
189: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190: currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
191: currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
192: -- BAKUCHIB - 2667636 - end
193: legal_entity_id OKL_TRX_QUOTES_B.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM, --dkagrawa for LE Uptake
194: repo_quote_indicator_yn OKL_TRX_QUOTES_B.REPO_QUOTE_INDICATOR_YN%TYPE := OKL_API.G_MISS_CHAR -- AKP:REPO-QUOTE-START-END 6599890
195: );
198: INDEX BY BINARY_INTEGER;
199: ---------------------------------------------------------------------------
200: -- GLOBAL MESSAGE CONSTANTS
201: ---------------------------------------------------------------------------
202: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
203: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
204: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
205: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
206: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
199: ---------------------------------------------------------------------------
200: -- GLOBAL MESSAGE CONSTANTS
201: ---------------------------------------------------------------------------
202: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
203: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
204: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
205: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
206: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
207: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
200: -- GLOBAL MESSAGE CONSTANTS
201: ---------------------------------------------------------------------------
202: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
203: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
204: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
205: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
206: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
207: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
208: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
201: ---------------------------------------------------------------------------
202: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
203: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
204: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
205: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
206: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
207: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
208: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
209: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
202: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
203: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
204: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
205: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
206: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
207: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
208: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
209: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
210: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
205: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
206: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
207: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
208: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
209: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
210: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
211: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
212: ---------------------------------------------------------------------------
213: -- GLOBAL VARIABLES
206: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
207: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
208: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
209: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
210: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
211: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
212: ---------------------------------------------------------------------------
213: -- GLOBAL VARIABLES
214: ---------------------------------------------------------------------------
207: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
208: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
209: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
210: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
211: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
212: ---------------------------------------------------------------------------
213: -- GLOBAL VARIABLES
214: ---------------------------------------------------------------------------
215: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_QTE_PVT';
223: PROCEDURE api_copy;
224: PROCEDURE add_language;
225: PROCEDURE insert_row(
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_qtev_rec IN qtev_rec_type,
232: x_qtev_rec OUT NOCOPY qtev_rec_type);
233:
234: PROCEDURE insert_row(
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
237: x_return_status OUT NOCOPY VARCHAR2,
238: x_msg_count OUT NOCOPY NUMBER,
239: x_msg_data OUT NOCOPY VARCHAR2,
240: p_qtev_tbl IN qtev_tbl_type,
241: x_qtev_tbl OUT NOCOPY qtev_tbl_type);
242:
243: PROCEDURE lock_row(
244: p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,
249: p_qtev_rec IN qtev_rec_type);
249: p_qtev_rec IN qtev_rec_type);
250:
251: PROCEDURE lock_row(
252: p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_qtev_tbl IN qtev_tbl_type);
257: p_qtev_tbl IN qtev_tbl_type);
258:
259: PROCEDURE update_row(
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,
265: p_qtev_rec IN qtev_rec_type,
266: x_qtev_rec OUT NOCOPY qtev_rec_type);
267:
268: PROCEDURE update_row(
269: p_api_version IN NUMBER,
270: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,
273: x_msg_data OUT NOCOPY VARCHAR2,
274: p_qtev_tbl IN qtev_tbl_type,
275: x_qtev_tbl OUT NOCOPY qtev_tbl_type);
276:
277: PROCEDURE delete_row(
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
282: x_msg_data OUT NOCOPY VARCHAR2,
283: p_qtev_rec IN qtev_rec_type);
283: p_qtev_rec IN qtev_rec_type);
284:
285: PROCEDURE delete_row(
286: p_api_version IN NUMBER,
287: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
291: p_qtev_tbl IN qtev_tbl_type);
291: p_qtev_tbl IN qtev_tbl_type);
292:
293: PROCEDURE validate_row(
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: p_qtev_rec IN qtev_rec_type);
299: p_qtev_rec IN qtev_rec_type);
300:
301: PROCEDURE validate_row(
302: p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
304: x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,
307: p_qtev_tbl IN qtev_tbl_type);