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_EVENT_OFFERS_ALL_PKG

Source


1 package body AMS_EVENT_OFFERS_ALL_PKG as
2 /* $Header: amslevob.pls 115.4 2002/11/16 00:41:53 dbiswas ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in OUT NOCOPY VARCHAR2,
5   X_EVENT_OFFER_ID in NUMBER,
6   X_ATTRIBUTE6 in VARCHAR2,
7   X_ORGANIZATION_ID in NUMBER,
8   X_ATTRIBUTE2 in VARCHAR2,
9   X_EVENT_START_DATE_TIME in DATE,
10   X_EVENT_END_DATE in DATE,
11   X_EVENT_END_DATE_TIME in DATE,
12   X_REG_START_DATE in DATE,
13   X_REG_START_TIME in DATE,
14   X_REG_END_DATE in DATE,
15   X_REG_END_TIME in DATE,
16   X_REG_MAXIMUM_CAPACITY in NUMBER,
17   X_REG_OVERBOOK_PCT in NUMBER,
18   X_ATTRIBUTE3 in VARCHAR2,
19   X_ATTRIBUTE7 in VARCHAR2,
20   X_REG_WAITLIST_PCT in NUMBER,
21   X_ATTRIBUTE4 in VARCHAR2,
22   X_EVENT_START_DATE in DATE,
23   X_ATTRIBUTE8 in VARCHAR2,
24   X_ATTRIBUTE9 in VARCHAR2,
25   X_ATTRIBUTE10 in VARCHAR2,
26   X_ATTRIBUTE11 in VARCHAR2,
27   X_ATTRIBUTE12 in VARCHAR2,
28   X_ATTRIBUTE13 in VARCHAR2,
29   X_ATTRIBUTE14 in VARCHAR2,
30   X_ATTRIBUTE15 in VARCHAR2,
31   X_EVENT_LEVEL in VARCHAR2,
32   X_LAST_STATUS_DATE in DATE,
33   X_SYSTEM_STATUS_CODE in VARCHAR2,
34   X_EVENT_TYPE_CODE in VARCHAR2,
35   X_EVENT_DELIVERY_METHOD_ID in NUMBER,
36   X_EVENT_REQUIRED_FLAG in VARCHAR2,
37   X_EVENT_LANGUAGE_CODE in VARCHAR2,
38   X_EVENT_LOCATION_ID in NUMBER,
39   X_OVERFLOW_FLAG in VARCHAR2,
40   X_PARTNER_FLAG in VARCHAR2,
41   X_EVENT_STANDALONE_FLAG in VARCHAR2,
42   X_REG_FROZEN_FLAG in VARCHAR2,
43   X_REG_REQUIRED_FLAG in VARCHAR2,
44   X_REG_CHARGE_FLAG in VARCHAR2,
45   X_REG_INVITED_ONLY_FLAG in VARCHAR2,
46   X_REG_WAITLIST_ALLOWED_FLAG in VARCHAR2,
47   X_REG_OVERBOOK_ALLOWED_FLAG in VARCHAR2,
48   X_PARENT_EVENT_OFFER_ID in NUMBER,
49   X_EVENT_DURATION in NUMBER,
50   X_EVENT_DURATION_UOM_CODE in VARCHAR2,
51   X_ATTRIBUTE5 in VARCHAR2,
52   X_REG_MINIMUM_CAPACITY in NUMBER,
53   X_REG_MINIMUM_REQ_BY_DATE in DATE,
54   X_INVENTORY_ITEM_ID in NUMBER,
55   X_PRICELIST_HEADER_ID in NUMBER,
56   X_PRICELIST_LINE_ID in NUMBER,
57   X_WAITLIST_ACTION_TYPE_CODE in VARCHAR2,
58   X_STREAM_TYPE_CODE in VARCHAR2,
59   X_OWNER_USER_ID in NUMBER,
60   X_EVENT_FULL_FLAG in VARCHAR2,
61   X_FORECASTED_REVENUE in NUMBER,
62   X_ACTUAL_REVENUE in NUMBER,
63   X_FORECASTED_COST in NUMBER,
64   X_ACTUAL_COST in NUMBER,
65   X_FUND_SOURCE_TYPE_CODE in VARCHAR2,
66   X_FUND_SOURCE_ID in NUMBER,
67   X_CERT_CREDIT_TYPE_CODE in VARCHAR2,
68   X_CERTIFICATION_CREDITS in NUMBER,
69   X_COORDINATOR_ID in NUMBER,
70   X_PRIORITY_TYPE_CODE in VARCHAR2,
71   X_CANCELLATION_REASON_CODE in VARCHAR2,
72   X_URL in VARCHAR2,
73   X_TIMEZONE_ID in NUMBER,
74   X_INBOUND_SCRIPT_NAME in VARCHAR2,
75   X_ATTRIBUTE_CATEGORY in VARCHAR2,
76   X_ATTRIBUTE1 in VARCHAR2,
77   X_AUTO_REGISTER_FLAG in VARCHAR2,
78   X_FUND_AMOUNT_TC in NUMBER,
79   X_FUND_AMOUNT_FC in NUMBER,
80   X_CURRENCY_CODE_TC in VARCHAR2,
81   X_CURRENCY_CODE_FC in VARCHAR2,
82   X_EMAIL in VARCHAR2,
83   X_PHONE in VARCHAR2,
84   X_USER_STATUS_ID in NUMBER,
85   X_EVENT_VENUE_ID in NUMBER,
86   X_REG_EFFECTIVE_CAPACITY in NUMBER,
87   X_OBJECT_VERSION_NUMBER in NUMBER,
88   X_APPLICATION_ID in NUMBER,
89   X_EVENT_HEADER_ID in NUMBER,
90   X_PRIVATE_FLAG in VARCHAR2,
91   X_ACTIVE_FLAG in VARCHAR2,
92   X_SOURCE_CODE in VARCHAR2,
93   X_EVENT_OFFER_NAME in VARCHAR2,
94   X_EVENT_MKTG_MESSAGE in VARCHAR2,
95   X_DESCRIPTION in VARCHAR2,
96   X_CREATION_DATE in DATE,
97   X_CREATED_BY in NUMBER,
98   X_LAST_UPDATE_DATE in DATE,
99   X_LAST_UPDATED_BY in NUMBER,
100   X_LAST_UPDATE_LOGIN in NUMBER
101 ) is
102   cursor C is select ROWID from AMS_EVENT_OFFERS_ALL_B
103     where EVENT_OFFER_ID = X_EVENT_OFFER_ID
104     ;
105 begin
106   insert into AMS_EVENT_OFFERS_ALL_B (
107     ATTRIBUTE6,
108     ORGANIZATION_ID,
109     ATTRIBUTE2,
110     EVENT_START_DATE_TIME,
111     EVENT_END_DATE,
112     EVENT_END_DATE_TIME,
113     REG_START_DATE,
114     REG_START_TIME,
115     REG_END_DATE,
116     REG_END_TIME,
117     REG_MAXIMUM_CAPACITY,
118     REG_OVERBOOK_PCT,
119     ATTRIBUTE3,
120     ATTRIBUTE7,
121     REG_WAITLIST_PCT,
122     ATTRIBUTE4,
123     EVENT_OFFER_ID,
124     EVENT_START_DATE,
125     ATTRIBUTE8,
126     ATTRIBUTE9,
127     ATTRIBUTE10,
128     ATTRIBUTE11,
129     ATTRIBUTE12,
130     ATTRIBUTE13,
131     ATTRIBUTE14,
132     ATTRIBUTE15,
133     EVENT_LEVEL,
134     LAST_STATUS_DATE,
135     SYSTEM_STATUS_CODE,
136     EVENT_TYPE_CODE,
137     EVENT_DELIVERY_METHOD_ID,
138     EVENT_REQUIRED_FLAG,
139     EVENT_LANGUAGE_CODE,
140     EVENT_LOCATION_ID,
141     OVERFLOW_FLAG,
142     PARTNER_FLAG,
143     EVENT_STANDALONE_FLAG,
144     REG_FROZEN_FLAG,
145     REG_REQUIRED_FLAG,
146     REG_CHARGE_FLAG,
147     REG_INVITED_ONLY_FLAG,
148     REG_WAITLIST_ALLOWED_FLAG,
149     REG_OVERBOOK_ALLOWED_FLAG,
150     PARENT_EVENT_OFFER_ID,
151     EVENT_DURATION,
152     EVENT_DURATION_UOM_CODE,
153     ATTRIBUTE5,
154     REG_MINIMUM_CAPACITY,
155     REG_MINIMUM_REQ_BY_DATE,
156     INVENTORY_ITEM_ID,
157     PRICELIST_HEADER_ID,
158     PRICELIST_LINE_ID,
159     WAITLIST_ACTION_TYPE_CODE,
160     STREAM_TYPE_CODE,
161     OWNER_USER_ID,
162     EVENT_FULL_FLAG,
163     FORECASTED_REVENUE,
164     ACTUAL_REVENUE,
165     FORECASTED_COST,
166     ACTUAL_COST,
167     FUND_SOURCE_TYPE_CODE,
168     FUND_SOURCE_ID,
169     CERT_CREDIT_TYPE_CODE,
170     CERTIFICATION_CREDITS,
171     COORDINATOR_ID,
172     PRIORITY_TYPE_CODE,
173     CANCELLATION_REASON_CODE,
174     URL,
175     TIMEZONE_ID,
176     INBOUND_SCRIPT_NAME,
177     ATTRIBUTE_CATEGORY,
178     ATTRIBUTE1,
179     AUTO_REGISTER_FLAG,
180     FUND_AMOUNT_TC,
181     FUND_AMOUNT_FC,
182     CURRENCY_CODE_TC,
183     CURRENCY_CODE_FC,
184     EMAIL,
185     PHONE,
186     USER_STATUS_ID,
187     EVENT_VENUE_ID,
188     REG_EFFECTIVE_CAPACITY,
189     OBJECT_VERSION_NUMBER,
190     APPLICATION_ID,
191     EVENT_HEADER_ID,
192     PRIVATE_FLAG,
193     ACTIVE_FLAG,
194     SOURCE_CODE,
195     CREATION_DATE,
196     CREATED_BY,
197     LAST_UPDATE_DATE,
198     LAST_UPDATED_BY,
199     LAST_UPDATE_LOGIN
200   ) values (
201     X_ATTRIBUTE6,
202     X_ORGANIZATION_ID,
203     X_ATTRIBUTE2,
204     X_EVENT_START_DATE_TIME,
205     X_EVENT_END_DATE,
206     X_EVENT_END_DATE_TIME,
207     X_REG_START_DATE,
208     X_REG_START_TIME,
209     X_REG_END_DATE,
210     X_REG_END_TIME,
211     X_REG_MAXIMUM_CAPACITY,
212     X_REG_OVERBOOK_PCT,
213     X_ATTRIBUTE3,
214     X_ATTRIBUTE7,
215     X_REG_WAITLIST_PCT,
216     X_ATTRIBUTE4,
217     X_EVENT_OFFER_ID,
218     X_EVENT_START_DATE,
219     X_ATTRIBUTE8,
220     X_ATTRIBUTE9,
221     X_ATTRIBUTE10,
222     X_ATTRIBUTE11,
223     X_ATTRIBUTE12,
224     X_ATTRIBUTE13,
225     X_ATTRIBUTE14,
226     X_ATTRIBUTE15,
227     X_EVENT_LEVEL,
228     X_LAST_STATUS_DATE,
229     X_SYSTEM_STATUS_CODE,
230     X_EVENT_TYPE_CODE,
231     X_EVENT_DELIVERY_METHOD_ID,
232     X_EVENT_REQUIRED_FLAG,
233     X_EVENT_LANGUAGE_CODE,
234     X_EVENT_LOCATION_ID,
235     X_OVERFLOW_FLAG,
236     X_PARTNER_FLAG,
237     X_EVENT_STANDALONE_FLAG,
238     X_REG_FROZEN_FLAG,
239     X_REG_REQUIRED_FLAG,
240     X_REG_CHARGE_FLAG,
241     X_REG_INVITED_ONLY_FLAG,
242     X_REG_WAITLIST_ALLOWED_FLAG,
243     X_REG_OVERBOOK_ALLOWED_FLAG,
244     X_PARENT_EVENT_OFFER_ID,
245     X_EVENT_DURATION,
246     X_EVENT_DURATION_UOM_CODE,
247     X_ATTRIBUTE5,
248     X_REG_MINIMUM_CAPACITY,
249     X_REG_MINIMUM_REQ_BY_DATE,
250     X_INVENTORY_ITEM_ID,
251     X_PRICELIST_HEADER_ID,
252     X_PRICELIST_LINE_ID,
253     X_WAITLIST_ACTION_TYPE_CODE,
254     X_STREAM_TYPE_CODE,
255     X_OWNER_USER_ID,
256     X_EVENT_FULL_FLAG,
257     X_FORECASTED_REVENUE,
258     X_ACTUAL_REVENUE,
259     X_FORECASTED_COST,
260     X_ACTUAL_COST,
261     X_FUND_SOURCE_TYPE_CODE,
262     X_FUND_SOURCE_ID,
263     X_CERT_CREDIT_TYPE_CODE,
264     X_CERTIFICATION_CREDITS,
265     X_COORDINATOR_ID,
266     X_PRIORITY_TYPE_CODE,
267     X_CANCELLATION_REASON_CODE,
268     X_URL,
269     X_TIMEZONE_ID,
270     X_INBOUND_SCRIPT_NAME,
271     X_ATTRIBUTE_CATEGORY,
272     X_ATTRIBUTE1,
273     X_AUTO_REGISTER_FLAG,
274     X_FUND_AMOUNT_TC,
275     X_FUND_AMOUNT_FC,
276     X_CURRENCY_CODE_TC,
277     X_CURRENCY_CODE_FC,
278     X_EMAIL,
279     X_PHONE,
280     X_USER_STATUS_ID,
281     X_EVENT_VENUE_ID,
282     X_REG_EFFECTIVE_CAPACITY,
283     X_OBJECT_VERSION_NUMBER,
284     X_APPLICATION_ID,
285     X_EVENT_HEADER_ID,
286     X_PRIVATE_FLAG,
287     X_ACTIVE_FLAG,
288     X_SOURCE_CODE,
289     X_CREATION_DATE,
290     X_CREATED_BY,
291     X_LAST_UPDATE_DATE,
295 
292     X_LAST_UPDATED_BY,
293     X_LAST_UPDATE_LOGIN
294   );
296   insert into AMS_EVENT_OFFERS_ALL_TL (
297     EVENT_OFFER_ID,
298     LAST_UPDATE_DATE,
299     LAST_UPDATED_BY,
300     CREATION_DATE,
301     CREATED_BY,
302     LAST_UPDATE_LOGIN,
303     EVENT_OFFER_NAME,
304     DESCRIPTION,
305     EVENT_MKTG_MESSAGE,
306     LANGUAGE,
307     SOURCE_LANG
308   ) select
309     X_EVENT_OFFER_ID,
310     X_LAST_UPDATE_DATE,
311     X_LAST_UPDATED_BY,
312     X_CREATION_DATE,
313     X_CREATED_BY,
314     X_LAST_UPDATE_LOGIN,
315     X_EVENT_OFFER_NAME,
316     X_DESCRIPTION,
317     X_EVENT_MKTG_MESSAGE,
318     L.LANGUAGE_CODE,
319     userenv('LANG')
320   from FND_LANGUAGES L
321   where L.INSTALLED_FLAG in ('I', 'B')
322   and not exists
323     (select NULL
324     from AMS_EVENT_OFFERS_ALL_TL T
325     where T.EVENT_OFFER_ID = X_EVENT_OFFER_ID
326     and T.LANGUAGE = L.LANGUAGE_CODE);
327 
328   open c;
329   fetch c into X_ROWID;
330   if (c%notfound) then
331     close c;
332     raise no_data_found;
333   end if;
334   close c;
335 
336 end INSERT_ROW;
337 
338 procedure LOCK_ROW (
339   X_EVENT_OFFER_ID in NUMBER,
340   X_ATTRIBUTE6 in VARCHAR2,
341   X_ORGANIZATION_ID in NUMBER,
342   X_ATTRIBUTE2 in VARCHAR2,
343   X_EVENT_START_DATE_TIME in DATE,
344   X_EVENT_END_DATE in DATE,
345   X_EVENT_END_DATE_TIME in DATE,
346   X_REG_START_DATE in DATE,
347   X_REG_START_TIME in DATE,
348   X_REG_END_DATE in DATE,
349   X_REG_END_TIME in DATE,
350   X_REG_MAXIMUM_CAPACITY in NUMBER,
351   X_REG_OVERBOOK_PCT in NUMBER,
352   X_ATTRIBUTE3 in VARCHAR2,
353   X_ATTRIBUTE7 in VARCHAR2,
354   X_REG_WAITLIST_PCT in NUMBER,
355   X_ATTRIBUTE4 in VARCHAR2,
356   X_EVENT_START_DATE in DATE,
357   X_ATTRIBUTE8 in VARCHAR2,
358   X_ATTRIBUTE9 in VARCHAR2,
359   X_ATTRIBUTE10 in VARCHAR2,
360   X_ATTRIBUTE11 in VARCHAR2,
361   X_ATTRIBUTE12 in VARCHAR2,
362   X_ATTRIBUTE13 in VARCHAR2,
363   X_ATTRIBUTE14 in VARCHAR2,
364   X_ATTRIBUTE15 in VARCHAR2,
365   X_EVENT_LEVEL in VARCHAR2,
366   X_LAST_STATUS_DATE in DATE,
367   X_SYSTEM_STATUS_CODE in VARCHAR2,
368   X_EVENT_TYPE_CODE in VARCHAR2,
369   X_EVENT_DELIVERY_METHOD_ID in NUMBER,
370   X_EVENT_REQUIRED_FLAG in VARCHAR2,
371   X_EVENT_LANGUAGE_CODE in VARCHAR2,
372   X_EVENT_LOCATION_ID in NUMBER,
373   X_OVERFLOW_FLAG in VARCHAR2,
374   X_PARTNER_FLAG in VARCHAR2,
375   X_EVENT_STANDALONE_FLAG in VARCHAR2,
376   X_REG_FROZEN_FLAG in VARCHAR2,
377   X_REG_REQUIRED_FLAG in VARCHAR2,
378   X_REG_CHARGE_FLAG in VARCHAR2,
379   X_REG_INVITED_ONLY_FLAG in VARCHAR2,
380   X_REG_WAITLIST_ALLOWED_FLAG in VARCHAR2,
381   X_REG_OVERBOOK_ALLOWED_FLAG in VARCHAR2,
382   X_PARENT_EVENT_OFFER_ID in NUMBER,
383   X_EVENT_DURATION in NUMBER,
384   X_EVENT_DURATION_UOM_CODE in VARCHAR2,
385   X_ATTRIBUTE5 in VARCHAR2,
386   X_REG_MINIMUM_CAPACITY in NUMBER,
387   X_REG_MINIMUM_REQ_BY_DATE in DATE,
388   X_INVENTORY_ITEM_ID in NUMBER,
389   X_PRICELIST_HEADER_ID in NUMBER,
390   X_PRICELIST_LINE_ID in NUMBER,
391   X_WAITLIST_ACTION_TYPE_CODE in VARCHAR2,
392   X_STREAM_TYPE_CODE in VARCHAR2,
393   X_OWNER_USER_ID in NUMBER,
394   X_EVENT_FULL_FLAG in VARCHAR2,
395   X_FORECASTED_REVENUE in NUMBER,
396   X_ACTUAL_REVENUE in NUMBER,
397   X_FORECASTED_COST in NUMBER,
398   X_ACTUAL_COST in NUMBER,
399   X_FUND_SOURCE_TYPE_CODE in VARCHAR2,
400   X_FUND_SOURCE_ID in NUMBER,
401   X_CERT_CREDIT_TYPE_CODE in VARCHAR2,
402   X_CERTIFICATION_CREDITS in NUMBER,
403   X_COORDINATOR_ID in NUMBER,
404   X_PRIORITY_TYPE_CODE in VARCHAR2,
405   X_CANCELLATION_REASON_CODE in VARCHAR2,
406   X_URL in VARCHAR2,
407   X_TIMEZONE_ID in NUMBER,
408   X_INBOUND_SCRIPT_NAME in VARCHAR2,
409   X_ATTRIBUTE_CATEGORY in VARCHAR2,
410   X_ATTRIBUTE1 in VARCHAR2,
411   X_AUTO_REGISTER_FLAG in VARCHAR2,
412   X_FUND_AMOUNT_TC in NUMBER,
413   X_FUND_AMOUNT_FC in NUMBER,
414   X_CURRENCY_CODE_TC in VARCHAR2,
415   X_CURRENCY_CODE_FC in VARCHAR2,
416   X_EMAIL in VARCHAR2,
417   X_PHONE in VARCHAR2,
421   X_OBJECT_VERSION_NUMBER in NUMBER,
418   X_USER_STATUS_ID in NUMBER,
419   X_EVENT_VENUE_ID in NUMBER,
420   X_REG_EFFECTIVE_CAPACITY in NUMBER,
422   X_APPLICATION_ID in NUMBER,
423   X_EVENT_HEADER_ID in NUMBER,
424   X_PRIVATE_FLAG in VARCHAR2,
425   X_ACTIVE_FLAG in VARCHAR2,
426   X_SOURCE_CODE in VARCHAR2,
427   X_EVENT_OFFER_NAME in VARCHAR2,
428   X_EVENT_MKTG_MESSAGE in VARCHAR2,
429   X_DESCRIPTION in VARCHAR2
430 ) is
431   cursor c is select
432       ATTRIBUTE6,
433       ORGANIZATION_ID,
437       EVENT_END_DATE_TIME,
434       ATTRIBUTE2,
435       EVENT_START_DATE_TIME,
436       EVENT_END_DATE,
438       REG_START_DATE,
439       REG_START_TIME,
440       REG_END_DATE,
441       REG_END_TIME,
442       REG_MAXIMUM_CAPACITY,
443       REG_OVERBOOK_PCT,
444       ATTRIBUTE3,
445       ATTRIBUTE7,
446       REG_WAITLIST_PCT,
447       ATTRIBUTE4,
448       EVENT_START_DATE,
449       ATTRIBUTE8,
450       ATTRIBUTE9,
451       ATTRIBUTE10,
452       ATTRIBUTE11,
453       ATTRIBUTE12,
454       ATTRIBUTE13,
455       ATTRIBUTE14,
456       ATTRIBUTE15,
457       EVENT_LEVEL,
458       LAST_STATUS_DATE,
459       SYSTEM_STATUS_CODE,
460       EVENT_TYPE_CODE,
461       EVENT_DELIVERY_METHOD_ID,
462       EVENT_REQUIRED_FLAG,
463       EVENT_LANGUAGE_CODE,
464       EVENT_LOCATION_ID,
465       OVERFLOW_FLAG,
466       PARTNER_FLAG,
467       EVENT_STANDALONE_FLAG,
468       REG_FROZEN_FLAG,
469       REG_REQUIRED_FLAG,
470       REG_CHARGE_FLAG,
471       REG_INVITED_ONLY_FLAG,
472       REG_WAITLIST_ALLOWED_FLAG,
473       REG_OVERBOOK_ALLOWED_FLAG,
474       PARENT_EVENT_OFFER_ID,
475       EVENT_DURATION,
476       EVENT_DURATION_UOM_CODE,
477       ATTRIBUTE5,
478       REG_MINIMUM_CAPACITY,
479       REG_MINIMUM_REQ_BY_DATE,
480       INVENTORY_ITEM_ID,
481       PRICELIST_HEADER_ID,
482       PRICELIST_LINE_ID,
483       WAITLIST_ACTION_TYPE_CODE,
484       STREAM_TYPE_CODE,
485       OWNER_USER_ID,
486       EVENT_FULL_FLAG,
487       FORECASTED_REVENUE,
488       ACTUAL_REVENUE,
489       FORECASTED_COST,
490       ACTUAL_COST,
491       FUND_SOURCE_TYPE_CODE,
492       FUND_SOURCE_ID,
493       CERT_CREDIT_TYPE_CODE,
494       CERTIFICATION_CREDITS,
495       COORDINATOR_ID,
496       PRIORITY_TYPE_CODE,
497       CANCELLATION_REASON_CODE,
498       URL,
499       TIMEZONE_ID,
500       INBOUND_SCRIPT_NAME,
501       ATTRIBUTE_CATEGORY,
502       ATTRIBUTE1,
503       AUTO_REGISTER_FLAG,
504       FUND_AMOUNT_TC,
505       FUND_AMOUNT_FC,
506       CURRENCY_CODE_TC,
507       CURRENCY_CODE_FC,
508       EMAIL,
509       PHONE,
510       USER_STATUS_ID,
511       EVENT_VENUE_ID,
512       REG_EFFECTIVE_CAPACITY,
513       OBJECT_VERSION_NUMBER,
514       APPLICATION_ID,
515       EVENT_HEADER_ID,
516       PRIVATE_FLAG,
517       ACTIVE_FLAG,
518       SOURCE_CODE
519     from AMS_EVENT_OFFERS_ALL_B
520     where EVENT_OFFER_ID = X_EVENT_OFFER_ID
521     for update of EVENT_OFFER_ID nowait;
522   recinfo c%rowtype;
523 
524   cursor c1 is select
525       EVENT_OFFER_NAME,
526       EVENT_MKTG_MESSAGE,
527       DESCRIPTION,
528       decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
529     from AMS_EVENT_OFFERS_ALL_TL
530     where EVENT_OFFER_ID = X_EVENT_OFFER_ID
531     and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
532     for update of EVENT_OFFER_ID nowait;
533 begin
534   open c;
535   fetch c into recinfo;
536   if (c%notfound) then
537     close c;
538     fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
539     app_exception.raise_exception;
540   end if;
541   close c;
542   if (    ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
543            OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
544       AND ((recinfo.ORGANIZATION_ID = X_ORGANIZATION_ID)
545            OR ((recinfo.ORGANIZATION_ID is null) AND (X_ORGANIZATION_ID is null)))
546       AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
547            OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
548       AND ((recinfo.EVENT_START_DATE_TIME = X_EVENT_START_DATE_TIME)
549            OR ((recinfo.EVENT_START_DATE_TIME is null) AND (X_EVENT_START_DATE_TIME is null)))
550       AND ((recinfo.EVENT_END_DATE = X_EVENT_END_DATE)
551            OR ((recinfo.EVENT_END_DATE is null) AND (X_EVENT_END_DATE is null)))
552       AND ((recinfo.EVENT_END_DATE_TIME = X_EVENT_END_DATE_TIME)
553            OR ((recinfo.EVENT_END_DATE_TIME is null) AND (X_EVENT_END_DATE_TIME is null)))
554       AND ((recinfo.REG_START_DATE = X_REG_START_DATE)
555            OR ((recinfo.REG_START_DATE is null) AND (X_REG_START_DATE is null)))
556       AND ((recinfo.REG_START_TIME = X_REG_START_TIME)
557            OR ((recinfo.REG_START_TIME is null) AND (X_REG_START_TIME is null)))
558       AND ((recinfo.REG_END_DATE = X_REG_END_DATE)
559            OR ((recinfo.REG_END_DATE is null) AND (X_REG_END_DATE is null)))
560       AND ((recinfo.REG_END_TIME = X_REG_END_TIME)
561            OR ((recinfo.REG_END_TIME is null) AND (X_REG_END_TIME is null)))
562       AND ((recinfo.REG_MAXIMUM_CAPACITY = X_REG_MAXIMUM_CAPACITY)
563            OR ((recinfo.REG_MAXIMUM_CAPACITY is null) AND (X_REG_MAXIMUM_CAPACITY is null)))
564       AND ((recinfo.REG_OVERBOOK_PCT = X_REG_OVERBOOK_PCT)
565            OR ((recinfo.REG_OVERBOOK_PCT is null) AND (X_REG_OVERBOOK_PCT is null)))
566       AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
567            OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
568       AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
569            OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
570       AND ((recinfo.REG_WAITLIST_PCT = X_REG_WAITLIST_PCT)
571            OR ((recinfo.REG_WAITLIST_PCT is null) AND (X_REG_WAITLIST_PCT is null)))
572       AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
573            OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
574       AND ((recinfo.EVENT_START_DATE = X_EVENT_START_DATE)
575            OR ((recinfo.EVENT_START_DATE is null) AND (X_EVENT_START_DATE is null)))
579            OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
576       AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
577            OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
578       AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
580       AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
581            OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
582       AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
583            OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
584       AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
585            OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
586       AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
587            OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
588       AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
589            OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
590       AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
591            OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
592       AND (recinfo.EVENT_LEVEL = X_EVENT_LEVEL)
593       AND (recinfo.LAST_STATUS_DATE = X_LAST_STATUS_DATE)
594       AND (recinfo.SYSTEM_STATUS_CODE = X_SYSTEM_STATUS_CODE)
595       AND ((recinfo.EVENT_TYPE_CODE = X_EVENT_TYPE_CODE)
596            OR ((recinfo.EVENT_TYPE_CODE is null) AND (X_EVENT_TYPE_CODE is null)))
597       AND ((recinfo.EVENT_DELIVERY_METHOD_ID = X_EVENT_DELIVERY_METHOD_ID)
598            OR ((recinfo.EVENT_DELIVERY_METHOD_ID is null) AND (X_EVENT_DELIVERY_METHOD_ID is null)))
599       AND (recinfo.EVENT_REQUIRED_FLAG = X_EVENT_REQUIRED_FLAG)
600       AND ((recinfo.EVENT_LANGUAGE_CODE = X_EVENT_LANGUAGE_CODE)
601            OR ((recinfo.EVENT_LANGUAGE_CODE is null) AND (X_EVENT_LANGUAGE_CODE is null)))
602       AND ((recinfo.EVENT_LOCATION_ID = X_EVENT_LOCATION_ID)
603            OR ((recinfo.EVENT_LOCATION_ID is null) AND (X_EVENT_LOCATION_ID is null)))
604       AND (recinfo.OVERFLOW_FLAG = X_OVERFLOW_FLAG)
605       AND (recinfo.PARTNER_FLAG = X_PARTNER_FLAG)
606       AND (recinfo.EVENT_STANDALONE_FLAG = X_EVENT_STANDALONE_FLAG)
607       AND (recinfo.REG_FROZEN_FLAG = X_REG_FROZEN_FLAG)
608       AND (recinfo.REG_REQUIRED_FLAG = X_REG_REQUIRED_FLAG)
609       AND (recinfo.REG_CHARGE_FLAG = X_REG_CHARGE_FLAG)
610       AND (recinfo.REG_INVITED_ONLY_FLAG = X_REG_INVITED_ONLY_FLAG)
611       AND (recinfo.REG_WAITLIST_ALLOWED_FLAG = X_REG_WAITLIST_ALLOWED_FLAG)
612       AND (recinfo.REG_OVERBOOK_ALLOWED_FLAG = X_REG_OVERBOOK_ALLOWED_FLAG)
613       AND ((recinfo.PARENT_EVENT_OFFER_ID = X_PARENT_EVENT_OFFER_ID)
614            OR ((recinfo.PARENT_EVENT_OFFER_ID is null) AND (X_PARENT_EVENT_OFFER_ID is null)))
615       AND ((recinfo.EVENT_DURATION = X_EVENT_DURATION)
616            OR ((recinfo.EVENT_DURATION is null) AND (X_EVENT_DURATION is null)))
617       AND ((recinfo.EVENT_DURATION_UOM_CODE = X_EVENT_DURATION_UOM_CODE)
618            OR ((recinfo.EVENT_DURATION_UOM_CODE is null) AND (X_EVENT_DURATION_UOM_CODE is null)))
619       AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
620            OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
621       AND ((recinfo.REG_MINIMUM_CAPACITY = X_REG_MINIMUM_CAPACITY)
622            OR ((recinfo.REG_MINIMUM_CAPACITY is null) AND (X_REG_MINIMUM_CAPACITY is null)))
623       AND ((recinfo.REG_MINIMUM_REQ_BY_DATE = X_REG_MINIMUM_REQ_BY_DATE)
624            OR ((recinfo.REG_MINIMUM_REQ_BY_DATE is null) AND (X_REG_MINIMUM_REQ_BY_DATE is null)))
625       AND ((recinfo.INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID)
626            OR ((recinfo.INVENTORY_ITEM_ID is null) AND (X_INVENTORY_ITEM_ID is null)))
627       AND ((recinfo.PRICELIST_HEADER_ID = X_PRICELIST_HEADER_ID)
628            OR ((recinfo.PRICELIST_HEADER_ID is null) AND (X_PRICELIST_HEADER_ID is null)))
629       AND ((recinfo.PRICELIST_LINE_ID = X_PRICELIST_LINE_ID)
630            OR ((recinfo.PRICELIST_LINE_ID is null) AND (X_PRICELIST_LINE_ID is null)))
631       AND ((recinfo.WAITLIST_ACTION_TYPE_CODE = X_WAITLIST_ACTION_TYPE_CODE)
632            OR ((recinfo.WAITLIST_ACTION_TYPE_CODE is null) AND (X_WAITLIST_ACTION_TYPE_CODE is null)))
633       AND ((recinfo.STREAM_TYPE_CODE = X_STREAM_TYPE_CODE)
634            OR ((recinfo.STREAM_TYPE_CODE is null) AND (X_STREAM_TYPE_CODE is null)))
635       AND ((recinfo.OWNER_USER_ID = X_OWNER_USER_ID)
636            OR ((recinfo.OWNER_USER_ID is null) AND (X_OWNER_USER_ID is null)))
637       AND ((recinfo.EVENT_FULL_FLAG = X_EVENT_FULL_FLAG)
638            OR ((recinfo.EVENT_FULL_FLAG is null) AND (X_EVENT_FULL_FLAG is null)))
639       AND ((recinfo.FORECASTED_REVENUE = X_FORECASTED_REVENUE)
640            OR ((recinfo.FORECASTED_REVENUE is null) AND (X_FORECASTED_REVENUE is null)))
641       AND ((recinfo.ACTUAL_REVENUE = X_ACTUAL_REVENUE)
642            OR ((recinfo.ACTUAL_REVENUE is null) AND (X_ACTUAL_REVENUE is null)))
643       AND ((recinfo.FORECASTED_COST = X_FORECASTED_COST)
644            OR ((recinfo.FORECASTED_COST is null) AND (X_FORECASTED_COST is null)))
645       AND ((recinfo.ACTUAL_COST = X_ACTUAL_COST)
646            OR ((recinfo.ACTUAL_COST is null) AND (X_ACTUAL_COST is null)))
647       AND ((recinfo.FUND_SOURCE_TYPE_CODE = X_FUND_SOURCE_TYPE_CODE)
648            OR ((recinfo.FUND_SOURCE_TYPE_CODE is null) AND (X_FUND_SOURCE_TYPE_CODE is null)))
649       AND ((recinfo.FUND_SOURCE_ID = X_FUND_SOURCE_ID)
650            OR ((recinfo.FUND_SOURCE_ID is null) AND (X_FUND_SOURCE_ID is null)))
651       AND ((recinfo.CERT_CREDIT_TYPE_CODE = X_CERT_CREDIT_TYPE_CODE)
652            OR ((recinfo.CERT_CREDIT_TYPE_CODE is null) AND (X_CERT_CREDIT_TYPE_CODE is null)))
653       AND ((recinfo.CERTIFICATION_CREDITS = X_CERTIFICATION_CREDITS)
654            OR ((recinfo.CERTIFICATION_CREDITS is null) AND (X_CERTIFICATION_CREDITS is null)))
655       AND ((recinfo.COORDINATOR_ID = X_COORDINATOR_ID)
656            OR ((recinfo.COORDINATOR_ID is null) AND (X_COORDINATOR_ID is null)))
657       AND ((recinfo.PRIORITY_TYPE_CODE = X_PRIORITY_TYPE_CODE)
658            OR ((recinfo.PRIORITY_TYPE_CODE is null) AND (X_PRIORITY_TYPE_CODE is null)))
659       AND ((recinfo.CANCELLATION_REASON_CODE = X_CANCELLATION_REASON_CODE)
663       AND ((recinfo.TIMEZONE_ID = X_TIMEZONE_ID)
660            OR ((recinfo.CANCELLATION_REASON_CODE is null) AND (X_CANCELLATION_REASON_CODE is null)))
661       AND ((recinfo.URL = X_URL)
662            OR ((recinfo.URL is null) AND (X_URL is null)))
664            OR ((recinfo.TIMEZONE_ID is null) AND (X_TIMEZONE_ID is null)))
665       AND ((recinfo.INBOUND_SCRIPT_NAME = X_INBOUND_SCRIPT_NAME)
666            OR ((recinfo.INBOUND_SCRIPT_NAME is null) AND (X_INBOUND_SCRIPT_NAME is null)))
667       AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
668            OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
669       AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
670            OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
671       AND ((recinfo.AUTO_REGISTER_FLAG = X_AUTO_REGISTER_FLAG)
672            OR ((recinfo.AUTO_REGISTER_FLAG is null) AND (X_AUTO_REGISTER_FLAG is null)))
673       AND ((recinfo.FUND_AMOUNT_TC = X_FUND_AMOUNT_TC)
674            OR ((recinfo.FUND_AMOUNT_TC is null) AND (X_FUND_AMOUNT_TC is null)))
675       AND ((recinfo.FUND_AMOUNT_FC = X_FUND_AMOUNT_FC)
676            OR ((recinfo.FUND_AMOUNT_FC is null) AND (X_FUND_AMOUNT_FC is null)))
677       AND ((recinfo.CURRENCY_CODE_TC = X_CURRENCY_CODE_TC)
678            OR ((recinfo.CURRENCY_CODE_TC is null) AND (X_CURRENCY_CODE_TC is null)))
679       AND ((recinfo.CURRENCY_CODE_FC = X_CURRENCY_CODE_FC)
680            OR ((recinfo.CURRENCY_CODE_FC is null) AND (X_CURRENCY_CODE_FC is null)))
681       AND ((recinfo.EMAIL = X_EMAIL)
682            OR ((recinfo.EMAIL is null) AND (X_EMAIL is null)))
683       AND ((recinfo.PHONE = X_PHONE)
684            OR ((recinfo.PHONE is null) AND (X_PHONE is null)))
685       AND ((recinfo.USER_STATUS_ID = X_USER_STATUS_ID)
686            OR ((recinfo.USER_STATUS_ID is null) AND (X_USER_STATUS_ID is null)))
687       AND ((recinfo.EVENT_VENUE_ID = X_EVENT_VENUE_ID)
688            OR ((recinfo.EVENT_VENUE_ID is null) AND (X_EVENT_VENUE_ID is null)))
689       AND ((recinfo.REG_EFFECTIVE_CAPACITY = X_REG_EFFECTIVE_CAPACITY)
690            OR ((recinfo.REG_EFFECTIVE_CAPACITY is null) AND (X_REG_EFFECTIVE_CAPACITY is null)))
691       AND ((recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
692            OR ((recinfo.OBJECT_VERSION_NUMBER is null) AND (X_OBJECT_VERSION_NUMBER is null)))
693       AND (recinfo.APPLICATION_ID = X_APPLICATION_ID)
694       AND ((recinfo.EVENT_HEADER_ID = X_EVENT_HEADER_ID)
695            OR ((recinfo.EVENT_HEADER_ID is null) AND (X_EVENT_HEADER_ID is null)))
696       AND (recinfo.PRIVATE_FLAG = X_PRIVATE_FLAG)
697       AND (recinfo.ACTIVE_FLAG = X_ACTIVE_FLAG)
698       AND ((recinfo.SOURCE_CODE = X_SOURCE_CODE)
699            OR ((recinfo.SOURCE_CODE is null) AND (X_SOURCE_CODE is null)))
700   ) then
701     null;
702   else
703     fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
704     app_exception.raise_exception;
705   end if;
706 
707   for tlinfo in c1 loop
708     if (tlinfo.BASELANG = 'Y') then
709       if (    (tlinfo.EVENT_OFFER_NAME = X_EVENT_OFFER_NAME)
710           AND ((tlinfo.EVENT_MKTG_MESSAGE = X_EVENT_MKTG_MESSAGE)
711                OR ((tlinfo.EVENT_MKTG_MESSAGE is null) AND (X_EVENT_MKTG_MESSAGE is null)))
712           AND ((tlinfo.DESCRIPTION = X_DESCRIPTION)
713                OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
714       ) then
715         null;
716       else
717         fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
718         app_exception.raise_exception;
719       end if;
720     end if;
721   end loop;
722   return;
723 end LOCK_ROW;
724 
725 procedure UPDATE_ROW (
726   X_EVENT_OFFER_ID in NUMBER,
727   X_ATTRIBUTE6 in VARCHAR2,
728   X_ORGANIZATION_ID in NUMBER,
729   X_ATTRIBUTE2 in VARCHAR2,
730   X_EVENT_START_DATE_TIME in DATE,
731   X_EVENT_END_DATE in DATE,
732   X_EVENT_END_DATE_TIME in DATE,
733   X_REG_START_DATE in DATE,
734   X_REG_START_TIME in DATE,
735   X_REG_END_DATE in DATE,
736   X_REG_END_TIME in DATE,
737   X_REG_MAXIMUM_CAPACITY in NUMBER,
738   X_REG_OVERBOOK_PCT in NUMBER,
739   X_ATTRIBUTE3 in VARCHAR2,
740   X_ATTRIBUTE7 in VARCHAR2,
741   X_REG_WAITLIST_PCT in NUMBER,
742   X_ATTRIBUTE4 in VARCHAR2,
743   X_EVENT_START_DATE in DATE,
744   X_ATTRIBUTE8 in VARCHAR2,
745   X_ATTRIBUTE9 in VARCHAR2,
746   X_ATTRIBUTE10 in VARCHAR2,
747   X_ATTRIBUTE11 in VARCHAR2,
748   X_ATTRIBUTE12 in VARCHAR2,
749   X_ATTRIBUTE13 in VARCHAR2,
750   X_ATTRIBUTE14 in VARCHAR2,
751   X_ATTRIBUTE15 in VARCHAR2,
752   X_EVENT_LEVEL in VARCHAR2,
753   X_LAST_STATUS_DATE in DATE,
754   X_SYSTEM_STATUS_CODE in VARCHAR2,
755   X_EVENT_TYPE_CODE in VARCHAR2,
756   X_EVENT_DELIVERY_METHOD_ID in NUMBER,
757   X_EVENT_REQUIRED_FLAG in VARCHAR2,
758   X_EVENT_LANGUAGE_CODE in VARCHAR2,
759   X_EVENT_LOCATION_ID in NUMBER,
760   X_OVERFLOW_FLAG in VARCHAR2,
761   X_PARTNER_FLAG in VARCHAR2,
762   X_EVENT_STANDALONE_FLAG in VARCHAR2,
763   X_REG_FROZEN_FLAG in VARCHAR2,
764   X_REG_REQUIRED_FLAG in VARCHAR2,
765   X_REG_CHARGE_FLAG in VARCHAR2,
766   X_REG_INVITED_ONLY_FLAG in VARCHAR2,
767   X_REG_WAITLIST_ALLOWED_FLAG in VARCHAR2,
768   X_REG_OVERBOOK_ALLOWED_FLAG in VARCHAR2,
769   X_PARENT_EVENT_OFFER_ID in NUMBER,
770   X_EVENT_DURATION in NUMBER,
771   X_EVENT_DURATION_UOM_CODE in VARCHAR2,
772   X_ATTRIBUTE5 in VARCHAR2,
773   X_REG_MINIMUM_CAPACITY in NUMBER,
774   X_REG_MINIMUM_REQ_BY_DATE in DATE,
775   X_INVENTORY_ITEM_ID in NUMBER,
776   X_PRICELIST_HEADER_ID in NUMBER,
777   X_PRICELIST_LINE_ID in NUMBER,
778   X_WAITLIST_ACTION_TYPE_CODE in VARCHAR2,
779   X_STREAM_TYPE_CODE in VARCHAR2,
780   X_OWNER_USER_ID in NUMBER,
781   X_EVENT_FULL_FLAG in VARCHAR2,
785   X_ACTUAL_COST in NUMBER,
782   X_FORECASTED_REVENUE in NUMBER,
783   X_ACTUAL_REVENUE in NUMBER,
784   X_FORECASTED_COST in NUMBER,
786   X_FUND_SOURCE_TYPE_CODE in VARCHAR2,
787   X_FUND_SOURCE_ID in NUMBER,
788   X_CERT_CREDIT_TYPE_CODE in VARCHAR2,
789   X_CERTIFICATION_CREDITS in NUMBER,
790   X_COORDINATOR_ID in NUMBER,
791   X_PRIORITY_TYPE_CODE in VARCHAR2,
792   X_CANCELLATION_REASON_CODE in VARCHAR2,
793   X_URL in VARCHAR2,
794   X_TIMEZONE_ID in NUMBER,
795   X_INBOUND_SCRIPT_NAME in VARCHAR2,
796   X_ATTRIBUTE_CATEGORY in VARCHAR2,
797   X_ATTRIBUTE1 in VARCHAR2,
798   X_AUTO_REGISTER_FLAG in VARCHAR2,
799   X_FUND_AMOUNT_TC in NUMBER,
800   X_FUND_AMOUNT_FC in NUMBER,
801   X_CURRENCY_CODE_TC in VARCHAR2,
802   X_CURRENCY_CODE_FC in VARCHAR2,
803   X_EMAIL in VARCHAR2,
804   X_PHONE in VARCHAR2,
805   X_USER_STATUS_ID in NUMBER,
806   X_EVENT_VENUE_ID in NUMBER,
807   X_REG_EFFECTIVE_CAPACITY in NUMBER,
808   X_OBJECT_VERSION_NUMBER in NUMBER,
809   X_APPLICATION_ID in NUMBER,
810   X_EVENT_HEADER_ID in NUMBER,
811   X_PRIVATE_FLAG in VARCHAR2,
812   X_ACTIVE_FLAG in VARCHAR2,
813   X_SOURCE_CODE in VARCHAR2,
814   X_EVENT_OFFER_NAME in VARCHAR2,
815   X_EVENT_MKTG_MESSAGE in VARCHAR2,
816   X_DESCRIPTION in VARCHAR2,
817   X_LAST_UPDATE_DATE in DATE,
818   X_LAST_UPDATED_BY in NUMBER,
819   X_LAST_UPDATE_LOGIN in NUMBER
820 ) is
821 begin
822   update AMS_EVENT_OFFERS_ALL_B set
823     ATTRIBUTE6 = X_ATTRIBUTE6,
824     ORGANIZATION_ID = X_ORGANIZATION_ID,
825     ATTRIBUTE2 = X_ATTRIBUTE2,
826     EVENT_START_DATE_TIME = X_EVENT_START_DATE_TIME,
827     EVENT_END_DATE = X_EVENT_END_DATE,
828     EVENT_END_DATE_TIME = X_EVENT_END_DATE_TIME,
829     REG_START_DATE = X_REG_START_DATE,
830     REG_START_TIME = X_REG_START_TIME,
831     REG_END_DATE = X_REG_END_DATE,
832     REG_END_TIME = X_REG_END_TIME,
833     REG_MAXIMUM_CAPACITY = X_REG_MAXIMUM_CAPACITY,
834     REG_OVERBOOK_PCT = X_REG_OVERBOOK_PCT,
835     ATTRIBUTE3 = X_ATTRIBUTE3,
836     ATTRIBUTE7 = X_ATTRIBUTE7,
837     REG_WAITLIST_PCT = X_REG_WAITLIST_PCT,
838     ATTRIBUTE4 = X_ATTRIBUTE4,
839     EVENT_START_DATE = X_EVENT_START_DATE,
840     ATTRIBUTE8 = X_ATTRIBUTE8,
841     ATTRIBUTE9 = X_ATTRIBUTE9,
842     ATTRIBUTE10 = X_ATTRIBUTE10,
843     ATTRIBUTE11 = X_ATTRIBUTE11,
844     ATTRIBUTE12 = X_ATTRIBUTE12,
845     ATTRIBUTE13 = X_ATTRIBUTE13,
846     ATTRIBUTE14 = X_ATTRIBUTE14,
847     ATTRIBUTE15 = X_ATTRIBUTE15,
848     EVENT_LEVEL = X_EVENT_LEVEL,
849     LAST_STATUS_DATE = X_LAST_STATUS_DATE,
850     SYSTEM_STATUS_CODE = X_SYSTEM_STATUS_CODE,
851     EVENT_TYPE_CODE = X_EVENT_TYPE_CODE,
852     EVENT_DELIVERY_METHOD_ID = X_EVENT_DELIVERY_METHOD_ID,
853     EVENT_REQUIRED_FLAG = X_EVENT_REQUIRED_FLAG,
854     EVENT_LANGUAGE_CODE = X_EVENT_LANGUAGE_CODE,
855     EVENT_LOCATION_ID = X_EVENT_LOCATION_ID,
856     OVERFLOW_FLAG = X_OVERFLOW_FLAG,
857     PARTNER_FLAG = X_PARTNER_FLAG,
858     EVENT_STANDALONE_FLAG = X_EVENT_STANDALONE_FLAG,
859     REG_FROZEN_FLAG = X_REG_FROZEN_FLAG,
860     REG_REQUIRED_FLAG = X_REG_REQUIRED_FLAG,
861     REG_CHARGE_FLAG = X_REG_CHARGE_FLAG,
862     REG_INVITED_ONLY_FLAG = X_REG_INVITED_ONLY_FLAG,
863     REG_WAITLIST_ALLOWED_FLAG = X_REG_WAITLIST_ALLOWED_FLAG,
864     REG_OVERBOOK_ALLOWED_FLAG = X_REG_OVERBOOK_ALLOWED_FLAG,
865     PARENT_EVENT_OFFER_ID = X_PARENT_EVENT_OFFER_ID,
866     EVENT_DURATION = X_EVENT_DURATION,
867     EVENT_DURATION_UOM_CODE = X_EVENT_DURATION_UOM_CODE,
868     ATTRIBUTE5 = X_ATTRIBUTE5,
869     REG_MINIMUM_CAPACITY = X_REG_MINIMUM_CAPACITY,
870     REG_MINIMUM_REQ_BY_DATE = X_REG_MINIMUM_REQ_BY_DATE,
871     INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
872     PRICELIST_HEADER_ID = X_PRICELIST_HEADER_ID,
873     PRICELIST_LINE_ID = X_PRICELIST_LINE_ID,
874     WAITLIST_ACTION_TYPE_CODE = X_WAITLIST_ACTION_TYPE_CODE,
875     STREAM_TYPE_CODE = X_STREAM_TYPE_CODE,
876     OWNER_USER_ID = X_OWNER_USER_ID,
877     EVENT_FULL_FLAG = X_EVENT_FULL_FLAG,
878     FORECASTED_REVENUE = X_FORECASTED_REVENUE,
879     ACTUAL_REVENUE = X_ACTUAL_REVENUE,
880     FORECASTED_COST = X_FORECASTED_COST,
881     ACTUAL_COST = X_ACTUAL_COST,
882     FUND_SOURCE_TYPE_CODE = X_FUND_SOURCE_TYPE_CODE,
883     FUND_SOURCE_ID = X_FUND_SOURCE_ID,
884     CERT_CREDIT_TYPE_CODE = X_CERT_CREDIT_TYPE_CODE,
885     CERTIFICATION_CREDITS = X_CERTIFICATION_CREDITS,
886     COORDINATOR_ID = X_COORDINATOR_ID,
887     PRIORITY_TYPE_CODE = X_PRIORITY_TYPE_CODE,
888     CANCELLATION_REASON_CODE = X_CANCELLATION_REASON_CODE,
889     URL = X_URL,
890     TIMEZONE_ID = X_TIMEZONE_ID,
891     INBOUND_SCRIPT_NAME = X_INBOUND_SCRIPT_NAME,
892     ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
893     ATTRIBUTE1 = X_ATTRIBUTE1,
894     AUTO_REGISTER_FLAG = X_AUTO_REGISTER_FLAG,
895     FUND_AMOUNT_TC = X_FUND_AMOUNT_TC,
896     FUND_AMOUNT_FC = X_FUND_AMOUNT_FC,
897     CURRENCY_CODE_TC = X_CURRENCY_CODE_TC,
898     CURRENCY_CODE_FC = X_CURRENCY_CODE_FC,
899     EMAIL = X_EMAIL,
900     PHONE = X_PHONE,
901     USER_STATUS_ID = X_USER_STATUS_ID,
902     EVENT_VENUE_ID = X_EVENT_VENUE_ID,
903     REG_EFFECTIVE_CAPACITY = X_REG_EFFECTIVE_CAPACITY,
904     OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
905     APPLICATION_ID = X_APPLICATION_ID,
906     EVENT_HEADER_ID = X_EVENT_HEADER_ID,
907     PRIVATE_FLAG = X_PRIVATE_FLAG,
908     ACTIVE_FLAG = X_ACTIVE_FLAG,
909     SOURCE_CODE = X_SOURCE_CODE,
910     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
911     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
912     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
913   where EVENT_OFFER_ID = X_EVENT_OFFER_ID;
914 
915   if (sql%notfound) then
916     raise no_data_found;
917   end if;
918 
919   update AMS_EVENT_OFFERS_ALL_TL set
923     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
920     EVENT_OFFER_NAME = X_EVENT_OFFER_NAME,
921     EVENT_MKTG_MESSAGE = X_EVENT_MKTG_MESSAGE,
922     DESCRIPTION = X_DESCRIPTION,
924     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
925     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
926     SOURCE_LANG = userenv('LANG')
927   where EVENT_OFFER_ID = X_EVENT_OFFER_ID
928   and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
929 
930   if (sql%notfound) then
931     raise no_data_found;
932   end if;
933 end UPDATE_ROW;
934 
935 procedure DELETE_ROW (
936   X_EVENT_OFFER_ID in NUMBER
937 ) is
938 begin
939   delete from AMS_EVENT_OFFERS_ALL_TL
940   where EVENT_OFFER_ID = X_EVENT_OFFER_ID;
941 
942   if (sql%notfound) then
943     raise no_data_found;
944   end if;
945 
946   delete from AMS_EVENT_OFFERS_ALL_B
947   where EVENT_OFFER_ID = X_EVENT_OFFER_ID;
948 
949   if (sql%notfound) then
950     raise no_data_found;
951   end if;
952 end DELETE_ROW;
953 
954 procedure ADD_LANGUAGE
955 is
956 begin
957   delete from AMS_EVENT_OFFERS_ALL_TL T
958   where not exists
959     (select NULL
960     from AMS_EVENT_OFFERS_ALL_B B
961     where B.EVENT_OFFER_ID = T.EVENT_OFFER_ID
962     );
963 
964   update AMS_EVENT_OFFERS_ALL_TL T set (
965       EVENT_OFFER_NAME,
966       EVENT_MKTG_MESSAGE,
967       DESCRIPTION
968     ) = (select
969       B.EVENT_OFFER_NAME,
970       B.EVENT_MKTG_MESSAGE,
971       B.DESCRIPTION
972     from AMS_EVENT_OFFERS_ALL_TL B
973     where B.EVENT_OFFER_ID = T.EVENT_OFFER_ID
974     and B.LANGUAGE = T.SOURCE_LANG)
975   where (
976       T.EVENT_OFFER_ID,
977       T.LANGUAGE
978   ) in (select
979       SUBT.EVENT_OFFER_ID,
980       SUBT.LANGUAGE
981     from AMS_EVENT_OFFERS_ALL_TL SUBB, AMS_EVENT_OFFERS_ALL_TL SUBT
982     where SUBB.EVENT_OFFER_ID = SUBT.EVENT_OFFER_ID
983     and SUBB.LANGUAGE = SUBT.SOURCE_LANG
984     and (SUBB.EVENT_OFFER_NAME <> SUBT.EVENT_OFFER_NAME
985       or SUBB.EVENT_MKTG_MESSAGE <> SUBT.EVENT_MKTG_MESSAGE
986       or (SUBB.EVENT_MKTG_MESSAGE is null and SUBT.EVENT_MKTG_MESSAGE is not null)
987       or (SUBB.EVENT_MKTG_MESSAGE is not null and SUBT.EVENT_MKTG_MESSAGE is null)
988       or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
989       or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
990       or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
991   ));
992 
993   insert into AMS_EVENT_OFFERS_ALL_TL (
994     EVENT_OFFER_ID,
995     LAST_UPDATE_DATE,
996     LAST_UPDATED_BY,
997     CREATION_DATE,
998     CREATED_BY,
999     LAST_UPDATE_LOGIN,
1000     EVENT_OFFER_NAME,
1001     DESCRIPTION,
1002     EVENT_MKTG_MESSAGE,
1003     LANGUAGE,
1004     SOURCE_LANG
1005   ) select
1006     B.EVENT_OFFER_ID,
1007     B.LAST_UPDATE_DATE,
1008     B.LAST_UPDATED_BY,
1009     B.CREATION_DATE,
1010     B.CREATED_BY,
1011     B.LAST_UPDATE_LOGIN,
1012     B.EVENT_OFFER_NAME,
1013     B.DESCRIPTION,
1014     B.EVENT_MKTG_MESSAGE,
1015     L.LANGUAGE_CODE,
1016     B.SOURCE_LANG
1017   from AMS_EVENT_OFFERS_ALL_TL B, FND_LANGUAGES L
1018   where L.INSTALLED_FLAG in ('I', 'B')
1019   and B.LANGUAGE = userenv('LANG')
1020   and not exists
1021     (select NULL
1022     from AMS_EVENT_OFFERS_ALL_TL T
1023     where T.EVENT_OFFER_ID = B.EVENT_OFFER_ID
1024     and T.LANGUAGE = L.LANGUAGE_CODE);
1025 end ADD_LANGUAGE;
1026 
1027 procedure TRANSLATE_ROW(
1028 	  X_EVENT_OFFER_ID	in NUMBER,
1029 	  X_EVENT_OFFER_NAME	in VARCHAR2,
1030 	  X_DESCRIPTION		in VARCHAR2,
1031 	  X_EVENT_MKTG_MESSAGE  in VARCHAR2,
1032 	  X_OWNER		in VARCHAR2
1033  ) 	IS
1034 	BEGIN
1035     update AMS_EVENT_OFFERS_ALL_TL set
1036 	EVENT_OFFER_NAME = nvl(X_EVENT_OFFER_NAME,EVENT_OFFER_NAME),
1037 	EVENT_MKTG_MESSAGE = nvl(X_EVENT_MKTG_MESSAGE,EVENT_MKTG_MESSAGE),
1038 	DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
1039 	LAST_UPDATE_DATE = SYSDATE,
1040 	LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),
1041 	LAST_UPDATE_LOGIN = 0,
1042 	SOURCE_LANG = userenv('LANG')
1043 	where EVENT_OFFER_ID = X_EVENT_OFFER_ID
1044 	and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1045 
1046 END TRANSLATE_ROW;
1047 
1048 procedure LOAD_ROW (
1049   X_EVENT_OFFER_ID in NUMBER,
1050   X_ATTRIBUTE6 in VARCHAR2,
1051   X_ORGANIZATION_ID in NUMBER,
1052   X_ATTRIBUTE2 in VARCHAR2,
1053   X_EVENT_START_DATE_TIME in DATE,
1054   X_EVENT_END_DATE in DATE,
1055   X_EVENT_END_DATE_TIME in DATE,
1056   X_REG_START_DATE in DATE,
1057   X_REG_START_TIME in DATE,
1058   X_REG_END_DATE in DATE,
1059   X_REG_END_TIME in DATE,
1060   X_REG_MAXIMUM_CAPACITY in NUMBER,
1061   X_REG_OVERBOOK_PCT in NUMBER,
1062   X_ATTRIBUTE3 in VARCHAR2,
1063   X_ATTRIBUTE7 in VARCHAR2,
1064   X_REG_WAITLIST_PCT in NUMBER,
1065   X_ATTRIBUTE4 in VARCHAR2,
1066   X_EVENT_START_DATE in DATE,
1067   X_ATTRIBUTE8 in VARCHAR2,
1068   X_ATTRIBUTE9 in VARCHAR2,
1069   X_ATTRIBUTE10 in VARCHAR2,
1070   X_ATTRIBUTE11 in VARCHAR2,
1071   X_ATTRIBUTE12 in VARCHAR2,
1072   X_ATTRIBUTE13 in VARCHAR2,
1073   X_ATTRIBUTE14 in VARCHAR2,
1074   X_ATTRIBUTE15 in VARCHAR2,
1075   X_EVENT_LEVEL in VARCHAR2,
1076   X_LAST_STATUS_DATE in DATE,
1077   X_SYSTEM_STATUS_CODE in VARCHAR2,
1078   X_EVENT_TYPE_CODE in VARCHAR2,
1079   X_EVENT_DELIVERY_METHOD_ID in NUMBER,
1080   X_EVENT_REQUIRED_FLAG in VARCHAR2,
1081   X_EVENT_LANGUAGE_CODE in VARCHAR2,
1082   X_EVENT_LOCATION_ID in NUMBER,
1083   X_OVERFLOW_FLAG in VARCHAR2,
1084   X_PARTNER_FLAG in VARCHAR2,
1085   X_EVENT_STANDALONE_FLAG in VARCHAR2,
1086   X_REG_FROZEN_FLAG in VARCHAR2,
1090   X_REG_WAITLIST_ALLOWED_FLAG in VARCHAR2,
1087   X_REG_REQUIRED_FLAG in VARCHAR2,
1088   X_REG_CHARGE_FLAG in VARCHAR2,
1089   X_REG_INVITED_ONLY_FLAG in VARCHAR2,
1091   X_REG_OVERBOOK_ALLOWED_FLAG in VARCHAR2,
1092   X_PARENT_EVENT_OFFER_ID in NUMBER,
1093   X_EVENT_DURATION in NUMBER,
1094   X_EVENT_DURATION_UOM_CODE in VARCHAR2,
1095   X_ATTRIBUTE5 in VARCHAR2,
1096   X_REG_MINIMUM_CAPACITY in NUMBER,
1097   X_REG_MINIMUM_REQ_BY_DATE in DATE,
1098   X_INVENTORY_ITEM_ID in NUMBER,
1099   X_PRICELIST_HEADER_ID in NUMBER,
1100   X_PRICELIST_LINE_ID in NUMBER,
1101   X_WAITLIST_ACTION_TYPE_CODE in VARCHAR2,
1102   X_STREAM_TYPE_CODE in VARCHAR2,
1103   X_OWNER_USER_ID in NUMBER,
1104   X_EVENT_FULL_FLAG in VARCHAR2,
1105   X_FORECASTED_REVENUE in NUMBER,
1106   X_ACTUAL_REVENUE in NUMBER,
1107   X_FORECASTED_COST in NUMBER,
1108   X_ACTUAL_COST in NUMBER,
1109   X_FUND_SOURCE_TYPE_CODE in VARCHAR2,
1110   X_FUND_SOURCE_ID in NUMBER,
1111   X_CERT_CREDIT_TYPE_CODE in VARCHAR2,
1112   X_CERTIFICATION_CREDITS in NUMBER,
1113   X_COORDINATOR_ID in NUMBER,
1114   X_PRIORITY_TYPE_CODE in VARCHAR2,
1115   X_CANCELLATION_REASON_CODE in VARCHAR2,
1116   X_URL in VARCHAR2,
1117   X_TIMEZONE_ID in NUMBER,
1118   X_INBOUND_SCRIPT_NAME in VARCHAR2,
1119   X_ATTRIBUTE_CATEGORY in VARCHAR2,
1120   X_ATTRIBUTE1 in VARCHAR2,
1121   X_AUTO_REGISTER_FLAG in VARCHAR2,
1122   X_FUND_AMOUNT_TC in NUMBER,
1123   X_FUND_AMOUNT_FC in NUMBER,
1124   X_CURRENCY_CODE_TC in VARCHAR2,
1125   X_CURRENCY_CODE_FC in VARCHAR2,
1126   X_EMAIL in VARCHAR2,
1127   X_PHONE in VARCHAR2,
1128   X_USER_STATUS_ID in NUMBER,
1129   X_EVENT_VENUE_ID in NUMBER,
1130   X_REG_EFFECTIVE_CAPACITY in NUMBER,
1131   X_OBJECT_VERSION_NUMBER in NUMBER,
1132   X_APPLICATION_ID in NUMBER,
1133   X_EVENT_HEADER_ID in NUMBER,
1134   X_PRIVATE_FLAG in VARCHAR2,
1135   X_ACTIVE_FLAG in VARCHAR2,
1136   X_SOURCE_CODE in VARCHAR2,
1137   X_EVENT_OFFER_NAME in VARCHAR2,
1138   X_EVENT_MKTG_MESSAGE in VARCHAR2,
1139   X_DESCRIPTION in VARCHAR2,
1140   X_OWNER       in VARCHAR2
1141 ) IS
1142 l_user_id    number := 0;
1143   l_version    number;
1144   l_evo_id    number;
1145   l_dummy_char varchar2(1);
1146   l_row_id     varchar2(100);
1147 
1148   cursor c_version is
1149   select object_version_number
1150   from   ams_event_offers_all_b
1151   where  event_header_id = X_EVENT_HEADER_ID;
1152 
1153   cursor c_evo_exists is
1154   select 'x'
1155   from   ams_event_offers_all_b
1156   where  event_offer_id = X_EVENT_OFFER_ID;
1157 
1158   cursor c_evo_id is
1159   select ams_event_offers_all_b_s.nextval
1160   from   dual;
1161 
1162   BEGIN
1163 
1164   if X_OWNER = 'SEED' then
1165     l_user_id := 1;
1166   end if;
1167 
1168   open c_evo_exists;
1169   fetch c_evo_exists into l_dummy_char;
1170   if c_evo_exists%notfound then
1171     close c_evo_exists;
1172     if X_EVENT_OFFER_ID is not null then
1173 	 l_evo_id := X_EVENT_OFFER_ID;
1174     else
1175       open c_evo_id;
1176       fetch c_evo_id into l_evo_id;
1177       close c_evo_id;
1178     end if;
1179     l_version := 1;
1180 
1181     AMS_EVENT_OFFERS_ALL_PKG.INSERT_ROW(
1182     X_ROWID => l_row_id,
1183     X_EVENT_OFFER_ID => l_evo_id,
1184     X_OBJECT_VERSION_NUMBER => l_version,
1185     X_ATTRIBUTE6 => X_ATTRIBUTE6,
1186     X_ORGANIZATION_ID => X_ORGANIZATION_ID,
1187     X_ATTRIBUTE2 => X_ATTRIBUTE2,
1188     X_EVENT_START_DATE_TIME => X_EVENT_START_DATE_TIME,
1189     X_EVENT_END_DATE => X_EVENT_END_DATE,
1190     X_EVENT_END_DATE_TIME => X_EVENT_END_DATE_TIME,
1191     X_REG_START_DATE => X_REG_START_DATE,
1192     X_REG_START_TIME => X_REG_START_TIME,
1193     X_REG_END_DATE => X_REG_END_DATE,
1194     X_REG_END_TIME => X_REG_END_TIME,
1195     X_REG_MAXIMUM_CAPACITY => X_REG_MAXIMUM_CAPACITY,
1196     X_REG_OVERBOOK_PCT => X_REG_OVERBOOK_PCT,
1197     X_ATTRIBUTE3 => X_ATTRIBUTE3,
1198     X_ATTRIBUTE7 => X_ATTRIBUTE7,
1199     X_REG_WAITLIST_PCT => X_REG_WAITLIST_PCT,
1200     X_ATTRIBUTE4 => X_ATTRIBUTE4,
1201     X_EVENT_START_DATE => X_EVENT_START_DATE,
1202     X_ATTRIBUTE8 => X_ATTRIBUTE8,
1203     X_ATTRIBUTE9 => X_ATTRIBUTE9,
1204     X_ATTRIBUTE10 => X_ATTRIBUTE10,
1205     X_ATTRIBUTE11 => X_ATTRIBUTE11,
1206     X_ATTRIBUTE12 => X_ATTRIBUTE12,
1207     X_ATTRIBUTE13 => X_ATTRIBUTE13,
1208     X_ATTRIBUTE14 => X_ATTRIBUTE14,
1209     X_ATTRIBUTE15 => X_ATTRIBUTE15,
1210     X_EVENT_LEVEL => X_EVENT_LEVEL,
1211     X_LAST_STATUS_DATE => X_LAST_STATUS_DATE,
1212     X_SYSTEM_STATUS_CODE => X_SYSTEM_STATUS_CODE,
1213     X_EVENT_TYPE_CODE => X_EVENT_TYPE_CODE,
1214     X_EVENT_DELIVERY_METHOD_ID => X_EVENT_DELIVERY_METHOD_ID,
1215     X_EVENT_REQUIRED_FLAG => X_EVENT_REQUIRED_FLAG,
1216     X_EVENT_LANGUAGE_CODE => X_EVENT_LANGUAGE_CODE,
1217     X_EVENT_LOCATION_ID => X_EVENT_LOCATION_ID,
1218     X_OVERFLOW_FLAG => X_OVERFLOW_FLAG,
1219     X_PARTNER_FLAG => X_PARTNER_FLAG,
1220     X_EVENT_STANDALONE_FLAG => X_EVENT_STANDALONE_FLAG,
1221     X_REG_FROZEN_FLAG => X_REG_FROZEN_FLAG,
1222     X_REG_REQUIRED_FLAG => X_REG_REQUIRED_FLAG,
1223     X_REG_CHARGE_FLAG => X_REG_CHARGE_FLAG,
1224     X_REG_INVITED_ONLY_FLAG => X_REG_INVITED_ONLY_FLAG,
1225     X_REG_WAITLIST_ALLOWED_FLAG => X_REG_WAITLIST_ALLOWED_FLAG,
1226     X_REG_OVERBOOK_ALLOWED_FLAG => X_REG_OVERBOOK_ALLOWED_FLAG,
1227     X_PARENT_EVENT_OFFER_ID => X_PARENT_EVENT_OFFER_ID,
1228     X_EVENT_DURATION => X_EVENT_DURATION,
1229     X_EVENT_DURATION_UOM_CODE => X_EVENT_DURATION_UOM_CODE,
1230     X_ATTRIBUTE5 => X_ATTRIBUTE5,
1231     X_REG_MINIMUM_CAPACITY => X_REG_MINIMUM_CAPACITY,
1235     X_PRICELIST_LINE_ID => X_PRICELIST_LINE_ID,
1232     X_REG_MINIMUM_REQ_BY_DATE => X_REG_MINIMUM_REQ_BY_DATE,
1233     X_INVENTORY_ITEM_ID => X_INVENTORY_ITEM_ID,
1234     X_PRICELIST_HEADER_ID => X_PRICELIST_HEADER_ID,
1236     X_WAITLIST_ACTION_TYPE_CODE => X_WAITLIST_ACTION_TYPE_CODE,
1237     X_STREAM_TYPE_CODE => X_STREAM_TYPE_CODE,
1238     X_OWNER_USER_ID => X_OWNER_USER_ID,
1239     X_EVENT_FULL_FLAG => X_EVENT_FULL_FLAG,
1240     X_FORECASTED_REVENUE => X_FORECASTED_REVENUE,
1241     X_ACTUAL_REVENUE => X_ACTUAL_REVENUE,
1242     X_FORECASTED_COST => X_FORECASTED_COST,
1243     X_ACTUAL_COST => X_ACTUAL_COST,
1244     X_FUND_SOURCE_TYPE_CODE => X_FUND_SOURCE_TYPE_CODE,
1245     X_FUND_SOURCE_ID => X_FUND_SOURCE_ID,
1246     X_CERT_CREDIT_TYPE_CODE => X_CERT_CREDIT_TYPE_CODE,
1247     X_CERTIFICATION_CREDITS => X_CERTIFICATION_CREDITS,
1248     X_COORDINATOR_ID => X_COORDINATOR_ID,
1249     X_PRIORITY_TYPE_CODE => X_PRIORITY_TYPE_CODE,
1250     X_CANCELLATION_REASON_CODE => X_CANCELLATION_REASON_CODE,
1251     X_URL => X_URL,
1252     X_TIMEZONE_ID => X_TIMEZONE_ID,
1253     X_INBOUND_SCRIPT_NAME => X_INBOUND_SCRIPT_NAME,
1254     X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
1255     X_ATTRIBUTE1 => X_ATTRIBUTE1,
1256     X_AUTO_REGISTER_FLAG => X_AUTO_REGISTER_FLAG,
1257     X_FUND_AMOUNT_TC => X_FUND_AMOUNT_TC,
1258     X_FUND_AMOUNT_FC => X_FUND_AMOUNT_FC,
1259     X_CURRENCY_CODE_TC => X_CURRENCY_CODE_TC,
1260     X_CURRENCY_CODE_FC => X_CURRENCY_CODE_FC,
1261     X_EMAIL => X_EMAIL,
1262     X_PHONE => X_PHONE,
1263     X_USER_STATUS_ID => X_USER_STATUS_ID,
1264     X_EVENT_VENUE_ID => X_EVENT_VENUE_ID,
1265     X_REG_EFFECTIVE_CAPACITY => X_REG_EFFECTIVE_CAPACITY,
1266     X_APPLICATION_ID => X_APPLICATION_ID,
1267     X_EVENT_HEADER_ID => X_EVENT_HEADER_ID,
1268     X_PRIVATE_FLAG => X_PRIVATE_FLAG,
1269     X_ACTIVE_FLAG => X_ACTIVE_FLAG,
1270     X_SOURCE_CODE => X_SOURCE_CODE,
1271     X_EVENT_OFFER_NAME => X_EVENT_OFFER_NAME,
1272     X_EVENT_MKTG_MESSAGE => X_EVENT_MKTG_MESSAGE,
1273     X_DESCRIPTION => X_DESCRIPTION,
1274       X_CREATION_DATE		=>  SYSDATE,
1275       X_CREATED_BY		=>  l_user_id,
1276       X_LAST_UPDATE_DATE	=>  SYSDATE,
1277       X_LAST_UPDATED_BY		=>  l_user_id,
1278       X_LAST_UPDATE_LOGIN	=>  0);
1279 
1280 
1281    else
1282     close c_evo_exists;
1283     open c_version;
1284     fetch c_version into l_version;
1285     close c_version;
1286 
1287   AMS_EVENT_OFFERS_ALL_PKG.UPDATE_ROW(
1288     X_EVENT_OFFER_ID => l_evo_id,
1289     X_OBJECT_VERSION_NUMBER => l_version+1,
1290     X_ATTRIBUTE6 => X_ATTRIBUTE6,
1291     X_ORGANIZATION_ID => X_ORGANIZATION_ID,
1292     X_ATTRIBUTE2 => X_ATTRIBUTE2,
1293     X_EVENT_START_DATE_TIME => X_EVENT_START_DATE_TIME,
1294     X_EVENT_END_DATE => X_EVENT_END_DATE,
1295     X_EVENT_END_DATE_TIME => X_EVENT_END_DATE_TIME,
1296     X_REG_START_DATE => X_REG_START_DATE,
1297     X_REG_START_TIME => X_REG_START_TIME,
1298     X_REG_END_DATE => X_REG_END_DATE,
1299     X_REG_END_TIME => X_REG_END_TIME,
1300     X_REG_MAXIMUM_CAPACITY => X_REG_MAXIMUM_CAPACITY,
1301     X_REG_OVERBOOK_PCT => X_REG_OVERBOOK_PCT,
1302     X_ATTRIBUTE3 => X_ATTRIBUTE3,
1303     X_ATTRIBUTE7 => X_ATTRIBUTE7,
1304     X_REG_WAITLIST_PCT => X_REG_WAITLIST_PCT,
1305     X_ATTRIBUTE4 => X_ATTRIBUTE4,
1306     X_EVENT_START_DATE => X_EVENT_START_DATE,
1307     X_ATTRIBUTE8 => X_ATTRIBUTE8,
1308     X_ATTRIBUTE9 => X_ATTRIBUTE9,
1309     X_ATTRIBUTE10 => X_ATTRIBUTE10,
1310     X_ATTRIBUTE11 => X_ATTRIBUTE11,
1311     X_ATTRIBUTE12 => X_ATTRIBUTE12,
1312     X_ATTRIBUTE13 => X_ATTRIBUTE13,
1313     X_ATTRIBUTE14 => X_ATTRIBUTE14,
1314     X_ATTRIBUTE15 => X_ATTRIBUTE15,
1315     X_EVENT_LEVEL => X_EVENT_LEVEL,
1316     X_LAST_STATUS_DATE => X_LAST_STATUS_DATE,
1317     X_SYSTEM_STATUS_CODE => X_SYSTEM_STATUS_CODE,
1318     X_EVENT_TYPE_CODE => X_EVENT_TYPE_CODE,
1319     X_EVENT_DELIVERY_METHOD_ID => X_EVENT_DELIVERY_METHOD_ID,
1320     X_EVENT_REQUIRED_FLAG => X_EVENT_REQUIRED_FLAG,
1321     X_EVENT_LANGUAGE_CODE => X_EVENT_LANGUAGE_CODE,
1322     X_EVENT_LOCATION_ID => X_EVENT_LOCATION_ID,
1323     X_OVERFLOW_FLAG => X_OVERFLOW_FLAG,
1324     X_PARTNER_FLAG => X_PARTNER_FLAG,
1325     X_EVENT_STANDALONE_FLAG => X_EVENT_STANDALONE_FLAG,
1326     X_REG_FROZEN_FLAG => X_REG_FROZEN_FLAG,
1327     X_REG_REQUIRED_FLAG => X_REG_REQUIRED_FLAG,
1328     X_REG_CHARGE_FLAG => X_REG_CHARGE_FLAG,
1329     X_REG_INVITED_ONLY_FLAG => X_REG_INVITED_ONLY_FLAG,
1330     X_REG_WAITLIST_ALLOWED_FLAG => X_REG_WAITLIST_ALLOWED_FLAG,
1331     X_REG_OVERBOOK_ALLOWED_FLAG => X_REG_OVERBOOK_ALLOWED_FLAG,
1332     X_PARENT_EVENT_OFFER_ID => X_PARENT_EVENT_OFFER_ID,
1333     X_EVENT_DURATION => X_EVENT_DURATION,
1334     X_EVENT_DURATION_UOM_CODE => X_EVENT_DURATION_UOM_CODE,
1335     X_ATTRIBUTE5 => X_ATTRIBUTE5,
1336     X_REG_MINIMUM_CAPACITY => X_REG_MINIMUM_CAPACITY,
1337     X_REG_MINIMUM_REQ_BY_DATE => X_REG_MINIMUM_REQ_BY_DATE,
1338     X_INVENTORY_ITEM_ID => X_INVENTORY_ITEM_ID,
1339     X_PRICELIST_HEADER_ID => X_PRICELIST_HEADER_ID,
1340     X_PRICELIST_LINE_ID => X_PRICELIST_LINE_ID,
1341     X_WAITLIST_ACTION_TYPE_CODE => X_WAITLIST_ACTION_TYPE_CODE,
1342     X_STREAM_TYPE_CODE => X_STREAM_TYPE_CODE,
1343     X_OWNER_USER_ID => X_OWNER_USER_ID,
1344     X_EVENT_FULL_FLAG => X_EVENT_FULL_FLAG,
1345     X_FORECASTED_REVENUE => X_FORECASTED_REVENUE,
1346     X_ACTUAL_REVENUE => X_ACTUAL_REVENUE,
1347     X_FORECASTED_COST => X_FORECASTED_COST,
1348     X_ACTUAL_COST => X_ACTUAL_COST,
1349     X_FUND_SOURCE_TYPE_CODE => X_FUND_SOURCE_TYPE_CODE,
1350     X_FUND_SOURCE_ID => X_FUND_SOURCE_ID,
1351     X_CERT_CREDIT_TYPE_CODE => X_CERT_CREDIT_TYPE_CODE,
1352     X_CERTIFICATION_CREDITS => X_CERTIFICATION_CREDITS,
1353     X_COORDINATOR_ID => X_COORDINATOR_ID,
1354     X_PRIORITY_TYPE_CODE => X_PRIORITY_TYPE_CODE,
1355     X_CANCELLATION_REASON_CODE => X_CANCELLATION_REASON_CODE,
1356     X_URL => X_URL,
1357     X_TIMEZONE_ID => X_TIMEZONE_ID,
1361     X_AUTO_REGISTER_FLAG => X_AUTO_REGISTER_FLAG,
1358     X_INBOUND_SCRIPT_NAME => X_INBOUND_SCRIPT_NAME,
1359     X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
1360     X_ATTRIBUTE1 => X_ATTRIBUTE1,
1362     X_FUND_AMOUNT_TC => X_FUND_AMOUNT_TC,
1363     X_FUND_AMOUNT_FC => X_FUND_AMOUNT_FC,
1364     X_CURRENCY_CODE_TC => X_CURRENCY_CODE_TC,
1365     X_CURRENCY_CODE_FC => X_CURRENCY_CODE_FC,
1366     X_EMAIL => X_EMAIL,
1367     X_PHONE => X_PHONE,
1368     X_USER_STATUS_ID => X_USER_STATUS_ID,
1369     X_EVENT_VENUE_ID => X_EVENT_VENUE_ID,
1370     X_REG_EFFECTIVE_CAPACITY => X_REG_EFFECTIVE_CAPACITY,
1371     X_APPLICATION_ID => X_APPLICATION_ID,
1372     X_EVENT_HEADER_ID => X_EVENT_HEADER_ID,
1373     X_PRIVATE_FLAG => X_PRIVATE_FLAG,
1374     X_ACTIVE_FLAG => X_ACTIVE_FLAG,
1375     X_SOURCE_CODE => X_SOURCE_CODE,
1376     X_EVENT_OFFER_NAME => X_EVENT_OFFER_NAME,
1377     X_EVENT_MKTG_MESSAGE => X_EVENT_MKTG_MESSAGE,
1378     X_DESCRIPTION => X_DESCRIPTION,
1379       X_LAST_UPDATE_DATE => SYSDATE,
1380       X_LAST_UPDATED_BY => l_user_id,
1381       X_LAST_UPDATE_LOGIN => 0);
1382 
1383    end if;
1384 END LOAD_ROW;
1385 end AMS_EVENT_OFFERS_ALL_PKG;