[Home] [Help]
PACKAGE BODY: APPS.CSD_REPAIR_JOB_XREF_PKG
Source
1 PACKAGE BODY CSD_REPAIR_JOB_XREF_PKG as
2 /* $Header: csdtdrjb.pls 115.12 2003/09/15 21:32:59 sragunat ship $ */
3 -- Start of Comments
4 -- Package name : CSD_REPAIR_JOB_XREF_PKG
5 -- Purpose :
6 -- History : Added Columns Inventory_Item_ID and Item_Revision -- travi
7 -- History : 01/17/2002, TRAVI added column OBJECT_VERSION_NUMBER
8 -- History : 08/20/2003, Shiv Ragunathan, 11.5.10 Changes: Added parameters
9 -- History : p_source_type_code, p_source_id1, p_ro_service_code_id, p_job_name
10 -- History : to Insert_row procedure.
11 -- NOTE :
12 -- End of Comments
13
14
15 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_JOB_XREF_PKG';
16 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtrjxb.pls';
17 l_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
18
19 PROCEDURE Insert_Row(
20 px_REPAIR_JOB_XREF_ID IN OUT NOCOPY NUMBER,
21 p_CREATED_BY NUMBER,
22 p_CREATION_DATE DATE,
23 p_LAST_UPDATED_BY NUMBER,
24 p_LAST_UPDATE_DATE DATE,
25 p_LAST_UPDATE_LOGIN NUMBER,
26 p_REPAIR_LINE_ID NUMBER,
27 p_WIP_ENTITY_ID NUMBER,
28 p_GROUP_ID NUMBER,
29 p_ORGANIZATION_ID NUMBER,
30 p_QUANTITY NUMBER,
31 p_INVENTORY_ITEM_ID NUMBER,
32 p_ITEM_REVISION VARCHAR2,
33 p_SOURCE_TYPE_CODE VARCHAR2,
34 p_SOURCE_ID1 NUMBER,
35 p_RO_SERVICE_CODE_ID NUMBER,
36 p_JOB_NAME VARCHAR2,
37 p_OBJECT_VERSION_NUMBER NUMBER,
38 p_ATTRIBUTE_CATEGORY VARCHAR2,
39 p_ATTRIBUTE1 VARCHAR2,
40 p_ATTRIBUTE2 VARCHAR2,
41 p_ATTRIBUTE3 VARCHAR2,
42 p_ATTRIBUTE4 VARCHAR2,
43 p_ATTRIBUTE5 VARCHAR2,
44 p_ATTRIBUTE6 VARCHAR2,
45 p_ATTRIBUTE7 VARCHAR2,
46 p_ATTRIBUTE8 VARCHAR2,
47 p_ATTRIBUTE9 VARCHAR2,
48 p_ATTRIBUTE10 VARCHAR2,
49 p_ATTRIBUTE11 VARCHAR2,
50 p_ATTRIBUTE12 VARCHAR2,
51 p_ATTRIBUTE13 VARCHAR2,
52 p_ATTRIBUTE14 VARCHAR2,
53 p_ATTRIBUTE15 VARCHAR2,
54 P_QUANTITY_COMPLETED NUMBER)
55
56 IS
57 CURSOR C2 IS SELECT CSD_REPAIR_JOB_XREF_S1.nextval FROM sys.dual;
58 BEGIN
59 If (px_REPAIR_JOB_XREF_ID IS NULL) OR (px_REPAIR_JOB_XREF_ID = FND_API.G_MISS_NUM) then
60 OPEN C2;
61 FETCH C2 INTO px_REPAIR_JOB_XREF_ID;
62 CLOSE C2;
63 End If;
64
65 IF l_debug > 0 THEN
66 csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PKG.Insert_Row OVN : '||to_char(p_OBJECT_VERSION_NUMBER));
67 END IF;
68
69 INSERT INTO CSD_REPAIR_JOB_XREF(
70 REPAIR_JOB_XREF_ID,
71 CREATED_BY,
72 CREATION_DATE,
73 LAST_UPDATED_BY,
74 LAST_UPDATE_DATE,
75 LAST_UPDATE_LOGIN,
76 REPAIR_LINE_ID,
77 WIP_ENTITY_ID,
78 GROUP_ID,
79 ORGANIZATION_ID,
80 QUANTITY,
81 INVENTORY_ITEM_ID,
82 ITEM_REVISION,
83 SOURCE_TYPE_CODE,
84 SOURCE_ID1 ,
85 RO_SERVICE_CODE_ID ,
86 JOB_NAME,
87 OBJECT_VERSION_NUMBER,
88 ATTRIBUTE_CATEGORY,
89 ATTRIBUTE1,
90 ATTRIBUTE2,
91 ATTRIBUTE3,
92 ATTRIBUTE4,
93 ATTRIBUTE5,
94 ATTRIBUTE6,
95 ATTRIBUTE7,
96 ATTRIBUTE8,
97 ATTRIBUTE9,
98 ATTRIBUTE10,
99 ATTRIBUTE11,
100 ATTRIBUTE12,
101 ATTRIBUTE13,
102 ATTRIBUTE14,
103 ATTRIBUTE15,
104 QUANTITY_COMPLETED
105 ) VALUES (
106 px_REPAIR_JOB_XREF_ID,
107 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
108 decode( p_CREATION_DATE, fnd_api.g_miss_date, to_date(null), p_CREATION_DATE),
109 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
110 decode( p_LAST_UPDATE_DATE, fnd_api.g_miss_date, to_date(null), p_LAST_UPDATE_DATE),
111 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
112 decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID),
113 decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID),
114 decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
115 decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
116 decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
117 decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
118 decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, p_ITEM_REVISION),
119 decode( p_SOURCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TYPE_CODE ),
120 decode( p_SOURCE_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_ID1),
121 decode( p_RO_SERVICE_CODE_ID, FND_API.G_MISS_NUM, NULL, p_RO_SERVICE_CODE_ID),
122 decode( p_JOB_NAME, FND_API.G_MISS_CHAR, NULL, p_JOB_NAME ),
123 decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
124 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
125 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
126 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
127 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
128 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
129 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
130 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
131 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
132 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
133 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
134 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
135 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
136 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
137 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
138 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
139 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
140 decode( p_QUANTITY_completed, FND_API.G_MISS_NUM, NULL, p_QUANTITY_completed));
141 End Insert_Row;
142
143 PROCEDURE Update_Row(
144 p_REPAIR_JOB_XREF_ID NUMBER,
145 p_CREATED_BY NUMBER,
146 p_CREATION_DATE DATE,
147 p_LAST_UPDATED_BY NUMBER,
148 p_LAST_UPDATE_DATE DATE,
149 p_LAST_UPDATE_LOGIN NUMBER,
150 p_REPAIR_LINE_ID NUMBER,
151 p_WIP_ENTITY_ID NUMBER,
152 p_GROUP_ID NUMBER,
153 p_ORGANIZATION_ID NUMBER,
154 p_QUANTITY NUMBER,
155 p_INVENTORY_ITEM_ID NUMBER,
156 p_ITEM_REVISION VARCHAR2,
157 p_OBJECT_VERSION_NUMBER NUMBER,
158 p_ATTRIBUTE_CATEGORY VARCHAR2,
159 p_ATTRIBUTE1 VARCHAR2,
160 p_ATTRIBUTE2 VARCHAR2,
161 p_ATTRIBUTE3 VARCHAR2,
162 p_ATTRIBUTE4 VARCHAR2,
163 p_ATTRIBUTE5 VARCHAR2,
164 p_ATTRIBUTE6 VARCHAR2,
165 p_ATTRIBUTE7 VARCHAR2,
166 p_ATTRIBUTE8 VARCHAR2,
167 p_ATTRIBUTE9 VARCHAR2,
168 p_ATTRIBUTE10 VARCHAR2,
169 p_ATTRIBUTE11 VARCHAR2,
170 p_ATTRIBUTE12 VARCHAR2,
171 p_ATTRIBUTE13 VARCHAR2,
172 p_ATTRIBUTE14 VARCHAR2,
173 p_ATTRIBUTE15 VARCHAR2,
174 p_quantity_completed NUMBER)
175
176 IS
177 BEGIN
178
179 IF l_debug > 0 THEN
180 csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PKG.Update_Row OVN : '||to_char(p_OBJECT_VERSION_NUMBER));
181 END IF;
182
183 Update CSD_REPAIR_JOB_XREF
184 SET
185 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
186 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
187 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
188 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
189 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
190 REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID),
191 WIP_ENTITY_ID = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, WIP_ENTITY_ID, p_WIP_ENTITY_ID),
192 GROUP_ID = decode( p_GROUP_ID, FND_API.G_MISS_NUM, GROUP_ID, p_GROUP_ID),
193 ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
194 QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
195 INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
196 ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION),
197 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
198 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
199 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
200 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
201 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
202 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
203 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
204 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
205 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
206 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
207 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
208 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
209 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
210 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
211 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
212 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
213 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
214
215 QUANTITY_COMPLETED = decode( p_QUANTITY_completed,
216 FND_API.G_MISS_NUM, QUANTITY_COMPLETED, p_QUANTITY_completed)
217 where REPAIR_JOB_XREF_ID = p_REPAIR_JOB_XREF_ID;
218
219 If (SQL%NOTFOUND) then
220 RAISE NO_DATA_FOUND;
221 End If;
222
223 END Update_Row;
224
225 PROCEDURE Delete_Row(
226 p_REPAIR_JOB_XREF_ID NUMBER)
227 IS
228 BEGIN
229 DELETE FROM CSD_REPAIR_JOB_XREF
230 WHERE REPAIR_JOB_XREF_ID = p_REPAIR_JOB_XREF_ID;
231 If (SQL%NOTFOUND) then
232 RAISE NO_DATA_FOUND;
233 End If;
234 END Delete_Row;
235
236 PROCEDURE Lock_Row(
237 p_REPAIR_JOB_XREF_ID NUMBER,
238 p_CREATED_BY NUMBER,
239 p_CREATION_DATE DATE,
240 p_LAST_UPDATED_BY NUMBER,
241 p_LAST_UPDATE_DATE DATE,
242 p_LAST_UPDATE_LOGIN NUMBER,
243 p_REPAIR_LINE_ID NUMBER,
244 p_WIP_ENTITY_ID NUMBER,
245 p_GROUP_ID NUMBER,
246 p_ORGANIZATION_ID NUMBER,
247 p_QUANTITY NUMBER,
248 p_INVENTORY_ITEM_ID NUMBER,
249 p_ITEM_REVISION VARCHAR2,
250 p_OBJECT_VERSION_NUMBER NUMBER,
251 p_ATTRIBUTE_CATEGORY VARCHAR2,
252 p_ATTRIBUTE1 VARCHAR2,
253 p_ATTRIBUTE2 VARCHAR2,
254 p_ATTRIBUTE3 VARCHAR2,
255 p_ATTRIBUTE4 VARCHAR2,
256 p_ATTRIBUTE5 VARCHAR2,
257 p_ATTRIBUTE6 VARCHAR2,
258 p_ATTRIBUTE7 VARCHAR2,
259 p_ATTRIBUTE8 VARCHAR2,
260 p_ATTRIBUTE9 VARCHAR2,
261 p_ATTRIBUTE10 VARCHAR2,
262 p_ATTRIBUTE11 VARCHAR2,
263 p_ATTRIBUTE12 VARCHAR2,
264 p_ATTRIBUTE13 VARCHAR2,
265 p_ATTRIBUTE14 VARCHAR2,
266 p_ATTRIBUTE15 VARCHAR2,
267 p_quantity_completed NUMBER)
268
269 IS
270 CURSOR C IS
271 SELECT *
272 FROM CSD_REPAIR_JOB_XREF
273 WHERE REPAIR_JOB_XREF_ID = p_REPAIR_JOB_XREF_ID
274 FOR UPDATE of REPAIR_JOB_XREF_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
286 -- travi added for Inventory_Item_ID , Item_Revision and OBJECT_VERSION_NUMBER
287 if (
288 ( Recinfo.REPAIR_JOB_XREF_ID = p_REPAIR_JOB_XREF_ID)
289 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
290 OR ( ( Recinfo.CREATED_BY IS NULL )
291 AND ( p_CREATED_BY IS NULL )))
292 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
293 OR ( ( Recinfo.CREATION_DATE IS NULL )
294 AND ( p_CREATION_DATE IS NULL )))
295 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
296 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
297 AND ( p_LAST_UPDATED_BY IS NULL )))
298 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
299 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
300 AND ( p_LAST_UPDATE_DATE IS NULL )))
301 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
302 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
303 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
304 AND ( ( Recinfo.REPAIR_LINE_ID = p_REPAIR_LINE_ID)
305 OR ( ( Recinfo.REPAIR_LINE_ID IS NULL )
306 AND ( p_REPAIR_LINE_ID IS NULL )))
307 AND ( ( Recinfo.WIP_ENTITY_ID = p_WIP_ENTITY_ID)
308 OR ( ( Recinfo.WIP_ENTITY_ID IS NULL )
309 AND ( p_WIP_ENTITY_ID IS NULL )))
310 AND ( ( Recinfo.GROUP_ID = p_GROUP_ID)
311 OR ( ( Recinfo.GROUP_ID IS NULL )
312 AND ( p_GROUP_ID IS NULL )))
313 AND ( ( Recinfo.ORGANIZATION_ID = p_ORGANIZATION_ID)
314 OR ( ( Recinfo.ORGANIZATION_ID IS NULL )
315 AND ( p_ORGANIZATION_ID IS NULL )))
316 AND ( ( Recinfo.QUANTITY = p_QUANTITY)
317 OR ( ( Recinfo.QUANTITY IS NULL )
318 AND ( p_QUANTITY IS NULL )))
319 AND ( ( Recinfo.INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID)
320 OR ( ( Recinfo.INVENTORY_ITEM_ID IS NULL )
321 AND ( p_INVENTORY_ITEM_ID IS NULL )))
322 AND ( ( Recinfo.ITEM_REVISION = p_ITEM_REVISION)
323 OR ( ( Recinfo.ITEM_REVISION IS NULL )
324 AND ( p_ITEM_REVISION IS NULL )))
325 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
326 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
327 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
328 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
329 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
330 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
331 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
332 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
333 AND ( p_ATTRIBUTE1 IS NULL )))
334 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
335 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
336 AND ( p_ATTRIBUTE2 IS NULL )))
337 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
338 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
339 AND ( p_ATTRIBUTE3 IS NULL )))
340 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
341 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
342 AND ( p_ATTRIBUTE4 IS NULL )))
343 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
344 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
345 AND ( p_ATTRIBUTE5 IS NULL )))
346 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
347 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
348 AND ( p_ATTRIBUTE6 IS NULL )))
349 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
350 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
351 AND ( p_ATTRIBUTE7 IS NULL )))
352 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
353 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
354 AND ( p_ATTRIBUTE8 IS NULL )))
355 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
356 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
357 AND ( p_ATTRIBUTE9 IS NULL )))
358 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
359 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
360 AND ( p_ATTRIBUTE10 IS NULL )))
361 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
362 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
363 AND ( p_ATTRIBUTE11 IS NULL )))
364 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
365 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
366 AND ( p_ATTRIBUTE12 IS NULL )))
367 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
368 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
369 AND ( p_ATTRIBUTE13 IS NULL )))
370 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
371 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
372 AND ( p_ATTRIBUTE14 IS NULL )))
373 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
374 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
375 AND ( p_ATTRIBUTE15 IS NULL )))
376 AND ( ( Recinfo.quantity_completed= p_quantity_completed)
377 OR ( ( Recinfo.quantity_completed IS NULL )
378 AND ( p_quantity_completed IS NULL )))
379 ) then
380 return;
381 else
382 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
383 APP_EXCEPTION.RAISE_EXCEPTION;
384 End If;
385 END Lock_Row;
386
387 End CSD_REPAIR_JOB_XREF_PKG;