[Home] [Help]
PACKAGE: APPS.AMS_WEBMARKETING_PVT
Source
1 PACKAGE AMS_WEBMARKETING_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvwpps.pls 120.1 2005/08/04 21:51:31 appldev noship $ */
3
4
5 TYPE web_mp_track_rec_type IS RECORD(
6 application_id NUMBER ,
7 placement_id NUMBER ,
8 placement_citem_id NUMBER ,
9 placement_mp_id NUMBER ,
10 content_item_id NUMBER ,
11 citem_version_id NUMBER ,
12 display_priority NUMBER ,
13 publish_flag VARCHAR2(1) ,
14 activity_id NUMBER ,
15 max_recommendations NUMBER ,
16 object_used_by_id NUMBER ,
17 object_used_by VARCHAR2(30) ,
18 security_group_id NUMBER ,
19 object_version_number NUMBER ,
20 creation_date DATE ,
21 creation_by NUMBER ,
22 attribute_category VARCHAR2(30) ,
23 attribute1 VARCHAR2(150) ,
24 attribute2 VARCHAR2(150) ,
25 attribute3 VARCHAR2(150) ,
26 attribute4 VARCHAR2(150) ,
27 attribute5 VARCHAR2(150) ,
28 attribute6 VARCHAR2(150) ,
29 attribute7 VARCHAR2(150) ,
30 attribute8 VARCHAR2(150) ,
31 attribute9 VARCHAR2(150) ,
32 attribute10 VARCHAR2(150) ,
33 attribute11 VARCHAR2(150) ,
34 attribute12 VARCHAR2(150) ,
35 attribute13 VARCHAR2(150) ,
36 attribute14 VARCHAR2(150) ,
37 attribute15 VARCHAR2(150) ,
38 content_type_code VARCHAR2(100) ,
39 placement_mp_title VARCHAR2(240) ,
40 last_update_date DATE ,
41 last_updated_by NUMBER ,
42 last_update_login NUMBER
43 );
44
45
46 g_miss_web_mp_track_rec web_mp_track_rec_type;
47 TYPE web_mp_track_tbl_type IS TABLE OF web_mp_track_rec_type INDEX BY BINARY_INTEGER;
48 g_miss_web_mp_track_tbl web_mp_track_tbl_type;
49
50 -- ========================================================================
51 -- PROCEDURE
52 -- handles successful API call for a row during Web ADI ->
53 -- WebMarketing integration call
54 -- Purpose
55 -- COMMIT successful row in database
56 -- HISTORY
57 --
58 -- ========================================================================
59
60 PROCEDURE CREATE_WEB_PLCE_ASSOC (
61 p_api_version_number IN NUMBER := 1.0,
62 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63 p_commit IN VARCHAR2 := FND_API.G_FALSE,
64 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65 p_web_mp_rec IN web_mp_track_rec_type := g_miss_web_mp_track_rec,
66 x_placement_mp_id OUT NOCOPY NUMBER,
67 x_placement_citem_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 x_return_status OUT NOCOPY VARCHAR2
71 );
72
73
74
75 -- ========================================================================
76 -- PROCEDURE
77 -- handles successful API call for a row during Web ADI ->
78 -- WebMarketing integration call
79 -- Purpose
80 -- COMMIT successful row in database
81 -- HISTORY
82 --
83 -- ========================================================================
84
85 PROCEDURE WEBMARKETING_PLCE_CONTENT_TYPE (
86 p_api_version_number IN NUMBER := 1.0,
87 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88 p_commit IN VARCHAR2 := FND_API.G_FALSE,
89 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90 p_placement_mp_id IN NUMBER,
91 placement_id IN NUMBER,
92 x_content_type OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 x_return_status OUT NOCOPY VARCHAR2
96 );
97
98
99 -- ========================================================================
100 -- PROCEDURE
101 -- Integration API Call for WebPlacement Content Status for Approval Process- ->
102 -- WebMarketing integration call
103 -- Purpose
104 -- WebMarketing integration call for Campaign Activity Approval Process
105 -- HISTORY
106 --
107 -- ========================================================================
108
109 PROCEDURE WEBMARKETING_CONTENT_STATUS (
110 p_api_version_number IN NUMBER := 1.0,
111 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113 p_campaign_activity_id IN NUMBER,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 x_return_status OUT NOCOPY VARCHAR2
117 );
118
119
120
121
122 END AMS_WEBMARKETING_PVT;