How to inactivate PERSON - ORGANIZATION relationship in TCA?

Hi ,

I am working on script to update/ Inactivate  PERSON - ORGANIZATION relationships using hz_relationship_v2pub.update_relationship API .

Script is given below ...

DECLARE

   p_relationship_rec              hz_relationship_v2pub.relationship_rec_type;

   x_relationship_id               NUMBER;

   x_party_id                      NUMBER;

   x_party_number                  VARCHAR2 (2000);

   x_return_status                 VARCHAR2 (2000);

   x_msg_count                     NUMBER;

   x_msg_data                      VARCHAR2 (2000);

   p_object_version_number         NUMBER;

   p_party_object_version_number   NUMBER;

BEGIN

   fnd_global.apps_initialize (0, 20678, 222);

   mo_global.init ('AR');

   p_relationship_rec.relationship_id := 1586412;

   p_relationship_rec.status := 'I';

   p_relationship_rec.party_rec.status := 'I';

   p_relationship_rec.party_rec.party_id := 1756668;