APPS.AMS_USER_STATUSES_PVT dependencies on AMS_USER_STATUSES_B

Line 96: SELECT ams_user_statuses_b_s.NEXTVAL

92: l_User_Status_rec User_Status_Rec_Type := p_user_status_rec;
93: l_dummy NUMBER;
94: l_return_status VARCHAR2(1);
95: CURSOR c_seq IS
96: SELECT ams_user_statuses_b_s.NEXTVAL
97: FROM dual;
98: CURSOR c_id_exists (x_id IN NUMBER) IS
99: SELECT 1
100: FROM dual

Line 176: INSERT INTO ams_user_statuses_b (

172: END IF;
173: --
174: -- Insert into mutli-language supported table.
175: --
176: INSERT INTO ams_user_statuses_b (
177: user_status_id,
178: -- standard who columns
179: last_update_date,
180: last_updated_by,

Line 377: UPDATE ams_user_statuses_b

373:
374: END IF; -- check for seeded flag
375:
376: IF l_user_status_rec.default_flag = 'Y' THEN
377: UPDATE ams_user_statuses_b
378: SET
379: default_flag = 'N'
380: WHERE system_status_type = l_user_status_rec.system_status_type
381: AND system_status_code = l_user_status_rec.system_status_code;

Line 409: UPDATE ams_user_statuses_b

405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407: END IF;
408:
409: UPDATE ams_user_statuses_b
410: SET
411: last_update_date = SYSDATE,
412: last_updated_by = FND_GLOBAL.User_Id,
413: last_update_login = FND_GLOBAL.Conc_Login_Id,

Line 574: DELETE FROM ams_user_statuses_b

570: FND_MSG_PUB.add;
571: END IF;
572: RAISE FND_API.g_exc_error;
573: END IF;
574: DELETE FROM ams_user_statuses_b
575: WHERE user_status_id = p_user_status_id
576: AND object_version_number = p_object_version;
577:
578: ELSE