APPS.IEU_UWQ_MACTION_DEFS_SEED_PVT dependencies on IEU_UWQ_MACTION_DEFS_TL

Line 34: INSERT INTO ieu_uwq_maction_defs_tl (

30: p_uwq_maction_defs_rec.action_proc,
31: p_uwq_maction_defs_rec.application_id
32: );
33:
34: INSERT INTO ieu_uwq_maction_defs_tl (
35: maction_def_id,
36: language,
37: created_by,
38: creation_date,

Line 60: FROM ieu_uwq_maction_defs_tl t

56: FROM fnd_languages l
57: WHERE l.installed_flag IN ('I', 'B')
58: AND NOT EXISTS
59: (SELECT NULL
60: FROM ieu_uwq_maction_defs_tl t
61: WHERE t.maction_def_id = p_uwq_maction_defs_rec.maction_def_id
62: AND t.language = l.language_code);
63:
64: OPEN c;

Line 90: UPDATE ieu_uwq_maction_defs_tl SET

86: IF (SQL%NOTFOUND) THEN
87: RAISE no_data_found;
88: END IF;
89:
90: UPDATE ieu_uwq_maction_defs_tl SET
91: action_user_label = p_uwq_maction_defs_rec.action_user_label,
92: source_lang = USERENV('LANG'),
93: action_description = p_uwq_maction_defs_rec.action_description,
94: last_updated_by = p_uwq_maction_defs_rec.last_updated_by,

Line 172: UPDATE ieu_uwq_maction_defs_tl SET

168: BEGIN
169:
170: -- only UPDATE rows that have not been altered by user
171:
172: UPDATE ieu_uwq_maction_defs_tl SET
173: action_user_label = p_action_user_label,
174: source_lang = userenv('LANG'),
175: action_description = p_action_description,
176: last_update_date = sysdate,

Line 187: delete from IEU_UWQ_MACTION_DEFS_TL T

183:
184: procedure ADD_LANGUAGE
185: is
186: begin
187: delete from IEU_UWQ_MACTION_DEFS_TL T
188: where not exists
189: (select NULL
190: from IEU_UWQ_MACTION_DEFS_B B
191: where B.MACTION_DEF_ID = T.MACTION_DEF_ID

Line 194: update IEU_UWQ_MACTION_DEFS_TL T set (

190: from IEU_UWQ_MACTION_DEFS_B B
191: where B.MACTION_DEF_ID = T.MACTION_DEF_ID
192: );
193:
194: update IEU_UWQ_MACTION_DEFS_TL T set (
195: ACTION_USER_LABEL,
196: ACTION_DESCRIPTION
197: ) = (select
198: B.ACTION_USER_LABEL,

Line 200: from IEU_UWQ_MACTION_DEFS_TL B

196: ACTION_DESCRIPTION
197: ) = (select
198: B.ACTION_USER_LABEL,
199: B.ACTION_DESCRIPTION
200: from IEU_UWQ_MACTION_DEFS_TL B
201: where B.MACTION_DEF_ID = T.MACTION_DEF_ID
202: and B.LANGUAGE = T.SOURCE_LANG)
203: where (
204: T.MACTION_DEF_ID,

Line 209: from IEU_UWQ_MACTION_DEFS_TL SUBB, IEU_UWQ_MACTION_DEFS_TL SUBT

205: T.LANGUAGE
206: ) in (select
207: SUBT.MACTION_DEF_ID,
208: SUBT.LANGUAGE
209: from IEU_UWQ_MACTION_DEFS_TL SUBB, IEU_UWQ_MACTION_DEFS_TL SUBT
210: where SUBB.MACTION_DEF_ID = SUBT.MACTION_DEF_ID
211: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
212: and (SUBB.ACTION_USER_LABEL <> SUBT.ACTION_USER_LABEL
213: or SUBB.ACTION_DESCRIPTION <> SUBT.ACTION_DESCRIPTION

Line 218: insert into IEU_UWQ_MACTION_DEFS_TL (

214: or (SUBB.ACTION_DESCRIPTION is null and SUBT.ACTION_DESCRIPTION is not null)
215: or (SUBB.ACTION_DESCRIPTION is not null and SUBT.ACTION_DESCRIPTION is null)
216: ));
217:
218: insert into IEU_UWQ_MACTION_DEFS_TL (
219: ACTION_DESCRIPTION,
220: CREATION_DATE,
221: LAST_UPDATED_BY,
222: LAST_UPDATE_DATE,

Line 240: from IEU_UWQ_MACTION_DEFS_TL B, FND_LANGUAGES L

236: B.MACTION_DEF_ID,
237: B.CREATED_BY,
238: L.LANGUAGE_CODE,
239: B.SOURCE_LANG
240: from IEU_UWQ_MACTION_DEFS_TL B, FND_LANGUAGES L
241: where L.INSTALLED_FLAG in ('I', 'B')
242: and B.LANGUAGE = userenv('LANG')
243: and not exists
244: (select NULL

Line 245: from IEU_UWQ_MACTION_DEFS_TL T

241: where L.INSTALLED_FLAG in ('I', 'B')
242: and B.LANGUAGE = userenv('LANG')
243: and not exists
244: (select NULL
245: from IEU_UWQ_MACTION_DEFS_TL T
246: where T.MACTION_DEF_ID = B.MACTION_DEF_ID
247: and T.LANGUAGE = L.LANGUAGE_CODE);
248: end ADD_LANGUAGE;
249: