DBA Data[Home] [Help]

APPS.HZ_PURGE dependencies on HZ_COMMON_PUB

Line 582: hz_common_pub.disable_cont_source_security;

578: log(partyname||'(ID= '||partyid||')',conc_prg);
579: end loop;
580: close printparties;
581:
582: hz_common_pub.disable_cont_source_security;
583: --4307686
584: DELETE from HZ_PARTY_USG_ASSIGNMENTS where PARTY_ID in
585: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
586: log(' HZ_PARTY_USG_ASSIGNMENTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

Line 876: hz_common_pub.enable_cont_source_security;

872: when others then
873: null;
874: end;
875:
876: hz_common_pub.enable_cont_source_security;
877: EXCEPTION
878: WHEN FND_API.G_EXC_ERROR THEN
879: retcode := 2;
880: errbuf := errbuf || logerror||SQLERRM;

Line 933: hz_common_pub.disable_cont_source_security;

929: from hz_parties a , hz_contact_points cp where a.party_id = p_party_id and
930: cp.owner_table_id(+)=a.party_id and cp.contact_point_type(+)='PHONE' and cp.primary_flag(+)='Y' and
931: cp.owner_table_name(+)='HZ_PARTIES';
932:
933: hz_common_pub.disable_cont_source_security;
934:
935: DELETE from HZ_ORGANIZATION_PROFILES where PARTY_ID = p_party_id;
936:
937: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in

Line 1109: hz_common_pub.enable_cont_source_security;

1105: /* update status to 'PURGED' in hz_purge_candidates for the purged parties */
1106: update hz_purge_candidates set status='PURGED' where candidate_party_id=p_party_id;
1107:
1108: --fnd_file.close;
1109: hz_common_pub.enable_cont_source_security;
1110: -- standard call to get message count and if count is 1, get message info.
1111: FND_MSG_PUB.Count_And_Get(
1112: p_encoded => FND_API.G_FALSE,
1113: p_count => x_msg_count,