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_CAMPAIGNS_ALL_PKG

Source


1 package AMS_CAMPAIGNS_ALL_PKG AUTHID CURRENT_USER as
2 /* $Header: amslcpns.pls 115.5 2002/11/16 00:41:41 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 
90 procedure LOCK_ROW (
91   X_CAMPAIGN_ID in NUMBER,
92   X_OBJECT_VERSION_NUMBER in NUMBER,
93   X_OWNER_USER_ID in NUMBER,
94   X_USER_STATUS_ID in NUMBER,
95   X_STATUS_CODE in VARCHAR2,
96   X_STATUS_DATE in DATE,
97   X_ACTIVE_FLAG in VARCHAR2,
98   X_PRIVATE_FLAG in VARCHAR2,
99   X_PARTNER_FLAG in VARCHAR2,
100   X_TEMPLATE_FLAG in VARCHAR2,
101   X_CASCADE_SOURCE_CODE_FLAG in VARCHAR2,
102   X_INHERIT_ATTRIBUTES_FLAG in VARCHAR2,
103   X_SOURCE_CODE in VARCHAR2,
104   X_ROLLUP_TYPE in VARCHAR2,
105   X_CAMPAIGN_TYPE in VARCHAR2,
106   X_MEDIA_TYPE_CODE in VARCHAR2,
107   X_PRIORITY in VARCHAR2,
108   X_FUND_SOURCE_TYPE in VARCHAR2,
109   X_FUND_SOURCE_ID in NUMBER,
110   X_PARENT_CAMPAIGN_ID in NUMBER,
111   X_APPLICATION_ID in NUMBER,
112   X_QP_LIST_HEADER_ID in NUMBER,
113   X_MEDIA_ID in NUMBER,
114   X_CHANNEL_ID in NUMBER,
115   X_EVENT_TYPE in VARCHAR2,
116   X_ARC_CHANNEL_FROM in VARCHAR2,
117   X_DSCRIPT_NAME in VARCHAR2,
118   X_TRANSACTION_CURRENCY_CODE in VARCHAR2,
119   X_FUNCTIONAL_CURRENCY_CODE in VARCHAR2,
120   X_BUDGET_AMOUNT_TC in NUMBER,
121   X_BUDGET_AMOUNT_FC in NUMBER,
122   X_FORECASTED_PLAN_START_DATE in DATE,
123   X_FORECASTED_PLAN_END_DATE in DATE,
124   X_FORECASTED_EXEC_START_DATE in DATE,
125   X_FORECASTED_EXEC_END_DATE in DATE,
126   X_ACTUAL_PLAN_START_DATE in DATE,
127   X_ACTUAL_PLAN_END_DATE in DATE,
128   X_ACTUAL_EXEC_START_DATE in DATE,
129   X_ACTUAL_EXEC_END_DATE in DATE,
130   X_INBOUND_URL in VARCHAR2,
131   X_INBOUND_EMAIL_ID in VARCHAR2,
132   X_INBOUND_PHONE_NO in VARCHAR2,
133   X_DURATION in NUMBER,
134   X_DURATION_UOM_CODE in VARCHAR2,
135   X_FF_PRIORITY in VARCHAR2,
136   X_FF_OVERRIDE_COVER_LETTER in NUMBER,
137   X_FF_SHIPPING_METHOD in VARCHAR2,
138   X_FF_CARRIER in VARCHAR2,
139   X_CONTENT_SOURCE in VARCHAR2,
140   X_CC_CALL_STRATEGY in VARCHAR2,
141   X_CC_MANAGER_USER_ID in NUMBER,
142   X_FORECASTED_REVENUE in NUMBER,
143   X_ACTUAL_REVENUE in NUMBER,
144   X_FORECASTED_COST in NUMBER,
145   X_ACTUAL_COST in NUMBER,
146   X_FORECASTED_RESPONSE in NUMBER,
147   X_ACTUAL_RESPONSE in NUMBER,
148   X_TARGET_RESPONSE in NUMBER,
149   X_COUNTRY_CODE in VARCHAR2,
150   X_LANGUAGE_CODE in VARCHAR2,
151   X_ATTRIBUTE_CATEGORY in VARCHAR2,
152   X_ATTRIBUTE1 in VARCHAR2,
153   X_ATTRIBUTE2 in VARCHAR2,
154   X_ATTRIBUTE3 in VARCHAR2,
155   X_ATTRIBUTE4 in VARCHAR2,
156   X_ATTRIBUTE5 in VARCHAR2,
157   X_ATTRIBUTE6 in VARCHAR2,
158   X_ATTRIBUTE7 in VARCHAR2,
159   X_ATTRIBUTE8 in VARCHAR2,
160   X_ATTRIBUTE9 in VARCHAR2,
161   X_ATTRIBUTE10 in VARCHAR2,
162   X_ATTRIBUTE11 in VARCHAR2,
163   X_ATTRIBUTE12 in VARCHAR2,
164   X_ATTRIBUTE14 in VARCHAR2,
165   X_ATTRIBUTE13 in VARCHAR2,
166   X_ATTRIBUTE15 in VARCHAR2,
167   X_CAMPAIGN_NAME in VARCHAR2,
168   X_CAMPAIGN_THEME in VARCHAR2,
169   X_DESCRIPTION in VARCHAR2
170 );
171 
172 procedure UPDATE_ROW (
173   X_CAMPAIGN_ID in NUMBER,
174   X_OBJECT_VERSION_NUMBER in NUMBER,
175   X_OWNER_USER_ID in NUMBER,
176   X_USER_STATUS_ID in NUMBER,
177   X_STATUS_CODE in VARCHAR2,
178   X_STATUS_DATE in DATE,
179   X_ACTIVE_FLAG in VARCHAR2,
180   X_PRIVATE_FLAG in VARCHAR2,
181   X_PARTNER_FLAG in VARCHAR2,
182   X_TEMPLATE_FLAG in VARCHAR2,
183   X_CASCADE_SOURCE_CODE_FLAG in VARCHAR2,
184   X_INHERIT_ATTRIBUTES_FLAG in VARCHAR2,
185   X_SOURCE_CODE in VARCHAR2,
186   X_ROLLUP_TYPE in VARCHAR2,
187   X_CAMPAIGN_TYPE in VARCHAR2,
188   X_MEDIA_TYPE_CODE in VARCHAR2,
189   X_PRIORITY in VARCHAR2,
190   X_FUND_SOURCE_TYPE in VARCHAR2,
191   X_FUND_SOURCE_ID in NUMBER,
192   X_PARENT_CAMPAIGN_ID in NUMBER,
193   X_APPLICATION_ID in NUMBER,
194   X_QP_LIST_HEADER_ID in NUMBER,
195   X_MEDIA_ID in NUMBER,
196   X_CHANNEL_ID in NUMBER,
197   X_EVENT_TYPE in VARCHAR2,
198   X_ARC_CHANNEL_FROM in VARCHAR2,
199   X_DSCRIPT_NAME in VARCHAR2,
200   X_TRANSACTION_CURRENCY_CODE in VARCHAR2,
201   X_FUNCTIONAL_CURRENCY_CODE in VARCHAR2,
202   X_BUDGET_AMOUNT_TC in NUMBER,
203   X_BUDGET_AMOUNT_FC in NUMBER,
204   X_FORECASTED_PLAN_START_DATE in DATE,
205   X_FORECASTED_PLAN_END_DATE in DATE,
206   X_FORECASTED_EXEC_START_DATE in DATE,
207   X_FORECASTED_EXEC_END_DATE in DATE,
208   X_ACTUAL_PLAN_START_DATE in DATE,
209   X_ACTUAL_PLAN_END_DATE in DATE,
210   X_ACTUAL_EXEC_START_DATE in DATE,
211   X_ACTUAL_EXEC_END_DATE in DATE,
212   X_INBOUND_URL in VARCHAR2,
213   X_INBOUND_EMAIL_ID in VARCHAR2,
214   X_INBOUND_PHONE_NO in VARCHAR2,
215   X_DURATION in NUMBER,
216   X_DURATION_UOM_CODE in VARCHAR2,
217   X_FF_PRIORITY in VARCHAR2,
218   X_FF_OVERRIDE_COVER_LETTER in NUMBER,
219   X_FF_SHIPPING_METHOD in VARCHAR2,
220   X_FF_CARRIER in VARCHAR2,
221   X_CONTENT_SOURCE in VARCHAR2,
222   X_CC_CALL_STRATEGY in VARCHAR2,
223   X_CC_MANAGER_USER_ID in NUMBER,
224   X_FORECASTED_REVENUE in NUMBER,
225   X_ACTUAL_REVENUE in NUMBER,
226   X_FORECASTED_COST in NUMBER,
227   X_ACTUAL_COST in NUMBER,
228   X_FORECASTED_RESPONSE in NUMBER,
229   X_ACTUAL_RESPONSE in NUMBER,
230   X_TARGET_RESPONSE in NUMBER,
231   X_COUNTRY_CODE in VARCHAR2,
232   X_LANGUAGE_CODE in VARCHAR2,
233   X_ATTRIBUTE_CATEGORY in VARCHAR2,
234   X_ATTRIBUTE1 in VARCHAR2,
235   X_ATTRIBUTE2 in VARCHAR2,
236   X_ATTRIBUTE3 in VARCHAR2,
237   X_ATTRIBUTE4 in VARCHAR2,
238   X_ATTRIBUTE5 in VARCHAR2,
239   X_ATTRIBUTE6 in VARCHAR2,
240   X_ATTRIBUTE7 in VARCHAR2,
241   X_ATTRIBUTE8 in VARCHAR2,
242   X_ATTRIBUTE9 in VARCHAR2,
243   X_ATTRIBUTE10 in VARCHAR2,
244   X_ATTRIBUTE11 in VARCHAR2,
245   X_ATTRIBUTE12 in VARCHAR2,
246   X_ATTRIBUTE14 in VARCHAR2,
247   X_ATTRIBUTE13 in VARCHAR2,
248   X_ATTRIBUTE15 in VARCHAR2,
249   X_CAMPAIGN_NAME in VARCHAR2,
250   X_CAMPAIGN_THEME in VARCHAR2,
251   X_DESCRIPTION in VARCHAR2,
252   X_LAST_UPDATE_DATE in DATE,
253   X_LAST_UPDATED_BY in NUMBER,
254   X_LAST_UPDATE_LOGIN in NUMBER
255 );
256 
257 procedure DELETE_ROW (
258   X_CAMPAIGN_ID in NUMBER
259 );
260 
261 procedure ADD_LANGUAGE;
262 
263 procedure TRANSLATE_ROW(
264   X_CAMPAIGN_ID in NUMBER,
265   X_CAMPAIGN_NAME in VARCHAR2,
266   X_CAMPAIGN_THEME in VARCHAR2,
267   X_DESCRIPTION in VARCHAR2,
268   X_OWNER in VARCHAR2
269 );
270 
271 procedure  LOAD_ROW(
272   X_CAMPAIGN_ID in NUMBER,
273   X_OBJECT_VERSION_NUMBER in NUMBER,
274   X_OWNER_USER_ID in NUMBER,
275   X_USER_STATUS_ID in NUMBER,
276   X_STATUS_CODE in VARCHAR2,
277   X_STATUS_DATE in DATE,
278   X_ACTIVE_FLAG in VARCHAR2,
279   X_PRIVATE_FLAG in VARCHAR2,
280   X_PARTNER_FLAG in VARCHAR2,
281   X_TEMPLATE_FLAG in VARCHAR2,
282   X_CASCADE_SOURCE_CODE_FLAG in VARCHAR2,
283   X_INHERIT_ATTRIBUTES_FLAG in VARCHAR2,
284   X_SOURCE_CODE in VARCHAR2,
285   X_ROLLUP_TYPE in VARCHAR2,
286   X_CAMPAIGN_TYPE in VARCHAR2,
287   X_MEDIA_TYPE_CODE in VARCHAR2,
288   X_PRIORITY in VARCHAR2,
289   X_FUND_SOURCE_TYPE in VARCHAR2,
290   X_FUND_SOURCE_ID in NUMBER,
291   X_PARENT_CAMPAIGN_ID in NUMBER,
292   X_APPLICATION_ID in NUMBER,
293   X_QP_LIST_HEADER_ID in NUMBER,
294   X_MEDIA_ID in NUMBER,
295   X_CHANNEL_ID in NUMBER,
296   X_EVENT_TYPE in VARCHAR2,
297   X_ARC_CHANNEL_FROM in VARCHAR2,
298   X_DSCRIPT_NAME in VARCHAR2,
299   X_TRANSACTION_CURRENCY_CODE in VARCHAR2,
300   X_FUNCTIONAL_CURRENCY_CODE in VARCHAR2,
301   X_BUDGET_AMOUNT_TC in NUMBER,
302   X_BUDGET_AMOUNT_FC in NUMBER,
303   X_FORECASTED_PLAN_START_DATE in DATE,
304   X_FORECASTED_PLAN_END_DATE in DATE,
305   X_FORECASTED_EXEC_START_DATE in DATE,
306   X_FORECASTED_EXEC_END_DATE in DATE,
307   X_ACTUAL_PLAN_START_DATE in DATE,
308   X_ACTUAL_PLAN_END_DATE in DATE,
309   X_ACTUAL_EXEC_START_DATE in DATE,
310   X_ACTUAL_EXEC_END_DATE in DATE,
311   X_INBOUND_URL in VARCHAR2,
312   X_INBOUND_EMAIL_ID in VARCHAR2,
313   X_INBOUND_PHONE_NO in VARCHAR2,
314   X_DURATION in NUMBER,
315   X_DURATION_UOM_CODE in VARCHAR2,
316   X_FF_PRIORITY in VARCHAR2,
317   X_FF_OVERRIDE_COVER_LETTER in NUMBER,
318   X_FF_SHIPPING_METHOD in VARCHAR2,
319   X_FF_CARRIER in VARCHAR2,
320   X_CONTENT_SOURCE in VARCHAR2,
321   X_CC_CALL_STRATEGY in VARCHAR2,
322   X_CC_MANAGER_USER_ID in NUMBER,
323   X_FORECASTED_REVENUE in NUMBER,
324   X_ACTUAL_REVENUE in NUMBER,
325   X_FORECASTED_COST in NUMBER,
326   X_ACTUAL_COST in NUMBER,
327   X_FORECASTED_RESPONSE in NUMBER,
328   X_ACTUAL_RESPONSE in NUMBER,
329   X_TARGET_RESPONSE in NUMBER,
330   X_COUNTRY_CODE in VARCHAR2,
331   X_LANGUAGE_CODE in VARCHAR2,
332   X_ATTRIBUTE_CATEGORY in VARCHAR2,
333   X_ATTRIBUTE1 in VARCHAR2,
337   X_ATTRIBUTE5 in VARCHAR2,
334   X_ATTRIBUTE2 in VARCHAR2,
335   X_ATTRIBUTE3 in VARCHAR2,
336   X_ATTRIBUTE4 in VARCHAR2,
338   X_ATTRIBUTE6 in VARCHAR2,
339   X_ATTRIBUTE7 in VARCHAR2,
340   X_ATTRIBUTE8 in VARCHAR2,
341   X_ATTRIBUTE9 in VARCHAR2,
342   X_ATTRIBUTE10 in VARCHAR2,
343   X_ATTRIBUTE11 in VARCHAR2,
344   X_ATTRIBUTE12 in VARCHAR2,
345   X_ATTRIBUTE14 in VARCHAR2,
346   X_ATTRIBUTE13 in VARCHAR2,
347   X_ATTRIBUTE15 in VARCHAR2,
348   X_CAMPAIGN_NAME in VARCHAR2,
349   X_CAMPAIGN_THEME in VARCHAR2,
350   X_DESCRIPTION in VARCHAR2,
351   X_OWNER in VARCHAR2
352 );
353 
354 end AMS_CAMPAIGNS_ALL_PKG;