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.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_LINES_B

Line 1531: FROM okc_k_lines_b

1527: l_new_rul_id NUMBER := OKC_API.G_MISS_NUM;
1528:
1529: CURSOR c_dnz_chr_id(p_id IN NUMBER) IS
1530: SELECT dnz_chr_id
1531: FROM okc_k_lines_b
1532: WHERE id = p_id;
1533:
1534: CURSOR c_atn(p_id IN NUMBER) IS
1535: SELECT id

Line 2496: FROM okc_k_lines_b

2492: l_cle_id NUMBER := OKC_API.G_MISS_NUM;
2493:
2494: CURSOR c_dnz_chr_id(p_id IN NUMBER) IS
2495: SELECT dnz_chr_id
2496: FROM okc_k_lines_b
2497: WHERE id = p_id;
2498:
2499: CURSOR c_ctcv IS
2500: SELECT id

Line 2814: FROM okc_k_lines_b

2810: l_result VARCHAR2(1):='?';
2811:
2812: CURSOR c_dnz_chr_id(p_id IN NUMBER) IS
2813: SELECT dnz_chr_id
2814: FROM okc_k_lines_b
2815: WHERE id = p_id;
2816: --->NO Union
2817:
2818: --Bug:3626930 cursor modified to check whether the rule

Line 3306: FROM okc_k_lines_b

3302: l_c NUMBER; -- Added for Bug 2387094/2292697
3303:
3304: CURSOR c_dnz_chr_id IS
3305: SELECT dnz_chr_id,price_level_ind
3306: FROM okc_k_lines_b
3307: WHERE id = p_to_cle_id;
3308:
3309: CURSOR c_cimv IS
3310: SELECT id

Line 3364: SELECT nvl(orig_system_id1,-001) into l_a FROM okc_k_lines_b

3360: x_return_status := l_return_status;
3361: RAISE G_EXCEPTION_HALT_VALIDATION;
3362: ELSE
3363: -- Getting the original line id from where this new line is copied
3364: SELECT nvl(orig_system_id1,-001) into l_a FROM okc_k_lines_b
3365: WHERE id = l_cimv_rec.cle_id;
3366:
3367: -- Getting the object1_id1 for original line id from where new line is copied
3368: SELECT nvl(object1_id1,-002) into l_b FROM okc_k_items

Line 3372: SELECT nvl(id,-003) into l_c FROM okc_k_lines_b

3368: SELECT nvl(object1_id1,-002) into l_b FROM okc_k_items
3369: WHERE cle_id = l_a;
3370:
3371: -- Getting the new line id
3372: SELECT nvl(id,-003) into l_c FROM okc_k_lines_b
3373: WHERE orig_system_id1 = l_b
3374: AND dnz_chr_id = l_cimv_rec.dnz_chr_id;
3375:
3376: IF l_c <> -003 THEN --if for l_c

Line 3406: DELETE FROM okc_k_lines_b

3402: OKC_API.set_message(G_APP_NAME,'OKC_ITEM_NOT_COPIED','ITEM_NAME',l_item_name);
3403:
3404: -- Begin Added for Bug 2207226
3405:
3406: DELETE FROM okc_k_lines_b
3407: WHERE id = l_cimv_rec.cle_id;
3408:
3409: DELETE FROM okc_k_lines_tl
3410: WHERE id = l_cimv_rec.cle_id;

Line 3428: DELETE FROM okc_k_lines_b

3424: OKC_API.set_message(G_APP_NAME,'OKC_ITEM_NOT_COPIED','ITEM_NAME',l_item_name);
3425:
3426: -- Begin Added for Bug 2207226
3427:
3428: DELETE FROM okc_k_lines_b
3429: WHERE id = l_cimv_rec.cle_id;
3430:
3431: DELETE FROM okc_k_lines_tl
3432: WHERE id = l_cimv_rec.cle_id;

Line 3467: DELETE FROM okc_k_lines_b

3463: OKC_API.set_message(G_APP_NAME,'OKC_ITEM_NOT_COPIED','ITEM_NAME',l_item_name);
3464:
3465: -- Begin Added for Bug 2207226
3466:
3467: DELETE FROM okc_k_lines_b
3468: WHERE id = l_cimv_rec.cle_id;
3469:
3470: DELETE FROM okc_k_lines_tl
3471: WHERE id = l_cimv_rec.cle_id;

Line 3629: from okc_k_lines_b

3625: -- LLC NEW CURSOR
3626:
3627: Cursor get_line_status_csr(p_from_cle_id in number) IS
3628: select sts_code, date_cancelled, trn_code, term_cancel_source, cancelled_amount
3629: from okc_k_lines_b
3630: where id= p_from_cle_id;
3631:
3632: -- Cursor created to get the PDF_ID for Class 'SERVICE' - Bug 1917514
3633: CURSOR c_pdf IS

Line 3660: FROM okc_k_lines_b

3656: -- Added for Bug 3764231
3657:
3658: CURSOR c_dnz_chr_id IS
3659: SELECT dnz_chr_id
3660: FROM okc_k_lines_b
3661: WHERE id = p_to_cle_id;
3662:
3663: CURSOR c_rgpv IS
3664: SELECT id

Line 3970: FROM okc_k_lines_b

3966: l_parent_end_date DATE;
3967:
3968: CURSOR c_cle IS
3969: SELECT start_date,end_date
3970: FROM okc_k_lines_b
3971: WHERE id = p_to_cle_id;
3972:
3973: CURSOR c_chr IS
3974: SELECT start_date,end_date

Line 4046: FROM okc_k_lines_b

4042: ----------------------------------------------------------------------------
4043: FUNCTION get_parent_id(p_cle_id IN NUMBER) RETURN NUMBER IS
4044: Cursor cle_csr Is
4045: SELECT nvl(chr_id , cle_id)
4046: FROM okc_k_lines_b
4047: WHERE id = p_cle_id;
4048: l_parent_id NUMBER := -1;
4049: BEGIN
4050: open cle_csr;

Line 4428: l_entity_name => 'OKC_K_LINES_B',

4424: -- before calling fnd_attachment_util_pkg.get_atchmt_exists
4425: Set_Attach_Session_Vars(x_clev_rec.dnz_chr_id);
4426:
4427: If (fnd_attachment_util_pkg.get_atchmt_exists (
4428: l_entity_name => 'OKC_K_LINES_B',
4429: l_pkey1 => p_from_cle_id,
4430: l_pkey2 => l_from_version) = 'Y')
4431:
4432: -- The following line to be added to the code once

Line 4441: x_from_entity_name => 'OKC_K_LINES_B',

4437: Then
4438: l_to_version := Get_Major_Version(x_clev_rec.dnz_chr_id);
4439:
4440: fnd_attached_documents2_pkg.copy_attachments(
4441: x_from_entity_name => 'OKC_K_LINES_B',
4442: x_from_pk1_value => p_from_cle_id,
4443: x_from_pk2_value => l_from_version,
4444: x_to_entity_name => 'OKC_K_LINES_B',
4445: x_to_pk1_value => x_clev_rec.id,

Line 4444: x_to_entity_name => 'OKC_K_LINES_B',

4440: fnd_attached_documents2_pkg.copy_attachments(
4441: x_from_entity_name => 'OKC_K_LINES_B',
4442: x_from_pk1_value => p_from_cle_id,
4443: x_from_pk2_value => l_from_version,
4444: x_to_entity_name => 'OKC_K_LINES_B',
4445: x_to_pk1_value => x_clev_rec.id,
4446: x_to_pk2_value => l_to_version
4447: );
4448: End if;

Line 4944: FROM okc_k_lines_b

4940: chr_id,
4941: cle_id,
4942: dnz_chr_id,
4943: lse_id
4944: FROM okc_k_lines_b
4945: CONNECT BY PRIOR id = cle_id
4946: START WITH id = p_from_cle_id;
4947:
4948: CURSOR c_application_id IS

Line 4951: okc_k_lines_b cle

4947:
4948: CURSOR c_application_id IS
4949: SELECT chr.application_id
4950: FROM okc_k_headers_b chr,
4951: okc_k_lines_b cle
4952: WHERE chr.id = cle.dnz_chr_id
4953: AND cle.id = p_from_cle_id;
4954: ----------------------------------------------------------------------------
4955: -- Function to find the new cle_id.

Line 6061: FROM okc_k_lines_b cle,

6057: AND okb.scs_code = osb.code ;
6058:
6059: CURSOR c_lines IS
6060: SELECT cle.id,lse.lty_code
6061: FROM okc_k_lines_b cle,
6062: okc_line_styles_b lse
6063: WHERE chr_id = p_chr_id
6064: AND cle.lse_id= lse.id
6065: AND g_copy_history_yn = 'N'

Line 6068: FROM okc_k_lines_bh cle,

6064: AND cle.lse_id= lse.id
6065: AND g_copy_history_yn = 'N'
6066: UNION ALL
6067: SELECT cle.id,lse.lty_code
6068: FROM okc_k_lines_bh cle,
6069: okc_line_styles_b lse
6070: WHERE chr_id = p_chr_id
6071: AND cle.lse_id= lse.id
6072: AND major_version = G_FROM_VERSION_NUMBER

Line 10440: FROM okc_k_lines_b

10436: --cursor to fetch id of line with lseid =20 -Bug:3668722
10437: CURSOR c_lines(p NUMBER) IS
10438: SELECT id,
10439: dnz_chr_id
10440: FROM okc_k_lines_b
10441: where lse_id=20
10442: CONNECT BY PRIOR id = cle_id
10443: START WITH id =p;
10444:

Line 10461: FROM OKC_K_LINES_b

10457: -- Cursor created to get the PDF_ID for Class 'SERVICE' - Bug 1917514
10458:
10459: CURSOR c_old_lse_id (p_id IN NUMBER) IS
10460: SELECT lse_id
10461: FROM OKC_K_LINES_b
10462: WHERE id = p_id;
10463:
10464: -- Added for Bug 3764231
10465: -- cursor to get the contract category

Line 11510: FROM okc_k_lines_b okcb, oks_k_lines_b oksb

11506: l_include_terminated_lines varchar2(1) := p_include_terminated_lines;
11507:
11508: CURSOR l_lines_csr(p_chr_id in number) IS
11509: SELECT COUNT(date_cancelled), COUNT(date_terminated)
11510: FROM okc_k_lines_b okcb, oks_k_lines_b oksb
11511: WHERE okcb.id = oksb.cle_id
11512: AND okcb.dnz_chr_id = p_chr_id;
11513: BEGIN
11514: -- hkamdar R12 Copy MOAC changes

Line 11806: FROM OKC_K_LINES_B

11802:
11803: -- Select all top lines and sublines
11804: CURSOR get_contract_lines_csr (p_chr_id IN NUMBER) IS
11805: SELECT id,start_date,end_date,lse_id
11806: FROM OKC_K_LINES_B
11807: WHERE lse_id in (1,7,8,9,10,11,12,13,14,19,18,25,35,46)
11808: CONNECT BY cle_id = PRIOR id
11809: START WITH CHR_ID = p_chr_id;
11810:

Line 11825: FROM OKC_K_LINES_B

11821: , start_date, end_date,lse_id,inv_rule_id
11822: --npalepu added new column on 18-may-2006 for bug # 5211482
11823: ,ORIG_SYSTEM_ID1
11824: --end npalepu
11825: FROM OKC_K_LINES_B
11826: WHERE dnz_chr_id = p_chr_id
11827: AND cle_id IS NULL;
11828:
11829:

Line 11891: FROM okc_k_lines_b cle, oks_k_lines_b kln

11887:
11888: --npalepu added on 27-FEB-2007 for bug # 5671352
11889: CURSOR toplinetax_cur(p_cle_id IN NUMBER) IS
11890: SELECT SUM(nvl(tax_amount, 0)) amount
11891: FROM okc_k_lines_b cle, oks_k_lines_b kln
11892: WHERE cle.cle_id = p_cle_id
11893: AND cle.id = kln.cle_id
11894: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25)
11895: AND cle.date_cancelled IS NULL;

Line 11911: FROM okc_k_lines_b cle, oks_k_lines_b kln

11907: l_klnv_tax_tbl_out oks_contract_line_pub.klnv_tbl_type;
11908:
11909: CURSOR hdrtax_cur IS
11910: SELECT SUM(kln.tax_amount) amount
11911: FROM okc_k_lines_b cle, oks_k_lines_b kln
11912: WHERE cle.dnz_chr_id = p_chr_id
11913: AND cle.id = kln.cle_id
11914: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25, 46)
11915: AND cle.date_cancelled IS NULL;

Line 11972: FROM OKC_K_LINES_B

11968: --npalepu modified on 5/12/2006 for bug # 5211447
11969: --changing because from R12 onwards the PM schedules will be directly
11970: --attached to the TOP line but not to the coverage line
11971: /* AND cle_id in ( SELECT id
11972: FROM OKC_K_LINES_B
11973: WHERE cle_id = p_cle_id); */
11974: AND cle_id = p_cle_id;
11975: --end npalepu
11976:

Line 11984: FROM okc_k_lines_b

11980: WHERE id= p_chr_id;
11981:
11982: CURSOR get_parent_line_enddate (p_cle_id IN NUMBER) IS
11983: SELECT end_date,inv_rule_id
11984: FROM okc_k_lines_b
11985: WHERE id IN (SELECT b.cle_id
11986: FROM OKC_K_LINES_B b
11987: WHERE b.id = p_cle_id);
11988:

Line 11986: FROM OKC_K_LINES_B b

11982: CURSOR get_parent_line_enddate (p_cle_id IN NUMBER) IS
11983: SELECT end_date,inv_rule_id
11984: FROM okc_k_lines_b
11985: WHERE id IN (SELECT b.cle_id
11986: FROM OKC_K_LINES_B b
11987: WHERE b.id = p_cle_id);
11988:
11989: -- Get the coverage line
11990: CURSOR line_cov_cur(p_cle_id IN Number) Is