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.HZ_PURGE dependencies on HZ_CONTACT_POINTS

Line 379: from hz_parties a , hz_purge_gt temp, hz_contact_points cp where

375: select to_number(batchid), a.party_id, substr(a.party_name,1,250), a.party_number,
376: a.address1||','||a.city||','||a.state||','||a.country||' '||a.postal_code,
377: cp.PHONE_AREA_CODE||'-'||cp.PHONE_COUNTRY_CODE||'-'||cp.PHONE_NUMBER, a.country, 'IDENTIFIED',
378: sysdate, fnd_global.login_id, sysdate, fnd_global.user_id, fnd_global.user_id
379: from hz_parties a , hz_purge_gt temp, hz_contact_points cp where
380: temp.party_id = a.party_id and
381: cp.owner_table_id(+)=temp.party_id and
382: cp.contact_point_type(+)='PHONE' and
383: cp.owner_table_name(+)='HZ_PARTIES' and

Line 399: from hz_parties a , hz_contact_points cp where

395: select to_number(batchid), pid, substr(a.party_name,1,250), a.party_number,
396: a.address1||','||a.city||','||a.state||','||a.country||' '||a.postal_code,
397: cp.PHONE_AREA_CODE||'-'||cp.PHONE_COUNTRY_CODE||'-'||cp.PHONE_NUMBER, a.country, 'IDENTIFIED',
398: sysdate, fnd_global.login_id, sysdate, fnd_global.user_id, fnd_global.user_id
399: from hz_parties a , hz_contact_points cp where
400: a.party_id = pid and
401: cp.owner_table_id(+)= a.party_id and
402: cp.contact_point_type(+)='PHONE' and
403: cp.owner_table_name(+)='HZ_PARTIES' and

Line 593: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in

589: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
590: log(' HZ_ORGANIZATION_PROFILES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
591:
592: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
593: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in
594: (SELECT PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
595: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED''))and OWNER_TABLE_NAME=''HZ_PARTY_SITES'')
596: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using batchid;
597: log(' HZ_CONTACT_PREFERENCES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

Line 596: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using batchid;

592: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
593: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in
594: (SELECT PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
595: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED''))and OWNER_TABLE_NAME=''HZ_PARTY_SITES'')
596: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using batchid;
597: log(' HZ_CONTACT_PREFERENCES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
598: begin
599: execute immediate 'DELETE from HZ_STAGED_CONTACT_POINTS where CONTACT_POINT_ID in
600: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in

Line 600: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in

596: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using batchid;
597: log(' HZ_CONTACT_PREFERENCES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
598: begin
599: execute immediate 'DELETE from HZ_STAGED_CONTACT_POINTS where CONTACT_POINT_ID in
600: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in
601: (SELECT PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
602: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED'')) and OWNER_TABLE_NAME=''HZ_PARTY_SITES'')' using batchid;
603: log(' HZ_STAGED_CONTACT_POINTS : Deleted '||SQL%ROWCOUNT||' rows', conc_prg);
604: EXCEPTION

Line 609: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID in

605: WHEN OTHERS THEN
606: null;
607: END;
608:
609: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID in
610: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
611: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED')) and OWNER_TABLE_NAME='HZ_PARTY_SITES';
612: log(' HZ_CONTACT_POINTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
613:

Line 612: log(' HZ_CONTACT_POINTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

608:
609: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID in
610: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
611: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED')) and OWNER_TABLE_NAME='HZ_PARTY_SITES';
612: log(' HZ_CONTACT_POINTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
613:
614: DELETE from HZ_ORG_CONTACT_ROLES where ORG_CONTACT_ID in
615: ( select ORG_CONTACT_ID FROM HZ_ORG_CONTACTS WHERE PARTY_SITE_ID in (
616: SELECT PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in

Line 668: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in

664: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
665: log(' HZ_PARTY_SITES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
666:
667: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
668: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in
669: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED'')
670: and OWNER_TABLE_NAME=''HZ_PARTIES'') and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using batchid;
671: log(' HZ_CONTACT_PREFERENCES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
672:

Line 670: and OWNER_TABLE_NAME=''HZ_PARTIES'') and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using batchid;

666:
667: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
668: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in
669: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED'')
670: and OWNER_TABLE_NAME=''HZ_PARTIES'') and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using batchid;
671: log(' HZ_CONTACT_PREFERENCES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
672:
673: begin
674: execute immediate 'DELETE from HZ_STAGED_CONTACT_POINTS where CONTACT_POINT_ID in

Line 675: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in

671: log(' HZ_CONTACT_PREFERENCES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
672:
673: begin
674: execute immediate 'DELETE from HZ_STAGED_CONTACT_POINTS where CONTACT_POINT_ID in
675: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in
676: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED'')
677: and OWNER_TABLE_NAME=''HZ_PARTIES'')' using batchid;
678: log(' HZ_STAGED_CONTACT_POINTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
679: exception

Line 684: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID in

680: when others then
681: null;
682: end;
683:
684: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID in
685: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED')
686: and OWNER_TABLE_NAME='HZ_PARTIES';
687: log(' HZ_CONTACT_POINTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
688:

Line 687: log(' HZ_CONTACT_POINTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

683:
684: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID in
685: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED')
686: and OWNER_TABLE_NAME='HZ_PARTIES';
687: log(' HZ_CONTACT_POINTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
688:
689: DELETE from HZ_PERSON_PROFILES where PARTY_ID in
690: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
691: log(' HZ_PERSON_PROFILES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

Line 917: from hz_parties a , hz_contact_points cp where a.party_id = p_party_id and

913: select to_number('-1'), a.party_id, substr(a.party_name,1,250), a.party_number,
914: a.address1||','||a.city||','||a.state||','||a.country||' '||a.postal_code,
915: cp.PHONE_AREA_CODE||'-'||cp.PHONE_COUNTRY_CODE||'-'||cp.PHONE_NUMBER, a.country, 'IDENTIFIED',
916: sysdate, fnd_global.login_id, sysdate, fnd_global.user_id, fnd_global.user_id
917: from hz_parties a , hz_contact_points cp where a.party_id = p_party_id and
918: cp.owner_table_id(+)=a.party_id and cp.contact_point_type(+)='PHONE' and cp.primary_flag(+)='Y' and
919: cp.owner_table_name(+)='HZ_PARTIES';
920:
921: hz_common_pub.disable_cont_source_security;

Line 926: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in

922:
923: DELETE from HZ_ORGANIZATION_PROFILES where PARTY_ID = p_party_id;
924:
925: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
926: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in
927: (SELECT PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID = :1)and OWNER_TABLE_NAME=''HZ_PARTY_SITES'')
928: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using p_party_id;
929:
930: begin

Line 928: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using p_party_id;

924:
925: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
926: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in
927: (SELECT PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID = :1)and OWNER_TABLE_NAME=''HZ_PARTY_SITES'')
928: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using p_party_id;
929:
930: begin
931: execute immediate 'DELETE from HZ_STAGED_CONTACT_POINTS where CONTACT_POINT_ID in
932: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in

Line 932: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in

928: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using p_party_id;
929:
930: begin
931: execute immediate 'DELETE from HZ_STAGED_CONTACT_POINTS where CONTACT_POINT_ID in
932: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID in
933: (SELECT PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID = :1) and OWNER_TABLE_NAME=''HZ_PARTY_SITES'')' using p_party_id;
934: exception
935: when others then
936: null;

Line 939: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID in

935: when others then
936: null;
937: end;
938:
939: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID in
940: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID = p_party_id) and OWNER_TABLE_NAME='HZ_PARTY_SITES';
941:
942: DELETE from HZ_ORG_CONTACT_ROLES where ORG_CONTACT_ID in
943: ( select ORG_CONTACT_ID FROM HZ_ORG_CONTACTS WHERE PARTY_SITE_ID in (

Line 978: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES'')

974:
975: DELETE from HZ_PARTY_SITES where PARTY_ID = p_party_id;
976:
977: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
978: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES'')
979: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using p_party_id;
980:
981: begin
982: execute immediate 'DELETE from HZ_STAGED_CONTACT_POINTS where CONTACT_POINT_ID in

Line 979: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using p_party_id;

975: DELETE from HZ_PARTY_SITES where PARTY_ID = p_party_id;
976:
977: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
978: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES'')
979: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using p_party_id;
980:
981: begin
982: execute immediate 'DELETE from HZ_STAGED_CONTACT_POINTS where CONTACT_POINT_ID in
983: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES'')' using p_party_id;

Line 983: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES'')' using p_party_id;

979: and CONTACT_LEVEL_TABLE=''HZ_CONTACT_POINTS''' using p_party_id;
980:
981: begin
982: execute immediate 'DELETE from HZ_STAGED_CONTACT_POINTS where CONTACT_POINT_ID in
983: ( select CONTACT_POINT_ID FROM HZ_CONTACT_POINTS WHERE OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES'')' using p_party_id;
984: exception
985: when others then
986: null;
987: end;

Line 989: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID = p_party_id and OWNER_TABLE_NAME='HZ_PARTIES';

985: when others then
986: null;
987: end;
988:
989: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID = p_party_id and OWNER_TABLE_NAME='HZ_PARTIES';
990:
991: DELETE from HZ_PERSON_PROFILES where PARTY_ID = p_party_id;
992:
993: DELETE from HZ_FINANCIAL_PROFILE where PARTY_ID = p_party_id;