[Home] [Help]
PACKAGE BODY: APPS.CN_IMP_HEADERS_PKG
Source
1 PACKAGE BODY CN_IMP_HEADERS_PKG AS
2 /* $Header: cntimhrb.pls 115.4 2002/02/12 18:58:45 pkm ship $*/
3
4
5 -- * -------------------------------------------------------------------------*
6 -- Procedure Name
7 -- Insert_row
8 -- Purpose
9 -- Main insert procedure
10 -- Note
11 -- 1. Primary key should be populated from sequence before call
12 -- this procedure. No refernece to sequence in this procedure.
13 -- 2. All paramaters are IN parameter.
14 -- * -------------------------------------------------------------------------*
15 PROCEDURE insert_row
16 ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE) IS
17
18 BEGIN
19
20 INSERT into CN_IMP_HEADERS
21 ( IMP_HEADER_ID,
22 NAME,
23 DESCRIPTION,
24 IMPORT_TYPE_CODE,
25 OPERATION,
26 SERVER_FLAG,
27 USER_FILENAME,
28 DATA_FILENAME,
29 TERMINATED_BY,
30 ENCLOSED_BY,
31 HEADINGS_FLAG,
32 STAGED_ROW,
33 PROCESSED_ROW,
34 FAILED_ROW,
35 STATUS_CODE,
36 IMP_MAP_ID,
37 SOURCE_COLUMN_NUM,
38 OBJECT_VERSION_NUMBER,
39 ATTRIBUTE_CATEGORY,
40 ATTRIBUTE1,
41 ATTRIBUTE2,
42 ATTRIBUTE3,
43 ATTRIBUTE4,
44 ATTRIBUTE5,
45 ATTRIBUTE6,
46 ATTRIBUTE7,
47 ATTRIBUTE8,
48 ATTRIBUTE9,
49 ATTRIBUTE10,
50 ATTRIBUTE11,
51 ATTRIBUTE12,
52 ATTRIBUTE13,
53 ATTRIBUTE14,
54 ATTRIBUTE15,
55 CREATION_DATE,
56 CREATED_BY,
57 LAST_UPDATE_DATE,
58 LAST_UPDATED_BY,
59 LAST_UPDATE_LOGIN)
60 select
61 DECODE(p_imp_headers_rec.IMP_HEADER_ID, FND_API.G_MISS_NUM, NULL,
62 p_imp_headers_rec.IMP_HEADER_ID),
63 DECODE(p_imp_headers_rec.NAME, FND_API.G_MISS_CHAR, NULL,
64 p_imp_headers_rec.NAME),
65 DECODE(p_imp_headers_rec.DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
66 p_imp_headers_rec.DESCRIPTION),
67 DECODE(p_imp_headers_rec.IMPORT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,
68 p_imp_headers_rec.IMPORT_TYPE_CODE),
69 DECODE(p_imp_headers_rec.OPERATION, FND_API.G_MISS_CHAR, NULL,
70 p_imp_headers_rec.OPERATION),
71 DECODE(p_imp_headers_rec.SERVER_FLAG, FND_API.G_MISS_CHAR, NULL,
72 p_imp_headers_rec.SERVER_FLAG),
73 DECODE(p_imp_headers_rec.USER_FILENAME, FND_API.G_MISS_CHAR, NULL,
74 p_imp_headers_rec.USER_FILENAME),
75 DECODE(p_imp_headers_rec.DATA_FILENAME, FND_API.G_MISS_CHAR, NULL,
76 p_imp_headers_rec.DATA_FILENAME),
77 DECODE(p_imp_headers_rec.TERMINATED_BY, FND_API.G_MISS_CHAR, NULL,
78 p_imp_headers_rec.TERMINATED_BY),
79 DECODE(p_imp_headers_rec.ENCLOSED_BY, FND_API.G_MISS_CHAR, NULL,
80 p_imp_headers_rec.ENCLOSED_BY),
81 DECODE(p_imp_headers_rec.HEADINGS_FLAG, FND_API.G_MISS_CHAR, NULL,
82 p_imp_headers_rec.HEADINGS_FLAG),
83 DECODE(p_imp_headers_rec.STAGED_ROW, FND_API.G_MISS_NUM, NULL,
84 p_imp_headers_rec.STAGED_ROW),
85 DECODE(p_imp_headers_rec.PROCESSED_ROW, FND_API.G_MISS_NUM, NULL,
86 p_imp_headers_rec.PROCESSED_ROW),
87 DECODE(p_imp_headers_rec.FAILED_ROW, FND_API.G_MISS_NUM, NULL,
88 p_imp_headers_rec.FAILED_ROW),
89 DECODE(p_imp_headers_rec.STATUS_CODE, FND_API.G_MISS_CHAR, NULL,
90 p_imp_headers_rec.STATUS_CODE),
91 DECODE(p_imp_headers_rec.IMP_MAP_ID, FND_API.G_MISS_NUM, NULL,
92 p_imp_headers_rec.IMP_MAP_ID),
93 DECODE(p_imp_headers_rec.SOURCE_COLUMN_NUM, FND_API.G_MISS_NUM, NULL,
94 p_imp_headers_rec.SOURCE_COLUMN_NUM),
95 1,
96 DECODE(p_imp_headers_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
97 p_imp_headers_rec.ATTRIBUTE_CATEGORY),
98 DECODE(p_imp_headers_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
99 p_imp_headers_rec.ATTRIBUTE1),
100 DECODE(p_imp_headers_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
101 p_imp_headers_rec.ATTRIBUTE2),
102 DECODE(p_imp_headers_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
103 p_imp_headers_rec.ATTRIBUTE3),
104 DECODE(p_imp_headers_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
105 p_imp_headers_rec.ATTRIBUTE4),
106 DECODE(p_imp_headers_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
107 p_imp_headers_rec.ATTRIBUTE5),
108 DECODE(p_imp_headers_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
109 p_imp_headers_rec.ATTRIBUTE6),
110 DECODE(p_imp_headers_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
111 p_imp_headers_rec.ATTRIBUTE7),
112 DECODE(p_imp_headers_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
113 p_imp_headers_rec.ATTRIBUTE8),
114 DECODE(p_imp_headers_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
115 p_imp_headers_rec.ATTRIBUTE9),
116 DECODE(p_imp_headers_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
117 p_imp_headers_rec.ATTRIBUTE10),
118 DECODE(p_imp_headers_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
119 p_imp_headers_rec.ATTRIBUTE11),
120 DECODE(p_imp_headers_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
121 p_imp_headers_rec.ATTRIBUTE12),
122 DECODE(p_imp_headers_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
123 p_imp_headers_rec.ATTRIBUTE13),
124 DECODE(p_imp_headers_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
125 p_imp_headers_rec.ATTRIBUTE14),
126 DECODE(p_imp_headers_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
127 p_imp_headers_rec.ATTRIBUTE15),
128 Sysdate,
129 fnd_global.user_id,
130 Sysdate,
131 fnd_global.user_id,
132 fnd_global.login_id
133 from dual;
134
135 END insert_row;
136
137
138 -- * -------------------------------------------------------------------------*
139 -- Procedure Name
140 -- update_row
141 -- Purpose
142 -- Main update procedure
143 -- Note
144 -- 1. No object version checking, overwrite may happen
145 -- 2. Calling lock_update for object version checking
146 -- 3. All paramaters are IN parameter.
147 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
148 -- * -------------------------------------------------------------------------*
149 PROCEDURE update_row
150 ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE) IS
151
152 BEGIN
153
154 UPDATE CN_IMP_HEADERS oldrec
155 SET
156 NAME = DECODE(p_imp_headers_rec.NAME,
157 FND_API.G_MISS_CHAR,
158 oldrec.NAME,
159 p_imp_headers_rec.NAME),
160 DESCRIPTION = DECODE(p_imp_headers_rec.DESCRIPTION,
161 FND_API.G_MISS_CHAR,
162 oldrec.DESCRIPTION,
163 p_imp_headers_rec.DESCRIPTION),
164 IMPORT_TYPE_CODE = DECODE(p_imp_headers_rec.IMPORT_TYPE_CODE,
165 FND_API.G_MISS_CHAR,
166 oldrec.IMPORT_TYPE_CODE,
167 p_imp_headers_rec.IMPORT_TYPE_CODE),
168 OPERATION = DECODE(p_imp_headers_rec.OPERATION,
169 FND_API.G_MISS_CHAR,
170 oldrec.OPERATION,
171 p_imp_headers_rec.OPERATION),
172 SERVER_FLAG = DECODE(p_imp_headers_rec.SERVER_FLAG,
173 FND_API.G_MISS_CHAR,
174 oldrec.SERVER_FLAG,
175 p_imp_headers_rec.SERVER_FLAG),
176 USER_FILENAME = DECODE(p_imp_headers_rec.USER_FILENAME,
177 FND_API.G_MISS_CHAR,
178 oldrec.USER_FILENAME,
179 p_imp_headers_rec.USER_FILENAME),
180 DATA_FILENAME = DECODE(p_imp_headers_rec.DATA_FILENAME,
181 FND_API.G_MISS_CHAR,
182 oldrec.DATA_FILENAME,
183 p_imp_headers_rec.DATA_FILENAME),
184 TERMINATED_BY = DECODE(p_imp_headers_rec.TERMINATED_BY,
185 FND_API.G_MISS_CHAR,
186 oldrec.TERMINATED_BY,
187 p_imp_headers_rec.TERMINATED_BY),
188 ENCLOSED_BY = DECODE(p_imp_headers_rec.ENCLOSED_BY,
189 FND_API.G_MISS_CHAR,
190 oldrec.ENCLOSED_BY,
191 p_imp_headers_rec.ENCLOSED_BY),
192 HEADINGS_FLAG = DECODE(p_imp_headers_rec.HEADINGS_FLAG,
193 FND_API.G_MISS_CHAR,
194 oldrec.HEADINGS_FLAG,
195 p_imp_headers_rec.HEADINGS_FLAG),
196 STAGED_ROW = DECODE(p_imp_headers_rec.STAGED_ROW,
197 FND_API.G_MISS_NUM,
198 oldrec.STAGED_ROW,
199 p_imp_headers_rec.STAGED_ROW),
200 PROCESSED_ROW = DECODE(p_imp_headers_rec.PROCESSED_ROW,
201 FND_API.G_MISS_NUM,
202 oldrec.PROCESSED_ROW,
203 p_imp_headers_rec.PROCESSED_ROW),
204 FAILED_ROW = DECODE(p_imp_headers_rec.FAILED_ROW,
205 FND_API.G_MISS_NUM,
206 oldrec.FAILED_ROW,
207 p_imp_headers_rec.FAILED_ROW),
208 STATUS_CODE = DECODE(p_imp_headers_rec.STATUS_CODE,
209 FND_API.G_MISS_CHAR,
210 oldrec.STATUS_CODE,
211 p_imp_headers_rec.STATUS_CODE),
212 IMP_MAP_ID = DECODE(p_imp_headers_rec.IMP_MAP_ID,
213 FND_API.G_MISS_NUM,
214 oldrec.IMP_MAP_ID,
215 p_imp_headers_rec.IMP_MAP_ID),
216 SOURCE_COLUMN_NUM = DECODE(p_imp_headers_rec.SOURCE_COLUMN_NUM,
217 FND_API.G_MISS_NUM,
218 oldrec.SOURCE_COLUMN_NUM,
219 p_imp_headers_rec.SOURCE_COLUMN_NUM),
220 OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
221 ATTRIBUTE_CATEGORY = DECODE(p_imp_headers_rec.ATTRIBUTE_CATEGORY,
222 FND_API.G_MISS_CHAR,
223 oldrec.ATTRIBUTE_CATEGORY,
224 p_imp_headers_rec.ATTRIBUTE_CATEGORY),
225 ATTRIBUTE1 = DECODE(p_imp_headers_rec.ATTRIBUTE1,
226 FND_API.G_MISS_CHAR,
227 oldrec.ATTRIBUTE1,
228 p_imp_headers_rec.ATTRIBUTE1),
229 ATTRIBUTE2 = DECODE(p_imp_headers_rec.ATTRIBUTE2,
230 FND_API.G_MISS_CHAR,
231 oldrec.ATTRIBUTE2,
232 p_imp_headers_rec.ATTRIBUTE2),
233 ATTRIBUTE3 = DECODE(p_imp_headers_rec.ATTRIBUTE3,
234 FND_API.G_MISS_CHAR,
235 oldrec.ATTRIBUTE3,
236 p_imp_headers_rec.ATTRIBUTE3),
237 ATTRIBUTE4 = DECODE(p_imp_headers_rec.ATTRIBUTE4,
238 FND_API.G_MISS_CHAR,
239 oldrec.ATTRIBUTE4,
240 p_imp_headers_rec.ATTRIBUTE4),
241 ATTRIBUTE5 = DECODE(p_imp_headers_rec.ATTRIBUTE5,
245 ATTRIBUTE6 = DECODE(p_imp_headers_rec.ATTRIBUTE6,
242 FND_API.G_MISS_CHAR,
243 oldrec.ATTRIBUTE5,
244 p_imp_headers_rec.ATTRIBUTE5),
246 FND_API.G_MISS_CHAR,
247 oldrec.ATTRIBUTE6,
248 p_imp_headers_rec.ATTRIBUTE6),
249 ATTRIBUTE7 = DECODE(p_imp_headers_rec.ATTRIBUTE7,
250 FND_API.G_MISS_CHAR,
251 oldrec.ATTRIBUTE7,
252 p_imp_headers_rec.ATTRIBUTE7),
253 ATTRIBUTE8 = DECODE(p_imp_headers_rec.ATTRIBUTE8,
254 FND_API.G_MISS_CHAR,
255 oldrec.ATTRIBUTE8,
256 p_imp_headers_rec.ATTRIBUTE8),
257 ATTRIBUTE9 = DECODE(p_imp_headers_rec.ATTRIBUTE9,
258 FND_API.G_MISS_CHAR,
259 oldrec.ATTRIBUTE9,
260 p_imp_headers_rec.ATTRIBUTE9),
261 ATTRIBUTE10 = DECODE(p_imp_headers_rec.ATTRIBUTE10,
262 FND_API.G_MISS_CHAR,
263 oldrec.ATTRIBUTE10,
264 p_imp_headers_rec.ATTRIBUTE10),
265 ATTRIBUTE11 = DECODE(p_imp_headers_rec.ATTRIBUTE11,
266 FND_API.G_MISS_CHAR,
267 oldrec.ATTRIBUTE11,
268 p_imp_headers_rec.ATTRIBUTE11),
269 ATTRIBUTE12 = DECODE(p_imp_headers_rec.ATTRIBUTE12,
270 FND_API.G_MISS_CHAR,
271 oldrec.ATTRIBUTE12,
272 p_imp_headers_rec.ATTRIBUTE12),
273 ATTRIBUTE13 = DECODE(p_imp_headers_rec.ATTRIBUTE13,
274 FND_API.G_MISS_CHAR,
275 oldrec.ATTRIBUTE13,
276 p_imp_headers_rec.ATTRIBUTE13),
277 ATTRIBUTE14 = DECODE(p_imp_headers_rec.ATTRIBUTE14,
278 FND_API.G_MISS_CHAR,
279 oldrec.ATTRIBUTE14,
280 p_imp_headers_rec.ATTRIBUTE14),
281 ATTRIBUTE15 = DECODE(p_imp_headers_rec.ATTRIBUTE15,
282 FND_API.G_MISS_CHAR,
283 oldrec.ATTRIBUTE15,
284 p_imp_headers_rec.ATTRIBUTE15),
285 LAST_UPDATE_DATE = Sysdate,
286 LAST_UPDATED_BY = fnd_global.user_id,
287 LAST_UPDATE_LOGIN = fnd_global.login_id
288 WHERE imp_header_id = p_imp_headers_rec.imp_header_id;
289
290 IF (SQL%ROWCOUNT=0) THEN
291 RAISE NO_DATA_FOUND;
292 END IF;
293
294 END update_row;
295
296
297 -- * -------------------------------------------------------------------------*
298 -- Procedure Name
299 -- lock_update_row
300 -- Purpose
301 -- Main lcok and update procedure
302 -- Note
303 -- 1. Object version checking is performed before checking
304 -- 2. Calling update_row if you don not want object version checking
305 -- 3. All paramaters are IN parameter.
306 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
307 -- * -------------------------------------------------------------------------*
308 PROCEDURE lock_update_row
309 ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE) IS
310
311 CURSOR c IS
312 SELECT object_version_number
313 FROM CN_IMP_HEADERS
314 WHERE imp_header_id = p_imp_headers_rec.imp_header_id;
315
316 tlinfo c%ROWTYPE ;
317 BEGIN
318
319 open c;
320 fetch c into tlinfo;
321 if (c%notfound) then
322 close c;
323 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
324 fnd_msg_pub.add;
325 raise fnd_api.g_exc_unexpected_error;
326 end if;
327 close c;
328
329 if (tlinfo.object_version_number <> p_imp_headers_rec.object_version_number) then
330 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
331 fnd_msg_pub.add;
332 raise fnd_api.g_exc_unexpected_error;
333 end if;
334 UPDATE CN_IMP_HEADERS oldrec
335 SET
336 NAME = DECODE(p_imp_headers_rec.NAME,
337 FND_API.G_MISS_CHAR,
338 oldrec.NAME,
339 p_imp_headers_rec.NAME),
340 DESCRIPTION = DECODE(p_imp_headers_rec.DESCRIPTION,
341 FND_API.G_MISS_CHAR,
342 oldrec.DESCRIPTION,
343 p_imp_headers_rec.DESCRIPTION),
344 IMPORT_TYPE_CODE = DECODE(p_imp_headers_rec.IMPORT_TYPE_CODE,
345 FND_API.G_MISS_CHAR,
346 oldrec.IMPORT_TYPE_CODE,
347 p_imp_headers_rec.IMPORT_TYPE_CODE),
348 OPERATION = DECODE(p_imp_headers_rec.OPERATION,
349 FND_API.G_MISS_CHAR,
350 oldrec.OPERATION,
351 p_imp_headers_rec.OPERATION),
352 SERVER_FLAG = DECODE(p_imp_headers_rec.SERVER_FLAG,
353 FND_API.G_MISS_CHAR,
354 oldrec.SERVER_FLAG,
355 p_imp_headers_rec.SERVER_FLAG),
356 USER_FILENAME = DECODE(p_imp_headers_rec.USER_FILENAME,
357 FND_API.G_MISS_CHAR,
361 FND_API.G_MISS_CHAR,
358 oldrec.USER_FILENAME,
359 p_imp_headers_rec.USER_FILENAME),
360 DATA_FILENAME = DECODE(p_imp_headers_rec.DATA_FILENAME,
362 oldrec.DATA_FILENAME,
363 p_imp_headers_rec.DATA_FILENAME),
364 TERMINATED_BY = DECODE(p_imp_headers_rec.TERMINATED_BY,
365 FND_API.G_MISS_CHAR,
366 oldrec.TERMINATED_BY,
367 p_imp_headers_rec.TERMINATED_BY),
368 ENCLOSED_BY = DECODE(p_imp_headers_rec.ENCLOSED_BY,
369 FND_API.G_MISS_CHAR,
370 oldrec.ENCLOSED_BY,
371 p_imp_headers_rec.ENCLOSED_BY),
372 HEADINGS_FLAG = DECODE(p_imp_headers_rec.HEADINGS_FLAG,
373 FND_API.G_MISS_CHAR,
374 oldrec.HEADINGS_FLAG,
375 p_imp_headers_rec.HEADINGS_FLAG),
376 STAGED_ROW = DECODE(p_imp_headers_rec.STAGED_ROW,
377 FND_API.G_MISS_NUM,
378 oldrec.STAGED_ROW,
379 p_imp_headers_rec.STAGED_ROW),
380 PROCESSED_ROW = DECODE(p_imp_headers_rec.PROCESSED_ROW,
381 FND_API.G_MISS_NUM,
382 oldrec.PROCESSED_ROW,
383 p_imp_headers_rec.PROCESSED_ROW),
384 FAILED_ROW = DECODE(p_imp_headers_rec.FAILED_ROW,
385 FND_API.G_MISS_NUM,
386 oldrec.FAILED_ROW,
387 p_imp_headers_rec.FAILED_ROW),
388 STATUS_CODE = DECODE(p_imp_headers_rec.STATUS_CODE,
389 FND_API.G_MISS_CHAR,
390 oldrec.STATUS_CODE,
391 p_imp_headers_rec.STATUS_CODE),
392 IMP_MAP_ID = DECODE(p_imp_headers_rec.IMP_MAP_ID,
393 FND_API.G_MISS_NUM,
394 oldrec.IMP_MAP_ID,
395 p_imp_headers_rec.IMP_MAP_ID),
396 SOURCE_COLUMN_NUM = DECODE(p_imp_headers_rec.SOURCE_COLUMN_NUM,
397 FND_API.G_MISS_NUM,
398 oldrec.SOURCE_COLUMN_NUM,
399 p_imp_headers_rec.SOURCE_COLUMN_NUM),
400 OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
401 ATTRIBUTE_CATEGORY = DECODE(p_imp_headers_rec.ATTRIBUTE_CATEGORY,
402 FND_API.G_MISS_CHAR,
403 oldrec.ATTRIBUTE_CATEGORY,
404 p_imp_headers_rec.ATTRIBUTE_CATEGORY),
405 ATTRIBUTE1 = DECODE(p_imp_headers_rec.ATTRIBUTE1,
406 FND_API.G_MISS_CHAR,
407 oldrec.ATTRIBUTE1,
408 p_imp_headers_rec.ATTRIBUTE1),
409 ATTRIBUTE2 = DECODE(p_imp_headers_rec.ATTRIBUTE2,
410 FND_API.G_MISS_CHAR,
411 oldrec.ATTRIBUTE2,
412 p_imp_headers_rec.ATTRIBUTE2),
413 ATTRIBUTE3 = DECODE(p_imp_headers_rec.ATTRIBUTE3,
414 FND_API.G_MISS_CHAR,
415 oldrec.ATTRIBUTE3,
416 p_imp_headers_rec.ATTRIBUTE3),
417 ATTRIBUTE4 = DECODE(p_imp_headers_rec.ATTRIBUTE4,
418 FND_API.G_MISS_CHAR,
419 oldrec.ATTRIBUTE4,
420 p_imp_headers_rec.ATTRIBUTE4),
421 ATTRIBUTE5 = DECODE(p_imp_headers_rec.ATTRIBUTE5,
422 FND_API.G_MISS_CHAR,
423 oldrec.ATTRIBUTE5,
424 p_imp_headers_rec.ATTRIBUTE5),
425 ATTRIBUTE6 = DECODE(p_imp_headers_rec.ATTRIBUTE6,
426 FND_API.G_MISS_CHAR,
427 oldrec.ATTRIBUTE6,
428 p_imp_headers_rec.ATTRIBUTE6),
429 ATTRIBUTE7 = DECODE(p_imp_headers_rec.ATTRIBUTE7,
430 FND_API.G_MISS_CHAR,
431 oldrec.ATTRIBUTE7,
432 p_imp_headers_rec.ATTRIBUTE7),
433 ATTRIBUTE8 = DECODE(p_imp_headers_rec.ATTRIBUTE8,
434 FND_API.G_MISS_CHAR,
435 oldrec.ATTRIBUTE8,
436 p_imp_headers_rec.ATTRIBUTE8),
437 ATTRIBUTE9 = DECODE(p_imp_headers_rec.ATTRIBUTE9,
438 FND_API.G_MISS_CHAR,
439 oldrec.ATTRIBUTE9,
440 p_imp_headers_rec.ATTRIBUTE9),
441 ATTRIBUTE10 = DECODE(p_imp_headers_rec.ATTRIBUTE10,
442 FND_API.G_MISS_CHAR,
443 oldrec.ATTRIBUTE10,
444 p_imp_headers_rec.ATTRIBUTE10),
445 ATTRIBUTE11 = DECODE(p_imp_headers_rec.ATTRIBUTE11,
446 FND_API.G_MISS_CHAR,
447 oldrec.ATTRIBUTE11,
448 p_imp_headers_rec.ATTRIBUTE11),
449 ATTRIBUTE12 = DECODE(p_imp_headers_rec.ATTRIBUTE12,
450 FND_API.G_MISS_CHAR,
451 oldrec.ATTRIBUTE12,
455 oldrec.ATTRIBUTE13,
452 p_imp_headers_rec.ATTRIBUTE12),
453 ATTRIBUTE13 = DECODE(p_imp_headers_rec.ATTRIBUTE13,
454 FND_API.G_MISS_CHAR,
456 p_imp_headers_rec.ATTRIBUTE13),
457 ATTRIBUTE14 = DECODE(p_imp_headers_rec.ATTRIBUTE14,
458 FND_API.G_MISS_CHAR,
459 oldrec.ATTRIBUTE14,
460 p_imp_headers_rec.ATTRIBUTE14),
461 ATTRIBUTE15 = DECODE(p_imp_headers_rec.ATTRIBUTE15,
462 FND_API.G_MISS_CHAR,
463 oldrec.ATTRIBUTE15,
464 p_imp_headers_rec.ATTRIBUTE15),
465 LAST_UPDATE_DATE = Sysdate,
466 LAST_UPDATED_BY = fnd_global.user_id,
467 LAST_UPDATE_LOGIN = fnd_global.login_id
468 WHERE imp_header_id = p_imp_headers_rec.imp_header_id;
469
470 IF (SQL%ROWCOUNT=0) THEN
471 RAISE NO_DATA_FOUND;
472 END IF;
473
474 END lock_update_row;
475
476
477 -- * -------------------------------------------------------------------------*
478 -- Procedure Name
479 -- delete_row
480 -- Purpose
481 -- Main lcok and update procedure
482 -- Note
483 -- 1. All paramaters are IN parameter.
484 -- 2. Raise NO_DATA_FOUND exception if no reocrd deleted (??)
485 -- * -------------------------------------------------------------------------*
486 PROCEDURE delete_row
487 (
488 p_imp_header_id NUMBER
489 ) IS
490
491 BEGIN
492
493 DELETE FROM CN_IMP_HEADERS
494 WHERE imp_header_id = p_imp_header_id;
495
496 IF (SQL%ROWCOUNT=0) THEN
497 RAISE NO_DATA_FOUND;
498 END IF;
499
500 END Delete_row;
501
502
503 END CN_IMP_HEADERS_PKG;