Tuesday, November 27, 2012

API to Delete message from FND_NEW_MESSAGES

DECLARE
   CURSOR c1
   IS
      SELECT *
        FROM fnd_new_messages;
BEGIN
   FOR z IN c1
   LOOP
      fnd_new_messages_pkg.delete_row (x_application_id      => z.application_id
                                     , x_language_code       => z.language_code
                                     , x_message_name        => z.message_name
                                      );
   END LOOP;
   COMMIT;
END;

No comments:

Post a Comment

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