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.OKS_AUTH_UTIL_PVT dependencies on OKS_K_LINES_B

Line 4912: FROM okc_k_lines_b cle, oks_k_lines_b sle

4908: --LLC
4909:
4910: CURSOR get_topline_tax_amt_csr (p_cle_id IN NUMBER) IS
4911: SELECT nvl(SUM(nvl(tax_amount, 0)), 0)
4912: FROM okc_k_lines_b cle, oks_k_lines_b sle
4913: WHERE cle.cle_id = p_cle_id
4914: AND cle.lse_id IN (7, 8, 9, 10, 11, 18, 25, 35)
4915: AND cle.id = sle.cle_id
4916: AND cle.dnz_chr_id = sle.dnz_chr_id

Line 4921: FROM okc_k_lines_b cle, oks_k_lines_b sle

4917: AND cle.date_cancelled IS NULL;
4918:
4919: CURSOR get_hdr_tax_amt_csr (p_chr_id IN NUMBER) IS
4920: SELECT nvl(SUM(nvl(tax_amount, 0)), 0)
4921: FROM okc_k_lines_b cle, oks_k_lines_b sle
4922: WHERE cle.dnz_chr_id = p_chr_id
4923: AND cle.lse_id IN (1, 12, 14, 19, 46)
4924: AND cle.cle_id IS NULL
4925: AND cle.id = sle.cle_id

Line 5039: oks_k_lines_b kln

5035: , cle.dnz_chr_id chr_id
5036: , kln.id kln_id
5037: , kln.object_version_number
5038: FROM okc_k_lines_b cle,
5039: oks_k_lines_b kln
5040: WHERE cle.cle_id = p_cle_id
5041: AND kln.cle_id = cle.id
5042: AND lse_id NOT IN (2, 15, 20, 46);
5043:

Line 5345: l_pm_prg_id oks_k_lines_b.pm_program_id%TYPE;

5341: AND date_cancelled IS NOT NULL; --Condition to consider only the cancelled sublines
5342:
5343: ---Added for bug 9481526 skuchima
5344:
5345: l_pm_prg_id oks_k_lines_b.pm_program_id%TYPE;
5346: l_pm_conf_req oks_k_lines_b.pm_conf_req_yn%TYPE;
5347: l_pm_sch_exists oks_k_lines_b.pm_sch_exists_yn%TYPE;
5348: l_pm_start_date DATE;
5349: l_pm_end_date DATE;

Line 5346: l_pm_conf_req oks_k_lines_b.pm_conf_req_yn%TYPE;

5342:
5343: ---Added for bug 9481526 skuchima
5344:
5345: l_pm_prg_id oks_k_lines_b.pm_program_id%TYPE;
5346: l_pm_conf_req oks_k_lines_b.pm_conf_req_yn%TYPE;
5347: l_pm_sch_exists oks_k_lines_b.pm_sch_exists_yn%TYPE;
5348: l_pm_start_date DATE;
5349: l_pm_end_date DATE;
5350:

Line 5347: l_pm_sch_exists oks_k_lines_b.pm_sch_exists_yn%TYPE;

5343: ---Added for bug 9481526 skuchima
5344:
5345: l_pm_prg_id oks_k_lines_b.pm_program_id%TYPE;
5346: l_pm_conf_req oks_k_lines_b.pm_conf_req_yn%TYPE;
5347: l_pm_sch_exists oks_k_lines_b.pm_sch_exists_yn%TYPE;
5348: l_pm_start_date DATE;
5349: l_pm_end_date DATE;
5350:
5351: --fetch the PM details of the new coverage

Line 5354: FROM oks_k_lines_b WHERE cle_id=p_covtemp_id;

5350:
5351: --fetch the PM details of the new coverage
5352: CURSOR fetch_pm_details(p_covtemp_id IN number) is
5353: SELECT pm_program_id,pm_conf_req_yn,pm_sch_exists_yn
5354: FROM oks_k_lines_b WHERE cle_id=p_covtemp_id;
5355:
5356: --fetch the line dates
5357: CURSOR fetch_line_date(p_cle_id IN number) is
5358: SELECT start_date,end_date

Line 5670: --update the pm details in oks_k_lines_b

5666: OPEN fetch_pm_details (l_covtemp_id);
5667: FETCH fetch_pm_details INTO l_pm_prg_id,l_pm_conf_req,l_pm_sch_exists;
5668: CLOSE fetch_pm_details;
5669:
5670: --update the pm details in oks_k_lines_b
5671: UPDATE oks_k_lines_b
5672: SET coverage_id = l_covtemp_id,
5673: standard_cov_yn = 'Y',
5674: pm_program_id =l_pm_prg_id ,

Line 5671: UPDATE oks_k_lines_b

5667: FETCH fetch_pm_details INTO l_pm_prg_id,l_pm_conf_req,l_pm_sch_exists;
5668: CLOSE fetch_pm_details;
5669:
5670: --update the pm details in oks_k_lines_b
5671: UPDATE oks_k_lines_b
5672: SET coverage_id = l_covtemp_id,
5673: standard_cov_yn = 'Y',
5674: pm_program_id =l_pm_prg_id ,
5675: pm_conf_req_yn =l_pm_conf_req ,

Line 6942: FROM okc_k_lines_b cle, oks_k_lines_b kln

6938: AND date_cancelled IS NULL; -- line Level Cancellation
6939:
6940: CURSOR toplinetax_cur(p_cle_id IN NUMBER) IS
6941: SELECT SUM(nvl(tax_amount, 0)) amount
6942: FROM okc_k_lines_b cle, oks_k_lines_b kln
6943: WHERE cle.cle_id = p_cle_id
6944: AND cle.id = kln.cle_id
6945: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25, 46)
6946: AND cle.date_cancelled IS NULL;

Line 6952: FROM oks_k_lines_b

6948: l_tax_amount toplinetax_cur%ROWTYPE;
6949:
6950: CURSOR Get_oks_Lines_details(p_cle_id IN NUMBER) IS
6951: SELECT id, object_version_number, dnz_chr_id
6952: FROM oks_k_lines_b
6953: WHERE cle_id = p_cle_id ;
6954:
6955: l_get_oks_details Get_oks_Lines_details%ROWTYPE;
6956:

Line 7092: FROM okc_k_lines_b cle, oks_k_lines_b kln

7088:
7089: -- Header Tax Total
7090: CURSOR hdrtax_cur IS
7091: SELECT SUM(kln.tax_amount) amount
7092: FROM okc_k_lines_b cle, oks_k_lines_b kln
7093: WHERE cle.dnz_chr_id = p_header_id
7094: AND cle.id = kln.cle_id
7095: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25, 46)
7096: AND cle.date_cancelled IS NULL;

Line 7251: FROM okc_k_lines_b okc, oks_k_lines_b oks

7247: okc.dnz_chr_id,
7248: currency_code,
7249: oks.id oks_id,
7250: oks.object_version_number
7251: FROM okc_k_lines_b okc, oks_k_lines_b oks
7252: WHERE okc.Cle_id = p_contract_line_id
7253: AND OKS.cle_id = okc.id
7254: AND (okc.date_terminated IS NULL OR okc.date_terminated > TRUNC(SYSDATE))
7255: AND lse_id NOT IN(2, 15, 20)

Line 7269: FROM okc_k_lines_b okc, oks_k_lines_b oks

7265: okc.dnz_chr_id,
7266: currency_code,
7267: oks.id oks_id,
7268: oks.object_version_number
7269: FROM okc_k_lines_b okc, oks_k_lines_b oks
7270: WHERE okc.Cle_id = p_contract_line_id
7271: AND OKS.cle_id = okc.id
7272: AND (okc.date_terminated IS NULL OR okc.date_terminated > TRUNC(SYSDATE))
7273: AND lse_id NOT IN(2, 15, 20)

Line 7282: FROM oks_k_lines_b

7278: /*Bug#13084968*/
7279:
7280: CURSOR get_tax_details(p_cle_id IN NUMBER) IS
7281: SELECT id, object_version_number
7282: FROM oks_k_lines_b
7283: WHERE cle_id = p_cle_id;
7284:
7285: get_tax_rec get_tax_details%rowtype;
7286: -- Bug 5228352 --

Line 8440: FROM OKS_k_LINES_B

8436:
8437: CURSOR get_lines_details (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
8438: SELECT locked_price_list_id,
8439: locked_price_list_line_id
8440: FROM OKS_k_LINES_B
8441: WHERE dnz_chr_id = p_chr_id
8442: AND cle_id = p_cle_id ;
8443:
8444: l_return_status VARCHAR2(2);

Line 8493: UPDATE OKS_K_LINES_B SET

8489: END IF;
8490: END IF;
8491: END IF;
8492:
8493: UPDATE OKS_K_LINES_B SET
8494: locked_price_list_id = NULL,
8495: locked_price_list_line_id = NULL
8496: WHERE dnz_chr_id = p_contract_hdr_id
8497: AND cle_id = cur_rec.id ;

Line 8614: oks_k_lines_b c, oks_k_lines_b d

8610: SUM(nvl(b.price_negotiated,0)) sum_subline_amt,
8611: nvl(c.tax_amount,0) topline_tax_amt,
8612: SUM(nvl(d.tax_amount,0)) sum_subline_tax_amt
8613: FROM okc_k_lines_b a, okc_k_lines_b b,
8614: oks_k_lines_b c, oks_k_lines_b d
8615: WHERE a.dnz_chr_id = cp_chr_id AND a.lse_id IN (1,12,14,19)
8616: AND b.dnz_chr_id = a.dnz_chr_id AND b.cle_id = a.id
8617: AND a.id=c.cle_id AND b.id=d.cle_id
8618: AND b.lse_id IN (7,8,9,10,11,35,13,18,25)

Line 8632: oks_k_lines_b c

8628: 0 sum_subline_amt,
8629: nvl(c.tax_amount,0) topline_tax_amt,
8630: 0 sum_subline_tax_amt
8631: FROM okc_k_lines_b a,
8632: oks_k_lines_b c
8633: WHERE a.dnz_chr_id = cp_chr_id
8634: AND a.lse_id IN (1,12,14,19)
8635: AND a.id=c.cle_id
8636: AND a.date_cancelled is null

Line 8661: oks_k_headers_b c, oks_k_lines_b d

8657: SUM(nvl(b.price_negotiated,0)) sum_tl_line_amt,
8658: nvl(c.tax_amount,0) hdr_tax_amt,
8659: SUM(nvl(d.tax_amount,0)) sum_tl_line_amt_tax
8660: FROM okc_k_headers_all_b a, okc_k_lines_b b,
8661: oks_k_headers_b c, oks_k_lines_b d
8662: WHERE a.id = cp_chr_id
8663: AND b.dnz_chr_id = a.id AND b.cle_id IS NULL
8664: AND d.dnz_chr_id = c.chr_id AND d.cle_id=b.id
8665: AND b.date_cancelled is null

Line 8798: UPDATE oks_k_lines_b

8794: SET price_negotiated = l_sl_amt_tbl(j)
8795: WHERE id = l_tl_id_tbl(j);
8796:
8797: FORALL j IN l_tl_id_tbl.first..l_tl_id_tbl.last
8798: UPDATE oks_k_lines_b
8799: SET tax_amount = l_sl_amt_tax_tbl(j)
8800: WHERE cle_id = l_tl_id_tbl(j);
8801:
8802: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 8880: UPDATE oks_k_lines_b

8876: SET price_negotiated = l_sl_amt_tbl(j)
8877: WHERE id = l_tl_id_tbl(j);
8878:
8879: FORALL j IN l_tl_id_tbl.first..l_tl_id_tbl.last
8880: UPDATE oks_k_lines_b
8881: SET tax_amount = l_sl_amt_tax_tbl(j)
8882: WHERE cle_id = l_tl_id_tbl(j);
8883:
8884: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 9533: FROM oks_k_lines_b

9529: WHERE chr_id = p_id;
9530:
9531: CURSOR l_oks_cle_csr(p_id NUMBER) IS
9532: SELECT ID, object_version_number
9533: FROM oks_k_lines_b
9534: WHERE cle_id = p_id;
9535: BEGIN
9536:
9537: IF p_type = g_okc_hdr THEN