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_HEADERS_ALL_PKG

Source


1 package AMS_EVENT_HEADERS_ALL_PKG AUTHID CURRENT_USER as
2 /* $Header: amslevhs.pls 115.3 2002/11/16 00:41:46 dbiswas ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in OUT NOCOPY VARCHAR2,
5   X_EVENT_HEADER_ID in NUMBER,
6   X_FUND_AMOUNT_TC in NUMBER,
7   X_FUND_AMOUNT_FC in NUMBER,
8   X_ATTRIBUTE4 in VARCHAR2,
9   X_USER_STATUS_ID in NUMBER,
10   X_ATTRIBUTE5 in VARCHAR2,
11   X_ATTRIBUTE6 in VARCHAR2,
12   X_ORGANIZATION_ID in NUMBER,
13   X_ATTRIBUTE7 in VARCHAR2,
14   X_ATTRIBUTE8 in VARCHAR2,
15   X_ATTRIBUTE9 in VARCHAR2,
16   X_ATTRIBUTE10 in VARCHAR2,
17   X_ATTRIBUTE11 in VARCHAR2,
18   X_ATTRIBUTE12 in VARCHAR2,
19   X_ATTRIBUTE13 in VARCHAR2,
20   X_ATTRIBUTE14 in VARCHAR2,
21   X_CURRENCY_CODE_TC in VARCHAR2,
22   X_CURRENCY_CODE_FC in VARCHAR2,
23   X_ATTRIBUTE15 in VARCHAR2,
24   X_EMAIL in VARCHAR2,
25   X_PHONE in VARCHAR2,
26   X_ACTUAL_COST in NUMBER,
27   X_COORDINATOR_ID in NUMBER,
28   X_FUND_SOURCE_TYPE_CODE in VARCHAR2,
29   X_FUND_SOURCE_ID in NUMBER,
30   X_OWNER_USER_ID in NUMBER,
31   X_URL in VARCHAR2,
32   X_PRIORITY_TYPE_CODE in VARCHAR2,
33   X_CANCELLATION_REASON_CODE in VARCHAR2,
34   X_INBOUND_SCRIPT_NAME in VARCHAR2,
35   X_ATTRIBUTE_CATEGORY in VARCHAR2,
36   X_ATTRIBUTE1 in VARCHAR2,
37   X_ATTRIBUTE2 in VARCHAR2,
38   X_ATTRIBUTE3 in VARCHAR2,
39   X_FORECASTED_COST in NUMBER,
40   X_OBJECT_VERSION_NUMBER in NUMBER,
41   X_EVENT_LEVEL in VARCHAR2,
42   X_APPLICATION_ID in NUMBER,
43   X_EVENT_TYPE_CODE in VARCHAR2,
44   X_ACTIVE_FLAG in VARCHAR2,
45   X_PRIVATE_FLAG in VARCHAR2,
46   X_SYSTEM_STATUS_CODE in VARCHAR2,
47   X_LAST_STATUS_DATE in DATE,
48   X_STREAM_TYPE_CODE in VARCHAR2,
49   X_SOURCE_CODE in VARCHAR2,
50   X_ACTUAL_REVENUE in NUMBER,
51   X_EVENT_STANDALONE_FLAG in VARCHAR2,
52   X_DAY_OF_EVENT in VARCHAR2,
53   X_AGENDA_START_TIME in DATE,
54   X_AGENDA_END_TIME in DATE,
55   X_REG_REQUIRED_FLAG in VARCHAR2,
56   X_REG_CHARGE_FLAG in VARCHAR2,
57   X_REG_INVITED_ONLY_FLAG in VARCHAR2,
58   X_PARTNER_FLAG in VARCHAR2,
59   X_OVERFLOW_FLAG in VARCHAR2,
60   X_PARENT_EVENT_HEADER_ID in NUMBER,
61   X_DURATION in NUMBER,
62   X_DURATION_UOM_CODE in VARCHAR2,
63   X_ACTIVE_FROM_DATE in DATE,
64   X_ACTIVE_TO_DATE in DATE,
65   X_REG_MAXIMUM_CAPACITY in NUMBER,
66   X_REG_MINIMUM_CAPACITY in NUMBER,
67   X_MAIN_LANGUAGE_CODE in VARCHAR2,
68   X_CERT_CREDIT_TYPE_CODE in VARCHAR2,
69   X_CERTIFICATION_CREDITS in NUMBER,
70   X_INVENTORY_ITEM_ID in NUMBER,
71   X_FORECASTED_REVENUE in NUMBER,
72   X_EVENT_HEADER_NAME in VARCHAR2,
73   X_EVENT_MKTG_MESSAGE in VARCHAR2,
74   X_DESCRIPTION in VARCHAR2,
75   X_CREATION_DATE in DATE,
76   X_CREATED_BY in NUMBER,
77   X_LAST_UPDATE_DATE in DATE,
78   X_LAST_UPDATED_BY in NUMBER,
79   X_LAST_UPDATE_LOGIN in NUMBER);
80 procedure LOCK_ROW (
81   X_EVENT_HEADER_ID in NUMBER,
82   X_FUND_AMOUNT_TC in NUMBER,
83   X_FUND_AMOUNT_FC in NUMBER,
84   X_ATTRIBUTE4 in VARCHAR2,
85   X_USER_STATUS_ID in NUMBER,
86   X_ATTRIBUTE5 in VARCHAR2,
87   X_ATTRIBUTE6 in VARCHAR2,
88   X_ORGANIZATION_ID in NUMBER,
89   X_ATTRIBUTE7 in VARCHAR2,
90   X_ATTRIBUTE8 in VARCHAR2,
91   X_ATTRIBUTE9 in VARCHAR2,
92   X_ATTRIBUTE10 in VARCHAR2,
93   X_ATTRIBUTE11 in VARCHAR2,
94   X_ATTRIBUTE12 in VARCHAR2,
95   X_ATTRIBUTE13 in VARCHAR2,
96   X_ATTRIBUTE14 in VARCHAR2,
97   X_CURRENCY_CODE_TC in VARCHAR2,
98   X_CURRENCY_CODE_FC in VARCHAR2,
99   X_ATTRIBUTE15 in VARCHAR2,
100   X_EMAIL in VARCHAR2,
101   X_PHONE in VARCHAR2,
102   X_ACTUAL_COST in NUMBER,
103   X_COORDINATOR_ID in NUMBER,
104   X_FUND_SOURCE_TYPE_CODE in VARCHAR2,
105   X_FUND_SOURCE_ID in NUMBER,
106   X_OWNER_USER_ID in NUMBER,
107   X_URL in VARCHAR2,
108   X_PRIORITY_TYPE_CODE in VARCHAR2,
109   X_CANCELLATION_REASON_CODE in VARCHAR2,
110   X_INBOUND_SCRIPT_NAME in VARCHAR2,
111   X_ATTRIBUTE_CATEGORY in VARCHAR2,
112   X_ATTRIBUTE1 in VARCHAR2,
113   X_ATTRIBUTE2 in VARCHAR2,
114   X_ATTRIBUTE3 in VARCHAR2,
115   X_FORECASTED_COST in NUMBER,
116   X_OBJECT_VERSION_NUMBER in NUMBER,
117   X_EVENT_LEVEL in VARCHAR2,
118   X_APPLICATION_ID in NUMBER,
119   X_EVENT_TYPE_CODE in VARCHAR2,
120   X_ACTIVE_FLAG in VARCHAR2,
121   X_PRIVATE_FLAG in VARCHAR2,
122   X_SYSTEM_STATUS_CODE in VARCHAR2,
123   X_LAST_STATUS_DATE in DATE,
124   X_STREAM_TYPE_CODE in VARCHAR2,
125   X_SOURCE_CODE in VARCHAR2,
126   X_ACTUAL_REVENUE in NUMBER,
127   X_EVENT_STANDALONE_FLAG in VARCHAR2,
128   X_DAY_OF_EVENT in VARCHAR2,
129   X_AGENDA_START_TIME in DATE,
130   X_AGENDA_END_TIME in DATE,
131   X_REG_REQUIRED_FLAG in VARCHAR2,
132   X_REG_CHARGE_FLAG in VARCHAR2,
133   X_REG_INVITED_ONLY_FLAG in VARCHAR2,
134   X_PARTNER_FLAG in VARCHAR2,
135   X_OVERFLOW_FLAG in VARCHAR2,
136   X_PARENT_EVENT_HEADER_ID in NUMBER,
137   X_DURATION in NUMBER,
138   X_DURATION_UOM_CODE in VARCHAR2,
139   X_ACTIVE_FROM_DATE in DATE,
140   X_ACTIVE_TO_DATE in DATE,
141   X_REG_MAXIMUM_CAPACITY in NUMBER,
142   X_REG_MINIMUM_CAPACITY in NUMBER,
143   X_MAIN_LANGUAGE_CODE in VARCHAR2,
144   X_CERT_CREDIT_TYPE_CODE in VARCHAR2,
145   X_CERTIFICATION_CREDITS in NUMBER,
146   X_INVENTORY_ITEM_ID in NUMBER,
147   X_FORECASTED_REVENUE in NUMBER,
148   X_EVENT_HEADER_NAME in VARCHAR2,
149   X_EVENT_MKTG_MESSAGE in VARCHAR2,
150   X_DESCRIPTION in VARCHAR2
151 );
152 
153 
154 procedure UPDATE_ROW (
155   X_EVENT_HEADER_ID in NUMBER,
156   X_FUND_AMOUNT_TC in NUMBER,
157   X_FUND_AMOUNT_FC in NUMBER,
158   X_ATTRIBUTE4 in VARCHAR2,
159   X_USER_STATUS_ID in NUMBER,
160   X_ATTRIBUTE5 in VARCHAR2,
161   X_ATTRIBUTE6 in VARCHAR2,
162   X_ORGANIZATION_ID in NUMBER,
163   X_ATTRIBUTE7 in VARCHAR2,
164   X_ATTRIBUTE8 in VARCHAR2,
165   X_ATTRIBUTE9 in VARCHAR2,
166   X_ATTRIBUTE10 in VARCHAR2,
167   X_ATTRIBUTE11 in VARCHAR2,
168   X_ATTRIBUTE12 in VARCHAR2,
169   X_ATTRIBUTE13 in VARCHAR2,
170   X_ATTRIBUTE14 in VARCHAR2,
171   X_CURRENCY_CODE_TC in VARCHAR2,
172   X_CURRENCY_CODE_FC in VARCHAR2,
173   X_ATTRIBUTE15 in VARCHAR2,
174   X_EMAIL in VARCHAR2,
175   X_PHONE in VARCHAR2,
176   X_ACTUAL_COST in NUMBER,
177   X_COORDINATOR_ID in NUMBER,
178   X_FUND_SOURCE_TYPE_CODE in VARCHAR2,
179   X_FUND_SOURCE_ID in NUMBER,
180   X_OWNER_USER_ID in NUMBER,
181   X_URL in VARCHAR2,
182   X_PRIORITY_TYPE_CODE in VARCHAR2,
183   X_CANCELLATION_REASON_CODE in VARCHAR2,
184   X_INBOUND_SCRIPT_NAME in VARCHAR2,
185   X_ATTRIBUTE_CATEGORY in VARCHAR2,
186   X_ATTRIBUTE1 in VARCHAR2,
187   X_ATTRIBUTE2 in VARCHAR2,
188   X_ATTRIBUTE3 in VARCHAR2,
189   X_FORECASTED_COST in NUMBER,
190   X_OBJECT_VERSION_NUMBER in NUMBER,
191   X_EVENT_LEVEL in VARCHAR2,
192   X_APPLICATION_ID in NUMBER,
193   X_EVENT_TYPE_CODE in VARCHAR2,
194   X_ACTIVE_FLAG in VARCHAR2,
195   X_PRIVATE_FLAG in VARCHAR2,
196   X_SYSTEM_STATUS_CODE in VARCHAR2,
197   X_LAST_STATUS_DATE in DATE,
198   X_STREAM_TYPE_CODE in VARCHAR2,
199   X_SOURCE_CODE in VARCHAR2,
200   X_ACTUAL_REVENUE in NUMBER,
201   X_EVENT_STANDALONE_FLAG in VARCHAR2,
202   X_DAY_OF_EVENT in VARCHAR2,
203   X_AGENDA_START_TIME in DATE,
204   X_AGENDA_END_TIME in DATE,
205   X_REG_REQUIRED_FLAG in VARCHAR2,
206   X_REG_CHARGE_FLAG in VARCHAR2,
207   X_REG_INVITED_ONLY_FLAG in VARCHAR2,
208   X_PARTNER_FLAG in VARCHAR2,
209   X_OVERFLOW_FLAG in VARCHAR2,
210   X_PARENT_EVENT_HEADER_ID in NUMBER,
211   X_DURATION in NUMBER,
212   X_DURATION_UOM_CODE in VARCHAR2,
213   X_ACTIVE_FROM_DATE in DATE,
214   X_ACTIVE_TO_DATE in DATE,
215   X_REG_MAXIMUM_CAPACITY in NUMBER,
216   X_REG_MINIMUM_CAPACITY in NUMBER,
217   X_MAIN_LANGUAGE_CODE in VARCHAR2,
218   X_CERT_CREDIT_TYPE_CODE in VARCHAR2,
219   X_CERTIFICATION_CREDITS in NUMBER,
220   X_INVENTORY_ITEM_ID in NUMBER,
221   X_FORECASTED_REVENUE in NUMBER,
222   X_EVENT_HEADER_NAME in VARCHAR2,
223   X_EVENT_MKTG_MESSAGE in VARCHAR2,
224   X_DESCRIPTION in VARCHAR2,
225   X_LAST_UPDATE_DATE in DATE,
226   X_LAST_UPDATED_BY in NUMBER,
227   X_LAST_UPDATE_LOGIN in NUMBER
228 );
229 procedure DELETE_ROW (
230   X_EVENT_HEADER_ID in NUMBER
231 );
232 procedure ADD_LANGUAGE;
233 
234 procedure TRANSLATE_ROW(
235 	  X_EVENT_HEADER_ID		in NUMBER,
236 	  X_EVENT_HEADER_NAME	in VARCHAR2,
237 	  X_DESCRIPTION		in VARCHAR2,
238 	  X_EVENT_MKTG_MESSAGE  in VARCHAR2,
239 	  X_OWNER		in VARCHAR2
240  ) ;
241 
242 procedure LOAD_ROW (
243   X_EVENT_HEADER_ID in NUMBER,
244   X_FUND_AMOUNT_TC in NUMBER,
245   X_FUND_AMOUNT_FC in NUMBER,
246   X_ATTRIBUTE4 in VARCHAR2,
247   X_USER_STATUS_ID in NUMBER,
248   X_ATTRIBUTE5 in VARCHAR2,
249   X_ATTRIBUTE6 in VARCHAR2,
250   X_ORGANIZATION_ID in NUMBER,
251   X_ATTRIBUTE7 in VARCHAR2,
252   X_ATTRIBUTE8 in VARCHAR2,
253   X_ATTRIBUTE9 in VARCHAR2,
254   X_ATTRIBUTE10 in VARCHAR2,
255   X_ATTRIBUTE11 in VARCHAR2,
256   X_ATTRIBUTE12 in VARCHAR2,
257   X_ATTRIBUTE13 in VARCHAR2,
258   X_ATTRIBUTE14 in VARCHAR2,
259   X_CURRENCY_CODE_TC in VARCHAR2,
260   X_CURRENCY_CODE_FC in VARCHAR2,
261   X_ATTRIBUTE15 in VARCHAR2,
262   X_EMAIL in VARCHAR2,
263   X_PHONE in VARCHAR2,
264   X_ACTUAL_COST in NUMBER,
265   X_COORDINATOR_ID in NUMBER,
266   X_FUND_SOURCE_TYPE_CODE in VARCHAR2,
267   X_FUND_SOURCE_ID in NUMBER,
268   X_OWNER_USER_ID in NUMBER,
269   X_URL in VARCHAR2,
270   X_PRIORITY_TYPE_CODE in VARCHAR2,
271   X_CANCELLATION_REASON_CODE in VARCHAR2,
272   X_INBOUND_SCRIPT_NAME in VARCHAR2,
273   X_ATTRIBUTE_CATEGORY in VARCHAR2,
274   X_ATTRIBUTE1 in VARCHAR2,
275   X_ATTRIBUTE2 in VARCHAR2,
276   X_ATTRIBUTE3 in VARCHAR2,
277   X_FORECASTED_COST in NUMBER,
278   X_OBJECT_VERSION_NUMBER in NUMBER,
279   X_EVENT_LEVEL in VARCHAR2,
280   X_APPLICATION_ID in NUMBER,
281   X_EVENT_TYPE_CODE in VARCHAR2,
282   X_ACTIVE_FLAG in VARCHAR2,
283   X_PRIVATE_FLAG in VARCHAR2,
284   X_SYSTEM_STATUS_CODE in VARCHAR2,
285   X_LAST_STATUS_DATE in DATE,
286   X_STREAM_TYPE_CODE in VARCHAR2,
287   X_SOURCE_CODE in VARCHAR2,
288   X_ACTUAL_REVENUE in NUMBER,
289   X_EVENT_STANDALONE_FLAG in VARCHAR2,
290   X_DAY_OF_EVENT in VARCHAR2,
291   X_AGENDA_START_TIME in DATE,
292   X_AGENDA_END_TIME in DATE,
293   X_REG_REQUIRED_FLAG in VARCHAR2,
294   X_REG_CHARGE_FLAG in VARCHAR2,
295   X_REG_INVITED_ONLY_FLAG in VARCHAR2,
296   X_PARTNER_FLAG in VARCHAR2,
297   X_OVERFLOW_FLAG in VARCHAR2,
298   X_PARENT_EVENT_HEADER_ID in NUMBER,
299   X_DURATION in NUMBER,
300   X_DURATION_UOM_CODE in VARCHAR2,
301   X_ACTIVE_FROM_DATE in DATE,
302   X_ACTIVE_TO_DATE in DATE,
303   X_REG_MAXIMUM_CAPACITY in NUMBER,
304   X_REG_MINIMUM_CAPACITY in NUMBER,
305   X_MAIN_LANGUAGE_CODE in VARCHAR2,
306   X_CERT_CREDIT_TYPE_CODE in VARCHAR2,
307   X_CERTIFICATION_CREDITS in NUMBER,
308   X_INVENTORY_ITEM_ID in NUMBER,
309   X_FORECASTED_REVENUE in NUMBER,
310   X_EVENT_HEADER_NAME in VARCHAR2,
311   X_EVENT_MKTG_MESSAGE in VARCHAR2,
312   X_DESCRIPTION in VARCHAR2,
313   X_OWNER       in VARCHAR2
314 );
315 
316 
317 
318 end AMS_EVENT_HEADERS_ALL_PKG;