[Home] [Help]
PACKAGE BODY: APPS.CN_SCA_CRRULEATTR_PKG
Source
1 PACKAGE BODY CN_SCA_CRRULEATTR_PKG as
2 -- $Header: cntscrrb.pls 120.3 2005/10/12 11:58:36 mpawar noship $
3
4
5 g_temp_status_code VARCHAR2(30) := NULL;
6 g_program_type VARCHAR2(30) := NULL;
7
8
9 --------------------------------------------------------------------------
10 -- Procedure Name : Get_UID
11 -- Purpose : Get the Sequence Number to Create a new Pay Group
12 --------------------------------------------------------------------------
13
14 PROCEDURE Get_UID( X_sca_rule_attribute_id IN OUT NOCOPY NUMBER) IS
15
16 BEGIN
17
18 SELECT cn_sca_rule_attributes_s.nextval
19 INTO X_sca_rule_attribute_id
20 FROM sys.dual;
21
22 END Get_UID;
23
24
25 -------------------------------------------------------------------------
26 -- Procedure Name : Insert_Record
27 -- Purpose : Main insert procedure
28 -------------------------------------------------------------------------
29
30 /* PROCEDURE Insert_Record(
31 x_Rowid IN OUT NOCOPY VARCHAR2
32 ,x_sca_rule_attribute_Id IN OUT NOCOPY NUMBER
33 ,x_trx_source_name VARCHAR2
34 ,x_user_name VARCHAR2
35 ,x_destination_column VARCHAR2
36 ,x_value_set_id NUMBER
37 ,x_enable_flag VARCHAR2
38 ,x_datatype VARCHAR2
39 ,x_trx_src_column_name VARCHAR2
40 ,x_attribute_category VARCHAR2
41 ,x_attribute1 VARCHAR2
42 ,x_attribute2 VARCHAR2
43 ,x_attribute3 VARCHAR2
44 ,x_attribute4 VARCHAR2
45 ,x_attribute5 VARCHAR2
46 ,x_attribute6 VARCHAR2
47 ,x_attribute7 VARCHAR2
48 ,x_attribute8 VARCHAR2
49 ,x_attribute9 VARCHAR2
50 ,x_attribute10 VARCHAR2
51 ,x_attribute11 VARCHAR2
52 ,x_attribute12 VARCHAR2
53 ,x_attribute13 VARCHAR2
54 ,x_attribute14 VARCHAR2
55 ,x_attribute15 VARCHAR2
56 ,x_Created_By NUMBER
57 ,x_Creation_Date DATE
58 ,x_Last_Updated_By NUMBER
59 ,x_Last_Update_Date DATE
60 ,x_Last_Update_Login NUMBER) IS
61
62
63
64 BEGIN
65
66 IF x_sca_rule_attribute_id is null
67 THEN
68 Get_UID( X_sca_rule_attribute_id );
69 END IF;
70
71 INSERT INTO cn_sca_rule_attributes(
72 sca_rule_Attribute_id
73 ,user_column_name
74 ,src_column_name
75 ,value_set_id
76 ,enabled_Flag
77 ,datatype
78 ,trx_src_column_name
79 ,transaction_source
80 ,attribute_category
81 ,attribute1
82 ,attribute2
83 ,attribute3
84 ,attribute4
85 ,attribute5
86 ,attribute6
87 ,attribute7
88 ,attribute8
89 ,attribute9
90 ,attribute10
91 ,attribute11
92 ,attribute12
93 ,attribute13
94 ,attribute14
95 ,attribute15
96 ,Created_By
97 ,Creation_Date
98 ,Last_Updated_By
99 ,Last_Update_Date
100 ,Last_Update_Login
101 ,object_version_number)
102 VALUES (
103 x_sca_rule_Attribute_id
104 ,x_user_name
105 ,x_destination_column
106 ,x_value_set_id
107 ,x_enable_flag
108 ,x_datatype
109 ,x_trx_src_column_name
110 ,x_trx_source_name
111 ,x_attribute_category
112 ,x_attribute1
113 ,x_attribute2
114 ,x_attribute3
115 ,x_attribute4
116 ,x_attribute5
117 ,x_attribute6
118 ,x_attribute7
119 ,x_attribute8
120 ,x_attribute9
121 ,x_attribute10
122 ,x_attribute11
123 ,x_attribute12
124 ,x_attribute13
125 ,x_attribute14
126 ,x_attribute15
127 ,x_Created_By
128 ,x_Creation_Date
129 ,x_Last_Updated_By
130 ,x_Last_Update_Date
131 ,x_Last_Update_Login
132 ,1
133 );
134
135 END Insert_Record;
136
137
138 --------------------------------------------------------------------------
139 -- Procedure Name : Update Record
140
141 --------------------------------------------------------------------------
142
143 PROCEDURE Update_Record(
144 x_Rowid IN OUT NOCOPY VARCHAR2
145 ,x_sca_rule_attribute_Id IN OUT NOCOPY NUMBER
146 ,x_trx_source_name VARCHAR2
147 ,x_user_name VARCHAR2
148 ,x_destination_column VARCHAR2
149 ,x_value_set_id NUMBER
150 ,x_enable_flag VARCHAR2
151 ,x_datatype VARCHAR2
152 ,x_trx_src_column_name VARCHAR2
153 ,x_attribute_category VARCHAR2
154 ,x_attribute1 VARCHAR2
155 ,x_attribute2 VARCHAR2
156 ,x_attribute3 VARCHAR2
157 ,x_attribute4 VARCHAR2
158 ,x_attribute5 VARCHAR2
159 ,x_attribute6 VARCHAR2
160 ,x_attribute7 VARCHAR2
161 ,x_attribute8 VARCHAR2
162 ,x_attribute9 VARCHAR2
163 ,x_attribute10 VARCHAR2
164 ,x_attribute11 VARCHAR2
165 ,x_attribute12 VARCHAR2
166 ,x_attribute13 VARCHAR2
167 ,x_attribute14 VARCHAR2
168 ,x_attribute15 VARCHAR2
169 ,x_Created_By NUMBER
170 ,x_Creation_Date DATE
171 ,x_Last_Updated_By NUMBER
172 ,x_Last_Update_Date DATE
173 ,x_Last_Update_Login NUMBER) IS
174
175 l_user_name cn_sca_rule_attributes.user_column_name%TYPE;
176 l_value_set_id cn_sca_rule_attributes.value_set_id%TYPE;
177 l_destination_column cn_sca_rule_attributes.src_column_name%TYPE;
178 l_enable_flag cn_sca_rule_attributes.enabled_flag%TYPE;
179 l_datatype cn_sca_rule_attributes.datatype%TYPE;
180 l_trx_source_column_name cn_sca_rule_attributes.trx_src_column_name%TYPE;
181 l_transaction_source cn_sca_rule_attributes.transaction_source%TYPE;
182 l_attribute_category cn_sca_rule_attributes.attribute_category%TYPE;
183 l_attribute1 cn_sca_rule_attributes.attribute1%TYPE;
184 l_attribute2 cn_sca_rule_attributes.attribute2%TYPE;
185 l_attribute3 cn_sca_rule_attributes.attribute3%TYPE;
186 l_attribute4 cn_sca_rule_attributes.attribute4%TYPE;
187 l_attribute5 cn_sca_rule_attributes.attribute5%TYPE;
188 l_attribute6 cn_sca_rule_attributes.attribute6%TYPE;
189 l_attribute7 cn_sca_rule_attributes.attribute7%TYPE;
190 l_attribute8 cn_sca_rule_attributes.attribute8%TYPE;
191 l_attribute9 cn_sca_rule_attributes.attribute9%TYPE;
192 l_attribute10 cn_sca_rule_attributes.attribute10%TYPE;
193 l_attribute11 cn_sca_rule_attributes.attribute11%TYPE;
194 l_attribute12 cn_sca_rule_attributes.attribute12%TYPE;
195 l_attribute13 cn_sca_rule_attributes.attribute13%TYPE;
196 l_attribute14 cn_sca_rule_attributes.attribute14%TYPE;
197 l_attribute15 cn_sca_rule_attributes.attribute15%TYPE;
198
199 CURSOR sca_rule_atribute_cur IS
200 SELECT *
201 FROM cn_sca_rule_attributes
202 WHERE sca_rule_attribute_id = x_sca_rule_attribute_id;
203
204 l_sca_rule_attribute_rec sca_rule_atribute_cur%ROWTYPE;
205
206 BEGIN
207
208 OPEN sca_rule_atribute_cur;
209 FETCH sca_rule_atribute_cur INTO l_sca_rule_attribute_rec;
210 CLOSE sca_rule_atribute_cur;
211
212 SELECT decode(x_user_name,
213 fnd_api.g_miss_char, l_sca_rule_attribute_rec.user_column_name,
214 x_user_name),
215 decode(x_destination_column,
216 fnd_api.g_miss_char, l_sca_rule_attribute_rec.src_column_name,
217 x_destination_column),
218 decode(x_value_set_id,
219 cn_api.g_miss_num, l_sca_rule_attribute_rec.value_set_id,
220 x_value_set_id),
221 decode(x_enable_flag,
222 fnd_api.g_miss_char, l_sca_rule_attribute_rec.enabled_flag,
223 x_enable_flag),
224 decode(x_datatype,
225 fnd_api.g_miss_char, l_sca_rule_attribute_rec.datatype,
226 x_datatype),
227 decode(x_trx_src_column_name,
228 fnd_api.g_miss_char, l_sca_rule_attribute_rec.trx_src_column_name,
229 x_trx_src_column_name),
230 decode(x_trx_source_name,
231 fnd_api.g_miss_char, l_sca_rule_attribute_rec.transaction_source,
232 x_trx_source_name),
233
234 decode(x_attribute_category,
235 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute_category,
236 x_attribute_category),
237 decode(x_attribute1,
238 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute1,
239 x_attribute1),
240 decode(x_attribute2,
241 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute2,
242 x_attribute2),
243 decode(x_attribute3,
244 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute3,
245 x_attribute3),
246 decode(x_attribute4,
247 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute4,
248 x_attribute4),
249 decode(x_attribute5,
250 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute5,
251 x_attribute5),
252 decode(x_attribute6,
253 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute6,
254 x_attribute6),
255 decode(x_attribute7,
256 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute7,
257 x_attribute7),
258 decode(x_attribute8,
259 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute8,
260 x_attribute8),
261 decode(x_attribute9,
262 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute9,
263 x_attribute9),
264 decode(x_attribute10,
265 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute10,
266 x_attribute10),
267 decode(x_attribute11,
268 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute11,
269 x_attribute11),
270 decode(x_attribute12,
271 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute12,
272 x_attribute12),
273 decode(x_attribute13,
274 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute13,
275 x_attribute13),
276 decode(x_attribute14,
277 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute14,
278 x_attribute14),
279 decode(x_attribute15,
280 fnd_api.g_miss_char, l_sca_rule_attribute_rec.attribute15,
281 x_attribute15)
282
283 INTO l_user_name,
284 l_destination_column ,
285 l_value_set_id,
286 l_enable_flag,
287 l_datatype,
288 l_trx_source_column_name,
289 l_transaction_source,
290 l_attribute_category,
291 l_attribute1,
292 l_attribute2,
293 l_attribute3,
294 l_attribute4,
295 l_attribute5,
296 l_attribute6,
297 l_attribute7,
298 l_attribute8,
299 l_attribute9,
300 l_attribute10,
301 l_attribute11,
302 l_attribute12,
303 l_attribute13,
307
304 l_attribute14,
305 l_attribute15
306 FROM dual;
308
309 UPDATE cn_sca_rule_attributes
310 SET
311 user_column_name = l_user_name,
312 src_column_name = l_destination_column,
313 value_set_id = l_value_set_id,
314 enabled_flag = l_enable_flag,
315 datatype = l_datatype,
316 trx_src_column_name = l_trx_source_column_name,
317 transaction_source = l_transaction_source,
318 attribute_category = l_attribute_category,
319 attribute1 = l_attribute1,
320 attribute2 = l_attribute2,
321 attribute3 = l_attribute3,
322 attribute4 = l_attribute4,
323 attribute5 = l_attribute5,
324 attribute6 = l_attribute6,
325 attribute7 = l_attribute7,
326 attribute8 = l_attribute8,
327 attribute9 = l_attribute9,
328 attribute10 = l_attribute10,
329 attribute11 = l_attribute11,
330 attribute12 = l_attribute12,
331 attribute13 = l_attribute13,
332 attribute14 = l_attribute14,
333 attribute15 = l_attribute15,
334 last_update_date = x_Last_Update_Date,
335 last_updated_by = x_Last_Updated_By,
336 last_update_login = x_Last_Update_Login,
337 object_version_number = object_version_number + 1
338 WHERE sca_rule_attribute_id = x_sca_rule_attribute_id ;
339
340 if (SQL%NOTFOUND) then
341 Raise NO_DATA_FOUND;
342 end if;
343
344 END Update_Record;
345
346
347
348
349 -----------------------------------------------------------------------------
350 -- Procedure Name : BEGIN_RECORD
351 -- Purpose : This PUBLIC procedure is called at the start of the
352 -- commit cycle.
353 -----------------------------------------------------------------------------
354 PROCEDURE Begin_Record(
355 X_OPERATION VARCHAR2,
356 X_ROWID in out VARCHAR2,
357 X_SCA_RULE_ATTRIBUTE_ID in NUMBER,
358 X_TRANSACTION_SOURCE in VARCHAR2,
359 X_SRC_COLUMN_NAME in VARCHAR2,
360 X_DATATYPE in VARCHAR2,
361 X_VALUE_SET_ID in NUMBER,
362 X_TRX_SRC_COLUMN_NAME in VARCHAR2,
363 X_ENABLED_FLAG in VARCHAR2,
364 X_ATTRIBUTE_CATEGORY in VARCHAR2,
365 X_ATTRIBUTE1 in VARCHAR2,
366 X_ATTRIBUTE2 in VARCHAR2,
367 X_ATTRIBUTE3 in VARCHAR2,
368 X_ATTRIBUTE4 in VARCHAR2,
369 X_ATTRIBUTE5 in VARCHAR2,
370 X_ATTRIBUTE6 in VARCHAR2,
371 X_ATTRIBUTE7 in VARCHAR2,
372 X_ATTRIBUTE8 in VARCHAR2,
373 X_ATTRIBUTE9 in VARCHAR2,
374 X_ATTRIBUTE10 in VARCHAR2,
375 X_ATTRIBUTE11 in VARCHAR2,
376 X_ATTRIBUTE12 in VARCHAR2,
377 X_ATTRIBUTE13 in VARCHAR2,
378 X_ATTRIBUTE14 in VARCHAR2,
379 X_ATTRIBUTE15 in VARCHAR2,
380 X_OBJECT_VERSION_NUMBER in NUMBER,
381 X_SECURITY_GROUP_ID in NUMBER,
382 X_USER_COLUMN_NAME in VARCHAR2,
383 X_CREATION_DATE in DATE,
384 X_CREATED_BY in NUMBER,
385 X_LAST_UPDATE_DATE in DATE,
386 X_LAST_UPDATED_BY in NUMBER,
387 X_LAST_UPDATE_LOGIN in NUMBER
388 ) is
389
390
391
392 BEGIN
393
394 -- Saves passing it around
395
396 g_temp_status_code := 'COMPLETE'; -- Assume it is good to begin with
397 IF X_Operation = 'INSERT' THEN
398
399 Insert_Row( X_ROWID
400 ,X_SCA_RULE_ATTRIBUTE_ID
401 ,X_TRANSACTION_SOURCE
402 ,X_SRC_COLUMN_NAME
403 ,X_DATATYPE
404 ,X_VALUE_SET_ID
405 ,X_TRX_SRC_COLUMN_NAME
406 ,X_ENABLED_FLAG
407 ,X_ATTRIBUTE_CATEGORY
408 ,X_ATTRIBUTE1
409 ,X_ATTRIBUTE2
410 ,X_ATTRIBUTE3
411 ,X_ATTRIBUTE4
412 ,X_ATTRIBUTE5
413 ,X_ATTRIBUTE6
414 ,X_ATTRIBUTE7
415 ,X_ATTRIBUTE8
416 ,X_ATTRIBUTE9
417 ,X_ATTRIBUTE10
418 ,X_ATTRIBUTE11
419 ,X_ATTRIBUTE12
420 ,X_ATTRIBUTE13
421 ,X_ATTRIBUTE14
422 ,X_ATTRIBUTE15
423 ,X_OBJECT_VERSION_NUMBER
424 ,X_SECURITY_GROUP_ID
425 ,X_USER_COLUMN_NAME
426 ,X_CREATION_DATE
427 ,X_CREATED_BY
428 ,X_LAST_UPDATE_DATE
429 ,X_LAST_UPDATED_BY
430 ,X_LAST_UPDATE_LOGIN);
431
432 ELSIF X_Operation = 'UPDATE' THEN
433
434 Update_Row(
435 X_SCA_RULE_ATTRIBUTE_ID
436 ,X_TRANSACTION_SOURCE
437 ,X_SRC_COLUMN_NAME
438 ,X_DATATYPE
439 ,X_VALUE_SET_ID
440 ,X_TRX_SRC_COLUMN_NAME
441 ,X_ENABLED_FLAG
442 ,X_ATTRIBUTE_CATEGORY
443 ,X_ATTRIBUTE1
444 ,X_ATTRIBUTE2
445 ,X_ATTRIBUTE3
446 ,X_ATTRIBUTE4
447 ,X_ATTRIBUTE5
448 ,X_ATTRIBUTE6
449 ,X_ATTRIBUTE7
450 ,X_ATTRIBUTE8
451 ,X_ATTRIBUTE9
452 ,X_ATTRIBUTE10
453 ,X_ATTRIBUTE11
454 ,X_ATTRIBUTE12
455 ,X_ATTRIBUTE13
456 ,X_ATTRIBUTE14
457 ,X_ATTRIBUTE15
458 ,X_OBJECT_VERSION_NUMBER
459 ,X_SECURITY_GROUP_ID
460 ,X_USER_COLUMN_NAME
464 END IF;
461 ,X_LAST_UPDATE_DATE
462 ,X_LAST_UPDATED_BY
463 ,X_LAST_UPDATE_LOGIN);
465
466 END Begin_Record;
467 */
468 procedure INSERT_ROW (
469 X_ROWID in out nocopy VARCHAR2,
470 X_ORG_ID in NUMBER, -- MOAC Change
471 X_SCA_RULE_ATTRIBUTE_ID in NUMBER,
472 X_TRANSACTION_SOURCE in VARCHAR2,
473 X_SRC_COLUMN_NAME in VARCHAR2,
474 X_DATATYPE in VARCHAR2,
475 X_VALUE_SET_ID in NUMBER,
476 X_TRX_SRC_COLUMN_NAME in VARCHAR2,
477 X_ENABLED_FLAG in VARCHAR2,
478 X_ATTRIBUTE_CATEGORY in VARCHAR2,
479 X_ATTRIBUTE1 in VARCHAR2,
480 X_ATTRIBUTE2 in VARCHAR2,
481 X_ATTRIBUTE3 in VARCHAR2,
482 X_ATTRIBUTE4 in VARCHAR2,
483 X_ATTRIBUTE5 in VARCHAR2,
484 X_ATTRIBUTE6 in VARCHAR2,
485 X_ATTRIBUTE7 in VARCHAR2,
486 X_ATTRIBUTE8 in VARCHAR2,
487 X_ATTRIBUTE9 in VARCHAR2,
488 X_ATTRIBUTE10 in VARCHAR2,
489 X_ATTRIBUTE11 in VARCHAR2,
490 X_ATTRIBUTE12 in VARCHAR2,
491 X_ATTRIBUTE13 in VARCHAR2,
492 X_ATTRIBUTE14 in VARCHAR2,
493 X_ATTRIBUTE15 in VARCHAR2,
494 X_OBJECT_VERSION_NUMBER in NUMBER,
495 X_SECURITY_GROUP_ID in NUMBER,
496 X_USER_COLUMN_NAME in VARCHAR2,
497 X_CREATION_DATE in DATE,
498 X_CREATED_BY in NUMBER,
499 X_LAST_UPDATE_DATE in DATE,
500 X_LAST_UPDATED_BY in NUMBER,
501 X_LAST_UPDATE_LOGIN in NUMBER
502 ) is
503 cursor C is select ROWID from CN_SCA_RULE_ATTRIBUTES_ALL_B
504 where SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
505 and org_id = x_org_id; -- MOAC Change
506 begin
507 insert into CN_SCA_RULE_ATTRIBUTES_ALL_B (
508 ORG_ID, -- MOAC Change
509 SCA_RULE_ATTRIBUTE_ID,
510 TRANSACTION_SOURCE,
511 SRC_COLUMN_NAME,
512 DATATYPE,
513 VALUE_SET_ID,
514 TRX_SRC_COLUMN_NAME,
515 ENABLED_FLAG,
516 ATTRIBUTE_CATEGORY,
517 ATTRIBUTE1,
518 ATTRIBUTE2,
519 ATTRIBUTE3,
520 ATTRIBUTE4,
521 ATTRIBUTE5,
522 ATTRIBUTE6,
523 ATTRIBUTE7,
524 ATTRIBUTE8,
525 ATTRIBUTE9,
526 ATTRIBUTE10,
527 ATTRIBUTE11,
528 ATTRIBUTE12,
529 ATTRIBUTE13,
530 ATTRIBUTE14,
531 ATTRIBUTE15,
532 OBJECT_VERSION_NUMBER,
533 SECURITY_GROUP_ID,
534 CREATION_DATE,
535 CREATED_BY,
536 LAST_UPDATE_DATE,
537 LAST_UPDATED_BY,
538 LAST_UPDATE_LOGIN
539 ) values (
540 X_ORG_ID, -- MOAC Change
541 X_SCA_RULE_ATTRIBUTE_ID,
542 X_TRANSACTION_SOURCE,
543 X_SRC_COLUMN_NAME,
544 X_DATATYPE,
545 X_VALUE_SET_ID,
546 X_TRX_SRC_COLUMN_NAME,
547 X_ENABLED_FLAG,
548 X_ATTRIBUTE_CATEGORY,
549 X_ATTRIBUTE1,
550 X_ATTRIBUTE2,
551 X_ATTRIBUTE3,
552 X_ATTRIBUTE4,
553 X_ATTRIBUTE5,
554 X_ATTRIBUTE6,
555 X_ATTRIBUTE7,
556 X_ATTRIBUTE8,
557 X_ATTRIBUTE9,
558 X_ATTRIBUTE10,
559 X_ATTRIBUTE11,
560 X_ATTRIBUTE12,
561 X_ATTRIBUTE13,
562 X_ATTRIBUTE14,
563 X_ATTRIBUTE15,
564 X_OBJECT_VERSION_NUMBER,
565 X_SECURITY_GROUP_ID,
566 X_CREATION_DATE,
567 X_CREATED_BY,
568 X_LAST_UPDATE_DATE,
569 X_LAST_UPDATED_BY,
570 X_LAST_UPDATE_LOGIN
571 );
572
573 insert into CN_SCA_RULE_ATTRIBUTES_ALL_TL (
574 ORG_ID, -- MOAC Change
575 SCA_RULE_ATTRIBUTE_ID,
576 USER_COLUMN_NAME,
577 CREATED_BY,
578 CREATION_DATE,
579 LAST_UPDATED_BY,
580 LAST_UPDATE_DATE,
581 LAST_UPDATE_LOGIN,
582 SECURITY_GROUP_ID,
583 LANGUAGE,
584 SOURCE_LANG
585 ) select
586 X_ORG_ID, -- MOAC Change
587 X_SCA_RULE_ATTRIBUTE_ID,
588 X_USER_COLUMN_NAME,
589 X_CREATED_BY,
590 X_CREATION_DATE,
591 X_LAST_UPDATED_BY,
592 X_LAST_UPDATE_DATE,
593 X_LAST_UPDATE_LOGIN,
594 X_SECURITY_GROUP_ID,
595 L.LANGUAGE_CODE,
596 userenv('LANG')
597 from FND_LANGUAGES L
598 where L.INSTALLED_FLAG in ('I', 'B')
599 and not exists
600 (select NULL
601 from CN_SCA_RULE_ATTRIBUTES_ALL_TL T
602 where T.SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
603 and T.LANGUAGE = L.LANGUAGE_CODE
604 and T.ORG_ID = X_ORG_ID);
605
606 open c;
607 fetch c into X_ROWID;
608 if (c%notfound) then
609 close c;
610 raise no_data_found;
611 end if;
612 close c;
613
614 end INSERT_ROW;
615
616 procedure LOCK_ROW (
617 X_ORG_ID in NUMBER, -- MOAC Change
618 X_SCA_RULE_ATTRIBUTE_ID in NUMBER,
619 X_TRANSACTION_SOURCE in VARCHAR2,
620 X_SRC_COLUMN_NAME in VARCHAR2,
621 X_DATATYPE in VARCHAR2,
622 X_VALUE_SET_ID in NUMBER,
623 X_TRX_SRC_COLUMN_NAME in VARCHAR2,
624 X_ENABLED_FLAG in VARCHAR2,
625 X_ATTRIBUTE_CATEGORY in VARCHAR2,
626 X_ATTRIBUTE1 in VARCHAR2,
627 X_ATTRIBUTE2 in VARCHAR2,
628 X_ATTRIBUTE3 in VARCHAR2,
629 X_ATTRIBUTE4 in VARCHAR2,
630 X_ATTRIBUTE5 in VARCHAR2,
631 X_ATTRIBUTE6 in VARCHAR2,
632 X_ATTRIBUTE7 in VARCHAR2,
633 X_ATTRIBUTE8 in VARCHAR2,
634 X_ATTRIBUTE9 in VARCHAR2,
635 X_ATTRIBUTE10 in VARCHAR2,
636 X_ATTRIBUTE11 in VARCHAR2,
637 X_ATTRIBUTE12 in VARCHAR2,
638 X_ATTRIBUTE13 in VARCHAR2,
639 X_ATTRIBUTE14 in VARCHAR2,
640 X_ATTRIBUTE15 in VARCHAR2,
641 X_OBJECT_VERSION_NUMBER in NUMBER,
645 cursor c is select
642 X_SECURITY_GROUP_ID in NUMBER,
643 X_USER_COLUMN_NAME in VARCHAR2
644 ) is
646 TRANSACTION_SOURCE,
647 SRC_COLUMN_NAME,
648 DATATYPE,
649 VALUE_SET_ID,
650 TRX_SRC_COLUMN_NAME,
651 ENABLED_FLAG,
652 ATTRIBUTE_CATEGORY,
653 ATTRIBUTE1,
654 ATTRIBUTE2,
655 ATTRIBUTE3,
656 ATTRIBUTE4,
657 ATTRIBUTE5,
658 ATTRIBUTE6,
659 ATTRIBUTE7,
660 ATTRIBUTE8,
661 ATTRIBUTE9,
662 ATTRIBUTE10,
663 ATTRIBUTE11,
664 ATTRIBUTE12,
665 ATTRIBUTE13,
666 ATTRIBUTE14,
667 ATTRIBUTE15,
668 OBJECT_VERSION_NUMBER,
669 SECURITY_GROUP_ID
670 from CN_SCA_RULE_ATTRIBUTES_ALL_B
671 where SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
672 and ORG_ID = X_ORG_ID -- MOAC Change
673 for update of SCA_RULE_ATTRIBUTE_ID nowait;
674 recinfo c%rowtype;
675
676 cursor c1 is select
677 USER_COLUMN_NAME,
678 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
679 from CN_SCA_RULE_ATTRIBUTES_ALL_TL
680 where SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
681 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
682 and ORG_ID = X_ORG_ID
683 for update of SCA_RULE_ATTRIBUTE_ID nowait;
684 begin
685 open c;
686 fetch c into recinfo;
687 if (c%notfound) then
688 close c;
689 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
690 app_exception.raise_exception;
691 end if;
692 close c;
693 if ( (recinfo.TRANSACTION_SOURCE = X_TRANSACTION_SOURCE)
694 AND (recinfo.SRC_COLUMN_NAME = X_SRC_COLUMN_NAME)
695 AND (recinfo.DATATYPE = X_DATATYPE)
696 AND ((recinfo.VALUE_SET_ID = X_VALUE_SET_ID)
697 OR ((recinfo.VALUE_SET_ID is null) AND (X_VALUE_SET_ID is null)))
698 AND ((recinfo.TRX_SRC_COLUMN_NAME = X_TRX_SRC_COLUMN_NAME)
699 OR ((recinfo.TRX_SRC_COLUMN_NAME is null) AND (X_TRX_SRC_COLUMN_NAME is null)))
700 AND ((recinfo.ENABLED_FLAG = X_ENABLED_FLAG)
701 OR ((recinfo.ENABLED_FLAG is null) AND (X_ENABLED_FLAG is null)))
702 AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
703 OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
704 AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
705 OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
706 AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
707 OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
708 AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
709 OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
710 AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
711 OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
712 AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
713 OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
714 AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
715 OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
716 AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
717 OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
718 AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
719 OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
720 AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
721 OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
722 AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
723 OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
724 AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
725 OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
726 AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
727 OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
728 AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
729 OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
730 AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
731 OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
732 AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
733 OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
734 AND ((recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
735 OR ((recinfo.OBJECT_VERSION_NUMBER is null) AND (X_OBJECT_VERSION_NUMBER is null)))
736 AND ((recinfo.SECURITY_GROUP_ID = X_SECURITY_GROUP_ID)
737 OR ((recinfo.SECURITY_GROUP_ID is null) AND (X_SECURITY_GROUP_ID is null)))
738 ) then
739 null;
740 else
741 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
742 app_exception.raise_exception;
743 end if;
744
745 for tlinfo in c1 loop
746 if (tlinfo.BASELANG = 'Y') then
747 if ( (tlinfo.USER_COLUMN_NAME = X_USER_COLUMN_NAME)
748 ) then
749 null;
750 else
751 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
752 app_exception.raise_exception;
753 end if;
754 end if;
755 end loop;
756 return;
757 end LOCK_ROW;
758
759 procedure UPDATE_ROW (
760 X_ORG_ID in NUMBER, -- MOAC Change
761 X_SCA_RULE_ATTRIBUTE_ID in NUMBER,
762 X_TRANSACTION_SOURCE in VARCHAR2,
763 X_SRC_COLUMN_NAME in VARCHAR2,
764 X_DATATYPE in VARCHAR2,
765 X_VALUE_SET_ID in NUMBER,
766 X_TRX_SRC_COLUMN_NAME in VARCHAR2,
767 X_ENABLED_FLAG in VARCHAR2,
768 X_ATTRIBUTE_CATEGORY in VARCHAR2,
769 X_ATTRIBUTE1 in VARCHAR2,
770 X_ATTRIBUTE2 in VARCHAR2,
771 X_ATTRIBUTE3 in VARCHAR2,
772 X_ATTRIBUTE4 in VARCHAR2,
773 X_ATTRIBUTE5 in VARCHAR2,
774 X_ATTRIBUTE6 in VARCHAR2,
775 X_ATTRIBUTE7 in VARCHAR2,
779 X_ATTRIBUTE11 in VARCHAR2,
776 X_ATTRIBUTE8 in VARCHAR2,
777 X_ATTRIBUTE9 in VARCHAR2,
778 X_ATTRIBUTE10 in VARCHAR2,
780 X_ATTRIBUTE12 in VARCHAR2,
781 X_ATTRIBUTE13 in VARCHAR2,
782 X_ATTRIBUTE14 in VARCHAR2,
783 X_ATTRIBUTE15 in VARCHAR2,
784 X_OBJECT_VERSION_NUMBER in NUMBER,
785 X_SECURITY_GROUP_ID in NUMBER,
786 X_USER_COLUMN_NAME in VARCHAR2,
787 X_LAST_UPDATE_DATE in DATE,
788 X_LAST_UPDATED_BY in NUMBER,
789 X_LAST_UPDATE_LOGIN in NUMBER
790 ) is
791 begin
792 update CN_SCA_RULE_ATTRIBUTES_ALL_B set
793 TRANSACTION_SOURCE = X_TRANSACTION_SOURCE,
794 SRC_COLUMN_NAME = X_SRC_COLUMN_NAME,
795 DATATYPE = X_DATATYPE,
796 VALUE_SET_ID = X_VALUE_SET_ID,
797 TRX_SRC_COLUMN_NAME = X_TRX_SRC_COLUMN_NAME,
798 ENABLED_FLAG = X_ENABLED_FLAG,
799 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
800 ATTRIBUTE1 = X_ATTRIBUTE1,
801 ATTRIBUTE2 = X_ATTRIBUTE2,
802 ATTRIBUTE3 = X_ATTRIBUTE3,
803 ATTRIBUTE4 = X_ATTRIBUTE4,
804 ATTRIBUTE5 = X_ATTRIBUTE5,
805 ATTRIBUTE6 = X_ATTRIBUTE6,
806 ATTRIBUTE7 = X_ATTRIBUTE7,
807 ATTRIBUTE8 = X_ATTRIBUTE8,
808 ATTRIBUTE9 = X_ATTRIBUTE9,
809 ATTRIBUTE10 = X_ATTRIBUTE10,
810 ATTRIBUTE11 = X_ATTRIBUTE11,
811 ATTRIBUTE12 = X_ATTRIBUTE12,
812 ATTRIBUTE13 = X_ATTRIBUTE13,
813 ATTRIBUTE14 = X_ATTRIBUTE14,
814 ATTRIBUTE15 = X_ATTRIBUTE15,
815 OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
816 SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
817 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
818 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
819 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
820 where SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
821 and ORG_ID = X_ORG_ID; -- MOAC Change
822
823 if (sql%notfound) then
824 raise no_data_found;
825 end if;
826
827 update CN_SCA_RULE_ATTRIBUTES_ALL_TL set
828 USER_COLUMN_NAME = X_USER_COLUMN_NAME,
829 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
830 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
831 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
832 SOURCE_LANG = userenv('LANG')
833 where SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
834 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
835 and ORG_ID = X_ORG_ID; -- MOAC Change
836
837 if (sql%notfound) then
838 raise no_data_found;
839 end if;
840 end UPDATE_ROW;
841
842 procedure DELETE_ROW (
843 X_ORG_ID in NUMBER, -- MOAC Change
844 X_SCA_RULE_ATTRIBUTE_ID in NUMBER
845 ) is
846 begin
847 delete from CN_SCA_RULE_ATTRIBUTES_ALL_TL
848 where SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
849 and ORG_ID = X_ORG_ID; -- MOAC Change
850
851 if (sql%notfound) then
852 raise no_data_found;
853 end if;
854
855 delete from CN_SCA_RULE_ATTRIBUTES_ALL_B
856 where SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
857 and ORG_ID = X_ORG_ID; -- MOAC Change
858
859 if (sql%notfound) then
860 raise no_data_found;
861 end if;
862 end DELETE_ROW;
863
864 procedure ADD_LANGUAGE
865 is
866 begin
867 delete from CN_SCA_RULE_ATTRIBUTES_ALL_TL T
868 where not exists
869 (select NULL
870 from CN_SCA_RULE_ATTRIBUTES_ALL_B B
871 where B.SCA_RULE_ATTRIBUTE_ID = T.SCA_RULE_ATTRIBUTE_ID
872 and B.ORG_ID = T.ORG_ID -- MOAC Change
873 );
874
875 update CN_SCA_RULE_ATTRIBUTES_ALL_TL T set (
876 USER_COLUMN_NAME
877 ) = (select
878 B.USER_COLUMN_NAME
879 from CN_SCA_RULE_ATTRIBUTES_ALL_TL B
880 where B.SCA_RULE_ATTRIBUTE_ID = T.SCA_RULE_ATTRIBUTE_ID
881 and B.LANGUAGE = T.SOURCE_LANG
882 and B.ORG_ID = T.ORG_ID -- MOAC Change
883 )
884 where (
885 T.SCA_RULE_ATTRIBUTE_ID,
886 T.LANGUAGE
887 ) in (select
888 SUBT.SCA_RULE_ATTRIBUTE_ID,
889 SUBT.LANGUAGE
890 from CN_SCA_RULE_ATTRIBUTES_ALL_TL SUBB, CN_SCA_RULE_ATTRIBUTES_ALL_TL SUBT
891 where SUBB.SCA_RULE_ATTRIBUTE_ID = SUBT.SCA_RULE_ATTRIBUTE_ID
892 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
893 and SUBB.ORG_ID = SUBT.ORG_ID -- MOAC Change
894 and (SUBB.USER_COLUMN_NAME <> SUBT.USER_COLUMN_NAME
895 ));
896
897 insert into CN_SCA_RULE_ATTRIBUTES_ALL_TL (
898 ORG_ID, -- MOAC Change
899 SCA_RULE_ATTRIBUTE_ID,
900 USER_COLUMN_NAME,
901 CREATED_BY,
902 CREATION_DATE,
903 LAST_UPDATED_BY,
904 LAST_UPDATE_DATE,
905 LAST_UPDATE_LOGIN,
906 SECURITY_GROUP_ID,
907 LANGUAGE,
908 SOURCE_LANG
909 ) select /*+ ORDERED */
910 B.ORG_ID, -- MOAC Change
911 B.SCA_RULE_ATTRIBUTE_ID,
912 B.USER_COLUMN_NAME,
913 B.CREATED_BY,
914 B.CREATION_DATE,
915 B.LAST_UPDATED_BY,
916 B.LAST_UPDATE_DATE,
917 B.LAST_UPDATE_LOGIN,
918 B.SECURITY_GROUP_ID,
919 L.LANGUAGE_CODE,
920 B.SOURCE_LANG
921 from CN_SCA_RULE_ATTRIBUTES_ALL_TL B, FND_LANGUAGES L
922 where L.INSTALLED_FLAG in ('I', 'B')
923 and B.LANGUAGE = userenv('LANG')
924 and not exists
925 (select NULL
926 from CN_SCA_RULE_ATTRIBUTES_ALL_TL T
927 where T.SCA_RULE_ATTRIBUTE_ID = B.SCA_RULE_ATTRIBUTE_ID
928 and T.LANGUAGE = L.LANGUAGE_CODE
929 and B.ORG_ID = T.ORG_ID -- MOAC Change
930 );
931 end ADD_LANGUAGE;
932
933 -- --------------------------------------------------------------------+
934 -- Procedure : LOAD_ROW
935 -- Description : Called by FNDLOAD to upload seed datas, this procedure
939 ( X_SCA_RULE_ATTRIBUTE_ID IN NUMBER,
936 -- only handle seed datas. ORG_ID = -3113
937 -- --------------------------------------------------------------------+
938 PROCEDURE LOAD_ROW
940 X_TRANSACTION_SOURCE in VARCHAR2,
941 X_SRC_COLUMN_NAME in VARCHAR2,
942 X_DATATYPE in VARCHAR2,
943 X_VALUE_SET_ID in NUMBER,
944 X_TRX_SRC_COLUMN_NAME in VARCHAR2,
945 X_ENABLED_FLAG in VARCHAR2,
946 X_USER_COLUMN_NAME IN VARCHAR2,
947 x_org_id IN NUMBER,
948 x_owner IN VARCHAR2) IS
949 user_id NUMBER;
950
951 BEGIN
952 -- Validate input data
953 IF (X_SCA_RULE_ATTRIBUTE_ID IS NULL) OR (X_USER_COLUMN_NAME IS NULL) THEN
954 GOTO end_load_row;
955 END IF;
956
957 IF (x_owner IS NOT NULL) AND (x_owner = 'SEED') THEN
958 user_id := 1;
959 ELSE
960 user_id := 0;
961 END IF;
962 -- Load The record to _B table
963 UPDATE cn_sca_rule_attributes_all_b SET
964 last_update_date = sysdate,
965 last_updated_by = user_id,
966 last_update_login = 0
967 WHERE sca_rule_attribute_id = X_SCA_RULE_ATTRIBUTE_id
968 AND org_id = x_org_id;
969
970 IF (SQL%NOTFOUND) THEN
971 -- Insert new record to _B table
972 INSERT INTO cn_sca_rule_attributes_all_b
973 ( SCA_RULE_ATTRIBUTE_ID,
974 TRANSACTION_SOURCE,
975 SRC_COLUMN_NAME,
976 DATATYPE,
977 VALUE_SET_ID,
978 TRX_SRC_COLUMN_NAME,
979 ENABLED_FLAG,
980 creation_date,
981 created_by,
982 last_update_date,
983 last_updated_by,
984 last_update_login,
985 org_id
986 ) VALUES
987 ( X_SCA_RULE_ATTRIBUTE_ID,
988 X_TRANSACTION_SOURCE,
989 X_SRC_COLUMN_NAME,
990 X_DATATYPE,
991 X_VALUE_SET_ID,
992 X_TRX_SRC_COLUMN_NAME,
993 X_ENABLED_FLAG,
994 sysdate,
995 user_id,
996 sysdate,
997 user_id,
998 0,
999 x_org_id
1000 );
1001 END IF;
1002 -- Load The record to _TL table
1003 UPDATE cn_sca_rule_attributes_all_tl SET
1004 USER_COLUMN_NAME = X_USER_COLUMN_NAME,
1005 last_update_date = sysdate,
1006 last_updated_by = user_id,
1007 last_update_login = 0,
1008 source_lang = userenv('LANG')
1009 WHERE sca_rule_attribute_id = x_sca_rule_attribute_id
1010 AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1011
1012 IF (SQL%NOTFOUND) THEN
1013 -- Insert new record to _TL table
1014 INSERT INTO cn_sca_rule_attributes_all_tl
1015 (sca_rule_attribute_id,
1016 USER_COLUMN_NAME,
1017 creation_date,
1018 created_by,
1019 last_update_date,
1020 last_updated_by,
1021 last_update_login,
1022 language,
1023 source_lang)
1024 SELECT
1025 x_sca_rule_attribute_id,
1026 X_USER_COLUMN_NAME,
1027 sysdate,
1028 user_id,
1029 sysdate,
1030 user_id,
1031 0,
1032 l.language_code,
1033 userenv('LANG')
1034 FROM fnd_languages l
1035 WHERE l.installed_flag IN ('I', 'B')
1036 AND NOT EXISTS
1037 (SELECT NULL
1038 FROM cn_sca_rule_attributes_all_tl t
1039 WHERE t.sca_rule_attribute_id = x_sca_rule_attribute_id
1040 AND t.language = l.language_code);
1041 END IF;
1042 << end_load_row >>
1043 NULL;
1044 END LOAD_ROW ;
1045
1046 -- --------------------------------------------------------------------+
1047 -- Procedure : TRANSLATE_ROW
1048 -- Description : Called by FNDLOAD to translate seed datas, this procedure
1049 -- only handle seed datas. ORG_ID = -3113
1050 -- --------------------------------------------------------------------+
1051 PROCEDURE TRANSLATE_ROW
1052 ( X_SCA_RULE_ATTRIBUTE_ID IN NUMBER,
1053 X_USER_COLUMN_NAME IN VARCHAR2,
1054 x_owner IN VARCHAR2) IS
1055 user_id NUMBER;
1056 BEGIN
1057 -- Validate input data
1058 IF (X_SCA_RULE_ATTRIBUTE_ID IS NULL) OR (X_USER_COLUMN_NAME IS NULL) THEN
1059 GOTO end_translate_row;
1060 END IF;
1061
1062 IF (x_owner IS NOT NULL) AND (x_owner = 'SEED') THEN
1063 user_id := 1;
1064 ELSE
1065 user_id := 0;
1066 END IF;
1067 -- Update the translation
1068 UPDATE cn_sca_rule_attributes_all_tl SET
1069 USER_COLUMN_NAME = X_USER_COLUMN_NAME,
1070 last_update_date = sysdate,
1071 last_updated_by = user_id,
1072 last_update_login = 0,
1073 source_lang = userenv('LANG')
1074 WHERE sca_rule_attribute_id = x_sca_rule_attribute_id
1075 AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1076
1077 << end_translate_row >>
1078 NULL;
1079 END TRANSLATE_ROW ;
1080
1081
1082 END CN_SCA_CRRULEATTR_PKG;