APPS.WF_LOOKUP_TYPES_PKG dependencies on WF_LOOKUP_TYPES_TL

Line 12: cursor C is select ROWID from WF_LOOKUP_TYPES_TL

8: X_CUSTOM_LEVEL in NUMBER,
9: X_DISPLAY_NAME in VARCHAR2,
10: X_DESCRIPTION in VARCHAR2
11: ) is
12: cursor C is select ROWID from WF_LOOKUP_TYPES_TL
13: where LOOKUP_TYPE = X_LOOKUP_TYPE
14: and LANGUAGE = userenv('LANG')
15: ;
16: begin

Line 17: insert into WF_LOOKUP_TYPES_TL (

13: where LOOKUP_TYPE = X_LOOKUP_TYPE
14: and LANGUAGE = userenv('LANG')
15: ;
16: begin
17: insert into WF_LOOKUP_TYPES_TL (
18: LOOKUP_TYPE,
19: DISPLAY_NAME,
20: ITEM_TYPE,
21: PROTECT_LEVEL,

Line 39: from WF_LOOKUP_TYPES_TL T

35: from WF_LANGUAGES L
36: where L.INSTALLED_FLAG = 'Y'
37: and not exists
38: (select NULL
39: from WF_LOOKUP_TYPES_TL T
40: where T.LOOKUP_TYPE = X_LOOKUP_TYPE
41: and T.LANGUAGE = L.CODE);
42:
43: open c;

Line 71: from WF_LOOKUP_TYPES_TL

67: PROTECT_LEVEL,
68: CUSTOM_LEVEL,
69: DISPLAY_NAME,
70: DESCRIPTION
71: from WF_LOOKUP_TYPES_TL
72: where LOOKUP_TYPE = X_LOOKUP_TYPE
73: and LANGUAGE = userenv('LANG')
74: for update of LOOKUP_TYPE nowait;
75: tlinfo c1%rowtype;

Line 114: update WF_LOOKUP_TYPES_TL set

110: X_DISPLAY_NAME in VARCHAR2,
111: X_DESCRIPTION in VARCHAR2
112: ) is
113: begin
114: update WF_LOOKUP_TYPES_TL set
115: ITEM_TYPE = X_ITEM_TYPE,
116: PROTECT_LEVEL = X_PROTECT_LEVEL,
117: CUSTOM_LEVEL = X_CUSTOM_LEVEL,
118: DISPLAY_NAME = X_DISPLAY_NAME,

Line 138: delete from WF_LOOKUP_TYPES_TL

134: procedure DELETE_ROW (
135: X_LOOKUP_TYPE in VARCHAR2
136: ) is
137: begin
138: delete from WF_LOOKUP_TYPES_TL
139: where LOOKUP_TYPE = X_LOOKUP_TYPE;
140:
141: if (sql%notfound) then
142: raise no_data_found;

Line 159: update WF_LOOKUP_TYPES_TL T set (

155: /* as a quick workaround to fix the time-consuming table handler issue */
156: /* Eventually we'll need to turn them into a separate fix_language procedure */
157: /*
158:
159: update WF_LOOKUP_TYPES_TL T set (
160: DISPLAY_NAME,
161: DESCRIPTION
162: ) = (select
163: B.DISPLAY_NAME,

Line 165: from WF_LOOKUP_TYPES_TL B

161: DESCRIPTION
162: ) = (select
163: B.DISPLAY_NAME,
164: B.DESCRIPTION
165: from WF_LOOKUP_TYPES_TL B
166: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
167: and B.LANGUAGE = T.SOURCE_LANG)
168: where (
169: T.LOOKUP_TYPE,

Line 174: from WF_LOOKUP_TYPES_TL SUBB, WF_LOOKUP_TYPES_TL SUBT

170: T.LANGUAGE
171: ) in (select
172: SUBT.LOOKUP_TYPE,
173: SUBT.LANGUAGE
174: from WF_LOOKUP_TYPES_TL SUBB, WF_LOOKUP_TYPES_TL SUBT
175: where SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
176: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
177: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
178: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 185: insert into WF_LOOKUP_TYPES_TL (

181: ));
182:
183: */
184:
185: insert into WF_LOOKUP_TYPES_TL (
186: LOOKUP_TYPE,
187: DISPLAY_NAME,
188: ITEM_TYPE,
189: PROTECT_LEVEL,

Line 203: from WF_LOOKUP_TYPES_TL B, WF_LANGUAGES L

199: B.CUSTOM_LEVEL,
200: B.DESCRIPTION,
201: L.CODE,
202: B.SOURCE_LANG
203: from WF_LOOKUP_TYPES_TL B, WF_LANGUAGES L
204: where L.INSTALLED_FLAG = 'Y'
205: and B.LANGUAGE = userenv('LANG')
206: and (B.LOOKUP_TYPE , L.CODE ) NOT IN
207: (select /*+ hash_aj index_ffs(T,WF_LOOKUP_TYPES_TL_PK ) */

Line 207: (select /*+ hash_aj index_ffs(T,WF_LOOKUP_TYPES_TL_PK ) */

203: from WF_LOOKUP_TYPES_TL B, WF_LANGUAGES L
204: where L.INSTALLED_FLAG = 'Y'
205: and B.LANGUAGE = userenv('LANG')
206: and (B.LOOKUP_TYPE , L.CODE ) NOT IN
207: (select /*+ hash_aj index_ffs(T,WF_LOOKUP_TYPES_TL_PK ) */
208: T.LOOKUP_TYPE ,T.LANGUAGE
209: from WF_LOOKUP_TYPES_TL T);
210:
211: end ADD_LANGUAGE;

Line 209: from WF_LOOKUP_TYPES_TL T);

205: and B.LANGUAGE = userenv('LANG')
206: and (B.LOOKUP_TYPE , L.CODE ) NOT IN
207: (select /*+ hash_aj index_ffs(T,WF_LOOKUP_TYPES_TL_PK ) */
208: T.LOOKUP_TYPE ,T.LANGUAGE
209: from WF_LOOKUP_TYPES_TL T);
210:
211: end ADD_LANGUAGE;
212:
213: end WF_LOOKUP_TYPES_PKG;