eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.CS_CF_SOURCE_CXT_TARGETS_PKG

Source


1 package body CS_CF_SOURCE_CXT_TARGETS_PKG as
2 /* $Header: CSCFCTAB.pls 120.0 2005/06/01 12:26:22 appldev noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_SOURCE_CONTEXT_TARGET_ID in NUMBER,
6   X_SOURCE_CONTEXT_TYPE_ID in NUMBER,
7   X_CONTEXT_VALUE1 in VARCHAR2,
8   X_CONTEXT_VALUE2 in VARCHAR2,
9   X_CONTEXT_VALUE3 in VARCHAR2,
10   X_CONTEXT_VALUE4 in VARCHAR2,
11   X_CONTEXT_VALUE5 in VARCHAR2,
12   X_SEED_TARGET_VALUE1 in VARCHAR2,
13   X_SEED_TARGET_VALUE2 in VARCHAR2,
14   X_CUST_TARGET_VALUE1 in VARCHAR2,
15   X_CUST_TARGET_VALUE2 in VARCHAR2,
16   X_OBJECT_VERSION_NUMBER in NUMBER,
17   X_CREATION_DATE in DATE,
18   X_CREATED_BY in NUMBER,
19   X_LAST_UPDATE_DATE in DATE,
20   X_LAST_UPDATED_BY in NUMBER,
21   X_LAST_UPDATE_LOGIN in NUMBER,
22   X_ATTRIBUTE_CATEGORY in VARCHAR2,
23   X_ATTRIBUTE1 in VARCHAR2,
24   X_ATTRIBUTE2 in VARCHAR2,
25   X_ATTRIBUTE3 in VARCHAR2,
26   X_ATTRIBUTE4 in VARCHAR2,
27   X_ATTRIBUTE5 in VARCHAR2,
28   X_ATTRIBUTE6 in VARCHAR2,
29   X_ATTRIBUTE7 in VARCHAR2,
30   X_ATTRIBUTE8 in VARCHAR2,
31   X_ATTRIBUTE9 in VARCHAR2,
32   X_ATTRIBUTE10 in VARCHAR2,
33   X_ATTRIBUTE11 in VARCHAR2,
34   X_ATTRIBUTE12 in VARCHAR2,
35   X_ATTRIBUTE13 in VARCHAR2,
36   X_ATTRIBUTE14 in VARCHAR2,
37   X_ATTRIBUTE15 in VARCHAR2,
38   X_ADDITIONAL_INFO1 in VARCHAR2,
39   X_ADDITIONAL_INFO2 in VARCHAR2,
40   X_ADDITIONAL_INFO3 in VARCHAR2,
41   X_ADDITIONAL_INFO4 in VARCHAR2,
42   X_ADDITIONAL_INFO5 in VARCHAR2,
43   X_ADDITIONAL_INFO6 in VARCHAR2,
44   X_ADDITIONAL_INFO7 in VARCHAR2,
45   X_ADDITIONAL_INFO8 in VARCHAR2,
46   X_ADDITIONAL_INFO9 in VARCHAR2,
47   X_ADDITIONAL_INFO10 in VARCHAR2,
48   X_ADDITIONAL_INFO11 in VARCHAR2,
49   X_ADDITIONAL_INFO12 in VARCHAR2,
50   X_ADDITIONAL_INFO13 in VARCHAR2,
51   X_ADDITIONAL_INFO14 in VARCHAR2,
52   X_ADDITIONAL_INFO15 in VARCHAR2
53 
54 ) is
55   cursor C is select ROWID from CS_CF_SOURCE_CXT_TARGETS
56     where SOURCE_CONTEXT_TARGET_ID = X_SOURCE_CONTEXT_TARGET_ID;
57 
58 
59 begin
60   insert into CS_CF_SOURCE_CXT_TARGETS (
61     SOURCE_CONTEXT_TARGET_ID,
62     SOURCE_CONTEXT_TYPE_ID,
63     CONTEXT_VALUE1,
64     CONTEXT_VALUE2,
65     CONTEXT_VALUE3,
66     CONTEXT_VALUE4,
67     CONTEXT_VALUE5,
68     SEED_TARGET_VALUE1,
69     SEED_TARGET_VALUE2,
70     CUST_TARGET_VALUE1,
71     CUST_TARGET_VALUE2,
72     OBJECT_VERSION_NUMBER,
73     CREATION_DATE,
74     CREATED_BY,
75     LAST_UPDATE_DATE,
76     LAST_UPDATED_BY,
77     LAST_UPDATE_LOGIN,
78     ATTRIBUTE_CATEGORY,
79     ATTRIBUTE1,
80     ATTRIBUTE2,
81     ATTRIBUTE3,
82     ATTRIBUTE4,
83     ATTRIBUTE5,
84     ATTRIBUTE6,
85     ATTRIBUTE7,
86     ATTRIBUTE8,
87     ATTRIBUTE9,
88     ATTRIBUTE10,
89     ATTRIBUTE11,
90     ATTRIBUTE12,
91     ATTRIBUTE13,
92     ATTRIBUTE14,
93     ATTRIBUTE15,
94     ADDITIONAL_INFO1,
95     ADDITIONAL_INFO2,
96     ADDITIONAL_INFO3,
97     ADDITIONAL_INFO4,
98     ADDITIONAL_INFO5,
99     ADDITIONAL_INFO6,
100     ADDITIONAL_INFO7,
101     ADDITIONAL_INFO8,
102     ADDITIONAL_INFO9,
103     ADDITIONAL_INFO10,
104     ADDITIONAL_INFO11,
105     ADDITIONAL_INFO12,
106     ADDITIONAL_INFO13,
107     ADDITIONAL_INFO14,
108     ADDITIONAL_INFO15
109   ) values (
110     X_SOURCE_CONTEXT_TARGET_ID,
111     X_SOURCE_CONTEXT_TYPE_ID,
112     X_CONTEXT_VALUE1,
113     X_CONTEXT_VALUE2,
114     X_CONTEXT_VALUE3,
115     X_CONTEXT_VALUE4,
116     X_CONTEXT_VALUE5,
117     X_SEED_TARGET_VALUE1,
118     X_SEED_TARGET_VALUE2,
119     X_CUST_TARGET_VALUE1,
120     X_CUST_TARGET_VALUE2,
121     X_OBJECT_VERSION_NUMBER,
122     X_CREATION_DATE,
123     X_CREATED_BY,
124     X_LAST_UPDATE_DATE,
125     X_LAST_UPDATED_BY,
126     X_LAST_UPDATE_LOGIN,
127     X_ATTRIBUTE_CATEGORY,
128     X_ATTRIBUTE1,
129     X_ATTRIBUTE2,
130     X_ATTRIBUTE3,
131     X_ATTRIBUTE4,
132     X_ATTRIBUTE5,
133     X_ATTRIBUTE6,
134     X_ATTRIBUTE7,
135     X_ATTRIBUTE8,
136     X_ATTRIBUTE9,
137     X_ATTRIBUTE10,
138     X_ATTRIBUTE11,
139     X_ATTRIBUTE12,
140     X_ATTRIBUTE13,
141     X_ATTRIBUTE14,
142     X_ATTRIBUTE15,
143     X_ADDITIONAL_INFO1,
144     X_ADDITIONAL_INFO2,
145     X_ADDITIONAL_INFO3,
146     X_ADDITIONAL_INFO4,
147     X_ADDITIONAL_INFO5,
148     X_ADDITIONAL_INFO6,
149     X_ADDITIONAL_INFO7,
150     X_ADDITIONAL_INFO8,
151     X_ADDITIONAL_INFO9,
152     X_ADDITIONAL_INFO10,
153     X_ADDITIONAL_INFO11,
154     X_ADDITIONAL_INFO12,
155     X_ADDITIONAL_INFO13,
156     X_ADDITIONAL_INFO14,
157     X_ADDITIONAL_INFO15
158   );
159 
160   open c;
161   fetch c into X_ROWID;
162   if (c%notfound) then
163     close c;
164     raise no_data_found;
165   end if;
166   close c;
167 
168 end INSERT_ROW;
169 
170 procedure LOCK_ROW (
171   X_SOURCE_CONTEXT_TARGET_ID in NUMBER,
172   X_SOURCE_CONTEXT_TYPE_ID in NUMBER,
173   X_CONTEXT_VALUE1 in VARCHAR2,
174   X_CONTEXT_VALUE2 in VARCHAR2,
175   X_CONTEXT_VALUE3 in VARCHAR2,
176   X_CONTEXT_VALUE4 in VARCHAR2,
177   X_CONTEXT_VALUE5 in VARCHAR2,
178   X_SEED_TARGET_VALUE1 in VARCHAR2,
179   X_SEED_TARGET_VALUE2 in VARCHAR2,
180   X_CUST_TARGET_VALUE1 in VARCHAR2,
181   X_CUST_TARGET_VALUE2 in VARCHAR2,
182   X_OBJECT_VERSION_NUMBER in NUMBER,
183   X_ATTRIBUTE_CATEGORY in VARCHAR2,
184   X_ATTRIBUTE1 in VARCHAR2,
185   X_ATTRIBUTE2 in VARCHAR2,
186   X_ATTRIBUTE3 in VARCHAR2,
187   X_ATTRIBUTE4 in VARCHAR2,
188   X_ATTRIBUTE5 in VARCHAR2,
189   X_ATTRIBUTE6 in VARCHAR2,
190   X_ATTRIBUTE7 in VARCHAR2,
191   X_ATTRIBUTE8 in VARCHAR2,
192   X_ATTRIBUTE9 in VARCHAR2,
193   X_ATTRIBUTE10 in VARCHAR2,
194   X_ATTRIBUTE11 in VARCHAR2,
195   X_ATTRIBUTE12 in VARCHAR2,
196   X_ATTRIBUTE13 in VARCHAR2,
197   X_ATTRIBUTE14 in VARCHAR2,
198   X_ATTRIBUTE15 in VARCHAR2,
199   X_ADDITIONAL_INFO1 in VARCHAR2,
200   X_ADDITIONAL_INFO2 in VARCHAR2,
201   X_ADDITIONAL_INFO3 in VARCHAR2,
202   X_ADDITIONAL_INFO4 in VARCHAR2,
203   X_ADDITIONAL_INFO5 in VARCHAR2,
204   X_ADDITIONAL_INFO6 in VARCHAR2,
205   X_ADDITIONAL_INFO7 in VARCHAR2,
206   X_ADDITIONAL_INFO8 in VARCHAR2,
207   X_ADDITIONAL_INFO9 in VARCHAR2,
208   X_ADDITIONAL_INFO10 in VARCHAR2,
209   X_ADDITIONAL_INFO11 in VARCHAR2,
210   X_ADDITIONAL_INFO12 in VARCHAR2,
211   X_ADDITIONAL_INFO13 in VARCHAR2,
212   X_ADDITIONAL_INFO14 in VARCHAR2,
213   X_ADDITIONAL_INFO15 in VARCHAR2
214 ) is
215   cursor c is select
216 	 SOURCE_CONTEXT_TYPE_ID,
217 	 CONTEXT_VALUE1,
218 	 CONTEXT_VALUE2,
219 	 CONTEXT_VALUE3,
220 	 CONTEXT_VALUE4,
221 	 CONTEXT_VALUE5,
222 	 SEED_TARGET_VALUE1,
223          SEED_TARGET_VALUE2,
224          CUST_TARGET_VALUE1,
225          CUST_TARGET_VALUE2,
226          OBJECT_VERSION_NUMBER,
227 	 ATTRIBUTE_CATEGORY,
228 	 ATTRIBUTE1,
229 	 ATTRIBUTE2,
230 	 ATTRIBUTE3,
231 	 ATTRIBUTE4,
232 	 ATTRIBUTE5,
233 	 ATTRIBUTE6,
234 	 ATTRIBUTE7,
235 	 ATTRIBUTE8,
236 	 ATTRIBUTE9,
237 	 ATTRIBUTE10,
238 	 ATTRIBUTE11,
239 	 ATTRIBUTE12,
240 	 ATTRIBUTE13,
241 	 ATTRIBUTE14,
242 	 ATTRIBUTE15,
243 	 ADDITIONAL_INFO1,
244 	 ADDITIONAL_INFO2,
245 	 ADDITIONAL_INFO3,
246 	 ADDITIONAL_INFO4,
247 	 ADDITIONAL_INFO5,
248 	 ADDITIONAL_INFO6,
249 	 ADDITIONAL_INFO7,
250 	 ADDITIONAL_INFO8,
251 	 ADDITIONAL_INFO9,
252 	 ADDITIONAL_INFO10,
253 	 ADDITIONAL_INFO11,
254 	 ADDITIONAL_INFO12,
255 	 ADDITIONAL_INFO13,
256 	 ADDITIONAL_INFO14,
257 	 ADDITIONAL_INFO15
258     from CS_CF_SOURCE_CXT_TARGETS
259     where SOURCE_CONTEXT_TARGET_ID = X_SOURCE_CONTEXT_TARGET_ID
260     for update of SOURCE_CONTEXT_TARGET_ID nowait;
261   recinfo c%rowtype;
262 
263 begin
264   open c;
265   fetch c into recinfo;
266   if (c%notfound) then
267     close c;
268     fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
269     app_exception.raise_exception;
270   end if;
271   close c;
272   if (    ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
273            OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
274       AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
275            OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
276       AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
277            OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
278       AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
279            OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
280       AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
281            OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
282       AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
283            OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
284       AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
285            OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
286       AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
287            OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
288       AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
289            OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
290       AND ((recinfo.ADDITIONAL_INFO1 = X_ADDITIONAL_INFO1)
291            OR ((recinfo.ADDITIONAL_INFO1 is null) AND (X_ADDITIONAL_INFO1 is null)))
292       AND ((recinfo.ADDITIONAL_INFO2 = X_ADDITIONAL_INFO2)
293            OR ((recinfo.ADDITIONAL_INFO2 is null) AND (X_ADDITIONAL_INFO2 is null)))
294       AND ((recinfo.ADDITIONAL_INFO3 = X_ADDITIONAL_INFO3)
295            OR ((recinfo.ADDITIONAL_INFO3 is null) AND (X_ADDITIONAL_INFO3 is null)))
296       AND ((recinfo.ADDITIONAL_INFO4 = X_ADDITIONAL_INFO4)
297            OR ((recinfo.ADDITIONAL_INFO4 is null) AND (X_ADDITIONAL_INFO4 is null)))
298       AND ((recinfo.ADDITIONAL_INFO5 = X_ADDITIONAL_INFO5)
299            OR ((recinfo.ADDITIONAL_INFO5 is null) AND (X_ADDITIONAL_INFO5 is null)))
300       AND ((recinfo.ADDITIONAL_INFO6 = X_ADDITIONAL_INFO6)
301            OR ((recinfo.ADDITIONAL_INFO6 is null) AND (X_ADDITIONAL_INFO6 is null)))
302       AND ((recinfo.ADDITIONAL_INFO7 = X_ADDITIONAL_INFO7)
303            OR ((recinfo.ADDITIONAL_INFO7 is null) AND (X_ADDITIONAL_INFO7 is null)))
304       AND ((recinfo.ADDITIONAL_INFO8 = X_ADDITIONAL_INFO8)
305            OR ((recinfo.ADDITIONAL_INFO8 is null) AND (X_ADDITIONAL_INFO8 is null)))
306       AND ((recinfo.ADDITIONAL_INFO9 = X_ADDITIONAL_INFO9)
307            OR ((recinfo.ADDITIONAL_INFO9 is null) AND (X_ADDITIONAL_INFO9 is null)))
308       AND ((recinfo.ADDITIONAL_INFO10 = X_ADDITIONAL_INFO10)
309            OR ((recinfo.ADDITIONAL_INFO10 is null) AND (X_ADDITIONAL_INFO10 is null)))
310       AND ((recinfo.ADDITIONAL_INFO11 = X_ADDITIONAL_INFO11)
311            OR ((recinfo.ADDITIONAL_INFO11 is null) AND (X_ADDITIONAL_INFO11 is null)))
312       AND ((recinfo.ADDITIONAL_INFO12 = X_ADDITIONAL_INFO12)
313            OR ((recinfo.ADDITIONAL_INFO12 is null) AND (X_ADDITIONAL_INFO12 is null)))
314       AND ((recinfo.ADDITIONAL_INFO13 = X_ADDITIONAL_INFO13)
315            OR ((recinfo.ADDITIONAL_INFO13 is null) AND (X_ADDITIONAL_INFO13 is null)))
316       AND ((recinfo.ADDITIONAL_INFO14 = X_ADDITIONAL_INFO14)
317            OR ((recinfo.ADDITIONAL_INFO14 is null) AND (X_ADDITIONAL_INFO14 is null)))
318       AND ((recinfo.ADDITIONAL_INFO15 = X_ADDITIONAL_INFO15)
319            OR ((recinfo.ADDITIONAL_INFO15 is null) AND (X_ADDITIONAL_INFO15 is null)))
320       AND ((recinfo.SEED_TARGET_VALUE2 = X_SEED_TARGET_VALUE2)
321            OR ((recinfo.SEED_TARGET_VALUE2 is null) AND (X_SEED_TARGET_VALUE2 is null)))
322       AND ((recinfo.CUST_TARGET_VALUE1 = X_CUST_TARGET_VALUE1)
323            OR ((recinfo.CUST_TARGET_VALUE1 is null) AND (X_CUST_TARGET_VALUE1 is null)))
324       AND ((recinfo.CUST_TARGET_VALUE2 = X_CUST_TARGET_VALUE2)
325            OR ((recinfo.CUST_TARGET_VALUE2 is null) AND (X_CUST_TARGET_VALUE2 is null)))
326       AND ((recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
327            OR ((recinfo.OBJECT_VERSION_NUMBER is null) AND (X_OBJECT_VERSION_NUMBER is null)))
328       AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
329            OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
330       AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
331            OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
332       AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
333            OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
334       AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
335            OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
336       AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
337            OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
338       AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
339            OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
340       AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
341            OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
342       AND ((recinfo.SOURCE_CONTEXT_TYPE_ID = X_SOURCE_CONTEXT_TYPE_ID)
343            OR ((recinfo.SOURCE_CONTEXT_TYPE_ID is null) AND (X_SOURCE_CONTEXT_TYPE_ID is null)))
344       AND ((recinfo.CONTEXT_VALUE1 = X_CONTEXT_VALUE1)
345            OR ((recinfo.CONTEXT_VALUE1 is null) AND (X_CONTEXT_VALUE1 is null)))
346       AND ((recinfo.CONTEXT_VALUE2 = X_CONTEXT_VALUE2)
347            OR ((recinfo.CONTEXT_VALUE2 is null) AND (X_CONTEXT_VALUE2 is null)))
348       AND ((recinfo.CONTEXT_VALUE3 = X_CONTEXT_VALUE3)
349            OR ((recinfo.CONTEXT_VALUE3 is null) AND (X_CONTEXT_VALUE3 is null)))
350       AND ((recinfo.CONTEXT_VALUE4 = X_CONTEXT_VALUE4)
351            OR ((recinfo.CONTEXT_VALUE4 is null) AND (X_CONTEXT_VALUE4 is null)))
352       AND ((recinfo.CONTEXT_VALUE5 = X_CONTEXT_VALUE5)
353            OR ((recinfo.CONTEXT_VALUE5 is null) AND (X_CONTEXT_VALUE5 is null)))
354       AND ((recinfo.SEED_TARGET_VALUE1 = X_SEED_TARGET_VALUE1)
355            OR ((recinfo.SEED_TARGET_VALUE1 is null) AND (X_SEED_TARGET_VALUE1 is null)))
356   ) then
357     null;
358   else
359     fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
360     app_exception.raise_exception;
361   end if;
362 
363   return;
364 end LOCK_ROW;
365 
366 procedure UPDATE_ROW (
367   X_SOURCE_CONTEXT_TARGET_ID in NUMBER,
368   X_SOURCE_CONTEXT_TYPE_ID in NUMBER,
369   X_CONTEXT_VALUE1 in VARCHAR2,
370   X_CONTEXT_VALUE2 in VARCHAR2,
371   X_CONTEXT_VALUE3 in VARCHAR2,
372   X_CONTEXT_VALUE4 in VARCHAR2,
373   X_CONTEXT_VALUE5 in VARCHAR2,
374   X_SEED_TARGET_VALUE1 in VARCHAR2,
375   X_SEED_TARGET_VALUE2 in VARCHAR2,
376   X_CUST_TARGET_VALUE1 in VARCHAR2,
377   X_CUST_TARGET_VALUE2 in VARCHAR2,
378   X_OBJECT_VERSION_NUMBER in NUMBER,
379   X_LAST_UPDATE_DATE in DATE,
380   X_LAST_UPDATED_BY in NUMBER,
381   X_LAST_UPDATE_LOGIN in NUMBER,
382   X_ATTRIBUTE_CATEGORY in VARCHAR2,
383   X_ATTRIBUTE1 in VARCHAR2,
384   X_ATTRIBUTE2 in VARCHAR2,
385   X_ATTRIBUTE3 in VARCHAR2,
386   X_ATTRIBUTE4 in VARCHAR2,
387   X_ATTRIBUTE5 in VARCHAR2,
388   X_ATTRIBUTE6 in VARCHAR2,
389   X_ATTRIBUTE7 in VARCHAR2,
390   X_ATTRIBUTE8 in VARCHAR2,
391   X_ATTRIBUTE9 in VARCHAR2,
392   X_ATTRIBUTE10 in VARCHAR2,
393   X_ATTRIBUTE11 in VARCHAR2,
394   X_ATTRIBUTE12 in VARCHAR2,
395   X_ATTRIBUTE13 in VARCHAR2,
396   X_ATTRIBUTE14 in VARCHAR2,
397   X_ATTRIBUTE15 in VARCHAR2,
398   X_ADDITIONAL_INFO1 in VARCHAR2,
399   X_ADDITIONAL_INFO2 in VARCHAR2,
400   X_ADDITIONAL_INFO3 in VARCHAR2,
401   X_ADDITIONAL_INFO4 in VARCHAR2,
402   X_ADDITIONAL_INFO5 in VARCHAR2,
403   X_ADDITIONAL_INFO6 in VARCHAR2,
404   X_ADDITIONAL_INFO7 in VARCHAR2,
405   X_ADDITIONAL_INFO8 in VARCHAR2,
406   X_ADDITIONAL_INFO9 in VARCHAR2,
407   X_ADDITIONAL_INFO10 in VARCHAR2,
408   X_ADDITIONAL_INFO11 in VARCHAR2,
409   X_ADDITIONAL_INFO12 in VARCHAR2,
410   X_ADDITIONAL_INFO13 in VARCHAR2,
414 
411   X_ADDITIONAL_INFO14 in VARCHAR2,
412   X_ADDITIONAL_INFO15 in VARCHAR2
413 ) is
415 
416 begin
417 
418 
419   update CS_CF_SOURCE_CXT_TARGETS set
420     SOURCE_CONTEXT_TYPE_ID = X_SOURCE_CONTEXT_TYPE_ID,
421     CONTEXT_VALUE1 = X_CONTEXT_VALUE1,
422     CONTEXT_VALUE2 = X_CONTEXT_VALUE2,
423     CONTEXT_VALUE3 = X_CONTEXT_VALUE3,
424     CONTEXT_VALUE4 = X_CONTEXT_VALUE4,
425     CONTEXT_VALUE5 = X_CONTEXT_VALUE5,
426     SEED_TARGET_VALUE1 = X_SEED_TARGET_VALUE1,
427     SEED_TARGET_VALUE2 = X_SEED_TARGET_VALUE2,
428     CUST_TARGET_VALUE1 = X_CUST_TARGET_VALUE1,
429     CUST_TARGET_VALUE2 = X_CUST_TARGET_VALUE2,
430     OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
431     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
432     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
433     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
434     ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
435     ATTRIBUTE1 = X_ATTRIBUTE1,
436     ATTRIBUTE2 = X_ATTRIBUTE2,
437     ATTRIBUTE3 = X_ATTRIBUTE3,
438     ATTRIBUTE4 = X_ATTRIBUTE4,
439     ATTRIBUTE5 = X_ATTRIBUTE5,
440     ATTRIBUTE6 = X_ATTRIBUTE6,
441     ATTRIBUTE7 = X_ATTRIBUTE7,
442     ATTRIBUTE8 = X_ATTRIBUTE8,
443     ATTRIBUTE9 = X_ATTRIBUTE9,
444     ATTRIBUTE10 = X_ATTRIBUTE10,
445     ATTRIBUTE11 = X_ATTRIBUTE11,
446     ATTRIBUTE12 = X_ATTRIBUTE12,
447     ATTRIBUTE13 = X_ATTRIBUTE13,
448     ATTRIBUTE14 = X_ATTRIBUTE14,
449     ATTRIBUTE15 = X_ATTRIBUTE15,
450     ADDITIONAL_INFO1 = X_ADDITIONAL_INFO1,
451     ADDITIONAL_INFO2 = X_ADDITIONAL_INFO2,
452     ADDITIONAL_INFO3 = X_ADDITIONAL_INFO3,
453     ADDITIONAL_INFO4 = X_ADDITIONAL_INFO4,
454     ADDITIONAL_INFO5 = X_ADDITIONAL_INFO5,
455     ADDITIONAL_INFO6 = X_ADDITIONAL_INFO6,
456     ADDITIONAL_INFO7 = X_ADDITIONAL_INFO7,
457     ADDITIONAL_INFO8 = X_ADDITIONAL_INFO8,
458     ADDITIONAL_INFO9 = X_ADDITIONAL_INFO9,
459     ADDITIONAL_INFO10 = X_ADDITIONAL_INFO10,
460     ADDITIONAL_INFO11 = X_ADDITIONAL_INFO11,
461     ADDITIONAL_INFO12 = X_ADDITIONAL_INFO12,
462     ADDITIONAL_INFO13 = X_ADDITIONAL_INFO13,
463     ADDITIONAL_INFO14 = X_ADDITIONAL_INFO14,
464     ADDITIONAL_INFO15 = X_ADDITIONAL_INFO15
465   where SOURCE_CONTEXT_TARGET_ID = X_SOURCE_CONTEXT_TARGET_ID;
466 
467 
468   if (sql%notfound) then
469     raise no_data_found;
470   end if;
471 
472 end UPDATE_ROW;
473 
474 procedure DELETE_ROW (
475   X_SOURCE_CONTEXT_TARGET_ID in NUMBER
476 ) is
477 begin
478 
479   delete from CS_CF_SOURCE_CXT_TARGETS
480   where SOURCE_CONTEXT_TARGET_ID = X_SOURCE_CONTEXT_TARGET_ID;
481 
482   if (sql%notfound) then
483     raise no_data_found;
484   end if;
485 end DELETE_ROW;
486 
487 procedure LOAD_ROW (
488   X_SOURCE_CONTEXT_TARGET_ID in NUMBER,
489   X_SOURCE_CONTEXT_TYPE_ID in NUMBER,
490   X_CONTEXT_VALUE1 in VARCHAR2,
491   X_CONTEXT_VALUE2 in VARCHAR2,
492   X_CONTEXT_VALUE3 in VARCHAR2,
493   X_CONTEXT_VALUE4 in VARCHAR2,
494   X_CONTEXT_VALUE5 in VARCHAR2,
495   X_SEED_TARGET_VALUE1 in VARCHAR2,
496   X_SEED_TARGET_VALUE2 in VARCHAR2,
497   X_CUST_TARGET_VALUE1 in VARCHAR2,
498   X_CUST_TARGET_VALUE2 in VARCHAR2,
499   X_OWNER in VARCHAR2,
500   X_LAST_UPDATE_DATE in DATE,
501   X_CUSTOM_MODE in VARCHAR2,
502   X_ADDITIONAL_INFO1 in VARCHAR2,
503   X_ADDITIONAL_INFO2 in VARCHAR2,
504   X_ADDITIONAL_INFO3 in VARCHAR2,
505   X_ADDITIONAL_INFO4 in VARCHAR2,
506   X_ADDITIONAL_INFO5 in VARCHAR2,
507   X_ADDITIONAL_INFO6 in VARCHAR2,
508   X_ADDITIONAL_INFO7 in VARCHAR2,
509   X_ADDITIONAL_INFO8 in VARCHAR2,
510   X_ADDITIONAL_INFO9 in VARCHAR2,
511   X_ADDITIONAL_INFO10 in VARCHAR2,
512   X_ADDITIONAL_INFO11 in VARCHAR2,
513   X_ADDITIONAL_INFO12 in VARCHAR2,
514   X_ADDITIONAL_INFO13 in VARCHAR2,
515   X_ADDITIONAL_INFO14 in VARCHAR2,
516   X_ADDITIONAL_INFO15 in VARCHAR2
517 ) AS
518 
519   f_luby number ; -- entity owner in file
520   f_ludate date ; -- entity update date in file
521   db_luby  number; -- entity owner in db
522   db_ludate date; -- entity update date in db
523 
524   l_object_version_number number := 1;
525   l_rowid varchar2(50);
526 
527   l_attribute_category varchar2(30);
528   l_attribute1 varchar2(150);
529   l_attribute2 varchar2(150);
530   l_attribute3 varchar2(150);
531   l_attribute4 varchar2(150);
532   l_attribute5 varchar2(150);
533   l_attribute6 varchar2(150);
534   l_attribute7 varchar2(150);
535   l_attribute8 varchar2(150);
536   l_attribute9 varchar2(150);
537   l_attribute10 varchar2(150);
538   l_attribute11 varchar2(150);
539   l_attribute12 varchar2(150);
540   l_attribute13 varchar2(150);
541   l_attribute14 varchar2(150);
542   l_attribute15 varchar2(150);
543 
544 begin
545 
546   f_luby := fnd_load_util.owner_id(X_OWNER);
547   f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);
548 
549 
550   select LAST_UPDATED_BY, LAST_UPDATE_DATE
551   into db_luby, db_ludate
552   from CS_CF_SOURCE_CXT_TARGETS
553   where source_context_target_id = X_SOURCE_CONTEXT_TARGET_ID;
554 
555   if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
556     -- Update existing row
557     SELECT object_version_number, rowid,
558 		 attribute_category,
559 		 attribute1,
560 		 attribute2,
561 		 attribute3,
562 		 attribute4,
563 		 attribute5,
564 		 attribute6,
565 		 attribute7,
566 		 attribute8,
567 		 attribute9,
568 		 attribute10,
569 		 attribute11,
570 		 attribute12,
571 		 attribute13,
572 		 attribute14,
573 		 attribute15
574     INTO l_object_version_number, l_rowid,
575 	    l_attribute_category,
576 	    l_attribute1,
577 	    l_attribute2,
578 	    l_attribute3,
579 	    l_attribute4,
580 	    l_attribute5,
581 	    l_attribute6,
582 	    l_attribute7,
583 	    l_attribute8,
584 	    l_attribute9,
585 	    l_attribute10,
586 	    l_attribute11,
587 	    l_attribute12,
588 	    l_attribute13,
589 	    l_attribute14,
590 	    l_attribute15
591     FROM CS_CF_SOURCE_CXT_TARGETS
592     WHERE source_context_target_id = X_SOURCE_CONTEXT_TARGET_ID
593     FOR UPDATE ;
594 
595     CS_CF_SOURCE_CXT_TARGETS_PKG.Update_Row(
596 	 X_SOURCE_CONTEXT_TARGET_ID => to_number(X_SOURCE_CONTEXT_TARGET_ID),
597 	 X_SOURCE_CONTEXT_TYPE_ID => to_number(X_SOURCE_CONTEXT_TYPE_ID),
598 	 X_CONTEXT_VALUE1 => X_CONTEXT_VALUE1,
599 	 X_CONTEXT_VALUE2 => X_CONTEXT_VALUE2,
600 	 X_CONTEXT_VALUE3 => X_CONTEXT_VALUE3,
601 	 X_CONTEXT_VALUE4 => X_CONTEXT_VALUE4,
602 	 X_CONTEXT_VALUE5 => X_CONTEXT_VALUE5,
603 	 X_SEED_TARGET_VALUE1 => X_SEED_TARGET_VALUE1,
604 	 X_SEED_TARGET_VALUE2 => X_SEED_TARGET_VALUE2,
605 	 X_CUST_TARGET_VALUE1 => X_CUST_TARGET_VALUE1,
606 	 X_CUST_TARGET_VALUE2 => X_CUST_TARGET_VALUE2,
607 	 X_OBJECT_VERSION_NUMBER => l_object_version_number + 1,
608 	 X_ATTRIBUTE_CATEGORY => l_attribute_category,
609 	 X_ATTRIBUTE1 => l_attribute1,
610 	 X_ATTRIBUTE2 => l_attribute2,
611 	 X_ATTRIBUTE3 => l_attribute3,
612 	 X_ATTRIBUTE4 => l_attribute4,
613 	 X_ATTRIBUTE5 => l_attribute5,
614 	 X_ATTRIBUTE6 => l_attribute6,
615 	 X_ATTRIBUTE7 => l_attribute7,
616 	 X_ATTRIBUTE8 => l_attribute8,
617 	 X_ATTRIBUTE9 => l_attribute9,
618 	 X_ATTRIBUTE10 => l_attribute10,
619 	 X_ATTRIBUTE11 => l_attribute11,
620 	 X_ATTRIBUTE12 => l_attribute12,
621 	 X_ATTRIBUTE13 => l_attribute13,
622 	 X_ATTRIBUTE14 => l_attribute14,
623 	 X_ATTRIBUTE15 => l_attribute15,
624 	 X_ADDITIONAL_INFO1 => X_ADDITIONAL_INFO1,
625 	 X_ADDITIONAL_INFO2 => X_ADDITIONAL_INFO2,
626 	 X_ADDITIONAL_INFO3 => X_ADDITIONAL_INFO3,
627 	 X_ADDITIONAL_INFO4 => X_ADDITIONAL_INFO4,
628 	 X_ADDITIONAL_INFO5 => X_ADDITIONAL_INFO5,
629 	 X_ADDITIONAL_INFO6 => X_ADDITIONAL_INFO6,
630 	 X_ADDITIONAL_INFO7 => X_ADDITIONAL_INFO7,
631 	 X_ADDITIONAL_INFO8 => X_ADDITIONAL_INFO8,
632 	 X_ADDITIONAL_INFO9 => X_ADDITIONAL_INFO9,
633 	 X_ADDITIONAL_INFO10 => X_ADDITIONAL_INFO10,
634 	 X_ADDITIONAL_INFO11 => X_ADDITIONAL_INFO11,
635 	 X_ADDITIONAL_INFO12 => X_ADDITIONAL_INFO12,
636 	 X_ADDITIONAL_INFO13 => X_ADDITIONAL_INFO13,
637 	 X_ADDITIONAL_INFO14 => X_ADDITIONAL_INFO14,
638 	 X_ADDITIONAL_INFO15 => X_ADDITIONAL_INFO15,
639 	 X_LAST_UPDATE_DATE => f_ludate,
640 	 X_LAST_UPDATED_BY => f_luby,
641 	 X_LAST_UPDATE_LOGIN => 0);
642     end if;
643     exception
644 	 when no_data_found then
645 	   -- Record doesn't exist -- insert in all cases
646 	   CS_CF_SOURCE_CXT_TARGETS_PKG.Insert_Row(
647 		X_ROWID => l_rowid,
648 		X_SOURCE_CONTEXT_TARGET_ID => X_SOURCE_CONTEXT_TARGET_ID,
649 		X_SOURCE_CONTEXT_TYPE_ID => X_SOURCE_CONTEXT_TYPE_ID,
650 		X_CONTEXT_VALUE1 => X_CONTEXT_VALUE1,
651 		X_CONTEXT_VALUE2 => X_CONTEXT_VALUE2,
652 		X_CONTEXT_VALUE3 => X_CONTEXT_VALUE3,
653 		X_CONTEXT_VALUE4 => X_CONTEXT_VALUE4,
654 		X_CONTEXT_VALUE5 => X_CONTEXT_VALUE5,
655 		X_SEED_TARGET_VALUE1 => X_SEED_TARGET_VALUE1,
656 		X_SEED_TARGET_VALUE2 => X_SEED_TARGET_VALUE2,
657 		X_CUST_TARGET_VALUE1 => X_CUST_TARGET_VALUE1,
658 		X_CUST_TARGET_VALUE2 => X_CUST_TARGET_VALUE2,
659 		X_OBJECT_VERSION_NUMBER => l_object_version_number,
660 		X_ATTRIBUTE_CATEGORY => NULL,
661 		X_ATTRIBUTE1 => NULL,
662 		X_ATTRIBUTE2 => NULL,
663 		X_ATTRIBUTE3 => NULL,
664 		X_ATTRIBUTE4 => NULL,
665 		X_ATTRIBUTE5 => NULL,
666 		X_ATTRIBUTE6 => NULL,
667 		X_ATTRIBUTE7 => NULL,
668 		X_ATTRIBUTE8 => NULL,
669 		X_ATTRIBUTE9 => NULL,
670 		X_ATTRIBUTE10 => NULL,
671 		X_ATTRIBUTE11 => NULL,
672 		X_ATTRIBUTE12 => NULL,
673 		X_ATTRIBUTE13 => NULL,
674 		X_ATTRIBUTE14 => NULL,
675 		X_ATTRIBUTE15 => NULL,
676 		X_ADDITIONAL_INFO1 => X_ADDITIONAL_INFO1,
677 		X_ADDITIONAL_INFO2 => X_ADDITIONAL_INFO2,
678 		X_ADDITIONAL_INFO3 => X_ADDITIONAL_INFO3,
679 		X_ADDITIONAL_INFO4 => X_ADDITIONAL_INFO4,
680 		X_ADDITIONAL_INFO5 => X_ADDITIONAL_INFO5,
681 		X_ADDITIONAL_INFO6 => X_ADDITIONAL_INFO6,
682 		X_ADDITIONAL_INFO7 => X_ADDITIONAL_INFO7,
683 		X_ADDITIONAL_INFO8 => X_ADDITIONAL_INFO8,
684 		X_ADDITIONAL_INFO9 => X_ADDITIONAL_INFO9,
685 		X_ADDITIONAL_INFO10 => X_ADDITIONAL_INFO10,
686 		X_ADDITIONAL_INFO11 => X_ADDITIONAL_INFO11,
687 		X_ADDITIONAL_INFO12 => X_ADDITIONAL_INFO12,
688 		X_ADDITIONAL_INFO13 => X_ADDITIONAL_INFO13,
689 		X_ADDITIONAL_INFO14 => X_ADDITIONAL_INFO14,
690 		X_ADDITIONAL_INFO15 => X_ADDITIONAL_INFO15,
691 		X_CREATION_DATE => sysdate,
692 		X_CREATED_BY => f_luby,
693 		X_LAST_UPDATE_DATE => f_ludate,
694 		X_LAST_UPDATED_BY => f_luby,
695 		X_LAST_UPDATE_LOGIN => 0);
696 end LOAD_ROW;
697 
698 end CS_CF_SOURCE_CXT_TARGETS_PKG;