APPS.AMS_CHANNEL_PVT dependencies on AMS_CHANNELS_TL

Line 239: INSERT INTO ams_channels_tl(

235: --l_chan_rec.internal_resource
236: --end 12/07/00
237: );
238:
239: INSERT INTO ams_channels_tl(
240: channel_id,
241: language,
242: last_update_date,
243: last_updated_by,

Line 266: FROM ams_channels_tl t

262: FROM fnd_languages l
263: WHERE l.installed_flag in ('I', 'B')
264: AND NOT EXISTS(
265: SELECT NULL
266: FROM ams_channels_tl t
267: WHERE t.channel_id = l_chan_rec.channel_id
268: AND t.language = l.language_code );
269:
270:

Line 452: DELETE FROM ams_channels_tl

448: END IF;
449: RAISE FND_API.g_exc_error;
450: END IF;
451:
452: DELETE FROM ams_channels_tl
453: WHERE channel_id = p_chan_id;
454:
455: IF (SQL%NOTFOUND) THEN
456: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 556: FROM ams_channels_tl

552: FOR UPDATE NOWAIT;
553:
554: CURSOR c_chan_tl IS
555: SELECT channel_id
556: FROM ams_channels_tl
557: WHERE channel_id = p_chan_id
558: AND USERENV('LANG') IN (language, source_lang)
559: FOR UPDATE NOWAIT;
560:

Line 831: update ams_channels_tl set

827: END IF;
828: RAISE FND_API.g_exc_error;
829: END IF;
830:
831: update ams_channels_tl set
832: channel_name = l_chan_rec.channel_name,
833: description = l_chan_rec.description,
834: last_update_date = SYSDATE,
835: last_updated_by = FND_GLOBAL.user_id,