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