[Home] [Help]
PACKAGE BODY: APPS.HZ_ORIG_SYS_ENTITY_MAP_PKG
Source
1 PACKAGE BODY HZ_ORIG_SYS_ENTITY_MAP_PKG AS
2 /*$Header: ARHOSSTB.pls 120.1 2003/06/26 09:07:54 rpalanis noship $ */
3
4 PROCEDURE Insert_Row (
5 x_orig_system IN VARCHAR2,
6 x_owner_table_name IN VARCHAR2,
7 x_status IN VARCHAR2,
8 x_multiple_flag IN VARCHAR2,
9 --raji
10 x_multi_osr_flag IN VARCHAR2,
11 x_object_version_number IN NUMBER,
12 x_created_by_module IN VARCHAR2,
13 x_application_id IN NUMBER,
14 x_attribute_category IN VARCHAR2,
15 x_attribute1 IN VARCHAR2,
16 x_attribute2 IN VARCHAR2,
17 x_attribute3 IN VARCHAR2,
18 x_attribute4 IN VARCHAR2,
19 x_attribute5 IN VARCHAR2,
20 x_attribute6 IN VARCHAR2,
21 x_attribute7 IN VARCHAR2,
22 x_attribute8 IN VARCHAR2,
23 x_attribute9 IN VARCHAR2,
24 x_attribute10 IN VARCHAR2,
25 x_attribute11 IN VARCHAR2,
26 x_attribute12 IN VARCHAR2,
27 x_attribute13 IN VARCHAR2,
28 x_attribute14 IN VARCHAR2,
29 x_attribute15 IN VARCHAR2,
30 x_attribute16 IN VARCHAR2,
31 x_attribute17 IN VARCHAR2,
32 x_attribute18 IN VARCHAR2,
33 x_attribute19 IN VARCHAR2,
34 x_attribute20 IN VARCHAR2
35 ) IS
36
37 BEGIN
38 INSERT INTO HZ_ORIG_SYS_MAPPING (
39 orig_system,
40 owner_table_name,
41 status,
42 multiple_flag,
43 --raji
44 multi_osr_flag,
45 created_by,
46 creation_date,
47 last_updated_by,
48 last_update_date,
49 last_update_login,
50 object_version_number,
51 created_by_module,
52 application_id,
53 attribute_category,
54 attribute1,
55 attribute2,
56 attribute3,
57 attribute4,
58 attribute5,
59 attribute6,
60 attribute7,
61 attribute8,
62 attribute9,
63 attribute10,
64 attribute11,
65 attribute12,
66 attribute13,
67 attribute14,
68 attribute15,
69 attribute16,
70 attribute17,
71 attribute18,
72 attribute19,
73 attribute20
74 )
75 VALUES (
76 DECODE(x_orig_system,
77 FND_API.G_MISS_CHAR, NULL,
78 x_orig_system),
79 DECODE(x_owner_table_name,
80 FND_API.G_MISS_CHAR, NULL,
81 x_owner_table_name),
82 DECODE(x_status,
83 FND_API.G_MISS_CHAR, 'A',
84 NULL, 'A',
85 x_status),
86 DECODE(x_multiple_flag,
87 FND_API.G_MISS_CHAR, 'N',NULL, 'N',
88 x_multiple_flag),
89 --raji
90 DECODE(x_multi_osr_flag,
91 FND_API.G_MISS_CHAR,'Y',NULL,'Y',
92 x_multi_osr_flag),
93 hz_utility_v2pub.created_by,
94 hz_utility_v2pub.creation_date,
95 hz_utility_v2pub.last_updated_by,
96 hz_utility_v2pub.last_update_date,
97 hz_utility_v2pub.last_update_login,
98 DECODE(x_object_version_number,
99 FND_API.G_MISS_NUM, NULL,
100 x_object_version_number),
101 DECODE(x_created_by_module,
102 FND_API.G_MISS_CHAR, NULL,
103 x_created_by_module),
104 hz_utility_v2pub.application_id,
105 DECODE(x_attribute_category,
106 FND_API.G_MISS_CHAR, NULL,
107 x_attribute_category),
108 DECODE(x_attribute1,
109 FND_API.G_MISS_CHAR, NULL,
110 x_attribute1),
111 DECODE(x_attribute2,
112 FND_API.G_MISS_CHAR, NULL,
113 x_attribute2),
114 DECODE(x_attribute3,
115 FND_API.G_MISS_CHAR, NULL,
116 x_attribute3),
117 DECODE(x_attribute4,
118 FND_API.G_MISS_CHAR, NULL,
119 x_attribute4),
120 DECODE(x_attribute5,
121 FND_API.G_MISS_CHAR, NULL,
122 x_attribute5),
123 DECODE(x_attribute6,
124 FND_API.G_MISS_CHAR, NULL,
125 x_attribute6),
126 DECODE(x_attribute7,
127 FND_API.G_MISS_CHAR, NULL,
128 x_attribute7),
129 DECODE(x_attribute8,
130 FND_API.G_MISS_CHAR, NULL,
131 x_attribute8),
132 DECODE(x_attribute9,
133 FND_API.G_MISS_CHAR, NULL,
134 x_attribute9),
135 DECODE(x_attribute10,
136 FND_API.G_MISS_CHAR, NULL,
137 x_attribute10),
138 DECODE(x_attribute11,
139 FND_API.G_MISS_CHAR, NULL,
140 x_attribute11),
141 DECODE(x_attribute12,
142 FND_API.G_MISS_CHAR, NULL,
143 x_attribute12),
144 DECODE(x_attribute13,
145 FND_API.G_MISS_CHAR, NULL,
146 x_attribute13),
147 DECODE(x_attribute14,
148 FND_API.G_MISS_CHAR, NULL,
149 x_attribute14),
150 DECODE(x_attribute15,
151 FND_API.G_MISS_CHAR, NULL,
152 x_attribute15),
153 DECODE(x_attribute16,
154 FND_API.G_MISS_CHAR, NULL,
155 x_attribute16),
156 DECODE(x_attribute17,
157 FND_API.G_MISS_CHAR, NULL,
158 x_attribute17),
159 DECODE(x_attribute18,
160 FND_API.G_MISS_CHAR, NULL,
161 x_attribute18),
162 DECODE(x_attribute19,
163 FND_API.G_MISS_CHAR, NULL,
164 x_attribute19),
165 DECODE(x_attribute20,
166 FND_API.G_MISS_CHAR, NULL,
167 x_attribute20)
168 ) ;
169
170 END Insert_Row;
171
172 PROCEDURE Update_Row (
173 x_orig_system IN VARCHAR2,
174 x_owner_table_name IN VARCHAR2,
175 x_status IN VARCHAR2,
176 x_multiple_flag IN VARCHAR2,
177 --raji
178 x_multi_osr_flag IN VARCHAR2,
179 x_object_version_number IN NUMBER,
180 x_created_by_module IN VARCHAR2,
181 x_application_id IN NUMBER,
182 x_attribute_category IN VARCHAR2,
183 x_attribute1 IN VARCHAR2,
184 x_attribute2 IN VARCHAR2,
185 x_attribute3 IN VARCHAR2,
186 x_attribute4 IN VARCHAR2,
187 x_attribute5 IN VARCHAR2,
188 x_attribute6 IN VARCHAR2,
189 x_attribute7 IN VARCHAR2,
190 x_attribute8 IN VARCHAR2,
191 x_attribute9 IN VARCHAR2,
192 x_attribute10 IN VARCHAR2,
193 x_attribute11 IN VARCHAR2,
194 x_attribute12 IN VARCHAR2,
195 x_attribute13 IN VARCHAR2,
196 x_attribute14 IN VARCHAR2,
197 x_attribute15 IN VARCHAR2,
198 x_attribute16 IN VARCHAR2,
199 x_attribute17 IN VARCHAR2,
200 x_attribute18 IN VARCHAR2,
201 x_attribute19 IN VARCHAR2,
202 x_attribute20 IN VARCHAR2
203 ) IS
204 BEGIN
205
206 UPDATE HZ_ORIG_SYS_MAPPING
207 SET
208 orig_system =
209 DECODE(x_orig_system,
210 NULL, orig_system,
211 FND_API.G_MISS_CHAR, NULL,
212 x_orig_system),
213 owner_table_name =
214 DECODE(x_owner_table_name,
215 NULL, owner_table_name,
216 FND_API.G_MISS_CHAR, NULL,
217 x_owner_table_name),
218 status =
219 DECODE(x_status,
220 NULL, status,
221 FND_API.G_MISS_CHAR, NULL,
222 x_status),
223 multiple_flag =
224 DECODE(x_multiple_flag,
225 NULL, multiple_flag,
226 FND_API.G_MISS_CHAR, NULL,
227 x_multiple_flag),
228 --raji
229 multi_osr_flag =
230 DECODE(x_multi_osr_flag,
231 NULL,multi_osr_flag,
232 FND_API.G_MISS_CHAR,'Y',
233 x_multi_osr_flag),
234 created_by = created_by,
235 creation_date = creation_date,
236 last_updated_by = hz_utility_v2pub.last_updated_by,
237 last_update_date = hz_utility_v2pub.last_update_date,
238 last_update_login = hz_utility_v2pub.last_update_login,
239 object_version_number =
240 DECODE(x_object_version_number,
241 NULL, object_version_number,
242 FND_API.G_MISS_NUM, NULL,
243 x_object_version_number),
244 created_by_module =
245 DECODE(x_created_by_module,
246 NULL, created_by_module,
247 FND_API.G_MISS_CHAR, NULL,
248 x_created_by_module),
249 application_id = hz_utility_v2pub.application_id,
250 attribute_category =
251 DECODE(x_attribute_category,
252 NULL, attribute_category,
253 FND_API.G_MISS_CHAR, NULL,
254 x_attribute_category),
255 attribute1 =
256 DECODE(x_attribute1,
257 NULL, attribute1,
258 FND_API.G_MISS_CHAR, NULL,
259 x_attribute1),
260 attribute2 =
261 DECODE(x_attribute2,
262 NULL, attribute2,
263 FND_API.G_MISS_CHAR, NULL,
264 x_attribute2),
265 attribute3 =
266 DECODE(x_attribute3,
267 NULL, attribute3,
268 FND_API.G_MISS_CHAR, NULL,
269 x_attribute3),
270 attribute4 =
271 DECODE(x_attribute4,
272 NULL, attribute4,
273 FND_API.G_MISS_CHAR, NULL,
274 x_attribute4),
275 attribute5 =
276 DECODE(x_attribute5,
277 NULL, attribute5,
278 FND_API.G_MISS_CHAR, NULL,
279 x_attribute5),
280 attribute6 =
281 DECODE(x_attribute6,
282 NULL, attribute6,
283 FND_API.G_MISS_CHAR, NULL,
284 x_attribute6),
285 attribute7 =
286 DECODE(x_attribute7,
287 NULL, attribute7,
288 FND_API.G_MISS_CHAR, NULL,
289 x_attribute7),
290 attribute8 =
291 DECODE(x_attribute8,
292 NULL, attribute8,
293 FND_API.G_MISS_CHAR, NULL,
294 x_attribute8),
295 attribute9 =
296 DECODE(x_attribute9,
297 NULL, attribute9,
298 FND_API.G_MISS_CHAR, NULL,
299 x_attribute9),
300 attribute10 =
301 DECODE(x_attribute10,
302 NULL, attribute10,
303 FND_API.G_MISS_CHAR, NULL,
304 x_attribute10),
305 attribute11 =
306 DECODE(x_attribute11,
307 NULL, attribute11,
308 FND_API.G_MISS_CHAR, NULL,
309 x_attribute11),
310 attribute12 =
311 DECODE(x_attribute12,
312 NULL, attribute12,
313 FND_API.G_MISS_CHAR, NULL,
314 x_attribute12),
315 attribute13 =
316 DECODE(x_attribute13,
317 NULL, attribute13,
318 FND_API.G_MISS_CHAR, NULL,
319 x_attribute13),
320 attribute14 =
321 DECODE(x_attribute14,
322 NULL, attribute14,
323 FND_API.G_MISS_CHAR, NULL,
324 x_attribute14),
325 attribute15 =
326 DECODE(x_attribute15,
327 NULL, attribute15,
328 FND_API.G_MISS_CHAR, NULL,
329 x_attribute15),
330 attribute16 =
331 DECODE(x_attribute16,
332 NULL, attribute16,
333 FND_API.G_MISS_CHAR, NULL,
334 x_attribute16),
335 attribute17 =
336 DECODE(x_attribute17,
337 NULL, attribute17,
338 FND_API.G_MISS_CHAR, NULL,
339 x_attribute17),
340 attribute18 =
341 DECODE(x_attribute18,
342 NULL, attribute18,
343 FND_API.G_MISS_CHAR, NULL,
344 x_attribute18),
345 attribute19 =
346 DECODE(x_attribute19,
347 NULL, attribute19,
348 FND_API.G_MISS_CHAR, NULL,
349 x_attribute19),
350 attribute20 =
351 DECODE(x_attribute20,
352 NULL, attribute20,
353 FND_API.G_MISS_CHAR, NULL,
354 x_attribute20)
355 WHERE ORIG_SYSTEM = X_ORIG_SYSTEM
356 AND OWNER_TABLE_NAME = X_OWNER_TABLE_NAME;
357
358 IF ( SQL%NOTFOUND ) THEN
359 RAISE NO_DATA_FOUND;
360 END IF;
361
362 END Update_Row;
363
364 PROCEDURE Lock_Row (
365 X_Rowid IN OUT NOCOPY VARCHAR2,
366 x_orig_system IN VARCHAR2,
367 x_owner_table_name IN VARCHAR2,
368 x_status IN VARCHAR2,
369 x_multiple_flag IN VARCHAR2,
370 --raji
371 x_multi_osr_flag IN VARCHAR2,
372 x_created_by IN NUMBER,
373 x_creation_date IN DATE,
374 x_last_updated_by IN NUMBER,
375 x_last_update_date IN DATE,
376 x_last_update_login IN NUMBER,
377 x_object_version_number IN NUMBER,
378 x_created_by_module IN VARCHAR2,
379 x_application_id IN NUMBER,
380 x_attribute_category IN VARCHAR2,
381 x_attribute1 IN VARCHAR2,
382 x_attribute2 IN VARCHAR2,
383 x_attribute3 IN VARCHAR2,
384 x_attribute4 IN VARCHAR2,
385 x_attribute5 IN VARCHAR2,
386 x_attribute6 IN VARCHAR2,
387 x_attribute7 IN VARCHAR2,
388 x_attribute8 IN VARCHAR2,
389 x_attribute9 IN VARCHAR2,
390 x_attribute10 IN VARCHAR2,
391 x_attribute11 IN VARCHAR2,
392 x_attribute12 IN VARCHAR2,
393 x_attribute13 IN VARCHAR2,
394 x_attribute14 IN VARCHAR2,
395 x_attribute15 IN VARCHAR2,
396 x_attribute16 IN VARCHAR2,
397 x_attribute17 IN VARCHAR2,
398 x_attribute18 IN VARCHAR2,
399 x_attribute19 IN VARCHAR2,
400 x_attribute20 IN VARCHAR2
401 ) IS
402
403 CURSOR c IS
404 SELECT * FROM HZ_ORIG_SYS_MAPPING
405 WHERE rowid = x_rowid
406 FOR UPDATE NOWAIT;
407 Recinfo c%ROWTYPE;
408
409 BEGIN
410
411 OPEN c;
412 FETCH c INTO Recinfo;
413 IF ( c%NOTFOUND ) THEN
414 CLOSE c;
415 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
416 APP_EXCEPTION.RAISE_EXCEPTION;
417 END IF;
418 CLOSE C;
419
420 IF (
421 ( ( Recinfo.orig_system = x_orig_system )
422 OR ( ( Recinfo.orig_system IS NULL )
423 AND ( x_orig_system IS NULL ) ) )
424 AND ( ( Recinfo.owner_table_name = x_owner_table_name )
425 OR ( ( Recinfo.owner_table_name IS NULL )
426 AND ( x_owner_table_name IS NULL ) ) )
427 AND ( ( Recinfo.status = x_status )
428 OR ( ( Recinfo.status IS NULL )
429 AND ( x_status IS NULL ) ) )
430 AND ( ( Recinfo.multiple_flag = x_multiple_flag )
431 OR ( ( Recinfo.multiple_flag IS NULL )
432 AND ( x_multiple_flag IS NULL ) ) )
433 --raji
434 AND ( ( Recinfo.multi_osr_flag = x_multi_osr_flag )
435 OR ( ( Recinfo.multi_osr_flag IS NULL )
436 AND ( x_multi_osr_flag IS NULL ) ) )
437 AND ( ( Recinfo.created_by = x_created_by )
438 OR ( ( Recinfo.created_by IS NULL )
439 AND ( x_created_by IS NULL ) ) )
440 AND ( ( Recinfo.creation_date = x_creation_date )
441 OR ( ( Recinfo.creation_date IS NULL )
442 AND ( x_creation_date IS NULL ) ) )
443 AND ( ( Recinfo.last_updated_by = x_last_updated_by )
444 OR ( ( Recinfo.last_updated_by IS NULL )
445 AND ( x_last_updated_by IS NULL ) ) )
446 AND ( ( Recinfo.last_update_date = x_last_update_date )
447 OR ( ( Recinfo.last_update_date IS NULL )
448 AND ( x_last_update_date IS NULL ) ) )
449 AND ( ( Recinfo.last_update_login = x_last_update_login )
450 OR ( ( Recinfo.last_update_login IS NULL )
451 AND ( x_last_update_login IS NULL ) ) )
452 AND ( ( Recinfo.object_version_number = x_object_version_number )
453 OR ( ( Recinfo.object_version_number IS NULL )
454 AND ( x_object_version_number IS NULL ) ) )
455 AND ( ( Recinfo.created_by_module = x_created_by_module )
456 OR ( ( Recinfo.created_by_module IS NULL )
457 AND ( x_created_by_module IS NULL ) ) )
458 AND ( ( Recinfo.application_id = x_application_id )
459 OR ( ( Recinfo.application_id IS NULL )
460 AND ( x_application_id IS NULL ) ) )
461 AND ( ( Recinfo.attribute_category = x_attribute_category )
462 OR ( ( Recinfo.attribute_category IS NULL )
463 AND ( x_attribute_category IS NULL ) ) )
464 AND ( ( Recinfo.attribute1 = x_attribute1 )
465 OR ( ( Recinfo.attribute1 IS NULL )
466 AND ( x_attribute1 IS NULL ) ) )
467 AND ( ( Recinfo.attribute2 = x_attribute2 )
468 OR ( ( Recinfo.attribute2 IS NULL )
469 AND ( x_attribute2 IS NULL ) ) )
470 AND ( ( Recinfo.attribute3 = x_attribute3 )
471 OR ( ( Recinfo.attribute3 IS NULL )
472 AND ( x_attribute3 IS NULL ) ) )
473 AND ( ( Recinfo.attribute4 = x_attribute4 )
474 OR ( ( Recinfo.attribute4 IS NULL )
475 AND ( x_attribute4 IS NULL ) ) )
476 AND ( ( Recinfo.attribute5 = x_attribute5 )
477 OR ( ( Recinfo.attribute5 IS NULL )
478 AND ( x_attribute5 IS NULL ) ) )
479 AND ( ( Recinfo.attribute6 = x_attribute6 )
480 OR ( ( Recinfo.attribute6 IS NULL )
481 AND ( x_attribute6 IS NULL ) ) )
482 AND ( ( Recinfo.attribute7 = x_attribute7 )
483 OR ( ( Recinfo.attribute7 IS NULL )
484 AND ( x_attribute7 IS NULL ) ) )
485 AND ( ( Recinfo.attribute8 = x_attribute8 )
486 OR ( ( Recinfo.attribute8 IS NULL )
487 AND ( x_attribute8 IS NULL ) ) )
488 AND ( ( Recinfo.attribute9 = x_attribute9 )
489 OR ( ( Recinfo.attribute9 IS NULL )
490 AND ( x_attribute9 IS NULL ) ) )
491 AND ( ( Recinfo.attribute10 = x_attribute10 )
492 OR ( ( Recinfo.attribute10 IS NULL )
493 AND ( x_attribute10 IS NULL ) ) )
494 AND ( ( Recinfo.attribute11 = x_attribute11 )
495 OR ( ( Recinfo.attribute11 IS NULL )
496 AND ( x_attribute11 IS NULL ) ) )
497 AND ( ( Recinfo.attribute12 = x_attribute12 )
498 OR ( ( Recinfo.attribute12 IS NULL )
499 AND ( x_attribute12 IS NULL ) ) )
500 AND ( ( Recinfo.attribute13 = x_attribute13 )
501 OR ( ( Recinfo.attribute13 IS NULL )
502 AND ( x_attribute13 IS NULL ) ) )
503 AND ( ( Recinfo.attribute14 = x_attribute14 )
504 OR ( ( Recinfo.attribute14 IS NULL )
505 AND ( x_attribute14 IS NULL ) ) )
506 AND ( ( Recinfo.attribute15 = x_attribute15 )
507 OR ( ( Recinfo.attribute15 IS NULL )
508 AND ( x_attribute15 IS NULL ) ) )
509 AND ( ( Recinfo.attribute16 = x_attribute16 )
510 OR ( ( Recinfo.attribute16 IS NULL )
511 AND ( x_attribute16 IS NULL ) ) )
512 AND ( ( Recinfo.attribute17 = x_attribute17 )
513 OR ( ( Recinfo.attribute17 IS NULL )
514 AND ( x_attribute17 IS NULL ) ) )
515 AND ( ( Recinfo.attribute18 = x_attribute18 )
516 OR ( ( Recinfo.attribute18 IS NULL )
517 AND ( x_attribute18 IS NULL ) ) )
518 AND ( ( Recinfo.attribute19 = x_attribute19 )
519 OR ( ( Recinfo.attribute19 IS NULL )
520 AND ( x_attribute19 IS NULL ) ) )
521 AND ( ( Recinfo.attribute20 = x_attribute20 )
522 OR ( ( Recinfo.attribute20 IS NULL )
523 AND ( x_attribute20 IS NULL ) ) )
524 ) THEN
525 RETURN;
526 ELSE
527 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
528 APP_EXCEPTION.RAISE_EXCEPTION;
529 END IF;
530
531 END Lock_Row;
532
533 PROCEDURE Select_Row (
534 x_orig_system IN OUT NOCOPY VARCHAR2,
535 x_owner_table_name IN OUT NOCOPY VARCHAR2,
536 x_status OUT NOCOPY VARCHAR2,
537 x_multiple_flag OUT NOCOPY VARCHAR2,
538 --raji
539 x_multi_osr_flag OUT NOCOPY VARCHAR2,
540 x_object_version_number OUT NOCOPY NUMBER,
541 x_created_by_module OUT NOCOPY VARCHAR2,
542 x_application_id OUT NOCOPY NUMBER,
543 x_attribute_category OUT NOCOPY VARCHAR2,
544 x_attribute1 OUT NOCOPY VARCHAR2,
545 x_attribute2 OUT NOCOPY VARCHAR2,
546 x_attribute3 OUT NOCOPY VARCHAR2,
547 x_attribute4 OUT NOCOPY VARCHAR2,
548 x_attribute5 OUT NOCOPY VARCHAR2,
549 x_attribute6 OUT NOCOPY VARCHAR2,
550 x_attribute7 OUT NOCOPY VARCHAR2,
551 x_attribute8 OUT NOCOPY VARCHAR2,
552 x_attribute9 OUT NOCOPY VARCHAR2,
553 x_attribute10 OUT NOCOPY VARCHAR2,
554 x_attribute11 OUT NOCOPY VARCHAR2,
555 x_attribute12 OUT NOCOPY VARCHAR2,
556 x_attribute13 OUT NOCOPY VARCHAR2,
557 x_attribute14 OUT NOCOPY VARCHAR2,
558 x_attribute15 OUT NOCOPY VARCHAR2,
559 x_attribute16 OUT NOCOPY VARCHAR2,
560 x_attribute17 OUT NOCOPY VARCHAR2,
561 x_attribute18 OUT NOCOPY VARCHAR2,
562 x_attribute19 OUT NOCOPY VARCHAR2,
563 x_attribute20 OUT NOCOPY VARCHAR2
564 ) IS
565 BEGIN
566
567 SELECT
568 NVL(orig_system, FND_API.G_MISS_CHAR),
569 NVL(owner_table_name, FND_API.G_MISS_CHAR),
570 NVL(status, FND_API.G_MISS_CHAR),
571 NVL(multiple_flag, FND_API.G_MISS_CHAR),
572 --raji
573 NVL(multi_osr_flag,FND_API.G_MISS_CHAR),
574 NVL(created_by_module, FND_API.G_MISS_CHAR),
575 NVL(application_id, FND_API.G_MISS_NUM),
576 NVL(attribute_category, FND_API.G_MISS_CHAR),
577 NVL(attribute1, FND_API.G_MISS_CHAR),
578 NVL(attribute2, FND_API.G_MISS_CHAR),
579 NVL(attribute3, FND_API.G_MISS_CHAR),
580 NVL(attribute4, FND_API.G_MISS_CHAR),
581 NVL(attribute5, FND_API.G_MISS_CHAR),
582 NVL(attribute6, FND_API.G_MISS_CHAR),
583 NVL(attribute7, FND_API.G_MISS_CHAR),
584 NVL(attribute8, FND_API.G_MISS_CHAR),
585 NVL(attribute9, FND_API.G_MISS_CHAR),
586 NVL(attribute10, FND_API.G_MISS_CHAR),
587 NVL(attribute11, FND_API.G_MISS_CHAR),
588 NVL(attribute12, FND_API.G_MISS_CHAR),
589 NVL(attribute13, FND_API.G_MISS_CHAR),
590 NVL(attribute14, FND_API.G_MISS_CHAR),
591 NVL(attribute15, FND_API.G_MISS_CHAR),
592 NVL(attribute16, FND_API.G_MISS_CHAR),
593 NVL(attribute17, FND_API.G_MISS_CHAR),
594 NVL(attribute18, FND_API.G_MISS_CHAR),
595 NVL(attribute19, FND_API.G_MISS_CHAR),
596 NVL(attribute20, FND_API.G_MISS_CHAR)
597 INTO
598 x_orig_system,
599 x_owner_table_name,
600 x_status,
601 x_multiple_flag,
602 --raji
603 x_multi_osr_flag,
604 x_created_by_module,
605 x_application_id,
606 x_attribute_category,
607 x_attribute1,
608 x_attribute2,
609 x_attribute3,
610 x_attribute4,
611 x_attribute5,
612 x_attribute6,
613 x_attribute7,
614 x_attribute8,
615 x_attribute9,
616 x_attribute10,
617 x_attribute11,
618 x_attribute12,
619 x_attribute13,
620 x_attribute14,
621 x_attribute15,
622 x_attribute16,
623 x_attribute17,
624 x_attribute18,
625 x_attribute19,
626 x_attribute20
627 FROM HZ_ORIG_SYS_MAPPING
628 WHERE ORIG_SYSTEM = X_ORIG_SYSTEM
629 AND OWNER_TABLE_NAME = X_OWNER_TABLE_NAME;
630
631
632 EXCEPTION
633 WHEN NO_DATA_FOUND THEN
634 FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
635 FND_MESSAGE.SET_TOKEN('RECORD', 'orig_sys_entity_map_rec');
636 FND_MESSAGE.SET_TOKEN('VALUE', x_orig_system);
637 FND_MSG_PUB.ADD;
638 RAISE FND_API.G_EXC_ERROR;
639
640 END Select_Row;
641
642
643 END HZ_ORIG_SYS_ENTITY_MAP_PKG;