[Home] [Help]
PACKAGE BODY: APPS.CSD_REPAIR_HISTORY_PKG
Source
1 PACKAGE BODY CSD_REPAIR_HISTORY_PKG as
2 /* $Header: csdtdrhb.pls 120.1 2006/02/24 17:05:28 mshirkol noship $ */
3 -- Start of Comments
4 -- Package name : CSD_REPAIR_HISTORY_PKG
5 -- Purpose :
6 -- History :
7 -- 02/05/02 travi Added Object Version Number Column
8 -- NOTE :
9 -- End of Comments
10
11
12 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_HISTORY_PKG';
13 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtrehb.pls';
14 l_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
15
16 -- travi 020502 obj ver num
17 PROCEDURE Insert_Row(
18 px_REPAIR_HISTORY_ID IN OUT NOCOPY NUMBER,
19 p_OBJECT_VERSION_NUMBER NUMBER,
20 p_REQUEST_ID NUMBER,
21 p_PROGRAM_ID NUMBER,
22 p_PROGRAM_APPLICATION_ID NUMBER,
23 p_PROGRAM_UPDATE_DATE DATE,
24 p_CREATED_BY NUMBER,
25 p_CREATION_DATE DATE,
26 p_LAST_UPDATED_BY NUMBER,
27 p_LAST_UPDATE_DATE DATE,
28 p_REPAIR_LINE_ID NUMBER,
29 p_EVENT_CODE VARCHAR2,
30 p_EVENT_DATE DATE,
31 p_QUANTITY NUMBER,
32 p_PARAMN1 NUMBER,
33 p_PARAMN2 NUMBER,
34 p_PARAMN3 NUMBER,
35 p_PARAMN4 NUMBER,
36 p_PARAMN5 NUMBER,
37 p_PARAMN6 NUMBER,
38 p_PARAMN7 NUMBER,
39 p_PARAMN8 NUMBER,
40 p_PARAMN9 NUMBER,
41 p_PARAMN10 NUMBER,
42 p_PARAMC1 VARCHAR2,
43 p_PARAMC2 VARCHAR2,
44 p_PARAMC3 VARCHAR2,
45 p_PARAMC4 VARCHAR2,
46 p_PARAMC5 VARCHAR2,
47 p_PARAMC6 VARCHAR2,
48 p_PARAMC7 VARCHAR2,
49 p_PARAMC8 VARCHAR2,
50 p_PARAMC9 VARCHAR2,
51 p_PARAMC10 VARCHAR2,
52 p_PARAMD1 DATE,
53 p_PARAMD2 DATE,
54 p_PARAMD3 DATE,
55 p_PARAMD4 DATE,
56 p_PARAMD5 DATE,
57 p_PARAMD6 DATE,
58 p_PARAMD7 DATE,
59 p_PARAMD8 DATE,
60 p_PARAMD9 DATE,
61 p_PARAMD10 DATE,
62 p_ATTRIBUTE_CATEGORY VARCHAR2,
63 p_ATTRIBUTE1 VARCHAR2,
64 p_ATTRIBUTE2 VARCHAR2,
65 p_ATTRIBUTE3 VARCHAR2,
66 p_ATTRIBUTE4 VARCHAR2,
67 p_ATTRIBUTE5 VARCHAR2,
68 p_ATTRIBUTE6 VARCHAR2,
69 p_ATTRIBUTE7 VARCHAR2,
70 p_ATTRIBUTE8 VARCHAR2,
71 p_ATTRIBUTE9 VARCHAR2,
72 p_ATTRIBUTE10 VARCHAR2,
73 p_ATTRIBUTE11 VARCHAR2,
74 p_ATTRIBUTE12 VARCHAR2,
75 p_ATTRIBUTE13 VARCHAR2,
76 p_ATTRIBUTE14 VARCHAR2,
77 p_ATTRIBUTE15 VARCHAR2,
78 p_LAST_UPDATE_LOGIN NUMBER)
79
80 IS
81 CURSOR C2 IS SELECT CSD_REPAIR_HISTORY_S1.nextval FROM sys.dual;
82 BEGIN
83 If (px_REPAIR_HISTORY_ID IS NULL) OR (px_REPAIR_HISTORY_ID = FND_API.G_MISS_NUM) then
84 OPEN C2;
85 FETCH C2 INTO px_REPAIR_HISTORY_ID;
86 CLOSE C2;
87 End If;
88 -- travi 020502 obj ver num
89 IF l_debug > 0 THEN
90 csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Insert_Row before inserting');
91 END IF;
92
93 INSERT INTO CSD_REPAIR_HISTORY(
94 REPAIR_HISTORY_ID,
95 OBJECT_VERSION_NUMBER,
96 REQUEST_ID,
97 PROGRAM_ID,
98 PROGRAM_APPLICATION_ID,
99 PROGRAM_UPDATE_DATE,
100 CREATED_BY,
101 CREATION_DATE,
102 LAST_UPDATED_BY,
103 LAST_UPDATE_DATE,
104 REPAIR_LINE_ID,
105 EVENT_CODE,
106 EVENT_DATE,
107 QUANTITY,
108 PARAMN1,
109 PARAMN2,
110 PARAMN3,
111 PARAMN4,
112 PARAMN5,
113 PARAMN6,
114 PARAMN7,
115 PARAMN8,
116 PARAMN9,
117 PARAMN10,
118 PARAMC1,
119 PARAMC2,
120 PARAMC3,
121 PARAMC4,
122 PARAMC5,
123 PARAMC6,
124 PARAMC7,
125 PARAMC8,
126 PARAMC9,
127 PARAMC10,
128 PARAMD1,
129 PARAMD2,
130 PARAMD3,
131 PARAMD4,
132 PARAMD5,
133 PARAMD6,
134 PARAMD7,
135 PARAMD8,
136 PARAMD9,
137 PARAMD10,
138 ATTRIBUTE_CATEGORY,
139 ATTRIBUTE1,
140 ATTRIBUTE2,
141 ATTRIBUTE3,
142 ATTRIBUTE4,
143 ATTRIBUTE5,
144 ATTRIBUTE6,
145 ATTRIBUTE7,
146 ATTRIBUTE8,
147 ATTRIBUTE9,
148 ATTRIBUTE10,
149 ATTRIBUTE11,
150 ATTRIBUTE12,
151 ATTRIBUTE13,
152 ATTRIBUTE14,
153 ATTRIBUTE15,
154 LAST_UPDATE_LOGIN
155 ) VALUES (
156 px_REPAIR_HISTORY_ID,
157 -- 4423818 : For insert p_OBJECT_VERSION_NUMBER should be 1
158 1,
159 -- decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
160 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
161 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
162 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
163 decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(NULL), p_PROGRAM_UPDATE_DATE),
164 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
165 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, to_date(NULL), p_CREATION_DATE),
166 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
167 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(NULL), p_LAST_UPDATE_DATE),
168 decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID),
169 decode( p_EVENT_CODE, FND_API.G_MISS_CHAR, NULL, p_EVENT_CODE),
170 decode( p_EVENT_DATE, FND_API.G_MISS_DATE, to_date(NULL), p_EVENT_DATE),
171 decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
172 decode( p_PARAMN1, FND_API.G_MISS_NUM, NULL, p_PARAMN1),
173 decode( p_PARAMN2, FND_API.G_MISS_NUM, NULL, p_PARAMN2),
174 decode( p_PARAMN3, FND_API.G_MISS_NUM, NULL, p_PARAMN3),
175 decode( p_PARAMN4, FND_API.G_MISS_NUM, NULL, p_PARAMN4),
176 decode( p_PARAMN5, FND_API.G_MISS_NUM, NULL, p_PARAMN5),
177 decode( p_PARAMN6, FND_API.G_MISS_NUM, NULL, p_PARAMN6),
178 decode( p_PARAMN7, FND_API.G_MISS_NUM, NULL, p_PARAMN7),
179 decode( p_PARAMN8, FND_API.G_MISS_NUM, NULL, p_PARAMN8),
180 decode( p_PARAMN9, FND_API.G_MISS_NUM, NULL, p_PARAMN9),
181 decode( p_PARAMN10, FND_API.G_MISS_NUM, NULL, p_PARAMN10),
182 decode( p_PARAMC1, FND_API.G_MISS_CHAR, NULL, p_PARAMC1),
183 decode( p_PARAMC2, FND_API.G_MISS_CHAR, NULL, p_PARAMC2),
184 decode( p_PARAMC3, FND_API.G_MISS_CHAR, NULL, p_PARAMC3),
185 decode( p_PARAMC4, FND_API.G_MISS_CHAR, NULL, p_PARAMC4),
186 decode( p_PARAMC5, FND_API.G_MISS_CHAR, NULL, p_PARAMC5),
187 decode( p_PARAMC6, FND_API.G_MISS_CHAR, NULL, p_PARAMC6),
188 decode( p_PARAMC7, FND_API.G_MISS_CHAR, NULL, p_PARAMC7),
189 decode( p_PARAMC8, FND_API.G_MISS_CHAR, NULL, p_PARAMC8),
190 decode( p_PARAMC9, FND_API.G_MISS_CHAR, NULL, p_PARAMC9),
191 decode( p_PARAMC10, FND_API.G_MISS_CHAR, NULL, p_PARAMC10),
192 decode( p_PARAMD1, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD1),
193 decode( p_PARAMD2, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD2),
194 decode( p_PARAMD3, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD3),
195 decode( p_PARAMD4, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD4),
196 decode( p_PARAMD5, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD5),
197 decode( p_PARAMD6, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD6),
198 decode( p_PARAMD7, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD7),
199 decode( p_PARAMD8, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD8),
200 decode( p_PARAMD9, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD9),
201 decode( p_PARAMD10, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD10),
202 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
203 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
204 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
205 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
206 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
207 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
208 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
209 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
210 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
211 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
212 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
213 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
214 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
215 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
216 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
217 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
218 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
219 IF l_debug > 0 THEN
220 csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Insert_Row after inserting');
221 END IF;
222
223 End Insert_Row;
224
225 -- travi 020502 obj ver num
226 PROCEDURE Update_Row(
227 p_REPAIR_HISTORY_ID NUMBER,
228 p_OBJECT_VERSION_NUMBER NUMBER,
229 p_REQUEST_ID NUMBER,
230 p_PROGRAM_ID NUMBER,
231 p_PROGRAM_APPLICATION_ID NUMBER,
232 p_PROGRAM_UPDATE_DATE DATE,
233 p_CREATED_BY NUMBER,
234 p_CREATION_DATE DATE,
235 p_LAST_UPDATED_BY NUMBER,
236 p_LAST_UPDATE_DATE DATE,
237 p_REPAIR_LINE_ID NUMBER,
238 p_EVENT_CODE VARCHAR2,
239 p_EVENT_DATE DATE,
240 p_QUANTITY NUMBER,
241 p_PARAMN1 NUMBER,
242 p_PARAMN2 NUMBER,
243 p_PARAMN3 NUMBER,
244 p_PARAMN4 NUMBER,
245 p_PARAMN5 NUMBER,
246 p_PARAMN6 NUMBER,
247 p_PARAMN7 NUMBER,
248 p_PARAMN8 NUMBER,
249 p_PARAMN9 NUMBER,
250 p_PARAMN10 NUMBER,
251 p_PARAMC1 VARCHAR2,
252 p_PARAMC2 VARCHAR2,
253 p_PARAMC3 VARCHAR2,
254 p_PARAMC4 VARCHAR2,
255 p_PARAMC5 VARCHAR2,
256 p_PARAMC6 VARCHAR2,
257 p_PARAMC7 VARCHAR2,
258 p_PARAMC8 VARCHAR2,
259 p_PARAMC9 VARCHAR2,
260 p_PARAMC10 VARCHAR2,
261 p_PARAMD1 DATE,
262 p_PARAMD2 DATE,
263 p_PARAMD3 DATE,
264 p_PARAMD4 DATE,
265 p_PARAMD5 DATE,
266 p_PARAMD6 DATE,
267 p_PARAMD7 DATE,
268 p_PARAMD8 DATE,
269 p_PARAMD9 DATE,
270 p_PARAMD10 DATE,
271 p_ATTRIBUTE_CATEGORY VARCHAR2,
272 p_ATTRIBUTE1 VARCHAR2,
273 p_ATTRIBUTE2 VARCHAR2,
274 p_ATTRIBUTE3 VARCHAR2,
275 p_ATTRIBUTE4 VARCHAR2,
276 p_ATTRIBUTE5 VARCHAR2,
277 p_ATTRIBUTE6 VARCHAR2,
278 p_ATTRIBUTE7 VARCHAR2,
279 p_ATTRIBUTE8 VARCHAR2,
280 p_ATTRIBUTE9 VARCHAR2,
281 p_ATTRIBUTE10 VARCHAR2,
282 p_ATTRIBUTE11 VARCHAR2,
283 p_ATTRIBUTE12 VARCHAR2,
284 p_ATTRIBUTE13 VARCHAR2,
285 p_ATTRIBUTE14 VARCHAR2,
286 p_ATTRIBUTE15 VARCHAR2,
287 p_LAST_UPDATE_LOGIN NUMBER)
288
289 IS
290 BEGIN
291 -- travi 020502 obj ver num
292 IF l_debug = 'Y' THEN
293 csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Update_Row before update');
294 END IF;
295
296 Update CSD_REPAIR_HISTORY
297 SET
298 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
299 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
300 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
301 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
302 PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
303 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
304 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
305 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
306 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
307 REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID),
308 EVENT_CODE = decode( p_EVENT_CODE, FND_API.G_MISS_CHAR, EVENT_CODE, p_EVENT_CODE),
309 EVENT_DATE = decode( p_EVENT_DATE, FND_API.G_MISS_DATE, EVENT_DATE, p_EVENT_DATE),
310 QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
311 PARAMN1 = decode( p_PARAMN1, FND_API.G_MISS_NUM, PARAMN1, p_PARAMN1),
312 PARAMN2 = decode( p_PARAMN2, FND_API.G_MISS_NUM, PARAMN2, p_PARAMN2),
313 PARAMN3 = decode( p_PARAMN3, FND_API.G_MISS_NUM, PARAMN3, p_PARAMN3),
314 PARAMN4 = decode( p_PARAMN4, FND_API.G_MISS_NUM, PARAMN4, p_PARAMN4),
315 PARAMN5 = decode( p_PARAMN5, FND_API.G_MISS_NUM, PARAMN5, p_PARAMN5),
316 PARAMN6 = decode( p_PARAMN6, FND_API.G_MISS_NUM, PARAMN6, p_PARAMN6),
317 PARAMN7 = decode( p_PARAMN7, FND_API.G_MISS_NUM, PARAMN7, p_PARAMN7),
318 PARAMN8 = decode( p_PARAMN8, FND_API.G_MISS_NUM, PARAMN8, p_PARAMN8),
319 PARAMN9 = decode( p_PARAMN9, FND_API.G_MISS_NUM, PARAMN9, p_PARAMN9),
320 PARAMN10 = decode( p_PARAMN10, FND_API.G_MISS_NUM, PARAMN10, p_PARAMN10),
321 PARAMC1 = decode( p_PARAMC1, FND_API.G_MISS_CHAR, PARAMC1, p_PARAMC1),
325 PARAMC5 = decode( p_PARAMC5, FND_API.G_MISS_CHAR, PARAMC5, p_PARAMC5),
322 PARAMC2 = decode( p_PARAMC2, FND_API.G_MISS_CHAR, PARAMC2, p_PARAMC2),
323 PARAMC3 = decode( p_PARAMC3, FND_API.G_MISS_CHAR, PARAMC3, p_PARAMC3),
324 PARAMC4 = decode( p_PARAMC4, FND_API.G_MISS_CHAR, PARAMC4, p_PARAMC4),
326 PARAMC6 = decode( p_PARAMC6, FND_API.G_MISS_CHAR, PARAMC6, p_PARAMC6),
327 PARAMC7 = decode( p_PARAMC7, FND_API.G_MISS_CHAR, PARAMC7, p_PARAMC7),
328 PARAMC8 = decode( p_PARAMC8, FND_API.G_MISS_CHAR, PARAMC8, p_PARAMC8),
329 PARAMC9 = decode( p_PARAMC9, FND_API.G_MISS_CHAR, PARAMC9, p_PARAMC9),
330 PARAMC10 = decode( p_PARAMC10, FND_API.G_MISS_CHAR, PARAMC10, p_PARAMC10),
331 PARAMD1 = decode( p_PARAMD1, FND_API.G_MISS_DATE, PARAMD1, p_PARAMD1),
332 PARAMD2 = decode( p_PARAMD2, FND_API.G_MISS_DATE, PARAMD2, p_PARAMD2),
333 PARAMD3 = decode( p_PARAMD3, FND_API.G_MISS_DATE, PARAMD3, p_PARAMD3),
334 PARAMD4 = decode( p_PARAMD4, FND_API.G_MISS_DATE, PARAMD4, p_PARAMD4),
335 PARAMD5 = decode( p_PARAMD5, FND_API.G_MISS_DATE, PARAMD5, p_PARAMD5),
336 PARAMD6 = decode( p_PARAMD6, FND_API.G_MISS_DATE, PARAMD6, p_PARAMD6),
337 PARAMD7 = decode( p_PARAMD7, FND_API.G_MISS_DATE, PARAMD7, p_PARAMD7),
338 PARAMD8 = decode( p_PARAMD8, FND_API.G_MISS_DATE, PARAMD8, p_PARAMD8),
339 PARAMD9 = decode( p_PARAMD9, FND_API.G_MISS_DATE, PARAMD9, p_PARAMD9),
340 PARAMD10 = decode( p_PARAMD10, FND_API.G_MISS_DATE, PARAMD10, p_PARAMD10),
341 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
342 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
343 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
344 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
345 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
346 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
347 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
348 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
349 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
350 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
351 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
352 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
353 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
354 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
355 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
356 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
357 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
358 where REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID;
359
360 IF l_debug = 'Y' THEN
361 csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Update_Row after update ');
362 END IF;
363
364 If (SQL%NOTFOUND) then
365 RAISE NO_DATA_FOUND;
366 End If;
367 END Update_Row;
368
369 PROCEDURE Delete_Row(
370 p_REPAIR_HISTORY_ID NUMBER,
371 p_OBJECT_VERSION_NUMBER NUMBER)
372 IS
373 BEGIN
374 DELETE FROM CSD_REPAIR_HISTORY
375 WHERE REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID;
376 If (SQL%NOTFOUND) then
377 RAISE NO_DATA_FOUND;
378 End If;
379 END Delete_Row;
380
381 -- travi 020502 obj ver num
382 PROCEDURE Lock_Row(
383 p_REPAIR_HISTORY_ID NUMBER,
384 p_OBJECT_VERSION_NUMBER NUMBER,
385 p_REQUEST_ID NUMBER,
386 p_PROGRAM_ID NUMBER,
387 p_PROGRAM_APPLICATION_ID NUMBER,
388 p_PROGRAM_UPDATE_DATE DATE,
389 p_CREATED_BY NUMBER,
390 p_CREATION_DATE DATE,
391 p_LAST_UPDATED_BY NUMBER,
392 p_LAST_UPDATE_DATE DATE,
393 p_REPAIR_LINE_ID NUMBER,
394 p_EVENT_CODE VARCHAR2,
395 p_EVENT_DATE DATE,
396 p_QUANTITY NUMBER,
397 p_PARAMN1 NUMBER,
398 p_PARAMN2 NUMBER,
399 p_PARAMN3 NUMBER,
400 p_PARAMN4 NUMBER,
401 p_PARAMN5 NUMBER,
402 p_PARAMN6 NUMBER,
403 p_PARAMN7 NUMBER,
404 p_PARAMN8 NUMBER,
405 p_PARAMN9 NUMBER,
406 p_PARAMN10 NUMBER,
407 p_PARAMC1 VARCHAR2,
408 p_PARAMC2 VARCHAR2,
409 p_PARAMC3 VARCHAR2,
410 p_PARAMC4 VARCHAR2,
411 p_PARAMC5 VARCHAR2,
412 p_PARAMC6 VARCHAR2,
413 p_PARAMC7 VARCHAR2,
414 p_PARAMC8 VARCHAR2,
415 p_PARAMC9 VARCHAR2,
416 p_PARAMC10 VARCHAR2,
417 p_PARAMD1 DATE,
418 p_PARAMD2 DATE,
419 p_PARAMD3 DATE,
420 p_PARAMD4 DATE,
421 p_PARAMD5 DATE,
422 p_PARAMD6 DATE,
423 p_PARAMD7 DATE,
424 p_PARAMD8 DATE,
428 p_ATTRIBUTE1 VARCHAR2,
425 p_PARAMD9 DATE,
426 p_PARAMD10 DATE,
427 p_ATTRIBUTE_CATEGORY VARCHAR2,
429 p_ATTRIBUTE2 VARCHAR2,
430 p_ATTRIBUTE3 VARCHAR2,
431 p_ATTRIBUTE4 VARCHAR2,
432 p_ATTRIBUTE5 VARCHAR2,
433 p_ATTRIBUTE6 VARCHAR2,
434 p_ATTRIBUTE7 VARCHAR2,
435 p_ATTRIBUTE8 VARCHAR2,
436 p_ATTRIBUTE9 VARCHAR2,
437 p_ATTRIBUTE10 VARCHAR2,
438 p_ATTRIBUTE11 VARCHAR2,
439 p_ATTRIBUTE12 VARCHAR2,
440 p_ATTRIBUTE13 VARCHAR2,
441 p_ATTRIBUTE14 VARCHAR2,
442 p_ATTRIBUTE15 VARCHAR2,
443 p_LAST_UPDATE_LOGIN NUMBER)
444
445 IS
446 CURSOR C IS
447 SELECT *
448 FROM CSD_REPAIR_HISTORY
449 WHERE REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID
450 FOR UPDATE of REPAIR_HISTORY_ID NOWAIT;
451 Recinfo C%ROWTYPE;
452 BEGIN
453 OPEN C;
454 FETCH C INTO Recinfo;
455 If (C%NOTFOUND) then
456 CLOSE C;
457 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
458 APP_EXCEPTION.RAISE_EXCEPTION;
459 End If;
460 CLOSE C;
461
462 -- travi 020502 obj ver num
463 if (
464 ( Recinfo.REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID)
465 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
466 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
467 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
468 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
469 OR ( ( Recinfo.REQUEST_ID IS NULL )
470 AND ( p_REQUEST_ID IS NULL )))
471 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
472 OR ( ( Recinfo.PROGRAM_ID IS NULL )
473 AND ( p_PROGRAM_ID IS NULL )))
474 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
475 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
476 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
477 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
478 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
479 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
480 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
481 OR ( ( Recinfo.CREATED_BY IS NULL )
482 AND ( p_CREATED_BY IS NULL )))
483 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
484 OR ( ( Recinfo.CREATION_DATE IS NULL )
485 AND ( p_CREATION_DATE IS NULL )))
486 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
487 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
488 AND ( p_LAST_UPDATED_BY IS NULL )))
489 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
490 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
491 AND ( p_LAST_UPDATE_DATE IS NULL )))
492 AND ( ( Recinfo.REPAIR_LINE_ID = p_REPAIR_LINE_ID)
493 OR ( ( Recinfo.REPAIR_LINE_ID IS NULL )
494 AND ( p_REPAIR_LINE_ID IS NULL )))
495 AND ( ( Recinfo.EVENT_CODE = p_EVENT_CODE)
496 OR ( ( Recinfo.EVENT_CODE IS NULL )
497 AND ( p_EVENT_CODE IS NULL )))
498 AND ( ( Recinfo.EVENT_DATE = p_EVENT_DATE)
499 OR ( ( Recinfo.EVENT_DATE IS NULL )
500 AND ( p_EVENT_DATE IS NULL )))
501 AND ( ( Recinfo.QUANTITY = p_QUANTITY)
502 OR ( ( Recinfo.QUANTITY IS NULL )
503 AND ( p_QUANTITY IS NULL )))
504 AND ( ( Recinfo.PARAMN1 = p_PARAMN1)
505 OR ( ( Recinfo.PARAMN1 IS NULL )
506 AND ( p_PARAMN1 IS NULL )))
507 AND ( ( Recinfo.PARAMN2 = p_PARAMN2)
508 OR ( ( Recinfo.PARAMN2 IS NULL )
509 AND ( p_PARAMN2 IS NULL )))
510 AND ( ( Recinfo.PARAMN3 = p_PARAMN3)
511 OR ( ( Recinfo.PARAMN3 IS NULL )
512 AND ( p_PARAMN3 IS NULL )))
513 AND ( ( Recinfo.PARAMN4 = p_PARAMN4)
514 OR ( ( Recinfo.PARAMN4 IS NULL )
515 AND ( p_PARAMN4 IS NULL )))
516 AND ( ( Recinfo.PARAMN5 = p_PARAMN5)
517 OR ( ( Recinfo.PARAMN5 IS NULL )
518 AND ( p_PARAMN5 IS NULL )))
519 AND ( ( Recinfo.PARAMN6 = p_PARAMN6)
520 OR ( ( Recinfo.PARAMN6 IS NULL )
521 AND ( p_PARAMN6 IS NULL )))
522 AND ( ( Recinfo.PARAMN7 = p_PARAMN7)
523 OR ( ( Recinfo.PARAMN7 IS NULL )
524 AND ( p_PARAMN7 IS NULL )))
525 AND ( ( Recinfo.PARAMN8 = p_PARAMN8)
526 OR ( ( Recinfo.PARAMN8 IS NULL )
527 AND ( p_PARAMN8 IS NULL )))
528 AND ( ( Recinfo.PARAMN9 = p_PARAMN9)
529 OR ( ( Recinfo.PARAMN9 IS NULL )
530 AND ( p_PARAMN9 IS NULL )))
531 AND ( ( Recinfo.PARAMN10 = p_PARAMN10)
532 OR ( ( Recinfo.PARAMN10 IS NULL )
533 AND ( p_PARAMN10 IS NULL )))
534 AND ( ( Recinfo.PARAMC1 = p_PARAMC1)
535 OR ( ( Recinfo.PARAMC1 IS NULL )
536 AND ( p_PARAMC1 IS NULL )))
537 AND ( ( Recinfo.PARAMC2 = p_PARAMC2)
538 OR ( ( Recinfo.PARAMC2 IS NULL )
539 AND ( p_PARAMC2 IS NULL )))
540 AND ( ( Recinfo.PARAMC3 = p_PARAMC3)
541 OR ( ( Recinfo.PARAMC3 IS NULL )
545 AND ( p_PARAMC4 IS NULL )))
542 AND ( p_PARAMC3 IS NULL )))
543 AND ( ( Recinfo.PARAMC4 = p_PARAMC4)
544 OR ( ( Recinfo.PARAMC4 IS NULL )
546 AND ( ( Recinfo.PARAMC5 = p_PARAMC5)
547 OR ( ( Recinfo.PARAMC5 IS NULL )
548 AND ( p_PARAMC5 IS NULL )))
549 AND ( ( Recinfo.PARAMC6 = p_PARAMC6)
550 OR ( ( Recinfo.PARAMC6 IS NULL )
551 AND ( p_PARAMC6 IS NULL )))
552 AND ( ( Recinfo.PARAMC7 = p_PARAMC7)
553 OR ( ( Recinfo.PARAMC7 IS NULL )
554 AND ( p_PARAMC7 IS NULL )))
555 AND ( ( Recinfo.PARAMC8 = p_PARAMC8)
556 OR ( ( Recinfo.PARAMC8 IS NULL )
557 AND ( p_PARAMC8 IS NULL )))
558 AND ( ( Recinfo.PARAMC9 = p_PARAMC9)
559 OR ( ( Recinfo.PARAMC9 IS NULL )
560 AND ( p_PARAMC9 IS NULL )))
561 AND ( ( Recinfo.PARAMC10 = p_PARAMC10)
562 OR ( ( Recinfo.PARAMC10 IS NULL )
563 AND ( p_PARAMC10 IS NULL )))
564 AND ( ( Recinfo.PARAMD1 = p_PARAMD1)
565 OR ( ( Recinfo.PARAMD1 IS NULL )
566 AND ( p_PARAMD1 IS NULL )))
567 AND ( ( Recinfo.PARAMD2 = p_PARAMD2)
568 OR ( ( Recinfo.PARAMD2 IS NULL )
569 AND ( p_PARAMD2 IS NULL )))
570 AND ( ( Recinfo.PARAMD3 = p_PARAMD3)
571 OR ( ( Recinfo.PARAMD3 IS NULL )
572 AND ( p_PARAMD3 IS NULL )))
573 AND ( ( Recinfo.PARAMD4 = p_PARAMD4)
574 OR ( ( Recinfo.PARAMD4 IS NULL )
575 AND ( p_PARAMD4 IS NULL )))
576 AND ( ( Recinfo.PARAMD5 = p_PARAMD5)
577 OR ( ( Recinfo.PARAMD5 IS NULL )
578 AND ( p_PARAMD5 IS NULL )))
579 AND ( ( Recinfo.PARAMD6 = p_PARAMD6)
580 OR ( ( Recinfo.PARAMD6 IS NULL )
581 AND ( p_PARAMD6 IS NULL )))
582 AND ( ( Recinfo.PARAMD7 = p_PARAMD7)
583 OR ( ( Recinfo.PARAMD7 IS NULL )
584 AND ( p_PARAMD7 IS NULL )))
585 AND ( ( Recinfo.PARAMD8 = p_PARAMD8)
586 OR ( ( Recinfo.PARAMD8 IS NULL )
587 AND ( p_PARAMD8 IS NULL )))
588 AND ( ( Recinfo.PARAMD9 = p_PARAMD9)
589 OR ( ( Recinfo.PARAMD9 IS NULL )
590 AND ( p_PARAMD9 IS NULL )))
591 AND ( ( Recinfo.PARAMD10 = p_PARAMD10)
592 OR ( ( Recinfo.PARAMD10 IS NULL )
593 AND ( p_PARAMD10 IS NULL )))
594 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
595 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
596 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
597 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
598 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
599 AND ( p_ATTRIBUTE1 IS NULL )))
600 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
601 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
602 AND ( p_ATTRIBUTE2 IS NULL )))
603 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
604 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
605 AND ( p_ATTRIBUTE3 IS NULL )))
606 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
607 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
608 AND ( p_ATTRIBUTE4 IS NULL )))
609 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
610 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
611 AND ( p_ATTRIBUTE5 IS NULL )))
612 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
613 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
614 AND ( p_ATTRIBUTE6 IS NULL )))
615 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
616 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
617 AND ( p_ATTRIBUTE7 IS NULL )))
618 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
619 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
620 AND ( p_ATTRIBUTE8 IS NULL )))
621 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
622 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
623 AND ( p_ATTRIBUTE9 IS NULL )))
624 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
625 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
626 AND ( p_ATTRIBUTE10 IS NULL )))
627 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
628 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
629 AND ( p_ATTRIBUTE11 IS NULL )))
630 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
631 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
632 AND ( p_ATTRIBUTE12 IS NULL )))
633 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
634 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
635 AND ( p_ATTRIBUTE13 IS NULL )))
636 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
637 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
638 AND ( p_ATTRIBUTE14 IS NULL )))
639 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
640 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
641 AND ( p_ATTRIBUTE15 IS NULL )))
642 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
643 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
644 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
645 ) then
646 return;
647 else
648 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
649 APP_EXCEPTION.RAISE_EXCEPTION;
650 End If;
651 END Lock_Row;
652
653 End CSD_REPAIR_HISTORY_PKG;