eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
[Home] [Help]
PACKAGE: APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT

Source


1 PACKAGE ICX_CAT_CNTNT_SCRTY_UPG_PVT AUTHID CURRENT_USER AS
2 /* $Header: ICXVCSUS.pls 120.1 2006/08/30 08:11:24 huphan noship $*/
3 
4 -- creating types on associative arrays gives incomplete types, so just
5 -- defining the types within this package
6 
7 TYPE ICX_MAP_NUMBER IS TABLE OF NUMBER
8   INDEX BY BINARY_INTEGER;
9 
10 TYPE ICX_MAP_VARCHAR20 IS TABLE OF VARCHAR2(20)
11   INDEX BY BINARY_INTEGER;
12 
13 TYPE ICX_MAP_TBL_NUMBER IS TABLE OF ICX_TBL_NUMBER
14   INDEX BY BINARY_INTEGER;
15 
16 
17 -- TOP-LEVEL MIGRATE METHOD AND HELPERS
18 ---------------------------------------
19 
20 PROCEDURE migrate;
21 
22 FUNCTION is_already_run
23 RETURN BOOLEAN;
24 
25 FUNCTION is_new_installation
26 RETURN BOOLEAN;
27 
28 
29 -- INITIALIZATION AND GLOBAL DATA
30 ---------------------------------
31 
32 PROCEDURE initialize;
33 
34 PROCEDURE populate_global_data;
35 
36 
37 -- SEED-DATA RELATED HELPERS
38 ----------------------------
39 
40 -- NEW INSTALLATIONS
41 
42 PROCEDURE add_main_store_content_link;
43 
44 -- PRE-PROCESSING
45 
46 PROCEDURE seed_data_preprocessing;
47 
48 PROCEDURE add_smart_form_content_link;
49 
50 FUNCTION exists_old_seeded_main_store
51 RETURN BOOLEAN;
52 
53 PROCEDURE migrate_seeded_store
54 (
55   p_old_id NUMBER,
56   p_new_id NUMBER
57 );
58 
59 PROCEDURE remove_R12_seeded_all_local;
60 
61 PROCEDURE migrate_all_local_pre_1159;
62 
63 -- POST-PROCESSING
64 
65 PROCEDURE seed_data_postprocessing;
66 
67 PROCEDURE promote_all_local_to_seeded;
68 
69 
70 -- HIGH-LEVEL MIGRATE METHODS
71 -----------------------------
72 
73 FUNCTION try_migrate_catalogs_no_realms
74 RETURN BOOLEAN;
75 
76 FUNCTION try_migrate_isrcs_no_realms
77 RETURN BOOLEAN;
78 
79 PROCEDURE migrate_all_catalogs_no_realms;
80 
81 PROCEDURE migrate_all_isrcs_no_realms;
82 
83 PROCEDURE migrate_content_with_realms
84 (
85   p_catalogs_migrated IN BOOLEAN,
86   p_item_sources_migrated IN BOOLEAN
87 );
88 
89 PROCEDURE migrate_templates;
90 
91 
92 -- MIGRATE LOCAL CATALOGS AND ITEM SOURCES HELPERS
93 --------------------------------------------------
94 
95 PROCEDURE migrate_catalogs_no_realms
96 (
97   p_catalog_ids IN ICX_TBL_NUMBER,
98   p_old_store_ids IN ICX_TBL_NUMBER,
99   p_new_zone_ids IN ICX_TBL_NUMBER
100 );
101 
102 PROCEDURE migrate_catalog_with_realms
103 (
104   p_catalog_id IN NUMBER,
105   p_old_store_id IN NUMBER,
106   p_resp_with_realms_ids IN ICX_TBL_NUMBER
107 );
108 
109 PROCEDURE migrate_isrcs_no_realms
110 (
111   p_item_source_ids IN ICX_TBL_NUMBER,
112   p_old_store_ids IN ICX_TBL_NUMBER,
113   p_new_zone_ids IN ICX_TBL_NUMBER
114 );
115 
116 PROCEDURE migrate_isrc_with_realms
117 (
118   p_item_source_id IN NUMBER,
119   p_old_store_id IN NUMBER,
120   p_resp_with_realms_ids IN ICX_TBL_NUMBER,
121   p_resp_without_realms_ids IN ICX_TBL_NUMBER
122 );
123 
124 
125 -- QUERYING OLD DATA HELPERS
126 ----------------------------
127 
128 FUNCTION exists_local_catalogs
129 RETURN BOOLEAN;
130 
131 FUNCTION exists_item_sources
132 RETURN BOOLEAN;
133 
134 PROCEDURE get_contents_to_migrate
135 (
136   p_catalogs_migrated IN BOOLEAN,
137   p_item_sources_migrated IN BOOLEAN,
138   x_old_content_ids OUT NOCOPY ICX_TBL_NUMBER,
139   x_content_types OUT NOCOPY ICX_TBL_VARCHAR15,
140   x_old_store_ids OUT NOCOPY ICX_TBL_NUMBER
141 );
142 
143 PROCEDURE populate_store_security_flags;
144 
145 PROCEDURE populate_catalog_supplr_flags;
146 
147 PROCEDURE populate_operator_id_list;
148 
149 
150 -- R12 STORE HELPERS
151 --------------------
152 
153 PROCEDURE create_R12_stores;
154 
155 PROCEDURE add_zones_to_store
156 (
157   p_zone_ids IN ICX_TBL_NUMBER,
158   p_r12_store_id IN NUMBER,
159   p_old_source_id IN NUMBER,
160   p_old_store_id IN NUMBER
161 );
162 
163 PROCEDURE add_zones_to_stores
164 (
165   p_zone_ids IN ICX_TBL_NUMBER,
166   p_r12_store_ids IN ICX_TBL_NUMBER,
167   p_old_source_ids IN ICX_TBL_NUMBER,
168   p_old_store_ids IN ICX_TBL_NUMBER
169 );
170 
171 PROCEDURE add_smart_forms_to_stores
172 (
173   p_smart_form_ids IN ICX_TBL_NUMBER,
174   p_r12_store_ids IN ICX_TBL_NUMBER,
175   p_old_store_ids IN ICX_TBL_NUMBER
176 );
177 
178 
179 -- CONTENT ZONE HELPERS
180 -----------------------
181 
182 FUNCTION get_new_zone_ids
183 (
184   p_num_zones IN NUMBER
185 )
186 RETURN ICX_TBL_NUMBER;
187 
188 PROCEDURE create_local_zones
189 (
190   p_new_zone_ids IN ICX_TBL_NUMBER,
191   p_catalog_id IN NUMBER,
192   p_security_flag IN VARCHAR2,
193   p_supplier_flag IN VARCHAR2,
194   p_category_flag IN VARCHAR2
195 );
196 
197 PROCEDURE create_local_zones
198 (
199   p_new_zone_ids IN ICX_TBL_NUMBER,
200   p_catalog_ids IN ICX_TBL_NUMBER,
201   p_security_flags IN ICX_TBL_VARCHAR20,
202   p_supplier_flags IN ICX_TBL_VARCHAR20,
203   p_category_flag IN VARCHAR2
204 );
205 
206 PROCEDURE create_local_all_content_zones
207 (
208   p_new_zone_ids IN ICX_TBL_NUMBER,
209   p_category_flag IN VARCHAR2
210 );
211 
212 PROCEDURE add_resp_categories_to_zone
213 (
214   p_new_zone_ids IN ICX_TBL_NUMBER,
215   p_resp_ids IN ICX_TBL_NUMBER
216 );
217 
218 PROCEDURE create_item_source_zones
219 (
220   p_new_zone_ids IN ICX_TBL_NUMBER,
221   p_item_source_id IN NUMBER,
222   p_security_flag IN VARCHAR2
223 );
224 
225 PROCEDURE create_item_source_zones
226 (
227   p_new_zone_ids IN ICX_TBL_NUMBER,
228   p_item_source_ids IN ICX_TBL_NUMBER,
229   p_security_flags IN ICX_TBL_VARCHAR20
230 );
231 
232 PROCEDURE update_exchange_punchouts;
233 
234 
235 -- CONTENT ZONE SECURITY HELPERS
236 --------------------------------
237 
238 PROCEDURE secure_zones_by_store_orgs
239 (
240   p_new_zone_ids IN ICX_TBL_NUMBER,
241   p_old_store_ids IN ICX_TBL_NUMBER,
242   p_security_flags IN ICX_TBL_VARCHAR20
243 );
244 
245 PROCEDURE secure_zones_by_resps
246 (
247   p_new_zone_ids IN ICX_TBL_NUMBER,
248   p_resp_ids IN ICX_TBL_NUMBER
249 );
250 
251 PROCEDURE secure_zone_by_resps
252 (
253   p_new_zone_id IN NUMBER,
254   p_resp_ids IN ICX_TBL_NUMBER
255 );
256 
257 
258 -- RESPONSIBILITY AND REALMS HELPER METHODS
259 -------------------------------------------
260 
261 PROCEDURE populate_isrcs_to_resp_map;
262 
263 FUNCTION get_catr_realm_values_cached
264 (
265   p_resp_id IN NUMBER
266 )
267 RETURN ICX_TBL_NUMBER;
268 
269 FUNCTION filter_out_no_category_resps
270 (
271   p_resp_with_realms_ids IN ICX_TBL_NUMBER
272 )
273 RETURN ICX_TBL_NUMBER;
274 
275 FUNCTION get_realm_values_for_resp
276 (
277   p_resp_id IN NUMBER,
278   p_realm_type IN VARCHAR2
279 )
280 RETURN ICX_TBL_NUMBER;
281 
282 
283 -- LARGE RESPONSIBILITY WITH REALMS QUERIES
284 -------------------------------------------
285 
286 FUNCTION get_all_resps_with_realms
287 (
288   p_realm_type IN VARCHAR2
289 )
290 RETURN ICX_TBL_NUMBER;
291 
292 FUNCTION get_all_resps_without_realms
293 (
294   p_realm_type IN VARCHAR2
295 )
296 RETURN ICX_TBL_NUMBER;
297 
298 FUNCTION get_resps_with_realms_store
299 (
300   p_realm_type IN VARCHAR2,
301   p_old_store_id IN NUMBER
302 )
303 RETURN ICX_TBL_NUMBER;
304 
305 FUNCTION get_resps_without_realms_store
306 (
307   p_realm_type IN VARCHAR2,
308   p_old_store_id IN NUMBER
309 )
310 RETURN ICX_TBL_NUMBER;
311 
312 END ICX_CAT_CNTNT_SCRTY_UPG_PVT;
313