[Home] [Help]
1529: cleb_fee.start_date,
1530: cleb_fee.end_date,
1531: cim_fee.id cim_fee_id,
1532: cim_fee.object1_id1
1533: FROM okl_k_lines kle_fee,
1534: okc_k_lines_b cleb_fee,
1535: okc_k_items cim_fee
1536: WHERE cleb_fee.id = p_fee_cle_id
1537: AND kle_fee.id = cleb_fee.id
1549: SELECT cleb_cov_asset.id cleb_cov_asset_id,
1550: NVL(kle_cov_asset.capital_amount,kle_cov_asset.amount) amount,
1551: cim_cov_asset.id cim_cov_asset_id
1552: FROM okc_k_lines_b cleb_cov_asset,
1553: okl_k_lines kle_cov_asset,
1554: okc_k_items cim_cov_asset
1555: WHERE cleb_cov_asset.cle_id = p_fee_cle_id
1556: AND cleb_cov_asset.dnz_chr_id = p_chr_id
1557: AND kle_cov_asset.id = cleb_cov_asset.id
1587: CURSOR check_fee_csr(p_chr_id IN NUMBER,
1588: p_fee_type IN VARCHAR2 ) IS
1589: SELECT cle.id
1590: FROM okc_k_lines_b cle,
1591: okl_k_lines kle
1592: WHERE cle.id = kle.id
1593: AND cle.dnz_chr_id = p_chr_id
1594: AND kle.fee_purpose_code = 'SALESTAX'
1595: AND kle.fee_type = p_fee_type
2077: CURSOR l_fee_csr (p_chr_id IN NUMBER) IS
2078: SELECT cle.id,
2079: kle.fee_type
2080: FROM okc_k_lines_b cle,
2081: okl_k_lines kle
2082: WHERE cle.id = kle.id
2083: AND cle.dnz_chr_id = p_chr_id
2084: AND cle.chr_id = p_chr_id
2085: AND kle.fee_purpose_code = 'SALESTAX'
2329: -- Bug# 6512668: Exclude fee line in Abandoned status
2330: CURSOR check_fee_csr ( l_fee_type IN VARCHAR2 ) IS
2331: SELECT cle.id
2332: FROM OKC_K_LINES_b cle,
2333: OKL_K_LINES KLE
2334: WHERE cle.id = kle.id
2335: AND cle.dnz_chr_id = p_contract_id
2336: AND kle.fee_purpose_code = 'SALESTAX'
2337: AND kle.fee_type = l_fee_type
4244: CURSOR check_st_fee_csr(p_chr_id IN NUMBER,
4245: p_fee_type IN VARCHAR2) IS
4246: SELECT cle.id
4247: FROM okc_k_lines_b cle,
4248: okl_k_lines kle
4249: WHERE cle.id = kle.id
4250: AND cle.dnz_chr_id = p_chr_id
4251: AND kle.fee_purpose_code = 'SALESTAX'
4252: AND kle.fee_type = NVL(p_fee_type,kle.fee_type)
4253: AND cle.sts_code <> 'ABANDONED';
4254:
4255: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;
4256: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
4257: l_fee_type_to_delete OKL_K_LINES.fee_type%TYPE;
4258:
4259: BEGIN
4260: IF (G_DEBUG_ENABLED = 'Y') THEN
4261: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
5731: --decode(kle.fee_type,'CAPITALIZED',kle.capital_amount,kle.amount) amount
5732: FROM
5733: okc_k_lines_b cleb,
5734: okc_k_lines_tl clet,
5735: okl_k_lines kle,
5736: okc_line_styles_v sty,
5737: okc_statuses_v sts
5738: WHERE cleb.lse_id = sty.id
5739: AND cleb.sts_code = sts.code
5744: AND cleb.id = clet.id
5745: AND clet.LANGUAGE = USERENV('LANG')
5746: AND kle.id = cleb.id;
5747: l_st_fee_rec st_fee_csr%ROWTYPE;
5748: l_fee_amount okl_k_lines.amount%TYPE;
5749:
5750: CURSOR st_fee_link_asset_csr(p_cleId OKC_K_LINES_B.ID%TYPE) IS
5751: SELECT cleb.id,
5752: nvl(kle.amount,0) amount,
5751: SELECT cleb.id,
5752: nvl(kle.amount,0) amount,
5753: nvl(kle.capital_amount,0) capital_amount
5754: FROM okc_k_lines_b cleb,
5755: okl_k_lines kle,
5756: okc_line_styles_b sty
5757: WHERE cle_id = p_cleId
5758: AND cleb.id = kle.id
5759: AND cleb.lse_id = sty.id
5785: AND lty_code = 'FREE_FORM1'
5786: AND cle.sts_code = sts.code
5787: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
5788:
5789: --CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE, p_fee_type OKL_K_LINES.FEE_TYPE%TYPE) IS
5790: CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE) IS
5791: SELECT item.object1_id1,cleb.id,cleb.cle_id,
5792: clet_asset.name,
5793: kle.amount,
5793: kle.amount,
5794: kle.fee_type
5795: FROM okc_k_lines_b fee_line,
5796: okc_k_lines_b cleb,
5797: okl_k_lines kle,
5798: okc_k_items item,
5799: okc_k_lines_tl clet_asset,
5800: okc_line_styles_b sty
5801: WHERE fee_line.id = kle.id
5836: -- R12B Authoring OA Migration
5837: CURSOR st_fee_count_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5838: SELECT COUNT(cleb.id)
5839: FROM okc_k_lines_b cleb,
5840: okl_k_lines kle,
5841: okc_line_styles_b sty,
5842: okc_statuses_b sts
5843: WHERE cleb.lse_id = sty.id
5844: AND sty.lty_code = 'FEE'
6471: kle.amount,
6472: clev.name,
6473: lsev.name line_type
6474: FROM okc_k_lines_v clev,
6475: okl_k_lines kle,
6476: okc_statuses_b okcsts,
6477: okc_line_styles_v lsev
6478: WHERE clev.dnz_chr_id = p_chr_id
6479: AND clev.chr_id = p_chr_id
6486:
6487: /* Cursor to get the financed fee sub-lines (applied to assets) for a
6488: given contract. */
6489: CURSOR l_fn_sub_ln_fee_csr ( p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
6490: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
6491: SELECT kle.id,
6492: kle.amount,
6493: cleb.end_date,
6494: cleb.start_date
6492: kle.amount,
6493: cleb.end_date,
6494: cleb.start_date
6495: FROM okc_k_lines_b cleb,
6496: okl_k_lines kle,
6497: okc_statuses_b okcsts
6498: WHERE cleb.dnz_chr_id = p_chr_id
6499: AND kle.id = cleb.id
6500: AND cleb.cle_id = p_fee_line_id
6503:
6504: /* Cursor to get the financed fee top/sub-line payments for a
6505: given contract. */
6506: CURSOR l_fn_fee_pmt_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
6507: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
6508: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
6509: SLL.rule_information3 periods,
6510: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6511: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
6529:
6530: /* Cursor to get the financed fee top/sub-line payments HEADER for a
6531: given contract. */
6532: CURSOR l_fn_fee_pmtH_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
6533: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
6534:
6535: SELECT slh.id
6536: FROM okc_rules_b slh,
6537: okc_rule_groups_b rgp,