172: VALUES
173: (
174: l_msg_rec.message_id,
175: SYSDATE,
176: FND_GLOBAL.user_id,
177: SYSDATE,
178: FND_GLOBAL.user_id,
179: FND_GLOBAL.conc_login_id,
180: 1,
174: l_msg_rec.message_id,
175: SYSDATE,
176: FND_GLOBAL.user_id,
177: SYSDATE,
178: FND_GLOBAL.user_id,
179: FND_GLOBAL.conc_login_id,
180: 1,
181: l_msg_rec.date_effective_from,
182: l_msg_rec.date_effective_to,
175: SYSDATE,
176: FND_GLOBAL.user_id,
177: SYSDATE,
178: FND_GLOBAL.user_id,
179: FND_GLOBAL.conc_login_id,
180: 1,
181: l_msg_rec.date_effective_from,
182: l_msg_rec.date_effective_to,
183: l_msg_rec.active_flag,
219: SELECT
220: l_msg_rec.message_id,
221: l.language_code,
222: SYSDATE,
223: FND_GLOBAL.user_id,
224: SYSDATE,
225: FND_GLOBAL.user_id,
226: FND_GLOBAL.conc_login_id,
227: USERENV('LANG'),
221: l.language_code,
222: SYSDATE,
223: FND_GLOBAL.user_id,
224: SYSDATE,
225: FND_GLOBAL.user_id,
226: FND_GLOBAL.conc_login_id,
227: USERENV('LANG'),
228: l_msg_rec.message_name,
229: l_msg_rec.description
222: SYSDATE,
223: FND_GLOBAL.user_id,
224: SYSDATE,
225: FND_GLOBAL.user_id,
226: FND_GLOBAL.conc_login_id,
227: USERENV('LANG'),
228: l_msg_rec.message_name,
229: l_msg_rec.description
230: FROM fnd_languages l
416: END IF;
417:
418: UPDATE AMS_MESSAGES_B SET
419: last_update_date = SYSDATE,
420: last_updated_by = FND_GLOBAL.user_id,
421: last_update_login = FND_GLOBAL.conc_login_id,
422: object_version_number = l_msg_rec.object_version_number + 1,
423: date_effective_from = l_msg_rec.date_effective_from,
424: date_effective_to = l_msg_rec.date_effective_to,
417:
418: UPDATE AMS_MESSAGES_B SET
419: last_update_date = SYSDATE,
420: last_updated_by = FND_GLOBAL.user_id,
421: last_update_login = FND_GLOBAL.conc_login_id,
422: object_version_number = l_msg_rec.object_version_number + 1,
423: date_effective_from = l_msg_rec.date_effective_from,
424: date_effective_to = l_msg_rec.date_effective_to,
425: active_flag = l_msg_rec.active_flag,
453: END IF;
454:
455: UPDATE AMS_MESSAGES_TL SET
456: last_update_date = SYSDATE,
457: last_updated_by = FND_GLOBAL.user_id,
458: last_update_login = FND_GLOBAL.conc_login_id,
459: source_lang = USERENV('LANG'),
460: message_name = l_msg_rec.message_name,
461: description = l_msg_rec.description
454:
455: UPDATE AMS_MESSAGES_TL SET
456: last_update_date = SYSDATE,
457: last_updated_by = FND_GLOBAL.user_id,
458: last_update_login = FND_GLOBAL.conc_login_id,
459: source_lang = USERENV('LANG'),
460: message_name = l_msg_rec.message_name,
461: description = l_msg_rec.description
462: WHERE message_id = l_msg_rec.message_id