[Home] [Help]
PACKAGE BODY: APPS.CSD_REPAIR_HISTORY_PKG
Source
1 PACKAGE BODY CSD_REPAIR_HISTORY_PKG as
2 /* $Header: csdtdrhb.pls 120.2 2011/12/05 07:13:08 yvchen ship $ */
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,
35 p_PARAMN4 NUMBER,
32 p_PARAMN1 NUMBER,
33 p_PARAMN2 NUMBER,
34 p_PARAMN3 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 --bug#12697494, yvchen: changed NULL to FND_GLOBAL.USER_ID
165 --decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
166 decode( p_CREATED_BY, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_CREATED_BY),
167 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, to_date(NULL), p_CREATION_DATE),
168 --bug#12697494, yvchen: changed NULL to FND_GLOBAL.USER_ID
169 --decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
170 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_LAST_UPDATED_BY),
171 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(NULL), p_LAST_UPDATE_DATE),
172 decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID),
173 decode( p_EVENT_CODE, FND_API.G_MISS_CHAR, NULL, p_EVENT_CODE),
174 decode( p_EVENT_DATE, FND_API.G_MISS_DATE, to_date(NULL), p_EVENT_DATE),
175 decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
176 decode( p_PARAMN1, FND_API.G_MISS_NUM, NULL, p_PARAMN1),
177 decode( p_PARAMN2, FND_API.G_MISS_NUM, NULL, p_PARAMN2),
181 decode( p_PARAMN6, FND_API.G_MISS_NUM, NULL, p_PARAMN6),
178 decode( p_PARAMN3, FND_API.G_MISS_NUM, NULL, p_PARAMN3),
179 decode( p_PARAMN4, FND_API.G_MISS_NUM, NULL, p_PARAMN4),
180 decode( p_PARAMN5, FND_API.G_MISS_NUM, NULL, p_PARAMN5),
182 decode( p_PARAMN7, FND_API.G_MISS_NUM, NULL, p_PARAMN7),
183 decode( p_PARAMN8, FND_API.G_MISS_NUM, NULL, p_PARAMN8),
184 decode( p_PARAMN9, FND_API.G_MISS_NUM, NULL, p_PARAMN9),
185 decode( p_PARAMN10, FND_API.G_MISS_NUM, NULL, p_PARAMN10),
186 decode( p_PARAMC1, FND_API.G_MISS_CHAR, NULL, p_PARAMC1),
187 decode( p_PARAMC2, FND_API.G_MISS_CHAR, NULL, p_PARAMC2),
188 decode( p_PARAMC3, FND_API.G_MISS_CHAR, NULL, p_PARAMC3),
189 decode( p_PARAMC4, FND_API.G_MISS_CHAR, NULL, p_PARAMC4),
190 decode( p_PARAMC5, FND_API.G_MISS_CHAR, NULL, p_PARAMC5),
191 decode( p_PARAMC6, FND_API.G_MISS_CHAR, NULL, p_PARAMC6),
192 decode( p_PARAMC7, FND_API.G_MISS_CHAR, NULL, p_PARAMC7),
193 decode( p_PARAMC8, FND_API.G_MISS_CHAR, NULL, p_PARAMC8),
194 decode( p_PARAMC9, FND_API.G_MISS_CHAR, NULL, p_PARAMC9),
195 decode( p_PARAMC10, FND_API.G_MISS_CHAR, NULL, p_PARAMC10),
196 decode( p_PARAMD1, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD1),
197 decode( p_PARAMD2, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD2),
198 decode( p_PARAMD3, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD3),
199 decode( p_PARAMD4, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD4),
200 decode( p_PARAMD5, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD5),
201 decode( p_PARAMD6, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD6),
202 decode( p_PARAMD7, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD7),
203 decode( p_PARAMD8, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD8),
204 decode( p_PARAMD9, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD9),
205 decode( p_PARAMD10, FND_API.G_MISS_DATE, to_date(NULL), p_PARAMD10),
206 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
207 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
208 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
209 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
210 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
211 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
212 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
213 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
214 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
215 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
216 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
217 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
218 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
219 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
220 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
221 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
222 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
223 IF l_debug > 0 THEN
224 csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Insert_Row after inserting');
225 END IF;
226
227 End Insert_Row;
228
229 -- travi 020502 obj ver num
230 PROCEDURE Update_Row(
231 p_REPAIR_HISTORY_ID NUMBER,
232 p_OBJECT_VERSION_NUMBER NUMBER,
233 p_REQUEST_ID NUMBER,
234 p_PROGRAM_ID NUMBER,
235 p_PROGRAM_APPLICATION_ID NUMBER,
236 p_PROGRAM_UPDATE_DATE DATE,
237 p_CREATED_BY NUMBER,
238 p_CREATION_DATE DATE,
239 p_LAST_UPDATED_BY NUMBER,
240 p_LAST_UPDATE_DATE DATE,
241 p_REPAIR_LINE_ID NUMBER,
242 p_EVENT_CODE VARCHAR2,
243 p_EVENT_DATE DATE,
244 p_QUANTITY NUMBER,
245 p_PARAMN1 NUMBER,
246 p_PARAMN2 NUMBER,
247 p_PARAMN3 NUMBER,
248 p_PARAMN4 NUMBER,
249 p_PARAMN5 NUMBER,
250 p_PARAMN6 NUMBER,
251 p_PARAMN7 NUMBER,
252 p_PARAMN8 NUMBER,
253 p_PARAMN9 NUMBER,
254 p_PARAMN10 NUMBER,
255 p_PARAMC1 VARCHAR2,
256 p_PARAMC2 VARCHAR2,
257 p_PARAMC3 VARCHAR2,
258 p_PARAMC4 VARCHAR2,
259 p_PARAMC5 VARCHAR2,
260 p_PARAMC6 VARCHAR2,
261 p_PARAMC7 VARCHAR2,
262 p_PARAMC8 VARCHAR2,
263 p_PARAMC9 VARCHAR2,
264 p_PARAMC10 VARCHAR2,
265 p_PARAMD1 DATE,
266 p_PARAMD2 DATE,
267 p_PARAMD3 DATE,
268 p_PARAMD4 DATE,
269 p_PARAMD5 DATE,
270 p_PARAMD6 DATE,
271 p_PARAMD7 DATE,
272 p_PARAMD8 DATE,
273 p_PARAMD9 DATE,
274 p_PARAMD10 DATE,
275 p_ATTRIBUTE_CATEGORY VARCHAR2,
276 p_ATTRIBUTE1 VARCHAR2,
277 p_ATTRIBUTE2 VARCHAR2,
278 p_ATTRIBUTE3 VARCHAR2,
279 p_ATTRIBUTE4 VARCHAR2,
280 p_ATTRIBUTE5 VARCHAR2,
281 p_ATTRIBUTE6 VARCHAR2,
282 p_ATTRIBUTE7 VARCHAR2,
283 p_ATTRIBUTE8 VARCHAR2,
284 p_ATTRIBUTE9 VARCHAR2,
285 p_ATTRIBUTE10 VARCHAR2,
286 p_ATTRIBUTE11 VARCHAR2,
287 p_ATTRIBUTE12 VARCHAR2,
288 p_ATTRIBUTE13 VARCHAR2,
289 p_ATTRIBUTE14 VARCHAR2,
290 p_ATTRIBUTE15 VARCHAR2,
294 BEGIN
291 p_LAST_UPDATE_LOGIN NUMBER)
292
293 IS
295 -- travi 020502 obj ver num
296 IF l_debug = 'Y' THEN
297 csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Update_Row before update');
298 END IF;
299
300 Update CSD_REPAIR_HISTORY
301 SET
302 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
303 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
304 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
305 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
306 PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
307 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
308 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
309 --bug#12697494, yvchen: changed LAST_UPDATED_BY to FND_GLOBAL.USER_ID
310 --LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
311 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_LAST_UPDATED_BY),
312 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
313 REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID),
314 EVENT_CODE = decode( p_EVENT_CODE, FND_API.G_MISS_CHAR, EVENT_CODE, p_EVENT_CODE),
315 EVENT_DATE = decode( p_EVENT_DATE, FND_API.G_MISS_DATE, EVENT_DATE, p_EVENT_DATE),
316 QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
317 PARAMN1 = decode( p_PARAMN1, FND_API.G_MISS_NUM, PARAMN1, p_PARAMN1),
318 PARAMN2 = decode( p_PARAMN2, FND_API.G_MISS_NUM, PARAMN2, p_PARAMN2),
319 PARAMN3 = decode( p_PARAMN3, FND_API.G_MISS_NUM, PARAMN3, p_PARAMN3),
320 PARAMN4 = decode( p_PARAMN4, FND_API.G_MISS_NUM, PARAMN4, p_PARAMN4),
321 PARAMN5 = decode( p_PARAMN5, FND_API.G_MISS_NUM, PARAMN5, p_PARAMN5),
322 PARAMN6 = decode( p_PARAMN6, FND_API.G_MISS_NUM, PARAMN6, p_PARAMN6),
323 PARAMN7 = decode( p_PARAMN7, FND_API.G_MISS_NUM, PARAMN7, p_PARAMN7),
324 PARAMN8 = decode( p_PARAMN8, FND_API.G_MISS_NUM, PARAMN8, p_PARAMN8),
325 PARAMN9 = decode( p_PARAMN9, FND_API.G_MISS_NUM, PARAMN9, p_PARAMN9),
326 PARAMN10 = decode( p_PARAMN10, FND_API.G_MISS_NUM, PARAMN10, p_PARAMN10),
327 PARAMC1 = decode( p_PARAMC1, FND_API.G_MISS_CHAR, PARAMC1, p_PARAMC1),
328 PARAMC2 = decode( p_PARAMC2, FND_API.G_MISS_CHAR, PARAMC2, p_PARAMC2),
329 PARAMC3 = decode( p_PARAMC3, FND_API.G_MISS_CHAR, PARAMC3, p_PARAMC3),
330 PARAMC4 = decode( p_PARAMC4, FND_API.G_MISS_CHAR, PARAMC4, p_PARAMC4),
331 PARAMC5 = decode( p_PARAMC5, FND_API.G_MISS_CHAR, PARAMC5, p_PARAMC5),
332 PARAMC6 = decode( p_PARAMC6, FND_API.G_MISS_CHAR, PARAMC6, p_PARAMC6),
333 PARAMC7 = decode( p_PARAMC7, FND_API.G_MISS_CHAR, PARAMC7, p_PARAMC7),
334 PARAMC8 = decode( p_PARAMC8, FND_API.G_MISS_CHAR, PARAMC8, p_PARAMC8),
335 PARAMC9 = decode( p_PARAMC9, FND_API.G_MISS_CHAR, PARAMC9, p_PARAMC9),
336 PARAMC10 = decode( p_PARAMC10, FND_API.G_MISS_CHAR, PARAMC10, p_PARAMC10),
337 PARAMD1 = decode( p_PARAMD1, FND_API.G_MISS_DATE, PARAMD1, p_PARAMD1),
338 PARAMD2 = decode( p_PARAMD2, FND_API.G_MISS_DATE, PARAMD2, p_PARAMD2),
339 PARAMD3 = decode( p_PARAMD3, FND_API.G_MISS_DATE, PARAMD3, p_PARAMD3),
340 PARAMD4 = decode( p_PARAMD4, FND_API.G_MISS_DATE, PARAMD4, p_PARAMD4),
341 PARAMD5 = decode( p_PARAMD5, FND_API.G_MISS_DATE, PARAMD5, p_PARAMD5),
342 PARAMD6 = decode( p_PARAMD6, FND_API.G_MISS_DATE, PARAMD6, p_PARAMD6),
343 PARAMD7 = decode( p_PARAMD7, FND_API.G_MISS_DATE, PARAMD7, p_PARAMD7),
344 PARAMD8 = decode( p_PARAMD8, FND_API.G_MISS_DATE, PARAMD8, p_PARAMD8),
345 PARAMD9 = decode( p_PARAMD9, FND_API.G_MISS_DATE, PARAMD9, p_PARAMD9),
346 PARAMD10 = decode( p_PARAMD10, FND_API.G_MISS_DATE, PARAMD10, p_PARAMD10),
347 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
348 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
349 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
350 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
351 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
352 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
353 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
354 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
355 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
356 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
357 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
358 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
359 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
360 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
361 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
362 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
363 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
367 csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Update_Row after update ');
364 where REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID;
365
366 IF l_debug = 'Y' THEN
368 END IF;
369
370 If (SQL%NOTFOUND) then
371 RAISE NO_DATA_FOUND;
372 End If;
373 END Update_Row;
374
375 PROCEDURE Delete_Row(
376 p_REPAIR_HISTORY_ID NUMBER,
377 p_OBJECT_VERSION_NUMBER NUMBER)
378 IS
379 BEGIN
380 DELETE FROM CSD_REPAIR_HISTORY
381 WHERE REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID;
382 If (SQL%NOTFOUND) then
383 RAISE NO_DATA_FOUND;
384 End If;
385 END Delete_Row;
386
387 -- travi 020502 obj ver num
388 PROCEDURE Lock_Row(
389 p_REPAIR_HISTORY_ID NUMBER,
390 p_OBJECT_VERSION_NUMBER NUMBER,
391 p_REQUEST_ID NUMBER,
392 p_PROGRAM_ID NUMBER,
393 p_PROGRAM_APPLICATION_ID NUMBER,
394 p_PROGRAM_UPDATE_DATE DATE,
395 p_CREATED_BY NUMBER,
396 p_CREATION_DATE DATE,
397 p_LAST_UPDATED_BY NUMBER,
398 p_LAST_UPDATE_DATE DATE,
399 p_REPAIR_LINE_ID NUMBER,
400 p_EVENT_CODE VARCHAR2,
401 p_EVENT_DATE DATE,
402 p_QUANTITY NUMBER,
403 p_PARAMN1 NUMBER,
404 p_PARAMN2 NUMBER,
405 p_PARAMN3 NUMBER,
406 p_PARAMN4 NUMBER,
407 p_PARAMN5 NUMBER,
408 p_PARAMN6 NUMBER,
409 p_PARAMN7 NUMBER,
410 p_PARAMN8 NUMBER,
411 p_PARAMN9 NUMBER,
412 p_PARAMN10 NUMBER,
413 p_PARAMC1 VARCHAR2,
414 p_PARAMC2 VARCHAR2,
415 p_PARAMC3 VARCHAR2,
416 p_PARAMC4 VARCHAR2,
417 p_PARAMC5 VARCHAR2,
418 p_PARAMC6 VARCHAR2,
419 p_PARAMC7 VARCHAR2,
420 p_PARAMC8 VARCHAR2,
421 p_PARAMC9 VARCHAR2,
422 p_PARAMC10 VARCHAR2,
423 p_PARAMD1 DATE,
424 p_PARAMD2 DATE,
425 p_PARAMD3 DATE,
426 p_PARAMD4 DATE,
427 p_PARAMD5 DATE,
428 p_PARAMD6 DATE,
429 p_PARAMD7 DATE,
430 p_PARAMD8 DATE,
431 p_PARAMD9 DATE,
432 p_PARAMD10 DATE,
433 p_ATTRIBUTE_CATEGORY VARCHAR2,
434 p_ATTRIBUTE1 VARCHAR2,
435 p_ATTRIBUTE2 VARCHAR2,
436 p_ATTRIBUTE3 VARCHAR2,
437 p_ATTRIBUTE4 VARCHAR2,
438 p_ATTRIBUTE5 VARCHAR2,
439 p_ATTRIBUTE6 VARCHAR2,
440 p_ATTRIBUTE7 VARCHAR2,
441 p_ATTRIBUTE8 VARCHAR2,
442 p_ATTRIBUTE9 VARCHAR2,
443 p_ATTRIBUTE10 VARCHAR2,
444 p_ATTRIBUTE11 VARCHAR2,
445 p_ATTRIBUTE12 VARCHAR2,
446 p_ATTRIBUTE13 VARCHAR2,
447 p_ATTRIBUTE14 VARCHAR2,
448 p_ATTRIBUTE15 VARCHAR2,
449 p_LAST_UPDATE_LOGIN NUMBER)
450
451 IS
452 CURSOR C IS
453 SELECT *
454 FROM CSD_REPAIR_HISTORY
455 WHERE REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID
456 FOR UPDATE of REPAIR_HISTORY_ID NOWAIT;
457 Recinfo C%ROWTYPE;
458 BEGIN
459 OPEN C;
460 FETCH C INTO Recinfo;
461 If (C%NOTFOUND) then
462 CLOSE C;
463 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
464 APP_EXCEPTION.RAISE_EXCEPTION;
465 End If;
466 CLOSE C;
467
468 -- travi 020502 obj ver num
469 if (
470 ( Recinfo.REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID)
471 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
472 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
473 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
474 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
475 OR ( ( Recinfo.REQUEST_ID IS NULL )
476 AND ( p_REQUEST_ID IS NULL )))
477 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
478 OR ( ( Recinfo.PROGRAM_ID IS NULL )
479 AND ( p_PROGRAM_ID IS NULL )))
480 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
481 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
482 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
483 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
484 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
485 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
486 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
487 OR ( ( Recinfo.CREATED_BY IS NULL )
488 AND ( p_CREATED_BY IS NULL )))
489 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
490 OR ( ( Recinfo.CREATION_DATE IS NULL )
491 AND ( p_CREATION_DATE IS NULL )))
492 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
493 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
494 AND ( p_LAST_UPDATED_BY IS NULL )))
495 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
496 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
497 AND ( p_LAST_UPDATE_DATE IS NULL )))
498 AND ( ( Recinfo.REPAIR_LINE_ID = p_REPAIR_LINE_ID)
499 OR ( ( Recinfo.REPAIR_LINE_ID IS NULL )
500 AND ( p_REPAIR_LINE_ID IS NULL )))
501 AND ( ( Recinfo.EVENT_CODE = p_EVENT_CODE)
502 OR ( ( Recinfo.EVENT_CODE IS NULL )
503 AND ( p_EVENT_CODE IS NULL )))
504 AND ( ( Recinfo.EVENT_DATE = p_EVENT_DATE)
505 OR ( ( Recinfo.EVENT_DATE IS NULL )
509 AND ( p_QUANTITY IS NULL )))
506 AND ( p_EVENT_DATE IS NULL )))
507 AND ( ( Recinfo.QUANTITY = p_QUANTITY)
508 OR ( ( Recinfo.QUANTITY IS NULL )
510 AND ( ( Recinfo.PARAMN1 = p_PARAMN1)
511 OR ( ( Recinfo.PARAMN1 IS NULL )
512 AND ( p_PARAMN1 IS NULL )))
513 AND ( ( Recinfo.PARAMN2 = p_PARAMN2)
514 OR ( ( Recinfo.PARAMN2 IS NULL )
515 AND ( p_PARAMN2 IS NULL )))
516 AND ( ( Recinfo.PARAMN3 = p_PARAMN3)
517 OR ( ( Recinfo.PARAMN3 IS NULL )
518 AND ( p_PARAMN3 IS NULL )))
519 AND ( ( Recinfo.PARAMN4 = p_PARAMN4)
520 OR ( ( Recinfo.PARAMN4 IS NULL )
521 AND ( p_PARAMN4 IS NULL )))
522 AND ( ( Recinfo.PARAMN5 = p_PARAMN5)
523 OR ( ( Recinfo.PARAMN5 IS NULL )
524 AND ( p_PARAMN5 IS NULL )))
525 AND ( ( Recinfo.PARAMN6 = p_PARAMN6)
526 OR ( ( Recinfo.PARAMN6 IS NULL )
527 AND ( p_PARAMN6 IS NULL )))
528 AND ( ( Recinfo.PARAMN7 = p_PARAMN7)
529 OR ( ( Recinfo.PARAMN7 IS NULL )
530 AND ( p_PARAMN7 IS NULL )))
531 AND ( ( Recinfo.PARAMN8 = p_PARAMN8)
532 OR ( ( Recinfo.PARAMN8 IS NULL )
533 AND ( p_PARAMN8 IS NULL )))
534 AND ( ( Recinfo.PARAMN9 = p_PARAMN9)
535 OR ( ( Recinfo.PARAMN9 IS NULL )
536 AND ( p_PARAMN9 IS NULL )))
537 AND ( ( Recinfo.PARAMN10 = p_PARAMN10)
538 OR ( ( Recinfo.PARAMN10 IS NULL )
539 AND ( p_PARAMN10 IS NULL )))
540 AND ( ( Recinfo.PARAMC1 = p_PARAMC1)
541 OR ( ( Recinfo.PARAMC1 IS NULL )
542 AND ( p_PARAMC1 IS NULL )))
543 AND ( ( Recinfo.PARAMC2 = p_PARAMC2)
544 OR ( ( Recinfo.PARAMC2 IS NULL )
545 AND ( p_PARAMC2 IS NULL )))
546 AND ( ( Recinfo.PARAMC3 = p_PARAMC3)
547 OR ( ( Recinfo.PARAMC3 IS NULL )
548 AND ( p_PARAMC3 IS NULL )))
549 AND ( ( Recinfo.PARAMC4 = p_PARAMC4)
550 OR ( ( Recinfo.PARAMC4 IS NULL )
551 AND ( p_PARAMC4 IS NULL )))
552 AND ( ( Recinfo.PARAMC5 = p_PARAMC5)
553 OR ( ( Recinfo.PARAMC5 IS NULL )
554 AND ( p_PARAMC5 IS NULL )))
555 AND ( ( Recinfo.PARAMC6 = p_PARAMC6)
556 OR ( ( Recinfo.PARAMC6 IS NULL )
557 AND ( p_PARAMC6 IS NULL )))
558 AND ( ( Recinfo.PARAMC7 = p_PARAMC7)
559 OR ( ( Recinfo.PARAMC7 IS NULL )
560 AND ( p_PARAMC7 IS NULL )))
561 AND ( ( Recinfo.PARAMC8 = p_PARAMC8)
562 OR ( ( Recinfo.PARAMC8 IS NULL )
563 AND ( p_PARAMC8 IS NULL )))
564 AND ( ( Recinfo.PARAMC9 = p_PARAMC9)
565 OR ( ( Recinfo.PARAMC9 IS NULL )
566 AND ( p_PARAMC9 IS NULL )))
567 AND ( ( Recinfo.PARAMC10 = p_PARAMC10)
568 OR ( ( Recinfo.PARAMC10 IS NULL )
569 AND ( p_PARAMC10 IS NULL )))
570 AND ( ( Recinfo.PARAMD1 = p_PARAMD1)
571 OR ( ( Recinfo.PARAMD1 IS NULL )
572 AND ( p_PARAMD1 IS NULL )))
573 AND ( ( Recinfo.PARAMD2 = p_PARAMD2)
574 OR ( ( Recinfo.PARAMD2 IS NULL )
575 AND ( p_PARAMD2 IS NULL )))
576 AND ( ( Recinfo.PARAMD3 = p_PARAMD3)
577 OR ( ( Recinfo.PARAMD3 IS NULL )
578 AND ( p_PARAMD3 IS NULL )))
579 AND ( ( Recinfo.PARAMD4 = p_PARAMD4)
580 OR ( ( Recinfo.PARAMD4 IS NULL )
581 AND ( p_PARAMD4 IS NULL )))
582 AND ( ( Recinfo.PARAMD5 = p_PARAMD5)
583 OR ( ( Recinfo.PARAMD5 IS NULL )
584 AND ( p_PARAMD5 IS NULL )))
585 AND ( ( Recinfo.PARAMD6 = p_PARAMD6)
586 OR ( ( Recinfo.PARAMD6 IS NULL )
587 AND ( p_PARAMD6 IS NULL )))
588 AND ( ( Recinfo.PARAMD7 = p_PARAMD7)
589 OR ( ( Recinfo.PARAMD7 IS NULL )
590 AND ( p_PARAMD7 IS NULL )))
591 AND ( ( Recinfo.PARAMD8 = p_PARAMD8)
592 OR ( ( Recinfo.PARAMD8 IS NULL )
593 AND ( p_PARAMD8 IS NULL )))
594 AND ( ( Recinfo.PARAMD9 = p_PARAMD9)
595 OR ( ( Recinfo.PARAMD9 IS NULL )
596 AND ( p_PARAMD9 IS NULL )))
597 AND ( ( Recinfo.PARAMD10 = p_PARAMD10)
598 OR ( ( Recinfo.PARAMD10 IS NULL )
599 AND ( p_PARAMD10 IS NULL )))
600 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
601 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
602 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
603 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
604 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
605 AND ( p_ATTRIBUTE1 IS NULL )))
606 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
607 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
608 AND ( p_ATTRIBUTE2 IS NULL )))
609 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
610 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
611 AND ( p_ATTRIBUTE3 IS NULL )))
612 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
613 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
614 AND ( p_ATTRIBUTE4 IS NULL )))
615 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
616 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
617 AND ( p_ATTRIBUTE5 IS NULL )))
618 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
619 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
620 AND ( p_ATTRIBUTE6 IS NULL )))
621 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
625 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
622 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
623 AND ( p_ATTRIBUTE7 IS NULL )))
624 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
626 AND ( p_ATTRIBUTE8 IS NULL )))
627 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
628 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
629 AND ( p_ATTRIBUTE9 IS NULL )))
630 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
631 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
632 AND ( p_ATTRIBUTE10 IS NULL )))
633 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
634 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
635 AND ( p_ATTRIBUTE11 IS NULL )))
636 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
637 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
638 AND ( p_ATTRIBUTE12 IS NULL )))
639 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
640 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
641 AND ( p_ATTRIBUTE13 IS NULL )))
642 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
643 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
644 AND ( p_ATTRIBUTE14 IS NULL )))
645 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
646 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
647 AND ( p_ATTRIBUTE15 IS NULL )))
648 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
649 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
650 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
651 ) then
652 return;
653 else
654 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
655 APP_EXCEPTION.RAISE_EXCEPTION;
656 End If;
657 END Lock_Row;
658
659 End CSD_REPAIR_HISTORY_PKG;