APPS.WF_ITEM_ATTRIBUTES_PKG dependencies on WF_ITEM_ATTRIBUTES_TL

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 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 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 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 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 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: