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