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