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_MAINTAIN_FEE_PVT dependencies on OKC_K_LINES_B

Line 473: FROM okc_k_lines_b

469: WHERE id = p_pph_id;
470:
471: CURSOR l_cle_csr(p_cle_id IN NUMBER) IS
472: SELECT orig_system_id1
473: FROM okc_k_lines_b
474: WHERE id = p_cle_id;
475:
476: l_cle_rec l_cle_csr%ROWTYPE;
477: l_chk_rebook_chr VARCHAR2(1);

Line 861: p_fee_line_id IN okc_k_lines_b.id%TYPE,

857: x_return_status OUT NOCOPY VARCHAR2,
858: x_msg_count OUT NOCOPY NUMBER,
859: x_msg_data OUT NOCOPY VARCHAR2,
860: p_chr_id IN okc_k_headers_b.id%TYPE,
861: p_fee_line_id IN okc_k_lines_b.id%TYPE,
862: p_event_name IN wf_events.name%TYPE) IS
863:
864: l_parameter_list wf_parameter_list_t;
865: l_contract_process VARCHAR2(30);

Line 1035: CURSOR l_roll_qt_csr(p_start_date okc_k_lines_b.start_date%type) IS

1031: from okc_k_headers_b chr, okl_k_headers khr
1032: where chr.id = p_fee_types_rec.dnz_chr_id
1033: and chr.id = khr.id;
1034:
1035: CURSOR l_roll_qt_csr(p_start_date okc_k_lines_b.start_date%type) IS
1036: SELECT rqt.qte_id
1037: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1038: OKC_K_HEADERS_B chr
1039: WHERE CHR.CUST_ACCT_ID = rqt.cust_acct_id

Line 1045: CURSOR l_qte_id_csr(p_start_date okc_k_lines_b.start_date%type) IS

1041: AND trunc(p_start_date) between nvl(trunc(date_effective_from),trunc(p_start_date))
1042: and nvl(trunc(date_effective_to),trunc(p_start_date+1))
1043: AND chr.id = p_fee_types_rec.dnz_chr_id;
1044:
1045: CURSOR l_qte_id_csr(p_start_date okc_k_lines_b.start_date%type) IS
1046: SELECT rqt.rollover_quote
1047: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1048: OKC_K_HEADERS_B chr,
1049: okl_k_headers khr

Line 1058: CURSOR l_qte_id_prog_csr(p_start_date okc_k_lines_b.start_date%type) IS

1054: AND trunc(p_start_date) between nvl(trunc(date_effective_from),trunc(p_start_date))
1055: and nvl(trunc(date_effective_to),trunc(p_start_date+1))
1056: AND chr.id = p_fee_types_rec.dnz_chr_id;
1057:
1058: CURSOR l_qte_id_prog_csr(p_start_date okc_k_lines_b.start_date%type) IS
1059: SELECT rqt.rollover_quote
1060: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1061: OKC_K_HEADERS_B chr,
1062: okl_k_headers khr

Line 1080: okc_k_lines_b cle

1076:
1077: CURSOR l_chk_roll_qt_upd_csr(p_qte_id okl_k_lines.qte_id%type) IS
1078: select 1
1079: from okl_k_lines kle,
1080: okc_k_lines_b cle
1081: where cle.id = kle.id
1082: and kle.qte_id = p_qte_id
1083: and cle.dnz_chr_id = p_fee_types_rec.dnz_chr_id
1084: and cle.id <> p_fee_types_rec.line_id;

Line 1089: okc_k_lines_b cle

1085:
1086: CURSOR l_chk_roll_qt_crt_csr(p_qte_id okl_k_lines.qte_id%type) IS
1087: select 1
1088: from okl_k_lines kle,
1089: okc_k_lines_b cle
1090: where cle.id = kle.id
1091: and kle.qte_id = p_qte_id
1092: and cle.dnz_chr_id = p_fee_types_rec.dnz_chr_id;
1093:

Line 1105: okc_k_lines_b cle

1101: -- Modified by zrehman for Bug#6763287 on 17-Jan-2008 start
1102: CURSOR l_inv_id_csr IS
1103: select hz.party_name
1104: from
1105: okc_k_lines_b cle
1106: , okc_k_headers_all_b chr
1107: , hz_parties hz
1108: , hz_cust_accounts hca
1109: where

Line 1121: okc_k_lines_b cle

1117:
1118: CURSOR l_inv_name_csr IS
1119: select hz.party_id
1120: from
1121: okc_k_lines_b cle
1122: , okc_k_headers_all_b chr
1123: , hz_parties hz
1124: , hz_cust_accounts hca
1125: where

Line 2508: FROM okc_k_lines_b cle

2504: p_chr_id IN NUMBER) IS
2505: SELECT cle.id,
2506: cle.start_date,
2507: cle.end_date
2508: FROM okc_k_lines_b cle
2509: WHERE cle.cle_id = p_cle_id
2510: AND cle.dnz_chr_id = p_chr_id;
2511:
2512: l_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 2808: okc_k_lines_b cle

2804: CURSOR l_line_csr(p_cle_id IN NUMBER) IS
2805: SELECT kle.qte_id,
2806: cle.orig_system_id1
2807: FROM okl_k_lines kle,
2808: okc_k_lines_b cle
2809: WHERE cle.id = p_cle_id
2810: AND kle.id = cle.id;
2811:
2812: -- Bug# 6438785

Line 2815: FROM okc_k_lines_b cle

2811:
2812: -- Bug# 6438785
2813: CURSOR c_orig_cle_csr(p_cle_id IN NUMBER) IS
2814: SELECT cle.start_date
2815: FROM okc_k_lines_b cle
2816: WHERE cle.id = p_cle_id;
2817:
2818: l_orig_cle_rec c_orig_cle_csr%ROWTYPE;
2819:

Line 3087: from okc_k_lines_b cle

3083: and chr.orig_system_source_code = 'OKL_REBOOK';
3084:
3085: CURSOR c_sub_line_csr( p_line_id IN NUMBER, p_chr_id IN NUMBER) IS
3086: select cle.id
3087: from okc_k_lines_b cle
3088: where cle.dnz_chr_id = p_chr_id
3089: and cle.cle_id = p_line_id;
3090:
3091: --Bug# 3877032

Line 3096: from okc_k_lines_b cle,

3092: --Bug# 6787858: Allow delete of 'GENERAL' fee and fees newly added during rebook
3093: CURSOR l_fee_type_csr IS
3094: select kle.fee_type,
3095: cle.orig_system_id1
3096: from okc_k_lines_b cle,
3097: okl_k_lines kle
3098: where cle.id = kle.id
3099: and cle.dnz_chr_id = p_fee_types_rec.dnz_chr_id
3100: and cle.id = p_fee_types_rec.line_id;

Line 3108: okc_k_lines_b cleb,

3104: select kle_fee.fee_type,
3105: cim.object1_id1,
3106: cim.dnz_chr_id
3107: from okc_k_items cim,
3108: okc_k_lines_b cleb,
3109: okl_k_lines kle_fee,
3110: okc_k_lines_b cleb_fee,
3111: okc_line_styles_b lseb_fee
3112: where cim.cle_id = cleb.id

Line 3110: okc_k_lines_b cleb_fee,

3106: cim.dnz_chr_id
3107: from okc_k_items cim,
3108: okc_k_lines_b cleb,
3109: okl_k_lines kle_fee,
3110: okc_k_lines_b cleb_fee,
3111: okc_line_styles_b lseb_fee
3112: where cim.cle_id = cleb.id
3113: and cim.dnz_chr_id = cleb.dnz_chr_id
3114: and cim.jtot_object1_code = 'OKX_COVASST'

Line 3134: l_orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE;

3130: i number;
3131: --End Bug# 3877032
3132:
3133: --Bug# 6787858
3134: l_orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE;
3135:
3136: BEGIN
3137:
3138: l_line_id := p_fee_types_rec.line_id;

Line 4007: l_ln_orig_sys_id1 okc_k_lines_b.orig_system_id1%type := null;

4003: l_q_num OKL_TRX_QUOTES_B.QUOTE_NUMBER%TYPE;
4004: l_fee_name OKC_K_LINES_V.NAME%TYPE;
4005:
4006: l_rebook_yn VARCHAR2(1) := null;
4007: l_ln_orig_sys_id1 okc_k_lines_b.orig_system_id1%type := null;
4008: l_mass_rebook_cnt NUMBER := null;
4009: l_do_validation VARCHAR2(1);
4010:
4011: /* Cursor to get the contract number and quote number. */

Line 4087: okc_k_lines_b cle,

4083: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4084: SELECT 1
4085: FROM okc_k_headers_b khr,
4086: okl_k_lines kle,
4087: okc_k_lines_b cle,
4088: okl_trx_quotes_b qte
4089: WHERE cle.id = kle.id
4090: AND khr.id = chrID
4091: AND khr.id = cle.dnz_chr_id

Line 4119: (SELECT SUM(KLE1.amount) FROM okc_k_lines_b cleb, okl_k_lines kle1

4115: WHERE qte.id = qteID
4116: AND tql.qte_id= qte.id
4117: AND tql.qlt_code not in ('AMCFIA', 'AMCTAX', 'AMYOUB', 'BILL_ADJST'))
4118: INTERSECT
4119: (SELECT SUM(KLE1.amount) FROM okc_k_lines_b cleb, okl_k_lines kle1
4120: WHERE cleb.dnz_chr_id = chrID
4121: AND kle1.ID = cleb.ID
4122: AND kle1.fee_type = 'ROLLOVER'
4123: AND kle1.qte_id = qteID

Line 4148: FROM okc_k_lines_b cle,

4144: /* Cursor to check if orig_system_id1 exists for a re-book contract
4145: If yes, ignore approval step else continue all the checks */
4146: CURSOR l_orig_sys_id1_csr ( p_chr_id OKC_K_HEADERS_B.ID%TYPE, p_qte_id OKL_K_LINES.QTE_ID%TYPE ) IS
4147: SELECT orig_system_id1
4148: FROM okc_k_lines_b cle,
4149: okl_k_lines kle
4150: WHERE cle.id = kle.id
4151: AND dnz_chr_id = p_chr_id
4152: AND kle.qte_id = p_qte_id;

Line 4568: from okc_k_lines_b cle,

4564: ) IS
4565:
4566: cursor c_roll_fee(p_chr_id number) is
4567: select nvl(sum(kle.amount),0) amt
4568: from okc_k_lines_b cle,
4569: okl_k_lines kle,
4570: okc_line_styles_b lse
4571: where cle.id = kle.id
4572: and cle.dnz_chr_id = p_chr_id

Line 4719: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle

4715: that is booked for the first time. */
4716:
4717: CURSOR l_rq_fee_lns_bkg_csr ( p_chr_id number ) IS
4718: SELECT kle.qte_id
4719: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
4720: WHERE khr.id = p_chr_id
4721: AND cleb.dnz_chr_id = khr.id
4722: AND kle.ID = cleb.ID
4723: AND kle.fee_type = 'ROLLOVER';

Line 4897: FROM okc_k_lines_b cle,

4893:
4894: CURSOR c_asset_number(p_fin_asset_id IN NUMBER,
4895: p_chr_id IN NUMBER) IS
4896: SELECT txl.asset_number
4897: FROM okc_k_lines_b cle,
4898: okc_line_styles_b lse,
4899: okl_txl_assets_b txl
4900: WHERE cle.id = txl.kle_id
4901: AND cle.lse_id = lse.id

Line 4910: FROM okc_k_lines_b cle,

4906:
4907: CURSOR c_term_sub_lines(p_cle_id IN NUMBER,
4908: p_chr_id IN NUMBER) is
4909: SELECT SUM(NVL(kle.capital_amount,kle.amount)) amount
4910: FROM okc_k_lines_b cle,
4911: okl_k_lines kle
4912: WHERE cle.cle_id = p_cle_id
4913: AND cle.dnz_chr_id = p_chr_id
4914: AND cle.sts_code = 'TERMINATED'

Line 5241: FROM okc_k_lines_b cov_ast_cle,

5237: p_fee_cle_id IN NUMBER,
5238: p_fin_ast_id IN NUMBER) IS
5239: SELECT cov_ast_cle.id cov_ast_cle_id,
5240: cov_ast_cim.id cov_ast_cim_id
5241: FROM okc_k_lines_b cov_ast_cle,
5242: okc_k_items cov_ast_cim
5243: WHERE cov_ast_cle.dnz_chr_id = p_chr_id
5244: AND cov_ast_cle.cle_id = p_fee_cle_id
5245: AND cov_ast_cim.cle_id = cov_ast_cle.id

Line 5427: okc_k_lines_b cleb,okl_k_lines kleb,okc_line_styles_b lseb

5423: -- cursor to get fee line id and amount
5424: CURSOR get_fee_line_id (p_chr_id in NUMBER) IS
5425: SELECT kleb.id,Kleb.amount
5426: FROM
5427: okc_k_lines_b cleb,okl_k_lines kleb,okc_line_styles_b lseb
5428: WHERE cleb.dnz_chr_id = p_chr_id AND
5429: kleb.id = cleb.id AND
5430: cleb.lse_id = lseb.id AND
5431: lseb.lty_code = 'FEE' AND

Line 5440: okc_k_lines_b cleb,

5436: CURSOR get_stream_name_csr (p_chr_id in NUMBER) IS
5437: SELECT styb.id, styb.code
5438: FROM okl_strm_type_b styb,
5439: okc_k_items cim,
5440: okc_k_lines_b cleb,
5441: okl_k_lines kle
5442: WHERE styb.id = cim.object1_id1
5443: AND '#' = cim.object1_id2
5444: AND cim.jtot_object1_code = 'OKL_STRMTYP'

Line 5465: l_line_id okc_k_lines_b.id%type;

5461: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5462: l_api_name VARCHAR2(200) := 'process_rvi_stream';
5463:
5464: l_fee_types_rec fee_types_rec_type := p_fee_types_rec;
5465: l_line_id okc_k_lines_b.id%type;
5466: l_chr_id okc_k_lines_b.dnz_chr_id%type;
5467: l_check_box_value VARCHAR2(450);
5468: l_strm_id okl_strm_type_b.id%type;
5469: l_strm_name okl_strm_type_b.code%type;

Line 5466: l_chr_id okc_k_lines_b.dnz_chr_id%type;

5462: l_api_name VARCHAR2(200) := 'process_rvi_stream';
5463:
5464: l_fee_types_rec fee_types_rec_type := p_fee_types_rec;
5465: l_line_id okc_k_lines_b.id%type;
5466: l_chr_id okc_k_lines_b.dnz_chr_id%type;
5467: l_check_box_value VARCHAR2(450);
5468: l_strm_id okl_strm_type_b.id%type;
5469: l_strm_name okl_strm_type_b.code%type;
5470: l_fee_line_id okl_k_lines.id%type;