APPS.IEU_UWQ_MEDIA_TYPES_SEED_PKG dependencies on IEU_UWQ_MEDIA_TYPES_TL

Line 50: INSERT INTO ieu_uwq_media_types_tl (

46: p_uwq_media_types_rec.blended_flag,
47: p_uwq_media_types_rec.blended_dir
48: );
49:
50: INSERT INTO ieu_uwq_media_types_tl (
51: media_type_id,
52: language,
53: created_by,
54: creation_date,

Line 76: FROM ieu_uwq_media_types_tl t

72: FROM fnd_languages l
73: WHERE l.installed_flag IN ('I', 'B')
74: AND NOT EXISTS
75: (SELECT NULL
76: FROM ieu_uwq_media_types_tl t
77: WHERE t.media_type_id = p_uwq_media_types_rec.media_type_id
78: AND t.language = l.language_code);
79:
80: OPEN c;

Line 115: UPDATE ieu_uwq_media_types_tl SET

111: IF (SQL%NOTFOUND) THEN
112: RAISE no_data_found;
113: END IF;
114:
115: UPDATE ieu_uwq_media_types_tl SET
116: media_type_name = p_uwq_media_types_rec.media_type_name,
117: source_lang = USERENV('LANG'),
118: media_type_description = p_uwq_media_types_rec.media_type_description,
119: last_updated_by = p_uwq_media_types_rec.last_updated_by,

Line 215: UPDATE ieu_uwq_media_types_tl SET

211: BEGIN
212:
213: -- only UPDATE rows that have not been altered by user
214:
215: UPDATE ieu_uwq_media_types_tl SET
216: media_type_name = p_media_type_name,
217: source_lang = userenv('LANG'),
218: media_type_description = p_media_type_description,
219: last_update_date = sysdate,

Line 230: delete from IEU_UWQ_MEDIA_TYPES_TL T

226:
227: PROCEDURE ADD_LANGUAGE
228: is
229: begin
230: delete from IEU_UWQ_MEDIA_TYPES_TL T
231: where not exists
232: (select NULL
233: from IEU_UWQ_MEDIA_TYPES_B B
234: where B.MEDIA_TYPE_ID = T.MEDIA_TYPE_ID

Line 237: update IEU_UWQ_MEDIA_TYPES_TL T set (

233: from IEU_UWQ_MEDIA_TYPES_B B
234: where B.MEDIA_TYPE_ID = T.MEDIA_TYPE_ID
235: );
236:
237: update IEU_UWQ_MEDIA_TYPES_TL T set (
238: MEDIA_TYPE_NAME,
239: MEDIA_TYPE_DESCRIPTION
240: ) = (select
241: B.MEDIA_TYPE_NAME,

Line 243: from IEU_UWQ_MEDIA_TYPES_TL B

239: MEDIA_TYPE_DESCRIPTION
240: ) = (select
241: B.MEDIA_TYPE_NAME,
242: B.MEDIA_TYPE_DESCRIPTION
243: from IEU_UWQ_MEDIA_TYPES_TL B
244: where B.MEDIA_TYPE_ID = T.MEDIA_TYPE_ID
245: and B.LANGUAGE = T.SOURCE_LANG)
246: where (
247: T.MEDIA_TYPE_ID,

Line 252: from IEU_UWQ_MEDIA_TYPES_TL SUBB, IEU_UWQ_MEDIA_TYPES_TL SUBT

248: T.LANGUAGE
249: ) in (select
250: SUBT.MEDIA_TYPE_ID,
251: SUBT.LANGUAGE
252: from IEU_UWQ_MEDIA_TYPES_TL SUBB, IEU_UWQ_MEDIA_TYPES_TL SUBT
253: where SUBB.MEDIA_TYPE_ID = SUBT.MEDIA_TYPE_ID
254: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
255: and (SUBB.MEDIA_TYPE_NAME <> SUBT.MEDIA_TYPE_NAME
256: or SUBB.MEDIA_TYPE_DESCRIPTION <> SUBT.MEDIA_TYPE_DESCRIPTION

Line 261: insert into IEU_UWQ_MEDIA_TYPES_TL (

257: or (SUBB.MEDIA_TYPE_DESCRIPTION is null and SUBT.MEDIA_TYPE_DESCRIPTION is not null)
258: or (SUBB.MEDIA_TYPE_DESCRIPTION is not null and SUBT.MEDIA_TYPE_DESCRIPTION is null)
259: ));
260:
261: insert into IEU_UWQ_MEDIA_TYPES_TL (
262: MEDIA_TYPE_ID,
263: CREATED_BY,
264: CREATION_DATE,
265: LAST_UPDATED_BY,

Line 283: from IEU_UWQ_MEDIA_TYPES_TL B, FND_LANGUAGES L

279: B.MEDIA_TYPE_NAME,
280: B.MEDIA_TYPE_DESCRIPTION,
281: L.LANGUAGE_CODE,
282: B.SOURCE_LANG
283: from IEU_UWQ_MEDIA_TYPES_TL B, FND_LANGUAGES L
284: where L.INSTALLED_FLAG in ('I', 'B')
285: and B.LANGUAGE = userenv('LANG')
286: and not exists
287: (select NULL

Line 288: from IEU_UWQ_MEDIA_TYPES_TL T

284: where L.INSTALLED_FLAG in ('I', 'B')
285: and B.LANGUAGE = userenv('LANG')
286: and not exists
287: (select NULL
288: from IEU_UWQ_MEDIA_TYPES_TL T
289: where T.MEDIA_TYPE_ID = B.MEDIA_TYPE_ID
290: and T.LANGUAGE = L.LANGUAGE_CODE);
291: end ADD_LANGUAGE;
292:

Line 299: delete from IEU_UWQ_MEDIA_TYPES_TL

295: procedure DELETE_ROW (
296: X_MEDIA_TYPE_ID in NUMBER
297: ) is
298: begin
299: delete from IEU_UWQ_MEDIA_TYPES_TL
300: where MEDIA_TYPE_ID = X_MEDIA_TYPE_ID;
301:
302: if (sql%notfound) then
303: raise no_data_found;

Line 349: from IEU_UWQ_MEDIA_TYPES_TL

345: SOURCE_LANG,
346: MEDIA_TYPE_DESCRIPTION,
347: OBJECT_VERSION_NUMBER,
348: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
349: from IEU_UWQ_MEDIA_TYPES_TL
350: where MEDIA_TYPE_ID = X_MEDIA_TYPE_ID
351: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
352: for update of MEDIA_TYPE_ID nowait;
353: