[Home] [Help]
273: cz_pb_mgr.v_child_expl_id_ref.DELETE;
274: cz_pb_mgr.v_referring_node_id_ref.DELETE;
275: cz_pb_mgr.v_ref_model_id_ref.DELETE;
276: END IF;
277: ELSIF(p_table_name = 'cz_func_comp_specs')
278: THEN
279: IF (p_table_type = 'tbl')
280: THEN
281: cz_pb_mgr.v_cz_func_comp_old_tbl.DELETE;
6512: delete_from_table('cz_ui_actions','ui_def_id','ui_action_id',v_database_link,'cz_pb_mgr.g_ui_actns_ui_uidef_ref','cz_pb_mgr.g_ui_actns_ui_act_id_ref',cz_pb_mgr.g_ui_actns_ui_uidef_ref);
6513: delete_from_table('cz_ui_images','ui_def_id','image_usage_code','entity_code',v_database_link,'cz_pb_mgr.l_ui_images_ui_ref','cz_pb_mgr.l_ui_images_usg_tbl','cz_pb_mgr.l_ui_images_enty_tbl',cz_pb_mgr.l_ui_images_ui_ref);
6514: delete_from_table('cz_signatures','signature_id',v_database_link,'cz_pb_mgr.v_sig_new_ref',cz_pb_mgr.v_sig_new_ref);
6515: delete_from_table('cz_signature_arguments','argument_signature_id','argument_index',v_database_link,'cz_pb_mgr.v_arg_sig_tbl','cz_pb_mgr.v_arg_ind_old_tbl',cz_pb_mgr.v_arg_sig_tbl);
6516: delete_from_table('cz_func_comp_specs','func_comp_id',v_database_link,'cz_pb_mgr.v_cz_func_comp_new_ref',cz_pb_mgr.v_cz_func_comp_new_ref);
6517: delete_from_table('cz_populators','populator_id',v_database_link,'cz_pb_mgr.v_populators_new_id_ref',cz_pb_mgr.v_populators_new_id_ref);
6518: delete_from_table('cz_filter_sets','filter_set_id',v_database_link,'cz_pb_mgr.v_filter_sets_new_id_ref',cz_pb_mgr.v_filter_sets_new_id_ref);
6519: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.g_archives_new_ref',cz_pb_mgr.g_archives_new_ref);
6520:
7711: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7712: ----get last update date for FC
7713: PROCEDURE get_fc_date(p_model_array IN cz_pb_mgr.t_ref, x_max_update_date IN OUT NOCOPY DATE)
7714: AS
7715: v_update_date cz_func_comp_specs.last_update_date%TYPE;
7716: BEGIN
7717: IF (p_model_array.COUNT > 0)
7718: THEN
7719: x_max_update_date := cz_utils.epoch_begin;
7722: LOOP
7723: BEGIN
7724: SELECT MAX(last_update_date)
7725: INTO v_update_date
7726: FROM cz_func_comp_specs
7727: WHERE cz_func_comp_specs.devl_project_id = p_model_array(i) AND cz_func_comp_specs.deleted_flag = record_not_deleted;
7728: EXCEPTION
7729: WHEN OTHERS
7730: THEN
7723: BEGIN
7724: SELECT MAX(last_update_date)
7725: INTO v_update_date
7726: FROM cz_func_comp_specs
7727: WHERE cz_func_comp_specs.devl_project_id = p_model_array(i) AND cz_func_comp_specs.deleted_flag = record_not_deleted;
7728: EXCEPTION
7729: WHEN OTHERS
7730: THEN
7731: v_update_date := NULL;
8623: v_last_struct_update cz_devl_projects.last_struct_update%TYPE;
8624: v_models_tbl cz_pb_mgr.t_ref;
8625: record_count PLS_INTEGER := 0;
8626: v_last_update_date cz_ui_defs.last_update_date%TYPE;
8627: v_fc_update_date cz_func_comp_specs.last_update_date%TYPE;
8628: v_eff_update_date DATE;
8629: v_last_xfr_activity cz_pb_model_exports.last_xfr_activity%TYPE;
8630: l_max_template_date cz_pb_model_exports.last_xfr_activity%TYPE;
8631: l_capt_update_date DATE;
11923: THEN
11924: log_timing_message('start bulk collect of func comp specs');
11925: END IF;
11926:
11927: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
11928:
11929: IF (cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0)
11930: THEN
11931: FOR i IN cz_pb_mgr.v_cz_model_ref_expls_old_ref.FIRST .. cz_pb_mgr.v_cz_model_ref_expls_old_ref.LAST
11929: IF (cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0)
11930: THEN
11931: FOR i IN cz_pb_mgr.v_cz_model_ref_expls_old_ref.FIRST .. cz_pb_mgr.v_cz_model_ref_expls_old_ref.LAST
11932: LOOP
11933: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
11934: v_cz_func_devl_old_tbl.DELETE;
11935: v_cz_func_cid_old_tbl.DELETE;
11936: v_cz_func_expl_old_tbl.DELETE;
11937: v_cz_func_fld_old_tbl.DELETE;
11937: v_cz_func_fld_old_tbl.DELETE;
11938: v_object_type_tbl.DELETE;
11939:
11940: BEGIN
11941: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_func_comp_specs_seq
11942: , 'cz_func_comp_specs_s.nextval' || cz_pb_mgr.v_db_link
11943: ,cz_pb_mgr.v_oraclesequenceincr
11944: )
11945: ,func_comp_id, devl_project_id, component_id, model_ref_expl_id
11938: v_object_type_tbl.DELETE;
11939:
11940: BEGIN
11941: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_func_comp_specs_seq
11942: , 'cz_func_comp_specs_s.nextval' || cz_pb_mgr.v_db_link
11943: ,cz_pb_mgr.v_oraclesequenceincr
11944: )
11945: ,func_comp_id, devl_project_id, component_id, model_ref_expl_id
11946: ,rule_folder_id, 'FNC'
11946: ,rule_folder_id, 'FNC'
11947: BULK COLLECT INTO cz_pb_mgr.v_cz_func_comp_new_tbl
11948: ,cz_pb_mgr.v_cz_func_comp_old_tbl, v_cz_func_devl_old_tbl, v_cz_func_cid_old_tbl, v_cz_func_expl_old_tbl
11949: ,v_cz_func_fld_old_tbl, v_object_type_tbl
11950: FROM cz_func_comp_specs t
11951: WHERE t.model_ref_expl_id = cz_pb_mgr.v_cz_model_ref_expls_old_ref(i) AND t.deleted_flag = '0';
11952: EXCEPTION
11953: WHEN NO_DATA_FOUND
11954: THEN
11955: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
11956: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.FUNCCOMP', SQLCODE);
11957: WHEN OTHERS
11958: THEN
11959: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_func_comp_specs', 'SQLERRM', SQLERRM);
11960: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
11961: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11962: RAISE;
11963: END;
12205: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
12206: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
12207: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
12208: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
12209: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
12210: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
12211: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
12212: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
12213: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
12206: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
12207: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
12208: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
12209: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
12210: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
12211: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
12212: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
12213: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
12214: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
15074: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
15075: rec_count := rec_count + 1;
15076: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
15077: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
15078: ----------insert into cz_func_comp_specs
15079: insert_into_table('cz_rule_folders'
15080: ,'rule_folder_id'
15081: ,'object_type'
15082: ,cz_pb_mgr.v_db_link
15654: cz_pb_mgr.v_cz_func_fld_old_ref(i):=v_model_root_folder_map(cz_pb_mgr.v_cz_func_devl_old_ref(i));
15655: END IF;
15656: END LOOP;
15657: END IF;
15658: resolve_ids(cz_pb_mgr.v_cz_func_fld_old_ref, cz_pb_mgr.v_cz_folders_id_idx_ref, 'rule folder id of cz_func_comp_specs');
15659:
15660: IF (cz_pb_mgr.g_log_timing = publication_timing)
15661: THEN
15662: log_timing_message('start resolve_ids devl project id of cz_func_comp_specs');
15658: resolve_ids(cz_pb_mgr.v_cz_func_fld_old_ref, cz_pb_mgr.v_cz_folders_id_idx_ref, 'rule folder id of cz_func_comp_specs');
15659:
15660: IF (cz_pb_mgr.g_log_timing = publication_timing)
15661: THEN
15662: log_timing_message('start resolve_ids devl project id of cz_func_comp_specs');
15663: END IF;
15664:
15665: resolve_ids(cz_pb_mgr.v_cz_func_devl_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl project id of cz_func_comp_specs');
15666:
15661: THEN
15662: log_timing_message('start resolve_ids devl project id of cz_func_comp_specs');
15663: END IF;
15664:
15665: resolve_ids(cz_pb_mgr.v_cz_func_devl_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl project id of cz_func_comp_specs');
15666:
15667: IF (cz_pb_mgr.g_log_timing = publication_timing)
15668: THEN
15669: log_timing_message('end resolve_ids devl project id of cz_func_comp_specs');
15665: resolve_ids(cz_pb_mgr.v_cz_func_devl_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl project id of cz_func_comp_specs');
15666:
15667: IF (cz_pb_mgr.g_log_timing = publication_timing)
15668: THEN
15669: log_timing_message('end resolve_ids devl project id of cz_func_comp_specs');
15670: log_timing_message('start resolve_ids component id of cz_func_comp_specs');
15671: END IF;
15672:
15673: resolve_ids(cz_pb_mgr.v_cz_func_cid_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_func_comp_specs', FLD_RULE_COMPONENT_ID);
15666:
15667: IF (cz_pb_mgr.g_log_timing = publication_timing)
15668: THEN
15669: log_timing_message('end resolve_ids devl project id of cz_func_comp_specs');
15670: log_timing_message('start resolve_ids component id of cz_func_comp_specs');
15671: END IF;
15672:
15673: resolve_ids(cz_pb_mgr.v_cz_func_cid_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_func_comp_specs', FLD_RULE_COMPONENT_ID);
15674:
15669: log_timing_message('end resolve_ids devl project id of cz_func_comp_specs');
15670: log_timing_message('start resolve_ids component id of cz_func_comp_specs');
15671: END IF;
15672:
15673: resolve_ids(cz_pb_mgr.v_cz_func_cid_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_func_comp_specs', FLD_RULE_COMPONENT_ID);
15674:
15675: IF (cz_pb_mgr.g_log_timing = publication_timing)
15676: THEN
15677: log_timing_message('end resolve_ids component id of cz_func_comp_specs');
15673: resolve_ids(cz_pb_mgr.v_cz_func_cid_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_func_comp_specs', FLD_RULE_COMPONENT_ID);
15674:
15675: IF (cz_pb_mgr.g_log_timing = publication_timing)
15676: THEN
15677: log_timing_message('end resolve_ids component id of cz_func_comp_specs');
15678: log_timing_message('start resolve_ids model ref expl id of cz_funce_comp_specs');
15679: END IF;
15680:
15681: resolve_ids(cz_pb_mgr.v_cz_func_expl_old_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of cz_func_comp_specs');
15677: log_timing_message('end resolve_ids component id of cz_func_comp_specs');
15678: log_timing_message('start resolve_ids model ref expl id of cz_funce_comp_specs');
15679: END IF;
15680:
15681: resolve_ids(cz_pb_mgr.v_cz_func_expl_old_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of cz_func_comp_specs');
15682:
15683: IF (cz_pb_mgr.g_log_timing = publication_timing)
15684: THEN
15685: log_timing_message('end resolve_ids model ref expl id of cz_funce_comp_specs');
15684: THEN
15685: log_timing_message('end resolve_ids model ref expl id of cz_funce_comp_specs');
15686: END IF;
15687:
15688: --------populate plsql_table_list for cz func comp specs
15689: plsql_table_list.DELETE;
15690: rec_count := 1;
15691: plsql_table_list(rec_count).col_name := 'func_comp_id';
15692: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_func_comp_new_ref';
15702: rec_count := rec_count + 1;
15703: plsql_table_list(rec_count).col_name := 'rule_folder_id';
15704: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_func_fld_old_ref';
15705:
15706: ----------insert into cz_func_comp_specs
15707: IF (cz_pb_mgr.g_log_timing = publication_timing)
15708: THEN
15709: log_timing_message('start insert_into_table cz_func_comp_specs');
15710: END IF;
15705:
15706: ----------insert into cz_func_comp_specs
15707: IF (cz_pb_mgr.g_log_timing = publication_timing)
15708: THEN
15709: log_timing_message('start insert_into_table cz_func_comp_specs');
15710: END IF;
15711:
15712: insert_into_table('cz_func_comp_specs'
15713: ,'func_comp_id'
15708: THEN
15709: log_timing_message('start insert_into_table cz_func_comp_specs');
15710: END IF;
15711:
15712: insert_into_table('cz_func_comp_specs'
15713: ,'func_comp_id'
15714: ,cz_pb_mgr.v_db_link
15715: ,plsql_table_list
15716: ,'cz_pb_mgr.v_cz_func_comp_old_ref'
15718: );
15719:
15720: IF (cz_pb_mgr.g_log_timing = publication_timing)
15721: THEN
15722: log_timing_message('end insert_into_table cz_func_comp_specs');
15723: END IF;
15724:
15725: -----insert new records into cz_rule_folders
15726: plsql_table_list.DELETE;
15735: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_func_devl_old_ref';
15736: rec_count := rec_count + 1;
15737: plsql_table_list(rec_count).col_name := 'parent_rule_folder_id';
15738: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_func_fld_old_ref';
15739: ----------insert into cz_func_comp_specs
15740: insert_into_table('cz_rule_folders'
15741: ,'rule_folder_id'
15742: ,'object_type'
15743: ,cz_pb_mgr.v_db_link