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_SEC_INVENTORIES_PKG

Source


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