[Home] [Help]
39: p_uwq_maction_defs_rec.maction_def_key,
40: p_uwq_maction_defs_rec.application_id
41: );
42:
43: INSERT INTO ieu_uwq_maction_defs_tl (
44: maction_def_id,
45: language,
46: created_by,
47: creation_date,
65: FROM fnd_languages l
66: WHERE l.installed_flag IN ('I', 'B')
67: AND NOT EXISTS
68: (SELECT NULL
69: FROM ieu_uwq_maction_defs_tl t
70: WHERE t.maction_def_id = p_uwq_maction_defs_rec.maction_def_id
71: AND t.language = l.language_code);
72:
73: OPEN c;
101: IF (SQL%NOTFOUND) THEN
102: RAISE no_data_found;
103: END IF;
104:
105: UPDATE ieu_uwq_maction_defs_tl SET
106: action_user_label = p_uwq_maction_defs_rec.action_user_label,
107: source_lang = USERENV('LANG'),
108: action_description = p_uwq_maction_defs_rec.action_description,
109: last_updated_by = p_uwq_maction_defs_rec.last_updated_by,
211: -- only UPDATE rows that have not been altered by user
212:
213: user_id := fnd_load_util.owner_id(P_OWNER);
214:
215: UPDATE ieu_uwq_maction_defs_tl SET
216: action_user_label = p_action_user_label,
217: source_lang = userenv('LANG'),
218: action_description = p_action_description,
219: last_update_date = decode(p_last_update_date, null, sysdate, to_date(p_last_update_date, 'YYYY/MM/DD')),
226:
227: procedure ADD_LANGUAGE
228: is
229: begin
230: delete from IEU_UWQ_MACTION_DEFS_TL T
231: where not exists
232: (select NULL
233: from IEU_UWQ_MACTION_DEFS_B B
234: where B.MACTION_DEF_ID = T.MACTION_DEF_ID
233: from IEU_UWQ_MACTION_DEFS_B B
234: where B.MACTION_DEF_ID = T.MACTION_DEF_ID
235: );
236:
237: update IEU_UWQ_MACTION_DEFS_TL T set (
238: ACTION_USER_LABEL,
239: ACTION_DESCRIPTION
240: ) = (select
241: B.ACTION_USER_LABEL,
239: ACTION_DESCRIPTION
240: ) = (select
241: B.ACTION_USER_LABEL,
242: B.ACTION_DESCRIPTION
243: from IEU_UWQ_MACTION_DEFS_TL B
244: where B.MACTION_DEF_ID = T.MACTION_DEF_ID
245: and B.LANGUAGE = T.SOURCE_LANG)
246: where (
247: T.MACTION_DEF_ID,
248: T.LANGUAGE
249: ) in (select
250: SUBT.MACTION_DEF_ID,
251: SUBT.LANGUAGE
252: from IEU_UWQ_MACTION_DEFS_TL SUBB, IEU_UWQ_MACTION_DEFS_TL SUBT
253: where SUBB.MACTION_DEF_ID = SUBT.MACTION_DEF_ID
254: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
255: and (SUBB.ACTION_USER_LABEL <> SUBT.ACTION_USER_LABEL
256: or SUBB.ACTION_DESCRIPTION <> SUBT.ACTION_DESCRIPTION
257: or (SUBB.ACTION_DESCRIPTION is null and SUBT.ACTION_DESCRIPTION is not null)
258: or (SUBB.ACTION_DESCRIPTION is not null and SUBT.ACTION_DESCRIPTION is null)
259: ));
260:
261: insert into IEU_UWQ_MACTION_DEFS_TL (
262: ACTION_DESCRIPTION,
263: CREATION_DATE,
264: LAST_UPDATED_BY,
265: LAST_UPDATE_DATE,
281: B.CREATED_BY,
282: 1,
283: L.LANGUAGE_CODE,
284: B.SOURCE_LANG
285: from IEU_UWQ_MACTION_DEFS_TL B, FND_LANGUAGES L
286: where L.INSTALLED_FLAG in ('I', 'B')
287: and B.LANGUAGE = userenv('LANG')
288: and not exists
289: (select NULL
286: where L.INSTALLED_FLAG in ('I', 'B')
287: and B.LANGUAGE = userenv('LANG')
288: and not exists
289: (select NULL
290: from IEU_UWQ_MACTION_DEFS_TL T
291: where T.MACTION_DEF_ID = B.MACTION_DEF_ID
292: and T.LANGUAGE = L.LANGUAGE_CODE);
293: end ADD_LANGUAGE;
294:
318: cursor c1 is select
319: ACTION_USER_LABEL,
320: ACTION_DESCRIPTION,
321: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
322: from IEU_UWQ_MACTION_DEFS_TL
323: where MACTION_DEF_ID = X_MACTION_DEF_ID
324: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
325: for update of MACTION_DEF_ID nowait;
326: begin
366: procedure DELETE_ROW (
367: X_MACTION_DEF_ID in NUMBER
368: ) is
369: begin
370: delete from IEU_UWQ_MACTION_DEFS_TL
371: where MACTION_DEF_ID = X_MACTION_DEF_ID;
372:
373: if (sql%notfound) then
374: raise no_data_found;