190: -- creation_date = p_last_update_date,
191: -- created_by = l_user,
192: last_update_date = f_ludate,
193: last_updated_by = l_user,
194: last_update_login = fnd_global.login_id
195: where
196: cs_definition_id = l_definition_id;
197:
198: update msd_cs_definitions_TL set
198: update msd_cs_definitions_TL set
199: description = p_description,
200: LAST_UPDATE_DATE = f_ludate,
201: LAST_UPDATED_BY = l_user,
202: LAST_UPDATE_LOGIN = fnd_global.login_id,
203: SOURCE_LANG = userenv('LANG')
204: where
205: cs_definition_id = l_definition_id
206: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
235: -- creation_date = f_ludate,
236: -- created_by = l_user,
237: last_update_date = f_ludate,
238: last_updated_by = l_user,
239: last_update_login = fnd_global.login_id
240: where
241: cs_definition_id = l_definition_id;
242:
243: end if;
270: l.language_code,
271: userenv('LANG'),
272: l_user,
273: f_ludate,
274: fnd_global.user_id,
275: f_ludate,
276: fnd_global.login_id
277: from fnd_languages l
278: where l.installed_flag in ('I','B');
272: l_user,
273: f_ludate,
274: fnd_global.user_id,
275: f_ludate,
276: fnd_global.login_id
277: from fnd_languages l
278: where l.installed_flag in ('I','B');
279: /* and not exists (select null
280: from msd_cs_definitions_TL
408: f_ludate,
409: l_user,
410: f_ludate,
411: l_user,
412: fnd_global.login_id
413: );
414:
415: insert into msd_cs_definitions_TL(
416: cs_definition_id,
427: l_definition_id,
428: p_description,
429: l.language_code,
430: userenv('LANG'),
431: fnd_global.user_id,
432: f_ludate,
433: fnd_global.user_id,
434: f_ludate,
435: fnd_global.login_id
429: l.language_code,
430: userenv('LANG'),
431: fnd_global.user_id,
432: f_ludate,
433: fnd_global.user_id,
434: f_ludate,
435: fnd_global.login_id
436: from fnd_languages l
437: where l.installed_flag in ('I','B');
431: fnd_global.user_id,
432: f_ludate,
433: fnd_global.user_id,
434: f_ludate,
435: fnd_global.login_id
436: from fnd_languages l
437: where l.installed_flag in ('I','B');
438: End;
439:
454: update msd_cs_definitions_TL set
455: description = p_description,
456: LAST_UPDATE_DATE = sysdate,
457: LAST_UPDATED_BY = l_user,
458: LAST_UPDATE_LOGIN = fnd_global.login_id,
459: SOURCE_LANG = userenv('LANG')
460: where
461: cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = p_name)
462: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);