[Home] [Help]
PACKAGE BODY: APPS.JTF_RS_RESOURCE_EXTN_AUD_PKG
Source
1 package body JTF_RS_RESOURCE_EXTN_AUD_PKG as
2 /* $Header: jtfrstab.pls 120.0 2005/05/11 08:22:04 appldev ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_RESOURCE_AUDIT_ID in NUMBER,
6 X_RESOURCE_ID in NUMBER,
7 X_NEW_CATEGORY in VARCHAR2,
8 X_OLD_CATEGORY in VARCHAR2,
9 X_NEW_RESOURCE_NUMBER in VARCHAR2,
10 X_OLD_RESOURCE_NUMBER in VARCHAR2,
11 X_NEW_SOURCE_ID in NUMBER,
12 X_OLD_SOURCE_ID in NUMBER,
13 X_NEW_ADDRESS_ID in NUMBER,
14 X_OLD_ADDRESS_ID in NUMBER,
15 X_NEW_CONTACT_ID in NUMBER,
16 X_OLD_CONTACT_ID in NUMBER,
17 X_NEW_MANAGING_EMPLOYEE_ID in NUMBER,
18 X_OLD_MANAGING_EMPLOYEE_ID in NUMBER,
19 X_OLD_START_DATE_ACTIVE in DATE,
20 X_NEW_START_DATE_ACTIVE in DATE,
21 X_OLD_END_DATE_ACTIVE in DATE,
22 X_NEW_END_DATE_ACTIVE in DATE,
23 X_NEW_TIME_ZONE in NUMBER,
24 X_OLD_TIME_ZONE in NUMBER,
25 X_NEW_COST_PER_HR in NUMBER,
26 X_OLD_COST_PER_HR in NUMBER,
27 X_NEW_PRIMARY_LANGUAGE in VARCHAR2,
28 X_OLD_PRIMARY_LANGUAGE in VARCHAR2,
29 X_NEW_SECONDARY_LANGUAGE in VARCHAR2,
30 X_OLD_SECONDARY_LANGUAGE in VARCHAR2,
31 X_NEW_SUPPORT_SITE_ID in NUMBER,
32 X_OLD_SUPPORT_SITE_ID in NUMBER,
33 X_NEW_IES_AGENT_LOGIN in VARCHAR2,
34 X_OLD_IES_AGENT_LOGIN in VARCHAR2,
35 X_NEW_SERVER_GROUP_ID in NUMBER,
36 X_OLD_SERVER_GROUP_ID in NUMBER,
37 X_NEW_ASSIGNED_TO_GROUP_ID in NUMBER,
38 X_OLD_ASSIGNED_TO_GROUP_ID in NUMBER,
39 X_NEW_COST_CENTER in VARCHAR2,
40 X_OLD_COST_CENTER in VARCHAR2,
41 X_NEW_CHARGE_TO_COST_CENTER in VARCHAR2,
42 X_OLD_CHARGE_TO_COST_CENTER in VARCHAR2,
43 X_NEW_COMPENSATION_CURRENCY_CO in VARCHAR2,
44 X_OLD_COMPENSATION_CURRENCY_CO in VARCHAR2,
45 X_NEW_COMMISSIONABLE_FLAG in VARCHAR2,
46 X_OLD_COMMISSIONABLE_FLAG in VARCHAR2,
47 X_NEW_HOLD_REASON_CODE in VARCHAR2,
48 X_OLD_HOLD_REASON_CODE in VARCHAR2,
49 X_NEW_HOLD_PAYMENT in VARCHAR2,
50 X_OLD_HOLD_PAYMENT in VARCHAR2,
51 X_NEW_COMP_SERVICE_TEAM_ID in NUMBER,
52 X_OLD_COMP_SERVICE_TEAM_ID in NUMBER,
53 X_NEW_TRANSACTION_NUMBER in NUMBER,
54 X_OLD_TRANSACTION_NUMBER in NUMBER,
55 X_NEW_OBJECT_VERSION_NUMBER in NUMBER,
56 X_OLD_OBJECT_VERSION_NUMBER in NUMBER,
57 X_NEW_USER_ID in NUMBER,
58 X_OLD_USER_ID in NUMBER,
59 --X_OLD_LOCATION in MDSYS.SDO_GEOMETRY,
60 --X_NEW_LOCATION in MDSYS.SDO_GEOMETRY,
61 X_CREATION_DATE in DATE,
62 X_CREATED_BY in NUMBER,
63 X_LAST_UPDATE_DATE in DATE,
64 X_LAST_UPDATED_BY in NUMBER,
65 X_LAST_UPDATE_LOGIN in NUMBER,
66 X_NEW_RESOURCE_NAME in VARCHAR2,
67 X_OLD_RESOURCE_NAME in VARCHAR2,
68 X_NEW_SOURCE_NAME in VARCHAR2,
69 X_OLD_SOURCE_NAME in VARCHAR2,
70 X_NEW_SOURCE_NUMBER in VARCHAR2,
71 X_OLD_SOURCE_NUMBER in VARCHAR2,
72 X_NEW_SOURCE_JOB_TITLE in VARCHAR2,
73 X_OLD_SOURCE_JOB_TITLE in VARCHAR2,
74 X_NEW_SOURCE_EMAIL in VARCHAR2,
75 X_OLD_SOURCE_EMAIL in VARCHAR2,
76 X_NEW_SOURCE_PHONE in VARCHAR2,
77 X_OLD_SOURCE_PHONE in VARCHAR2,
78 X_NEW_SOURCE_ORG_ID in NUMBER,
79 X_OLD_SOURCE_ORG_ID in NUMBER,
80 X_NEW_SOURCE_ORG_NAME in VARCHAR2,
81 X_OLD_SOURCE_ORG_NAME in VARCHAR2,
82 X_NEW_SOURCE_ADDRESS1 in VARCHAR2,
83 X_OLD_SOURCE_ADDRESS1 in VARCHAR2,
84 X_NEW_SOURCE_ADDRESS2 in VARCHAR2,
85 X_OLD_SOURCE_ADDRESS2 in VARCHAR2,
86 X_NEW_SOURCE_ADDRESS3 in VARCHAR2,
87 X_OLD_SOURCE_ADDRESS3 in VARCHAR2,
88 X_NEW_SOURCE_ADDRESS4 in VARCHAR2,
89 X_OLD_SOURCE_ADDRESS4 in VARCHAR2,
90 X_NEW_SOURCE_CITY in VARCHAR2,
91 X_OLD_SOURCE_CITY in VARCHAR2,
92 X_NEW_SOURCE_POSTAL_CODE in VARCHAR2,
93 X_OLD_SOURCE_POSTAL_CODE in VARCHAR2,
94 X_NEW_SOURCE_STATE in VARCHAR2,
95 X_OLD_SOURCE_STATE in VARCHAR2,
96 X_NEW_SOURCE_PROVINCE in VARCHAR2,
97 X_OLD_SOURCE_PROVINCE in VARCHAR2,
98 X_NEW_SOURCE_COUNTY in VARCHAR2,
99 X_OLD_SOURCE_COUNTY in VARCHAR2,
100 X_NEW_SOURCE_COUNTRY in VARCHAR2,
101 X_OLD_SOURCE_COUNTRY in VARCHAR2,
102 X_NEW_SOURCE_MGR_ID in NUMBER,
103 X_OLD_SOURCE_MGR_ID in NUMBER,
104 X_NEW_SOURCE_MGR_NAME in VARCHAR2,
105 X_OLD_SOURCE_MGR_NAME in VARCHAR2,
106 X_NEW_SOURCE_BUSINESS_GRP_ID in NUMBER,
107 X_OLD_SOURCE_BUSINESS_GRP_ID in NUMBER,
108 X_NEW_SOURCE_BUSINESS_GRP_NAME in VARCHAR2,
109 X_OLD_SOURCE_BUSINESS_GRP_NAME in VARCHAR2,
110 X_NEW_SOURCE_FIRST_NAME in VARCHAR2,
111 X_OLD_SOURCE_FIRST_NAME in VARCHAR2,
112 X_NEW_SOURCE_MIDDLE_NAME in VARCHAR2,
113 X_OLD_SOURCE_MIDDLE_NAME in VARCHAR2,
114 X_NEW_SOURCE_LAST_NAME in VARCHAR2,
115 X_OLD_SOURCE_LAST_NAME in VARCHAR2,
116 X_NEW_SOURCE_CATEGORY in VARCHAR2,
117 X_OLD_SOURCE_CATEGORY in VARCHAR2,
118 X_NEW_SOURCE_STATUS in VARCHAR2,
119 X_OLD_SOURCE_STATUS in VARCHAR2,
120 X_NEW_SOURCE_OFFICE in VARCHAR2,
121 X_OLD_SOURCE_OFFICE in VARCHAR2,
122 X_NEW_SOURCE_LOCATION in VARCHAR2,
123 X_OLD_SOURCE_LOCATION in VARCHAR2,
124 X_NEW_SOURCE_MAILSTOP in VARCHAR2,
125 X_OLD_SOURCE_MAILSTOP in VARCHAR2,
126 X_NEW_USER_NAME in VARCHAR2,
127 X_OLD_USER_NAME in VARCHAR2,
128 X_NEW_SOURCE_JOB_ID in VARCHAR2,
129 X_OLD_SOURCE_JOB_ID in VARCHAR2,
130 X_NEW_PARTY_ID in VARCHAR2,
131 X_OLD_PARTY_ID in VARCHAR2,
132 X_NEW_SOURCE_MOBILE_PHONE in VARCHAR2,
133 X_OLD_SOURCE_MOBILE_PHONE in VARCHAR2,
134 X_NEW_SOURCE_PAGER in VARCHAR2,
135 X_OLD_SOURCE_PAGER in VARCHAR2
136 ) is
137 cursor C is select ROWID from JTF_RS_RESOURCE_EXTN_AUD
138 where RESOURCE_AUDIT_ID = X_RESOURCE_AUDIT_ID
139 ;
140 begin
141 insert into JTF_RS_RESOURCE_EXTN_AUD (
142 RESOURCE_AUDIT_ID,
143 RESOURCE_ID,
144 NEW_CATEGORY,
145 OLD_CATEGORY,
146 NEW_RESOURCE_NUMBER,
147 OLD_RESOURCE_NUMBER,
148 NEW_SOURCE_ID,
149 OLD_SOURCE_ID,
150 NEW_ADDRESS_ID,
151 OLD_ADDRESS_ID,
152 NEW_CONTACT_ID,
153 OLD_CONTACT_ID,
154 NEW_MANAGING_EMPLOYEE_ID,
155 OLD_MANAGING_EMPLOYEE_ID,
156 OLD_START_DATE_ACTIVE,
157 NEW_START_DATE_ACTIVE,
158 OLD_END_DATE_ACTIVE,
159 NEW_END_DATE_ACTIVE,
160 NEW_TIME_ZONE,
161 OLD_TIME_ZONE,
162 NEW_COST_PER_HR,
163 OLD_COST_PER_HR,
164 NEW_PRIMARY_LANGUAGE,
165 OLD_PRIMARY_LANGUAGE,
166 NEW_SECONDARY_LANGUAGE,
167 OLD_SECONDARY_LANGUAGE,
168 NEW_SUPPORT_SITE_ID,
169 OLD_SUPPORT_SITE_ID,
170 NEW_IES_AGENT_LOGIN,
171 OLD_IES_AGENT_LOGIN,
172 NEW_SERVER_GROUP_ID,
173 OLD_SERVER_GROUP_ID,
174 NEW_ASSIGNED_TO_GROUP_ID,
175 OLD_ASSIGNED_TO_GROUP_ID,
176 NEW_COST_CENTER,
177 OLD_COST_CENTER,
178 NEW_CHARGE_TO_COST_CENTER,
179 OLD_CHARGE_TO_COST_CENTER,
180 NEW_COMPENSATION_CURRENCY_CODE,
181 OLD_COMPENSATION_CURRENCY_CODE,
182 NEW_COMMISSIONABLE_FLAG,
183 OLD_COMMISSIONABLE_FLAG,
184 NEW_HOLD_REASON_CODE,
185 OLD_HOLD_REASON_CODE,
186 NEW_HOLD_PAYMENT,
187 OLD_HOLD_PAYMENT,
188 NEW_COMP_SERVICE_TEAM_ID,
189 OLD_COMP_SERVICE_TEAM_ID,
190 NEW_TRANSACTION_NUMBER,
191 OLD_TRANSACTION_NUMBER,
192 NEW_OBJECT_VERSION_NUMBER,
193 OLD_OBJECT_VERSION_NUMBER,
194 NEW_USER_ID,
195 OLD_USER_ID,
196 --OLD_LOCATION,
197 -- NEW_LOCATION,
198 CREATED_BY,
199 CREATION_DATE,
200 LAST_UPDATED_BY,
201 LAST_UPDATE_DATE,
202 LAST_UPDATE_LOGIN,
203 NEW_RESOURCE_NAME ,
204 OLD_RESOURCE_NAME ,
205 NEW_SOURCE_NAME ,
206 OLD_SOURCE_NAME ,
207 NEW_SOURCE_NUMBER ,
208 OLD_SOURCE_NUMBER ,
209 NEW_SOURCE_JOB_TITLE ,
210 OLD_SOURCE_JOB_TITLE ,
211 NEW_SOURCE_EMAIL ,
212 OLD_SOURCE_EMAIL ,
213 NEW_SOURCE_PHONE ,
214 OLD_SOURCE_PHONE ,
215 NEW_SOURCE_ORG_ID ,
216 OLD_SOURCE_ORG_ID ,
217 NEW_SOURCE_ORG_NAME ,
218 OLD_SOURCE_ORG_NAME ,
219 NEW_SOURCE_ADDRESS1 ,
220 OLD_SOURCE_ADDRESS1 ,
221 NEW_SOURCE_ADDRESS2 ,
222 OLD_SOURCE_ADDRESS2 ,
223 NEW_SOURCE_ADDRESS3 ,
224 OLD_SOURCE_ADDRESS3 ,
225 NEW_SOURCE_ADDRESS4 ,
226 OLD_SOURCE_ADDRESS4 ,
227 NEW_SOURCE_CITY ,
228 OLD_SOURCE_CITY ,
229 NEW_SOURCE_POSTAL_CODE ,
230 OLD_SOURCE_POSTAL_CODE ,
231 NEW_SOURCE_STATE ,
232 OLD_SOURCE_STATE ,
233 NEW_SOURCE_PROVINCE ,
234 OLD_SOURCE_PROVINCE ,
235 NEW_SOURCE_COUNTY ,
236 OLD_SOURCE_COUNTY ,
237 NEW_SOURCE_COUNTRY ,
238 OLD_SOURCE_COUNTRY,
239 NEW_SOURCE_MGR_ID,
240 OLD_SOURCE_MGR_ID,
241 NEW_SOURCE_MGR_NAME,
242 OLD_SOURCE_MGR_NAME,
243 NEW_SOURCE_BUSINESS_GRP_ID,
244 OLD_SOURCE_BUSINESS_GRP_ID,
245 NEW_SOURCE_BUSINESS_GRP_NAME,
246 OLD_SOURCE_BUSINESS_GRP_NAME,
247 NEW_SOURCE_FIRST_NAME ,
248 OLD_SOURCE_FIRST_NAME,
249 NEW_SOURCE_LAST_NAME ,
250 OLD_SOURCE_LAST_NAME,
251 NEW_SOURCE_MIDDLE_NAME,
252 OLD_SOURCE_MIDDLE_NAME ,
253 NEW_SOURCE_CATEGORY ,
254 OLD_SOURCE_CATEGORY ,
255 NEW_SOURCE_STATUS ,
256 OLD_SOURCE_STATUS ,
257 NEW_SOURCE_OFFICE,
258 OLD_SOURCE_OFFICE,
259 NEW_SOURCE_LOCATION,
260 OLD_SOURCE_LOCATION,
261 NEW_SOURCE_MAILSTOP,
262 OLD_SOURCE_MAILSTOP,
263 NEW_USER_NAME,
264 OLD_USER_NAME,
265 NEW_SOURCE_JOB_ID,
266 OLD_SOURCE_JOB_ID,
267 NEW_PARTY_ID,
268 OLD_PARTY_ID,
269 NEW_SOURCE_MOBILE_PHONE,
270 OLD_SOURCE_MOBILE_PHONE,
271 NEW_SOURCE_PAGER,
272 OLD_SOURCE_PAGER
273 ) values (
274 X_RESOURCE_AUDIT_ID,
275 X_RESOURCE_ID,
276 X_NEW_CATEGORY,
277 X_OLD_CATEGORY,
278 X_NEW_RESOURCE_NUMBER,
279 X_OLD_RESOURCE_NUMBER,
280 X_NEW_SOURCE_ID,
281 X_OLD_SOURCE_ID,
282 X_NEW_ADDRESS_ID,
283 X_OLD_ADDRESS_ID,
284 X_NEW_CONTACT_ID,
285 X_OLD_CONTACT_ID,
286 X_NEW_MANAGING_EMPLOYEE_ID,
287 X_OLD_MANAGING_EMPLOYEE_ID,
288 X_OLD_START_DATE_ACTIVE,
289 X_NEW_START_DATE_ACTIVE,
290 X_OLD_END_DATE_ACTIVE,
291 X_NEW_END_DATE_ACTIVE,
292 X_NEW_TIME_ZONE,
293 X_OLD_TIME_ZONE,
294 X_NEW_COST_PER_HR,
295 X_OLD_COST_PER_HR,
296 X_NEW_PRIMARY_LANGUAGE,
297 X_OLD_PRIMARY_LANGUAGE,
298 X_NEW_SECONDARY_LANGUAGE,
299 X_OLD_SECONDARY_LANGUAGE,
300 X_NEW_SUPPORT_SITE_ID,
301 X_OLD_SUPPORT_SITE_ID,
302 X_NEW_IES_AGENT_LOGIN,
303 X_OLD_IES_AGENT_LOGIN,
304 X_NEW_SERVER_GROUP_ID,
305 X_OLD_SERVER_GROUP_ID,
306 X_NEW_ASSIGNED_TO_GROUP_ID,
307 X_OLD_ASSIGNED_TO_GROUP_ID,
308 X_NEW_COST_CENTER,
309 X_OLD_COST_CENTER,
310 X_NEW_CHARGE_TO_COST_CENTER,
311 X_OLD_CHARGE_TO_COST_CENTER,
312 X_NEW_COMPENSATION_CURRENCY_CO,
313 X_OLD_COMPENSATION_CURRENCY_CO,
314 X_NEW_COMMISSIONABLE_FLAG,
315 X_OLD_COMMISSIONABLE_FLAG,
316 X_NEW_HOLD_REASON_CODE,
317 X_OLD_HOLD_REASON_CODE,
318 X_NEW_HOLD_PAYMENT,
319 X_OLD_HOLD_PAYMENT,
320 X_NEW_COMP_SERVICE_TEAM_ID,
321 X_OLD_COMP_SERVICE_TEAM_ID,
322 X_NEW_TRANSACTION_NUMBER,
323 X_OLD_TRANSACTION_NUMBER,
324 X_NEW_OBJECT_VERSION_NUMBER,
325 X_OLD_OBJECT_VERSION_NUMBER,
326 X_NEW_USER_ID,
327 X_OLD_USER_ID,
328 -- X_OLD_LOCATION,
329 -- X_NEW_LOCATION,
330 X_CREATED_BY,
331 X_CREATION_DATE,
332 X_LAST_UPDATED_BY,
333 X_LAST_UPDATE_DATE,
334 X_LAST_UPDATE_LOGIN,
335 X_NEW_RESOURCE_NAME ,
336 X_OLD_RESOURCE_NAME ,
337 X_NEW_SOURCE_NAME ,
338 X_OLD_SOURCE_NAME ,
339 X_NEW_SOURCE_NUMBER ,
340 X_OLD_SOURCE_NUMBER ,
341 X_NEW_SOURCE_JOB_TITLE ,
342 X_OLD_SOURCE_JOB_TITLE ,
343 X_NEW_SOURCE_EMAIL ,
344 X_OLD_SOURCE_EMAIL ,
345 X_NEW_SOURCE_PHONE ,
346 X_OLD_SOURCE_PHONE ,
347 X_NEW_SOURCE_ORG_ID ,
348 X_OLD_SOURCE_ORG_ID ,
349 X_NEW_SOURCE_ORG_NAME ,
350 X_OLD_SOURCE_ORG_NAME ,
351 X_NEW_SOURCE_ADDRESS1 ,
352 X_OLD_SOURCE_ADDRESS1 ,
353 X_NEW_SOURCE_ADDRESS2 ,
354 X_OLD_SOURCE_ADDRESS2 ,
355 X_NEW_SOURCE_ADDRESS3 ,
356 X_OLD_SOURCE_ADDRESS3 ,
357 X_NEW_SOURCE_ADDRESS4 ,
358 X_OLD_SOURCE_ADDRESS4 ,
359 X_NEW_SOURCE_CITY ,
360 X_OLD_SOURCE_CITY ,
361 X_NEW_SOURCE_POSTAL_CODE ,
362 X_OLD_SOURCE_POSTAL_CODE ,
363 X_NEW_SOURCE_STATE ,
364 X_OLD_SOURCE_STATE ,
365 X_NEW_SOURCE_PROVINCE ,
366 X_OLD_SOURCE_PROVINCE ,
367 X_NEW_SOURCE_COUNTY ,
368 X_OLD_SOURCE_COUNTY ,
369 X_NEW_SOURCE_COUNTRY ,
370 X_OLD_SOURCE_COUNTRY ,
371 X_NEW_SOURCE_MGR_ID,
372 X_OLD_SOURCE_MGR_ID,
373 X_NEW_SOURCE_MGR_NAME,
374 X_OLD_SOURCE_MGR_NAME,
375 X_NEW_SOURCE_BUSINESS_GRP_ID,
376 X_OLD_SOURCE_BUSINESS_GRP_ID,
377 X_NEW_SOURCE_BUSINESS_GRP_NAME,
378 X_OLD_SOURCE_BUSINESS_GRP_NAME,
379 X_NEW_SOURCE_FIRST_NAME ,
380 X_OLD_SOURCE_FIRST_NAME,
381 X_NEW_SOURCE_LAST_NAME ,
382 X_OLD_SOURCE_LAST_NAME,
383 X_NEW_SOURCE_MIDDLE_NAME,
384 X_OLD_SOURCE_MIDDLE_NAME ,
385 X_NEW_SOURCE_CATEGORY ,
386 X_OLD_SOURCE_CATEGORY ,
387 X_NEW_SOURCE_STATUS ,
388 X_OLD_SOURCE_STATUS ,
389 X_NEW_SOURCE_OFFICE,
393 X_NEW_SOURCE_MAILSTOP,
390 X_OLD_SOURCE_OFFICE,
391 X_NEW_SOURCE_LOCATION,
392 X_OLD_SOURCE_LOCATION,
394 X_OLD_SOURCE_MAILSTOP,
395 X_NEW_USER_NAME,
396 X_OLD_USER_NAME,
397 X_NEW_SOURCE_JOB_ID,
398 X_OLD_SOURCE_JOB_ID,
399 X_NEW_PARTY_ID,
400 X_OLD_PARTY_ID,
401 X_NEW_SOURCE_MOBILE_PHONE,
402 X_OLD_SOURCE_MOBILE_PHONE,
403 X_NEW_SOURCE_PAGER,
404 X_OLD_SOURCE_PAGER
405 );
406
407 open c;
408 fetch c into X_ROWID;
409 if (c%notfound) then
410 close c;
411 raise no_data_found;
412 end if;
413 close c;
414
415 end INSERT_ROW;
416
417 procedure LOCK_ROW (
418 X_RESOURCE_AUDIT_ID in NUMBER,
419 X_RESOURCE_ID in NUMBER,
420 X_NEW_CATEGORY in VARCHAR2,
421 X_OLD_CATEGORY in VARCHAR2,
422 X_NEW_RESOURCE_NUMBER in VARCHAR2,
423 X_OLD_RESOURCE_NUMBER in VARCHAR2,
424 X_NEW_SOURCE_ID in NUMBER,
425 X_OLD_SOURCE_ID in NUMBER,
426 X_NEW_ADDRESS_ID in NUMBER,
427 X_OLD_ADDRESS_ID in NUMBER,
428 X_NEW_CONTACT_ID in NUMBER,
429 X_OLD_CONTACT_ID in NUMBER,
430 X_NEW_MANAGING_EMPLOYEE_ID in NUMBER,
431 X_OLD_MANAGING_EMPLOYEE_ID in NUMBER,
432 X_OLD_START_DATE_ACTIVE in DATE,
433 X_NEW_START_DATE_ACTIVE in DATE,
434 X_OLD_END_DATE_ACTIVE in DATE,
435 X_NEW_END_DATE_ACTIVE in DATE,
436 X_NEW_TIME_ZONE in NUMBER,
437 X_OLD_TIME_ZONE in NUMBER,
438 X_NEW_COST_PER_HR in NUMBER,
439 X_OLD_COST_PER_HR in NUMBER,
440 X_NEW_PRIMARY_LANGUAGE in VARCHAR2,
441 X_OLD_PRIMARY_LANGUAGE in VARCHAR2,
442 X_NEW_SECONDARY_LANGUAGE in VARCHAR2,
443 X_OLD_SECONDARY_LANGUAGE in VARCHAR2,
444 X_NEW_SUPPORT_SITE_ID in NUMBER,
445 X_OLD_SUPPORT_SITE_ID in NUMBER,
446 X_NEW_IES_AGENT_LOGIN in VARCHAR2,
447 X_OLD_IES_AGENT_LOGIN in VARCHAR2,
448 X_NEW_SERVER_GROUP_ID in NUMBER,
449 X_OLD_SERVER_GROUP_ID in NUMBER,
450 X_NEW_ASSIGNED_TO_GROUP_ID in NUMBER,
451 X_OLD_ASSIGNED_TO_GROUP_ID in NUMBER,
452 X_NEW_COST_CENTER in VARCHAR2,
453 X_OLD_COST_CENTER in VARCHAR2,
454 X_NEW_CHARGE_TO_COST_CENTER in VARCHAR2,
455 X_OLD_CHARGE_TO_COST_CENTER in VARCHAR2,
456 X_NEW_COMPENSATION_CURRENCY_CO in VARCHAR2,
457 X_OLD_COMPENSATION_CURRENCY_CO in VARCHAR2,
458 X_NEW_COMMISSIONABLE_FLAG in VARCHAR2,
459 X_OLD_COMMISSIONABLE_FLAG in VARCHAR2,
460 X_NEW_HOLD_REASON_CODE in VARCHAR2,
461 X_OLD_HOLD_REASON_CODE in VARCHAR2,
462 X_NEW_HOLD_PAYMENT in VARCHAR2,
463 X_OLD_HOLD_PAYMENT in VARCHAR2,
464 X_NEW_COMP_SERVICE_TEAM_ID in NUMBER,
465 X_OLD_COMP_SERVICE_TEAM_ID in NUMBER,
466 X_NEW_TRANSACTION_NUMBER in NUMBER,
467 X_OLD_TRANSACTION_NUMBER in NUMBER,
468 X_NEW_OBJECT_VERSION_NUMBER in NUMBER,
469 X_OLD_OBJECT_VERSION_NUMBER in NUMBER,
470 X_NEW_USER_ID in NUMBER,
471 X_OLD_USER_ID in NUMBER,
472 -- X_OLD_LOCATION in MDSYS.SDO_GEOMETRY,
473 -- X_NEW_LOCATION in MDSYS.SDO_GEOMETRY
474 X_NEW_RESOURCE_NAME in VARCHAR2,
475 X_OLD_RESOURCE_NAME in VARCHAR2,
476 X_NEW_SOURCE_NAME in VARCHAR2,
477 X_OLD_SOURCE_NAME in VARCHAR2,
478 X_NEW_SOURCE_NUMBER in VARCHAR2,
479 X_OLD_SOURCE_NUMBER in VARCHAR2,
480 X_NEW_SOURCE_JOB_TITLE in VARCHAR2,
481 X_OLD_SOURCE_JOB_TITLE in VARCHAR2,
482 X_NEW_SOURCE_EMAIL in VARCHAR2,
483 X_OLD_SOURCE_EMAIL in VARCHAR2,
484 X_NEW_SOURCE_PHONE in VARCHAR2,
485 X_OLD_SOURCE_PHONE in VARCHAR2,
486 X_NEW_SOURCE_ORG_ID in NUMBER,
487 X_OLD_SOURCE_ORG_ID in NUMBER,
488 X_NEW_SOURCE_ORG_NAME in VARCHAR2,
489 X_OLD_SOURCE_ORG_NAME in VARCHAR2,
490 X_NEW_SOURCE_ADDRESS1 in VARCHAR2,
491 X_OLD_SOURCE_ADDRESS1 in VARCHAR2,
492 X_NEW_SOURCE_ADDRESS2 in VARCHAR2,
493 X_OLD_SOURCE_ADDRESS2 in VARCHAR2,
494 X_NEW_SOURCE_ADDRESS3 in VARCHAR2,
495 X_OLD_SOURCE_ADDRESS3 in VARCHAR2,
496 X_NEW_SOURCE_ADDRESS4 in VARCHAR2,
497 X_OLD_SOURCE_ADDRESS4 in VARCHAR2,
498 X_NEW_SOURCE_CITY in VARCHAR2,
499 X_OLD_SOURCE_CITY in VARCHAR2,
500 X_NEW_SOURCE_POSTAL_CODE in VARCHAR2,
501 X_OLD_SOURCE_POSTAL_CODE in VARCHAR2,
502 X_NEW_SOURCE_STATE in VARCHAR2,
503 X_OLD_SOURCE_STATE in VARCHAR2,
504 X_NEW_SOURCE_PROVINCE in VARCHAR2,
505 X_OLD_SOURCE_PROVINCE in VARCHAR2,
506 X_NEW_SOURCE_COUNTY in VARCHAR2,
507 X_OLD_SOURCE_COUNTY in VARCHAR2,
508 X_NEW_SOURCE_COUNTRY in VARCHAR2,
509 X_OLD_SOURCE_COUNTRY in VARCHAR2,
510 X_NEW_SOURCE_MGR_ID in NUMBER,
511 X_OLD_SOURCE_MGR_ID in NUMBER,
512 X_NEW_SOURCE_MGR_NAME in VARCHAR2,
513 X_OLD_SOURCE_MGR_NAME in VARCHAR2,
514 X_NEW_SOURCE_BUSINESS_GRP_ID in NUMBER,
515 X_OLD_SOURCE_BUSINESS_GRP_ID in NUMBER,
516 X_NEW_SOURCE_BUSINESS_GRP_NAME in VARCHAR2,
517 X_OLD_SOURCE_BUSINESS_GRP_NAME in VARCHAR2,
518 X_NEW_SOURCE_FIRST_NAME in VARCHAR2,
519 X_OLD_SOURCE_FIRST_NAME in VARCHAR2,
520 X_NEW_SOURCE_MIDDLE_NAME in VARCHAR2,
521 X_OLD_SOURCE_MIDDLE_NAME in VARCHAR2,
522 X_NEW_SOURCE_LAST_NAME in VARCHAR2,
523 X_OLD_SOURCE_LAST_NAME in VARCHAR2,
524 X_NEW_SOURCE_CATEGORY in VARCHAR2,
525 X_OLD_SOURCE_CATEGORY in VARCHAR2,
526 X_NEW_SOURCE_STATUS in VARCHAR2,
527 X_OLD_SOURCE_STATUS in VARCHAR2,
528 X_NEW_SOURCE_OFFICE in VARCHAR2,
529 X_OLD_SOURCE_OFFICE in VARCHAR2,
533 X_OLD_SOURCE_MAILSTOP in VARCHAR2,
530 X_NEW_SOURCE_LOCATION in VARCHAR2,
531 X_OLD_SOURCE_LOCATION in VARCHAR2,
532 X_NEW_SOURCE_MAILSTOP in VARCHAR2,
534 X_NEW_USER_NAME in VARCHAR2,
535 X_OLD_USER_NAME in VARCHAR2,
536 X_NEW_SOURCE_JOB_ID in VARCHAR2,
537 X_OLD_SOURCE_JOB_ID in VARCHAR2,
538 X_NEW_PARTY_ID in VARCHAR2,
539 X_OLD_PARTY_ID in VARCHAR2,
540 X_NEW_SOURCE_MOBILE_PHONE in VARCHAR2,
541 X_OLD_SOURCE_MOBILE_PHONE in VARCHAR2,
542 X_NEW_SOURCE_PAGER in VARCHAR2,
543 X_OLD_SOURCE_PAGER in VARCHAR2
544 ) is
545 cursor c1 is select
546 RESOURCE_ID,
547 NEW_CATEGORY,
548 OLD_CATEGORY,
549 NEW_RESOURCE_NUMBER,
550 OLD_RESOURCE_NUMBER,
551 NEW_SOURCE_ID,
552 OLD_SOURCE_ID,
553 NEW_ADDRESS_ID,
554 OLD_ADDRESS_ID,
555 NEW_CONTACT_ID,
556 OLD_CONTACT_ID,
557 NEW_MANAGING_EMPLOYEE_ID,
558 OLD_MANAGING_EMPLOYEE_ID,
559 OLD_START_DATE_ACTIVE,
560 NEW_START_DATE_ACTIVE,
561 OLD_END_DATE_ACTIVE,
562 NEW_END_DATE_ACTIVE,
563 NEW_TIME_ZONE,
564 OLD_TIME_ZONE,
565 NEW_COST_PER_HR,
566 OLD_COST_PER_HR,
567 NEW_PRIMARY_LANGUAGE,
568 OLD_PRIMARY_LANGUAGE,
569 NEW_SECONDARY_LANGUAGE,
570 OLD_SECONDARY_LANGUAGE,
571 NEW_SUPPORT_SITE_ID,
572 OLD_SUPPORT_SITE_ID,
573 NEW_IES_AGENT_LOGIN,
574 OLD_IES_AGENT_LOGIN,
575 NEW_SERVER_GROUP_ID,
576 OLD_SERVER_GROUP_ID,
577 NEW_ASSIGNED_TO_GROUP_ID,
578 OLD_ASSIGNED_TO_GROUP_ID,
579 NEW_COST_CENTER,
580 OLD_COST_CENTER,
581 NEW_CHARGE_TO_COST_CENTER,
582 OLD_CHARGE_TO_COST_CENTER,
583 NEW_COMPENSATION_CURRENCY_CODE,
584 OLD_COMPENSATION_CURRENCY_CODE,
585 NEW_COMMISSIONABLE_FLAG,
586 OLD_COMMISSIONABLE_FLAG,
587 NEW_HOLD_REASON_CODE,
588 OLD_HOLD_REASON_CODE,
589 NEW_HOLD_PAYMENT,
590 OLD_HOLD_PAYMENT,
591 NEW_COMP_SERVICE_TEAM_ID,
592 OLD_COMP_SERVICE_TEAM_ID,
593 NEW_TRANSACTION_NUMBER,
594 OLD_TRANSACTION_NUMBER,
595 NEW_OBJECT_VERSION_NUMBER,
596 OLD_OBJECT_VERSION_NUMBER,
597 NEW_USER_ID,
598 OLD_USER_ID
599 --OLD_LOCATION,
600 --NEW_LOCATION
601 from JTF_RS_RESOURCE_EXTN_AUD
602 where RESOURCE_AUDIT_ID = X_RESOURCE_AUDIT_ID
603 for update of RESOURCE_AUDIT_ID nowait;
604 tlinfo c1%rowtype;
605 begin
606 open c1;
607 fetch c1 into tlinfo;
608 if (c1%notfound) then
609 fnd_message.set_name('FND','FORM_RECORD_DELETED');
610 app_exception.raise_exception;
611 close c1;
612 end if;
613 close c1;
614
615 if ( (tlinfo.RESOURCE_ID = X_RESOURCE_ID)
616 AND ((tlinfo.NEW_CATEGORY = X_NEW_CATEGORY)
617 OR ((tlinfo.NEW_CATEGORY is null) AND (X_NEW_CATEGORY is null)))
618 AND ((tlinfo.OLD_CATEGORY = X_OLD_CATEGORY)
619 OR ((tlinfo.OLD_CATEGORY is null) AND (X_OLD_CATEGORY is null)))
620 AND ((tlinfo.NEW_RESOURCE_NUMBER = X_NEW_RESOURCE_NUMBER)
621 OR ((tlinfo.NEW_RESOURCE_NUMBER is null) AND (X_NEW_RESOURCE_NUMBER is null)))
622 AND ((tlinfo.OLD_RESOURCE_NUMBER = X_OLD_RESOURCE_NUMBER)
623 OR ((tlinfo.OLD_RESOURCE_NUMBER is null) AND (X_OLD_RESOURCE_NUMBER is null)))
624 AND ((tlinfo.NEW_SOURCE_ID = X_NEW_SOURCE_ID)
625 OR ((tlinfo.NEW_SOURCE_ID is null) AND (X_NEW_SOURCE_ID is null)))
626 AND ((tlinfo.OLD_SOURCE_ID = X_OLD_SOURCE_ID)
627 OR ((tlinfo.OLD_SOURCE_ID is null) AND (X_OLD_SOURCE_ID is null)))
628 AND ((tlinfo.NEW_ADDRESS_ID = X_NEW_ADDRESS_ID)
629 OR ((tlinfo.NEW_ADDRESS_ID is null) AND (X_NEW_ADDRESS_ID is null)))
630 AND ((tlinfo.OLD_ADDRESS_ID = X_OLD_ADDRESS_ID)
631 OR ((tlinfo.OLD_ADDRESS_ID is null) AND (X_OLD_ADDRESS_ID is null)))
632 AND ((tlinfo.NEW_CONTACT_ID = X_NEW_CONTACT_ID)
633 OR ((tlinfo.NEW_CONTACT_ID is null) AND (X_NEW_CONTACT_ID is null)))
634 AND ((tlinfo.OLD_CONTACT_ID = X_OLD_CONTACT_ID)
635 OR ((tlinfo.OLD_CONTACT_ID is null) AND (X_OLD_CONTACT_ID is null)))
636 AND ((tlinfo.NEW_MANAGING_EMPLOYEE_ID = X_NEW_MANAGING_EMPLOYEE_ID)
637 OR ((tlinfo.NEW_MANAGING_EMPLOYEE_ID is null) AND (X_NEW_MANAGING_EMPLOYEE_ID is null)))
638 AND ((tlinfo.OLD_MANAGING_EMPLOYEE_ID = X_OLD_MANAGING_EMPLOYEE_ID)
639 OR ((tlinfo.OLD_MANAGING_EMPLOYEE_ID is null) AND (X_OLD_MANAGING_EMPLOYEE_ID is null)))
640 AND ((tlinfo.OLD_START_DATE_ACTIVE = X_OLD_START_DATE_ACTIVE)
641 OR ((tlinfo.OLD_START_DATE_ACTIVE is null) AND (X_OLD_START_DATE_ACTIVE is null)))
642 AND ((tlinfo.NEW_START_DATE_ACTIVE = X_NEW_START_DATE_ACTIVE)
643 OR ((tlinfo.NEW_START_DATE_ACTIVE is null) AND (X_NEW_START_DATE_ACTIVE is null)))
644 AND ((tlinfo.OLD_END_DATE_ACTIVE = X_OLD_END_DATE_ACTIVE)
645 OR ((tlinfo.OLD_END_DATE_ACTIVE is null) AND (X_OLD_END_DATE_ACTIVE is null)))
646 AND ((tlinfo.NEW_END_DATE_ACTIVE = X_NEW_END_DATE_ACTIVE)
647 OR ((tlinfo.NEW_END_DATE_ACTIVE is null) AND (X_NEW_END_DATE_ACTIVE is null)))
648 AND ((tlinfo.NEW_TIME_ZONE = X_NEW_TIME_ZONE)
652 AND ((tlinfo.NEW_COST_PER_HR = X_NEW_COST_PER_HR)
649 OR ((tlinfo.NEW_TIME_ZONE is null) AND (X_NEW_TIME_ZONE is null)))
650 AND ((tlinfo.OLD_TIME_ZONE = X_OLD_TIME_ZONE)
651 OR ((tlinfo.OLD_TIME_ZONE is null) AND (X_OLD_TIME_ZONE is null)))
653 OR ((tlinfo.NEW_COST_PER_HR is null) AND (X_NEW_COST_PER_HR is null)))
654 AND ((tlinfo.OLD_COST_PER_HR = X_OLD_COST_PER_HR)
655 OR ((tlinfo.OLD_COST_PER_HR is null) AND (X_OLD_COST_PER_HR is null)))
656 AND ((tlinfo.NEW_PRIMARY_LANGUAGE = X_NEW_PRIMARY_LANGUAGE)
657 OR ((tlinfo.NEW_PRIMARY_LANGUAGE is null) AND (X_NEW_PRIMARY_LANGUAGE is null)))
658 AND ((tlinfo.OLD_PRIMARY_LANGUAGE = X_OLD_PRIMARY_LANGUAGE)
659 OR ((tlinfo.OLD_PRIMARY_LANGUAGE is null) AND (X_OLD_PRIMARY_LANGUAGE is null)))
660 AND ((tlinfo.NEW_SECONDARY_LANGUAGE = X_NEW_SECONDARY_LANGUAGE)
661 OR ((tlinfo.NEW_SECONDARY_LANGUAGE is null) AND (X_NEW_SECONDARY_LANGUAGE is null)))
662 AND ((tlinfo.OLD_SECONDARY_LANGUAGE = X_OLD_SECONDARY_LANGUAGE)
663 OR ((tlinfo.OLD_SECONDARY_LANGUAGE is null) AND (X_OLD_SECONDARY_LANGUAGE is null)))
664 AND ((tlinfo.NEW_SUPPORT_SITE_ID = X_NEW_SUPPORT_SITE_ID)
665 OR ((tlinfo.NEW_SUPPORT_SITE_ID is null) AND (X_NEW_SUPPORT_SITE_ID is null)))
666 AND ((tlinfo.OLD_SUPPORT_SITE_ID = X_OLD_SUPPORT_SITE_ID)
667 OR ((tlinfo.OLD_SUPPORT_SITE_ID is null) AND (X_OLD_SUPPORT_SITE_ID is null)))
668 AND ((tlinfo.NEW_IES_AGENT_LOGIN = X_NEW_IES_AGENT_LOGIN)
669 OR ((tlinfo.NEW_IES_AGENT_LOGIN is null) AND (X_NEW_IES_AGENT_LOGIN is null)))
670 AND ((tlinfo.OLD_IES_AGENT_LOGIN = X_OLD_IES_AGENT_LOGIN)
671 OR ((tlinfo.OLD_IES_AGENT_LOGIN is null) AND (X_OLD_IES_AGENT_LOGIN is null)))
672 AND ((tlinfo.NEW_SERVER_GROUP_ID = X_NEW_SERVER_GROUP_ID)
673 OR ((tlinfo.NEW_SERVER_GROUP_ID is null) AND (X_NEW_SERVER_GROUP_ID is null)))
674 AND ((tlinfo.OLD_SERVER_GROUP_ID = X_OLD_SERVER_GROUP_ID)
675 OR ((tlinfo.OLD_SERVER_GROUP_ID is null) AND (X_OLD_SERVER_GROUP_ID is null)))
676 AND ((tlinfo.NEW_ASSIGNED_TO_GROUP_ID = X_NEW_ASSIGNED_TO_GROUP_ID)
677 OR ((tlinfo.NEW_ASSIGNED_TO_GROUP_ID is null) AND (X_NEW_ASSIGNED_TO_GROUP_ID is null)))
678 AND ((tlinfo.OLD_ASSIGNED_TO_GROUP_ID = X_OLD_ASSIGNED_TO_GROUP_ID)
679 OR ((tlinfo.OLD_ASSIGNED_TO_GROUP_ID is null) AND (X_OLD_ASSIGNED_TO_GROUP_ID is null)))
680 AND ((tlinfo.NEW_COST_CENTER = X_NEW_COST_CENTER)
681 OR ((tlinfo.NEW_COST_CENTER is null) AND (X_NEW_COST_CENTER is null)))
682 AND ((tlinfo.OLD_COST_CENTER = X_OLD_COST_CENTER)
683 OR ((tlinfo.OLD_COST_CENTER is null) AND (X_OLD_COST_CENTER is null)))
684 AND ((tlinfo.NEW_CHARGE_TO_COST_CENTER = X_NEW_CHARGE_TO_COST_CENTER)
685 OR ((tlinfo.NEW_CHARGE_TO_COST_CENTER is null) AND (X_NEW_CHARGE_TO_COST_CENTER is null)))
686 AND ((tlinfo.OLD_CHARGE_TO_COST_CENTER = X_OLD_CHARGE_TO_COST_CENTER)
687 OR ((tlinfo.OLD_CHARGE_TO_COST_CENTER is null) AND (X_OLD_CHARGE_TO_COST_CENTER is null)))
688 AND ((tlinfo.NEW_COMPENSATION_CURRENCY_CODE = X_NEW_COMPENSATION_CURRENCY_CO)
689 OR ((tlinfo.NEW_COMPENSATION_CURRENCY_CODE is null) AND (X_NEW_COMPENSATION_CURRENCY_CO is null)))
690 AND ((tlinfo.OLD_COMPENSATION_CURRENCY_CODE = X_OLD_COMPENSATION_CURRENCY_CO)
691 OR ((tlinfo.OLD_COMPENSATION_CURRENCY_CODE is null) AND (X_OLD_COMPENSATION_CURRENCY_CO is null)))
692 AND ((tlinfo.NEW_COMMISSIONABLE_FLAG = X_NEW_COMMISSIONABLE_FLAG)
693 OR ((tlinfo.NEW_COMMISSIONABLE_FLAG is null) AND (X_NEW_COMMISSIONABLE_FLAG is null)))
694 AND ((tlinfo.OLD_COMMISSIONABLE_FLAG = X_OLD_COMMISSIONABLE_FLAG)
695 OR ((tlinfo.OLD_COMMISSIONABLE_FLAG is null) AND (X_OLD_COMMISSIONABLE_FLAG is null)))
696 AND ((tlinfo.NEW_HOLD_REASON_CODE = X_NEW_HOLD_REASON_CODE)
697 OR ((tlinfo.NEW_HOLD_REASON_CODE is null) AND (X_NEW_HOLD_REASON_CODE is null)))
698 AND ((tlinfo.OLD_HOLD_REASON_CODE = X_OLD_HOLD_REASON_CODE)
699 OR ((tlinfo.OLD_HOLD_REASON_CODE is null) AND (X_OLD_HOLD_REASON_CODE is null)))
700 AND ((tlinfo.NEW_HOLD_PAYMENT = X_NEW_HOLD_PAYMENT)
701 OR ((tlinfo.NEW_HOLD_PAYMENT is null) AND (X_NEW_HOLD_PAYMENT is null)))
702 AND ((tlinfo.OLD_HOLD_PAYMENT = X_OLD_HOLD_PAYMENT)
703 OR ((tlinfo.OLD_HOLD_PAYMENT is null) AND (X_OLD_HOLD_PAYMENT is null)))
704 AND ((tlinfo.NEW_COMP_SERVICE_TEAM_ID = X_NEW_COMP_SERVICE_TEAM_ID)
705 OR ((tlinfo.NEW_COMP_SERVICE_TEAM_ID is null) AND (X_NEW_COMP_SERVICE_TEAM_ID is null)))
706 AND ((tlinfo.OLD_COMP_SERVICE_TEAM_ID = X_OLD_COMP_SERVICE_TEAM_ID)
707 OR ((tlinfo.OLD_COMP_SERVICE_TEAM_ID is null) AND (X_OLD_COMP_SERVICE_TEAM_ID is null)))
708 AND ((tlinfo.NEW_TRANSACTION_NUMBER = X_NEW_TRANSACTION_NUMBER)
709 OR ((tlinfo.NEW_TRANSACTION_NUMBER is null) AND (X_NEW_TRANSACTION_NUMBER is null)))
710 AND ((tlinfo.OLD_TRANSACTION_NUMBER = X_OLD_TRANSACTION_NUMBER)
711 OR ((tlinfo.OLD_TRANSACTION_NUMBER is null) AND (X_OLD_TRANSACTION_NUMBER is null)))
712 AND ((tlinfo.NEW_OBJECT_VERSION_NUMBER = X_NEW_OBJECT_VERSION_NUMBER)
713 OR ((tlinfo.NEW_OBJECT_VERSION_NUMBER is null) AND (X_NEW_OBJECT_VERSION_NUMBER is null)))
714 AND ((tlinfo.OLD_OBJECT_VERSION_NUMBER = X_OLD_OBJECT_VERSION_NUMBER)
715 OR ((tlinfo.OLD_OBJECT_VERSION_NUMBER is null) AND (X_OLD_OBJECT_VERSION_NUMBER is null)))
719 OR ((tlinfo.OLD_USER_ID is null) AND (X_OLD_USER_ID is null)))
716 AND ((tlinfo.NEW_USER_ID = X_NEW_USER_ID)
717 OR ((tlinfo.NEW_USER_ID is null) AND (X_NEW_USER_ID is null)))
718 AND ((tlinfo.OLD_USER_ID = X_OLD_USER_ID)
720 /* AND ((tlinfo.NEW_LOCATION = X_NEW_LOCATION)
721 OR ((tlinfo.NEW_LOCATION is null) AND (X_NEW_LOCATION is null)))
722 AND ((tlinfo.OLD_LOCATION = X_OLD_LOCATION)
723 OR ((tlinfo.OLD_LOCATION is null) AND (X_OLD_LOCATION is null))) */
724 ) then
725 null;
726 else
727 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
728 app_exception.raise_exception;
729 end if;
730 return;
731 end LOCK_ROW;
732
733 procedure UPDATE_ROW (
734 X_RESOURCE_AUDIT_ID in NUMBER,
735 X_RESOURCE_ID in NUMBER,
736 X_NEW_CATEGORY in VARCHAR2,
737 X_OLD_CATEGORY in VARCHAR2,
738 X_NEW_RESOURCE_NUMBER in VARCHAR2,
739 X_OLD_RESOURCE_NUMBER in VARCHAR2,
740 X_NEW_SOURCE_ID in NUMBER,
741 X_OLD_SOURCE_ID in NUMBER,
742 X_NEW_ADDRESS_ID in NUMBER,
743 X_OLD_ADDRESS_ID in NUMBER,
744 X_NEW_CONTACT_ID in NUMBER,
745 X_OLD_CONTACT_ID in NUMBER,
746 X_NEW_MANAGING_EMPLOYEE_ID in NUMBER,
747 X_OLD_MANAGING_EMPLOYEE_ID in NUMBER,
748 X_OLD_START_DATE_ACTIVE in DATE,
749 X_NEW_START_DATE_ACTIVE in DATE,
750 X_OLD_END_DATE_ACTIVE in DATE,
751 X_NEW_END_DATE_ACTIVE in DATE,
752 X_NEW_TIME_ZONE in NUMBER,
753 X_OLD_TIME_ZONE in NUMBER,
754 X_NEW_COST_PER_HR in NUMBER,
755 X_OLD_COST_PER_HR in NUMBER,
756 X_NEW_PRIMARY_LANGUAGE in VARCHAR2,
757 X_OLD_PRIMARY_LANGUAGE in VARCHAR2,
758 X_NEW_SECONDARY_LANGUAGE in VARCHAR2,
759 X_OLD_SECONDARY_LANGUAGE in VARCHAR2,
760 X_NEW_SUPPORT_SITE_ID in NUMBER,
761 X_OLD_SUPPORT_SITE_ID in NUMBER,
762 X_NEW_IES_AGENT_LOGIN in VARCHAR2,
763 X_OLD_IES_AGENT_LOGIN in VARCHAR2,
764 X_NEW_SERVER_GROUP_ID in NUMBER,
765 X_OLD_SERVER_GROUP_ID in NUMBER,
766 X_NEW_ASSIGNED_TO_GROUP_ID in NUMBER,
767 X_OLD_ASSIGNED_TO_GROUP_ID in NUMBER,
768 X_NEW_COST_CENTER in VARCHAR2,
769 X_OLD_COST_CENTER in VARCHAR2,
770 X_NEW_CHARGE_TO_COST_CENTER in VARCHAR2,
771 X_OLD_CHARGE_TO_COST_CENTER in VARCHAR2,
772 X_NEW_COMPENSATION_CURRENCY_CO in VARCHAR2,
773 X_OLD_COMPENSATION_CURRENCY_CO in VARCHAR2,
774 X_NEW_COMMISSIONABLE_FLAG in VARCHAR2,
775 X_OLD_COMMISSIONABLE_FLAG in VARCHAR2,
776 X_NEW_HOLD_REASON_CODE in VARCHAR2,
777 X_OLD_HOLD_REASON_CODE in VARCHAR2,
778 X_NEW_HOLD_PAYMENT in VARCHAR2,
779 X_OLD_HOLD_PAYMENT in VARCHAR2,
780 X_NEW_COMP_SERVICE_TEAM_ID in NUMBER,
781 X_OLD_COMP_SERVICE_TEAM_ID in NUMBER,
782 X_NEW_TRANSACTION_NUMBER in NUMBER,
783 X_OLD_TRANSACTION_NUMBER in NUMBER,
784 X_NEW_OBJECT_VERSION_NUMBER in NUMBER,
785 X_OLD_OBJECT_VERSION_NUMBER in NUMBER,
786 X_NEW_USER_ID in NUMBER,
787 X_OLD_USER_ID in NUMBER,
788 --X_OLD_LOCATION in MDSYS.SDO_GEOMETRY,
789 --X_NEW_LOCATION in MDSYS.SDO_GEOMETRY,
790 X_LAST_UPDATE_DATE in DATE,
791 X_LAST_UPDATED_BY in NUMBER,
792 X_LAST_UPDATE_LOGIN in NUMBER,
793 X_NEW_RESOURCE_NAME in VARCHAR2,
794 X_OLD_RESOURCE_NAME in VARCHAR2,
795 X_NEW_SOURCE_NAME in VARCHAR2,
796 X_OLD_SOURCE_NAME in VARCHAR2,
797 X_NEW_SOURCE_NUMBER in VARCHAR2,
798 X_OLD_SOURCE_NUMBER in VARCHAR2,
799 X_NEW_SOURCE_JOB_TITLE in VARCHAR2,
800 X_OLD_SOURCE_JOB_TITLE in VARCHAR2,
801 X_NEW_SOURCE_EMAIL in VARCHAR2,
802 X_OLD_SOURCE_EMAIL in VARCHAR2,
803 X_NEW_SOURCE_PHONE in VARCHAR2,
804 X_OLD_SOURCE_PHONE in VARCHAR2,
805 X_NEW_SOURCE_ORG_ID in NUMBER,
806 X_OLD_SOURCE_ORG_ID in NUMBER,
807 X_NEW_SOURCE_ORG_NAME in VARCHAR2,
808 X_OLD_SOURCE_ORG_NAME in VARCHAR2,
809 X_NEW_SOURCE_ADDRESS1 in VARCHAR2,
810 X_OLD_SOURCE_ADDRESS1 in VARCHAR2,
811 X_NEW_SOURCE_ADDRESS2 in VARCHAR2,
812 X_OLD_SOURCE_ADDRESS2 in VARCHAR2,
813 X_NEW_SOURCE_ADDRESS3 in VARCHAR2,
814 X_OLD_SOURCE_ADDRESS3 in VARCHAR2,
815 X_NEW_SOURCE_ADDRESS4 in VARCHAR2,
816 X_OLD_SOURCE_ADDRESS4 in VARCHAR2,
817 X_NEW_SOURCE_CITY in VARCHAR2,
818 X_OLD_SOURCE_CITY in VARCHAR2,
819 X_NEW_SOURCE_POSTAL_CODE in VARCHAR2,
820 X_OLD_SOURCE_POSTAL_CODE in VARCHAR2,
821 X_NEW_SOURCE_STATE in VARCHAR2,
822 X_OLD_SOURCE_STATE in VARCHAR2,
823 X_NEW_SOURCE_PROVINCE in VARCHAR2,
824 X_OLD_SOURCE_PROVINCE in VARCHAR2,
825 X_NEW_SOURCE_COUNTY in VARCHAR2,
826 X_OLD_SOURCE_COUNTY in VARCHAR2,
827 X_NEW_SOURCE_COUNTRY in VARCHAR2,
828 X_OLD_SOURCE_COUNTRY in VARCHAR2,
829 X_NEW_SOURCE_MGR_ID in NUMBER,
830 X_OLD_SOURCE_MGR_ID in NUMBER,
831 X_NEW_SOURCE_MGR_NAME in VARCHAR2,
832 X_OLD_SOURCE_MGR_NAME in VARCHAR2,
833 X_NEW_SOURCE_BUSINESS_GRP_ID in NUMBER,
834 X_OLD_SOURCE_BUSINESS_GRP_ID in NUMBER,
835 X_NEW_SOURCE_BUSINESS_GRP_NAME in VARCHAR2,
836 X_OLD_SOURCE_BUSINESS_GRP_NAME in VARCHAR2,
837 X_NEW_SOURCE_FIRST_NAME in VARCHAR2,
838 X_OLD_SOURCE_FIRST_NAME in VARCHAR2,
839 X_NEW_SOURCE_MIDDLE_NAME in VARCHAR2,
843 X_NEW_SOURCE_CATEGORY in VARCHAR2,
840 X_OLD_SOURCE_MIDDLE_NAME in VARCHAR2,
841 X_NEW_SOURCE_LAST_NAME in VARCHAR2,
842 X_OLD_SOURCE_LAST_NAME in VARCHAR2,
844 X_OLD_SOURCE_CATEGORY in VARCHAR2,
845 X_NEW_SOURCE_STATUS in VARCHAR2,
846 X_OLD_SOURCE_STATUS in VARCHAR2,
847 X_NEW_SOURCE_OFFICE in VARCHAR2,
848 X_OLD_SOURCE_OFFICE in VARCHAR2,
849 X_NEW_SOURCE_LOCATION in VARCHAR2,
850 X_OLD_SOURCE_LOCATION in VARCHAR2,
851 X_NEW_SOURCE_MAILSTOP in VARCHAR2,
852 X_OLD_SOURCE_MAILSTOP in VARCHAR2,
853 X_NEW_USER_NAME in VARCHAR2,
854 X_OLD_USER_NAME in VARCHAR2,
855 X_NEW_SOURCE_JOB_ID in VARCHAR2,
856 X_OLD_SOURCE_JOB_ID in VARCHAR2,
857 X_NEW_PARTY_ID in VARCHAR2,
858 X_OLD_PARTY_ID in VARCHAR2,
859 X_NEW_SOURCE_MOBILE_PHONE in VARCHAR2,
860 X_OLD_SOURCE_MOBILE_PHONE in VARCHAR2,
861 X_NEW_SOURCE_PAGER in VARCHAR2,
862 X_OLD_SOURCE_PAGER in VARCHAR2
863 ) is
864 begin
865 update JTF_RS_RESOURCE_EXTN_AUD set
866 RESOURCE_ID = X_RESOURCE_ID,
867 NEW_CATEGORY = X_NEW_CATEGORY,
868 OLD_CATEGORY = X_OLD_CATEGORY,
869 NEW_RESOURCE_NUMBER = X_NEW_RESOURCE_NUMBER,
870 OLD_RESOURCE_NUMBER = X_OLD_RESOURCE_NUMBER,
871 NEW_SOURCE_ID = X_NEW_SOURCE_ID,
872 OLD_SOURCE_ID = X_OLD_SOURCE_ID,
873 NEW_ADDRESS_ID = X_NEW_ADDRESS_ID,
874 OLD_ADDRESS_ID = X_OLD_ADDRESS_ID,
875 NEW_CONTACT_ID = X_NEW_CONTACT_ID,
876 OLD_CONTACT_ID = X_OLD_CONTACT_ID,
877 NEW_MANAGING_EMPLOYEE_ID = X_NEW_MANAGING_EMPLOYEE_ID,
878 OLD_MANAGING_EMPLOYEE_ID = X_OLD_MANAGING_EMPLOYEE_ID,
879 OLD_START_DATE_ACTIVE = X_OLD_START_DATE_ACTIVE,
880 NEW_START_DATE_ACTIVE = X_NEW_START_DATE_ACTIVE,
881 OLD_END_DATE_ACTIVE = X_OLD_END_DATE_ACTIVE,
882 NEW_END_DATE_ACTIVE = X_NEW_END_DATE_ACTIVE,
883 NEW_TIME_ZONE = X_NEW_TIME_ZONE,
884 OLD_TIME_ZONE = X_OLD_TIME_ZONE,
885 NEW_COST_PER_HR = X_NEW_COST_PER_HR,
886 OLD_COST_PER_HR = X_OLD_COST_PER_HR,
887 NEW_PRIMARY_LANGUAGE = X_NEW_PRIMARY_LANGUAGE,
888 OLD_PRIMARY_LANGUAGE = X_OLD_PRIMARY_LANGUAGE,
889 NEW_SECONDARY_LANGUAGE = X_NEW_SECONDARY_LANGUAGE,
890 OLD_SECONDARY_LANGUAGE = X_OLD_SECONDARY_LANGUAGE,
891 NEW_SUPPORT_SITE_ID = X_NEW_SUPPORT_SITE_ID,
892 OLD_SUPPORT_SITE_ID = X_OLD_SUPPORT_SITE_ID,
893 NEW_IES_AGENT_LOGIN = X_NEW_IES_AGENT_LOGIN,
894 OLD_IES_AGENT_LOGIN = X_OLD_IES_AGENT_LOGIN,
895 NEW_SERVER_GROUP_ID = X_NEW_SERVER_GROUP_ID,
896 OLD_SERVER_GROUP_ID = X_OLD_SERVER_GROUP_ID,
897 NEW_ASSIGNED_TO_GROUP_ID = X_NEW_ASSIGNED_TO_GROUP_ID,
898 OLD_ASSIGNED_TO_GROUP_ID = X_OLD_ASSIGNED_TO_GROUP_ID,
899 NEW_COST_CENTER = X_NEW_COST_CENTER,
900 OLD_COST_CENTER = X_OLD_COST_CENTER,
901 NEW_CHARGE_TO_COST_CENTER = X_NEW_CHARGE_TO_COST_CENTER,
902 OLD_CHARGE_TO_COST_CENTER = X_OLD_CHARGE_TO_COST_CENTER,
903 NEW_COMPENSATION_CURRENCY_CODE = X_NEW_COMPENSATION_CURRENCY_CO,
904 OLD_COMPENSATION_CURRENCY_CODE = X_OLD_COMPENSATION_CURRENCY_CO,
905 NEW_COMMISSIONABLE_FLAG = X_NEW_COMMISSIONABLE_FLAG,
906 OLD_COMMISSIONABLE_FLAG = X_OLD_COMMISSIONABLE_FLAG,
907 NEW_HOLD_REASON_CODE = X_NEW_HOLD_REASON_CODE,
908 OLD_HOLD_REASON_CODE = X_OLD_HOLD_REASON_CODE,
909 NEW_HOLD_PAYMENT = X_NEW_HOLD_PAYMENT,
910 OLD_HOLD_PAYMENT = X_OLD_HOLD_PAYMENT,
911 NEW_COMP_SERVICE_TEAM_ID = X_NEW_COMP_SERVICE_TEAM_ID,
912 OLD_COMP_SERVICE_TEAM_ID = X_OLD_COMP_SERVICE_TEAM_ID,
913 NEW_TRANSACTION_NUMBER = X_NEW_TRANSACTION_NUMBER,
914 OLD_TRANSACTION_NUMBER = X_OLD_TRANSACTION_NUMBER,
915 NEW_OBJECT_VERSION_NUMBER = X_NEW_OBJECT_VERSION_NUMBER,
916 OLD_OBJECT_VERSION_NUMBER = X_OLD_OBJECT_VERSION_NUMBER,
917 NEW_USER_ID = X_NEW_USER_ID,
918 OLD_USER_ID = X_OLD_USER_ID,
919 --OLD_LOCATION = X_OLD_LOCATION,
920 -- NEW_LOCATION = X_NEW_LOCATION,
921 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
922 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
923 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
924 NEW_RESOURCE_NAME = X_NEW_RESOURCE_NAME ,
925 OLD_RESOURCE_NAME = X_OLD_RESOURCE_NAME ,
926 NEW_SOURCE_NAME = X_NEW_SOURCE_NAME ,
927 OLD_SOURCE_NAME = X_OLD_SOURCE_NAME ,
928 NEW_SOURCE_NUMBER = X_NEW_SOURCE_NUMBER ,
929 OLD_SOURCE_NUMBER = X_OLD_SOURCE_NUMBER ,
930 NEW_SOURCE_JOB_TITLE = X_NEW_SOURCE_JOB_TITLE ,
931 OLD_SOURCE_JOB_TITLE = X_OLD_SOURCE_JOB_TITLE ,
932 NEW_SOURCE_EMAIL = X_NEW_SOURCE_EMAIL ,
933 OLD_SOURCE_EMAIL = X_OLD_SOURCE_EMAIL ,
934 NEW_SOURCE_PHONE = X_NEW_SOURCE_PHONE ,
935 OLD_SOURCE_PHONE = X_OLD_SOURCE_PHONE ,
936 NEW_SOURCE_ORG_ID = X_NEW_SOURCE_ORG_ID ,
937 OLD_SOURCE_ORG_ID = X_OLD_SOURCE_ORG_ID ,
938 NEW_SOURCE_ORG_NAME = X_NEW_SOURCE_ORG_NAME ,
939 OLD_SOURCE_ORG_NAME = X_OLD_SOURCE_ORG_NAME ,
940 NEW_SOURCE_ADDRESS1 = X_NEW_SOURCE_ADDRESS1 ,
941 OLD_SOURCE_ADDRESS1 = X_OLD_SOURCE_ADDRESS1 ,
942 NEW_SOURCE_ADDRESS2 = X_NEW_SOURCE_ADDRESS2 ,
943 OLD_SOURCE_ADDRESS2 = X_OLD_SOURCE_ADDRESS2 ,
944 NEW_SOURCE_ADDRESS3 = X_NEW_SOURCE_ADDRESS3 ,
945 OLD_SOURCE_ADDRESS3 = X_OLD_SOURCE_ADDRESS3 ,
946 NEW_SOURCE_ADDRESS4 = X_NEW_SOURCE_ADDRESS4 ,
947 OLD_SOURCE_ADDRESS4 = X_OLD_SOURCE_ADDRESS4 ,
948 NEW_SOURCE_CITY = X_NEW_SOURCE_CITY ,
949 OLD_SOURCE_CITY = X_OLD_SOURCE_CITY ,
950 NEW_SOURCE_POSTAL_CODE = X_NEW_SOURCE_POSTAL_CODE ,
951 OLD_SOURCE_POSTAL_CODE = X_OLD_SOURCE_POSTAL_CODE ,
952 NEW_SOURCE_STATE = X_NEW_SOURCE_STATE ,
953 OLD_SOURCE_STATE = X_OLD_SOURCE_STATE ,
954 NEW_SOURCE_PROVINCE = X_NEW_SOURCE_PROVINCE ,
955 OLD_SOURCE_PROVINCE = X_OLD_SOURCE_PROVINCE ,
956 NEW_SOURCE_COUNTY = X_NEW_SOURCE_COUNTY ,
957 OLD_SOURCE_COUNTY = X_OLD_SOURCE_COUNTY ,
958 NEW_SOURCE_COUNTRY = X_NEW_SOURCE_COUNTRY ,
959 OLD_SOURCE_COUNTRY = X_OLD_SOURCE_COUNTRY ,
960 NEW_SOURCE_MGR_ID = X_NEW_SOURCE_MGR_ID,
961 OLD_SOURCE_MGR_ID = X_OLD_SOURCE_MGR_ID,
962 NEW_SOURCE_MGR_NAME = X_NEW_SOURCE_MGR_NAME,
963 OLD_SOURCE_MGR_NAME = X_OLD_SOURCE_MGR_NAME,
964 NEW_SOURCE_BUSINESS_GRP_ID = X_NEW_SOURCE_BUSINESS_GRP_ID,
965 OLD_SOURCE_BUSINESS_GRP_ID = X_OLD_SOURCE_BUSINESS_GRP_ID,
966 NEW_SOURCE_BUSINESS_GRP_NAME = X_NEW_SOURCE_BUSINESS_GRP_NAME,
967 OLD_SOURCE_BUSINESS_GRP_NAME = X_OLD_SOURCE_BUSINESS_GRP_NAME,
968 NEW_SOURCE_FIRST_NAME = X_NEW_SOURCE_FIRST_NAME ,
969 OLD_SOURCE_FIRST_NAME = X_OLD_SOURCE_FIRST_NAME ,
970 NEW_SOURCE_LAST_NAME = X_NEW_SOURCE_LAST_NAME ,
971 OLD_SOURCE_LAST_NAME = X_OLD_SOURCE_LAST_NAME ,
972 NEW_SOURCE_MIDDLE_NAME = X_NEW_SOURCE_MIDDLE_NAME ,
973 OLD_SOURCE_MIDDLE_NAME = X_OLD_SOURCE_MIDDLE_NAME ,
974 NEW_SOURCE_CATEGORY = X_NEW_SOURCE_CATEGORY ,
975 OLD_SOURCE_CATEGORY = X_OLD_SOURCE_CATEGORY ,
976 NEW_SOURCE_STATUS = X_NEW_SOURCE_STATUS ,
977 OLD_SOURCE_STATUS = X_OLD_SOURCE_STATUS ,
978 NEW_SOURCE_OFFICE = X_NEW_SOURCE_OFFICE,
979 OLD_SOURCE_OFFICE = X_OLD_SOURCE_OFFICE,
980 NEW_SOURCE_LOCATION = X_NEW_SOURCE_LOCATION,
981 OLD_SOURCE_LOCATION = X_OLD_SOURCE_LOCATION,
982 NEW_SOURCE_MAILSTOP = X_NEW_SOURCE_MAILSTOP,
983 OLD_SOURCE_MAILSTOP = X_OLD_SOURCE_MAILSTOP,
984 NEW_USER_NAME = X_NEW_USER_NAME,
985 OLD_USER_NAME = X_OLD_USER_NAME,
986 NEW_SOURCE_JOB_ID = X_NEW_SOURCE_JOB_ID,
987 OLD_SOURCE_JOB_ID = X_OLD_SOURCE_JOB_ID,
988 NEW_PARTY_ID = X_NEW_PARTY_ID,
989 OLD_PARTY_ID = X_OLD_PARTY_ID,
990 NEW_SOURCE_MOBILE_PHONE = X_NEW_SOURCE_MOBILE_PHONE,
991 OLD_SOURCE_MOBILE_PHONE = X_OLD_SOURCE_MOBILE_PHONE,
992 NEW_SOURCE_PAGER = X_NEW_SOURCE_PAGER,
993 OLD_SOURCE_PAGER = X_OLD_SOURCE_PAGER
994 where RESOURCE_AUDIT_ID = X_RESOURCE_AUDIT_ID;
995
996 if (sql%notfound) then
997 raise no_data_found;
998 end if;
999 end UPDATE_ROW;
1000
1001 procedure DELETE_ROW (
1002 X_RESOURCE_AUDIT_ID in NUMBER
1003 ) is
1004 begin
1005 delete from JTF_RS_RESOURCE_EXTN_AUD
1006 where RESOURCE_AUDIT_ID = X_RESOURCE_AUDIT_ID;
1007
1008 if (sql%notfound) then
1009 raise no_data_found;
1010 end if;
1011
1012 end DELETE_ROW;
1013
1014 end JTF_RS_RESOURCE_EXTN_AUD_PKG;