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_CONTACTS

Line 516: okc_contacts oco

512: l_old_value := p_ctr_rec.old_value;
513: l_stmt := l_select||' , :l_old_value old_value'||
514: l_from||
515: l_where||'AND EXISTS (SELECT ''x'' from
516: okc_contacts oco
517: WHERE oco.dnz_chr_id = okh.id
518: AND oco.cro_code = ''ENGINEER''
519: AND oco.jtot_object1_code = ''OKX_RESOURCE'')
520: AND okh.id = to_number(:update_level_value)';

Line 527: okc_contacts oco

523: l_old_value := p_ctr_rec.old_value;
524: l_stmt := l_select||' , :l_old_value old_value'||
525: l_from||
526: l_where||'AND EXISTS (SELECT ''x'' from
527: okc_contacts oco
528: WHERE oco.dnz_chr_id = okh.id
529: AND oco.cro_code = ''ENGINEER''
530: AND oco.jtot_object1_code = ''OKX_RESOURCE''
531: AND oco.object1_id1 = :p_ctr_rec_old_value)

Line 546: okc_contacts oco

542: l_old_value := p_ctr_rec.old_value;
543: l_stmt := l_select||' , :l_old_value old_value'||
544: l_from||
545: l_where||'AND EXISTS (SELECT ''x'' from
546: okc_contacts oco
547: WHERE oco.dnz_chr_id = okh.id
548: AND oco.cro_code = ''RSC_GROUP''
549: AND oco.jtot_object1_code = ''OKS_RSCGROUP'')
550: AND okh.id = to_number(:update_level_value)';

Line 557: okc_contacts oco

553: l_old_value := p_ctr_rec.old_value;
554: l_stmt := l_select||' , :l_old_value old_value'||
555: l_from||
556: l_where||'AND EXISTS (SELECT ''x'' from
557: okc_contacts oco
558: WHERE oco.dnz_chr_id = okh.id
559: AND oco.cro_code = ''RSC_GROUP''
560: AND oco.jtot_object1_code = ''OKS_RSCGROUP''
561: AND oco.object1_id1 = :p_ctr_rec_old_value)

Line 711: ' AND (EXISTS (Select ''x'' from okc_contacts oc

707: -- Old Value: NULL (-9999)
708: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
709: l_stmt := l_select||' ,NULL old_value'||
710: l_from||l_where||
711: ' AND (EXISTS (Select ''x'' from okc_contacts oc
712: where oc.dnz_chr_id = okh.id
713: and oc.cro_code = ''SALESPERSON''
714: and oc.object1_id1 is null
715: and oc.jtot_object1_code = ''OKX_SALEPERS'')

Line 726: l_from||', okc_contacts oc '||

722:
723: ELSIF p_ctr_rec.old_value = '-1111' THEN
724:
725: l_stmt := l_select||' ,oc.object1_id1 old_value '||
726: l_from||', okc_contacts oc '||
727: l_where||' and oc.dnz_chr_id = okh.id
728: and oc.cro_code = ''SALESPERSON''
729: and oc.jtot_object1_code = ''OKX_SALEPERS''
730: AND okh.id = to_number(:update_level_value)';

Line 738: ' AND (EXISTS (Select ''x'' from okc_contacts oc

734: ELSE
735: l_old_value := p_ctr_rec.old_value;
736: l_stmt := l_select||' , :l_old_value old_value'||
737: l_from||l_where||
738: ' AND (EXISTS (Select ''x'' from okc_contacts oc
739: where oc.dnz_chr_id = okh.id
740: and oc.cro_code = ''SALESPERSON''
741: and oc.object1_id1=:p_ctr_rec_old_value
742: and oc.jtot_object1_code = ''OKX_SALEPERS'')

Line 759: ' AND EXISTS (Select ''x'' from okc_contacts oc

755: -- Old Value: NULL (-9999)
756: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
757: l_stmt := l_select||' ,NULL old_value'||
758: l_from||l_where||
759: ' AND EXISTS (Select ''x'' from okc_contacts oc
760: where oc.dnz_chr_id = okh.id
761: and oc.cro_code = ''SHIPPING''
762: and oc.object1_id1 is null
763: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 770: l_from||', okc_contacts oc '||

766: -- Old Value: ALL (-1111)
767:
768: ELSIF p_ctr_rec.old_value = '-1111' THEN
769: l_stmt := l_select||' ,oc.object1_id1 old_value'||
770: l_from||', okc_contacts oc '||
771: l_where||
772: ' and oc.dnz_chr_id = okh.id
773: and oc.cro_code = ''SHIPPING''
774: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 784: ' AND EXISTS (Select ''x'' from okc_contacts oc

780:
781: l_old_value := p_ctr_rec.old_value;
782: l_stmt := l_select||' , :l_old_value old_value'||
783: l_from||l_where||
784: ' AND EXISTS (Select ''x'' from okc_contacts oc
785: where oc.dnz_chr_id = okh.id
786: and oc.cro_code = ''SHIPPING''
787: and oc.object1_id1=:p_ctr_rec_old_value
788: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 802: ' AND EXISTS (Select ''x'' from okc_contacts oc

798: -- Old Value: NULL (-9999)
799: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
800: l_stmt := l_select||' ,NULL old_value'||
801: l_from||l_where||
802: ' AND EXISTS (Select ''x'' from okc_contacts oc
803: where oc.dnz_chr_id = okh.id
804: and oc.cro_code = ''BILLING''
805: and oc.object1_id1 is null
806: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 813: l_from||', okc_contacts oc '||

809: -- Old Value: ALL (-1111)
810:
811: ELSIF p_ctr_rec.old_value = '-1111' THEN
812: l_stmt := l_select||' ,oc.object1_id1 old_value'||
813: l_from||', okc_contacts oc '||
814: l_where||
815: ' and oc.dnz_chr_id = okh.id
816: and oc.cro_code = ''BILLING''
817: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 827: ' AND EXISTS (Select ''x'' from okc_contacts oc

823:
824: l_old_value := p_ctr_rec.old_value;
825: l_stmt := l_select||' , :l_old_value old_value'||
826: l_from||l_where||
827: ' AND EXISTS (Select ''x'' from okc_contacts oc
828: where oc.dnz_chr_id = okh.id
829: and oc.cro_code = ''BILLING''
830: and oc.object1_id1=:p_ctr_rec_old_value
831: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 844: ' AND EXISTS (Select ''x'' from okc_contacts oc

840: -- Old Value: NULL (-9999)
841: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
842: l_stmt := l_select||' ,NULL old_value'||
843: l_from||l_where||
844: ' AND EXISTS (Select ''x'' from okc_contacts oc
845: where oc.dnz_chr_id = okh.id
846: and oc.cro_code = ''CUST_SHIPPING''
847: and oc.object1_id1 is null
848: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 855: l_from||', okc_contacts oc '||

851: -- Old Value: ALL (-1111)
852:
853: ELSIF p_ctr_rec.old_value = '-1111' THEN
854: l_stmt := l_select||' ,oc.object1_id1 old_value'||
855: l_from||', okc_contacts oc '||
856: l_where||
857: ' and oc.dnz_chr_id = okh.id
858: and oc.cro_code = ''CUST_SHIPPING''
859: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 869: ' AND EXISTS (Select ''x'' from okc_contacts oc

865:
866: l_old_value := p_ctr_rec.old_value;
867: l_stmt := l_select||' , :l_old_value old_value'||
868: l_from||l_where||
869: ' AND EXISTS (Select ''x'' from okc_contacts oc
870: where oc.dnz_chr_id = okh.id
871: and oc.cro_code = ''CUST_SHIPPING''
872: and oc.object1_id1=:p_ctr_rec_old_value
873: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 887: ' AND EXISTS (Select ''x'' from okc_contacts oc

883: -- Old Value: NULL (-9999)
884: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
885: l_stmt := l_select||' ,NULL old_value'||
886: l_from||l_where||
887: ' AND EXISTS (Select ''x'' from okc_contacts oc
888: where oc.dnz_chr_id = okh.id
889: and oc.cro_code = ''CUST_BILLING''
890: and oc.object1_id1 is null
891: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 898: l_from||', okc_contacts oc '||

894: -- Old Value: ALL (-1111)
895:
896: ELSIF p_ctr_rec.old_value = '-1111' THEN
897: l_stmt := l_select||' ,oc.object1_id1 old_value'||
898: l_from||', okc_contacts oc '||
899: l_where||
900: ' and oc.dnz_chr_id = okh.id
901: and oc.cro_code = ''CUST_BILLING''
902: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 912: ' AND EXISTS (Select ''x'' from okc_contacts oc

908:
909: l_old_value := p_ctr_rec.old_value;
910: l_stmt := l_select||' , :l_old_value old_value'||
911: l_from||l_where||
912: ' AND EXISTS (Select ''x'' from okc_contacts oc
913: where oc.dnz_chr_id = okh.id
914: and oc.cro_code = ''CUST_BILLING''
915: and oc.object1_id1 = :p_ctr_rec_old_value
916: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 1660: okc_contacts oco

1656: l_old_value := p_ctr_rec.old_value;
1657: l_stmt := l_select||' , :l_old_value old_value'||
1658: l_from||
1659: l_where||'AND EXISTS (SELECT ''x'' from
1660: okc_contacts oco
1661: WHERE oco.dnz_chr_id = okh.id
1662: AND oco.cro_code = ''ENGINEER''
1663: AND oco.jtot_object1_code = ''OKX_RESOURCE'')
1664: AND okh.org_id = to_number(:update_level_value)';

Line 1673: okc_contacts oco

1669: l_old_value := p_ctr_rec.old_value;
1670: l_stmt := l_select||' , :l_old_value old_value'||
1671: l_from||
1672: l_where||'AND EXISTS (SELECT ''x'' from
1673: okc_contacts oco
1674: WHERE oco.dnz_chr_id = okh.id
1675: AND oco.cro_code = ''ENGINEER''
1676: AND oco.jtot_object1_code = ''OKX_RESOURCE''
1677: AND oco.object1_id1 = :p_ctr_rec_old_value)

Line 1692: okc_contacts oco

1688: l_old_value := p_ctr_rec.old_value;
1689: l_stmt := l_select||' , :l_old_value old_value'||
1690: l_from||
1691: l_where||'AND EXISTS (SELECT ''x'' from
1692: okc_contacts oco
1693: WHERE oco.dnz_chr_id = okh.id
1694: AND oco.cro_code = ''RSC_GROUP''
1695: AND oco.jtot_object1_code = ''OKS_RSCGROUP'')
1696: AND okh.org_id = to_number(:update_level_value)';

Line 1705: okc_contacts oco

1701: l_old_value := p_ctr_rec.old_value;
1702: l_stmt := l_select||' , :l_old_value old_value'||
1703: l_from||
1704: l_where||'AND EXISTS (SELECT ''x'' from
1705: okc_contacts oco
1706: WHERE oco.dnz_chr_id = okh.id
1707: AND oco.cro_code = ''RSC_GROUP''
1708: AND oco.jtot_object1_code = ''OKS_RSCGROUP''
1709: AND oco.object1_id1 = :p_ctr_rec_old_value)

Line 1859: ' AND EXISTS (Select ''x'' from okc_contacts oc

1855:
1856: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
1857: l_stmt := l_select||' ,NULL old_value'||
1858: l_from||l_where||
1859: ' AND EXISTS (Select ''x'' from okc_contacts oc
1860: where oc.dnz_chr_id = okh.id
1861: and oc.cro_code = ''SALESPERSON''
1862: and oc.object1_id1 is null
1863: and oc.jtot_object1_code = ''OKX_SALEPERS'')

Line 1869: l_from||', okc_contacts oc '||

1865:
1866: ELSIF p_ctr_rec.old_value = '-1111' THEN
1867:
1868: l_stmt := l_select||' ,oc.object1_id1 old_value '||
1869: l_from||', okc_contacts oc '||
1870: l_where||' and oc.dnz_chr_id = okh.id
1871: and oc.cro_code = ''SALESPERSON''
1872: and oc.jtot_object1_code = ''OKX_SALEPERS''
1873: AND okh.org_id = to_number(:update_level_value)';

Line 1879: ' AND (EXISTS (Select ''x'' from okc_contacts oc

1875:
1876: l_old_value := p_ctr_rec.old_value;
1877: l_stmt := l_select||' , :l_old_value old_value'||
1878: l_from||l_where||
1879: ' AND (EXISTS (Select ''x'' from okc_contacts oc
1880: where oc.dnz_chr_id = okh.id
1881: and oc.cro_code = ''SALESPERSON''
1882: and oc.object1_id1= :p_ctr_rec_old_value
1883: and oc.jtot_object1_code = ''OKX_SALEPERS'')

Line 1899: ' AND EXISTS (Select ''x'' from okc_contacts oc

1895:
1896: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
1897: l_stmt := l_select||' ,NULL old_value'||
1898: l_from||l_where||
1899: ' AND EXISTS (Select ''x'' from okc_contacts oc
1900: where oc.dnz_chr_id = okh.id
1901: and oc.cro_code = ''SHIPPING''
1902: and oc.object1_id1 is null
1903: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 1908: l_from||', okc_contacts oc '||

1904: AND okh.org_id = to_number(:update_level_value)';
1905:
1906: ELSIF p_ctr_rec.old_value = '-1111' THEN
1907: l_stmt := l_select||' ,oc.object1_id1 old_value'||
1908: l_from||', okc_contacts oc '||
1909: l_where||
1910: ' and oc.dnz_chr_id = okh.id
1911: and oc.cro_code = ''SHIPPING''
1912: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 1920: ' AND EXISTS (Select ''x'' from okc_contacts oc

1916:
1917: l_old_value := p_ctr_rec.old_value;
1918: l_stmt := l_select||' , :l_old_value old_value'||
1919: l_from||l_where||
1920: ' AND EXISTS (Select ''x'' from okc_contacts oc
1921: where oc.dnz_chr_id = okh.id
1922: and oc.cro_code = ''SHIPPING''
1923: and oc.object1_id1= :p_ctr_rec_old_value
1924: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 1937: ' AND EXISTS (Select ''x'' from okc_contacts oc

1933:
1934: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
1935: l_stmt := l_select||' ,NULL old_value'||
1936: l_from||l_where||
1937: ' AND EXISTS (Select ''x'' from okc_contacts oc
1938: where oc.dnz_chr_id = okh.id
1939: and oc.cro_code = ''BILLING''
1940: and oc.object1_id1 is null
1941: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 1946: l_from||', okc_contacts oc '||

1942: AND okh.org_id = to_number(:update_level_value)';
1943:
1944: ELSIF p_ctr_rec.old_value = '-1111' THEN
1945: l_stmt := l_select||' ,oc.object1_id1 old_value'||
1946: l_from||', okc_contacts oc '||
1947: l_where||
1948: ' and oc.dnz_chr_id = okh.id
1949: and oc.cro_code = ''BILLING''
1950: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 1958: ' AND EXISTS (Select ''x'' from okc_contacts oc

1954: -- dbms_output.put_line('Inside billing else');
1955: l_old_value := p_ctr_rec.old_value;
1956: l_stmt := l_select||' , :l_old_value old_value'||
1957: l_from||l_where||
1958: ' AND EXISTS (Select ''x'' from okc_contacts oc
1959: where oc.dnz_chr_id = okh.id
1960: and oc.cro_code = ''BILLING''
1961: and oc.object1_id1= :p_ctr_rec_old_value
1962: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 1975: ' AND EXISTS (Select ''x'' from okc_contacts oc

1971:
1972: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
1973: l_stmt := l_select||' ,NULL old_value'||
1974: l_from||l_where||
1975: ' AND EXISTS (Select ''x'' from okc_contacts oc
1976: where oc.dnz_chr_id = okh.id
1977: and oc.cro_code = ''CUST_SHIPPING''
1978: and oc.object1_id1 is null
1979: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 1984: l_from||', okc_contacts oc '||

1980: AND okh.org_id = to_number(:update_level_value)';
1981:
1982: ELSIF p_ctr_rec.old_value = '-1111' THEN
1983: l_stmt := l_select||' ,oc.object1_id1 old_value'||
1984: l_from||', okc_contacts oc '||
1985: l_where||
1986: ' and oc.dnz_chr_id = okh.id
1987: and oc.cro_code = ''CUST_SHIPPING''
1988: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 1996: ' AND EXISTS (Select ''x'' from okc_contacts oc

1992: -- dbms_output.put_line('Inside else');
1993: l_old_value := p_ctr_rec.old_value;
1994: l_stmt := l_select||' , :l_old_value old_value'||
1995: l_from||l_where||
1996: ' AND EXISTS (Select ''x'' from okc_contacts oc
1997: where oc.dnz_chr_id = okh.id
1998: and oc.cro_code = ''CUST_SHIPPING''
1999: and oc.object1_id1= :p_ctr_rec_old_value
2000: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 2013: ' AND EXISTS (Select ''x'' from okc_contacts oc

2009:
2010: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
2011: l_stmt := l_select||' ,NULL old_value'||
2012: l_from||l_where||
2013: ' AND EXISTS (Select ''x'' from okc_contacts oc
2014: where oc.dnz_chr_id = okh.id
2015: and oc.cro_code = ''CUST_BILLING''
2016: and oc.object1_id1 is null
2017: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 2022: l_from||', okc_contacts oc '||

2018: AND okh.org_id = to_number(:update_level_value)';
2019:
2020: ELSIF p_ctr_rec.old_value = '-1111' THEN
2021: l_stmt := l_select||' ,oc.object1_id1 old_value'||
2022: l_from||', okc_contacts oc '||
2023: l_where||
2024: ' and oc.dnz_chr_id = okh.id
2025: and oc.cro_code = ''CUST_BILLING''
2026: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 2034: ' AND EXISTS (Select ''x'' from okc_contacts oc

2030: -- dbms_output.put_line('Inside billing else');
2031: l_old_value := p_ctr_rec.old_value;
2032: l_stmt := l_select||' , :l_old_value old_value'||
2033: l_from||l_where||
2034: ' AND EXISTS (Select ''x'' from okc_contacts oc
2035: where oc.dnz_chr_id = okh.id
2036: and oc.cro_code = ''CUST_BILLING''
2037: and oc.object1_id1= :p_ctr_rec_old_value
2038: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 2807: okc_contacts oco

2803: l_old_value := p_ctr_rec.old_value;
2804: l_stmt := l_select||' , :l_old_value old_value'||
2805: l_from||',okc_k_party_roles_v okp1'||
2806: l_where||'AND EXISTS (SELECT ''x'' from
2807: okc_contacts oco
2808: WHERE oco.dnz_chr_id = okh.id
2809: AND oco.cro_code = ''ENGINEER''
2810: AND oco.jtot_object1_code = ''OKX_RESOURCE'')
2811: AND okh.id = okp1.chr_id

Line 2823: okc_contacts oco

2819: l_old_value := p_ctr_rec.old_value;
2820: l_stmt := l_select||' , :l_old_value old_value'||
2821: l_from||',okc_k_party_roles_v okp1'||
2822: l_where||'AND EXISTS (SELECT ''x'' from
2823: okc_contacts oco
2824: WHERE oco.dnz_chr_id = okh.id
2825: AND oco.cro_code = ''ENGINEER''
2826: AND oco.jtot_object1_code = ''OKX_RESOURCE''
2827: AND oco.object1_id1 = :p_ctr_rec_old_value)

Line 2845: okc_contacts oco

2841: l_old_value := p_ctr_rec.old_value;
2842: l_stmt := l_select||' , :l_old_value old_value'||
2843: l_from||',okc_k_party_roles_v okp1'||
2844: l_where||'AND EXISTS (SELECT ''x'' from
2845: okc_contacts oco
2846: WHERE oco.dnz_chr_id = okh.id
2847: AND oco.cro_code = ''RSC_GROUP''
2848: AND oco.jtot_object1_code = ''OKS_RSCGROUP'')
2849: AND okh.id = okp1.chr_id

Line 2861: okc_contacts oco

2857: l_old_value := p_ctr_rec.old_value;
2858: l_stmt := l_select||' , :l_old_value old_value'||
2859: l_from||',okc_k_party_roles_v okp1'||
2860: l_where||'AND EXISTS (SELECT ''x'' from
2861: okc_contacts oco
2862: WHERE oco.dnz_chr_id = okh.id
2863: AND oco.cro_code = ''RSC_GROUP''
2864: AND oco.jtot_object1_code = ''OKS_RSCGROUP''
2865: AND oco.object1_id1 = :p_ctr_rec_old_value)

Line 3034: ' AND EXISTS (Select ''x'' from okc_contacts oc

3030:
3031: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3032: l_stmt := l_select||' ,NULL old_value'||
3033: l_from||',okc_k_party_roles_b okp1 '||l_where||
3034: ' AND EXISTS (Select ''x'' from okc_contacts oc
3035: where oc.dnz_chr_id = okh.id
3036: and oc.cro_code = ''SALESPERSON''
3037: and oc.object1_id1 is null
3038: and oc.jtot_object1_code = ''OKX_SALEPERS'')

Line 3045: l_from||',okc_k_party_roles_b okp1, okc_contacts oc '||

3041: AND okp1.object1_id1 = :update_level_value';
3042:
3043: ELSIF p_ctr_rec.old_value = '-1111' THEN
3044: l_stmt := l_select||' ,oc.object1_id1 old_value'||
3045: l_from||',okc_k_party_roles_b okp1, okc_contacts oc '||
3046: l_where||
3047: ' and oc.dnz_chr_id = okh.id
3048: and oc.cro_code = ''SALESPERSON''
3049: and oc.jtot_object1_code = ''OKX_SALEPERS'')

Line 3058: ' AND (EXISTS (Select ''x'' from okc_contacts oc

3054: ELSE
3055: l_old_value := p_ctr_rec.old_value;
3056: l_stmt := l_select||' , :l_old_value old_value'||
3057: l_from||',okc_k_party_roles_b okp1 '||l_where||
3058: ' AND (EXISTS (Select ''x'' from okc_contacts oc
3059: where oc.dnz_chr_id = okh.id
3060: and oc.cro_code = ''SALESPERSON''
3061: and oc.object1_id1= :p_ctr_rec_old_value
3062: and oc.jtot_object1_code = ''OKX_SALEPERS'')

Line 3078: ' AND EXISTS (Select ''x'' from okc_contacts oc

3074:
3075: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3076: l_stmt := l_select||' ,NULL old_value'||
3077: l_from||',okc_k_party_roles_b okp1 '||l_where||
3078: ' AND EXISTS (Select ''x'' from okc_contacts oc
3079: where oc.dnz_chr_id = okh.id
3080: and oc.cro_code = ''SHIPPING''
3081: and oc.object1_id1 is null
3082: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 3089: l_from||',okc_k_party_roles_b okp1, okc_contacts oc '||

3085: AND okp1.object1_id1 = :update_level_value';
3086:
3087: ELSIF p_ctr_rec.old_value = '-1111' THEN
3088: l_stmt := l_select||' ,oc.object1_id1 old_value'||
3089: l_from||',okc_k_party_roles_b okp1, okc_contacts oc '||
3090: l_where||
3091: ' and oc.dnz_chr_id = okh.id
3092: and oc.cro_code = ''SHIPPING''
3093: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 3103: ' AND EXISTS (Select ''x'' from okc_contacts oc

3099: -- dbms_output.put_line('Inside billing else');
3100: l_old_value := p_ctr_rec.old_value;
3101: l_stmt := l_select||' , :l_old_value old_value'||
3102: l_from||',okc_k_party_roles_b okp1 '||l_where||
3103: ' AND EXISTS (Select ''x'' from okc_contacts oc
3104: where oc.dnz_chr_id = okh.id
3105: and oc.cro_code = ''SHIPPING''
3106: and oc.object1_id1= :p_ctr_rec_old_value
3107: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 3121: ' AND EXISTS (Select ''x'' from okc_contacts oc

3117:
3118: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3119: l_stmt := l_select||' ,NULL old_value'||
3120: l_from||',okc_k_party_roles_b okp1 '||l_where||
3121: ' AND EXISTS (Select ''x'' from okc_contacts oc
3122: where oc.dnz_chr_id = okh.id
3123: and oc.cro_code = ''BILLING''
3124: and oc.object1_id1 is null
3125: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 3132: l_from||',okc_k_party_roles_b okp1, okc_contacts oc '||

3128: AND okp1.object1_id1 = :update_level_value';
3129:
3130: ELSIF p_ctr_rec.old_value = '-1111' THEN
3131: l_stmt := l_select||' ,oc.object1_id1 old_value'||
3132: l_from||',okc_k_party_roles_b okp1, okc_contacts oc '||
3133: l_where||
3134: ' and oc.dnz_chr_id = okh.id
3135: and oc.cro_code = ''BILLING''
3136: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 3146: ' AND EXISTS (Select ''x'' from okc_contacts oc

3142: -- dbms_output.put_line('Inside billing else');
3143: l_old_value := p_ctr_rec.old_value;
3144: l_stmt := l_select||' , :l_old_value old_value'||
3145: l_from||',okc_k_party_roles_b okp1 '||l_where||
3146: ' AND EXISTS (Select ''x'' from okc_contacts oc
3147: where oc.dnz_chr_id = okh.id
3148: and oc.cro_code = ''BILLING''
3149: and oc.object1_id1= :p_ctr_rec_old_value
3150: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 3165: ' AND EXISTS (Select ''x'' from okc_contacts oc

3161:
3162: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3163: l_stmt := l_select||' ,NULL old_value'||
3164: l_from||',okc_k_party_roles_b okp1 '||l_where||
3165: ' AND EXISTS (Select ''x'' from okc_contacts oc
3166: where oc.dnz_chr_id = okh.id
3167: and oc.cro_code = ''CUST_SHIPPING''
3168: and oc.object1_id1 is null
3169: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 3176: l_from||',okc_k_party_roles_b okp1, okc_contacts oc '||

3172: AND okp1.object1_id1 = :update_level_value';
3173:
3174: ELSIF p_ctr_rec.old_value = '-1111' THEN
3175: l_stmt := l_select||' ,oc.object1_id1 old_value'||
3176: l_from||',okc_k_party_roles_b okp1, okc_contacts oc '||
3177: l_where||
3178: ' and oc.dnz_chr_id = okh.id
3179: and oc.cro_code = ''CUST_SHIPPING''
3180: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 3190: ' AND EXISTS (Select ''x'' from okc_contacts oc

3186: -- dbms_output.put_line('Inside billing else');
3187: l_old_value := p_ctr_rec.old_value;
3188: l_stmt := l_select||' , :l_old_value old_value'||
3189: l_from||',okc_k_party_roles_b okp1 '||l_where||
3190: ' AND EXISTS (Select ''x'' from okc_contacts oc
3191: where oc.dnz_chr_id = okh.id
3192: and oc.cro_code = ''CUST_SHIPPING''
3193: and oc.object1_id1= :p_ctr_rec_old_value
3194: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 3208: ' AND EXISTS (Select ''x'' from okc_contacts oc

3204:
3205: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3206: l_stmt := l_select||' ,NULL old_value'||
3207: l_from||',okc_k_party_roles_b okp1 '||l_where||
3208: ' AND EXISTS (Select ''x'' from okc_contacts oc
3209: where oc.dnz_chr_id = okh.id
3210: and oc.cro_code = ''CUST_BILLING''
3211: and oc.object1_id1 is null
3212: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 3219: l_from||',okc_k_party_roles_b okp1, okc_contacts oc '||

3215: AND okp1.object1_id1 = :update_level_value';
3216:
3217: ELSIF p_ctr_rec.old_value = '-1111' THEN
3218: l_stmt := l_select||' ,oc.object1_id1 old_value'||
3219: l_from||',okc_k_party_roles_b okp1, okc_contacts oc '||
3220: l_where||
3221: ' and oc.dnz_chr_id = okh.id
3222: and oc.cro_code = ''CUST_BILLING''
3223: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 3233: ' AND EXISTS (Select ''x'' from okc_contacts oc

3229: -- dbms_output.put_line('Inside billing else');
3230: l_old_value := p_ctr_rec.old_value;
3231: l_stmt := l_select||' , :l_old_value old_value'||
3232: l_from||',okc_k_party_roles_b okp1 '||l_where||
3233: ' AND EXISTS (Select ''x'' from okc_contacts oc
3234: where oc.dnz_chr_id = okh.id
3235: and oc.cro_code = ''CUST_BILLING''
3236: and oc.object1_id1= :p_ctr_rec_old_value
3237: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 4099: okc_contacts oco

4095: l_old_value := p_ctr_rec.old_value;
4096: l_stmt := l_select||' , :l_old_value old_value'||
4097: l_from||
4098: l_where||'AND EXISTS (SELECT ''x'' from
4099: okc_contacts oco
4100: WHERE oco.dnz_chr_id = okh.id
4101: AND oco.cro_code = ''ENGINEER''
4102: AND oco.jtot_object1_code = ''OKX_RESOURCE'')
4103: AND okh.scs_code = :update_level_value';

Line 4110: okc_contacts oco

4106: l_old_value := p_ctr_rec.old_value;
4107: l_stmt := l_select||' , :l_old_value old_value'||
4108: l_from||
4109: l_where||'AND EXISTS (SELECT ''x'' from
4110: okc_contacts oco
4111: WHERE oco.dnz_chr_id = okh.id
4112: AND oco.cro_code = ''ENGINEER''
4113: AND oco.jtot_object1_code = ''OKX_RESOURCE''
4114: AND oco.object1_id1 = :p_ctr_rec_old_value)

Line 4128: okc_contacts oco

4124: l_old_value := p_ctr_rec.old_value;
4125: l_stmt := l_select||' , :l_old_value old_value'||
4126: l_from||
4127: l_where||'AND EXISTS (SELECT ''x'' from
4128: okc_contacts oco
4129: WHERE oco.dnz_chr_id = okh.id
4130: AND oco.cro_code = ''RSC_GROUP''
4131: AND oco.jtot_object1_code = ''OKS_RSCGROUP'')
4132: AND okh.scs_code = :update_level_value';

Line 4139: okc_contacts oco

4135: l_old_value := p_ctr_rec.old_value;
4136: l_stmt := l_select||' , :l_old_value old_value'||
4137: l_from||
4138: l_where||'AND EXISTS (SELECT ''x'' from
4139: okc_contacts oco
4140: WHERE oco.dnz_chr_id = okh.id
4141: AND oco.cro_code = ''RSC_GROUP''
4142: AND oco.jtot_object1_code = ''OKS_RSCGROUP''
4143: AND oco.object1_id1 = :p_ctr_rec_old_value)

Line 4279: ' AND EXISTS (Select ''x'' from okc_contacts oc

4275:
4276: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4277: l_stmt := l_select||' ,NULL old_value'||
4278: l_from||l_where||
4279: ' AND EXISTS (Select ''x'' from okc_contacts oc
4280: where oc.dnz_chr_id = okh.id
4281: and oc.cro_code = ''SALESPERSON''
4282: and oc.object1_id1 is null
4283: and oc.jtot_object1_code = ''OKX_SALEPERS'')

Line 4288: l_from||', okc_contacts oc '||

4284: AND okh.scs_code = :update_level_value';
4285: ELSIF p_ctr_rec.old_value = '-1111' THEN
4286: -- dbms_output.put_line('Inside else ALL SALES_REP');
4287: l_stmt := l_select||' ,oc.object1_id1 old_value '||
4288: l_from||', okc_contacts oc '||
4289: l_where||' and oc.dnz_chr_id = okh.id
4290: and oc.cro_code = ''SALESPERSON''
4291: and oc.jtot_object1_code = ''OKX_SALEPERS''
4292: AND okh.scs_code = :update_level_value';

Line 4298: ' AND (EXISTS (Select ''x'' from okc_contacts oc

4294: -- dbms_output.put_line('Inside else');
4295: l_old_value := p_ctr_rec.old_value;
4296: l_stmt := l_select||' , :l_old_value old_value'||
4297: l_from||l_where||
4298: ' AND (EXISTS (Select ''x'' from okc_contacts oc
4299: where oc.dnz_chr_id = okh.id
4300: and oc.cro_code = ''SALESPERSON''
4301: and oc.object1_id1=:p_ctr_rec_old_value
4302: and oc.jtot_object1_code = ''OKX_SALEPERS'')

Line 4318: ' AND EXISTS (Select ''x'' from okc_contacts oc

4314:
4315: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4316: l_stmt := l_select||' ,NULL old_value'||
4317: l_from||l_where||
4318: ' AND EXISTS (Select ''x'' from okc_contacts oc
4319: where oc.dnz_chr_id = okh.id
4320: and oc.cro_code = ''SHIPPING''
4321: and oc.object1_id1 is null
4322: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 4327: l_from||', okc_contacts oc '||

4323: AND okh.scs_code = :update_level_value';
4324:
4325: ELSIF p_ctr_rec.old_value = '-1111' THEN
4326: l_stmt := l_select||' ,oc.object1_id1 old_value'||
4327: l_from||', okc_contacts oc '||
4328: l_where||
4329: ' and oc.dnz_chr_id = okh.id
4330: and oc.cro_code = ''SHIPPING''
4331: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 4340: ' AND EXISTS (Select ''x'' from okc_contacts oc

4336:
4337: l_old_value := p_ctr_rec.old_value;
4338: l_stmt := l_select||' , :l_old_value old_value'||
4339: l_from||l_where||
4340: ' AND EXISTS (Select ''x'' from okc_contacts oc
4341: where oc.dnz_chr_id = okh.id
4342: and oc.cro_code = ''SHIPPING''
4343: and oc.object1_id1=:p_ctr_rec_old_value
4344: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 4357: ' AND EXISTS (Select ''x'' from okc_contacts oc

4353:
4354: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4355: l_stmt := l_select||' ,NULL old_value'||
4356: l_from||l_where||
4357: ' AND EXISTS (Select ''x'' from okc_contacts oc
4358: where oc.dnz_chr_id = okh.id
4359: and oc.cro_code = ''BILLING''
4360: and oc.object1_id1 is null
4361: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 4366: l_from||', okc_contacts oc '||

4362: AND okh.scs_code = :update_level_value';
4363:
4364: ELSIF p_ctr_rec.old_value = '-1111' THEN
4365: l_stmt := l_select||' ,oc.object1_id1 old_value'||
4366: l_from||', okc_contacts oc '||
4367: l_where||
4368: ' and oc.dnz_chr_id = okh.id
4369: and oc.cro_code = ''BILLING''
4370: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 4378: ' AND EXISTS (Select ''x'' from okc_contacts oc

4374: -- dbms_output.put_line('Inside billing else');
4375: l_old_value := p_ctr_rec.old_value;
4376: l_stmt := l_select||' , :l_old_value old_value'||
4377: l_from||l_where||
4378: ' AND EXISTS (Select ''x'' from okc_contacts oc
4379: where oc.dnz_chr_id = okh.id
4380: and oc.cro_code = ''BILLING''
4381: and oc.object1_id1=:p_ctr_rec_old_value
4382: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 4395: ' AND EXISTS (Select ''x'' from okc_contacts oc

4391:
4392: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4393: l_stmt := l_select||' ,NULL old_value'||
4394: l_from||l_where||
4395: ' AND EXISTS (Select ''x'' from okc_contacts oc
4396: where oc.dnz_chr_id = okh.id
4397: and oc.cro_code = ''CUST_SHIPPING''
4398: and oc.object1_id1 is null
4399: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 4404: l_from||', okc_contacts oc '||

4400: AND okh.scs_code = :update_level_value';
4401:
4402: ELSIF p_ctr_rec.old_value = '-1111' THEN
4403: l_stmt := l_select||' ,oc.object1_id1 old_value'||
4404: l_from||', okc_contacts oc '||
4405: l_where||
4406: ' and oc.dnz_chr_id = okh.id
4407: and oc.cro_code = ''CUST_SHIPPING''
4408: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 4417: ' AND EXISTS (Select ''x'' from okc_contacts oc

4413:
4414: l_old_value := p_ctr_rec.old_value;
4415: l_stmt := l_select||' , :l_old_value old_value'||
4416: l_from||l_where||
4417: ' AND EXISTS (Select ''x'' from okc_contacts oc
4418: where oc.dnz_chr_id = okh.id
4419: and oc.cro_code = ''CUST_SHIPPING''
4420: and oc.object1_id1=:p_ctr_rec_old_value
4421: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 4434: ' AND EXISTS (Select ''x'' from okc_contacts oc

4430:
4431: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4432: l_stmt := l_select||' ,NULL old_value'||
4433: l_from||l_where||
4434: ' AND EXISTS (Select ''x'' from okc_contacts oc
4435: where oc.dnz_chr_id = okh.id
4436: and oc.cro_code = ''CUST_BILLING''
4437: and oc.object1_id1 is null
4438: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 4443: l_from||', okc_contacts oc '||

4439: AND okh.scs_code= = :update_level_value';
4440:
4441: ELSIF p_ctr_rec.old_value = '-1111' THEN
4442: l_stmt := l_select||' ,oc.object1_id1 old_value'||
4443: l_from||', okc_contacts oc '||
4444: l_where||
4445: ' and oc.dnz_chr_id = okh.id
4446: and oc.cro_code = ''CUST_BILLING''
4447: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 4455: ' AND EXISTS (Select ''x'' from okc_contacts oc

4451: -- dbms_output.put_line('Inside billing else');
4452: l_old_value := p_ctr_rec.old_value;
4453: l_stmt := l_select||' , :l_old_value old_value'||
4454: l_from||l_where||
4455: ' AND EXISTS (Select ''x'' from okc_contacts oc
4456: where oc.dnz_chr_id = okh.id
4457: and oc.cro_code = ''CUST_BILLING''
4458: and oc.object1_id1= :p_ctr_rec_old_value
4459: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 5292: okc_contacts oco

5288: l_old_value := p_ctr_rec.old_value;
5289: l_stmt := l_select||' , :l_old_value old_value'||
5290: l_from||
5291: l_where||'AND EXISTS (SELECT ''x'' from
5292: okc_contacts oco
5293: WHERE oco.dnz_chr_id = okh.id
5294: AND oco.cro_code = ''ENGINEER''
5295: AND oco.jtot_object1_code = ''OKX_RESOURCE'')
5296: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1

Line 5306: okc_contacts oco

5302: l_old_value := p_ctr_rec.old_value;
5303: l_stmt := l_select||' , :l_old_value old_value'||
5304: l_from||
5305: l_where||'AND EXISTS (SELECT ''x'' from
5306: okc_contacts oco
5307: WHERE oco.dnz_chr_id = okh.id
5308: AND oco.cro_code = ''ENGINEER''
5309: AND oco.jtot_object1_code = ''OKX_RESOURCE''
5310: AND oco.object1_id1 = :p_ctr_rec_old_value)

Line 5327: okc_contacts oco

5323: l_old_value := p_ctr_rec.old_value;
5324: l_stmt := l_select||' , :l_old_value old_value'||
5325: l_from||
5326: l_where||'AND EXISTS (SELECT ''x'' from
5327: okc_contacts oco
5328: WHERE oco.dnz_chr_id = okh.id
5329: AND oco.cro_code = ''RSC_GROUP''
5330: AND oco.jtot_object1_code = ''OKS_RSCGROUP'')
5331: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1

Line 5341: okc_contacts oco

5337: l_old_value := p_ctr_rec.old_value;
5338: l_stmt := l_select||' , :l_old_value old_value'||
5339: l_from||
5340: l_where||'AND EXISTS (SELECT ''x'' from
5341: okc_contacts oco
5342: WHERE oco.dnz_chr_id = okh.id
5343: AND oco.cro_code = ''RSC_GROUP''
5344: AND oco.jtot_object1_code = ''OKS_RSCGROUP''
5345: AND oco.object1_id1 = :p_ctr_rec_old_value)

Line 5518: ' AND EXISTS (Select ''x'' from okc_contacts oc

5514:
5515: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5516: l_stmt := l_select||' ,NULL old_value'||
5517: l_from||l_where||
5518: ' AND EXISTS (Select ''x'' from okc_contacts oc
5519: where oc.dnz_chr_id = okh.id
5520: and oc.cro_code = ''SALESPERSON''
5521: and oc.object1_id1 is null
5522: and oc.jtot_object1_code = ''OKX_SALEPERS'')

Line 5531: l_from||', okc_contacts oc '||

5527:
5528: ELSIF p_ctr_rec.old_value = '-1111' THEN
5529: -- dbms_output.put_line('Inside else ALL SALES_REP');
5530: l_stmt := l_select||' ,oc.object1_id1 old_value '||
5531: l_from||', okc_contacts oc '||
5532: l_where||' and oc.dnz_chr_id = okh.id
5533: and oc.cro_code = ''SALESPERSON''
5534: and oc.jtot_object1_code = ''OKX_SALEPERS''
5535: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1

Line 5543: ' AND (EXISTS (Select ''x'' from okc_contacts oc

5539: ELSE
5540: l_old_value := p_ctr_rec.old_value;
5541: l_stmt := l_select||' , :l_old_value old_value'||
5542: l_from||l_where||
5543: ' AND (EXISTS (Select ''x'' from okc_contacts oc
5544: where oc.dnz_chr_id = okh.id
5545: and oc.cro_code = ''SALESPERSON''
5546: and oc.object1_id1=:p_ctr_rec_old_value
5547: and oc.jtot_object1_code = ''OKX_SALEPERS'')

Line 5566: ' AND EXISTS (Select ''x'' from okc_contacts oc

5562:
5563: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5564: l_stmt := l_select||' ,NULL old_value'||
5565: l_from||l_where||
5566: ' AND EXISTS (Select ''x'' from okc_contacts oc
5567: where oc.dnz_chr_id = okh.id
5568: and oc.cro_code = ''SHIPPING''
5569: and oc.object1_id1 is null
5570: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 5578: l_from||', okc_contacts oc '||

5574: CONNECT BY okg1.cgp_parent_id = PRIOR okg1.included_cgp_id)';
5575:
5576: ELSIF p_ctr_rec.old_value = '-1111' THEN
5577: l_stmt := l_select||' ,oc.object1_id1 old_value'||
5578: l_from||', okc_contacts oc '||
5579: l_where||
5580: ' and oc.dnz_chr_id = okh.id
5581: and oc.cro_code = ''SHIPPING''
5582: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 5592: ' AND EXISTS (Select ''x'' from okc_contacts oc

5588: ELSE
5589: l_old_value := p_ctr_rec.old_value;
5590: l_stmt := l_select||' , :l_old_value old_value'||
5591: l_from||l_where||
5592: ' AND EXISTS (Select ''x'' from okc_contacts oc
5593: where oc.dnz_chr_id = okh.id
5594: and oc.cro_code = ''SHIPPING''
5595: and oc.object1_id1=:p_ctr_rec_old_value
5596: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 5612: ' AND EXISTS (Select ''x'' from okc_contacts oc

5608:
5609: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5610: l_stmt := l_select||' ,NULL old_value'||
5611: l_from||l_where||
5612: ' AND EXISTS (Select ''x'' from okc_contacts oc
5613: where oc.dnz_chr_id = okh.id
5614: and oc.cro_code = ''BILLING''
5615: and oc.object1_id1 is null
5616: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 5624: l_from||', okc_contacts oc '||

5620: CONNECT BY okg1.cgp_parent_id = PRIOR okg1.included_cgp_id)';
5621:
5622: ELSIF p_ctr_rec.old_value = '-1111' THEN
5623: l_stmt := l_select||' ,oc.object1_id1 old_value'||
5624: l_from||', okc_contacts oc '||
5625: l_where||
5626: ' and oc.dnz_chr_id = okh.id
5627: and oc.cro_code = ''BILLING''
5628: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 5637: ' AND EXISTS (Select ''x'' from okc_contacts oc

5633: ELSE
5634: l_old_value := p_ctr_rec.old_value;
5635: l_stmt := l_select||' , :l_old_value old_value'||
5636: l_from||l_where||
5637: ' AND EXISTS (Select ''x'' from okc_contacts oc
5638: where oc.dnz_chr_id = okh.id
5639: and oc.cro_code = ''BILLING''
5640: and oc.object1_id1=:p_ctr_rec_old_value
5641: and oc.jtot_object1_code = ''OKX_PCONTACT'')

Line 5656: ' AND EXISTS (Select ''x'' from okc_contacts oc

5652:
5653: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5654: l_stmt := l_select||' ,NULL old_value'||
5655: l_from||l_where||
5656: ' AND EXISTS (Select ''x'' from okc_contacts oc
5657: where oc.dnz_chr_id = okh.id
5658: and oc.cro_code = ''CUST_SHIPPING''
5659: and oc.object1_id1 is null
5660: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 5668: l_from||', okc_contacts oc '||

5664: CONNECT BY okg1.cgp_parent_id = PRIOR okg1.included_cgp_id)';
5665:
5666: ELSIF p_ctr_rec.old_value = '-1111' THEN
5667: l_stmt := l_select||' ,oc.object1_id1 old_value'||
5668: l_from||', okc_contacts oc '||
5669: l_where||
5670: ' and oc.dnz_chr_id = okh.id
5671: and oc.cro_code = ''CUST_SHIPPING''
5672: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 5682: ' AND EXISTS (Select ''x'' from okc_contacts oc

5678: ELSE
5679: l_old_value := p_ctr_rec.old_value;
5680: l_stmt := l_select||' , :l_old_value old_value'||
5681: l_from||l_where||
5682: ' AND EXISTS (Select ''x'' from okc_contacts oc
5683: where oc.dnz_chr_id = okh.id
5684: and oc.cro_code = ''CUST_SHIPPING''
5685: and oc.object1_id1=:p_ctr_rec_old_value
5686: and oc.jtot_object1_code = ''OKX_CONTSHIP'')

Line 5702: ' AND EXISTS (Select ''x'' from okc_contacts oc

5698:
5699: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5700: l_stmt := l_select||' ,NULL old_value'||
5701: l_from||l_where||
5702: ' AND EXISTS (Select ''x'' from okc_contacts oc
5703: where oc.dnz_chr_id = okh.id
5704: and oc.cro_code = ''CUST_BILLING''
5705: and oc.object1_id1 is null
5706: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 5714: l_from||', okc_contacts oc '||

5710: CONNECT BY okg1.cgp_parent_id = PRIOR okg1.included_cgp_id)';
5711:
5712: ELSIF p_ctr_rec.old_value = '-1111' THEN
5713: l_stmt := l_select||' ,oc.object1_id1 old_value'||
5714: l_from||', okc_contacts oc '||
5715: l_where||
5716: ' and oc.dnz_chr_id = okh.id
5717: and oc.cro_code = ''CUST_BILLING''
5718: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 5727: ' AND EXISTS (Select ''x'' from okc_contacts oc

5723: ELSE
5724: l_old_value := p_ctr_rec.old_value;
5725: l_stmt := l_select||' , :l_old_value old_value'||
5726: l_from||l_where||
5727: ' AND EXISTS (Select ''x'' from okc_contacts oc
5728: where oc.dnz_chr_id = okh.id
5729: and oc.cro_code = ''CUST_BILLING''
5730: and oc.object1_id1=:p_ctr_rec_old_value
5731: and oc.jtot_object1_code = ''OKX_CONTBILL'')

Line 6996: FROM okc_contacts oc , okc_k_headers_b kh

6992:
6993: CURSOR Get_contact(p_chr_id IN Number,p_cro_code IN Varchar2,
6994: p_object_code IN Varchar2, p_old_value IN Varchar2) IS
6995: SELECT oc.id, oc.object_version_number, kh.start_date start_date
6996: FROM okc_contacts oc , okc_k_headers_b kh
6997: WHERE oc.dnz_chr_id = p_chr_id
6998: AND oc.cro_code = p_cro_code
6999: AND oc.object1_id1 = p_old_value
7000: AND oc.jtot_object1_code = p_object_code

Line 8529: LOG_MESSAGES('SALES_PERSON in OKC_CONTACTS update status: '||l_return_status);

8525: p_ctcv_rec => l_ctcv_rec_in,
8526: x_ctcv_rec => l_ctcv_rec_out);
8527:
8528: IF l_return_status = G_RET_STS_SUCCESS THEN
8529: LOG_MESSAGES('SALES_PERSON in OKC_CONTACTS update status: '||l_return_status);
8530: ELSE
8531: IF l_msg_count > 0
8532: THEN
8533: FOR i in 1..l_msg_count

Line 8545: LOG_MESSAGES('SALESPERSON in OKC_CONTACTS update status: '||l_return_status);

8541:
8542: END LOOP;
8543: END IF;
8544:
8545: LOG_MESSAGES('SALESPERSON in OKC_CONTACTS update status: '||l_return_status);
8546: LOG_MESSAGES('SALES Person in OKC_CONTACTS Update failed;'||l_message);
8547: l_status := 'ERROR';
8548: RAISE G_EXCEPTION_HALT_VALIDATION;
8549: END IF;

Line 8546: LOG_MESSAGES('SALES Person in OKC_CONTACTS Update failed;'||l_message);

8542: END LOOP;
8543: END IF;
8544:
8545: LOG_MESSAGES('SALESPERSON in OKC_CONTACTS update status: '||l_return_status);
8546: LOG_MESSAGES('SALES Person in OKC_CONTACTS Update failed;'||l_message);
8547: l_status := 'ERROR';
8548: RAISE G_EXCEPTION_HALT_VALIDATION;
8549: END IF;
8550:

Line 8564: LOG_MESSAGES('SALESPERSON in OKC_CONTACTS lock status: '||l_return_status);

8560: l_message := l_message||' ; '||l_msg_data;
8561: END LOOP;
8562: END IF;
8563:
8564: LOG_MESSAGES('SALESPERSON in OKC_CONTACTS lock status: '||l_return_status);
8565: LOG_MESSAGES('SALESPERSON in OKC_CONTACTS lock failed;'||l_message);
8566: l_status := 'ERROR';
8567: RAISE G_EXCEPTION_HALT_VALIDATION;
8568: END IF;

Line 8565: LOG_MESSAGES('SALESPERSON in OKC_CONTACTS lock failed;'||l_message);

8561: END LOOP;
8562: END IF;
8563:
8564: LOG_MESSAGES('SALESPERSON in OKC_CONTACTS lock status: '||l_return_status);
8565: LOG_MESSAGES('SALESPERSON in OKC_CONTACTS lock failed;'||l_message);
8566: l_status := 'ERROR';
8567: RAISE G_EXCEPTION_HALT_VALIDATION;
8568: END IF;
8569: END IF;