[Home] [Help]
PACKAGE BODY: APPS.CSP_ITEM_SUB_INVENTORIES_PKG
Source
1 PACKAGE BODY CSP_ITEM_SUB_INVENTORIES_PKG as
2 /* $Header: csptpaub.pls 115.9 2002/11/26 07:15:48 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name : CSP_ITEM_SUB_INVENTORIES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_ITEM_SUB_INVENTORIES_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptausb.pls';
13
14 PROCEDURE Insert_Row(
15 px_INVENTORY_ITEM_ID IN OUT NOCOPY NUMBER,
16 p_ORGANIZATION_ID NUMBER,
17 p_SECONDARY_INVENTORY VARCHAR2,
18 p_LAST_UPDATE_DATE DATE,
19 p_LAST_UPDATED_BY NUMBER,
20 p_CREATION_DATE DATE,
21 p_CREATED_BY NUMBER,
22 p_LAST_UPDATE_LOGIN NUMBER,
23 p_PRIMARY_SUBINVENTORY_FLAG NUMBER,
24 p_PICKING_ORDER NUMBER,
25 p_MIN_MINMAX_QUANTITY NUMBER,
26 p_MAX_MINMAX_QUANTITY NUMBER,
27 p_INVENTORY_PLANNING_CODE NUMBER,
28 p_FIXED_LOT_MULTIPLE NUMBER,
29 p_MINIMUM_ORDER_QUANTITY NUMBER,
30 p_MAXIMUM_ORDER_QUANTITY NUMBER,
31 p_SOURCE_TYPE NUMBER,
32 p_SOURCE_ORGANIZATION_ID NUMBER,
33 p_SOURCE_SUBINVENTORY VARCHAR2,
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 p_ENCUMBRANCE_ACCOUNT NUMBER,
51 p_PREPROCESSING_LEAD_TIME NUMBER,
52 p_PROCESSING_LEAD_TIME NUMBER,
53 p_POSTPROCESSING_LEAD_TIME NUMBER)
54
55 IS
56 BEGIN
57
58 INSERT INTO MTL_ITEM_SUB_INVENTORIES(
59 INVENTORY_ITEM_ID,
60 ORGANIZATION_ID,
61 SECONDARY_INVENTORY,
62 LAST_UPDATE_DATE,
63 LAST_UPDATED_BY,
64 CREATION_DATE,
65 CREATED_BY,
66 LAST_UPDATE_LOGIN,
67 PRIMARY_SUBINVENTORY_FLAG,
68 PICKING_ORDER,
69 MIN_MINMAX_QUANTITY,
70 MAX_MINMAX_QUANTITY,
71 INVENTORY_PLANNING_CODE,
72 FIXED_LOT_MULTIPLE,
73 MINIMUM_ORDER_QUANTITY,
74 MAXIMUM_ORDER_QUANTITY,
75 SOURCE_TYPE,
76 SOURCE_ORGANIZATION_ID,
77 SOURCE_SUBINVENTORY,
78 ATTRIBUTE_CATEGORY,
79 ATTRIBUTE1,
80 ATTRIBUTE2,
81 ATTRIBUTE3,
82 ATTRIBUTE4,
83 ATTRIBUTE5,
84 ATTRIBUTE6,
85 ATTRIBUTE7,
86 ATTRIBUTE8,
87 ATTRIBUTE9,
88 ATTRIBUTE10,
89 ATTRIBUTE11,
90 ATTRIBUTE12,
91 ATTRIBUTE13,
92 ATTRIBUTE14,
93 ATTRIBUTE15,
94 ENCUMBRANCE_ACCOUNT,
95 PREPROCESSING_LEAD_TIME,
96 PROCESSING_LEAD_TIME,
97 POSTPROCESSING_LEAD_TIME
98 ) VALUES (
99 px_INVENTORY_ITEM_ID,
100 decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
101 decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY),
102 decode( p_LAST_UPDATE_DATE, fnd_api.g_miss_date, to_date(null), p_last_update_date),
103 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
104 decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
105 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
106 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
107 decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, NULL, p_PRIMARY_SUBINVENTORY_FLAG),
108 decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, NULL, p_PICKING_ORDER),
109 decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MIN_MINMAX_QUANTITY),
110 decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAX_MINMAX_QUANTITY),
111 decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, NULL, p_INVENTORY_PLANNING_CODE),
112 decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_FIXED_LOT_MULTIPLE),
113 decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_ORDER_QUANTITY),
114 decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAXIMUM_ORDER_QUANTITY),
115 decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, NULL, p_SOURCE_TYPE),
116 decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ORGANIZATION_ID),
117 decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_SOURCE_SUBINVENTORY),
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 decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_ACCOUNT),
135 decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PREPROCESSING_LEAD_TIME),
136 decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PROCESSING_LEAD_TIME),
137 decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_POSTPROCESSING_LEAD_TIME));
138 End Insert_Row;
139
140 PROCEDURE Update_Row(
141 p_ROW_ID VARCHAR2,
142 p_INVENTORY_ITEM_ID NUMBER,
143 p_ORGANIZATION_ID NUMBER,
144 p_SECONDARY_INVENTORY VARCHAR2,
145 p_LAST_UPDATE_DATE DATE,
146 p_LAST_UPDATED_BY NUMBER,
147 p_CREATION_DATE DATE,
148 p_CREATED_BY NUMBER,
149 p_LAST_UPDATE_LOGIN NUMBER,
150 p_PRIMARY_SUBINVENTORY_FLAG NUMBER,
151 p_PICKING_ORDER NUMBER,
152 p_MIN_MINMAX_QUANTITY NUMBER,
153 p_MAX_MINMAX_QUANTITY NUMBER,
154 p_INVENTORY_PLANNING_CODE NUMBER,
155 p_FIXED_LOT_MULTIPLE NUMBER,
156 p_MINIMUM_ORDER_QUANTITY NUMBER,
157 p_MAXIMUM_ORDER_QUANTITY NUMBER,
158 p_SOURCE_TYPE NUMBER,
159 p_SOURCE_ORGANIZATION_ID NUMBER,
160 p_SOURCE_SUBINVENTORY VARCHAR2,
161 p_ATTRIBUTE_CATEGORY VARCHAR2,
162 p_ATTRIBUTE1 VARCHAR2,
163 p_ATTRIBUTE2 VARCHAR2,
164 p_ATTRIBUTE3 VARCHAR2,
165 p_ATTRIBUTE4 VARCHAR2,
166 p_ATTRIBUTE5 VARCHAR2,
167 p_ATTRIBUTE6 VARCHAR2,
168 p_ATTRIBUTE7 VARCHAR2,
169 p_ATTRIBUTE8 VARCHAR2,
170 p_ATTRIBUTE9 VARCHAR2,
171 p_ATTRIBUTE10 VARCHAR2,
172 p_ATTRIBUTE11 VARCHAR2,
173 p_ATTRIBUTE12 VARCHAR2,
174 p_ATTRIBUTE13 VARCHAR2,
175 p_ATTRIBUTE14 VARCHAR2,
176 p_ATTRIBUTE15 VARCHAR2,
177 p_ENCUMBRANCE_ACCOUNT NUMBER,
178 p_PREPROCESSING_LEAD_TIME NUMBER,
179 p_PROCESSING_LEAD_TIME NUMBER,
180 p_POSTPROCESSING_LEAD_TIME NUMBER)
181
182 IS
183 BEGIN
184 Update MTL_ITEM_SUB_INVENTORIES
185 SET
186 ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
187 SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY),
188 LAST_UPDATE_DATE = decode(p_last_update_date,fnd_api.g_miss_date,last_update_date,p_last_update_date),
189 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
190 CREATION_DATE = decode(p_creation_date,fnd_api.g_miss_date,creation_date,p_creation_date),
191 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
192 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
193 PRIMARY_SUBINVENTORY_FLAG = decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, PRIMARY_SUBINVENTORY_FLAG, p_PRIMARY_SUBINVENTORY_FLAG),
194 PICKING_ORDER = decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, PICKING_ORDER, p_PICKING_ORDER),
195 MIN_MINMAX_QUANTITY = decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MIN_MINMAX_QUANTITY, p_MIN_MINMAX_QUANTITY),
196 MAX_MINMAX_QUANTITY = decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MAX_MINMAX_QUANTITY, p_MAX_MINMAX_QUANTITY),
197 INVENTORY_PLANNING_CODE = decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, INVENTORY_PLANNING_CODE, p_INVENTORY_PLANNING_CODE),
198 FIXED_LOT_MULTIPLE = decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, FIXED_LOT_MULTIPLE, p_FIXED_LOT_MULTIPLE),
199 MINIMUM_ORDER_QUANTITY = decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MINIMUM_ORDER_QUANTITY, p_MINIMUM_ORDER_QUANTITY),
200 MAXIMUM_ORDER_QUANTITY = decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MAXIMUM_ORDER_QUANTITY, p_MAXIMUM_ORDER_QUANTITY),
201 SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, SOURCE_TYPE, p_SOURCE_TYPE),
202 SOURCE_ORGANIZATION_ID = decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, SOURCE_ORGANIZATION_ID, p_SOURCE_ORGANIZATION_ID),
203 SOURCE_SUBINVENTORY = decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, SOURCE_SUBINVENTORY, p_SOURCE_SUBINVENTORY),
204 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
205 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
206 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
207 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
208 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
209 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
210 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
211 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
212 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
213 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
214 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
215 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
216 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
217 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
218 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
219 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
220 ENCUMBRANCE_ACCOUNT = decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_ACCOUNT, p_ENCUMBRANCE_ACCOUNT),
221 PREPROCESSING_LEAD_TIME = decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PREPROCESSING_LEAD_TIME, p_PREPROCESSING_LEAD_TIME),
222 PROCESSING_LEAD_TIME = decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PROCESSING_LEAD_TIME, p_PROCESSING_LEAD_TIME),
223 POSTPROCESSING_LEAD_TIME = decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, POSTPROCESSING_LEAD_TIME, p_POSTPROCESSING_LEAD_TIME)
224 where inventory_item_id = p_INVENTORY_ITEM_ID
225 and secondary_inventory = p_SECONDARY_INVENTORY
226 and organization_id = p_ORGANIZATION_ID;
227
228 If (SQL%NOTFOUND) then
229 RAISE NO_DATA_FOUND;
230 End If;
231 END Update_Row;
232
233
234 PROCEDURE Delete_Row(
235 p_INVENTORY_ITEM_ID NUMBER,
236 p_ORGANIZATION_ID NUMBER,
237 p_SECONDARY_INVENTORY VARCHAR2)
238 IS
239 BEGIN
240 DELETE FROM MTL_ITEM_SUB_INVENTORIES
241 where inventory_item_id = p_INVENTORY_ITEM_ID
242 and secondary_inventory = p_SECONDARY_INVENTORY
243 and organization_id = p_ORGANIZATION_ID;
244 If (SQL%NOTFOUND) then
245 RAISE NO_DATA_FOUND;
246 End If;
247 END Delete_Row;
248
249 PROCEDURE Lock_Row(
250 p_ROW_ID VARCHAR2,
251 p_INVENTORY_ITEM_ID NUMBER,
252 p_ORGANIZATION_ID NUMBER,
253 p_SECONDARY_INVENTORY VARCHAR2,
254 p_LAST_UPDATE_DATE DATE,
255 p_LAST_UPDATED_BY NUMBER,
256 p_CREATION_DATE DATE,
257 p_CREATED_BY NUMBER,
258 p_LAST_UPDATE_LOGIN NUMBER,
259 p_PRIMARY_SUBINVENTORY_FLAG NUMBER,
260 p_PICKING_ORDER NUMBER,
261 p_MIN_MINMAX_QUANTITY NUMBER,
262 p_MAX_MINMAX_QUANTITY NUMBER,
263 p_INVENTORY_PLANNING_CODE NUMBER,
264 p_FIXED_LOT_MULTIPLE NUMBER,
265 p_MINIMUM_ORDER_QUANTITY NUMBER,
266 p_MAXIMUM_ORDER_QUANTITY NUMBER,
267 p_SOURCE_TYPE NUMBER,
268 p_SOURCE_ORGANIZATION_ID NUMBER,
269 p_SOURCE_SUBINVENTORY VARCHAR2,
270 p_ATTRIBUTE_CATEGORY VARCHAR2,
271 p_ATTRIBUTE1 VARCHAR2,
272 p_ATTRIBUTE2 VARCHAR2,
273 p_ATTRIBUTE3 VARCHAR2,
274 p_ATTRIBUTE4 VARCHAR2,
275 p_ATTRIBUTE5 VARCHAR2,
276 p_ATTRIBUTE6 VARCHAR2,
277 p_ATTRIBUTE7 VARCHAR2,
278 p_ATTRIBUTE8 VARCHAR2,
279 p_ATTRIBUTE9 VARCHAR2,
280 p_ATTRIBUTE10 VARCHAR2,
281 p_ATTRIBUTE11 VARCHAR2,
282 p_ATTRIBUTE12 VARCHAR2,
283 p_ATTRIBUTE13 VARCHAR2,
284 p_ATTRIBUTE14 VARCHAR2,
285 p_ATTRIBUTE15 VARCHAR2,
286 p_ENCUMBRANCE_ACCOUNT NUMBER,
287 p_PREPROCESSING_LEAD_TIME NUMBER,
288 p_PROCESSING_LEAD_TIME NUMBER,
289 p_POSTPROCESSING_LEAD_TIME NUMBER)
290
291 IS
292 CURSOR C IS
293 SELECT *
294 FROM MTL_ITEM_SUB_INVENTORIES
295 where inventory_item_id = p_INVENTORY_ITEM_ID
296 and secondary_inventory = p_SECONDARY_INVENTORY
297 and organization_id = p_ORGANIZATION_ID
298 FOR UPDATE of INVENTORY_ITEM_ID NOWAIT;
299 Recinfo C%ROWTYPE;
300 BEGIN
301 OPEN C;
302 FETCH C INTO Recinfo;
303 If (C%NOTFOUND) then
304 CLOSE C;
305 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
306 APP_EXCEPTION.RAISE_EXCEPTION;
307 End If;
308 CLOSE C;
309 if (
310 ( Recinfo.INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID)
311 AND ( ( Recinfo.ORGANIZATION_ID = p_ORGANIZATION_ID)
312 OR ( ( Recinfo.ORGANIZATION_ID IS NULL )
313 AND ( p_ORGANIZATION_ID IS NULL )))
314 AND ( ( Recinfo.SECONDARY_INVENTORY = p_SECONDARY_INVENTORY)
315 OR ( ( Recinfo.SECONDARY_INVENTORY IS NULL )
316 AND ( p_SECONDARY_INVENTORY IS NULL )))
317 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
318 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
319 AND ( p_LAST_UPDATE_DATE IS NULL )))
320 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
321 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
322 AND ( p_LAST_UPDATED_BY IS NULL )))
323 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
324 OR ( ( Recinfo.CREATION_DATE IS NULL )
325 AND ( p_CREATION_DATE IS NULL )))
326 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
327 OR ( ( Recinfo.CREATED_BY IS NULL )
328 AND ( p_CREATED_BY IS NULL )))
332 AND ( ( Recinfo.PRIMARY_SUBINVENTORY_FLAG = p_PRIMARY_SUBINVENTORY_FLAG)
329 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
330 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
331 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
333 OR ( ( Recinfo.PRIMARY_SUBINVENTORY_FLAG IS NULL )
334 AND ( p_PRIMARY_SUBINVENTORY_FLAG IS NULL )))
335 AND ( ( Recinfo.PICKING_ORDER = p_PICKING_ORDER)
336 OR ( ( Recinfo.PICKING_ORDER IS NULL )
337 AND ( p_PICKING_ORDER IS NULL )))
338 AND ( ( Recinfo.MIN_MINMAX_QUANTITY = p_MIN_MINMAX_QUANTITY)
339 OR ( ( Recinfo.MIN_MINMAX_QUANTITY IS NULL )
340 AND ( p_MIN_MINMAX_QUANTITY IS NULL )))
341 AND ( ( Recinfo.MAX_MINMAX_QUANTITY = p_MAX_MINMAX_QUANTITY)
342 OR ( ( Recinfo.MAX_MINMAX_QUANTITY IS NULL )
343 AND ( p_MAX_MINMAX_QUANTITY IS NULL )))
344 AND ( ( Recinfo.INVENTORY_PLANNING_CODE = p_INVENTORY_PLANNING_CODE)
345 OR ( ( Recinfo.INVENTORY_PLANNING_CODE IS NULL )
346 AND ( p_INVENTORY_PLANNING_CODE IS NULL )))
347 AND ( ( Recinfo.FIXED_LOT_MULTIPLE = p_FIXED_LOT_MULTIPLE)
348 OR ( ( Recinfo.FIXED_LOT_MULTIPLE IS NULL )
349 AND ( p_FIXED_LOT_MULTIPLE IS NULL )))
350 AND ( ( Recinfo.MINIMUM_ORDER_QUANTITY = p_MINIMUM_ORDER_QUANTITY)
351 OR ( ( Recinfo.MINIMUM_ORDER_QUANTITY IS NULL )
352 AND ( p_MINIMUM_ORDER_QUANTITY IS NULL )))
353 AND ( ( Recinfo.MAXIMUM_ORDER_QUANTITY = p_MAXIMUM_ORDER_QUANTITY)
354 OR ( ( Recinfo.MAXIMUM_ORDER_QUANTITY IS NULL )
355 AND ( p_MAXIMUM_ORDER_QUANTITY IS NULL )))
356 AND ( ( Recinfo.SOURCE_TYPE = p_SOURCE_TYPE)
357 OR ( ( Recinfo.SOURCE_TYPE IS NULL )
358 AND ( p_SOURCE_TYPE IS NULL )))
359 AND ( ( Recinfo.SOURCE_ORGANIZATION_ID = p_SOURCE_ORGANIZATION_ID)
360 OR ( ( Recinfo.SOURCE_ORGANIZATION_ID IS NULL )
361 AND ( p_SOURCE_ORGANIZATION_ID IS NULL )))
362 AND ( ( Recinfo.SOURCE_SUBINVENTORY = p_SOURCE_SUBINVENTORY)
363 OR ( ( Recinfo.SOURCE_SUBINVENTORY IS NULL )
364 AND ( p_SOURCE_SUBINVENTORY IS NULL )))
365 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
366 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
367 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
368 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
369 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
370 AND ( p_ATTRIBUTE1 IS NULL )))
371 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
372 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
373 AND ( p_ATTRIBUTE2 IS NULL )))
374 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
375 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
376 AND ( p_ATTRIBUTE3 IS NULL )))
377 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
378 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
379 AND ( p_ATTRIBUTE4 IS NULL )))
380 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
381 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
382 AND ( p_ATTRIBUTE5 IS NULL )))
383 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
384 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
385 AND ( p_ATTRIBUTE6 IS NULL )))
386 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
387 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
388 AND ( p_ATTRIBUTE7 IS NULL )))
389 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
390 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
391 AND ( p_ATTRIBUTE8 IS NULL )))
392 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
393 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
394 AND ( p_ATTRIBUTE9 IS NULL )))
395 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
396 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
397 AND ( p_ATTRIBUTE10 IS NULL )))
398 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
399 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
400 AND ( p_ATTRIBUTE11 IS NULL )))
401 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
402 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
403 AND ( p_ATTRIBUTE12 IS NULL )))
404 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
405 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
406 AND ( p_ATTRIBUTE13 IS NULL )))
407 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
408 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
409 AND ( p_ATTRIBUTE14 IS NULL )))
410 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
411 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
412 AND ( p_ATTRIBUTE15 IS NULL )))
413 AND ( ( Recinfo.ENCUMBRANCE_ACCOUNT = p_ENCUMBRANCE_ACCOUNT)
414 OR ( ( Recinfo.ENCUMBRANCE_ACCOUNT IS NULL )
415 AND ( p_ENCUMBRANCE_ACCOUNT IS NULL )))
416 AND ( ( Recinfo.PREPROCESSING_LEAD_TIME = p_PREPROCESSING_LEAD_TIME)
417 OR ( ( Recinfo.PREPROCESSING_LEAD_TIME IS NULL )
418 AND ( p_PREPROCESSING_LEAD_TIME IS NULL )))
419 AND ( ( Recinfo.PROCESSING_LEAD_TIME = p_PROCESSING_LEAD_TIME)
420 OR ( ( Recinfo.PROCESSING_LEAD_TIME IS NULL )
421 AND ( p_PROCESSING_LEAD_TIME IS NULL )))
422 AND ( ( Recinfo.POSTPROCESSING_LEAD_TIME = p_POSTPROCESSING_LEAD_TIME)
423 OR ( ( Recinfo.POSTPROCESSING_LEAD_TIME IS NULL )
424 AND ( p_POSTPROCESSING_LEAD_TIME IS NULL )))
425 ) then
426 return;
427 else
428 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
429 APP_EXCEPTION.RAISE_EXCEPTION;
430 End If;
431 END Lock_Row;
432
433 End CSP_ITEM_SUB_INVENTORIES_PKG;