[Home] [Help]
332: -- Version : 1.0
333: -- End of comments
334: ----------------------------------------------------------------------------------
335: FUNCTION is_kle_securitized(
336: p_kle_id IN okc_k_lines_b.ID%TYPE
337: ,p_effective_date IN DATE
338: -- cklee 08-08-2003 11.5.10
339: ,p_effective_date_operator IN VARCHAR2 DEFAULT G_GREATER_THAN_EQUAL_TO
340: ,p_stream_type_subclass IN okl_strm_type_b.stream_type_subclass%TYPE DEFAULT NULL
345: x_value VARCHAR2(1) := Okl_Api.G_FALSE;
346: l_row_found BOOLEAN := FALSE;
347:
348: -- case 1
349: CURSOR c_kle_def(p_kle_id okc_k_lines_b.ID%TYPE, p_effective_date DATE) IS
350: SELECT '1'
351: FROM okl_pool_contents pocb,
352: okl_pools polb,
353: okc_k_headers_b chrb
368: = NVL(p_stream_type_subclass, NVL(styb.stream_type_subclass,'x'))
369: );
370:
371: -- case 2
372: CURSOR c_kle_gr(p_kle_id okc_k_lines_b.ID%TYPE, p_effective_date DATE) IS
373: SELECT '1'
374: FROM okl_pool_contents pocb,
375: okl_pools polb,
376: okc_k_headers_b chrb
391: = NVL(p_stream_type_subclass, NVL(styb.stream_type_subclass,'x'))
392: );
393:
394: -- case 3
395: CURSOR c_kle_ls(p_kle_id okc_k_lines_b.ID%TYPE, p_effective_date DATE) IS
396: SELECT '1'
397: FROM okl_pool_contents pocb,
398: okl_pools polb,
399: okc_k_headers_b chrb
414: = NVL(p_stream_type_subclass, NVL(styb.stream_type_subclass,'x'))
415: );
416:
417: -- case 4
418: CURSOR c_kle_eq(p_kle_id okc_k_lines_b.ID%TYPE, p_effective_date DATE) IS
419: SELECT '1'
420: FROM okl_pool_contents pocb,
421: okl_pools polb,
422: okc_k_headers_b chrb
504: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
505: ,x_return_status OUT NOCOPY VARCHAR2
506: ,x_msg_count OUT NOCOPY NUMBER
507: ,x_msg_data OUT NOCOPY VARCHAR2
508: ,p_kle_id IN okc_k_lines_b.ID%TYPE
509: ,p_effective_date IN DATE
510: -- cklee 08-08-2003 11.5.10
511: ,p_effective_date_operator IN VARCHAR2 DEFAULT G_GREATER_THAN_EQUAL_TO
512: ,p_stream_type_subclass IN okl_strm_type_b.stream_type_subclass%TYPE DEFAULT NULL
519: l_api_version CONSTANT NUMBER := 1.0;
520: i NUMBER;
521: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
522:
523: CURSOR c_inv_khr(p_kle_id okc_k_lines_b.id%TYPE) IS
524: SELECT ph.khr_id -- inv agreemnet id
525: FROM okl_pools ph
526: WHERE EXISTS (SELECT '1'
527: FROM okl_pool_contents pl
1373: ,p_init_msg_list IN VARCHAR2
1374: ,x_return_status OUT NOCOPY VARCHAR2
1375: ,x_msg_count OUT NOCOPY NUMBER
1376: ,x_msg_data OUT NOCOPY VARCHAR2
1377: ,p_kle_id IN OKC_K_LINES_B.ID%TYPE
1378: ,p_effective_date IN DATE
1379: )
1380: IS
1381: BEGIN
1635: ,p_init_msg_list IN VARCHAR2
1636: ,x_return_status OUT NOCOPY VARCHAR2
1637: ,x_msg_count OUT NOCOPY NUMBER
1638: ,x_msg_data OUT NOCOPY VARCHAR2
1639: ,p_kle_id IN okc_k_lines_b.ID%TYPE
1640: ,p_effective_date IN DATE
1641: ,p_rgd_code IN VARCHAR2
1642: ,p_rdf_code IN VARCHAR2
1643: ,x_process_code OUT NOCOPY VARCHAR2
1653: l_action NUMBER;
1654:
1655: CURSOR c_action(p_rgd_code okc_rule_groups_b.rgd_code%TYPE,
1656: p_rdf_code okc_rules_b.RULE_INFORMATION_CATEGORY%TYPE,
1657: p_kle_id okc_k_lines_b.id%TYPE) IS
1658: SELECT MIN(DECODE(rg.RULE_INFORMATION1, G_PROCESS_AUTO_BACK_BACK, G_PRIORITY_2,
1659: G_PROCESS_NOT_ALLOWED, G_PRIORITY_1,
1660: G_PRIORITY_2))
1661: FROM okc_rule_groups_b rgd,
1676:
1677: CURSOR c_inv_khr(p_rgd_code okc_rule_groups_b.rgd_code%TYPE,
1678: p_rdf_code okc_rules_b.RULE_INFORMATION_CATEGORY%TYPE,
1679:
1680: p_kle_id okc_k_lines_b.id%TYPE) IS
1681: SELECT rgd.dnz_chr_id,
1682: rg.RULE_INFORMATION1
1683: FROM okc_rule_groups_b rgd,
1684: okc_rules_b rg
2106: CURSOR l_okl_rev_shares_csr(p_khr_id IN NUMBER,p_sty_id IN NUMBER)
2107: IS
2108: SELECT kleb.percent_stake percent_stake
2109: FROM okl_k_lines kleb
2110: ,okc_k_lines_b cles
2111: ,okc_line_styles_b lses
2112: ,okc_k_lines_b clet
2113: ,okc_line_styles_b lset
2114: WHERE clet.dnz_chr_id = p_khr_id
2108: SELECT kleb.percent_stake percent_stake
2109: FROM okl_k_lines kleb
2110: ,okc_k_lines_b cles
2111: ,okc_line_styles_b lses
2112: ,okc_k_lines_b clet
2113: ,okc_line_styles_b lset
2114: WHERE clet.dnz_chr_id = p_khr_id
2115: AND clet.lse_id = lset.id
2116: AND lset.lty_code = 'INVESTMENT'
2540: p_api_version IN NUMBER
2541: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
2542: ,p_transaction_reason IN VARCHAR2
2543: ,p_khr_id IN okc_k_headers_b.ID%TYPE
2544: ,p_kle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT NULL
2545: ,p_stream_type_subclass IN okl_strm_type_b.stream_type_subclass%TYPE DEFAULT NULL
2546: ,p_transaction_date IN DATE
2547: ,p_effective_date IN DATE
2548: ,x_return_status OUT NOCOPY VARCHAR2
2867: p_api_version IN NUMBER
2868: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
2869: ,p_transaction_reason IN VARCHAR2
2870: ,p_khr_id IN OKC_K_HEADERS_B.ID%TYPE
2871: ,p_kle_id IN OKC_K_LINES_B.ID%TYPE
2872: ,p_split_kle_ids IN cle_tbl_type
2873: ,p_transaction_date IN DATE
2874: ,p_effective_date IN DATE
2875: ,x_return_status OUT NOCOPY VARCHAR2