APPS.AMS_MEDIA_PKG dependencies on AMS_MEDIA_TL

Line 97: insert into AMS_MEDIA_TL (

93: X_LAST_UPDATE_LOGIN,
94: X_DEDUPE_RULE_ID
95: );
96:
97: insert into AMS_MEDIA_TL (
98: MEDIA_NAME,
99: DESCRIPTION,
100: MEDIA_ID,
101: LAST_UPDATE_DATE,

Line 123: from AMS_MEDIA_TL T

119: from FND_LANGUAGES L
120: where L.INSTALLED_FLAG in ('I', 'B')
121: and not exists
122: (select NULL
123: from AMS_MEDIA_TL T
124: where T.MEDIA_ID = X_MEDIA_ID
125: and T.LANGUAGE = L.LANGUAGE_CODE);
126:
127: open c;

Line 208: update AMS_MEDIA_TL set

204:
205: following code is modified by soagrawa on 13-Jan-2003
206: The seeded activities can be updated for name and description
207: */
208: update AMS_MEDIA_TL set
209: MEDIA_NAME = X_MEDIA_NAME,
210: DESCRIPTION = X_DESCRIPTION,
211: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
212: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 227: delete from AMS_MEDIA_TL

223: procedure DELETE_ROW (
224: X_MEDIA_ID in NUMBER
225: ) is
226: begin
227: delete from AMS_MEDIA_TL
228: where MEDIA_ID = X_MEDIA_ID;
229:
230: if (sql%notfound) then
231: raise no_data_found;

Line 245: delete from AMS_MEDIA_TL T

241:
242: procedure ADD_LANGUAGE
243: is
244: begin
245: delete from AMS_MEDIA_TL T
246: where not exists
247: (select NULL
248: from AMS_MEDIA_B B
249: where B.MEDIA_ID = T.MEDIA_ID

Line 252: update AMS_MEDIA_TL T set (

248: from AMS_MEDIA_B B
249: where B.MEDIA_ID = T.MEDIA_ID
250: );
251:
252: update AMS_MEDIA_TL T set (
253: MEDIA_NAME,
254: DESCRIPTION
255: ) = (select
256: B.MEDIA_NAME,

Line 258: from AMS_MEDIA_TL B

254: DESCRIPTION
255: ) = (select
256: B.MEDIA_NAME,
257: B.DESCRIPTION
258: from AMS_MEDIA_TL B
259: where B.MEDIA_ID = T.MEDIA_ID
260: and B.LANGUAGE = T.SOURCE_LANG)
261: where (
262: T.MEDIA_ID,

Line 267: from AMS_MEDIA_TL SUBB, AMS_MEDIA_TL SUBT

263: T.LANGUAGE
264: ) in (select
265: SUBT.MEDIA_ID,
266: SUBT.LANGUAGE
267: from AMS_MEDIA_TL SUBB, AMS_MEDIA_TL SUBT
268: where SUBB.MEDIA_ID = SUBT.MEDIA_ID
269: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
270: and (SUBB.MEDIA_NAME <> SUBT.MEDIA_NAME
271: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 276: insert into AMS_MEDIA_TL (

272: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
273: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
274: ));
275:
276: insert into AMS_MEDIA_TL (
277: MEDIA_NAME,
278: DESCRIPTION,
279: MEDIA_ID,
280: LAST_UPDATE_DATE,

Line 298: from AMS_MEDIA_TL B, FND_LANGUAGES L

294: B.CREATED_BY,
295: B.LAST_UPDATE_LOGIN,
296: L.LANGUAGE_CODE,
297: B.SOURCE_LANG
298: from AMS_MEDIA_TL B, FND_LANGUAGES L
299: where L.INSTALLED_FLAG in ('I', 'B')
300: and B.LANGUAGE = userenv('LANG')
301: and not exists
302: (select NULL

Line 303: from AMS_MEDIA_TL T

299: where L.INSTALLED_FLAG in ('I', 'B')
300: and B.LANGUAGE = userenv('LANG')
301: and not exists
302: (select NULL
303: from AMS_MEDIA_TL T
304: where T.MEDIA_ID = B.MEDIA_ID
305: and T.LANGUAGE = L.LANGUAGE_CODE);
306: end ADD_LANGUAGE;
307:

Line 316: update AMS_MEDIA_TL set

312: , x_description in VARCHAR2
313: , x_owner in VARCHAR2
314: ) is
315: begin
316: update AMS_MEDIA_TL set
317: media_name = nvl(x_media_name, media_name),
318: description = nvl(x_description, description),
319: source_lang = userenv('LANG'),
320: last_update_date = sysdate,