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_ITEM_ATTRIBUTES_PKG dependencies on WF_ITEM_ATTRIBUTES

Line 1: package body WF_ITEM_ATTRIBUTES_PKG as

1: package body WF_ITEM_ATTRIBUTES_PKG as
2: /* $Header: wfitab.pls 120.1 2005/07/02 02:46:32 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_ITEM_TYPE in VARCHAR2,

Line 19: cursor C is select ROWID from WF_ITEM_ATTRIBUTES

15: X_DATE_DEFAULT in DATE,
16: X_DISPLAY_NAME in VARCHAR2,
17: X_DESCRIPTION in VARCHAR2
18: ) is
19: cursor C is select ROWID from WF_ITEM_ATTRIBUTES
20: where ITEM_TYPE = X_ITEM_TYPE
21: and NAME = X_NAME
22: ;
23: begin

Line 24: insert into WF_ITEM_ATTRIBUTES (

20: where ITEM_TYPE = X_ITEM_TYPE
21: and NAME = X_NAME
22: ;
23: begin
24: insert into WF_ITEM_ATTRIBUTES (
25: ITEM_TYPE,
26: NAME,
27: SEQUENCE,
28: TYPE,

Line 50: insert into WF_ITEM_ATTRIBUTES_TL (

46: X_NUMBER_DEFAULT,
47: X_DATE_DEFAULT
48: );
49:
50: insert into WF_ITEM_ATTRIBUTES_TL (
51: ITEM_TYPE,
52: NAME,
53: DISPLAY_NAME,
54: PROTECT_LEVEL,

Line 72: from WF_ITEM_ATTRIBUTES_TL T

68: from WF_LANGUAGES L
69: where L.INSTALLED_FLAG = 'Y'
70: and not exists
71: (select NULL
72: from WF_ITEM_ATTRIBUTES_TL T
73: where T.ITEM_TYPE = X_ITEM_TYPE
74: and T.NAME = X_NAME
75: and T.LANGUAGE = L.CODE);
76:

Line 87: wf_core.context('Wf_Item_Attributes_Pkg', 'Insert_Row',

83: close c;
84:
85: exception
86: when others then
87: wf_core.context('Wf_Item_Attributes_Pkg', 'Insert_Row',
88: x_item_type, x_name);
89: raise;
90: end INSERT_ROW;
91:

Line 117: from WF_ITEM_ATTRIBUTES

113: FORMAT,
114: TEXT_DEFAULT,
115: NUMBER_DEFAULT,
116: DATE_DEFAULT
117: from WF_ITEM_ATTRIBUTES
118: where ITEM_TYPE = X_ITEM_TYPE
119: and NAME = X_NAME
120: for update of ITEM_TYPE nowait;
121: recinfo c%rowtype;

Line 126: from WF_ITEM_ATTRIBUTES_TL

122:
123: cursor c1 is select
124: DISPLAY_NAME,
125: DESCRIPTION
126: from WF_ITEM_ATTRIBUTES_TL
127: where ITEM_TYPE = X_ITEM_TYPE
128: and NAME = X_NAME
129: and LANGUAGE = userenv('LANG')
130: for update of ITEM_TYPE nowait;

Line 181: wf_core.context('Wf_Item_Attributes_Pkg', 'Lock_Row',

177: return;
178:
179: exception
180: when others then
181: wf_core.context('Wf_Item_Attributes_Pkg', 'Lock_Row',
182: x_item_type, x_name);
183: raise;
184: end LOCK_ROW;
185:

Line 202: update WF_ITEM_ATTRIBUTES set

198: X_DISPLAY_NAME in VARCHAR2,
199: X_DESCRIPTION in VARCHAR2
200: ) is
201: begin
202: update WF_ITEM_ATTRIBUTES set
203: SEQUENCE = X_SEQUENCE,
204: TYPE = X_TYPE,
205: PROTECT_LEVEL = X_PROTECT_LEVEL,
206: CUSTOM_LEVEL = X_CUSTOM_LEVEL,

Line 219: update WF_ITEM_ATTRIBUTES_TL set

215: if (sql%notfound) then
216: raise no_data_found;
217: end if;
218:
219: update WF_ITEM_ATTRIBUTES_TL set
220: DISPLAY_NAME = X_DISPLAY_NAME,
221: DESCRIPTION = X_DESCRIPTION,
222: SOURCE_LANG = userenv('LANG')
223: where ITEM_TYPE = X_ITEM_TYPE

Line 233: wf_core.context('Wf_Item_Attributes_Pkg', 'Update_Row',

229: end if;
230:
231: exception
232: when others then
233: wf_core.context('Wf_Item_Attributes_Pkg', 'Update_Row',
234: x_item_type, x_name);
235: raise;
236: end UPDATE_ROW;
237:

Line 243: delete from WF_ITEM_ATTRIBUTES_TL

239: X_ITEM_TYPE in VARCHAR2,
240: X_NAME in VARCHAR2
241: ) is
242: begin
243: delete from WF_ITEM_ATTRIBUTES_TL
244: where ITEM_TYPE = X_ITEM_TYPE
245: and NAME = X_NAME;
246:
247: if (sql%notfound) then

Line 251: delete from WF_ITEM_ATTRIBUTES

247: if (sql%notfound) then
248: raise no_data_found;
249: end if;
250:
251: delete from WF_ITEM_ATTRIBUTES
252: where ITEM_TYPE = X_ITEM_TYPE
253: and NAME = X_NAME;
254:
255: if (sql%notfound) then

Line 261: wf_core.context('Wf_Item_Attributes_Pkg', 'Delete_Row',

257: end if;
258:
259: exception
260: when others then
261: wf_core.context('Wf_Item_Attributes_Pkg', 'Delete_Row',
262: x_item_type, x_name);
263: raise;
264: end DELETE_ROW;
265:

Line 275: delete from WF_ITEM_ATTRIBUTES_TL T

271: /* as a quick workaround to fix the time-consuming table handler issue */
272: /* Eventually we'll need to turn them into a separate fix_language procedure */
273: /*
274:
275: delete from WF_ITEM_ATTRIBUTES_TL T
276: where not exists
277: (select NULL
278: from WF_ITEM_ATTRIBUTES B
279: where B.ITEM_TYPE = T.ITEM_TYPE

Line 278: from WF_ITEM_ATTRIBUTES B

274:
275: delete from WF_ITEM_ATTRIBUTES_TL T
276: where not exists
277: (select NULL
278: from WF_ITEM_ATTRIBUTES B
279: where B.ITEM_TYPE = T.ITEM_TYPE
280: and B.NAME = T.NAME
281: );
282:

Line 283: update WF_ITEM_ATTRIBUTES_TL T set (

279: where B.ITEM_TYPE = T.ITEM_TYPE
280: and B.NAME = T.NAME
281: );
282:
283: update WF_ITEM_ATTRIBUTES_TL T set (
284: DISPLAY_NAME,
285: DESCRIPTION
286: ) = (select
287: B.DISPLAY_NAME,

Line 289: from WF_ITEM_ATTRIBUTES_TL B

285: DESCRIPTION
286: ) = (select
287: B.DISPLAY_NAME,
288: B.DESCRIPTION
289: from WF_ITEM_ATTRIBUTES_TL B
290: where B.ITEM_TYPE = T.ITEM_TYPE
291: and B.NAME = T.NAME
292: and B.LANGUAGE = T.SOURCE_LANG)
293: where (

Line 301: from WF_ITEM_ATTRIBUTES_TL SUBB, WF_ITEM_ATTRIBUTES_TL SUBT

297: ) in (select
298: SUBT.ITEM_TYPE,
299: SUBT.NAME,
300: SUBT.LANGUAGE
301: from WF_ITEM_ATTRIBUTES_TL SUBB, WF_ITEM_ATTRIBUTES_TL SUBT
302: where SUBB.ITEM_TYPE = SUBT.ITEM_TYPE
303: and SUBB.NAME = SUBT.NAME
304: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
305: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME

Line 311: insert into WF_ITEM_ATTRIBUTES_TL (

307: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
308: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
309: ));
310: */
311: insert into WF_ITEM_ATTRIBUTES_TL (
312: ITEM_TYPE,
313: NAME,
314: DISPLAY_NAME,
315: PROTECT_LEVEL,

Line 329: from WF_ITEM_ATTRIBUTES_TL B, WF_LANGUAGES L

325: B.CUSTOM_LEVEL,
326: B.DESCRIPTION,
327: L.CODE,
328: B.SOURCE_LANG
329: from WF_ITEM_ATTRIBUTES_TL B, WF_LANGUAGES L
330: where L.INSTALLED_FLAG = 'Y'
331: and B.LANGUAGE = userenv('LANG')
332: and (B.ITEM_TYPE ,B.NAME ,L.CODE) NOT IN
333: (select /*+ hash_aj index_ffs(T,WF_ITEM_ATTRIBUTES_TL_PK) */

Line 333: (select /+ hash_aj index_ffs(T,WF_ITEM_ATTRIBUTES_TL_PK) /

329: from WF_ITEM_ATTRIBUTES_TL B, WF_LANGUAGES L
330: where L.INSTALLED_FLAG = 'Y'
331: and B.LANGUAGE = userenv('LANG')
332: and (B.ITEM_TYPE ,B.NAME ,L.CODE) NOT IN
333: (select /*+ hash_aj index_ffs(T,WF_ITEM_ATTRIBUTES_TL_PK) */
334: T.ITEM_TYPE , T.NAME,T.LANGUAGE
335: from WF_ITEM_ATTRIBUTES_TL T) ;
336:
337:

Line 335: from WF_ITEM_ATTRIBUTES_TL T) ;

331: and B.LANGUAGE = userenv('LANG')
332: and (B.ITEM_TYPE ,B.NAME ,L.CODE) NOT IN
333: (select /*+ hash_aj index_ffs(T,WF_ITEM_ATTRIBUTES_TL_PK) */
334: T.ITEM_TYPE , T.NAME,T.LANGUAGE
335: from WF_ITEM_ATTRIBUTES_TL T) ;
336:
337:
338: end ADD_LANGUAGE;
339:

Line 340: end WF_ITEM_ATTRIBUTES_PKG;

336:
337:
338: end ADD_LANGUAGE;
339:
340: end WF_ITEM_ATTRIBUTES_PKG;