APPS.AMS_USER_STATUSES_PVT dependencies on AMS_USER_STATUSES_TL

Line 212: INSERT INTO ams_user_statuses_tl (

208: l_user_status_rec.start_date_active,
209: l_user_status_rec.end_date_active,
210: fnd_global.resp_appl_id -- added to capture application_id
211: );
212: INSERT INTO ams_user_statuses_tl (
213: user_status_id,
214: language,
215: last_update_date,
216: last_updated_by,

Line 238: FROM ams_user_statuses_tl t

234: l_user_status_rec.description
235: FROM fnd_languages l
236: WHERE l.installed_flag IN ('I', 'B')
237: AND NOT EXISTS (SELECT NULL
238: FROM ams_user_statuses_tl t
239: WHERE t.user_status_id = l_user_status_rec.user_status_id
240: AND t.language = l.language_code);
241: ------------------------- finish -------------------------------
242: -- set OUT value

Line 431: UPDATE ams_user_statuses_tl

427: FND_MSG_PUB.add;
428: END IF;
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;
431: UPDATE ams_user_statuses_tl
432: SET
433: last_update_date = SYSDATE,
434: last_updated_by = FND_GLOBAL.User_Id,
435: last_update_login = FND_GLOBAL.Conc_Login_Id,

Line 564: DELETE FROM ams_user_statuses_tl

560:
561: IF l_user_status_rec.seeded_flag='N'
562: THEN
563:
564: DELETE FROM ams_user_statuses_tl
565: WHERE user_status_id = p_user_status_id;
566: IF (SQL%NOTFOUND) THEN
567: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error)
568: THEN