APPS.OKL_QTE_PVT dependencies on OKL_TRX_QUOTES_B

Line 8: qrs_code OKL_TRX_QUOTES_B.QRS_CODE%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 9: qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 13: qtp_code OKL_TRX_QUOTES_B.QTP_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,
17: pdt_id NUMBER := OKC_API.G_MISS_NUM,

Line 14: trn_code OKL_TRX_QUOTES_B.TRN_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,
18: date_effective_from OKL_TRX_QUOTES_B.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,

Line 15: pop_code_end OKL_TRX_QUOTES_B.POP_CODE_END%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 16: pop_code_early OKL_TRX_QUOTES_B.POP_CODE_EARLY%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 18: date_effective_from OKL_TRX_QUOTES_B.DATE_EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE,

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,

Line 23: date_restructure_start OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_START%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,

Line 24: date_due OKL_TRX_QUOTES_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 25: date_approved OKL_TRX_QUOTES_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,

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,

Line 26: date_restructure_end OKL_TRX_QUOTES_B.DATE_RESTRUCTURE_END%TYPE := OKC_API.G_MISS_DATE,

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,

Line 32: payment_frequency OKL_TRX_QUOTES_B.PAYMENT_FREQUENCY%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,

Line 33: early_termination_yn OKL_TRX_QUOTES_B.EARLY_TERMINATION_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,

Line 34: partial_yn OKL_TRX_QUOTES_B.PARTIAL_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,

Line 35: preproceeds_yn OKL_TRX_QUOTES_B.PREPROCEEDS_YN%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 36: summary_format_yn OKL_TRX_QUOTES_B.SUMMARY_FORMAT_YN%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 37: consolidated_yn OKL_TRX_QUOTES_B.CONSOLIDATED_YN%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,
41: date_accepted OKL_TRX_QUOTES_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,

Line 38: date_requested OKL_TRX_QUOTES_B.DATE_REQUESTED%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,

Line 39: date_proposal OKL_TRX_QUOTES_B.DATE_PROPOSAL%TYPE := OKC_API.G_MISS_DATE,

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,

Line 40: date_effective_to OKL_TRX_QUOTES_B.DATE_EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE,

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,

Line 41: date_accepted OKL_TRX_QUOTES_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE,

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,

Line 42: payment_received_yn OKL_TRX_QUOTES_B.PAYMENT_RECEIVED_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,

Line 44: approved_yn OKL_TRX_QUOTES_B.APPROVED_YN%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 45: accepted_yn OKL_TRX_QUOTES_B.ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 46: date_payment_received OKL_TRX_QUOTES_B.DATE_PAYMENT_RECEIVED%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,
50: program_application_id NUMBER := OKC_API.G_MISS_NUM,

Line 52: program_update_date OKL_TRX_QUOTES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 53: attribute_category OKL_TRX_QUOTES_B.ATTRIBUTE_CATEGORY%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,

Line 54: attribute1 OKL_TRX_QUOTES_B.ATTRIBUTE1%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,

Line 55: attribute2 OKL_TRX_QUOTES_B.ATTRIBUTE2%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,

Line 56: attribute3 OKL_TRX_QUOTES_B.ATTRIBUTE3%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,

Line 57: attribute4 OKL_TRX_QUOTES_B.ATTRIBUTE4%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,

Line 58: attribute5 OKL_TRX_QUOTES_B.ATTRIBUTE5%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,

Line 59: attribute6 OKL_TRX_QUOTES_B.ATTRIBUTE6%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,

Line 60: attribute7 OKL_TRX_QUOTES_B.ATTRIBUTE7%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,

Line 61: attribute8 OKL_TRX_QUOTES_B.ATTRIBUTE8%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,

Line 62: attribute9 OKL_TRX_QUOTES_B.ATTRIBUTE9%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,

Line 63: attribute10 OKL_TRX_QUOTES_B.ATTRIBUTE10%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,

Line 64: attribute11 OKL_TRX_QUOTES_B.ATTRIBUTE11%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,

Line 65: attribute12 OKL_TRX_QUOTES_B.ATTRIBUTE12%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,

Line 66: attribute13 OKL_TRX_QUOTES_B.ATTRIBUTE13%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,
70: creation_date OKL_TRX_QUOTES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 67: attribute14 OKL_TRX_QUOTES_B.ATTRIBUTE14%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,
71: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 68: attribute15 OKL_TRX_QUOTES_B.ATTRIBUTE15%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,
72: last_update_date OKL_TRX_QUOTES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 70: creation_date OKL_TRX_QUOTES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 72: last_update_date OKL_TRX_QUOTES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 75: purchase_formula OKL_TRX_QUOTES_B.PURCHASE_FORMULA%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 82: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%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,

Line 83: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,

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

Line 84: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,

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

Line 85: currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,

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

Line 86: currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,

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

Line 88: legal_entity_id OKL_TRX_QUOTES_B.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM, --dkagrawa for LE Uptake

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: );
91:
92: g_miss_qte_rec qte_rec_type;

Line 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

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: );
91:
92: g_miss_qte_rec qte_rec_type;
93: TYPE qte_tbl_type IS TABLE OF qte_rec_type

Line 187: currency_code OKL_TRX_QUOTES_B.CURRENCY_CODE%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,

Line 188: currency_conversion_code OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,

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

Line 189: currency_conversion_type OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,

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

Line 190: currency_conversion_rate OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,

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

Line 191: currency_conversion_date OKL_TRX_QUOTES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,

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

Line 193: legal_entity_id OKL_TRX_QUOTES_B.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM, --dkagrawa for LE Uptake

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: );
196: g_miss_qtev_rec qtev_rec_type;
197: TYPE qtev_tbl_type IS TABLE OF qtev_rec_type

Line 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

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: );
196: g_miss_qtev_rec qtev_rec_type;
197: TYPE qtev_tbl_type IS TABLE OF qtev_rec_type
198: INDEX BY BINARY_INTEGER;