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 STANDARD

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

497:
498: UPDATE HZ_CUST_SITE_USES su1
499: SET status = 'I',
500: last_update_date = sysdate,
501: last_updated_by = arp_standard.profile.user_id,
502: last_update_login = arp_standard.profile.last_update_login,
503: request_id = req_id,
504: program_application_id = arp_standard.profile.program_application_id,
505: program_id = arp_standard.profile.program_id,

Line 502: last_update_login = arp_standard.profile.last_update_login,

498: UPDATE HZ_CUST_SITE_USES su1
499: SET status = 'I',
500: last_update_date = sysdate,
501: last_updated_by = arp_standard.profile.user_id,
502: last_update_login = arp_standard.profile.last_update_login,
503: request_id = req_id,
504: program_application_id = arp_standard.profile.program_application_id,
505: program_id = arp_standard.profile.program_id,
506: program_update_date = sysdate

Line 504: program_application_id = arp_standard.profile.program_application_id,

500: last_update_date = sysdate,
501: last_updated_by = arp_standard.profile.user_id,
502: last_update_login = arp_standard.profile.last_update_login,
503: request_id = req_id,
504: program_application_id = arp_standard.profile.program_application_id,
505: program_id = arp_standard.profile.program_id,
506: program_update_date = sysdate
507: WHERE cust_acct_site_id IN (
508: SELECT m.duplicate_address_id

Line 505: program_id = arp_standard.profile.program_id,

501: last_updated_by = arp_standard.profile.user_id,
502: last_update_login = arp_standard.profile.last_update_login,
503: request_id = req_id,
504: program_application_id = arp_standard.profile.program_application_id,
505: program_id = arp_standard.profile.program_id,
506: program_update_date = sysdate
507: WHERE cust_acct_site_id IN (
508: SELECT m.duplicate_address_id
509: 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 1435: last_updated_by = arp_standard.profile.user_id,

1431: --Inactivate the from account relationship
1432: UPDATE hz_cust_acct_relate_all yt SET
1433: status = 'I',
1434: last_update_date = sysdate,
1435: last_updated_by = arp_standard.profile.user_id,
1436: last_update_login = arp_standard.profile.last_update_login,
1437: request_id = req_id,
1438: program_application_id =arp_standard.profile.program_application_id,
1439: program_id = arp_standard.profile.program_id,

Line 1436: last_update_login = arp_standard.profile.last_update_login,

1432: UPDATE hz_cust_acct_relate_all yt SET
1433: status = 'I',
1434: last_update_date = sysdate,
1435: last_updated_by = arp_standard.profile.user_id,
1436: last_update_login = arp_standard.profile.last_update_login,
1437: request_id = req_id,
1438: program_application_id =arp_standard.profile.program_application_id,
1439: program_id = arp_standard.profile.program_id,
1440: program_update_date = sysdate

Line 1438: program_application_id =arp_standard.profile.program_application_id,

1434: last_update_date = sysdate,
1435: last_updated_by = arp_standard.profile.user_id,
1436: last_update_login = arp_standard.profile.last_update_login,
1437: request_id = req_id,
1438: program_application_id =arp_standard.profile.program_application_id,
1439: program_id = arp_standard.profile.program_id,
1440: program_update_date = sysdate
1441: WHERE status = 'A'
1442: AND yt.cust_account_id = from_rec.cust_account_id

Line 1439: program_id = arp_standard.profile.program_id,

1435: last_updated_by = arp_standard.profile.user_id,
1436: last_update_login = arp_standard.profile.last_update_login,
1437: request_id = req_id,
1438: program_application_id =arp_standard.profile.program_application_id,
1439: program_id = arp_standard.profile.program_id,
1440: program_update_date = sysdate
1441: WHERE status = 'A'
1442: AND yt.cust_account_id = from_rec.cust_account_id
1443: AND yt.related_cust_account_id = from_rec.related_cust_account_id

Line 1497: last_updated_by = arp_standard.profile.user_id,

1493: --Inactivate the from account relationships
1494: UPDATE hz_cust_acct_relate_all yt SET
1495: status = 'I',
1496: last_update_date = sysdate,
1497: last_updated_by = arp_standard.profile.user_id,
1498: last_update_login = arp_standard.profile.last_update_login,
1499: request_id = req_id,
1500: program_application_id =arp_standard.profile.program_application_id,
1501: program_id = arp_standard.profile.program_id,

Line 1498: last_update_login = arp_standard.profile.last_update_login,

1494: UPDATE hz_cust_acct_relate_all yt SET
1495: status = 'I',
1496: last_update_date = sysdate,
1497: last_updated_by = arp_standard.profile.user_id,
1498: last_update_login = arp_standard.profile.last_update_login,
1499: request_id = req_id,
1500: program_application_id =arp_standard.profile.program_application_id,
1501: program_id = arp_standard.profile.program_id,
1502: program_update_date = sysdate

Line 1500: program_application_id =arp_standard.profile.program_application_id,

1496: last_update_date = sysdate,
1497: last_updated_by = arp_standard.profile.user_id,
1498: last_update_login = arp_standard.profile.last_update_login,
1499: request_id = req_id,
1500: program_application_id =arp_standard.profile.program_application_id,
1501: program_id = arp_standard.profile.program_id,
1502: program_update_date = sysdate
1503: WHERE status = 'A'
1504: AND yt.cust_account_id = from_rec.cust_account_id

Line 1501: program_id = arp_standard.profile.program_id,

1497: last_updated_by = arp_standard.profile.user_id,
1498: last_update_login = arp_standard.profile.last_update_login,
1499: request_id = req_id,
1500: program_application_id =arp_standard.profile.program_application_id,
1501: program_id = arp_standard.profile.program_id,
1502: program_update_date = sysdate
1503: WHERE status = 'A'
1504: AND yt.cust_account_id = from_rec.cust_account_id
1505: AND yt.related_cust_account_id = from_rec.related_cust_account_id

Line 1521: last_updated_by = arp_standard.profile.user_id,

1517: --Start bug 7192302
1518: /*UPDATE HZ_CUST_ACCT_RELATE_ALL yt
1519: SET status = 'I',
1520: last_update_date = sysdate,
1521: last_updated_by = arp_standard.profile.user_id,
1522: last_update_login = arp_standard.profile.last_update_login,
1523: request_id = req_id,
1524: program_application_id =arp_standard.profile.program_application_id,
1525: program_id = arp_standard.profile.program_id,

Line 1522: last_update_login = arp_standard.profile.last_update_login,

1518: /*UPDATE HZ_CUST_ACCT_RELATE_ALL yt
1519: SET status = 'I',
1520: last_update_date = sysdate,
1521: last_updated_by = arp_standard.profile.user_id,
1522: last_update_login = arp_standard.profile.last_update_login,
1523: request_id = req_id,
1524: program_application_id =arp_standard.profile.program_application_id,
1525: program_id = arp_standard.profile.program_id,
1526: program_update_date = sysdate

Line 1524: program_application_id =arp_standard.profile.program_application_id,

1520: last_update_date = sysdate,
1521: last_updated_by = arp_standard.profile.user_id,
1522: last_update_login = arp_standard.profile.last_update_login,
1523: request_id = req_id,
1524: program_application_id =arp_standard.profile.program_application_id,
1525: program_id = arp_standard.profile.program_id,
1526: program_update_date = sysdate
1527: WHERE EXISTS (
1528: SELECT 'relationship to self not allowed'

Line 1525: program_id = arp_standard.profile.program_id,

1521: last_updated_by = arp_standard.profile.user_id,
1522: last_update_login = arp_standard.profile.last_update_login,
1523: request_id = req_id,
1524: program_application_id =arp_standard.profile.program_application_id,
1525: program_id = arp_standard.profile.program_id,
1526: program_update_date = sysdate
1527: WHERE EXISTS (
1528: SELECT 'relationship to self not allowed'
1529: FROM ra_customer_merges m

Line 1551: LAST_UPDATED_BY = arp_standard.profile.user_id ,

1547:
1548: UPDATE HZ_CUST_ACCT_RELATE_ALL YT
1549: SET STATUS = 'I',
1550: LAST_UPDATE_DATE = SYSDATE,
1551: LAST_UPDATED_BY = arp_standard.profile.user_id ,
1552: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login ,
1553: REQUEST_ID = req_id,
1554: PROGRAM_APPLICATION_ID =arp_standard.profile.program_application_id ,
1555: PROGRAM_ID = arp_standard.profile.program_id ,

Line 1552: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login ,

1548: UPDATE HZ_CUST_ACCT_RELATE_ALL YT
1549: SET STATUS = 'I',
1550: LAST_UPDATE_DATE = SYSDATE,
1551: LAST_UPDATED_BY = arp_standard.profile.user_id ,
1552: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login ,
1553: REQUEST_ID = req_id,
1554: PROGRAM_APPLICATION_ID =arp_standard.profile.program_application_id ,
1555: PROGRAM_ID = arp_standard.profile.program_id ,
1556: PROGRAM_UPDATE_DATE = SYSDATE

Line 1554: PROGRAM_APPLICATION_ID =arp_standard.profile.program_application_id ,

1550: LAST_UPDATE_DATE = SYSDATE,
1551: LAST_UPDATED_BY = arp_standard.profile.user_id ,
1552: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login ,
1553: REQUEST_ID = req_id,
1554: PROGRAM_APPLICATION_ID =arp_standard.profile.program_application_id ,
1555: PROGRAM_ID = arp_standard.profile.program_id ,
1556: PROGRAM_UPDATE_DATE = SYSDATE
1557: WHERE (RELATED_CUST_ACCOUNT_ID,CUST_ACCOUNT_ID,ORG_ID ) IN
1558: (SELECT CUSTOMER_ID,

Line 1555: PROGRAM_ID = arp_standard.profile.program_id ,

1551: LAST_UPDATED_BY = arp_standard.profile.user_id ,
1552: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login ,
1553: REQUEST_ID = req_id,
1554: PROGRAM_APPLICATION_ID =arp_standard.profile.program_application_id ,
1555: PROGRAM_ID = arp_standard.profile.program_id ,
1556: PROGRAM_UPDATE_DATE = SYSDATE
1557: WHERE (RELATED_CUST_ACCOUNT_ID,CUST_ACCOUNT_ID,ORG_ID ) IN
1558: (SELECT CUSTOMER_ID,
1559: DUPLICATE_ID,

Line 1572: LAST_UPDATED_BY = arp_standard.profile.user_id ,

1568:
1569: UPDATE HZ_CUST_ACCT_RELATE_ALL YT
1570: SET STATUS = 'I',
1571: LAST_UPDATE_DATE = SYSDATE,
1572: LAST_UPDATED_BY = arp_standard.profile.user_id ,
1573: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login ,
1574: REQUEST_ID = req_id,
1575: PROGRAM_APPLICATION_ID =arp_standard.profile.program_application_id ,
1576: PROGRAM_ID = arp_standard.profile.program_id ,

Line 1573: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login ,

1569: UPDATE HZ_CUST_ACCT_RELATE_ALL YT
1570: SET STATUS = 'I',
1571: LAST_UPDATE_DATE = SYSDATE,
1572: LAST_UPDATED_BY = arp_standard.profile.user_id ,
1573: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login ,
1574: REQUEST_ID = req_id,
1575: PROGRAM_APPLICATION_ID =arp_standard.profile.program_application_id ,
1576: PROGRAM_ID = arp_standard.profile.program_id ,
1577: PROGRAM_UPDATE_DATE = SYSDATE

Line 1575: PROGRAM_APPLICATION_ID =arp_standard.profile.program_application_id ,

1571: LAST_UPDATE_DATE = SYSDATE,
1572: LAST_UPDATED_BY = arp_standard.profile.user_id ,
1573: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login ,
1574: REQUEST_ID = req_id,
1575: PROGRAM_APPLICATION_ID =arp_standard.profile.program_application_id ,
1576: PROGRAM_ID = arp_standard.profile.program_id ,
1577: PROGRAM_UPDATE_DATE = SYSDATE
1578: WHERE (CUST_ACCOUNT_ID,RELATED_CUST_ACCOUNT_ID,ORG_ID ) IN
1579: (SELECT CUSTOMER_ID,

Line 1576: PROGRAM_ID = arp_standard.profile.program_id ,

1572: LAST_UPDATED_BY = arp_standard.profile.user_id ,
1573: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login ,
1574: REQUEST_ID = req_id,
1575: PROGRAM_APPLICATION_ID =arp_standard.profile.program_application_id ,
1576: PROGRAM_ID = arp_standard.profile.program_id ,
1577: PROGRAM_UPDATE_DATE = SYSDATE
1578: WHERE (CUST_ACCOUNT_ID,RELATED_CUST_ACCOUNT_ID,ORG_ID ) IN
1579: (SELECT CUSTOMER_ID,
1580: DUPLICATE_ID,

Line 1888: -- Bug 2707587 : Added standard who columns (created_by, creation_date,

1884: DATE_COL1_ORIG,
1885: DATE_COL1_NEW,
1886: REQUEST_ID,
1887:
1888: -- Bug 2707587 : Added standard who columns (created_by, creation_date,
1889: -- last_update_by, last_update_date, last_update_login)
1890: -- and ACTION_FLAG column into insert statemnt.
1891:
1892: CREATED_BY,

Line 1926: -- Bug 2707587 : Added standard who columns (created_by, creation_date,

1922: DATE_COL1_ORIG,
1923: DATE_COL1_NEW,
1924: REQUEST_ID,
1925:
1926: -- Bug 2707587 : Added standard who columns (created_by, creation_date,
1927: -- last_update_by, last_update_date, last_update_login)
1928: -- and ACTION_FLAG column into insert statemnt.
1929:
1930: CREATED_BY,

Line 1978: | last_updated_by = arp_standard.profile.user_id,

1974: | --- bug 1611619 : put customer_id in where clause to use index
1975: | UPDATE RA_CUST_RECEIPT_METHODS yt
1976: | SET end_date = sysdate,
1977: | last_update_date = sysdate,
1978: | last_updated_by = arp_standard.profile.user_id,
1979: | last_update_login = arp_standard.profile.last_update_login,
1980: | request_id = req_id,
1981: | program_application_id =arp_standard.profile.program_application_id,
1982: | program_id = arp_standard.profile.program_id,

Line 1979: | last_update_login = arp_standard.profile.last_update_login,

Line 1981: | program_application_id =arp_standard.profile.program_application_id,

1977: | last_update_date = sysdate,
1978: | last_updated_by = arp_standard.profile.user_id,
1979: | last_update_login = arp_standard.profile.last_update_login,
1980: | request_id = req_id,
1981: | program_application_id =arp_standard.profile.program_application_id,
1982: | program_id = arp_standard.profile.program_id,
1983: | program_update_date = sysdate
1984: | WHERE (customer_id, site_use_id) IN (
1985: | SELECT m.duplicate_id, m.duplicate_site_id

Line 1982: | program_id = arp_standard.profile.program_id,

1978: | last_updated_by = arp_standard.profile.user_id,
1979: | last_update_login = arp_standard.profile.last_update_login,
1980: | request_id = req_id,
1981: | program_application_id =arp_standard.profile.program_application_id,
1982: | program_id = arp_standard.profile.program_id,
1983: | program_update_date = sysdate
1984: | WHERE (customer_id, site_use_id) IN (
1985: | SELECT m.duplicate_id, m.duplicate_site_id
1986: | FROM ra_customer_merges m

Line 2003: , last_updated_by=arp_standard.profile.user_id

1999: AND l.TABLE_NAME = 'RA_CUST_RECEIPT_METHODS'
2000: AND l.PRIMARY_KEY_ID = CUST_RECEIPT_METHOD_ID
2001: )
2002: , LAST_UPDATE_DATE=SYSDATE
2003: , last_updated_by=arp_standard.profile.user_id
2004: , last_update_login=arp_standard.profile.last_update_login
2005: , REQUEST_ID=req_id
2006: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
2007: , PROGRAM_ID=arp_standard.profile.program_id

Line 2004: , last_update_login=arp_standard.profile.last_update_login

2000: AND l.PRIMARY_KEY_ID = CUST_RECEIPT_METHOD_ID
2001: )
2002: , LAST_UPDATE_DATE=SYSDATE
2003: , last_updated_by=arp_standard.profile.user_id
2004: , last_update_login=arp_standard.profile.last_update_login
2005: , REQUEST_ID=req_id
2006: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
2007: , PROGRAM_ID=arp_standard.profile.program_id
2008: , PROGRAM_UPDATE_DATE=SYSDATE

Line 2006: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

2002: , LAST_UPDATE_DATE=SYSDATE
2003: , last_updated_by=arp_standard.profile.user_id
2004: , last_update_login=arp_standard.profile.last_update_login
2005: , REQUEST_ID=req_id
2006: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
2007: , PROGRAM_ID=arp_standard.profile.program_id
2008: , PROGRAM_UPDATE_DATE=SYSDATE
2009: WHERE (CUST_RECEIPT_METHOD_ID) in (
2010: SELECT PRIMARY_KEY_ID

Line 2007: , PROGRAM_ID=arp_standard.profile.program_id

2003: , last_updated_by=arp_standard.profile.user_id
2004: , last_update_login=arp_standard.profile.last_update_login
2005: , REQUEST_ID=req_id
2006: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
2007: , PROGRAM_ID=arp_standard.profile.program_id
2008: , PROGRAM_UPDATE_DATE=SYSDATE
2009: WHERE (CUST_RECEIPT_METHOD_ID) in (
2010: SELECT PRIMARY_KEY_ID
2011: FROM HZ_CUSTOMER_MERGE_LOG l1, RA_CUSTOMER_MERGES h

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

Line 2049: | last_update_login = arp_standard.profile.last_update_login,

Line 2051: | program_application_id =arp_standard.profile.program_application_id,

Line 2052: | program_id = arp_standard.profile.program_id,

Line 2447: last_updated_by = arp_standard.profile.user_id,

2443: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_ACCOUNT_ROLES', FALSE );
2444: UPDATE HZ_CUST_ACCOUNT_ROLES yt
2445: SET status = 'I',
2446: last_update_date = sysdate,
2447: last_updated_by = arp_standard.profile.user_id,
2448: last_update_login = arp_standard.profile.last_update_login,
2449: request_id = req_id,
2450: program_application_id = arp_standard.profile.program_application_id,
2451: program_id = arp_standard.profile.program_id,

Line 2448: last_update_login = arp_standard.profile.last_update_login,

2444: UPDATE HZ_CUST_ACCOUNT_ROLES yt
2445: SET status = 'I',
2446: last_update_date = sysdate,
2447: last_updated_by = arp_standard.profile.user_id,
2448: last_update_login = arp_standard.profile.last_update_login,
2449: request_id = req_id,
2450: program_application_id = arp_standard.profile.program_application_id,
2451: program_id = arp_standard.profile.program_id,
2452: program_update_date = sysdate

Line 2450: program_application_id = arp_standard.profile.program_application_id,

2446: last_update_date = sysdate,
2447: last_updated_by = arp_standard.profile.user_id,
2448: last_update_login = arp_standard.profile.last_update_login,
2449: request_id = req_id,
2450: program_application_id = arp_standard.profile.program_application_id,
2451: program_id = arp_standard.profile.program_id,
2452: program_update_date = sysdate
2453: WHERE party_id = l_party_id
2454: AND nvl(status,'A') ='A';

Line 2451: program_id = arp_standard.profile.program_id,

2447: last_updated_by = arp_standard.profile.user_id,
2448: last_update_login = arp_standard.profile.last_update_login,
2449: request_id = req_id,
2450: program_application_id = arp_standard.profile.program_application_id,
2451: program_id = arp_standard.profile.program_id,
2452: program_update_date = sysdate
2453: WHERE party_id = l_party_id
2454: AND nvl(status,'A') ='A';
2455:

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 5694: standard_terms,

5690: credit_hold,
5691: profile_class_id,
5692: credit_rating,
5693: risk_code,
5694: standard_terms,
5695: override_terms,
5696: dunning_letter_set_id,
5697: interest_period_days,
5698: payment_grace_days,

Line 5800: cust_prof_rec.standard_terms,

5796: cust_prof_rec.credit_hold,
5797: cust_prof_rec.profile_class_id,
5798: cust_prof_rec.credit_rating,
5799: cust_prof_rec.risk_code,
5800: cust_prof_rec.standard_terms,
5801: cust_prof_rec.override_terms,
5802: cust_prof_rec.dunning_letter_set_id,
5803: cust_prof_rec.interest_period_days,
5804: cust_prof_rec.payment_grace_days,

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

Line 7042: standard_terms ,

7038: profile_class_id ,
7039: site_use_id ,
7040: credit_rating ,
7041: risk_code ,
7042: standard_terms ,
7043: override_terms ,
7044: dunning_letter_set_id ,
7045: interest_period_days ,
7046: payment_grace_days ,

Line 7152: cp.standard_terms ,

7148: cp.profile_class_id ,
7149: cp.site_use_id ,
7150: cp.credit_rating ,
7151: cp.risk_code ,
7152: cp.standard_terms ,
7153: cp.override_terms ,
7154: cp.dunning_letter_set_id ,
7155: cp.interest_period_days ,
7156: cp.payment_grace_days ,

Line 7996: p_cust_acct_relate_rec.application_id := arp_standard.profile.program_id;

7992: ELSE
7993: p_cust_acct_relate_rec.cust_account_id := p_customer_id;
7994: END IF;
7995: p_cust_acct_relate_rec.created_by_module := 'HZ_TCA_CUSTOMER_MERGE';
7996: p_cust_acct_relate_rec.application_id := arp_standard.profile.program_id;
7997: l_cust_acct_relate_id := NULL;
7998: -- Call table-handler.
7999: HZ_CUST_ACCT_RELATE_PKG.Insert_Row (
8000: X_CUST_ACCOUNT_ID => p_cust_acct_relate_rec.cust_account_id,