1 PACKAGE AMS_Web_Track_PVT AS
2 /* $Header: amsvwtgs.pls 120.1 2005/06/27 05:42:20 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Web_Track_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- web_track_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- web_tracking_id
29 -- schedule_id
30 -- party_id
31 -- placement_id
32 -- content_item_id
33 -- last_update_date
34 -- last_updated_by
35 -- creation_date
36 -- created_by
37 -- last_update_login
38 -- object_version_number
39 -- attribute_category
40 -- attribute1
41 -- attribute2
42 -- attribute3
43 -- attribute4
44 -- attribute5
45 -- attribute6
46 -- attribute7
47 -- attribute8
48 -- attribute9
49 -- attribute10
50 -- attribute11
51 -- attribute12
52 -- attribute13
53 -- attribute14
54 -- attribute15
55 --
56 -- Required
57 --
58 -- Defaults
59 --
60 -- Note: This is automatic generated record definition, it includes all columns
61 -- defined in the table, developer must manually add or delete some of the attributes.
62 --
63 -- End of Comments
64
65 --===================================================================
66 TYPE web_track_rec_type IS RECORD
67 (
68 web_tracking_id NUMBER,
69 schedule_id NUMBER,
70 schedule_type VARCHAR2(30),
71 party_id NUMBER,
72 placement_id NUMBER,
73 content_item_id NUMBER,
74 last_update_date DATE,
75 last_updated_by NUMBER,
76 creation_date DATE,
77 created_by NUMBER,
78 last_update_login NUMBER,
79 object_version_number NUMBER,
80 attribute_category VARCHAR2(30),
81 attribute1 VARCHAR2(150),
82 attribute2 VARCHAR2(150),
83 attribute3 VARCHAR2(150),
84 attribute4 VARCHAR2(150),
85 attribute5 VARCHAR2(150),
86 attribute6 VARCHAR2(150),
87 attribute7 VARCHAR2(150),
88 attribute8 VARCHAR2(150),
89 attribute9 VARCHAR2(150),
90 attribute10 VARCHAR2(150),
91 attribute11 VARCHAR2(150),
92 attribute12 VARCHAR2(150),
93 attribute13 VARCHAR2(150),
94 attribute14 VARCHAR2(150),
95 attribute15 VARCHAR2(150)
96 );
97
98 g_miss_web_track_rec web_track_rec_type := NULL;
99 TYPE web_track_tbl_type IS TABLE OF web_track_rec_type INDEX BY BINARY_INTEGER;
100 g_miss_web_track_tbl web_track_tbl_type;
101
102 -- ==============================================================================
103 -- Start of Comments
104 -- ==============================================================================
105 -- API Name
106 -- Create_Web_Track
107 -- Type
108 -- Private
109 -- Pre-Req
110 --
111 -- Parameters
112 --
113 -- IN
114 -- p_api_version_number IN NUMBER Required
115 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
116 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
117 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
118 -- p_web_track_rec IN web_track_rec_type Required
119 --
120 -- OUT
121 -- x_return_status OUT VARCHAR2
122 -- x_msg_count OUT NUMBER
123 -- x_msg_data OUT VARCHAR2
124 -- Version : Current version 1.0
125 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
126 -- and basic operation, developer must manually add parameters and business logic as necessary.
127 --
128 -- History
129 --
130 -- NOTE
131 --
132 -- End of Comments
133 -- ==============================================================================
134
135 PROCEDURE Create_Web_Track(
136 p_api_version_number IN NUMBER,
137 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138 p_commit IN VARCHAR2 := FND_API.G_FALSE,
139 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144
145 p_web_track_rec IN web_track_rec_type := g_miss_web_track_rec,
146 x_web_tracking_id OUT NOCOPY NUMBER
147 );
148
149 -- ==============================================================================
150 -- Start of Comments
151 -- ==============================================================================
152 -- API Name
153 -- Update_Web_Track
154 -- Type
155 -- Private
156 -- Pre-Req
157 --
158 -- Parameters
159 --
160 -- IN
161 -- p_api_version_number IN NUMBER Required
162 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
163 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
164 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
165 -- p_web_track_rec IN web_track_rec_type Required
166 --
167 -- OUT
168 -- x_return_status OUT VARCHAR2
169 -- x_msg_count OUT NUMBER
170 -- x_msg_data OUT VARCHAR2
171 -- Version : Current version 1.0
172 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
173 -- and basic operation, developer must manually add parameters and business logic as necessary.
174 --
175 -- History
176 --
177 -- NOTE
178 --
179 -- End of Comments
180 -- ==============================================================================
181
182 PROCEDURE Update_Web_Track(
183 p_api_version_number IN NUMBER,
184 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185 p_commit IN VARCHAR2 := FND_API.G_FALSE,
186 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191
192 p_web_track_rec IN web_track_rec_type
193 );
194
195 -- ==============================================================================
196 -- Start of Comments
197 -- ==============================================================================
198 -- API Name
199 -- Delete_Web_Track
200 -- Type
201 -- Private
202 -- Pre-Req
203 --
204 -- Parameters
205 --
206 -- IN
207 -- p_api_version_number IN NUMBER Required
208 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
209 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
210 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
211 -- p_web_tracking_id IN NUMBER
212 -- p_object_version_number IN NUMBER Optional Default = NULL
213 --
214 -- OUT
215 -- x_return_status OUT VARCHAR2
216 -- x_msg_count OUT NUMBER
217 -- x_msg_data OUT VARCHAR2
218 -- Version : Current version 1.0
219 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
220 -- and basic operation, developer must manually add parameters and business logic as necessary.
221 --
222 -- History
223 --
224 -- NOTE
225 --
226 -- End of Comments
227 -- ==============================================================================
228
229 PROCEDURE Delete_Web_Track(
230 p_api_version_number IN NUMBER,
231 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232 p_commit IN VARCHAR2 := FND_API.G_FALSE,
233 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2,
237 p_web_tracking_id IN NUMBER,
238 p_object_version_number IN NUMBER
239 );
240
241 -- ==============================================================================
242 -- Start of Comments
243 -- ==============================================================================
244 -- API Name
245 -- Lock_Web_Track
246 -- Type
247 -- Private
248 -- Pre-Req
249 --
250 -- Parameters
251 --
252 -- IN
253 -- p_api_version_number IN NUMBER Required
254 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
255 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
256 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
257 -- p_web_track_rec IN web_track_rec_type Required
258 --
259 -- OUT
260 -- x_return_status OUT VARCHAR2
261 -- x_msg_count OUT NUMBER
262 -- x_msg_data OUT VARCHAR2
263 -- Version : Current version 1.0
264 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
265 -- and basic operation, developer must manually add parameters and business logic as necessary.
266 --
267 -- History
268 --
269 -- NOTE
270 --
271 -- End of Comments
272 -- ==============================================================================
273
274 PROCEDURE Lock_Web_Track(
275 p_api_version_number IN NUMBER,
276 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
277
278 x_return_status OUT NOCOPY VARCHAR2,
279 x_msg_count OUT NOCOPY NUMBER,
280 x_msg_data OUT NOCOPY VARCHAR2,
281
282 p_web_tracking_id IN NUMBER,
283 p_object_version IN NUMBER
284 );
285
286
287 -- ==============================================================================
288 -- Start of Comments
289 -- ==============================================================================
290 -- API Name
291 -- Validate_Web_Track
292 --
293 -- Version : Current version 1.0
294 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
295 -- For create: G_CREATE, for update: G_UPDATE
296 -- Note: 1. This is automated generated item level validation procedure.
297 -- The actual validation detail is needed to be added.
298 -- 2. We can also validate table instead of record. There will be an option for user to choose.
299 --
300 -- History
301 --
302 -- NOTE
303 --
304 -- End of Comments
305 -- ==============================================================================
306
307
308 PROCEDURE Validate_Web_Track(
309 p_api_version_number IN NUMBER,
310 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
311 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
312 p_web_track_rec IN web_track_rec_type,
313 p_validation_mode IN VARCHAR2,
314 x_return_status OUT NOCOPY VARCHAR2,
315 x_msg_count OUT NOCOPY NUMBER,
316 x_msg_data OUT NOCOPY VARCHAR2
317 );
318
319 -- ==============================================================================
320 -- Start of Comments
321 -- ==============================================================================
322 -- API Name
323 -- Web_Track_Items
324 --
325 -- Version : Current version 1.0
326 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
327 -- For create: G_CREATE, for update: G_UPDATE
328 -- Note: 1. This is automated generated item level validation procedure.
329 -- The actual validation detail is needed to be added.
330 -- 2. Validate the unique keys, lookups here
331 --
332 -- History
333 --
334 -- NOTE
335 --
336 -- End of Comments
337 -- ==============================================================================
338
339
340 PROCEDURE Check_Web_Track_Items (
341 P_web_track_rec IN web_track_rec_type,
342 p_validation_mode IN VARCHAR2,
343 x_return_status OUT NOCOPY VARCHAR2
344 );
345
346 -- ==============================================================================
347 -- Start of Comments
348 -- ==============================================================================
349 -- API Name
350 -- Validate_Web_Track_Rec
351 --
352 -- Version : Current version 1.0
353 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
354 -- For create: G_CREATE, for update: G_UPDATE
355 -- Note: 1. This is automated generated item level validation procedure.
356 -- The actual validation detail is needed to be added.
357 -- 2. Developer can manually added inter-field level validation.
358 --
359 -- History
360 --
361 -- NOTE
362 --
363 -- End of Comments
364 -- ==============================================================================
365
366
367 PROCEDURE Validate_Web_Track_Rec (
368 p_api_version_number IN NUMBER,
369 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
370 x_return_status OUT NOCOPY VARCHAR2,
371 x_msg_count OUT NOCOPY NUMBER,
372 x_msg_data OUT NOCOPY VARCHAR2,
373 p_web_track_rec IN web_track_rec_type
374 );
375
376
377 TYPE web_recomms_rec_type IS RECORD
378 (
379 web_recomm_id NUMBER,
380 web_tracking_id NUMBER,
381 recomm_object_id NUMBER,
382 recomm_type VARCHAR2(80),
383 rule_id NUMBER,
384 offer_id NUMBER,
385 offer_src_code VARCHAR2(30),
386 last_update_date DATE,
387 last_updated_by NUMBER,
388 creation_date DATE,
392 attribute_category VARCHAR2(30),
389 created_by NUMBER,
390 last_update_login NUMBER,
391 object_version_number NUMBER,
393 attribute1 VARCHAR2(150),
394 attribute2 VARCHAR2(150),
395 attribute3 VARCHAR2(150),
396 attribute4 VARCHAR2(150),
397 attribute5 VARCHAR2(150),
398 attribute6 VARCHAR2(150),
399 attribute7 VARCHAR2(150),
400 attribute8 VARCHAR2(150),
401 attribute9 VARCHAR2(150),
402 attribute10 VARCHAR2(150),
403 attribute11 VARCHAR2(150),
404 attribute12 VARCHAR2(150),
405 attribute13 VARCHAR2(150),
406 attribute14 VARCHAR2(150),
407 attribute15 VARCHAR2(150)
408 );
409
410 g_miss_web_recomms_rec web_recomms_rec_type := NULL;
411 TYPE web_recomms_tbl_type IS TABLE OF web_recomms_rec_type INDEX BY BINARY_INTEGER;
412 g_miss_web_recomms_tbl web_recomms_tbl_type;
413
414 -- ==============================================================================
415 -- Start of Comments
416 -- ==============================================================================
417 -- API Name
418 -- Create_Web_Recomms
419 -- Type
420 -- Private
421 -- Pre-Req
422 --
423 -- Parameters
424 --
425 -- IN
426 -- p_api_version_number IN NUMBER Required
427 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
428 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
429 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
430 -- p_web_recomms_rec IN web_recomms_rec_type Required
431 --
432 -- OUT
433 -- x_return_status OUT VARCHAR2
434 -- x_msg_count OUT NUMBER
435 -- x_msg_data OUT VARCHAR2
436 -- Version : Current version 1.0
437 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
438 -- and basic operation, developer must manually add parameters and business logic as necessary.
439 --
440 -- History
441 --
442 -- NOTE
443 --
444 -- End of Comments
445 -- ==============================================================================
446
447 PROCEDURE Create_Web_Recomms(
448 p_api_version_number IN NUMBER,
449 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
450 p_commit IN VARCHAR2 := FND_API.G_FALSE,
451 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
452
453 x_return_status OUT NOCOPY VARCHAR2,
454 x_msg_count OUT NOCOPY NUMBER,
455 x_msg_data OUT NOCOPY VARCHAR2,
456
457 p_web_recomms_rec IN web_recomms_rec_type := g_miss_web_recomms_rec,
458 x_web_recomm_id OUT NOCOPY NUMBER
459 );
460
461 -- ==============================================================================
462 -- Start of Comments
463 -- ==============================================================================
464 -- API Name
465 -- Update_Web_Recomms
466 -- Type
467 -- Private
468 -- Pre-Req
469 --
470 -- Parameters
471 --
472 -- IN
473 -- p_api_version_number IN NUMBER Required
474 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
475 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
476 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
477 -- p_web_recomms_rec IN web_recomms_rec_type Required
478 --
479 -- OUT
480 -- x_return_status OUT VARCHAR2
481 -- x_msg_count OUT NUMBER
482 -- x_msg_data OUT VARCHAR2
483 -- Version : Current version 1.0
484 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
485 -- and basic operation, developer must manually add parameters and business logic as necessary.
486 --
487 -- History
488 --
489 -- NOTE
490 --
491 -- End of Comments
492 -- ==============================================================================
493
494 PROCEDURE Update_Web_Recomms(
495 p_api_version_number IN NUMBER,
496 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
497 p_commit IN VARCHAR2 := FND_API.G_FALSE,
498 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
499
500 x_return_status OUT NOCOPY VARCHAR2,
501 x_msg_count OUT NOCOPY NUMBER,
502 x_msg_data OUT NOCOPY VARCHAR2,
503
504 p_web_recomms_rec IN web_recomms_rec_type
505 );
506
507 -- ==============================================================================
511 -- Delete_Web_Recomms
508 -- Start of Comments
509 -- ==============================================================================
510 -- API Name
512 -- Type
513 -- Private
514 -- Pre-Req
515 --
516 -- Parameters
517 --
518 -- IN
519 -- p_api_version_number IN NUMBER Required
520 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
521 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
522 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
523 -- p_web_recomm_id IN NUMBER
524 -- p_object_version_number IN NUMBER Optional Default = NULL
525 --
526 -- OUT
527 -- x_return_status OUT VARCHAR2
528 -- x_msg_count OUT NUMBER
529 -- x_msg_data OUT VARCHAR2
530 -- Version : Current version 1.0
531 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
532 -- and basic operation, developer must manually add parameters and business logic as necessary.
533 --
534 -- History
535 --
536 -- NOTE
537 --
538 -- End of Comments
539 -- ==============================================================================
540
541 PROCEDURE Delete_Web_Recomms(
542 p_api_version_number IN NUMBER,
543 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
544 p_commit IN VARCHAR2 := FND_API.G_FALSE,
545 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
546 x_return_status OUT NOCOPY VARCHAR2,
547 x_msg_count OUT NOCOPY NUMBER,
548 x_msg_data OUT NOCOPY VARCHAR2,
549 p_web_recomm_id IN NUMBER,
550 p_object_version_number IN NUMBER
551 );
552
553 -- ==============================================================================
554 -- Start of Comments
555 -- ==============================================================================
556 -- API Name
557 -- Lock_Web_Recomms
558 -- Type
559 -- Private
560 -- Pre-Req
561 --
562 -- Parameters
563 --
564 -- IN
565 -- p_api_version_number IN NUMBER Required
566 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
567 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
568 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
569 -- p_web_recomms_rec IN web_recomms_rec_type Required
570 --
571 -- OUT
572 -- x_return_status OUT VARCHAR2
573 -- x_msg_count OUT NUMBER
574 -- x_msg_data OUT VARCHAR2
575 -- Version : Current version 1.0
576 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
577 -- and basic operation, developer must manually add parameters and business logic as necessary.
578 --
579 -- History
580 --
581 -- NOTE
582 --
583 -- End of Comments
584 -- ==============================================================================
585
586 PROCEDURE Lock_Web_Recomms(
587 p_api_version_number IN NUMBER,
588 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
589
590 x_return_status OUT NOCOPY VARCHAR2,
591 x_msg_count OUT NOCOPY NUMBER,
592 x_msg_data OUT NOCOPY VARCHAR2,
593
594 p_web_recomm_id IN NUMBER,
595 p_object_version IN NUMBER
596 );
597
598
599 -- ==============================================================================
600 -- Start of Comments
601 -- ==============================================================================
602 -- API Name
603 -- Validate_Web_Recomms
604 --
605 -- Version : Current version 1.0
606 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
607 -- For create: G_CREATE, for update: G_UPDATE
608 -- Note: 1. This is automated generated item level validation procedure.
609 -- The actual validation detail is needed to be added.
610 -- 2. We can also validate table instead of record. There will be an option for user to choose.
611 --
612 -- History
613 --
614 -- NOTE
615 --
616 -- End of Comments
617 -- ==============================================================================
618
619
620 PROCEDURE Validate_Web_Recomms(
621 p_api_version_number IN NUMBER,
622 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
623 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
624 p_web_recomms_rec IN web_recomms_rec_type,
625 p_validation_mode IN VARCHAR2,
626 x_return_status OUT NOCOPY VARCHAR2,
627 x_msg_count OUT NOCOPY NUMBER,
628 x_msg_data OUT NOCOPY VARCHAR2
629 );
630
631 -- ==============================================================================
632 -- Start of Comments
633 -- ==============================================================================
634 -- API Name
635 -- Web_Recomms_Items
636 --
637 -- Version : Current version 1.0
638 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
639 -- For create: G_CREATE, for update: G_UPDATE
640 -- Note: 1. This is automated generated item level validation procedure.
641 -- The actual validation detail is needed to be added.
642 -- 2. Validate the unique keys, lookups here
643 --
644 -- History
645 --
646 -- NOTE
647 --
648 -- End of Comments
649 -- ==============================================================================
650
651
652 PROCEDURE Check_Web_Recomms_Items (
653 P_web_recomms_rec IN web_recomms_rec_type,
654 p_validation_mode IN VARCHAR2,
655 x_return_status OUT NOCOPY VARCHAR2
656 );
657
658 -- ==============================================================================
659 -- Start of Comments
660 -- ==============================================================================
661 -- API Name
662 -- Validate_Web_Recomms_Rec
663 --
664 -- Version : Current version 1.0
665 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
666 -- For create: G_CREATE, for update: G_UPDATE
667 -- Note: 1. This is automated generated item level validation procedure.
668 -- The actual validation detail is needed to be added.
669 -- 2. Developer can manually added inter-field level validation.
670 --
671 -- History
672 --
673 -- NOTE
674 --
675 -- End of Comments
676 -- ==============================================================================
677
678
679 PROCEDURE Validate_Web_Recomms_Rec (
680 p_api_version_number IN NUMBER,
681 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
682 x_return_status OUT NOCOPY VARCHAR2,
683 x_msg_count OUT NOCOPY NUMBER,
684 x_msg_data OUT NOCOPY VARCHAR2,
685 p_web_recomms_rec IN web_recomms_rec_type
686 );
687
688
689
690 TYPE impr_obj_id_rec_type is record (
691 obj_id number,
692 impr_track_id number);
693
694 -- objid is ctdid for webadv/offer and prodid for webprod
695
696 TYPE impr_obj_id_tbl_type IS TABLE OF impr_obj_id_rec_type INDEX BY BINARY_INTEGER;
697
698
699 PROCEDURE Create_Web_Imp_Track(
700 p_api_version_number IN NUMBER,
701 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
702 p_commit IN VARCHAR2 := FND_API.G_FALSE,
703 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
704 p_web_track_rec IN web_track_rec_type,
705 p_web_recomms_tbl IN web_recomms_tbl_type,
706 --p_web_prod IN VARCHAR2,
707 x_impr_obj_id_rec OUT NOCOPY impr_obj_id_tbl_type,
708 x_return_status OUT NOCOPY VARCHAR2,
709 x_msg_count OUT NOCOPY NUMBER,
710 x_msg_data OUT NOCOPY VARCHAR2
711 );
712
713
714
715 END AMS_Web_Track_PVT;