5: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
6:
7: -- Store the yields types
8: TYPE yields_type IS RECORD (
9: pre_Tax_yield okl_k_headers.pre_tax_yield%type,
10: after_tax_yield okl_k_headers.after_tax_yield%type,
11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
6:
7: -- Store the yields types
8: TYPE yields_type IS RECORD (
9: pre_Tax_yield okl_k_headers.pre_tax_yield%type,
10: after_tax_yield okl_k_headers.after_tax_yield%type,
11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
7: -- Store the yields types
8: TYPE yields_type IS RECORD (
9: pre_Tax_yield okl_k_headers.pre_tax_yield%type,
10: after_tax_yield okl_k_headers.after_tax_yield%type,
11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
8: TYPE yields_type IS RECORD (
9: pre_Tax_yield okl_k_headers.pre_tax_yield%type,
10: after_tax_yield okl_k_headers.after_tax_yield%type,
11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,
9: pre_Tax_yield okl_k_headers.pre_tax_yield%type,
10: after_tax_yield okl_k_headers.after_tax_yield%type,
11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,
17: sub_after_tax_irr okl_k_headers.sub_after_tax_irr%type,
10: after_tax_yield okl_k_headers.after_tax_yield%type,
11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,
17: sub_after_tax_irr okl_k_headers.sub_after_tax_irr%type,
18: sub_impl_interest_rate okl_k_headers.sub_impl_interest_rate%type);
11: pre_tax_irr okl_k_headers.pre_tax_irr%type,
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,
17: sub_after_tax_irr okl_k_headers.sub_after_tax_irr%type,
18: sub_impl_interest_rate okl_k_headers.sub_impl_interest_rate%type);
19: SUBTYPE yields_rec_type IS yields_type;
12: after_tax_irr okl_k_headers.after_tax_irr%type,
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,
17: sub_after_tax_irr okl_k_headers.sub_after_tax_irr%type,
18: sub_impl_interest_rate okl_k_headers.sub_impl_interest_rate%type);
19: SUBTYPE yields_rec_type IS yields_type;
20:
13: implicit_interest_rate okl_k_headers.implicit_interest_rate%type,
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,
17: sub_after_tax_irr okl_k_headers.sub_after_tax_irr%type,
18: sub_impl_interest_rate okl_k_headers.sub_impl_interest_rate%type);
19: SUBTYPE yields_rec_type IS yields_type;
20:
21: TYPE strm_rec IS RECORD (
14: sub_pre_Tax_yield okl_k_headers.sub_pre_tax_yield%type,
15: sub_after_tax_yield okl_k_headers.sub_after_tax_yield%type,
16: sub_pre_tax_irr okl_k_headers.sub_pre_tax_irr%TYPE,
17: sub_after_tax_irr okl_k_headers.sub_after_tax_irr%type,
18: sub_impl_interest_rate okl_k_headers.sub_impl_interest_rate%type);
19: SUBTYPE yields_rec_type IS yields_type;
20:
21: TYPE strm_rec IS RECORD (
22: id OKL_STRM_TYPE_B.ID%TYPE ,
40: NVL(pdt.reporting_pdt_id, -1) report_pdt_id,
41: chr.currency_code currency_code,
42: khr.term_duration term
43: FROM okc_k_headers_v chr,
44: okl_k_headers khr,
45: okl_products_v pdt
46: WHERE khr.id = chr.id
47: AND chr.id = chrId
48: AND khr.pdt_id = pdt.id(+);
263: NVL(pdt.reporting_pdt_id, -1) report_pdt_id,
264: chr.currency_code currency_code,
265: khr.term_duration term
266: FROM okc_k_headers_v chr,
267: okl_k_headers khr,
268: okl_products_v pdt
269: WHERE khr.id = chr.id
270: AND chr.id = chrId
271: AND khr.pdt_id = pdt.id(+);