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.ARP_CMERGE_ARCUS dependencies on HZ_UTILITY_V2PUB

Line 468: last_updated_by =hz_utility_v2pub.user_id,-- arp_standard.profile.user_id,

464:
465: UPDATE HZ_CUST_SITE_USES_ALL yt --SSUptake
466: SET status = 'I',
467: last_update_date = sysdate,
468: last_updated_by =hz_utility_v2pub.user_id,-- arp_standard.profile.user_id,
469: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
470: request_id = req_id,
471: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
472: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

Line 469: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

465: UPDATE HZ_CUST_SITE_USES_ALL yt --SSUptake
466: SET status = 'I',
467: last_update_date = sysdate,
468: last_updated_by =hz_utility_v2pub.user_id,-- arp_standard.profile.user_id,
469: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
470: request_id = req_id,
471: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
472: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
473: program_update_date = sysdate

Line 471: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

467: last_update_date = sysdate,
468: last_updated_by =hz_utility_v2pub.user_id,-- arp_standard.profile.user_id,
469: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
470: request_id = req_id,
471: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
472: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
473: program_update_date = sysdate
474: WHERE EXISTS (
475: SELECT 'Y'

Line 472: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

468: last_updated_by =hz_utility_v2pub.user_id,-- arp_standard.profile.user_id,
469: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
470: request_id = req_id,
471: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
472: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
473: program_update_date = sysdate
474: WHERE EXISTS (
475: SELECT 'Y'
476: FROM ra_customer_merges m

Line 768: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

764:
765: UPDATE HZ_CUST_ACCT_SITES_ALL yt --SSUptake
766: SET status = 'I',
767: last_update_date = sysdate,
768: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
769: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
770: request_id = req_id,
771: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
772: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

Line 769: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

765: UPDATE HZ_CUST_ACCT_SITES_ALL yt --SSUptake
766: SET status = 'I',
767: last_update_date = sysdate,
768: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
769: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
770: request_id = req_id,
771: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
772: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
773: program_update_date = sysdate

Line 771: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

767: last_update_date = sysdate,
768: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
769: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
770: request_id = req_id,
771: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
772: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
773: program_update_date = sysdate
774: WHERE EXISTS (
775: SELECT 'Y'

Line 772: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

768: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
769: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
770: request_id = req_id,
771: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
772: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
773: program_update_date = sysdate
774: WHERE EXISTS (
775: SELECT 'Y'
776: FROM ra_customer_merges m

Line 803: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

799:
800: UPDATE HZ_CUST_ACCT_SITES_ALL yt --SSUptake
801: SET bill_to_flag = null,
802: last_update_date = sysdate,
803: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
804: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
805: request_id = req_id,
806: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
807: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

Line 804: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

800: UPDATE HZ_CUST_ACCT_SITES_ALL yt --SSUptake
801: SET bill_to_flag = null,
802: last_update_date = sysdate,
803: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
804: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
805: request_id = req_id,
806: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
807: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
808: program_update_date = sysdate

Line 806: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

802: last_update_date = sysdate,
803: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
804: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
805: request_id = req_id,
806: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
807: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
808: program_update_date = sysdate
809: WHERE EXISTS (
810: SELECT 'Y'

Line 807: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

803: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
804: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
805: request_id = req_id,
806: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
807: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
808: program_update_date = sysdate
809: WHERE EXISTS (
810: SELECT 'Y'
811: FROM ra_customer_merges m

Line 840: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

836:
837: UPDATE HZ_CUST_ACCT_SITES_ALL yt --SSUptake
838: SET ship_to_flag = null,
839: last_update_date = sysdate,
840: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
841: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
842: request_id = req_id,
843: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
844: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

Line 841: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

837: UPDATE HZ_CUST_ACCT_SITES_ALL yt --SSUptake
838: SET ship_to_flag = null,
839: last_update_date = sysdate,
840: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
841: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
842: request_id = req_id,
843: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
844: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
845: program_update_date = sysdate

Line 843: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

839: last_update_date = sysdate,
840: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
841: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
842: request_id = req_id,
843: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
844: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
845: program_update_date = sysdate
846: WHERE EXISTS (
847: SELECT 'Y'

Line 844: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

840: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
841: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
842: request_id = req_id,
843: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
844: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
845: program_update_date = sysdate
846: WHERE EXISTS (
847: SELECT 'Y'
848: FROM ra_customer_merges m

Line 877: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

873:
874: UPDATE HZ_CUST_ACCT_SITES_ALL yt --SSUptake
875: SET market_flag = null,
876: last_update_date = sysdate,
877: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
878: last_update_login = hz_utility_v2pub.last_update_login,--arp_standard.profile.last_update_login,
879: request_id = req_id,
880: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
881: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

Line 878: last_update_login = hz_utility_v2pub.last_update_login,--arp_standard.profile.last_update_login,

874: UPDATE HZ_CUST_ACCT_SITES_ALL yt --SSUptake
875: SET market_flag = null,
876: last_update_date = sysdate,
877: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
878: last_update_login = hz_utility_v2pub.last_update_login,--arp_standard.profile.last_update_login,
879: request_id = req_id,
880: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
881: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
882: program_update_date = sysdate

Line 880: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

876: last_update_date = sysdate,
877: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
878: last_update_login = hz_utility_v2pub.last_update_login,--arp_standard.profile.last_update_login,
879: request_id = req_id,
880: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
881: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
882: program_update_date = sysdate
883: WHERE EXISTS (
884: SELECT 'Y'

Line 881: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

877: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
878: last_update_login = hz_utility_v2pub.last_update_login,--arp_standard.profile.last_update_login,
879: request_id = req_id,
880: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
881: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
882: program_update_date = sysdate
883: WHERE EXISTS (
884: SELECT 'Y'
885: FROM ra_customer_merges m

Line 1120: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

1116:
1117: UPDATE HZ_CUST_ACCOUNTS yt
1118: SET status = 'I',
1119: last_update_date = sysdate,
1120: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
1121: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
1122: request_id = req_id,
1123: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
1124: program_id = hz_utility_v2pub.program_id,--arp_standard.profile.program_id,

Line 1121: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

1117: UPDATE HZ_CUST_ACCOUNTS yt
1118: SET status = 'I',
1119: last_update_date = sysdate,
1120: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
1121: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
1122: request_id = req_id,
1123: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
1124: program_id = hz_utility_v2pub.program_id,--arp_standard.profile.program_id,
1125: program_update_date = sysdate

Line 1123: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

1119: last_update_date = sysdate,
1120: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
1121: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
1122: request_id = req_id,
1123: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
1124: program_id = hz_utility_v2pub.program_id,--arp_standard.profile.program_id,
1125: program_update_date = sysdate
1126: WHERE cust_account_id IN (
1127: SELECT m.duplicate_id

Line 1124: program_id = hz_utility_v2pub.program_id,--arp_standard.profile.program_id,

1120: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
1121: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
1122: request_id = req_id,
1123: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
1124: program_id = hz_utility_v2pub.program_id,--arp_standard.profile.program_id,
1125: program_update_date = sysdate
1126: WHERE cust_account_id IN (
1127: SELECT m.duplicate_id
1128: FROM ra_customer_merges m

Line 1908: hz_utility_v2pub.CREATED_BY,

1904: receipt_id(i),
1905: end_date(i),
1906: new_date,
1907: req_id,
1908: hz_utility_v2pub.CREATED_BY,
1909: hz_utility_v2pub.CREATION_DATE,
1910: hz_utility_v2pub.LAST_UPDATED_BY,
1911: hz_utility_v2pub.LAST_UPDATE_DATE,
1912: hz_utility_v2pub.LAST_UPDATE_LOGIN,

Line 1909: hz_utility_v2pub.CREATION_DATE,

1905: end_date(i),
1906: new_date,
1907: req_id,
1908: hz_utility_v2pub.CREATED_BY,
1909: hz_utility_v2pub.CREATION_DATE,
1910: hz_utility_v2pub.LAST_UPDATED_BY,
1911: hz_utility_v2pub.LAST_UPDATE_DATE,
1912: hz_utility_v2pub.LAST_UPDATE_LOGIN,
1913: 'U'

Line 1910: hz_utility_v2pub.LAST_UPDATED_BY,

1906: new_date,
1907: req_id,
1908: hz_utility_v2pub.CREATED_BY,
1909: hz_utility_v2pub.CREATION_DATE,
1910: hz_utility_v2pub.LAST_UPDATED_BY,
1911: hz_utility_v2pub.LAST_UPDATE_DATE,
1912: hz_utility_v2pub.LAST_UPDATE_LOGIN,
1913: 'U'
1914: ) ;

Line 1911: hz_utility_v2pub.LAST_UPDATE_DATE,

1907: req_id,
1908: hz_utility_v2pub.CREATED_BY,
1909: hz_utility_v2pub.CREATION_DATE,
1910: hz_utility_v2pub.LAST_UPDATED_BY,
1911: hz_utility_v2pub.LAST_UPDATE_DATE,
1912: hz_utility_v2pub.LAST_UPDATE_LOGIN,
1913: 'U'
1914: ) ;
1915:

Line 1912: hz_utility_v2pub.LAST_UPDATE_LOGIN,

1908: hz_utility_v2pub.CREATED_BY,
1909: hz_utility_v2pub.CREATION_DATE,
1910: hz_utility_v2pub.LAST_UPDATED_BY,
1911: hz_utility_v2pub.LAST_UPDATE_DATE,
1912: hz_utility_v2pub.LAST_UPDATE_LOGIN,
1913: 'U'
1914: ) ;
1915:
1916: -- Commented for bug 3786802

Line 1945: hz_utility_v2pub.CREATED_BY,

1941: CUST_RECEIPT_METHOD_ID,
1942: END_DATE,
1943: SYSDATE,
1944: req_id,
1945: hz_utility_v2pub.CREATED_BY,
1946: hz_utility_v2pub.CREATION_DATE,
1947: hz_utility_v2pub.LAST_UPDATED_BY,
1948: hz_utility_v2pub.LAST_UPDATE_DATE,
1949: hz_utility_v2pub.LAST_UPDATE_LOGIN,

Line 1946: hz_utility_v2pub.CREATION_DATE,

1942: END_DATE,
1943: SYSDATE,
1944: req_id,
1945: hz_utility_v2pub.CREATED_BY,
1946: hz_utility_v2pub.CREATION_DATE,
1947: hz_utility_v2pub.LAST_UPDATED_BY,
1948: hz_utility_v2pub.LAST_UPDATE_DATE,
1949: hz_utility_v2pub.LAST_UPDATE_LOGIN,
1950: 'U'

Line 1947: hz_utility_v2pub.LAST_UPDATED_BY,

1943: SYSDATE,
1944: req_id,
1945: hz_utility_v2pub.CREATED_BY,
1946: hz_utility_v2pub.CREATION_DATE,
1947: hz_utility_v2pub.LAST_UPDATED_BY,
1948: hz_utility_v2pub.LAST_UPDATE_DATE,
1949: hz_utility_v2pub.LAST_UPDATE_LOGIN,
1950: 'U'
1951:

Line 1948: hz_utility_v2pub.LAST_UPDATE_DATE,

1944: req_id,
1945: hz_utility_v2pub.CREATED_BY,
1946: hz_utility_v2pub.CREATION_DATE,
1947: hz_utility_v2pub.LAST_UPDATED_BY,
1948: hz_utility_v2pub.LAST_UPDATE_DATE,
1949: hz_utility_v2pub.LAST_UPDATE_LOGIN,
1950: 'U'
1951:
1952: FROM (

Line 1949: hz_utility_v2pub.LAST_UPDATE_LOGIN,

1945: hz_utility_v2pub.CREATED_BY,
1946: hz_utility_v2pub.CREATION_DATE,
1947: hz_utility_v2pub.LAST_UPDATED_BY,
1948: hz_utility_v2pub.LAST_UPDATE_DATE,
1949: hz_utility_v2pub.LAST_UPDATE_LOGIN,
1950: 'U'
1951:
1952: FROM (
1953: SELECT distinct CUSTOMER_MERGE_HEADER_ID,

Line 2026: , last_updated_by=hz_utility_v2pub.user_id--arp_standard.profile.user_id

2022:
2023: UPDATE RA_CUST_RECEIPT_METHODS yt SET
2024: END_DATE = new_date
2025: , LAST_UPDATE_DATE=sysdate
2026: , last_updated_by=hz_utility_v2pub.user_id--arp_standard.profile.user_id
2027: , last_update_login=hz_utility_v2pub.last_update_login--arp_standard.profile.last_update_login
2028: , REQUEST_ID=req_id
2029: , PROGRAM_APPLICATION_ID=hz_utility_v2pub.program_application_id--arp_standard.profile.program_application_id
2030: , PROGRAM_ID=hz_utility_v2pub.program_id--arp_standard.profile.program_id

Line 2027: , last_update_login=hz_utility_v2pub.last_update_login--arp_standard.profile.last_update_login

2023: UPDATE RA_CUST_RECEIPT_METHODS yt SET
2024: END_DATE = new_date
2025: , LAST_UPDATE_DATE=sysdate
2026: , last_updated_by=hz_utility_v2pub.user_id--arp_standard.profile.user_id
2027: , last_update_login=hz_utility_v2pub.last_update_login--arp_standard.profile.last_update_login
2028: , REQUEST_ID=req_id
2029: , PROGRAM_APPLICATION_ID=hz_utility_v2pub.program_application_id--arp_standard.profile.program_application_id
2030: , PROGRAM_ID=hz_utility_v2pub.program_id--arp_standard.profile.program_id
2031: , PROGRAM_UPDATE_DATE=SYSDATE

Line 2029: , PROGRAM_APPLICATION_ID=hz_utility_v2pub.program_application_id--arp_standard.profile.program_application_id

2025: , LAST_UPDATE_DATE=sysdate
2026: , last_updated_by=hz_utility_v2pub.user_id--arp_standard.profile.user_id
2027: , last_update_login=hz_utility_v2pub.last_update_login--arp_standard.profile.last_update_login
2028: , REQUEST_ID=req_id
2029: , PROGRAM_APPLICATION_ID=hz_utility_v2pub.program_application_id--arp_standard.profile.program_application_id
2030: , PROGRAM_ID=hz_utility_v2pub.program_id--arp_standard.profile.program_id
2031: , PROGRAM_UPDATE_DATE=SYSDATE
2032: WHERE CUST_RECEIPT_METHOD_ID = receipt_id(i);
2033:

Line 2030: , PROGRAM_ID=hz_utility_v2pub.program_id--arp_standard.profile.program_id

2026: , last_updated_by=hz_utility_v2pub.user_id--arp_standard.profile.user_id
2027: , last_update_login=hz_utility_v2pub.last_update_login--arp_standard.profile.last_update_login
2028: , REQUEST_ID=req_id
2029: , PROGRAM_APPLICATION_ID=hz_utility_v2pub.program_application_id--arp_standard.profile.program_application_id
2030: , PROGRAM_ID=hz_utility_v2pub.program_id--arp_standard.profile.program_id
2031: , PROGRAM_UPDATE_DATE=SYSDATE
2032: WHERE CUST_RECEIPT_METHOD_ID = receipt_id(i);
2033:
2034: g_count := sql%rowcount;

Line 2482: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

2478: AND m.request_id = req_id
2479: AND m.set_number = set_num
2480: AND m.process_flag = 'N' ),
2481: last_update_date = sysdate,
2482: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2483: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2484: request_id = req_id,
2485: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2486: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

Line 2483: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

2479: AND m.set_number = set_num
2480: AND m.process_flag = 'N' ),
2481: last_update_date = sysdate,
2482: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2483: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2484: request_id = req_id,
2485: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2486: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2487: program_update_date = sysdate

Line 2485: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

2481: last_update_date = sysdate,
2482: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2483: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2484: request_id = req_id,
2485: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2486: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2487: program_update_date = sysdate
2488: WHERE cust_acct_site_id IN (
2489: SELECT m.duplicate_address_id

Line 2486: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

2482: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2483: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2484: request_id = req_id,
2485: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2486: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2487: program_update_date = sysdate
2488: WHERE cust_acct_site_id IN (
2489: SELECT m.duplicate_address_id
2490: FROM ra_customer_merges m

Line 2517: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

2513: AND m.process_flag = 'N'
2514: AND m.set_number = set_num
2515: AND ROWNUM = 1 ),
2516: last_update_date = sysdate,
2517: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2518: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2519: request_id = req_id,
2520: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2521: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

Line 2518: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

2514: AND m.set_number = set_num
2515: AND ROWNUM = 1 ),
2516: last_update_date = sysdate,
2517: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2518: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2519: request_id = req_id,
2520: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2521: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2522: program_update_date = sysdate

Line 2520: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

2516: last_update_date = sysdate,
2517: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2518: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2519: request_id = req_id,
2520: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2521: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2522: program_update_date = sysdate
2523: WHERE cust_account_id IN (
2524: SELECT m.duplicate_id

Line 2521: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

2517: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2518: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2519: request_id = req_id,
2520: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2521: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2522: program_update_date = sysdate
2523: WHERE cust_account_id IN (
2524: SELECT m.duplicate_id
2525: FROM ra_customer_merges m

Line 2669: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

2665: AND m.request_id = req_id
2666: AND m.set_number = set_num
2667: AND m.process_flag = 'N' ),
2668: last_update_date = sysdate,
2669: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2670: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2671: request_id = req_id,
2672: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2673: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

Line 2670: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

2666: AND m.set_number = set_num
2667: AND m.process_flag = 'N' ),
2668: last_update_date = sysdate,
2669: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2670: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2671: request_id = req_id,
2672: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2673: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2674: program_update_date = sysdate

Line 2672: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

2668: last_update_date = sysdate,
2669: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2670: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2671: request_id = req_id,
2672: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2673: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2674: program_update_date = sysdate
2675: WHERE cust_account_site_id IN (
2676: SELECT m.duplicate_address_id

Line 2673: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

2669: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2670: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2671: request_id = req_id,
2672: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2673: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2674: program_update_date = sysdate
2675: WHERE cust_account_site_id IN (
2676: SELECT m.duplicate_address_id
2677: FROM ra_customer_merges m

Line 2701: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

2697: AND m.request_id = req_id
2698: AND m.process_flag = 'N'
2699: AND m.set_number = set_num),
2700: last_update_date = sysdate,
2701: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2702: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2703: request_id = req_id,
2704: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2705: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

Line 2702: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

2698: AND m.process_flag = 'N'
2699: AND m.set_number = set_num),
2700: last_update_date = sysdate,
2701: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2702: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2703: request_id = req_id,
2704: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2705: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2706: program_update_date = sysdate

Line 2704: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

2700: last_update_date = sysdate,
2701: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2702: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2703: request_id = req_id,
2704: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2705: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2706: program_update_date = sysdate
2707: WHERE cust_account_id IN (
2708: SELECT m.duplicate_id

Line 2705: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

2701: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2702: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2703: request_id = req_id,
2704: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2705: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2706: program_update_date = sysdate
2707: WHERE cust_account_id IN (
2708: SELECT m.duplicate_id
2709: FROM ra_customer_merges m

Line 2820: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

2816: SET effective_end_date = trunc(sysdate),
2817: status_flag = 'I',
2818: --Bug No. 4558392
2819: last_update_date=sysdate,
2820: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2821: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2822: request_id = req_id,
2823: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2824: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id

Line 2821: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

2817: status_flag = 'I',
2818: --Bug No. 4558392
2819: last_update_date=sysdate,
2820: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2821: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2822: request_id = req_id,
2823: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2824: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id
2825: --Bug No. 4558392

Line 2823: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

2819: last_update_date=sysdate,
2820: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2821: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2822: request_id = req_id,
2823: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2824: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id
2825: --Bug No. 4558392
2826: WHERE party_usage_code = 'CUSTOMER'
2827: AND nvl(effective_end_date,sysdate+1)>=sysdate

Line 2824: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id

2820: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2821: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2822: request_id = req_id,
2823: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2824: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id
2825: --Bug No. 4558392
2826: WHERE party_usage_code = 'CUSTOMER'
2827: AND nvl(effective_end_date,sysdate+1)>=sysdate
2828: AND status_flag = 'A'

Line 2864: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

2860: SET effective_end_date = trunc(sysdate),
2861: status_flag = 'I',
2862:
2863: last_update_date=sysdate,
2864: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2865: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2866: request_id = req_id,
2867: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2868: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id

Line 2865: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

2861: status_flag = 'I',
2862:
2863: last_update_date=sysdate,
2864: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2865: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2866: request_id = req_id,
2867: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2868: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id
2869:

Line 2867: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

2863: last_update_date=sysdate,
2864: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2865: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2866: request_id = req_id,
2867: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2868: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id
2869:
2870: WHERE party_usage_code = 'CUSTOMER'
2871: AND nvl(effective_end_date,sysdate+1)>=sysdate

Line 2868: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id

2864: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2865: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2866: request_id = req_id,
2867: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2868: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id
2869:
2870: WHERE party_usage_code = 'CUSTOMER'
2871: AND nvl(effective_end_date,sysdate+1)>=sysdate
2872: AND status_flag = 'A'

Line 6446: X_Created_By => hz_utility_v2pub.user_id,--arp_standard.profile.user_id ,

6442: l_Cust_Receipt_Method_Id := null;
6443:
6444: arp_CRM_PKG.Insert_Row(X_Rowid => l_row_id ,
6445: X_Cust_Receipt_Method_Id => l_Cust_Receipt_Method_Id,
6446: X_Created_By => hz_utility_v2pub.user_id,--arp_standard.profile.user_id ,
6447: X_Creation_Date => sysdate,
6448: X_Customer_Id => l_customer_id,
6449: X_Last_Updated_By =>hz_utility_v2pub.user_id,-- arp_standard.profile.user_id,
6450: X_Last_Update_Date => sysdate,

Line 6449: X_Last_Updated_By =>hz_utility_v2pub.user_id,-- arp_standard.profile.user_id,

6445: X_Cust_Receipt_Method_Id => l_Cust_Receipt_Method_Id,
6446: X_Created_By => hz_utility_v2pub.user_id,--arp_standard.profile.user_id ,
6447: X_Creation_Date => sysdate,
6448: X_Customer_Id => l_customer_id,
6449: X_Last_Updated_By =>hz_utility_v2pub.user_id,-- arp_standard.profile.user_id,
6450: X_Last_Update_Date => sysdate,
6451: X_Primary_Flag => merge_from_pay_method_row.Primary_Flag,
6452: X_Receipt_Method_Id => merge_from_pay_method_row.Receipt_Method_Id,
6453: X_Start_Date => merge_from_pay_method_row.Start_Date,

Line 6455: X_Last_Update_Login =>hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

6451: X_Primary_Flag => merge_from_pay_method_row.Primary_Flag,
6452: X_Receipt_Method_Id => merge_from_pay_method_row.Receipt_Method_Id,
6453: X_Start_Date => merge_from_pay_method_row.Start_Date,
6454: X_End_Date => merge_from_pay_method_row.End_Date,
6455: X_Last_Update_Login =>hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6456: X_Site_Use_Id => l_customer_site_id,
6457: X_Attribute_Category => merge_from_pay_method_row.Attribute_Category,
6458: X_Attribute1 => merge_from_pay_method_row.Attribute1,
6459: X_Attribute2 => merge_from_pay_method_row.Attribute2,

Line 6482: last_updated_by =hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

6478: if l_row_id is not null then
6479: update RA_CUST_RECEIPT_METHODS
6480: set
6481: last_update_date = sysdate,
6482: last_updated_by =hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6483: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6484: request_id = req_id,
6485: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6486: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

Line 6483: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

6479: update RA_CUST_RECEIPT_METHODS
6480: set
6481: last_update_date = sysdate,
6482: last_updated_by =hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6483: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6484: request_id = req_id,
6485: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6486: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6487: program_update_date = sysdate

Line 6485: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

6481: last_update_date = sysdate,
6482: last_updated_by =hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6483: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6484: request_id = req_id,
6485: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6486: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6487: program_update_date = sysdate
6488: where rowid = l_row_id;
6489: end if;

Line 6486: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

6482: last_updated_by =hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6483: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6484: request_id = req_id,
6485: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6486: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6487: program_update_date = sysdate
6488: where rowid = l_row_id;
6489: end if;
6490:

Line 6541: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

6537: customer_site_id = nvl(l_customer_site_id,-99),
6538: customer_location = l_customer_location, --bug 4018346 removed nvl condition
6539: customer_site_number = nvl(l_party_site_number,-99), ---bug 3959776 updated customer_site_number
6540: last_update_date = sysdate,
6541: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6542: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6543: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6544: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6545: program_update_date = sysdate

Line 6542: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

6538: customer_location = l_customer_location, --bug 4018346 removed nvl condition
6539: customer_site_number = nvl(l_party_site_number,-99), ---bug 3959776 updated customer_site_number
6540: last_update_date = sysdate,
6541: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6542: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6543: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6544: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6545: program_update_date = sysdate
6546: WHERE duplicate_id = l_duplicate_id

Line 6543: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,

6539: customer_site_number = nvl(l_party_site_number,-99), ---bug 3959776 updated customer_site_number
6540: last_update_date = sysdate,
6541: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6542: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6543: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6544: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6545: program_update_date = sysdate
6546: WHERE duplicate_id = l_duplicate_id
6547: AND duplicate_site_id = l_duplicate_site_id

Line 6544: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

6540: last_update_date = sysdate,
6541: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6542: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6543: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6544: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6545: program_update_date = sysdate
6546: WHERE duplicate_id = l_duplicate_id
6547: AND duplicate_site_id = l_duplicate_site_id
6548: AND customer_id = l_customer_id