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