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_MASSCHANGE_PVT dependencies on OKC_K_LINES_V

Line 440: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl

436: -- Old Value: NULL (-9999)
437: IF p_ctr_rec.old_value = '-9999' THEN
438: l_stmt := l_select||' ,NULL old_value'||
439: l_from||l_where||
440: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl
441: WHERE okl.dnz_chr_id = okh.id
442: AND oksl.cle_id = okl.id
443: AND oksl.coverage_type is NULL )
444: AND okh.id = to_number(:update_level_value)' ;

Line 453: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

449:
450: l_old_value := p_ctr_rec.old_value;
451: l_stmt := l_select||' , :l_old_value old_value'||
452: l_from||
453: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
454: WHERE okl.dnz_chr_id = okh.id
455: AND oksl.cle_id = okl.id )
456: AND okh.id = to_number(:update_level_value)' ;
457: ELSE

Line 461: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

457: ELSE
458: l_old_value := p_ctr_rec.old_value;
459: l_stmt := l_select||' , :l_old_value old_value'||
460: l_from||
461: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
462: WHERE okl.dnz_chr_id = okh.id
463: AND oksl.cle_id = okl.id
464: AND oksl.coverage_type = :p_ctr_rec_old_value )
465: AND okh.id = to_number(:update_level_value)' ;

Line 588: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

584: -- Old Value: NULL (-9999)
585: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
586: l_stmt := l_select||' ,NULL old_value'||
587: l_from||l_where||
588: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
589: WHERE cle.dnz_chr_id = okh.id
590: AND cle.lse_id IN (7,8,9,10,11,18,25,35)
591: AND cle.cognomen is NULL)
592: AND okh.id = to_number(:update_level_value)';

Line 599: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

595: ELSIF p_ctr_rec.old_value = '-1111' THEN
596:
597: l_stmt := l_select||' ,NULL old_value'||
598: l_from||l_where||
599: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
600: WHERE cle.dnz_chr_id = okh.id
601: AND cle.lse_id IN (7,8,9,10,11,18,25,35))
602: AND okh.id = to_number(:update_level_value)';
603:

Line 611: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

607: --nerrorout_n('Here**********');
608: l_old_value := p_ctr_rec.old_value;
609: l_stmt := l_select||' , :l_old_value old_value'||
610: l_from||l_where||
611: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
612: WHERE cle.dnz_chr_id = okh.id
613: AND cle.lse_id IN (7,8,9,10,11,18,25,35)
614: AND cle.cognomen = :p_ctr_rec_old_value)
615: AND okh.id = to_number(:update_level_value)';

Line 629: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

625: -- Old Value: NULL (-9999)
626: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
627: l_stmt := l_select||' ,NULL old_value'||
628: l_from||l_where||
629: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
630: WHERE cle.chr_id = okh.id
631: AND cle.lse_id IN (1,12,14,19)
632: AND cle.cognomen is NULL)
633: AND okh.id = to_number(:update_level_value)';

Line 640: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

636:
637: ELSIF p_ctr_rec.old_value = '-1111' THEN
638: l_stmt := l_select||' ,NULL old_value'||
639: l_from||l_where||
640: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
641: WHERE cle.chr_id = okh.id
642: AND cle.lse_id IN (1,12,14,19))
643: AND okh.id = to_number(:update_level_value)';
644:

Line 652: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

648:
649: l_old_value := p_ctr_rec.old_value;
650: l_stmt := l_select||' , :l_old_value old_value'||
651: l_from||l_where||
652: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
653: WHERE cle.chr_id = okh.id
654: AND cle.lse_id IN (1,12,14,19)
655: AND cle.cognomen = :p_ctr_rec_old_value)
656: AND okh.id = to_number(:update_level_value)';

Line 1580: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl

1576: -- Old Value: NULL (-9999)
1577: IF p_ctr_rec.old_value = '-9999' THEN
1578: l_stmt := l_select||' ,NULL old_value'||
1579: l_from||l_where||
1580: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl
1581: WHERE okl.dnz_chr_id = okh.id
1582: AND oksl.cle_id = okl.id
1583: AND oksl.coverage_type is NULL )
1584: AND okh.org_id = to_number(:update_level_value)';

Line 1593: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

1589:
1590: l_old_value := p_ctr_rec.old_value;
1591: l_stmt := l_select||' , :l_old_value old_value'||
1592: l_from||
1593: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
1594: WHERE okl.dnz_chr_id = okh.id
1595: AND oksl.cle_id = okl.id )
1596: AND okh.org_id = to_number(:update_level_value)';
1597: -- Old Value: Other than NULL or ALL

Line 1602: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

1598: ELSE
1599: l_old_value := p_ctr_rec.old_value;
1600: l_stmt := l_select||' , :l_old_value old_value'||
1601: l_from||
1602: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
1603: WHERE okl.dnz_chr_id = okh.id
1604: AND oksl.cle_id = okl.id
1605: AND oksl.coverage_type = :p_ctr_rec_old_value )
1606: AND okh.org_id = to_number(:update_level_value)';

Line 1738: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

1734: -- Old Value: NULL (-9999)
1735: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
1736: l_stmt := l_select||' ,NULL old_value'||
1737: l_from||l_where||
1738: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
1739: WHERE cle.dnz_chr_id = okh.id
1740: AND cle.lse_id IN (7,8,9,10,11,18,25,35)
1741: AND cle.cognomen is NULL)
1742: AND okh.org_id = to_number(:update_level_value)';

Line 1750: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

1746: ELSIF p_ctr_rec.old_value = '-1111' THEN
1747:
1748: l_stmt := l_select||' ,NULL old_value'||
1749: l_from||l_where||
1750: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
1751: WHERE cle.dnz_chr_id = okh.id
1752: AND cle.lse_id IN (7,8,9,10,11,18,25,35))
1753: AND okh.org_id = to_number(:update_level_value)';
1754:

Line 1762: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

1758:
1759: l_old_value := p_ctr_rec.old_value;
1760: l_stmt := l_select||' , :l_old_value old_value'||
1761: l_from||l_where||
1762: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
1763: WHERE cle.dnz_chr_id = okh.id
1764: AND cle.lse_id IN (7,8,9,10,11,18,25,35)
1765: AND cle.cognomen = :p_ctr_rec_old_value)
1766: AND okh.org_id = to_number(:update_level_value)';

Line 1779: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

1775: -- Old Value: NULL (-9999)
1776: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
1777: l_stmt := l_select||' ,NULL old_value'||
1778: l_from||l_where||
1779: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
1780: WHERE cle.chr_id = okh.id
1781: AND cle.lse_id IN (1,12,14,19)
1782: AND cle.cognomen is NULL)
1783: AND okh.org_id = to_number(:update_level_value)';

Line 1790: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

1786:
1787: ELSIF p_ctr_rec.old_value = '-1111' THEN
1788: l_stmt := l_select||' ,NULL old_value'||
1789: l_from||l_where||
1790: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
1791: WHERE cle.chr_id = okh.id
1792: AND cle.lse_id IN (1,12,14,19))
1793: AND okh.org_id = to_number(:update_level_value)';
1794:

Line 1802: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

1798:
1799: l_old_value := p_ctr_rec.old_value;
1800: l_stmt := l_select||' , :l_old_value old_value'||
1801: l_from||l_where||
1802: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
1803: WHERE cle.chr_id = okh.id
1804: AND cle.lse_id IN (1,12,14,19)
1805: AND cle.cognomen = :p_ctr_rec_old_value)
1806: AND okh.org_id = to_number(:update_level_value)';

Line 2715: l_where||' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl

2711: -- Old Value: NULL (-9999)
2712: IF p_ctr_rec.old_value = '-9999' THEN
2713: l_stmt := l_select||' ,NULL old_value'||
2714: l_from||',okc_k_party_roles_v okp1'||
2715: l_where||' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl
2716: WHERE okl.dnz_chr_id = okh.id
2717: AND oksl.cle_id = okl.id
2718: AND oksl.coverage_type is NULL )
2719: AND okh.id = okp1.chr_id

Line 2730: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

2726:
2727: l_old_value := p_ctr_rec.old_value;
2728: l_stmt := l_select||' , :l_old_value old_value'||
2729: l_from||',okc_k_party_roles_v okp1'||
2730: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
2731: WHERE okl.dnz_chr_id = okh.id
2732: AND oksl.cle_id = okl.id )
2733: AND okh.id = okp1.chr_id
2734: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 2742: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

2738: ELSE
2739: l_old_value := p_ctr_rec.old_value;
2740: l_stmt := l_select||' , :l_old_value old_value'||
2741: l_from||',okc_k_party_roles_v okp1'||
2742: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
2743: WHERE okl.dnz_chr_id = okh.id
2744: AND oksl.cle_id = okl.id
2745: AND oksl.coverage_type = :p_ctr_rec_old_value )
2746: AND okh.id = okp1.chr_id

Line 2896: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

2892:
2893: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
2894: l_stmt := l_select||' ,NULL old_value'||
2895: l_from||' ,okc_k_party_roles_b okp1 '||l_where||
2896: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
2897: WHERE cle.dnz_chr_id = okh.id
2898: AND cle.lse_id in (7,8,9,10,11,18,25,35)
2899: AND cle.cognomen is NULL)
2900: AND okh.id = okp1.chr_id

Line 2908: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

2904: ELSIF p_ctr_rec.old_value = '-1111' THEN
2905:
2906: l_stmt := l_select||' ,NULL old_value'||
2907: l_from||' ,okc_k_party_roles_b okp1 '||l_where||
2908: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
2909: WHERE cle.dnz_chr_id = okh.id
2910: AND cle.lse_id in (7,8,9,10,11,18,25,35))
2911: AND okh.id = okp1.chr_id
2912: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 2920: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

2916: -- dbms_output.put_line('Inside else');
2917: l_old_value := p_ctr_rec.old_value;
2918: l_stmt := l_select||' , :l_old_value old_value'||
2919: l_from||' ,okc_k_party_roles_b okp1 '||l_where||
2920: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
2921: WHERE cle.dnz_chr_id = okh.id
2922: AND cle.lse_id in (7,8,9,10,11,18,25,35)
2923: AND cle.cognomen = :p_ctr_rec_old_value)
2924: AND okh.id = okp1.chr_id

Line 2938: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

2934:
2935: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
2936: l_stmt := l_select||' ,NULL old_value'||
2937: l_from||' ,okc_k_party_roles_b okp1 '||l_where||
2938: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
2939: WHERE cle.chr_id = okh.id
2940: AND cle.lse_id in (1,12,14,19)
2941: AND cle.cognomen is NULL)
2942: AND okh.id = okp1.chr_id

Line 2950: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

2946: ELSIF p_ctr_rec.old_value = '-1111' THEN
2947:
2948: l_stmt := l_select||' ,NULL old_value'||
2949: l_from||' ,okc_k_party_roles_b okp1 '||l_where||
2950: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
2951: WHERE cle.chr_id = okh.id
2952: AND cle.lse_id in (1,12,14,19))
2953: AND okh.id = okp1.chr_id
2954: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 2962: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

2958: -- dbms_output.put_line('Inside else');
2959: l_old_value := p_ctr_rec.old_value;
2960: l_stmt := l_select||' , :l_old_value old_value'||
2961: l_from||' ,okc_k_party_roles_b okp1 '||l_where||
2962: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
2963: WHERE cle.chr_id = okh.id
2964: AND cle.lse_id in (1,12,14,19)
2965: AND cle.cognomen = :p_ctr_rec_old_value)
2966: AND okh.id = okp1.chr_id

Line 4022: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl

4018: -- Old Value: NULL (-9999)
4019: IF p_ctr_rec.old_value = '-9999' THEN
4020: l_stmt := l_select||' ,NULL old_value'||
4021: l_from||l_where||
4022: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl
4023: WHERE okl.dnz_chr_id = okh.id
4024: AND oksl.cle_id = okl.id
4025: AND oksl.coverage_type is NULL )
4026: AND okh.scs_code = :update_level_value';

Line 4035: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

4031:
4032: l_old_value := p_ctr_rec.old_value;
4033: l_stmt := l_select||' , :l_old_value old_value'||
4034: l_from||
4035: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
4036: WHERE okl.dnz_chr_id = okh.id
4037: AND oksl.cle_id = okl.id )
4038: AND okh.scs_code = :update_level_value';
4039: -- Old Value: Other than NULL or ALL

Line 4044: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

4040: ELSE
4041: l_old_value := p_ctr_rec.old_value;
4042: l_stmt := l_select||' , :l_old_value old_value'||
4043: l_from||
4044: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
4045: WHERE okl.dnz_chr_id = okh.id
4046: AND oksl.cle_id = okl.id
4047: AND oksl.coverage_type = :p_ctr_rec_old_value )
4048: AND okh.scs_code = :update_level_value';

Line 4169: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

4165:
4166: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4167: l_stmt := l_select||' ,NULL old_value'||
4168: l_from||l_where||
4169: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
4170: WHERE cle.dnz_chr_id = okh.id
4171: AND cle.lse_id IN (7,8,9,10,11,18,25,35)
4172: AND cle.cognomen is NULL)
4173: AND okh.scs_code = :update_level_value';

Line 4178: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

4174: ELSIF p_ctr_rec.old_value = '-1111' THEN
4175:
4176: l_stmt := l_select||' ,NULL old_value'||
4177: l_from||l_where||
4178: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
4179: WHERE cle.dnz_chr_id = okh.id
4180: AND cle.lse_id IN (7,8,9,10,11,18,25,35))
4181: AND okh.scs_code = :update_level_value';
4182:

Line 4187: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

4183: ELSE
4184: l_old_value := p_ctr_rec.old_value;
4185: l_stmt := l_select||' , :l_old_value old_value'||
4186: l_from||l_where||
4187: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
4188: WHERE cle.dnz_chr_id = okh.id
4189: AND cle.lse_id IN (7,8,9,10,11,18,25,35)
4190: AND cle.cognomen = :p_ctr_rec_old_value)
4191: AND okh.scs_code = :update_level_value';

Line 4203: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

4199:
4200: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4201: l_stmt := l_select||' ,NULL old_value'||
4202: l_from||l_where||
4203: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
4204: WHERE cle.chr_id = okh.id
4205: AND cle.lse_id IN (1,12,14,19)
4206: AND cle.cognomen is NULL)
4207: AND okh.scs_code = :update_level_value';

Line 4213: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

4209: ELSIF p_ctr_rec.old_value = '-1111' THEN
4210:
4211: l_stmt := l_select||' ,NULL old_value'||
4212: l_from||l_where||
4213: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
4214: WHERE cle.chr_id = okh.id
4215: AND cle.lse_id IN (1,12,14,19))
4216: AND okh.scs_code = :update_level_value';
4217: ELSE

Line 4221: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

4217: ELSE
4218: l_old_value := p_ctr_rec.old_value;
4219: l_stmt := l_select||' , :l_old_value old_value'||
4220: l_from||l_where||
4221: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
4222: WHERE cle.chr_id = okh.id
4223: AND cle.lse_id IN (1,12,14,19)
4224: AND cle.cognomen = :p_ctr_rec_old_value)
4225: AND okh.scs_code = :update_level_value';

Line 5194: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl

5190:
5191: IF p_ctr_rec.old_value = '-9999' THEN
5192: l_stmt := l_select||' ,NULL old_value'||
5193: l_from||l_where||
5194: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl
5195: WHERE okl.dnz_chr_id = okh.id
5196: AND oksl.cle_id = okl.id
5197: AND oksl.coverage_type is NULL )
5198: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1

Line 5210: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

5206:
5207: l_old_value := p_ctr_rec.old_value;
5208: l_stmt := l_select||' , :l_old_value old_value'||
5209: l_from||
5210: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
5211: WHERE okl.dnz_chr_id = okh.id
5212: AND oksl.cle_id = okl.id )
5213: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1
5214: WHERE okg1.included_chr_id is not null

Line 5223: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

5219: ELSE
5220: l_old_value := p_ctr_rec.old_value;
5221: l_stmt := l_select||' , :l_old_value old_value'||
5222: l_from||
5223: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
5224: WHERE okl.dnz_chr_id = okh.id
5225: AND oksl.cle_id = okl.id
5226: AND oksl.coverage_type = :p_ctr_rec_old_value )
5227: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1

Line 5380: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

5376:
5377: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5378: l_stmt := l_select||' ,NULL old_value'||
5379: l_from||l_where||
5380: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
5381: WHERE cle.dnz_chr_id = okh.id
5382: AND cle.lse_id IN (7,8,9,10,11,18,25,35)
5383: AND cle.cognomen is NULL)
5384: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1

Line 5392: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

5388:
5389: ELSIF p_ctr_rec.old_value = '-1111' THEN
5390: l_stmt := l_select||' ,NULL old_value'||
5391: l_from||l_where||
5392: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
5393: WHERE cle.dnz_chr_id = okh.id
5394: AND cle.lse_id IN (7,8,9,10,11,18,25,35))
5395: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1
5396: WHERE okg1.included_chr_id is not null

Line 5405: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

5401: -- dbms_output.put_line('Inside else');
5402: l_old_value := p_ctr_rec.old_value;
5403: l_stmt := l_select||' , :l_old_value old_value'||
5404: l_from||l_where||
5405: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
5406: WHERE cle.dnz_chr_id = okh.id
5407: AND cle.lse_id IN (7,8,9,10,11,18,25,35)
5408: AND cle.cognomen = :p_ctr_rec_old_value)
5409: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1

Line 5423: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

5419:
5420: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5421: l_stmt := l_select||' ,NULL old_value'||
5422: l_from||l_where||
5423: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
5424: WHERE cle.chr_id = okh.id
5425: AND cle.lse_id IN (1,12,14,19)
5426: AND cle.cognomen is NULL)
5427: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1

Line 5435: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

5431:
5432: ELSIF p_ctr_rec.old_value = '-1111' THEN
5433: l_stmt := l_select||' ,NULL old_value'||
5434: l_from||l_where||
5435: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
5436: WHERE cle.chr_id = okh.id
5437: AND cle.lse_id IN (1,12,14,19))
5438: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1
5439: WHERE okg1.included_chr_id is not null

Line 5447: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle

5443: -- dbms_output.put_line('Inside else');
5444: l_old_value := p_ctr_rec.old_value;
5445: l_stmt := l_select||' , :l_old_value old_value'||
5446: l_from||l_where||
5447: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V cle
5448: WHERE cle.chr_id = okh.id
5449: AND cle.lse_id IN (1,12,14,19)
5450: AND cle.cognomen = :p_ctr_rec_old_value)
5451: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1

Line 7077: FROM OKC_K_LINES_V okl, oks_action_times oat , oks_action_time_types att

7073: CURSOR Get_act_time ( p_chr_id IN NUMBER , p_action_type_code VARCHAR2
7074: , p_old_value IN Varchar2) IS
7075: SELECT oat.id id ,oat.sun_duration ,oat.mon_duration ,oat.tue_duration ,oat.wed_duration,
7076: oat.thu_duration ,oat.fri_duration, oat.sat_duration, oat.object_version_number
7077: FROM OKC_K_LINES_V okl, oks_action_times oat , oks_action_time_types att
7078: WHERE okl.dnz_chr_id = p_chr_id
7079: AND att.cle_id = okl.id
7080: AND att.action_type_code = p_action_type_code
7081: AND oat.cov_action_type_id = att.id

Line 7092: FROM okc_k_lines_v okl, oks_k_lines_v osl

7088: OR oat.sat_duration = p_old_value ) ;
7089:
7090: CURSOR Get_cov_type ( p_chr_id IN NUMBER , p_old_value IN Varchar2) IS
7091: SELECT osl.id , osl.object_version_number
7092: FROM okc_k_lines_v okl, oks_k_lines_v osl
7093: WHERE okl.id = osl.cle_id
7094: AND okl.dnz_chr_id = p_chr_id
7095: AND okl.lse_id in( 2,15,20)
7096: AND osl.coverage_type = p_old_value ;

Line 7340: l_stmt:= 'SELECT cle.id,object_version_number,lse_id FROM okc_k_lines_v cle

7336: ** Modified the sql by adding date_cancelled condition
7337: ** to take care of Line Level Cancelation project
7338: */
7339:
7340: l_stmt:= 'SELECT cle.id,object_version_number,lse_id FROM okc_k_lines_v cle
7341: WHERE cle.date_cancelled is NULL
7342: AND cle.dnz_chr_id = :p_chr_id';
7343:
7344: IF p_attr = 'CONTRACT_START_DATE' then