APPS.WF_LOOKUPS_PKG dependencies on WF_LOOKUPS_TL

Line 12: cursor C is select ROWID from WF_LOOKUPS_TL

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

Line 18: insert into WF_LOOKUPS_TL (

14: and LOOKUP_CODE = X_LOOKUP_CODE
15: and LANGUAGE = userenv('LANG')
16: ;
17: begin
18: insert into WF_LOOKUPS_TL (
19: LOOKUP_TYPE,
20: LOOKUP_CODE,
21: MEANING,
22: PROTECT_LEVEL,

Line 40: from WF_LOOKUPS_TL T

36: from WF_LANGUAGES L
37: where L.INSTALLED_FLAG = 'Y'
38: and not exists
39: (select NULL
40: from WF_LOOKUPS_TL T
41: where T.LOOKUP_TYPE = X_LOOKUP_TYPE
42: and T.LOOKUP_CODE = X_LOOKUP_CODE
43: and T.LANGUAGE = L.CODE);
44:

Line 73: from WF_LOOKUPS_TL

69: PROTECT_LEVEL,
70: CUSTOM_LEVEL,
71: MEANING,
72: DESCRIPTION
73: from WF_LOOKUPS_TL
74: where LOOKUP_TYPE = X_LOOKUP_TYPE
75: and LOOKUP_CODE = X_LOOKUP_CODE
76: and LANGUAGE = userenv('LANG')
77: for update of LOOKUP_TYPE nowait;

Line 117: update WF_LOOKUPS_TL set

113: X_MEANING in VARCHAR2,
114: X_DESCRIPTION in VARCHAR2
115: ) is
116: begin
117: update WF_LOOKUPS_TL set
118: PROTECT_LEVEL = X_PROTECT_LEVEL,
119: CUSTOM_LEVEL = X_CUSTOM_LEVEL,
120: MEANING = X_MEANING,
121: DESCRIPTION = X_DESCRIPTION,

Line 143: delete from WF_LOOKUPS_TL

139: X_LOOKUP_TYPE in VARCHAR2,
140: X_LOOKUP_CODE in VARCHAR2
141: ) is
142: begin
143: delete from WF_LOOKUPS_TL
144: where LOOKUP_TYPE = X_LOOKUP_TYPE
145: and LOOKUP_CODE = X_LOOKUP_CODE;
146:
147: if (sql%notfound) then

Line 167: update WF_LOOKUPS_TL T set (

163: /* as a quick workaround to fix the time-consuming table handler issue */
164: /* Eventually we'll need to turn them into a separate fix_language procedure */
165: /*
166:
167: update WF_LOOKUPS_TL T set (
168: MEANING,
169: DESCRIPTION
170: ) = (select
171: B.MEANING,

Line 173: from WF_LOOKUPS_TL B

169: DESCRIPTION
170: ) = (select
171: B.MEANING,
172: B.DESCRIPTION
173: from WF_LOOKUPS_TL B
174: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
175: and B.LOOKUP_CODE = T.LOOKUP_CODE
176: and B.LANGUAGE = T.SOURCE_LANG)
177: where (

Line 185: from WF_LOOKUPS_TL SUBB, WF_LOOKUPS_TL SUBT

181: ) in (select
182: SUBT.LOOKUP_TYPE,
183: SUBT.LOOKUP_CODE,
184: SUBT.LANGUAGE
185: from WF_LOOKUPS_TL SUBB, WF_LOOKUPS_TL SUBT
186: where SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
187: and SUBB.LOOKUP_CODE = SUBT.LOOKUP_CODE
188: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
189: and (SUBB.MEANING <> SUBT.MEANING

Line 196: insert into WF_LOOKUPS_TL (

192: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
193: ));
194: */
195:
196: insert into WF_LOOKUPS_TL (
197: LOOKUP_TYPE,
198: LOOKUP_CODE,
199: MEANING,
200: PROTECT_LEVEL,

Line 214: from WF_LOOKUPS_TL B, WF_LANGUAGES L

210: B.CUSTOM_LEVEL,
211: B.DESCRIPTION,
212: L.CODE,
213: B.SOURCE_LANG
214: from WF_LOOKUPS_TL B, WF_LANGUAGES L
215: where L.INSTALLED_FLAG = 'Y'
216: and B.LANGUAGE = userenv('LANG')
217: and (B.LOOKUP_TYPE ,B.LOOKUP_CODE ,L.CODE ) NOT IN
218: (select /*+ hash_aj index_ffs(T,WF_LOOKUPS_TL_PK ) */

Line 218: (select /*+ hash_aj index_ffs(T,WF_LOOKUPS_TL_PK ) */

214: from WF_LOOKUPS_TL B, WF_LANGUAGES L
215: where L.INSTALLED_FLAG = 'Y'
216: and B.LANGUAGE = userenv('LANG')
217: and (B.LOOKUP_TYPE ,B.LOOKUP_CODE ,L.CODE ) NOT IN
218: (select /*+ hash_aj index_ffs(T,WF_LOOKUPS_TL_PK ) */
219: T.LOOKUP_TYPE , T.LOOKUP_CODE , T.LANGUAGE
220: from WF_LOOKUPS_TL T );
221:
222: end ADD_LANGUAGE;

Line 220: from WF_LOOKUPS_TL T );

216: and B.LANGUAGE = userenv('LANG')
217: and (B.LOOKUP_TYPE ,B.LOOKUP_CODE ,L.CODE ) NOT IN
218: (select /*+ hash_aj index_ffs(T,WF_LOOKUPS_TL_PK ) */
219: T.LOOKUP_TYPE , T.LOOKUP_CODE , T.LANGUAGE
220: from WF_LOOKUPS_TL T );
221:
222: end ADD_LANGUAGE;
223:
224: end WF_LOOKUPS_PKG;