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_TYPES_PKG dependencies on WF_ITEM_TYPES

Line 1: package body WF_ITEM_TYPES_PKG as

1: package body WF_ITEM_TYPES_PKG as
2: /* $Header: wfittb.pls 120.3 2005/10/04 05:13:04 rtodi ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_NAME in VARCHAR2,

Line 17: cursor C is select ROWID from WF_ITEM_TYPES

13: X_DESCRIPTION in VARCHAR2,
14: X_PERSISTENCE_TYPE in VARCHAR2,
15: X_PERSISTENCE_DAYS in NUMBER
16: ) is
17: cursor C is select ROWID from WF_ITEM_TYPES
18: where NAME = X_NAME
19: ;
20: begin
21: insert into WF_ITEM_TYPES (

Line 21: insert into WF_ITEM_TYPES (

17: cursor C is select ROWID from WF_ITEM_TYPES
18: where NAME = X_NAME
19: ;
20: begin
21: insert into WF_ITEM_TYPES (
22: NAME,
23: PROTECT_LEVEL,
24: CUSTOM_LEVEL,
25: WF_SELECTOR,

Line 43: insert into WF_ITEM_TYPES_TL (

39: X_PERSISTENCE_TYPE,
40: X_PERSISTENCE_DAYS
41: );
42:
43: insert into WF_ITEM_TYPES_TL (
44: NAME,
45: DISPLAY_NAME,
46: PROTECT_LEVEL,
47: CUSTOM_LEVEL,

Line 63: from WF_ITEM_TYPES_TL T

59: from WF_LANGUAGES L
60: where L.INSTALLED_FLAG = 'Y'
61: and not exists
62: (select NULL
63: from WF_ITEM_TYPES_TL T
64: where T.NAME = X_NAME
65: and T.LANGUAGE = L.CODE);
66:
67: open c;

Line 77: wf_core.context('Wf_Item_Types_Pkg', 'Insert_Row', x_name);

73: close c;
74:
75: exception
76: when others then
77: wf_core.context('Wf_Item_Types_Pkg', 'Insert_Row', x_name);
78: raise;
79: end INSERT_ROW;
80:
81: procedure LOCK_ROW (

Line 99: from WF_ITEM_TYPES

95: WF_SELECTOR,
96: READ_ROLE,
97: WRITE_ROLE,
98: EXECUTE_ROLE
99: from WF_ITEM_TYPES
100: where NAME = X_NAME
101: for update of NAME nowait;
102: recinfo c%rowtype;
103:

Line 107: from WF_ITEM_TYPES_TL

103:
104: cursor c1 is select
105: DISPLAY_NAME,
106: DESCRIPTION
107: from WF_ITEM_TYPES_TL
108: where NAME = X_NAME
109: and LANGUAGE = userenv('LANG')
110: for update of NAME nowait;
111: tlinfo c1%rowtype;

Line 156: wf_core.context('Wf_Item_Types_Pkg', 'Lock_Row', x_name);

152: end if;
153: return;
154: exception
155: when others then
156: wf_core.context('Wf_Item_Types_Pkg', 'Lock_Row', x_name);
157: raise;
158: end LOCK_ROW;
159:
160: procedure UPDATE_ROW (

Line 174: update WF_ITEM_TYPES set

170: X_PERSISTENCE_TYPE in VARCHAR2,
171: X_PERSISTENCE_DAYS in NUMBER
172: ) is
173: begin
174: update WF_ITEM_TYPES set
175: PROTECT_LEVEL = X_PROTECT_LEVEL,
176: CUSTOM_LEVEL = X_CUSTOM_LEVEL,
177: WF_SELECTOR = X_WF_SELECTOR,
178: READ_ROLE = X_READ_ROLE,

Line 189: update WF_ITEM_TYPES_TL set

185: if (sql%notfound) then
186: raise no_data_found;
187: end if;
188:
189: update WF_ITEM_TYPES_TL set
190: DISPLAY_NAME = X_DISPLAY_NAME,
191: DESCRIPTION = X_DESCRIPTION,
192: SOURCE_LANG = userenv('LANG')
193: where NAME = X_NAME

Line 201: wf_core.context('Wf_Item_Types_Pkg', 'Update_Row', x_name);

197: raise no_data_found;
198: end if;
199: exception
200: when others then
201: wf_core.context('Wf_Item_Types_Pkg', 'Update_Row', x_name);
202: raise;
203: end UPDATE_ROW;
204:
205: procedure DELETE_ROW (

Line 209: delete from WF_ITEM_TYPES_TL

205: procedure DELETE_ROW (
206: X_NAME in VARCHAR2
207: ) is
208: begin
209: delete from WF_ITEM_TYPES_TL
210: where NAME = X_NAME;
211:
212: if (sql%notfound) then
213: raise no_data_found;

Line 216: delete from WF_ITEM_TYPES

212: if (sql%notfound) then
213: raise no_data_found;
214: end if;
215:
216: delete from WF_ITEM_TYPES
217: where NAME = X_NAME;
218:
219: if (sql%notfound) then
220: raise no_data_found;

Line 225: wf_core.context('Wf_Item_Types_Pkg', 'Delete_Row', x_name);

221: end if;
222:
223: exception
224: when others then
225: wf_core.context('Wf_Item_Types_Pkg', 'Delete_Row', x_name);
226: raise;
227: end DELETE_ROW;
228:
229: procedure ADD_LANGUAGE

Line 237: delete from WF_ITEM_TYPES_TL T

233: /* as a quick workaround to fix the time-consuming table handler issue */
234: /* Eventually we'll need to turn them into a separate fix_language procedure */
235: /*
236:
237: delete from WF_ITEM_TYPES_TL T
238: where not exists
239: (select NULL
240: from WF_ITEM_TYPES B
241: where B.NAME = T.NAME

Line 240: from WF_ITEM_TYPES B

236:
237: delete from WF_ITEM_TYPES_TL T
238: where not exists
239: (select NULL
240: from WF_ITEM_TYPES B
241: where B.NAME = T.NAME
242: );
243:
244: update WF_ITEM_TYPES_TL T set (

Line 244: update WF_ITEM_TYPES_TL T set (

240: from WF_ITEM_TYPES B
241: where B.NAME = T.NAME
242: );
243:
244: update WF_ITEM_TYPES_TL T set (
245: DISPLAY_NAME,
246: DESCRIPTION
247: ) = (select
248: B.DISPLAY_NAME,

Line 250: from WF_ITEM_TYPES_TL B

246: DESCRIPTION
247: ) = (select
248: B.DISPLAY_NAME,
249: B.DESCRIPTION
250: from WF_ITEM_TYPES_TL B
251: where B.NAME = T.NAME
252: and B.LANGUAGE = T.SOURCE_LANG)
253: where (
254: T.NAME,

Line 259: from WF_ITEM_TYPES_TL SUBB, WF_ITEM_TYPES_TL SUBT

255: T.LANGUAGE
256: ) in (select
257: SUBT.NAME,
258: SUBT.LANGUAGE
259: from WF_ITEM_TYPES_TL SUBB, WF_ITEM_TYPES_TL SUBT
260: where SUBB.NAME = SUBT.NAME
261: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
262: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
263: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 270: insert into WF_ITEM_TYPES_TL (

266: ));
267:
268:
269: */
270: insert into WF_ITEM_TYPES_TL (
271: NAME,
272: DISPLAY_NAME,
273: PROTECT_LEVEL,
274: CUSTOM_LEVEL,

Line 286: from WF_ITEM_TYPES_TL B, WF_LANGUAGES L

282: B.CUSTOM_LEVEL,
283: B.DESCRIPTION,
284: L.CODE,
285: B.SOURCE_LANG
286: from WF_ITEM_TYPES_TL B, WF_LANGUAGES L
287: where L.INSTALLED_FLAG = 'Y'
288: and B.LANGUAGE = userenv('LANG')
289: and (b.name,l.code) NOT IN
290: (select /*+ hash_aj index_ffs(T,WF_ITEM_TYPES_TL_PK) */

Line 290: (select /+ hash_aj index_ffs(T,WF_ITEM_TYPES_TL_PK) /

286: from WF_ITEM_TYPES_TL B, WF_LANGUAGES L
287: where L.INSTALLED_FLAG = 'Y'
288: and B.LANGUAGE = userenv('LANG')
289: and (b.name,l.code) NOT IN
290: (select /*+ hash_aj index_ffs(T,WF_ITEM_TYPES_TL_PK) */
291: T.NAME,T.LANGUAGE
292: from WF_ITEM_TYPES_TL T) ;
293:
294: end ADD_LANGUAGE;

Line 292: from WF_ITEM_TYPES_TL T) ;

288: and B.LANGUAGE = userenv('LANG')
289: and (b.name,l.code) NOT IN
290: (select /*+ hash_aj index_ffs(T,WF_ITEM_TYPES_TL_PK) */
291: T.NAME,T.LANGUAGE
292: from WF_ITEM_TYPES_TL T) ;
293:
294: end ADD_LANGUAGE;
295:
296: end WF_ITEM_TYPES_PKG;

Line 296: end WF_ITEM_TYPES_PKG;

292: from WF_ITEM_TYPES_TL T) ;
293:
294: end ADD_LANGUAGE;
295:
296: end WF_ITEM_TYPES_PKG;