DBA Data[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;