25: ------------------------------------------------------------------------------
26: -- Record Type
27: ------------------------------------------------------------------------------
28: TYPE amort_hdr_id_rec_type IS RECORD (
29: pri_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
30: pri_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
31: int_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
32: int_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
33: pri_bal_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
26: -- Record Type
27: ------------------------------------------------------------------------------
28: TYPE amort_hdr_id_rec_type IS RECORD (
29: pri_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
30: pri_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
31: int_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
32: int_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
33: pri_bal_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
34: pri_bal_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
27: ------------------------------------------------------------------------------
28: TYPE amort_hdr_id_rec_type IS RECORD (
29: pri_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
30: pri_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
31: int_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
32: int_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
33: pri_bal_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
34: pri_bal_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
35: loan_pymnt_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
28: TYPE amort_hdr_id_rec_type IS RECORD (
29: pri_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
30: pri_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
31: int_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
32: int_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
33: pri_bal_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
34: pri_bal_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
35: loan_pymnt_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
36: loan_pymnt_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
29: pri_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
30: pri_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
31: int_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
32: int_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
33: pri_bal_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
34: pri_bal_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
35: loan_pymnt_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
36: loan_pymnt_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
37: date_from_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
30: pri_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
31: int_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
32: int_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
33: pri_bal_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
34: pri_bal_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
35: loan_pymnt_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
36: loan_pymnt_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
37: date_from_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
38: date_from_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
31: int_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
32: int_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
33: pri_bal_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
34: pri_bal_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
35: loan_pymnt_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
36: loan_pymnt_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
37: date_from_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
38: date_from_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
39: date_to_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
32: int_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
33: pri_bal_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
34: pri_bal_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
35: loan_pymnt_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
36: loan_pymnt_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
37: date_from_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
38: date_from_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
39: date_to_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
40: proj_interest_rate_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
33: pri_bal_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
34: pri_bal_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
35: loan_pymnt_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
36: loan_pymnt_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
37: date_from_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
38: date_from_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
39: date_to_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
40: proj_interest_rate_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
41: -- pastproj_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
34: pri_bal_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
35: loan_pymnt_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
36: loan_pymnt_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
37: date_from_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
38: date_from_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
39: date_to_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
40: proj_interest_rate_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
41: -- pastproj_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
42: pastproj_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
35: loan_pymnt_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
36: loan_pymnt_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
37: date_from_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
38: date_from_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
39: date_to_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
40: proj_interest_rate_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
41: -- pastproj_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
42: pastproj_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
43: order_by_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
36: loan_pymnt_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
37: date_from_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
38: date_from_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
39: date_to_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
40: proj_interest_rate_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
41: -- pastproj_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
42: pastproj_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
43: order_by_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
44: order_by_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type
37: date_from_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
38: date_from_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
39: date_to_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
40: proj_interest_rate_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
41: -- pastproj_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
42: pastproj_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
43: order_by_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
44: order_by_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type
45: );
38: date_from_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
39: date_to_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
40: proj_interest_rate_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
41: -- pastproj_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
42: pastproj_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
43: order_by_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
44: order_by_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type
45: );
46:
39: date_to_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
40: proj_interest_rate_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
41: -- pastproj_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
42: pastproj_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
43: order_by_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
44: order_by_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type
45: );
46:
47: TYPE amort_hdr_id_tbl_type is table of amort_hdr_id_rec_type INDEX BY BINARY_INTEGER;
40: proj_interest_rate_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
41: -- pastproj_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
42: pastproj_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
43: order_by_summ_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type,
44: order_by_det_id OKL_AMORT_SCHED_HDRS.amort_hdr_id%type
45: );
46:
47: TYPE amort_hdr_id_tbl_type is table of amort_hdr_id_rec_type INDEX BY BINARY_INTEGER;
48: TYPE amort_line_id is table of number;