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.AMS_CAMPAIGNS_ALL_PKG

Source


1 package body AMS_CAMPAIGNS_ALL_PKG as
2 /* $Header: amslcpnb.pls 115.7 2002/11/16 00:41:44 dbiswas ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in OUT NOCOPY VARCHAR2,
5   X_CAMPAIGN_ID in NUMBER,
6   X_OBJECT_VERSION_NUMBER in NUMBER,
7   X_OWNER_USER_ID in NUMBER,
8   X_USER_STATUS_ID in NUMBER,
9   X_STATUS_CODE in VARCHAR2,
10   X_STATUS_DATE in DATE,
11   X_ACTIVE_FLAG in VARCHAR2,
12   X_PRIVATE_FLAG in VARCHAR2,
13   X_PARTNER_FLAG in VARCHAR2,
14   X_TEMPLATE_FLAG in VARCHAR2,
15   X_CASCADE_SOURCE_CODE_FLAG in VARCHAR2,
16   X_INHERIT_ATTRIBUTES_FLAG in VARCHAR2,
17   X_SOURCE_CODE in VARCHAR2,
18   X_ROLLUP_TYPE in VARCHAR2,
19   X_CAMPAIGN_TYPE in VARCHAR2,
20   X_MEDIA_TYPE_CODE in VARCHAR2,
21   X_PRIORITY in VARCHAR2,
22   X_FUND_SOURCE_TYPE in VARCHAR2,
23   X_FUND_SOURCE_ID in NUMBER,
24   X_PARENT_CAMPAIGN_ID in NUMBER,
25   X_APPLICATION_ID in NUMBER,
26   X_QP_LIST_HEADER_ID in NUMBER,
27   X_MEDIA_ID in NUMBER,
28   X_CHANNEL_ID in NUMBER,
29   X_EVENT_TYPE in VARCHAR2,
30   X_ARC_CHANNEL_FROM in VARCHAR2,
31   X_DSCRIPT_NAME in VARCHAR2,
32   X_TRANSACTION_CURRENCY_CODE in VARCHAR2,
33   X_FUNCTIONAL_CURRENCY_CODE in VARCHAR2,
34   X_BUDGET_AMOUNT_TC in NUMBER,
35   X_BUDGET_AMOUNT_FC in NUMBER,
36   X_FORECASTED_PLAN_START_DATE in DATE,
37   X_FORECASTED_PLAN_END_DATE in DATE,
38   X_FORECASTED_EXEC_START_DATE in DATE,
39   X_FORECASTED_EXEC_END_DATE in DATE,
40   X_ACTUAL_PLAN_START_DATE in DATE,
41   X_ACTUAL_PLAN_END_DATE in DATE,
42   X_ACTUAL_EXEC_START_DATE in DATE,
43   X_ACTUAL_EXEC_END_DATE in DATE,
44   X_INBOUND_URL in VARCHAR2,
45   X_INBOUND_EMAIL_ID in VARCHAR2,
46   X_INBOUND_PHONE_NO in VARCHAR2,
47   X_DURATION in NUMBER,
48   X_DURATION_UOM_CODE in VARCHAR2,
49   X_FF_PRIORITY in VARCHAR2,
50   X_FF_OVERRIDE_COVER_LETTER in NUMBER,
51   X_FF_SHIPPING_METHOD in VARCHAR2,
52   X_FF_CARRIER in VARCHAR2,
53   X_CONTENT_SOURCE in VARCHAR2,
54   X_CC_CALL_STRATEGY in VARCHAR2,
55   X_CC_MANAGER_USER_ID in NUMBER,
56   X_FORECASTED_REVENUE in NUMBER,
57   X_ACTUAL_REVENUE in NUMBER,
58   X_FORECASTED_COST in NUMBER,
59   X_ACTUAL_COST in NUMBER,
60   X_FORECASTED_RESPONSE in NUMBER,
61   X_ACTUAL_RESPONSE in NUMBER,
62   X_TARGET_RESPONSE in NUMBER,
63   X_COUNTRY_CODE in VARCHAR2,
64   X_LANGUAGE_CODE in VARCHAR2,
65   X_ATTRIBUTE_CATEGORY in VARCHAR2,
66   X_ATTRIBUTE1 in VARCHAR2,
67   X_ATTRIBUTE2 in VARCHAR2,
68   X_ATTRIBUTE3 in VARCHAR2,
69   X_ATTRIBUTE4 in VARCHAR2,
70   X_ATTRIBUTE5 in VARCHAR2,
71   X_ATTRIBUTE6 in VARCHAR2,
72   X_ATTRIBUTE7 in VARCHAR2,
73   X_ATTRIBUTE8 in VARCHAR2,
74   X_ATTRIBUTE9 in VARCHAR2,
75   X_ATTRIBUTE10 in VARCHAR2,
76   X_ATTRIBUTE11 in VARCHAR2,
77   X_ATTRIBUTE12 in VARCHAR2,
78   X_ATTRIBUTE14 in VARCHAR2,
79   X_ATTRIBUTE13 in VARCHAR2,
80   X_ATTRIBUTE15 in VARCHAR2,
81   X_CAMPAIGN_NAME in VARCHAR2,
82   X_CAMPAIGN_THEME in VARCHAR2,
83   X_DESCRIPTION in VARCHAR2,
84   X_CREATION_DATE in DATE,
85   X_CREATED_BY in NUMBER,
86   X_LAST_UPDATE_DATE in DATE,
87   X_LAST_UPDATED_BY in NUMBER,
88   X_LAST_UPDATE_LOGIN in NUMBER
89 ) is
90   cursor C is select ROWID from AMS_CAMPAIGNS_ALL_B
91     where CAMPAIGN_ID = X_CAMPAIGN_ID
92     ;
93 begin
94   insert into AMS_CAMPAIGNS_ALL_B (
95     CAMPAIGN_ID,
96     OBJECT_VERSION_NUMBER,
97     OWNER_USER_ID,
98     USER_STATUS_ID,
99     STATUS_CODE,
100     STATUS_DATE,
101     ACTIVE_FLAG,
102     PRIVATE_FLAG,
103     PARTNER_FLAG,
104     TEMPLATE_FLAG,
105     CASCADE_SOURCE_CODE_FLAG,
106     INHERIT_ATTRIBUTES_FLAG,
107     SOURCE_CODE,
108     ROLLUP_TYPE,
109     CAMPAIGN_TYPE,
110     MEDIA_TYPE_CODE,
111     PRIORITY,
112     FUND_SOURCE_TYPE,
113     FUND_SOURCE_ID,
114     PARENT_CAMPAIGN_ID,
115     APPLICATION_ID,
116     QP_LIST_HEADER_ID,
117     MEDIA_ID,
118     CHANNEL_ID,
119     EVENT_TYPE,
120     ARC_CHANNEL_FROM,
121     DSCRIPT_NAME,
122     TRANSACTION_CURRENCY_CODE,
123     FUNCTIONAL_CURRENCY_CODE,
124     BUDGET_AMOUNT_TC,
125     BUDGET_AMOUNT_FC,
126     FORECASTED_PLAN_START_DATE,
127     FORECASTED_PLAN_END_DATE,
128     FORECASTED_EXEC_START_DATE,
129     FORECASTED_EXEC_END_DATE,
130     ACTUAL_PLAN_START_DATE,
131     ACTUAL_PLAN_END_DATE,
132     ACTUAL_EXEC_START_DATE,
133     ACTUAL_EXEC_END_DATE,
134     INBOUND_URL,
135     INBOUND_EMAIL_ID,
136     INBOUND_PHONE_NO,
137     DURATION,
138     DURATION_UOM_CODE,
139     FF_PRIORITY,
140     FF_OVERRIDE_COVER_LETTER,
141     FF_SHIPPING_METHOD,
142     FF_CARRIER,
143     CONTENT_SOURCE,
144     CC_CALL_STRATEGY,
145     CC_MANAGER_USER_ID,
146     FORECASTED_REVENUE,
147     ACTUAL_REVENUE,
148     FORECASTED_COST,
149     ACTUAL_COST,
150     FORECASTED_RESPONSE,
151     ACTUAL_RESPONSE,
152     TARGET_RESPONSE,
153     COUNTRY_CODE,
154     LANGUAGE_CODE,
155     ATTRIBUTE_CATEGORY,
156     ATTRIBUTE1,
157     ATTRIBUTE2,
158     ATTRIBUTE3,
159     ATTRIBUTE4,
160     ATTRIBUTE5,
161     ATTRIBUTE6,
162     ATTRIBUTE7,
163     ATTRIBUTE8,
164     ATTRIBUTE9,
165     ATTRIBUTE10,
166     ATTRIBUTE11,
167     ATTRIBUTE12,
168     ATTRIBUTE14,
169     ATTRIBUTE13,
170     ATTRIBUTE15,
171     CREATION_DATE,
172     CREATED_BY,
173     LAST_UPDATE_DATE,
174     LAST_UPDATED_BY,
175     LAST_UPDATE_LOGIN
176   ) values (
177     X_CAMPAIGN_ID,
178     X_OBJECT_VERSION_NUMBER,
179     X_OWNER_USER_ID,
180     X_USER_STATUS_ID,
181     X_STATUS_CODE,
182     X_STATUS_DATE,
183     X_ACTIVE_FLAG,
184     X_PRIVATE_FLAG,
185     X_PARTNER_FLAG,
186     X_TEMPLATE_FLAG,
187     X_CASCADE_SOURCE_CODE_FLAG,
188     X_INHERIT_ATTRIBUTES_FLAG,
189     X_SOURCE_CODE,
190     X_ROLLUP_TYPE,
191     X_CAMPAIGN_TYPE,
192     X_MEDIA_TYPE_CODE,
193     X_PRIORITY,
194     X_FUND_SOURCE_TYPE,
195     X_FUND_SOURCE_ID,
196     X_PARENT_CAMPAIGN_ID,
197     X_APPLICATION_ID,
198     X_QP_LIST_HEADER_ID,
199     X_MEDIA_ID,
200     X_CHANNEL_ID,
201     X_EVENT_TYPE,
202     X_ARC_CHANNEL_FROM,
203     X_DSCRIPT_NAME,
204     X_TRANSACTION_CURRENCY_CODE,
205     X_FUNCTIONAL_CURRENCY_CODE,
206     X_BUDGET_AMOUNT_TC,
207     X_BUDGET_AMOUNT_FC,
208     X_FORECASTED_PLAN_START_DATE,
209     X_FORECASTED_PLAN_END_DATE,
210     X_FORECASTED_EXEC_START_DATE,
211     X_FORECASTED_EXEC_END_DATE,
212     X_ACTUAL_PLAN_START_DATE,
213     X_ACTUAL_PLAN_END_DATE,
214     X_ACTUAL_EXEC_START_DATE,
215     X_ACTUAL_EXEC_END_DATE,
216     X_INBOUND_URL,
217     X_INBOUND_EMAIL_ID,
218     X_INBOUND_PHONE_NO,
219     X_DURATION,
220     X_DURATION_UOM_CODE,
221     X_FF_PRIORITY,
222     X_FF_OVERRIDE_COVER_LETTER,
223     X_FF_SHIPPING_METHOD,
224     X_FF_CARRIER,
225     X_CONTENT_SOURCE,
226     X_CC_CALL_STRATEGY,
227     X_CC_MANAGER_USER_ID,
228     X_FORECASTED_REVENUE,
229     X_ACTUAL_REVENUE,
230     X_FORECASTED_COST,
231     X_ACTUAL_COST,
232     X_FORECASTED_RESPONSE,
233     X_ACTUAL_RESPONSE,
234     X_TARGET_RESPONSE,
235     X_COUNTRY_CODE,
236     X_LANGUAGE_CODE,
237     X_ATTRIBUTE_CATEGORY,
238     X_ATTRIBUTE1,
239     X_ATTRIBUTE2,
240     X_ATTRIBUTE3,
241     X_ATTRIBUTE4,
242     X_ATTRIBUTE5,
243     X_ATTRIBUTE6,
244     X_ATTRIBUTE7,
245     X_ATTRIBUTE8,
246     X_ATTRIBUTE9,
247     X_ATTRIBUTE10,
248     X_ATTRIBUTE11,
249     X_ATTRIBUTE12,
250     X_ATTRIBUTE14,
251     X_ATTRIBUTE13,
252     X_ATTRIBUTE15,
253     X_CREATION_DATE,
254     X_CREATED_BY,
255     X_LAST_UPDATE_DATE,
256     X_LAST_UPDATED_BY,
257     X_LAST_UPDATE_LOGIN
258   );
259 
260   insert into AMS_CAMPAIGNS_ALL_TL (
261     CAMPAIGN_ID,
262     CREATION_DATE,
263     CREATED_BY,
264     LAST_UPDATE_DATE,
265     LAST_UPDATED_BY,
266     LAST_UPDATE_LOGIN,
267     CAMPAIGN_NAME,
268     CAMPAIGN_THEME,
269     DESCRIPTION,
270     LANGUAGE,
271     SOURCE_LANG
272   ) select
273     X_CAMPAIGN_ID,
274     X_CREATION_DATE,
275     X_CREATED_BY,
276     X_LAST_UPDATE_DATE,
277     X_LAST_UPDATED_BY,
278     X_LAST_UPDATE_LOGIN,
279     X_CAMPAIGN_NAME,
280     X_CAMPAIGN_THEME,
281     X_DESCRIPTION,
282     L.LANGUAGE_CODE,
283     userenv('LANG')
284   from FND_LANGUAGES L
285   where L.INSTALLED_FLAG in ('I', 'B')
286   and not exists
287     (select NULL
288     from AMS_CAMPAIGNS_ALL_TL T
289     where T.CAMPAIGN_ID = X_CAMPAIGN_ID
290     and T.LANGUAGE = L.LANGUAGE_CODE);
291 
292   open c;
293   fetch c into X_ROWID;
294   if (c%notfound) then
295     close c;
296     raise no_data_found;
297   end if;
298   close c;
299 
300 end INSERT_ROW;
301 
302 procedure LOCK_ROW (
303   X_CAMPAIGN_ID in NUMBER,
304   X_OBJECT_VERSION_NUMBER in NUMBER,
305   X_OWNER_USER_ID in NUMBER,
306   X_USER_STATUS_ID in NUMBER,
307   X_STATUS_CODE in VARCHAR2,
308   X_STATUS_DATE in DATE,
309   X_ACTIVE_FLAG in VARCHAR2,
310   X_PRIVATE_FLAG in VARCHAR2,
311   X_PARTNER_FLAG in VARCHAR2,
312   X_TEMPLATE_FLAG in VARCHAR2,
313   X_CASCADE_SOURCE_CODE_FLAG in VARCHAR2,
314   X_INHERIT_ATTRIBUTES_FLAG in VARCHAR2,
315   X_SOURCE_CODE in VARCHAR2,
316   X_ROLLUP_TYPE in VARCHAR2,
317   X_CAMPAIGN_TYPE in VARCHAR2,
318   X_MEDIA_TYPE_CODE in VARCHAR2,
319   X_PRIORITY in VARCHAR2,
320   X_FUND_SOURCE_TYPE in VARCHAR2,
321   X_FUND_SOURCE_ID in NUMBER,
322   X_PARENT_CAMPAIGN_ID in NUMBER,
323   X_APPLICATION_ID in NUMBER,
324   X_QP_LIST_HEADER_ID in NUMBER,
325   X_MEDIA_ID in NUMBER,
326   X_CHANNEL_ID in NUMBER,
327   X_EVENT_TYPE in VARCHAR2,
328   X_ARC_CHANNEL_FROM in VARCHAR2,
329   X_DSCRIPT_NAME in VARCHAR2,
330   X_TRANSACTION_CURRENCY_CODE in VARCHAR2,
331   X_FUNCTIONAL_CURRENCY_CODE in VARCHAR2,
332   X_BUDGET_AMOUNT_TC in NUMBER,
333   X_BUDGET_AMOUNT_FC in NUMBER,
334   X_FORECASTED_PLAN_START_DATE in DATE,
335   X_FORECASTED_PLAN_END_DATE in DATE,
336   X_FORECASTED_EXEC_START_DATE in DATE,
337   X_FORECASTED_EXEC_END_DATE in DATE,
338   X_ACTUAL_PLAN_START_DATE in DATE,
339   X_ACTUAL_PLAN_END_DATE in DATE,
340   X_ACTUAL_EXEC_START_DATE in DATE,
341   X_ACTUAL_EXEC_END_DATE in DATE,
342   X_INBOUND_URL in VARCHAR2,
343   X_INBOUND_EMAIL_ID in VARCHAR2,
344   X_INBOUND_PHONE_NO in VARCHAR2,
345   X_DURATION in NUMBER,
346   X_DURATION_UOM_CODE in VARCHAR2,
347   X_FF_PRIORITY in VARCHAR2,
348   X_FF_OVERRIDE_COVER_LETTER in NUMBER,
349   X_FF_SHIPPING_METHOD in VARCHAR2,
350   X_FF_CARRIER in VARCHAR2,
351   X_CONTENT_SOURCE in VARCHAR2,
352   X_CC_CALL_STRATEGY in VARCHAR2,
353   X_CC_MANAGER_USER_ID in NUMBER,
354   X_FORECASTED_REVENUE in NUMBER,
355   X_ACTUAL_REVENUE in NUMBER,
356   X_FORECASTED_COST in NUMBER,
357   X_ACTUAL_COST in NUMBER,
358   X_FORECASTED_RESPONSE in NUMBER,
359   X_ACTUAL_RESPONSE in NUMBER,
360   X_TARGET_RESPONSE in NUMBER,
361   X_COUNTRY_CODE in VARCHAR2,
362   X_LANGUAGE_CODE in VARCHAR2,
363   X_ATTRIBUTE_CATEGORY in VARCHAR2,
364   X_ATTRIBUTE1 in VARCHAR2,
365   X_ATTRIBUTE2 in VARCHAR2,
366   X_ATTRIBUTE3 in VARCHAR2,
367   X_ATTRIBUTE4 in VARCHAR2,
368   X_ATTRIBUTE5 in VARCHAR2,
369   X_ATTRIBUTE6 in VARCHAR2,
370   X_ATTRIBUTE7 in VARCHAR2,
371   X_ATTRIBUTE8 in VARCHAR2,
372   X_ATTRIBUTE9 in VARCHAR2,
373   X_ATTRIBUTE10 in VARCHAR2,
374   X_ATTRIBUTE11 in VARCHAR2,
375   X_ATTRIBUTE12 in VARCHAR2,
376   X_ATTRIBUTE14 in VARCHAR2,
377   X_ATTRIBUTE13 in VARCHAR2,
378   X_ATTRIBUTE15 in VARCHAR2,
379   X_CAMPAIGN_NAME in VARCHAR2,
380   X_CAMPAIGN_THEME in VARCHAR2,
381   X_DESCRIPTION in VARCHAR2
382 ) is
383   cursor c is select
384       OBJECT_VERSION_NUMBER,
385       OWNER_USER_ID,
386       USER_STATUS_ID,
387       STATUS_CODE,
388       STATUS_DATE,
389       ACTIVE_FLAG,
390       PRIVATE_FLAG,
391       PARTNER_FLAG,
392       TEMPLATE_FLAG,
393       CASCADE_SOURCE_CODE_FLAG,
394       INHERIT_ATTRIBUTES_FLAG,
395       SOURCE_CODE,
396       ROLLUP_TYPE,
397       CAMPAIGN_TYPE,
398       MEDIA_TYPE_CODE,
399       PRIORITY,
400       FUND_SOURCE_TYPE,
401       FUND_SOURCE_ID,
402       PARENT_CAMPAIGN_ID,
403       APPLICATION_ID,
404       QP_LIST_HEADER_ID,
405       MEDIA_ID,
406       CHANNEL_ID,
407       EVENT_TYPE,
408       ARC_CHANNEL_FROM,
409       DSCRIPT_NAME,
410       TRANSACTION_CURRENCY_CODE,
411       FUNCTIONAL_CURRENCY_CODE,
412       BUDGET_AMOUNT_TC,
413       BUDGET_AMOUNT_FC,
414       FORECASTED_PLAN_START_DATE,
415       FORECASTED_PLAN_END_DATE,
416       FORECASTED_EXEC_START_DATE,
417       FORECASTED_EXEC_END_DATE,
418       ACTUAL_PLAN_START_DATE,
419       ACTUAL_PLAN_END_DATE,
420       ACTUAL_EXEC_START_DATE,
421       ACTUAL_EXEC_END_DATE,
422       INBOUND_URL,
423       INBOUND_EMAIL_ID,
424       INBOUND_PHONE_NO,
425       DURATION,
426       DURATION_UOM_CODE,
427       FF_PRIORITY,
428       FF_OVERRIDE_COVER_LETTER,
429       FF_SHIPPING_METHOD,
430       FF_CARRIER,
431       CONTENT_SOURCE,
432       CC_CALL_STRATEGY,
433       CC_MANAGER_USER_ID,
434       FORECASTED_REVENUE,
435       ACTUAL_REVENUE,
436       FORECASTED_COST,
437       ACTUAL_COST,
438       FORECASTED_RESPONSE,
439       ACTUAL_RESPONSE,
440       TARGET_RESPONSE,
441       COUNTRY_CODE,
442       LANGUAGE_CODE,
443       ATTRIBUTE_CATEGORY,
444       ATTRIBUTE1,
445       ATTRIBUTE2,
446       ATTRIBUTE3,
447       ATTRIBUTE4,
448       ATTRIBUTE5,
449       ATTRIBUTE6,
450       ATTRIBUTE7,
451       ATTRIBUTE8,
452       ATTRIBUTE9,
453       ATTRIBUTE10,
454       ATTRIBUTE11,
455       ATTRIBUTE12,
456       ATTRIBUTE14,
457       ATTRIBUTE13,
458       ATTRIBUTE15
459     from AMS_CAMPAIGNS_ALL_B
460     where CAMPAIGN_ID = X_CAMPAIGN_ID
461     for update of CAMPAIGN_ID nowait;
462   recinfo c%rowtype;
463 
464   cursor c1 is select
465       CAMPAIGN_NAME,
466       CAMPAIGN_THEME,
467       DESCRIPTION,
468       decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
469     from AMS_CAMPAIGNS_ALL_TL
470     where CAMPAIGN_ID = X_CAMPAIGN_ID
471     and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
472     for update of CAMPAIGN_ID nowait;
473 begin
474   open c;
475   fetch c into recinfo;
476   if (c%notfound) then
477     close c;
478     fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
479     app_exception.raise_exception;
480   end if;
481   close c;
482   if (    ((recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
483            OR ((recinfo.OBJECT_VERSION_NUMBER is null) AND (X_OBJECT_VERSION_NUMBER is null)))
484       AND (recinfo.OWNER_USER_ID = X_OWNER_USER_ID)
485       AND (recinfo.USER_STATUS_ID = X_USER_STATUS_ID)
486       AND (recinfo.STATUS_CODE = X_STATUS_CODE)
487       AND (recinfo.STATUS_DATE = X_STATUS_DATE)
488       AND (recinfo.ACTIVE_FLAG = X_ACTIVE_FLAG)
489       AND (recinfo.PRIVATE_FLAG = X_PRIVATE_FLAG)
490       AND (recinfo.PARTNER_FLAG = X_PARTNER_FLAG)
491       AND (recinfo.TEMPLATE_FLAG = X_TEMPLATE_FLAG)
492       AND (recinfo.CASCADE_SOURCE_CODE_FLAG = X_CASCADE_SOURCE_CODE_FLAG)
496       AND ((recinfo.CAMPAIGN_TYPE = X_CAMPAIGN_TYPE)
493       AND (recinfo.INHERIT_ATTRIBUTES_FLAG = X_INHERIT_ATTRIBUTES_FLAG)
494       AND (recinfo.SOURCE_CODE = X_SOURCE_CODE)
495       AND (recinfo.ROLLUP_TYPE = X_ROLLUP_TYPE)
497            OR ((recinfo.CAMPAIGN_TYPE is null) AND (X_CAMPAIGN_TYPE is null)))
498       AND ((recinfo.MEDIA_TYPE_CODE = X_MEDIA_TYPE_CODE)
499            OR ((recinfo.MEDIA_TYPE_CODE is null) AND (X_MEDIA_TYPE_CODE is null)))
500       AND ((recinfo.PRIORITY = X_PRIORITY)
501            OR ((recinfo.PRIORITY is null) AND (X_PRIORITY is null)))
502       AND ((recinfo.FUND_SOURCE_TYPE = X_FUND_SOURCE_TYPE)
503            OR ((recinfo.FUND_SOURCE_TYPE is null) AND (X_FUND_SOURCE_TYPE is null)))
504       AND ((recinfo.FUND_SOURCE_ID = X_FUND_SOURCE_ID)
505            OR ((recinfo.FUND_SOURCE_ID is null) AND (X_FUND_SOURCE_ID is null)))
506       AND ((recinfo.PARENT_CAMPAIGN_ID = X_PARENT_CAMPAIGN_ID)
507            OR ((recinfo.PARENT_CAMPAIGN_ID is null) AND (X_PARENT_CAMPAIGN_ID is null)))
508       AND (recinfo.APPLICATION_ID = X_APPLICATION_ID)
509       AND ((recinfo.QP_LIST_HEADER_ID = X_QP_LIST_HEADER_ID)
510            OR ((recinfo.QP_LIST_HEADER_ID is null) AND (X_QP_LIST_HEADER_ID is null)))
511       AND ((recinfo.MEDIA_ID = X_MEDIA_ID)
512            OR ((recinfo.MEDIA_ID is null) AND (X_MEDIA_ID is null)))
513       AND ((recinfo.CHANNEL_ID = X_CHANNEL_ID)
514            OR ((recinfo.CHANNEL_ID is null) AND (X_CHANNEL_ID is null)))
515       AND ((recinfo.EVENT_TYPE = X_EVENT_TYPE)
516            OR ((recinfo.EVENT_TYPE is null) AND (X_EVENT_TYPE is null)))
517       AND ((recinfo.ARC_CHANNEL_FROM = X_ARC_CHANNEL_FROM)
518            OR ((recinfo.ARC_CHANNEL_FROM is null) AND (X_ARC_CHANNEL_FROM is null)))
519       AND ((recinfo.DSCRIPT_NAME = X_DSCRIPT_NAME)
520            OR ((recinfo.DSCRIPT_NAME is null) AND (X_DSCRIPT_NAME is null)))
521       AND ((recinfo.TRANSACTION_CURRENCY_CODE = X_TRANSACTION_CURRENCY_CODE)
522            OR ((recinfo.TRANSACTION_CURRENCY_CODE is null) AND (X_TRANSACTION_CURRENCY_CODE is null)))
523       AND ((recinfo.FUNCTIONAL_CURRENCY_CODE = X_FUNCTIONAL_CURRENCY_CODE)
524            OR ((recinfo.FUNCTIONAL_CURRENCY_CODE is null) AND (X_FUNCTIONAL_CURRENCY_CODE is null)))
525       AND ((recinfo.BUDGET_AMOUNT_TC = X_BUDGET_AMOUNT_TC)
526            OR ((recinfo.BUDGET_AMOUNT_TC is null) AND (X_BUDGET_AMOUNT_TC is null)))
527       AND ((recinfo.BUDGET_AMOUNT_FC = X_BUDGET_AMOUNT_FC)
528            OR ((recinfo.BUDGET_AMOUNT_FC is null) AND (X_BUDGET_AMOUNT_FC is null)))
529       AND ((recinfo.FORECASTED_PLAN_START_DATE = X_FORECASTED_PLAN_START_DATE)
530            OR ((recinfo.FORECASTED_PLAN_START_DATE is null) AND (X_FORECASTED_PLAN_START_DATE is null)))
531       AND ((recinfo.FORECASTED_PLAN_END_DATE = X_FORECASTED_PLAN_END_DATE)
532            OR ((recinfo.FORECASTED_PLAN_END_DATE is null) AND (X_FORECASTED_PLAN_END_DATE is null)))
533       AND ((recinfo.FORECASTED_EXEC_START_DATE = X_FORECASTED_EXEC_START_DATE)
534            OR ((recinfo.FORECASTED_EXEC_START_DATE is null) AND (X_FORECASTED_EXEC_START_DATE is null)))
535       AND ((recinfo.FORECASTED_EXEC_END_DATE = X_FORECASTED_EXEC_END_DATE)
536            OR ((recinfo.FORECASTED_EXEC_END_DATE is null) AND (X_FORECASTED_EXEC_END_DATE is null)))
537       AND ((recinfo.ACTUAL_PLAN_START_DATE = X_ACTUAL_PLAN_START_DATE)
538            OR ((recinfo.ACTUAL_PLAN_START_DATE is null) AND (X_ACTUAL_PLAN_START_DATE is null)))
539       AND ((recinfo.ACTUAL_PLAN_END_DATE = X_ACTUAL_PLAN_END_DATE)
540            OR ((recinfo.ACTUAL_PLAN_END_DATE is null) AND (X_ACTUAL_PLAN_END_DATE is null)))
541       AND ((recinfo.ACTUAL_EXEC_START_DATE = X_ACTUAL_EXEC_START_DATE)
542            OR ((recinfo.ACTUAL_EXEC_START_DATE is null) AND (X_ACTUAL_EXEC_START_DATE is null)))
543       AND ((recinfo.ACTUAL_EXEC_END_DATE = X_ACTUAL_EXEC_END_DATE)
544            OR ((recinfo.ACTUAL_EXEC_END_DATE is null) AND (X_ACTUAL_EXEC_END_DATE is null)))
545       AND ((recinfo.INBOUND_URL = X_INBOUND_URL)
546            OR ((recinfo.INBOUND_URL is null) AND (X_INBOUND_URL is null)))
547       AND ((recinfo.INBOUND_EMAIL_ID = X_INBOUND_EMAIL_ID)
548            OR ((recinfo.INBOUND_EMAIL_ID is null) AND (X_INBOUND_EMAIL_ID is null)))
549       AND ((recinfo.INBOUND_PHONE_NO = X_INBOUND_PHONE_NO)
550            OR ((recinfo.INBOUND_PHONE_NO is null) AND (X_INBOUND_PHONE_NO is null)))
551       AND ((recinfo.DURATION = X_DURATION)
552            OR ((recinfo.DURATION is null) AND (X_DURATION is null)))
553       AND ((recinfo.DURATION_UOM_CODE = X_DURATION_UOM_CODE)
554            OR ((recinfo.DURATION_UOM_CODE is null) AND (X_DURATION_UOM_CODE is null)))
555       AND ((recinfo.FF_PRIORITY = X_FF_PRIORITY)
556            OR ((recinfo.FF_PRIORITY is null) AND (X_FF_PRIORITY is null)))
557       AND ((recinfo.FF_OVERRIDE_COVER_LETTER = X_FF_OVERRIDE_COVER_LETTER)
558            OR ((recinfo.FF_OVERRIDE_COVER_LETTER is null) AND (X_FF_OVERRIDE_COVER_LETTER is null)))
559       AND ((recinfo.FF_SHIPPING_METHOD = X_FF_SHIPPING_METHOD)
560            OR ((recinfo.FF_SHIPPING_METHOD is null) AND (X_FF_SHIPPING_METHOD is null)))
561       AND ((recinfo.FF_CARRIER = X_FF_CARRIER)
562            OR ((recinfo.FF_CARRIER is null) AND (X_FF_CARRIER is null)))
563       AND ((recinfo.CONTENT_SOURCE = X_CONTENT_SOURCE)
564            OR ((recinfo.CONTENT_SOURCE is null) AND (X_CONTENT_SOURCE is null)))
565       AND ((recinfo.CC_CALL_STRATEGY = X_CC_CALL_STRATEGY)
566            OR ((recinfo.CC_CALL_STRATEGY is null) AND (X_CC_CALL_STRATEGY is null)))
567       AND ((recinfo.CC_MANAGER_USER_ID = X_CC_MANAGER_USER_ID)
568            OR ((recinfo.CC_MANAGER_USER_ID is null) AND (X_CC_MANAGER_USER_ID is null)))
572            OR ((recinfo.ACTUAL_REVENUE is null) AND (X_ACTUAL_REVENUE is null)))
569       AND ((recinfo.FORECASTED_REVENUE = X_FORECASTED_REVENUE)
570            OR ((recinfo.FORECASTED_REVENUE is null) AND (X_FORECASTED_REVENUE is null)))
571       AND ((recinfo.ACTUAL_REVENUE = X_ACTUAL_REVENUE)
573       AND ((recinfo.FORECASTED_COST = X_FORECASTED_COST)
574            OR ((recinfo.FORECASTED_COST is null) AND (X_FORECASTED_COST is null)))
575       AND ((recinfo.ACTUAL_COST = X_ACTUAL_COST)
576            OR ((recinfo.ACTUAL_COST is null) AND (X_ACTUAL_COST is null)))
577       AND ((recinfo.FORECASTED_RESPONSE = X_FORECASTED_RESPONSE)
578            OR ((recinfo.FORECASTED_RESPONSE is null) AND (X_FORECASTED_RESPONSE is null)))
579       AND ((recinfo.ACTUAL_RESPONSE = X_ACTUAL_RESPONSE)
580            OR ((recinfo.ACTUAL_RESPONSE is null) AND (X_ACTUAL_RESPONSE is null)))
581       AND ((recinfo.TARGET_RESPONSE = X_TARGET_RESPONSE)
582            OR ((recinfo.TARGET_RESPONSE is null) AND (X_TARGET_RESPONSE is null)))
583       AND ((recinfo.COUNTRY_CODE = X_COUNTRY_CODE)
584            OR ((recinfo.COUNTRY_CODE is null) AND (X_COUNTRY_CODE is null)))
585       AND ((recinfo.LANGUAGE_CODE = X_LANGUAGE_CODE)
586            OR ((recinfo.LANGUAGE_CODE is null) AND (X_LANGUAGE_CODE is null)))
587       AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
588            OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
589       AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
590            OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
591       AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
592            OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
593       AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
594            OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
595       AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
596            OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
597       AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
598            OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
599       AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
600            OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
601       AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
602            OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
603       AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
604            OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
605       AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
606            OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
607       AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
608            OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
609       AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
610            OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
611       AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
612            OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
613       AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
614            OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
615       AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
616            OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
617       AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
618            OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
619   ) then
620     null;
621   else
622     fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
623     app_exception.raise_exception;
624   end if;
625 
626   for tlinfo in c1 loop
627     if (tlinfo.BASELANG = 'Y') then
628       if (    (tlinfo.CAMPAIGN_NAME = X_CAMPAIGN_NAME)
629           AND ((tlinfo.CAMPAIGN_THEME = X_CAMPAIGN_THEME)
630                OR ((tlinfo.CAMPAIGN_THEME is null) AND (X_CAMPAIGN_THEME is null)))
631           AND ((tlinfo.DESCRIPTION = X_DESCRIPTION)
632                OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
633       ) then
634         null;
635       else
636         fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
637         app_exception.raise_exception;
638       end if;
639     end if;
640   end loop;
641   return;
642 end LOCK_ROW;
643 
644 procedure UPDATE_ROW (
645   X_CAMPAIGN_ID in NUMBER,
646   X_OBJECT_VERSION_NUMBER in NUMBER,
647   X_OWNER_USER_ID in NUMBER,
648   X_USER_STATUS_ID in NUMBER,
649   X_STATUS_CODE in VARCHAR2,
650   X_STATUS_DATE in DATE,
651   X_ACTIVE_FLAG in VARCHAR2,
652   X_PRIVATE_FLAG in VARCHAR2,
653   X_PARTNER_FLAG in VARCHAR2,
654   X_TEMPLATE_FLAG in VARCHAR2,
655   X_CASCADE_SOURCE_CODE_FLAG in VARCHAR2,
656   X_INHERIT_ATTRIBUTES_FLAG in VARCHAR2,
657   X_SOURCE_CODE in VARCHAR2,
658   X_ROLLUP_TYPE in VARCHAR2,
659   X_CAMPAIGN_TYPE in VARCHAR2,
660   X_MEDIA_TYPE_CODE in VARCHAR2,
661   X_PRIORITY in VARCHAR2,
662   X_FUND_SOURCE_TYPE in VARCHAR2,
663   X_FUND_SOURCE_ID in NUMBER,
664   X_PARENT_CAMPAIGN_ID in NUMBER,
665   X_APPLICATION_ID in NUMBER,
666   X_QP_LIST_HEADER_ID in NUMBER,
667   X_MEDIA_ID in NUMBER,
668   X_CHANNEL_ID in NUMBER,
669   X_EVENT_TYPE in VARCHAR2,
670   X_ARC_CHANNEL_FROM in VARCHAR2,
671   X_DSCRIPT_NAME in VARCHAR2,
672   X_TRANSACTION_CURRENCY_CODE in VARCHAR2,
673   X_FUNCTIONAL_CURRENCY_CODE in VARCHAR2,
674   X_BUDGET_AMOUNT_TC in NUMBER,
675   X_BUDGET_AMOUNT_FC in NUMBER,
676   X_FORECASTED_PLAN_START_DATE in DATE,
677   X_FORECASTED_PLAN_END_DATE in DATE,
678   X_FORECASTED_EXEC_START_DATE in DATE,
679   X_FORECASTED_EXEC_END_DATE in DATE,
680   X_ACTUAL_PLAN_START_DATE in DATE,
684   X_INBOUND_URL in VARCHAR2,
681   X_ACTUAL_PLAN_END_DATE in DATE,
682   X_ACTUAL_EXEC_START_DATE in DATE,
683   X_ACTUAL_EXEC_END_DATE in DATE,
685   X_INBOUND_EMAIL_ID in VARCHAR2,
686   X_INBOUND_PHONE_NO in VARCHAR2,
687   X_DURATION in NUMBER,
688   X_DURATION_UOM_CODE in VARCHAR2,
689   X_FF_PRIORITY in VARCHAR2,
690   X_FF_OVERRIDE_COVER_LETTER in NUMBER,
691   X_FF_SHIPPING_METHOD in VARCHAR2,
692   X_FF_CARRIER in VARCHAR2,
693   X_CONTENT_SOURCE in VARCHAR2,
694   X_CC_CALL_STRATEGY in VARCHAR2,
695   X_CC_MANAGER_USER_ID in NUMBER,
696   X_FORECASTED_REVENUE in NUMBER,
697   X_ACTUAL_REVENUE in NUMBER,
698   X_FORECASTED_COST in NUMBER,
699   X_ACTUAL_COST in NUMBER,
700   X_FORECASTED_RESPONSE in NUMBER,
701   X_ACTUAL_RESPONSE in NUMBER,
702   X_TARGET_RESPONSE in NUMBER,
703   X_COUNTRY_CODE in VARCHAR2,
704   X_LANGUAGE_CODE in VARCHAR2,
705   X_ATTRIBUTE_CATEGORY in VARCHAR2,
706   X_ATTRIBUTE1 in VARCHAR2,
707   X_ATTRIBUTE2 in VARCHAR2,
708   X_ATTRIBUTE3 in VARCHAR2,
709   X_ATTRIBUTE4 in VARCHAR2,
710   X_ATTRIBUTE5 in VARCHAR2,
711   X_ATTRIBUTE6 in VARCHAR2,
712   X_ATTRIBUTE7 in VARCHAR2,
713   X_ATTRIBUTE8 in VARCHAR2,
714   X_ATTRIBUTE9 in VARCHAR2,
715   X_ATTRIBUTE10 in VARCHAR2,
716   X_ATTRIBUTE11 in VARCHAR2,
717   X_ATTRIBUTE12 in VARCHAR2,
718   X_ATTRIBUTE14 in VARCHAR2,
719   X_ATTRIBUTE13 in VARCHAR2,
720   X_ATTRIBUTE15 in VARCHAR2,
721   X_CAMPAIGN_NAME in VARCHAR2,
722   X_CAMPAIGN_THEME in VARCHAR2,
723   X_DESCRIPTION in VARCHAR2,
724   X_LAST_UPDATE_DATE in DATE,
725   X_LAST_UPDATED_BY in NUMBER,
726   X_LAST_UPDATE_LOGIN in NUMBER
727 ) is
728 begin
729   update AMS_CAMPAIGNS_ALL_B set
730     OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
731     OWNER_USER_ID = X_OWNER_USER_ID,
732     USER_STATUS_ID = X_USER_STATUS_ID,
733     STATUS_CODE = X_STATUS_CODE,
734     STATUS_DATE = X_STATUS_DATE,
735     ACTIVE_FLAG = X_ACTIVE_FLAG,
736     PRIVATE_FLAG = X_PRIVATE_FLAG,
737     PARTNER_FLAG = X_PARTNER_FLAG,
738     TEMPLATE_FLAG = X_TEMPLATE_FLAG,
739     CASCADE_SOURCE_CODE_FLAG = X_CASCADE_SOURCE_CODE_FLAG,
740     INHERIT_ATTRIBUTES_FLAG = X_INHERIT_ATTRIBUTES_FLAG,
741     SOURCE_CODE = X_SOURCE_CODE,
742     ROLLUP_TYPE = X_ROLLUP_TYPE,
743     CAMPAIGN_TYPE = X_CAMPAIGN_TYPE,
744     MEDIA_TYPE_CODE = X_MEDIA_TYPE_CODE,
745     PRIORITY = X_PRIORITY,
746     FUND_SOURCE_TYPE = X_FUND_SOURCE_TYPE,
747     FUND_SOURCE_ID = X_FUND_SOURCE_ID,
748     PARENT_CAMPAIGN_ID = X_PARENT_CAMPAIGN_ID,
749     APPLICATION_ID = X_APPLICATION_ID,
750     QP_LIST_HEADER_ID = X_QP_LIST_HEADER_ID,
751     MEDIA_ID = X_MEDIA_ID,
752     CHANNEL_ID = X_CHANNEL_ID,
753     EVENT_TYPE = X_EVENT_TYPE,
754     ARC_CHANNEL_FROM = X_ARC_CHANNEL_FROM,
755     DSCRIPT_NAME = X_DSCRIPT_NAME,
756     TRANSACTION_CURRENCY_CODE = X_TRANSACTION_CURRENCY_CODE,
757     FUNCTIONAL_CURRENCY_CODE = X_FUNCTIONAL_CURRENCY_CODE,
758     BUDGET_AMOUNT_TC = X_BUDGET_AMOUNT_TC,
759     BUDGET_AMOUNT_FC = X_BUDGET_AMOUNT_FC,
760     FORECASTED_PLAN_START_DATE = X_FORECASTED_PLAN_START_DATE,
761     FORECASTED_PLAN_END_DATE = X_FORECASTED_PLAN_END_DATE,
762     FORECASTED_EXEC_START_DATE = X_FORECASTED_EXEC_START_DATE,
763     FORECASTED_EXEC_END_DATE = X_FORECASTED_EXEC_END_DATE,
764     ACTUAL_PLAN_START_DATE = X_ACTUAL_PLAN_START_DATE,
765     ACTUAL_PLAN_END_DATE = X_ACTUAL_PLAN_END_DATE,
766     ACTUAL_EXEC_START_DATE = X_ACTUAL_EXEC_START_DATE,
767     ACTUAL_EXEC_END_DATE = X_ACTUAL_EXEC_END_DATE,
768     INBOUND_URL = X_INBOUND_URL,
769     INBOUND_EMAIL_ID = X_INBOUND_EMAIL_ID,
770     INBOUND_PHONE_NO = X_INBOUND_PHONE_NO,
771     DURATION = X_DURATION,
772     DURATION_UOM_CODE = X_DURATION_UOM_CODE,
773     FF_PRIORITY = X_FF_PRIORITY,
774     FF_OVERRIDE_COVER_LETTER = X_FF_OVERRIDE_COVER_LETTER,
775     FF_SHIPPING_METHOD = X_FF_SHIPPING_METHOD,
776     FF_CARRIER = X_FF_CARRIER,
777     CONTENT_SOURCE = X_CONTENT_SOURCE,
778     CC_CALL_STRATEGY = X_CC_CALL_STRATEGY,
779     CC_MANAGER_USER_ID = X_CC_MANAGER_USER_ID,
780     FORECASTED_REVENUE = X_FORECASTED_REVENUE,
781     ACTUAL_REVENUE = X_ACTUAL_REVENUE,
782     FORECASTED_COST = X_FORECASTED_COST,
783     ACTUAL_COST = X_ACTUAL_COST,
784     FORECASTED_RESPONSE = X_FORECASTED_RESPONSE,
785     ACTUAL_RESPONSE = X_ACTUAL_RESPONSE,
786     TARGET_RESPONSE = X_TARGET_RESPONSE,
787     COUNTRY_CODE = X_COUNTRY_CODE,
788     LANGUAGE_CODE = X_LANGUAGE_CODE,
789     ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
790     ATTRIBUTE1 = X_ATTRIBUTE1,
791     ATTRIBUTE2 = X_ATTRIBUTE2,
792     ATTRIBUTE3 = X_ATTRIBUTE3,
793     ATTRIBUTE4 = X_ATTRIBUTE4,
794     ATTRIBUTE5 = X_ATTRIBUTE5,
795     ATTRIBUTE6 = X_ATTRIBUTE6,
796     ATTRIBUTE7 = X_ATTRIBUTE7,
797     ATTRIBUTE8 = X_ATTRIBUTE8,
798     ATTRIBUTE9 = X_ATTRIBUTE9,
799     ATTRIBUTE10 = X_ATTRIBUTE10,
800     ATTRIBUTE11 = X_ATTRIBUTE11,
801     ATTRIBUTE12 = X_ATTRIBUTE12,
802     ATTRIBUTE14 = X_ATTRIBUTE14,
803     ATTRIBUTE13 = X_ATTRIBUTE13,
804     ATTRIBUTE15 = X_ATTRIBUTE15,
805     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
806     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
807     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
808   where CAMPAIGN_ID = X_CAMPAIGN_ID;
809 
810   if (sql%notfound) then
811     raise no_data_found;
812   end if;
813 
814   update AMS_CAMPAIGNS_ALL_TL set
815     CAMPAIGN_NAME = X_CAMPAIGN_NAME,
816     CAMPAIGN_THEME = X_CAMPAIGN_THEME,
817     DESCRIPTION = X_DESCRIPTION,
821     SOURCE_LANG = userenv('LANG')
818     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
819     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
820     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
822   where CAMPAIGN_ID = X_CAMPAIGN_ID
823   and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
824 
825   if (sql%notfound) then
826     raise no_data_found;
827   end if;
828 end UPDATE_ROW;
829 
830 procedure DELETE_ROW (
831   X_CAMPAIGN_ID in NUMBER
832 ) is
833 begin
834   delete from AMS_CAMPAIGNS_ALL_TL
835   where CAMPAIGN_ID = X_CAMPAIGN_ID;
836 
837   if (sql%notfound) then
838     raise no_data_found;
839   end if;
840 
841   delete from AMS_CAMPAIGNS_ALL_B
842   where CAMPAIGN_ID = X_CAMPAIGN_ID;
843 
844   if (sql%notfound) then
845     raise no_data_found;
846   end if;
847 end DELETE_ROW;
848 
849 procedure ADD_LANGUAGE
850 is
851 begin
852   delete from AMS_CAMPAIGNS_ALL_TL T
853   where not exists
854     (select NULL
855     from AMS_CAMPAIGNS_ALL_B B
856     where B.CAMPAIGN_ID = T.CAMPAIGN_ID
857     );
858 
859   update AMS_CAMPAIGNS_ALL_TL T set (
860       CAMPAIGN_NAME,
861       CAMPAIGN_THEME,
862       DESCRIPTION
863     ) = (select
864       B.CAMPAIGN_NAME,
865       B.CAMPAIGN_THEME,
866       B.DESCRIPTION
867     from AMS_CAMPAIGNS_ALL_TL B
868     where B.CAMPAIGN_ID = T.CAMPAIGN_ID
869     and B.LANGUAGE = T.SOURCE_LANG)
870   where (
871       T.CAMPAIGN_ID,
872       T.LANGUAGE
873   ) in (select
874       SUBT.CAMPAIGN_ID,
875       SUBT.LANGUAGE
876     from AMS_CAMPAIGNS_ALL_TL SUBB, AMS_CAMPAIGNS_ALL_TL SUBT
877     where SUBB.CAMPAIGN_ID = SUBT.CAMPAIGN_ID
878     and SUBB.LANGUAGE = SUBT.SOURCE_LANG
879     and (SUBB.CAMPAIGN_NAME <> SUBT.CAMPAIGN_NAME
880       or SUBB.CAMPAIGN_THEME <> SUBT.CAMPAIGN_THEME
881       or (SUBB.CAMPAIGN_THEME is null and SUBT.CAMPAIGN_THEME is not null)
882       or (SUBB.CAMPAIGN_THEME is not null and SUBT.CAMPAIGN_THEME is null)
883       or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
884       or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
885       or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
886   ));
887 
888   insert into AMS_CAMPAIGNS_ALL_TL (
889     CAMPAIGN_ID,
890     CREATION_DATE,
891     CREATED_BY,
892     LAST_UPDATE_DATE,
893     LAST_UPDATED_BY,
894     LAST_UPDATE_LOGIN,
895     CAMPAIGN_NAME,
896     CAMPAIGN_THEME,
897     DESCRIPTION,
898     LANGUAGE,
899     SOURCE_LANG
900   ) select
901     B.CAMPAIGN_ID,
902     B.CREATION_DATE,
903     B.CREATED_BY,
904     B.LAST_UPDATE_DATE,
905     B.LAST_UPDATED_BY,
906     B.LAST_UPDATE_LOGIN,
907     B.CAMPAIGN_NAME,
908     B.CAMPAIGN_THEME,
909     B.DESCRIPTION,
910     L.LANGUAGE_CODE,
911     B.SOURCE_LANG
912   from AMS_CAMPAIGNS_ALL_TL B, FND_LANGUAGES L
913   where L.INSTALLED_FLAG in ('I', 'B')
914   and B.LANGUAGE = userenv('LANG')
915   and not exists
916     (select NULL
917     from AMS_CAMPAIGNS_ALL_TL T
918     where T.CAMPAIGN_ID = B.CAMPAIGN_ID
919     and T.LANGUAGE = L.LANGUAGE_CODE);
920 end ADD_LANGUAGE;
921 
922 procedure TRANSLATE_ROW(
923   X_CAMPAIGN_ID in NUMBER,
924   X_CAMPAIGN_NAME in VARCHAR2,
925   X_CAMPAIGN_THEME in VARCHAR2,
926   X_DESCRIPTION in VARCHAR2,
927   X_OWNER in VARCHAR2
928 )
929 IS
930 BEGIN
931   update AMS_CAMPAIGNS_ALL_TL set
932     campaign_name = nvl(x_campaign_name, campaign_name),
933     campaign_theme = nvl(x_campaign_theme, campaign_theme),
934     description = nvl(x_description, description),
935     source_lang = userenv('LANG'),
936     last_update_date = sysdate,
937     last_updated_by = decode(x_owner, 'SEED', 1, 0),
938     last_update_login = 0
939   where campaign_id = x_campaign_id
940   and userenv('LANG') in (language, source_lang);
941 END TRANSLATE_ROW;
942 
943 procedure  LOAD_ROW(
944   X_CAMPAIGN_ID in NUMBER,
945   X_OBJECT_VERSION_NUMBER in NUMBER,
946   X_OWNER_USER_ID in NUMBER,
947   X_USER_STATUS_ID in NUMBER,
948   X_STATUS_CODE in VARCHAR2,
949   X_STATUS_DATE in DATE,
950   X_ACTIVE_FLAG in VARCHAR2,
951   X_PRIVATE_FLAG in VARCHAR2,
952   X_PARTNER_FLAG in VARCHAR2,
953   X_TEMPLATE_FLAG in VARCHAR2,
954   X_CASCADE_SOURCE_CODE_FLAG in VARCHAR2,
955   X_INHERIT_ATTRIBUTES_FLAG in VARCHAR2,
956   X_SOURCE_CODE in VARCHAR2,
957   X_ROLLUP_TYPE in VARCHAR2,
958   X_CAMPAIGN_TYPE in VARCHAR2,
959   X_MEDIA_TYPE_CODE in VARCHAR2,
960   X_PRIORITY in VARCHAR2,
961   X_FUND_SOURCE_TYPE in VARCHAR2,
962   X_FUND_SOURCE_ID in NUMBER,
963   X_PARENT_CAMPAIGN_ID in NUMBER,
964   X_APPLICATION_ID in NUMBER,
965   X_QP_LIST_HEADER_ID in NUMBER,
966   X_MEDIA_ID in NUMBER,
967   X_CHANNEL_ID in NUMBER,
968   X_EVENT_TYPE in VARCHAR2,
969   X_ARC_CHANNEL_FROM in VARCHAR2,
970   X_DSCRIPT_NAME in VARCHAR2,
971   X_TRANSACTION_CURRENCY_CODE in VARCHAR2,
972   X_FUNCTIONAL_CURRENCY_CODE in VARCHAR2,
973   X_BUDGET_AMOUNT_TC in NUMBER,
977   X_FORECASTED_EXEC_START_DATE in DATE,
974   X_BUDGET_AMOUNT_FC in NUMBER,
975   X_FORECASTED_PLAN_START_DATE in DATE,
976   X_FORECASTED_PLAN_END_DATE in DATE,
978   X_FORECASTED_EXEC_END_DATE in DATE,
979   X_ACTUAL_PLAN_START_DATE in DATE,
980   X_ACTUAL_PLAN_END_DATE in DATE,
981   X_ACTUAL_EXEC_START_DATE in DATE,
982   X_ACTUAL_EXEC_END_DATE in DATE,
983   X_INBOUND_URL in VARCHAR2,
984   X_INBOUND_EMAIL_ID in VARCHAR2,
985   X_INBOUND_PHONE_NO in VARCHAR2,
986   X_DURATION in NUMBER,
987   X_DURATION_UOM_CODE in VARCHAR2,
988   X_FF_PRIORITY in VARCHAR2,
989   X_FF_OVERRIDE_COVER_LETTER in NUMBER,
990   X_FF_SHIPPING_METHOD in VARCHAR2,
991   X_FF_CARRIER in VARCHAR2,
992   X_CONTENT_SOURCE in VARCHAR2,
993   X_CC_CALL_STRATEGY in VARCHAR2,
994   X_CC_MANAGER_USER_ID in NUMBER,
995   X_FORECASTED_REVENUE in NUMBER,
996   X_ACTUAL_REVENUE in NUMBER,
997   X_FORECASTED_COST in NUMBER,
998   X_ACTUAL_COST in NUMBER,
999   X_FORECASTED_RESPONSE in NUMBER,
1000   X_ACTUAL_RESPONSE in NUMBER,
1001   X_TARGET_RESPONSE in NUMBER,
1002   X_COUNTRY_CODE in VARCHAR2,
1003   X_LANGUAGE_CODE in VARCHAR2,
1004   X_ATTRIBUTE_CATEGORY in VARCHAR2,
1005   X_ATTRIBUTE1 in VARCHAR2,
1006   X_ATTRIBUTE2 in VARCHAR2,
1007   X_ATTRIBUTE3 in VARCHAR2,
1008   X_ATTRIBUTE4 in VARCHAR2,
1009   X_ATTRIBUTE5 in VARCHAR2,
1010   X_ATTRIBUTE6 in VARCHAR2,
1011   X_ATTRIBUTE7 in VARCHAR2,
1012   X_ATTRIBUTE8 in VARCHAR2,
1013   X_ATTRIBUTE9 in VARCHAR2,
1014   X_ATTRIBUTE10 in VARCHAR2,
1015   X_ATTRIBUTE11 in VARCHAR2,
1016   X_ATTRIBUTE12 in VARCHAR2,
1017   X_ATTRIBUTE14 in VARCHAR2,
1018   X_ATTRIBUTE13 in VARCHAR2,
1019   X_ATTRIBUTE15 in VARCHAR2,
1020   X_CAMPAIGN_NAME in VARCHAR2,
1021   X_CAMPAIGN_THEME in VARCHAR2,
1022   X_DESCRIPTION in VARCHAR2,
1023   X_OWNER in VARCHAR2
1024 )
1025 IS
1026 
1027   l_user_id    number := 0;
1028   l_version    number;
1029   l_camp_id    number;
1030   l_dummy_char varchar2(1);
1031   l_row_id     varchar2(100);
1032 
1033   cursor c_version is
1034   select object_version_number
1035   from   ams_campaigns_all_b
1036   where  campaign_id = X_CAMPAIGN_ID;
1037 
1038   cursor c_camp_exists is
1039   select 'x'
1040   from   ams_campaigns_all_b
1041   where  campaign_id = X_CAMPAIGN_ID;
1042 
1043   cursor c_camp_id is
1044   select ams_campaigns_all_b_s.nextval
1045   from   dual;
1046 
1047 BEGIN
1048 
1049   if X_OWNER = 'SEED' then
1050     l_user_id := 1;
1051   end if;
1052 
1053   open c_camp_exists;
1054   fetch c_camp_exists into l_dummy_char;
1055   if c_camp_exists%notfound then
1056     close c_camp_exists;
1057     if X_CAMPAIGN_ID is not null then
1058 	 l_camp_id := X_CAMPAIGN_ID;
1059     else
1060       open c_camp_id;
1061       fetch c_camp_id into l_camp_id;
1062       close c_camp_id;
1063     end if;
1064     l_version := 1;
1065     AMS_CAMPAIGNS_ALL_PKG.INSERT_ROW(
1066       X_ROWID	=> l_row_id,
1067       X_CAMPAIGN_ID => l_camp_id,
1068       X_OBJECT_VERSION_NUMBER => l_version,
1069       X_OWNER_USER_ID => X_OWNER_USER_ID,
1070       X_USER_STATUS_ID => X_USER_STATUS_ID,
1071       X_STATUS_CODE => X_STATUS_CODE,
1072       X_STATUS_DATE => X_STATUS_DATE,
1073       X_ACTIVE_FLAG => X_ACTIVE_FLAG,
1074       X_PRIVATE_FLAG => X_PRIVATE_FLAG,
1075       X_PARTNER_FLAG => X_PARTNER_FLAG,
1076       X_TEMPLATE_FLAG => X_TEMPLATE_FLAG,
1077       X_CASCADE_SOURCE_CODE_FLAG => X_CASCADE_SOURCE_CODE_FLAG,
1078       X_INHERIT_ATTRIBUTES_FLAG => X_INHERIT_ATTRIBUTES_FLAG,
1079       X_SOURCE_CODE => X_SOURCE_CODE,
1080       X_ROLLUP_TYPE => X_ROLLUP_TYPE,
1081       X_CAMPAIGN_TYPE => X_CAMPAIGN_TYPE,
1082       X_MEDIA_TYPE_CODE => X_MEDIA_TYPE_CODE,
1083       X_PRIORITY => X_PRIORITY,
1084       X_FUND_SOURCE_TYPE => X_FUND_SOURCE_TYPE,
1085       X_FUND_SOURCE_ID => X_FUND_SOURCE_ID,
1086       X_PARENT_CAMPAIGN_ID => X_PARENT_CAMPAIGN_ID,
1087       X_APPLICATION_ID => X_APPLICATION_ID,
1088       X_QP_LIST_HEADER_ID => X_QP_LIST_HEADER_ID,
1089       X_MEDIA_ID => X_MEDIA_ID,
1090       X_CHANNEL_ID => X_CHANNEL_ID,
1091       X_EVENT_TYPE => X_EVENT_TYPE,
1092       X_ARC_CHANNEL_FROM => X_ARC_CHANNEL_FROM,
1093       X_DSCRIPT_NAME => X_DSCRIPT_NAME,
1094       X_TRANSACTION_CURRENCY_CODE => X_TRANSACTION_CURRENCY_CODE,
1095       X_FUNCTIONAL_CURRENCY_CODE => X_FUNCTIONAL_CURRENCY_CODE,
1096       X_BUDGET_AMOUNT_TC => X_BUDGET_AMOUNT_TC,
1097       X_BUDGET_AMOUNT_FC => X_BUDGET_AMOUNT_FC,
1098       X_FORECASTED_PLAN_START_DATE => X_FORECASTED_PLAN_START_DATE,
1099       X_FORECASTED_PLAN_END_DATE => X_FORECASTED_PLAN_END_DATE,
1100       X_FORECASTED_EXEC_START_DATE => X_FORECASTED_EXEC_START_DATE,
1101       X_FORECASTED_EXEC_END_DATE => X_FORECASTED_EXEC_END_DATE,
1102       X_ACTUAL_PLAN_START_DATE => X_ACTUAL_PLAN_START_DATE,
1103       X_ACTUAL_PLAN_END_DATE => X_ACTUAL_PLAN_END_DATE,
1104       X_ACTUAL_EXEC_START_DATE => X_ACTUAL_EXEC_START_DATE,
1105       X_ACTUAL_EXEC_END_DATE => X_ACTUAL_EXEC_END_DATE,
1106       X_INBOUND_URL => X_INBOUND_URL,
1107       X_INBOUND_EMAIL_ID => X_INBOUND_EMAIL_ID,
1108       X_INBOUND_PHONE_NO => X_INBOUND_PHONE_NO,
1112       X_FF_OVERRIDE_COVER_LETTER => X_FF_OVERRIDE_COVER_LETTER,
1109       X_DURATION => X_DURATION,
1110       X_DURATION_UOM_CODE => X_DURATION_UOM_CODE,
1111       X_FF_PRIORITY => X_FF_PRIORITY,
1113       X_FF_SHIPPING_METHOD => X_FF_SHIPPING_METHOD,
1114       X_FF_CARRIER => X_FF_CARRIER,
1115       X_CONTENT_SOURCE => X_CONTENT_SOURCE,
1116       X_CC_CALL_STRATEGY => X_CC_CALL_STRATEGY,
1117       X_CC_MANAGER_USER_ID => X_CC_MANAGER_USER_ID,
1118       X_FORECASTED_REVENUE => X_FORECASTED_REVENUE,
1119       X_ACTUAL_REVENUE => X_ACTUAL_REVENUE,
1120       X_FORECASTED_COST => X_FORECASTED_COST,
1121       X_ACTUAL_COST => X_ACTUAL_COST,
1122       X_FORECASTED_RESPONSE => X_FORECASTED_RESPONSE,
1123       X_ACTUAL_RESPONSE => X_ACTUAL_RESPONSE,
1124       X_TARGET_RESPONSE => X_TARGET_RESPONSE,
1125       X_COUNTRY_CODE => X_COUNTRY_CODE,
1126       X_LANGUAGE_CODE => X_LANGUAGE_CODE,
1127       X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
1128       X_ATTRIBUTE1 => X_ATTRIBUTE1,
1129       X_ATTRIBUTE2 => X_ATTRIBUTE2,
1130       X_ATTRIBUTE3 => X_ATTRIBUTE3,
1131       X_ATTRIBUTE4 => X_ATTRIBUTE4,
1132       X_ATTRIBUTE5 => X_ATTRIBUTE5,
1133       X_ATTRIBUTE6 => X_ATTRIBUTE6,
1134       X_ATTRIBUTE7 => X_ATTRIBUTE7,
1135       X_ATTRIBUTE8 => X_ATTRIBUTE8,
1136       X_ATTRIBUTE9 => X_ATTRIBUTE9,
1137       X_ATTRIBUTE10 => X_ATTRIBUTE10,
1138       X_ATTRIBUTE11 => X_ATTRIBUTE11,
1139       X_ATTRIBUTE12 => X_ATTRIBUTE12,
1140       X_ATTRIBUTE14 => X_ATTRIBUTE14,
1141       X_ATTRIBUTE13 => X_ATTRIBUTE13,
1142       X_ATTRIBUTE15 => X_ATTRIBUTE15,
1143       X_CAMPAIGN_NAME => X_CAMPAIGN_NAME,
1144       X_CAMPAIGN_THEME => X_CAMPAIGN_THEME,
1145       X_DESCRIPTION => X_DESCRIPTION,
1146       X_CREATION_DATE		=>  SYSDATE,
1147       X_CREATED_BY			=>  l_user_id,
1148       X_LAST_UPDATE_DATE	=>  SYSDATE,
1149       X_LAST_UPDATED_BY		=>  l_user_id,
1150       X_LAST_UPDATE_LOGIN	=>  0
1151     );
1152   else
1153     close c_camp_exists;
1154     open c_version;
1155     fetch c_version into l_version;
1156     close c_version;
1157     AMS_CAMPAIGNS_ALL_PKG.UPDATE_ROW(
1158       X_CAMPAIGN_ID => X_CAMPAIGN_ID,
1159       X_OBJECT_VERSION_NUMBER => l_version + 1,
1160       X_OWNER_USER_ID => X_OWNER_USER_ID,
1161       X_USER_STATUS_ID => X_USER_STATUS_ID,
1162       X_STATUS_CODE => X_STATUS_CODE,
1163       X_STATUS_DATE => X_STATUS_DATE,
1164       X_ACTIVE_FLAG => X_ACTIVE_FLAG,
1165       X_PRIVATE_FLAG => X_PRIVATE_FLAG,
1166       X_PARTNER_FLAG => X_PARTNER_FLAG,
1167       X_TEMPLATE_FLAG => X_TEMPLATE_FLAG,
1168       X_CASCADE_SOURCE_CODE_FLAG => X_CASCADE_SOURCE_CODE_FLAG,
1169       X_INHERIT_ATTRIBUTES_FLAG => X_INHERIT_ATTRIBUTES_FLAG,
1170       X_SOURCE_CODE => X_SOURCE_CODE,
1171       X_ROLLUP_TYPE => X_ROLLUP_TYPE,
1172       X_CAMPAIGN_TYPE => X_CAMPAIGN_TYPE,
1173       X_MEDIA_TYPE_CODE => X_MEDIA_TYPE_CODE,
1174       X_PRIORITY => X_PRIORITY,
1175       X_FUND_SOURCE_TYPE => X_FUND_SOURCE_TYPE,
1176       X_FUND_SOURCE_ID => X_FUND_SOURCE_ID,
1177       X_PARENT_CAMPAIGN_ID => X_PARENT_CAMPAIGN_ID,
1178       X_APPLICATION_ID => X_APPLICATION_ID,
1179       X_QP_LIST_HEADER_ID => X_QP_LIST_HEADER_ID,
1180       X_MEDIA_ID => X_MEDIA_ID,
1181       X_CHANNEL_ID => X_CHANNEL_ID,
1182       X_EVENT_TYPE => X_EVENT_TYPE,
1183       X_ARC_CHANNEL_FROM => X_ARC_CHANNEL_FROM,
1184       X_DSCRIPT_NAME => X_DSCRIPT_NAME,
1185       X_TRANSACTION_CURRENCY_CODE => X_TRANSACTION_CURRENCY_CODE,
1186       X_FUNCTIONAL_CURRENCY_CODE => X_FUNCTIONAL_CURRENCY_CODE,
1187       X_BUDGET_AMOUNT_TC => X_BUDGET_AMOUNT_TC,
1188       X_BUDGET_AMOUNT_FC => X_BUDGET_AMOUNT_FC,
1189       X_FORECASTED_PLAN_START_DATE => X_FORECASTED_PLAN_START_DATE,
1190       X_FORECASTED_PLAN_END_DATE => X_FORECASTED_PLAN_END_DATE,
1191       X_FORECASTED_EXEC_START_DATE => X_FORECASTED_EXEC_START_DATE,
1192       X_FORECASTED_EXEC_END_DATE => X_FORECASTED_EXEC_END_DATE,
1193       X_ACTUAL_PLAN_START_DATE => X_ACTUAL_PLAN_START_DATE,
1194       X_ACTUAL_PLAN_END_DATE => X_ACTUAL_PLAN_END_DATE,
1195       X_ACTUAL_EXEC_START_DATE => X_ACTUAL_EXEC_START_DATE,
1196       X_ACTUAL_EXEC_END_DATE => X_ACTUAL_EXEC_END_DATE,
1197       X_INBOUND_URL => X_INBOUND_URL,
1198       X_INBOUND_EMAIL_ID => X_INBOUND_EMAIL_ID,
1199       X_INBOUND_PHONE_NO => X_INBOUND_PHONE_NO,
1200       X_DURATION => X_DURATION,
1201       X_DURATION_UOM_CODE => X_DURATION_UOM_CODE,
1202       X_FF_PRIORITY => X_FF_PRIORITY,
1203       X_FF_OVERRIDE_COVER_LETTER => X_FF_OVERRIDE_COVER_LETTER,
1204       X_FF_SHIPPING_METHOD => X_FF_SHIPPING_METHOD,
1205       X_FF_CARRIER => X_FF_CARRIER,
1206       X_CONTENT_SOURCE => X_CONTENT_SOURCE,
1207       X_CC_CALL_STRATEGY => X_CC_CALL_STRATEGY,
1208       X_CC_MANAGER_USER_ID => X_CC_MANAGER_USER_ID,
1209       X_FORECASTED_REVENUE => X_FORECASTED_REVENUE,
1210       X_ACTUAL_REVENUE => X_ACTUAL_REVENUE,
1211       X_FORECASTED_COST => X_FORECASTED_COST,
1212       X_ACTUAL_COST => X_ACTUAL_COST,
1213       X_FORECASTED_RESPONSE => X_FORECASTED_RESPONSE,
1214       X_ACTUAL_RESPONSE => X_ACTUAL_RESPONSE,
1215       X_TARGET_RESPONSE => X_TARGET_RESPONSE,
1216       X_COUNTRY_CODE => X_COUNTRY_CODE,
1217       X_LANGUAGE_CODE => X_LANGUAGE_CODE,
1218       X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
1219       X_ATTRIBUTE1 => X_ATTRIBUTE1,
1220       X_ATTRIBUTE2 => X_ATTRIBUTE2,
1221       X_ATTRIBUTE3 => X_ATTRIBUTE3,
1222       X_ATTRIBUTE4 => X_ATTRIBUTE4,
1223       X_ATTRIBUTE5 => X_ATTRIBUTE5,
1224       X_ATTRIBUTE6 => X_ATTRIBUTE6,
1225       X_ATTRIBUTE7 => X_ATTRIBUTE7,
1226       X_ATTRIBUTE8 => X_ATTRIBUTE8,
1227       X_ATTRIBUTE9 => X_ATTRIBUTE9,
1231       X_ATTRIBUTE14 => X_ATTRIBUTE14,
1228       X_ATTRIBUTE10 => X_ATTRIBUTE10,
1229       X_ATTRIBUTE11 => X_ATTRIBUTE11,
1230       X_ATTRIBUTE12 => X_ATTRIBUTE12,
1232       X_ATTRIBUTE13 => X_ATTRIBUTE13,
1233       X_ATTRIBUTE15 => X_ATTRIBUTE15,
1234       X_CAMPAIGN_NAME => X_CAMPAIGN_NAME,
1235       X_CAMPAIGN_THEME => X_CAMPAIGN_THEME,
1236       X_DESCRIPTION => X_DESCRIPTION,
1237       X_LAST_UPDATE_DATE => SYSDATE,
1238       X_LAST_UPDATED_BY => l_user_id,
1239       X_LAST_UPDATE_LOGIN => 0
1240     );
1241   end if;
1242 END LOAD_ROW;
1243 
1244 end AMS_CAMPAIGNS_ALL_PKG;