54: identifier_type = p_identifier_type,
55: system_flag = p_system_flag,
56: last_update_date = sysdate,
57: last_updated_by = l_user,
58: last_update_login = fnd_global.login_id
59: where
60: column_identifier = p_column_identifier;
61:
62: if (sql%notfound) then
67: description = p_description,
68: user_prompt = p_user_prompt,
69: LAST_UPDATE_DATE = sysdate,
70: LAST_UPDATED_BY = l_user,
71: LAST_UPDATE_LOGIN = fnd_global.login_id,
72: SOURCE_LANG = userenv('LANG')
73: where
74: column_identifier = p_column_identifier
75: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
93: p_description,
94: p_user_prompt,
95: l.language_code,
96: userenv('LANG'),
97: fnd_global.user_id,
98: sysdate,
99: fnd_global.user_id,
100: sysdate,
101: fnd_global.login_id
95: l.language_code,
96: userenv('LANG'),
97: fnd_global.user_id,
98: sysdate,
99: fnd_global.user_id,
100: sysdate,
101: fnd_global.login_id
102: from fnd_languages l
103: where l.installed_flag in ('I','B');
97: fnd_global.user_id,
98: sysdate,
99: fnd_global.user_id,
100: sysdate,
101: fnd_global.login_id
102: from fnd_languages l
103: where l.installed_flag in ('I','B');
104: /* and not exists (select null
105: from msd_cs_definitions_TL
147: l_user,
148: sysdate,
149: l_user,
150: sysdate,
151: fnd_global.login_id
152: );
153:
154: insert into msd_cs_clmn_identifiers_TL(
155: column_identifier,
168: p_description,
169: p_user_prompt,
170: l.language_code,
171: userenv('LANG'),
172: fnd_global.user_id,
173: sysdate,
174: fnd_global.user_id,
175: sysdate,
176: fnd_global.login_id
170: l.language_code,
171: userenv('LANG'),
172: fnd_global.user_id,
173: sysdate,
174: fnd_global.user_id,
175: sysdate,
176: fnd_global.login_id
177: from fnd_languages l
178: where l.installed_flag in ('I','B');
172: fnd_global.user_id,
173: sysdate,
174: fnd_global.user_id,
175: sysdate,
176: fnd_global.login_id
177: from fnd_languages l
178: where l.installed_flag in ('I','B');
179: End;
180:
196: description = p_description,
197: user_prompt = p_user_prompt,
198: LAST_UPDATE_DATE = sysdate,
199: LAST_UPDATED_BY = l_user,
200: LAST_UPDATE_LOGIN = fnd_global.login_id,
201: SOURCE_LANG = userenv('LANG')
202: where
203: column_identifier = p_column_identifier
204: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);