APPS.AMS_MESSAGES_PKG dependencies on AMS_MESSAGES_TL

Line 52: insert into AMS_MESSAGES_TL (

48: X_LAST_UPDATED_BY,
49: X_LAST_UPDATE_LOGIN
50: );
51:
52: insert into AMS_MESSAGES_TL (
53: DESCRIPTION,
54: MESSAGE_ID,
55: LAST_UPDATE_DATE,
56: LAST_UPDATED_BY,

Line 78: from AMS_MESSAGES_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from AMS_MESSAGES_TL T
79: where T.MESSAGE_ID = X_MESSAGE_ID
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 119: from AMS_MESSAGES_TL

115: cursor c1 is select
116: MESSAGE_NAME,
117: DESCRIPTION,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from AMS_MESSAGES_TL
120: where MESSAGE_ID = X_MESSAGE_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of MESSAGE_ID nowait;
123: begin

Line 197: update AMS_MESSAGES_TL set

193: if (sql%notfound) then
194: raise no_data_found;
195: end if;
196:
197: update AMS_MESSAGES_TL set
198: MESSAGE_NAME = X_MESSAGE_NAME,
199: DESCRIPTION = X_DESCRIPTION,
200: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
201: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 216: delete from AMS_MESSAGES_TL

212: procedure DELETE_ROW (
213: X_MESSAGE_ID in NUMBER
214: ) is
215: begin
216: delete from AMS_MESSAGES_TL
217: where MESSAGE_ID = X_MESSAGE_ID;
218:
219: if (sql%notfound) then
220: raise no_data_found;

Line 234: delete from AMS_MESSAGES_TL T

230:
231: procedure ADD_LANGUAGE
232: is
233: begin
234: delete from AMS_MESSAGES_TL T
235: where not exists
236: (select NULL
237: from AMS_MESSAGES_B B
238: where B.MESSAGE_ID = T.MESSAGE_ID

Line 241: update AMS_MESSAGES_TL T set (

237: from AMS_MESSAGES_B B
238: where B.MESSAGE_ID = T.MESSAGE_ID
239: );
240:
241: update AMS_MESSAGES_TL T set (
242: MESSAGE_NAME,
243: DESCRIPTION
244: ) = (select
245: B.MESSAGE_NAME,

Line 247: from AMS_MESSAGES_TL B

243: DESCRIPTION
244: ) = (select
245: B.MESSAGE_NAME,
246: B.DESCRIPTION
247: from AMS_MESSAGES_TL B
248: where B.MESSAGE_ID = T.MESSAGE_ID
249: and B.LANGUAGE = T.SOURCE_LANG)
250: where (
251: T.MESSAGE_ID,

Line 256: from AMS_MESSAGES_TL SUBB, AMS_MESSAGES_TL SUBT

252: T.LANGUAGE
253: ) in (select
254: SUBT.MESSAGE_ID,
255: SUBT.LANGUAGE
256: from AMS_MESSAGES_TL SUBB, AMS_MESSAGES_TL SUBT
257: where SUBB.MESSAGE_ID = SUBT.MESSAGE_ID
258: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
259: and (SUBB.MESSAGE_NAME <> SUBT.MESSAGE_NAME
260: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 265: insert into AMS_MESSAGES_TL (

261: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
262: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
263: ));
264:
265: insert into AMS_MESSAGES_TL (
266: DESCRIPTION,
267: MESSAGE_ID,
268: LAST_UPDATE_DATE,
269: LAST_UPDATED_BY,

Line 287: from AMS_MESSAGES_TL B, FND_LANGUAGES L

283: B.LAST_UPDATE_LOGIN,
284: B.MESSAGE_NAME,
285: L.LANGUAGE_CODE,
286: B.SOURCE_LANG
287: from AMS_MESSAGES_TL B, FND_LANGUAGES L
288: where L.INSTALLED_FLAG in ('I', 'B')
289: and B.LANGUAGE = userenv('LANG')
290: and not exists
291: (select NULL

Line 292: from AMS_MESSAGES_TL T

288: where L.INSTALLED_FLAG in ('I', 'B')
289: and B.LANGUAGE = userenv('LANG')
290: and not exists
291: (select NULL
292: from AMS_MESSAGES_TL T
293: where T.MESSAGE_ID = B.MESSAGE_ID
294: and T.LANGUAGE = L.LANGUAGE_CODE);
295: end ADD_LANGUAGE;
296:

Line 305: update ams_messages_tl set

301: X_OWNER in VARCHAR2
302: )
303: is
304: begin
305: update ams_messages_tl set
306: message_name = nvl(x_message_name, message_name),
307: description = nvl(x_description, description),
308: source_lang = userenv('LANG'),
309: last_update_date = sysdate,