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