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

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

Line 2497: FROM okc_k_lines_b

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

Line 2815: FROM okc_k_lines_b

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

Line 3307: FROM okc_k_lines_b

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

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

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

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

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

Line 3407: DELETE FROM okc_k_lines_b

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

Line 3429: DELETE FROM okc_k_lines_b

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

Line 3468: DELETE FROM okc_k_lines_b

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

Line 3630: from okc_k_lines_b

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

Line 3661: FROM okc_k_lines_b

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

Line 3971: FROM okc_k_lines_b

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

Line 4047: FROM okc_k_lines_b

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

Line 4429: l_entity_name => 'OKC_K_LINES_B',

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

Line 4442: x_from_entity_name => 'OKC_K_LINES_B',

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

Line 4445: x_to_entity_name => 'OKC_K_LINES_B',

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

Line 4945: FROM okc_k_lines_b

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

Line 4952: okc_k_lines_b cle

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

Line 6062: FROM okc_k_lines_b cle,

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

Line 6069: FROM okc_k_lines_bh cle,

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

Line 10441: FROM okc_k_lines_b

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

Line 10462: FROM OKC_K_LINES_b

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

Line 11511: FROM okc_k_lines_b okcb, oks_k_lines_b oksb

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

Line 11807: FROM OKC_K_LINES_B

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

Line 11826: FROM OKC_K_LINES_B

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

Line 11892: FROM okc_k_lines_b cle, oks_k_lines_b kln

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

Line 11912: FROM okc_k_lines_b cle, oks_k_lines_b kln

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

Line 11973: FROM OKC_K_LINES_B

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

Line 11985: FROM okc_k_lines_b

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

Line 11987: FROM OKC_K_LINES_B b

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