[Home] [Help]
PACKAGE: APPS.CZ_PB_MGR
Source
1 PACKAGE cz_pb_mgr AS
2 /* $Header: czpbmgrs.pls 120.59 2008/02/20 22:39:31 qmao ship $ */
3 /*
4 Introducing custom error message to handle remote exception
5 from insert_jrad_doc.
6
7 Copying this help message to describe the use of
8 custom error message.
9
10 'Package DBMS_STANDARD, which is supplied with Oracle,
11 provides language facilities that help your application interact with Oracle.
12 For example, the procedure raise_application_error lets you
13 issue user-defined error messages from stored subprograms.
14 That way, you can report errors to your application
15 and avoid returning unhandled exceptions.
16 To call raise_application_error, use the syntax
17 raise_application_error(error_number, message[, {TRUE | FALSE}]);
18 where error_number is a negative integer in the range -20000 .. -20999
19 and message is a character string up to 2048 bytes long.
20 If the optional third parameter is TRUE, the error is placed
21 on the stack of previous errors. If the parameter is FALSE (the default),
22 the error replaces all previous errors.
23 Package DBMS_STANDARD is an extension of package STANDARD,
24 so you need not qualify references to its contents.'
25
26 */
27
28 EXPLORETREE_ERROR EXCEPTION;
29 PRAGMA EXCEPTION_INIT(EXPLORETREE_ERROR, -20001);
30 v_server_id cz_model_publications.server_id%TYPE;
31 v_ui_def_id cz_model_publications.ui_def_id%TYPE;
32 v_export_id cz_pb_model_exports.export_id%TYPE;
33 v_publication_id cz_model_publications.publication_id%TYPE;
34 v_root_model_id cz_model_publications.model_id%TYPE;
35 v_root_ui_def_id cz_model_publications.ui_def_id%TYPE;
36 target_root_model_id cz_model_publications.model_id%TYPE;
37 v_status_code cz_model_publications.export_status%TYPE;
38 v_remote_comp_id cz_model_ref_expls.component_id%TYPE;
39 v_child_expl_id cz_model_ref_expls.child_model_expl_id%TYPE;
40 v_server_local_name cz_servers.local_name%TYPE;
41 v_target_ui_def_id cz_ui_defs.ui_def_id%TYPE;
42 v_ui_name cz_ui_defs.NAME%TYPE;
43 v_pb_run_id cz_xfr_run_infos.run_id%TYPE;
44 loguser cz_db_logs.loguser%TYPE;
45 v_deep_project_name cz_devl_projects.NAME%TYPE;
46 v_err_message cz_db_logs.MESSAGE%TYPE;
47 v_rp_folder_id cz_rp_entries.enclosing_folder%TYPE;
48 v_rp_name cz_rp_entries.NAME%TYPE;
49 v_rp_desc cz_rp_entries.description%TYPE;
50 v_sql_err_msg cz_db_logs.MESSAGE%TYPE;
51 v_db_link cz_servers.fndnam_link_name%TYPE;
52 v_prev_remote_publication_id cz_model_publications.publication_id%TYPE;
53 v_new_devl_id cz_devl_projects.devl_project_id%TYPE;
54 new_ui_def_id cz_ui_defs.ui_def_id%TYPE;
55 sequence_no NUMBER := 0;
56 v_oraclesequenceincr PLS_INTEGER := 0.0;
57 msg_count PLS_INTEGER := 0.0;
58 v_expr_count PLS_INTEGER := 0.0;
59 v_pb_log_flag VARCHAR2(5);
60 v_insert_string VARCHAR2(2000) := '';
61 sequence_const NUMBER := 0.0;
62 index_variable NUMBER := 0.0;
63 -----table_name variable used in insert_into_table procedure
64 v_insert_table_name VARCHAR2(128);
65 v_insert_error VARCHAR2(2000);
66 remote_publication_id cz_model_publications.remote_publication_id%TYPE;
67 v_ui_str VARCHAR2(6) := 'x';
68 ------------parameters of delete publication
69 d_pbid NUMBER;
70
71 ------------msg record
72 TYPE t_messagerecord IS RECORD(
73 msg_text cz_db_logs.MESSAGE%TYPE
74 ,called_proc cz_db_logs.caller%TYPE
75 ,sql_code cz_db_logs.statuscode%TYPE
76 );
77
78 TYPE t_columnrecord IS RECORD(
79 col_name VARCHAR2(100)
80 ,table_name VARCHAR2(100)
81 );
82
83 TYPE t_collisionrecord IS RECORD(
84 old_value NUMBER
85 ,new_value NUMBER
86 );
87
88 TYPE t_jradchunk IS RECORD(
89 jrad_doc VARCHAR2(2000)
90 ,seq_nbr NUMBER
91 ,CHUNK VARCHAR2(32767)
92 );
93
94 TYPE jrad_chunks_tbl IS TABLE OF t_jradchunk
95 INDEX BY BINARY_INTEGER;
96
97 cz_jrad_tbl jrad_chunks_tbl;
98
99 TYPE collision_tbl IS TABLE OF t_collisionrecord
100 INDEX BY BINARY_INTEGER;
101
102 TYPE col_plsql_table_list IS TABLE OF t_columnrecord
103 INDEX BY BINARY_INTEGER;
104
105 TYPE propertytype IS TABLE OF cz_item_property_values.property_value%TYPE
106 INDEX BY BINARY_INTEGER;
107
108 TYPE exprstrtype IS TABLE OF cz_expressions.expr_str%TYPE
109 INDEX BY BINARY_INTEGER;
110
111 TYPE exprflgtype IS TABLE OF cz_expressions.parsed_flag%TYPE
112 INDEX BY BINARY_INTEGER;
113
114 TYPE rulesusagetype IS TABLE OF cz_rules.effective_usage_mask%TYPE
115 INDEX BY BINARY_INTEGER;
116
117 TYPE rulesefftype IS TABLE OF cz_rules.effective_from%TYPE
118 INDEX BY BINARY_INTEGER;
119
120 TYPE propdatatype IS TABLE OF cz_ps_prop_vals.data_value%TYPE
121 INDEX BY BINARY_INTEGER;
122
123 TYPE lcetexttype IS TABLE OF cz_lce_texts.lce_text%TYPE
124 INDEX BY BINARY_INTEGER;
125
126 TYPE orig_sys_ref_type IS TABLE OF VARCHAR2(255)
127 INDEX BY BINARY_INTEGER;
128
129 TYPE t_lang_code IS TABLE OF fnd_languages.language_code%TYPE
130 INDEX BY BINARY_INTEGER;
131
132 TYPE ref_cursor IS REF CURSOR;
133
134 TYPE model_id_table IS TABLE OF cz_model_publications.model_id%TYPE
135 INDEX BY BINARY_INTEGER;
136
137 TYPE t_ref IS TABLE OF NUMBER
138 INDEX BY BINARY_INTEGER;
139
140 TYPE t_ref_idx_vc2 IS TABLE OF NUMBER
141 INDEX BY VARCHAR2(15);
142
143 TYPE usage_name_list IS TABLE OF cz_model_usages.NAME%TYPE
144 INDEX BY BINARY_INTEGER;
145
146 TYPE msg_text_list IS TABLE OF t_messagerecord
147 INDEX BY BINARY_INTEGER;
148
149 TYPE t_alias_name IS TABLE OF VARCHAR2(255)
150 INDEX BY BINARY_INTEGER;
151
152 TYPE keystrtype IS TABLE OF cz_ui_node_props.key_str%TYPE
153 INDEX BY BINARY_INTEGER;
154
155 TYPE number_type_tbl IS TABLE OF NUMBER
156 INDEX BY BINARY_INTEGER;
157
158 TYPE varchar_type_tbl IS TABLE OF VARCHAR2(2000)
159 INDEX BY BINARY_INTEGER;
160
161 TYPE jraddoc_type_tbl IS TABLE OF cz_ui_pages.jrad_doc%TYPE
162 INDEX BY BINARY_INTEGER;
163
164 TYPE objtype IS TABLE OF cz_rule_folders.object_type%TYPE
165 INDEX BY BINARY_INTEGER;
166
167 TYPE varchar_type_1_tbl IS TABLE OF VARCHAR2(1)
168 INDEX BY BINARY_INTEGER;
169
170 TYPE varchar_type_8_tbl IS TABLE OF VARCHAR2(8)
171 INDEX BY BINARY_INTEGER;
172
173 TYPE varchar_type_1000_tbl IS TABLE OF VARCHAR2(1000)
174 INDEX BY BINARY_INTEGER;
175
176 TYPE varchar_type_4000_tbl IS TABLE OF VARCHAR2(4000)
177 INDEX BY BINARY_INTEGER;
178
179 TYPE t_propertyrecord IS RECORD(
180 NAME cz_properties.NAME%TYPE
181 ,data_type cz_properties.data_type%TYPE
182 ,src_application_id cz_properties.src_application_id%TYPE
183 );
184
185 TYPE t_typerecord IS RECORD(
186 NAME cz_item_types.NAME%TYPE
187 ,src_application_id cz_item_types.src_application_id%TYPE
188 );
189
190 TYPE t_propertytable IS TABLE OF t_propertyrecord
191 INDEX BY BINARY_INTEGER;
192
193 TYPE t_typetable IS TABLE OF t_typerecord
194 INDEX BY BINARY_INTEGER;
195
196 TYPE table_of_propertytables IS TABLE OF t_propertytable
197 INDEX BY BINARY_INTEGER;
198
199 TYPE date_tbl_type IS TABLE OF DATE
200 INDEX BY PLS_INTEGER;
201
202 g_ps_uits_add_tbl date_tbl_type; -- cz_ps_nodes.UI_TIMESTAMP_ADD
203 v_specs_alias_name_ref t_alias_name;
204 ---------------------------------------
205 v_cz_ps_nodes_new_tbl t_ref;
206 v_cz_ps_nodes_old_tbl t_ref;
207 v_cz_ps_nodes_idx_tbl t_ref_idx_vc2;
208 v_ps_parent_id_tbl t_ref;
209 v_ps_refid_old_tbl t_ref;
210 v_devl_project_tbl t_ref;
211 v_ref_model_id_tbl t_ref;
212 v_cz_ps_nodes_comp_tbl t_ref;
213 v_ps_item_id_tbl t_ref;
214 v_ps_item_id_ref t_ref;
215 v_cz_ps_nodes_new_ref t_ref;
216 v_cz_ps_nodes_old_ref t_ref;
217 v_ps_parent_id_ref t_ref;
218 v_ps_ref_id_ref t_ref;
219 v_ref_model_id_ref t_ref;
220 v_cz_ps_nodes_comp_ref t_ref;
221 v_ps_eff_set_id_ref t_ref;
222 v_ps_eff_set_id_tbl t_ref;
223 v_ps_intl_old_tbl t_ref;
224 v_ps_intl_old_ref t_ref;
225 v_ps_viol_old_tbl t_ref;
226 v_ps_viol_old_ref t_ref;
227 v_ps_capt_rule_ref t_ref;
228 v_ps_capt_rule_tbl t_ref;
229 v_ps_type_old_tbl t_ref;
230 v_ps_type_old_ref t_ref;
231 v_cz_model_ref_expls_new_ref t_ref;
232 v_cz_model_ref_expls_old_ref t_ref;
233 v_component_id_old_ref t_ref;
234 v_parent_expl_id_ref t_ref;
235 v_child_expl_id_ref t_ref;
236 v_referring_node_id_ref t_ref;
237 v_component_id_old_tbl t_ref;
238 v_parent_expl_id_tbl t_ref;
239 v_child_expl_id_tbl t_ref;
240 v_referring_node_id_tbl t_ref;
241 v_cz_model_ref_expls_idx_ref t_ref_idx_vc2;
242 v_cz_ui_defs_new_ref t_ref;
243 v_cz_ui_defs_old_ref t_ref;
244 v_cz_ui_defs_old_oa_ref t_ref;
245 v_cz_ui_defs_old_tbl t_ref;
246 v_ui_devl_id_ref t_ref;
247 v_ui_comp_id_ref t_ref;
248 v_ui_devl_id_tbl t_ref;
249 v_ui_comp_id_tbl t_ref;
250 v_ui_defs_mcpt_rule_ref t_ref;
251 v_ui_defs_pcpt_rule_ref t_ref;
252 v_cz_ui_nodes_new_ref t_ref;
253 v_cz_ui_nodes_old_ref t_ref;
254 v_cz_ui_nodes_ui_def_id_ref t_ref;
255 v_cz_ui_nodes_parent_id_ref t_ref;
256 v_cz_ui_nodes_ui_ref_id_ref t_ref;
257 v_cz_ui_nodes_ps_node_id_ref t_ref;
258 v_cz_ui_nodes_component_id_ref t_ref;
259 v_cz_ui_nodes_ui_dref_id_ref t_ref;
260 v_cz_ui_nodes_expl_id_ref t_ref;
261 v_cz_ui_nodes_fcomp_id_ref t_ref;
262 v_cz_ui_nodes_capt_id_ref t_ref;
263 v_cz_ui_nodes_tool_id_ref t_ref;
264 g_ui_node_prop_new_node_tbl t_ref;
265 g_ui_node_prop_old_node_tbl t_ref;
266 g_ui_node_prop_new_uidf_tbl t_ref;
267 g_ui_node_prop_old_uidf_tbl t_ref;
268 v_cz_intl_text_new_ref t_ref;
269 v_cz_intl_text_old_ref t_ref;
270 v_cz_folders_id_old_ref t_ref;
271 v_cz_folders_id_idx_ref t_ref_idx_vc2;
272 v_cz_folders_id_new_ref t_ref;
273 v_cz_folders_pf_id_ref t_ref;
274 v_cz_folders_pj_id_ref t_ref;
275 v_cz_folders_id_old_tbl t_ref;
276 v_cz_folders_id_new_tbl t_ref;
277 v_cz_folders_eff_ref t_ref;
278 v_cz_folders_orig_ref orig_sys_ref_type;
279 v_cz_folders_obj_ref objtype;
280 v_cz_rules_obj_ref objtype;
281 v_cz_rules_ui_ref t_ref;
282 v_cz_enodes_enode_id_idx_ref t_ref_idx_vc2;
283 v_cz_enodes_enode_id_old_ref t_ref;
284 v_cz_enodes_enode_id_new_ref t_ref;
285 v_cz_enodes_expr_id_ref t_ref;
286 v_cz_enodes_psnode_id_ref t_ref;
287 v_cz_enodes_gcol_id_ref t_ref;
288 v_cz_enodes_pexpr_id_ref t_ref;
289 v_cz_enodes_mrefl_id_ref t_ref;
290 v_cz_enodes_rule_id_tbl t_ref;
291 v_cz_enodes_rule_id_ref t_ref;
292 v_cz_enodes_arg_sig_id_tbl t_ref;
293 v_cz_enodes_par_sig_id_tbl t_ref;
294 v_cz_enodes_prop_id_tbl t_ref;
295 v_cz_enodes_arg_sig_id_ref t_ref;
296 v_cz_enodes_par_sig_id_ref t_ref;
297 v_cz_enodes_prop_id_ref t_ref;
298 v_cz_expr_sig_ref t_ref;
299 v_cz_expr_sig_idx_ref t_ref_idx_vc2;
300 v_cz_enodes_expr_id_tbl t_ref;
301 v_cz_enodes_psnode_id_tbl t_ref;
302 v_cz_enodes_gcol_id_tbl t_ref;
303 v_cz_enodes_pexpr_id_tbl t_ref;
304 v_cz_enodes_mrefl_id_tbl t_ref;
305 v_cz_enodes_enode_id_new_tbl t_ref;
306 v_cz_enodes_enode_id_old_tbl t_ref;
307 v_cz_rules_persistent_id_ref t_ref;
308 v_cz_rules_rule_id_old_ref t_ref;
309 v_cz_rules_rule_id_new_ref t_ref;
310 v_cz_rules_rule_id_idx_ref t_ref_idx_vc2;
311 v_cz_rules_grid_id_ref t_ref;
312 v_cz_rules_rf_id_ref t_ref;
313 v_cz_rules_proj_id_ref t_ref;
314 v_cz_rules_comp_id_ref t_ref;
315 v_cz_rules_ant_id_ref t_ref;
316 v_cz_rules_con_id_ref t_ref;
317 v_cz_rules_rea_id_ref t_ref;
318 v_cz_rules_unmsg_id_ref t_ref;
319 v_cz_intl_unmsg_idx_ref t_ref;
320 v_cz_rules_eff_id_ref t_ref;
321 v_cz_rules_expl_ref t_ref;
322 v_cz_rules_sig_ref t_ref;
323 v_cz_rules_sig_idx_ref t_ref;
324 v_sig_new_ref t_ref;
325 v_sig_old_ref t_ref;
326 v_sig_idx_ref t_ref_idx_vc2;
327 v_arg_sig_tbl t_ref;
328 v_data_sig_tbl t_ref;
329 v_arg_sig_old_tbl t_ref;
330 v_arg_ind_old_tbl t_ref;
331 v_cz_des_feature_id_old_ref t_ref;
332 v_cz_des_feature_id_new_ref t_ref;
333 v_cz_des_feature_rid_new_ref t_ref;
334 v_cz_des_feature_rule_id_ref t_ref;
335 v_cz_des_feature_mrefl_id_ref t_ref;
336 v_cz_des_feature_ft_typ_ref t_ref;
337 v_cz_des_cells_rule_id_new_ref t_ref;
338 v_cz_des_cells_rule_id_old_ref t_ref;
339 v_cz_des_cells_sf_id_ref t_ref;
340 v_cz_des_cells_sopt_id_ref t_ref;
341 v_cz_des_cells_popt_id_ref t_ref;
342 v_cz_des_cells_sexpl_id_ref t_ref;
343 v_cz_des_cells_mark_char_ref exprflgtype;
344 v_cz_eff_sets_old_tbl t_ref;
345 v_cz_eff_sets_new_tbl t_ref;
346 v_ref_child_remote_model t_ref;
347 v_ref_child_remote_ref t_ref;
348 v_remote_ref_expl_ref t_ref;
349 v_ref_child_source_model t_ref;
350 v_ref_child_source_ref t_ref;
351 v_source_ref_expl_ref t_ref;
352 v_prop_vals_node_tbl t_ref;
353 v_prop_vals_prop_tbl t_ref;
354 v_prop_vals_data_tbl propdatatype;
355 v_prop_vals_num_tbl t_ref;
356 v_prop_vals_origsys_tbl propdatatype;
357 v_prop_vals_datanum_tbl t_ref;
358 v_prop_vals_num_ref t_ref;
359 v_prop_vals_origsys_ref propdatatype;
360 v_prop_vals_datanum_ref t_ref;
361 v_prop_vals_node_ref t_ref;
362 v_prop_vals_prop_ref t_ref;
363 v_prop_vals_data_ref propdatatype;
367 v_propval_node_id cz_ps_prop_vals.ps_node_id%TYPE;
364 v_prop_vals_data_typ_ref t_ref;
365 v_prop_vals_data_num_ref t_ref;
366 v_prop_vals_intl_text_ref t_ref;
368 v_propval_prop_id cz_ps_prop_vals.property_id%TYPE;
369 v_propval_data_value cz_ps_prop_vals.data_value%TYPE;
370 v_propval_data_num_value cz_ps_prop_vals.data_num_value%TYPE;
371 v_model_usages_tbl t_ref;
372 v_cz_ui_nodes_idx_ref t_ref_idx_vc2;
373 v_cz_ui_defs_idx_ref t_ref_idx_vc2;
374 v_intl_text_model_tbl t_ref;
375 v_intl_text_ui_tbl t_ref;
376 -------mls implementation
377 v_src_lang_code_tbl propertytype;
378 v_tgt_lang_code_tbl propertytype;
379 v_pb_lang_ref propertytype;
380 v_src_lang_ref propertytype;
381 v_remote_prop_ref t_ref;
382 v_property_record_ref t_propertytable;
383 v_type_property_record_ref table_of_propertytables;
384 v_type_record_ref t_typetable;
385 v_cz_model_pub_new_id cz_model_publications.publication_id%TYPE;
386 v_cz_model_pub_old_id cz_model_publications.publication_id%TYPE;
387 v_models_to_be_exported t_ref;
388 v_models_not_to_be_exported t_ref;
389 v_models_to_be_exported_new t_ref;
390 v_cz_express_expr_id_new_ref1 t_ref;
391 array_uis t_ref;
392 v_cz_func_comp_new_tbl t_ref;
393 v_cz_func_comp_old_tbl t_ref;
394 v_cz_func_devl_old_tbl t_ref;
395 v_cz_func_rule_old_tbl t_ref;
396 v_cz_func_expl_old_tbl t_ref;
397 v_cz_func_comp_idx_ref t_ref_idx_vc2;
398 v_cz_func_comp_new_ref t_ref;
399 v_cz_func_comp_old_ref t_ref;
400 v_cz_func_devl_old_ref t_ref;
401 v_cz_func_cid_old_ref t_ref;
402 v_cz_func_expl_old_ref t_ref;
403 v_cz_func_fld_old_ref t_ref;
404 v_cz_func_obj_ref objtype;
405 v_cz_enodes_seq_nbr_ref t_ref;
406 v_cz_enodes_item_type_id_ref t_ref;
407 v_cz_enodes_item_id_ref t_ref;
408 v_cz_enodes_filter_set_id_ref t_ref;
409 v_cz_enodes_property_id_ref t_ref;
410 v_cz_enodes_compile_advice_ref t_ref;
411 v_cz_enodes_expr_type_ref t_ref;
412 v_cz_enodes_expr_subtype_ref t_ref;
413 v_cz_enodes_token_list_seq_ref t_ref;
414 v_cz_enodes_col_ref t_ref;
415 v_cz_enodes_seq_nbr_tbl t_ref;
416 v_cz_enodes_item_type_id_tbl t_ref;
417 v_cz_enodes_item_id_tbl t_ref;
418 v_cz_enodes_filter_set_id_tbl t_ref;
419 v_cz_enodes_property_id_tbl t_ref;
420 v_cz_enodes_compile_advice_tbl t_ref;
421 v_cz_enodes_col_tbl t_ref;
422 v_cz_enodes_expr_type_tbl t_ref;
423 v_cz_enodes_expr_subtype_tbl t_ref;
424 v_cz_enodes_token_list_seq_tbl t_ref;
425 v_item_masters_tbl t_ref;
426 v_item_masters_ref t_ref;
427 v_item_prop_data_typ_ref t_ref;
428 v_item_types_tbl t_ref;
429 v_item_types_new_ref t_ref;
430 v_item_types_ref t_ref;
431 v_item_prop_id_tbl t_ref;
432 v_item_prop_type_tbl t_ref;
433 v_item_prop_num_val_tbl t_ref;
434 v_item_prop_id_ref t_ref;
435 v_item_prop_type_ref t_ref;
436 v_item_prop_num_val_ref t_ref;
437 v_item_prop_data_typ_tbl t_ref;
438 v_it_prop_vals_id_tbl t_ref;
439 v_it_prop_vals_id_ref t_ref;
440 v_it_prop_vals_item_tbl t_ref;
441 v_it_prop_vals_item_ref t_ref;
442 v_it_prop_value_tbl propertytype;
443 v_it_prop_value_ref propertytype;
444 v_item_types_orig_ref orig_sys_ref_type;
445 v_items_orig_ref orig_sys_ref_type;
446 v_enodes_values_tbl propertytype;
447 v_enodes_values_ref propertytype;
448 v_enodes_fldname_tbl propertytype;
449 v_enodes_fldname_ref propertytype;
450 v_cz_express_name_ref propertytype;
451 v_cz_express_expr_str_ref exprstrtype;
452 v_cz_express_desc_text_ref propertytype;
453 v_cz_express_present_typ_ref t_ref;
454 v_cz_express_parsed_flg_ref exprflgtype;
455 v_cz_express_pers_id_ref t_ref;
456 v_cz_lce_headers_old_tbl t_ref;
457 v_cz_lce_headers_new_tbl t_ref;
458 v_cz_lce_headers_new_ref t_ref;
459 v_cz_lce_headers_old_ref t_ref;
460 v_cz_lce_headers_idx_ref t_ref_idx_vc2;
461 v_cz_lce_comp_id_ref t_ref;
462 v_cz_lce_expl_id_ref t_ref;
463 v_cz_lce_devl_id_ref t_ref;
464 v_specs_attach_expl_id_ref t_ref;
465 v_specs_lce_header_id_ref t_ref;
466 v_specs_required_expl_id_ref t_ref;
467 v_specs_attach_comp_id_ref t_ref;
468 v_specs_model_id_ref t_ref;
469 v_specs_net_type_ref t_ref;
470 v_cz_eff_sets_idx_tbl t_ref_idx_vc2;
471 v_cz_intl_text_idx_ref t_ref_idx_vc2;
472 v_imported_ps_ref t_ref;
473 v_imported_ps_node NUMBER := 0.0;
474 -----bomsynch
475 v_cz_intl_orig_sys_ref orig_sys_ref_type;
476 v_ps_orig_sys_ref orig_sys_ref_type;
477 v_ps_comp_seq_path_ref orig_sys_ref_type;
478 v_ps_comp_seq_id_ref t_ref;
479 v_ps_orig_sys_tbl orig_sys_ref_type;
480 v_ps_comp_seq_path_tbl orig_sys_ref_type;
481 v_ps_comp_seq_id_tbl t_ref;
482 bomsynch_flag VARCHAR2(1) := 'N';
483 l_intl_text_id NUMBER := 0;
484 l_bom_caption_rule NUMBER := 0;
485 l_nonbom_capt_rule_id NUMBER := 0;
486 l_devl_proj_inv_id NUMBER := 0;
487 l_devl_proj_org_id NUMBER := 0;
488 l_devl_proj_product_key cz_devl_projects.product_key%TYPE;
489 l_bom_caption_text_id cz_devl_projects.bom_caption_text_id%TYPE;
490 l_nonbom_caption_text_id cz_devl_projects.nonbom_caption_text_id%TYPE;
491 -----new tech stack arrays
492 v_templates_tobe_exported t_ref;
493 v_templates_not_exported t_ref;
494 v_global_templs_ref t_ref;
498 l_element_type_ref t_ref;
495 v_global_templs_exported t_ref;
496 l_template_id_ref t_ref;
497 l_ui_def_id_ref t_ref;
499 l_element_id_ref t_ref;
500 l_pers_elem_ref t_ref;
501 v_usages_lang_tbl t_lang_code;
502 --------------------commit size variables
503 end_count NUMBER := 0;
504 start_count NUMBER := 0;
505 last_set BOOLEAN;
506 ----------constants for sequences
507 CZ_PS_NODES_SEQ CONSTANT PLS_INTEGER := 1;
508 CZ_MODEL_REF_EXPLS_SEQ CONSTANT PLS_INTEGER := 2;
509 CZ_FUNC_COMP_SPECS_SEQ CONSTANT PLS_INTEGER := 3;
510 CZ_UI_DEFS_SEQ CONSTANT PLS_INTEGER := 4;
511 CZ_UI_NODES_SEQ CONSTANT PLS_INTEGER := 5;
512 CZ_INTL_TEXTS_SEQ CONSTANT PLS_INTEGER := 6;
513 CZ_RULE_FOLDERS_SEQ CONSTANT PLS_INTEGER := 7;
514 CZ_GRID_DEFS_SEQ CONSTANT PLS_INTEGER := 8;
515 CZ_GRID_COLS_SEQ CONSTANT PLS_INTEGER := 9;
516 CZ_EXPRESSIONS_SEQ CONSTANT PLS_INTEGER := 10;
517 CZ_EXPRESSION_NODES_SEQ CONSTANT PLS_INTEGER := 11;
518 CZ_RULES_SEQ CONSTANT PLS_INTEGER := 12;
519 CZ_GRID_CELLS_SEQ CONSTANT PLS_INTEGER := 13;
520 CZ_LCE_HEADERS_SEQ CONSTANT PLS_INTEGER := 14;
521 CZ_MODEL_PUBLICATIONS_SEQ CONSTANT PLS_INTEGER := 15;
522 CZ_EFFECTIVITY_SETS_SEQ CONSTANT PLS_INTEGER := 16;
523 CZ_CONFIG_MESSAGES_SEQ CONSTANT PLS_INTEGER := 17;
524 CZ_UI_TEMPLATES CONSTANT PLS_INTEGER := 18;
525 CZ_SIGNATURES_SEQ CONSTANT PLS_INTEGER := 19;
526 CZ_ARCHIVES_SEQ CONSTANT PLS_INTEGER := 20;
527 CZ_FILTER_SETS_SEQ CONSTANT PLS_INTEGER := 21;
528 CZ_POPULATORS_SEQ CONSTANT PLS_INTEGER := 22;
529 CZ_UI_ACTIONS_SEQ CONSTANT PLS_INTEGER := 23;
530 CZ_PROPERTIES_SEQ CONSTANT PLS_INTEGER := 24;
531 CZ_ITEM_MASTERS_SEQ CONSTANT PLS_INTEGER := 25;
532 CZ_ITEM_TYPES_SEQ CONSTANT PLS_INTEGER := 26;
533 CZ_FCE_FILES_SEQ CONSTANT PLS_INTEGER := 27;
534
535 v_msg_tbl msg_text_list;
536 ----variables used for orig_sys_ref returned by bomsynch
537 v_devl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
538 v_it_masters_sys_ref VARCHAR2(255);
539 v_it_types_sys_ref VARCHAR2(255);
540 v_bomsynch_product_key cz_model_publications.product_key%TYPE;
541 v_bomsynch_org_id cz_model_publications.organization_id%TYPE;
542 v_bomsynch_item_id cz_model_publications.top_item_id%TYPE;
543 ---variables used by republish model
544 v_orig_start_date DATE;
545 v_orig_end_date DATE;
546 v_repub_appl_from DATE;
547 v_repub_appl_until DATE;
548 v_republish_model NUMBER := -1;
549 v_repub_remote_pb_id cz_model_publications.remote_publication_id%TYPE;
550 ------------variables used in publication functions
551 model_ref_expl_id_table t_ref;
552 v_last_struct_update DATE;
553 ----global declarations for item schema bug# 2463594
554 ----avoid using literals
555 g_item_type_id cz_item_types.item_type_id%TYPE;
556 g_item_id cz_item_masters.item_id%TYPE;
557 -- Array define to hold sequence count for each sequencer
558 v_sequence_count t_ref;
559 v_next_sequence_gen t_ref;
560 ------exceptions
561 pb_upload_ps_schema EXCEPTION;
562 pb_upload_ui_schema EXCEPTION;
563 pb_upload_rule_schema EXCEPTION;
564 pb_upload_item_schema EXCEPTION;
565 no_load_specs_data EXCEPTION;
566 insert_table_error EXCEPTION;
567 run_id_error EXCEPTION;
568 verify_model_error EXCEPTION;
569 proc_export_error EXCEPTION;
570 cz_pb_global_synch EXCEPTION;
571 ------------------------------------
572 PUBLICATION_ERROR CONSTANT VARCHAR2(3) := 'ERR';
573 PUBLICATION_OK CONSTANT VARCHAR2(3) := 'OK';
574 PUBLICATION_PROCESSING CONSTANT VARCHAR2(3) := 'PRC';
575 PUBLICATION_PENDING CONSTANT VARCHAR2(3) := 'PEN';
576 PUBLICATION_PEN_UPDATE CONSTANT VARCHAR2(3) := 'PUP';
577 PUB_SOURCE_TARGET_FLAG CONSTANT VARCHAR2(1) := 'T';
578 PS_NODE_REF_TYPE CONSTANT NUMBER := 263;
579 SEQUENCE_INCR_STR CONSTANT VARCHAR2(20) := 'OracleSequenceIncr';
580 record_commit_str CONSTANT VARCHAR2(20) := 'CommitSize';
581 publication_log CONSTANT VARCHAR2(20) := 'PublicationLogging';
582 pb_timing_log CONSTANT VARCHAR2(20) := 'PublicationTiming';
583 rule_copy CONSTANT VARCHAR2(20) := 'PublishingCopyRules';
584 empty_string CONSTANT VARCHAR2(5) := ' ';
585 null_string CONSTANT VARCHAR2(4) := 'NULL';
586 reasonid CONSTANT VARCHAR2(4) := '... ';
587 unmsgid CONSTANT VARCHAR2(3) := 'GS ';
588 pbnewline CONSTANT VARCHAR2(25) := fnd_global.NEWLINE;
589 non_virtual_component CONSTANT NUMBER := 259;
590 model_connector CONSTANT NUMBER := 264;
591 record_not_deleted CONSTANT VARCHAR2(1) := '0';
592 record_commit_size PLS_INTEGER := 500;
593 global_export_retcode PLS_INTEGER := 0;
594 global_process_retcode PLS_INTEGER := 0;
595 publication_timing CONSTANT NUMBER := 0;
596 v_new_object_id cz_rp_entries.object_id%TYPE;
597 model_copy CONSTANT VARCHAR2(20) := 'DEEP_MODEL_COPY';
598 pub_model CONSTANT VARCHAR2(20) := 'PUBLISHMODEL';
599 cz_publish CONSTANT VARCHAR2(30) := 'PUBLISH_NEW_MODEL';
600 cz_republish CONSTANT VARCHAR2(30) := 'REPUBLISH_EXISTING_MODEL';
601 copy_rules VARCHAR2(3) := 'YES';
602 copy_uis VARCHAR2(3) := 'YES';
603 copy_root_only VARCHAR2(3) := 'YES';
604 bom_synch_flag VARCHAR2(3) := 'NO';
605 v_session_parameter VARCHAR2(20) := empty_string;
606 new_copy_mode CONSTANT NUMBER := 0;
607 rebublish_mode CONSTANT NUMBER := 1;
608 repub_new_copy CONSTANT NUMBER := 2;
609 no_mode CONSTANT NUMBER := -1;
613 refresh_rules_count CONSTANT NUMBER := -666;
610 new_copy_str CONSTANT VARCHAR2(20) := 'new copy';
611 repub_str CONSTANT VARCHAR2(20) := 'republish model';
612 v_repub_parameter VARCHAR2(20) := empty_string;
614 v_refresh_rules VARCHAR2(3) := 'NO';
615 g_log_timing NUMBER := 1;
616 bom_item CONSTANT NUMBER := 0;
617 nonbom_item CONSTANT NUMBER := 1;
618 ------->>>>>>rewrite variables
619 template_publication CONSTANT VARCHAR2(3) := 'UIT';
620 model_publication CONSTANT VARCHAR2(3) := 'PRJ';
621 seed_data CONSTANT VARCHAR2(1) := '1';
622 oa_ui_style CONSTANT VARCHAR2(3) := '7';
623 locks_in_prod_mode CONSTANT VARCHAR2(200) := 'CZ_ALLOW_PUBLISH_TO_PRODUCTION_WHEN_LOCKED';
624 locks_in_test_mode CONSTANT VARCHAR2(200) := 'CZ_ALLOW_PUBLISH_TO_TEST_WHEN_LOCKED';
625 -----priv constants
626 publish_model_function CONSTANT VARCHAR2(100) := 'CZDEVPUBLISHFUNC';
627 has_no_privilege CONSTANT VARCHAR2(1) := 'F';
628 has_privilege CONSTANT VARCHAR2(1) := 'T';
629 use_entity_access_control CONSTANT VARCHAR2(100) := 'CZ_USE_ENTITY_ACCESS_CONTROL';
630
631 TYPE varchar_tbl_type IS TABLE OF VARCHAR2(255)
632 INDEX BY BINARY_INTEGER;
633
634 TYPE varchar_tbl_type_3 IS TABLE OF cz_rp_entries.object_type%TYPE
635 INDEX BY BINARY_INTEGER;
636
637 g_source_flag cz_model_publications.source_target_flag%TYPE;
638 g_target_flag cz_model_publications.source_target_flag%TYPE;
639 g_migration_group_id cz_model_publications.migration_group_id%TYPE;
640 g_object_type cz_model_publications.object_type%TYPE;
641 g_template_id cz.cz_ui_templates.template_id%TYPE;
642 g_jrad_doc cz.cz_ui_templates.jrad_doc%TYPE;
643 g_button_tmpl_id cz.cz_ui_templates.template_id%TYPE;
644 g_main_msg_id cz.cz_ui_templates.main_message_id%TYPE;
645 g_title_id cz.cz_ui_templates.title_id%TYPE;
646 pbdebug NUMBER := 0;
647 g_button_tbl t_ref;
648 g_message_tbl t_ref;
649 g_title_tbl t_ref;
650 g_jrad_doc_tbl varchar_tbl_type;
651 g_cz_ui_pages_ui_def_ref t_ref;
652 g_pages_ui_def_old_ref t_ref;
653 g_cz_ui_pages_jrad_doc_ref varchar_tbl_type;
654 g_cz_ui_old_jrad_doc_ref varchar_tbl_type;
655 g_cz_ui_pages_capt_id_ref t_ref;
656 g_cz_ui_pages_stat_templ t_ref;
657 g_cz_ui_pages_stat_ui t_ref;
658 g_cz_uipg_tmplid_tbl t_ref;
659 g_cz_uipg_tmplui_tbl t_ref;
660 g_intl_text_id_ref t_ref;
661 g_cz_ui_pages_ui_def_tbl t_ref;
662 g_cz_ui_pages_jrad_doc_tbl varchar_tbl_type;
663 g_cz_ui_pages_capt_id_tbl t_ref;
664 g_cz_ui_pages_dis_cond_tbl t_ref;
665 g_cz_ui_pages_enb_cond_tbl t_ref;
666 g_cz_ui_pages_expl_tbl t_ref;
667 g_page_sets_ui_old_ref t_ref;
668 g_page_sets_ui_ref t_ref;
669 g_page_sets_pg_tbl t_ref;
670 g_page_sets_jrad_doc_ref varchar_type_tbl;
671 g_page_sets_expl_tbl t_ref;
672 g_page_refs_ui_def_old_ref t_ref;
673 g_page_refs_ui_def_new_ref t_ref;
674 g_page_refs_pg_set_ref t_ref;
675 g_page_refs_pg_ref_ref t_ref;
676 g_page_refs_tgt_expl_tbl t_ref;
677 g_page_refs_cond_id_ref t_ref;
678 g_page_refs_capt_id_ref t_ref;
679 g_page_refs_tgt_ui_ref t_ref;
680 g_page_refs_cpt_rule_tbl t_ref;
681 g_ui_refs_old_ui_def_ref t_ref;
682 g_ui_refs_new_ui_def_ref t_ref;
683 g_ui_refs_ref_ui_def_ref t_ref;
684 g_ui_refs_expl_id_ref t_ref;
685 g_ui_refs_ref_ui_def_old_ref t_ref;
686 g_ui_refs_expl_id_old_ref t_ref;
687 g_ui_ps_maps_old_ui_def_ref t_ref;
688 g_ui_ps_maps_new_ui_def_ref t_ref;
689 g_ui_ps_maps_ctrl_tmp_ref t_ref;
690 g_ui_ps_maps_elem_sig_tbl t_ref;
691 g_ui_ps_maps_tgt_pg_ui_def_tbl t_ref;
692 g_ui_ps_maps_page_id_tbl t_ref;
693 g_ui_ps_maps_expl_id_tbl t_ref;
694 g_ui_ps_maps_templ_ui_tbl t_ref;
695 g_ui_ps_maps_element_tbl varchar_type_tbl;
696
697 -- g_ui_templates_jrad_new_ref/g_ui_templates_jrad_old_ref: not published before, or exported
698 -- before but changed since, used for isnertion or updates, and for replace_enxtends
699 -- g_tmpl_jrad_old_tbl/g_tmpl_jrad_new_tbl, exported and no change since, used in replace_extends
700 g_tmpl_jrad_old_tbl varchar_type_tbl;
701 g_tmpl_jrad_new_tbl varchar_type_tbl;
702 g_ui_templates_old_temp_id_ref t_ref;
703 g_ui_templates_new_temp_id_ref t_ref;
704 g_ui_templates_idx_temp_ref t_ref_idx_vc2;
705 g_ui_templates_ui_def_old_ref t_ref;
706 mm_ui_tmpls_ui_def_old_ref t_ref;
707 g_ui_templates_ui_def_new_ref t_ref;
708 g_template_id_ref t_ref;
709 g_ref_template_id_ref t_ref;
710 g_ref_template_id_old_ref t_ref;
711 g_template_ui_ref t_ref;
712 g_ref_templ_ui_ref t_ref;
713 g_template_id_old_ref t_ref;
714 g_ui_templates_msg_id_ref t_ref;
715 g_ui_templates_title_ref t_ref;
716 g_ui_templates_jrad_new_ref varchar_type_tbl;
717 g_ui_templates_jrad_old_ref varchar_type_tbl;
718 g_ui_templates_button_tbl t_ref;
719 g_ui_templates_but_uidef_id t_ref;
720 g_cnt_typ_tmpls_old_uidef_ref t_ref;
721 g_cnt_typ_tmpls_new_uidef_ref t_ref;
722 g_cnt_typ_tmpls_tmpid_ref t_ref;
723 g_cnt_typ_tmpls_tgtuidef_ref t_ref;
724 g_cnt_typ_tmpls_cont_ref t_ref;
725 g_ui_actns_ui_act_id_ref t_ref;
726 g_ui_actns_ui_act_id_old_ref t_ref;
727 g_ui_actions_id_idx_ref t_ref_idx_vc2;
728 g_ui_actns_ui_uidef_ref t_ref;
729 g_ui_actns_ui_tgtui_ref t_ref;
730 g_ui_actns_ui_uidef_old_ref t_ref;
734 g_intl_text_model_tbl t_ref;
731 g_ui_actns_tgtexpl_ref t_ref;
732 g_ui_actns_ctx_comp_tbl t_ref;
733 g_ui_actns_ren_cond_tbl t_ref;
735 g_intl_text_ui_tbl t_ref;
736 g_archive_id_ref t_ref;
737 g_devl_proj_ref t_ref;
738 g_archives_new_ref t_ref;
739 g_archives_old_ref t_ref;
740 g_archives_old_tbl t_ref;
741 g_archives_idx_ref t_ref_idx_vc2;
742 g_archive_id_old_ref t_ref;
743 g_devl_proj_old_ref t_ref;
744 g_archives_obj_type varchar_tbl_type_3;
745 g_archives_mig_idx_ref t_ref_idx_vc2;
746 -- Bug 5514199; 12-Sep-2006; kdande; Moved the following plsql table declarations from package body
747 -- in order to use these plsql tables in dynamic sqls of package body
748 l_cnt_typ_tmpls_cont_ref cz_pb_mgr.t_ref;
749 l_cnt_typ_tmpls_new_uidef_ref cz_pb_mgr.t_ref;
750 l_ui_images_ui_ref cz_pb_mgr.t_ref;
751 l_ui_images_enty_tbl cz_pb_mgr.t_ref;
752 l_ui_images_usg_tbl cz_pb_mgr.t_ref;
753 h_devl_prj_by_intl_text t_ref_idx_vc2;
754 l_intl_text_id_tbl t_ref;
755 l_bom_caption_rule_tbl t_ref;
756 l_nonbom_caption_rule_tbl t_ref;
757 v_ui_images_ui_ref t_ref;
758 v_ui_images_ui_tbl t_ref;
759 v_ui_images_usg_tbl t_ref;
760 v_ui_images_enty_tbl t_ref;
761 v_filter_sets_new_id_ref t_ref;
762 v_filter_sets_id_ref t_ref;
763 v_filter_sets_devl_ref t_ref;
764 v_filter_sets_rule_ref t_ref;
765 v_filter_sets_idx_ref t_ref_idx_vc2;
766 v_populators_new_id_ref t_ref;
767 v_populators_id_ref t_ref;
768 v_populators_node_ref t_ref;
769 v_populators_set_id_ref t_ref;
770 g_jrad_trans_list jdr_utils.translationlist := jdr_utils.translationlist();
771 g_migration_tgt_folder_id cz_model_publications.migration_tgt_folder%TYPE;
772 g_mt_obj_type varchar_tbl_type_3;
773 g_mt_enclosing_fld_rp_entry t_ref;
774 g_ui_templates_obj_type varchar_tbl_type_3;
775 g_enclosing_fld_rp_entry t_ref;
776 g_eff_set_obj_type varchar_tbl_type_3;
777
778 mm_intl_text_model_id_ref t_ref;
779
780 -- 28b change
781 g_ps_reverse_connector_tbl t_ref;
782 g_uiact_prcpg_templ_tbl t_ref;
783 g_uiact_prcpg_tmpui_tbl t_ref;
784 g_uiact_prc_caption_tbl t_ref;
785 g_uiact_pg_title_tbl t_ref;
786 g_uiact_main_msg_tbl t_ref;
787 g_fcefile_old_id_tbl t_ref;
788 g_fcefile_new_id_tbl t_ref;
789 g_fcefile_compid_tbl t_ref;
790
791 --Arrays for handling usage synch and re-keying during migration
792 TYPE t_eff_usage_mask IS TABLE OF cz_ps_nodes.effective_usage_mask%TYPE
793 INDEX BY BINARY_INTEGER;
794
795 v_cz_effective_usage_mask_ref t_eff_usage_mask;
796 v_cz_effective_usage_mask_tbl t_eff_usage_mask;
797 v_cz_rule_usage_mask_tbl t_eff_usage_mask;
798 v_cz_ps_to_eff_usg_mask t_eff_usage_mask;
799 v_new_eff_usg_msk_tbl t_eff_usage_mask;
800 v_new_rul_usg_msk_tbl t_eff_usage_mask;
801
802 TYPE t_usage_name IS TABLE OF cz_model_usages.NAME%TYPE
803 INDEX BY BINARY_INTEGER;
804
805 v_old_usage_name_to_id_map t_usage_name;
806
807 TYPE t_usage_name_1 IS TABLE OF cz_model_usages.model_usage_id%TYPE
808 INDEX BY VARCHAR2(2000);
809
810 v_new_usage_name_to_id_map t_usage_name_1;
811 g_usg_name_processed t_usage_name_1;
812
813 --Arrays for Mater template synch.
814 v_master_template_id_ref t_ref;
815
816 TYPE t_mt_name IS TABLE OF cz_ui_defs.NAME%TYPE
817 INDEX BY BINARY_INTEGER;
818
819 v_mt_name t_mt_name;
820 v_mt_old_id_tbl t_ref;
821 v_mt_old_id_ref t_ref;
822 v_mt_gen_id t_ref;
823 v_mt_old_only t_ref;
824
825 TYPE t_mt_name_ref IS TABLE OF NUMBER
826 INDEX BY cz_ui_defs.NAME%TYPE;
827
828 v_mt_name_ref t_mt_name_ref;
829
830 TYPE t_mt_name_to_id_map IS TABLE OF cz_ui_defs.ui_def_id%TYPE
831 INDEX BY VARCHAR2(2000);
832
833 v_new_mt_name_to_id_map t_mt_name_to_id_map;
834 v_mt_id_ref t_ref;
835 v_new_mt_id_ref t_ref;
836 v_new_mt_id_tbl t_ref;
837 v_mt_old_to_new_id t_ref_idx_vc2;
838
839 --->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
840 --------sequence generator
841 FUNCTION sequence_generate(seq_const PLS_INTEGER, seq_name VARCHAR2, p_oraclesequenceincr NUMBER)
842 RETURN NUMBER;
843
844 ----->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
845 ------------- procedure to publish a single model
849 ---------procedure to publish all models
846 PROCEDURE publish_model(publicationid IN NUMBER, x_run_id IN OUT NOCOPY NUMBER, x_pb_status IN OUT NOCOPY VARCHAR2);
847
848 --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
850 PROCEDURE publish_all_models;
851
852 ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
853 -------procedure to check if model is upto date
854 PROCEDURE model_upto_date(modelid IN NUMBER, uidefid IN NUMBER, status IN OUT NOCOPY VARCHAR2);
855
856 -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
857 ---------deep model copy
858 PROCEDURE deep_model_copy(
859 p_model_id IN NUMBER
860 ,p_server_id IN NUMBER
861 ,p_folder IN NUMBER
862 ,p_copy_rules IN NUMBER
863 ,p_copy_uis IN NUMBER
864 ,p_copy_root IN NUMBER
865 ,x_model_id OUT NOCOPY NUMBER
866 ,x_run_id OUT NOCOPY NUMBER
867 ,x_status OUT NOCOPY VARCHAR2
868 );
869
870 --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
871 PROCEDURE deep_model_copy(
872 p_model_id IN NUMBER
873 ,p_server_id IN NUMBER
874 ,p_folder IN NUMBER
875 ,p_copy_rules IN NUMBER
876 ,p_copy_uis IN NUMBER
877 ,p_copy_root IN NUMBER
878 ,x_return_status OUT NOCOPY VARCHAR2
879 ,x_msg_count OUT NOCOPY NUMBER
880 ,x_msg_data OUT NOCOPY VARCHAR2
881 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
882 );
883
884 -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
885 --------check overlap publications
886 PROCEDURE check_publication_overlap(
887 productkey IN VARCHAR2
888 ,publicationmode IN VARCHAR2
889 ,applicationid IN VARCHAR2
890 ,languageid IN VARCHAR2
891 ,usageid IN VARCHAR2
892 ,serverid IN NUMBER
893 ,startdate IN DATE
894 ,disabledate IN DATE
895 ,sourcetargetflag IN VARCHAR2
896 ,pubrecid IN NUMBER
897 ,publicationidstring OUT NOCOPY VARCHAR2
898 );
899
900 ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
901 -----------------edit publication
902 PROCEDURE edit_publication(
903 publicationid IN NUMBER
904 ,applicationid IN OUT NOCOPY VARCHAR2
905 ,languageid IN OUT NOCOPY VARCHAR2
906 ,usageid IN OUT NOCOPY VARCHAR2
907 ,startdate IN DATE
908 ,disabledate IN DATE
909 ,publicationmode IN VARCHAR2
910 ,x_return_status OUT NOCOPY VARCHAR2
911 ,x_msg_count OUT NOCOPY NUMBER
912 ,x_msg_data OUT NOCOPY VARCHAR2
913 );
914
915 ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
916 --------------
917 PROCEDURE edit_tgt_pub(
918 publicationid IN NUMBER
919 ,applicationid IN OUT NOCOPY VARCHAR2
920 ,languageid IN OUT NOCOPY VARCHAR2
921 ,usageid IN OUT NOCOPY VARCHAR2
922 ,startdate IN DATE
923 ,disabledate IN DATE
924 ,publicationmode IN VARCHAR2
925 ,x_return_status OUT NOCOPY VARCHAR2
926 ,x_msg_count OUT NOCOPY NUMBER
927 ,x_msg_data OUT NOCOPY VARCHAR2
931 ---------------enable publication
928 );
929
930 -------------------------------
932 PROCEDURE enable_publication(
933 publicationid IN NUMBER
934 ,x_return_status OUT NOCOPY VARCHAR2
935 ,x_msg_count OUT NOCOPY NUMBER
936 ,x_msg_data OUT NOCOPY VARCHAR2
937 );
938
939 ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
940 --------------disable publication
941 PROCEDURE disable_publication(
942 publicationid IN NUMBER
943 ,x_return_status OUT NOCOPY VARCHAR2
944 ,x_msg_count OUT NOCOPY NUMBER
945 ,x_msg_data OUT NOCOPY VARCHAR2
946 );
947
948 ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
949 ----------delete publication
950 PROCEDURE delete_publication(
951 publicationid IN NUMBER
952 ,x_return_status OUT NOCOPY VARCHAR2
953 ,x_msg_count OUT NOCOPY NUMBER
954 ,x_msg_data OUT NOCOPY VARCHAR2
955 );
956
957 --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
958 ---------wrapper called by concurrent manager to publish models
959 ---------
960 PROCEDURE publish_single_model_cp(errbuf IN OUT NOCOPY VARCHAR2, retcode IN OUT NOCOPY PLS_INTEGER, p_publication_id NUMBER);
961
962 PROCEDURE publish_models_cp(errbuf IN OUT NOCOPY VARCHAR2, retcode IN OUT NOCOPY PLS_INTEGER);
963
964 --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
965 ----------------log errors
966 ---------------
967 PROCEDURE log_pb_errors(p_message IN VARCHAR2, p_urgency IN VARCHAR2, p_caller IN VARCHAR2, p_statuscode IN PLS_INTEGER);
968
969 --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
970 PROCEDURE reset_processing_pubs;
971
972 FUNCTION retrieve_db_link(p_server_id PLS_INTEGER)
973 RETURN VARCHAR2;
974
975 FUNCTION is_val_number (p_str IN VARCHAR2) RETURN VARCHAR2;
976
977 PROCEDURE republish_model(
978 p_publication_id IN OUT NOCOPY NUMBER
979 ,p_start_date IN OUT NOCOPY DATE
980 ,p_end_date IN OUT NOCOPY DATE
981 ,x_run_id OUT NOCOPY NUMBER
982 ,x_status OUT NOCOPY cz_model_publications.export_status%TYPE
983 );
984
985 PROCEDURE create_republish_publication(
986 p_publication_id IN NUMBER
987 ,x_new_publication_id OUT NOCOPY NUMBER
988 ,x_return_status OUT NOCOPY VARCHAR2
989 ,x_msg_count OUT NOCOPY NUMBER
990 ,x_msg_data OUT NOCOPY VARCHAR2
991 );
992
993 ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
994 -----procedure to copy single UI
995 PROCEDURE export_single_oa_ui(
996 p_ui_def_id IN NUMBER
997 ,x_ui_def_id OUT NOCOPY NUMBER
998 ,x_return_status OUT NOCOPY VARCHAR2
999 ,x_msg_count OUT NOCOPY NUMBER
1000 ,x_msg_data OUT NOCOPY VARCHAR2
1001 );
1002
1003 PROCEDURE is_ui_upto_date(p_ui_def_id IN NUMBER, x_return_status OUT NOCOPY NUMBER, x_msg_data OUT NOCOPY VARCHAR2);
1004
1005 FUNCTION is_ui_upto_date(p_ui_def_id IN NUMBER)
1006 RETURN VARCHAR2;
1007
1008 PROCEDURE is_model_upto_date(p_model_id IN NUMBER, x_return_status IN OUT NOCOPY NUMBER, x_msg_data IN OUT NOCOPY VARCHAR2);
1009
1010 PROCEDURE export_jrad_docs(
1011 p_document_name IN VARCHAR2
1012 ,p_link_name IN VARCHAR2
1013 ,x_return_status OUT NOCOPY VARCHAR2
1014 ,x_msg_count OUT NOCOPY NUMBER
1015 ,x_msg_data OUT NOCOPY VARCHAR2
1016 );
1017
1018 PROCEDURE insert_jrad_docs;
1019
1020 PROCEDURE export_jrad_docs(
1021 p_ui_def_id IN NUMBER
1022 ,p_link_name IN VARCHAR2
1023 ,x_return_status OUT NOCOPY VARCHAR2
1024 ,x_msg_count OUT NOCOPY NUMBER
1025 ,x_msg_data OUT NOCOPY VARCHAR2
1026 );
1027
1028 PROCEDURE export_template_jrad_docs(
1029 p_link_name IN VARCHAR2
1030 ,x_return_status OUT NOCOPY VARCHAR2
1031 ,x_msg_count OUT NOCOPY NUMBER
1032 ,x_msg_data OUT NOCOPY VARCHAR2
1033 );
1034
1035 PROCEDURE exploretree(
1036 p_jrad_parent_element IN jdr_docbuilder.ELEMENT
1037 ,p_dom_parent_element IN xmldom.domnode
1038 ,p_grouping_tag IN VARCHAR2
1039 ,p_link_name IN VARCHAR2
1040 );
1041
1042 FUNCTION copy_name(p_devl_project_id IN NUMBER)
1043 RETURN VARCHAR2;
1044
1045 PROCEDURE create_publication_request(
1046 p_model_id IN NUMBER
1047 ,p_ui_def_id IN NUMBER
1048 ,p_publication_mode IN VARCHAR2
1049 ,p_server_id IN NUMBER
1050 ,p_appl_id_tbl IN cz_pb_mgr.t_ref
1051 ,p_usg_id_tbl IN cz_pb_mgr.t_ref
1052 ,p_lang_tbl IN cz_pb_mgr.t_lang_code
1053 ,p_start_date IN DATE
1054 ,p_end_date IN DATE
1055 ,x_publication_id OUT NOCOPY NUMBER
1056 ,x_return_status OUT NOCOPY VARCHAR2
1057 ,x_msg_count OUT NOCOPY NUMBER
1058 ,x_msg_data OUT NOCOPY VARCHAR2
1059 );
1060
1061 PROCEDURE edit_publication(
1062 publicationid IN NUMBER
1063 ,applicationid IN OUT NOCOPY cz_pb_mgr.t_ref
1064 ,languageid IN OUT NOCOPY cz_pb_mgr.t_lang_code
1065 ,usageid IN OUT NOCOPY cz_pb_mgr.t_ref
1066 ,startdate IN DATE
1067 ,disabledate IN DATE
1068 ,publicationmode IN VARCHAR2
1069 ,x_return_status OUT NOCOPY VARCHAR2
1070 ,x_msg_count OUT NOCOPY NUMBER
1071 ,x_msg_data OUT NOCOPY VARCHAR2
1072 );
1073
1074 PROCEDURE seed_fnd_application_cp(errbuf IN OUT NOCOPY VARCHAR2, retcode IN OUT NOCOPY PLS_INTEGER, p_application_name VARCHAR2);
1075
1079 v_prop_vals_item_id_ref t_ref;
1076 --model migration
1077 --more columns required for property resolution
1078 v_prop_vals_item_type_id_ref t_ref;
1080 v_prop_vals_valuesource_ref varchar_type_8_tbl;
1081 v_prop_vals_inherited_flag_ref varchar_type_1_tbl;
1082 model_publication_obselete CONSTANT VARCHAR2(3) := 'OBS';
1083 pub_maybe_obsoleted EXCEPTION;
1084 prop_valuesource_itemdefault CONSTANT VARCHAR2(7) := 'ItmDflt';
1085 prop_valuesource_item CONSTANT VARCHAR2(4) := 'Item';
1086 prop_valuesource_itemtype CONSTANT VARCHAR2(6) := 'ItmTyp';
1087 prop_valuesource_psdefault CONSTANT VARCHAR2(6) := 'PsDflt';
1088 prop_valuesource_psvalue CONSTANT VARCHAR2(7) := 'PsValue';
1089 mm_v_tbl_sync_prop_type varchar_tbl_type_3;
1090 mm_v_tbl_sync_prop_folder t_ref;
1091 mm_v_ui_from_msttmp_id_tbl t_ref;
1092 mm_v_tbl_sync_prop t_ref_idx_vc2;
1093 mm_v_tbl_sync_prop_vals_num t_ref_idx_vc2;
1094 mm_v_tbl_prop_vals_trans_old t_ref;
1095 mm_v_tbl_prop_vals_trans_new t_ref;
1096 mm_v_ht_sync_all_prop t_ref_idx_vc2;
1097 mm_v_ht_sync_all_prop_val_num t_ref;
1098 mm_v_ht_sync_item_type t_ref_idx_vc2;
1099 mm_v_ht_sync_item_type_items t_ref_idx_vc2;
1100 mm_v_ht_sync_items t_ref_idx_vc2;
1101 mm_v_ht_sync_it_propval_itm t_ref_idx_vc2;
1102 mm_v_ht_sync_exist_items t_ref;
1103 mm_v_ps_item_id_tbl t_ref;
1104 mm_v_ht_sync_item_prop t_ref;
1105 mm_v_ht_sync_item_type_prop t_ref_idx_vc2;
1106 mm_v_ht_sync_itmtype_for_prop t_ref_idx_vc2;
1107 mm_v_ht_sync_ps_propval t_ref;
1108 mm_v_ht_sync_it_propval t_ref_idx_vc2;
1109 mm_v_ht_sync_archives t_ref;
1110 mm_v_ht_sync_archive_refs t_ref;
1111 mm_v_itmst_ref_part_nbr_ref varchar_type_1000_tbl;
1112 mm_v_itmst_ref_part_nbr_tbl varchar_type_1000_tbl;
1113 mm_v_itmst_src_app_id_ref t_ref;
1114 mm_v_itmst_src_app_id_tbl t_ref;
1115 mm_v_ht_eff_set_tbl_t t_ref;
1116 mm_v_ht_eff_set_tbl_s t_ref;
1117 mm_v_tbl_rule_seq t_ref;
1118 mm_v_ht_rule_rule_seq t_ref;
1119 mm_v_ht_item_types_orig_ref orig_sys_ref_type;
1120 mm_v_ht_items_orig_ref orig_sys_ref_type;
1121 mm_insert_array1 t_ref;
1122 mm_insert_array2 t_ref;
1123 mm_insert_array3 orig_sys_ref_type;
1124 mm_source_array1 t_ref;
1125 mm_source_array2 t_ref;
1126 mm_source_array3 orig_sys_ref_type;
1127 mm_objtype_array varchar_tbl_type_3;
1128 mm_tgtfldr_array t_ref;
1129
1130 PROCEDURE mm_loadoldpsnodesforitems;
1131
1132 PROCEDURE mm_raiseallpossiblesyncerrors;
1133
1134 PROCEDURE get_all_properties;
1135
1136 PROCEDURE mm_sync_properties;
1137
1138 PROCEDURE mm_migrate_into_ps_prop_vals;
1139
1140 PROCEDURE mm_sync_itemschema;
1141
1142 PROCEDURE mm_insert_archives;
1143
1144 PROCEDURE mm_sync_archives;
1145
1146
1147 PROCEDURE mm_insert_archives_for_pb;
1148
1149 PROCEDURE mm_get_ifexists_on_target(source_id IN NUMBER, target_id IN OUT NOCOPY NUMBER, what_exists IN VARCHAR2);
1150
1151 FUNCTION mm_sync_eff_sets(old_eff_set_id NUMBER, new_eff_set_id NUMBER)
1152 RETURN NUMBER;
1153
1154 FUNCTION mm_get_ifexists_on_source(source_id IN NUMBER, what_exists VARCHAR2)
1155 RETURN VARCHAR2;
1156
1157 FUNCTION mm_get_newid(what_id IN VARCHAR2)
1158 RETURN NUMBER;
1159
1160 mm_v_rootmodels_tobe_exported t_ref;
1161 mm_v_rootmodels_notbe_exported t_ref;
1162
1163 PROCEDURE mm_get_models_tobe_exported(rootmodelid_tbl IN cz_pb_mgr.t_ref);
1164
1165 FUNCTION mm_chkifmodelselectedforexport(input_model NUMBER)
1166 RETURN NUMBER;
1167
1168 FUNCTION get_rootmodel_and_mig_tgt_fldr(p_publication_id NUMBER)
1169 RETURN t_ref;
1170
1171 PROCEDURE mm_break_long_str(v_inp_str IN VARCHAR2);
1172
1173 PROCEDURE mm_resolve_ids(
1174 array_to_resolve IN cz_pb_mgr.t_ref
1175 ,array_of_new_keys IN cz_pb_mgr.t_ref_idx_vc2
1176 ,resolving_id IN VARCHAR2
1177 ,resolved_array IN OUT NOCOPY cz_pb_mgr.t_ref
1178 ,source_array IN OUT NOCOPY cz_pb_mgr.t_ref
1179 );
1180
1181 PROCEDURE mm_resolve_ids_w_rp_entries(
1182 array_to_resolve IN cz_pb_mgr.t_ref
1183 ,array_of_new_keys IN cz_pb_mgr.t_ref_idx_vc2
1184 ,object_type IN VARCHAR2
1185 ,target_folder IN NUMBER
1186 ,resolving_id IN VARCHAR2
1187 ,resolved_array IN OUT NOCOPY cz_pb_mgr.t_ref
1188 ,object_type_array IN OUT NOCOPY cz_pb_mgr.varchar_tbl_type_3
1189 ,tgt_folder_array IN OUT NOCOPY cz_pb_mgr.t_ref
1190 ,source_array IN OUT NOCOPY cz_pb_mgr.t_ref
1191 );
1192
1193 PROCEDURE mm_resolve_orig_refs(
1194 array_to_resolve IN cz_pb_mgr.t_ref
1195 ,array_of_new_keys IN cz_pb_mgr.orig_sys_ref_type
1196 ,resolving_id IN VARCHAR2
1197 ,resolved_array IN OUT NOCOPY cz_pb_mgr.orig_sys_ref_type
1198 ,source_array IN OUT NOCOPY cz_pb_mgr.orig_sys_ref_type
1199 );
1200
1201 PROCEDURE mm_resync_ps_items;
1202
1203 PROCEDURE insert_into_rp_entries(
1204 table_name IN VARCHAR2
1205 ,primary_key1 IN VARCHAR2
1206 ,primary_key2 IN VARCHAR2
1207 ,db_link IN VARCHAR2
1208 ,plsql_table_list IN cz_pb_mgr.col_plsql_table_list
1209 ,plsql_table_name1 IN VARCHAR2
1210 ,plsql_table_name2 IN VARCHAR2
1211 ,primary_key_plsql_table1 IN OUT NOCOPY cz_pb_mgr.t_ref
1212 ,primary_key_plsql_table2 IN OUT NOCOPY cz_pb_mgr.varchar_tbl_type_3
1213 );
1214
1215 PROCEDURE mm_resolve_rule_seq_effsetid;
1216 FUNCTION getRemoteImportServer(x_import_server_on_local IN OUT NOCOPY cz_servers.server_local_id%TYPE) RETURN NUMBER;
1217 FUNCTION has_ui_inany_chld_mdl_changed(rootmodelid IN NUMBER)RETURN boolean;
1218 FUNCTION get_mdl_last_xfr_activity(
1219 p_model_id IN cz_model_publications.model_id%TYPE
1220 ,p_server_id IN cz_model_publications.server_id%TYPE
1221
1222 ) RETURN DATE;
1223 END cz_pb_mgr;