[Home] [Help]
PACKAGE BODY: APPS.AMS_WEB_TRACK_PKG
Source
1 PACKAGE BODY AMS_Web_Track_PKG as
2 /* $Header: amstwtgb.pls 120.1 2005/06/27 05:40:55 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Web_Track_PKG
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
20 G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Web_Track_PKG';
21 G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstwtgb.pls';
22
23
24
25
26 -- ========================================================
27 --
28 -- NAME
29 -- Insert_Row
30 --
31 -- PURPOSE
32 --
33 -- NOTES
34 --
35 -- HISTORY
36 --
37 -- ========================================================
38 PROCEDURE Insert_Row(
39 px_web_tracking_id IN OUT NOCOPY NUMBER,
40 p_schedule_id NUMBER,
41 p_party_id NUMBER,
42 p_placement_id NUMBER,
43 p_content_item_id NUMBER,
44 p_last_update_date DATE,
45 p_last_updated_by NUMBER,
46 p_creation_date DATE,
47 p_created_by NUMBER,
48 p_last_update_login NUMBER,
49 px_object_version_number IN OUT NOCOPY NUMBER,
50 p_attribute_category VARCHAR2,
51 p_attribute1 VARCHAR2,
52 p_attribute2 VARCHAR2,
53 p_attribute3 VARCHAR2,
54 p_attribute4 VARCHAR2,
55 p_attribute5 VARCHAR2,
56 p_attribute6 VARCHAR2,
57 p_attribute7 VARCHAR2,
58 p_attribute8 VARCHAR2,
59 p_attribute9 VARCHAR2,
60 p_attribute10 VARCHAR2,
61 p_attribute11 VARCHAR2,
62 p_attribute12 VARCHAR2,
63 p_attribute13 VARCHAR2,
64 p_attribute14 VARCHAR2,
65 p_attribute15 VARCHAR2)
66
67 IS
68 x_rowid VARCHAR2(30);
69
70
71 BEGIN
72
73
74 px_object_version_number := nvl(px_object_version_number, 1);
75
76
77 INSERT INTO ams_web_tracking(
78 web_tracking_id,
79 schedule_id,
80 party_id,
81 placement_id,
82 content_item_id,
83 last_update_date,
84 last_updated_by,
85 creation_date,
86 created_by,
87 last_update_login,
88 object_version_number,
89 attribute_category,
90 attribute1,
91 attribute2,
92 attribute3,
93 attribute4,
94 attribute5,
95 attribute6,
96 attribute7,
97 attribute8,
98 attribute9,
99 attribute10,
100 attribute11,
101 attribute12,
102 attribute13,
103 attribute14,
104 attribute15
105 ) VALUES (
106 DECODE( px_web_tracking_id, FND_API.G_MISS_NUM, NULL, px_web_tracking_id),
107 DECODE( p_schedule_id, FND_API.G_MISS_NUM, NULL, p_schedule_id),
108 DECODE( p_party_id, FND_API.G_MISS_NUM, NULL, p_party_id),
109 DECODE( p_placement_id, FND_API.G_MISS_NUM, NULL, p_placement_id),
110 DECODE( p_content_item_id, FND_API.G_MISS_NUM, NULL, p_content_item_id),
111 DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
112 DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
113 DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
114 DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
115 DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
116 DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
117 DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
118 DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
119 DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
120 DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
121 DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
122 DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
123 DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
124 DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
125 DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
126 DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
127 DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
128 DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
129 DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
130 DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
131 DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
132 DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
133
134 END Insert_Row;
135
136
137
138
139 -- ========================================================
140 --
141 -- NAME
142 -- Update_Row
143 --
144 -- PURPOSE
145 --
146 -- NOTES
147 --
148 -- HISTORY
149 --
150 -- ========================================================
151 PROCEDURE Update_Row(
152 p_web_tracking_id NUMBER,
153 p_schedule_id NUMBER,
154 p_party_id NUMBER,
155 p_placement_id NUMBER,
156 p_content_item_id NUMBER,
157 p_last_update_date DATE,
158 p_last_updated_by NUMBER,
159 p_last_update_login NUMBER,
160 p_object_version_number IN NUMBER,
161 p_attribute_category VARCHAR2,
162 p_attribute1 VARCHAR2,
163 p_attribute2 VARCHAR2,
164 p_attribute3 VARCHAR2,
165 p_attribute4 VARCHAR2,
166 p_attribute5 VARCHAR2,
167 p_attribute6 VARCHAR2,
168 p_attribute7 VARCHAR2,
169 p_attribute8 VARCHAR2,
170 p_attribute9 VARCHAR2,
171 p_attribute10 VARCHAR2,
172 p_attribute11 VARCHAR2,
173 p_attribute12 VARCHAR2,
174 p_attribute13 VARCHAR2,
175 p_attribute14 VARCHAR2,
176 p_attribute15 VARCHAR2)
177
178 IS
179 BEGIN
180 Update ams_web_tracking
181 SET
182 web_tracking_id = DECODE( p_web_tracking_id, null, web_tracking_id, FND_API.G_MISS_NUM, null, p_web_tracking_id),
183 schedule_id = DECODE( p_schedule_id, null, schedule_id, FND_API.G_MISS_NUM, null, p_schedule_id),
184 party_id = DECODE( p_party_id, null, party_id, FND_API.G_MISS_NUM, null, p_party_id),
185 placement_id = DECODE( p_placement_id, null, placement_id, FND_API.G_MISS_NUM, null, p_placement_id),
186 content_item_id = DECODE( p_content_item_id, null, content_item_id, FND_API.G_MISS_NUM, null, p_content_item_id),
187 last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
188 last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
189 last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
190 object_version_number = nvl(p_object_version_number,0) + 1 ,
191 attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
192 attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
193 attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
194 attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
195 attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
196 attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
197 attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
198 attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
199 attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
200 attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
201 attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
202 attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
203 attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
204 attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
205 attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
206 attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
207 WHERE web_tracking_id = p_web_tracking_id
208 AND object_version_number = p_object_version_number;
209
210
211 IF (SQL%NOTFOUND) THEN
212 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213 END IF;
214
215
216 END Update_Row;
217
218
219
220
221 -- ========================================================
222 --
223 -- NAME
224 -- Delete_Row
225 --
226 -- PURPOSE
227 --
228 -- NOTES
229 --
230 -- HISTORY
231 --
232 -- ========================================================
233 PROCEDURE Delete_Row(
234 p_web_tracking_id NUMBER,
235 p_object_version_number NUMBER)
236 IS
237 BEGIN
238 DELETE FROM ams_web_tracking
239 WHERE web_tracking_id = p_web_tracking_id
240 AND object_version_number = p_object_version_number;
241 If (SQL%NOTFOUND) then
242 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243 End If;
244 END Delete_Row ;
245
246
247
248
249
250 -- ========================================================
251 --
252 -- NAME
253 -- Lock_Row
254 --
255 -- PURPOSE
256 --
257 -- NOTES
258 --
259 -- HISTORY
260 --
261 -- ========================================================
262 PROCEDURE Lock_Row(
263 p_web_tracking_id NUMBER,
264 p_object_version_number NUMBER)
265 IS
266 CURSOR C IS
267 SELECT *
268 FROM ams_web_tracking
269 WHERE web_tracking_id = p_web_tracking_id
270 AND object_version_number = p_object_version_number
271 FOR UPDATE OF web_tracking_id NOWAIT;
272 Recinfo C%ROWTYPE;
273 BEGIN
274
275 OPEN c;
276 FETCH c INTO Recinfo;
277 IF (c%NOTFOUND) THEN
278 CLOSE c;
279 AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
280 RAISE FND_API.g_exc_error;
281 END IF;
282 CLOSE c;
283 END Lock_Row;
284
285
286
287 END AMS_Web_Track_PKG;