[Home] [Help]
PACKAGE BODY: APPS.ZX_CONDITION_GROUPS_PKG
Source
1 package body ZX_CONDITION_GROUPS_PKG as
2 /* $Header: zxdcondgroupsb.pls 120.11 2005/10/21 22:06:36 rsanthan ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out nocopy VARCHAR2,
6 X_CONDITION_GROUP_ID in NUMBER,
7 X_DETERMINING_FACTOR_CODE10 in VARCHAR2,
8 X_COUNTRY_CODE in VARCHAR2,
9 X_TAX_PARAMETER_CODE10 in VARCHAR2,
10 X_DATA_TYPE10_CODE in VARCHAR2,
11 X_DETERMINING_FACTOR_CLAS10_CO in VARCHAR2,
12 X_DETERMINING_FACTOR_CQ10_CODE in VARCHAR2,
13 X_OPERATOR10_CODE in VARCHAR2,
14 X_NUMERIC_VALUE10 in NUMBER,
15 X_DATE_VALUE10 in DATE,
16 X_ALPHANUMERIC_VALUE10 in VARCHAR2,
17 X_VALUE_LOW10 in VARCHAR2,
18 X_VALUE_HIGH10 in VARCHAR2,
19 X_Record_Type_CODE in VARCHAR2,
20 X_REQUEST_ID in NUMBER,
21 X_CONDITION_GROUP_CODE in VARCHAR2,
22 X_DET_FACTOR_TEMPL_CODE in VARCHAR2,
23 X_LEDGER_ID in NUMBER,
24 X_CHART_OF_ACCOUNTS_ID in NUMBER,
25 X_More_Than_Max_Cond_Flag in VARCHAR2,
26 X_Enabled_Flag in VARCHAR2,
27 X_DETERMINING_FACTOR_CODE1 in VARCHAR2,
28 X_TAX_PARAMETER_CODE1 in VARCHAR2,
29 X_DATA_TYPE1_CODE in VARCHAR2,
30 X_DETERMINING_FACTOR_CLASS1_CO in VARCHAR2,
31 X_DETERMINING_FACTOR_CQ1_CODE in VARCHAR2,
32 X_OPERATOR1_CODE in VARCHAR2,
33 X_NUMERIC_VALUE1 in NUMBER,
34 X_DATE_VALUE1 in DATE,
35 X_ALPHANUMERIC_VALUE1 in VARCHAR2,
36 X_VALUE_LOW1 in VARCHAR2,
37 X_VALUE_HIGH1 in VARCHAR2,
38 X_DETERMINING_FACTOR_CODE2 in VARCHAR2,
39 X_TAX_PARAMETER_CODE2 in VARCHAR2,
40 X_DATA_TYPE2_CODE in VARCHAR2,
41 X_DETERMINING_FACTOR_CLASS2_CO in VARCHAR2,
42 X_DETERMINING_FACTOR_CQ2_CODE in VARCHAR2,
43 X_OPERATOR2_CODE in VARCHAR2,
44 X_NUMERIC_VALUE2 in NUMBER,
45 X_DATE_VALUE2 in DATE,
46 X_ALPHANUMERIC_VALUE2 in VARCHAR2,
47 X_VALUE_LOW2 in VARCHAR2,
48 X_VALUE_HIGH2 in VARCHAR2,
49 X_DETERMINING_FACTOR_CODE3 in VARCHAR2,
50 X_TAX_PARAMETER_CODE3 in VARCHAR2,
51 X_DATA_TYPE3_CODE in VARCHAR2,
52 X_DETERMINING_FACTOR_CLASS3_CO in VARCHAR2,
53 X_DETERMINING_FACTOR_CQ3_CODE in VARCHAR2,
54 X_OPERATOR3_CODE in VARCHAR2,
55 X_NUMERIC_VALUE3 in NUMBER,
56 X_DATE_VALUE3 in DATE,
57 X_ALPHANUMERIC_VALUE3 in VARCHAR2,
58 X_VALUE_LOW3 in VARCHAR2,
59 X_VALUE_HIGH3 in VARCHAR2,
60 X_DETERMINING_FACTOR_CODE4 in VARCHAR2,
61 X_TAX_PARAMETER_CODE4 in VARCHAR2,
62 X_DATA_TYPE4_CODE in VARCHAR2,
63 X_DETERMINING_FACTOR_CLASS4_CO in VARCHAR2,
64 X_DETERMINING_FACTOR_CQ4_CODE in VARCHAR2,
65 X_OPERATOR4_CODE in VARCHAR2,
66 X_NUMERIC_VALUE4 in NUMBER,
67 X_DATE_VALUE4 in DATE,
68 X_ALPHANUMERIC_VALUE4 in VARCHAR2,
69 X_VALUE_LOW4 in VARCHAR2,
70 X_VALUE_HIGH4 in VARCHAR2,
71 X_DETERMINING_FACTOR_CODE5 in VARCHAR2,
72 X_TAX_PARAMETER_CODE5 in VARCHAR2,
73 X_data_Type5_CODE in VARCHAR2,
74 X_DETERMINING_FACTOR_CLASS5_CO in VARCHAR2,
75 X_DETERMINING_FACTOR_CQ5_CODE in VARCHAR2,
76 X_OPERATOR5_CODE in VARCHAR2,
77 X_NUMERIC_VALUE5 in NUMBER,
78 X_DATE_VALUE5 in DATE,
79 X_ALPHANUMERIC_VALUE5 in VARCHAR2,
80 X_VALUE_LOW5 in VARCHAR2,
81 X_VALUE_HIGH5 in VARCHAR2,
82 X_DETERMINING_FACTOR_CODE6 in VARCHAR2,
83 X_TAX_PARAMETER_CODE6 in VARCHAR2,
84 X_DATA_TYPE6_CODE in VARCHAR2,
85 X_DETERMINING_FACTOR_CLASS6_CO in VARCHAR2,
86 X_DETERMINING_FACTOR_CQ6_CODE in VARCHAR2,
87 X_OPERATOR6_CODE in VARCHAR2,
88 X_NUMERIC_VALUE6 in NUMBER,
89 X_DATE_VALUE6 in DATE,
90 X_ALPHANUMERIC_VALUE6 in VARCHAR2,
91 X_VALUE_LOW6 in VARCHAR2,
92 X_VALUE_HIGH6 in VARCHAR2,
93 X_DETERMINING_FACTOR_CODE7 in VARCHAR2,
94 X_TAX_PARAMETER_CODE7 in VARCHAR2,
95 X_DATA_TYPE7_CODE in VARCHAR2,
96 X_DETERMINING_FACTOR_CLASS7_CO in VARCHAR2,
97 X_DETERMINING_FACTOR_CQ7_CODE in VARCHAR2,
98 X_OPERATOR7_CODE in VARCHAR2,
99 X_NUMERIC_VALUE7 in NUMBER,
100 X_DATE_VALUE7 in DATE,
101 X_ALPHANUMERIC_VALUE7 in VARCHAR2,
102 X_VALUE_LOW7 in VARCHAR2,
103 X_VALUE_HIGH7 in VARCHAR2,
104 X_DETERMINING_FACTOR_CODE8 in VARCHAR2,
105 X_TAX_PARAMETER_CODE8 in VARCHAR2,
106 X_DATA_TYPE8_CODE in VARCHAR2,
107 X_DETERMINING_FACTOR_CLASS8_CO in VARCHAR2,
108 X_DETERMINING_FACTOR_CQ8_CODE in VARCHAR2,
109 X_OPERATOR8_CODE in VARCHAR2,
110 X_NUMERIC_VALUE8 in NUMBER,
111 X_DATE_VALUE8 in DATE,
112 X_ALPHANUMERIC_VALUE8 in VARCHAR2,
113 X_VALUE_LOW8 in VARCHAR2,
114 X_VALUE_HIGH8 in VARCHAR2,
115 X_DETERMINING_FACTOR_CODE9 in VARCHAR2,
116 X_TAX_PARAMETER_CODE9 in VARCHAR2,
117 X_DATA_TYPE9_CODE in VARCHAR2,
118 X_DETERMINING_FACTOR_CLASS9_CO in VARCHAR2,
119 X_DETERMINING_FACTOR_CQ9_CODE in VARCHAR2,
120 X_OPERATOR9_CODE in VARCHAR2,
121 X_NUMERIC_VALUE9 in NUMBER,
122 X_DATE_VALUE9 in DATE,
123 X_ALPHANUMERIC_VALUE9 in VARCHAR2,
124 X_VALUE_LOW9 in VARCHAR2,
125 X_VALUE_HIGH9 in VARCHAR2,
126 X_CONDITION_GROUP_NAME in VARCHAR2,
127 X_CONDITION_GROUP_DESC in VARCHAR2,
128 X_CREATION_DATE in DATE,
129 X_CREATED_BY in NUMBER,
130 X_LAST_UPDATE_DATE in DATE,
131 X_LAST_UPDATED_BY in NUMBER,
132 X_LAST_UPDATE_LOGIN in NUMBER,
133 X_PROGRAM_APPLICATION_ID in NUMBER,
134 X_PROGRAM_ID in NUMBER,
135 X_PROGRAM_LOGIN_ID in NUMBER,
136 X_CONSTRAINT_ID IN NUMBER,
137 X_OBJECT_VERSION_NUMBER in NUMBER) is
138 cursor C is select ROWID from ZX_CONDITION_GROUPS_B
139 where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID ;
140 begin
141 insert into ZX_CONDITION_GROUPS_B (
142 DETERMINING_FACTOR_CODE10,
143 COUNTRY_CODE,
144 TAX_PARAMETER_CODE10,
145 DATA_TYPE10_Code,
146 Determining_Factor_Clas10_Code,
147 DETERMINING_FACTOR_CQ10_Code,
148 OPERATOR10_Code,
149 NUMERIC_VALUE10,
150 DATE_VALUE10,
151 ALPHANUMERIC_VALUE10,
152 VALUE_LOW10,
153 VALUE_HIGH10,
154 Record_Type_Code,
155 REQUEST_ID,
156 CONDITION_GROUP_ID,
157 CONDITION_GROUP_CODE,
158 DET_FACTOR_TEMPL_CODE,
159 LEDGER_ID,
160 CHART_OF_ACCOUNTS_ID,
161 More_Than_Max_Cond_Flag,
162 Enabled_Flag,
163 DETERMINING_FACTOR_CODE1,
164 TAX_PARAMETER_CODE1,
165 DATA_TYPE1_Code,
166 Determining_Factor_Class1_Code,
167 DETERMINING_FACTOR_CQ1_Code,
168 OPERATOR1_Code,
169 NUMERIC_VALUE1,
170 DATE_VALUE1,
171 ALPHANUMERIC_VALUE1,
172 VALUE_LOW1,
173 VALUE_HIGH1,
174 DETERMINING_FACTOR_CODE2,
175 TAX_PARAMETER_CODE2,
176 DATA_TYPE2_Code,
177 Determining_Factor_Class2_Code,
178 DETERMINING_FACTOR_CQ2_Code,
179 OPERATOR2_Code,
180 NUMERIC_VALUE2,
181 DATE_VALUE2,
182 ALPHANUMERIC_VALUE2,
183 VALUE_LOW2,
184 VALUE_HIGH2,
185 DETERMINING_FACTOR_CODE3,
186 TAX_PARAMETER_CODE3,
187 DATA_TYPE3_Code,
188 Determining_Factor_Class3_Code,
189 DETERMINING_FACTOR_CQ3_Code,
190 OPERATOR3_Code,
191 NUMERIC_VALUE3,
192 DATE_VALUE3,
193 ALPHANUMERIC_VALUE3,
194 VALUE_LOW3,
195 VALUE_HIGH3,
196 DETERMINING_FACTOR_CODE4,
197 TAX_PARAMETER_CODE4,
198 DATA_TYPE4_Code,
199 Determining_Factor_Class4_Code,
200 DETERMINING_FACTOR_CQ4_Code,
201 OPERATOR4_Code,
202 NUMERIC_VALUE4,
203 DATE_VALUE4,
204 ALPHANUMERIC_VALUE4,
205 VALUE_LOW4,
206 VALUE_HIGH4,
207 DETERMINING_FACTOR_CODE5,
208 TAX_PARAMETER_CODE5,
209 DATA_TYPE5_Code,
210 Determining_Factor_Class5_Code,
211 DETERMINING_FACTOR_CQ5_Code,
212 OPERATOR5_Code,
213 NUMERIC_VALUE5,
214 DATE_VALUE5,
215 ALPHANUMERIC_VALUE5,
216 VALUE_LOW5,
217 VALUE_HIGH5,
218 DETERMINING_FACTOR_CODE6,
219 TAX_PARAMETER_CODE6,
220 DATA_TYPE6_Code,
221 Determining_Factor_Class6_Code,
222 DETERMINING_FACTOR_CQ6_Code,
223 OPERATOR6_Code,
224 NUMERIC_VALUE6,
225 DATE_VALUE6,
226 ALPHANUMERIC_VALUE6,
227 VALUE_LOW6,
228 VALUE_HIGH6,
229 DETERMINING_FACTOR_CODE7,
230 TAX_PARAMETER_CODE7,
231 DATA_TYPE7_Code,
232 Determining_Factor_Class7_Code,
233 DETERMINING_FACTOR_CQ7_Code,
234 OPERATOR7_Code,
235 NUMERIC_VALUE7,
236 DATE_VALUE7,
237 ALPHANUMERIC_VALUE7,
238 VALUE_LOW7,
239 VALUE_HIGH7,
240 DETERMINING_FACTOR_CODE8,
241 TAX_PARAMETER_CODE8,
242 DATA_TYPE8_Code,
243 Determining_Factor_Class8_Code,
244 DETERMINING_FACTOR_CQ8_Code,
245 OPERATOR8_Code,
246 NUMERIC_VALUE8,
247 DATE_VALUE8,
248 ALPHANUMERIC_VALUE8,
249 VALUE_LOW8,
250 VALUE_HIGH8,
251 DETERMINING_FACTOR_CODE9,
252 TAX_PARAMETER_CODE9,
253 DATA_TYPE9_Code,
254 Determining_Factor_Class9_Code,
255 DETERMINING_FACTOR_CQ9_Code,
256 OPERATOR9_Code,
257 NUMERIC_VALUE9,
258 DATE_VALUE9,
259 ALPHANUMERIC_VALUE9,
260 VALUE_LOW9,
261 VALUE_HIGH9,
262 CREATION_DATE,
263 CREATED_BY,
264 LAST_UPDATE_DATE,
265 LAST_UPDATED_BY,
266 LAST_UPDATE_LOGIN,
267 PROGRAM_APPLICATION_ID,
268 PROGRAM_ID,
269 PROGRAM_LOGIN_ID,
270 CONSTRAINT_ID,
271 OBJECT_VERSION_NUMBER )
272 values (
273 X_DETERMINING_FACTOR_CODE10,
274 X_COUNTRY_CODE,
275 X_TAX_PARAMETER_CODE10,
276 X_DATA_TYPE10_Code,
277 X_DETERMINING_FACTOR_CLAS10_CO,
278 X_DETERMINING_FACTOR_CQ10_Code,
279 X_OPERATOR10_Code,
280 X_NUMERIC_VALUE10,
281 X_DATE_VALUE10,
282 X_ALPHANUMERIC_VALUE10,
283 X_VALUE_LOW10,
284 X_VALUE_HIGH10,
285 X_Record_Type_Code,
286 X_REQUEST_ID,
287 X_CONDITION_GROUP_ID,
288 X_CONDITION_GROUP_CODE,
289 X_DET_FACTOR_TEMPL_CODE,
290 X_LEDGER_ID,
291 X_CHART_OF_ACCOUNTS_ID,
292 NVL(X_MORE_THAN_MAX_COND_FLAG,'N'),
293 NVL(X_ENABLED_FLAG,'N'),
294 X_DETERMINING_FACTOR_CODE1,
295 X_TAX_PARAMETER_CODE1,
296 X_DATA_TYPE1_Code,
297 X_DETERMINING_FACTOR_CLASS1_Co,
298 X_DETERMINING_FACTOR_CQ1_Code,
299 X_OPERATOR1_Code,
300 X_NUMERIC_VALUE1,
301 X_DATE_VALUE1,
302 X_ALPHANUMERIC_VALUE1,
303 X_VALUE_LOW1,
304 X_VALUE_HIGH1,
305 X_DETERMINING_FACTOR_CODE2,
306 X_TAX_PARAMETER_CODE2,
307 X_DATA_TYPE2_Code,
308 X_DETERMINING_FACTOR_CLASS2_Co,
309 X_DETERMINING_FACTOR_CQ2_Code,
310 X_OPERATOR2_Code,
311 X_NUMERIC_VALUE2,
312 X_DATE_VALUE2,
313 X_ALPHANUMERIC_VALUE2,
314 X_VALUE_LOW2,
315 X_VALUE_HIGH2,
316 X_DETERMINING_FACTOR_CODE3,
317 X_TAX_PARAMETER_CODE3,
318 X_DATA_TYPE3_Code,
319 X_DETERMINING_FACTOR_CLASS3_Co,
320 X_DETERMINING_FACTOR_CQ3_Code,
321 X_OPERATOR3_Code,
322 X_NUMERIC_VALUE3,
323 X_DATE_VALUE3,
324 X_ALPHANUMERIC_VALUE3,
325 X_VALUE_LOW3,
326 X_VALUE_HIGH3,
327 X_DETERMINING_FACTOR_CODE4,
328 X_TAX_PARAMETER_CODE4,
329 X_DATA_TYPE4_Code,
330 X_DETERMINING_FACTOR_CLASS4_Co,
331 X_DETERMINING_FACTOR_CQ4_Code,
332 X_OPERATOR4_Code,
333 X_NUMERIC_VALUE4,
334 X_DATE_VALUE4,
335 X_ALPHANUMERIC_VALUE4,
336 X_VALUE_LOW4,
337 X_VALUE_HIGH4,
338 X_DETERMINING_FACTOR_CODE5,
339 X_TAX_PARAMETER_CODE5,
340 X_data_Type5_Code,
341 X_DETERMINING_FACTOR_CLASS5_Co,
342 X_DETERMINING_FACTOR_CQ5_Code,
343 X_OPERATOR5_Code,
344 X_NUMERIC_VALUE5,
345 X_DATE_VALUE5,
346 X_ALPHANUMERIC_VALUE5,
347 X_VALUE_LOW5,
348 X_VALUE_HIGH5,
349 X_DETERMINING_FACTOR_CODE6,
350 X_TAX_PARAMETER_CODE6,
351 X_DATA_TYPE6_Code,
352 X_DETERMINING_FACTOR_CLASS6_Co,
353 X_DETERMINING_FACTOR_CQ6_Code,
354 X_OPERATOR6_Code,
355 X_NUMERIC_VALUE6,
356 X_DATE_VALUE6,
357 X_ALPHANUMERIC_VALUE6,
358 X_VALUE_LOW6,
359 X_VALUE_HIGH6,
360 X_DETERMINING_FACTOR_CODE7,
361 X_TAX_PARAMETER_CODE7,
362 X_DATA_TYPE7_Code,
363 X_DETERMINING_FACTOR_CLASS7_Co,
364 X_DETERMINING_FACTOR_CQ7_Code,
365 X_OPERATOR7_Code,
366 X_NUMERIC_VALUE7,
367 X_DATE_VALUE7,
368 X_ALPHANUMERIC_VALUE7,
369 X_VALUE_LOW7,
370 X_VALUE_HIGH7,
371 X_DETERMINING_FACTOR_CODE8,
372 X_TAX_PARAMETER_CODE8,
373 X_DATA_TYPE8_Code,
374 X_DETERMINING_FACTOR_CLASS8_Co,
375 X_DETERMINING_FACTOR_CQ8_Code,
376 X_OPERATOR8_Code,
377 X_NUMERIC_VALUE8,
378 X_DATE_VALUE8,
379 X_ALPHANUMERIC_VALUE8,
380 X_VALUE_LOW8,
381 X_VALUE_HIGH8,
382 X_DETERMINING_FACTOR_CODE9,
383 X_TAX_PARAMETER_CODE9,
387 X_OPERATOR9_Code,
384 X_DATA_TYPE9_Code,
385 X_DETERMINING_FACTOR_CLASS9_Co,
386 X_DETERMINING_FACTOR_CQ9_Code,
388 X_NUMERIC_VALUE9,
389 X_DATE_VALUE9,
390 X_ALPHANUMERIC_VALUE9,
391 X_VALUE_LOW9,
392 X_VALUE_HIGH9,
393 X_CREATION_DATE,
394 X_CREATED_BY,
395 X_LAST_UPDATE_DATE,
396 X_LAST_UPDATED_BY,
397 X_LAST_UPDATE_LOGIN,
398 X_PROGRAM_APPLICATION_ID,
399 X_PROGRAM_ID,
400 X_PROGRAM_LOGIN_ID,
401 X_CONSTRAINT_ID,
402 X_OBJECT_VERSION_NUMBER);
403 insert into ZX_CONDITION_GROUPS_TL (
404 CONDITION_GROUP_ID,
405 CONDITION_GROUP_NAME,
406 CONDITION_GROUP_DESC,
407 CREATION_DATE,
408 CREATED_BY,
409 LAST_UPDATE_DATE,
410 LAST_UPDATED_BY,
411 LAST_UPDATE_LOGIN,
412 LANGUAGE,
413 SOURCE_LANG)
414 select
415 X_CONDITION_GROUP_ID,
416 X_CONDITION_GROUP_NAME,
417 X_CONDITION_GROUP_DESC,
418 X_CREATION_DATE,
419 X_CREATED_BY,
420 X_LAST_UPDATE_DATE,
421 X_LAST_UPDATED_BY,
422 X_LAST_UPDATE_LOGIN,
423 L.LANGUAGE_CODE,
424 userenv('LANG')
425 from FND_LANGUAGES L
426 where L.INSTALLED_FLAG in ('I', 'B')
427 and not exists
428 (select NULL
429 from ZX_CONDITION_GROUPS_TL T
430 where T.CONDITION_GROUP_ID = X_CONDITION_GROUP_ID
431 and T.LANGUAGE = L.LANGUAGE_CODE);
432 open c;
433 fetch c into X_ROWID;
434 if (c%notfound) then
435 close c;
436 raise no_data_found;
437 end if;
438 close c;
439
440 EXCEPTION
441 WHEN OTHERS THEN
442 APP_EXCEPTION.RAISE_EXCEPTION;
443
444 end INSERT_ROW;
445
446 procedure LOCK_ROW (
447 X_CONDITION_GROUP_ID in NUMBER,
448 X_DETERMINING_FACTOR_CODE10 in VARCHAR2,
449 X_COUNTRY_CODE in VARCHAR2,
450 X_TAX_PARAMETER_CODE10 in VARCHAR2,
451 X_DATA_TYPE10_CODE in VARCHAR2,
452 X_DETERMINING_FACTOR_CLAS10_CO in VARCHAR2,
453 X_DETERMINING_FACTOR_CQ10_CODE in VARCHAR2,
454 X_OPERATOR10_CODE in VARCHAR2,
455 X_NUMERIC_VALUE10 in NUMBER,
456 X_DATE_VALUE10 in DATE,
457 X_ALPHANUMERIC_VALUE10 in VARCHAR2,
458 X_VALUE_LOW10 in VARCHAR2,
459 X_VALUE_HIGH10 in VARCHAR2,
460 X_Record_Type_CODE in VARCHAR2,
461 X_REQUEST_ID in NUMBER,
462 X_CONDITION_GROUP_CODE in VARCHAR2,
463 X_DET_FACTOR_TEMPL_CODE in VARCHAR2,
464 X_LEDGER_ID in NUMBER,
465 X_CHART_OF_ACCOUNTS_ID in NUMBER,
466 X_More_Than_Max_Cond_Flag in VARCHAR2,
467 X_Enabled_Flag in VARCHAR2,
468 X_DETERMINING_FACTOR_CODE1 in VARCHAR2,
469 X_TAX_PARAMETER_CODE1 in VARCHAR2,
470 X_DATA_TYPE1_CODE in VARCHAR2,
471 X_DETERMINING_FACTOR_CLASS1_CO in VARCHAR2,
472 X_DETERMINING_FACTOR_CQ1_CODE in VARCHAR2,
473 X_OPERATOR1_CODE in VARCHAR2,
474 X_NUMERIC_VALUE1 in NUMBER,
475 X_DATE_VALUE1 in DATE,
476 X_ALPHANUMERIC_VALUE1 in VARCHAR2,
477 X_VALUE_LOW1 in VARCHAR2,
478 X_VALUE_HIGH1 in VARCHAR2,
479 X_DETERMINING_FACTOR_CODE2 in VARCHAR2,
480 X_TAX_PARAMETER_CODE2 in VARCHAR2,
481 X_DATA_TYPE2_CODE in VARCHAR2,
482 X_DETERMINING_FACTOR_CLASS2_CO in VARCHAR2,
483 X_DETERMINING_FACTOR_CQ2_CODE in VARCHAR2,
484 X_OPERATOR2_CODE in VARCHAR2,
485 X_NUMERIC_VALUE2 in NUMBER,
486 X_DATE_VALUE2 in DATE,
487 X_ALPHANUMERIC_VALUE2 in VARCHAR2,
488 X_VALUE_LOW2 in VARCHAR2,
489 X_VALUE_HIGH2 in VARCHAR2,
490 X_DETERMINING_FACTOR_CODE3 in VARCHAR2,
491 X_TAX_PARAMETER_CODE3 in VARCHAR2,
492 X_DATA_TYPE3_CODE in VARCHAR2,
493 X_DETERMINING_FACTOR_CLASS3_CO in VARCHAR2,
494 X_DETERMINING_FACTOR_CQ3_CODE in VARCHAR2,
495 X_OPERATOR3_CODE in VARCHAR2,
496 X_NUMERIC_VALUE3 in NUMBER,
497 X_DATE_VALUE3 in DATE,
498 X_ALPHANUMERIC_VALUE3 in VARCHAR2,
499 X_VALUE_LOW3 in VARCHAR2,
500 X_VALUE_HIGH3 in VARCHAR2,
501 X_DETERMINING_FACTOR_CODE4 in VARCHAR2,
502 X_TAX_PARAMETER_CODE4 in VARCHAR2,
503 X_DATA_TYPE4_CODE in VARCHAR2,
504 X_DETERMINING_FACTOR_CLASS4_CO in VARCHAR2,
505 X_DETERMINING_FACTOR_CQ4_CODE in VARCHAR2,
506 X_OPERATOR4_CODE in VARCHAR2,
507 X_NUMERIC_VALUE4 in NUMBER,
508 X_DATE_VALUE4 in DATE,
509 X_ALPHANUMERIC_VALUE4 in VARCHAR2,
510 X_VALUE_LOW4 in VARCHAR2,
511 X_VALUE_HIGH4 in VARCHAR2,
512 X_DETERMINING_FACTOR_CODE5 in VARCHAR2,
513 X_TAX_PARAMETER_CODE5 in VARCHAR2,
514 X_data_Type5_CODE in VARCHAR2,
515 X_DETERMINING_FACTOR_CLASS5_CO in VARCHAR2,
516 X_DETERMINING_FACTOR_CQ5_CODE in VARCHAR2,
517 X_OPERATOR5_CODE in VARCHAR2,
518 X_NUMERIC_VALUE5 in NUMBER,
519 X_DATE_VALUE5 in DATE,
520 X_ALPHANUMERIC_VALUE5 in VARCHAR2,
521 X_VALUE_LOW5 in VARCHAR2,
522 X_VALUE_HIGH5 in VARCHAR2,
523 X_DETERMINING_FACTOR_CODE6 in VARCHAR2,
524 X_TAX_PARAMETER_CODE6 in VARCHAR2,
525 X_DATA_TYPE6_CODE in VARCHAR2,
526 X_DETERMINING_FACTOR_CLASS6_CO in VARCHAR2,
527 X_DETERMINING_FACTOR_CQ6_CODE in VARCHAR2,
528 X_OPERATOR6_CODE in VARCHAR2,
529 X_NUMERIC_VALUE6 in NUMBER,
530 X_DATE_VALUE6 in DATE,
531 X_ALPHANUMERIC_VALUE6 in VARCHAR2,
532 X_VALUE_LOW6 in VARCHAR2,
533 X_VALUE_HIGH6 in VARCHAR2,
534 X_DETERMINING_FACTOR_CODE7 in VARCHAR2,
535 X_TAX_PARAMETER_CODE7 in VARCHAR2,
536 X_DATA_TYPE7_CODE in VARCHAR2,
537 X_DETERMINING_FACTOR_CLASS7_CO in VARCHAR2,
538 X_DETERMINING_FACTOR_CQ7_CODE in VARCHAR2,
539 X_OPERATOR7_CODE in VARCHAR2,
540 X_NUMERIC_VALUE7 in NUMBER,
541 X_DATE_VALUE7 in DATE,
542 X_ALPHANUMERIC_VALUE7 in VARCHAR2,
543 X_VALUE_LOW7 in VARCHAR2,
544 X_VALUE_HIGH7 in VARCHAR2,
545 X_DETERMINING_FACTOR_CODE8 in VARCHAR2,
549 X_DETERMINING_FACTOR_CQ8_CODE in VARCHAR2,
546 X_TAX_PARAMETER_CODE8 in VARCHAR2,
547 X_DATA_TYPE8_CODE in VARCHAR2,
548 X_DETERMINING_FACTOR_CLASS8_CO in VARCHAR2,
550 X_OPERATOR8_CODE in VARCHAR2,
551 X_NUMERIC_VALUE8 in NUMBER,
552 X_DATE_VALUE8 in DATE,
553 X_ALPHANUMERIC_VALUE8 in VARCHAR2,
554 X_VALUE_LOW8 in VARCHAR2,
555 X_VALUE_HIGH8 in VARCHAR2,
556 X_DETERMINING_FACTOR_CODE9 in VARCHAR2,
557 X_TAX_PARAMETER_CODE9 in VARCHAR2,
558 X_DATA_TYPE9_CODE in VARCHAR2,
559 X_DETERMINING_FACTOR_CLASS9_CO in VARCHAR2,
560 X_DETERMINING_FACTOR_CQ9_CODE in VARCHAR2,
561 X_OPERATOR9_CODE in VARCHAR2,
562 X_NUMERIC_VALUE9 in NUMBER,
563 X_DATE_VALUE9 in DATE,
564 X_ALPHANUMERIC_VALUE9 in VARCHAR2,
565 X_VALUE_LOW9 in VARCHAR2,
566 X_VALUE_HIGH9 in VARCHAR2,
567 X_CONDITION_GROUP_NAME in VARCHAR2,
568 X_CONDITION_GROUP_DESC in VARCHAR2,
569 X_PROGRAM_APPLICATION_ID in NUMBER,
570 X_PROGRAM_ID in NUMBER,
571 X_PROGRAM_LOGIN_ID in NUMBER,
572 X_CONSTRAINT_ID IN NUMBER,
573 X_OBJECT_VERSION_NUMBER in NUMBER) is
574 cursor c is select
575 DETERMINING_FACTOR_CODE10,
576 COUNTRY_CODE,
577 TAX_PARAMETER_CODE10,
578 DATA_TYPE10_Code,
579 Determining_Factor_Clas10_Code,
580 DETERMINING_FACTOR_CQ10_Code,
581 OPERATOR10_Code,
582 NUMERIC_VALUE10,
583 DATE_VALUE10,
584 ALPHANUMERIC_VALUE10,
585 VALUE_LOW10,
586 VALUE_HIGH10,
590 DET_FACTOR_TEMPL_CODE,
587 Record_Type_Code,
588 REQUEST_ID,
589 CONDITION_GROUP_CODE,
591 LEDGER_ID,
592 CHART_OF_ACCOUNTS_ID,
593 More_Than_Max_Cond_Flag,
594 Enabled_Flag,
595 DETERMINING_FACTOR_CODE1,
596 TAX_PARAMETER_CODE1,
597 DATA_TYPE1_Code,
598 Determining_Factor_Class1_Code,
599 DETERMINING_FACTOR_CQ1_Code,
600 OPERATOR1_Code,
601 NUMERIC_VALUE1,
602 DATE_VALUE1,
603 ALPHANUMERIC_VALUE1,
604 VALUE_LOW1,
605 VALUE_HIGH1,
606 DETERMINING_FACTOR_CODE2,
607 TAX_PARAMETER_CODE2,
608 DATA_TYPE2_Code,
609 Determining_Factor_Class2_Code,
610 DETERMINING_FACTOR_CQ2_Code,
611 OPERATOR2_Code,
612 NUMERIC_VALUE2,
613 DATE_VALUE2,
614 ALPHANUMERIC_VALUE2,
615 VALUE_LOW2,
616 VALUE_HIGH2,
617 DETERMINING_FACTOR_CODE3,
618 TAX_PARAMETER_CODE3,
619 DATA_TYPE3_Code,
620 Determining_Factor_Class3_Code,
621 DETERMINING_FACTOR_CQ3_Code,
622 OPERATOR3_Code,
623 NUMERIC_VALUE3,
624 DATE_VALUE3,
625 ALPHANUMERIC_VALUE3,
626 VALUE_LOW3,
627 VALUE_HIGH3,
628 DETERMINING_FACTOR_CODE4,
629 TAX_PARAMETER_CODE4,
630 DATA_TYPE4_Code,
631 Determining_Factor_Class4_Code,
632 DETERMINING_FACTOR_CQ4_Code,
633 OPERATOR4_Code,
634 NUMERIC_VALUE4,
635 DATE_VALUE4,
636 ALPHANUMERIC_VALUE4,
637 VALUE_LOW4,
638 VALUE_HIGH4,
639 DETERMINING_FACTOR_CODE5,
640 TAX_PARAMETER_CODE5,
641 DATA_TYPE5_Code,
642 Determining_Factor_Class5_Code,
643 DETERMINING_FACTOR_CQ5_Code,
644 OPERATOR5_Code,
645 NUMERIC_VALUE5,
646 DATE_VALUE5,
647 ALPHANUMERIC_VALUE5,
648 VALUE_LOW5,
649 VALUE_HIGH5,
650 DETERMINING_FACTOR_CODE6,
651 TAX_PARAMETER_CODE6,
652 DATA_TYPE6_Code,
653 Determining_Factor_Class6_Code,
654 DETERMINING_FACTOR_CQ6_Code,
655 OPERATOR6_Code,
656 NUMERIC_VALUE6,
657 DATE_VALUE6,
658 ALPHANUMERIC_VALUE6,
659 VALUE_LOW6,
660 VALUE_HIGH6,
661 DETERMINING_FACTOR_CODE7,
662 TAX_PARAMETER_CODE7,
663 DATA_TYPE7_Code,
664 Determining_Factor_Class7_Code,
665 DETERMINING_FACTOR_CQ7_Code,
666 OPERATOR7_Code,
667 NUMERIC_VALUE7,
668 DATE_VALUE7,
669 ALPHANUMERIC_VALUE7,
670 VALUE_LOW7,
671 VALUE_HIGH7,
672 DETERMINING_FACTOR_CODE8,
673 TAX_PARAMETER_CODE8,
674 DATA_TYPE8_Code,
675 Determining_Factor_Class8_Code,
676 DETERMINING_FACTOR_CQ8_Code,
677 OPERATOR8_Code,
678 NUMERIC_VALUE8,
679 DATE_VALUE8,
680 ALPHANUMERIC_VALUE8,
681 VALUE_LOW8,
682 VALUE_HIGH8,
683 DETERMINING_FACTOR_CODE9,
684 TAX_PARAMETER_CODE9,
685 DATA_TYPE9_Code,
689 NUMERIC_VALUE9,
686 Determining_Factor_Class9_Code,
687 DETERMINING_FACTOR_CQ9_Code,
688 OPERATOR9_Code,
690 DATE_VALUE9,
691 ALPHANUMERIC_VALUE9,
692 VALUE_LOW9,
693 VALUE_HIGH9,
694 PROGRAM_APPLICATION_ID,
695 PROGRAM_ID,
696 PROGRAM_LOGIN_ID ,
697 CONSTRAINT_ID ,
698 OBJECT_VERSION_NUMBER
699 from ZX_CONDITION_GROUPS_B
700 where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID
701 for update of CONDITION_GROUP_ID nowait;
702 recinfo c%rowtype;
703 cursor c1 is select
704 CONDITION_GROUP_NAME,
705 CONDITION_GROUP_DESC,
706 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
707 from ZX_CONDITION_GROUPS_TL
708 where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID
709 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
710 for update of CONDITION_GROUP_ID nowait;
711 begin
712 open c;
713 fetch c into recinfo;
714 if (c%notfound) then
715 close c;
716 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
717 app_exception.raise_exception;
718 end if;
719 close c;
720 if ( ((recinfo.DETERMINING_FACTOR_CODE10 = X_DETERMINING_FACTOR_CODE10)
721 OR ((recinfo.DETERMINING_FACTOR_CODE10 is null) AND (X_DETERMINING_FACTOR_CODE10 is null)))
722 AND ((recinfo.TAX_PARAMETER_CODE10 = X_TAX_PARAMETER_CODE10)
723 OR ((recinfo.TAX_PARAMETER_CODE10 is null) AND (X_TAX_PARAMETER_CODE10 is null)))
724 AND ((recinfo.DATA_TYPE10_CODE = X_DATA_TYPE10_Code)
725 OR ((recinfo.DATA_TYPE10_CODE is null) AND (X_DATA_TYPE10_CODE is null)))
726 AND ((recinfo.Determining_Factor_Clas10_CODE = X_DETERMINING_FACTOR_CLAS10_CO)
727 OR ((recinfo.Determining_Factor_Clas10_CODE is null) AND (X_DETERMINING_FACTOR_CLAS10_CO is null)))
728 AND ((recinfo.DETERMINING_FACTOR_CQ10_CODE = X_DETERMINING_FACTOR_CQ10_Code)
729 OR ((recinfo.DETERMINING_FACTOR_CQ10_CODE is null) AND (X_DETERMINING_FACTOR_CQ10_CODE is null)))
730 AND ((recinfo.OPERATOR10_CODE = X_OPERATOR10_Code)
731 OR ((recinfo.OPERATOR10_CODE is null) AND (X_OPERATOR10_CODE is null)))
732 AND ((recinfo.NUMERIC_VALUE10 = X_NUMERIC_VALUE10)
733 OR ((recinfo.NUMERIC_VALUE10 is null) AND (X_NUMERIC_VALUE10 is null)))
734 AND ((recinfo.DATE_VALUE10 = X_DATE_VALUE10)
735 OR ((recinfo.DATE_VALUE10 is null) AND (X_DATE_VALUE10 is null)))
736 AND ((recinfo.ALPHANUMERIC_VALUE10 = X_ALPHANUMERIC_VALUE10)
737 OR ((recinfo.ALPHANUMERIC_VALUE10 is null) AND (X_ALPHANUMERIC_VALUE10 is null)))
738 AND ((recinfo.VALUE_LOW10 = X_VALUE_LOW10)
739 OR ((recinfo.VALUE_LOW10 is null) AND (X_VALUE_LOW10 is null)))
740 AND ((recinfo.VALUE_HIGH10 = X_VALUE_HIGH10)
741 OR ((recinfo.VALUE_HIGH10 is null) AND (X_VALUE_HIGH10 is null)))
742 AND ((recinfo.Record_Type_CODE = X_Record_Type_Code)
743 OR ((recinfo.Record_Type_CODE is null) AND (X_Record_Type_CODE is null)))
744 AND ((recinfo.REQUEST_ID = X_REQUEST_ID)
745 OR ((recinfo.REQUEST_ID is null) AND (X_REQUEST_ID is null)))
746 AND (recinfo.CONDITION_GROUP_CODE = X_CONDITION_GROUP_CODE)
747 AND (recinfo.DET_FACTOR_TEMPL_CODE = X_DET_FACTOR_TEMPL_CODE)
748 AND ((recinfo.LEDGER_ID = X_LEDGER_ID)
749 OR ((recinfo.LEDGER_ID is null) AND (X_LEDGER_ID is null)))
750 AND ((recinfo.CHART_OF_ACCOUNTS_ID = X_CHART_OF_ACCOUNTS_ID)
751 OR ((recinfo.CHART_OF_ACCOUNTS_ID is null) AND (X_CHART_OF_ACCOUNTS_ID is null)))
752 AND (recinfo.More_Than_Max_Cond_Flag = X_More_Than_Max_Cond_Flag)
756 OR ((recinfo.DETERMINING_FACTOR_CODE1 is null) AND (X_DETERMINING_FACTOR_CODE1 is null)))
753 AND ((recinfo.Enabled_Flag = X_Enabled_Flag)
754 OR ((recinfo.Enabled_Flag is null) AND (X_Enabled_Flag is null)))
755 AND ((recinfo.DETERMINING_FACTOR_CODE1 = X_DETERMINING_FACTOR_CODE1)
757 AND ((recinfo.COUNTRY_CODE = X_COUNTRY_CODE)
758 OR ((recinfo.COUNTRY_CODE is null) AND (X_COUNTRY_CODE is null)))
762 OR ((recinfo.DATA_TYPE1_CODE is null) AND (X_DATA_TYPE1_CODE is null)))
759 AND ((recinfo.TAX_PARAMETER_CODE1 = X_TAX_PARAMETER_CODE1)
760 OR ((recinfo.TAX_PARAMETER_CODE1 is null) AND (X_TAX_PARAMETER_CODE1 is null)))
761 AND ((recinfo.DATA_TYPE1_CODE = X_DATA_TYPE1_Code)
763 AND ((recinfo.Determining_Factor_Class1_CODE = X_DETERMINING_FACTOR_CLASS1_Co)
764 OR ((recinfo.Determining_Factor_Class1_CODE is null) AND (X_DETERMINING_FACTOR_CLASS1_CO is null)))
765 AND ((recinfo.DETERMINING_FACTOR_CQ1_CODE = X_DETERMINING_FACTOR_CQ1_Code)
766 OR ((recinfo.DETERMINING_FACTOR_CQ1_CODE is null) AND (X_DETERMINING_FACTOR_CQ1_CODE is null)))
767 AND ((recinfo.OPERATOR1_CODE = X_OPERATOR1_Code)
768 OR ((recinfo.OPERATOR1_CODE is null) AND (X_OPERATOR1_CODE is null)))
769 AND ((recinfo.NUMERIC_VALUE1 = X_NUMERIC_VALUE1)
770 OR ((recinfo.NUMERIC_VALUE1 is null) AND (X_NUMERIC_VALUE1 is null)))
771 AND ((recinfo.DATE_VALUE1 = X_DATE_VALUE1)
772 OR ((recinfo.DATE_VALUE1 is null) AND (X_DATE_VALUE1 is null)))
773 AND ((recinfo.ALPHANUMERIC_VALUE1 = X_ALPHANUMERIC_VALUE1)
774 OR ((recinfo.ALPHANUMERIC_VALUE1 is null) AND (X_ALPHANUMERIC_VALUE1 is null)))
775 AND ((recinfo.VALUE_LOW1 = X_VALUE_LOW1)
776 OR ((recinfo.VALUE_LOW1 is null) AND (X_VALUE_LOW1 is null)))
777 AND ((recinfo.VALUE_HIGH1 = X_VALUE_HIGH1)
778 OR ((recinfo.VALUE_HIGH1 is null) AND (X_VALUE_HIGH1 is null)))
779 AND ((recinfo.DETERMINING_FACTOR_CODE2 = X_DETERMINING_FACTOR_CODE2)
780 OR ((recinfo.DETERMINING_FACTOR_CODE2 is null) AND (X_DETERMINING_FACTOR_CODE2 is null)))
781 AND ((recinfo.TAX_PARAMETER_CODE2 = X_TAX_PARAMETER_CODE2)
782 OR ((recinfo.TAX_PARAMETER_CODE2 is null) AND (X_TAX_PARAMETER_CODE2 is null)))
783 AND ((recinfo.DATA_TYPE2_CODE = X_DATA_TYPE2_Code)
784 OR ((recinfo.DATA_TYPE2_CODE is null) AND (X_DATA_TYPE2_CODE is null)))
785 AND ((recinfo.Determining_Factor_Class2_CODE = X_DETERMINING_FACTOR_CLASS2_Co)
786 OR ((recinfo.Determining_Factor_Class2_CODE is null) AND (X_DETERMINING_FACTOR_CLASS2_CO is null)))
787 AND ((recinfo.DETERMINING_FACTOR_CQ2_CODE = X_DETERMINING_FACTOR_CQ2_Code)
788 OR ((recinfo.DETERMINING_FACTOR_CQ2_CODE is null) AND (X_DETERMINING_FACTOR_CQ2_CODE is null)))
789 AND ((recinfo.OPERATOR2_CODE = X_OPERATOR2_Code)
790 OR ((recinfo.OPERATOR2_CODE is null) AND (X_OPERATOR2_CODE is null)))
791 AND ((recinfo.NUMERIC_VALUE2 = X_NUMERIC_VALUE2)
792 OR ((recinfo.NUMERIC_VALUE2 is null) AND (X_NUMERIC_VALUE2 is null)))
793 AND ((recinfo.DATE_VALUE2 = X_DATE_VALUE2)
794 OR ((recinfo.DATE_VALUE2 is null) AND (X_DATE_VALUE2 is null)))
795 AND ((recinfo.ALPHANUMERIC_VALUE2 = X_ALPHANUMERIC_VALUE2)
796 OR ((recinfo.ALPHANUMERIC_VALUE2 is null) AND (X_ALPHANUMERIC_VALUE2 is null)))
797 AND ((recinfo.VALUE_LOW2 = X_VALUE_LOW2)
798 OR ((recinfo.VALUE_LOW2 is null) AND (X_VALUE_LOW2 is null)))
799 AND ((recinfo.VALUE_HIGH2 = X_VALUE_HIGH2)
800 OR ((recinfo.VALUE_HIGH2 is null) AND (X_VALUE_HIGH2 is null)))
801 AND ((recinfo.DETERMINING_FACTOR_CODE3 = X_DETERMINING_FACTOR_CODE3)
802 OR ((recinfo.DETERMINING_FACTOR_CODE3 is null) AND (X_DETERMINING_FACTOR_CODE3 is null)))
803 AND ((recinfo.TAX_PARAMETER_CODE3 = X_TAX_PARAMETER_CODE3)
804 OR ((recinfo.TAX_PARAMETER_CODE3 is null) AND (X_TAX_PARAMETER_CODE3 is null)))
805 AND ((recinfo.DATA_TYPE3_CODE = X_DATA_TYPE3_Code)
806 OR ((recinfo.DATA_TYPE3_CODE is null) AND (X_DATA_TYPE3_CODE is null)))
807 AND ((recinfo.Determining_Factor_Class3_CODE = X_DETERMINING_FACTOR_CLASS3_Co)
808 OR ((recinfo.Determining_Factor_Class3_CODE is null) AND (X_DETERMINING_FACTOR_CLASS3_CO is null)))
809 AND ((recinfo.DETERMINING_FACTOR_CQ3_CODE = X_DETERMINING_FACTOR_CQ3_Code)
810 OR ((recinfo.DETERMINING_FACTOR_CQ3_CODE is null) AND (X_DETERMINING_FACTOR_CQ3_CODE is null)))
811 AND ((recinfo.OPERATOR3_CODE = X_OPERATOR3_Code)
812 OR ((recinfo.OPERATOR3_CODE is null) AND (X_OPERATOR3_CODE is null)))
813 AND ((recinfo.NUMERIC_VALUE3 = X_NUMERIC_VALUE3)
814 OR ((recinfo.NUMERIC_VALUE3 is null) AND (X_NUMERIC_VALUE3 is null)))
815 AND ((recinfo.DATE_VALUE3 = X_DATE_VALUE3)
816 OR ((recinfo.DATE_VALUE3 is null) AND (X_DATE_VALUE3 is null)))
817 AND ((recinfo.ALPHANUMERIC_VALUE3 = X_ALPHANUMERIC_VALUE3)
818 OR ((recinfo.ALPHANUMERIC_VALUE3 is null) AND (X_ALPHANUMERIC_VALUE3 is null)))
819 AND ((recinfo.VALUE_LOW3 = X_VALUE_LOW3)
820 OR ((recinfo.VALUE_LOW3 is null) AND (X_VALUE_LOW3 is null)))
821 AND ((recinfo.VALUE_HIGH3 = X_VALUE_HIGH3)
822 OR ((recinfo.VALUE_HIGH3 is null) AND (X_VALUE_HIGH3 is null)))
823 AND ((recinfo.DETERMINING_FACTOR_CODE4 = X_DETERMINING_FACTOR_CODE4)
824 OR ((recinfo.DETERMINING_FACTOR_CODE4 is null) AND (X_DETERMINING_FACTOR_CODE4 is null)))
825 AND ((recinfo.TAX_PARAMETER_CODE4 = X_TAX_PARAMETER_CODE4)
826 OR ((recinfo.TAX_PARAMETER_CODE4 is null) AND (X_TAX_PARAMETER_CODE4 is null)))
827 AND ((recinfo.DATA_TYPE4_CODE = X_DATA_TYPE4_Code)
828 OR ((recinfo.DATA_TYPE4_CODE is null) AND (X_DATA_TYPE4_CODE is null)))
829 AND ((recinfo.Determining_Factor_Class4_CODE = X_DETERMINING_FACTOR_CLASS4_Co)
830 OR ((recinfo.Determining_Factor_Class4_CODE is null) AND (X_DETERMINING_FACTOR_CLASS4_CO is null)))
831 AND ((recinfo.DETERMINING_FACTOR_CQ4_CODE = X_DETERMINING_FACTOR_CQ4_Code)
832 OR ((recinfo.DETERMINING_FACTOR_CQ4_CODE is null) AND (X_DETERMINING_FACTOR_CQ4_CODE is null)))
833 AND ((recinfo.OPERATOR4_CODE = X_OPERATOR4_Code)
834 OR ((recinfo.OPERATOR4_CODE is null) AND (X_OPERATOR4_CODE is null)))
835 AND ((recinfo.NUMERIC_VALUE4 = X_NUMERIC_VALUE4)
836 OR ((recinfo.NUMERIC_VALUE4 is null) AND (X_NUMERIC_VALUE4 is null)))
837 AND ((recinfo.DATE_VALUE4 = X_DATE_VALUE4)
838 OR ((recinfo.DATE_VALUE4 is null) AND (X_DATE_VALUE4 is null)))
842 OR ((recinfo.VALUE_LOW4 is null) AND (X_VALUE_LOW4 is null)))
839 AND ((recinfo.ALPHANUMERIC_VALUE4 = X_ALPHANUMERIC_VALUE4)
840 OR ((recinfo.ALPHANUMERIC_VALUE4 is null) AND (X_ALPHANUMERIC_VALUE4 is null)))
841 AND ((recinfo.VALUE_LOW4 = X_VALUE_LOW4)
843 AND ((recinfo.VALUE_HIGH4 = X_VALUE_HIGH4)
844 OR ((recinfo.VALUE_HIGH4 is null) AND (X_VALUE_HIGH4 is null)))
845 AND ((recinfo.DETERMINING_FACTOR_CODE5 = X_DETERMINING_FACTOR_CODE5)
846 OR ((recinfo.DETERMINING_FACTOR_CODE5 is null) AND (X_DETERMINING_FACTOR_CODE5 is null)))
847 AND ((recinfo.TAX_PARAMETER_CODE5 = X_TAX_PARAMETER_CODE5)
848 OR ((recinfo.TAX_PARAMETER_CODE5 is null) AND (X_TAX_PARAMETER_CODE5 is null)))
849 AND ((recinfo.DATA_TYPE5_CODE = X_data_Type5_Code)
850 OR ((recinfo.DATA_TYPE5_CODE is null) AND (X_data_Type5_CODE is null)))
851 AND ((recinfo.Determining_Factor_Class5_CODE = X_DETERMINING_FACTOR_CLASS5_Co)
852 OR ((recinfo.Determining_Factor_Class5_CODE is null) AND (X_DETERMINING_FACTOR_CLASS5_CO is null)))
853 AND ((recinfo.DETERMINING_FACTOR_CQ5_CODE = X_DETERMINING_FACTOR_CQ5_Code)
854 OR ((recinfo.DETERMINING_FACTOR_CQ5_CODE is null) AND (X_DETERMINING_FACTOR_CQ5_CODE is null)))
855 AND ((recinfo.OPERATOR5_CODE = X_OPERATOR5_Code)
856 OR ((recinfo.OPERATOR5_CODE is null) AND (X_OPERATOR5_CODE is null)))
857 AND ((recinfo.NUMERIC_VALUE5 = X_NUMERIC_VALUE5)
858 OR ((recinfo.NUMERIC_VALUE5 is null) AND (X_NUMERIC_VALUE5 is null)))
859 AND ((recinfo.DATE_VALUE5 = X_DATE_VALUE5)
860 OR ((recinfo.DATE_VALUE5 is null) AND (X_DATE_VALUE5 is null)))
861 AND ((recinfo.ALPHANUMERIC_VALUE5 = X_ALPHANUMERIC_VALUE5)
862 OR ((recinfo.ALPHANUMERIC_VALUE5 is null) AND (X_ALPHANUMERIC_VALUE5 is null)))
863 AND ((recinfo.VALUE_LOW5 = X_VALUE_LOW5)
864 OR ((recinfo.VALUE_LOW5 is null) AND (X_VALUE_LOW5 is null)))
865 AND ((recinfo.VALUE_HIGH5 = X_VALUE_HIGH5)
866 OR ((recinfo.VALUE_HIGH5 is null) AND (X_VALUE_HIGH5 is null)))
867 AND ((recinfo.DETERMINING_FACTOR_CODE6 = X_DETERMINING_FACTOR_CODE6)
868 OR ((recinfo.DETERMINING_FACTOR_CODE6 is null) AND (X_DETERMINING_FACTOR_CODE6 is null)))
869 AND ((recinfo.TAX_PARAMETER_CODE6 = X_TAX_PARAMETER_CODE6)
870 OR ((recinfo.TAX_PARAMETER_CODE6 is null) AND (X_TAX_PARAMETER_CODE6 is null)))
871 AND ((recinfo.DATA_TYPE6_CODE = X_DATA_TYPE6_Code)
872 OR ((recinfo.DATA_TYPE6_CODE is null) AND (X_DATA_TYPE6_CODE is null)))
873 AND ((recinfo.Determining_Factor_Class6_CODE = X_DETERMINING_FACTOR_CLASS6_Co)
874 OR ((recinfo.Determining_Factor_Class6_CODE is null) AND (X_DETERMINING_FACTOR_CLASS6_CO is null)))
875 AND ((recinfo.DETERMINING_FACTOR_CQ6_CODE = X_DETERMINING_FACTOR_CQ6_Code)
876 OR ((recinfo.DETERMINING_FACTOR_CQ6_CODE is null) AND (X_DETERMINING_FACTOR_CQ6_CODE is null)))
877 AND ((recinfo.OPERATOR6_CODE = X_OPERATOR6_Code)
878 OR ((recinfo.OPERATOR6_CODE is null) AND (X_OPERATOR6_CODE is null)))
879 AND ((recinfo.NUMERIC_VALUE6 = X_NUMERIC_VALUE6)
880 OR ((recinfo.NUMERIC_VALUE6 is null) AND (X_NUMERIC_VALUE6 is null)))
881 AND ((recinfo.DATE_VALUE6 = X_DATE_VALUE6)
882 OR ((recinfo.DATE_VALUE6 is null) AND (X_DATE_VALUE6 is null)))
883 AND ((recinfo.ALPHANUMERIC_VALUE6 = X_ALPHANUMERIC_VALUE6)
884 OR ((recinfo.ALPHANUMERIC_VALUE6 is null) AND (X_ALPHANUMERIC_VALUE6 is null)))
885 AND ((recinfo.VALUE_LOW6 = X_VALUE_LOW6)
886 OR ((recinfo.VALUE_LOW6 is null) AND (X_VALUE_LOW6 is null)))
887 AND ((recinfo.VALUE_HIGH6 = X_VALUE_HIGH6)
888 OR ((recinfo.VALUE_HIGH6 is null) AND (X_VALUE_HIGH6 is null)))
889 AND ((recinfo.DETERMINING_FACTOR_CODE7 = X_DETERMINING_FACTOR_CODE7)
890 OR ((recinfo.DETERMINING_FACTOR_CODE7 is null) AND (X_DETERMINING_FACTOR_CODE7 is null)))
891 AND ((recinfo.TAX_PARAMETER_CODE7 = X_TAX_PARAMETER_CODE7)
892 OR ((recinfo.TAX_PARAMETER_CODE7 is null) AND (X_TAX_PARAMETER_CODE7 is null)))
893 AND ((recinfo.DATA_TYPE7_CODE = X_DATA_TYPE7_Code)
894 OR ((recinfo.DATA_TYPE7_CODE is null) AND (X_DATA_TYPE7_CODE is null)))
895 AND ((recinfo.Determining_Factor_Class7_CODE = X_DETERMINING_FACTOR_CLASS7_Co)
896 OR ((recinfo.Determining_Factor_Class7_CODE is null) AND (X_DETERMINING_FACTOR_CLASS7_CO is null)))
897 AND ((recinfo.DETERMINING_FACTOR_CQ7_CODE = X_DETERMINING_FACTOR_CQ7_Code)
898 OR ((recinfo.DETERMINING_FACTOR_CQ7_CODE is null) AND (X_DETERMINING_FACTOR_CQ7_CODE is null)))
899 AND ((recinfo.OPERATOR7_CODE = X_OPERATOR7_Code)
900 OR ((recinfo.OPERATOR7_CODE is null) AND (X_OPERATOR7_CODE is null)))
901 AND ((recinfo.NUMERIC_VALUE7 = X_NUMERIC_VALUE7)
902 OR ((recinfo.NUMERIC_VALUE7 is null) AND (X_NUMERIC_VALUE7 is null)))
903 AND ((recinfo.DATE_VALUE7 = X_DATE_VALUE7)
904 OR ((recinfo.DATE_VALUE7 is null) AND (X_DATE_VALUE7 is null)))
905 AND ((recinfo.ALPHANUMERIC_VALUE7 = X_ALPHANUMERIC_VALUE7)
906 OR ((recinfo.ALPHANUMERIC_VALUE7 is null) AND (X_ALPHANUMERIC_VALUE7 is null)))
907 AND ((recinfo.VALUE_LOW7 = X_VALUE_LOW7)
908 OR ((recinfo.VALUE_LOW7 is null) AND (X_VALUE_LOW7 is null)))
909 AND ((recinfo.VALUE_HIGH7 = X_VALUE_HIGH7)
910 OR ((recinfo.VALUE_HIGH7 is null) AND (X_VALUE_HIGH7 is null)))
911 AND ((recinfo.DETERMINING_FACTOR_CODE8 = X_DETERMINING_FACTOR_CODE8)
912 OR ((recinfo.DETERMINING_FACTOR_CODE8 is null) AND (X_DETERMINING_FACTOR_CODE8 is null)))
913 AND ((recinfo.TAX_PARAMETER_CODE8 = X_TAX_PARAMETER_CODE8)
914 OR ((recinfo.TAX_PARAMETER_CODE8 is null) AND (X_TAX_PARAMETER_CODE8 is null)))
915 AND ((recinfo.DATA_TYPE8_CODE = X_DATA_TYPE8_Code)
916 OR ((recinfo.DATA_TYPE8_CODE is null) AND (X_DATA_TYPE8_CODE is null)))
917 AND ((recinfo.Determining_Factor_Class8_CODE = X_DETERMINING_FACTOR_CLASS8_Co)
918 OR ((recinfo.Determining_Factor_Class8_CODE is null) AND (X_DETERMINING_FACTOR_CLASS8_CO is null)))
922 OR ((recinfo.OPERATOR8_CODE is null) AND (X_OPERATOR8_CODE is null)))
919 AND ((recinfo.DETERMINING_FACTOR_CQ8_CODE = X_DETERMINING_FACTOR_CQ8_Code)
920 OR ((recinfo.DETERMINING_FACTOR_CQ8_CODE is null) AND (X_DETERMINING_FACTOR_CQ8_CODE is null)))
921 AND ((recinfo.OPERATOR8_CODE = X_OPERATOR8_Code)
923 AND ((recinfo.NUMERIC_VALUE8 = X_NUMERIC_VALUE8)
924 OR ((recinfo.NUMERIC_VALUE8 is null) AND (X_NUMERIC_VALUE8 is null)))
925 AND ((recinfo.DATE_VALUE8 = X_DATE_VALUE8)
926 OR ((recinfo.DATE_VALUE8 is null) AND (X_DATE_VALUE8 is null)))
927 AND ((recinfo.ALPHANUMERIC_VALUE8 = X_ALPHANUMERIC_VALUE8)
928 OR ((recinfo.ALPHANUMERIC_VALUE8 is null) AND (X_ALPHANUMERIC_VALUE8 is null)))
929 AND ((recinfo.VALUE_LOW8 = X_VALUE_LOW8)
930 OR ((recinfo.VALUE_LOW8 is null) AND (X_VALUE_LOW8 is null)))
931 AND ((recinfo.VALUE_HIGH8 = X_VALUE_HIGH8)
932 OR ((recinfo.VALUE_HIGH8 is null) AND (X_VALUE_HIGH8 is null)))
933 AND ((recinfo.DETERMINING_FACTOR_CODE9 = X_DETERMINING_FACTOR_CODE9)
934 OR ((recinfo.DETERMINING_FACTOR_CODE9 is null) AND (X_DETERMINING_FACTOR_CODE9 is null)))
935 AND ((recinfo.TAX_PARAMETER_CODE9 = X_TAX_PARAMETER_CODE9)
936 OR ((recinfo.TAX_PARAMETER_CODE9 is null) AND (X_TAX_PARAMETER_CODE9 is null)))
937 AND ((recinfo.DATA_TYPE9_CODE = X_DATA_TYPE9_Code)
938 OR ((recinfo.DATA_TYPE9_CODE is null) AND (X_DATA_TYPE9_CODE is null)))
939 AND ((recinfo.Determining_Factor_Class9_CODE = X_DETERMINING_FACTOR_CLASS9_Co)
940 OR ((recinfo.Determining_Factor_Class9_CODE is null) AND (X_DETERMINING_FACTOR_CLASS9_CO is null)))
941 AND ((recinfo.DETERMINING_FACTOR_CQ9_CODE = X_DETERMINING_FACTOR_CQ9_Code)
942 OR ((recinfo.DETERMINING_FACTOR_CQ9_CODE is null) AND (X_DETERMINING_FACTOR_CQ9_CODE is null)))
943 AND ((recinfo.OPERATOR9_CODE = X_OPERATOR9_Code)
944 OR ((recinfo.OPERATOR9_CODE is null) AND (X_OPERATOR9_CODE is null)))
945 AND ((recinfo.NUMERIC_VALUE9 = X_NUMERIC_VALUE9)
946 OR ((recinfo.NUMERIC_VALUE9 is null) AND (X_NUMERIC_VALUE9 is null)))
947 AND ((recinfo.DATE_VALUE9 = X_DATE_VALUE9)
948 OR ((recinfo.DATE_VALUE9 is null) AND (X_DATE_VALUE9 is null)))
949 AND ((recinfo.ALPHANUMERIC_VALUE9 = X_ALPHANUMERIC_VALUE9)
950 OR ((recinfo.ALPHANUMERIC_VALUE9 is null) AND (X_ALPHANUMERIC_VALUE9 is null)))
951 AND ((recinfo.VALUE_LOW9 = X_VALUE_LOW9)
952 OR ((recinfo.VALUE_LOW9 is null) AND (X_VALUE_LOW9 is null)))
953 AND ((recinfo.VALUE_HIGH9 = X_VALUE_HIGH9)
954 OR ((recinfo.VALUE_HIGH9 is null) AND (X_VALUE_HIGH9 is null)))
955 AND ((recinfo.PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID)
956 OR ((recinfo.PROGRAM_APPLICATION_ID is null) AND (X_PROGRAM_APPLICATION_ID is null)))
957 AND ((recinfo. PROGRAM_ID = X_PROGRAM_ID)
958 OR ((recinfo.PROGRAM_ID is null) AND (X_PROGRAM_ID is null)))
959 AND ((recinfo.PROGRAM_LOGIN_ID = X_PROGRAM_LOGIN_ID)
960 OR ((recinfo.PROGRAM_LOGIN_ID is null) AND (X_PROGRAM_LOGIN_ID is null)))
961 AND ((recinfo.CONSTRAINT_ID = X_CONSTRAINT_ID)
962 OR ((recinfo.CONSTRAINT_ID is null) AND (X_CONSTRAINT_ID is null)))
963 AND (recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
964
965 ) then
966 null;
967 else
968 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
969 app_exception.raise_exception;
970 end if;
971 for tlinfo in c1 loop
972 if (tlinfo.BASELANG = 'Y') then
973 if ( (tlinfo.CONDITION_GROUP_NAME = X_CONDITION_GROUP_NAME)
974 AND ((tlinfo.CONDITION_GROUP_DESC = X_CONDITION_GROUP_DESC)
975 OR ((tlinfo.CONDITION_GROUP_DESC is null) AND (X_CONDITION_GROUP_DESC is null)))
976 ) then
977 null;
978 else
979 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
980 app_exception.raise_exception;
981 end if;
982 end if;
983 end loop;
984 return;
985
986 EXCEPTION
987 WHEN OTHERS THEN
988 APP_EXCEPTION.RAISE_EXCEPTION;
989
990 end LOCK_ROW;
991
992 procedure UPDATE_ROW (
993 X_CONDITION_GROUP_ID in NUMBER,
994 X_DETERMINING_FACTOR_CODE10 in VARCHAR2,
995 X_COUNTRY_CODE in VARCHAR2,
996 X_TAX_PARAMETER_CODE10 in VARCHAR2,
997 X_DATA_TYPE10_CODE in VARCHAR2,
998 X_DETERMINING_FACTOR_CLAS10_CO in VARCHAR2,
999 X_DETERMINING_FACTOR_CQ10_CODE in VARCHAR2,
1000 X_OPERATOR10_CODE in VARCHAR2,
1001 X_NUMERIC_VALUE10 in NUMBER,
1002 X_DATE_VALUE10 in DATE,
1003 X_ALPHANUMERIC_VALUE10 in VARCHAR2,
1004 X_VALUE_LOW10 in VARCHAR2,
1005 X_VALUE_HIGH10 in VARCHAR2,
1006 X_Record_Type_CODE in VARCHAR2,
1007 X_REQUEST_ID in NUMBER,
1008 X_CONDITION_GROUP_CODE in VARCHAR2,
1009 X_DET_FACTOR_TEMPL_CODE in VARCHAR2,
1010 X_LEDGER_ID in NUMBER,
1011 X_CHART_OF_ACCOUNTS_ID in NUMBER,
1012 X_More_Than_Max_Cond_Flag in VARCHAR2,
1013 X_Enabled_Flag in VARCHAR2,
1014 X_DETERMINING_FACTOR_CODE1 in VARCHAR2,
1015 X_TAX_PARAMETER_CODE1 in VARCHAR2,
1016 X_DATA_TYPE1_CODE in VARCHAR2,
1017 X_DETERMINING_FACTOR_CLASS1_CO in VARCHAR2,
1018 X_DETERMINING_FACTOR_CQ1_CODE in VARCHAR2,
1019 X_OPERATOR1_CODE in VARCHAR2,
1020 X_NUMERIC_VALUE1 in NUMBER,
1021 X_DATE_VALUE1 in DATE,
1022 X_ALPHANUMERIC_VALUE1 in VARCHAR2,
1023 X_VALUE_LOW1 in VARCHAR2,
1024 X_VALUE_HIGH1 in VARCHAR2,
1025 X_DETERMINING_FACTOR_CODE2 in VARCHAR2,
1026 X_TAX_PARAMETER_CODE2 in VARCHAR2,
1027 X_DATA_TYPE2_CODE in VARCHAR2,
1028 X_DETERMINING_FACTOR_CLASS2_CO in VARCHAR2,
1029 X_DETERMINING_FACTOR_CQ2_CODE in VARCHAR2,
1030 X_OPERATOR2_CODE in VARCHAR2,
1031 X_NUMERIC_VALUE2 in NUMBER,
1032 X_DATE_VALUE2 in DATE,
1033 X_ALPHANUMERIC_VALUE2 in VARCHAR2,
1034 X_VALUE_LOW2 in VARCHAR2,
1035 X_VALUE_HIGH2 in VARCHAR2,
1039 X_DETERMINING_FACTOR_CLASS3_CO in VARCHAR2,
1036 X_DETERMINING_FACTOR_CODE3 in VARCHAR2,
1037 X_TAX_PARAMETER_CODE3 in VARCHAR2,
1038 X_DATA_TYPE3_CODE in VARCHAR2,
1040 X_DETERMINING_FACTOR_CQ3_CODE in VARCHAR2,
1041 X_OPERATOR3_CODE in VARCHAR2,
1042 X_NUMERIC_VALUE3 in NUMBER,
1043 X_DATE_VALUE3 in DATE,
1044 X_ALPHANUMERIC_VALUE3 in VARCHAR2,
1045 X_VALUE_LOW3 in VARCHAR2,
1046 X_VALUE_HIGH3 in VARCHAR2,
1047 X_DETERMINING_FACTOR_CODE4 in VARCHAR2,
1048 X_TAX_PARAMETER_CODE4 in VARCHAR2,
1049 X_DATA_TYPE4_CODE in VARCHAR2,
1050 X_DETERMINING_FACTOR_CLASS4_CO in VARCHAR2,
1051 X_DETERMINING_FACTOR_CQ4_CODE in VARCHAR2,
1052 X_OPERATOR4_CODE in VARCHAR2,
1053 X_NUMERIC_VALUE4 in NUMBER,
1054 X_DATE_VALUE4 in DATE,
1055 X_ALPHANUMERIC_VALUE4 in VARCHAR2,
1056 X_VALUE_LOW4 in VARCHAR2,
1057 X_VALUE_HIGH4 in VARCHAR2,
1058 X_DETERMINING_FACTOR_CODE5 in VARCHAR2,
1059 X_TAX_PARAMETER_CODE5 in VARCHAR2,
1060 X_data_Type5_CODE in VARCHAR2,
1061 X_DETERMINING_FACTOR_CLASS5_CO in VARCHAR2,
1062 X_DETERMINING_FACTOR_CQ5_CODE in VARCHAR2,
1063 X_OPERATOR5_CODE in VARCHAR2,
1064 X_NUMERIC_VALUE5 in NUMBER,
1065 X_DATE_VALUE5 in DATE,
1066 X_ALPHANUMERIC_VALUE5 in VARCHAR2,
1067 X_VALUE_LOW5 in VARCHAR2,
1068 X_VALUE_HIGH5 in VARCHAR2,
1069 X_DETERMINING_FACTOR_CODE6 in VARCHAR2,
1070 X_TAX_PARAMETER_CODE6 in VARCHAR2,
1071 X_DATA_TYPE6_CODE in VARCHAR2,
1072 X_DETERMINING_FACTOR_CLASS6_CO in VARCHAR2,
1073 X_DETERMINING_FACTOR_CQ6_CODE in VARCHAR2,
1074 X_OPERATOR6_CODE in VARCHAR2,
1075 X_NUMERIC_VALUE6 in NUMBER,
1076 X_DATE_VALUE6 in DATE,
1077 X_ALPHANUMERIC_VALUE6 in VARCHAR2,
1078 X_VALUE_LOW6 in VARCHAR2,
1079 X_VALUE_HIGH6 in VARCHAR2,
1080 X_DETERMINING_FACTOR_CODE7 in VARCHAR2,
1081 X_TAX_PARAMETER_CODE7 in VARCHAR2,
1082 X_DATA_TYPE7_CODE in VARCHAR2,
1083 X_DETERMINING_FACTOR_CLASS7_CO in VARCHAR2,
1084 X_DETERMINING_FACTOR_CQ7_CODE in VARCHAR2,
1085 X_OPERATOR7_CODE in VARCHAR2,
1086 X_NUMERIC_VALUE7 in NUMBER,
1087 X_DATE_VALUE7 in DATE,
1088 X_ALPHANUMERIC_VALUE7 in VARCHAR2,
1089 X_VALUE_LOW7 in VARCHAR2,
1090 X_VALUE_HIGH7 in VARCHAR2,
1091 X_DETERMINING_FACTOR_CODE8 in VARCHAR2,
1092 X_TAX_PARAMETER_CODE8 in VARCHAR2,
1093 X_DATA_TYPE8_CODE in VARCHAR2,
1094 X_DETERMINING_FACTOR_CLASS8_CO in VARCHAR2,
1095 X_DETERMINING_FACTOR_CQ8_CODE in VARCHAR2,
1096 X_OPERATOR8_CODE in VARCHAR2,
1097 X_NUMERIC_VALUE8 in NUMBER,
1098 X_DATE_VALUE8 in DATE,
1099 X_ALPHANUMERIC_VALUE8 in VARCHAR2,
1100 X_VALUE_LOW8 in VARCHAR2,
1101 X_VALUE_HIGH8 in VARCHAR2,
1102 X_DETERMINING_FACTOR_CODE9 in VARCHAR2,
1103 X_TAX_PARAMETER_CODE9 in VARCHAR2,
1104 X_DATA_TYPE9_CODE in VARCHAR2,
1105 X_DETERMINING_FACTOR_CLASS9_CO in VARCHAR2,
1106 X_DETERMINING_FACTOR_CQ9_CODE in VARCHAR2,
1107 X_OPERATOR9_CODE in VARCHAR2,
1108 X_NUMERIC_VALUE9 in NUMBER,
1109 X_DATE_VALUE9 in DATE,
1110 X_ALPHANUMERIC_VALUE9 in VARCHAR2,
1111 X_VALUE_LOW9 in VARCHAR2,
1112 X_VALUE_HIGH9 in VARCHAR2,
1113 X_CONDITION_GROUP_NAME in VARCHAR2,
1114 X_CONDITION_GROUP_DESC in VARCHAR2,
1115 X_LAST_UPDATE_DATE in DATE,
1116 X_LAST_UPDATED_BY in NUMBER,
1117 X_LAST_UPDATE_LOGIN in NUMBER,
1118 X_PROGRAM_APPLICATION_ID in NUMBER,
1119 X_PROGRAM_ID in NUMBER,
1120 X_PROGRAM_LOGIN_ID in NUMBER,
1121 X_CONSTRAINT_ID IN NUMBER,
1122 X_OBJECT_VERSION_NUMBER in NUMBER) is
1123
1124 CURSOR C1 is
1125 SELECT Enabled_Flag
1126 FROM ZX_CONDITION_GROUPS_VL
1127 WHERE CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
1128
1129 CURSOR C_PROC_RES is
1130 SELECT TAX_RULE_ID,RESULT_ID
1131 FROM ZX_PROCESS_RESULTS
1132 WHERE Enabled_Flag = 'Y'
1133 AND CONDITION_GROUP_CODE = X_CONDITION_GROUP_CODE;
1134
1135 CURSOR C_RES_RULE_ID(p_cur_rule_id NUMBER, p_cur_result_id NUMBER) is
1136 SELECT TAX_RULE_ID
1137 FROM ZX_PROCESS_RESULTS
1138 WHERE TAX_RULE_ID = p_cur_rule_id and Enabled_Flag = 'Y'
1139 and RESULT_ID <> p_cur_result_id;
1140
1141 CURSOR C_RULE_REC (p_cur_rule_id1 NUMBER) is
1142 SELECT *
1143 FROM ZX_RULES_VL
1144 WHERE TAX_RULE_ID = p_cur_rule_id1;
1145
1146 p_rule_rec ZX_RULES_VL%ROWTYPE;
1147 p_rule_id1 NUMBER;
1148 p_Enabled_Flag VARCHAR2(1);
1149 p_rule_id NUMBER;
1150 p_result_id NUMBER;
1151 ctr NUMBER;
1152 begin
1153
1154 -- Logic to update ZX_PROCESS_RESULTS and ZX_RULES tables,
1155 -- to disable the associated results and rules
1156 OPEN C1;
1157 FETCH C1 INTO p_Enabled_Flag;
1158 CLOSE C1;
1159
1160 if p_Enabled_Flag = 'Y' and X_Enabled_Flag = 'N'then
1161 OPEN C_PROC_RES;
1162 LOOP
1163 FETCH C_PROC_RES into p_rule_id,p_result_id;
1164 EXIT WHEN C_PROC_RES%NOTFOUND;
1165 OPEN C_RES_RULE_ID(p_rule_id,p_result_id);
1166 FETCH C_RES_RULE_ID into p_rule_id1;
1167 if nvl(p_rule_id1,0) = 0 THEN
1168 OPEN C_RULE_REC(p_rule_id);
1169 LOOP
1170 FETCH C_RULE_REC INTO p_rule_rec;
1171 EXIT WHEN C_RULE_REC%NOTFOUND;
1172 ZX_RULES_PKG.UPDATE_ROW( p_rule_id,
1173 p_rule_rec.TAX_RULE_CODE ,
1174 p_rule_rec.TAX ,
1175 p_rule_rec.TAX_REGIME_CODE ,
1176 p_rule_rec.SERVICE_TYPE_CODE ,
1177 p_rule_rec.RECOVERY_TYPE_CODE ,
1178 p_rule_rec.PRIORITY ,
1179 p_rule_rec.System_Default_Flag ,
1180 p_rule_rec.EFFECTIVE_FROM ,
1181 p_rule_rec.EFFECTIVE_TO ,
1182 p_rule_rec.Record_Type_CODE ,
1183 p_rule_rec.REQUEST_ID ,
1184 p_rule_rec.TAX_RULE_NAME ,
1185 p_rule_rec.TAX_RULE_DESC ,
1186 p_rule_rec.LAST_UPDATE_DATE ,
1190 p_rule_rec.PROGRAM_ID ,
1187 p_rule_rec.LAST_UPDATED_BY ,
1188 p_rule_rec.LAST_UPDATE_LOGIN ,
1189 p_rule_rec.PROGRAM_APPLICATION_ID ,
1191 p_rule_rec.PROGRAM_LOGIN_ID ,
1192 'N',
1193 p_rule_rec.APPLICATION_ID ,
1194 p_rule_rec.CONTENT_OWNER_ID ,
1195 p_rule_rec.DET_FACTOR_TEMPL_CODE,
1196 p_rule_rec.EVENT_CLASS_MAPPING_ID,
1197 p_rule_rec.TAX_EVENT_CLASS_CODE ,
1198 p_rule_rec.OBJECT_VERSION_NUMBER,
1199 p_rule_rec.DETERMINING_FACTOR_CQ_CODE,
1200 p_rule_rec.GEOGRAPHY_TYPE ,
1201 p_rule_rec.GEOGRAPHY_ID ,
1202 p_rule_rec.TAX_LAW_REF_CODE ,
1203 p_rule_rec.TAX_LAW_REF_DESC ,
1204 p_rule_rec.LAST_UPDATE_MODE_FLAG ,
1205 p_rule_rec.NEVER_BEEN_ENABLED_FLAG
1206 );
1207 end loop;
1208 CLOSE C_RULE_REC;
1209 END IF;
1210 CLOSE C_RES_RULE_ID;
1211 END LOOP;
1212 CLOSE C_PROC_RES;
1213 UPDATE ZX_PROCESS_RESULTS SET Enabled_Flag = 'N'
1214 WHERE CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
1215 end if;
1216
1217 update ZX_CONDITION_GROUPS_B set
1218 DETERMINING_FACTOR_CODE10 = X_DETERMINING_FACTOR_CODE10,
1219 COUNTRY_CODE = X_COUNTRY_CODE,
1220 TAX_PARAMETER_CODE10 = X_TAX_PARAMETER_CODE10,
1221 DATA_TYPE10_CODE = X_DATA_TYPE10_Code,
1222 Determining_Factor_Clas10_CODE = X_DETERMINING_FACTOR_CLAS10_CO,
1223 DETERMINING_FACTOR_CQ10_CODE = X_DETERMINING_FACTOR_CQ10_Code,
1224 OPERATOR10_CODE = X_OPERATOR10_Code,
1225 NUMERIC_VALUE10 = X_NUMERIC_VALUE10,
1226 DATE_VALUE10 = X_DATE_VALUE10,
1227 ALPHANUMERIC_VALUE10 = X_ALPHANUMERIC_VALUE10,
1228 VALUE_LOW10 = X_VALUE_LOW10,
1229 VALUE_HIGH10 = X_VALUE_HIGH10,
1230 Record_Type_CODE = X_Record_Type_Code,
1231 REQUEST_ID = X_REQUEST_ID,
1232 CONDITION_GROUP_CODE = X_CONDITION_GROUP_CODE,
1233 DET_FACTOR_TEMPL_CODE = X_DET_FACTOR_TEMPL_CODE,
1234 LEDGER_ID = X_LEDGER_ID,
1235 CHART_OF_ACCOUNTS_ID = X_CHART_OF_ACCOUNTS_ID,
1236 More_Than_Max_Cond_Flag = NVL(X_MORE_THAN_MAX_COND_FLAG,'N'),
1237 Enabled_Flag = NVL(X_ENABLED_FLAG,'N'),
1238 DETERMINING_FACTOR_CODE1 = X_DETERMINING_FACTOR_CODE1,
1239 TAX_PARAMETER_CODE1 = X_TAX_PARAMETER_CODE1,
1240 DATA_TYPE1_CODE = X_DATA_TYPE1_Code,
1241 Determining_Factor_Class1_CODE = X_DETERMINING_FACTOR_CLASS1_Co,
1242 DETERMINING_FACTOR_CQ1_CODE = X_DETERMINING_FACTOR_CQ1_Code,
1243 OPERATOR1_CODE = X_OPERATOR1_Code,
1244 NUMERIC_VALUE1 = X_NUMERIC_VALUE1,
1245 DATE_VALUE1 = X_DATE_VALUE1,
1246 ALPHANUMERIC_VALUE1 = X_ALPHANUMERIC_VALUE1,
1247 VALUE_LOW1 = X_VALUE_LOW1,
1248 VALUE_HIGH1 = X_VALUE_HIGH1,
1249 DETERMINING_FACTOR_CODE2 = X_DETERMINING_FACTOR_CODE2,
1250 TAX_PARAMETER_CODE2 = X_TAX_PARAMETER_CODE2,
1251 DATA_TYPE2_CODE = X_DATA_TYPE2_Code,
1252 Determining_Factor_Class2_CODE = X_DETERMINING_FACTOR_CLASS2_Co,
1253 DETERMINING_FACTOR_CQ2_CODE = X_DETERMINING_FACTOR_CQ2_Code,
1254 OPERATOR2_CODE = X_OPERATOR2_Code,
1255 NUMERIC_VALUE2 = X_NUMERIC_VALUE2,
1256 DATE_VALUE2 = X_DATE_VALUE2,
1257 ALPHANUMERIC_VALUE2 = X_ALPHANUMERIC_VALUE2,
1258 VALUE_LOW2 = X_VALUE_LOW2,
1259 VALUE_HIGH2 = X_VALUE_HIGH2,
1260 DETERMINING_FACTOR_CODE3 = X_DETERMINING_FACTOR_CODE3,
1261 TAX_PARAMETER_CODE3 = X_TAX_PARAMETER_CODE3,
1262 DATA_TYPE3_CODE = X_DATA_TYPE3_Code,
1263 Determining_Factor_Class3_CODE = X_DETERMINING_FACTOR_CLASS3_Co,
1264 DETERMINING_FACTOR_CQ3_CODE = X_DETERMINING_FACTOR_CQ3_Code,
1265 OPERATOR3_CODE = X_OPERATOR3_Code,
1266 NUMERIC_VALUE3 = X_NUMERIC_VALUE3,
1267 DATE_VALUE3 = X_DATE_VALUE3,
1268 ALPHANUMERIC_VALUE3 = X_ALPHANUMERIC_VALUE3,
1269 VALUE_LOW3 = X_VALUE_LOW3,
1270 VALUE_HIGH3 = X_VALUE_HIGH3,
1271 DETERMINING_FACTOR_CODE4 = X_DETERMINING_FACTOR_CODE4,
1272 TAX_PARAMETER_CODE4 = X_TAX_PARAMETER_CODE4,
1273 DATA_TYPE4_CODE = X_DATA_TYPE4_Code,
1274 Determining_Factor_Class4_CODE = X_DETERMINING_FACTOR_CLASS4_Co,
1275 DETERMINING_FACTOR_CQ4_CODE = X_DETERMINING_FACTOR_CQ4_Code,
1276 OPERATOR4_CODE = X_OPERATOR4_Code,
1277 NUMERIC_VALUE4 = X_NUMERIC_VALUE4,
1278 DATE_VALUE4 = X_DATE_VALUE4,
1279 ALPHANUMERIC_VALUE4 = X_ALPHANUMERIC_VALUE4,
1280 VALUE_LOW4 = X_VALUE_LOW4,
1281 VALUE_HIGH4 = X_VALUE_HIGH4,
1282 DETERMINING_FACTOR_CODE5 = X_DETERMINING_FACTOR_CODE5,
1283 TAX_PARAMETER_CODE5 = X_TAX_PARAMETER_CODE5,
1284 DATA_TYPE5_CODE = X_data_Type5_Code,
1285 Determining_Factor_Class5_CODE = X_DETERMINING_FACTOR_CLASS5_Co,
1286 DETERMINING_FACTOR_CQ5_CODE = X_DETERMINING_FACTOR_CQ5_Code,
1287 OPERATOR5_CODE = X_OPERATOR5_Code,
1288 NUMERIC_VALUE5 = X_NUMERIC_VALUE5,
1289 DATE_VALUE5 = X_DATE_VALUE5,
1290 ALPHANUMERIC_VALUE5 = X_ALPHANUMERIC_VALUE5,
1291 VALUE_LOW5 = X_VALUE_LOW5,
1292 VALUE_HIGH5 = X_VALUE_HIGH5,
1293 DETERMINING_FACTOR_CODE6 = X_DETERMINING_FACTOR_CODE6,
1294 TAX_PARAMETER_CODE6 = X_TAX_PARAMETER_CODE6,
1295 DATA_TYPE6_CODE = X_DATA_TYPE6_Code,
1296 Determining_Factor_Class6_CODE = X_DETERMINING_FACTOR_CLASS6_Co,
1297 DETERMINING_FACTOR_CQ6_CODE = X_DETERMINING_FACTOR_CQ6_Code,
1298 OPERATOR6_CODE = X_OPERATOR6_Code,
1302 VALUE_LOW6 = X_VALUE_LOW6,
1299 NUMERIC_VALUE6 = X_NUMERIC_VALUE6,
1300 DATE_VALUE6 = X_DATE_VALUE6,
1301 ALPHANUMERIC_VALUE6 = X_ALPHANUMERIC_VALUE6,
1303 VALUE_HIGH6 = X_VALUE_HIGH6,
1304 DETERMINING_FACTOR_CODE7 = X_DETERMINING_FACTOR_CODE7,
1305 TAX_PARAMETER_CODE7 = X_TAX_PARAMETER_CODE7,
1306 DATA_TYPE7_CODE = X_DATA_TYPE7_Code,
1307 Determining_Factor_Class7_CODE = X_DETERMINING_FACTOR_CLASS7_Co,
1308 DETERMINING_FACTOR_CQ7_CODE = X_DETERMINING_FACTOR_CQ7_Code,
1309 OPERATOR7_CODE = X_OPERATOR7_Code,
1310 NUMERIC_VALUE7 = X_NUMERIC_VALUE7,
1311 DATE_VALUE7 = X_DATE_VALUE7,
1312 ALPHANUMERIC_VALUE7 = X_ALPHANUMERIC_VALUE7,
1313 VALUE_LOW7 = X_VALUE_LOW7,
1314 VALUE_HIGH7 = X_VALUE_HIGH7,
1315 DETERMINING_FACTOR_CODE8 = X_DETERMINING_FACTOR_CODE8,
1316 TAX_PARAMETER_CODE8 = X_TAX_PARAMETER_CODE8,
1317 DATA_TYPE8_CODE = X_DATA_TYPE8_Code,
1318 Determining_Factor_Class8_CODE = X_DETERMINING_FACTOR_CLASS8_Co,
1319 DETERMINING_FACTOR_CQ8_CODE = X_DETERMINING_FACTOR_CQ8_Code,
1320 OPERATOR8_CODE = X_OPERATOR8_Code,
1321 NUMERIC_VALUE8 = X_NUMERIC_VALUE8,
1322 DATE_VALUE8 = X_DATE_VALUE8,
1323 ALPHANUMERIC_VALUE8 = X_ALPHANUMERIC_VALUE8,
1324 VALUE_LOW8 = X_VALUE_LOW8,
1325 VALUE_HIGH8 = X_VALUE_HIGH8,
1326 DETERMINING_FACTOR_CODE9 = X_DETERMINING_FACTOR_CODE9,
1327 TAX_PARAMETER_CODE9 = X_TAX_PARAMETER_CODE9,
1328 DATA_TYPE9_CODE = X_DATA_TYPE9_Code,
1329 Determining_Factor_Class9_CODE = X_DETERMINING_FACTOR_CLASS9_Co,
1330 DETERMINING_FACTOR_CQ9_CODE = X_DETERMINING_FACTOR_CQ9_Code,
1331 OPERATOR9_CODE = X_OPERATOR9_Code,
1332 NUMERIC_VALUE9 = X_NUMERIC_VALUE9,
1333 DATE_VALUE9 = X_DATE_VALUE9,
1334 ALPHANUMERIC_VALUE9 = X_ALPHANUMERIC_VALUE9,
1335 VALUE_LOW9 = X_VALUE_LOW9,
1336 VALUE_HIGH9 = X_VALUE_HIGH9,
1337 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1338 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1339 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1340 PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
1341 PROGRAM_ID = X_PROGRAM_ID,
1342 PROGRAM_LOGIN_ID = X_PROGRAM_LOGIN_ID,
1343 CONSTRAINT_ID = X_CONSTRAINT_ID,
1344 OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
1345 where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
1346 if (sql%notfound) then
1347 raise no_data_found;
1348 end if;
1349 update ZX_CONDITION_GROUPS_TL set
1350 CONDITION_GROUP_NAME = X_CONDITION_GROUP_NAME,
1351 CONDITION_GROUP_DESC = X_CONDITION_GROUP_DESC,
1352 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1353 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1354 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1355 SOURCE_LANG = userenv('LANG')
1356 where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID
1357 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1358 if (sql%notfound) then
1359 raise no_data_found;
1360 end if;
1361
1362 EXCEPTION
1363 WHEN OTHERS THEN
1364 APP_EXCEPTION.RAISE_EXCEPTION;
1365
1366 end UPDATE_ROW;
1367
1368 procedure DELETE_ROW (
1369 X_CONDITION_GROUP_ID in NUMBER) is
1370 begin
1371 delete from ZX_CONDITION_GROUPS_TL
1372 where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
1373 if (sql%notfound) then
1374 raise no_data_found;
1375 end if;
1376 delete from ZX_CONDITION_GROUPS_B
1377 where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
1378 if (sql%notfound) then
1379 raise no_data_found;
1380 end if;
1381
1382 EXCEPTION
1383 WHEN OTHERS THEN
1384 APP_EXCEPTION.RAISE_EXCEPTION;
1385
1386 end DELETE_ROW;
1387
1388 procedure ADD_LANGUAGE
1389 is
1390 begin
1391 delete from ZX_CONDITION_GROUPS_TL T
1392 where not exists
1393 (select NULL
1394 from ZX_CONDITION_GROUPS_B B
1395 where B.CONDITION_GROUP_ID = T.CONDITION_GROUP_ID);
1396 update ZX_CONDITION_GROUPS_TL T set (
1397 CONDITION_GROUP_NAME,
1398 CONDITION_GROUP_DESC) = (select B.CONDITION_GROUP_NAME,
1399 B.CONDITION_GROUP_DESC
1400 from ZX_CONDITION_GROUPS_TL B
1401 where B.CONDITION_GROUP_ID = T.CONDITION_GROUP_ID
1402 and B.LANGUAGE = T.SOURCE_LANG)
1403 where (T.CONDITION_GROUP_ID, T.LANGUAGE) in
1404 (select SUBT.CONDITION_GROUP_ID,
1405 SUBT.LANGUAGE
1406 from ZX_CONDITION_GROUPS_TL SUBB, ZX_CONDITION_GROUPS_TL SUBT
1407 where SUBB.CONDITION_GROUP_ID = SUBT.CONDITION_GROUP_ID
1408 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1409 and (SUBB.CONDITION_GROUP_NAME <> SUBT.CONDITION_GROUP_NAME
1410 or SUBB.CONDITION_GROUP_DESC <> SUBT.CONDITION_GROUP_DESC
1411 or (SUBB.CONDITION_GROUP_DESC is null
1412 and SUBT.CONDITION_GROUP_DESC is not null)
1413 or (SUBB.CONDITION_GROUP_DESC is not null
1414 and SUBT.CONDITION_GROUP_DESC is null) ));
1415 insert into ZX_CONDITION_GROUPS_TL (
1416 CONDITION_GROUP_ID,
1417 CONDITION_GROUP_NAME,
1418 CONDITION_GROUP_DESC,
1419 CREATION_DATE,
1420 CREATED_BY,
1421 LAST_UPDATE_DATE,
1422 LAST_UPDATED_BY,
1423 LAST_UPDATE_LOGIN,
1424 LANGUAGE,
1425 SOURCE_LANG)
1426 select
1427 B.CONDITION_GROUP_ID,
1428 B.CONDITION_GROUP_NAME,
1429 B.CONDITION_GROUP_DESC,
1430 B.CREATION_DATE,
1431 B.CREATED_BY,
1432 B.LAST_UPDATE_DATE,
1433 B.LAST_UPDATED_BY,
1437 from ZX_CONDITION_GROUPS_TL B, FND_LANGUAGES L
1434 B.LAST_UPDATE_LOGIN,
1435 L.LANGUAGE_CODE,
1436 B.SOURCE_LANG
1438 where L.INSTALLED_FLAG in ('I', 'B')
1439 and B.LANGUAGE = userenv('LANG')
1440 and not exists
1441 (select NULL
1442 from ZX_CONDITION_GROUPS_TL T
1443 where T.CONDITION_GROUP_ID = B.CONDITION_GROUP_ID
1444 and T.LANGUAGE = L.LANGUAGE_CODE);
1445
1446 EXCEPTION
1447 WHEN OTHERS THEN
1448 APP_EXCEPTION.RAISE_EXCEPTION;
1449
1450 end ADD_LANGUAGE;
1451
1452 /*procedure bulk_insert_condition_groups (
1453 X_CONDITION_GROUP_ID IN t_condition_group_id,
1454 X_DETERMINING_FACTOR_CODE10 IN t_determining_factor_code,
1455 X_COUNTRY_CODE IN t_country_code,
1456 X_TAX_PARAMETER_CODE10 IN t_tax_parameter_code,
1457 X_DATA_TYPE10_CODE IN t_data_type,
1458 X_DETERMINING_FACTOR_CLAS10_CO IN t_determining_factor_class,
1459 X_DETERMINING_FACTOR_CQ10_CODE IN t_determining_factor_cq,
1460 X_OPERATOR10_CODE IN t_operator,
1461 X_NUMERIC_VALUE10 IN t_numeric_value,
1462 X_DATE_VALUE10 IN t_date_value,
1463 X_ALPHANUMERIC_VALUE10 IN t_alphanumeric_value,
1464 X_VALUE_LOW10 IN t_value_low,
1465 X_VALUE_HIGH10 IN t_value_high,
1466 X_Record_Type_CODE IN t_record_type,
1467 X_CONDITION_GROUP_CODE IN t_condition_group_code,
1468 X_DET_FACTOR_TEMPL_CODE IN t_det_factor_templ_code,
1469 X_APPLICATION_ID IN t_application_id,
1470 X_LEDGER_ID IN t_ledger_id,
1471 X_CHART_OF_ACCOUNTS_ID IN t_chart_of_accounts_id,
1472 X_More_Than_Max_Cond_Flag IN t_more_than_max_cond_flg,
1473 X_Enabled_Flag IN t_enabled_flg,
1474 X_DETERMINING_FACTOR_CODE1 IN t_determining_factor_code,
1475 X_TAX_PARAMETER_CODE1 IN t_tax_parameter_code,
1476 X_DATA_TYPE1_CODE IN t_data_type,
1477 X_DETERMINING_FACTOR_CLASS1_CO IN t_determining_factor_class,
1478 X_DETERMINING_FACTOR_CQ1_CODE IN t_determining_factor_cq,
1479 X_OPERATOR1_CODE IN t_operator,
1480 X_NUMERIC_VALUE1 IN t_numeric_value,
1481 X_DATE_VALUE1 IN t_date_value,
1482 X_ALPHANUMERIC_VALUE1 IN t_alphanumeric_value,
1483 X_VALUE_LOW1 IN t_value_low,
1484 X_VALUE_HIGH1 IN t_value_high,
1485 X_DETERMINING_FACTOR_CODE2 IN t_determining_factor_code,
1486 X_TAX_PARAMETER_CODE2 IN t_tax_parameter_code,
1487 X_DATA_TYPE2_CODE IN t_data_type,
1488 X_DETERMINING_FACTOR_CLASS2_CO IN t_determining_factor_class,
1489 X_DETERMINING_FACTOR_CQ2_CODE IN t_determining_factor_cq,
1490 X_OPERATOR2_CODE IN t_operator,
1491 X_NUMERIC_VALUE2 IN t_numeric_value,
1492 X_DATE_VALUE2 IN t_date_value,
1493 X_ALPHANUMERIC_VALUE2 IN t_alphanumeric_value,
1494 X_VALUE_LOW2 IN t_value_low,
1495 X_VALUE_HIGH2 IN t_value_high,
1496 X_DETERMINING_FACTOR_CODE3 IN t_determining_factor_code,
1497 X_TAX_PARAMETER_CODE3 IN t_tax_parameter_code,
1498 X_DATA_TYPE3_CODE IN t_data_type,
1499 X_DETERMINING_FACTOR_CLASS3_CO IN t_determining_factor_class,
1500 X_DETERMINING_FACTOR_CQ3_CODE IN t_determining_factor_cq,
1501 X_OPERATOR3_CODE IN t_operator,
1502 X_NUMERIC_VALUE3 IN t_numeric_value,
1503 X_DATE_VALUE3 IN t_date_value,
1504 X_ALPHANUMERIC_VALUE3 IN t_alphanumeric_value,
1505 X_VALUE_LOW3 IN t_value_low,
1506 X_VALUE_HIGH3 IN t_value_high,
1507 X_DETERMINING_FACTOR_CODE4 IN t_determining_factor_code,
1508 X_TAX_PARAMETER_CODE4 IN t_tax_parameter_code,
1509 X_DATA_TYPE4_CODE IN t_data_type,
1510 X_DETERMINING_FACTOR_CLASS4_CO IN t_determining_factor_class,
1511 X_DETERMINING_FACTOR_CQ4_CODE IN t_determining_factor_cq,
1512 X_OPERATOR4_CODE IN t_operator,
1513 X_NUMERIC_VALUE4 IN t_numeric_value,
1514 X_DATE_VALUE4 IN t_date_value,
1515 X_ALPHANUMERIC_VALUE4 IN t_alphanumeric_value,
1516 X_VALUE_LOW4 IN t_value_low,
1517 X_VALUE_HIGH4 IN t_value_high,
1518 X_DETERMINING_FACTOR_CODE5 IN t_determining_factor_code,
1519 X_TAX_PARAMETER_CODE5 IN t_tax_parameter_code,
1520 X_data_Type5_CODE IN t_data_type,
1521 X_DETERMINING_FACTOR_CLASS5_CO IN t_determining_factor_class,
1522 X_DETERMINING_FACTOR_CQ5_CODE IN t_determining_factor_cq,
1523 X_OPERATOR5_CODE IN t_operator,
1524 X_NUMERIC_VALUE5 IN t_numeric_value,
1525 X_DATE_VALUE5 IN t_date_value,
1526 X_ALPHANUMERIC_VALUE5 IN t_alphanumeric_value,
1527 X_VALUE_LOW5 IN t_value_low,
1528 X_VALUE_HIGH5 IN t_value_high,
1529 X_DETERMINING_FACTOR_CODE6 IN t_determining_factor_code,
1530 X_TAX_PARAMETER_CODE6 IN t_tax_parameter_code,
1531 X_DATA_TYPE6_CODE IN t_data_type,
1532 X_DETERMINING_FACTOR_CLASS6_CO IN t_determining_factor_class,
1533 X_DETERMINING_FACTOR_CQ6_CODE IN t_determining_factor_cq,
1534 X_OPERATOR6_CODE IN t_operator,
1535 X_NUMERIC_VALUE6 IN t_numeric_value,
1536 X_DATE_VALUE6 IN t_date_value,
1537 X_ALPHANUMERIC_VALUE6 IN t_alphanumeric_value,
1538 X_VALUE_LOW6 IN t_value_low,
1539 X_VALUE_HIGH6 IN t_value_high,
1540 X_DETERMINING_FACTOR_CODE7 IN t_determining_factor_code,
1541 X_TAX_PARAMETER_CODE7 IN t_tax_parameter_code,
1542 X_DATA_TYPE7_CODE IN t_data_type,
1543 X_DETERMINING_FACTOR_CLASS7_CO IN t_determining_factor_class,
1544 X_DETERMINING_FACTOR_CQ7_CODE IN t_determining_factor_cq,
1545 X_OPERATOR7_CODE IN t_operator,
1549 X_VALUE_LOW7 IN t_value_low,
1546 X_NUMERIC_VALUE7 IN t_numeric_value,
1547 X_DATE_VALUE7 IN t_date_value,
1548 X_ALPHANUMERIC_VALUE7 IN t_alphanumeric_value,
1550 X_VALUE_HIGH7 IN t_value_high,
1551 X_DETERMINING_FACTOR_CODE8 IN t_determining_factor_code,
1552 X_TAX_PARAMETER_CODE8 IN t_tax_parameter_code,
1553 X_DATA_TYPE8_CODE IN t_data_type,
1554 X_DETERMINING_FACTOR_CLASS8_CO IN t_determining_factor_class,
1555 X_DETERMINING_FACTOR_CQ8_CODE IN t_determining_factor_cq,
1556 X_OPERATOR8_CODE IN t_operator,
1557 X_NUMERIC_VALUE8 IN t_numeric_value,
1558 X_DATE_VALUE8 IN t_date_value,
1559 X_ALPHANUMERIC_VALUE8 IN t_alphanumeric_value,
1560 X_VALUE_LOW8 IN t_value_low,
1561 X_VALUE_HIGH8 IN t_value_high,
1562 X_DETERMINING_FACTOR_CODE9 IN t_determining_factor_code,
1563 X_TAX_PARAMETER_CODE9 IN t_tax_parameter_code,
1564 X_DATA_TYPE9_CODE IN t_data_type,
1565 X_DETERMINING_FACTOR_CLASS9_CO IN t_determining_factor_class,
1566 X_DETERMINING_FACTOR_CQ9_CODE IN t_determining_factor_cq,
1567 X_OPERATOR9_CODE IN t_operator,
1568 X_NUMERIC_VALUE9 IN t_numeric_value,
1569 X_DATE_VALUE9 IN t_date_value,
1570 X_ALPHANUMERIC_VALUE9 IN t_alphanumeric_value,
1571 X_VALUE_LOW9 IN t_value_low,
1572 X_VALUE_HIGH9 IN t_value_high,
1573 X_CONDITION_GROUP_NAME IN t_condition_group_name,
1574 X_CONDITION_GROUP_DESC IN t_condition_group_desc) is
1575
1576 begin
1577
1578 If x_condition_group_id.count <> 0 then
1579 forall i in x_condition_group_id.first..x_condition_group_id.last
1580 INSERT INTO ZX_CONDITION_GROUPS_B (
1581 DETERMINING_FACTOR_CODE10,
1582 COUNTRY_CODE,
1583 TAX_PARAMETER_CODE10,
1584 DATA_TYPE10_Code,
1585 Determining_Factor_Clas10_Code,
1586 DETERMINING_FACTOR_CQ10_Code,
1587 OPERATOR10_Code,
1588 NUMERIC_VALUE10,
1589 DATE_VALUE10,
1590 ALPHANUMERIC_VALUE10,
1591 VALUE_LOW10,
1592 VALUE_HIGH10,
1593 Record_Type_Code,
1594 CONDITION_GROUP_ID,
1595 CONDITION_GROUP_CODE,
1596 DET_FACTOR_TEMPL_CODE,
1597 APPLICATION_ID,
1598 LEDGER_ID,
1599 CHART_OF_ACCOUNTS_ID,
1600 More_Than_Max_Cond_Flag,
1601 Enabled_Flag,
1602 DETERMINING_FACTOR_CODE1,
1603 TAX_PARAMETER_CODE1,
1604 DATA_TYPE1_Code,
1605 Determining_Factor_Class1_Code,
1606 DETERMINING_FACTOR_CQ1_Code,
1607 OPERATOR1_Code,
1608 NUMERIC_VALUE1,
1609 DATE_VALUE1,
1610 ALPHANUMERIC_VALUE1,
1611 VALUE_LOW1,
1612 VALUE_HIGH1,
1613 DETERMINING_FACTOR_CODE2,
1614 TAX_PARAMETER_CODE2,
1615 DATA_TYPE2_Code,
1616 Determining_Factor_Class2_Code,
1617 DETERMINING_FACTOR_CQ2_Code,
1618 OPERATOR2_Code,
1619 NUMERIC_VALUE2,
1620 DATE_VALUE2,
1621 ALPHANUMERIC_VALUE2,
1622 VALUE_LOW2,
1623 VALUE_HIGH2,
1624 DETERMINING_FACTOR_CODE3,
1625 TAX_PARAMETER_CODE3,
1626 DATA_TYPE3_Code,
1627 Determining_Factor_Class3_Code,
1628 DETERMINING_FACTOR_CQ3_Code,
1629 OPERATOR3_Code,
1630 NUMERIC_VALUE3,
1631 DATE_VALUE3,
1632 ALPHANUMERIC_VALUE3,
1633 VALUE_LOW3,
1634 VALUE_HIGH3,
1635 DETERMINING_FACTOR_CODE4,
1636 TAX_PARAMETER_CODE4,
1637 DATA_TYPE4_Code,
1638 Determining_Factor_Class4_Code,
1639 DETERMINING_FACTOR_CQ4_Code,
1640 OPERATOR4_Code,
1641 NUMERIC_VALUE4,
1642 DATE_VALUE4,
1643 ALPHANUMERIC_VALUE4,
1644 VALUE_LOW4,
1645 VALUE_HIGH4,
1646 DETERMINING_FACTOR_CODE5,
1647 TAX_PARAMETER_CODE5,
1648 DATA_TYPE5_Code,
1649 Determining_Factor_Class5_Code,
1650 DETERMINING_FACTOR_CQ5_Code,
1651 OPERATOR5_Code,
1652 NUMERIC_VALUE5,
1653 DATE_VALUE5,
1654 ALPHANUMERIC_VALUE5,
1655 VALUE_LOW5,
1656 VALUE_HIGH5,
1657 DETERMINING_FACTOR_CODE6,
1658 TAX_PARAMETER_CODE6,
1659 DATA_TYPE6_Code,
1660 Determining_Factor_Class6_Code,
1661 DETERMINING_FACTOR_CQ6_Code,
1662 OPERATOR6_Code,
1663 NUMERIC_VALUE6,
1664 DATE_VALUE6,
1665 ALPHANUMERIC_VALUE6,
1666 VALUE_LOW6,
1667 VALUE_HIGH6,
1668 DETERMINING_FACTOR_CODE7,
1669 TAX_PARAMETER_CODE7,
1670 DATA_TYPE7_Code,
1671 Determining_Factor_Class7_Code,
1672 DETERMINING_FACTOR_CQ7_Code,
1673 OPERATOR7_Code,
1674 NUMERIC_VALUE7,
1675 DATE_VALUE7,
1676 ALPHANUMERIC_VALUE7,
1677 VALUE_LOW7,
1681 DATA_TYPE8_Code,
1678 VALUE_HIGH7,
1679 DETERMINING_FACTOR_CODE8,
1680 TAX_PARAMETER_CODE8,
1682 Determining_Factor_Class8_Code,
1683 DETERMINING_FACTOR_CQ8_Code,
1684 OPERATOR8_Code,
1685 NUMERIC_VALUE8,
1686 DATE_VALUE8,
1687 ALPHANUMERIC_VALUE8,
1688 VALUE_LOW8,
1689 VALUE_HIGH8,
1690 DETERMINING_FACTOR_CODE9,
1691 TAX_PARAMETER_CODE9,
1692 DATA_TYPE9_Code,
1693 Determining_Factor_Class9_Code,
1694 DETERMINING_FACTOR_CQ9_Code,
1695 OPERATOR9_Code,
1696 NUMERIC_VALUE9,
1697 DATE_VALUE9,
1698 ALPHANUMERIC_VALUE9,
1699 VALUE_LOW9,
1700 VALUE_HIGH9,
1701 CREATED_BY ,
1702 CREATION_DATE ,
1703 LAST_UPDATED_BY ,
1704 LAST_UPDATE_DATE ,
1705 LAST_UPDATE_LOGIN ,
1706 REQUEST_ID ,
1707 PROGRAM_APPLICATION_ID ,
1708 PROGRAM_ID ,
1709 PROGRAM_LOGIN_ID)
1710 values ( X_DETERMINING_FACTOR_CODE10(i),
1711 X_COUNTRY_CODE(i),
1712 X_TAX_PARAMETER_CODE10(i),
1713 X_DATA_TYPE10_Code(i),
1714 X_Determining_Factor_Clas10_Co(i),
1715 X_DETERMINING_FACTOR_CQ10_Code(i),
1716 X_OPERATOR10_Code(i),
1717 X_NUMERIC_VALUE10(i),
1718 X_DATE_VALUE10(i),
1719 X_ALPHANUMERIC_VALUE10(i),
1720 X_VALUE_LOW10(i),
1721 X_VALUE_HIGH10(i),
1722 X_Record_Type_Code(i),
1723 X_CONDITION_GROUP_ID(i),
1724 X_CONDITION_GROUP_CODE(i),
1725 X_DET_FACTOR_TEMPL_CODE(i),
1726 X_APPLICATION_ID(i),
1727 X_LEDGER_ID(i),
1728 X_CHART_OF_ACCOUNTS_ID(i),
1729 NVL(X_More_Than_Max_Cond_Flag(i),'N'),
1730 NVL(X_Enabled_Flag(i),'N'),
1731 X_DETERMINING_FACTOR_CODE1(i),
1732 X_TAX_PARAMETER_CODE1(i),
1733 X_DATA_TYPE1_Code(i),
1734 X_DETERMINING_FACTOR_CLASS1_Co(i),
1735 X_DETERMINING_FACTOR_CQ1_Code(i),
1736 X_OPERATOR1_Code(i),
1737 X_NUMERIC_VALUE1(i),
1738 X_DATE_VALUE1(i),
1739 X_ALPHANUMERIC_VALUE1(i),
1740 X_VALUE_LOW1(i),
1741 X_VALUE_HIGH1(i),
1742 X_DETERMINING_FACTOR_CODE2(i),
1743 X_TAX_PARAMETER_CODE2(i),
1744 X_DATA_TYPE2_Code(i),
1745 X_DETERMINING_FACTOR_CLASS2_Co(i),
1746 X_DETERMINING_FACTOR_CQ2_Code(i),
1747 X_OPERATOR2_Code(i),
1748 X_NUMERIC_VALUE2(i),
1749 X_DATE_VALUE2(i),
1750 X_ALPHANUMERIC_VALUE2(i),
1751 X_VALUE_LOW2(i),
1752 X_VALUE_HIGH2(i),
1753 X_DETERMINING_FACTOR_CODE3(i),
1754 X_TAX_PARAMETER_CODE3(i),
1755 X_DATA_TYPE3_Code(i),
1756 X_DETERMINING_FACTOR_CLASS3_Co(i),
1757 X_DETERMINING_FACTOR_CQ3_Code(i),
1758 X_OPERATOR3_Code(i),
1759 X_NUMERIC_VALUE3(i),
1760 X_DATE_VALUE3(i),
1761 X_ALPHANUMERIC_VALUE3(i),
1762 X_VALUE_LOW3(i),
1763 X_VALUE_HIGH3(i),
1764 X_DETERMINING_FACTOR_CODE4(i),
1765 X_TAX_PARAMETER_CODE4(i),
1766 X_DATA_TYPE4_Code(i),
1767 X_DETERMINING_FACTOR_CLASS4_Co(i),
1768 X_DETERMINING_FACTOR_CQ4_Code(i),
1769 X_OPERATOR4_Code(i),
1770 X_NUMERIC_VALUE4(i),
1771 X_DATE_VALUE4(i),
1772 X_ALPHANUMERIC_VALUE4(i),
1773 X_VALUE_LOW4(i),
1774 X_VALUE_HIGH4(i),
1775 X_DETERMINING_FACTOR_CODE5(i),
1776 X_TAX_PARAMETER_CODE5(i),
1777 X_data_Type5_Code(i),
1778 X_DETERMINING_FACTOR_CLASS5_Co(i),
1779 X_DETERMINING_FACTOR_CQ5_Code(i),
1780 X_OPERATOR5_Code(i),
1781 X_NUMERIC_VALUE5(i),
1782 X_DATE_VALUE5(i),
1783 X_ALPHANUMERIC_VALUE5(i),
1784 X_VALUE_LOW5(i),
1785 X_VALUE_HIGH5(i),
1786 X_DETERMINING_FACTOR_CODE6(i),
1787 X_TAX_PARAMETER_CODE6(i),
1788 X_DATA_TYPE6_Code(i),
1789 X_DETERMINING_FACTOR_CLASS6_Co(i),
1790 X_DETERMINING_FACTOR_CQ6_Code(i),
1791 X_OPERATOR6_Code(i),
1792 X_NUMERIC_VALUE6(i),
1793 X_DATE_VALUE6(i),
1794 X_ALPHANUMERIC_VALUE6(i),
1795 X_VALUE_LOW6(i),
1796 X_VALUE_HIGH6(i),
1797 X_DETERMINING_FACTOR_CODE7(i),
1798 X_TAX_PARAMETER_CODE7(i),
1799 X_DATA_TYPE7_Code(i),
1800 X_DETERMINING_FACTOR_CLASS7_Co(i),
1801 X_DETERMINING_FACTOR_CQ7_Code(i),
1802 X_OPERATOR7_Code(i),
1803 X_NUMERIC_VALUE7(i),
1804 X_DATE_VALUE7(i),
1805 X_ALPHANUMERIC_VALUE7(i),
1806 X_VALUE_LOW7(i),
1807 X_VALUE_HIGH7(i),
1811 X_DETERMINING_FACTOR_CLASS8_Co(i),
1808 X_DETERMINING_FACTOR_CODE8(i),
1809 X_TAX_PARAMETER_CODE8(i),
1810 X_DATA_TYPE8_Code(i),
1812 X_DETERMINING_FACTOR_CQ8_Code(i),
1813 X_OPERATOR8_Code(i),
1814 X_NUMERIC_VALUE8(i),
1815 X_DATE_VALUE8(i),
1816 X_ALPHANUMERIC_VALUE8(i),
1817 X_VALUE_LOW8(i),
1818 X_VALUE_HIGH8(i),
1819 X_DETERMINING_FACTOR_CODE9(i),
1820 X_TAX_PARAMETER_CODE9(i),
1821 X_DATA_TYPE9_Code(i),
1822 X_DETERMINING_FACTOR_CLASS9_Co(i),
1823 X_DETERMINING_FACTOR_CQ9_Code(i),
1824 X_OPERATOR9_Code(i),
1825 X_NUMERIC_VALUE9(i),
1826 X_DATE_VALUE9(i),
1827 X_ALPHANUMERIC_VALUE9(i),
1828 X_VALUE_LOW9(i),
1829 X_VALUE_HIGH9(i),
1830 fnd_global.user_id ,
1831 sysdate ,
1832 fnd_global.user_id ,
1833 sysdate ,
1834 fnd_global.conc_login_id ,
1835 fnd_global.conc_request_id ,
1836 fnd_global.prog_appl_id ,
1837 fnd_global.conc_program_id ,
1838 fnd_global.conc_login_id
1839 );
1840
1841 forall i in x_condition_group_id.first..x_condition_group_id.last
1842 insert into ZX_CONDITION_GROUPS_TL (
1843 CONDITION_GROUP_ID,
1844 CONDITION_GROUP_NAME,
1845 CONDITION_GROUP_DESC,
1846 LANGUAGE,
1847 SOURCE_LANG,
1848 CREATED_BY ,
1849 CREATION_DATE ,
1850 LAST_UPDATED_BY ,
1851 LAST_UPDATE_DATE ,
1852 LAST_UPDATE_LOGIN)
1853 select X_CONDITION_GROUP_ID(i),
1854 X_CONDITION_GROUP_NAME(i),
1855 X_CONDITION_GROUP_DESC(i),
1856 L.LANGUAGE_CODE,
1857 userenv('LANG'),
1858 fnd_global.user_id ,
1859 sysdate ,
1860 fnd_global.user_id ,
1861 sysdate ,
1862 fnd_global.conc_login_id
1863 from FND_LANGUAGES L
1864 where L.INSTALLED_FLAG in ('I', 'B')
1865 and not exists
1866 (select NULL
1867 from ZX_CONDITION_GROUPS_TL T
1868 where T.CONDITION_GROUP_ID = X_CONDITION_GROUP_ID(i)
1869 and T.LANGUAGE = L.LANGUAGE_CODE);
1870 end if;
1871
1872 EXCEPTION
1873 WHEN OTHERS THEN
1874 APP_EXCEPTION.RAISE_EXCEPTION;
1875
1876 end bulk_insert_condition_groups; */
1877
1878 end ZX_CONDITION_GROUPS_PKG;