APPS.AMS_CHANNELS_PKG dependencies on AMS_CHANNELS_TL

Line 115: insert into AMS_CHANNELS_TL (

111: X_LAST_UPDATED_BY,
112: X_LAST_UPDATE_LOGIN
113: );
114:
115: insert into AMS_CHANNELS_TL (
116: CHANNEL_ID,
117: LAST_UPDATE_DATE,
118: LAST_UPDATED_BY,
119: CREATION_DATE,

Line 141: from AMS_CHANNELS_TL T

137: from FND_LANGUAGES L
138: where L.INSTALLED_FLAG in ('I', 'B')
139: and not exists
140: (select NULL
141: from AMS_CHANNELS_TL T
142: where T.CHANNEL_ID = X_CHANNEL_ID
143: and T.LANGUAGE = L.LANGUAGE_CODE);
144:
145: open c;

Line 224: from AMS_CHANNELS_TL

220: cursor c1 is select
221: CHANNEL_NAME,
222: DESCRIPTION,
223: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
224: from AMS_CHANNELS_TL
225: where CHANNEL_ID = X_CHANNEL_ID
226: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
227: for update of CHANNEL_ID nowait;
228: begin

Line 381: update AMS_CHANNELS_TL set

377: if (sql%notfound) then
378: raise no_data_found;
379: end if;
380:
381: update AMS_CHANNELS_TL set
382: CHANNEL_NAME = X_CHANNEL_NAME,
383: DESCRIPTION = X_DESCRIPTION,
384: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
385: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 400: delete from AMS_CHANNELS_TL

396: procedure DELETE_ROW (
397: X_CHANNEL_ID in NUMBER
398: ) is
399: begin
400: delete from AMS_CHANNELS_TL
401: where CHANNEL_ID = X_CHANNEL_ID;
402:
403: if (sql%notfound) then
404: raise no_data_found;

Line 418: delete from AMS_CHANNELS_TL T

414:
415: procedure ADD_LANGUAGE
416: is
417: begin
418: delete from AMS_CHANNELS_TL T
419: where not exists
420: (select NULL
421: from AMS_CHANNELS_B B
422: where B.CHANNEL_ID = T.CHANNEL_ID

Line 425: update AMS_CHANNELS_TL T set (

421: from AMS_CHANNELS_B B
422: where B.CHANNEL_ID = T.CHANNEL_ID
423: );
424:
425: update AMS_CHANNELS_TL T set (
426: CHANNEL_NAME,
427: DESCRIPTION
428: ) = (select
429: B.CHANNEL_NAME,

Line 431: from AMS_CHANNELS_TL B

427: DESCRIPTION
428: ) = (select
429: B.CHANNEL_NAME,
430: B.DESCRIPTION
431: from AMS_CHANNELS_TL B
432: where B.CHANNEL_ID = T.CHANNEL_ID
433: and B.LANGUAGE = T.SOURCE_LANG)
434: where (
435: T.CHANNEL_ID,

Line 440: from AMS_CHANNELS_TL SUBB, AMS_CHANNELS_TL SUBT

436: T.LANGUAGE
437: ) in (select
438: SUBT.CHANNEL_ID,
439: SUBT.LANGUAGE
440: from AMS_CHANNELS_TL SUBB, AMS_CHANNELS_TL SUBT
441: where SUBB.CHANNEL_ID = SUBT.CHANNEL_ID
442: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
443: and (SUBB.CHANNEL_NAME <> SUBT.CHANNEL_NAME
444: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 449: insert into AMS_CHANNELS_TL (

445: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
446: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
447: ));
448:
449: insert into AMS_CHANNELS_TL (
450: CHANNEL_ID,
451: LAST_UPDATE_DATE,
452: LAST_UPDATED_BY,
453: CREATION_DATE,

Line 471: from AMS_CHANNELS_TL B, FND_LANGUAGES L

467: B.CHANNEL_NAME,
468: B.DESCRIPTION,
469: L.LANGUAGE_CODE,
470: B.SOURCE_LANG
471: from AMS_CHANNELS_TL B, FND_LANGUAGES L
472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL

Line 476: from AMS_CHANNELS_TL T

472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL
476: from AMS_CHANNELS_TL T
477: where T.CHANNEL_ID = B.CHANNEL_ID
478: and T.LANGUAGE = L.LANGUAGE_CODE);
479: end ADD_LANGUAGE;
480:

Line 489: update AMS_CHANNELS_TL set

485: , x_description in VARCHAR2
486: , x_owner in VARCHAR2
487: ) is
488: begin
489: update AMS_CHANNELS_TL set
490: channel_name = nvl(x_channel_name, channel_name),
491: description = nvl(x_description, description),
492: source_lang = userenv('LANG'),
493: last_update_date = sysdate,