APPS.AMS_MEDIA_PVT dependencies on AMS_MEDIA_TL

Line 378: INSERT INTO ams_media_tl (

374: l_media_rec.attribute14,
375: l_media_rec.attribute15
376: );
377:
378: INSERT INTO ams_media_tl (
379: media_id,
380: language,
381: last_update_date,
382: last_updated_by,

Line 404: FROM ams_media_tl t

400: l_media_rec.description
401: FROM fnd_languages l
402: WHERE l.installed_flag IN ('I', 'B')
403: AND NOT EXISTS (SELECT NULL
404: FROM ams_media_tl t
405: WHERE t.media_id = l_media_rec.media_id
406: AND t.language = l.language_code);
407:
408: ------------------------- finish -------------------------------

Line 620: UPDATE ams_media_tl

616: END IF;
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619:
620: UPDATE ams_media_tl
621: SET
622: last_update_date = SYSDATE,
623: last_updated_by = FND_GLOBAL.User_Id,
624: last_update_login = FND_GLOBAL.Conc_Login_Id,

Line 810: DELETE FROM ams_media_tl

806:
807: -- end abhola
808:
809: -- Delete TL data
810: DELETE FROM ams_media_tl
811: WHERE media_id = p_media_id ;
812:
813:
814: IF (SQL%NOTFOUND) THEN