eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_MESSAGES_PKG dependencies on WF_MESSAGES

Line 1: package body WF_MESSAGES_PKG as

1: package body WF_MESSAGES_PKG as
2: /* $Header: wfmsgb.pls 120.1 2005/07/02 02:48:16 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_TYPE in VARCHAR2,

Line 18: cursor C is select ROWID from WF_MESSAGES

14: X_SUBJECT in VARCHAR2,
15: X_BODY in VARCHAR2,
16: X_HTML_BODY in VARCHAR2
17: ) is
18: cursor C is select ROWID from WF_MESSAGES
19: where TYPE = X_TYPE
20: and NAME = X_NAME
21: ;
22: begin

Line 23: insert into WF_MESSAGES (

19: where TYPE = X_TYPE
20: and NAME = X_NAME
21: ;
22: begin
23: insert into WF_MESSAGES (
24: TYPE,
25: NAME,
26: PROTECT_LEVEL,
27: CUSTOM_LEVEL,

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 84: wf_core.context('Wf_Messages_Pkg', 'Insert_Row', x_type, x_name);

80: close c;
81:
82: exception
83: when others then
84: wf_core.context('Wf_Messages_Pkg', 'Insert_Row', x_type, x_name);
85: raise;
86: end INSERT_ROW;
87:
88: procedure LOCK_ROW (

Line 108: from WF_MESSAGES

104: CUSTOM_LEVEL,
105: DEFAULT_PRIORITY,
106: READ_ROLE,
107: WRITE_ROLE
108: from WF_MESSAGES
109: where TYPE = X_TYPE
110: and NAME = X_NAME
111: for update of TYPE nowait;
112: recinfo c%rowtype;

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 174: wf_core.context('Wf_Messages_Pkg', 'Lock_Row', x_type, x_name);

170: return;
171:
172: exception
173: when others then
174: wf_core.context('Wf_Messages_Pkg', 'Lock_Row', x_type, x_name);
175: raise;
176: end LOCK_ROW;
177:
178: procedure UPDATE_ROW (

Line 193: update WF_MESSAGES set

189: X_BODY in VARCHAR2,
190: X_HTML_BODY in VARCHAR2
191: ) is
192: begin
193: update WF_MESSAGES set
194: PROTECT_LEVEL = X_PROTECT_LEVEL,
195: CUSTOM_LEVEL = X_CUSTOM_LEVEL,
196: DEFAULT_PRIORITY = X_DEFAULT_PRIORITY,
197: READ_ROLE = X_READ_ROLE,

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 223: wf_core.context('Wf_Messages_Pkg', 'Update_Row', x_type, x_name);

219: end if;
220:
221: exception
222: when others then
223: wf_core.context('Wf_Messages_Pkg', 'Update_Row', x_type, x_name);
224: raise;
225: end UPDATE_ROW;
226:
227: procedure DELETE_ROW (

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 240: delete from WF_MESSAGES

236: if (sql%notfound) then
237: raise no_data_found;
238: end if;
239:
240: delete from WF_MESSAGES
241: where TYPE = X_TYPE
242: and NAME = X_NAME;
243:
244: if (sql%notfound) then

Line 250: wf_core.context('Wf_Messages_Pkg', 'Delete_Row', x_type, x_name);

246: end if;
247:
248: exception
249: when others then
250: wf_core.context('Wf_Messages_Pkg', 'Delete_Row', x_type, x_name);
251: raise;
252: end DELETE_ROW;
253:
254: procedure ADD_LANGUAGE

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 266: from WF_MESSAGES B

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
268: and B.NAME = T.NAME
269: );
270:

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;

Line 347: end WF_MESSAGES_PKG;

343: from WF_MESSAGES_TL T);
344:
345: end ADD_LANGUAGE;
346:
347: end WF_MESSAGES_PKG;