APPS.WF_DIRECTORY_PARTITIONS_PKG dependencies on WF_DIRECTORY_PARTITIONS_TL

Line 29: insert into WF_DIRECTORY_PARTITIONS_TL (

25: when DUP_VAL_ON_INDEX then
26: null;
27: end;
28:
29: insert into WF_DIRECTORY_PARTITIONS_TL (
30: ORIG_SYSTEM,
31: DISPLAY_NAME,
32: LANGUAGE,
33: SOURCE_LANG

Line 43: from WF_DIRECTORY_PARTITIONS_TL T

39: from WF_LANGUAGES L
40: where L.INSTALLED_FLAG = 'Y'
41: and not exists
42: (select NULL
43: from WF_DIRECTORY_PARTITIONS_TL T
44: where T.ORIG_SYSTEM = X_ORIG_SYSTEM
45: and T.LANGUAGE = L.CODE);
46:
47: open c;

Line 76: from WF_DIRECTORY_PARTITIONS_TL

72:
73: cursor c1 is select
74: DISPLAY_NAME,
75: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
76: from WF_DIRECTORY_PARTITIONS_TL
77: where ORIG_SYSTEM = X_ORIG_SYSTEM
78: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
79: for update of ORIG_SYSTEM nowait;
80: tlinfo c1%rowtype;

Line 129: update WF_DIRECTORY_PARTITIONS_TL set

125: if (sql%notfound) then
126: raise no_data_found;
127: end if;
128:
129: update WF_DIRECTORY_PARTITIONS_TL set
130: DISPLAY_NAME = X_DISPLAY_NAME,
131: SOURCE_LANG = userenv('LANG')
132: where ORIG_SYSTEM = X_ORIG_SYSTEM
133: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 149: delete from WF_DIRECTORY_PARTITIONS_TL

145: procedure DELETE_ROW (
146: X_ORIG_SYSTEM in VARCHAR2
147: ) is
148: begin
149: delete from WF_DIRECTORY_PARTITIONS_TL
150: where ORIG_SYSTEM = X_ORIG_SYSTEM;
151:
152: if (sql%notfound) then
153: raise no_data_found;

Line 172: delete from WF_DIRECTORY_PARTITIONS_TL T

168:
169: procedure ADD_LANGUAGE
170: is
171: begin
172: delete from WF_DIRECTORY_PARTITIONS_TL T
173: where not exists
174: (select NULL
175: from WF_DIRECTORY_PARTITIONS B
176: where B.ORIG_SYSTEM = T.ORIG_SYSTEM

Line 179: update WF_DIRECTORY_PARTITIONS_TL T set (

175: from WF_DIRECTORY_PARTITIONS B
176: where B.ORIG_SYSTEM = T.ORIG_SYSTEM
177: );
178:
179: update WF_DIRECTORY_PARTITIONS_TL T set (
180: DISPLAY_NAME
181: ) = (select
182: B.DISPLAY_NAME
183: from WF_DIRECTORY_PARTITIONS_TL B

Line 183: from WF_DIRECTORY_PARTITIONS_TL B

179: update WF_DIRECTORY_PARTITIONS_TL T set (
180: DISPLAY_NAME
181: ) = (select
182: B.DISPLAY_NAME
183: from WF_DIRECTORY_PARTITIONS_TL B
184: where B.ORIG_SYSTEM = T.ORIG_SYSTEM
185: and B.LANGUAGE = T.SOURCE_LANG)
186: where (
187: T.ORIG_SYSTEM,

Line 192: from WF_DIRECTORY_PARTITIONS_TL SUBB, WF_DIRECTORY_PARTITIONS_TL SUBT

188: T.LANGUAGE
189: ) in (select
190: SUBT.ORIG_SYSTEM,
191: SUBT.LANGUAGE
192: from WF_DIRECTORY_PARTITIONS_TL SUBB, WF_DIRECTORY_PARTITIONS_TL SUBT
193: where SUBB.ORIG_SYSTEM = SUBT.ORIG_SYSTEM
194: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
195: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
196: ));

Line 198: insert into WF_DIRECTORY_PARTITIONS_TL (

194: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
195: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
196: ));
197:
198: insert into WF_DIRECTORY_PARTITIONS_TL (
199: ORIG_SYSTEM,
200: DISPLAY_NAME,
201: LANGUAGE,
202: SOURCE_LANG

Line 208: from WF_DIRECTORY_PARTITIONS_TL B, WF_LANGUAGES L

204: B.ORIG_SYSTEM,
205: B.DISPLAY_NAME,
206: L.CODE,
207: B.SOURCE_LANG
208: from WF_DIRECTORY_PARTITIONS_TL B, WF_LANGUAGES L
209: where L.INSTALLED_FLAG = 'Y'
210: and B.LANGUAGE = userenv('LANG')
211: and not exists
212: (select NULL

Line 213: from WF_DIRECTORY_PARTITIONS_TL T

209: where L.INSTALLED_FLAG = 'Y'
210: and B.LANGUAGE = userenv('LANG')
211: and not exists
212: (select NULL
213: from WF_DIRECTORY_PARTITIONS_TL T
214: where T.ORIG_SYSTEM = B.ORIG_SYSTEM
215: and T.LANGUAGE = L.CODE);
216:
217: exception

Line 257: update WF_DIRECTORY_PARTITIONS_TL

253: X_DISPLAY_NAME in VARCHAR2
254: )
255: is
256: begin
257: update WF_DIRECTORY_PARTITIONS_TL
258: set DISPLAY_NAME = X_DISPLAY_NAME,
259: SOURCE_LANG = userenv('LANG')
260: where ORIG_SYSTEM = X_ORIG_SYSTEM
261: and userenv('LANG') in (language, source_lang);