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 804: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

909:
910: UPDATE HZ_CUST_ACCT_SITES_ALL yt --SSUptake
911: SET market_flag = null,
912: last_update_date = sysdate,
913: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
914: last_update_login = hz_utility_v2pub.last_update_login,--arp_standard.profile.last_update_login,
915: request_id = req_id,
916: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
917: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

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

910: UPDATE HZ_CUST_ACCT_SITES_ALL yt --SSUptake
911: SET market_flag = null,
912: last_update_date = sysdate,
913: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
914: last_update_login = hz_utility_v2pub.last_update_login,--arp_standard.profile.last_update_login,
915: request_id = req_id,
916: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
917: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
918: program_update_date = sysdate

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

912: last_update_date = sysdate,
913: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
914: last_update_login = hz_utility_v2pub.last_update_login,--arp_standard.profile.last_update_login,
915: request_id = req_id,
916: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
917: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
918: program_update_date = sysdate
919: WHERE EXISTS (
920: SELECT 'Y'

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

913: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
914: last_update_login = hz_utility_v2pub.last_update_login,--arp_standard.profile.last_update_login,
915: request_id = req_id,
916: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
917: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
918: program_update_date = sysdate
919: WHERE EXISTS (
920: SELECT 'Y'
921: FROM ra_customer_merges m

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

1251:
1252: UPDATE HZ_CUST_ACCOUNTS yt
1253: SET status = 'I',
1254: last_update_date = sysdate,
1255: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
1256: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
1257: request_id = req_id,
1258: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
1259: program_id = hz_utility_v2pub.program_id,--arp_standard.profile.program_id,

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

1252: UPDATE HZ_CUST_ACCOUNTS yt
1253: SET status = 'I',
1254: last_update_date = sysdate,
1255: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
1256: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
1257: request_id = req_id,
1258: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
1259: program_id = hz_utility_v2pub.program_id,--arp_standard.profile.program_id,
1260: program_update_date = sysdate

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

1254: last_update_date = sysdate,
1255: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
1256: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
1257: request_id = req_id,
1258: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
1259: program_id = hz_utility_v2pub.program_id,--arp_standard.profile.program_id,
1260: program_update_date = sysdate
1261: WHERE cust_account_id IN (
1262: SELECT m.duplicate_id

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

1255: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
1256: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
1257: request_id = req_id,
1258: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
1259: program_id = hz_utility_v2pub.program_id,--arp_standard.profile.program_id,
1260: program_update_date = sysdate
1261: WHERE cust_account_id IN (
1262: SELECT m.duplicate_id
1263: FROM ra_customer_merges m

Line 1570: last_updated_by = hz_utility_v2pub.user_id,

1566: --Inactivate the from account relationship
1567: UPDATE hz_cust_acct_relate_all yt SET
1568: status = 'I',
1569: last_update_date = sysdate,
1570: last_updated_by = hz_utility_v2pub.user_id,
1571: last_update_login = hz_utility_v2pub.last_update_login,
1572: request_id = req_id,
1573: program_application_id = hz_utility_v2pub.program_application_id,
1574: program_id = hz_utility_v2pub.program_id,

Line 1571: last_update_login = hz_utility_v2pub.last_update_login,

1567: UPDATE hz_cust_acct_relate_all yt SET
1568: status = 'I',
1569: last_update_date = sysdate,
1570: last_updated_by = hz_utility_v2pub.user_id,
1571: last_update_login = hz_utility_v2pub.last_update_login,
1572: request_id = req_id,
1573: program_application_id = hz_utility_v2pub.program_application_id,
1574: program_id = hz_utility_v2pub.program_id,
1575: program_update_date = sysdate

Line 1573: program_application_id = hz_utility_v2pub.program_application_id,

1569: last_update_date = sysdate,
1570: last_updated_by = hz_utility_v2pub.user_id,
1571: last_update_login = hz_utility_v2pub.last_update_login,
1572: request_id = req_id,
1573: program_application_id = hz_utility_v2pub.program_application_id,
1574: program_id = hz_utility_v2pub.program_id,
1575: program_update_date = sysdate
1576: WHERE status = 'A'
1577: AND yt.cust_account_id = from_rec.cust_account_id

Line 1574: program_id = hz_utility_v2pub.program_id,

1570: last_updated_by = hz_utility_v2pub.user_id,
1571: last_update_login = hz_utility_v2pub.last_update_login,
1572: request_id = req_id,
1573: program_application_id = hz_utility_v2pub.program_application_id,
1574: program_id = hz_utility_v2pub.program_id,
1575: program_update_date = sysdate
1576: WHERE status = 'A'
1577: AND yt.cust_account_id = from_rec.cust_account_id
1578: AND yt.related_cust_account_id = from_rec.related_cust_account_id

Line 1632: last_updated_by =hz_utility_v2pub.user_id,

1628: --Inactivate the from account relationships
1629: UPDATE hz_cust_acct_relate_all yt SET
1630: status = 'I',
1631: last_update_date = sysdate,
1632: last_updated_by =hz_utility_v2pub.user_id,
1633: last_update_login = hz_utility_v2pub.last_update_login,
1634: request_id = req_id,
1635: program_application_id =hz_utility_v2pub.program_application_id,
1636: program_id = hz_utility_v2pub.program_id,

Line 1633: last_update_login = hz_utility_v2pub.last_update_login,

1629: UPDATE hz_cust_acct_relate_all yt SET
1630: status = 'I',
1631: last_update_date = sysdate,
1632: last_updated_by =hz_utility_v2pub.user_id,
1633: last_update_login = hz_utility_v2pub.last_update_login,
1634: request_id = req_id,
1635: program_application_id =hz_utility_v2pub.program_application_id,
1636: program_id = hz_utility_v2pub.program_id,
1637: program_update_date = sysdate

Line 1635: program_application_id =hz_utility_v2pub.program_application_id,

1631: last_update_date = sysdate,
1632: last_updated_by =hz_utility_v2pub.user_id,
1633: last_update_login = hz_utility_v2pub.last_update_login,
1634: request_id = req_id,
1635: program_application_id =hz_utility_v2pub.program_application_id,
1636: program_id = hz_utility_v2pub.program_id,
1637: program_update_date = sysdate
1638: WHERE status = 'A'
1639: AND yt.cust_account_id = from_rec.cust_account_id

Line 1636: program_id = hz_utility_v2pub.program_id,

1632: last_updated_by =hz_utility_v2pub.user_id,
1633: last_update_login = hz_utility_v2pub.last_update_login,
1634: request_id = req_id,
1635: program_application_id =hz_utility_v2pub.program_application_id,
1636: program_id = hz_utility_v2pub.program_id,
1637: program_update_date = sysdate
1638: WHERE status = 'A'
1639: AND yt.cust_account_id = from_rec.cust_account_id
1640: AND yt.related_cust_account_id = from_rec.related_cust_account_id

Line 1686: LAST_UPDATED_BY = hz_utility_v2pub.user_id ,

1682:
1683: UPDATE HZ_CUST_ACCT_RELATE_ALL YT
1684: SET STATUS = 'I',
1685: LAST_UPDATE_DATE = SYSDATE,
1686: LAST_UPDATED_BY = hz_utility_v2pub.user_id ,
1687: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login ,
1688: REQUEST_ID = req_id,
1689: PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id ,
1690: PROGRAM_ID = hz_utility_v2pub.program_id ,

Line 1687: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login ,

1683: UPDATE HZ_CUST_ACCT_RELATE_ALL YT
1684: SET STATUS = 'I',
1685: LAST_UPDATE_DATE = SYSDATE,
1686: LAST_UPDATED_BY = hz_utility_v2pub.user_id ,
1687: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login ,
1688: REQUEST_ID = req_id,
1689: PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id ,
1690: PROGRAM_ID = hz_utility_v2pub.program_id ,
1691: PROGRAM_UPDATE_DATE = SYSDATE

Line 1689: PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id ,

1685: LAST_UPDATE_DATE = SYSDATE,
1686: LAST_UPDATED_BY = hz_utility_v2pub.user_id ,
1687: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login ,
1688: REQUEST_ID = req_id,
1689: PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id ,
1690: PROGRAM_ID = hz_utility_v2pub.program_id ,
1691: PROGRAM_UPDATE_DATE = SYSDATE
1692: WHERE (RELATED_CUST_ACCOUNT_ID,CUST_ACCOUNT_ID,ORG_ID ) IN
1693: (SELECT CUSTOMER_ID,

Line 1690: PROGRAM_ID = hz_utility_v2pub.program_id ,

1686: LAST_UPDATED_BY = hz_utility_v2pub.user_id ,
1687: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login ,
1688: REQUEST_ID = req_id,
1689: PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id ,
1690: PROGRAM_ID = hz_utility_v2pub.program_id ,
1691: PROGRAM_UPDATE_DATE = SYSDATE
1692: WHERE (RELATED_CUST_ACCOUNT_ID,CUST_ACCOUNT_ID,ORG_ID ) IN
1693: (SELECT CUSTOMER_ID,
1694: DUPLICATE_ID,

Line 1707: LAST_UPDATED_BY = hz_utility_v2pub.user_id ,

1703:
1704: UPDATE HZ_CUST_ACCT_RELATE_ALL YT
1705: SET STATUS = 'I',
1706: LAST_UPDATE_DATE = SYSDATE,
1707: LAST_UPDATED_BY = hz_utility_v2pub.user_id ,
1708: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login ,
1709: REQUEST_ID = req_id,
1710: PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id ,
1711: PROGRAM_ID = hz_utility_v2pub.program_id ,

Line 1708: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login ,

1704: UPDATE HZ_CUST_ACCT_RELATE_ALL YT
1705: SET STATUS = 'I',
1706: LAST_UPDATE_DATE = SYSDATE,
1707: LAST_UPDATED_BY = hz_utility_v2pub.user_id ,
1708: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login ,
1709: REQUEST_ID = req_id,
1710: PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id ,
1711: PROGRAM_ID = hz_utility_v2pub.program_id ,
1712: PROGRAM_UPDATE_DATE = SYSDATE

Line 1710: PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id ,

1706: LAST_UPDATE_DATE = SYSDATE,
1707: LAST_UPDATED_BY = hz_utility_v2pub.user_id ,
1708: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login ,
1709: REQUEST_ID = req_id,
1710: PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id ,
1711: PROGRAM_ID = hz_utility_v2pub.program_id ,
1712: PROGRAM_UPDATE_DATE = SYSDATE
1713: WHERE (CUST_ACCOUNT_ID,RELATED_CUST_ACCOUNT_ID,ORG_ID ) IN
1714: (SELECT CUSTOMER_ID,

Line 1711: PROGRAM_ID = hz_utility_v2pub.program_id ,

1707: LAST_UPDATED_BY = hz_utility_v2pub.user_id ,
1708: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login ,
1709: REQUEST_ID = req_id,
1710: PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id ,
1711: PROGRAM_ID = hz_utility_v2pub.program_id ,
1712: PROGRAM_UPDATE_DATE = SYSDATE
1713: WHERE (CUST_ACCOUNT_ID,RELATED_CUST_ACCOUNT_ID,ORG_ID ) IN
1714: (SELECT CUSTOMER_ID,
1715: DUPLICATE_ID,

Line 2043: hz_utility_v2pub.CREATED_BY,

2039: receipt_id(i),
2040: end_date(i),
2041: new_date,
2042: req_id,
2043: hz_utility_v2pub.CREATED_BY,
2044: hz_utility_v2pub.CREATION_DATE,
2045: hz_utility_v2pub.LAST_UPDATED_BY,
2046: hz_utility_v2pub.LAST_UPDATE_DATE,
2047: hz_utility_v2pub.LAST_UPDATE_LOGIN,

Line 2044: hz_utility_v2pub.CREATION_DATE,

2040: end_date(i),
2041: new_date,
2042: req_id,
2043: hz_utility_v2pub.CREATED_BY,
2044: hz_utility_v2pub.CREATION_DATE,
2045: hz_utility_v2pub.LAST_UPDATED_BY,
2046: hz_utility_v2pub.LAST_UPDATE_DATE,
2047: hz_utility_v2pub.LAST_UPDATE_LOGIN,
2048: 'U'

Line 2045: hz_utility_v2pub.LAST_UPDATED_BY,

2041: new_date,
2042: req_id,
2043: hz_utility_v2pub.CREATED_BY,
2044: hz_utility_v2pub.CREATION_DATE,
2045: hz_utility_v2pub.LAST_UPDATED_BY,
2046: hz_utility_v2pub.LAST_UPDATE_DATE,
2047: hz_utility_v2pub.LAST_UPDATE_LOGIN,
2048: 'U'
2049: ) ;

Line 2046: hz_utility_v2pub.LAST_UPDATE_DATE,

2042: req_id,
2043: hz_utility_v2pub.CREATED_BY,
2044: hz_utility_v2pub.CREATION_DATE,
2045: hz_utility_v2pub.LAST_UPDATED_BY,
2046: hz_utility_v2pub.LAST_UPDATE_DATE,
2047: hz_utility_v2pub.LAST_UPDATE_LOGIN,
2048: 'U'
2049: ) ;
2050:

Line 2047: hz_utility_v2pub.LAST_UPDATE_LOGIN,

2043: hz_utility_v2pub.CREATED_BY,
2044: hz_utility_v2pub.CREATION_DATE,
2045: hz_utility_v2pub.LAST_UPDATED_BY,
2046: hz_utility_v2pub.LAST_UPDATE_DATE,
2047: hz_utility_v2pub.LAST_UPDATE_LOGIN,
2048: 'U'
2049: ) ;
2050:
2051: -- Commented for bug 3786802

Line 2080: hz_utility_v2pub.CREATED_BY,

2076: CUST_RECEIPT_METHOD_ID,
2077: END_DATE,
2078: SYSDATE,
2079: req_id,
2080: hz_utility_v2pub.CREATED_BY,
2081: hz_utility_v2pub.CREATION_DATE,
2082: hz_utility_v2pub.LAST_UPDATED_BY,
2083: hz_utility_v2pub.LAST_UPDATE_DATE,
2084: hz_utility_v2pub.LAST_UPDATE_LOGIN,

Line 2081: hz_utility_v2pub.CREATION_DATE,

2077: END_DATE,
2078: SYSDATE,
2079: req_id,
2080: hz_utility_v2pub.CREATED_BY,
2081: hz_utility_v2pub.CREATION_DATE,
2082: hz_utility_v2pub.LAST_UPDATED_BY,
2083: hz_utility_v2pub.LAST_UPDATE_DATE,
2084: hz_utility_v2pub.LAST_UPDATE_LOGIN,
2085: 'U'

Line 2082: hz_utility_v2pub.LAST_UPDATED_BY,

2078: SYSDATE,
2079: req_id,
2080: hz_utility_v2pub.CREATED_BY,
2081: hz_utility_v2pub.CREATION_DATE,
2082: hz_utility_v2pub.LAST_UPDATED_BY,
2083: hz_utility_v2pub.LAST_UPDATE_DATE,
2084: hz_utility_v2pub.LAST_UPDATE_LOGIN,
2085: 'U'
2086:

Line 2083: hz_utility_v2pub.LAST_UPDATE_DATE,

2079: req_id,
2080: hz_utility_v2pub.CREATED_BY,
2081: hz_utility_v2pub.CREATION_DATE,
2082: hz_utility_v2pub.LAST_UPDATED_BY,
2083: hz_utility_v2pub.LAST_UPDATE_DATE,
2084: hz_utility_v2pub.LAST_UPDATE_LOGIN,
2085: 'U'
2086:
2087: FROM (

Line 2084: hz_utility_v2pub.LAST_UPDATE_LOGIN,

2080: hz_utility_v2pub.CREATED_BY,
2081: hz_utility_v2pub.CREATION_DATE,
2082: hz_utility_v2pub.LAST_UPDATED_BY,
2083: hz_utility_v2pub.LAST_UPDATE_DATE,
2084: hz_utility_v2pub.LAST_UPDATE_LOGIN,
2085: 'U'
2086:
2087: FROM (
2088: SELECT distinct CUSTOMER_MERGE_HEADER_ID,

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

2157:
2158: UPDATE RA_CUST_RECEIPT_METHODS yt SET
2159: END_DATE = new_date
2160: , LAST_UPDATE_DATE=sysdate
2161: , last_updated_by=hz_utility_v2pub.user_id--arp_standard.profile.user_id
2162: , last_update_login=hz_utility_v2pub.last_update_login--arp_standard.profile.last_update_login
2163: , REQUEST_ID=req_id
2164: , PROGRAM_APPLICATION_ID=hz_utility_v2pub.program_application_id--arp_standard.profile.program_application_id
2165: , PROGRAM_ID=hz_utility_v2pub.program_id--arp_standard.profile.program_id

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

2158: UPDATE RA_CUST_RECEIPT_METHODS yt SET
2159: END_DATE = new_date
2160: , LAST_UPDATE_DATE=sysdate
2161: , last_updated_by=hz_utility_v2pub.user_id--arp_standard.profile.user_id
2162: , last_update_login=hz_utility_v2pub.last_update_login--arp_standard.profile.last_update_login
2163: , REQUEST_ID=req_id
2164: , PROGRAM_APPLICATION_ID=hz_utility_v2pub.program_application_id--arp_standard.profile.program_application_id
2165: , PROGRAM_ID=hz_utility_v2pub.program_id--arp_standard.profile.program_id
2166: , PROGRAM_UPDATE_DATE=SYSDATE

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

2160: , LAST_UPDATE_DATE=sysdate
2161: , last_updated_by=hz_utility_v2pub.user_id--arp_standard.profile.user_id
2162: , last_update_login=hz_utility_v2pub.last_update_login--arp_standard.profile.last_update_login
2163: , REQUEST_ID=req_id
2164: , PROGRAM_APPLICATION_ID=hz_utility_v2pub.program_application_id--arp_standard.profile.program_application_id
2165: , PROGRAM_ID=hz_utility_v2pub.program_id--arp_standard.profile.program_id
2166: , PROGRAM_UPDATE_DATE=SYSDATE
2167: WHERE CUST_RECEIPT_METHOD_ID = receipt_id(i);
2168:

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

2161: , last_updated_by=hz_utility_v2pub.user_id--arp_standard.profile.user_id
2162: , last_update_login=hz_utility_v2pub.last_update_login--arp_standard.profile.last_update_login
2163: , REQUEST_ID=req_id
2164: , PROGRAM_APPLICATION_ID=hz_utility_v2pub.program_application_id--arp_standard.profile.program_application_id
2165: , PROGRAM_ID=hz_utility_v2pub.program_id--arp_standard.profile.program_id
2166: , PROGRAM_UPDATE_DATE=SYSDATE
2167: WHERE CUST_RECEIPT_METHOD_ID = receipt_id(i);
2168:
2169: g_count := sql%rowcount;

Line 2630: last_updated_by = hz_utility_v2pub.user_id,

2626: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_ACCOUNT_ROLES', FALSE );
2627: UPDATE HZ_CUST_ACCOUNT_ROLES yt
2628: SET status = 'I',
2629: last_update_date = sysdate,
2630: last_updated_by = hz_utility_v2pub.user_id,
2631: last_update_login = hz_utility_v2pub.last_update_login,
2632: request_id = req_id,
2633: program_application_id = hz_utility_v2pub.program_application_id,
2634: program_id = hz_utility_v2pub.program_id,

Line 2631: last_update_login = hz_utility_v2pub.last_update_login,

2627: UPDATE HZ_CUST_ACCOUNT_ROLES yt
2628: SET status = 'I',
2629: last_update_date = sysdate,
2630: last_updated_by = hz_utility_v2pub.user_id,
2631: last_update_login = hz_utility_v2pub.last_update_login,
2632: request_id = req_id,
2633: program_application_id = hz_utility_v2pub.program_application_id,
2634: program_id = hz_utility_v2pub.program_id,
2635: program_update_date = sysdate

Line 2633: program_application_id = hz_utility_v2pub.program_application_id,

2629: last_update_date = sysdate,
2630: last_updated_by = hz_utility_v2pub.user_id,
2631: last_update_login = hz_utility_v2pub.last_update_login,
2632: request_id = req_id,
2633: program_application_id = hz_utility_v2pub.program_application_id,
2634: program_id = hz_utility_v2pub.program_id,
2635: program_update_date = sysdate
2636: WHERE party_id = l_party_id
2637: AND nvl(status,'A') ='A';

Line 2634: program_id = hz_utility_v2pub.program_id,

2630: last_updated_by = hz_utility_v2pub.user_id,
2631: last_update_login = hz_utility_v2pub.last_update_login,
2632: request_id = req_id,
2633: program_application_id = hz_utility_v2pub.program_application_id,
2634: program_id = hz_utility_v2pub.program_id,
2635: program_update_date = sysdate
2636: WHERE party_id = l_party_id
2637: AND nvl(status,'A') ='A';
2638:

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

2661: AND m.request_id = req_id
2662: AND m.set_number = set_num
2663: AND m.process_flag = 'N' ),
2664: last_update_date = sysdate,
2665: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2666: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2667: request_id = req_id,
2668: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2669: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

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

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

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

2664: last_update_date = sysdate,
2665: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2666: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2667: request_id = req_id,
2668: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2669: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2670: program_update_date = sysdate
2671: WHERE cust_acct_site_id IN (
2672: SELECT m.duplicate_address_id

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

2665: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2666: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2667: request_id = req_id,
2668: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2669: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2670: program_update_date = sysdate
2671: WHERE cust_acct_site_id IN (
2672: SELECT m.duplicate_address_id
2673: FROM ra_customer_merges m

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

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

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

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

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

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

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

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

Line 2754: last_updated_by = hz_utility_v2pub.user_id,

2750: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_ACCOUNT_ROLES', FALSE );
2751: UPDATE HZ_CUST_ACCOUNT_ROLES yt
2752: SET status = 'I',
2753: last_update_date = sysdate,
2754: last_updated_by = hz_utility_v2pub.user_id,
2755: last_update_login = hz_utility_v2pub.last_update_login,
2756: request_id = req_id,
2757: program_application_id = hz_utility_v2pub.program_application_id,
2758: program_id = hz_utility_v2pub.program_id,

Line 2755: last_update_login = hz_utility_v2pub.last_update_login,

2751: UPDATE HZ_CUST_ACCOUNT_ROLES yt
2752: SET status = 'I',
2753: last_update_date = sysdate,
2754: last_updated_by = hz_utility_v2pub.user_id,
2755: last_update_login = hz_utility_v2pub.last_update_login,
2756: request_id = req_id,
2757: program_application_id = hz_utility_v2pub.program_application_id,
2758: program_id = hz_utility_v2pub.program_id,
2759: program_update_date = sysdate

Line 2757: program_application_id = hz_utility_v2pub.program_application_id,

2753: last_update_date = sysdate,
2754: last_updated_by = hz_utility_v2pub.user_id,
2755: last_update_login = hz_utility_v2pub.last_update_login,
2756: request_id = req_id,
2757: program_application_id = hz_utility_v2pub.program_application_id,
2758: program_id = hz_utility_v2pub.program_id,
2759: program_update_date = sysdate
2760: WHERE party_id = l_party_id
2761: AND nvl(status,'A') ='A';

Line 2758: program_id = hz_utility_v2pub.program_id,

2754: last_updated_by = hz_utility_v2pub.user_id,
2755: last_update_login = hz_utility_v2pub.last_update_login,
2756: request_id = req_id,
2757: program_application_id = hz_utility_v2pub.program_application_id,
2758: program_id = hz_utility_v2pub.program_id,
2759: program_update_date = sysdate
2760: WHERE party_id = l_party_id
2761: AND nvl(status,'A') ='A';
2762:

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

2784: AND m.request_id = req_id
2785: AND m.set_number = set_num
2786: AND m.process_flag = 'N' ),
2787: last_update_date = sysdate,
2788: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2789: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2790: request_id = req_id,
2791: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2792: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

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

2785: AND m.set_number = set_num
2786: AND m.process_flag = 'N' ),
2787: last_update_date = sysdate,
2788: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2789: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2790: request_id = req_id,
2791: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2792: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2793: program_update_date = sysdate

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

2787: last_update_date = sysdate,
2788: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2789: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2790: request_id = req_id,
2791: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2792: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2793: program_update_date = sysdate
2794: WHERE cust_acct_site_id IN (
2795: SELECT m.duplicate_address_id

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

2788: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2789: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2790: request_id = req_id,
2791: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2792: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2793: program_update_date = sysdate
2794: WHERE cust_acct_site_id IN (
2795: SELECT m.duplicate_address_id
2796: FROM ra_customer_merges m

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

2819: AND m.process_flag = 'N'
2820: AND m.set_number = set_num
2821: AND ROWNUM = 1 ),
2822: last_update_date = sysdate,
2823: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2824: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2825: request_id = req_id,
2826: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2827: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

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

2820: AND m.set_number = set_num
2821: AND ROWNUM = 1 ),
2822: last_update_date = sysdate,
2823: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2824: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2825: request_id = req_id,
2826: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2827: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2828: program_update_date = sysdate

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

2822: last_update_date = sysdate,
2823: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2824: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2825: request_id = req_id,
2826: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2827: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2828: program_update_date = sysdate
2829: WHERE cust_account_id IN (
2830: SELECT m.duplicate_id

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

2823: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2824: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2825: request_id = req_id,
2826: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2827: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2828: program_update_date = sysdate
2829: WHERE cust_account_id IN (
2830: SELECT m.duplicate_id
2831: FROM ra_customer_merges m, hz_cust_accounts c

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

2973: AND m.request_id = req_id
2974: AND m.set_number = set_num
2975: AND m.process_flag = 'N' ),
2976: last_update_date = sysdate,
2977: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2978: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2979: request_id = req_id,
2980: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2981: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

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

2974: AND m.set_number = set_num
2975: AND m.process_flag = 'N' ),
2976: last_update_date = sysdate,
2977: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2978: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2979: request_id = req_id,
2980: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2981: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2982: program_update_date = sysdate

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

2976: last_update_date = sysdate,
2977: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2978: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2979: request_id = req_id,
2980: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2981: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2982: program_update_date = sysdate
2983: WHERE cust_account_site_id IN (
2984: SELECT m.duplicate_address_id

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

2977: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
2978: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
2979: request_id = req_id,
2980: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
2981: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2982: program_update_date = sysdate
2983: WHERE cust_account_site_id IN (
2984: SELECT m.duplicate_address_id
2985: FROM ra_customer_merges m

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

3005: AND m.request_id = req_id
3006: AND m.process_flag = 'N'
3007: AND m.set_number = set_num),
3008: last_update_date = sysdate,
3009: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
3010: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
3011: request_id = req_id,
3012: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
3013: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

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

3006: AND m.process_flag = 'N'
3007: AND m.set_number = set_num),
3008: last_update_date = sysdate,
3009: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
3010: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
3011: request_id = req_id,
3012: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
3013: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
3014: program_update_date = sysdate

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

3008: last_update_date = sysdate,
3009: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
3010: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
3011: request_id = req_id,
3012: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
3013: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
3014: program_update_date = sysdate
3015: WHERE cust_account_id IN (
3016: SELECT m.duplicate_id

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

3009: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
3010: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
3011: request_id = req_id,
3012: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
3013: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
3014: program_update_date = sysdate
3015: WHERE cust_account_id IN (
3016: SELECT m.duplicate_id
3017: FROM ra_customer_merges m

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

3124: SET effective_end_date = trunc(sysdate),
3125: status_flag = 'I',
3126: --Bug No. 4558392
3127: last_update_date=sysdate,
3128: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
3129: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
3130: request_id = req_id,
3131: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
3132: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id

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

3125: status_flag = 'I',
3126: --Bug No. 4558392
3127: last_update_date=sysdate,
3128: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
3129: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
3130: request_id = req_id,
3131: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
3132: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id
3133: --Bug No. 4558392

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

3127: last_update_date=sysdate,
3128: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
3129: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
3130: request_id = req_id,
3131: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
3132: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id
3133: --Bug No. 4558392
3134: WHERE party_usage_code = 'CUSTOMER'
3135: AND nvl(effective_end_date,sysdate+1)>=sysdate

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

3128: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
3129: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
3130: request_id = req_id,
3131: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
3132: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id
3133: --Bug No. 4558392
3134: WHERE party_usage_code = 'CUSTOMER'
3135: AND nvl(effective_end_date,sysdate+1)>=sysdate
3136: AND status_flag = 'A'

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

3168: SET effective_end_date = trunc(sysdate),
3169: status_flag = 'I',
3170:
3171: last_update_date=sysdate,
3172: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
3173: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
3174: request_id = req_id,
3175: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
3176: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id

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

3169: status_flag = 'I',
3170:
3171: last_update_date=sysdate,
3172: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
3173: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
3174: request_id = req_id,
3175: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
3176: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id
3177:

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

3171: last_update_date=sysdate,
3172: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
3173: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
3174: request_id = req_id,
3175: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
3176: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id
3177:
3178: WHERE party_usage_code = 'CUSTOMER'
3179: AND nvl(effective_end_date,sysdate+1)>=sysdate

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

3172: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
3173: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
3174: request_id = req_id,
3175: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
3176: program_id =hz_utility_v2pub.program_id-- arp_standard.profile.program_id
3177:
3178: WHERE party_usage_code = 'CUSTOMER'
3179: AND nvl(effective_end_date,sysdate+1)>=sysdate
3180: AND status_flag = 'A'

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

6777: l_Cust_Receipt_Method_Id := null;
6778:
6779: arp_CRM_PKG.Insert_Row(X_Rowid => l_row_id ,
6780: X_Cust_Receipt_Method_Id => l_Cust_Receipt_Method_Id,
6781: X_Created_By => hz_utility_v2pub.user_id,--arp_standard.profile.user_id ,
6782: X_Creation_Date => sysdate,
6783: X_Customer_Id => l_customer_id,
6784: X_Last_Updated_By =>hz_utility_v2pub.user_id,-- arp_standard.profile.user_id,
6785: X_Last_Update_Date => sysdate,

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

6780: X_Cust_Receipt_Method_Id => l_Cust_Receipt_Method_Id,
6781: X_Created_By => hz_utility_v2pub.user_id,--arp_standard.profile.user_id ,
6782: X_Creation_Date => sysdate,
6783: X_Customer_Id => l_customer_id,
6784: X_Last_Updated_By =>hz_utility_v2pub.user_id,-- arp_standard.profile.user_id,
6785: X_Last_Update_Date => sysdate,
6786: X_Primary_Flag => merge_from_pay_method_row.Primary_Flag,
6787: X_Receipt_Method_Id => merge_from_pay_method_row.Receipt_Method_Id,
6788: X_Start_Date => merge_from_pay_method_row.Start_Date,

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

6786: X_Primary_Flag => merge_from_pay_method_row.Primary_Flag,
6787: X_Receipt_Method_Id => merge_from_pay_method_row.Receipt_Method_Id,
6788: X_Start_Date => merge_from_pay_method_row.Start_Date,
6789: X_End_Date => merge_from_pay_method_row.End_Date,
6790: X_Last_Update_Login =>hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6791: X_Site_Use_Id => l_customer_site_id,
6792: X_Attribute_Category => merge_from_pay_method_row.Attribute_Category,
6793: X_Attribute1 => merge_from_pay_method_row.Attribute1,
6794: X_Attribute2 => merge_from_pay_method_row.Attribute2,

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

6813: if l_row_id is not null then
6814: update RA_CUST_RECEIPT_METHODS
6815: set
6816: last_update_date = sysdate,
6817: last_updated_by =hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6818: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6819: request_id = req_id,
6820: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6821: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,

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

6814: update RA_CUST_RECEIPT_METHODS
6815: set
6816: last_update_date = sysdate,
6817: last_updated_by =hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6818: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6819: request_id = req_id,
6820: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6821: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6822: program_update_date = sysdate

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

6816: last_update_date = sysdate,
6817: last_updated_by =hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6818: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6819: request_id = req_id,
6820: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6821: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6822: program_update_date = sysdate
6823: where rowid = l_row_id;
6824: end if;

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

6817: last_updated_by =hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6818: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6819: request_id = req_id,
6820: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6821: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6822: program_update_date = sysdate
6823: where rowid = l_row_id;
6824: end if;
6825:

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

6874: customer_site_id = nvl(l_customer_site_id,-99),
6875: customer_location = l_customer_location, --bug 4018346 removed nvl condition
6876: customer_site_number = nvl(l_party_site_number,-99), ---bug 3959776 updated customer_site_number
6877: last_update_date = sysdate,
6878: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6879: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6880: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6881: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6882: program_update_date = sysdate

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

6875: customer_location = l_customer_location, --bug 4018346 removed nvl condition
6876: customer_site_number = nvl(l_party_site_number,-99), ---bug 3959776 updated customer_site_number
6877: last_update_date = sysdate,
6878: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6879: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6880: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6881: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6882: program_update_date = sysdate
6883: WHERE duplicate_id = l_duplicate_id

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

6876: customer_site_number = nvl(l_party_site_number,-99), ---bug 3959776 updated customer_site_number
6877: last_update_date = sysdate,
6878: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6879: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6880: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6881: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6882: program_update_date = sysdate
6883: WHERE duplicate_id = l_duplicate_id
6884: AND duplicate_site_id = l_duplicate_site_id

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

6877: last_update_date = sysdate,
6878: last_updated_by = hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6879: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,
6880: program_application_id =hz_utility_v2pub.program_application_id,-- arp_standard.profile.program_application_id,
6881: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
6882: program_update_date = sysdate
6883: WHERE duplicate_id = l_duplicate_id
6884: AND duplicate_site_id = l_duplicate_site_id
6885: AND duplicate_address_id = l_duplicate_address_id -- bug 7851438

Line 8351: p_cust_acct_relate_rec.application_id := hz_utility_v2pub.program_application_id;

8347: ELSE
8348: p_cust_acct_relate_rec.cust_account_id := p_customer_id;
8349: END IF;
8350: p_cust_acct_relate_rec.created_by_module := 'HZ_TCA_CUSTOMER_MERGE';
8351: p_cust_acct_relate_rec.application_id := hz_utility_v2pub.program_application_id;
8352: l_cust_acct_relate_id := NULL;
8353: -- Call table-handler.
8354: HZ_CUST_ACCT_RELATE_PKG.Insert_Row (
8355: X_CUST_ACCOUNT_ID => p_cust_acct_relate_rec.cust_account_id,