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