eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_K_HEADERS

Line 46: okl_k_headers khr,

42: nvl(pdt.reporting_pdt_id, -1) report_pdt_id,
43: chr.currency_code currency_code,
44: khr.term_duration term
45: from okc_k_headers_v chr,
46: okl_k_headers khr,
47: okl_products_v pdt
48: where khr.id = chr.id
49: and chr.id = p_khr_id
50: and khr.pdt_id = pdt.id(+);

Line 855: okl_k_headers khr

851: khr.deal_type,
852: khr.term_duration,
853: NVL(khr.generate_accrual_yn, 'Y')
854: FROM okc_k_headers_b chr,
855: okl_k_headers khr
856: WHERE khr.id = p_khr_id
857: AND chr.id = khr.id;
858:
859: l_hdr c_hdr%ROWTYPE;

Line 2030: okl_k_headers khr,

2026: nvl(pdt.reporting_pdt_id, -1) report_pdt_id,
2027: chr.currency_code currency_code,
2028: khr.term_duration term
2029: from okc_k_headers_v chr,
2030: okl_k_headers khr,
2031: okl_products_v pdt
2032: where khr.id = chr.id
2033: and chr.id = p_khr_id
2034: and khr.pdt_id = pdt.id(+);

Line 3961: okl_k_headers khr

3957: khr.term_duration,
3958: khr.pre_tax_irr,
3959: NVL(khr.generate_accrual_yn, 'Y')
3960: FROM okc_k_headers_b chr,
3961: okl_k_headers khr
3962: WHERE khr.id = p_khr_id
3963: AND chr.id = khr.id;
3964:
3965: cursor l_line_csr( chrid NUMBER, lnetype VARCHAR2 ) is

Line 4834: okl_k_headers khr

4830: khr.deal_type,
4831: khr.term_duration,
4832: NVL(khr.generate_accrual_yn, 'Y')
4833: FROM okc_k_headers_b chr,
4834: okl_k_headers khr
4835: WHERE khr.id = p_khr_id
4836: AND chr.id = khr.id;
4837:
4838: l_hdr c_hdr%ROWTYPE;

Line 5225: okl_k_headers khr

5221: khr.deal_type,
5222: khr.term_duration,
5223: NVL(khr.generate_accrual_yn, 'Y')
5224: FROM okc_k_headers_b chr,
5225: okl_k_headers khr
5226: WHERE khr.id = p_khr_id
5227: AND chr.id = khr.id;
5228:
5229: l_hdr c_hdr%ROWTYPE;

Line 6383: FROM okl_k_headers

6379:
6380: --To get the regular product id
6381: CURSOR c_get_regular_product_id IS
6382: SELECT pdt_id
6383: FROM okl_k_headers
6384: WHERE id = p_chr_id;
6385:
6386: --To get the reporting product id
6387: CURSOR c_get_report_product_id IS

Line 6389: FROM okl_k_headers khr,

6385:
6386: --To get the reporting product id
6387: CURSOR c_get_report_product_id IS
6388: SELECT pdt.reporting_pdt_id
6389: FROM okl_k_headers khr,
6390: okl_products pdt
6391: WHERE khr.id = p_chr_id
6392: AND khr.pdt_id = pdt.id;
6393:

Line 8021: okl_k_headers khr,

8017: khr.term_duration,
8018: NVL(khr.generate_accrual_yn, 'Y'),
8019: nvl(rpar.base_rate, 10) base_rate
8020: FROM okc_k_headers_b chr,
8021: okl_k_headers khr,
8022: OKL_K_RATE_PARAMS rpar
8023: WHERE khr.id = p_khr_id
8024: AND chr.id = khr.id
8025: AND rpar.khr_id(+) = khr.id;

Line 10394: okl_k_headers khr

10390: khr.deal_type,
10391: khr.term_duration,
10392: NVL(khr.generate_accrual_yn, 'Y')
10393: FROM okc_k_headers_b chr,
10394: okl_k_headers khr
10395: WHERE khr.id = p_khr_id
10396: AND chr.id = khr.id;
10397:
10398: l_hdr c_hdr%ROWTYPE;

Line 10682: okl_K_headers_full_v pkhr,

10678: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
10679: nvl(khr.PRE_TAX_IRR, -1) contract_yield
10680: from okl_pools pol,
10681: okl_pool_contents pcn,
10682: okl_K_headers_full_v pkhr,
10683: okl_k_headers khr
10684: where pcn.pol_id = pol.id
10685: and pcn.khr_id = khr.id
10686: and pol.khr_id = pkhr.id

Line 10683: okl_k_headers khr

10679: nvl(khr.PRE_TAX_IRR, -1) contract_yield
10680: from okl_pools pol,
10681: okl_pool_contents pcn,
10682: okl_K_headers_full_v pkhr,
10683: okl_k_headers khr
10684: where pcn.pol_id = pol.id
10685: and pcn.khr_id = khr.id
10686: and pol.khr_id = pkhr.id
10687: and pol.khr_id = agmntID

Line 10741: okl_K_headers_full_v pkhr,

10737: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
10738: nvl(khr.PRE_TAX_IRR, -1) contract_yield
10739: from okl_pools pol,
10740: okl_pool_contents pcn,
10741: okl_K_headers_full_v pkhr,
10742: okl_k_headers khr
10743: where pcn.pol_id = pol.id
10744: and pcn.khr_id = khr.id
10745: and pol.khr_id = pkhr.id

Line 10742: okl_k_headers khr

10738: nvl(khr.PRE_TAX_IRR, -1) contract_yield
10739: from okl_pools pol,
10740: okl_pool_contents pcn,
10741: okl_K_headers_full_v pkhr,
10742: okl_k_headers khr
10743: where pcn.pol_id = pol.id
10744: and pcn.khr_id = khr.id
10745: and pol.khr_id = pkhr.id
10746: and pol.khr_id = agmntID

Line 11351: okl_K_headers_full_v pkhr,

11347: pkhr.contract_number agreement_number,
11348: nvl(khr.PRE_TAX_IRR, -1) contract_yield
11349: from okl_pools pol,
11350: okl_pool_contents pcn,
11351: okl_K_headers_full_v pkhr,
11352: okl_k_headers khr
11353: where pcn.pol_id = pol.id
11354: and pcn.khr_id = khr.id
11355: and pol.khr_id = pkhr.id

Line 11352: okl_k_headers khr

11348: nvl(khr.PRE_TAX_IRR, -1) contract_yield
11349: from okl_pools pol,
11350: okl_pool_contents pcn,
11351: okl_K_headers_full_v pkhr,
11352: okl_k_headers khr
11353: where pcn.pol_id = pol.id
11354: and pcn.khr_id = khr.id
11355: and pol.khr_id = pkhr.id
11356: and pol.khr_id = agmntID

Line 11412: okl_K_headers_full_v pkhr,

11408: pkhr.contract_number agreement_number,
11409: nvl(khr.PRE_TAX_IRR, -1) contract_yield
11410: from okl_pools pol,
11411: okl_pool_contents pcn,
11412: okl_K_headers_full_v pkhr,
11413: okl_k_headers khr
11414: where pcn.pol_id = pol.id
11415: and pcn.khr_id = khr.id
11416: and pol.khr_id = pkhr.id

Line 11413: okl_k_headers khr

11409: nvl(khr.PRE_TAX_IRR, -1) contract_yield
11410: from okl_pools pol,
11411: okl_pool_contents pcn,
11412: okl_K_headers_full_v pkhr,
11413: okl_k_headers khr
11414: where pcn.pol_id = pol.id
11415: and pcn.khr_id = khr.id
11416: and pol.khr_id = pkhr.id
11417: and pol.khr_id = agmntID

Line 12197: l_stmv_rec.source_table := 'OKL_K_HEADERS';

12193:
12194: l_stmv_rec.say_code := 'CURR';
12195: l_stmv_rec.date_current := sysdate;
12196: l_stmv_rec.active_yn := 'Y';
12197: l_stmv_rec.source_table := 'OKL_K_HEADERS';
12198: l_stmv_rec.source_id := sec_strms_rec.agreement_id;
12199:
12200: print( l_api_name, ' # of streams ' || to_char( l_selv_tbl.COUNT ) );
12201: If( l_selv_tbl.COUNT > 0 AND (l_stmv_rec.sty_id IS NOT NULL) ) Then

Line 12386: l_stmv_rec.source_table := 'OKL_K_HEADERS';

12382:
12383: l_stmv_rec.say_code := 'CURR';
12384: l_stmv_rec.date_current := sysdate;
12385: l_stmv_rec.active_yn := 'Y';
12386: l_stmv_rec.source_table := 'OKL_K_HEADERS';
12387: l_stmv_rec.source_id := sec_strms_rec.agreement_id;
12388:
12389: print( l_api_name, ' # of streams ' || to_char( l_selv_tbl.COUNT ) );
12390: If( l_selv_tbl.COUNT > 0 AND (l_stmv_rec.sty_id IS NOT NULL) ) Then

Line 12801: l_stmv_rec.source_table := 'OKL_K_HEADERS';

12797:
12798: l_stmv_rec.say_code := 'CURR';
12799: l_stmv_rec.date_current := sysdate;
12800: l_stmv_rec.active_yn := 'Y';
12801: l_stmv_rec.source_table := 'OKL_K_HEADERS';
12802: l_stmv_rec.source_id := sec_strms_rec.agreement_id;
12803:
12804: If( l_selv_tbl.COUNT > 0 AND l_stmv_rec.sty_id IS NOT NULL) Then
12805:

Line 12994: l_stmv_rec.source_table := 'OKL_K_HEADERS';

12990:
12991: l_stmv_rec.say_code := 'CURR';
12992: l_stmv_rec.date_current := sysdate;
12993: l_stmv_rec.active_yn := 'Y';
12994: l_stmv_rec.source_table := 'OKL_K_HEADERS';
12995: l_stmv_rec.source_id := sec_strms_rec.agreement_id;
12996:
12997: If( l_selv_tbl.COUNT > 0 AND l_stmv_rec.sty_id IS NOT NULL) Then
12998:

Line 13426: okl_k_headers khr

13422: CURSOR c_hdr IS
13423: SELECT nvl(khr.implicit_interest_rate, 0),
13424: khr.deal_type
13425: FROM okc_k_headers_b chr,
13426: okl_k_headers khr
13427: WHERE khr.id = p_khr_id
13428: AND chr.id = khr.id;
13429:
13430: r_hdr c_hdr%ROWTYPE;

Line 13825: okl_k_headers khr

13821: khr.deal_type,
13822: khr.term_duration,
13823: NVL(khr.generate_accrual_yn, 'Y')
13824: FROM okc_k_headers_b chr,
13825: okl_k_headers khr
13826: WHERE khr.id = p_khr_id
13827: AND chr.id = khr.id;
13828:
13829: l_hdr c_hdr%ROWTYPE;

Line 14330: okl_k_headers khr,

14326: SELECT to_char(pdt.id) pid,
14327: chr.currency_code currency_code,
14328: khr.multi_gaap_yn multi_gaap_yn -- R12.1.2
14329: FROM okc_k_headers_v chr,
14330: okl_k_headers khr,
14331: okl_products_v pdt
14332: WHERE khr.id = chr.id
14333: AND chr.id = p_khr_id
14334: AND khr.pdt_id = pdt.id(+);

Line 14337: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;

14333: AND chr.id = p_khr_id
14334: AND khr.pdt_id = pdt.id(+);
14335:
14336: -- racheruv.. R12.1.2: start
14337: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
14338:
14339: cursor rep_pdt_csr(p_pdt_id number) is
14340: select reporting_pdt_id
14341: from okl_products

Line 14706: from okl_k_headers

14702:
14703: -- R12.1.2 .. start
14704: CURSOR get_multi_gaap_yn(p_khr_id number) IS
14705: select multi_gaap_yn
14706: from okl_k_headers
14707: where id = p_khr_id;
14708:
14709: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
14710: -- R12.1.2 .. end

Line 14709: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;

14705: select multi_gaap_yn
14706: from okl_k_headers
14707: where id = p_khr_id;
14708:
14709: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
14710: -- R12.1.2 .. end
14711:
14712: BEGIN
14713: x_return_status := OKL_API.G_RET_STS_SUCCESS;