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_HZ_MERGE_PUB dependencies on STANDARD

Line 472: ,kpr.last_updated_by = arp_standard.profile.user_id

468: UPDATE okc_k_party_roles_b kpr
469: SET kpr.object1_id1 = l_target_party_id
470: ,kpr.object_version_number = kpr.object_version_number + 1
471: ,kpr.last_update_date = SYSDATE
472: ,kpr.last_updated_by = arp_standard.profile.user_id
473: ,kpr.last_update_login = arp_standard.profile.last_update_login
474: WHERE kpr.object1_id1 = l_source_party_id
475: AND kpr.dnz_chr_id = l_chr_id;
476:

Line 473: ,kpr.last_update_login = arp_standard.profile.last_update_login

469: SET kpr.object1_id1 = l_target_party_id
470: ,kpr.object_version_number = kpr.object_version_number + 1
471: ,kpr.last_update_date = SYSDATE
472: ,kpr.last_updated_by = arp_standard.profile.user_id
473: ,kpr.last_update_login = arp_standard.profile.last_update_login
474: WHERE kpr.object1_id1 = l_source_party_id
475: AND kpr.dnz_chr_id = l_chr_id;
476:
477: l_count := sql%rowcount;

Line 544: ,ver.last_updated_by = arp_standard.profile.user_id

540: UPDATE okc_k_vers_numbers ver
541: SET ver.minor_version = ver.minor_version + 1
542: ,ver.object_version_number = ver.object_version_number + 1
543: ,ver.last_update_date = SYSDATE
544: ,ver.last_updated_by = arp_standard.profile.user_id
545: ,ver.last_update_login = arp_standard.profile.last_update_login
546: WHERE chr_id = l_chr_id;
547: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957
548: g_minor_ver_upd_processed := 'Y'; /*bug9077092*/

Line 545: ,ver.last_update_login = arp_standard.profile.last_update_login

541: SET ver.minor_version = ver.minor_version + 1
542: ,ver.object_version_number = ver.object_version_number + 1
543: ,ver.last_update_date = SYSDATE
544: ,ver.last_updated_by = arp_standard.profile.user_id
545: ,ver.last_update_login = arp_standard.profile.last_update_login
546: WHERE chr_id = l_chr_id;
547: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957
548: g_minor_ver_upd_processed := 'Y'; /*bug9077092*/
549: END IF;

Line 663: ,kpr.last_updated_by = arp_standard.profile.user_id

659: AND rcm.request_id = req_id
660: AND rcm.set_number = set_number)
661: ,kpr.object_version_number = kpr.object_version_number + 1
662: ,kpr.last_update_date = SYSDATE
663: ,kpr.last_updated_by = arp_standard.profile.user_id
664: ,kpr.last_update_login = arp_standard.profile.last_update_login
665: WHERE kpr.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
666: FROM ra_customer_merges rcm
667: WHERE rcm.process_flag = 'N'

Line 664: ,kpr.last_update_login = arp_standard.profile.last_update_login

660: AND rcm.set_number = set_number)
661: ,kpr.object_version_number = kpr.object_version_number + 1
662: ,kpr.last_update_date = SYSDATE
663: ,kpr.last_updated_by = arp_standard.profile.user_id
664: ,kpr.last_update_login = arp_standard.profile.last_update_login
665: WHERE kpr.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
666: FROM ra_customer_merges rcm
667: WHERE rcm.process_flag = 'N'
668: AND rcm.request_id = req_id

Line 740: ,rle.last_updated_by = arp_standard.profile.user_id

736: AND rcm.request_id = req_id
737: AND rcm.set_number = set_number)
738: ,rle.object_version_number = rle.object_version_number + 1
739: ,rle.last_update_date = SYSDATE
740: ,rle.last_updated_by = arp_standard.profile.user_id
741: ,rle.last_update_login = arp_standard.profile.last_update_login
742: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
743: FROM ra_customer_merges rcm
744: WHERE rcm.process_flag = 'N'

Line 741: ,rle.last_update_login = arp_standard.profile.last_update_login

737: AND rcm.set_number = set_number)
738: ,rle.object_version_number = rle.object_version_number + 1
739: ,rle.last_update_date = SYSDATE
740: ,rle.last_updated_by = arp_standard.profile.user_id
741: ,rle.last_update_login = arp_standard.profile.last_update_login
742: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
743: FROM ra_customer_merges rcm
744: WHERE rcm.process_flag = 'N'
745: AND rcm.request_id = req_id

Line 817: ,rle.last_updated_by = arp_standard.profile.user_id

813: AND rcm.request_id = req_id
814: AND rcm.set_number = set_number)
815: ,rle.object_version_number = rle.object_version_number + 1
816: ,rle.last_update_date = SYSDATE
817: ,rle.last_updated_by = arp_standard.profile.user_id
818: ,rle.last_update_login = arp_standard.profile.last_update_login
819: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_id)
820: FROM ra_customer_merges rcm
821: WHERE rcm.process_flag = 'N'

Line 818: ,rle.last_update_login = arp_standard.profile.last_update_login

814: AND rcm.set_number = set_number)
815: ,rle.object_version_number = rle.object_version_number + 1
816: ,rle.last_update_date = SYSDATE
817: ,rle.last_updated_by = arp_standard.profile.user_id
818: ,rle.last_update_login = arp_standard.profile.last_update_login
819: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_id)
820: FROM ra_customer_merges rcm
821: WHERE rcm.process_flag = 'N'
822: AND rcm.request_id = req_id

Line 894: ,rle.last_updated_by = arp_standard.profile.user_id

890: AND rcm.request_id = req_id
891: AND rcm.set_number = set_number)
892: ,rle.object_version_number = rle.object_version_number + 1
893: ,rle.last_update_date = SYSDATE
894: ,rle.last_updated_by = arp_standard.profile.user_id
895: ,rle.last_update_login = arp_standard.profile.last_update_login
896: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_id)
897: FROM ra_customer_merges rcm
898: WHERE rcm.process_flag = 'N'

Line 895: ,rle.last_update_login = arp_standard.profile.last_update_login

891: AND rcm.set_number = set_number)
892: ,rle.object_version_number = rle.object_version_number + 1
893: ,rle.last_update_date = SYSDATE
894: ,rle.last_updated_by = arp_standard.profile.user_id
895: ,rle.last_update_login = arp_standard.profile.last_update_login
896: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_id)
897: FROM ra_customer_merges rcm
898: WHERE rcm.process_flag = 'N'
899: AND rcm.request_id = req_id

Line 969: ,okh.last_updated_by = arp_standard.profile.user_id

965: AND rcm.request_id = req_id
966: AND rcm.set_number = set_number)
967: ,okh.object_version_number = okh.object_version_number + 1
968: ,okh.last_update_date = SYSDATE
969: ,okh.last_updated_by = arp_standard.profile.user_id
970: ,okh.last_update_login = arp_standard.profile.last_update_login
971: WHERE okh.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
972: FROM ra_customer_merges rcm
973: WHERE rcm.process_flag = 'N'

Line 970: ,okh.last_update_login = arp_standard.profile.last_update_login

966: AND rcm.set_number = set_number)
967: ,okh.object_version_number = okh.object_version_number + 1
968: ,okh.last_update_date = SYSDATE
969: ,okh.last_updated_by = arp_standard.profile.user_id
970: ,okh.last_update_login = arp_standard.profile.last_update_login
971: WHERE okh.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
972: FROM ra_customer_merges rcm
973: WHERE rcm.process_flag = 'N'
974: AND rcm.request_id = req_id

Line 1049: ,okl.last_updated_by = arp_standard.profile.user_id

1045: AND rcm.request_id = req_id
1046: AND rcm.set_number = set_number)
1047: ,okl.object_version_number = okl.object_version_number + 1
1048: ,okl.last_update_date = SYSDATE
1049: ,okl.last_updated_by = arp_standard.profile.user_id
1050: ,okl.last_update_login = arp_standard.profile.last_update_login
1051: WHERE okl.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
1052: FROM ra_customer_merges rcm
1053: WHERE rcm.process_flag = 'N'

Line 1050: ,okl.last_update_login = arp_standard.profile.last_update_login

1046: AND rcm.set_number = set_number)
1047: ,okl.object_version_number = okl.object_version_number + 1
1048: ,okl.last_update_date = SYSDATE
1049: ,okl.last_updated_by = arp_standard.profile.user_id
1050: ,okl.last_update_login = arp_standard.profile.last_update_login
1051: WHERE okl.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
1052: FROM ra_customer_merges rcm
1053: WHERE rcm.process_flag = 'N'
1054: AND rcm.request_id = req_id

Line 1119: ,okpr.last_updated_by = arp_standard.profile.user_id

1115: AND rcm.request_id = req_id
1116: AND rcm.set_number = set_number)
1117: ,okpr.object_version_number = okpr.object_version_number + 1
1118: ,okpr.last_update_date = SYSDATE
1119: ,okpr.last_updated_by = arp_standard.profile.user_id
1120: ,okpr.last_update_login = arp_standard.profile.last_update_login
1121: WHERE okpr.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
1122: FROM ra_customer_merges rcm
1123: WHERE rcm.process_flag = 'N'

Line 1120: ,okpr.last_update_login = arp_standard.profile.last_update_login

1116: AND rcm.set_number = set_number)
1117: ,okpr.object_version_number = okpr.object_version_number + 1
1118: ,okpr.last_update_date = SYSDATE
1119: ,okpr.last_updated_by = arp_standard.profile.user_id
1120: ,okpr.last_update_login = arp_standard.profile.last_update_login
1121: WHERE okpr.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
1122: FROM ra_customer_merges rcm
1123: WHERE rcm.process_flag = 'N'
1124: AND rcm.request_id = req_id

Line 1193: ,cim.last_updated_by = arp_standard.profile.user_id

1189: AND rcm.request_id = req_id
1190: AND rcm.set_number = set_number)
1191: ,cim.object_version_number = cim.object_version_number + 1
1192: ,cim.last_update_date = SYSDATE
1193: ,cim.last_updated_by = arp_standard.profile.user_id
1194: ,cim.last_update_login = arp_standard.profile.last_update_login
1195: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
1196: FROM ra_customer_merges rcm
1197: WHERE rcm.process_flag = 'N'

Line 1194: ,cim.last_update_login = arp_standard.profile.last_update_login

1190: AND rcm.set_number = set_number)
1191: ,cim.object_version_number = cim.object_version_number + 1
1192: ,cim.last_update_date = SYSDATE
1193: ,cim.last_updated_by = arp_standard.profile.user_id
1194: ,cim.last_update_login = arp_standard.profile.last_update_login
1195: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
1196: FROM ra_customer_merges rcm
1197: WHERE rcm.process_flag = 'N'
1198: AND rcm.request_id = req_id

Line 1245: ,ver.last_updated_by = arp_standard.profile.user_id

1241: UPDATE okc_k_vers_numbers ver
1242: SET ver.minor_version = ver.minor_version + 1
1243: ,ver.object_version_number = ver.object_version_number + 1
1244: ,ver.last_update_date = SYSDATE
1245: ,ver.last_updated_by = arp_standard.profile.user_id
1246: ,ver.last_update_login = arp_standard.profile.last_update_login
1247: WHERE chr_id = l_chr_id(k);
1248: END LOOP;
1249: g_minor_ver_upd_processed := 'Y';

Line 1246: ,ver.last_update_login = arp_standard.profile.last_update_login

1242: SET ver.minor_version = ver.minor_version + 1
1243: ,ver.object_version_number = ver.object_version_number + 1
1244: ,ver.last_update_date = SYSDATE
1245: ,ver.last_updated_by = arp_standard.profile.user_id
1246: ,ver.last_update_login = arp_standard.profile.last_update_login
1247: WHERE chr_id = l_chr_id(k);
1248: END LOOP;
1249: g_minor_ver_upd_processed := 'Y';
1250: END IF;

Line 1357: ,rle.last_updated_by = arp_standard.profile.user_id

1353: AND rcm.set_number = set_number
1354: AND ROWNUM=1)
1355: ,rle.object_version_number = rle.object_version_number + 1
1356: ,rle.last_update_date = SYSDATE
1357: ,rle.last_updated_by = arp_standard.profile.user_id
1358: ,rle.last_update_login = arp_standard.profile.last_update_login
1359: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1360: FROM ra_customer_merges rcm
1361: WHERE rcm.process_flag = 'N'

Line 1358: ,rle.last_update_login = arp_standard.profile.last_update_login

1354: AND ROWNUM=1)
1355: ,rle.object_version_number = rle.object_version_number + 1
1356: ,rle.last_update_date = SYSDATE
1357: ,rle.last_updated_by = arp_standard.profile.user_id
1358: ,rle.last_update_login = arp_standard.profile.last_update_login
1359: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1360: FROM ra_customer_merges rcm
1361: WHERE rcm.process_flag = 'N'
1362: AND rcm.request_id = req_id

Line 1435: ,rle.last_updated_by = arp_standard.profile.user_id

1431: AND rcm.set_number = set_number
1432: AND ROWNUM=1)
1433: ,rle.object_version_number = rle.object_version_number + 1
1434: ,rle.last_update_date = SYSDATE
1435: ,rle.last_updated_by = arp_standard.profile.user_id
1436: ,rle.last_update_login = arp_standard.profile.last_update_login
1437: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1438: FROM ra_customer_merges rcm
1439: WHERE rcm.process_flag = 'N'

Line 1436: ,rle.last_update_login = arp_standard.profile.last_update_login

1432: AND ROWNUM=1)
1433: ,rle.object_version_number = rle.object_version_number + 1
1434: ,rle.last_update_date = SYSDATE
1435: ,rle.last_updated_by = arp_standard.profile.user_id
1436: ,rle.last_update_login = arp_standard.profile.last_update_login
1437: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1438: FROM ra_customer_merges rcm
1439: WHERE rcm.process_flag = 'N'
1440: AND rcm.request_id = req_id

Line 1512: ,rle.last_updated_by = arp_standard.profile.user_id

1508: AND rcm.set_number = set_number
1509: AND ROWNUM=1)
1510: ,rle.object_version_number = rle.object_version_number + 1
1511: ,rle.last_update_date = SYSDATE
1512: ,rle.last_updated_by = arp_standard.profile.user_id
1513: ,rle.last_update_login = arp_standard.profile.last_update_login
1514: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1515: FROM ra_customer_merges rcm
1516: WHERE rcm.process_flag = 'N'

Line 1513: ,rle.last_update_login = arp_standard.profile.last_update_login

1509: AND ROWNUM=1)
1510: ,rle.object_version_number = rle.object_version_number + 1
1511: ,rle.last_update_date = SYSDATE
1512: ,rle.last_updated_by = arp_standard.profile.user_id
1513: ,rle.last_update_login = arp_standard.profile.last_update_login
1514: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1515: FROM ra_customer_merges rcm
1516: WHERE rcm.process_flag = 'N'
1517: AND rcm.request_id = req_id

Line 1592: ,cim.last_updated_by = arp_standard.profile.user_id

1588: AND rcm.set_number = set_number
1589: AND ROWNUM=1)
1590: ,cim.object_version_number = cim.object_version_number + 1
1591: ,cim.last_update_date = SYSDATE
1592: ,cim.last_updated_by = arp_standard.profile.user_id
1593: ,cim.last_update_login = arp_standard.profile.last_update_login
1594: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1595: FROM ra_customer_merges rcm
1596: WHERE rcm.process_flag = 'N'

Line 1593: ,cim.last_update_login = arp_standard.profile.last_update_login

1589: AND ROWNUM=1)
1590: ,cim.object_version_number = cim.object_version_number + 1
1591: ,cim.last_update_date = SYSDATE
1592: ,cim.last_updated_by = arp_standard.profile.user_id
1593: ,cim.last_update_login = arp_standard.profile.last_update_login
1594: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1595: FROM ra_customer_merges rcm
1596: WHERE rcm.process_flag = 'N'
1597: AND rcm.request_id = req_id

Line 1681: ,rle.last_updated_by = arp_standard.profile.user_id

1677: AND rcm.request_id = req_id
1678: AND rcm.set_number = set_number)
1679: ,rle.object_version_number = rle.object_version_number + 1
1680: ,rle.last_update_date = SYSDATE
1681: ,rle.last_updated_by = arp_standard.profile.user_id
1682: ,rle.last_update_login = arp_standard.profile.last_update_login
1683: WHERE rle.object1_id1 IN ( SELECT to_char(rcm.duplicate_site_id)
1684: FROM ra_customer_merges rcm
1685: WHERE rcm.process_flag = 'N'

Line 1682: ,rle.last_update_login = arp_standard.profile.last_update_login

1678: AND rcm.set_number = set_number)
1679: ,rle.object_version_number = rle.object_version_number + 1
1680: ,rle.last_update_date = SYSDATE
1681: ,rle.last_updated_by = arp_standard.profile.user_id
1682: ,rle.last_update_login = arp_standard.profile.last_update_login
1683: WHERE rle.object1_id1 IN ( SELECT to_char(rcm.duplicate_site_id)
1684: FROM ra_customer_merges rcm
1685: WHERE rcm.process_flag = 'N'
1686: AND rcm.request_id = req_id

Line 1771: ,rle.last_updated_by = arp_standard.profile.user_id

1767: AND rcm.request_id = req_id
1768: AND rcm.set_number = set_number)
1769: ,rle.object_version_number = rle.object_version_number + 1
1770: ,rle.last_update_date = SYSDATE
1771: ,rle.last_updated_by = arp_standard.profile.user_id
1772: ,rle.last_update_login = arp_standard.profile.last_update_login
1773: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1774: FROM ra_customer_merges rcm
1775: WHERE rcm.process_flag = 'N'

Line 1772: ,rle.last_update_login = arp_standard.profile.last_update_login

1768: AND rcm.set_number = set_number)
1769: ,rle.object_version_number = rle.object_version_number + 1
1770: ,rle.last_update_date = SYSDATE
1771: ,rle.last_updated_by = arp_standard.profile.user_id
1772: ,rle.last_update_login = arp_standard.profile.last_update_login
1773: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1774: FROM ra_customer_merges rcm
1775: WHERE rcm.process_flag = 'N'
1776: AND rcm.request_id = req_id

Line 1847: ,rle.last_updated_by = arp_standard.profile.user_id

1843: AND rcm.request_id = req_id
1844: AND rcm.set_number = set_number)
1845: ,rle.object_version_number = rle.object_version_number + 1
1846: ,rle.last_update_date = SYSDATE
1847: ,rle.last_updated_by = arp_standard.profile.user_id
1848: ,rle.last_update_login = arp_standard.profile.last_update_login
1849: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1850: FROM ra_customer_merges rcm
1851: WHERE rcm.process_flag = 'N'

Line 1848: ,rle.last_update_login = arp_standard.profile.last_update_login

1844: AND rcm.set_number = set_number)
1845: ,rle.object_version_number = rle.object_version_number + 1
1846: ,rle.last_update_date = SYSDATE
1847: ,rle.last_updated_by = arp_standard.profile.user_id
1848: ,rle.last_update_login = arp_standard.profile.last_update_login
1849: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1850: FROM ra_customer_merges rcm
1851: WHERE rcm.process_flag = 'N'
1852: AND rcm.request_id = req_id

Line 1924: ,rle.last_updated_by = arp_standard.profile.user_id

1920: AND rcm.request_id = req_id
1921: AND rcm.set_number = set_number)
1922: ,rle.object_version_number = rle.object_version_number + 1
1923: ,rle.last_update_date = SYSDATE
1924: ,rle.last_updated_by = arp_standard.profile.user_id
1925: ,rle.last_update_login = arp_standard.profile.last_update_login
1926: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1927: FROM ra_customer_merges rcm
1928: WHERE rcm.process_flag = 'N'

Line 1925: ,rle.last_update_login = arp_standard.profile.last_update_login

1921: AND rcm.set_number = set_number)
1922: ,rle.object_version_number = rle.object_version_number + 1
1923: ,rle.last_update_date = SYSDATE
1924: ,rle.last_updated_by = arp_standard.profile.user_id
1925: ,rle.last_update_login = arp_standard.profile.last_update_login
1926: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1927: FROM ra_customer_merges rcm
1928: WHERE rcm.process_flag = 'N'
1929: AND rcm.request_id = req_id

Line 1999: ,okh.last_updated_by = arp_standard.profile.user_id

1995: AND rcm.request_id = req_id
1996: AND rcm.set_number = set_number)
1997: ,okh.object_version_number = okh.object_version_number + 1
1998: ,okh.last_update_date = SYSDATE
1999: ,okh.last_updated_by = arp_standard.profile.user_id
2000: ,okh.last_update_login = arp_standard.profile.last_update_login
2001: WHERE okh.ship_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2002: FROM ra_customer_merges rcm
2003: WHERE rcm.process_flag = 'N'

Line 2000: ,okh.last_update_login = arp_standard.profile.last_update_login

1996: AND rcm.set_number = set_number)
1997: ,okh.object_version_number = okh.object_version_number + 1
1998: ,okh.last_update_date = SYSDATE
1999: ,okh.last_updated_by = arp_standard.profile.user_id
2000: ,okh.last_update_login = arp_standard.profile.last_update_login
2001: WHERE okh.ship_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2002: FROM ra_customer_merges rcm
2003: WHERE rcm.process_flag = 'N'
2004: AND rcm.request_id = req_id

Line 2069: ,okh.last_updated_by = arp_standard.profile.user_id

2065: AND rcm.request_id = req_id
2066: AND rcm.set_number = set_number)
2067: ,okh.object_version_number = okh.object_version_number + 1
2068: ,okh.last_update_date = SYSDATE
2069: ,okh.last_updated_by = arp_standard.profile.user_id
2070: ,okh.last_update_login = arp_standard.profile.last_update_login
2071: WHERE okh.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2072: FROM ra_customer_merges rcm
2073: WHERE rcm.process_flag = 'N'

Line 2070: ,okh.last_update_login = arp_standard.profile.last_update_login

2066: AND rcm.set_number = set_number)
2067: ,okh.object_version_number = okh.object_version_number + 1
2068: ,okh.last_update_date = SYSDATE
2069: ,okh.last_updated_by = arp_standard.profile.user_id
2070: ,okh.last_update_login = arp_standard.profile.last_update_login
2071: WHERE okh.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2072: FROM ra_customer_merges rcm
2073: WHERE rcm.process_flag = 'N'
2074: AND rcm.request_id = req_id

Line 2146: ,okl.last_updated_by = arp_standard.profile.user_id

2142: AND rcm.request_id = req_id
2143: AND rcm.set_number = set_number)
2144: ,okl.object_version_number = okl.object_version_number + 1
2145: ,okl.last_update_date = SYSDATE
2146: ,okl.last_updated_by = arp_standard.profile.user_id
2147: ,okl.last_update_login = arp_standard.profile.last_update_login
2148: WHERE okl.ship_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2149: FROM ra_customer_merges rcm
2150: WHERE rcm.process_flag = 'N'

Line 2147: ,okl.last_update_login = arp_standard.profile.last_update_login

2143: AND rcm.set_number = set_number)
2144: ,okl.object_version_number = okl.object_version_number + 1
2145: ,okl.last_update_date = SYSDATE
2146: ,okl.last_updated_by = arp_standard.profile.user_id
2147: ,okl.last_update_login = arp_standard.profile.last_update_login
2148: WHERE okl.ship_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2149: FROM ra_customer_merges rcm
2150: WHERE rcm.process_flag = 'N'
2151: AND rcm.request_id = req_id

Line 2216: ,okl.last_updated_by = arp_standard.profile.user_id

2212: AND rcm.request_id = req_id
2213: AND rcm.set_number = set_number)
2214: ,okl.object_version_number = okl.object_version_number + 1
2215: ,okl.last_update_date = SYSDATE
2216: ,okl.last_updated_by = arp_standard.profile.user_id
2217: ,okl.last_update_login = arp_standard.profile.last_update_login
2218: WHERE okl.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2219: FROM ra_customer_merges rcm
2220: WHERE rcm.process_flag = 'N'

Line 2217: ,okl.last_update_login = arp_standard.profile.last_update_login

2213: AND rcm.set_number = set_number)
2214: ,okl.object_version_number = okl.object_version_number + 1
2215: ,okl.last_update_date = SYSDATE
2216: ,okl.last_updated_by = arp_standard.profile.user_id
2217: ,okl.last_update_login = arp_standard.profile.last_update_login
2218: WHERE okl.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2219: FROM ra_customer_merges rcm
2220: WHERE rcm.process_flag = 'N'
2221: AND rcm.request_id = req_id

Line 2286: ,okpr.last_updated_by = arp_standard.profile.user_id

2282: AND rcm.request_id = req_id
2283: AND rcm.set_number = set_number)
2284: ,okpr.object_version_number = okpr.object_version_number + 1
2285: ,okpr.last_update_date = SYSDATE
2286: ,okpr.last_updated_by = arp_standard.profile.user_id
2287: ,okpr.last_update_login = arp_standard.profile.last_update_login
2288: WHERE okpr.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2289: FROM ra_customer_merges rcm
2290: WHERE rcm.process_flag = 'N'

Line 2287: ,okpr.last_update_login = arp_standard.profile.last_update_login

2283: AND rcm.set_number = set_number)
2284: ,okpr.object_version_number = okpr.object_version_number + 1
2285: ,okpr.last_update_date = SYSDATE
2286: ,okpr.last_updated_by = arp_standard.profile.user_id
2287: ,okpr.last_update_login = arp_standard.profile.last_update_login
2288: WHERE okpr.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2289: FROM ra_customer_merges rcm
2290: WHERE rcm.process_flag = 'N'
2291: AND rcm.request_id = req_id

Line 2361: ,cim.last_updated_by = arp_standard.profile.user_id

2357: AND rcm.request_id = req_id
2358: AND rcm.set_number = set_number)
2359: ,cim.object_version_number = cim.object_version_number + 1
2360: ,cim.last_update_date = SYSDATE
2361: ,cim.last_updated_by = arp_standard.profile.user_id
2362: ,cim.last_update_login = arp_standard.profile.last_update_login
2363: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
2364: FROM ra_customer_merges rcm
2365: WHERE rcm.process_flag = 'N'

Line 2362: ,cim.last_update_login = arp_standard.profile.last_update_login

2358: AND rcm.set_number = set_number)
2359: ,cim.object_version_number = cim.object_version_number + 1
2360: ,cim.last_update_date = SYSDATE
2361: ,cim.last_updated_by = arp_standard.profile.user_id
2362: ,cim.last_update_login = arp_standard.profile.last_update_login
2363: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
2364: FROM ra_customer_merges rcm
2365: WHERE rcm.process_flag = 'N'
2366: AND rcm.request_id = req_id

Line 2413: ,ver.last_updated_by = arp_standard.profile.user_id

2409: UPDATE okc_k_vers_numbers ver
2410: SET ver.minor_version = ver.minor_version + 1
2411: ,ver.object_version_number = ver.object_version_number + 1
2412: ,ver.last_update_date = SYSDATE
2413: ,ver.last_updated_by = arp_standard.profile.user_id
2414: ,ver.last_update_login = arp_standard.profile.last_update_login
2415: WHERE chr_id = l_chr_id(k);
2416: END LOOP;
2417: g_minor_ver_upd_processed := 'Y';

Line 2414: ,ver.last_update_login = arp_standard.profile.last_update_login

2410: SET ver.minor_version = ver.minor_version + 1
2411: ,ver.object_version_number = ver.object_version_number + 1
2412: ,ver.last_update_date = SYSDATE
2413: ,ver.last_updated_by = arp_standard.profile.user_id
2414: ,ver.last_update_login = arp_standard.profile.last_update_login
2415: WHERE chr_id = l_chr_id(k);
2416: END LOOP;
2417: g_minor_ver_upd_processed := 'Y';
2418: END IF;