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 497: last_updated_by = arp_standard.PROFILE.user_id,

493:
494: UPDATE hz_cust_site_uses_all asu
495: SET primary_flag = 'Y',
496: last_update_date = SYSDATE,
497: last_updated_by = arp_standard.PROFILE.user_id,
498: last_update_login = arp_standard.PROFILE.last_update_login,
499: request_id = req_id,
500: program_application_id = arp_standard.PROFILE.program_application_id,
501: program_id = arp_standard.PROFILE.program_id,

Line 498: last_update_login = arp_standard.PROFILE.last_update_login,

494: UPDATE hz_cust_site_uses_all asu
495: SET primary_flag = 'Y',
496: last_update_date = SYSDATE,
497: last_updated_by = arp_standard.PROFILE.user_id,
498: last_update_login = arp_standard.PROFILE.last_update_login,
499: request_id = req_id,
500: program_application_id = arp_standard.PROFILE.program_application_id,
501: program_id = arp_standard.PROFILE.program_id,
502: program_update_date = SYSDATE

Line 500: program_application_id = arp_standard.PROFILE.program_application_id,

496: last_update_date = SYSDATE,
497: last_updated_by = arp_standard.PROFILE.user_id,
498: last_update_login = arp_standard.PROFILE.last_update_login,
499: request_id = req_id,
500: program_application_id = arp_standard.PROFILE.program_application_id,
501: program_id = arp_standard.PROFILE.program_id,
502: program_update_date = SYSDATE
503: WHERE asu.site_use_id IN( SELECT customer_site_id
504: FROM ra_customer_merges m

Line 501: program_id = arp_standard.PROFILE.program_id,

497: last_updated_by = arp_standard.PROFILE.user_id,
498: last_update_login = arp_standard.PROFILE.last_update_login,
499: request_id = req_id,
500: program_application_id = arp_standard.PROFILE.program_application_id,
501: program_id = arp_standard.PROFILE.program_id,
502: program_update_date = SYSDATE
503: WHERE asu.site_use_id IN( SELECT customer_site_id
504: FROM ra_customer_merges m
505: WHERE m.request_id = req_id

Line 537: last_updated_by = arp_standard.profile.user_id,

533:
534: UPDATE HZ_CUST_SITE_USES su1
535: SET status = 'I',
536: last_update_date = sysdate,
537: last_updated_by = arp_standard.profile.user_id,
538: last_update_login = arp_standard.profile.last_update_login,
539: request_id = req_id,
540: program_application_id = arp_standard.profile.program_application_id,
541: program_id = arp_standard.profile.program_id,

Line 538: last_update_login = arp_standard.profile.last_update_login,

534: UPDATE HZ_CUST_SITE_USES su1
535: SET status = 'I',
536: last_update_date = sysdate,
537: last_updated_by = arp_standard.profile.user_id,
538: last_update_login = arp_standard.profile.last_update_login,
539: request_id = req_id,
540: program_application_id = arp_standard.profile.program_application_id,
541: program_id = arp_standard.profile.program_id,
542: program_update_date = sysdate

Line 540: program_application_id = arp_standard.profile.program_application_id,

536: last_update_date = sysdate,
537: last_updated_by = arp_standard.profile.user_id,
538: last_update_login = arp_standard.profile.last_update_login,
539: request_id = req_id,
540: program_application_id = arp_standard.profile.program_application_id,
541: program_id = arp_standard.profile.program_id,
542: program_update_date = sysdate
543: WHERE cust_acct_site_id IN (
544: SELECT m.duplicate_address_id

Line 541: program_id = arp_standard.profile.program_id,

537: last_updated_by = arp_standard.profile.user_id,
538: last_update_login = arp_standard.profile.last_update_login,
539: request_id = req_id,
540: program_application_id = arp_standard.profile.program_application_id,
541: program_id = arp_standard.profile.program_id,
542: program_update_date = sysdate
543: WHERE cust_acct_site_id IN (
544: SELECT m.duplicate_address_id
545: 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 947: last_updated_by = arp_standard.profile.user_id,

943:
944: UPDATE hz_cust_acct_sites_all yt
945: SET bill_to_flag = 'P',
946: last_update_date = sysdate,
947: last_updated_by = arp_standard.profile.user_id,
948: last_update_login = arp_standard.profile.last_update_login,
949: request_id = req_id,
950: program_application_id = arp_standard.profile.program_application_id,
951: program_id = arp_standard.profile.program_id,

Line 948: last_update_login = arp_standard.profile.last_update_login,

944: UPDATE hz_cust_acct_sites_all yt
945: SET bill_to_flag = 'P',
946: last_update_date = sysdate,
947: last_updated_by = arp_standard.profile.user_id,
948: last_update_login = arp_standard.profile.last_update_login,
949: request_id = req_id,
950: program_application_id = arp_standard.profile.program_application_id,
951: program_id = arp_standard.profile.program_id,
952: program_update_date = sysdate

Line 950: program_application_id = arp_standard.profile.program_application_id,

946: last_update_date = sysdate,
947: last_updated_by = arp_standard.profile.user_id,
948: last_update_login = arp_standard.profile.last_update_login,
949: request_id = req_id,
950: program_application_id = arp_standard.profile.program_application_id,
951: program_id = arp_standard.profile.program_id,
952: program_update_date = sysdate
953: WHERE EXISTS ( SELECT 1
954: FROM hz_cust_site_uses_all su, ra_customer_merges m

Line 951: program_id = arp_standard.profile.program_id,

947: last_updated_by = arp_standard.profile.user_id,
948: last_update_login = arp_standard.profile.last_update_login,
949: request_id = req_id,
950: program_application_id = arp_standard.profile.program_application_id,
951: program_id = arp_standard.profile.program_id,
952: program_update_date = sysdate
953: WHERE EXISTS ( SELECT 1
954: FROM hz_cust_site_uses_all su, ra_customer_merges m
955: WHERE m.request_id = req_id

Line 980: last_updated_by = arp_standard.profile.user_id,

976:
977: UPDATE hz_cust_acct_sites_all yt
978: SET ship_to_flag = 'P',
979: last_update_date = sysdate,
980: last_updated_by = arp_standard.profile.user_id,
981: last_update_login = arp_standard.profile.last_update_login,
982: request_id = req_id,
983: program_application_id = arp_standard.profile.program_application_id,
984: program_id = arp_standard.profile.program_id,

Line 981: last_update_login = arp_standard.profile.last_update_login,

977: UPDATE hz_cust_acct_sites_all yt
978: SET ship_to_flag = 'P',
979: last_update_date = sysdate,
980: last_updated_by = arp_standard.profile.user_id,
981: last_update_login = arp_standard.profile.last_update_login,
982: request_id = req_id,
983: program_application_id = arp_standard.profile.program_application_id,
984: program_id = arp_standard.profile.program_id,
985: program_update_date = sysdate

Line 983: program_application_id = arp_standard.profile.program_application_id,

979: last_update_date = sysdate,
980: last_updated_by = arp_standard.profile.user_id,
981: last_update_login = arp_standard.profile.last_update_login,
982: request_id = req_id,
983: program_application_id = arp_standard.profile.program_application_id,
984: program_id = arp_standard.profile.program_id,
985: program_update_date = sysdate
986: WHERE EXISTS ( SELECT 1
987: FROM hz_cust_site_uses_all su, ra_customer_merges m

Line 984: program_id = arp_standard.profile.program_id,

980: last_updated_by = arp_standard.profile.user_id,
981: last_update_login = arp_standard.profile.last_update_login,
982: request_id = req_id,
983: program_application_id = arp_standard.profile.program_application_id,
984: program_id = arp_standard.profile.program_id,
985: program_update_date = sysdate
986: WHERE EXISTS ( SELECT 1
987: FROM hz_cust_site_uses_all su, ra_customer_merges m
988: WHERE m.request_id = req_id

Line 1013: last_updated_by = arp_standard.profile.user_id,

1009:
1010: UPDATE hz_cust_acct_sites_all yt
1011: SET market_flag = 'P',
1012: last_update_date = sysdate,
1013: last_updated_by = arp_standard.profile.user_id,
1014: last_update_login = arp_standard.profile.last_update_login,
1015: request_id = req_id,
1016: program_application_id = arp_standard.profile.program_application_id,
1017: program_id = arp_standard.profile.program_id,

Line 1014: last_update_login = arp_standard.profile.last_update_login,

1010: UPDATE hz_cust_acct_sites_all yt
1011: SET market_flag = 'P',
1012: last_update_date = sysdate,
1013: last_updated_by = arp_standard.profile.user_id,
1014: last_update_login = arp_standard.profile.last_update_login,
1015: request_id = req_id,
1016: program_application_id = arp_standard.profile.program_application_id,
1017: program_id = arp_standard.profile.program_id,
1018: program_update_date = sysdate

Line 1016: program_application_id = arp_standard.profile.program_application_id,

1012: last_update_date = sysdate,
1013: last_updated_by = arp_standard.profile.user_id,
1014: last_update_login = arp_standard.profile.last_update_login,
1015: request_id = req_id,
1016: program_application_id = arp_standard.profile.program_application_id,
1017: program_id = arp_standard.profile.program_id,
1018: program_update_date = sysdate
1019: WHERE EXISTS ( SELECT 1
1020: FROM hz_cust_site_uses_all su, ra_customer_merges m

Line 1017: program_id = arp_standard.profile.program_id,

1013: last_updated_by = arp_standard.profile.user_id,
1014: last_update_login = arp_standard.profile.last_update_login,
1015: request_id = req_id,
1016: program_application_id = arp_standard.profile.program_application_id,
1017: program_id = arp_standard.profile.program_id,
1018: program_update_date = sysdate
1019: WHERE EXISTS ( SELECT 1
1020: FROM hz_cust_site_uses_all su, ra_customer_merges m
1021: WHERE m.request_id = req_id

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

1652: --Start bug 7192302
1653: /*UPDATE HZ_CUST_ACCT_RELATE_ALL yt
1654: SET status = 'I',
1655: last_update_date = sysdate,
1656: last_updated_by = arp_standard.profile.user_id,
1657: last_update_login = arp_standard.profile.last_update_login,
1658: request_id = req_id,
1659: program_application_id =arp_standard.profile.program_application_id,
1660: program_id = arp_standard.profile.program_id,

Line 1657: last_update_login = arp_standard.profile.last_update_login,

1653: /*UPDATE HZ_CUST_ACCT_RELATE_ALL yt
1654: SET status = 'I',
1655: last_update_date = sysdate,
1656: last_updated_by = arp_standard.profile.user_id,
1657: last_update_login = arp_standard.profile.last_update_login,
1658: request_id = req_id,
1659: program_application_id =arp_standard.profile.program_application_id,
1660: program_id = arp_standard.profile.program_id,
1661: program_update_date = sysdate

Line 1659: program_application_id =arp_standard.profile.program_application_id,

1655: last_update_date = sysdate,
1656: last_updated_by = arp_standard.profile.user_id,
1657: last_update_login = arp_standard.profile.last_update_login,
1658: request_id = req_id,
1659: program_application_id =arp_standard.profile.program_application_id,
1660: program_id = arp_standard.profile.program_id,
1661: program_update_date = sysdate
1662: WHERE EXISTS (
1663: SELECT 'relationship to self not allowed'

Line 1660: program_id = arp_standard.profile.program_id,

1656: last_updated_by = arp_standard.profile.user_id,
1657: last_update_login = arp_standard.profile.last_update_login,
1658: request_id = req_id,
1659: program_application_id =arp_standard.profile.program_application_id,
1660: program_id = arp_standard.profile.program_id,
1661: program_update_date = sysdate
1662: WHERE EXISTS (
1663: SELECT 'relationship to self not allowed'
1664: FROM ra_customer_merges m

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

2019: DATE_COL1_ORIG,
2020: DATE_COL1_NEW,
2021: REQUEST_ID,
2022:
2023: -- Bug 2707587 : Added standard who columns (created_by, creation_date,
2024: -- last_update_by, last_update_date, last_update_login)
2025: -- and ACTION_FLAG column into insert statemnt.
2026:
2027: CREATED_BY,

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

2057: DATE_COL1_ORIG,
2058: DATE_COL1_NEW,
2059: REQUEST_ID,
2060:
2061: -- Bug 2707587 : Added standard who columns (created_by, creation_date,
2062: -- last_update_by, last_update_date, last_update_login)
2063: -- and ACTION_FLAG column into insert statemnt.
2064:
2065: CREATED_BY,

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

2109: | --- bug 1611619 : put customer_id in where clause to use index
2110: | UPDATE RA_CUST_RECEIPT_METHODS yt
2111: | SET end_date = sysdate,
2112: | last_update_date = sysdate,
2113: | last_updated_by = arp_standard.profile.user_id,
2114: | last_update_login = arp_standard.profile.last_update_login,
2115: | request_id = req_id,
2116: | program_application_id =arp_standard.profile.program_application_id,
2117: | program_id = arp_standard.profile.program_id,

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

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

2112: | last_update_date = sysdate,
2113: | last_updated_by = arp_standard.profile.user_id,
2114: | last_update_login = arp_standard.profile.last_update_login,
2115: | request_id = req_id,
2116: | program_application_id =arp_standard.profile.program_application_id,
2117: | program_id = arp_standard.profile.program_id,
2118: | program_update_date = sysdate
2119: | WHERE (customer_id, site_use_id) IN (
2120: | SELECT m.duplicate_id, m.duplicate_site_id

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

2113: | last_updated_by = arp_standard.profile.user_id,
2114: | last_update_login = arp_standard.profile.last_update_login,
2115: | request_id = req_id,
2116: | program_application_id =arp_standard.profile.program_application_id,
2117: | program_id = arp_standard.profile.program_id,
2118: | program_update_date = sysdate
2119: | WHERE (customer_id, site_use_id) IN (
2120: | SELECT m.duplicate_id, m.duplicate_site_id
2121: | FROM ra_customer_merges m

Line 2138: , last_updated_by=arp_standard.profile.user_id

2134: AND l.TABLE_NAME = 'RA_CUST_RECEIPT_METHODS'
2135: AND l.PRIMARY_KEY_ID = CUST_RECEIPT_METHOD_ID
2136: )
2137: , LAST_UPDATE_DATE=SYSDATE
2138: , last_updated_by=arp_standard.profile.user_id
2139: , last_update_login=arp_standard.profile.last_update_login
2140: , REQUEST_ID=req_id
2141: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
2142: , PROGRAM_ID=arp_standard.profile.program_id

Line 2139: , last_update_login=arp_standard.profile.last_update_login

2135: AND l.PRIMARY_KEY_ID = CUST_RECEIPT_METHOD_ID
2136: )
2137: , LAST_UPDATE_DATE=SYSDATE
2138: , last_updated_by=arp_standard.profile.user_id
2139: , last_update_login=arp_standard.profile.last_update_login
2140: , REQUEST_ID=req_id
2141: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
2142: , PROGRAM_ID=arp_standard.profile.program_id
2143: , PROGRAM_UPDATE_DATE=SYSDATE

Line 2141: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

2137: , LAST_UPDATE_DATE=SYSDATE
2138: , last_updated_by=arp_standard.profile.user_id
2139: , last_update_login=arp_standard.profile.last_update_login
2140: , REQUEST_ID=req_id
2141: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
2142: , PROGRAM_ID=arp_standard.profile.program_id
2143: , PROGRAM_UPDATE_DATE=SYSDATE
2144: WHERE (CUST_RECEIPT_METHOD_ID) in (
2145: SELECT PRIMARY_KEY_ID

Line 2142: , PROGRAM_ID=arp_standard.profile.program_id

2138: , last_updated_by=arp_standard.profile.user_id
2139: , last_update_login=arp_standard.profile.last_update_login
2140: , REQUEST_ID=req_id
2141: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
2142: , PROGRAM_ID=arp_standard.profile.program_id
2143: , PROGRAM_UPDATE_DATE=SYSDATE
2144: WHERE (CUST_RECEIPT_METHOD_ID) in (
2145: SELECT PRIMARY_KEY_ID
2146: FROM HZ_CUSTOMER_MERGE_LOG l1, RA_CUSTOMER_MERGES h

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

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

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

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

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

6019: credit_hold,
6020: profile_class_id,
6021: credit_rating,
6022: risk_code,
6023: standard_terms,
6024: override_terms,
6025: dunning_letter_set_id,
6026: interest_period_days,
6027: payment_grace_days,

Line 6130: cust_prof_rec.standard_terms,

6126: cust_prof_rec.credit_hold,
6127: cust_prof_rec.profile_class_id,
6128: cust_prof_rec.credit_rating,
6129: cust_prof_rec.risk_code,
6130: cust_prof_rec.standard_terms,
6131: cust_prof_rec.override_terms,
6132: cust_prof_rec.dunning_letter_set_id,
6133: cust_prof_rec.interest_period_days,
6134: cust_prof_rec.payment_grace_days,

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

7389: profile_class_id ,
7390: site_use_id ,
7391: credit_rating ,
7392: risk_code ,
7393: standard_terms ,
7394: override_terms ,
7395: dunning_letter_set_id ,
7396: interest_period_days ,
7397: payment_grace_days ,

Line 7504: cp.standard_terms ,

7500: cp.profile_class_id ,
7501: cp.site_use_id ,
7502: cp.credit_rating ,
7503: cp.risk_code ,
7504: cp.standard_terms ,
7505: cp.override_terms ,
7506: cp.dunning_letter_set_id ,
7507: cp.interest_period_days ,
7508: cp.payment_grace_days ,