APPS.AMS_USER_STATUSES_PKG dependencies on AMS_USER_STATUSES_TL

Line 65: insert into AMS_USER_STATUSES_TL (

61: X_LAST_UPDATE_LOGIN,
62: X_APPLICATION_ID
63: );
64:
65: insert into AMS_USER_STATUSES_TL (
66: USER_STATUS_ID,
67: LAST_UPDATE_DATE,
68: LAST_UPDATED_BY,
69: CREATION_DATE,

Line 91: from AMS_USER_STATUSES_TL T

87: from FND_LANGUAGES L
88: where L.INSTALLED_FLAG in ('I', 'B')
89: and not exists
90: (select NULL
91: from AMS_USER_STATUSES_TL T
92: where T.USER_STATUS_ID = X_USER_STATUS_ID
93: and T.LANGUAGE = L.LANGUAGE_CODE);
94:
95: open c;

Line 136: from AMS_USER_STATUSES_TL

132: cursor c1 is select
133: NAME,
134: DESCRIPTION,
135: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
136: from AMS_USER_STATUSES_TL
137: where USER_STATUS_ID = X_USER_STATUS_ID
138: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
139: for update of USER_STATUS_ID nowait;
140: begin

Line 260: update AMS_USER_STATUSES_TL set

256: if (sql%notfound) then
257: raise no_data_found;
258: end if;
259:
260: update AMS_USER_STATUSES_TL set
261: NAME = X_NAME,
262: DESCRIPTION = X_DESCRIPTION,
263: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
264: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 279: delete from AMS_USER_STATUSES_TL

275: procedure DELETE_ROW (
276: X_USER_STATUS_ID in NUMBER
277: ) is
278: begin
279: delete from AMS_USER_STATUSES_TL
280: where USER_STATUS_ID = X_USER_STATUS_ID;
281:
282: if (sql%notfound) then
283: raise no_data_found;

Line 297: delete from AMS_USER_STATUSES_TL T

293:
294: procedure ADD_LANGUAGE
295: is
296: begin
297: delete from AMS_USER_STATUSES_TL T
298: where not exists
299: (select NULL
300: from AMS_USER_STATUSES_B B
301: where B.USER_STATUS_ID = T.USER_STATUS_ID

Line 304: update AMS_USER_STATUSES_TL T set (

300: from AMS_USER_STATUSES_B B
301: where B.USER_STATUS_ID = T.USER_STATUS_ID
302: );
303:
304: update AMS_USER_STATUSES_TL T set (
305: NAME,
306: DESCRIPTION
307: ) = (select
308: B.NAME,

Line 310: from AMS_USER_STATUSES_TL B

306: DESCRIPTION
307: ) = (select
308: B.NAME,
309: B.DESCRIPTION
310: from AMS_USER_STATUSES_TL B
311: where B.USER_STATUS_ID = T.USER_STATUS_ID
312: and B.LANGUAGE = T.SOURCE_LANG)
313: where (
314: T.USER_STATUS_ID,

Line 319: from AMS_USER_STATUSES_TL SUBB, AMS_USER_STATUSES_TL SUBT

315: T.LANGUAGE
316: ) in (select
317: SUBT.USER_STATUS_ID,
318: SUBT.LANGUAGE
319: from AMS_USER_STATUSES_TL SUBB, AMS_USER_STATUSES_TL SUBT
320: where SUBB.USER_STATUS_ID = SUBT.USER_STATUS_ID
321: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
322: and (SUBB.NAME <> SUBT.NAME
323: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 330: insert into AMS_USER_STATUSES_TL (

326: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
327: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
328: ));
329:
330: insert into AMS_USER_STATUSES_TL (
331: USER_STATUS_ID,
332: LAST_UPDATE_DATE,
333: LAST_UPDATED_BY,
334: CREATION_DATE,

Line 352: from AMS_USER_STATUSES_TL B, FND_LANGUAGES L

348: B.NAME,
349: B.DESCRIPTION,
350: L.LANGUAGE_CODE,
351: B.SOURCE_LANG
352: from AMS_USER_STATUSES_TL B, FND_LANGUAGES L
353: where L.INSTALLED_FLAG in ('I', 'B')
354: and B.LANGUAGE = userenv('LANG')
355: and not exists
356: (select NULL

Line 357: from AMS_USER_STATUSES_TL T

353: where L.INSTALLED_FLAG in ('I', 'B')
354: and B.LANGUAGE = userenv('LANG')
355: and not exists
356: (select NULL
357: from AMS_USER_STATUSES_TL T
358: where T.USER_STATUS_ID = B.USER_STATUS_ID
359: and T.LANGUAGE = L.LANGUAGE_CODE);
360: end ADD_LANGUAGE;
361:

Line 372: update AMS_USER_STATUSES_TL set

368: X_OWNER in VARCHAR2
369: ) IS
370:
371: begin
372: update AMS_USER_STATUSES_TL set
373: name = nvl(x_name, name),
374: description = nvl(x_description, description),
375: source_lang = userenv('LANG'),
376: last_update_date = sysdate,