Tuesday, November 27, 2012

API to Update the Messages in FND_NEW_MESSAGES

DECLARE
   CURSOR c1
   IS
      SELECT *
        FROM fnd_new_messages
       WHERE message_name = &MESSAGE_NAME;
BEGIN
   FOR z IN c1
   LOOP
      fnd_new_messages_pkg.translate_row (x_application_id        => z.application_id
                                        , x_message_name          => z.message_name
                                        , x_message_text          => z.msg_txt
                                        , x_owner                 => NULL
                                        , x_custom_mode           => 'FORCE'
                                        , x_last_update_date      => NULL
                                         );
   END LOOP;
   COMMIT;
END;

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.