1 PACKAGE body JTF_TASK_AUDITS_PKG as
2 /* $Header: jtftktub.pls 115.9 2000/02/28 22:54:23 pkm ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out VARCHAR2,
5 X_TASK_AUDIT_ID in NUMBER,
6 X_NEW_NOTIFICATION_PERIOD in NUMBER,
7 X_OLD_NOTIFICATION_PERIOD_UOM in VARCHAR2,
8 X_NEW_NOTIFICATION_PERIOD_UOM in VARCHAR2,
9 X_OLD_PARENT_TASK_ID in NUMBER,
10 X_NEW_PARENT_TASK_ID in NUMBER,
11 X_OLD_RECURRENCE_RULE_ID in NUMBER,
12 X_NEW_RECURRENCE_RULE_ID in NUMBER,
13 X_PALM_CHANGED_FLAG in VARCHAR2,
14 X_WINCE_CHANGED_FLAG in VARCHAR2,
15 X_LAPTOP_CHANGED_FLAG in VARCHAR2,
16 X_DEVICE1_CHANGED_FLAG in VARCHAR2,
17 X_DEVICE2_CHANGED_FLAG in VARCHAR2,
18 X_DEVICE3_CHANGED_FLAG in VARCHAR2,
19 X_OLD_CURRENCY_CODE in VARCHAR2,
20 X_NEW_CURRENCY_CODE in VARCHAR2,
21 X_OLD_COSTS in NUMBER,
22 X_NEW_COSTS in NUMBER,
23 X_OLD_ORG_ID in NUMBER,
24 X_NEW_ORG_ID in NUMBER,
25 X_TASK_ID in NUMBER,
26 X_OLD_TASK_TYPE_ID in NUMBER,
27 X_NEW_TASK_TYPE_ID in NUMBER,
28 X_OLD_TASK_STATUS_ID in NUMBER,
29 X_NEW_TASK_STATUS_ID in NUMBER,
30 X_OLD_TASK_PRIORITY_ID in NUMBER,
31 X_NEW_TASK_PRIORITY_ID in NUMBER,
32 X_OLD_OWNER_ID in NUMBER,
33 X_NEW_OWNER_ID in NUMBER,
34 X_OLD_OWNER_TYPE_CODE in VARCHAR2,
35 X_NEW_OWNER_TYPE_CODE in VARCHAR2,
36 X_OLD_ASSIGNED_BY_ID in NUMBER,
37 X_NEW_ASSIGNED_BY_ID in NUMBER,
38 X_OLD_CUST_ACCOUNT_ID in NUMBER,
39 X_NEW_CUST_ACCOUNT_ID in NUMBER,
40 X_OLD_CUSTOMER_ID in NUMBER,
41 X_NEW_CUSTOMER_ID in NUMBER,
42 X_OLD_ADDRESS_ID in NUMBER,
43 X_NEW_ADDRESS_ID in NUMBER,
44 X_OLD_PLANNED_START_DATE in DATE,
45 X_NEW_PLANNED_START_DATE in DATE,
46 X_OLD_PLANNED_END_DATE in DATE,
47 X_NEW_PLANNED_END_DATE in DATE,
48 X_OLD_SCHEDULED_START_DATE in DATE,
49 X_NEW_SCHEDULED_START_DATE in DATE,
50 X_OLD_SCHEDULED_END_DATE in DATE,
51 X_NEW_SCHEDULED_END_DATE in DATE,
52 X_OLD_ACTUAL_START_DATE in DATE,
53 X_NEW_ACTUAL_START_DATE in DATE,
54 X_OLD_ACTUAL_END_DATE in DATE,
55 X_NEW_ACTUAL_END_DATE in DATE,
56 X_OLD_SOURCE_OBJECT_TYPE_CODE in VARCHAR2,
57 X_NEW_SOURCE_OBJECT_TYPE_CODE in VARCHAR2,
58 X_OLD_TIMEZONE_ID in NUMBER,
59 X_NEW_TIMEZONE_ID in NUMBER,
60 X_OLD_SOURCE_OBJECT_ID in NUMBER,
61 X_NEW_SOURCE_OBJECT_ID in NUMBER,
62 X_OLD_SOURCE_OBJECT_NAME in VARCHAR2,
63 X_NEW_SOURCE_OBJECT_NAME in VARCHAR2,
64 X_OLD_DURATION in NUMBER,
65 X_NEW_DURATION in NUMBER,
66 X_OLD_DURATION_UOM in VARCHAR2,
67 X_NEW_DURATION_UOM in VARCHAR2,
68 X_OLD_PLANNED_EFFORT in NUMBER,
69 X_NEW_PLANNED_EFFORT in NUMBER,
70 X_OLD_PLANNED_EFFORT_UOM in VARCHAR2,
71 X_NEW_PLANNED_EFFORT_UOM in VARCHAR2,
72 X_OLD_ACTUAL_EFFORT in NUMBER,
73 X_NEW_ACTUAL_EFFORT in NUMBER,
74 X_OLD_ACTUAL_EFFORT_UOM in VARCHAR2,
75 X_NEW_ACTUAL_EFFORT_UOM in VARCHAR2,
76 X_OLD_PERCENTAGE_COMPLETE in NUMBER,
77 X_NEW_PERCENTAGE_COMPLETE in NUMBER,
78 X_OLD_REASON_CODE in VARCHAR2,
79 X_NEW_REASON_CODE in VARCHAR2,
80 X_PRIVATE_CHANGED_FLAG in VARCHAR2,
81 X_PUBLISH_CHANGED_FLAG in VARCHAR2,
82 X_RESTRICT_CLOSURE_CHANGE_FLAG in VARCHAR2,
83 X_MULTI_BOOKED_CHANGED_FLAG in VARCHAR2,
84 X_MILESTONE_CHANGED_FLAG in VARCHAR2,
85 X_HOLIDAY_CHANGED_FLAG in VARCHAR2,
86 X_BILLABLE_CHANGED_FLAG in VARCHAR2,
87 X_OLD_BOUND_MODE_CODE in VARCHAR2,
88 X_NEW_BOUND_MODE_CODE in VARCHAR2,
89 X_SOFT_BOUND_CHANGED_FLAG in VARCHAR2,
90 X_OLD_WORKFLOW_PROCESS_ID in NUMBER,
91 X_NEW_WORKFLOW_PROCESS_ID in NUMBER,
92 X_NOTIFICATION_CHANGED_FLAG in VARCHAR2,
93 X_OLD_NOTIFICATION_PERIOD in NUMBER,
94 X_OLD_TASK_NAME in VARCHAR2,
95 X_NEW_TASK_NAME in VARCHAR2,
96 X_OLD_DESCRIPTION in VARCHAR2,
97 X_NEW_DESCRIPTION in VARCHAR2,
98 X_CREATION_DATE in DATE,
99 X_CREATED_BY in NUMBER,
100 X_LAST_UPDATE_DATE in DATE,
101 X_LAST_UPDATED_BY in NUMBER,
102 X_LAST_UPDATE_LOGIN in NUMBER,
103 X_OBJECT_VERSION_NUMBER in NUMBER,
104 X_OLD_OWNER_TERRITORY_ID in NUMBER,
105 X_NEW_OWNER_TERRITORY_ID in NUMBER,
106 X_NEW_ESCALATION_LEVEL in VARCHAR2,
107 X_OLD_ESCALATION_LEVEL in VARCHAR2
108 ) is
109 cursor C is select ROWID from JTF_TASK_AUDITS_B
110 where TASK_AUDIT_ID = X_TASK_AUDIT_ID
111 ;
112 begin
113 insert into JTF_TASK_AUDITS_B (
114 NEW_NOTIFICATION_PERIOD,
115 OLD_NOTIFICATION_PERIOD_UOM,
116 NEW_NOTIFICATION_PERIOD_UOM,
117 OLD_PARENT_TASK_ID,
118 NEW_PARENT_TASK_ID,
119 OLD_RECURRENCE_RULE_ID,
120 NEW_RECURRENCE_RULE_ID,
121 PALM_CHANGED_FLAG,
122 WINCE_CHANGED_FLAG,
123 LAPTOP_CHANGED_FLAG,
124 DEVICE1_CHANGED_FLAG,
125 DEVICE2_CHANGED_FLAG,
126 DEVICE3_CHANGED_FLAG,
127 OLD_CURRENCY_CODE,
128 NEW_CURRENCY_CODE,
129 OLD_COSTS,
130 NEW_COSTS,
131 OLD_ORG_ID,
132 NEW_ORG_ID,
133 TASK_AUDIT_ID,
134 TASK_ID,
135 OLD_TASK_TYPE_ID,
136 NEW_TASK_TYPE_ID,
137 OLD_TASK_STATUS_ID,
138 NEW_TASK_STATUS_ID,
139 OLD_TASK_PRIORITY_ID,
140 NEW_TASK_PRIORITY_ID,
141 OLD_OWNER_ID,
142 NEW_OWNER_ID,
143 OLD_OWNER_TYPE_CODE,
144 NEW_OWNER_TYPE_CODE,
145 OLD_ASSIGNED_BY_ID,
146 NEW_ASSIGNED_BY_ID,
147 OLD_CUST_ACCOUNT_ID,
148 NEW_CUST_ACCOUNT_ID,
149 OLD_CUSTOMER_ID,
150 NEW_CUSTOMER_ID,
151 OLD_ADDRESS_ID,
152 NEW_ADDRESS_ID,
153 OLD_PLANNED_START_DATE,
154 NEW_PLANNED_START_DATE,
155 OLD_PLANNED_END_DATE,
156 NEW_PLANNED_END_DATE,
157 OLD_SCHEDULED_START_DATE,
158 NEW_SCHEDULED_START_DATE,
159 OLD_SCHEDULED_END_DATE,
160 NEW_SCHEDULED_END_DATE,
161 OLD_ACTUAL_START_DATE,
162 NEW_ACTUAL_START_DATE,
163 OLD_ACTUAL_END_DATE,
164 NEW_ACTUAL_END_DATE,
165 OLD_SOURCE_OBJECT_TYPE_CODE,
166 NEW_SOURCE_OBJECT_TYPE_CODE,
167 OLD_TIMEZONE_ID,
168 NEW_TIMEZONE_ID,
169 OLD_SOURCE_OBJECT_ID,
170 NEW_SOURCE_OBJECT_ID,
171 OLD_SOURCE_OBJECT_NAME,
172 NEW_SOURCE_OBJECT_NAME,
173 OLD_DURATION,
174 NEW_DURATION,
175 OLD_DURATION_UOM,
176 NEW_DURATION_UOM,
177 OLD_PLANNED_EFFORT,
178 NEW_PLANNED_EFFORT,
179 OLD_PLANNED_EFFORT_UOM,
180 NEW_PLANNED_EFFORT_UOM,
181 OLD_ACTUAL_EFFORT,
182 NEW_ACTUAL_EFFORT,
183 OLD_ACTUAL_EFFORT_UOM,
184 NEW_ACTUAL_EFFORT_UOM,
185 OLD_PERCENTAGE_COMPLETE,
186 NEW_PERCENTAGE_COMPLETE,
187 OLD_REASON_CODE,
188 NEW_REASON_CODE,
189 PRIVATE_CHANGED_FLAG,
190 PUBLISH_CHANGED_FLAG,
191 RESTRICT_CLOSURE_CHANGE_FLAG,
192 MULTI_BOOKED_CHANGED_FLAG,
193 MILESTONE_CHANGED_FLAG,
194 HOLIDAY_CHANGED_FLAG,
195 BILLABLE_CHANGED_FLAG,
196 OLD_BOUND_MODE_CODE,
197 NEW_BOUND_MODE_CODE,
198 SOFT_BOUND_CHANGED_FLAG,
199 OLD_WORKFLOW_PROCESS_ID,
200 NEW_WORKFLOW_PROCESS_ID,
201 NOTIFICATION_CHANGED_FLAG,
202 OLD_NOTIFICATION_PERIOD,
203 CREATION_DATE,
204 CREATED_BY,
205 LAST_UPDATE_DATE,
206 LAST_UPDATED_BY,
207 LAST_UPDATE_LOGIN,
208 OBJECT_VERSION_NUMBER,
209 OLD_OWNER_TERRITORY_ID,
210 NEW_OWNER_TERRITORY_ID,
211 NEW_ESCALATION_LEVEL,
212 OLD_ESCALATION_LEVEL
213 ) values (
214 X_NEW_NOTIFICATION_PERIOD,
215 X_OLD_NOTIFICATION_PERIOD_UOM,
216 X_NEW_NOTIFICATION_PERIOD_UOM,
217 X_OLD_PARENT_TASK_ID,
218 X_NEW_PARENT_TASK_ID,
219 X_OLD_RECURRENCE_RULE_ID,
220 X_NEW_RECURRENCE_RULE_ID,
221 X_PALM_CHANGED_FLAG,
222 X_WINCE_CHANGED_FLAG,
223 X_LAPTOP_CHANGED_FLAG,
224 X_DEVICE1_CHANGED_FLAG,
225 X_DEVICE2_CHANGED_FLAG,
226 X_DEVICE3_CHANGED_FLAG,
227 X_OLD_CURRENCY_CODE,
228 X_NEW_CURRENCY_CODE,
229 X_OLD_COSTS,
230 X_NEW_COSTS,
231 X_OLD_ORG_ID,
232 X_NEW_ORG_ID,
233 X_TASK_AUDIT_ID,
234 X_TASK_ID,
235 X_OLD_TASK_TYPE_ID,
236 X_NEW_TASK_TYPE_ID,
237 X_OLD_TASK_STATUS_ID,
238 X_NEW_TASK_STATUS_ID,
239 X_OLD_TASK_PRIORITY_ID,
240 X_NEW_TASK_PRIORITY_ID,
241 X_OLD_OWNER_ID,
242 X_NEW_OWNER_ID,
243 X_OLD_OWNER_TYPE_CODE,
244 X_NEW_OWNER_TYPE_CODE,
245 X_OLD_ASSIGNED_BY_ID,
246 X_NEW_ASSIGNED_BY_ID,
247 X_OLD_CUST_ACCOUNT_ID,
248 X_NEW_CUST_ACCOUNT_ID,
249 X_OLD_CUSTOMER_ID,
250 X_NEW_CUSTOMER_ID,
251 X_OLD_ADDRESS_ID,
252 X_NEW_ADDRESS_ID,
253 X_OLD_PLANNED_START_DATE,
254 X_NEW_PLANNED_START_DATE,
255 X_OLD_PLANNED_END_DATE,
256 X_NEW_PLANNED_END_DATE,
257 X_OLD_SCHEDULED_START_DATE,
258 X_NEW_SCHEDULED_START_DATE,
259 X_OLD_SCHEDULED_END_DATE,
260 X_NEW_SCHEDULED_END_DATE,
261 X_OLD_ACTUAL_START_DATE,
262 X_NEW_ACTUAL_START_DATE,
263 X_OLD_ACTUAL_END_DATE,
264 X_NEW_ACTUAL_END_DATE,
265 X_OLD_SOURCE_OBJECT_TYPE_CODE,
266 X_NEW_SOURCE_OBJECT_TYPE_CODE,
267 X_OLD_TIMEZONE_ID,
268 X_NEW_TIMEZONE_ID,
269 X_OLD_SOURCE_OBJECT_ID,
270 X_NEW_SOURCE_OBJECT_ID,
271 X_OLD_SOURCE_OBJECT_NAME,
272 X_NEW_SOURCE_OBJECT_NAME,
273 X_OLD_DURATION,
274 X_NEW_DURATION,
275 X_OLD_DURATION_UOM,
276 X_NEW_DURATION_UOM,
277 X_OLD_PLANNED_EFFORT,
278 X_NEW_PLANNED_EFFORT,
279 X_OLD_PLANNED_EFFORT_UOM,
280 X_NEW_PLANNED_EFFORT_UOM,
281 X_OLD_ACTUAL_EFFORT,
282 X_NEW_ACTUAL_EFFORT,
283 X_OLD_ACTUAL_EFFORT_UOM,
284 X_NEW_ACTUAL_EFFORT_UOM,
285 X_OLD_PERCENTAGE_COMPLETE,
286 X_NEW_PERCENTAGE_COMPLETE,
287 X_OLD_REASON_CODE,
288 X_NEW_REASON_CODE,
289 X_PRIVATE_CHANGED_FLAG,
290 X_PUBLISH_CHANGED_FLAG,
291 X_RESTRICT_CLOSURE_CHANGE_FLAG,
292 X_MULTI_BOOKED_CHANGED_FLAG,
293 X_MILESTONE_CHANGED_FLAG,
294 X_HOLIDAY_CHANGED_FLAG,
295 X_BILLABLE_CHANGED_FLAG,
296 X_OLD_BOUND_MODE_CODE,
297 X_NEW_BOUND_MODE_CODE,
298 X_SOFT_BOUND_CHANGED_FLAG,
299 X_OLD_WORKFLOW_PROCESS_ID,
300 X_NEW_WORKFLOW_PROCESS_ID,
301 X_NOTIFICATION_CHANGED_FLAG,
302 X_OLD_NOTIFICATION_PERIOD,
303 X_CREATION_DATE,
304 X_CREATED_BY,
305 X_LAST_UPDATE_DATE,
306 X_LAST_UPDATED_BY,
307 X_LAST_UPDATE_LOGIN,
308 X_OBJECT_VERSION_NUMBER,
309 X_OLD_OWNER_TERRITORY_ID,
310 X_NEW_OWNER_TERRITORY_ID,
311 X_NEW_ESCALATION_LEVEL,
312 X_OLD_ESCALATION_LEVEL
313 );
314
315 insert into JTF_TASK_AUDITS_TL (
316 TASK_AUDIT_ID,
317 OLD_TASK_NAME,
318 NEW_TASK_NAME,
319 OLD_DESCRIPTION,
320 NEW_DESCRIPTION,
321 CREATED_BY,
322 CREATION_DATE,
323 LAST_UPDATED_BY,
324 LAST_UPDATE_DATE,
325 LAST_UPDATE_LOGIN,
326 LANGUAGE,
327 SOURCE_LANG
328 ) select
329 X_TASK_AUDIT_ID,
330 X_OLD_TASK_NAME,
331 X_NEW_TASK_NAME,
332 X_OLD_DESCRIPTION,
333 X_NEW_DESCRIPTION,
334 X_CREATED_BY,
335 X_CREATION_DATE,
336 X_LAST_UPDATED_BY,
337 X_LAST_UPDATE_DATE,
338 X_LAST_UPDATE_LOGIN,
339 L.LANGUAGE_CODE,
340 userenv('LANG')
341 from FND_LANGUAGES L
342 where L.INSTALLED_FLAG in ('I', 'B')
343 and not exists
344 (select NULL
345 from JTF_TASK_AUDITS_TL T
346 where T.TASK_AUDIT_ID = X_TASK_AUDIT_ID
347 and T.LANGUAGE = L.LANGUAGE_CODE);
348
349 open c;
350 fetch c into X_ROWID;
351 if (c%notfound) then
352 close c;
353 raise no_data_found;
354 end if;
355 close c;
356
357 end INSERT_ROW;
358
359 procedure LOCK_ROW (
360 X_TASK_AUDIT_ID in NUMBER,
361 X_NEW_NOTIFICATION_PERIOD in NUMBER,
362 X_OLD_NOTIFICATION_PERIOD_UOM in VARCHAR2,
363 X_NEW_NOTIFICATION_PERIOD_UOM in VARCHAR2,
364 X_OLD_PARENT_TASK_ID in NUMBER,
365 X_NEW_PARENT_TASK_ID in NUMBER,
366 X_OLD_RECURRENCE_RULE_ID in NUMBER,
367 X_NEW_RECURRENCE_RULE_ID in NUMBER,
368 X_PALM_CHANGED_FLAG in VARCHAR2,
369 X_WINCE_CHANGED_FLAG in VARCHAR2,
370 X_LAPTOP_CHANGED_FLAG in VARCHAR2,
371 X_DEVICE1_CHANGED_FLAG in VARCHAR2,
372 X_DEVICE2_CHANGED_FLAG in VARCHAR2,
373 X_DEVICE3_CHANGED_FLAG in VARCHAR2,
374 X_OLD_CURRENCY_CODE in VARCHAR2,
375 X_NEW_CURRENCY_CODE in VARCHAR2,
376 X_OLD_COSTS in NUMBER,
377 X_NEW_COSTS in NUMBER,
378 X_OLD_ORG_ID in NUMBER,
382 X_NEW_TASK_TYPE_ID in NUMBER,
379 X_NEW_ORG_ID in NUMBER,
380 X_TASK_ID in NUMBER,
381 X_OLD_TASK_TYPE_ID in NUMBER,
383 X_OLD_TASK_STATUS_ID in NUMBER,
384 X_NEW_TASK_STATUS_ID in NUMBER,
385 X_OLD_TASK_PRIORITY_ID in NUMBER,
386 X_NEW_TASK_PRIORITY_ID in NUMBER,
387 X_OLD_OWNER_ID in NUMBER,
388 X_NEW_OWNER_ID in NUMBER,
389 X_OLD_OWNER_TYPE_CODE in VARCHAR2,
390 X_NEW_OWNER_TYPE_CODE in VARCHAR2,
391 X_OLD_ASSIGNED_BY_ID in NUMBER,
392 X_NEW_ASSIGNED_BY_ID in NUMBER,
393 X_OLD_CUST_ACCOUNT_ID in NUMBER,
394 X_NEW_CUST_ACCOUNT_ID in NUMBER,
395 X_OLD_CUSTOMER_ID in NUMBER,
396 X_NEW_CUSTOMER_ID in NUMBER,
397 X_OLD_ADDRESS_ID in NUMBER,
398 X_NEW_ADDRESS_ID in NUMBER,
399 X_OLD_PLANNED_START_DATE in DATE,
400 X_NEW_PLANNED_START_DATE in DATE,
401 X_OLD_PLANNED_END_DATE in DATE,
402 X_NEW_PLANNED_END_DATE in DATE,
403 X_OLD_SCHEDULED_START_DATE in DATE,
404 X_NEW_SCHEDULED_START_DATE in DATE,
405 X_OLD_SCHEDULED_END_DATE in DATE,
406 X_NEW_SCHEDULED_END_DATE in DATE,
407 X_OLD_ACTUAL_START_DATE in DATE,
408 X_NEW_ACTUAL_START_DATE in DATE,
409 X_OLD_ACTUAL_END_DATE in DATE,
410 X_NEW_ACTUAL_END_DATE in DATE,
411 X_OLD_SOURCE_OBJECT_TYPE_CODE in VARCHAR2,
412 X_NEW_SOURCE_OBJECT_TYPE_CODE in VARCHAR2,
413 X_OLD_TIMEZONE_ID in NUMBER,
414 X_NEW_TIMEZONE_ID in NUMBER,
415 X_OLD_SOURCE_OBJECT_ID in NUMBER,
416 X_NEW_SOURCE_OBJECT_ID in NUMBER,
417 X_OLD_SOURCE_OBJECT_NAME in VARCHAR2,
418 X_NEW_SOURCE_OBJECT_NAME in VARCHAR2,
419 X_OLD_DURATION in NUMBER,
420 X_NEW_DURATION in NUMBER,
421 X_OLD_DURATION_UOM in VARCHAR2,
422 X_NEW_DURATION_UOM in VARCHAR2,
423 X_OLD_PLANNED_EFFORT in NUMBER,
424 X_NEW_PLANNED_EFFORT in NUMBER,
425 X_OLD_PLANNED_EFFORT_UOM in VARCHAR2,
426 X_NEW_PLANNED_EFFORT_UOM in VARCHAR2,
427 X_OLD_ACTUAL_EFFORT in NUMBER,
428 X_NEW_ACTUAL_EFFORT in NUMBER,
429 X_OLD_ACTUAL_EFFORT_UOM in VARCHAR2,
430 X_NEW_ACTUAL_EFFORT_UOM in VARCHAR2,
431 X_OLD_PERCENTAGE_COMPLETE in NUMBER,
432 X_NEW_PERCENTAGE_COMPLETE in NUMBER,
433 X_OLD_REASON_CODE in VARCHAR2,
434 X_NEW_REASON_CODE in VARCHAR2,
435 X_PRIVATE_CHANGED_FLAG in VARCHAR2,
436 X_PUBLISH_CHANGED_FLAG in VARCHAR2,
437 X_RESTRICT_CLOSURE_CHANGE_FLAG in VARCHAR2,
438 X_MULTI_BOOKED_CHANGED_FLAG in VARCHAR2,
439 X_MILESTONE_CHANGED_FLAG in VARCHAR2,
440 X_HOLIDAY_CHANGED_FLAG in VARCHAR2,
441 X_BILLABLE_CHANGED_FLAG in VARCHAR2,
442 X_OLD_BOUND_MODE_CODE in VARCHAR2,
443 X_NEW_BOUND_MODE_CODE in VARCHAR2,
444 X_SOFT_BOUND_CHANGED_FLAG in VARCHAR2,
445 X_OLD_WORKFLOW_PROCESS_ID in NUMBER,
446 X_NEW_WORKFLOW_PROCESS_ID in NUMBER,
447 X_NOTIFICATION_CHANGED_FLAG in VARCHAR2,
448 X_OLD_NOTIFICATION_PERIOD in NUMBER,
449 X_OLD_TASK_NAME in VARCHAR2,
450 X_NEW_TASK_NAME in VARCHAR2,
451 X_OLD_DESCRIPTION in VARCHAR2,
452 X_NEW_DESCRIPTION in VARCHAR2,
453 X_NEW_ESCALATION_LEVEL in VARCHAR2,
454 X_OLD_ESCALATION_LEVEL in VARCHAR2
455 ) is
456 cursor c is select
457 NEW_NOTIFICATION_PERIOD,
458 OLD_NOTIFICATION_PERIOD_UOM,
459 NEW_NOTIFICATION_PERIOD_UOM,
460 OLD_PARENT_TASK_ID,
461 NEW_PARENT_TASK_ID,
462 OLD_RECURRENCE_RULE_ID,
463 NEW_RECURRENCE_RULE_ID,
464 PALM_CHANGED_FLAG,
465 WINCE_CHANGED_FLAG,
466 LAPTOP_CHANGED_FLAG,
467 DEVICE1_CHANGED_FLAG,
468 DEVICE2_CHANGED_FLAG,
469 DEVICE3_CHANGED_FLAG,
470 OLD_CURRENCY_CODE,
471 NEW_CURRENCY_CODE,
472 OLD_COSTS,
473 NEW_COSTS,
474 OLD_ORG_ID,
475 NEW_ORG_ID,
476 TASK_ID,
477 OLD_TASK_TYPE_ID,
478 NEW_TASK_TYPE_ID,
479 OLD_TASK_STATUS_ID,
480 NEW_TASK_STATUS_ID,
481 OLD_TASK_PRIORITY_ID,
482 NEW_TASK_PRIORITY_ID,
483 OLD_OWNER_ID,
484 NEW_OWNER_ID,
485 OLD_OWNER_TYPE_CODE,
486 NEW_OWNER_TYPE_CODE,
487 OLD_ASSIGNED_BY_ID,
488 NEW_ASSIGNED_BY_ID,
489 OLD_CUST_ACCOUNT_ID,
490 NEW_CUST_ACCOUNT_ID,
491 OLD_CUSTOMER_ID,
492 NEW_CUSTOMER_ID,
493 OLD_ADDRESS_ID,
494 NEW_ADDRESS_ID,
495 OLD_PLANNED_START_DATE,
496 NEW_PLANNED_START_DATE,
497 OLD_PLANNED_END_DATE,
498 NEW_PLANNED_END_DATE,
499 OLD_SCHEDULED_START_DATE,
500 NEW_SCHEDULED_START_DATE,
501 OLD_SCHEDULED_END_DATE,
502 NEW_SCHEDULED_END_DATE,
503 OLD_ACTUAL_START_DATE,
504 NEW_ACTUAL_START_DATE,
505 OLD_ACTUAL_END_DATE,
506 NEW_ACTUAL_END_DATE,
507 OLD_SOURCE_OBJECT_TYPE_CODE,
508 NEW_SOURCE_OBJECT_TYPE_CODE,
509 OLD_TIMEZONE_ID,
510 NEW_TIMEZONE_ID,
511 OLD_SOURCE_OBJECT_ID,
512 NEW_SOURCE_OBJECT_ID,
513 OLD_SOURCE_OBJECT_NAME,
514 NEW_SOURCE_OBJECT_NAME,
515 OLD_DURATION,
516 NEW_DURATION,
517 OLD_DURATION_UOM,
518 NEW_DURATION_UOM,
519 OLD_PLANNED_EFFORT,
520 NEW_PLANNED_EFFORT,
521 OLD_PLANNED_EFFORT_UOM,
522 NEW_PLANNED_EFFORT_UOM,
523 OLD_ACTUAL_EFFORT,
524 NEW_ACTUAL_EFFORT,
525 OLD_ACTUAL_EFFORT_UOM,
526 NEW_ACTUAL_EFFORT_UOM,
527 OLD_PERCENTAGE_COMPLETE,
528 NEW_PERCENTAGE_COMPLETE,
529 OLD_REASON_CODE,
530 NEW_REASON_CODE,
531 PRIVATE_CHANGED_FLAG,
532 PUBLISH_CHANGED_FLAG,
533 RESTRICT_CLOSURE_CHANGE_FLAG,
534 MULTI_BOOKED_CHANGED_FLAG,
535 MILESTONE_CHANGED_FLAG,
536 HOLIDAY_CHANGED_FLAG,
537 BILLABLE_CHANGED_FLAG,
541 OLD_WORKFLOW_PROCESS_ID,
538 OLD_BOUND_MODE_CODE,
539 NEW_BOUND_MODE_CODE,
540 SOFT_BOUND_CHANGED_FLAG,
542 NEW_WORKFLOW_PROCESS_ID,
543 NOTIFICATION_CHANGED_FLAG,
544 OLD_NOTIFICATION_PERIOD
545 from JTF_TASK_AUDITS_B
546 where TASK_AUDIT_ID = X_TASK_AUDIT_ID
547 for update of TASK_AUDIT_ID nowait;
548 recinfo c%rowtype;
549
550 cursor c1 is select
551 OLD_TASK_NAME,
552 NEW_TASK_NAME,
553 OLD_DESCRIPTION,
554 NEW_DESCRIPTION,
555 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
556 from JTF_TASK_AUDITS_TL
557 where TASK_AUDIT_ID = X_TASK_AUDIT_ID
558 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
559 for update of TASK_AUDIT_ID nowait;
560 begin
561 open c;
562 fetch c into recinfo;
563 if (c%notfound) then
564 close c;
565 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
566 app_exception.raise_exception;
567 end if;
568 close c;
569 if ( ((recinfo.NEW_NOTIFICATION_PERIOD = X_NEW_NOTIFICATION_PERIOD)
570 OR ((recinfo.NEW_NOTIFICATION_PERIOD is null) AND (X_NEW_NOTIFICATION_PERIOD is null)))
571 AND ((recinfo.OLD_NOTIFICATION_PERIOD_UOM = X_OLD_NOTIFICATION_PERIOD_UOM)
572 OR ((recinfo.OLD_NOTIFICATION_PERIOD_UOM is null) AND (X_OLD_NOTIFICATION_PERIOD_UOM is null)))
573 AND ((recinfo.NEW_NOTIFICATION_PERIOD_UOM = X_NEW_NOTIFICATION_PERIOD_UOM)
574 OR ((recinfo.NEW_NOTIFICATION_PERIOD_UOM is null) AND (X_NEW_NOTIFICATION_PERIOD_UOM is null)))
575 AND ((recinfo.OLD_PARENT_TASK_ID = X_OLD_PARENT_TASK_ID)
576 OR ((recinfo.OLD_PARENT_TASK_ID is null) AND (X_OLD_PARENT_TASK_ID is null)))
577 AND ((recinfo.NEW_PARENT_TASK_ID = X_NEW_PARENT_TASK_ID)
578 OR ((recinfo.NEW_PARENT_TASK_ID is null) AND (X_NEW_PARENT_TASK_ID is null)))
579 AND ((recinfo.OLD_RECURRENCE_RULE_ID = X_OLD_RECURRENCE_RULE_ID)
580 OR ((recinfo.OLD_RECURRENCE_RULE_ID is null) AND (X_OLD_RECURRENCE_RULE_ID is null)))
581 AND ((recinfo.NEW_RECURRENCE_RULE_ID = X_NEW_RECURRENCE_RULE_ID)
582 OR ((recinfo.NEW_RECURRENCE_RULE_ID is null) AND (X_NEW_RECURRENCE_RULE_ID is null)))
583 AND ((recinfo.PALM_CHANGED_FLAG = X_PALM_CHANGED_FLAG)
584 OR ((recinfo.PALM_CHANGED_FLAG is null) AND (X_PALM_CHANGED_FLAG is null)))
585 AND ((recinfo.WINCE_CHANGED_FLAG = X_WINCE_CHANGED_FLAG)
586 OR ((recinfo.WINCE_CHANGED_FLAG is null) AND (X_WINCE_CHANGED_FLAG is null)))
587 AND ((recinfo.LAPTOP_CHANGED_FLAG = X_LAPTOP_CHANGED_FLAG)
588 OR ((recinfo.LAPTOP_CHANGED_FLAG is null) AND (X_LAPTOP_CHANGED_FLAG is null)))
589 AND ((recinfo.DEVICE1_CHANGED_FLAG = X_DEVICE1_CHANGED_FLAG)
590 OR ((recinfo.DEVICE1_CHANGED_FLAG is null) AND (X_DEVICE1_CHANGED_FLAG is null)))
591 AND ((recinfo.DEVICE2_CHANGED_FLAG = X_DEVICE2_CHANGED_FLAG)
592 OR ((recinfo.DEVICE2_CHANGED_FLAG is null) AND (X_DEVICE2_CHANGED_FLAG is null)))
593 AND ((recinfo.DEVICE3_CHANGED_FLAG = X_DEVICE3_CHANGED_FLAG)
594 OR ((recinfo.DEVICE3_CHANGED_FLAG is null) AND (X_DEVICE3_CHANGED_FLAG is null)))
595 AND ((recinfo.OLD_CURRENCY_CODE = X_OLD_CURRENCY_CODE)
596 OR ((recinfo.OLD_CURRENCY_CODE is null) AND (X_OLD_CURRENCY_CODE is null)))
597 AND ((recinfo.NEW_CURRENCY_CODE = X_NEW_CURRENCY_CODE)
598 OR ((recinfo.NEW_CURRENCY_CODE is null) AND (X_NEW_CURRENCY_CODE is null)))
599 AND ((recinfo.OLD_COSTS = X_OLD_COSTS)
600 OR ((recinfo.OLD_COSTS is null) AND (X_OLD_COSTS is null)))
601 AND ((recinfo.NEW_COSTS = X_NEW_COSTS)
602 OR ((recinfo.NEW_COSTS is null) AND (X_NEW_COSTS is null)))
603 AND ((recinfo.OLD_ORG_ID = X_OLD_ORG_ID)
604 OR ((recinfo.OLD_ORG_ID is null) AND (X_OLD_ORG_ID is null)))
605 AND ((recinfo.NEW_ORG_ID = X_NEW_ORG_ID)
606 OR ((recinfo.NEW_ORG_ID is null) AND (X_NEW_ORG_ID is null)))
607 AND (recinfo.TASK_ID = X_TASK_ID)
608 AND ((recinfo.OLD_TASK_TYPE_ID = X_OLD_TASK_TYPE_ID)
609 OR ((recinfo.OLD_TASK_TYPE_ID is null) AND (X_OLD_TASK_TYPE_ID is null)))
610 AND ((recinfo.NEW_TASK_TYPE_ID = X_NEW_TASK_TYPE_ID)
611 OR ((recinfo.NEW_TASK_TYPE_ID is null) AND (X_NEW_TASK_TYPE_ID is null)))
612 AND ((recinfo.OLD_TASK_STATUS_ID = X_OLD_TASK_STATUS_ID)
613 OR ((recinfo.OLD_TASK_STATUS_ID is null) AND (X_OLD_TASK_STATUS_ID is null)))
614 AND ((recinfo.NEW_TASK_STATUS_ID = X_NEW_TASK_STATUS_ID)
615 OR ((recinfo.NEW_TASK_STATUS_ID is null) AND (X_NEW_TASK_STATUS_ID is null)))
616 AND ((recinfo.OLD_TASK_PRIORITY_ID = X_OLD_TASK_PRIORITY_ID)
617 OR ((recinfo.OLD_TASK_PRIORITY_ID is null) AND (X_OLD_TASK_PRIORITY_ID is null)))
618 AND ((recinfo.NEW_TASK_PRIORITY_ID = X_NEW_TASK_PRIORITY_ID)
619 OR ((recinfo.NEW_TASK_PRIORITY_ID is null) AND (X_NEW_TASK_PRIORITY_ID is null)))
620 AND ((recinfo.OLD_OWNER_ID = X_OLD_OWNER_ID)
621 OR ((recinfo.OLD_OWNER_ID is null) AND (X_OLD_OWNER_ID is null)))
622 AND ((recinfo.NEW_OWNER_ID = X_NEW_OWNER_ID)
623 OR ((recinfo.NEW_OWNER_ID is null) AND (X_NEW_OWNER_ID is null)))
624 AND ((recinfo.OLD_OWNER_TYPE_CODE = X_OLD_OWNER_TYPE_CODE)
625 OR ((recinfo.OLD_OWNER_TYPE_CODE is null) AND (X_OLD_OWNER_TYPE_CODE is null)))
626 AND ((recinfo.NEW_OWNER_TYPE_CODE = X_NEW_OWNER_TYPE_CODE)
627 OR ((recinfo.NEW_OWNER_TYPE_CODE is null) AND (X_NEW_OWNER_TYPE_CODE is null)))
628 AND ((recinfo.OLD_ASSIGNED_BY_ID = X_OLD_ASSIGNED_BY_ID)
629 OR ((recinfo.OLD_ASSIGNED_BY_ID is null) AND (X_OLD_ASSIGNED_BY_ID is null)))
630 AND ((recinfo.NEW_ASSIGNED_BY_ID = X_NEW_ASSIGNED_BY_ID)
631 OR ((recinfo.NEW_ASSIGNED_BY_ID is null) AND (X_NEW_ASSIGNED_BY_ID is null)))
632 AND ((recinfo.OLD_CUST_ACCOUNT_ID = X_OLD_CUST_ACCOUNT_ID)
633 OR ((recinfo.OLD_CUST_ACCOUNT_ID is null) AND (X_OLD_CUST_ACCOUNT_ID is null)))
634 AND ((recinfo.NEW_CUST_ACCOUNT_ID = X_NEW_CUST_ACCOUNT_ID)
638 AND ((recinfo.NEW_CUSTOMER_ID = X_NEW_CUSTOMER_ID)
635 OR ((recinfo.NEW_CUST_ACCOUNT_ID is null) AND (X_NEW_CUST_ACCOUNT_ID is null)))
636 AND ((recinfo.OLD_CUSTOMER_ID = X_OLD_CUSTOMER_ID)
637 OR ((recinfo.OLD_CUSTOMER_ID is null) AND (X_OLD_CUSTOMER_ID is null)))
639 OR ((recinfo.NEW_CUSTOMER_ID is null) AND (X_NEW_CUSTOMER_ID is null)))
640 AND ((recinfo.OLD_ADDRESS_ID = X_OLD_ADDRESS_ID)
641 OR ((recinfo.OLD_ADDRESS_ID is null) AND (X_OLD_ADDRESS_ID is null)))
642 AND ((recinfo.NEW_ADDRESS_ID = X_NEW_ADDRESS_ID)
643 OR ((recinfo.NEW_ADDRESS_ID is null) AND (X_NEW_ADDRESS_ID is null)))
644 AND ((recinfo.OLD_PLANNED_START_DATE = X_OLD_PLANNED_START_DATE)
645 OR ((recinfo.OLD_PLANNED_START_DATE is null) AND (X_OLD_PLANNED_START_DATE is null)))
646 AND ((recinfo.NEW_PLANNED_START_DATE = X_NEW_PLANNED_START_DATE)
647 OR ((recinfo.NEW_PLANNED_START_DATE is null) AND (X_NEW_PLANNED_START_DATE is null)))
648 AND ((recinfo.OLD_PLANNED_END_DATE = X_OLD_PLANNED_END_DATE)
649 OR ((recinfo.OLD_PLANNED_END_DATE is null) AND (X_OLD_PLANNED_END_DATE is null)))
650 AND ((recinfo.NEW_PLANNED_END_DATE = X_NEW_PLANNED_END_DATE)
651 OR ((recinfo.NEW_PLANNED_END_DATE is null) AND (X_NEW_PLANNED_END_DATE is null)))
652 AND ((recinfo.OLD_SCHEDULED_START_DATE = X_OLD_SCHEDULED_START_DATE)
653 OR ((recinfo.OLD_SCHEDULED_START_DATE is null) AND (X_OLD_SCHEDULED_START_DATE is null)))
654 AND ((recinfo.NEW_SCHEDULED_START_DATE = X_NEW_SCHEDULED_START_DATE)
655 OR ((recinfo.NEW_SCHEDULED_START_DATE is null) AND (X_NEW_SCHEDULED_START_DATE is null)))
656 AND ((recinfo.OLD_SCHEDULED_END_DATE = X_OLD_SCHEDULED_END_DATE)
657 OR ((recinfo.OLD_SCHEDULED_END_DATE is null) AND (X_OLD_SCHEDULED_END_DATE is null)))
658 AND ((recinfo.NEW_SCHEDULED_END_DATE = X_NEW_SCHEDULED_END_DATE)
659 OR ((recinfo.NEW_SCHEDULED_END_DATE is null) AND (X_NEW_SCHEDULED_END_DATE is null)))
660 AND ((recinfo.OLD_ACTUAL_START_DATE = X_OLD_ACTUAL_START_DATE)
661 OR ((recinfo.OLD_ACTUAL_START_DATE is null) AND (X_OLD_ACTUAL_START_DATE is null)))
662 AND ((recinfo.NEW_ACTUAL_START_DATE = X_NEW_ACTUAL_START_DATE)
663 OR ((recinfo.NEW_ACTUAL_START_DATE is null) AND (X_NEW_ACTUAL_START_DATE is null)))
664 AND ((recinfo.OLD_ACTUAL_END_DATE = X_OLD_ACTUAL_END_DATE)
665 OR ((recinfo.OLD_ACTUAL_END_DATE is null) AND (X_OLD_ACTUAL_END_DATE is null)))
666 AND ((recinfo.NEW_ACTUAL_END_DATE = X_NEW_ACTUAL_END_DATE)
667 OR ((recinfo.NEW_ACTUAL_END_DATE is null) AND (X_NEW_ACTUAL_END_DATE is null)))
668 AND ((recinfo.OLD_SOURCE_OBJECT_TYPE_CODE = X_OLD_SOURCE_OBJECT_TYPE_CODE)
669 OR ((recinfo.OLD_SOURCE_OBJECT_TYPE_CODE is null) AND (X_OLD_SOURCE_OBJECT_TYPE_CODE is null)))
670 AND ((recinfo.NEW_SOURCE_OBJECT_TYPE_CODE = X_NEW_SOURCE_OBJECT_TYPE_CODE)
671 OR ((recinfo.NEW_SOURCE_OBJECT_TYPE_CODE is null) AND (X_NEW_SOURCE_OBJECT_TYPE_CODE is null)))
672 AND ((recinfo.OLD_TIMEZONE_ID = X_OLD_TIMEZONE_ID)
673 OR ((recinfo.OLD_TIMEZONE_ID is null) AND (X_OLD_TIMEZONE_ID is null)))
674 AND ((recinfo.NEW_TIMEZONE_ID = X_NEW_TIMEZONE_ID)
675 OR ((recinfo.NEW_TIMEZONE_ID is null) AND (X_NEW_TIMEZONE_ID is null)))
676 AND ((recinfo.OLD_SOURCE_OBJECT_ID = X_OLD_SOURCE_OBJECT_ID)
677 OR ((recinfo.OLD_SOURCE_OBJECT_ID is null) AND (X_OLD_SOURCE_OBJECT_ID is null)))
678 AND ((recinfo.NEW_SOURCE_OBJECT_ID = X_NEW_SOURCE_OBJECT_ID)
679 OR ((recinfo.NEW_SOURCE_OBJECT_ID is null) AND (X_NEW_SOURCE_OBJECT_ID is null)))
680 AND ((recinfo.OLD_SOURCE_OBJECT_NAME = X_OLD_SOURCE_OBJECT_NAME)
681 OR ((recinfo.OLD_SOURCE_OBJECT_NAME is null) AND (X_OLD_SOURCE_OBJECT_NAME is null)))
682 AND ((recinfo.NEW_SOURCE_OBJECT_NAME = X_NEW_SOURCE_OBJECT_NAME)
683 OR ((recinfo.NEW_SOURCE_OBJECT_NAME is null) AND (X_NEW_SOURCE_OBJECT_NAME is null)))
684 AND ((recinfo.OLD_DURATION = X_OLD_DURATION)
685 OR ((recinfo.OLD_DURATION is null) AND (X_OLD_DURATION is null)))
686 AND ((recinfo.NEW_DURATION = X_NEW_DURATION)
687 OR ((recinfo.NEW_DURATION is null) AND (X_NEW_DURATION is null)))
688 AND ((recinfo.OLD_DURATION_UOM = X_OLD_DURATION_UOM)
689 OR ((recinfo.OLD_DURATION_UOM is null) AND (X_OLD_DURATION_UOM is null)))
690 AND ((recinfo.NEW_DURATION_UOM = X_NEW_DURATION_UOM)
691 OR ((recinfo.NEW_DURATION_UOM is null) AND (X_NEW_DURATION_UOM is null)))
692 AND ((recinfo.OLD_PLANNED_EFFORT = X_OLD_PLANNED_EFFORT)
693 OR ((recinfo.OLD_PLANNED_EFFORT is null) AND (X_OLD_PLANNED_EFFORT is null)))
694 AND ((recinfo.NEW_PLANNED_EFFORT = X_NEW_PLANNED_EFFORT)
695 OR ((recinfo.NEW_PLANNED_EFFORT is null) AND (X_NEW_PLANNED_EFFORT is null)))
696 AND ((recinfo.OLD_PLANNED_EFFORT_UOM = X_OLD_PLANNED_EFFORT_UOM)
697 OR ((recinfo.OLD_PLANNED_EFFORT_UOM is null) AND (X_OLD_PLANNED_EFFORT_UOM is null)))
698 AND ((recinfo.NEW_PLANNED_EFFORT_UOM = X_NEW_PLANNED_EFFORT_UOM)
699 OR ((recinfo.NEW_PLANNED_EFFORT_UOM is null) AND (X_NEW_PLANNED_EFFORT_UOM is null)))
700 AND ((recinfo.OLD_ACTUAL_EFFORT = X_OLD_ACTUAL_EFFORT)
701 OR ((recinfo.OLD_ACTUAL_EFFORT is null) AND (X_OLD_ACTUAL_EFFORT is null)))
702 AND ((recinfo.NEW_ACTUAL_EFFORT = X_NEW_ACTUAL_EFFORT)
703 OR ((recinfo.NEW_ACTUAL_EFFORT is null) AND (X_NEW_ACTUAL_EFFORT is null)))
704 AND ((recinfo.OLD_ACTUAL_EFFORT_UOM = X_OLD_ACTUAL_EFFORT_UOM)
705 OR ((recinfo.OLD_ACTUAL_EFFORT_UOM is null) AND (X_OLD_ACTUAL_EFFORT_UOM is null)))
706 AND ((recinfo.NEW_ACTUAL_EFFORT_UOM = X_NEW_ACTUAL_EFFORT_UOM)
707 OR ((recinfo.NEW_ACTUAL_EFFORT_UOM is null) AND (X_NEW_ACTUAL_EFFORT_UOM is null)))
708 AND ((recinfo.OLD_PERCENTAGE_COMPLETE = X_OLD_PERCENTAGE_COMPLETE)
709 OR ((recinfo.OLD_PERCENTAGE_COMPLETE is null) AND (X_OLD_PERCENTAGE_COMPLETE is null)))
710 AND ((recinfo.NEW_PERCENTAGE_COMPLETE = X_NEW_PERCENTAGE_COMPLETE)
711 OR ((recinfo.NEW_PERCENTAGE_COMPLETE is null) AND (X_NEW_PERCENTAGE_COMPLETE is null)))
715 OR ((recinfo.NEW_REASON_CODE is null) AND (X_NEW_REASON_CODE is null)))
712 AND ((recinfo.OLD_REASON_CODE = X_OLD_REASON_CODE)
713 OR ((recinfo.OLD_REASON_CODE is null) AND (X_OLD_REASON_CODE is null)))
714 AND ((recinfo.NEW_REASON_CODE = X_NEW_REASON_CODE)
716 AND ((recinfo.PRIVATE_CHANGED_FLAG = X_PRIVATE_CHANGED_FLAG)
717 OR ((recinfo.PRIVATE_CHANGED_FLAG is null) AND (X_PRIVATE_CHANGED_FLAG is null)))
718 AND ((recinfo.PUBLISH_CHANGED_FLAG = X_PUBLISH_CHANGED_FLAG)
719 OR ((recinfo.PUBLISH_CHANGED_FLAG is null) AND (X_PUBLISH_CHANGED_FLAG is null)))
720 AND ((recinfo.RESTRICT_CLOSURE_CHANGE_FLAG = X_RESTRICT_CLOSURE_CHANGE_FLAG)
721 OR ((recinfo.RESTRICT_CLOSURE_CHANGE_FLAG is null) AND (X_RESTRICT_CLOSURE_CHANGE_FLAG is null)))
722 AND ((recinfo.MULTI_BOOKED_CHANGED_FLAG = X_MULTI_BOOKED_CHANGED_FLAG)
723 OR ((recinfo.MULTI_BOOKED_CHANGED_FLAG is null) AND (X_MULTI_BOOKED_CHANGED_FLAG is null)))
724 AND ((recinfo.MILESTONE_CHANGED_FLAG = X_MILESTONE_CHANGED_FLAG)
725 OR ((recinfo.MILESTONE_CHANGED_FLAG is null) AND (X_MILESTONE_CHANGED_FLAG is null)))
726 AND ((recinfo.HOLIDAY_CHANGED_FLAG = X_HOLIDAY_CHANGED_FLAG)
727 OR ((recinfo.HOLIDAY_CHANGED_FLAG is null) AND (X_HOLIDAY_CHANGED_FLAG is null)))
728 AND ((recinfo.BILLABLE_CHANGED_FLAG = X_BILLABLE_CHANGED_FLAG)
729 OR ((recinfo.BILLABLE_CHANGED_FLAG is null) AND (X_BILLABLE_CHANGED_FLAG is null)))
730 AND ((recinfo.OLD_BOUND_MODE_CODE = X_OLD_BOUND_MODE_CODE)
731 OR ((recinfo.OLD_BOUND_MODE_CODE is null) AND (X_OLD_BOUND_MODE_CODE is null)))
732 AND ((recinfo.NEW_BOUND_MODE_CODE = X_NEW_BOUND_MODE_CODE)
733 OR ((recinfo.NEW_BOUND_MODE_CODE is null) AND (X_NEW_BOUND_MODE_CODE is null)))
734 AND ((recinfo.SOFT_BOUND_CHANGED_FLAG = X_SOFT_BOUND_CHANGED_FLAG)
735 OR ((recinfo.SOFT_BOUND_CHANGED_FLAG is null) AND (X_SOFT_BOUND_CHANGED_FLAG is null)))
736 AND ((recinfo.OLD_WORKFLOW_PROCESS_ID = X_OLD_WORKFLOW_PROCESS_ID)
737 OR ((recinfo.OLD_WORKFLOW_PROCESS_ID is null) AND (X_OLD_WORKFLOW_PROCESS_ID is null)))
738 AND ((recinfo.NEW_WORKFLOW_PROCESS_ID = X_NEW_WORKFLOW_PROCESS_ID)
739 OR ((recinfo.NEW_WORKFLOW_PROCESS_ID is null) AND (X_NEW_WORKFLOW_PROCESS_ID is null)))
740 AND ((recinfo.NOTIFICATION_CHANGED_FLAG = X_NOTIFICATION_CHANGED_FLAG)
741 OR ((recinfo.NOTIFICATION_CHANGED_FLAG is null) AND (X_NOTIFICATION_CHANGED_FLAG is null)))
742 AND ((recinfo.OLD_NOTIFICATION_PERIOD = X_OLD_NOTIFICATION_PERIOD)
743 OR ((recinfo.OLD_NOTIFICATION_PERIOD is null) AND (X_OLD_NOTIFICATION_PERIOD is null)))
744 ) then
745 null;
746 else
747 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
748 app_exception.raise_exception;
749 end if;
750
751 for tlinfo in c1 loop
752 if (tlinfo.BASELANG = 'Y') then
753 if ( (tlinfo.OLD_TASK_NAME = X_OLD_TASK_NAME)
754 AND (tlinfo.NEW_TASK_NAME = X_NEW_TASK_NAME)
755 AND ((tlinfo.OLD_DESCRIPTION = X_OLD_DESCRIPTION)
756 OR ((tlinfo.OLD_DESCRIPTION is null) AND (X_OLD_DESCRIPTION is null)))
757 AND ((tlinfo.NEW_DESCRIPTION = X_NEW_DESCRIPTION)
758 OR ((tlinfo.NEW_DESCRIPTION is null) AND (X_NEW_DESCRIPTION is null)))
759 ) then
760 null;
761 else
762 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
763 app_exception.raise_exception;
764 end if;
765 end if;
766 end loop;
767 return;
768 end LOCK_ROW;
769
770 procedure UPDATE_ROW (
771 X_TASK_AUDIT_ID in NUMBER,
772 X_NEW_NOTIFICATION_PERIOD in NUMBER,
773 X_OLD_NOTIFICATION_PERIOD_UOM in VARCHAR2,
774 X_NEW_NOTIFICATION_PERIOD_UOM in VARCHAR2,
775 X_OLD_PARENT_TASK_ID in NUMBER,
776 X_NEW_PARENT_TASK_ID in NUMBER,
777 X_OLD_RECURRENCE_RULE_ID in NUMBER,
778 X_NEW_RECURRENCE_RULE_ID in NUMBER,
779 X_PALM_CHANGED_FLAG in VARCHAR2,
780 X_WINCE_CHANGED_FLAG in VARCHAR2,
781 X_LAPTOP_CHANGED_FLAG in VARCHAR2,
782 X_DEVICE1_CHANGED_FLAG in VARCHAR2,
783 X_DEVICE2_CHANGED_FLAG in VARCHAR2,
784 X_DEVICE3_CHANGED_FLAG in VARCHAR2,
785 X_OLD_CURRENCY_CODE in VARCHAR2,
786 X_NEW_CURRENCY_CODE in VARCHAR2,
787 X_OLD_COSTS in NUMBER,
788 X_NEW_COSTS in NUMBER,
789 X_OLD_ORG_ID in NUMBER,
790 X_NEW_ORG_ID in NUMBER,
791 X_TASK_ID in NUMBER,
792 X_OLD_TASK_TYPE_ID in NUMBER,
793 X_NEW_TASK_TYPE_ID in NUMBER,
794 X_OLD_TASK_STATUS_ID in NUMBER,
795 X_NEW_TASK_STATUS_ID in NUMBER,
796 X_OLD_TASK_PRIORITY_ID in NUMBER,
797 X_NEW_TASK_PRIORITY_ID in NUMBER,
798 X_OLD_OWNER_ID in NUMBER,
799 X_NEW_OWNER_ID in NUMBER,
800 X_OLD_OWNER_TYPE_CODE in VARCHAR2,
801 X_NEW_OWNER_TYPE_CODE in VARCHAR2,
802 X_OLD_ASSIGNED_BY_ID in NUMBER,
803 X_NEW_ASSIGNED_BY_ID in NUMBER,
804 X_OLD_CUST_ACCOUNT_ID in NUMBER,
805 X_NEW_CUST_ACCOUNT_ID in NUMBER,
806 X_OLD_CUSTOMER_ID in NUMBER,
807 X_NEW_CUSTOMER_ID in NUMBER,
808 X_OLD_ADDRESS_ID in NUMBER,
809 X_NEW_ADDRESS_ID in NUMBER,
810 X_OLD_PLANNED_START_DATE in DATE,
811 X_NEW_PLANNED_START_DATE in DATE,
812 X_OLD_PLANNED_END_DATE in DATE,
813 X_NEW_PLANNED_END_DATE in DATE,
814 X_OLD_SCHEDULED_START_DATE in DATE,
815 X_NEW_SCHEDULED_START_DATE in DATE,
816 X_OLD_SCHEDULED_END_DATE in DATE,
817 X_NEW_SCHEDULED_END_DATE in DATE,
818 X_OLD_ACTUAL_START_DATE in DATE,
819 X_NEW_ACTUAL_START_DATE in DATE,
820 X_OLD_ACTUAL_END_DATE in DATE,
821 X_NEW_ACTUAL_END_DATE in DATE,
822 X_OLD_SOURCE_OBJECT_TYPE_CODE in VARCHAR2,
823 X_NEW_SOURCE_OBJECT_TYPE_CODE in VARCHAR2,
824 X_OLD_TIMEZONE_ID in NUMBER,
825 X_NEW_TIMEZONE_ID in NUMBER,
826 X_OLD_SOURCE_OBJECT_ID in NUMBER,
827 X_NEW_SOURCE_OBJECT_ID in NUMBER,
828 X_OLD_SOURCE_OBJECT_NAME in VARCHAR2,
829 X_NEW_SOURCE_OBJECT_NAME in VARCHAR2,
833 X_NEW_DURATION_UOM in VARCHAR2,
830 X_OLD_DURATION in NUMBER,
831 X_NEW_DURATION in NUMBER,
832 X_OLD_DURATION_UOM in VARCHAR2,
834 X_OLD_PLANNED_EFFORT in NUMBER,
835 X_NEW_PLANNED_EFFORT in NUMBER,
836 X_OLD_PLANNED_EFFORT_UOM in VARCHAR2,
837 X_NEW_PLANNED_EFFORT_UOM in VARCHAR2,
838 X_OLD_ACTUAL_EFFORT in NUMBER,
839 X_NEW_ACTUAL_EFFORT in NUMBER,
840 X_OLD_ACTUAL_EFFORT_UOM in VARCHAR2,
841 X_NEW_ACTUAL_EFFORT_UOM in VARCHAR2,
842 X_OLD_PERCENTAGE_COMPLETE in NUMBER,
843 X_NEW_PERCENTAGE_COMPLETE in NUMBER,
844 X_OLD_REASON_CODE in VARCHAR2,
845 X_NEW_REASON_CODE in VARCHAR2,
846 X_PRIVATE_CHANGED_FLAG in VARCHAR2,
847 X_PUBLISH_CHANGED_FLAG in VARCHAR2,
848 X_RESTRICT_CLOSURE_CHANGE_FLAG in VARCHAR2,
849 X_MULTI_BOOKED_CHANGED_FLAG in VARCHAR2,
850 X_MILESTONE_CHANGED_FLAG in VARCHAR2,
851 X_HOLIDAY_CHANGED_FLAG in VARCHAR2,
852 X_BILLABLE_CHANGED_FLAG in VARCHAR2,
853 X_OLD_BOUND_MODE_CODE in VARCHAR2,
854 X_NEW_BOUND_MODE_CODE in VARCHAR2,
855 X_SOFT_BOUND_CHANGED_FLAG in VARCHAR2,
856 X_OLD_WORKFLOW_PROCESS_ID in NUMBER,
857 X_NEW_WORKFLOW_PROCESS_ID in NUMBER,
858 X_NOTIFICATION_CHANGED_FLAG in VARCHAR2,
859 X_OLD_NOTIFICATION_PERIOD in NUMBER,
860 X_OLD_TASK_NAME in VARCHAR2,
861 X_NEW_TASK_NAME in VARCHAR2,
862 X_OLD_DESCRIPTION in VARCHAR2,
863 X_NEW_DESCRIPTION in VARCHAR2,
864 X_LAST_UPDATE_DATE in DATE,
865 X_LAST_UPDATED_BY in NUMBER,
866 X_LAST_UPDATE_LOGIN in NUMBER,
867 X_NEW_ESCALATION_LEVEL in VARCHAR2,
868 X_OLD_ESCALATION_LEVEL in VARCHAR2
869 ) is
870 begin
871 update JTF_TASK_AUDITS_B set
872 NEW_NOTIFICATION_PERIOD = X_NEW_NOTIFICATION_PERIOD,
873 OLD_NOTIFICATION_PERIOD_UOM = X_OLD_NOTIFICATION_PERIOD_UOM,
874 NEW_NOTIFICATION_PERIOD_UOM = X_NEW_NOTIFICATION_PERIOD_UOM,
875 OLD_PARENT_TASK_ID = X_OLD_PARENT_TASK_ID,
876 NEW_PARENT_TASK_ID = X_NEW_PARENT_TASK_ID,
877 OLD_RECURRENCE_RULE_ID = X_OLD_RECURRENCE_RULE_ID,
878 NEW_RECURRENCE_RULE_ID = X_NEW_RECURRENCE_RULE_ID,
879 PALM_CHANGED_FLAG = X_PALM_CHANGED_FLAG,
880 WINCE_CHANGED_FLAG = X_WINCE_CHANGED_FLAG,
881 LAPTOP_CHANGED_FLAG = X_LAPTOP_CHANGED_FLAG,
882 DEVICE1_CHANGED_FLAG = X_DEVICE1_CHANGED_FLAG,
883 DEVICE2_CHANGED_FLAG = X_DEVICE2_CHANGED_FLAG,
884 DEVICE3_CHANGED_FLAG = X_DEVICE3_CHANGED_FLAG,
885 OLD_CURRENCY_CODE = X_OLD_CURRENCY_CODE,
886 NEW_CURRENCY_CODE = X_NEW_CURRENCY_CODE,
887 OLD_COSTS = X_OLD_COSTS,
888 NEW_COSTS = X_NEW_COSTS,
889 OLD_ORG_ID = X_OLD_ORG_ID,
890 NEW_ORG_ID = X_NEW_ORG_ID,
891 TASK_ID = X_TASK_ID,
892 OLD_TASK_TYPE_ID = X_OLD_TASK_TYPE_ID,
893 NEW_TASK_TYPE_ID = X_NEW_TASK_TYPE_ID,
894 OLD_TASK_STATUS_ID = X_OLD_TASK_STATUS_ID,
895 NEW_TASK_STATUS_ID = X_NEW_TASK_STATUS_ID,
896 OLD_TASK_PRIORITY_ID = X_OLD_TASK_PRIORITY_ID,
897 NEW_TASK_PRIORITY_ID = X_NEW_TASK_PRIORITY_ID,
898 OLD_OWNER_ID = X_OLD_OWNER_ID,
899 NEW_OWNER_ID = X_NEW_OWNER_ID,
900 OLD_OWNER_TYPE_CODE = X_OLD_OWNER_TYPE_CODE,
901 NEW_OWNER_TYPE_CODE = X_NEW_OWNER_TYPE_CODE,
902 OLD_ASSIGNED_BY_ID = X_OLD_ASSIGNED_BY_ID,
903 NEW_ASSIGNED_BY_ID = X_NEW_ASSIGNED_BY_ID,
904 OLD_CUST_ACCOUNT_ID = X_OLD_CUST_ACCOUNT_ID,
905 NEW_CUST_ACCOUNT_ID = X_NEW_CUST_ACCOUNT_ID,
906 OLD_CUSTOMER_ID = X_OLD_CUSTOMER_ID,
907 NEW_CUSTOMER_ID = X_NEW_CUSTOMER_ID,
908 OLD_ADDRESS_ID = X_OLD_ADDRESS_ID,
909 NEW_ADDRESS_ID = X_NEW_ADDRESS_ID,
910 OLD_PLANNED_START_DATE = X_OLD_PLANNED_START_DATE,
911 NEW_PLANNED_START_DATE = X_NEW_PLANNED_START_DATE,
912 OLD_PLANNED_END_DATE = X_OLD_PLANNED_END_DATE,
913 NEW_PLANNED_END_DATE = X_NEW_PLANNED_END_DATE,
914 OLD_SCHEDULED_START_DATE = X_OLD_SCHEDULED_START_DATE,
915 NEW_SCHEDULED_START_DATE = X_NEW_SCHEDULED_START_DATE,
916 OLD_SCHEDULED_END_DATE = X_OLD_SCHEDULED_END_DATE,
917 NEW_SCHEDULED_END_DATE = X_NEW_SCHEDULED_END_DATE,
918 OLD_ACTUAL_START_DATE = X_OLD_ACTUAL_START_DATE,
919 NEW_ACTUAL_START_DATE = X_NEW_ACTUAL_START_DATE,
920 OLD_ACTUAL_END_DATE = X_OLD_ACTUAL_END_DATE,
921 NEW_ACTUAL_END_DATE = X_NEW_ACTUAL_END_DATE,
922 OLD_SOURCE_OBJECT_TYPE_CODE = X_OLD_SOURCE_OBJECT_TYPE_CODE,
923 NEW_SOURCE_OBJECT_TYPE_CODE = X_NEW_SOURCE_OBJECT_TYPE_CODE,
924 OLD_TIMEZONE_ID = X_OLD_TIMEZONE_ID,
925 NEW_TIMEZONE_ID = X_NEW_TIMEZONE_ID,
926 OLD_SOURCE_OBJECT_ID = X_OLD_SOURCE_OBJECT_ID,
927 NEW_SOURCE_OBJECT_ID = X_NEW_SOURCE_OBJECT_ID,
928 OLD_SOURCE_OBJECT_NAME = X_OLD_SOURCE_OBJECT_NAME,
929 NEW_SOURCE_OBJECT_NAME = X_NEW_SOURCE_OBJECT_NAME,
930 OLD_DURATION = X_OLD_DURATION,
931 NEW_DURATION = X_NEW_DURATION,
932 OLD_DURATION_UOM = X_OLD_DURATION_UOM,
933 NEW_DURATION_UOM = X_NEW_DURATION_UOM,
934 OLD_PLANNED_EFFORT = X_OLD_PLANNED_EFFORT,
935 NEW_PLANNED_EFFORT = X_NEW_PLANNED_EFFORT,
936 OLD_PLANNED_EFFORT_UOM = X_OLD_PLANNED_EFFORT_UOM,
937 NEW_PLANNED_EFFORT_UOM = X_NEW_PLANNED_EFFORT_UOM,
938 OLD_ACTUAL_EFFORT = X_OLD_ACTUAL_EFFORT,
939 NEW_ACTUAL_EFFORT = X_NEW_ACTUAL_EFFORT,
940 OLD_ACTUAL_EFFORT_UOM = X_OLD_ACTUAL_EFFORT_UOM,
941 NEW_ACTUAL_EFFORT_UOM = X_NEW_ACTUAL_EFFORT_UOM,
942 OLD_PERCENTAGE_COMPLETE = X_OLD_PERCENTAGE_COMPLETE,
943 NEW_PERCENTAGE_COMPLETE = X_NEW_PERCENTAGE_COMPLETE,
944 OLD_REASON_CODE = X_OLD_REASON_CODE,
945 NEW_REASON_CODE = X_NEW_REASON_CODE,
946 PRIVATE_CHANGED_FLAG = X_PRIVATE_CHANGED_FLAG,
947 PUBLISH_CHANGED_FLAG = X_PUBLISH_CHANGED_FLAG,
948 RESTRICT_CLOSURE_CHANGE_FLAG = X_RESTRICT_CLOSURE_CHANGE_FLAG,
949 MULTI_BOOKED_CHANGED_FLAG = X_MULTI_BOOKED_CHANGED_FLAG,
950 MILESTONE_CHANGED_FLAG = X_MILESTONE_CHANGED_FLAG,
951 HOLIDAY_CHANGED_FLAG = X_HOLIDAY_CHANGED_FLAG,
952 BILLABLE_CHANGED_FLAG = X_BILLABLE_CHANGED_FLAG,
956 OLD_WORKFLOW_PROCESS_ID = X_OLD_WORKFLOW_PROCESS_ID,
953 OLD_BOUND_MODE_CODE = X_OLD_BOUND_MODE_CODE,
954 NEW_BOUND_MODE_CODE = X_NEW_BOUND_MODE_CODE,
955 SOFT_BOUND_CHANGED_FLAG = X_SOFT_BOUND_CHANGED_FLAG,
957 NEW_WORKFLOW_PROCESS_ID = X_NEW_WORKFLOW_PROCESS_ID,
958 NOTIFICATION_CHANGED_FLAG = X_NOTIFICATION_CHANGED_FLAG,
959 OLD_NOTIFICATION_PERIOD = X_OLD_NOTIFICATION_PERIOD,
960 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
961 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
962 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
963 NEW_ESCALATION_LEVEL = X_NEW_ESCALATION_LEVEL,
964 OLD_ESCALATION_LEVEL = X_OLD_ESCALATION_LEVEL
965 where TASK_AUDIT_ID = X_TASK_AUDIT_ID;
966
967 if (sql%notfound) then
968 raise no_data_found;
969 end if;
970
971 update JTF_TASK_AUDITS_TL set
972 OLD_TASK_NAME = X_OLD_TASK_NAME,
973 NEW_TASK_NAME = X_NEW_TASK_NAME,
974 OLD_DESCRIPTION = X_OLD_DESCRIPTION,
975 NEW_DESCRIPTION = X_NEW_DESCRIPTION,
976 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
977 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
978 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
979 SOURCE_LANG = userenv('LANG')
980 where TASK_AUDIT_ID = X_TASK_AUDIT_ID
981 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
982
983 if (sql%notfound) then
984 raise no_data_found;
985 end if;
986 end UPDATE_ROW;
987
988 procedure DELETE_ROW (
989 X_TASK_AUDIT_ID in NUMBER
990 ) is
991 begin
992 delete from JTF_TASK_AUDITS_TL
993 where TASK_AUDIT_ID = X_TASK_AUDIT_ID;
994
995 if (sql%notfound) then
996 raise no_data_found;
997 end if;
998
999 delete from JTF_TASK_AUDITS_B
1000 where TASK_AUDIT_ID = X_TASK_AUDIT_ID;
1001
1002 if (sql%notfound) then
1003 raise no_data_found;
1004 end if;
1005 end DELETE_ROW;
1006
1007 procedure ADD_LANGUAGE
1008 is
1009 begin
1010 delete from JTF_TASK_AUDITS_TL T
1011 where not exists
1012 (select NULL
1013 from JTF_TASK_AUDITS_B B
1014 where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
1015 );
1016
1017 update JTF_TASK_AUDITS_TL T set (
1018 OLD_TASK_NAME,
1019 NEW_TASK_NAME,
1020 OLD_DESCRIPTION,
1021 NEW_DESCRIPTION
1022 ) = (select
1023 B.OLD_TASK_NAME,
1024 B.NEW_TASK_NAME,
1025 B.OLD_DESCRIPTION,
1026 B.NEW_DESCRIPTION
1027 from JTF_TASK_AUDITS_TL B
1028 where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
1029 and B.LANGUAGE = T.SOURCE_LANG)
1030 where (
1031 T.TASK_AUDIT_ID,
1032 T.LANGUAGE
1033 ) in (select
1034 SUBT.TASK_AUDIT_ID,
1035 SUBT.LANGUAGE
1036 from JTF_TASK_AUDITS_TL SUBB, JTF_TASK_AUDITS_TL SUBT
1037 where SUBB.TASK_AUDIT_ID = SUBT.TASK_AUDIT_ID
1038 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1039 and (SUBB.OLD_TASK_NAME <> SUBT.OLD_TASK_NAME
1040 or SUBB.NEW_TASK_NAME <> SUBT.NEW_TASK_NAME
1041 or SUBB.OLD_DESCRIPTION <> SUBT.OLD_DESCRIPTION
1042 or (SUBB.OLD_DESCRIPTION is null and SUBT.OLD_DESCRIPTION is not null)
1043 or (SUBB.OLD_DESCRIPTION is not null and SUBT.OLD_DESCRIPTION is null)
1044 or SUBB.NEW_DESCRIPTION <> SUBT.NEW_DESCRIPTION
1045 or (SUBB.NEW_DESCRIPTION is null and SUBT.NEW_DESCRIPTION is not null)
1046 or (SUBB.NEW_DESCRIPTION is not null and SUBT.NEW_DESCRIPTION is null)
1047 ));
1048
1049 insert into JTF_TASK_AUDITS_TL (
1050 TASK_AUDIT_ID,
1051 OLD_TASK_NAME,
1052 NEW_TASK_NAME,
1053 OLD_DESCRIPTION,
1054 NEW_DESCRIPTION,
1055 CREATED_BY,
1056 CREATION_DATE,
1057 LAST_UPDATED_BY,
1058 LAST_UPDATE_DATE,
1059 LAST_UPDATE_LOGIN,
1060 LANGUAGE,
1061 SOURCE_LANG
1062 ) select
1063 B.TASK_AUDIT_ID,
1064 B.OLD_TASK_NAME,
1065 B.NEW_TASK_NAME,
1066 B.OLD_DESCRIPTION,
1067 B.NEW_DESCRIPTION,
1068 B.CREATED_BY,
1069 B.CREATION_DATE,
1070 B.LAST_UPDATED_BY,
1071 B.LAST_UPDATE_DATE,
1072 B.LAST_UPDATE_LOGIN,
1073 L.LANGUAGE_CODE,
1074 B.SOURCE_LANG
1075 from JTF_TASK_AUDITS_TL B, FND_LANGUAGES L
1076 where L.INSTALLED_FLAG in ('I', 'B')
1077 and B.LANGUAGE = userenv('LANG')
1078 and not exists
1079 (select NULL
1080 from JTF_TASK_AUDITS_TL T
1081 where T.TASK_AUDIT_ID = B.TASK_AUDIT_ID
1082 and T.LANGUAGE = L.LANGUAGE_CODE);
1083 end ADD_LANGUAGE;
1084
1085 end JTF_TASK_AUDITS_PKG;