[Home] [Help]
PACKAGE BODY: APPS.ASO_FREIGHT_CHARGES_PKG
Source
1 PACKAGE BODY ASO_FREIGHT_CHARGES_PKG as
2 /* $Header: asotfchb.pls 120.1 2005/06/29 12:38:49 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_FREIGHT_CHARGES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_FREIGHT_CHARGES_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotfchb.pls';
13
14 PROCEDURE Insert_Row(
15 px_FREIGHT_CHARGE_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
16 p_CREATION_DATE DATE,
17 p_CREATED_BY NUMBER,
18 p_LAST_UPDATE_DATE DATE,
19 p_LAST_UPDATED_BY NUMBER,
20 p_LAST_UPDATE_LOGIN NUMBER,
21 p_REQUEST_ID NUMBER,
22 p_PROGRAM_APPLICATION_ID NUMBER,
23 p_PROGRAM_ID NUMBER,
24 p_PROGRAM_UPDATE_DATE DATE,
25 p_QUOTE_SHIPMENT_ID NUMBER,
26 p_FREIGHT_CHARGE_TYPE_ID NUMBER,
27 p_CHARGE_AMOUNT NUMBER,
28 p_ATTRIBUTE_CATEGORY VARCHAR2,
29 p_ATTRIBUTE1 VARCHAR2,
30 p_ATTRIBUTE2 VARCHAR2,
31 p_ATTRIBUTE3 VARCHAR2,
32 p_ATTRIBUTE4 VARCHAR2,
33 p_ATTRIBUTE5 VARCHAR2,
34 p_ATTRIBUTE6 VARCHAR2,
35 p_ATTRIBUTE7 VARCHAR2,
36 p_ATTRIBUTE8 VARCHAR2,
37 p_ATTRIBUTE9 VARCHAR2,
38 p_ATTRIBUTE10 VARCHAR2,
39 p_ATTRIBUTE11 VARCHAR2,
40 p_ATTRIBUTE12 VARCHAR2,
41 p_ATTRIBUTE13 VARCHAR2,
42 p_ATTRIBUTE14 VARCHAR2,
43 p_ATTRIBUTE15 VARCHAR2)
44
45 IS
46 CURSOR C2 IS SELECT ASO_FREIGHT_CHARGES_S.nextval FROM sys.dual;
47 BEGIN
48 If (px_FREIGHT_CHARGE_ID IS NULL) OR (px_FREIGHT_CHARGE_ID = FND_API.G_MISS_NUM) then
49 OPEN C2;
50 FETCH C2 INTO px_FREIGHT_CHARGE_ID;
51 CLOSE C2;
52 End If;
53 INSERT INTO ASO_FREIGHT_CHARGES(
54 FREIGHT_CHARGE_ID,
55 CREATION_DATE,
56 CREATED_BY,
57 LAST_UPDATE_DATE,
58 LAST_UPDATED_BY,
59 LAST_UPDATE_LOGIN,
60 REQUEST_ID,
61 PROGRAM_APPLICATION_ID,
62 PROGRAM_ID,
63 PROGRAM_UPDATE_DATE,
64 QUOTE_SHIPMENT_ID,
65 FREIGHT_CHARGE_TYPE_ID,
66 CHARGE_AMOUNT,
67 ATTRIBUTE_CATEGORY,
68 ATTRIBUTE1,
69 ATTRIBUTE2,
70 ATTRIBUTE3,
71 ATTRIBUTE4,
72 ATTRIBUTE5,
73 ATTRIBUTE6,
74 ATTRIBUTE7,
75 ATTRIBUTE8,
76 ATTRIBUTE9,
77 ATTRIBUTE10,
78 ATTRIBUTE11,
79 ATTRIBUTE12,
80 ATTRIBUTE13,
81 ATTRIBUTE14,
82 ATTRIBUTE15
83 ) VALUES (
84 px_FREIGHT_CHARGE_ID,
85 ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
86 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
87 ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
88 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
89 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
90 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
91 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
92 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
93 ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
94 decode( p_QUOTE_SHIPMENT_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_SHIPMENT_ID),
95 decode( p_FREIGHT_CHARGE_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_FREIGHT_CHARGE_TYPE_ID),
96 decode( p_CHARGE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_CHARGE_AMOUNT),
97 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
98 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
99 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
100 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
101 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
102 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
103 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
104 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
105 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
106 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
107 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
108 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
109 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
110 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
111 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
112 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
113 End Insert_Row;
114
115 PROCEDURE Update_Row(
116 p_FREIGHT_CHARGE_ID NUMBER,
117 p_CREATION_DATE DATE,
118 p_CREATED_BY NUMBER,
119 p_LAST_UPDATE_DATE DATE,
120 p_LAST_UPDATED_BY NUMBER,
121 p_LAST_UPDATE_LOGIN NUMBER,
122 p_REQUEST_ID NUMBER,
123 p_PROGRAM_APPLICATION_ID NUMBER,
124 p_PROGRAM_ID NUMBER,
125 p_PROGRAM_UPDATE_DATE DATE,
126 p_QUOTE_SHIPMENT_ID NUMBER,
127 p_FREIGHT_CHARGE_TYPE_ID NUMBER,
128 p_CHARGE_AMOUNT NUMBER,
129 p_ATTRIBUTE_CATEGORY VARCHAR2,
130 p_ATTRIBUTE1 VARCHAR2,
131 p_ATTRIBUTE2 VARCHAR2,
132 p_ATTRIBUTE3 VARCHAR2,
133 p_ATTRIBUTE4 VARCHAR2,
134 p_ATTRIBUTE5 VARCHAR2,
135 p_ATTRIBUTE6 VARCHAR2,
136 p_ATTRIBUTE7 VARCHAR2,
137 p_ATTRIBUTE8 VARCHAR2,
138 p_ATTRIBUTE9 VARCHAR2,
139 p_ATTRIBUTE10 VARCHAR2,
140 p_ATTRIBUTE11 VARCHAR2,
141 p_ATTRIBUTE12 VARCHAR2,
142 p_ATTRIBUTE13 VARCHAR2,
143 p_ATTRIBUTE14 VARCHAR2,
144 p_ATTRIBUTE15 VARCHAR2)
145
146 IS
147 BEGIN
148 Update ASO_FREIGHT_CHARGES
149 SET
150 /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
151 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
152 LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
153 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
154 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
155 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
156 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
157 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
158 PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
159 QUOTE_SHIPMENT_ID = decode( p_QUOTE_SHIPMENT_ID, FND_API.G_MISS_NUM, QUOTE_SHIPMENT_ID, p_QUOTE_SHIPMENT_ID),
160 FREIGHT_CHARGE_TYPE_ID = decode( p_FREIGHT_CHARGE_TYPE_ID, FND_API.G_MISS_NUM, FREIGHT_CHARGE_TYPE_ID, p_FREIGHT_CHARGE_TYPE_ID),
161 CHARGE_AMOUNT = decode( p_CHARGE_AMOUNT, FND_API.G_MISS_NUM, CHARGE_AMOUNT, p_CHARGE_AMOUNT),
162 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
163 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
164 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
165 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
166 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
167 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
168 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
169 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
170 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
171 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
172 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
173 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
174 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
175 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
176 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
177 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
178 where FREIGHT_CHARGE_ID = p_FREIGHT_CHARGE_ID;
179
180 If (SQL%NOTFOUND) then
181 RAISE NO_DATA_FOUND;
182 End If;
183 END Update_Row;
184
185 PROCEDURE Delete_Row(
186 p_FREIGHT_CHARGE_ID NUMBER)
187 IS
188 BEGIN
189 DELETE FROM ASO_FREIGHT_CHARGES
190 WHERE FREIGHT_CHARGE_ID = p_FREIGHT_CHARGE_ID;
191 If (SQL%NOTFOUND) then
192 RAISE NO_DATA_FOUND;
193 End If;
194 END Delete_Row;
195
196 PROCEDURE Delete_Row(
197 p_QUOTE_LINE_ID NUMBER)
198 IS
199 BEGIN
200 DELETE FROM ASO_FREIGHT_CHARGES
201 WHERE quote_shipment_id in
202 (select shipment_id from ASO_SHIPMENTS
203 where QUOTE_LINE_ID = p_quote_line_id);
204 If (SQL%NOTFOUND) then
205 RAISE NO_DATA_FOUND;
206 End If;
207 END Delete_Row;
208
209 PROCEDURE Lock_Row(
210 p_FREIGHT_CHARGE_ID NUMBER,
211 p_CREATION_DATE DATE,
212 p_CREATED_BY NUMBER,
213 p_LAST_UPDATE_DATE DATE,
214 p_LAST_UPDATED_BY NUMBER,
215 p_LAST_UPDATE_LOGIN NUMBER,
216 p_REQUEST_ID NUMBER,
217 p_PROGRAM_APPLICATION_ID NUMBER,
218 p_PROGRAM_ID NUMBER,
219 p_PROGRAM_UPDATE_DATE DATE,
220 p_QUOTE_SHIPMENT_ID NUMBER,
221 p_FREIGHT_CHARGE_TYPE_ID NUMBER,
222 p_CHARGE_AMOUNT NUMBER,
223 p_ATTRIBUTE_CATEGORY VARCHAR2,
224 p_ATTRIBUTE1 VARCHAR2,
225 p_ATTRIBUTE2 VARCHAR2,
226 p_ATTRIBUTE3 VARCHAR2,
227 p_ATTRIBUTE4 VARCHAR2,
228 p_ATTRIBUTE5 VARCHAR2,
229 p_ATTRIBUTE6 VARCHAR2,
230 p_ATTRIBUTE7 VARCHAR2,
231 p_ATTRIBUTE8 VARCHAR2,
232 p_ATTRIBUTE9 VARCHAR2,
233 p_ATTRIBUTE10 VARCHAR2,
234 p_ATTRIBUTE11 VARCHAR2,
235 p_ATTRIBUTE12 VARCHAR2,
236 p_ATTRIBUTE13 VARCHAR2,
237 p_ATTRIBUTE14 VARCHAR2,
238 p_ATTRIBUTE15 VARCHAR2)
239
240 IS
241 CURSOR C IS
242 SELECT FREIGHT_CHARGE_ID,
243 CREATION_DATE,
244 CREATED_BY,
245 LAST_UPDATE_DATE,
246 LAST_UPDATED_BY,
247 LAST_UPDATE_LOGIN,
248 REQUEST_ID,
249 PROGRAM_APPLICATION_ID,
250 PROGRAM_ID,
251 PROGRAM_UPDATE_DATE,
252 QUOTE_SHIPMENT_ID,
253 FREIGHT_CHARGE_TYPE_ID,
254 CHARGE_AMOUNT,
255 ATTRIBUTE_CATEGORY,
256 ATTRIBUTE1,
257 ATTRIBUTE2,
258 ATTRIBUTE3,
259 ATTRIBUTE4,
260 ATTRIBUTE5,
261 ATTRIBUTE6,
262 ATTRIBUTE7,
263 ATTRIBUTE8,
264 ATTRIBUTE9,
265 ATTRIBUTE10,
266 ATTRIBUTE11,
267 ATTRIBUTE12,
268 ATTRIBUTE13,
269 ATTRIBUTE14,
270 ATTRIBUTE15
271 FROM ASO_FREIGHT_CHARGES
272 WHERE FREIGHT_CHARGE_ID = p_FREIGHT_CHARGE_ID
273 FOR UPDATE of FREIGHT_CHARGE_ID NOWAIT;
274 Recinfo C%ROWTYPE;
275 BEGIN
276 OPEN C;
277 FETCH C INTO Recinfo;
278 If (C%NOTFOUND) then
279 CLOSE C;
280 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
281 APP_EXCEPTION.RAISE_EXCEPTION;
282 End If;
283 CLOSE C;
284 if (
285 /*
286 ( Recinfo.FREIGHT_CHARGE_ID = p_FREIGHT_CHARGE_ID)
287 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
288 OR ( ( Recinfo.CREATION_DATE IS NULL )
289 AND ( p_CREATION_DATE IS NULL )))
290 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
291 OR ( ( Recinfo.CREATED_BY IS NULL )
292 AND ( p_CREATED_BY IS NULL )))
293 AND
294 */
295 ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
296 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
297 AND ( p_LAST_UPDATE_DATE IS NULL )))
298 /*
299 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
300 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
301 AND ( p_LAST_UPDATED_BY IS NULL )))
302 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
303 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
304 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
305 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
306 OR ( ( Recinfo.REQUEST_ID IS NULL )
307 AND ( p_REQUEST_ID IS NULL )))
308 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
309 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
310 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
311 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
312 OR ( ( Recinfo.PROGRAM_ID IS NULL )
313 AND ( p_PROGRAM_ID IS NULL )))
314 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
315 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
316 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
317 AND ( ( Recinfo.QUOTE_SHIPMENT_ID = p_QUOTE_SHIPMENT_ID)
318 OR ( ( Recinfo.QUOTE_SHIPMENT_ID IS NULL )
319 AND ( p_QUOTE_SHIPMENT_ID IS NULL )))
320 AND ( ( Recinfo.FREIGHT_CHARGE_TYPE_ID = p_FREIGHT_CHARGE_TYPE_ID)
321 OR ( ( Recinfo.FREIGHT_CHARGE_TYPE_ID IS NULL )
322 AND ( p_FREIGHT_CHARGE_TYPE_ID IS NULL )))
323 AND ( ( Recinfo.CHARGE_AMOUNT = p_CHARGE_AMOUNT)
324 OR ( ( Recinfo.CHARGE_AMOUNT IS NULL )
325 AND ( p_CHARGE_AMOUNT IS NULL )))
326 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
327 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
328 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
329 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
330 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
331 AND ( p_ATTRIBUTE1 IS NULL )))
332 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
333 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
334 AND ( p_ATTRIBUTE2 IS NULL )))
335 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
336 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
337 AND ( p_ATTRIBUTE3 IS NULL )))
338 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
339 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
340 AND ( p_ATTRIBUTE4 IS NULL )))
341 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
342 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
343 AND ( p_ATTRIBUTE5 IS NULL )))
344 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
345 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
346 AND ( p_ATTRIBUTE6 IS NULL )))
347 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
348 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
349 AND ( p_ATTRIBUTE7 IS NULL )))
350 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
351 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
352 AND ( p_ATTRIBUTE8 IS NULL )))
353 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
354 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
355 AND ( p_ATTRIBUTE9 IS NULL )))
356 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
357 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
358 AND ( p_ATTRIBUTE10 IS NULL )))
359 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
360 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
361 AND ( p_ATTRIBUTE11 IS NULL )))
362 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
363 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
364 AND ( p_ATTRIBUTE12 IS NULL )))
365 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
366 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
367 AND ( p_ATTRIBUTE13 IS NULL )))
368 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
369 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
370 AND ( p_ATTRIBUTE14 IS NULL )))
371 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
372 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
373 AND ( p_ATTRIBUTE15 IS NULL )))
374 */
375 ) then
376 return;
377 else
378 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
379 APP_EXCEPTION.RAISE_EXCEPTION;
380 End If;
381 END Lock_Row;
382
383 End ASO_FREIGHT_CHARGES_PKG;