[Home] [Help]
PACKAGE BODY: APPS.AD_MORG
Source
1 package body ad_morg as
2 /* $Header: admorgb.pls 120.21.12010000.2 2009/01/05 08:27:47 diverma ship $ */
3
4 --
5 -- Private Cursors
6 --
7 -- This cursor had been combined with the dynamic INSERT statement
8 -- in replicate_table_data_bulk() to improve a performance issue
9 -- described in bug 5409325. Any changes to this cursor would
10 -- require corresponding changes to the value of "in_line_view"
11 -- in replicate_table_data_bulk().
12 --
13 cursor org_cursor is
14 select organization_id
15 from hr_operating_units
16 , fnd_product_groups
17 where product_group_id = 1
18 and multi_org_flag = 'Y'
19 union
20 select to_number(null)
21 from dual
22 where not exists (
23 select null
24 from fnd_product_groups
25 where multi_org_flag = 'Y')
26 order by 1;
27
28 MSG_LEVEL_WARN CONSTANT BINARY_INTEGER := 1;
29 MSG_LEVEL_BASIC CONSTANT BINARY_INTEGER := 2;
30 MSG_LEVEL_DATA CONSTANT BINARY_INTEGER := 3;
31 MSG_LEVEL_SQL CONSTANT BINARY_INTEGER := 4;
32
33
34 --
35 -- Private variables
36 --
37 g_prod_status varchar2(10);
38 g_industry varchar2(10);
39 g_prev_product varchar2(30);
40 g_oracle_schema varchar2(30);
41 g_load_table_data boolean := FALSE;
42 g_load_table_stats varchar2(1);
43 g_debug_level number := 0;
44
45
46 --
47 -- Private Functions and Procedures
48 --
49
50 --
51 -- Function
52 -- check_object
53 --
54 -- Purpose
55 -- Checks if the object exists in the database
56 --
57 -- Arguments
58 -- X_table_name name of partitioned table
59 -- X_appl_short_name application owner of table
60 --
61 -- Returns
62 -- TRUE if the object exists, FALSE if it does not
63 --
64 -- Example
65 -- none
66 --
67 -- Notes
68 -- none
69 --
70 function check_table
71 (X_table_name in varchar2,
72 X_appl_short_name in varchar2,
73 O_table_owner out nocopy varchar2) return boolean
74 is
75 l_dummy varchar2(30);
76 begin
77
78 select 'table exists',t.owner
79 into l_dummy,
80 O_table_owner
81 from user_synonyms s,
82 dba_tables t
83 where s.synonym_name = upper(X_table_name)
84 and t.owner = s.table_owner
85 and t.table_name = s.table_name
86 and rownum = 1;
87
88 return(TRUE);
89
90 exception
91 when NO_DATA_FOUND then
92 return(FALSE);
93 end;
94
95 --
96 -- Procedure
97 -- add_list
98 --
99 -- Purpose
100 -- Add a partitioned table to the register
101 --
102 -- Arguments
103 -- X_table_name name of partitioned table
104 -- X_view_name name of corresponding partitioned view
105 -- X_appl_short_name application owner of table
106 -- X_seed_data_flag table containing seed data?
107 -- X_chk_licensed add to list only if the product is licensed (default N)
108 -- X_chk_industry add to list only if specific industry (default NULL)
109 -- X_alt_short_name alternative application owner of table (default NULL)
110 -- (see notes)
111 -- X_conv_method table conversion method (S or P, default NULL)
112 --
113 -- Example
114 -- none
115 --
116 -- Notes
117 -- Some tables (mostly localization tables) are not created in their
118 -- own schema but rather in some other product's schema. For instance,
119 -- JG_ZZ_INT_INV_LINES_ALL is created in the AR schema and not in JG.
120 -- For such tables, an additional application short name needs to be
121 -- specified. The first application name will be stored in the
122 -- application names list while the second application name will be
123 -- used to determine the name of the oracle schema that owns the table.
124 --
125 -- Determining the name of the oracle schema that corresponds to an
126 -- apps product is a bit trickier than expected. This is because some
127 -- apps instances once implemented the Multiple Set Of Books
128 -- Architecture. Under the MSOBA, some products define a separate
129 -- oracle schema for each implemented set of books.
130 --
131 -- For example, an instance may define 3 payables schemas named
132 -- 'AP', 'AP1' and 'AP2' in order to support 3 sets of books.
133 -- At some point the instance was converted to a single schema instance
134 -- which eliminated two of the Payables schemas. The remaining schema
135 -- however is not necessarily 'AP', but may as well be 'AP1' or 'AP2'.
136 --
137 -- Performance issue:
138 -- The check_exists parameter has been removed from the parameter
139 -- list because we always want to verify the existance of the table
140 -- before we try to load the parameters into the respective tables.
141 -- Testing indicates that at most there is a half-second difference
142 -- between checking all of the tables for existance and only checking
143 -- some of the tables for existance when loading the entire list.
144 -- (Yes, we mean the entire list, not each entry.)
145 --
146 procedure add_list
147 (X_table_name in varchar2,
148 X_view_name in varchar2,
149 X_appl_short_name in varchar2,
150 X_seed_data_flag in varchar2,
151 X_chk_licensed in varchar2,
152 X_chk_industry in varchar2 default null,
153 X_alt_short_name in varchar2 default null,
154 X_conv_method in varchar2 default null)
155 is
156 l_status varchar2(30);
157 l_industry varchar2(30);
158 l_oracle_schema varchar2(30) := null;
159 l_ign boolean;
160 l_conv_method varchar2(1);
161 l_num_rows number;
162 l_table_owner dba_tables.owner%type;
163 begin
164
165 l_conv_method := 'S';
166 --
167 -- First, we need to retrieve the product status, industry and name of
168 -- the oracle schema associated to the specified application.
169 --
170
171 if ( x_appl_short_name <> g_prev_product) then
172
173 -- We need to call fnd_installation.get_app_info() every time we
174 -- are passed a new application short name.
175
176 -- The x_appl_short_name <> g_prev_product comparison evaluates to
177 -- false when x_appl_short_name is null.
178
179 l_ign := fnd_installation.get_app_info(x_appl_short_name, l_status,
180 l_industry, l_oracle_schema);
181
182 -- Cache the values so we can use them the next time add_list() is
183 -- called (if the same application name is passed):
184
185 g_prod_status := l_status;
186 g_industry := l_industry;
187 g_oracle_schema := l_oracle_schema;
188
189 g_prev_product := x_appl_short_name;
190
191 else
192 -- The value of x_appl_short_name is the same as last time
193 -- add_list() was called, so we can use the cached values:
194
195 l_status := g_prod_status;
196 l_industry := g_industry;
197 l_oracle_schema := g_oracle_schema;
198
199 end if;
200
201
202 --
203 -- Localization tables are created only when they are licenced. Ignore
204 -- these tables where localizations are not installed.
205 --
206 if (X_chk_licensed = 'Y' or X_chk_industry is not null)
207 then
208 if (X_chk_licensed = 'Y' and l_status <> 'I') then
209 return;
210 end if;
211
212 if (X_chk_industry is not null and
213 l_industry <> upper(X_chk_industry))
214 then
215 return;
216 end if;
217 end if;
218
219 -- We need to put the check in for the last entry in the table and then
220 -- go ahead and process it. Other routines may use this as a table terminator.
221 -- This should be changed in the next revision so that we can use a more
222 -- elegant solution.
223
224 -- check_table() doesn't use the x_appl_short_name parameter
225 if ( (X_table_name is not null) and
226 (NOT check_table(X_table_name, X_appl_short_name, l_table_owner) ) )
227 then
228 return;
229 end if;
230
231 -- If the x_alt_short_name parameter is not null, we're dealing with
232 -- a licensed localization table. This is an exceptional and hopefully
233 -- rare case. We cannot use the schema value associated with
234 -- x_appl_short_schema (see notes section) but we must call
235 -- fnd_installation.get_app_info() once again:
236
237 if (g_load_table_stats = 'Y' and x_alt_short_name is not null) then
238
239 l_ign := fnd_installation.get_app_info(x_alt_short_name, l_status,
240 l_industry, l_oracle_schema);
241
242 -- We won't cache anything this time because it won't buy us much.
243
244 -- Note: after this point, l_status and l_industry correspond to
245 -- l_alt_short_name, not l_appl_short_name! Use them with care, or
246 -- better yet, don't use them at all!
247
248 end if;
249
250 --
251 -- We now need to determine how the table will be converted. If the
252 -- caller has specified a valid conversion method, we'll accept it,
253 -- otherwise we'll look at the table's statistics. If the table
254 -- contains more than 1 million rows we'll convert it in parallel;
255 -- otherwise serially. Retrieving the table's statistics is an
256 -- expensive operation which we want to avoid if not needed. Hence,
257 -- when the g_load_table_stats flag is not 'Y', we'll just set the
258 -- conversion method to 'S'.
259 --
260
261 if ((x_table_name is null) or (x_conv_method in ('S', 'P'))) then
262 l_conv_method := x_conv_method;
263 else
264
265 l_conv_method := 'S'; -- default conversion method is 'S'
266
267 if (g_load_table_stats = 'Y') then
268
269 begin
270 select num_rows
271 into l_num_rows
272 from dba_tables
273 where table_name = x_table_name
274 and owner= l_table_owner;
275 exception
276 when no_data_found then
277 raise_application_error(-20001,
278 'Unable to get statistics for table : '||
279 l_oracle_schema||'.'||x_table_name);
280 end;
281
282 if (l_num_rows > 1000000) then
283 l_conv_method := 'P';
284 end if;
285
286 end if;
287
288 end if;
289
290 table_list (table_list.count+1) := X_table_name;
291 owner_list (owner_list.count+1) := l_oracle_schema;
292 view_list (view_list.count+1) := X_view_name;
293 appl_list (appl_list.count+1) := X_appl_short_name;
294 seed_data (seed_data.count+1) := X_seed_data_flag;
295 conv_method(conv_method.count+1) := l_conv_method;
296
297 end;
298
299 --
300 -- Procedure
301 -- create_sequences
302 --
303 -- Purpose
304 -- Perform seed data replication from the template to the specified
305 -- org for the specified table
306 --
307 -- Arguments
308 -- X_sequence_name name of sequence to create
309 -- X_seq_start_num sequence's starting number
310 -- X_appl_short_name Application owner of sequence
311 --
312 -- Example
313 -- none
314 --
315 -- Notes
316 -- none
317 --
318 procedure create_sequence
319 (X_sequence_name in varchar2,
320 X_seq_start_num in number,
321 X_appl_short_name in varchar2)
322 is
323 statement varchar2(2000);
324 sequence_exists exception;
325 inst_stat varchar2(30);
326 ind varchar2(30);
327 schema_nm varchar2(30);
328
329 pragma exception_init(sequence_exists, -955);
330
331 begin
332 -- Get the schema name to use for the ad_ddl call below. Note that this
333 -- used to be passed as parameter 1, but due to GSCC requirements, it is
334 -- deemed a much safer way to do it this way instead.
335 begin
336 if (NOT (FND_INSTALLATION.get_app_info('FND', inst_stat, ind, schema_nm)))
337 then
338 -- Check the status from the call.
339 if (inst_stat <> 'I') then
340 raise_application_error(-20001,'FND_INSTALLATION.GET_APP_INFO()'||
341 ' installation status of FND = '||inst_stat||
342 ' '|| X_sequence_name||' not created.');
343 end if;
344 end if;
345 exception
346 when others then
347 raise_application_error(-20000, sqlerrm || ' during '||
348 'FND_INSTALLATION.GET_APP_INFO()');
349 end;
350
351
352 statement := 'create sequence ' || X_sequence_name ||
353 ' start with ' || to_char(X_seq_start_num) ||
354 ' increment by 1';
355
356 ad_ddl.do_ddl(schema_nm, X_appl_short_name,
357 ad_ddl.create_sequence, statement, X_sequence_name);
358 exception
359 when sequence_exists then
360 null;
361 when others then
362 raise_application_error(-20002,sqlerrm||' in CREATE_SEQUENCE for '||
363 X_sequence_name);
364 end;
365
366
367 --
368 -- Procedure
369 -- replicate_table_data
370 --
371 -- Purpose
372 -- Perform seed data replication from the template to the specified
373 -- org for the specified table
374 --
375 -- Arguments
376 -- X_table_name Name of table
377 -- X_source_org_id org_id of the source organization_id
378 -- X_target_org_id org_id of the target organization_id
379 --
380 -- Example
381 -- none
382 --
383 -- Notes
384 -- 1. Templates for partitioned seed data have a source org_id of -3113.
385 -- 2. Templates for shared seed data have a source org_id of -3114.
386 -- 3. Custom data have a source org_id of NULL.
387 --
388 procedure replicate_table_data
389 (X_table_name in varchar2,
390 X_source_org_id in number,
391 X_target_org_id in number)
392 is
393 where_clause varchar2(32767);
394 column_list varchar2(32767);
395 statement varchar2(32767);
396 c integer;
397
398 table_not_found exception;
399
400 cursor c_column is
401 select distinct column_name, column_id
402 from all_tab_columns tc
403 , user_synonyms us
404 where us.synonym_name = X_table_name
405 and tc.table_name = us.synonym_name
406 and tc.owner = us.table_owner
407 and tc.column_name <> 'ORG_ID'
408 and tc.data_type not in ('LONG', 'LONG RAW')
409 order by column_id;
410
411 cursor c_primary_key is
412 select c.column_name, pkc.primary_key_sequence
413 from fnd_columns c
414 , fnd_primary_key_columns pkc
415 , fnd_primary_keys pk
416 , fnd_tables t
417 where t.application_id >= 0
418 and t.table_name = X_table_name
419 and pk.application_id = t.application_id
420 and pk.table_id = t.table_id
421 and pk.primary_key_type = 'D'
422 and pkc.application_id = pk.application_id
423 and pkc.table_id = pk.table_id
427 and c.column_id = pkc.column_id
424 and pkc.primary_key_id = pk.primary_key_id
425 and c.application_id = pkc.application_id
426 and c.table_id = pkc.table_id
428 and c.column_name <> 'ORG_ID'
429 order by pkc.primary_key_sequence;
430
431 begin
432
433 if (X_source_org_id is null and X_target_org_id is null) then
434 return;
435 end if;
436
437 column_list := NULL;
438 c := 0;
439 for c_col in c_column loop
440 c := c + 1;
441 column_list := column_list || c_col.column_name || ', ';
442 end loop;
443 if c = 0 then
444 raise table_not_found;
445 end if;
446
447 where_clause := ' WHERE NVL(ORG_ID, -99) = nvl(:X_source_org_id, -99)' ||
448 ' AND NOT (ORG_ID = -3114 AND :X_target_org_id IS NOT NULL)' ||
449 ' AND NOT EXISTS (' ||
450 ' SELECT NULL FROM ' || X_table_name ||
451 ' WHERE NVL(ORG_ID, -99) = NVL(:X_target_org_id, -99)';
452 for c_pk in c_primary_key loop
453 where_clause := where_clause || ' AND ' ||
454 c_pk.column_name || ' = A.' || c_pk.column_name;
455 end loop;
456 where_clause := where_clause || ')';
457
458 statement := 'INSERT INTO ' || X_table_name || ' (' ||
459 column_list || 'ORG_ID) SELECT ' ||
460 column_list || ':X_target_org_id FROM ' || X_table_name || ' A' ||
461 where_clause;
462
463 EXECUTE IMMEDIATE statement USING X_target_org_id, X_source_org_id,
464 X_target_org_id, X_target_org_id;
465
466 exception
467 when table_not_found then
468 null;
469 when others then
470 raise_application_error(-20000, sqlerrm || ':ad_morg.replicate_table_data(' ||
471 X_table_name || ',' || X_target_org_id || '):' || statement);
472
473 end replicate_table_data;
474
475
476 --
477 -- Procedure
478 -- replicate_table_data_bulk
479 --
480 -- Purpose
481 -- Perform seed data replication from the template to
482 -- a group of orgs for the specified table
483 --
484 -- This procedure was adapted from replicate_table_data()
485 --
486 -- This was written to improve performance as described
487 -- in bug 5409325.
488 --
489 -- Instead of calling replicate_table_data() for each
490 -- value fetched from the cursor, the cursor is combined
491 -- with the dynamic INSERT statement to process all orgs
492 -- in one shot per table.
493 --
494 -- Arguments
495 -- X_table_name Name of table
496 -- X_source_org_id org_id of the source organization_id
497 --
498 -- Example
499 -- none
500 --
501 -- Notes
502 -- 1. Templates for partitioned seed data have a source org_id of -3113.
503 -- 2. Templates for shared seed data have a source org_id of -3114.
504 -- 3. Custom data have a source org_id of NULL.
505 --
506 procedure replicate_table_data_bulk
507 (X_table_name in varchar2,
508 X_source_org_id in number)
509 is
510 where_clause varchar2(32767);
511 in_line_view varchar2(32767);
512 column_list varchar2(32767);
513 statement varchar2(32767);
514 c integer;
515
516 table_not_found exception;
517
518 cursor c_column is
519 select distinct column_name, column_id
520 from all_tab_columns tc
521 , user_synonyms us
522 where us.synonym_name = X_table_name
523 and tc.table_name = us.synonym_name
524 and tc.owner = us.table_owner
525 and tc.column_name <> 'ORG_ID'
526 and tc.data_type not in ('LONG', 'LONG RAW')
527 order by column_id;
528
529 cursor c_primary_key is
530 select c.column_name, pkc.primary_key_sequence
531 from fnd_columns c
532 , fnd_primary_key_columns pkc
533 , fnd_primary_keys pk
534 , fnd_tables t
535 where t.application_id >= 0
536 and t.table_name = X_table_name
537 and pk.application_id = t.application_id
538 and pk.table_id = t.table_id
539 and pk.primary_key_type = 'D'
540 and pkc.application_id = pk.application_id
541 and pkc.table_id = pk.table_id
542 and pkc.primary_key_id = pk.primary_key_id
543 and c.application_id = pkc.application_id
544 and c.table_id = pkc.table_id
545 and c.column_id = pkc.column_id
546 and c.column_name <> 'ORG_ID'
547 order by pkc.primary_key_sequence;
548
549 begin
550
551 if (X_source_org_id is null) then
552 return;
553 end if;
554
555 column_list := NULL;
556 c := 0;
557 for c_col in c_column loop
558 c := c + 1;
559 column_list := column_list || c_col.column_name || ', ';
560 end loop;
561 if c = 0 then
562 raise table_not_found;
563 end if;
564
565 where_clause :=
566 ' WHERE NVL(ORG_ID, -99) = nvl(:X_source_org_id, -99)' ||
567 ' AND NOT (ORG_ID = -3114 AND V.ORGANIZATION_ID IS NOT NULL)';
568 for c_pk in c_primary_key loop
569 where_clause := where_clause ||
570 ' AND (A.' || c_pk.column_name || ', NVL(V.ORGANIZATION_ID, -99))' ||
571 ' NOT IN (SELECT /*+ hash_aj parallel(b) */ ' || c_pk.column_name ||
572 ', NVL(ORG_ID, -99) FROM ' || X_table_name || ' B)';
573 end loop;
577 end loop;
574 for c_pk in c_primary_key loop
575 where_clause := where_clause || ' AND ' ||
576 c_pk.column_name || ' = A.' || c_pk.column_name;
578
579 in_line_view := ' (SELECT /*+ no_merge */ ORGANIZATION_ID FROM' ||
580 ' fnd_product_groups, hr_operating_units' ||
581 ' WHERE product_group_id = 1' ||
582 ' AND multi_org_flag = ''Y'' UNION' ||
583 ' SELECT TO_NUMBER(NULL) FROM DUAL WHERE NOT EXISTS' ||
584 ' (SELECT NULL FROM fnd_product_groups WHERE' ||
585 ' multi_org_flag = ''Y'')) V';
586
587 statement := 'INSERT INTO ' || X_table_name || ' (' ||
588 column_list || 'ORG_ID)' ||
589 ' SELECT /*+ ordered no_expand parallel(a) */ ' ||
590 column_list || ' V.ORGANIZATION_ID FROM ' || X_table_name ||
591 ' A,' || in_line_view || where_clause;
592
593 EXECUTE IMMEDIATE statement USING X_source_org_id;
594
595 exception
596 when table_not_found then
597 null;
598 when others then
599 raise_application_error(-20000, sqlerrm ||
600 ':ad_morg.replicate_table_data_bulk(' ||
601 X_table_name || ',' || X_source_org_id || '):' || statement);
602
603 end replicate_table_data_bulk;
604
605 procedure replicate_ar_org_data
606 (X_org_id in number)
607 is
608 begin
609 --
610 -- Now create seeded batch source sequences
611 --
612 if X_org_id is not null then
613 create_sequence('RA_TRX_NUMBER_N1_'||to_char(X_org_id)||'_S', 10000, 'AR');
614 create_sequence('RA_TRX_NUMBER_8_'||to_char(X_org_id)||'_S', 10000, 'AR');
615 create_sequence('RA_TRX_NUMBER_11_'||to_char(X_org_id)||'_S', 200000, 'AR');
616 create_sequence('RA_TRX_NUMBER_12_'||to_char(X_org_id)||'_S', 100000, 'AR');
617 create_sequence('RA_TRX_NUMBER_13_'||to_char(X_org_id)||'_S', 10000, 'AR');
618 create_sequence('RA_TRX_NUMBER_22_'||to_char(X_org_id)||'_S', 10000, 'AR');
619 create_sequence('RA_TRX_NUMBER_24_'||to_char(X_org_id)||'_S', 10000, 'AR');
620 create_sequence('RA_TRX_NUMBER_25_'||to_char(X_org_id)||'_S', 10000, 'AR');
621 create_sequence('RA_TRX_NUMBER_26_'||to_char(X_org_id)||'_S', 10000, 'AR');
622 create_sequence('RA_TRX_NUMBER_27_'||to_char(X_org_id)||'_S', 10000, 'AR');
623 create_sequence('RA_TRX_NUMBER_29_'||to_char(X_org_id)||'_S', 10000, 'AR');
624 create_sequence('RA_TRX_NUMBER_30_'||to_char(X_org_id)||'_S', 10000, 'AR');
625 end if;
626
627 exception
628 when others then
629 raise;
630 end replicate_ar_org_data;
631
632 --
633 -- Public Functions and Procedures
634 --
635
636 --
637 -- Procedure
638 -- replicate_seed_data
639 --
640 -- Purpose
641 -- Perform seed data replication from the template to the specified
642 -- org or all orgs for the specified table or all tables from one
643 -- product or all tables
644 --
645 -- Arguments
646 -- X_org_id org_id of the target organization_id (NULL if all)
647 -- X_appl_short_name application (NULL if all)
648 -- X_table_name Name of table (NULL if all)
649 --
650 -- Example
651 -- none
652 --
653 -- Notes
654 -- 1. Template rows have a special org_id of -3113.
655 --
656 procedure replicate_seed_data
657 (X_org_id in number,
658 X_appl_short_name in varchar2,
659 x_table_name in varchar2)
660 is
661 is_org varchar2(1);
662 i number;
663 begin
664 --
665 -- If org_id is not null and multi_org_flag is not 'Y', exit
666 -- use min() to return a value even if no rows (fresh install case)
667 --
668 select nvl(min(multi_org_flag),'N')
669 into is_org
670 from fnd_product_groups
671 where product_group_id = 1;
672
673 if X_org_id is not null and is_org <> 'Y' then
674 return;
675 end if;
676 --
677 -- Check to see if single table replication
678 --
679 if X_table_name is not null then
680 --
681 -- Check to see if single org replication
682 --
683 if X_org_id is not null then
684 replicate_table_data(X_table_name, -3113, X_org_id);
685 else
686 replicate_table_data(X_table_name, -3114, null);
687 replicate_table_data_bulk(X_table_name, -3113);
688 commit;
689 end if;
690 else
691 load_table_list('N');
692 --
693 -- Check to see if single org replication
694 --
695 if X_org_id is not null then
696 i := 1;
697 while table_list(i) is not null loop
698 if ((appl_list(i) = X_appl_short_name or X_appl_short_name is null)
699 and seed_data(i) = 'Y') then
700 replicate_table_data(table_list(i), -3113, X_org_id);
701 end if;
702 -- increment counter to go to next table/view
703 i := i + 1;
704 end loop;
705 if (X_appl_short_name is null or X_appl_short_name = 'AR') then
706 replicate_ar_org_data(X_org_id);
707 end if;
708 else
709 i := 1;
710 while table_list(i) is not null loop
711 if ((appl_list(i) = X_appl_short_name or X_appl_short_name is null)
712 and seed_data(i) = 'Y') then
713 replicate_table_data_bulk(table_list(i), -3113);
714 replicate_table_data(table_list(i), -3114, null);
715 commit;
716 end if;
717 -- increment counter to go to next table/view
721 for c_org in org_cursor loop
718 i := i + 1;
719 end loop;
720 if (X_appl_short_name is null or X_appl_short_name = 'AR') then
722 replicate_ar_org_data(c_org.organization_id);
723 end loop;
724 commit;
725 end if;
726 end if;
727 end if;
728 --
729 -- Comments out following codes based on request from table owner
730 -- Bug 4557238
731 --
732 -- Exception cases: we need to unstamp certain rows
733 -- This is added as a cleanup step.
734 --
735 -- update ar_payment_schedules_all
736 -- set org_id = null
737 -- where payment_schedule_id < 0;
738
739 exception
740 when others then
741 raise;
742 end replicate_seed_data;
743
744
745 --
746 -- Procedure
747 -- load_table_list
748 --
749 -- Purpose
750 -- Loads the hard-coded list of partitioned tables into PL/SQL tables.
751 -- These PL/SQL tables should replace AK_PARTITIONED_TABLES in 10.7.
752 --
753 -- Arguments
754 -- X_load_table_stats indicates whether the tables' row count should
755 -- be used to determine the conversion method
756 -- (default Y)
757 --
758 -- Example
759 -- none
760 --
761 procedure load_table_list
762 (x_load_table_stats in varchar2)
763 is
764 begin
765
766 g_load_table_stats := x_load_table_stats;
767
768 -- If someone calls this routine multiple times within the same database
769 -- session, we need to make sure that we don't add to the table entries.
770 -- So, truncate all of the tables before we add to them.
771 if (table_list.count > 0)
772 then
773 table_list.DELETE;
774 owner_list.DELETE;
775 view_list.DELETE;
776 appl_list.DELETE;
777 seed_data.DELETE;
778 conv_method.DELETE;
779 end if;
780 --
781 -- get licence status for localization products
782 --
783
784 /*
785 -- IMPORTANT: performance is best when the add_list() calls for the
786 -- same application are grouped together!
787 */
788
789 add_list('AP_1096_DATA_ALL' , 'AP_1096_DATA' , 'SQLAP' ,'Y','N');
790 add_list('AP_1099_TAPE_DATA_ALL' , 'AP_1099_TAPE_DATA' , 'SQLAP' ,'N','N');
791 add_list('AP_ACCOUNTING_EVENTS_ALL' , 'AP_ACCOUNTING_EVENTS' , 'SQLAP' ,'N','N');
792 add_list('AP_AE_HEADERS_ALL' , 'AP_AE_HEADERS' , 'SQLAP' ,'N','N');
793 add_list('AP_AE_LINES_ALL' , 'AP_AE_LINES' , 'SQLAP' ,'N','N');
794 add_list('AP_AUD_RULE_ASSIGNMENTS_ALL' , 'AP_AUD_RULE_ASSIGNMENTS' , 'SQLAP' ,'N','N');
795 add_list('AP_AWT_BUCKETS_ALL' , 'AP_AWT_BUCKETS' , 'SQLAP' ,'N','N');
796 add_list('AP_AWT_GROUP_TAXES_ALL' , 'AP_AWT_GROUP_TAXES' , 'SQLAP' ,'N','N');
797 add_list('AP_AWT_TAX_RATES_ALL' , 'AP_AWT_TAX_RATES' , 'SQLAP' ,'N','N');
798 add_list('AP_AWT_TEMP_DISTRIBUTIONS_ALL' , 'AP_AWT_TEMP_DISTRIBUTIONS' , 'SQLAP' ,'N','N');
799 add_list('AP_BANK_ACCOUNTS_ALL' , 'AP_BANK_ACCOUNTS' , 'SQLAP' ,'N','N');
800 add_list('AP_BANK_ACCOUNT_USES_ALL' , 'AP_BANK_ACCOUNT_USES' , 'SQLAP' ,'N','N');
801 add_list('AP_BATCHES_ALL' , 'AP_BATCHES' , 'SQLAP' ,'N','N');
802 add_list('AP_CARDS_ALL' , 'AP_CARDS' , 'SQLAP' ,'N','N');
803 add_list('AP_CARD_CODES_ALL' , 'AP_CARD_CODES' , 'SQLAP' ,'N','N');
804 add_list('AP_CARD_CODE_SETS_ALL' , 'AP_CARD_CODE_SETS' , 'SQLAP' ,'N','N');
805 add_list('AP_CARD_GL_ACCTS_ALL' , 'AP_CARD_GL_ACCTS' , 'SQLAP' ,'N','N');
806 add_list('AP_CARD_GL_SETS_ALL' , 'AP_CARD_GL_SETS' , 'SQLAP' ,'N','N');
807 add_list('AP_CARD_PROFILES_ALL' , 'AP_CARD_PROFILES' , 'SQLAP' ,'N','N');
808 add_list('AP_CARD_PROFILE_LIMITS_ALL' , 'AP_CARD_PROFILE_LIMITS' , 'SQLAP' ,'N','N');
809 add_list('AP_CARD_PROGRAMS_ALL' , 'AP_CARD_PROGRAMS' , 'SQLAP' ,'N','N');
810 add_list('AP_CARD_REQUESTS_ALL' , 'AP_CARD_REQUESTS' , 'SQLAP' ,'N','N');
811 add_list('AP_CARD_SUPPLIERS_ALL' , 'AP_CARD_SUPPLIERS' , 'SQLAP' ,'N','N');
812 add_list('AP_CHRG_ALLOCATIONS_ALL' , 'AP_CHRG_ALLOCATIONS' , 'SQLAP' ,'N','N');
813 add_list('AP_CHECKRUN_CONC_PROCESSES_ALL' , 'AP_CHECKRUN_CONC_PROCESSES' , 'SQLAP' ,'N','N');
814 add_list('AP_CHECKRUN_CONFIRMATIONS_ALL' , 'AP_CHECKRUN_CONFIRMATIONS' , 'SQLAP' ,'N','N');
815 add_list('AP_CHECKS_ALL' , 'AP_CHECKS' , 'SQLAP' ,'N','N');
816 add_list('AP_CHECK_STOCKS_ALL' , 'AP_CHECK_STOCKS' , 'SQLAP' ,'N','N');
817 add_list('AP_CREDIT_CARD_TRXNS_ALL' , 'AP_CREDIT_CARD_TRXNS' , 'SQLAP' ,'N','N');
818 add_list('AP_DISTRIBUTION_SETS_ALL' , 'AP_DISTRIBUTION_SETS' , 'SQLAP' ,'N','N');
819 add_list('AP_DISTRIBUTION_SET_LINES_ALL' , 'AP_DISTRIBUTION_SET_LINES' , 'SQLAP' ,'N','N');
820 add_list('AP_DUPLICATE_VENDORS_ALL' , 'AP_DUPLICATE_VENDORS' , 'SQLAP' ,'N','N');
821 add_list('AP_ENCUMBRANCE_LINES_ALL' , 'AP_ENCUMBRANCE_LINES' , 'SQLAP' ,'N','N');
822 add_list('AP_EXP_REPORT_DISTS_ALL' , 'AP_EXP_REPORT_DISTS' , 'SQLAP' ,'N','N');
823 add_list('AP_EXPENSE_FEED_DISTS_ALL' , 'AP_EXPENSE_FEED_DISTS' , 'SQLAP' ,'N','N');
824 add_list('AP_EXPENSE_FEED_LINES_ALL' , 'AP_EXPENSE_FEED_LINES' , 'SQLAP' ,'N','N');
825 add_list('AP_EXPENSE_PARAMS_ALL' , 'AP_EXPENSE_PARAMS' , 'SQLAP' ,'N','N');
829 add_list('AP_EXPENSE_REPORTS_ALL' , 'AP_EXPENSE_REPORTS' , 'SQLAP' ,'N','N');
826 add_list('AP_EXPENSE_REPORT_HEADERS_ALL' , 'AP_EXPENSE_REPORT_HEADERS' , 'SQLAP' ,'N','N');
827 add_list('AP_EXPENSE_REPORT_LINES_ALL' , 'AP_EXPENSE_REPORT_LINES' , 'SQLAP' ,'N','N');
828 add_list('AP_EXPENSE_REPORT_PARAMS_ALL' , 'AP_EXPENSE_REPORT_PARAMS' , 'SQLAP' ,'N','N');
830 add_list('AP_FLEX_SEGMENT_MAPPINGS_ALL' , 'AP_FLEX_SEGMENT_MAPPINGS' , 'SQLAP' ,'Y','N');
831 add_list('AP_HISTORY_CHECKS_ALL' , 'AP_HISTORY_CHECKS' , 'SQLAP' ,'N','N');
832 add_list('AP_HISTORY_INVOICES_ALL' , 'AP_HISTORY_INVOICES' , 'SQLAP' ,'N','N');
833 add_list('AP_HISTORY_INV_PAYMENTS_ALL' , 'AP_HISTORY_INVOICE_PAYMENTS' , 'SQLAP' ,'N','N');
834 add_list('AP_HOLDS_ALL' , 'AP_HOLDS' , 'SQLAP' ,'N','N');
835 add_list('AP_INVOICES_ALL' , 'AP_INVOICES' , 'SQLAP' ,'N','N');
836 add_list('AP_INVOICE_DISTRIBUTIONS_ALL' , 'AP_INVOICE_DISTRIBUTIONS' , 'SQLAP' ,'N','N');
837 add_list('AP_INVOICE_KEY_IND_ALL' , 'AP_INVOICE_KEY_IND' , 'SQLAP' ,'N','N');
838 add_list('AP_INVOICE_PAYMENTS_ALL' , 'AP_INVOICE_PAYMENTS' , 'SQLAP' ,'N','N');
839 add_list('AP_INVOICE_PREPAYS_ALL' , 'AP_INVOICE_PREPAYS' , 'SQLAP' ,'N','N');
840 add_list('AP_INV_SELECTION_CRITERIA_ALL' , 'AP_INVOICE_SELECTION_CRITERIA' , 'SQLAP' ,'N','N');
841 add_list('AP_INV_APRVL_HIST_ALL' , 'AP_INV_APRVL_HIST' , 'SQLAP' ,'N','N');
842 add_list('AP_MATCHED_RECT_ADJ_ALL' , 'AP_MATCHED_RECT_ADJ' , 'SQLAP' ,'N','N');
843 add_list('AP_PAYMENT_HISTORY_ALL' , 'AP_PAYMENT_HISTORY' , 'SQLAP' ,'N','N');
844 add_list('AP_PAYMENT_KEY_IND_ALL' , 'AP_PAYMENT_KEY_IND' , 'SQLAP' ,'N','N');
845 add_list('AP_PAYMENT_SCHEDULES_ALL' , 'AP_PAYMENT_SCHEDULES' , 'SQLAP' ,'N','N');
846 add_list('AP_PBATCH_SETS_ALL' , 'AP_PBATCH_SETS' , 'SQLAP' ,'N','N');
847 add_list('AP_PBATCH_SET_LINES_ALL' , 'AP_PBATCH_SET_LINES' , 'SQLAP' ,'N','N');
848 add_list('AP_POL_CAT_OPTIONS_ALL' , 'AP_POL_CAT_OPTIONS' , 'SQLAP' ,'N','N');
849 add_list('AP_POL_EXRATE_OPTIONS_ALL' , 'AP_POL_EXRATE_OPTIONS' , 'SQLAP' ,'N','N');
850 add_list('AP_POL_VIOLATIONS_ALL' , 'AP_POL_VIOLATIONS' , 'SQLAP' ,'N','N');
851 add_list('AP_RECURRING_PAYMENTS_ALL' , 'AP_RECURRING_PAYMENTS' , 'SQLAP' ,'N','N');
852 add_list('AP_REPORTING_ENTITIES_ALL' , 'AP_REPORTING_ENTITIES' , 'SQLAP' ,'N','N');
853 add_list('AP_REPORTING_ENTITY_LINES_ALL' , 'AP_REPORTING_ENTITY_LINES' , 'SQLAP' ,'N','N');
854 add_list('AP_SELECTED_INVOICES_ALL' , 'AP_SELECTED_INVOICES' , 'SQLAP' ,'N','N');
855 add_list('AP_SELECTED_INVOICE_CHECKS_ALL' , 'AP_SELECTED_INVOICE_CHECKS' , 'SQLAP' ,'N','N');
856 add_list('AP_SYSTEM_PARAMETERS_ALL' , 'AP_SYSTEM_PARAMETERS' , 'SQLAP' ,'N','N');
857 add_list('AP_TAX_RECVRY_RATES_ALL' , 'AP_TAX_RECVRY_RATES' , 'SQLAP' ,'N','N');
858 add_list('AP_TAX_RECVRY_RULES_ALL' , 'AP_TAX_RECVRY_RULES' , 'SQLAP' ,'N','N');
859 add_list('AP_TEMP_APPROVAL_ALL' , 'AP_TEMP_APPROVAL' , 'SQLAP' ,'N','N');
860 add_list('AP_TOLERANCES_ALL' , 'AP_TOLERANCES' , 'SQLAP' ,'Y','N');
861 add_list('AP_VENDOR_KEY_IND_ALL' , 'AP_VENDOR_KEY_IND' , 'SQLAP' ,'N','N');
862 add_list('AP_WEB_SIGNING_LIMITS_ALL' , 'AP_WEB_SIGNING_LIMITS' , 'SQLAP' ,'N','N');
863 add_list('AP_WEB_VAT_SETUP_ALL' , 'AP_WEB_VAT_SETUP' , 'SQLAP' ,'N','N');
864 add_list('AP_WEB_EMPLOYEE_INFO_ALL' , 'AP_WEB_EMPLOYEE_INFO' , 'SQLAP' ,'N','N');
865 add_list('FINANCIALS_SYSTEM_PARAMS_ALL' , 'FINANCIALS_SYSTEM_PARAMETERS' , 'SQLAP' ,'N','N');
866 add_list('OIE_ATTENDEES_ALL' , 'OIE_ATTENDEES' , 'SQLAP' ,'N','N');
867 add_list('AR_ADJUSTMENTS_ALL' , 'AR_ADJUSTMENTS' , 'AR' ,'N','N');
868 add_list('AR_BATCHES_ALL' , 'AR_BATCHES' , 'AR' ,'N','N');
869 add_list('AR_BATCH_SOURCES_ALL' , 'AR_BATCH_SOURCES' , 'AR' ,'Y','N');
870 add_list('AR_BR_STAMP_VALUES_ALL' , 'AR_BR_STAMP_VALUES' , 'AR' ,'N','N');
871 add_list('AR_CASH_BASIS_DISTS_ALL' , 'AR_CASH_BASIS_DISTRIBUTIONS' , 'AR' ,'N','N');
872 add_list('AR_CASH_RECEIPTS_ALL' , 'AR_CASH_RECEIPTS' , 'AR' ,'N','N');
873 add_list('AR_CASH_RECEIPT_HISTORY_ALL' , 'AR_CASH_RECEIPT_HISTORY' , 'AR' ,'N','N');
874 add_list ('AR_CCID_CORRECTIONS_ALL' , 'AR_CCID_CORRECTIONS' , 'AR' ,'N','N');
875 add_list('RA_CM_REQUESTS_ALL' , 'RA_CM_REQUESTS' , 'AR' ,'N','N');
876 add_list('RA_CM_REQUEST_LINES_ALL' , 'RA_CM_REQUEST_LINES' , 'AR' ,'N','N');
877 add_list('AR_COLLECTION_INDICATORS_ALL' , 'AR_COLLECTION_INDICATORS' , 'AR' ,'N','N');
878 add_list('AR_CONS_INV_ALL' , 'AR_CONS_INV' , 'AR' ,'N','N');
879 add_list('AR_CONS_INV_TRX_ALL' , 'AR_CONS_INV_TRX' , 'AR' ,'N','N');
880 add_list('AR_CONS_INV_TRX_LINES_ALL' , 'AR_CONS_INV_TRX_LINES' , 'AR' ,'N','N');
881 add_list('AR_CONT_ACTIONS_ALL' , 'AR_CONT_ACTIONS' , 'AR' ,'Y','N');
882 add_list('AR_CORRESPONDENCES_ALL' , 'AR_CORRESPONDENCES' , 'AR' ,'N','N');
883 add_list('AR_CORR_PAY_SCHED_ALL' , 'AR_CORRESPONDENCE_PAY_SCHED' , 'AR' ,'N','N');
884 add_list('AR_CUSTOMER_CALLS_ALL' , 'AR_CUSTOMER_CALLS' , 'AR' ,'N','N');
885 add_list('AR_CUSTOMER_CALL_TOPICS_ALL' , 'AR_CUSTOMER_CALL_TOPICS' , 'AR' ,'N','N');
886 add_list('AR_DEFERRED_LINES_ALL' , 'AR_DEFERRED_LINES' , 'AR' ,'N','N');
890 add_list('AR_INTERFACE_CONTS_ALL' , 'AR_INTERFACE_CONTS' , 'AR' ,'N','N');
887 add_list('AR_DISTRIBUTIONS_ALL' , 'AR_DISTRIBUTIONS' , 'AR' ,'N','N');
888 add_list('AR_DISTRIBUTION_SETS_ALL' , 'AR_DISTRIBUTION_SETS' , 'AR' ,'N','N');
889 add_list('AR_DISTRIBUTION_SET_LINES_ALL' , 'AR_DISTRIBUTION_SET_LINES' , 'AR' ,'N','N');
891 add_list('AR_INTERIM_CASH_RCPT_LINES_ALL' , 'AR_INTERIM_CASH_RECEIPT_LINES' , 'AR' ,'N','N');
892 add_list('AR_INTERIM_CASH_RECEIPTS_ALL' , 'AR_INTERIM_CASH_RECEIPTS' , 'AR' ,'N','N');
893 add_list('AR_JOURNAL_INTERIM_ALL' , 'AR_JOURNAL_INTERIM' , 'AR' ,'N','N');
894 add_list('AR_LINE_CONTS_ALL' , 'AR_LINE_CONTS' , 'AR' ,'N','N');
895 add_list('AR_LOCATION_ACCOUNTS_ALL' , 'AR_LOCATION_ACCOUNTS' , 'AR' ,'N','N');
896 add_list('AR_LOCKBOXES_ALL' , 'AR_LOCKBOXES' , 'AR' ,'N','N');
897
898 --
899 -- AR_MC_DISTRIBUTIONS_ALL is MRC related and does not have corresponding
900 -- view. Setting it to AR_MC_DISTRIBUTIONS_ALL
901 --
902 add_list('AR_MC_DISTRIBUTIONS_ALL' , 'AR_MC_DISTRIBUTIONS_ALL' , 'AR' ,'N','N');
903 add_list('AR_MC_CASH_BASIS_DISTS_ALL' , 'AR_CASH_BASIS_DISTS_MRC_V' , 'AR' ,'N','N');
904 add_list('AR_MEMO_LINES_ALL_B' , 'AR_MEMO_LINES_B' , 'AR' ,'Y','N');
905 add_list('AR_MEMO_LINES_ALL_TL' , 'AR_MEMO_LINES_TL' , 'AR' ,'Y','N');
906 add_list('AR_MISC_CASH_DISTRIBUTIONS_ALL' , 'AR_MISC_CASH_DISTRIBUTIONS' , 'AR' ,'N','N');
907 add_list('AR_PAYMENTS_INTERFACE_ALL' , 'AR_PAYMENTS_INTERFACE' , 'AR' ,'N','N');
908 add_list('AR_PAYMENT_SCHEDULES_ALL' , 'AR_PAYMENT_SCHEDULES' , 'AR' ,'N','N');
909 add_list('AR_RATE_ADJUSTMENTS_ALL' , 'AR_RATE_ADJUSTMENTS' , 'AR' ,'N','N');
910 add_list('AR_RECEIPT_METHOD_ACCOUNTS_ALL' , 'AR_RECEIPT_METHOD_ACCOUNTS' , 'AR' ,'N','N');
911 add_list('AR_RECEIVABLES_TRX_ALL' , 'AR_RECEIVABLES_TRX' , 'AR' ,'Y','N');
912 add_list('AR_RECEIVABLE_APPLICATIONS_ALL' , 'AR_RECEIVABLE_APPLICATIONS' , 'AR' ,'N','N');
913 add_list('AR_REVENUE_ADJUSTMENTS_ALL' , 'AR_REVENUE_ADJUSTMENTS' , 'AR' ,'N','N');
914 add_list('AR_STATEMENTS_HISTORY_ALL' , 'AR_STATEMENTS_HISTORY' , 'AR' ,'N','N');
915 add_list('AR_STATEMENT_CYCLE_DATES_ALL' , 'AR_STATEMENT_CYCLE_DATES' , 'AR' ,'N','N');
916 add_list('AR_SYSTEM_PARAMETERS_ALL' , 'AR_SYSTEM_PARAMETERS' , 'AR' ,'Y','N');
917 add_list('AR_TAX_CONDITIONS_ALL' , 'AR_TAX_CONDITIONS' , 'AR' ,'N','N');
918 add_list('AR_TAX_CONDITION_ACTIONS_ALL' , 'AR_TAX_CONDITION_ACTIONS' , 'AR' ,'N','N');
919 add_list('AR_TAX_CONDITION_LINES_ALL' , 'AR_TAX_CONDITION_LINES' , 'AR' ,'N','N');
920 add_list('AR_TRANSACTION_HISTORY_ALL' , 'AR_TRANSACTION_HISTORY' , 'AR' ,'N','N');
921 add_list('AR_TRANSMISSIONS_ALL' , 'AR_TRANSMISSIONS' , 'AR' ,'N','N');
922 add_list('HZ_CUST_ACCT_RELATE_ALL' , 'HZ_CUST_ACCT_RELATE' , 'AR' ,'N','N');
923 add_list('HZ_CUST_ACCT_SITES_ALL' , 'HZ_CUST_ACCT_SITES' , 'AR' ,'N','N');
924 add_list('HZ_CUST_SITE_USES_ALL' , 'HZ_CUST_SITE_USES' , 'AR' ,'N','N');
925 add_list('RA_ACCOUNT_DEFAULTS_ALL' , 'RA_ACCOUNT_DEFAULTS' , 'AR' ,'N','N');
926 add_list('RA_BATCHES_ALL' , 'RA_BATCHES' , 'AR' ,'N','N');
927 add_list('RA_BATCH_SOURCES_ALL' , 'RA_BATCH_SOURCES' , 'AR' ,'Y','N');
928 add_list('RA_CONTACT_PHONES_INT_ALL' , 'RA_CONTACT_PHONES_INTERFACE' , 'AR' ,'N','N');
929 add_list('RA_CUSTOMERS_INTERFACE_ALL' , 'RA_CUSTOMERS_INTERFACE' , 'AR' ,'N','N');
930 add_list('RA_CUSTOMER_BANKS_INT_ALL' , 'RA_CUSTOMER_BANKS_INTERFACE' , 'AR' ,'N','N');
931 add_list('RA_CUSTOMER_PROFILES_INT_ALL' , 'RA_CUSTOMER_PROFILES_INTERFACE' , 'AR' ,'N','N');
932 add_list('RA_CUSTOMER_RELATIONSHIPS_ALL' , 'RA_CUSTOMER_RELATIONSHIPS' , 'AR' ,'N','N');
933 add_list('RA_CUSTOMER_TRX_ALL' , 'RA_CUSTOMER_TRX' , 'AR' ,'N','N');
934 add_list('RA_CUSTOMER_TRX_LINES_ALL' , 'RA_CUSTOMER_TRX_LINES' , 'AR' ,'N','N');
935 add_list('RA_CUST_PAY_METHOD_INT_ALL' , 'RA_CUST_PAY_METHOD_INTERFACE' , 'AR' ,'N','N');
936 add_list('RA_CUST_TRX_LINE_GL_DIST_ALL' , 'RA_CUST_TRX_LINE_GL_DIST' , 'AR' ,'N','N');
937 add_list('RA_CUST_TRX_LINE_SALESREPS_ALL' , 'RA_CUST_TRX_LINE_SALESREPS' , 'AR' ,'N','N');
938 add_list('RA_CUST_TRX_TYPES_ALL' , 'RA_CUST_TRX_TYPES' , 'AR' ,'Y','N');
939 add_list('RA_INTERFACE_DISTRIBUTIONS_ALL' , 'RA_INTERFACE_DISTRIBUTIONS' , 'AR' ,'N','N');
940 add_list('RA_INTERFACE_ERRORS_ALL' , 'RA_INTERFACE_ERRORS' , 'AR' ,'N','N');
941 add_list('RA_INTERFACE_LINES_ALL' , 'RA_INTERFACE_LINES' , 'AR' ,'N','N');
942 add_list('RA_INTERFACE_SALESCREDITS_ALL' , 'RA_INTERFACE_SALESCREDITS' , 'AR' ,'N','N');
943 add_list('RA_REMIT_TOS_ALL' , 'RA_REMIT_TOS' , 'AR' ,'N','N');
944 add_list('RA_SALESREPS_ALL' , 'RA_SALESREPS' , 'AR' ,'Y','N');
945 add_list('RA_SITE_USES_ALL' , 'RA_SITE_USES' , 'AR' ,'N','N');
946 add_list('ASO_QUOTE_HEADERS_ALL' ,'ASO_QUOTE_HEADERS' , 'ASO' ,'N','N');
947 add_list('ASO_QUOTE_LINES_ALL' ,'ASO_QUOTE_LINES' , 'ASO' ,'N','N');
948 -- for bug 4208651
949 add_list('BLC_SYSTEM_OPTIONS_ALL' , 'BLC_SYSTEM_OPTIONS' , 'BLC' ,'N','N');
950 add_list('BLC_CHARGE_CATS_ALL_B' , 'BLC_CHARGE_CATS_VL' , 'BLC' ,'N','N');
951 --
955 add_list('CE_ARCH_RECONCILIATIONS_ALL' , 'CE_ARCH_RECONCILIATIONS' , 'CE' ,'N','N');
952 add_list('CE_ARCH_HEADERS_ALL' , 'CE_ARCH_HEADERS' , 'CE' ,'N','N');
953 add_list('CE_ARCH_INTERFACE_HEADERS_ALL' , 'CE_ARCH_INTERFACE_HEADERS' , 'CE' ,'N','N');
954 add_list('CE_ARCH_INTRA_HEADERS_ALL' , 'CE_ARCH_INTRA_HEADERS' , 'CE' ,'N','N');
956 add_list('CE_BANK_ACCT_USES_ALL' , 'CE_BANK_ACCT_USES' , 'CE' ,'N','N');
957 add_list('CE_INTRA_STMT_HEADERS_ALL' , 'CE_INTRA_STMT_HEADERS' , 'CE' ,'N','N');
958 add_list('CE_STATEMENT_HEADERS_ALL' , 'CE_STATEMENT_HEADERS' , 'CE' ,'N','N');
959 add_list('CE_STATEMENT_HEADERS_INT_ALL' , 'CE_STATEMENT_HEADERS_INTERFACE' , 'CE' ,'N','N');
960 add_list('CE_STATEMENT_RECONCILS_ALL' , 'CE_STATEMENT_RECONCILIATIONS' , 'CE' ,'N','N');
961 add_list('CE_SYSTEM_PARAMETERS_ALL' , 'CE_SYSTEM_PARAMETERS' , 'CE' ,'N','N');
962 add_list('CE_UPG_BA_USES_ALL' , 'CE_UPG_BA_USES' , 'CE' ,'N','N');
963 add_list('CE_UPGA_BA_USES_ALL' , 'CE_UPGA_BA_USES' , 'CE' ,'N','N');
964 --
965 add_list('CN_ATTRIBUTE_RULES_ALL' , 'CN_ATTRIBUTE_RULES' , 'CN' ,'N','N');
966 add_list('CN_CAL_PER_INT_TYPES_ALL' , 'CN_CAL_PER_INT_TYPES' , 'CN' ,'N','N');
967 add_list('CN_CALC_EDGES_ALL' , 'CN_CALC_EDGES' , 'CN' ,'N','N');
968 add_list('CN_CALC_EXT_TABLES_ALL' , 'CN_CALC_EXT_TABLES' , 'CN' ,'N','N');
969 add_list('CN_CALC_EXT_TBL_DTLS_ALL' , 'CN_CALC_EXT_TBL_DTLS' , 'CN' ,'N','N');
970 add_list('CN_CALC_FORMULAS_ALL' , 'CN_CALC_FORMULAS' , 'CN' ,'N','N');
971 add_list('CN_CALC_SUBMISSION_BATCHES_ALL' , 'CN_CALC_SUBMISSION_BATCHES' , 'CN' ,'N','N');
972 add_list('CN_CALC_SUBMISSION_ENTRIES_ALL' , 'CN_CALC_SUBMISSION_ENTRIES' , 'CN' ,'N','N');
973 add_list('CN_CALC_SUB_QUOTAS_ALL' , 'CN_CALC_SUB_QUOTAS' , 'CN' ,'N','N');
974 add_list('CN_CLRL_API_ALL' , 'CN_CLRL_API' , 'CN' ,'N','N');
975 add_list('CN_COLUMN_MAPS_ALL' , 'CN_COLUMN_MAPS' , 'CN' ,'Y','N');
976 add_list('CN_COMMISSION_HEADERS_ALL' , 'CN_COMMISSION_HEADERS' , 'CN' ,'N','N');
977 add_list('CN_COMMISSION_LINES_ALL' , 'CN_COMMISSION_LINES' , 'CN' ,'N','N');
978 add_list('CN_COMM_LINES_API_ALL' , 'CN_COMM_LINES_API' , 'CN' ,'N','N');
979 add_list('CN_COMP_PLANS_ALL' , 'CN_COMP_PLANS' , 'CN' ,'N','N');
980 add_list('CN_CREDIT_CONV_FCTS_ALL' , 'CN_CREDIT_CONV_FCTS' , 'CN' ,'N','N');
981 add_list('CN_CREDIT_TYPES_ALL_B' , 'CN_CREDIT_TYPES_ALL_VL' , 'CN' ,'Y','N');
982 add_list('CN_CREDIT_TYPES_ALL_TL' , 'CN_CREDIT_TYPES_ALL_VL' , 'CN' ,'Y','N');
983 add_list('CN_DIMENSIONS_ALL_B' , 'CN_DIMENSIONS_ALL_VL' , 'CN' ,'Y','N');
984 add_list('CN_DIMENSIONS_ALL_TL' , 'CN_DIMENSIONS_ALL_VL' , 'CN' ,'Y','N');
985 add_list('CN_DIM_EXPLOSION_ALL' , 'CN_DIM_EXPLOSION' , 'CN' ,'N','N');
986 add_list('CN_DIM_HIERARCHIES_ALL' , 'CN_DIM_HIERARCHIES' , 'CN' ,'N','N');
987 add_list('CN_EVENTS_ALL_B' , 'CN_EVENTS_ALL_VL' , 'CN' ,'Y','N');
988 add_list('CN_EVENTS_ALL_TL' , 'CN_EVENTS_ALL_VL' , 'CN' ,'Y','N');
989 add_list('CN_EVENT_LOG_ALL' , 'CN_EVENT_LOG' , 'CN' ,'N','N');
990 add_list('CN_FORMULA_INPUTS_ALL' , 'CN_FORMULA_INPUTS' , 'CN' ,'N','N');
991 add_list('CN_HEAD_HIERARCHIES_ALL_B' , 'CN_HEAD_HIERARCHIES_ALL_VL' , 'CN' ,'Y','N');
992 add_list('CN_HEAD_HIERARCHIES_ALL_TL' , 'CN_HEAD_HIERARCHIES_ALL_VL' , 'CN' ,'Y','N');
993 add_list('CN_HIERARCHIES_API_ALL' , 'CN_HIERARCHIES_API' , 'CN' ,'N','N');
994 add_list('CN_HIERARCHY_EDGES_ALL' , 'CN_HIERARCHY_EDGES' , 'CN' ,'N','N');
995 add_list('CN_HIERARCHY_NODES_ALL' , 'CN_HIERARCHY_NODES' , 'CN' ,'N','N');
996 add_list('CN_INTERVAL_TYPES_ALL_B' , 'CN_INTERVAL_TYPES_ALL_VL' , 'CN' ,'Y','N');
997 add_list('CN_INTERVAL_TYPES_ALL_TL' , 'CN_INTERVAL_TYPES_ALL_VL' , 'CN' ,'Y','N');
998 add_list('CN_LEDGER_JE_BATCHES_ALL' , 'CN_LEDGER_JE_BATCHES' , 'CN' ,'N','N');
999 add_list('CN_LEDGER_JOURNAL_ENTRIES_ALL' , 'CN_LEDGER_JOURNAL_ENTRIES' , 'CN' ,'N','N');
1000 add_list('CN_LINE_ROLLUP_PATHS_ALL' , 'CN_LINE_ROLLUP_PATHS' , 'CN' ,'N','N');
1001 add_list('CN_MODULES_ALL_B' , 'CN_MODULES_ALL_VL' , 'CN' ,'Y','N');
1002 add_list('CN_MODULES_ALL_TL' , 'CN_MODULES_ALL_VL' , 'CN' ,'Y','N');
1003 add_list('CN_MOD_OBJ_DEPENDS_ALL' , 'CN_MOD_OBJ_DEPENDS' , 'CN' ,'N','N');
1004 add_list('CN_NOTIFY_LOG_ALL' , 'CN_NOTIFY_LOG' , 'CN' ,'N','N');
1005 add_list('CN_NOT_TRX_ALL' , 'CN_NOT_TRX' , 'CN' ,'N','N');
1006 add_list('CN_OBJECTS_ALL' , 'CN_OBJECTS' , 'CN' ,'Y','N');
1007 add_list('CN_PAY_GROUPS_ALL' , 'CN_PAY_GROUPS' , 'CN' ,'N','N');
1008 add_list('CN_PAYMENT_API_ALL' , 'CN_PAYMENT_API' , 'CN' ,'N','N');
1009 add_list('CN_PAYMENT_WORKSHEETS_ALL' , 'CN_PAYMENT_WORKSHEETS' , 'CN' ,'N','N');
1010 add_list('CN_PAYRUNS_ALL' , 'CN_PAYRUNS' , 'CN' ,'N','N');
1011 add_list('CN_PERIOD_QUOTAS_ALL' , 'CN_PERIOD_QUOTAS' , 'CN' ,'N','N');
1012 add_list('CN_PERIOD_SETS_ALL' , 'CN_PERIOD_SETS' , 'CN' ,'N','N');
1016 add_list('CN_PMT_PLANS_ALL' , 'CN_PMT_PLANS' , 'CN' ,'N','N');
1013 add_list('CN_PERIOD_STATUSES_ALL' , 'CN_PERIOD_STATUSES' , 'CN' ,'N','N');
1014 add_list('CN_PERIOD_TYPES_ALL' , 'CN_PERIOD_TYPES' , 'CN' ,'Y','N');
1015 add_list('CN_PERF_MEASURES_ALL' , 'CN_PERF_MEASURES' , 'CN' ,'N','N');
1017 add_list('CN_POSTING_BATCHES_ALL' , 'CN_POSTING_BATCHES' , 'CN' ,'N','N');
1018 add_list('CN_POSTING_DETAILS_ALL' , 'CN_POSTING_DETAILS' , 'CN' ,'N','N');
1019 add_list('CN_PROCESS_AUDITS_ALL' , 'CN_PROCESS_AUDITS' , 'CN' ,'N','N');
1020 add_list('CN_PROCESS_AUDIT_LINES_ALL' , 'CN_PROCESS_AUDIT_LINES' , 'CN' ,'N','N');
1021 add_list('CN_PROCESS_BATCHES_ALL' , 'CN_PROCESS_BATCHES' , 'CN' ,'N','N');
1022 add_list('CN_QUOTAS_ALL' , 'CN_QUOTAS' , 'CN' ,'N','N');
1023 add_list('CN_QUOTA_ASSIGNS_ALL' , 'CN_QUOTA_ASSIGNS' , 'CN' ,'N','N');
1024 add_list('CN_QUOTA_RULE_UPLIFTS_ALL' , 'CN_QUOTA_RULE_UPLIFTS' , 'CN' ,'N','N');
1025 add_list('CN_QUOTA_RULES_ALL' , 'CN_QUOTA_RULES' , 'CN' ,'N','N');
1026 add_list('CN_RATE_DIM_TIERS_ALL' , 'CN_RATE_DIM_TIERS' , 'CN' ,'N','N');
1027 add_list('CN_RATE_DIMENSIONS_ALL' , 'CN_RATE_DIMENSIONS' , 'CN' ,'N','N');
1028 add_list('CN_RATE_SCH_DIMS_ALL' , 'CN_RATE_SCH_DIMS' , 'CN' ,'N','N');
1029 add_list('CN_RATE_SCHEDULES_ALL' , 'CN_RATE_SCHEDULES' , 'CN' ,'N','N');
1030 add_list('CN_RATE_TIERS_ALL' , 'CN_RATE_TIERS' , 'CN' ,'N','N');
1031 add_list('CN_REASONS_ALL' , 'CN_REASONS' , 'CN' ,'N','N');
1032 add_list('CN_REPOSITORIES_ALL' , 'CN_REPOSITORIES' , 'CN' ,'Y','N');
1033 add_list('CN_REVENUE_CLASSES_ALL' , 'CN_REVENUE_CLASSES' , 'CN' ,'N','N');
1034 add_list('CN_ROLE_PLANS_ALL' , 'CN_ROLE_PLANS' , 'CN' ,'N','N');
1035 add_list('CN_RT_FORMULA_ASGNS_ALL' , 'CN_RT_FORMULA_ASGNS' , 'CN' ,'N','N');
1036 add_list('CN_RT_QUOTA_ASGNS_ALL' , 'CN_RT_QUOTA_ASGNS' , 'CN' ,'N','N');
1037 add_list('CN_RULE_ATTR_EXPRESSION_ALL' , 'CN_RULE_ATTR_EXPRESSION' , 'CN' ,'N','N');
1038 add_list('CN_RULESETS_ALL_B' , 'CN_RULESETS_ALL_VL' , 'CN' ,'Y','N');
1039 add_list('CN_RULESETS_ALL_TL' , 'CN_RULESETS_ALL_VL' , 'CN' ,'Y','N');
1040 add_list('CN_RULES_ALL_B' , 'CN_RULES_ALL_VL' , 'CN' ,'Y','N');
1041 add_list('CN_RULES_ALL_TL' , 'CN_RULES_ALL_VL' , 'CN' ,'Y','N');
1042 add_list('CN_RULES_HIERARCHY_ALL' , 'CN_RULES_HIERARCHY' , 'CN' ,'N','N');
1043 add_list('CN_SALESREPS_API_ALL' , 'CN_SALESREPS_API' , 'CN' ,'N','N');
1044 add_list('CN_SCH_DIM_TIERS_ALL' , 'CN_SCH_DIM_TIERS' , 'CN' ,'N','N');
1045 add_list('CN_SCA_RULE_ATTRIBUTES_ALL_B' , 'CN_SCA_RULE_ATTRIBUTES_ALL_VL' , 'CN' ,'Y','N');
1046 add_list('CN_SCA_RULE_ATTRIBUTES_ALL_TL' , 'CN_SCA_RULE_ATTRIBUTES_ALL_VL' , 'CN' ,'Y','N');
1047 add_list('CN_SEC_PROF_ASSIGNS_ALL' , 'CN_SEC_PROF_ASSIGNS' , 'CN' ,'N','N');
1048 add_list('CN_SECURITY_PROFILES_ALL' , 'CN_SECURITY_PROFILES' , 'CN' ,'N','N');
1049 add_list('CN_SOURCE_ALL' , 'CN_SOURCE' , 'CN' ,'N','N');
1050 add_list('CN_SRP_INTEL_PERIODS_ALL' , 'CN_SRP_INTEL_PERIODS' , 'CN' ,'N','N');
1051 add_list('CN_SRP_PAY_GROUPS_ALL' , 'CN_SRP_PAY_GROUPS' , 'CN' ,'N','N');
1052 add_list('CN_SRP_PAYEE_ASSIGNS_ALL' , 'CN_SRP_PAYEE_ASSIGNS' , 'CN' ,'N','N');
1053 add_list('CN_SRP_PERIODS_ALL' , 'CN_SRP_PERIODS' , 'CN' ,'N','N');
1054 add_list('CN_SRP_PERIOD_PAYEES_ALL' , 'CN_SRP_PERIOD_PAYEES' , 'CN' ,'N','N');
1055 add_list('CN_SRP_PERIOD_QUOTAS_ALL' , 'CN_SRP_PERIOD_QUOTAS' , 'CN' ,'N','N');
1056 add_list('CN_SRP_PER_QUOTA_RC_ALL' , 'CN_SRP_PER_QUOTA_RC' , 'CN' ,'N','N');
1057 add_list('CN_SRP_PLAN_ASSIGNS_ALL' , 'CN_SRP_PLAN_ASSIGNS' , 'CN' ,'N','N');
1058 add_list('CN_SRP_PMT_PLANS_ALL' , 'CN_SRP_PMT_PLANS' , 'CN' ,'N','N');
1059 add_list('CN_SRP_QUOTA_ASSIGNS_ALL' , 'CN_SRP_QUOTA_ASSIGNS' , 'CN' ,'N','N');
1060 add_list('CN_SRP_QUOTA_RULES_ALL' , 'CN_SRP_QUOTA_RULES' , 'CN' ,'N','N');
1061 add_list('CN_SRP_RATE_ASSIGNS_ALL' , 'CN_SRP_RATE_ASSIGNS' , 'CN' ,'N','N');
1062 add_list('CN_SRP_RULE_UPLIFTS_ALL' , 'CN_SRP_RULE_UPLIFTS' , 'CN' ,'N','N');
1063 add_list('CN_LEDGER_BAL_TYPES_ALL_B' , 'CN_LEDGER_BAL_TYPES_ALL_VL' , 'CN' ,'Y','N');
1064 add_list('CN_LEDGER_BAL_TYPES_ALL_TL' , 'CN_LEDGER_BAL_TYPES_ALL_VL' , 'CN' ,'Y','N');
1065 add_list('CN_TABLE_MAPS_ALL' , 'CN_TABLE_MAPS' , 'CN' ,'Y','N');
1066 add_list('CN_TABLE_MAP_OBJECTS_ALL' , 'CN_TABLE_MAP_OBJECTS' , 'CN' ,'Y','N');
1067 add_list('CN_TRX_ALL' , 'CN_TRX' , 'CN' ,'N','N');
1068 add_list('CN_TRX_BATCHES_ALL' , 'CN_TRX_BATCHES' , 'CN' ,'N','N');
1069 add_list('CN_TRX_FACTORS_ALL' , 'CN_TRX_FACTORS' , 'CN' ,'N','N');
1070 add_list('CN_TRX_LINES_ALL' , 'CN_TRX_LINES' , 'CN' ,'N','N');
1071 add_list('CN_TRX_SALES_LINES_ALL' , 'CN_TRX_SALES_LINES' , 'CN' ,'N','N');
1072 add_list('CN_WORKSHEET_BONUSES_ALL' , 'CN_WORKSHEET_BONUSES' , 'CN' ,'N','N');
1073 --
1074 add_list('CS_ACCESS_CONTROL_TEMPLATE_ALL' , 'CS_ACCESS_CONTROL_TEMPLATES' , 'CS' ,'N','N');
1078 add_list('CS_ORDERS_INTERFACE_ALL' , 'CS_ORDERS_INTERFACE' , 'CS' ,'N','N');
1075 add_list('CS_CP_SERVICES_ALL' , 'CS_CP_SERVICES' , 'CS' ,'N','N');
1076 add_list('CS_ESTIMATE_HEADERS_ALL' , 'CS_ESTIMATE_HEADERS' , 'CS' ,'N','N');
1077 add_list('CS_INCIDENTS_ALL' , 'CS_INCIDENTS' , 'CS' ,'N','N');
1079 add_list('CS_REPAIRS_ALL' , 'CS_REPAIRS' , 'CS' ,'N','N');
1080 add_list('CS_SYSTEMS_ALL_B' , 'CS_SYSTEMS_VL' , 'CS' ,'N','N');
1081 add_list('CS_SYSTEM_PARAMETERS_ALL' , 'CS_SYSTEM_PARAMETERS' , 'CS' ,'N','N');
1082 add_list('CS_TERMINATION_INTERFACE_ALL' , 'CS_TERMINATION_INTERFACE' , 'CS' ,'N','N');
1083 --
1084 add_list('CSR_WIN_PROMIS_ALL_B' , 'CSR_WIN_PROMIS_VL' , 'CSR' ,'Y','N');
1085 add_list('CSR_COSTS_ALL_B' , 'CSR_COSTS_VL' , 'CSR' ,'Y','N');
1086 --
1087 add_list('FPT_AP_HEADERS_ALL' , 'FPT_AP_HEADERS_V' , 'FPT' ,'N','N');
1088 add_list('FPT_BK_ACCOUNTS_ALL' , 'FPT_ACCOUNTS_V' , 'FPT' ,'N','N');
1089 add_list('FPT_BK_TRANSACTIONS_ALL' , 'FPT_BK_TRANSACTIONS_V' , 'FPT' ,'N','N');
1090 add_list('FPT_FN_HEADERS_ALL' , 'FPT_FN_HEADERS_ALL_V' , 'FPT' ,'N','N');
1091 --
1092 add_list('GMS_AWARDS_ALL' , 'GMS_AWARDS' , 'GMS' ,'N','N');
1093 add_list('GMS_FUNDING_PATTERNS_ALL' , 'GMS_FUNDING_PATTERNS' , 'GMS' ,'N','N');
1094 add_list('GMS_IMPLEMENTATIONS_ALL' , 'GMS_IMPLEMENTATIONS' , 'GMS' ,'N','N');
1095 add_list('GMS_TRANSACTION_INTERFACE_ALL' , 'GMS_TRANSACTION_INTERFACE' , 'GMS' ,'N','N');
1096 add_list('GMS_ENCUMBRANCES_ALL' , 'GMS_ENCUMBRANCES' , 'GMS' ,'N','N');
1097 add_list('GMS_ENCUMBRANCE_GROUPS_ALL' , 'GMS_ENCUMBRANCE_GROUPS' , 'GMS' ,'N','N');
1098 add_list('GMS_ENCUMBRANCE_ITEMS_ALL' , 'GMS_ENCUMBRANCE_ITEMS' , 'GMS' ,'N','N');
1099
1100 --
1101
1102 add_list('IBE_SH_SHP_LISTS_ALL' , 'IBE_SH_SHP_LISTS' , 'IBE' ,'N','N');
1103 add_list('IBE_SHP_LIST_ITEMS_ALL' , 'IBE_SH_SHP_LIST_ITEMS' , 'IBE' ,'N','N');
1104
1105 --
1106 add_list('IGW_IMPLEMENTATIONS_ALL' , 'IGW_IMPLEMENTATIONS' , 'IGW' ,'N','N');
1107 add_list('IGW_PROPOSALS_ALL' , 'IGW_PROPOSALS' , 'IGW' ,'N','N');
1108 add_list('IGW_BUSINESS_RULES_ALL' , 'IGW_BUSINESS_RULES' , 'IGW' ,'N','N');
1109 add_list('IGW_ORG_MAPS_ALL' , 'IGW_ORG_MAPS_V' , 'IGW' ,'N','N');
1110
1111 add_list('IPA_ASSET_NAMING_CONVENTS_ALL' , 'IPA_ASSET_NAMING_CONVENTIONS' , 'IPA' ,'N','N');
1112
1113 --
1114 add_list('FV_1099C_ALL' , 'FV_1099C' , 'FV' ,'N','N');
1115 add_list('FV_AAN_SETUP_DETAILS_ALL' , 'FV_AAN_SETUP_DETAILS' , 'FV' ,'N','N');
1116 add_list('FV_AAN_SETUP_HDRS_ALL' , 'FV_AAN_SETUP_HDRS' , 'FV' ,'N','N');
1117 add_list('FV_AR_BATCHES_ALL' , 'FV_AR_BATCHES' , 'FV' ,'N','N');
1118 add_list('FV_AR_CONTROLS_ALL' , 'FV_AR_CONTROLS' , 'FV' ,'N','N');
1119 add_list('FV_ASSIGN_REASON_CODES_ALL' , 'FV_ASSIGN_REASON_CODES' , 'FV' ,'N','N');
1120 add_list('FV_CUST_FINANCE_CHRGS_ALL' , 'FV_CUST_FINANCE_CHRGS' , 'FV' ,'N','N');
1121 add_list('FV_FINANCE_CHARGE_CONTROLS_ALL' , 'FV_FINANCE_CHARGE_CONTROLS' , 'FV' ,'N','N');
1122 add_list('FV_INTERAGENCY_FUNDS_ALL' , 'FV_INTERAGENCY_FUNDS' , 'FV' ,'N','N');
1123 add_list('FV_INTERIM_CASH_RECEIPTS_ALL' , 'FV_INTERIM_CASH_RECEIPTS' , 'FV' ,'N','N');
1124 add_list('FV_INVOICE_FINANCE_CHRGS_ALL' , 'FV_INVOICE_FINANCE_CHRGS' , 'FV' ,'N','N');
1125 add_list('FV_INVOICE_RETURNS_ALL' , 'FV_INVOICE_RETURNS' , 'FV' ,'N','N');
1126 add_list('FV_INVOICE_RETURN_DATES_ALL' , 'FV_INVOICE_RETURN_DATES' , 'FV' ,'N','N');
1127 add_list('FV_INVOICE_STATUSES_ALL' , 'FV_INVOICE_STATUSES' , 'FV' ,'N','N');
1128 add_list('FV_INVOICE_STATUSES_HIST_ALL' , 'FV_INVOICE_STATUSES_HIST' , 'FV' ,'N','N');
1129 add_list('FV_OPAC_AUDIT_ALL' , 'FV_OPAC_AUDIT' , 'FV' ,'N','N');
1130 add_list('FV_OPAC_BILLING_ALL' , 'FV_OPAC_BILLING' , 'FV' ,'N','N');
1131 add_list('FV_OPERATING_UNITS_ALL' , 'FV_OPERATING_UNITS' , 'FV' ,'N','N');
1132 add_list('FV_RECEIVABLE_TYPES_ALL' , 'FV_RECEIVABLE_TYPES' , 'FV' ,'N','N');
1133 add_list('FV_REC_CUST_TRX_TYPES_ALL' , 'FV_REC_CUST_TRX_TYPES' , 'FV' ,'N','N');
1134 add_list('FV_REFUNDS_VOIDS_ALL' , 'FV_REFUNDS_VOIDS' , 'FV' ,'N','N');
1135 add_list('FV_TREASURY_CONFIRMATIONS_ALL' , 'FV_TREASURY_CONFIRMATIONS' , 'FV' ,'N','N');
1136 --
1137 add_list('JE_ES_MESSAGES_ALL' , 'JE_ES_MESSAGES' , 'JE' ,'N','N');
1138 add_list('JE_ES_MODELO_190_ALL' , 'JE_ES_MODELO_190' , 'JE' ,'N','N');
1139 add_list('JE_ES_MODELO_347_ALL' , 'JE_ES_MODELO_347' , 'JE' ,'N','N');
1140 add_list('JE_ES_MODELO_349_ALL' , 'JE_ES_MODELO_349' , 'JE' ,'N','N');
1141 add_list('JE_ES_MODELO_415_ALL' , 'JE_ES_MODELO_415' , 'JE' ,'N','N');
1142 add_list('JE_CZ_EFT_CONTRACTS_ALL' , 'JE_CZ_EFT_CONTRACTS' , 'JE' ,'N' ,'N' , null, 'SQLAP');
1143 add_list('JE_CZ_CONT_ALLOC_ALL' , 'JE_CZ_CONT_ALLOC' , 'JE' ,'N' ,'N', null, 'SQLAP');
1144 --
1145 add_list('JG_ZZ_AR_SRC_TRX_TY_ALL' , 'JG_ZZ_AR_SRC_TRX_TY' , 'JG' ,'Y','N');
1149 add_list('JE_CZ_EFT_CONTRACTS_ALL' , 'JE_CZ_EFT_CONTRACTS' , 'JE' ,'N' ,'N' , null, 'SQLAP');
1146 add_list('JG_ZZ_SYS_FORMATS_ALL_B' , 'JG_ZZ_SYS_FORMATS' , 'JG' ,'N' ,'N', null, 'SQLAP');
1147 add_list('JG_ZZ_SYS_FORMATS_ALL_TL' , 'JG_ZZ_SYS_FORMATS_VL' , 'JG' ,'N' ,'N', null, 'SQLAP');
1148 --
1150 add_list('JE_CZ_CONT_ALLOC_ALL' , 'JE_CZ_CONT_ALLOC' , 'JE' ,'N' ,'N', null, 'SQLAP');
1151 --
1152 add_list('JL_AR_AP_AWT_CERTIF_ALL' , 'JL_AR_AP_AWT_CERTIF' , 'JL' ,'N','N');
1153 add_list('JL_AR_AR_DOC_LETTER_ALL' , 'JL_AR_AR_DOC_LETTER' , 'JL' ,'N','N');
1154
1155 add_list('JL_BR_AP_COLLECTION_DOCS_ALL' , 'JL_BR_AP_COLLECTION_DOCS' , 'JL' ,'N','N');
1156 add_list('JL_BR_AP_CONSOLID_INVOICES_ALL' , 'JL_BR_AP_CONSOLID_INVOICES' , 'JL' ,'N','N');
1157 --
1158 -- JL_BR_AP_EXP_REP_HEAD_EXT_ALL is MRC related and does not have
1159 -- corresponding view. Setting it to JL_BR_AP_EXP_REP_HEAD_EXT_ALL
1160 --
1161 add_list('JL_BR_AP_INT_COLLECT_ALL' , 'JL_BR_AP_INT_COLLECT' , 'JL' ,'N','N');
1162 add_list('JL_BR_AP_INT_COLLECT_EXT_ALL' , 'JL_BR_AP_INT_COLLECT_EXT' , 'JL' ,'N','N');
1163 add_list('JL_BR_AR_BANK_RETURNS_ALL' , 'JL_BR_AR_BANK_RETURNS' , 'JL' ,'N','N');
1164 add_list('JL_BR_AR_BORDEROS_ALL' , 'JL_BR_AR_BORDEROS' , 'JL' ,'N','N');
1165 add_list('JL_BR_AR_COLLECTION_DOCS_ALL' , 'JL_BR_AR_COLLECTION_DOCS' , 'JL' ,'N','N');
1166 add_list('JL_BR_AR_COMP_INV_ALL' , 'JL_BR_AR_COMP_INV' , 'JL' ,'N','N');
1167 add_list('JL_BR_AR_OCCURRENCE_DOCS_ALL' , 'JL_BR_AR_OCCURRENCE_DOCS' , 'JL' ,'N','N');
1168 add_list('JL_BR_AR_REC_MET_ACCTS_EXT_ALL' , 'JL_BR_AR_REC_MET_ACCTS_EXT' , 'JL' ,'N','N');
1169 add_list('JL_BR_AR_REMIT_BORDEROS_ALL' , 'JL_BR_AR_REMIT_BORDEROS' , 'JL' ,'N','N');
1170 add_list('JL_BR_AR_RET_INTERFACE_ALL' , 'JL_BR_AR_RET_INTERFACE' , 'JL' ,'N','N');
1171 add_list('JL_BR_AR_RET_INTERFACE_EXT_ALL' , 'JL_BR_AR_RET_INTERFACE_EXT' , 'JL' ,'N','N');
1172 add_list('JL_BR_AR_SELECT_ACCOUNTS_ALL' , 'JL_BR_AR_SELECT_ACCOUNTS' , 'JL' ,'N','N');
1173 add_list('JL_BR_AR_SELECT_CONTROLS_ALL' , 'JL_BR_AR_SELECT_CONTROLS' , 'JL' ,'N','N');
1174 add_list('JL_BR_AR_TX_CATEG_ALL' , 'JL_BR_AR_TX_CATEG' , 'JL' ,'Y','N');
1175 add_list('JL_BR_AR_TX_EXC_ITM_ALL' , 'JL_BR_AR_TX_EXC_ITM' , 'JL' ,'N','N');
1176 add_list('JL_BR_AR_TX_FSC_CLS_ALL' , 'JL_BR_AR_TX_FSC_CLS' , 'JL' ,'N','N');
1177 add_list('JL_BR_AR_TX_GROUP_ALL' , 'JL_BR_AR_TX_GROUP' , 'JL' ,'N','N');
1178 add_list('JL_BR_AR_TX_LOCN_ALL' , 'JL_BR_AR_TX_LOCN' , 'JL' ,'N','N');
1179 add_list('JL_BR_AR_TX_RULES_ALL' , 'JL_BR_AR_TX_RULES' , 'JL' ,'N','N');
1180 add_list('JL_BR_BALANCES_ALL' , 'JL_BR_BALANCES' , 'JL' ,'N','N');
1181 add_list('JL_BR_JOURNALS_ALL' , 'JL_BR_JOURNALS' , 'JL' ,'N','N');
1182 add_list('JL_BR_PO_FISC_CLASSIF_ALL' , 'JL_BR_PO_FISC_CLASSIF' , 'JL' ,'N','N');
1183 add_list('JL_BR_PO_TAX_EXCEPTIONS_ALL' , 'JL_BR_PO_TAX_EXCEPTIONS' , 'JL' ,'N','N');
1184 add_list('JL_BR_PO_TAX_EXC_ITEMS_ALL' , 'JL_BR_PO_TAX_EXC_ITEMS' , 'JL' ,'N','N');
1185 add_list('JL_BR_PO_TAX_LOCATIONS_ALL' , 'JL_BR_PO_TAX_LOCATIONS' , 'JL' ,'N','N');
1186 add_list('JL_BR_TAX_LMSG_ALL' , 'JL_BR_TAX_LMSG' , 'JL' ,'N','N');
1187 add_list('JL_ZZ_AP_INV_DIS_WH_ALL' , 'JL_ZZ_AP_INV_DIS_WH' , 'JL' ,'N','N');
1188 add_list('JL_ZZ_AP_SUP_AWT_CD_ALL' , 'JL_ZZ_AP_SUP_AWT_CD' , 'JL' ,'N','N');
1189 add_list('JL_ZZ_AR_TX_ATT_CLS_ALL' , 'JL_ZZ_AR_TX_ATT_CLS' , 'JL' ,'Y','N');
1190 add_list('JL_ZZ_AR_TX_ATT_VAL_ALL' , 'JL_ZZ_AR_TX_ATT_VAL' , 'JL' ,'Y','N');
1191 add_list('JL_ZZ_AR_TX_CAT_ATT_ALL' , 'JL_ZZ_AR_TX_CAT_ATT' , 'JL' ,'Y','N');
1192 add_list('JL_ZZ_AR_TX_CAT_DTL_ALL' , 'JL_ZZ_AR_TX_CAT_DTL' , 'JL' ,'N','N');
1193 add_list('JL_ZZ_AR_TX_CATEG_ALL' , 'JL_ZZ_AR_TX_CATEG' , 'JL' ,'Y','N');
1194 add_list('JL_ZZ_AR_TX_CUS_CLS_ALL' , 'JL_ZZ_AR_TX_CUS_CLS' , 'JL' ,'N','N');
1195 add_list('JL_ZZ_AR_TX_EXC_CUS_ALL' , 'JL_ZZ_AR_TX_EXC_CUS' , 'JL' ,'N','N');
1196 add_list('JL_ZZ_AR_TX_EXC_FSC_ALL' , 'JL_ZZ_AR_TX_EXC_FSC' , 'JL' ,'N','N');
1197 add_list('JL_ZZ_AR_TX_EXC_ITM_ALL' , 'JL_ZZ_AR_TX_EXC_ITM' , 'JL' ,'N','N');
1198 add_list('JL_ZZ_AR_TX_FSC_CLS_ALL' , 'JL_ZZ_AR_TX_FSC_CLS' , 'JL' ,'N','N');
1199 add_list('JL_ZZ_AR_TX_GROUPS_ALL' , 'JL_ZZ_AR_TX_GROUPS' , 'JL' ,'N','N');
1200 add_list('JL_ZZ_AR_TX_LGL_MSG_ALL' , 'JL_ZZ_AR_TX_LGL_MSG' , 'JL' ,'N','N');
1201 add_list('JL_ZZ_AR_TX_LOCN_ALL' , 'JL_ZZ_AR_TX_LOCN' , 'JL' ,'N','N');
1202 add_list('JL_ZZ_AR_TX_NAT_RAT_ALL' , 'JL_ZZ_AR_TX_NAT_RAT' , 'JL' ,'N','N');
1203 add_list('JL_ZZ_AR_TX_RULES_ALL' , 'JL_ZZ_AR_TX_RULES' , 'JL' ,'N','N');
1204 add_list('JL_ZZ_AR_TX_SCHEDULES_ALL' , 'JL_ZZ_AR_TX_SCHEDULES' , 'JL' ,'N','N');
1205 --
1206 add_list('JTF_TERR_ALL' , 'JTF_TERR' , 'JTF' ,'Y','N');
1207 --add_list('JTF_QUAL_TYPE_USGS_ALL' , 'JTF_QUAL_TYPE_USGS' , 'JTF' ,'Y','N');
1208 --add_list('JTF_QUAL_TYPES_ALL' , 'JTF_QUAL_TYPES' , 'JTF' ,'Y','N');
1209 add_list('JTF_QUAL_USGS_ALL' , 'JTF_QUAL_USGS' , 'JTF' ,'Y','N');
1210 --add_list('JTF_SEEDED_QUAL_ALL_B' , 'JTF_SEEDED_QUAL' , 'JTF' ,'Y','N');
1214 add_list('JTF_FM_QUERIES_ALL' , 'JTF_FM_QUERY' , 'JTF' ,'Y','N');
1211 --add_list('JTF_SEEDED_QUAL_ALL_TL' , 'JTF_SEEDED_QUAL' , 'JTF' ,'Y','N');
1212 --add_list('JTF_SOURCES_ALL' , 'JTF_SOURCES' , 'JTF' ,'Y','N');
1213 add_list('JTF_FM_GROUPS_ALL' , 'JTF_FM_GROUP' , 'JTF' ,'N','N');
1215 add_list('JTF_FM_SERVICE_ALL' , 'JTF_FM_SERVICE' , 'JTF' ,'N','N');
1216 add_list('JTF_FM_TEMPLATE_ALL' , 'JTF_FM_TEMPLATE' , 'JTF' ,'Y','N');
1217 add_list('JTF_FM_STATUS_ALL' , 'JTF_FM_STATUS' , 'JTF' ,'N','N');
1218 add_list('JTF_FM_REQUEST_HISTORY_ALL' , 'JTF_FM_REQUEST_HISTORY' , 'JTF' ,'N','N');
1219 add_list('JTF_CHANGED_TERR_ALL' , 'JTF_CHANGED_TERR' , 'JTF' ,'N','N');
1220 add_list('JTF_TERR_QTYPE_USGS_ALL' , 'JTF_TERR_QTYPE_USGS' , 'JTF' ,'N','N');
1221 add_list('JTF_TERR_QUAL_ALL' , 'JTF_TERR_QUAL' , 'JTF' ,'N','N');
1222 add_list('JTF_TERR_USGS_ALL' , 'JTF_TERR_USGS' , 'JTF' ,'N','N');
1223 add_list('JTF_TERR_VALUES_ALL' , 'JTF_TERR_VALUES' , 'JTF' ,'N','N');
1224 add_list('JTF_TERR_RSC_ACCESS_ALL' , 'JTF_TERR_RSC_ACCESS' , 'JTF' ,'N','N');
1225 add_list('JTF_TERR_RSC_ALL' , 'JTF_TERR_RSC' , 'JTF' ,'N','N');
1226 add_list('JTF_TERR_TYPE_QUAL_ALL' , 'JTF_TERR_TYPE_QUAL' , 'JTF' ,'N','N');
1227 add_list('JTF_TERR_TYPE_USGS_ALL' , 'JTF_TERR_TYPE_USGS' , 'JTF' ,'Y','N');
1228 add_list('JTF_TERR_TYPES_ALL' , 'JTF_TERR_TYPES' , 'JTF' ,'Y','N');
1229 add_list('JTF_TYPE_QTYPE_USGS_ALL' , 'JTF_TYPE_QTYPE_USGS' , 'JTF' ,'Y','N');
1230 add_list('JTF_RS_SALESREPS' , 'JTF_RS_SALESREPS_MO_V' , 'JTF' ,'Y','N');
1231 --
1232 add_list('SO_HEADERS_ALL' , 'SO_HEADERS' , 'OE' ,'N','N');
1233 add_list('SO_HEADERS_INTERFACE_ALL' , 'SO_HEADERS_INTERFACE' , 'OE' ,'N','N');
1234 add_list('SO_HOLD_SOURCES_ALL' , 'SO_HOLD_SOURCES' , 'OE' ,'N','N');
1235 add_list('SO_LINES_ALL' , 'SO_LINES' , 'OE' ,'N','N');
1236 add_list('SO_LINES_INTERFACE_ALL' , 'SO_LINES_INTERFACE' , 'OE' ,'N','N');
1237 add_list('SO_ORDER_HOLDS_ALL' , 'SO_ORDER_HOLDS_115' , 'OE' ,'N','N');
1238 add_list('SO_ORDER_TYPES_115_ALL' , 'SO_ORDER_TYPES_115' , 'OE' ,'N','N');
1239 add_list('SO_PICKING_BATCHES_ALL' , 'SO_PICKING_BATCHES' , 'OE' ,'N','N');
1240 add_list('SO_PICKING_HEADERS_ALL' , 'SO_PICKING_HEADERS' , 'OE' ,'N','N');
1241 add_list('SO_PICKING_LINES_ALL' , 'SO_PICKING_LINES' , 'OE' ,'N','N');
1242 --
1243 add_list('OE_ACTIONS_IFACE_ALL' , 'OE_ACTIONS_INTERFACE' , 'ONT' ,'N','N');
1244 add_list('OE_BLANKET_HEADERS_ALL' , 'OE_BLANKET_HEADERS' , 'ONT' ,'N', 'N');
1245 add_list('OE_BLANKET_LINES_ALL' , 'OE_BLANKET_LINES' , 'ONT' ,'N', 'N');
1246 add_list('OE_CREDIT_BALANCES_ALL' , 'OE_CREDIT_BALANCES' , 'ONT' ,'N', 'N');
1247 add_list('OE_CUST_TOTAL_AMTS_ALL' , 'OE_CUST_TOTAL_AMTS' , 'ONT' ,'N', 'N');
1248 add_list('OE_CREDITS_IFACE_ALL' , 'OE_CREDITS_INTERFACE' , 'ONT' ,'N','N');
1249 add_list('OE_EM_INFORMATION_ALL' , 'OE_EM_INFORMATION' , 'ONT' ,'N','N');
1250 add_list('OE_HEADERS_IFACE_ALL' , 'OE_HEADERS_INTERFACE' , 'ONT' ,'N','N');
1251 add_list('OE_ITEM_CUST_VOLS_ALL' , 'OE_ITEM_CUST_VOLS' , 'ONT' ,'N', 'N');
1252 add_list('OE_LINES_IFACE_ALL' , 'OE_LINES_INTERFACE' , 'ONT' ,'N','N');
1253 add_list('OE_LOTSERIALS_IFACE_ALL' , 'OE_LOTSERIALS_INTERFACE' , 'ONT' ,'N','N');
1254 add_list('OE_RESERVTNS_IFACE_ALL' , 'OE_RESERVTNS_INTERFACE' , 'ONT' ,'N','N');
1255 add_list('OE_HOLD_SOURCES_ALL' , 'OE_HOLD_SOURCES' , 'ONT' ,'N','N');
1256 add_list('OE_ORDER_HEADERS_ALL' , 'OE_ORDER_HEADERS' , 'ONT' ,'N','N');
1257 add_list('OE_ORDER_HOLDS_ALL' , 'OE_ORDER_HOLDS' , 'ONT' ,'N','N');
1258 add_list('OE_ORDER_LINES_ALL' , 'OE_ORDER_LINES' , 'ONT' ,'N','N');
1259 add_list('OE_PAYMENTS_IFACE_ALL' , 'OE_PAYMENTS_INTERFACE' , 'ONT' ,'N', 'N');
1260 add_list('OE_PAYMENT_TYPES_ALL' , 'OE_PAYMENT_TYPES_VL' , 'ONT' ,'Y','N');
1261 add_list('OE_PAYMENT_TYPES_TL' , 'OE_PAYMENT_TYPES_VL' , 'ONT' ,'Y','N');
1262 add_list('OE_PRICE_ADJS_IFACE_ALL' , 'OE_PRICE_ADJS_INTERFACE' , 'ONT' ,'N','N');
1263 add_list('OE_PRICE_ATTS_IFACE_ALL' , 'OE_PRICE_ATTS_INTERFACE' , 'ONT' ,'N','N');
1264 add_list('OE_SYS_PARAMETERS_ALL' , 'OE_SYS_PARAMETERS_V' , 'ONT' ,'N','N');
1265 add_list('OE_SYSTEM_PARAMETERS_ALL' , 'OE_SYSTEM_PARAMETERS' , 'ONT' ,'N','N');
1266 add_list('OE_TRANSACTION_TYPES_ALL' , 'OE_TRANSACTION_TYPES_VL' , 'ONT' ,'N','N');
1267 --
1268 add_list('PA_ALL_ORGANIZATIONS' , 'PA_ALL_ORGANIZATIONS' , 'PA' ,'N','N');
1269 add_list('PA_BC_COMMITMENTS_ALL' , 'PA_BC_COMMITMENTS' , 'PA' ,'N','N');
1270 --
1271 add_list('AS_ACCESSES_ALL' , 'AS_ACCESSES' , 'AS' ,'N','N');
1272 add_list('AS_ACCESSES_ALL_ALL' , 'AS_ACCESSES' , 'AS' ,'N','N');
1273 add_list('AS_ACCESSES_ALL_ALL' , 'AS_ACCESSES_ALL' , 'AS' ,'N','N');
1274 add_list('AS_CHANGED_ACCOUNTS_ALL' , 'AS_CHANGED_ACCOUNTS' , 'AS' ,'N','N');
1278 add_list('AS_INTEREST_CATEGORY_SETS_ALL' , 'AS_INTEREST_CATEGORY_SETS' , 'AS' ,'N','N');
1275 add_list('AS_DEFAULT_PURCHASES_ALL' , 'AS_DEFAULT_PURCHASES' , 'AS' ,'N','N');
1276 add_list('AS_FORECAST_PROB_ALL_B' , 'AS_FORECAST_PROB' , 'AS' ,'N','N');
1277 add_list('AS_INTERESTS_ALL' , 'AS_INTERESTS' , 'AS' ,'N','N');
1279 add_list('AS_INTEREST_TYPES_ALL' , 'AS_INTEREST_TYPES' , 'AS' ,'N','N');
1280 add_list('AS_LEADS_ALL' , 'AS_LEADS' , 'AS' ,'N','N');
1281 add_list('AS_LEAD_CONTACTS_ALL' , 'AS_LEAD_CONTACTS' , 'AS' ,'N','N');
1282 add_list('AS_LEAD_LINES_ALL' , 'AS_LEAD_LINES' , 'AS' ,'N','N');
1283 add_list('AS_MERGE_FILES_ALL' , 'AS_MERGE_FILES' , 'AS' ,'N','N');
1284 add_list('AS_SALES_STAGES_ALL_B' , 'AS_SALES_STAGES' , 'AS' ,'N','N');
1285 --
1286 add_list('PA_AGREEMENTS_ALL' , 'PA_AGREEMENTS' , 'PA' ,'N','N');
1287 add_list('PA_ALLOC_RULES_ALL' , 'PA_ALLOC_RULES' , 'PA' ,'N','N');
1288 add_list('PA_ALLOC_RUNS_ALL' , 'PA_ALLOC_RUNS' , 'PA' ,'N','N');
1289 add_list('PA_BILLING_ASSIGNMENTS_ALL' , 'PA_BILLING_ASSIGNMENTS' , 'PA' ,'Y','N');
1290 add_list('PA_BILL_RATES_ALL' , 'PA_BILL_RATES' , 'PA' ,'N','N');
1291 add_list('PA_BIS_TOTALS_TO_DATE_ALL' , 'PA_BIS_TOTALS_TO_DATE' , 'PA' ,'N','N');
1292 add_list('PA_BIS_TOTALS_BY_PRD_ALL' , 'PA_BIS_TOTALS_BY_PRD' , 'PA' ,'N','N');
1293 add_list('PA_BIS_TO_DATE_DRILLS_ALL' , 'PA_BIS_TO_DATE_DRILLS' , 'PA' ,'N','N');
1294 add_list('PA_BIS_PRJ_TO_DATE_DRILLS_ALL' , 'PA_BIS_PRJ_TO_DATE_DRILLS' , 'PA' ,'N','N');
1295 add_list('PA_BIS_PRJ_BY_PRD_DRILLS_ALL' , 'PA_BIS_PRJ_BY_PRD_DRILLS' , 'PA' ,'N','N');
1296 add_list('PA_CC_DIST_LINES_ALL' , 'PA_CC_DIST_LINES' , 'PA' ,'N','N');
1297 add_list('PA_CINT_RATE_INFO_ALL' , 'PA_CINT_RATE_INFO' , 'PA' ,'N','N');
1298 add_list('PA_CINT_EXP_TYPE_EXCL_ALL' , 'PA_CINT_EXP_TYPE_EXCL' , 'PA' ,'N','N');
1299 add_list('PA_COMPENSATION_DETAILS_ALL' , 'PA_COMPENSATION_DETAILS' , 'PA' ,'N','N');
1300 add_list('PA_COMP_RULE_OT_DEFAULTS_ALL' , 'PA_COMP_RULE_OT_DEFAULTS' , 'PA' ,'N','N');
1301 add_list('PA_COST_DISTRIBUTION_LINES_ALL' , 'PA_COST_DISTRIBUTION_LINES' , 'PA' ,'N','N');
1302 add_list('PA_CUST_EVENT_RDL_ALL' , 'PA_CUST_EVENT_REV_DIST_LINES' , 'PA' ,'N','N');
1303 add_list('PA_CUST_REV_DIST_LINES_ALL' , 'PA_CUST_REV_DIST_LINES' , 'PA' ,'N','N');
1304 add_list('PA_DRAFT_INVOICES_ALL' , 'PA_DRAFT_INVOICES' , 'PA' ,'N','N');
1305 add_list('PA_DRAFT_INVOICE_DETAILS_ALL' , 'PA_DRAFT_INVOICE_DETAILS' , 'PA' ,'N','N');
1306 add_list('PA_DRAFT_REVENUES_ALL' , 'PA_DRAFT_REVENUES' , 'PA' ,'N','N');
1307 add_list('PA_EMPLOYEE_ACCUM_ALL' , 'PA_EMPLOYEE_ACCUM' , 'PA' ,'N','N');
1308 add_list('PA_EMPLOYEE_ORG_ACCUM_ALL' , 'PA_EMPLOYEE_ORG_ACCUM' , 'PA' ,'N','N');
1309 add_list('PA_EVENT_TYPE_OUS_ALL' , 'PA_EVENT_TYPE_OUS' , 'PA' ,'N','N');
1310 add_list('PA_EXPENDITURES_ALL' , 'PA_EXPENDITURES' , 'PA' ,'N','N');
1311 add_list('PA_EXPENDITURE_BATCHES_ALL' , 'PA_EXPENDITURE_BATCHES' , 'PA' ,'N','N');
1312 add_list('PA_EXPENDITURE_COST_RATES_ALL' , 'PA_EXPENDITURE_COST_RATES' , 'PA' ,'N','N');
1313 add_list('PA_EXPENDITURE_GROUPS_ALL' , 'PA_EXPENDITURE_GROUPS' , 'PA' ,'N','N');
1314 add_list('PA_EXPENDITURE_ITEMS_ALL' , 'PA_EXPENDITURE_ITEMS' , 'PA' ,'N','N');
1315 add_list('PA_EXPENDITURE_TYPE_OUS_ALL' , 'PA_EXPENDITURE_TYPE_OUS' , 'PA' ,'N','N');
1316 add_list('PA_FUNCTION_TRANSACTIONS_ALL' , 'PA_FUNCTION_TRANSACTIONS' , 'PA' ,'Y','N');
1317 add_list('PA_IMPLEMENTATIONS_ALL' , 'PA_IMPLEMENTATIONS' , 'PA' ,'N','N');
1318 add_list('PA_MASS_UPDATE_BATCHES_ALL' , 'PA_MASS_UPDATE_BATCHES' , 'PA' ,'N','N');
1319 add_list('PA_PERIODS_ALL' , 'PA_PERIODS' , 'PA' ,'N','N');
1320 add_list('PA_PRJ_ACT_CMT_IT_ALL' , 'PA_PRJ_ACT_CMT_IT' , 'PA' ,'N','N');
1321 add_list('PA_PRJ_BGT_LINES_IT_ALL' , 'PA_PRJ_BGT_LINES_IT' , 'PA' ,'N','N');
1322 add_list('PA_PRJ_TYPES_IT_ALL' , 'PA_PRJ_TYPES_IT' , 'PA' ,'N','N');
1323 add_list('PA_PROJECTS_ALL' , 'PA_PROJECTS' , 'PA' ,'N','N');
1324 add_list('PA_PROJECTS_IT_ALL' , 'PA_PROJECTS_IT' , 'PA' ,'N','N');
1325 add_list('PA_PROJECT_ASSETS_ALL' , 'PA_PROJECT_ASSETS' , 'PA' ,'N','N');
1326 add_list('PA_PROJECT_ASSET_LINES_ALL' , 'PA_PROJECT_ASSET_LINES' , 'PA' ,'N','N');
1327 add_list('PA_PROJECT_TYPES_ALL' , 'PA_PROJECT_TYPES' , 'PA' ,'N','N');
1328 add_list('PA_PROJ_TYPE_DISTRIBUTIONS_ALL' , 'PA_PROJECT_TYPE_DISTRIBUTIONS' , 'PA' ,'N','N');
1329 add_list('PA_PROJ_TYPE_VERIFICATIONS_ALL' , 'PA_PROJECT_TYPE_VERIFICATIONS' , 'PA' ,'N','N');
1330 add_list('PA_SEGMENT_RULE_PAIRINGS_ALL' , 'PA_SEGMENT_RULE_PAIRINGS' , 'PA' ,'N','N');
1331 add_list('PA_STD_BILL_RATE_SCHEDULES_ALL' , 'PA_STD_BILL_RATE_SCHEDULES' , 'PA' ,'N','N');
1332 add_list('PA_TRANSACTION_INTERFACE_ALL' , 'PA_TRANSACTION_INTERFACE' , 'PA' ,'N','N');
1333 add_list('PA_TRANSACTION_XFACE_CTRL_ALL' , 'PA_TRANSACTION_XFACE_CONTROL' , 'PA' ,'N','N');
1334 add_list('PA_TSK_ACT_CMT_IT_ALL' , 'PA_TSK_ACT_CMT_IT' , 'PA' ,'N','N');
1338 add_list('PA_FORECASTING_OPTIONS_ALL' , 'PA_FORECASTING_OPTIONS' , 'PA' ,'N','N');
1335 add_list('PA_TSK_BGT_LINES_IT_ALL' , 'PA_TSK_BGT_LINES_IT' , 'PA' ,'N','N');
1336 add_list('PA_TXN_INTERFACE_AUDIT_ALL' , 'PA_TXN_INTERFACE_AUDIT' , 'PA' ,'N','N');
1337 add_list('PA_USAGE_COST_RATE_OVR_ALL' , 'PA_USAGE_COST_RATE_OVERRIDES' , 'PA' ,'N','N');
1339 add_list('PA_UTILIZATION_OPTIONS_ALL' , 'PA_UTILIZATION_OPTIONS' , 'PA' ,'N','N');
1340
1341 --------
1342
1343 add_list('PN_ACCOUNTING_EVENTS_ALL' , 'PN_ACCOUNTING_EVENTS' , 'PN' ,'N','N');
1344 add_list('PN_ADDRESSES_ALL' , 'PN_ADDRESSES' , 'PN' ,'N','N');
1345 add_list('PN_AE_HEADERS_ALL' , 'PN_AE_HEADERS' , 'PN' ,'N','N');
1346 add_list('PN_AE_LINES_ALL' , 'PN_AE_LINES' , 'PN' ,'N','N');
1347 add_list('PN_COMPANIES_ALL' , 'PN_COMPANIES' , 'PN' ,'N','N');
1348 add_list('PN_COMPANY_SITES_ALL' , 'PN_COMPANY_SITES' , 'PN' ,'N','N');
1349 add_list('PN_CONTACTS_ALL' , 'PN_CONTACTS' , 'PN' ,'N','N');
1350 add_list('PN_CONTACT_ASSIGNMENTS_ALL' , 'PN_CONTACT_ASSIGNMENTS' , 'PN' ,'N','N');
1351 add_list('PN_DISTRIBUTIONS_ALL' , 'PN_DISTRIBUTIONS' , 'PN' ,'N','N');
1352 add_list('PN_INDEX_EXCLUDE_TERM_ALL' , 'PN_INDEX_EXCLUDE_TERM' , 'PN' ,'N','N');
1353 add_list('PN_INDEX_LEASES_ALL' , 'PN_INDEX_LEASES' , 'PN' ,'N','N');
1354 add_list('PN_INDEX_LEASE_CONSTRAINTS_ALL' , 'PN_INDEX_LEASE_CONSTRAINTS' , 'PN' ,'N','N');
1355 add_list('PN_INDEX_LEASE_PERIODS_ALL' , 'PN_INDEX_LEASE_PERIODS' , 'PN' ,'N','N');
1356 add_list('PN_INDEX_LEASE_TERMS_ALL' , 'PN_INDEX_LEASE_TERMS' , 'PN' ,'N','N');
1357 add_list('PN_INSURANCE_REQUIREMENTS_ALL' , 'PN_INSURANCE_REQUIREMENTS' , 'PN' ,'N','N');
1358 add_list('PN_LANDLORD_SERVICES_ALL' , 'PN_LANDLORD_SERVICES' , 'PN' ,'N','N');
1359 add_list('PN_LEASES_ALL' , 'PN_LEASES' , 'PN' ,'N','N');
1360 add_list('PN_LEASE_CHANGES_ALL' , 'PN_LEASE_CHANGES' , 'PN' ,'N','N');
1361 add_list('PN_LEASE_DETAILS_ALL' , 'PN_LEASE_DETAILS' , 'PN' ,'N','N');
1362 add_list('PN_LEASE_MILESTONES_ALL' , 'PN_LEASE_MILESTONES' , 'PN' ,'N','N');
1363 add_list('PN_LEASE_TRANSACTIONS_ALL' , 'PN_LEASE_TRANSACTIONS' , 'PN' ,'N','N');
1364 add_list('PN_LOC_ACC_MAP_HDR_ALL' , 'PN_LOC_ACC_MAP_HDR' , 'PN' ,'N','N');
1365 add_list('PN_LOC_ACC_MAP_ALL' , 'PN_LOC_ACC_MAP' , 'PN' ,'N','N');
1366 add_list('PN_LOCATIONS_ALL' , 'PN_LOCATIONS' , 'PN' ,'N','N');
1367 add_list('PN_LOCATION_FEATURES_ALL' , 'PN_LOCATION_FEATURES' , 'PN' ,'N','N');
1368 add_list('PN_OPTIONS_ALL' , 'PN_OPTIONS' , 'PN' ,'N','N');
1369 add_list('PN_PAYMENT_ITEMS_ALL' , 'PN_PAYMENT_ITEMS' , 'PN' ,'N','N');
1370 add_list('PN_PAYMENT_SCHEDULES_ALL' , 'PN_PAYMENT_SCHEDULES' , 'PN' ,'N','N');
1371 add_list('PN_PAYMENT_TERMS_ALL' , 'PN_PAYMENT_TERMS' , 'PN' ,'N','N');
1372 add_list('PN_PHONES_ALL' , 'PN_PHONES' , 'PN' ,'N','N');
1373 add_list('PN_PROPERTIES_ALL' , 'PN_PROPERTIES' , 'PN' ,'N','N');
1374
1375 add_list('PN_REC_AGR_LINABAT_ALL' , 'PN_REC_AGR_LINABAT' , 'PN' ,'N','N');
1376 add_list('PN_REC_AGR_LINAREA_ALL' , 'PN_REC_AGR_LINAREA' , 'PN' ,'N','N');
1377 add_list('PN_REC_AGR_LINCONST_ALL' , 'PN_REC_AGR_LINCONST' , 'PN' ,'N','N');
1378 add_list('PN_REC_AGR_LINES_ALL' , 'PN_REC_AGR_LINES' , 'PN' ,'N','N');
1379 add_list('PN_REC_AGR_LINEXP_ALL' , 'PN_REC_AGR_LINEXP' , 'PN' ,'N','N');
1380 add_list('PN_REC_AGREEMENTS_ALL' , 'PN_REC_AGREEMENTS' , 'PN' ,'N','N');
1381 add_list('PN_REC_ARCL_ALL' , 'PN_REC_ARCL' , 'PN' ,'N','N');
1382 add_list('PN_REC_ARCL_DTL_ALL' , 'PN_REC_ARCL_DTL' , 'PN' ,'N','N');
1383 add_list('PN_REC_ARCL_DTLLN_ALL' , 'PN_REC_ARCL_DTLLN' , 'PN' ,'N','N');
1384 add_list('PN_REC_ARCL_EXC_ALL' , 'PN_REC_ARCL_EXC' , 'PN' ,'N','N');
1385 add_list('PN_REC_CALC_PERIODS_ALL' , 'PN_REC_CALC_PERIODS' , 'PN' ,'N','N');
1386 add_list('PN_REC_EXP_LINE_ALL' , 'PN_REC_EXP_LINE' , 'PN' ,'N','N');
1387 add_list('PN_REC_EXP_LINE_DTL_ALL' , 'PN_REC_EXP_LINE_DTL' , 'PN' ,'N','N');
1388 add_list('PN_REC_EXPCL_ALL' , 'PN_REC_EXPCL' , 'PN' ,'N','N');
1389 add_list('PN_REC_EXPCL_DTL_ALL' , 'PN_REC_EXPCL_DTL' , 'PN' ,'N','N');
1390 add_list('PN_REC_EXPCL_DTLACC_ALL' , 'PN_REC_EXPCL_DTLACC' , 'PN' ,'N','N');
1391 add_list('PN_REC_EXPCL_DTLLN_ALL' , 'PN_REC_EXPCL_DTLLN' , 'PN' ,'N','N');
1392 add_list('PN_REC_EXPCL_INC_ALL' , 'PN_REC_EXPCL_INC' , 'PN' ,'N','N');
1393 add_list('PN_REC_EXPCL_TYPE_ALL' , 'PN_REC_EXPCL_TYPE' , 'PN' ,'N','N');
1394 add_list('PN_REC_LINBILL_ALL' , 'PN_REC_LINBILL' , 'PN' ,'N','N');
1395 add_list('PN_REC_PERIOD_BILLREC_ALL' , 'PN_REC_PERIOD_BILLREC' , 'PN' ,'N','N');
1399 add_list('PN_SPACE_ASSIGN_CUST_ALL' , 'PN_SPACE_ASSIGN_CUST' , 'PN' ,'N','N');
1396 add_list('PN_REC_PERIOD_LINES_ALL' , 'PN_REC_PERIOD_LINES' , 'PN' ,'N','N');
1397
1398 add_list('PN_SPACE_ALLOCATIONS_ALL' , 'PN_SPACE_ALLOCATIONS' , 'PN' ,'N','N');
1400 add_list('PN_SPACE_ASSIGN_EMP_ALL' , 'PN_SPACE_ASSIGN_EMP' , 'PN' ,'N','N');
1401 add_list('PN_TENANCIES_ALL' , 'PN_TENANCIES' , 'PN' ,'N','N');
1402 add_list('PN_TERM_TEMPLATES_ALL' , 'PN_TERM_TEMPLATES' , 'PN' ,'N','N');
1403 add_list('PN_VAR_ABATEMENTS_ALL' , 'PN_VAR_ABATEMENTS' , 'PN' ,'N','N');
1404 add_list('PN_VAR_BKPTS_DET_ALL' , 'PN_VAR_BKPTS_DET' , 'PN' ,'N','N');
1405 add_list('PN_VAR_BKPTS_HEAD_ALL' , 'PN_VAR_BKPTS_HEAD' , 'PN' ,'Y','N');
1406 add_list('PN_VAR_CONSTRAINTS_ALL' , 'PN_VAR_CONSTRAINTS' , 'PN' ,'Y','N');
1407 add_list('PN_VAR_DEDUCTIONS_ALL' , 'PN_VAR_DEDUCTIONS' , 'PN' ,'Y','N');
1408 add_list('PN_VAR_GRP_DATES_ALL' , 'PN_VAR_GRP_DATES' , 'PN' ,'N','N');
1409 add_list('PN_VAR_LINES_ALL' , 'PN_VAR_LINES' , 'PN' ,'Y','N');
1410 add_list('PN_VAR_PERIODS_ALL' , 'PN_VAR_PERIODS' , 'PN' ,'N','N');
1411 add_list('PN_VAR_RENTS_ALL' , 'PN_VAR_RENTS' , 'PN' ,'Y','N');
1412 add_list('PN_VAR_RENT_DATES_ALL' , 'PN_VAR_RENT_DATES' , 'PN' ,'Y','N');
1413 add_list('PN_VAR_RENT_INV_ALL' , 'PN_VAR_RENT_INV' , 'PN' ,'N','N');
1414 add_list('PN_VAR_RENT_SUMM_ALL' , 'PN_VAR_RENT_SUMM' , 'PN' ,'N','N');
1415 add_list('PN_VAR_VOL_HIST_ALL' , 'PN_VAR_VOL_HIST' , 'PN' ,'N','N');
1416
1417 --
1418 add_list('PO_ACCRUAL_ACCOUNTS_TEMP_ALL' , 'PO_ACCRUAL_ACCOUNTS_TEMP' , 'PO' ,'N','N');
1419 add_list('PO_ACCRUAL_RECONCILE_TEMP_ALL' , 'PO_ACCRUAL_RECONCILE_TEMP' , 'PO' ,'N','N');
1420 add_list('PO_ACCRUAL_WRITE_OFFS_ALL' , 'PO_ACCRUAL_WRITE_OFFS' , 'PO' ,'N','N');
1421 add_list('PO_AUTOSOURCE_DOCUMENTS_ALL' , 'PO_AUTOSOURCE_DOCUMENTS' , 'PO' ,'N','N');
1422 add_list('PO_CONTROL_GROUPS_ALL' , 'PO_CONTROL_GROUPS' , 'PO' ,'N','N');
1423 add_list('PO_DISTRIBUTIONS_ALL' , 'PO_DISTRIBUTIONS' , 'PO' ,'N','N');
1424 add_list('PO_DISTRIBUTIONS_ARCHIVE_ALL' , 'PO_DISTRIBUTIONS_ARCHIVE' , 'PO' ,'N','N');
1425 add_list('PO_DOCUMENT_TYPES_ALL_B' , 'PO_DOCUMENT_TYPES_B' , 'PO' ,'Y','N');
1426 add_list('PO_DOCUMENT_TYPES_ALL_TL' , 'PO_DOCUMENT_TYPES_TL' , 'PO' ,'Y','N');
1427 add_list('PO_HEADERS_ALL' , 'PO_HEADERS' , 'PO' ,'N','N');
1428 add_list('PO_HEADERS_ARCHIVE_ALL' , 'PO_HEADERS_ARCHIVE' , 'PO' ,'N','N');
1429 add_list('PO_HISTORY_POS_ALL' , 'PO_HISTORY_POS' , 'PO' ,'N','N');
1430 add_list('PO_HISTORY_REQUISITIONS_ALL' , 'PO_HISTORY_REQUISITIONS' , 'PO' ,'N','N');
1431 add_list('PO_LINES_ALL' , 'PO_LINES' , 'PO' ,'N','N');
1432 add_list('PO_LINES_ARCHIVE_ALL' , 'PO_LINES_ARCHIVE' , 'PO' ,'N','N');
1433 add_list('PO_LINE_LOCATIONS_ALL' , 'PO_LINE_LOCATIONS' , 'PO' ,'N','N');
1434 add_list('PO_LINE_LOCATIONS_ARCHIVE_ALL' , 'PO_LINE_LOCATIONS_ARCHIVE' , 'PO' ,'N','N');
1435 add_list('PO_LOCATION_ASSOCIATIONS_ALL' , 'PO_LOCATION_ASSOCIATIONS' , 'PO' ,'N','N');
1436 add_list('PO_MASSCANCEL_INCLUDES_ALL' , 'PO_MASSCANCEL_INCLUDES' , 'PO' ,'N','N');
1437 add_list('PO_NOTIFICATIONS_ALL' , 'PO_NOTIFICATIONS' , 'PO' ,'N','N');
1438 add_list('PO_POSITION_CONTROLS_ALL' , 'PO_POSITION_CONTROLS' , 'PO' ,'N','N');
1439 add_list('PO_QUOTATION_APPROVALS_ALL' , 'PO_QUOTATION_APPROVALS' , 'PO' ,'N','N');
1440 add_list('PO_RELEASES_ALL' , 'PO_RELEASES' , 'PO' ,'N','N');
1441 add_list('PO_RELEASES_ARCHIVE_ALL' , 'PO_RELEASES_ARCHIVE' , 'PO' ,'N','N');
1442 add_list('PO_REQEXPRESS_HEADERS_ALL' , 'PO_REQEXPRESS_HEADERS' , 'PO' ,'N','N');
1443 add_list('PO_REQEXPRESS_LINES_ALL' , 'PO_REQEXPRESS_LINES' , 'PO' ,'N','N');
1444 add_list('PO_REQUISITIONS_INTERFACE_ALL' , 'PO_REQUISITIONS_INTERFACE' , 'PO' ,'N','N');
1445 add_list('PO_REQUISITION_HEADERS_ALL' , 'PO_REQUISITION_HEADERS' , 'PO' ,'N','N');
1446 add_list('PO_REQUISITION_LINES_ALL' , 'PO_REQUISITION_LINES' , 'PO' ,'N','N');
1447 add_list('PO_REQ_DISTRIBUTIONS_ALL' , 'PO_REQ_DISTRIBUTIONS' , 'PO' ,'N','N');
1448 add_list('PO_REQ_DIST_INTERFACE_ALL' , 'PO_REQ_DIST_INTERFACE' , 'PO' ,'N','N');
1449 add_list('PO_RULE_EXPENSE_ACCOUNTS' , 'PO_RULE_EXPENSE_ACCOUNTS' , 'PO' ,'N','N');
1450 add_list('PO_SYSTEM_PARAMETERS_ALL' , 'PO_SYSTEM_PARAMETERS' , 'PO' ,'N','N');
1451 add_list('PO_UNIQUE_IDENTIFIER_CONT_ALL' , 'PO_UNIQUE_IDENTIFIER_CONTROL' , 'PO' ,'Y','N');
1452 add_list('PO_VENDOR_SITES_ALL' , 'PO_VENDOR_SITES' , 'PO' ,'N','N');
1453 --
1454 add_list('PON_AUCTION_HEADERS_ALL' , 'PON_AUCTION_HEADERS' , 'PN' ,'N','N');
1455 add_list('PON_AUCTION_ITEM_PRICES_ALL' , 'PON_AUCTION_ITEM_PRICES' , 'PN' ,'N','N');
1456 --
1457 -- bug 7654852
1458 add_list('PON_EMD_PAYMENT_TYPES_ALL' , 'PON_EMD_PAYMENT_TYPES_VL' , 'PON' ,'Y','N');
1462 add_list('RLA_DEMAND_HEADERS_ARCHIVE_ALL' , 'RLA_DEMAND_HEADERS_ARCHIVE' , 'RLA' ,'N','N');
1459 add_list('PON_EMD_PAYMENT_TYPES_TL' , 'PON_EMD_PAYMENT_TYPES_VL' , 'PON' ,'Y','N');
1460 --
1461 add_list('RLA_DEMAND_HEADERS_ALL' , 'RLA_DEMAND_HEADERS' , 'RLA' ,'N','N');
1463 add_list('RLA_DEMAND_INTERFACE_ALL' , 'RLA_DEMAND_INTERFACE' , 'RLA' ,'N','N');
1464 add_list('RLA_DEMAND_LINES_ALL' , 'RLA_DEMAND_LINES' , 'RLA' ,'N','N');
1465 add_list('RLA_DEMAND_LINES_ARCHIVE_ALL' , 'RLA_DEMAND_LINES_ARCHIVE' , 'RLA' ,'N','N');
1466 --
1467 add_list('RLM_CUST_ITEM_CUM_ADJ_ALL' , 'RLM_CUST_ITEM_CUM_ADJ' , 'RLM' ,'N','N');
1468 add_list('RLM_CUST_ITEM_CUM_KEYS_ALL' , 'RLM_CUST_ITEM_CUM_KEYS' , 'RLM' ,'N','N');
1469 add_list('RLM_CUST_ITEM_TERMS_ALL' , 'RLM_CUST_ITEM_TERMS' , 'RLM' ,'N','N');
1470 add_list('RLM_CUST_SHIPTO_TERMS_ALL' , 'RLM_CUST_SHIPTO_TERMS' , 'RLM' ,'N','N');
1471 add_list('RLM_INTERFACE_HEADERS_ALL' , 'RLM_INTERFACE_HEADERS' , 'RLM' ,'N','N');
1472 add_list('RLM_INTERFACE_LINES_ALL' , 'RLM_INTERFACE_LINES' , 'RLM' ,'N','N');
1473 add_list('RLM_SCHEDULE_HEADERS_ALL' , 'RLM_SCHEDULE_HEADERS' , 'RLM' ,'N','N');
1474 add_list('RLM_SCHEDULE_LINES_ALL' , 'RLM_SCHEDULE_LINES' , 'RLM' ,'N','N');
1475
1476 add_list('OZF_CLAIM_TYPES_ALL_B' , 'OZF_CLAIM_TYPES_VL' , 'OZF' ,'Y','N');
1477 add_list('OZF_CLAIM_TYPES_ALL_TL' , 'OZF_CLAIM_TYPES_ALL_VL' , 'OZF' ,'Y','N');
1478
1479
1480 -- Bug: 4623852
1481 add_list('OZF_CLAIM_DEF_RULES_ALL' , 'OZF_CLAIM_DEF_RULES_ALL' , 'OZF' ,'Y','N');
1482 add_list('OZF_CLAIM_STTLMNT_METHODS_ALL' , 'OZF_CLAIM_STTLMNT_METHODS_ALL' , 'OZF' ,'Y','N');
1483
1484 --
1485 -- for bug 3513992, table WSH_DELIVERY_DETAILS does not have corresponding
1486 -- view. Setting it to WSH_DELIVERY_DETAILS
1487 add_list('WSH_DELIVERY_DETAILS' , 'WSH_DELIVERY_DETAILS' , 'WSH' , 'N','N');
1488
1489 --
1490 -- for bug 4407367, table PO_CHANGE_ORDER_TOLERANCES_ALL does not have corresponding
1491 -- view. Setting it to PO_CHANGE_ORDER_TOLERANCES_ALL
1492 add_list('PO_CHANGE_ORDER_TOLERANCES_ALL' , 'PO_CHANGE_ORDER_TOLERANCES_ALL' , 'PO' , 'Y','N');
1493
1494 -- for bug 4592660, adding the following seed tables
1495
1496 add_list('CN_CW_WORKBENCH_ITEMS_ALL_B' , 'CN_CW_WORKBENCH_ITEMS_ALL_VL' , 'CN' , 'Y','N');
1497 add_list('CN_CW_WORKBENCH_ITEMS_ALL_TL' , 'CN_CW_WORKBENCH_ITEMS_ALL_VL' , 'CN' , 'Y','N');
1498 add_list('CN_CW_SETUP_TASKS_ALL_B' , 'CN_CW_SETUP_TASKS_ALL_VL' , 'CN' , 'Y','N');
1499 add_list('CN_CW_SETUP_TASKS_ALL_TL' , 'CN_CW_SETUP_TASKS_ALL_VL' , 'CN' , 'Y','N');
1500
1501 --
1502 -- all NULL end of list
1503 --
1504 add_list(null, null, null, null,'N');
1505
1506 g_load_table_data := TRUE;
1507 end load_table_list;
1508
1509
1510 -- Bug 3611969 : FIXED FILE.SQL.35 GSCC WARNINGS
1511 -- sraghuve (07/05/2004)
1512
1513 procedure load_table_list
1514 is
1515 begin
1516 load_table_list('N');
1517 end;
1518
1519 --
1520 -- Procedure to initialize the table list and return the count of
1521 -- multi-org partitioned tables
1522 --
1523
1524 procedure initialize
1525 (X_number out nocopy number)
1526 is
1527 begin
1528 load_table_list;
1529
1530 X_number := 0;
1531
1532 if (table_list.count > 0) then
1533 X_number := table_list.count - 1;
1534 end if;
1535 end;
1536
1537 --
1538 -- procedure to return the next partitioned table given the index to the
1539 -- current table. It also returns the conversion method for the table and
1540 -- increments the index variable to point to the new table.
1541 --
1542
1543 procedure get_next_table
1544 (X_number in out nocopy number,
1545 X_table_name out nocopy varchar2,
1546 X_conv_method out nocopy varchar2)
1547 is
1548 i number;
1549 begin
1550 if (NOT g_load_table_data) then
1551 load_table_list;
1552 end if;
1553
1554 i := X_number + 1;
1555
1556 X_table_name := table_list(i);
1557 X_conv_method := conv_method(i);
1558
1559 X_number := i;
1560
1561 return;
1562 end;
1563
1564 function get_org_count return number is
1565 l_num_org number;
1566 begin
1567
1568 select count(*)
1569 into l_num_org
1570 from hr_operating_units
1571 , fnd_product_groups
1572 where product_group_id = 1
1573 and multi_org_flag = 'Y';
1574
1575 return(l_num_org);
1576 end;
1577
1578 procedure enable_debug
1579 (p_debug_level in number)
1580 is
1581 begin
1582 g_debug_level := p_debug_level;
1583 end;
1584
1585 procedure debug
1586 (p_txt in varchar2,
1587 p_debug_level in number default 0,
1588 p_indent_level in number default 0)
1589 is
1590 l_len number;
1591 l_total_len number;
1592 l_max_len number := 80 - (p_indent_level * 4);
1593 begin
1594
1598 l_len := 1;
1595 return;
1596
1597 if (g_debug_level >= p_debug_level) then
1599
1600 l_total_len := length(p_txt);
1601
1602 while (l_len < l_total_len)
1603 loop
1604 l_len := l_len + l_max_len;
1605 end loop;
1606 end if;
1607 end;
1608
1609 procedure debugln
1610 (p_txt in varchar2,
1611 p_debug_level in number default 0,
1612 p_indent_level in number default 0)
1613 is
1614 begin
1615 debug(p_txt, p_debug_level, p_indent_level);
1616 debug(' ', p_debug_level);
1617 end;
1618
1619
1620 procedure verify_table_seed_data
1621 (X_table IN varchar2,
1622 X_num_org IN number,
1623 X_debug_level IN number default 0)
1624 is
1625 where_clause varchar2(32767);
1626 group_clause varchar2(32767);
1627 column_list varchar2(32767);
1628 statement varchar2(32767);
1629 c integer;
1630 row_processed integer;
1631 l_count integer;
1632 pk_list varchar2(200);
1633 pk_list_simple varchar2(200);
1634 pk_value varchar2(600);
1635
1636 table_not_found exception;
1637
1638 cursor c_primary_key(p_table varchar2) is
1639 select c.column_name, pkc.primary_key_sequence
1640 from fnd_columns c
1641 , fnd_primary_key_columns pkc
1642 , fnd_primary_keys pk
1643 , fnd_tables t
1644 where t.application_id >= 0
1645 and t.table_name = p_table
1646 and pk.application_id = t.application_id
1647 and pk.table_id = t.table_id
1648 and pk.primary_key_type = 'D'
1649 and pkc.application_id = pk.application_id
1650 and pkc.table_id = pk.table_id
1651 and pkc.primary_key_id = pk.primary_key_id
1652 and c.application_id = pkc.application_id
1653 and c.table_id = pkc.table_id
1654 and c.column_id = pkc.column_id
1655 and c.column_name <> 'ORG_ID'
1656 order by pkc.primary_key_sequence;
1657
1658 begin
1659
1660 enable_debug(X_debug_level);
1661 debugln('Process table : '||X_table, MSG_LEVEL_BASIC);
1662
1663 for c_pk in c_primary_key(X_table) loop
1664 if (pk_list is null) then
1665 pk_list := c_pk.column_name;
1666 pk_list_simple := initcap(c_pk.column_name);
1667 else
1668 pk_list := pk_list||'||'||''''||'-'||''''||'||'||c_pk.column_name;
1669 pk_list_simple := pk_list_simple||'-'||initcap(c_pk.column_name);
1670 end if;
1671
1672 if (where_clause is null) then
1673 where_clause := 'b.'||c_pk.column_name || ' = A.' || c_pk.column_name;
1674 else
1675 where_clause := where_clause || ' AND b.' ||
1676 c_pk.column_name || ' = A.' || c_pk.column_name;
1677 end if;
1678
1679 if (group_clause is null) then
1680 group_clause := ' group by '||c_pk.column_name;
1681 else
1682 group_clause := group_clause||', '||c_pk.column_name;
1683 end if;
1684 end loop;
1685
1686 if (pk_list is null) then
1687 debugln('Warning : '||X_table||' does not have primary key',
1688 MSG_LEVEL_WARN);
1689 end if;
1690
1691 statement := ' select '||''' '||''''||'||'||
1692 nvl(pk_list, ''''||'no primary key'||'''')
1693 ||' pk_value '||
1694 ' from '||X_table||' a'||
1695 ' where org_id in (-3113, -3114)'||
1696 ' and decode(org_id, -3114, 1, '||X_num_org||') <> ( '||
1697 ' select count(*)'||
1698 ' from '||X_table||' b'||
1699 ' where '||nvl(where_clause, '1=1 ')||
1700 ' and nvl(b.org_id, -99) not in (-3113, -3114)'||
1701 ') order by 1';
1702
1703 debugln(statement, MSG_LEVEL_SQL, 1);
1704
1705 c := dbms_sql.open_cursor;
1706 dbms_sql.parse(c, statement, dbms_sql.native);
1707 dbms_sql.define_column(c, 1, pk_value, 600);
1708 row_processed := dbms_sql.execute(c);
1709
1710 l_count := 0;
1711
1712 loop
1713 if dbms_sql.fetch_rows(c) > 0 then
1714 if (l_count = 0) then
1715 debug('There are seed data row(s) missing from the table. '||
1716 'The primary key values for these rows are as follows ',
1717 MSG_LEVEL_DATA, 1);
1718 debug(pk_list_simple,
1719 MSG_LEVEL_DATA, 2);
1720 debugln(rpad('-', length(pk_list_simple), '-'),
1721 MSG_LEVEL_DATA, 2);
1722 end if;
1723 dbms_sql.column_value(c, 1, pk_value);
1724 l_count := l_count + 1;
1725 if (pk_value is null) then
1726 debug('Primary key is null', MSG_LEVEL_DATA, 2);
1727 else
1728 debug(pk_value, MSG_LEVEL_DATA, 2);
1729 end if;
1730 else
1731 dbms_sql.close_cursor(c);
1732 exit;
1733 end if;
1734 end loop;
1735
1736 if (l_count > 0) then
1737 debugln(rpad(X_table, 30)||' : '||lpad(to_char(l_count), 6)||
1738 ' row(s) missing ', MSG_LEVEL_WARN);
1742
1739 end if;
1740
1741 end;
1743 procedure verify_seed_data
1744 (X_appl_short_name IN varchar2,
1745 X_table IN varchar2,
1746 X_debug_level IN number) is
1747
1748 l_num_org number;
1749 l_multi_org boolean := TRUE;
1750 i number;
1751 begin
1752
1753 l_num_org := get_org_count();
1754
1755 if (l_num_org = 0) then
1756 l_num_org := 1;
1757 l_multi_org := FALSE;
1758 end if;
1759
1760 ad_morg.load_table_list('N');
1761
1762 if (X_table is null) then
1763
1764 i := 1;
1765
1766 loop
1767 if (ad_morg.table_list(i) is not null
1768 and
1769 ad_morg.seed_data(i) = 'Y'
1770 and
1771 ad_morg.appl_list(i) = nvl(upper(X_appl_short_name),
1772 ad_morg.appl_list(i))
1773 )
1774 then
1775
1776 verify_table_seed_data(ad_morg.table_list(i), l_num_org,
1777 X_debug_level);
1778
1779 end if;
1780
1781 if (ad_morg.table_list(i) is null) then
1782 exit;
1783 end if;
1784
1785 i := i + 1;
1786
1787 end loop;
1788
1789 elsif (X_table is not null) then
1790 verify_table_seed_data(X_table, l_num_org, X_debug_level);
1791 end if;
1792
1793
1794 end verify_seed_data;
1795
1796 begin
1797 g_prod_status := '$#';
1798 g_industry := '$#';
1799 g_prev_product := '$#$#';
1800 g_oracle_schema := '$#$#';
1801 g_load_table_stats := 'Y';
1802
1803 end ad_morg;