[Home] [Help]
64: SUBTYPE itiv_rec_type IS OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
65: SUBTYPE itiv_tbl_type IS OKL_TXL_ITM_INSTS_PUB.iipv_tbl_type;
66: SUBTYPE rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;
67: TYPE g_chr_sts_rec IS RECORD (chr_id NUMBER := OKL_API.G_MISS_NUM,
68: sts_code OKC_K_LINES_B.STS_CODE%TYPE);
69: TYPE g_chr_sts_tbl IS TABLE OF g_chr_sts_rec
70: INDEX BY BINARY_INTEGER;
71:
72: TYPE g_cle_amt_rec IS RECORD (cle_id NUMBER := OKL_API.G_MISS_NUM,
1560: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
1561: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1562: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1563:
1564: CURSOR c_get_k_stream(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1565: SELECT id stm_id
1566: FROM OKL_STREAMS
1567: WHERE khr_id = p_khr_id;
1568:
1565: SELECT id stm_id
1566: FROM OKL_STREAMS
1567: WHERE khr_id = p_khr_id;
1568:
1569: CURSOR c_get_je_trans(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1570: SELECT id trx_id
1571: FROM OKL_TRX_CONTRACTS
1572: WHERE khr_id = p_khr_id
1573: --rkuttiya added for 12.1.1 Multi GAAP
1572: WHERE khr_id = p_khr_id
1573: --rkuttiya added for 12.1.1 Multi GAAP
1574: AND representation_type = 'PRIMARY';
1575:
1576: CURSOR c_get_source_id(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1577: SELECT id
1578: FROM OKL_TXL_CNTRCT_LNS
1579: WHERE khr_id = p_khr_id;
1580:
1577: SELECT id
1578: FROM OKL_TXL_CNTRCT_LNS
1579: WHERE khr_id = p_khr_id;
1580:
1581: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1582: SELECT cle.id top_line
1583: FROM okc_line_styles_b lse,
1584: okc_k_lines_b cle
1585: WHERE cle.dnz_chr_id = p_dnz_chr_id
1580:
1581: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1582: SELECT cle.id top_line
1583: FROM okc_line_styles_b lse,
1584: okc_k_lines_b cle
1585: WHERE cle.dnz_chr_id = p_dnz_chr_id
1586: AND cle.cle_id IS NULL
1587: AND cle.chr_id = cle.dnz_chr_id
1588: AND cle.lse_id = lse.id
2247: IS
2248: SELECT '1'
2249: FROM DUAL
2250: WHERE EXISTS (SELECT '1'
2251: FROM OKC_K_LINES_B cle,
2252: OKC_LINE_STYLES_b lse
2253: WHERE cle.dnz_chr_id = p_chr_id
2254: AND lse.id = cle.lse_id
2255: AND lse.lty_code IN (G_SER_LINE_LTY_CODE,
2280: CURSOR get_item_info_tls(p_dnz_chr_Id OKC_K_HEADERS_V.ID%TYPE)
2281: IS
2282: select tcle.id id
2283: from okc_k_items tcim,
2284: okc_k_lines_b tcle,
2285: okc_line_styles_b lse
2286: where tcim.dnz_chr_id = p_dnz_chr_id
2287: and tcle.lse_id = lse.id
2288: and tcim.cle_id = tcle.id
2289: and tcim.dnz_chr_id = tcle.dnz_chr_id
2290: and lse.lty_code in (G_FEE_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
2291: and exists (select 1
2292: from okc_k_items cim,
2293: okc_k_lines_b cle
2294: where cim.dnz_chr_id = p_dnz_chr_id
2295: and cle.cle_id = tcle.id
2296: and cim.cle_id = cle.id
2297: and cim.jtot_object1_code = 'OKX_COVASST'
2296: and cim.cle_id = cle.id
2297: and cim.jtot_object1_code = 'OKX_COVASST'
2298: and not exists
2299: (select 1
2300: from okc_k_lines_b cle,
2301: okc_line_styles_b lse
2302: where cle.dnz_chr_id = p_dnz_chr_id
2303: and cle.lse_id = lse.id
2304: and lse.lty_code in (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
2305: and lse.lse_type = G_TLS_TYPE
2306: and cle.id = cim.object1_id1))
2307: and not exists
2308: (select 1
2309: from okc_k_lines_b cle,
2310: okc_line_styles_b lse
2311: where cle.dnz_chr_id = p_dnz_chr_id
2312: and cle.lse_id = lse.id
2313: and lse.lty_code in (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
2312: and cle.lse_id = lse.id
2313: and lse.lty_code in (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
2314: and lse.lse_type = G_TLS_TYPE
2315: and exists(select 1
2316: from okc_k_lines_b scle,
2317: okc_k_items scim
2318: where scle.id = scim.cle_id -- sub line join with item
2319: and scim.dnz_chr_id = p_dnz_chr_id
2320: and scim.dnz_chr_id = tcle.dnz_chr_id
2330: WHERE cle.dnz_chr_id = p_dnz_chr_Id
2331: AND cle.id = cim.cle_id
2332: AND cim.jtot_object1_code = 'OKX_COVASST'
2333: AND cim.object1_id1 NOT IN (SELECT cle.id
2334: FROM okc_k_lines_b cle,
2335: okc_line_styles_b lse
2336: WHERE cle.dnz_chr_id = p_dnz_chr_Id
2337: AND cle.lse_id = lse.id
2338: AND lse.lty_code IN (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
2343: /* CURSOR get_item_info_tls(p_dnz_chr_Id OKC_K_HEADERS_V.ID%TYPE)
2344: IS
2345: SELECT cle.cle_id fee_top_line_id, cim.cle_id linked_asset_id
2346: FROM okc_k_items cim,
2347: okc_k_lines_b cle
2348: WHERE cim.dnz_chr_id = p_dnz_chr_Id
2349: AND cim.cle_id = cle.id
2350: AND cim.dnz_chr_id = cle.dnz_chr_id
2351: AND cim.jtot_object1_code = 'OKX_COVASST'
2349: AND cim.cle_id = cle.id
2350: AND cim.dnz_chr_id = cle.dnz_chr_id
2351: AND cim.jtot_object1_code = 'OKX_COVASST'
2352: AND cim.object1_id1 not in (SELECT cle.id
2353: FROM okc_k_lines_b cle,
2354: okc_line_styles_b lse
2355: WHERE cle.dnz_chr_id = p_dnz_chr_Id
2356: AND cle.lse_id = lse.id
2357: AND lse.lty_code = G_FIN_LINE_LTY_CODE
2363: FROM okc_k_items cim
2364: WHERE cim.dnz_chr_id = p_dnz_chr_Id
2365: AND cim.jtot_object1_code = 'OKX_COVASST'
2366: AND cim.object1_id1 not in (SELECT cle.id
2367: FROM okc_k_lines_b cle,
2368: okc_line_styles_b lse
2369: WHERE cle.dnz_chr_id = p_dnz_chr_Id
2370: AND cle.lse_id = lse.id
2371: AND lse.lty_code = G_FIN_LINE_LTY_CODE
3319: IS
3320: SELECT '1'
3321: FROM DUAL
3322: WHERE EXISTS (SELECT '1'
3323: FROM OKC_K_LINES_B cle,
3324: OKC_LINE_STYLES_b lse
3325: WHERE cle.dnz_chr_id = p_chr_id
3326: AND lse.id = cle.lse_id
3327: AND lse.lty_code IN (G_USG_LINE_LTY_CODE,
3398: AND cle.id = iti.kle_id;
3399:
3400: -- To get the item information from original line id and original contract id
3401: CURSOR get_item_info(p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE,
3402: p_orig_cle_id OKC_K_LINES_B.ID%TYPE) IS
3403: SELECT object1_id1,
3404: object1_id2
3405: FROM okc_k_items
3406: WHERE cle_id = p_orig_cle_id
4528: AND TRUNC(a.date_processed) IN (SELECT MAX(TRUNC(b.date_processed))
4529: FROM okl_stream_interfaces b
4530: WHERE b.khr_id = p_khr_id);
4531:
4532: CURSOR c_get_source_id(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4533: SELECT id
4534: FROM OKL_TXL_CNTRCT_LNS
4535: WHERE khr_id = p_khr_id;
4536: