eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.CSP_PACKLIST_LINES_PKG

Source


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