262: LAST_UPDATE_DATE = sysdate,
263: LAST_UPDATED_BY = Decode(x_owner, 'SEED', 1, 0),
264: LAST_UPDATE_LOGIN = 0,
265: SOURCE_LANG = userenv('LANG')
266: WHERE NOTIFICATION_ID = fnd_number.canonical_to_number(X_NOTIFICATION_ID)
267: AND userenv('LANG') IN (language, source_lang);
268: END translate_row;
269:
270: /*----------------------------------------------------------*/
291: END IF;
292: --
293:
294: SELECT Sysdate INTO l_sysdate FROM dual;
295: -- l_notification_id := fnd_number.canonical_to_number(X_NOTIFICATION_ID);
296:
297: BEGIN
298:
299: SELECT NOTIFICATION_ID INTO l_notification_id FROM CLN_NOTIFICATION_CODES_B