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