Search This Blog

Sunday, November 21, 2010

Delete Contact Information in Oracle HR

Sample code provided below:

declare
 cursor cur is
 select * from per_contact_relationships where trunc(creation_date) = trunc(sysdate);
 ln_ovn number;
begin
for i in cur
loop
ln_ovn  := i.object_version_number;
hr_contact_rel_api.delete_contact_relationship
  (p_validate                          =>    false
  ,p_contact_relationship_id           => i.contact_relationship_id
  ,p_object_version_number             => ln_ovn
  );
end loop;          
end;

3 comments:

  1. Generally I do not learn post on blogs, but I would
    like to say that this write-up very compelled me to take a look at and do it!

    Your writing taste has been surprised me. Thanks, quite great article.


    My blog post herbal party pills

    ReplyDelete
  2. I'm not sure where you're getting your info, but good topic.
    I needs to sρend some time leaгning
    much more or unԁerstanding mοre.

    Thanks for great іnformatiοn I was lоokіng for thiѕ іnfo for my
    mission.

    my blоg рost: aussie party pills index

    ReplyDelete
  3. What's up, after reading this amazing paragraph i am as well glad to share my familiarity here with friends.

    my homepage ... Party pills cheap

    ReplyDelete