801: l_venue_rec.attribute14,
802: l_venue_rec.attribute15
803: );
804:
805: INSERT INTO ams_venues_tl (
806: venue_id,
807: language,
808: last_update_date,
809: last_updated_by,
827: l_venue_rec.description
828: FROM fnd_languages l
829: WHERE l.installed_flag IN ('I', 'B')
830: AND NOT EXISTS (SELECT NULL
831: FROM ams_venues_tl t
832: WHERE t.venue_id = l_venue_rec.venue_id
833: AND t.language = l.language_code);
834:
835: ------------------------- finish -------------------------------
1372: l_rec_cnt := 0;
1373:
1374: SELECT count(*)
1375: INTO l_rec_cnt
1376: FROM ams_venues_tl
1377: where venue_id <> l_venue_rec.venue_id
1378: and venue_name = l_venue_rec.venue_name
1379: and SOURCE_LANG = USERENV('LANG');
1380:
1446: END IF;
1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1448: END IF;
1449:
1450: UPDATE ams_venues_tl
1451: SET
1452: last_update_date = SYSDATE,
1453: last_updated_by = FND_GLOBAL.User_Id,
1454: last_update_login = FND_GLOBAL.Conc_Login_Id,
1573: AMS_Utility_PVT.debug_message (l_full_name || ': Delete');
1574: END IF;
1575:
1576: -- Delete TL data
1577: DELETE FROM ams_venues_tl
1578: WHERE venue_id = p_venue_id;
1579:
1580: IF (SQL%NOTFOUND) THEN
1581: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN