1 package ad_morg as
2 /* $Header: admorgs.pls 120.2.12010000.2 2008/10/06 11:11:29 mkumandu ship $ */
3 --
4 -- Declare table for Multi-Org table list
5 --
6 type TableNameType is table of varchar2(30)
7 index by binary_integer;
8
9 type FlagValueType is table of varchar2(1)
10 index by binary_integer;
11
12 table_list TableNameType;
13 view_list TableNameType;
14 appl_list TableNameType;
15 seed_data TableNameType;
16 conv_method FlagValueType;
17 owner_list TableNameType;
18
19 --
20 -- Procedure
21 -- load_table_list
22 --
23 -- Purpose
24 -- Loads the hard-coded list of partitioned tables into PL/SQL tables.
25 -- These PL/SQL tables should replace AK_PARTITIONED_TABLES in 10.7.
26 --
27 -- Arguments
28 -- X_load_table_stats indicates whether the tables' row count should
29 -- be used to determine the conversion method
30 -- (default Y)
31 --
32 -- Example
33 -- none
34 --
35 procedure load_table_list(x_load_table_stats in varchar2);
36
37
38 procedure load_table_list;
39
40 --
41 -- Procedure
42 -- replicate_table_data
43 --
44 -- Purpose
45 -- Perform seed data replication from the template to the specified
46 -- org for the specified table
47 --
48 -- Arguments
49 -- X_table_name Name of table
50 -- X_source_org_id org_id of the source organization_id
51 -- X_target_org_id org_id of the target organization_id
52 --
53 -- Example
54 -- none
55 --
56 -- Notes
57 -- 1. Templates for partitioned seed data have a source org_id of -3113.
58 -- 2. Templates for shared seed data have a source org_id of -3114.
59 -- 3. Custom data have a source org_id of NULL.
60 --
61 procedure replicate_table_data
62 (X_table_name in varchar2,
63 X_source_org_id in number,
64 X_target_org_id in number);
65
66 --
67 -- Procedure
68 -- replicate_table_data_bulk
69 --
70 -- Purpose
71 -- Perform seed data replication from the template to
72 -- a group of orgs for the specified table
73 --
74 -- This procedure was adapted from replicate_table_data()
75 --
76 -- This was written to improve performance as described
77 -- in bug 5409325.
78 --
79 -- Instead of calling replicate_table_data() for each
80 -- value fetched from the cursor, the cursor is combined
81 -- with the dynamic INSERT statement to process all orgs
82 -- in one shot per table.
83 --
84 -- Arguments
85 -- X_table_name Name of table
86 -- X_source_org_id org_id of the source organization_id
87 --
88 -- Example
89 -- none
90 --
91 -- Notes
92 -- 1. Templates for partitioned seed data have a source org_id of -3113.
93 -- 2. Templates for shared seed data have a source org_id of -3114.
94 -- 3. Custom data have a source org_id of NULL.
95 --
96 procedure replicate_table_data_bulk
97 (X_table_name in varchar2,
98 X_source_org_id in number);
99
100 --
101 -- Procedure
102 -- replicate_seed_data
103 --
104 -- Purpose
105 -- Perform seed data replication from the template to the specified
106 -- org or all orgs for the specified table or all tables from one
107 -- product or all tables
108 --
109 -- Arguments
110 -- X_org_id org_id of the target organization_id (NULL if all)
111 -- X_appl_short_name application (NULL if all)
112 -- X_table_name Name of table (NULL if all)
113 --
114 -- Example
115 -- none
116 --
117 -- Notes
118 -- none
119 --
120 procedure replicate_seed_data
121 (X_org_id in number,
122 X_appl_short_name in varchar2,
123 X_table_name in varchar2);
124
125 procedure get_next_table
126 (X_number in out nocopy number,
127 X_table_name out nocopy varchar2,
128 X_conv_method out nocopy varchar2);
129
130 procedure initialize(X_number out nocopy number);
131
132 procedure verify_seed_data
133 (X_appl_short_name IN varchar2,
134 X_table IN varchar2,
135 X_debug_level IN number default 1);
136
137 end ad_morg;