APPS.FUN_RICH_MESSAGES_PKG dependencies on FUN_RICH_MESSAGES_TL

Line 37: insert into FUN_RICH_MESSAGES_TL (

33: FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
34: FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN
35: );
36:
37: insert into FUN_RICH_MESSAGES_TL (
38: APPLICATION_ID,
39: MESSAGE_NAME,
40: MESSAGE_TEXT,
41: CREATION_DATE,

Line 63: from FUN_RICH_MESSAGES_TL T

59: from FND_LANGUAGES L
60: where L.INSTALLED_FLAG in ('I', 'B')
61: and not exists
62: (select NULL
63: from FUN_RICH_MESSAGES_TL T
64: where T.APPLICATION_ID = X_APPLICATION_ID
65: and T.MESSAGE_NAME = X_MESSAGE_NAME
66: and T.LANGUAGE = L.LANGUAGE_CODE);
67:

Line 133: update FUN_RICH_MESSAGES_TL set

129: if (sql%notfound) then
130: raise no_data_found;
131: end if;
132:
133: update FUN_RICH_MESSAGES_TL set
134: MESSAGE_TEXT = X_MESSAGE_TEXT,
135: LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE,
136: LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY,
137: LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN,

Line 162: delete from FUN_RICH_MESSAGES_TL

158: if (sql%notfound) then
159: raise no_data_found;
160: end if;
161:
162: delete from FUN_RICH_MESSAGES_TL
163: where APPLICATION_ID = X_APPLICATION_ID
164: and MESSAGE_NAME = X_MESSAGE_NAME;
165:
166: if (sql%notfound) then

Line 189: delete from FUN_RICH_MESSAGES_TL T

185:
186: procedure ADD_LANGUAGE
187: is
188: begin
189: delete from FUN_RICH_MESSAGES_TL T
190: where not exists
191: (select NULL
192: from FUN_RICH_MESSAGES_B B
193: where B.APPLICATION_ID = T.APPLICATION_ID

Line 197: update FUN_RICH_MESSAGES_TL T set

193: where B.APPLICATION_ID = T.APPLICATION_ID
194: and B.MESSAGE_NAME = T.MESSAGE_NAME
195: );
196:
197: update FUN_RICH_MESSAGES_TL T set
198: ( MESSAGE_TEXT )
199: = (select B.MESSAGE_TEXT
200: from FUN_RICH_MESSAGES_TL B
201: where B.APPLICATION_ID = T.APPLICATION_ID

Line 200: from FUN_RICH_MESSAGES_TL B

196:
197: update FUN_RICH_MESSAGES_TL T set
198: ( MESSAGE_TEXT )
199: = (select B.MESSAGE_TEXT
200: from FUN_RICH_MESSAGES_TL B
201: where B.APPLICATION_ID = T.APPLICATION_ID
202: and B.MESSAGE_NAME = T.MESSAGE_NAME
203: and B.LANGUAGE = T.SOURCE_LANG)
204: where (

Line 212: from FUN_RICH_MESSAGES_TL SUBB, FUN_RICH_MESSAGES_TL SUBT

208: ) in (
209: select SUBT.APPLICATION_ID,
210: SUBT.MESSAGE_NAME,
211: SUBT.LANGUAGE
212: from FUN_RICH_MESSAGES_TL SUBB, FUN_RICH_MESSAGES_TL SUBT
213: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
214: and SUBB.MESSAGE_NAME = SUBT.MESSAGE_NAME
215: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
216: -- and SUBB.MESSAGE_TEXT <> SUBT.MESSAGE_TEXT

Line 220: insert into FUN_RICH_MESSAGES_TL (

216: -- and SUBB.MESSAGE_TEXT <> SUBT.MESSAGE_TEXT
217: );
218:
219:
220: insert into FUN_RICH_MESSAGES_TL (
221: APPLICATION_ID,
222: MESSAGE_NAME,
223: MESSAGE_TEXT,
224: CREATION_DATE,

Line 242: from FUN_RICH_MESSAGES_TL B, FND_LANGUAGES L

238: B.LAST_UPDATED_BY,
239: B.LAST_UPDATE_LOGIN,
240: L.LANGUAGE_CODE,
241: B.SOURCE_LANG
242: from FUN_RICH_MESSAGES_TL B, FND_LANGUAGES L
243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL

Line 247: from FUN_RICH_MESSAGES_TL T

243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL
247: from FUN_RICH_MESSAGES_TL T
248: where T.APPLICATION_ID = B.APPLICATION_ID
249: and T.MESSAGE_NAME = B.MESSAGE_NAME
250: and T.LANGUAGE = L.LANGUAGE_CODE);
251: end ADD_LANGUAGE;

Line 276: from FUN_RICH_MESSAGES_TL

272: WHERE application_short_name = X_APP_SHORT_NAME;
273:
274: select last_updated_by, last_update_date
275: into db_luby, db_ludate
276: from FUN_RICH_MESSAGES_TL
277: where application_id = appid
278: and message_name = x_message_name
279: and language = userenv('LANG');
280:

Line 289: update FUN_RICH_MESSAGES_TL

285: p_db_id => db_luby,
286: p_db_lud => db_ludate,
287: p_custom_mode => x_custom_mode))
288: then
289: update FUN_RICH_MESSAGES_TL
290: set message_text = nvl(x_message_text, message_text)
291: where application_id = appid
292: and message_name = x_message_name
293: and language = userenv('LANG');

Line 329: from FUN_RICH_MESSAGES_TL

325: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
326:
327: select LAST_UPDATED_BY, LAST_UPDATE_DATE
328: into db_luby, db_ludate
329: from FUN_RICH_MESSAGES_TL
330: where APPLICATION_ID = appid
331: and MESSAGE_NAME = X_MESSAGE_NAME;
332:
333: