APPS.WF_MESSAGES_PKG dependencies on WF_MESSAGES_TL

Line 41: insert into WF_MESSAGES_TL (

37: X_READ_ROLE,
38: X_WRITE_ROLE
39: );
40:
41: insert into WF_MESSAGES_TL (
42: TYPE,
43: NAME,
44: DISPLAY_NAME,
45: SUBJECT,

Line 69: from WF_MESSAGES_TL T

65: from WF_LANGUAGES L
66: where L.INSTALLED_FLAG = 'Y'
67: and not exists
68: (select NULL
69: from WF_MESSAGES_TL T
70: where T.TYPE = X_TYPE
71: and T.NAME = X_NAME
72: and T.LANGUAGE = L.CODE);
73:

Line 120: from WF_MESSAGES_TL

116: DESCRIPTION,
117: SUBJECT,
118: BODY,
119: HTML_BODY
120: from WF_MESSAGES_TL
121: where TYPE = X_TYPE
122: and NAME = X_NAME
123: and LANGUAGE = userenv('LANG')
124: for update of TYPE nowait;

Line 206: update WF_MESSAGES_TL set

202: if (sql%notfound) then
203: raise no_data_found;
204: end if;
205:
206: update WF_MESSAGES_TL set
207: DISPLAY_NAME = X_DISPLAY_NAME,
208: DESCRIPTION = X_DESCRIPTION,
209: SUBJECT = X_SUBJECT,
210: BODY = X_BODY,

Line 232: delete from WF_MESSAGES_TL

228: X_TYPE in VARCHAR2,
229: X_NAME in VARCHAR2
230: ) is
231: begin
232: delete from WF_MESSAGES_TL
233: where TYPE = X_TYPE
234: and NAME = X_NAME;
235:
236: if (sql%notfound) then

Line 263: delete from WF_MESSAGES_TL T

259: /* as a quick workaround to fix the time-consuming table handler issue */
260: /* Eventually we'll need to turn them into a separate fix_language procedure */
261: /*
262:
263: delete from WF_MESSAGES_TL T
264: where not exists
265: (select NULL
266: from WF_MESSAGES B
267: where B.TYPE = T.TYPE

Line 271: update WF_MESSAGES_TL T set (

267: where B.TYPE = T.TYPE
268: and B.NAME = T.NAME
269: );
270:
271: update WF_MESSAGES_TL T set (
272: DISPLAY_NAME,
273: DESCRIPTION,
274: SUBJECT,
275: BODY,

Line 283: from WF_MESSAGES_TL B

279: B.DESCRIPTION,
280: B.SUBJECT,
281: B.BODY,
282: B.HTML_BODY
283: from WF_MESSAGES_TL B
284: where B.TYPE = T.TYPE
285: and B.NAME = T.NAME
286: and B.LANGUAGE = T.SOURCE_LANG)
287: where (

Line 295: from WF_MESSAGES_TL SUBB, WF_MESSAGES_TL SUBT

291: ) in (select
292: SUBT.TYPE,
293: SUBT.NAME,
294: SUBT.LANGUAGE
295: from WF_MESSAGES_TL SUBB, WF_MESSAGES_TL SUBT
296: where SUBB.TYPE = SUBT.TYPE
297: and SUBB.NAME = SUBT.NAME
298: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
299: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME

Line 313: insert into WF_MESSAGES_TL (

309: or (SUBB.HTML_BODY is not null and SUBT.HTML_BODY is null)
310: ));
311: */
312:
313: insert into WF_MESSAGES_TL (
314: TYPE,
315: NAME,
316: DISPLAY_NAME,
317: SUBJECT,

Line 337: from WF_MESSAGES_TL B, WF_LANGUAGES L

333: B.BODY,
334: B.HTML_BODY,
335: L.CODE,
336: B.SOURCE_LANG
337: from WF_MESSAGES_TL B, WF_LANGUAGES L
338: where L.INSTALLED_FLAG = 'Y'
339: and B.LANGUAGE = userenv('LANG')
340: and (B.TYPE,B.NAME ,L.CODE ) NOT IN
341: (select /*+ hash_aj index_ffs(T,WF_MESSAGES_TL_PK) */

Line 341: (select /*+ hash_aj index_ffs(T,WF_MESSAGES_TL_PK) */

337: from WF_MESSAGES_TL B, WF_LANGUAGES L
338: where L.INSTALLED_FLAG = 'Y'
339: and B.LANGUAGE = userenv('LANG')
340: and (B.TYPE,B.NAME ,L.CODE ) NOT IN
341: (select /*+ hash_aj index_ffs(T,WF_MESSAGES_TL_PK) */
342: T.TYPE ,T.NAME ,T.LANGUAGE
343: from WF_MESSAGES_TL T);
344:
345: end ADD_LANGUAGE;

Line 343: from WF_MESSAGES_TL T);

339: and B.LANGUAGE = userenv('LANG')
340: and (B.TYPE,B.NAME ,L.CODE ) NOT IN
341: (select /*+ hash_aj index_ffs(T,WF_MESSAGES_TL_PK) */
342: T.TYPE ,T.NAME ,T.LANGUAGE
343: from WF_MESSAGES_TL T);
344:
345: end ADD_LANGUAGE;
346:
347: end WF_MESSAGES_PKG;