1 package body WMS_TASK_RELEASE_PKG as
2 /* $Header: WMSTKPLB.pls 120.2.12010000.1 2009/03/25 09:55:16 shrmitra noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 X_CRITERIA_ID in NUMBER,
6 X_CONS_LOCATOR_TOLERANCE in NUMBER,
7 X_MIN_EQUIP_CAPACITY_FLAG in VARCHAR2,
8 X_CUSTOM_TASK_PLAN_FLAG in VARCHAR2,
9 X_CUSTOM_PLAN_TOLERANCE in NUMBER,
10 X_ORGANIZATION_ID in NUMBER,
11 X_ATTRIBUTE_CATEGORY in VARCHAR2,
12 X_ATTRIBUTE1 in VARCHAR2,
13 X_ATTRIBUTE2 in VARCHAR2,
14 X_ATTRIBUTE3 in VARCHAR2,
15 X_ATTRIBUTE4 in VARCHAR2,
16 X_ATTRIBUTE5 in VARCHAR2,
17 X_ATTRIBUTE6 in VARCHAR2,
18 X_ATTRIBUTE7 in VARCHAR2,
19 X_ATTRIBUTE8 in VARCHAR2,
20 X_ATTRIBUTE9 in VARCHAR2,
21 X_ATTRIBUTE10 in VARCHAR2,
22 X_ATTRIBUTE11 in VARCHAR2,
23 X_ATTRIBUTE12 in VARCHAR2,
24 X_ATTRIBUTE13 in VARCHAR2,
25 X_ATTRIBUTE14 in VARCHAR2,
26 X_ATTRIBUTE15 in VARCHAR2,
27 X_REPLEN_COMPLETED_FLAG in VARCHAR2,
28 X_REPLEN_TOLERANCE in NUMBER,
29 X_REV_TRIP_STOP_FLAG in VARCHAR2,
30 X_TRIP_STOP_TOLERANCE in NUMBER,
31 X_CONS_LOCATOR_FLAG in VARCHAR2,
32 X_CRITERIA_NAME in VARCHAR2,
33 X_CRITERIA_DESCRIPTION in VARCHAR2,
34 X_CREATION_DATE in DATE,
35 X_CREATED_BY in NUMBER,
36 X_LAST_UPDATE_DATE in DATE,
37 X_LAST_UPDATED_BY in NUMBER,
38 X_LAST_UPDATE_LOGIN in NUMBER
39 ) is
40 cursor C is select ROWID from WMS_TASK_RELEASE_B
41 where CRITERIA_ID = X_CRITERIA_ID
42 ;
43
44 l_ctype c%ROWTYPE;
45 begin
46 insert into WMS_TASK_RELEASE_B (
47 CONS_LOCATOR_TOLERANCE,
48 MIN_EQUIP_CAPACITY_FLAG,
49 CUSTOM_TASK_PLAN_FLAG,
50 CUSTOM_PLAN_TOLERANCE,
51 ORGANIZATION_ID,
52 ATTRIBUTE_CATEGORY,
53 ATTRIBUTE1,
54 ATTRIBUTE2,
55 ATTRIBUTE3,
56 ATTRIBUTE4,
57 ATTRIBUTE5,
58 ATTRIBUTE6,
59 ATTRIBUTE7,
60 ATTRIBUTE8,
61 ATTRIBUTE9,
62 ATTRIBUTE10,
63 ATTRIBUTE11,
64 ATTRIBUTE12,
65 ATTRIBUTE13,
66 ATTRIBUTE14,
67 ATTRIBUTE15,
68 CRITERIA_ID,
69 REPLEN_COMPLETED_FLAG,
70 REPLEN_TOLERANCE,
71 REV_TRIP_STOP_FLAG,
72 TRIP_STOP_TOLERANCE,
73 CONS_LOCATOR_FLAG,
74 CREATION_DATE,
75 CREATED_BY,
76 LAST_UPDATE_DATE,
77 LAST_UPDATED_BY,
78 LAST_UPDATE_LOGIN
79 ) values (
80 X_CONS_LOCATOR_TOLERANCE,
81 X_MIN_EQUIP_CAPACITY_FLAG,
82 X_CUSTOM_TASK_PLAN_FLAG,
83 X_CUSTOM_PLAN_TOLERANCE,
84 X_ORGANIZATION_ID,
85 X_ATTRIBUTE_CATEGORY,
86 X_ATTRIBUTE1,
87 X_ATTRIBUTE2,
88 X_ATTRIBUTE3,
89 X_ATTRIBUTE4,
90 X_ATTRIBUTE5,
91 X_ATTRIBUTE6,
92 X_ATTRIBUTE7,
93 X_ATTRIBUTE8,
94 X_ATTRIBUTE9,
95 X_ATTRIBUTE10,
96 X_ATTRIBUTE11,
97 X_ATTRIBUTE12,
98 X_ATTRIBUTE13,
99 X_ATTRIBUTE14,
100 X_ATTRIBUTE15,
101 X_CRITERIA_ID,
102 X_REPLEN_COMPLETED_FLAG,
103 X_REPLEN_TOLERANCE,
104 X_REV_TRIP_STOP_FLAG,
105 X_TRIP_STOP_TOLERANCE,
106 X_CONS_LOCATOR_FLAG,
107 X_CREATION_DATE,
108 X_CREATED_BY,
109 X_LAST_UPDATE_DATE,
110 X_LAST_UPDATED_BY,
111 X_LAST_UPDATE_LOGIN
112 );
113
114 insert into WMS_TASK_RELEASE_TL (
115 CRITERIA_ID,
116 LAST_UPDATED_BY,
117 LAST_UPDATE_DATE,
118 CREATED_BY,
119 CREATION_DATE,
120 LAST_UPDATE_LOGIN,
121 CRITERIA_NAME,
122 CRITERIA_DESCRIPTION,
123 LANGUAGE,
124 SOURCE_LANG
125 ) select
126 X_CRITERIA_ID,
127 X_LAST_UPDATED_BY,
128 X_LAST_UPDATE_DATE,
129 X_CREATED_BY,
130 X_CREATION_DATE,
131 X_LAST_UPDATE_LOGIN,
132 X_CRITERIA_NAME,
133 X_CRITERIA_DESCRIPTION,
134 L.LANGUAGE_CODE,
135 userenv('LANG')
136 from FND_LANGUAGES L
137 where L.INSTALLED_FLAG in ('I', 'B')
138 and not exists
139 (select NULL
140 from WMS_TASK_RELEASE_TL T
141 where T.CRITERIA_ID = X_CRITERIA_ID
142 and T.LANGUAGE = L.LANGUAGE_CODE);
143
144 open c;
145 --fetch c into X_ROWID;
146 fetch c into l_ctype;
147 if (c%notfound) then
148 close c;
149 raise no_data_found;
150 end if;
151 close c;
152
153 end INSERT_ROW;
154
155 procedure LOCK_ROW (
156 X_CRITERIA_ID in NUMBER,
157 X_CONS_LOCATOR_TOLERANCE in NUMBER,
158 X_MIN_EQUIP_CAPACITY_FLAG in VARCHAR2,
159 X_CUSTOM_TASK_PLAN_FLAG in VARCHAR2,
160 X_CUSTOM_PLAN_TOLERANCE in NUMBER,
161 X_ORGANIZATION_ID in NUMBER,
162 X_ATTRIBUTE_CATEGORY in VARCHAR2,
163 X_ATTRIBUTE1 in VARCHAR2,
164 X_ATTRIBUTE2 in VARCHAR2,
165 X_ATTRIBUTE3 in VARCHAR2,
166 X_ATTRIBUTE4 in VARCHAR2,
167 X_ATTRIBUTE5 in VARCHAR2,
168 X_ATTRIBUTE6 in VARCHAR2,
169 X_ATTRIBUTE7 in VARCHAR2,
170 X_ATTRIBUTE8 in VARCHAR2,
171 X_ATTRIBUTE9 in VARCHAR2,
172 X_ATTRIBUTE10 in VARCHAR2,
173 X_ATTRIBUTE11 in VARCHAR2,
174 X_ATTRIBUTE12 in VARCHAR2,
175 X_ATTRIBUTE13 in VARCHAR2,
176 X_ATTRIBUTE14 in VARCHAR2,
177 X_ATTRIBUTE15 in VARCHAR2,
178 X_REPLEN_COMPLETED_FLAG in VARCHAR2,
179 X_REPLEN_TOLERANCE in NUMBER,
180 X_REV_TRIP_STOP_FLAG in VARCHAR2,
181 X_TRIP_STOP_TOLERANCE in NUMBER,
182 X_CONS_LOCATOR_FLAG in VARCHAR2,
183 X_CRITERIA_NAME in VARCHAR2,
184 X_CRITERIA_DESCRIPTION in VARCHAR2
185 ) is
186 cursor c is select
187 CONS_LOCATOR_TOLERANCE,
188 MIN_EQUIP_CAPACITY_FLAG,
189 CUSTOM_TASK_PLAN_FLAG,
190 CUSTOM_PLAN_TOLERANCE,
191 ORGANIZATION_ID,
192 ATTRIBUTE_CATEGORY,
193 ATTRIBUTE1,
194 ATTRIBUTE2,
195 ATTRIBUTE3,
196 ATTRIBUTE4,
197 ATTRIBUTE5,
198 ATTRIBUTE6,
199 ATTRIBUTE7,
200 ATTRIBUTE8,
201 ATTRIBUTE9,
202 ATTRIBUTE10,
203 ATTRIBUTE11,
204 ATTRIBUTE12,
205 ATTRIBUTE13,
206 ATTRIBUTE14,
207 ATTRIBUTE15,
208 REPLEN_COMPLETED_FLAG,
209 REPLEN_TOLERANCE,
210 REV_TRIP_STOP_FLAG,
211 TRIP_STOP_TOLERANCE,
212 CONS_LOCATOR_FLAG
213 from WMS_TASK_RELEASE_B
214 where CRITERIA_ID = X_CRITERIA_ID
215 for update of CRITERIA_ID nowait;
216 recinfo c%rowtype;
217
218 cursor c1 is select
219 CRITERIA_NAME,
220 CRITERIA_DESCRIPTION,
221 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
222 from WMS_TASK_RELEASE_TL
223 where CRITERIA_ID = X_CRITERIA_ID
224 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
225 for update of CRITERIA_ID nowait;
226 begin
227 open c;
228 fetch c into recinfo;
229 if (c%notfound) then
230 close c;
231 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
232 app_exception.raise_exception;
233 end if;
234 close c;
235 if ( ((recinfo.CONS_LOCATOR_TOLERANCE = X_CONS_LOCATOR_TOLERANCE)
236 OR ((recinfo.CONS_LOCATOR_TOLERANCE is null) AND (X_CONS_LOCATOR_TOLERANCE is null)))
237 AND ((recinfo.MIN_EQUIP_CAPACITY_FLAG = X_MIN_EQUIP_CAPACITY_FLAG)
238 OR ((recinfo.MIN_EQUIP_CAPACITY_FLAG is null) AND (X_MIN_EQUIP_CAPACITY_FLAG is null)))
239 AND ((recinfo.CUSTOM_TASK_PLAN_FLAG = X_CUSTOM_TASK_PLAN_FLAG)
240 OR ((recinfo.CUSTOM_TASK_PLAN_FLAG is null) AND (X_CUSTOM_TASK_PLAN_FLAG is null)))
241 AND ((recinfo.CUSTOM_PLAN_TOLERANCE = X_CUSTOM_PLAN_TOLERANCE)
242 OR ((recinfo.CUSTOM_PLAN_TOLERANCE is null) AND (X_CUSTOM_PLAN_TOLERANCE is null)))
243 AND (recinfo.ORGANIZATION_ID = X_ORGANIZATION_ID)
244 AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
245 OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
246 AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
247 OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
248 AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
249 OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
250 AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
251 OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
252 AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
253 OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
254 AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
255 OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
256 AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
257 OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
258 AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
259 OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
260 AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
261 OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
262 AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
263 OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
264 AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
265 OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
266 AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
267 OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
268 AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
269 OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
270 AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
271 OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
272 AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
273 OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
274 AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
275 OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
276 AND ((recinfo.REPLEN_COMPLETED_FLAG = X_REPLEN_COMPLETED_FLAG)
277 OR ((recinfo.REPLEN_COMPLETED_FLAG is null) AND (X_REPLEN_COMPLETED_FLAG is null)))
278 AND ((recinfo.REPLEN_TOLERANCE = X_REPLEN_TOLERANCE)
279 OR ((recinfo.REPLEN_TOLERANCE is null) AND (X_REPLEN_TOLERANCE is null)))
280 AND ((recinfo.REV_TRIP_STOP_FLAG = X_REV_TRIP_STOP_FLAG)
281 OR ((recinfo.REV_TRIP_STOP_FLAG is null) AND (X_REV_TRIP_STOP_FLAG is null)))
282 AND ((recinfo.TRIP_STOP_TOLERANCE = X_TRIP_STOP_TOLERANCE)
283 OR ((recinfo.TRIP_STOP_TOLERANCE is null) AND (X_TRIP_STOP_TOLERANCE is null)))
284 AND ((recinfo.CONS_LOCATOR_FLAG = X_CONS_LOCATOR_FLAG)
285 OR ((recinfo.CONS_LOCATOR_FLAG is null) AND (X_CONS_LOCATOR_FLAG is null)))
286 ) then
287 null;
288 else
289 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
290 app_exception.raise_exception;
291 end if;
292
293 for tlinfo in c1 loop
294 if (tlinfo.BASELANG = 'Y') then
295 if ( (tlinfo.CRITERIA_NAME = X_CRITERIA_NAME)
296 AND ((tlinfo.CRITERIA_DESCRIPTION = X_CRITERIA_DESCRIPTION)
297 OR ((tlinfo.CRITERIA_DESCRIPTION is null) AND (X_CRITERIA_DESCRIPTION is null)))
298 ) then
299 null;
300 else
301 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
302 app_exception.raise_exception;
303 end if;
304 end if;
305 end loop;
306 return;
307 end LOCK_ROW;
308
309 procedure UPDATE_ROW (
310 X_CRITERIA_ID in NUMBER,
311 X_CONS_LOCATOR_TOLERANCE in NUMBER,
312 X_MIN_EQUIP_CAPACITY_FLAG in VARCHAR2,
313 X_CUSTOM_TASK_PLAN_FLAG in VARCHAR2,
314 X_CUSTOM_PLAN_TOLERANCE in NUMBER,
315 X_ORGANIZATION_ID in NUMBER,
316 X_ATTRIBUTE_CATEGORY in VARCHAR2,
317 X_ATTRIBUTE1 in VARCHAR2,
318 X_ATTRIBUTE2 in VARCHAR2,
319 X_ATTRIBUTE3 in VARCHAR2,
320 X_ATTRIBUTE4 in VARCHAR2,
321 X_ATTRIBUTE5 in VARCHAR2,
322 X_ATTRIBUTE6 in VARCHAR2,
323 X_ATTRIBUTE7 in VARCHAR2,
324 X_ATTRIBUTE8 in VARCHAR2,
325 X_ATTRIBUTE9 in VARCHAR2,
326 X_ATTRIBUTE10 in VARCHAR2,
327 X_ATTRIBUTE11 in VARCHAR2,
328 X_ATTRIBUTE12 in VARCHAR2,
329 X_ATTRIBUTE13 in VARCHAR2,
330 X_ATTRIBUTE14 in VARCHAR2,
331 X_ATTRIBUTE15 in VARCHAR2,
332 X_REPLEN_COMPLETED_FLAG in VARCHAR2,
333 X_REPLEN_TOLERANCE in NUMBER,
334 X_REV_TRIP_STOP_FLAG in VARCHAR2,
335 X_TRIP_STOP_TOLERANCE in NUMBER,
336 X_CONS_LOCATOR_FLAG in VARCHAR2,
337 X_CRITERIA_NAME in VARCHAR2,
338 X_CRITERIA_DESCRIPTION in VARCHAR2,
339 X_LAST_UPDATE_DATE in DATE,
340 X_LAST_UPDATED_BY in NUMBER,
341 X_LAST_UPDATE_LOGIN in NUMBER
342 ) is
343 begin
344 update WMS_TASK_RELEASE_B set
345 CONS_LOCATOR_TOLERANCE = X_CONS_LOCATOR_TOLERANCE,
346 MIN_EQUIP_CAPACITY_FLAG = X_MIN_EQUIP_CAPACITY_FLAG,
347 CUSTOM_TASK_PLAN_FLAG = X_CUSTOM_TASK_PLAN_FLAG,
348 CUSTOM_PLAN_TOLERANCE = X_CUSTOM_PLAN_TOLERANCE,
349 ORGANIZATION_ID = X_ORGANIZATION_ID,
350 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
351 ATTRIBUTE1 = X_ATTRIBUTE1,
352 ATTRIBUTE2 = X_ATTRIBUTE2,
353 ATTRIBUTE3 = X_ATTRIBUTE3,
354 ATTRIBUTE4 = X_ATTRIBUTE4,
355 ATTRIBUTE5 = X_ATTRIBUTE5,
356 ATTRIBUTE6 = X_ATTRIBUTE6,
357 ATTRIBUTE7 = X_ATTRIBUTE7,
358 ATTRIBUTE8 = X_ATTRIBUTE8,
359 ATTRIBUTE9 = X_ATTRIBUTE9,
360 ATTRIBUTE10 = X_ATTRIBUTE10,
361 ATTRIBUTE11 = X_ATTRIBUTE11,
362 ATTRIBUTE12 = X_ATTRIBUTE12,
363 ATTRIBUTE13 = X_ATTRIBUTE13,
364 ATTRIBUTE14 = X_ATTRIBUTE14,
365 ATTRIBUTE15 = X_ATTRIBUTE15,
366 REPLEN_COMPLETED_FLAG = X_REPLEN_COMPLETED_FLAG,
367 REPLEN_TOLERANCE = X_REPLEN_TOLERANCE,
368 REV_TRIP_STOP_FLAG = X_REV_TRIP_STOP_FLAG,
369 TRIP_STOP_TOLERANCE = X_TRIP_STOP_TOLERANCE,
370 CONS_LOCATOR_FLAG = X_CONS_LOCATOR_FLAG,
371 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
372 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
373 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
374 where CRITERIA_ID = X_CRITERIA_ID;
375
376 if (sql%notfound) then
377 raise no_data_found;
378 end if;
379
380 update WMS_TASK_RELEASE_TL set
381 CRITERIA_NAME = X_CRITERIA_NAME,
382 CRITERIA_DESCRIPTION = X_CRITERIA_DESCRIPTION,
383 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
384 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
385 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
386 SOURCE_LANG = userenv('LANG')
390 if (sql%notfound) then
387 where CRITERIA_ID = X_CRITERIA_ID
388 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
389
391 raise no_data_found;
392 end if;
393 end UPDATE_ROW;
394
395 procedure DELETE_ROW (
396 X_CRITERIA_ID in NUMBER
397 ) is
398 begin
399 delete from WMS_TASK_RELEASE_TL
400 where CRITERIA_ID = X_CRITERIA_ID;
401
402 if (sql%notfound) then
403 raise no_data_found;
404 end if;
405
406 delete from WMS_TASK_RELEASE_B
407 where CRITERIA_ID = X_CRITERIA_ID;
408
409 if (sql%notfound) then
410 raise no_data_found;
411 end if;
412 end DELETE_ROW;
413
414 procedure ADD_LANGUAGE
415 is
416 begin
417 delete from WMS_TASK_RELEASE_TL T
418 where not exists
419 (select NULL
420 from WMS_TASK_RELEASE_B B
421 where B.CRITERIA_ID = T.CRITERIA_ID
422 );
423
424 update WMS_TASK_RELEASE_TL T set (
425 CRITERIA_NAME,
426 CRITERIA_DESCRIPTION
427 ) = (select
428 B.CRITERIA_NAME,
429 B.CRITERIA_DESCRIPTION
430 from WMS_TASK_RELEASE_TL B
431 where B.CRITERIA_ID = T.CRITERIA_ID
432 and B.LANGUAGE = T.SOURCE_LANG)
433 where (
434 T.CRITERIA_ID,
435 T.LANGUAGE
436 ) in (select
437 SUBT.CRITERIA_ID,
438 SUBT.LANGUAGE
439 from WMS_TASK_RELEASE_TL SUBB, WMS_TASK_RELEASE_TL SUBT
440 where SUBB.CRITERIA_ID = SUBT.CRITERIA_ID
441 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
442 and (SUBB.CRITERIA_NAME <> SUBT.CRITERIA_NAME
443 or SUBB.CRITERIA_DESCRIPTION <> SUBT.CRITERIA_DESCRIPTION
444 or (SUBB.CRITERIA_DESCRIPTION is null and SUBT.CRITERIA_DESCRIPTION is not null)
445 or (SUBB.CRITERIA_DESCRIPTION is not null and SUBT.CRITERIA_DESCRIPTION is null)
446 ));
447
448 insert into WMS_TASK_RELEASE_TL (
449 CRITERIA_ID,
450 LAST_UPDATED_BY,
451 LAST_UPDATE_DATE,
452 CREATED_BY,
453 CREATION_DATE,
454 LAST_UPDATE_LOGIN,
455 CRITERIA_NAME,
456 CRITERIA_DESCRIPTION,
457 LANGUAGE,
458 SOURCE_LANG
459 ) select /*+ ORDERED */
460 B.CRITERIA_ID,
461 B.LAST_UPDATED_BY,
462 B.LAST_UPDATE_DATE,
463 B.CREATED_BY,
464 B.CREATION_DATE,
465 B.LAST_UPDATE_LOGIN,
466 B.CRITERIA_NAME,
467 B.CRITERIA_DESCRIPTION,
468 L.LANGUAGE_CODE,
469 B.SOURCE_LANG
470 from WMS_TASK_RELEASE_TL B, FND_LANGUAGES L
471 where L.INSTALLED_FLAG in ('I', 'B')
472 and B.LANGUAGE = userenv('LANG')
473 and not exists
474 (select NULL
475 from WMS_TASK_RELEASE_TL T
476 where T.CRITERIA_ID = B.CRITERIA_ID
477 and T.LANGUAGE = L.LANGUAGE_CODE);
478 end ADD_LANGUAGE;
479
480 end WMS_TASK_RELEASE_PKG;