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: APPS.AMS_EVENT_OFFERS_ALL_PKG

Source


1 package AMS_EVENT_OFFERS_ALL_PKG AUTHID CURRENT_USER as
2 /* $Header: amslevos.pls 115.3 2002/11/16 00:41:51 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 procedure LOCK_ROW (
102   X_EVENT_OFFER_ID in NUMBER,
103   X_ATTRIBUTE6 in VARCHAR2,
104   X_ORGANIZATION_ID in NUMBER,
105   X_ATTRIBUTE2 in VARCHAR2,
106   X_EVENT_START_DATE_TIME in DATE,
107   X_EVENT_END_DATE in DATE,
108   X_EVENT_END_DATE_TIME in DATE,
109   X_REG_START_DATE in DATE,
110   X_REG_START_TIME in DATE,
111   X_REG_END_DATE in DATE,
112   X_REG_END_TIME in DATE,
113   X_REG_MAXIMUM_CAPACITY in NUMBER,
114   X_REG_OVERBOOK_PCT in NUMBER,
115   X_ATTRIBUTE3 in VARCHAR2,
116   X_ATTRIBUTE7 in VARCHAR2,
117   X_REG_WAITLIST_PCT in NUMBER,
118   X_ATTRIBUTE4 in VARCHAR2,
119   X_EVENT_START_DATE in DATE,
120   X_ATTRIBUTE8 in VARCHAR2,
121   X_ATTRIBUTE9 in VARCHAR2,
122   X_ATTRIBUTE10 in VARCHAR2,
123   X_ATTRIBUTE11 in VARCHAR2,
124   X_ATTRIBUTE12 in VARCHAR2,
125   X_ATTRIBUTE13 in VARCHAR2,
126   X_ATTRIBUTE14 in VARCHAR2,
127   X_ATTRIBUTE15 in VARCHAR2,
128   X_EVENT_LEVEL in VARCHAR2,
129   X_LAST_STATUS_DATE in DATE,
130   X_SYSTEM_STATUS_CODE in VARCHAR2,
131   X_EVENT_TYPE_CODE in VARCHAR2,
132   X_EVENT_DELIVERY_METHOD_ID in NUMBER,
133   X_EVENT_REQUIRED_FLAG in VARCHAR2,
134   X_EVENT_LANGUAGE_CODE in VARCHAR2,
135   X_EVENT_LOCATION_ID in NUMBER,
136   X_OVERFLOW_FLAG in VARCHAR2,
137   X_PARTNER_FLAG in VARCHAR2,
138   X_EVENT_STANDALONE_FLAG in VARCHAR2,
139   X_REG_FROZEN_FLAG in VARCHAR2,
140   X_REG_REQUIRED_FLAG in VARCHAR2,
141   X_REG_CHARGE_FLAG in VARCHAR2,
142   X_REG_INVITED_ONLY_FLAG in VARCHAR2,
143   X_REG_WAITLIST_ALLOWED_FLAG in VARCHAR2,
144   X_REG_OVERBOOK_ALLOWED_FLAG in VARCHAR2,
145   X_PARENT_EVENT_OFFER_ID in NUMBER,
146   X_EVENT_DURATION in NUMBER,
147   X_EVENT_DURATION_UOM_CODE in VARCHAR2,
148   X_ATTRIBUTE5 in VARCHAR2,
149   X_REG_MINIMUM_CAPACITY in NUMBER,
150   X_REG_MINIMUM_REQ_BY_DATE in DATE,
151   X_INVENTORY_ITEM_ID in NUMBER,
152   X_PRICELIST_HEADER_ID in NUMBER,
153   X_PRICELIST_LINE_ID in NUMBER,
154   X_WAITLIST_ACTION_TYPE_CODE in VARCHAR2,
155   X_STREAM_TYPE_CODE in VARCHAR2,
156   X_OWNER_USER_ID in NUMBER,
157   X_EVENT_FULL_FLAG in VARCHAR2,
158   X_FORECASTED_REVENUE in NUMBER,
159   X_ACTUAL_REVENUE in NUMBER,
160   X_FORECASTED_COST in NUMBER,
161   X_ACTUAL_COST in NUMBER,
162   X_FUND_SOURCE_TYPE_CODE in VARCHAR2,
163   X_FUND_SOURCE_ID in NUMBER,
164   X_CERT_CREDIT_TYPE_CODE in VARCHAR2,
165   X_CERTIFICATION_CREDITS in NUMBER,
166   X_COORDINATOR_ID in NUMBER,
167   X_PRIORITY_TYPE_CODE in VARCHAR2,
168   X_CANCELLATION_REASON_CODE in VARCHAR2,
169   X_URL in VARCHAR2,
170   X_TIMEZONE_ID in NUMBER,
171   X_INBOUND_SCRIPT_NAME in VARCHAR2,
172   X_ATTRIBUTE_CATEGORY in VARCHAR2,
173   X_ATTRIBUTE1 in VARCHAR2,
174   X_AUTO_REGISTER_FLAG in VARCHAR2,
175   X_FUND_AMOUNT_TC in NUMBER,
176   X_FUND_AMOUNT_FC in NUMBER,
177   X_CURRENCY_CODE_TC in VARCHAR2,
178   X_CURRENCY_CODE_FC in VARCHAR2,
179   X_EMAIL in VARCHAR2,
180   X_PHONE in VARCHAR2,
181   X_USER_STATUS_ID in NUMBER,
182   X_EVENT_VENUE_ID in NUMBER,
183   X_REG_EFFECTIVE_CAPACITY in NUMBER,
184   X_OBJECT_VERSION_NUMBER in NUMBER,
185   X_APPLICATION_ID in NUMBER,
186   X_EVENT_HEADER_ID in NUMBER,
187   X_PRIVATE_FLAG in VARCHAR2,
188   X_ACTIVE_FLAG in VARCHAR2,
189   X_SOURCE_CODE in VARCHAR2,
190   X_EVENT_OFFER_NAME in VARCHAR2,
191   X_EVENT_MKTG_MESSAGE in VARCHAR2,
192   X_DESCRIPTION in VARCHAR2
193 );
194 procedure UPDATE_ROW (
195   X_EVENT_OFFER_ID in NUMBER,
196   X_ATTRIBUTE6 in VARCHAR2,
197   X_ORGANIZATION_ID in NUMBER,
198   X_ATTRIBUTE2 in VARCHAR2,
199   X_EVENT_START_DATE_TIME in DATE,
200   X_EVENT_END_DATE in DATE,
201   X_EVENT_END_DATE_TIME in DATE,
202   X_REG_START_DATE in DATE,
203   X_REG_START_TIME in DATE,
204   X_REG_END_DATE in DATE,
205   X_REG_END_TIME in DATE,
206   X_REG_MAXIMUM_CAPACITY in NUMBER,
207   X_REG_OVERBOOK_PCT in NUMBER,
208   X_ATTRIBUTE3 in VARCHAR2,
209   X_ATTRIBUTE7 in VARCHAR2,
210   X_REG_WAITLIST_PCT in NUMBER,
211   X_ATTRIBUTE4 in VARCHAR2,
212   X_EVENT_START_DATE in DATE,
213   X_ATTRIBUTE8 in VARCHAR2,
214   X_ATTRIBUTE9 in VARCHAR2,
215   X_ATTRIBUTE10 in VARCHAR2,
216   X_ATTRIBUTE11 in VARCHAR2,
217   X_ATTRIBUTE12 in VARCHAR2,
218   X_ATTRIBUTE13 in VARCHAR2,
219   X_ATTRIBUTE14 in VARCHAR2,
220   X_ATTRIBUTE15 in VARCHAR2,
221   X_EVENT_LEVEL in VARCHAR2,
222   X_LAST_STATUS_DATE in DATE,
223   X_SYSTEM_STATUS_CODE in VARCHAR2,
224   X_EVENT_TYPE_CODE in VARCHAR2,
225   X_EVENT_DELIVERY_METHOD_ID in NUMBER,
226   X_EVENT_REQUIRED_FLAG in VARCHAR2,
227   X_EVENT_LANGUAGE_CODE in VARCHAR2,
228   X_EVENT_LOCATION_ID in NUMBER,
229   X_OVERFLOW_FLAG in VARCHAR2,
230   X_PARTNER_FLAG in VARCHAR2,
231   X_EVENT_STANDALONE_FLAG in VARCHAR2,
232   X_REG_FROZEN_FLAG in VARCHAR2,
233   X_REG_REQUIRED_FLAG in VARCHAR2,
234   X_REG_CHARGE_FLAG in VARCHAR2,
235   X_REG_INVITED_ONLY_FLAG in VARCHAR2,
236   X_REG_WAITLIST_ALLOWED_FLAG in VARCHAR2,
237   X_REG_OVERBOOK_ALLOWED_FLAG in VARCHAR2,
238   X_PARENT_EVENT_OFFER_ID in NUMBER,
239   X_EVENT_DURATION in NUMBER,
240   X_EVENT_DURATION_UOM_CODE in VARCHAR2,
241   X_ATTRIBUTE5 in VARCHAR2,
242   X_REG_MINIMUM_CAPACITY in NUMBER,
243   X_REG_MINIMUM_REQ_BY_DATE in DATE,
244   X_INVENTORY_ITEM_ID in NUMBER,
245   X_PRICELIST_HEADER_ID in NUMBER,
246   X_PRICELIST_LINE_ID in NUMBER,
247   X_WAITLIST_ACTION_TYPE_CODE in VARCHAR2,
248   X_STREAM_TYPE_CODE in VARCHAR2,
249   X_OWNER_USER_ID in NUMBER,
250   X_EVENT_FULL_FLAG in VARCHAR2,
251   X_FORECASTED_REVENUE in NUMBER,
252   X_ACTUAL_REVENUE in NUMBER,
253   X_FORECASTED_COST in NUMBER,
254   X_ACTUAL_COST in NUMBER,
255   X_FUND_SOURCE_TYPE_CODE in VARCHAR2,
256   X_FUND_SOURCE_ID in NUMBER,
257   X_CERT_CREDIT_TYPE_CODE in VARCHAR2,
258   X_CERTIFICATION_CREDITS in NUMBER,
259   X_COORDINATOR_ID in NUMBER,
260   X_PRIORITY_TYPE_CODE in VARCHAR2,
261   X_CANCELLATION_REASON_CODE in VARCHAR2,
262   X_URL in VARCHAR2,
263   X_TIMEZONE_ID in NUMBER,
264   X_INBOUND_SCRIPT_NAME in VARCHAR2,
265   X_ATTRIBUTE_CATEGORY in VARCHAR2,
266   X_ATTRIBUTE1 in VARCHAR2,
267   X_AUTO_REGISTER_FLAG in VARCHAR2,
268   X_FUND_AMOUNT_TC in NUMBER,
269   X_FUND_AMOUNT_FC in NUMBER,
270   X_CURRENCY_CODE_TC in VARCHAR2,
271   X_CURRENCY_CODE_FC in VARCHAR2,
272   X_EMAIL in VARCHAR2,
273   X_PHONE in VARCHAR2,
274   X_USER_STATUS_ID in NUMBER,
275   X_EVENT_VENUE_ID in NUMBER,
276   X_REG_EFFECTIVE_CAPACITY in NUMBER,
277   X_OBJECT_VERSION_NUMBER in NUMBER,
278   X_APPLICATION_ID in NUMBER,
279   X_EVENT_HEADER_ID in NUMBER,
280   X_PRIVATE_FLAG in VARCHAR2,
281   X_ACTIVE_FLAG in VARCHAR2,
282   X_SOURCE_CODE in VARCHAR2,
283   X_EVENT_OFFER_NAME in VARCHAR2,
284   X_EVENT_MKTG_MESSAGE in VARCHAR2,
285   X_DESCRIPTION in VARCHAR2,
286   X_LAST_UPDATE_DATE in DATE,
287   X_LAST_UPDATED_BY in NUMBER,
288   X_LAST_UPDATE_LOGIN in NUMBER
289 );
290 procedure DELETE_ROW (
291   X_EVENT_OFFER_ID in NUMBER
292 );
293 procedure ADD_LANGUAGE;
294 
295 procedure TRANSLATE_ROW(
296 	  X_EVENT_OFFER_ID		in NUMBER,
297 	  X_EVENT_OFFER_NAME	in VARCHAR2,
298 	  X_DESCRIPTION		in VARCHAR2,
299 	  X_EVENT_MKTG_MESSAGE  in VARCHAR2,
300 	  X_OWNER		in VARCHAR2
301  ) ;
302 
303 
304 
305 procedure LOAD_ROW (
306   X_EVENT_OFFER_ID in NUMBER,
307   X_ATTRIBUTE6 in VARCHAR2,
308   X_ORGANIZATION_ID in NUMBER,
309   X_ATTRIBUTE2 in VARCHAR2,
310   X_EVENT_START_DATE_TIME in DATE,
311   X_EVENT_END_DATE in DATE,
312   X_EVENT_END_DATE_TIME in DATE,
313   X_REG_START_DATE in DATE,
314   X_REG_START_TIME in DATE,
315   X_REG_END_DATE in DATE,
316   X_REG_END_TIME in DATE,
317   X_REG_MAXIMUM_CAPACITY in NUMBER,
318   X_REG_OVERBOOK_PCT in NUMBER,
319   X_ATTRIBUTE3 in VARCHAR2,
320   X_ATTRIBUTE7 in VARCHAR2,
321   X_REG_WAITLIST_PCT in NUMBER,
322   X_ATTRIBUTE4 in VARCHAR2,
323   X_EVENT_START_DATE in DATE,
324   X_ATTRIBUTE8 in VARCHAR2,
325   X_ATTRIBUTE9 in VARCHAR2,
326   X_ATTRIBUTE10 in VARCHAR2,
327   X_ATTRIBUTE11 in VARCHAR2,
328   X_ATTRIBUTE12 in VARCHAR2,
329   X_ATTRIBUTE13 in VARCHAR2,
330   X_ATTRIBUTE14 in VARCHAR2,
331   X_ATTRIBUTE15 in VARCHAR2,
332   X_EVENT_LEVEL in VARCHAR2,
333   X_LAST_STATUS_DATE in DATE,
334   X_SYSTEM_STATUS_CODE in VARCHAR2,
335   X_EVENT_TYPE_CODE in VARCHAR2,
336   X_EVENT_DELIVERY_METHOD_ID in NUMBER,
337   X_EVENT_REQUIRED_FLAG in VARCHAR2,
338   X_EVENT_LANGUAGE_CODE in VARCHAR2,
339   X_EVENT_LOCATION_ID in NUMBER,
340   X_OVERFLOW_FLAG in VARCHAR2,
341   X_PARTNER_FLAG in VARCHAR2,
342   X_EVENT_STANDALONE_FLAG in VARCHAR2,
343   X_REG_FROZEN_FLAG in VARCHAR2,
344   X_REG_REQUIRED_FLAG in VARCHAR2,
345   X_REG_CHARGE_FLAG in VARCHAR2,
346   X_REG_INVITED_ONLY_FLAG in VARCHAR2,
347   X_REG_WAITLIST_ALLOWED_FLAG in VARCHAR2,
348   X_REG_OVERBOOK_ALLOWED_FLAG in VARCHAR2,
349   X_PARENT_EVENT_OFFER_ID in NUMBER,
350   X_EVENT_DURATION in NUMBER,
351   X_EVENT_DURATION_UOM_CODE in VARCHAR2,
352   X_ATTRIBUTE5 in VARCHAR2,
353   X_REG_MINIMUM_CAPACITY in NUMBER,
354   X_REG_MINIMUM_REQ_BY_DATE in DATE,
355   X_INVENTORY_ITEM_ID in NUMBER,
356   X_PRICELIST_HEADER_ID in NUMBER,
357   X_PRICELIST_LINE_ID in NUMBER,
358   X_WAITLIST_ACTION_TYPE_CODE in VARCHAR2,
359   X_STREAM_TYPE_CODE in VARCHAR2,
360   X_OWNER_USER_ID in NUMBER,
361   X_EVENT_FULL_FLAG in VARCHAR2,
362   X_FORECASTED_REVENUE in NUMBER,
363   X_ACTUAL_REVENUE in NUMBER,
364   X_FORECASTED_COST in NUMBER,
365   X_ACTUAL_COST in NUMBER,
366   X_FUND_SOURCE_TYPE_CODE in VARCHAR2,
367   X_FUND_SOURCE_ID in NUMBER,
368   X_CERT_CREDIT_TYPE_CODE in VARCHAR2,
369   X_CERTIFICATION_CREDITS in NUMBER,
370   X_COORDINATOR_ID in NUMBER,
371   X_PRIORITY_TYPE_CODE in VARCHAR2,
372   X_CANCELLATION_REASON_CODE in VARCHAR2,
373   X_URL in VARCHAR2,
374   X_TIMEZONE_ID in NUMBER,
375   X_INBOUND_SCRIPT_NAME in VARCHAR2,
376   X_ATTRIBUTE_CATEGORY in VARCHAR2,
377   X_ATTRIBUTE1 in VARCHAR2,
378   X_AUTO_REGISTER_FLAG in VARCHAR2,
379   X_FUND_AMOUNT_TC in NUMBER,
380   X_FUND_AMOUNT_FC in NUMBER,
381   X_CURRENCY_CODE_TC in VARCHAR2,
382   X_CURRENCY_CODE_FC in VARCHAR2,
383   X_EMAIL in VARCHAR2,
384   X_PHONE in VARCHAR2,
385   X_USER_STATUS_ID in NUMBER,
386   X_EVENT_VENUE_ID in NUMBER,
387   X_REG_EFFECTIVE_CAPACITY in NUMBER,
388   X_OBJECT_VERSION_NUMBER in NUMBER,
389   X_APPLICATION_ID in NUMBER,
390   X_EVENT_HEADER_ID in NUMBER,
391   X_PRIVATE_FLAG in VARCHAR2,
392   X_ACTIVE_FLAG in VARCHAR2,
393   X_SOURCE_CODE in VARCHAR2,
394   X_EVENT_OFFER_NAME in VARCHAR2,
395   X_EVENT_MKTG_MESSAGE in VARCHAR2,
396   X_DESCRIPTION in VARCHAR2,
397   X_OWNER       in VARCHAR2
398 );
399 
400 
401 end AMS_EVENT_OFFERS_ALL_PKG;