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