APPS.WF_MESSAGE_ATTRIBUTES_PKG dependencies on WF_MESSAGE_ATTRIBUTES_TL

Line 60: insert into WF_MESSAGE_ATTRIBUTES_TL (

56: X_DATE_DEFAULT,
57: X_ATTACH
58: );
59:
60: insert into WF_MESSAGE_ATTRIBUTES_TL (
61: MESSAGE_TYPE,
62: MESSAGE_NAME,
63: NAME,
64: DISPLAY_NAME,

Line 84: from WF_MESSAGE_ATTRIBUTES_TL T

80: from WF_LANGUAGES L
81: where L.INSTALLED_FLAG = 'Y'
82: and not exists
83: (select NULL
84: from WF_MESSAGE_ATTRIBUTES_TL T
85: where T.MESSAGE_NAME = X_MESSAGE_NAME
86: and T.MESSAGE_TYPE = X_MESSAGE_TYPE
87: and T.NAME = X_NAME
88: and T.LANGUAGE = L.CODE);

Line 143: from WF_MESSAGE_ATTRIBUTES_TL

139:
140: cursor c1 is select
141: DISPLAY_NAME,
142: DESCRIPTION
143: from WF_MESSAGE_ATTRIBUTES_TL
144: where MESSAGE_NAME = X_MESSAGE_NAME
145: and MESSAGE_TYPE = X_MESSAGE_TYPE
146: and NAME = X_NAME
147: and LANGUAGE = userenv('LANG')

Line 243: update WF_MESSAGE_ATTRIBUTES_TL set

239: if (sql%notfound) then
240: raise no_data_found;
241: end if;
242:
243: update WF_MESSAGE_ATTRIBUTES_TL set
244: DISPLAY_NAME = X_DISPLAY_NAME,
245: DESCRIPTION = X_DESCRIPTION,
246: SOURCE_LANG = userenv('LANG')
247: where MESSAGE_NAME = X_MESSAGE_NAME

Line 269: delete from WF_MESSAGE_ATTRIBUTES_TL

265: X_MESSAGE_TYPE in VARCHAR2,
266: X_NAME in VARCHAR2
267: ) is
268: begin
269: delete from WF_MESSAGE_ATTRIBUTES_TL
270: where MESSAGE_NAME = X_MESSAGE_NAME
271: and MESSAGE_TYPE = X_MESSAGE_TYPE
272: and NAME = X_NAME;
273:

Line 303: delete from WF_MESSAGE_ATTRIBUTES_TL T

299: /* as a quick workaround to fix the time-consuming table handler issue */
300: /* Eventually we'll need to turn them into a separate fix_language procedure */
301: /*
302:
303: delete from WF_MESSAGE_ATTRIBUTES_TL T
304: where not exists
305: (select NULL
306: from WF_MESSAGE_ATTRIBUTES B
307: where B.MESSAGE_NAME = T.MESSAGE_NAME

Line 312: update WF_MESSAGE_ATTRIBUTES_TL T set (

308: and B.MESSAGE_TYPE = T.MESSAGE_TYPE
309: and B.NAME = T.NAME
310: );
311:
312: update WF_MESSAGE_ATTRIBUTES_TL T set (
313: DISPLAY_NAME,
314: DESCRIPTION
315: ) = (select
316: B.DISPLAY_NAME,

Line 318: from WF_MESSAGE_ATTRIBUTES_TL B

314: DESCRIPTION
315: ) = (select
316: B.DISPLAY_NAME,
317: B.DESCRIPTION
318: from WF_MESSAGE_ATTRIBUTES_TL B
319: where B.MESSAGE_NAME = T.MESSAGE_NAME
320: and B.MESSAGE_TYPE = T.MESSAGE_TYPE
321: and B.NAME = T.NAME
322: and B.LANGUAGE = T.SOURCE_LANG)

Line 333: from WF_MESSAGE_ATTRIBUTES_TL SUBB, WF_MESSAGE_ATTRIBUTES_TL SUBT

329: SUBT.MESSAGE_NAME,
330: SUBT.MESSAGE_TYPE,
331: SUBT.NAME,
332: SUBT.LANGUAGE
333: from WF_MESSAGE_ATTRIBUTES_TL SUBB, WF_MESSAGE_ATTRIBUTES_TL SUBT
334: where SUBB.MESSAGE_NAME = SUBT.MESSAGE_NAME
335: and SUBB.MESSAGE_TYPE = SUBT.MESSAGE_TYPE
336: and SUBB.NAME = SUBT.NAME
337: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 345: insert /*+ append parallel */ into WF_MESSAGE_ATTRIBUTES_TL (

341: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
342: ));
343: */
344:
345: insert /*+ append parallel */ into WF_MESSAGE_ATTRIBUTES_TL (
346: MESSAGE_TYPE,
347: MESSAGE_NAME,
348: NAME,
349: DISPLAY_NAME,

Line 365: from WF_MESSAGE_ATTRIBUTES_TL B, WF_LANGUAGES L

361: B.CUSTOM_LEVEL,
362: B.DESCRIPTION,
363: L.CODE,
364: B.SOURCE_LANG
365: from WF_MESSAGE_ATTRIBUTES_TL B, WF_LANGUAGES L
366: where L.INSTALLED_FLAG = 'Y'
367: and B.LANGUAGE = userenv('LANG')
368: and ( B.MESSAGE_NAME,B.MESSAGE_TYPE, B.NAME , L.CODE) NOT IN
369: (select /*+ hash_aj index_ffs(T,WF_MESSAGE_ATTRIBUTES_TL_PK) */

Line 369: (select /*+ hash_aj index_ffs(T,WF_MESSAGE_ATTRIBUTES_TL_PK) */

365: from WF_MESSAGE_ATTRIBUTES_TL B, WF_LANGUAGES L
366: where L.INSTALLED_FLAG = 'Y'
367: and B.LANGUAGE = userenv('LANG')
368: and ( B.MESSAGE_NAME,B.MESSAGE_TYPE, B.NAME , L.CODE) NOT IN
369: (select /*+ hash_aj index_ffs(T,WF_MESSAGE_ATTRIBUTES_TL_PK) */
370: T.MESSAGE_NAME ,T.MESSAGE_TYPE ,T.NAME ,T.LANGUAGE
371: from WF_MESSAGE_ATTRIBUTES_TL T);
372:
373: end ADD_LANGUAGE;

Line 371: from WF_MESSAGE_ATTRIBUTES_TL T);

367: and B.LANGUAGE = userenv('LANG')
368: and ( B.MESSAGE_NAME,B.MESSAGE_TYPE, B.NAME , L.CODE) NOT IN
369: (select /*+ hash_aj index_ffs(T,WF_MESSAGE_ATTRIBUTES_TL_PK) */
370: T.MESSAGE_NAME ,T.MESSAGE_TYPE ,T.NAME ,T.LANGUAGE
371: from WF_MESSAGE_ATTRIBUTES_TL T);
372:
373: end ADD_LANGUAGE;
374:
375: end WF_MESSAGE_ATTRIBUTES_PKG;