APPS.WF_ITEM_TYPES_PKG dependencies on WF_ITEM_TYPES_TL

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