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_RENEW_PVT dependencies on OKC_K_LINES_B

Line 19: TYPE IdTab is table of okc_k_lines_b.id%type;

15: --will save the extra overhead of remaking the tables that are made of same values again and again
16: g_cached_chr_id NUMBER := OKC_API.G_MISS_NUM;
17:
18:
19: TYPE IdTab is table of okc_k_lines_b.id%type;
20: g_parent_id_tbl idTab;--used to cache in values of parents of a given line from renconsol
21: TYPE CLE_DATES_REC_TYPE IS RECORD(
22: ID NUMBER:=OKC_API.G_MISS_NUM,
23: orig_start_date DATE:=OKC_API.G_MISS_DATE,

Line 55: from okc_k_lines_b

51: and rul.rule_information_category='LRT' order by rgp.cle_id;
52:
53: cursor cur_line(p_chr_id number) is
54: select id comp_id,nvl(line_renewal_type_code,g_def_cle_ren) rule_type
55: from okc_k_lines_b
56: where dnz_chr_id = p_chr_id;
57:
58: cursor cur_headers(p_chr_id number) is
59: select application_id from okc_k_headers_b where id = p_chr_id;

Line 756: FROM okc_k_lines_b l, okc_statuses_b sts

752: FUNCTION VALIDATE_LINE(p_contract_id IN NUMBER) RETURN VARCHAR2
753: IS
754: CURSOR cur_k_lines is
755: SELECT ID
756: FROM okc_k_lines_b l, okc_statuses_b sts
757: WHERE sts.code = l.sts_code
758: and sts.ste_code in ('ACTIVE','EXPIRED','SIGNED')
759: and l.dnz_chr_id = p_contract_id
760: and l.date_renewed is null

Line 1403: FROM okc_k_lines_b a,okc_k_lines_b b

1399: WHERE id = p_chr_id;
1400:
1401: CURSOR cur_lines(p_chr_id number) is
1402: SELECT a.id,b.id cle_id_ren_to ,a.object_version_number
1403: FROM okc_k_lines_b a,okc_k_lines_b b
1404: WHERE a.dnz_chr_id = p_chr_id and a.id=b.cle_id_renewed and b.dnz_chr_id=p_new_header;
1405:
1406: TYPE objTab is table of okc_k_lines_b.object_version_number%type;
1407:

Line 1406: TYPE objTab is table of okc_k_lines_b.object_version_number%type;

1402: SELECT a.id,b.id cle_id_ren_to ,a.object_version_number
1403: FROM okc_k_lines_b a,okc_k_lines_b b
1404: WHERE a.dnz_chr_id = p_chr_id and a.id=b.cle_id_renewed and b.dnz_chr_id=p_new_header;
1405:
1406: TYPE objTab is table of okc_k_lines_b.object_version_number%type;
1407:
1408: l_id_tbl idTab;
1409: l_obj_tbl objtab;
1410: l_ren_id_tbl idTab;

Line 1497: FROM okc_k_lines_b l, okc_operation_lines a

1493:
1494: --san rencol
1495: SELECT l.id,l.object_version_number
1496: bulk collect into l_id_tbl,l_obj_tbl
1497: FROM okc_k_lines_b l, okc_operation_lines a
1498: where a.object_chr_id=p_chr_id and
1499: a.subject_chr_id=p_new_header and
1500: a.active_yn='Y'
1501: and l.id=a.object_cle_id and

Line 1647: FROM okc_k_lines_b

1643: where id = p_chr_id;
1644:
1645: CURSOR cur_lines(p_id number) is
1646: SELECT id,object_version_number,start_date,end_date,level,cle_id
1647: FROM okc_k_lines_b
1648: where dnz_chr_id=p_id
1649: start with (chr_id=p_id)
1650: connect by prior id=cle_id;
1651:

Line 1656: FROM okc_k_lines_b

1652: -- Modiifed for Bug 2084147
1653: -- Added new field price_negotiated in the SELECT
1654: Cursor l_rencon_n_cur(l_chr_id number) is
1655: SELECT id,object_version_number,start_date,END_date,level,cle_id,price_negotiated
1656: FROM okc_k_lines_b
1657: where dnz_chr_id=l_chr_id
1658: start with (chr_id=l_chr_id)
1659: connect by prior id=cle_id;
1660:

Line 1665: FROM okc_k_lines_b

1661: -- Modiifed for Bug 2084147
1662: -- Added new field price_negotiated in the SELECT
1663: Cursor l_rencon_y_cur(l_chr_id number,l_cle_id number) is
1664: SELECT id,object_version_number,start_date,END_date,level,cle_id,price_negotiated
1665: FROM okc_k_lines_b
1666: where dnz_chr_id=l_chr_id
1667: start with (id=l_cle_id)
1668: connect by prior id=cle_id;
1669:

Line 1967: FROM okc_k_lines_b

1963: -- renew_rule not defined for this line, we will have to get it from its parent
1964: -- so collect a tree of its parents
1965: SELECT id
1966: bulk collect into g_parent_id_tbl
1967: FROM okc_k_lines_b
1968: where dnz_chr_id=p_chr_id
1969: start with (id=p_parent_cle_id)
1970: connect by prior cle_id=id;
1971:

Line 2115: FROM okc_k_lines_b

2111: --Added decode for Bug 2911298
2112: SELECT TO_DATE(TO_CHAR(l_cle_rec.start_date, 'dd/mm/yyYY') || TO_CHAR(start_date, 'hh24:mi:ss'), 'dd/mm/yyYYhh24:mi:ss'),
2113: decode(l_cle_rec.end_date, null, null, TO_DATE(TO_CHAR(l_cle_rec.end_date, 'dd/mm/yyYY') || TO_CHAR(end_date, 'hh24:mi:ss'), 'dd/mm/yyYYhh24:mi:ss'))
2114: INTO l_cle_rec.start_date, l_cle_rec.end_date
2115: FROM okc_k_lines_b
2116: WHERE id = (SELECT object_cle_id FROM okc_operation_lines WHERE subject_cle_id = l_cle_rec.id);
2117:
2118: okc_contract_pub.update_contract_line (
2119: p_api_version => 1,

Line 3533: from okc_k_lines_b line, okc_ancestrys ans

3529: CLE_ID_ASCENDANT,
3530: LEVEL_SEQUENCE)
3531: select line.dnz_chr_id, ans.cle_id,
3532: ans.cle_id_ascendant, ans.level_sequence
3533: from okc_k_lines_b line, okc_ancestrys ans
3534: where line.id = ans.cle_id
3535: and line.dnz_chr_id = p_chr_id;
3536:
3537: -- To check whether any sublines are present

Line 3539: from okc_k_lines_b line, okc_ancestrys ans

3535: and line.dnz_chr_id = p_chr_id;
3536:
3537: -- To check whether any sublines are present
3538: select count(*) into l_top_count
3539: from okc_k_lines_b line, okc_ancestrys ans
3540: where line.id = ans.cle_id
3541: and line.dnz_chr_id = p_chr_id;
3542: -- If sublines are present
3543: If l_top_count > 0 Then

Line 3558: from okc_k_lines_b

3554: fetch ancestry_cle_id into l_cle_id_ascendant;
3555: exit when ancestry_cle_id%NOTFOUND;
3556: -- To check whether any sublines are present for this line
3557: select count(*) into l_line_count
3558: from okc_k_lines_b
3559: where cle_id = l_cle_id_ascendant;
3560:
3561: If l_line_count > 0 Then
3562: -- To check the Date_Renewed field for all sublines

Line 3564: from okc_k_lines_b

3560:
3561: If l_line_count > 0 Then
3562: -- To check the Date_Renewed field for all sublines
3563: select count(*) into l_date_count
3564: from okc_k_lines_b
3565: where cle_id = l_cle_id_ascendant
3566: and date_renewed IS NULL;
3567: -- If Date_Renewed is not null for all the sublines
3568: If l_date_count = 0 Then

Line 3570: update okc_k_lines_b

3566: and date_renewed IS NULL;
3567: -- If Date_Renewed is not null for all the sublines
3568: If l_date_count = 0 Then
3569: -- Update Date_Renewed field of parent line
3570: update okc_k_lines_b
3571: set date_renewed = ( select MAX(date_renewed )
3572: from okc_k_lines_b
3573: where cle_id = l_cle_id_ascendant )
3574: where id = l_cle_id_ascendant;

Line 3572: from okc_k_lines_b

3568: If l_date_count = 0 Then
3569: -- Update Date_Renewed field of parent line
3570: update okc_k_lines_b
3571: set date_renewed = ( select MAX(date_renewed )
3572: from okc_k_lines_b
3573: where cle_id = l_cle_id_ascendant )
3574: where id = l_cle_id_ascendant;
3575: End If;
3576: End If;

Line 3586: from okc_k_lines_b

3582: End If;
3583:
3584: -- To check whether the header has any top line
3585: select count(*) into l_no_lines_count
3586: from okc_k_lines_b
3587: where chr_id = p_chr_id;
3588: -- If header has a top line
3589: If l_no_lines_count > 0 Then
3590: -- To check the Date_Renewed field for all top lines

Line 3592: from okc_k_lines_b

3588: -- If header has a top line
3589: If l_no_lines_count > 0 Then
3590: -- To check the Date_Renewed field for all top lines
3591: select count(*) into l_top_date_count
3592: from okc_k_lines_b
3593: where chr_id = p_chr_id
3594: and date_renewed IS NULL;
3595:
3596: -- If Date_Renewed is not null for all the top lines

Line 3601: from okc_k_lines_b

3597: If l_top_date_count = 0 Then
3598: -- Update Date_Renewed field of contract header
3599: update okc_k_headers_b
3600: set date_renewed = ( select MAX(date_renewed)
3601: from okc_k_lines_b
3602: where chr_id = p_chr_id )
3603: where id = p_chr_id;
3604: End If;
3605: End If;