[Home] [Help]
PACKAGE BODY: APPS.ASO_TAX_DETAILS_PKG
Source
1 PACKAGE BODY ASO_TAX_DETAILS_PKG as
2 /* $Header: asottaxb.pls 120.2 2005/08/30 04:58:06 anrajan ship $ */
3 -- Start of Comments
4 -- Package name : ASO_TAX_DETAILS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_TAX_DETAILS_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asottaxb.pls';
13
14 --Added the TAX_RATE_ID column in INSERT_ROW,UPDATE_ROW and LOCK_ROW procedures
15 --by Anoop Rajan on 30 August 2005.
16 PROCEDURE Insert_Row(
17 px_TAX_DETAIL_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
18 p_CREATION_DATE DATE,
19 p_CREATED_BY NUMBER,
20 p_LAST_UPDATE_DATE DATE,
21 p_LAST_UPDATED_BY NUMBER,
22 p_LAST_UPDATE_LOGIN NUMBER,
23 p_REQUEST_ID NUMBER,
24 p_PROGRAM_APPLICATION_ID NUMBER,
25 p_PROGRAM_ID NUMBER,
26 p_PROGRAM_UPDATE_DATE DATE,
27 p_QUOTE_HEADER_ID NUMBER,
28 p_QUOTE_LINE_ID NUMBER,
29 p_QUOTE_SHIPMENT_ID NUMBER,
30 p_ORIG_TAX_CODE VARCHAR2,
31 p_TAX_CODE VARCHAR2,
32 p_TAX_RATE NUMBER,
33 p_TAX_DATE DATE,
34 p_TAX_AMOUNT NUMBER,
35 p_TAX_EXEMPT_FLAG VARCHAR2,
36 p_TAX_EXEMPT_NUMBER VARCHAR2,
37 p_TAX_EXEMPT_REASON_CODE VARCHAR2,
38 p_ATTRIBUTE_CATEGORY VARCHAR2,
39 p_ATTRIBUTE1 VARCHAR2,
40 p_ATTRIBUTE2 VARCHAR2,
41 p_ATTRIBUTE3 VARCHAR2,
42 p_ATTRIBUTE4 VARCHAR2,
43 p_ATTRIBUTE5 VARCHAR2,
44 p_ATTRIBUTE6 VARCHAR2,
45 p_ATTRIBUTE7 VARCHAR2,
46 p_ATTRIBUTE8 VARCHAR2,
47 p_ATTRIBUTE9 VARCHAR2,
48 p_ATTRIBUTE10 VARCHAR2,
49 p_ATTRIBUTE11 VARCHAR2,
50 p_ATTRIBUTE12 VARCHAR2,
51 p_ATTRIBUTE13 VARCHAR2,
52 p_ATTRIBUTE14 VARCHAR2,
53 p_ATTRIBUTE15 VARCHAR2,
54 p_ATTRIBUTE16 VARCHAR2,
55 p_ATTRIBUTE17 VARCHAR2,
56 p_ATTRIBUTE18 VARCHAR2,
57 p_ATTRIBUTE19 VARCHAR2,
58 p_ATTRIBUTE20 VARCHAR2,
59 p_TAX_INCLUSIVE_FLAG VARCHAR2,
60 p_OBJECT_VERSION_NUMBER NUMBER,
61 p_TAX_RATE_ID NUMBER
62 )
63
64 IS
65 CURSOR C2 IS SELECT ASO_TAX_DETAILS_S.nextval FROM sys.dual;
66 BEGIN
67 If (px_TAX_DETAIL_ID IS NULL) OR (px_TAX_DETAIL_ID = FND_API.G_MISS_NUM) then
68 OPEN C2;
69 FETCH C2 INTO px_TAX_DETAIL_ID;
70 CLOSE C2;
71 End If;
72 INSERT INTO ASO_TAX_DETAILS(
73 TAX_DETAIL_ID,
74 CREATION_DATE,
75 CREATED_BY,
76 LAST_UPDATE_DATE,
77 LAST_UPDATED_BY,
78 LAST_UPDATE_LOGIN,
79 REQUEST_ID,
80 PROGRAM_APPLICATION_ID,
81 PROGRAM_ID,
82 PROGRAM_UPDATE_DATE,
83 QUOTE_HEADER_ID,
84 QUOTE_LINE_ID,
85 QUOTE_SHIPMENT_ID,
86 ORIG_TAX_CODE,
87 TAX_CODE,
88 TAX_RATE,
89 TAX_DATE,
90 TAX_AMOUNT,
91 TAX_EXEMPT_FLAG,
92 TAX_EXEMPT_NUMBER,
93 TAX_EXEMPT_REASON_CODE,
94 ATTRIBUTE_CATEGORY,
95 ATTRIBUTE1,
96 ATTRIBUTE2,
97 ATTRIBUTE3,
98 ATTRIBUTE4,
99 ATTRIBUTE5,
100 ATTRIBUTE6,
101 ATTRIBUTE7,
102 ATTRIBUTE8,
103 ATTRIBUTE9,
104 ATTRIBUTE10,
105 ATTRIBUTE11,
106 ATTRIBUTE12,
107 ATTRIBUTE13,
108 ATTRIBUTE14,
109 ATTRIBUTE15,
110 ATTRIBUTE16,
111 ATTRIBUTE17,
112 ATTRIBUTE18,
113 ATTRIBUTE19,
114 ATTRIBUTE20,
115 TAX_INCLUSIVE_FLAG,
116 OBJECT_VERSION_NUMBER,
117 TAX_RATE_ID
118 ) VALUES (
119 px_TAX_DETAIL_ID,
120 ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
121 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
122 ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
123 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
124 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
125 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
126 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
127 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
128 ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
129 decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
130 decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
131 decode( p_QUOTE_SHIPMENT_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_SHIPMENT_ID),
132 decode( p_ORIG_TAX_CODE, FND_API.G_MISS_CHAR, NULL, p_ORIG_TAX_CODE),
133 decode( p_TAX_CODE, FND_API.G_MISS_CHAR, NULL, p_TAX_CODE),
134 decode( p_TAX_RATE, FND_API.G_MISS_NUM, NULL, p_TAX_RATE),
135 ASO_UTILITY_PVT.decode( p_TAX_DATE, FND_API.G_MISS_DATE, NULL, p_TAX_DATE),
136 decode( p_TAX_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TAX_AMOUNT),
137 decode( p_TAX_EXEMPT_FLAG, FND_API.G_MISS_CHAR, NULL, p_TAX_EXEMPT_FLAG),
138 decode( p_TAX_EXEMPT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_TAX_EXEMPT_NUMBER),
139 decode( p_TAX_EXEMPT_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_TAX_EXEMPT_REASON_CODE),
140 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
141 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
142 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
143 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
144 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
145 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
146 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
147 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
148 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
149 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
150 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
151 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
152 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
153 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
154 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
155 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
156 decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
157 decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
158 decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
159 decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
160 decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
161 decode( p_TAX_INCLUSIVE_FLAG, FND_API.G_MISS_CHAR, NULL, p_TAX_INCLUSIVE_FLAG),
162 decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER),
163 decode( p_TAX_RATE_ID, FND_API.G_MISS_NUM, NULL, p_TAX_RATE_ID)
164 );
165 End Insert_Row;
166
167 PROCEDURE Update_Row(
168 p_TAX_DETAIL_ID NUMBER,
169 p_CREATION_DATE DATE,
170 p_CREATED_BY NUMBER,
171 p_LAST_UPDATE_DATE DATE,
172 p_LAST_UPDATED_BY NUMBER,
173 p_LAST_UPDATE_LOGIN NUMBER,
174 p_REQUEST_ID NUMBER,
175 p_PROGRAM_APPLICATION_ID NUMBER,
176 p_PROGRAM_ID NUMBER,
177 p_PROGRAM_UPDATE_DATE DATE,
178 p_QUOTE_HEADER_ID NUMBER,
179 p_QUOTE_LINE_ID NUMBER,
180 p_QUOTE_SHIPMENT_ID NUMBER,
181 p_ORIG_TAX_CODE VARCHAR2,
182 p_TAX_CODE VARCHAR2,
183 p_TAX_RATE NUMBER,
184 p_TAX_DATE DATE,
185 p_TAX_AMOUNT NUMBER,
186 p_TAX_EXEMPT_FLAG VARCHAR2,
187 p_TAX_EXEMPT_NUMBER VARCHAR2,
188 p_TAX_EXEMPT_REASON_CODE VARCHAR2,
189 p_ATTRIBUTE_CATEGORY VARCHAR2,
190 p_ATTRIBUTE1 VARCHAR2,
191 p_ATTRIBUTE2 VARCHAR2,
192 p_ATTRIBUTE3 VARCHAR2,
193 p_ATTRIBUTE4 VARCHAR2,
194 p_ATTRIBUTE5 VARCHAR2,
195 p_ATTRIBUTE6 VARCHAR2,
196 p_ATTRIBUTE7 VARCHAR2,
197 p_ATTRIBUTE8 VARCHAR2,
198 p_ATTRIBUTE9 VARCHAR2,
199 p_ATTRIBUTE10 VARCHAR2,
200 p_ATTRIBUTE11 VARCHAR2,
201 p_ATTRIBUTE12 VARCHAR2,
202 p_ATTRIBUTE13 VARCHAR2,
203 p_ATTRIBUTE14 VARCHAR2,
204 p_ATTRIBUTE15 VARCHAR2,
205 p_ATTRIBUTE16 VARCHAR2,
206 p_ATTRIBUTE17 VARCHAR2,
207 p_ATTRIBUTE18 VARCHAR2,
208 p_ATTRIBUTE19 VARCHAR2,
209 p_ATTRIBUTE20 VARCHAR2,
210 p_TAX_INCLUSIVE_FLAG VARCHAR2,
211 p_OBJECT_VERSION_NUMBER NUMBER,
212 p_TAX_RATE_ID NUMBER
213 )
214
215 IS
216 BEGIN
217 Update ASO_TAX_DETAILS
218 SET
219 /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
220 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
221 LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
222 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
223 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
224 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
225 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
226 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
227 PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
228 QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
229 QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
230 QUOTE_SHIPMENT_ID = decode( p_QUOTE_SHIPMENT_ID, FND_API.G_MISS_NUM, QUOTE_SHIPMENT_ID, p_QUOTE_SHIPMENT_ID),
231 ORIG_TAX_CODE = decode( p_ORIG_TAX_CODE, FND_API.G_MISS_CHAR, ORIG_TAX_CODE, p_ORIG_TAX_CODE),
232 TAX_CODE = decode( p_TAX_CODE, FND_API.G_MISS_CHAR, TAX_CODE, p_TAX_CODE),
233 TAX_RATE = decode( p_TAX_RATE, FND_API.G_MISS_NUM, TAX_RATE, p_TAX_RATE),
234 TAX_DATE = ASO_UTILITY_PVT.decode( p_TAX_DATE, FND_API.G_MISS_DATE, TAX_DATE, p_TAX_DATE),
235 TAX_AMOUNT = decode( p_TAX_AMOUNT, FND_API.G_MISS_NUM, TAX_AMOUNT, p_TAX_AMOUNT),
236 TAX_EXEMPT_FLAG = decode( p_TAX_EXEMPT_FLAG, FND_API.G_MISS_CHAR, TAX_EXEMPT_FLAG, p_TAX_EXEMPT_FLAG),
237 TAX_EXEMPT_NUMBER = decode( p_TAX_EXEMPT_NUMBER, FND_API.G_MISS_CHAR, TAX_EXEMPT_NUMBER, p_TAX_EXEMPT_NUMBER),
238 TAX_EXEMPT_REASON_CODE = decode( p_TAX_EXEMPT_REASON_CODE, FND_API.G_MISS_CHAR, TAX_EXEMPT_REASON_CODE, p_TAX_EXEMPT_REASON_CODE),
239 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
240 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
241 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
242 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
243 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
244 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
245 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
246 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
247 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
248 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
252 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
249 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
250 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
251 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
253 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
254 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
255 ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
256 ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
257 ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
258 ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
259 ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
260 TAX_INCLUSIVE_FLAG = decode( p_TAX_INCLUSIVE_FLAG, FND_API.G_MISS_CHAR, TAX_INCLUSIVE_FLAG, p_TAX_INCLUSIVE_FLAG),
261 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1),
262 TAX_RATE_ID = decode(p_TAX_RATE_ID, FND_API.G_MISS_NUM, TAX_RATE_ID, p_TAX_RATE_ID)
263 where TAX_DETAIL_ID = p_TAX_DETAIL_ID;
264
265 If (SQL%NOTFOUND) then
266 RAISE NO_DATA_FOUND;
267 End If;
268 END Update_Row;
269
270 PROCEDURE Delete_Row(
271 p_TAX_DETAIL_ID NUMBER)
272 IS
273 BEGIN
274 DELETE FROM ASO_TAX_DETAILS
275 WHERE TAX_DETAIL_ID = p_TAX_DETAIL_ID;
276 If (SQL%NOTFOUND) then
277 RAISE NO_DATA_FOUND;
278 End If;
279 END Delete_Row;
280
281
282 PROCEDURE Delete_Row(
283 p_QUOTE_LINE_ID NUMBER)
284 IS
285 BEGIN
286 DELETE FROM ASO_TAX_DETAILS
287 WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID;
288 If (SQL%NOTFOUND) then
289 RAISE NO_DATA_FOUND;
290 End If;
291 END Delete_Row;
292
293
294 PROCEDURE Lock_Row(
295 --p_OBJECT_VERSION_NUMBER NUMBER,
296 p_TAX_DETAIL_ID NUMBER,
297 p_CREATION_DATE DATE,
298 p_CREATED_BY NUMBER,
299 p_LAST_UPDATE_DATE DATE,
300 p_LAST_UPDATED_BY NUMBER,
301 p_LAST_UPDATE_LOGIN NUMBER,
302 p_REQUEST_ID NUMBER,
303 p_PROGRAM_APPLICATION_ID NUMBER,
304 p_PROGRAM_ID NUMBER,
305 p_PROGRAM_UPDATE_DATE DATE,
306 p_QUOTE_HEADER_ID NUMBER,
307 p_QUOTE_LINE_ID NUMBER,
308 p_QUOTE_SHIPMENT_ID NUMBER,
309 p_ORIG_TAX_CODE VARCHAR2,
310 p_TAX_CODE VARCHAR2,
311 p_TAX_RATE NUMBER,
312 p_TAX_DATE DATE,
313 p_TAX_AMOUNT NUMBER,
314 p_TAX_EXEMPT_FLAG VARCHAR2,
315 p_TAX_EXEMPT_NUMBER VARCHAR2,
316 p_TAX_EXEMPT_REASON_CODE VARCHAR2,
317 p_ATTRIBUTE_CATEGORY VARCHAR2,
318 p_ATTRIBUTE1 VARCHAR2,
319 p_ATTRIBUTE2 VARCHAR2,
320 p_ATTRIBUTE3 VARCHAR2,
321 p_ATTRIBUTE4 VARCHAR2,
322 p_ATTRIBUTE5 VARCHAR2,
323 p_ATTRIBUTE6 VARCHAR2,
324 p_ATTRIBUTE7 VARCHAR2,
325 p_ATTRIBUTE8 VARCHAR2,
326 p_ATTRIBUTE9 VARCHAR2,
327 p_ATTRIBUTE10 VARCHAR2,
328 p_ATTRIBUTE11 VARCHAR2,
329 p_ATTRIBUTE12 VARCHAR2,
330 p_ATTRIBUTE13 VARCHAR2,
331 p_ATTRIBUTE14 VARCHAR2,
332 p_ATTRIBUTE15 VARCHAR2,
333 p_TAX_RATE_ID NUMBER)
334
335 IS
336 CURSOR C IS
337 SELECT TAX_EXEMPT_FLAG,
338 --OBJECT_VERSION_NUMBER,
339 TAX_EXEMPT_NUMBER,
340 TAX_EXEMPT_REASON_CODE,
341 ATTRIBUTE_CATEGORY,
342 ATTRIBUTE1,
343 ATTRIBUTE2,
344 ATTRIBUTE3,
345 ATTRIBUTE4,
346 ATTRIBUTE5,
347 ATTRIBUTE6,
348 ATTRIBUTE7,
349 ATTRIBUTE8,
350 ATTRIBUTE9,
351 ATTRIBUTE10,
352 ATTRIBUTE11,
353 ATTRIBUTE12,
354 ATTRIBUTE13,
355 ATTRIBUTE14,
356 ATTRIBUTE15,
357 TAX_DETAIL_ID,
358 CREATION_DATE,
359 CREATED_BY,
360 LAST_UPDATE_DATE,
361 LAST_UPDATED_BY,
362 LAST_UPDATE_LOGIN,
363 REQUEST_ID,
364 PROGRAM_APPLICATION_ID,
365 PROGRAM_ID,
366 PROGRAM_UPDATE_DATE,
367 QUOTE_HEADER_ID,
368 QUOTE_LINE_ID,
369 QUOTE_SHIPMENT_ID,
370 ORIG_TAX_CODE,
371 TAX_CODE,
372 TAX_RATE,
373 TAX_DATE,
374 TAX_AMOUNT,
375 TAX_RATE_ID
376 FROM ASO_TAX_DETAILS
377 WHERE TAX_DETAIL_ID = p_TAX_DETAIL_ID
378 FOR UPDATE of TAX_DETAIL_ID NOWAIT;
379 Recinfo C%ROWTYPE;
380 BEGIN
381 OPEN C;
382 FETCH C INTO Recinfo;
383 If (C%NOTFOUND) then
384 CLOSE C;
385 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
386 APP_EXCEPTION.RAISE_EXCEPTION;
387 End If;
388 CLOSE C;
389 if (
390 /*
391 ( Recinfo.TAX_DETAIL_ID = p_TAX_DETAIL_ID)
392 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
393 OR ( ( Recinfo.CREATION_DATE IS NULL )
394 AND ( p_CREATION_DATE IS NULL )))
395 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
396 OR ( ( Recinfo.CREATED_BY IS NULL )
397 AND ( p_CREATED_BY IS NULL )))
398 AND
399 */
400 ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
404 AND
401 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
402 AND ( p_LAST_UPDATE_DATE IS NULL )))
403 /*
405 ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
406 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
407 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
408
409 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
410 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
411 AND ( p_LAST_UPDATED_BY IS NULL )))
412 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
413 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
414 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
415 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
416 OR ( ( Recinfo.REQUEST_ID IS NULL )
417 AND ( p_REQUEST_ID IS NULL )))
418 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
419 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
420 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
421 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
422 OR ( ( Recinfo.PROGRAM_ID IS NULL )
423 AND ( p_PROGRAM_ID IS NULL )))
424 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
425 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
426 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
427 AND ( ( Recinfo.QUOTE_HEADER_ID = p_QUOTE_HEADER_ID)
428 OR ( ( Recinfo.QUOTE_HEADER_ID IS NULL )
429 AND ( p_QUOTE_HEADER_ID IS NULL )))
430 AND ( ( Recinfo.QUOTE_LINE_ID = p_QUOTE_LINE_ID)
431 OR ( ( Recinfo.QUOTE_LINE_ID IS NULL )
432 AND ( p_QUOTE_LINE_ID IS NULL )))
433 AND ( ( Recinfo.QUOTE_SHIPMENT_ID = p_QUOTE_SHIPMENT_ID)
434 OR ( ( Recinfo.QUOTE_SHIPMENT_ID IS NULL )
435 AND ( p_QUOTE_SHIPMENT_ID IS NULL )))
436 AND ( ( Recinfo.ORIG_TAX_CODE = p_ORIG_TAX_CODE)
437 OR ( ( Recinfo.ORIG_TAX_CODE IS NULL )
438 AND ( p_ORIG_TAX_CODE IS NULL )))
439 AND ( ( Recinfo.TAX_CODE = p_TAX_CODE)
440 OR ( ( Recinfo.TAX_CODE IS NULL )
441 AND ( p_TAX_CODE IS NULL )))
442 AND ( ( Recinfo.TAX_RATE = p_TAX_RATE)
443 OR ( ( Recinfo.TAX_RATE IS NULL )
444 AND ( p_TAX_RATE IS NULL )))
445 AND ( ( Recinfo.TAX_DATE = p_TAX_DATE)
446 OR ( ( Recinfo.TAX_DATE IS NULL )
447 AND ( p_TAX_DATE IS NULL )))
448 AND ( ( Recinfo.TAX_AMOUNT = p_TAX_AMOUNT)
449 OR ( ( Recinfo.TAX_AMOUNT IS NULL )
450 AND ( p_TAX_AMOUNT IS NULL )))
451 AND ( ( Recinfo.TAX_EXEMPT_FLAG = p_TAX_EXEMPT_FLAG)
452 OR ( ( Recinfo.TAX_EXEMPT_FLAG IS NULL )
453 AND ( p_TAX_EXEMPT_FLAG IS NULL )))
454 AND ( ( Recinfo.TAX_EXEMPT_NUMBER = p_TAX_EXEMPT_NUMBER)
455 OR ( ( Recinfo.TAX_EXEMPT_NUMBER IS NULL )
456 AND ( p_TAX_EXEMPT_NUMBER IS NULL )))
457 AND ( ( Recinfo.TAX_EXEMPT_REASON_CODE = p_TAX_EXEMPT_REASON_CODE)
458 OR ( ( Recinfo.TAX_EXEMPT_REASON_CODE IS NULL )
459 AND ( p_TAX_EXEMPT_REASON_CODE IS NULL )))
460 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
461 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
462 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
463 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
464 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
465 AND ( p_ATTRIBUTE1 IS NULL )))
466 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
467 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
468 AND ( p_ATTRIBUTE2 IS NULL )))
469 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
470 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
471 AND ( p_ATTRIBUTE3 IS NULL )))
472 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
473 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
474 AND ( p_ATTRIBUTE4 IS NULL )))
475 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
476 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
477 AND ( p_ATTRIBUTE5 IS NULL )))
478 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
479 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
480 AND ( p_ATTRIBUTE6 IS NULL )))
481 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
482 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
483 AND ( p_ATTRIBUTE7 IS NULL )))
484 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
485 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
486 AND ( p_ATTRIBUTE8 IS NULL )))
487 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
488 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
489 AND ( p_ATTRIBUTE9 IS NULL )))
490 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
491 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
492 AND ( p_ATTRIBUTE10 IS NULL )))
493 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
494 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
495 AND ( p_ATTRIBUTE11 IS NULL )))
496 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
497 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
498 AND ( p_ATTRIBUTE12 IS NULL )))
499 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
500 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
501 AND ( p_ATTRIBUTE13 IS NULL )))
502 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
503 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
504 AND ( p_ATTRIBUTE14 IS NULL )))
505 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
506 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
507 AND ( p_ATTRIBUTE15 IS NULL )))
508 */
509 ) then
510 return;
511 else
512 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
513 APP_EXCEPTION.RAISE_EXCEPTION;
514 End If;
515 END Lock_Row;
516
517 End ASO_TAX_DETAILS_PKG;