[Home] [Help]
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:
6521: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.mm_v_ht_sync_archives',cz_pb_mgr.mm_v_ht_sync_archives);
6522:
6523: delete_from_table('cz_archive_refs','archive_id','devl_project_id',v_database_link,'cz_pb_mgr.g_archive_id_ref','cz_pb_mgr.g_devl_proj_ref',cz_pb_mgr.g_archive_id_ref);
6524: delete_from_table('cz_localized_texts','intl_text_id',v_database_link,'cz_pb_mgr.v_cz_intl_text_new_ref',cz_pb_mgr.v_cz_intl_text_new_ref);
6525:
6526: delete_from_idx_tables('cz_rule_folders', 'rule_folder_id', cz_pb_mgr.v_cz_folders_id_old_ref, cz_pb_mgr.v_cz_folders_id_idx_ref);
6527: delete_from_idx_tables('cz_expression_nodes', 'expr_node_id', cz_pb_mgr.v_cz_enodes_enode_id_old_ref, cz_pb_mgr.v_cz_enodes_enode_id_idx_ref);
7659: LOOP
7660: BEGIN
7661: SELECT GREATEST(MAX(arch.last_update_date), MAX(refs.last_update_date))
7662: INTO v_last_archive_update
7663: FROM cz_archives arch, cz_archive_refs refs
7664: WHERE refs.devl_project_id = p_model_array(i) AND arch.archive_id = refs.archive_id AND arch.deleted_flag = '0'
7665: AND refs.deleted_flag = 0;
7666: EXCEPTION
7667: WHEN NO_DATA_FOUND
9272:
9273: -----------end expr nodes check
9274: SELECT GREATEST(MAX(arc.last_update_date), MAX(REF.last_update_date))
9275: INTO l_max_arc_date
9276: FROM cz_archives arc, cz_archive_refs REF
9277: WHERE REF.devl_project_id = v_model_id AND arc.archive_id = REF.archive_id AND arc.deleted_flag = '0' AND REF.deleted_flag = '0';
9278:
9279: IF l_max_arc_date IS NOT NULL AND l_max_arc_date > v_expr_last_update
9280: THEN
15112:
15113: BEGIN
15114: SELECT archive_id, devl_project_id
15115: BULK COLLECT INTO l_archive_refs_tbl, l_devl_proj_tbl
15116: FROM cz_archive_refs
15117: WHERE cz_archive_refs.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_archive_refs.deleted_flag = record_not_deleted;
15118: EXCEPTION
15119: WHEN NO_DATA_FOUND
15120: THEN
15113: BEGIN
15114: SELECT archive_id, devl_project_id
15115: BULK COLLECT INTO l_archive_refs_tbl, l_devl_proj_tbl
15116: FROM cz_archive_refs
15117: WHERE cz_archive_refs.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_archive_refs.deleted_flag = record_not_deleted;
15118: EXCEPTION
15119: WHEN NO_DATA_FOUND
15120: THEN
15121: NULL;
15138: END IF;
15139: EXCEPTION
15140: WHEN OTHERS
15141: THEN
15142: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_archive_refs', 'SQLERRM', SQLERRM);
15143: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.ARCHIVES', SQLCODE);
15144: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15145: RAISE;
15146: END bulk_collect_archives;
23191: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_archive_id_ref';
23192: rec_count := rec_count + 1;
23193: plsql_table_list(rec_count).col_name := 'devl_project_id';
23194: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_devl_proj_ref';
23195: insert_into_table('cz_archive_refs'
23196: ,'archive_id'
23197: ,'devl_project_id'
23198: ,cz_pb_mgr.v_db_link
23199: ,plsql_table_list
23264: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_archive_id_ref';
23265: rec_count := rec_count + 1;
23266: plsql_table_list(rec_count).col_name := 'devl_project_id';
23267: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_devl_proj_ref';
23268: insert_into_table('cz_archive_refs'
23269: ,'archive_id'
23270: ,'devl_project_id'
23271: ,cz_pb_mgr.v_db_link
23272: ,plsql_table_list