1 PACKAGE ams_copyelements_pvt AS
2 /* $Header: amsvcpes.pls 120.2 2007/12/26 09:35:56 spragupa ship $ */
3
4 -- Start Of Comments
5 --
6 -- Name:
7 -- Ams_CopyElements_PVT
8 --
9 -- Purpose:
10 -- This is the specification for copying the different elements
11 -- in Oracle Marketing.
12 -- These procedures will be called by marketing activities such as campaigns,
13 -- deliverables,events,etc while copying them.
14 -- Called from AMS_COPYACTIVITIES_PVT
15 -- This should be called from inside AMS only and not by any
16 -- external source for copying campaigns
17 -- Procedures:
18 -- copy_act_objectives (see below for specification)
19 -- copy_act_offers (see below for specification)
20 -- copy_act_offer_products (see below for specification)
21 -- copy_act_sripts (see below for specification)
22 -- copy_act_resources (see below for specification)
23 -- copy_act_products (see below for specification)
24 -- copy_act_cells (see below for specification)
25 -- copy_act_geo_area (see below for specification)
26 -- copy_act_attachments (see below for specification)
27 -- copy_object_associations (see below for specification)
28 -- copy_act_list_headers (see below for specification)
29 -- copy_act_access (see below for specification)
30 -- copy_list_select_actions (see below for specification)
31 -- Notes:
32 --
33 -- History:
34 -- 05/25/1999 Mumu Pande Updated Comments
35 -- ams_CopyElements_PVT package.
36 -- 05/15/1999 Mumu Pande Created ([email protected])
37 -- 07/11/2000 skarumur
38 -- Added the following procedures
39 -- copy_tasks (see below for specification)
40 -- copy_partners (see below for specification)
41 -- Removed the following procedures
42 -- copy_act_offers
43 -- copy_act_offers
44 -- 05-Apr-2001 choang - Added copy_list_select_actions
45 -- - added g_attribute task, team and trng
46 -- 18-Aug-2001 ptendulk Added copy_act_schedules to copy schedules
47 -- 25-jan-2002 soagrawa Added copy_act_content to copy content
48 -- 01-may-2003 nyostos Added G_ATTRIBUTE_SELC to copy Scoring Run Data Selections
49 -- 30-sep-2003 soagrawa Added API copy_act_collateral
50 -- 06-oct-2003 soagrawa Added API copy_target_group
51 -- 24-Dec-2007 spragupa ER - 6467510 - Extend Copy functionality to include TASKS for campaign schedules/activities
52 -- End Of Comments
53
54 -- global constants
55 --
56 -- choang - 05-apr-2001
57 -- add attributes/elements for copy here using the format:
58 -- G_ATTRIBUTE_xxxx, and in alphabetical order
59 G_ATTRIBUTE_CELL CONSTANT VARCHAR2(30) := 'CELL';
60 G_ATTRIBUTE_PROD CONSTANT VARCHAR2(30) := 'PROD';
61 -- nyostos - 01-may-2003
62 -- Added to copy data selections for Scoring Runs.
63 G_ATTRIBUTE_SELC CONSTANT VARCHAR2(30) := 'SELC';
64 G_ATTRIBUTE_TASK CONSTANT VARCHAR2(30) := 'TASK';
65 G_ATTRIBUTE_TEAM CONSTANT VARCHAR2(30) := 'TEAM';
66 G_ATTRIBUTE_TRNG CONSTANT VARCHAR2(30) := 'TRNG';
67
68
69 -- Sub-Program unit declarations
70 /* Copy products from campaign,event headers,event offerings - all activities */
71 PROCEDURE copy_act_prod (
72 p_src_act_type IN VARCHAR2,
73 p_new_act_type IN VARCHAR2 := NULL,
74 p_src_act_id IN NUMBER,
75 p_new_act_id IN NUMBER,
76 p_errnum OUT NOCOPY NUMBER,
77 p_errcode OUT NOCOPY VARCHAR2,
78 p_errmsg OUT NOCOPY VARCHAR2
79 );
80
81 /* Copy associations of campaign,deliverables,events - all activities.
82 The procedure has flags .Depending on yes or no of the flag the
83 campaigns,deliverables, event offering, event headers would be copied.
84 Should be noted that all these components use the same activity
85 object association table*/
86
87 PROCEDURE copy_object_associations (
88 p_src_act_type IN VARCHAR2,
89 p_new_act_type IN VARCHAR2 := NULL,
90 p_src_act_id IN NUMBER,
91 p_new_act_id IN NUMBER,
92 p_errnum OUT NOCOPY NUMBER,
93 p_errcode OUT NOCOPY VARCHAR2,
94 p_errmsg OUT NOCOPY VARCHAR2
95 );
96
97 -- Sub-Program unit declarations
98
99 -- Sub-Program unit declarations
100 /* Copy geo_areas from campaign,event headers,event offerings -
101 all activities */
102
103 PROCEDURE copy_act_geo_areas (
104 p_src_act_type IN VARCHAR2,
105 p_new_act_type IN VARCHAR2 := NULL,
106 p_src_act_id IN NUMBER,
107 p_new_act_id IN NUMBER,
108 p_errnum OUT NOCOPY NUMBER,
109 p_errcode OUT NOCOPY VARCHAR2,
110 p_errmsg OUT NOCOPY VARCHAR2
111 );
112
113 -- Sub-Program unit declarations
114 /* Copy resources from campaign,event headers,event offerings -
115 all activities */
116
117 /* commented OUT NOCOPY by murali on may 13-2002 we don't support copying resource
118 PROCEDURE copy_act_resources (
119 p_src_act_type IN VARCHAR2,
120 p_new_act_type IN VARCHAR2 := NULL,
121 p_src_act_id IN NUMBER,
122 p_new_act_id IN NUMBER,
123 p_errnum OUT NOCOPY NUMBER,
124 p_errcode OUT NOCOPY VARCHAR2,
125 p_errmsg OUT NOCOPY VARCHAR2
126 );
127 */
128 -- Sub-Program unit declarations
129 /* Copy attachments from campaign,event headers,event offerings -
130 all activities */
131
132 PROCEDURE copy_act_attachments (
133 p_src_act_type IN VARCHAR2,
134 p_new_act_type IN VARCHAR2 := NULL,
135 p_src_act_id IN NUMBER,
136 p_new_act_id IN NUMBER,
137 p_errnum OUT NOCOPY NUMBER,
138 p_errcode OUT NOCOPY VARCHAR2,
139 p_errmsg OUT NOCOPY VARCHAR2
140 );
141 -- Sub-Program unit declarations
142 /* Copy access from campaign,event headers,event offerings -
143 all activities */
144
145 PROCEDURE copy_act_access (
146 p_src_act_type IN VARCHAR2,
147 p_new_act_type IN VARCHAR2 := NULL,
148 p_src_act_id IN NUMBER,
149 p_new_act_id IN NUMBER,
150 p_errnum OUT NOCOPY NUMBER,
151 p_errcode OUT NOCOPY VARCHAR2,
152 p_errmsg OUT NOCOPY VARCHAR2
153 );
154
155 -- Sub-Program unit declarations
156 /* Copy delivkits from campaign,event headers,event offerings - all
157 activities */
158
159 PROCEDURE copy_deliv_kits (
160 p_src_deli_id IN NUMBER,
161 p_new_deliv_id IN NUMBER,
162 p_errnum OUT NOCOPY NUMBER,
163 p_errcode OUT NOCOPY VARCHAR2,
164 p_errmsg OUT NOCOPY VARCHAR2
165 );
166
167 /* Copy categories from campaign,event headers,event offerings -
168 all activities */
169 PROCEDURE copy_act_categories (
170 p_src_act_type IN VARCHAR2,
171 p_new_act_type IN VARCHAR2 := NULL,
172 p_src_act_id IN NUMBER,
173 p_new_act_id IN NUMBER,
174 p_errnum OUT NOCOPY NUMBER,
175 p_errcode OUT NOCOPY VARCHAR2,
176 p_errmsg OUT NOCOPY VARCHAR2
177 );
178 /* Copy messages from campaign,event headers,event offerings - all activities */
179 PROCEDURE copy_act_messages (
180 p_src_act_type IN VARCHAR2,
181 p_new_act_type IN VARCHAR2 := NULL,
182 p_src_act_id IN NUMBER,
183 p_new_act_id IN NUMBER,
184 p_errnum OUT NOCOPY NUMBER,
185 p_errcode OUT NOCOPY VARCHAR2,
186 p_errmsg OUT NOCOPY VARCHAR2
187
188 );
189
190 /* Copy market segments from campaign,event headers,event offerings -
191 all activities */
192 PROCEDURE copy_act_market_segments (
193 p_src_act_type IN VARCHAR2,
194 p_new_act_type IN VARCHAR2 := NULL,
195 p_src_act_id IN NUMBER,
196 p_new_act_id IN NUMBER,
197 p_errnum OUT NOCOPY NUMBER,
198 p_errcode OUT NOCOPY VARCHAR2,
199 p_errmsg OUT NOCOPY VARCHAR2
200 );
201
202
203 /* Copy camapign schdelues from campaign - all activities */
204
205 -- removed by soagrawa on 02-oct-2002
206 -- refer to bug# 2605184
207
208 /*
209 PROCEDURE copy_campaign_schedules (
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 x_campaign_schedule_id OUT NOCOPY NUMBER,
216 p_src_camp_schedule_id IN NUMBER,
217 p_new_camp_id IN NUMBER
218 );
219 */
220 PROCEDURE copy_tasks (
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_old_camp_id IN NUMBER,
227 p_new_camp_id IN NUMBER,
228 p_task_id IN NUMBER,
229 p_owner_id IN NUMBER,
230 p_actual_due_date IN DATE
231 );
232
233 PROCEDURE copy_partners (
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_old_camp_id IN NUMBER,
240 p_new_camp_id IN NUMBER
241 );
242
243
244 --
245 -- Purpose
246 -- Copy list select actions for a given object
247 -- to a new object of the same type.
248 PROCEDURE copy_list_select_actions (
249 p_api_version IN NUMBER,
250 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
251 p_commit IN VARCHAR2 := FND_API.G_FALSE,
252 x_return_status OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER,
254 x_msg_data OUT NOCOPY VARCHAR2,
255 p_object_type IN VARCHAR2,
256 p_src_object_id IN NUMBER,
257 p_tar_object_id IN NUMBER
258 );
259
260 -- copy partners - generic type i.e. not just for CAMP
261 PROCEDURE copy_partners_generic (
262 p_api_version IN NUMBER,
263 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2,
267 p_old_id IN NUMBER,
268 p_new_id IN NUMBER,
269 p_type IN VARCHAR2
270 );
271
272 --======================================================================
273 -- FUNCTION
274 -- copy_act_schedules
275 --
276 -- PURPOSE
277 -- Created to copy schedules for the campaign.
278 --
279 -- HISTORY
280 -- 18-Aug-2001 ptendulk Create.
281 --======================================================================
282 PROCEDURE copy_act_schedules(
283 p_old_camp_id IN NUMBER,
284 p_new_camp_id IN NUMBER,
285 p_new_start_date IN DATE,
286 x_return_status OUT NOCOPY VARCHAR2,
287 x_msg_count OUT NOCOPY NUMBER,
288 x_msg_data OUT NOCOPY VARCHAR2) ;
289
290 --======================================================================
291 -- FUNCTION
292 -- copy_selected_schedule
293 --
294 -- PURPOSE
295 -- Created to copy selected schedules of the campaign.
296 --
297 -- HISTORY
298 -- 04-Sep-2001 rrajesh Created.
299 --======================================================================
300
301 PROCEDURE copy_selected_schedule(
302 p_old_camp_id IN NUMBER,
303 p_new_camp_id IN NUMBER,
304 p_old_schedule_id IN NUMBER,
305 p_new_start_date IN DATE,
306 p_new_end_date IN DATE,
307 x_return_status OUT NOCOPY VARCHAR2,
308 x_msg_count OUT NOCOPY NUMBER,
309 x_msg_data OUT NOCOPY VARCHAR2);
310
311
312 --======================================================================
313 -- FUNCTION
314 -- copy_act_content
315 --
316 -- PURPOSE
317 -- Created to copy content bug# 2175580
318 --
319 -- HISTORY
320 -- 25-jan-2002 soagrawa Created.
321 --======================================================================
322
323 PROCEDURE copy_act_content (
324 p_src_act_type IN VARCHAR2,
325 p_new_act_type IN VARCHAR2 := NULL,
326 p_src_act_id IN NUMBER,
327 p_new_act_id IN NUMBER,
328 p_errnum OUT NOCOPY NUMBER,
329 p_errcode OUT NOCOPY VARCHAR2,
330 p_errmsg OUT NOCOPY VARCHAR2
331 );
332
333 --======================================================================
334 -- FUNCTION
335 -- copy_act_collateral
336 --
337 -- PURPOSE
338 -- Created to copy collateral for 11.5.10
339 --
340 -- HISTORY
341 -- 30-sep-2003 soagrawa Created.
342 --======================================================================
343
344 PROCEDURE copy_act_collateral (
345 p_src_act_type IN VARCHAR2,
346 p_new_act_type IN VARCHAR2 := NULL,
347 p_src_act_id IN NUMBER,
348 p_new_act_id IN NUMBER,
349 p_errnum OUT NOCOPY NUMBER,
350 p_errcode OUT NOCOPY VARCHAR2,
351 p_errmsg OUT NOCOPY VARCHAR2
352 );
353
354 --======================================================================
355 -- FUNCTION
356 -- copy_target_group
357 --
358 -- PURPOSE
359 -- Created to copy target group for 11.5.10
360 --
361 -- HISTORY
362 -- 06-oct-2003 sodixit Created.
363 --======================================================================
364
365 PROCEDURE copy_target_group (
366 p_src_act_type IN VARCHAR2,
367 p_new_act_type IN VARCHAR2 := NULL,
368 p_src_act_id IN NUMBER,
369 p_new_act_id IN NUMBER,
370 p_errnum OUT NOCOPY NUMBER,
371 p_errcode OUT NOCOPY VARCHAR2,
372 p_errmsg OUT NOCOPY VARCHAR2
373 );
374
375
376 -- Sub-Program unit declarations
377 -- added by spragupa on 23-nov-2007 for ER 6467510 - For extending COPY functionality for TASKS
378 /* Copy tasks from one activity to other */
379 PROCEDURE copy_act_task (
380 p_src_act_type IN VARCHAR2,
381 p_new_act_type IN VARCHAR2 := NULL,
382 p_src_act_id IN NUMBER,
383 p_new_act_id IN NUMBER,
384 p_errnum OUT NOCOPY NUMBER,
385 p_errcode OUT NOCOPY VARCHAR2,
386 p_errmsg OUT NOCOPY VARCHAR2
387 );
388
389
390 END ams_copyelements_pvt;
[Home] [Help]