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 477: FROM okc_k_lines_b

473: AND passthru_term = p_passthru_term;
474:
475: CURSOR l_cle_csr(p_cle_id IN NUMBER) IS
476: SELECT orig_system_id1
477: FROM okc_k_lines_b
478: WHERE id = p_cle_id;
479:
480: l_cle_rec l_cle_csr%ROWTYPE;
481: l_chk_rebook_chr VARCHAR2(1);

Line 870: p_fee_line_id IN okc_k_lines_b.id%TYPE,

866: x_return_status OUT NOCOPY VARCHAR2,
867: x_msg_count OUT NOCOPY NUMBER,
868: x_msg_data OUT NOCOPY VARCHAR2,
869: p_chr_id IN okc_k_headers_b.id%TYPE,
870: p_fee_line_id IN okc_k_lines_b.id%TYPE,
871: p_event_name IN wf_events.name%TYPE) IS
872:
873: l_parameter_list wf_parameter_list_t;
874: l_contract_process VARCHAR2(30);

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

1040: from okc_k_headers_b chr, okl_k_headers khr
1041: where chr.id = p_fee_types_rec.dnz_chr_id
1042: and chr.id = khr.id;
1043:
1044: CURSOR l_roll_qt_csr(p_start_date okc_k_lines_b.start_date%type) IS
1045: SELECT rqt.qte_id
1046: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1047: OKC_K_HEADERS_B chr
1048: WHERE CHR.CUST_ACCT_ID = rqt.cust_acct_id

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

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

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

1063: AND trunc(p_start_date) between nvl(trunc(date_effective_from),trunc(p_start_date))
1064: and nvl(trunc(date_effective_to),trunc(p_start_date+1))
1065: AND chr.id = p_fee_types_rec.dnz_chr_id;
1066:
1067: CURSOR l_qte_id_prog_csr(p_start_date okc_k_lines_b.start_date%type) IS
1068: SELECT rqt.rollover_quote
1069: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1070: OKC_K_HEADERS_B chr,
1071: okl_k_headers khr

Line 1089: okc_k_lines_b cle

1085:
1086: CURSOR l_chk_roll_qt_upd_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: and cle.id <> p_fee_types_rec.line_id;

Line 1098: okc_k_lines_b cle

1094:
1095: CURSOR l_chk_roll_qt_crt_csr(p_qte_id okl_k_lines.qte_id%type) IS
1096: select 1
1097: from okl_k_lines kle,
1098: okc_k_lines_b cle
1099: where cle.id = kle.id
1100: and kle.qte_id = p_qte_id
1101: and cle.dnz_chr_id = p_fee_types_rec.dnz_chr_id;
1102:

Line 1114: okc_k_lines_b cle

1110: -- Modified by zrehman for Bug#6763287 on 17-Jan-2008 start
1111: CURSOR l_inv_id_csr IS
1112: select hz.party_name
1113: from
1114: okc_k_lines_b cle
1115: , okc_k_headers_all_b chr
1116: , hz_parties hz
1117: , hz_cust_accounts hca
1118: where

Line 1130: okc_k_lines_b cle

1126:
1127: CURSOR l_inv_name_csr IS
1128: select hz.party_id
1129: from
1130: okc_k_lines_b cle
1131: , okc_k_headers_all_b chr
1132: , hz_parties hz
1133: , hz_cust_accounts hca
1134: where

Line 2521: FROM okc_k_lines_b cle

2517: p_chr_id IN NUMBER) IS
2518: SELECT cle.id,
2519: cle.start_date,
2520: cle.end_date
2521: FROM okc_k_lines_b cle
2522: WHERE cle.cle_id = p_cle_id
2523: AND cle.dnz_chr_id = p_chr_id;
2524:
2525: l_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 2821: okc_k_lines_b cle

2817: CURSOR l_line_csr(p_cle_id IN NUMBER) IS
2818: SELECT kle.qte_id,
2819: cle.orig_system_id1
2820: FROM okl_k_lines kle,
2821: okc_k_lines_b cle
2822: WHERE cle.id = p_cle_id
2823: AND kle.id = cle.id;
2824:
2825: -- Bug# 6438785

Line 2828: FROM okc_k_lines_b cle

2824:
2825: -- Bug# 6438785
2826: CURSOR c_orig_cle_csr(p_cle_id IN NUMBER) IS
2827: SELECT cle.start_date
2828: FROM okc_k_lines_b cle
2829: WHERE cle.id = p_cle_id;
2830:
2831: l_orig_cle_rec c_orig_cle_csr%ROWTYPE;
2832:

Line 3100: from okc_k_lines_b cle

3096: and chr.orig_system_source_code = 'OKL_REBOOK';
3097:
3098: CURSOR c_sub_line_csr( p_line_id IN NUMBER, p_chr_id IN NUMBER) IS
3099: select cle.id
3100: from okc_k_lines_b cle
3101: where cle.dnz_chr_id = p_chr_id
3102: and cle.cle_id = p_line_id;
3103:
3104: --Bug# 3877032

Line 3109: from okc_k_lines_b cle,

3105: --Bug# 6787858: Allow delete of 'GENERAL' fee and fees newly added during rebook
3106: CURSOR l_fee_type_csr IS
3107: select kle.fee_type,
3108: cle.orig_system_id1
3109: from okc_k_lines_b cle,
3110: okl_k_lines kle
3111: where cle.id = kle.id
3112: and cle.dnz_chr_id = p_fee_types_rec.dnz_chr_id
3113: and cle.id = p_fee_types_rec.line_id;

Line 3121: okc_k_lines_b cleb,

3117: select kle_fee.fee_type,
3118: cim.object1_id1,
3119: cim.dnz_chr_id
3120: from okc_k_items cim,
3121: okc_k_lines_b cleb,
3122: okl_k_lines kle_fee,
3123: okc_k_lines_b cleb_fee,
3124: okc_line_styles_b lseb_fee
3125: where cim.cle_id = cleb.id

Line 3123: okc_k_lines_b cleb_fee,

3119: cim.dnz_chr_id
3120: from okc_k_items cim,
3121: okc_k_lines_b cleb,
3122: okl_k_lines kle_fee,
3123: okc_k_lines_b cleb_fee,
3124: okc_line_styles_b lseb_fee
3125: where cim.cle_id = cleb.id
3126: and cim.dnz_chr_id = cleb.dnz_chr_id
3127: and cim.jtot_object1_code = 'OKX_COVASST'

Line 3147: l_orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE;

3143: i number;
3144: --End Bug# 3877032
3145:
3146: --Bug# 6787858
3147: l_orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE;
3148:
3149: BEGIN
3150:
3151: l_line_id := p_fee_types_rec.line_id;

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

4016: l_q_num OKL_TRX_QUOTES_B.QUOTE_NUMBER%TYPE;
4017: l_fee_name OKC_K_LINES_V.NAME%TYPE;
4018:
4019: l_rebook_yn VARCHAR2(1) := null;
4020: l_ln_orig_sys_id1 okc_k_lines_b.orig_system_id1%type := null;
4021: l_mass_rebook_cnt NUMBER := null;
4022: l_do_validation VARCHAR2(1);
4023:
4024: /* Cursor to get the contract number and quote number. */

Line 4100: okc_k_lines_b cle,

4096: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4097: SELECT 1
4098: FROM okc_k_headers_b khr,
4099: okl_k_lines kle,
4100: okc_k_lines_b cle,
4101: okl_trx_quotes_b qte
4102: WHERE cle.id = kle.id
4103: AND khr.id = chrID
4104: AND khr.id = cle.dnz_chr_id

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

4128: WHERE qte.id = qteID
4129: AND tql.qte_id= qte.id
4130: AND tql.qlt_code not in ('AMCFIA', 'AMCTAX', 'AMYOUB', 'BILL_ADJST'))
4131: INTERSECT
4132: (SELECT SUM(KLE1.amount) FROM okc_k_lines_b cleb, okl_k_lines kle1
4133: WHERE cleb.dnz_chr_id = chrID
4134: AND kle1.ID = cleb.ID
4135: AND kle1.fee_type = 'ROLLOVER'
4136: AND kle1.qte_id = qteID

Line 4161: FROM okc_k_lines_b cle,

4157: /* Cursor to check if orig_system_id1 exists for a re-book contract
4158: If yes, ignore approval step else continue all the checks */
4159: 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
4160: SELECT orig_system_id1
4161: FROM okc_k_lines_b cle,
4162: okl_k_lines kle
4163: WHERE cle.id = kle.id
4164: AND dnz_chr_id = p_chr_id
4165: AND kle.qte_id = p_qte_id;

Line 4581: from okc_k_lines_b cle,

4577: ) IS
4578:
4579: cursor c_roll_fee(p_chr_id number) is
4580: select nvl(sum(kle.amount),0) amt
4581: from okc_k_lines_b cle,
4582: okl_k_lines kle,
4583: okc_line_styles_b lse
4584: where cle.id = kle.id
4585: and cle.dnz_chr_id = p_chr_id

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

4728: that is booked for the first time. */
4729:
4730: CURSOR l_rq_fee_lns_bkg_csr ( p_chr_id number ) IS
4731: SELECT kle.qte_id
4732: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
4733: WHERE khr.id = p_chr_id
4734: AND cleb.dnz_chr_id = khr.id
4735: AND kle.ID = cleb.ID
4736: AND kle.fee_type = 'ROLLOVER';

Line 4910: FROM okc_k_lines_b cle,

4906:
4907: CURSOR c_asset_number(p_fin_asset_id IN NUMBER,
4908: p_chr_id IN NUMBER) IS
4909: SELECT txl.asset_number
4910: FROM okc_k_lines_b cle,
4911: okc_line_styles_b lse,
4912: okl_txl_assets_b txl
4913: WHERE cle.id = txl.kle_id
4914: AND cle.lse_id = lse.id

Line 4923: FROM okc_k_lines_b cle,

4919:
4920: CURSOR c_term_sub_lines(p_cle_id IN NUMBER,
4921: p_chr_id IN NUMBER) is
4922: SELECT SUM(NVL(kle.capital_amount,kle.amount)) amount
4923: FROM okc_k_lines_b cle,
4924: okl_k_lines kle
4925: WHERE cle.cle_id = p_cle_id
4926: AND cle.dnz_chr_id = p_chr_id
4927: AND cle.sts_code = 'TERMINATED'

Line 5254: FROM okc_k_lines_b cov_ast_cle,

5250: p_fee_cle_id IN NUMBER,
5251: p_fin_ast_id IN NUMBER) IS
5252: SELECT cov_ast_cle.id cov_ast_cle_id,
5253: cov_ast_cim.id cov_ast_cim_id
5254: FROM okc_k_lines_b cov_ast_cle,
5255: okc_k_items cov_ast_cim
5256: WHERE cov_ast_cle.dnz_chr_id = p_chr_id
5257: AND cov_ast_cle.cle_id = p_fee_cle_id
5258: AND cov_ast_cim.cle_id = cov_ast_cle.id

Line 5440: okc_k_lines_b cleb,okl_k_lines kleb,okc_line_styles_b lseb

5436: -- cursor to get fee line id and amount
5437: CURSOR get_fee_line_id (p_chr_id in NUMBER) IS
5438: SELECT kleb.id,Kleb.amount
5439: FROM
5440: okc_k_lines_b cleb,okl_k_lines kleb,okc_line_styles_b lseb
5441: WHERE cleb.dnz_chr_id = p_chr_id AND
5442: kleb.id = cleb.id AND
5443: cleb.lse_id = lseb.id AND
5444: lseb.lty_code = 'FEE' AND

Line 5453: okc_k_lines_b cleb,

5449: CURSOR get_stream_name_csr (p_chr_id in NUMBER) IS
5450: SELECT styb.id, styb.code
5451: FROM okl_strm_type_b styb,
5452: okc_k_items cim,
5453: okc_k_lines_b cleb,
5454: okl_k_lines kle
5455: WHERE styb.id = cim.object1_id1
5456: AND '#' = cim.object1_id2
5457: AND cim.jtot_object1_code = 'OKL_STRMTYP'

Line 5478: l_line_id okc_k_lines_b.id%type;

5474: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5475: l_api_name VARCHAR2(200) := 'process_rvi_stream';
5476:
5477: l_fee_types_rec fee_types_rec_type := p_fee_types_rec;
5478: l_line_id okc_k_lines_b.id%type;
5479: l_chr_id okc_k_lines_b.dnz_chr_id%type;
5480: l_check_box_value VARCHAR2(450);
5481: l_strm_id okl_strm_type_b.id%type;
5482: l_strm_name okl_strm_type_b.code%type;

Line 5479: l_chr_id okc_k_lines_b.dnz_chr_id%type;

5475: l_api_name VARCHAR2(200) := 'process_rvi_stream';
5476:
5477: l_fee_types_rec fee_types_rec_type := p_fee_types_rec;
5478: l_line_id okc_k_lines_b.id%type;
5479: l_chr_id okc_k_lines_b.dnz_chr_id%type;
5480: l_check_box_value VARCHAR2(450);
5481: l_strm_id okl_strm_type_b.id%type;
5482: l_strm_name okl_strm_type_b.code%type;
5483: l_fee_line_id okl_k_lines.id%type;