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 OKL_K_LINES

Line 965: l_qte_id okl_k_lines.qte_id%type := null;

961: l_item_id NUMBER:= null;
962: l_item_name OKL_STRMTYP_SOURCE_V.name%type := null;
963: l_start_date okc_k_headers_b.start_date%type := null;
964: l_pdt_id okl_k_headers.pdt_id%type := null;
965: l_qte_id okl_k_lines.qte_id%type := null;
966: l_chk_qte_id okl_k_lines.qte_id%type := null;
967: l_roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type := null;
968: l_khr_id okl_k_headers.khr_id%type := null;
969:

Line 966: l_chk_qte_id okl_k_lines.qte_id%type := null;

962: l_item_name OKL_STRMTYP_SOURCE_V.name%type := null;
963: l_start_date okc_k_headers_b.start_date%type := null;
964: l_pdt_id okl_k_headers.pdt_id%type := null;
965: l_qte_id okl_k_lines.qte_id%type := null;
966: l_chk_qte_id okl_k_lines.qte_id%type := null;
967: l_roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type := null;
968: l_khr_id okl_k_headers.khr_id%type := null;
969:
970: CURSOR l_supp_name_csr IS

Line 1086: CURSOR l_chk_roll_qt_upd_csr(p_qte_id okl_k_lines.qte_id%type) IS

1082: select khr_id
1083: from okl_k_headers
1084: where id = p_fee_types_rec.dnz_chr_id;
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

Line 1088: from okl_k_lines kle,

1084: where id = p_fee_types_rec.dnz_chr_id;
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

Line 1095: CURSOR l_chk_roll_qt_crt_csr(p_qte_id okl_k_lines.qte_id%type) IS

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;
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

Line 1097: from okl_k_lines kle,

1093: and cle.id <> p_fee_types_rec.line_id;
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;

Line 1103: CURSOR l_fee_purpose_csr(p_fee_purpose_code okl_k_lines.FEE_PURPOSE_CODE%type) IS

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:
1103: CURSOR l_fee_purpose_csr(p_fee_purpose_code okl_k_lines.FEE_PURPOSE_CODE%type) IS
1104: select lookup_code
1105: from fnd_lookups fnd
1106: where fnd.lookup_type = G_OKL_FEE_PURPOSE_LOOKUP_TYPE
1107: and fnd.lookup_code = p_fee_purpose_code;

Line 1108: l_fee_purpose_code okl_k_lines.fee_purpose_code%type := null;

1104: select lookup_code
1105: from fnd_lookups fnd
1106: where fnd.lookup_type = G_OKL_FEE_PURPOSE_LOOKUP_TYPE
1107: and fnd.lookup_code = p_fee_purpose_code;
1108: l_fee_purpose_code okl_k_lines.fee_purpose_code%type := null;
1109:
1110: -- Modified by zrehman for Bug#6763287 on 17-Jan-2008 start
1111: CURSOR l_inv_id_csr IS
1112: select hz.party_name

Line 2820: FROM okl_k_lines kle,

2816:
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:

Line 3083: l_fee_type okl_k_lines.fee_type%type := null;

3079: l_line_id l_clev_rec.dnz_chr_id%type;
3080:
3081: l_api_name CONSTANT VARCHAR2(30) := 'delete_fee_type';
3082: l_api_version CONSTANT NUMBER := 1.0;
3083: l_fee_type okl_k_lines.fee_type%type := null;
3084: l_rebook_yn varchar2(5) := null;
3085:
3086: CURSOR get_fee_purpose_code_csr (p_line_id IN NUMBER) IS
3087: SELECT fee_purpose_code

Line 3088: FROM okl_k_lines

3084: l_rebook_yn varchar2(5) := null;
3085:
3086: CURSOR get_fee_purpose_code_csr (p_line_id IN NUMBER) IS
3087: SELECT fee_purpose_code
3088: FROM okl_k_lines
3089: WHERE ID = p_line_id;
3090: l_fee_purpose_code okl_k_lines.fee_purpose_code%type;
3091:
3092: CURSOR l_rebook_csr IS

Line 3090: l_fee_purpose_code okl_k_lines.fee_purpose_code%type;

3086: CURSOR get_fee_purpose_code_csr (p_line_id IN NUMBER) IS
3087: SELECT fee_purpose_code
3088: FROM okl_k_lines
3089: WHERE ID = p_line_id;
3090: l_fee_purpose_code okl_k_lines.fee_purpose_code%type;
3091:
3092: CURSOR l_rebook_csr IS
3093: select 'Y'
3094: from OKC_K_HEADERS_B chr

Line 3110: okl_k_lines kle

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;
3114:

Line 3122: okl_k_lines kle_fee,

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
3126: and cim.dnz_chr_id = cleb.dnz_chr_id

Line 4004: p_qte_id IN OKL_K_LINES.QTE_ID%TYPE,

4000: x_return_status OUT NOCOPY VARCHAR2,
4001: x_msg_count OUT NOCOPY NUMBER,
4002: x_msg_data OUT NOCOPY VARCHAR2,
4003: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
4004: p_qte_id IN OKL_K_LINES.QTE_ID%TYPE,
4005: p_for_qa_check IN BOOLEAN DEFAULT FALSE) IS
4006:
4007: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_ROLLOVER_FEELINE';
4008: l_api_version CONSTANT NUMBER := 1.0;

Line 4027: qteID OKL_K_LINES.QTE_ID%TYPE ) IS

4023:
4024: /* Cursor to get the contract number and quote number. */
4025:
4026: CURSOR l_con_qte_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4027: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4028: SELECT khr.contract_number, qte.quote_number
4029: FROM okc_k_headers_v khr,okl_trx_quotes_b qte
4030: WHERE khr.id = chrID
4031: AND qte.id = qteID;

Line 4036: qteID OKL_K_LINES.QTE_ID%TYPE ) IS

4032:
4033: /* Cursor to get the Fee Name. */
4034:
4035: CURSOR l_fee_name_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4036: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4037: SELECT cle.name
4038: FROM okc_k_headers_b khr,
4039: okl_k_lines kle,
4040: okc_k_lines_v cle,

Line 4039: okl_k_lines kle,

4035: CURSOR l_fee_name_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4036: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4037: SELECT cle.name
4038: FROM okc_k_headers_b khr,
4039: okl_k_lines kle,
4040: okc_k_lines_v cle,
4041: okl_trx_quotes_b qte
4042: WHERE cle.id = kle.id
4043: AND khr.id = chrID

Line 4052: qteID OKL_K_LINES.QTE_ID%TYPE ) IS

4048: /* Cursor to check if the Customer Account on the current Contract
4049: and the contract on the quote match, if not throw an error. */
4050:
4051: CURSOR l_cust_accnt_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4052: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4053: SELECT 1 FROM okc_k_headers_b
4054: WHERE id = chrID
4055: AND cust_acct_id = (SELECT khr.cust_acct_id FROM okc_k_headers_b khr,okl_trx_quotes_b qte
4056: WHERE khr.id = qte.khr_id

Line 4063: qteID OKL_K_LINES.QTE_ID%TYPE ) IS

4059: /* Cursor to check if the Currency Code on the current Contract
4060: and the contract on the quote match, if not throw an error. */
4061:
4062: CURSOR l_curr_code_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4063: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4064: SELECT 1 FROM okc_k_headers_b
4065: WHERE id = chrID
4066: AND currency_code = (SELECT khr.currency_code FROM okc_k_headers_b khr,okl_trx_quotes_b qte
4067: WHERE khr.id = qte.khr_id

Line 4072: CURSOR l_qts_code_csr ( qteID OKL_K_LINES.QTE_ID%TYPE ) IS

4068: AND qte.id = qteID);
4069:
4070: /* Cursor to check if the Quote status is Approved, if not throw an error. */
4071:
4072: CURSOR l_qts_code_csr ( qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4073: SELECT 1 FROM okl_trx_quotes_b
4074: WHERE id = qteID
4075: AND qst_code = 'APPROVED';
4076:

Line 4079: CURSOR l_con_yn_csr ( qteID OKL_K_LINES.QTE_ID%TYPE ) IS

4075: AND qst_code = 'APPROVED';
4076:
4077: /* Cursor to check if the Quote Consolidate flag is set to N, if not throw an error. */
4078:
4079: CURSOR l_con_yn_csr ( qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4080: SELECT 1 FROM okl_trx_quotes_b
4081: WHERE id = qteID
4082: AND consolidated_yn = 'N';
4083:

Line 4087: CURSOR l_qte_typ_csr ( qteID OKL_K_LINES.QTE_ID%TYPE ) IS

4083:
4084: /* Cursor to check if the Quote Type is either TER_ROLL_PURCHASE or
4085: TER_ROLL_WO_PURCHASE, if not throw an error. */
4086:
4087: CURSOR l_qte_typ_csr ( qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4088: SELECT 1 FROM okl_trx_quotes_b
4089: WHERE id = qteID
4090: AND qtp_code IN ('TER_ROLL_PURCHASE' , 'TER_ROLL_WO_PURCHASE');
4091:

Line 4096: qteID OKL_K_LINES.QTE_ID%TYPE ) IS

4092: /* Cursor to check if the Rollover Fee Start date is between Quote
4093: effective dates, if not throw an error. */
4094:
4095: CURSOR l_rq_fee_check_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
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,

Line 4099: okl_k_lines kle,

4095: CURSOR l_rq_fee_check_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
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

Line 4125: qteID OKL_K_LINES.QTE_ID%TYPE ) IS

4121: Rollover Fee line amount on the contract, if not throw an error. */
4122:
4123: -- AKJAIN fixed bug 4198968
4124: CURSOR l_rq_amt_check_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4125: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4126: (SELECT SUM(tql.amount)
4127: FROM okl_trx_quotes_b qte, okl_txl_quote_lines_b tql
4128: WHERE qte.id = qteID
4129: AND tql.qte_id= qte.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 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

4155: AND id = p_chr_id;
4156:
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

Line 4162: okl_k_lines kle

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;
4166:

Line 4582: okl_k_lines kle,

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
4586: and lse.id = cle.lse_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 4924: okl_k_lines kle

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'
4928: AND kle.id = cle.id;

Line 4939: FROM okl_k_lines

4935: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4936:
4937: SELECT NVL(amount, 0)
4938: INTO l_line_amount
4939: FROM okl_k_lines
4940: WHERE id = p_cle_id;
4941:
4942: -- Exclude Terminated sub-line amounts from
4943: -- total amount available for allocation

Line 4983: FROM okl_k_lines

4979: --Bug# 4631549
4980: If l_release_contract_yn = okl_api.g_true then
4981: SELECT NVL(expected_asset_cost, 0)
4982: INTO l_asset_oec
4983: FROM okl_k_lines
4984: WHERE id = l_link_asset_tbl(i).fin_asset_id;
4985: else
4986: SELECT NVL(oec, 0)
4987: INTO l_asset_oec

Line 4988: FROM okl_k_lines

4984: WHERE id = l_link_asset_tbl(i).fin_asset_id;
4985: else
4986: SELECT NVL(oec, 0)
4987: INTO l_asset_oec
4988: FROM okl_k_lines
4989: WHERE id = l_link_asset_tbl(i).fin_asset_id;
4990: end if;
4991:
4992: l_oec_total := l_oec_total + l_asset_oec;

Line 5020: FROM okl_k_lines

5016: --Bug# 4631549
5017: If l_release_contract_yn = okl_api.g_true then
5018: SELECT NVL(expected_asset_cost, 0)
5019: INTO l_asset_oec
5020: FROM okl_k_lines
5021: WHERE id = l_link_asset_tbl(i).fin_asset_id;
5022: Else
5023: SELECT NVL(oec, 0)
5024: INTO l_asset_oec

Line 5025: FROM okl_k_lines

5021: WHERE id = l_link_asset_tbl(i).fin_asset_id;
5022: Else
5023: SELECT NVL(oec, 0)
5024: INTO l_asset_oec
5025: FROM okl_k_lines
5026: WHERE id = l_link_asset_tbl(i).fin_asset_id;
5027: End If;
5028:
5029: IF l_link_asset_tbl.COUNT = 1 THEN

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 5454: okl_k_lines kle

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'
5458: AND cim.cle_id = cleb.id

Line 5483: l_fee_line_id okl_k_lines.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;
5484: l_amount okl_k_lines.amount%type;
5485:
5486: l_start_date DATE;
5487: l_end_date DATE;

Line 5484: l_amount okl_k_lines.amount%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;
5484: l_amount okl_k_lines.amount%type;
5485:
5486: l_start_date DATE;
5487: l_end_date DATE;
5488: