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 864: hz_common_pub.enable_cont_source_security;

860: when others then
861: null;
862: end;
863:
864: hz_common_pub.enable_cont_source_security;
865: EXCEPTION
866: WHEN FND_API.G_EXC_ERROR THEN
867: retcode := 2;
868: errbuf := errbuf || logerror||SQLERRM;

Line 921: hz_common_pub.disable_cont_source_security;

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;
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

Line 1092: hz_common_pub.enable_cont_source_security;

1088: /* update status to 'PURGED' in hz_purge_candidates for the purged parties */
1089: update hz_purge_candidates set status='PURGED' where candidate_party_id=p_party_id;
1090:
1091: --fnd_file.close;
1092: hz_common_pub.enable_cont_source_security;
1093: -- standard call to get message count and if count is 1, get message info.
1094: FND_MSG_PUB.Count_And_Get(
1095: p_encoded => FND_API.G_FALSE,
1096: p_count => x_msg_count,