1 PACKAGE AMS_TRACKING_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvtrks.pls 115.9 2003/12/14 04:07:56 ryedator noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_TRACKING_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 -- Default number of records fetch per call
16 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
17 --================================================================
18 -- Start of Comments
19 -- -------------------------------------------------------
20 -- Record name
21 -- interaction_track_rec_type
22 -- -------------------------------------------------------
23 -- Parameters:
24 -- created_by
25 -- creation_date
26 -- last_updated_by
27 -- last_update_date
28 -- last_update_login
29 -- object_version_number
30 -- web_content_id
31 -- obj_type
32 -- obj_src_code
33 -- obj_id
34 -- offer_src_code
35 -- offer_id
36 -- party_id
37 -- affiliate_id
38 -- posting_id
39 -- did
40 -- flavour
41 -- web_tracking_id
42 -- Required
43 --
44 -- Defaults
45 --
46 -- Note: This is automatic generated record definition, it includes all columns
47 -- defined in the table, developer must manually add or delete some of the attributes.
48 --
49 -- End of Comments
50
51 --===================================================================
52 TYPE interaction_track_rec_type IS RECORD
53 (
54 created_by NUMBER := FND_API.G_MISS_NUM,
55 creation_date DATE := FND_API.G_MISS_DATE,
56 last_updated_by NUMBER := FND_API.G_MISS_NUM,
57 last_update_date DATE := FND_API.G_MISS_DATE,
58 last_update_login NUMBER := FND_API.G_MISS_NUM,
59 object_version_number NUMBER := FND_API.G_MISS_NUM,
60 web_content_id NUMBER := FND_API.G_MISS_NUM,
61 obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62 obj_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63 obj_id NUMBER := FND_API.G_MISS_NUM,
64 offer_src_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65 offer_id NUMBER := FND_API.G_MISS_NUM,
66 party_id NUMBER := FND_API.G_MISS_NUM,
67 affiliate_id NUMBER := FND_API.G_MISS_NUM,
68 posting_id NUMBER := FND_API.G_MISS_NUM,
69 did NUMBER := FND_API.G_MISS_NUM,
70 flavour VARCHAR2(30) := FND_API.G_MISS_CHAR,
71 web_tracking_id NUMBER := FND_API.G_MISS_NUM
72 );
73
74 g_miss_ps_strats_rec interaction_track_rec_type;
75
76 -- ========================================================================
77 -- Start of Comments
78 -- ========================================================================
79 -- API Name
80 -- Log_interaction
81 -- Type
82 -- Private
83 -- Pre-Req
84 --
85 -- Parameters
86 --
87 -- IN
88 -- p_api_version_number IN NUMBER Required
89 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92 -- p_track_rec IN interaction_track_rec_type Required
93 -- OUT
94 -- x_return_status OUT VARCHAR2
95 -- x_msg_count OUT NUMBER
96 -- x_msg_data OUT VARCHAR2
97 -- x_interaction_id OUT NUMBER
98 -- Version : Current version 1.0
99 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
100 -- and basic operation, developer must manually add parameters and business logic as necessary.
101 --
102 -- End of Comments
103 -- =======================================================================
104 --
105
106 PROCEDURE Log_interaction(
107 p_api_version_number IN NUMBER,
108 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109 p_commit IN VARCHAR2 := FND_API.G_FALSE,
110 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 x_interaction_id OUT NOCOPY NUMBER,
116
117 p_track_rec IN interaction_track_rec_type := g_miss_ps_strats_rec
118
119 );
120
121 -- ==========================================================================
122 -- Start of Comments
123 -- ==========================================================================
124 -- API Name
125 -- get_redirect_url
126 -- Type
127 -- Private
128 -- Pre-Req
129 --
130 -- IN
131 -- p_web_content_id IN NUMBER
132 -- Parameters
133 -- OUT
134 -- x_redirect_url OUT VARCHAR2
135 -- x_action_parameter_code OUT VARCHAR2
136 -- Version : Current version 1.0
137 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
138 -- and basic operation, developer must manually add parameters and business logic as necessary.
139 --
140 -- End of Comments
141 -- ==========================================================================
142 --
143 PROCEDURE get_redirect_url(
144 p_web_content_id IN NUMBER,
145 x_redirect_url OUT NOCOPY VARCHAR2,
146 x_action_parameter_code OUT NOCOPY VARCHAR2
147 );
148
149
150 -- ==========================================================================
151 -- Start of Comments
152 -- ==========================================================================
153 -- API Name
154 -- Log_redirect
155 -- Type
156 -- Private
157 -- Pre-Req
158 --
159 -- Parameters
160 --
161 -- IN
162 -- p_track_rec IN interaction_track_rec_type Required
163 --
164 -- OUT
165 -- x_redirect_url OUT VARCHAR2
166 -- x_interaction_id OUT NUMBER
167 -- x_action_parameter_code OUT VARCHAR2
168 -- Version : Current version 1.0
169 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
170 -- and basic operation, developer must manually add parameters and business logic as necessary.
171 --
172 -- End of Comments
173 -- ==========================================================================
174 --
175
176 PROCEDURE Log_redirect(
177 tracking_rec IN interaction_track_rec_type:=g_miss_ps_strats_rec,
178 x_redirect_url OUT NOCOPY VARCHAR2,
179 x_interaction_id OUT NOCOPY NUMBER ,
180 x_action_parameter_code OUT NOCOPY VARCHAR2
181 );
182
183
184 -- ==========================================================================
185 -- Start of Comments
186 -- ==========================================================================
187 -- API Name
188 -- weblite_log
189 -- Type
190 -- Private
191 -- Pre-Req
192 --
193 -- IN
194 -- p_web_content_id IN NUMBER
195 -- Parameters
196 -- OUT
197 -- x_interaction_id OUT VARCHAR2
198 -- x_msource OUT NOCOPY NUMBER
199 -- x_return_status OUT VARCHAR2
200 -- x_msg_count OUT VARCHAR2
201 -- x_msg_data OUT VARCHAR2
202 -- Version : Current version 1.0
203 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
204 -- and basic operation, developer must manually add parameters and business logic as necessary.
205 --
206 -- End of Comments
207 -- ==========================================================================
208 --
209 PROCEDURE weblite_log( tracking_rec IN interaction_track_rec_type := g_miss_ps_strats_rec,
210 x_interaction_id OUT NOCOPY NUMBER,
211 x_msource OUT NOCOPY NUMBER,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2
215 );
216
217 END AMS_TRACKING_PVT;