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;
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;
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;
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;
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;
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;
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;
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;
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;
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;