[Home] [Help]
2046:
2047: v_model_conversion_set_id:=p_model_conversion_set_id;
2048: FOR v_models IN
2049: ( SELECT remote_model_id
2050: FROM cz_model_publications p , cz_pb_model_exports z
2051: WHERE p.export_status IN('OK')
2052: AND p.server_id = 0
2053: AND p.publication_mode = 'M'
2054: AND p.migration_group_id = p_model_conversion_set_id
2085: UPDATE cz_rules
2086: SET config_engine_type = 'F' , rule_class=nvl(rule_class,0)
2087: WHERE deleted_flag='0'
2088: AND devl_project_id IN( SELECT remote_model_id
2089: FROM cz_model_publications p , cz_pb_model_exports z
2090: WHERE p.export_status IN('OK')
2091: AND p.server_id = 0
2092: AND p.publication_mode = 'M'
2093: AND p.migration_group_id = p_model_conversion_set_id
2102: -- Clearing Initial values need to be done at last for all models
2103: -- as some models may have a downward contribute/consume and hence may require the initial values for accumulator rule creation
2104: FOR v_models IN
2105: ( SELECT remote_model_id
2106: FROM cz_model_publications p , cz_pb_model_exports z
2107: WHERE p.export_status IN('OK')
2108: AND p.server_id = 0
2109: AND p.publication_mode = 'M'
2110: AND p.migration_group_id = p_model_conversion_set_id
2154: /*
2155: * Copy Model For Conversionprocedure.
2156: * @param errbuf Standard Oracle Concurrent Program output parameters.
2157: * @param retcode Standard Oracle Concurrent Program output parameters.
2158: * @param p_request_id This is the CZ_MODEL_PUBLICATIONS, MIGRATION_GROUP_ID of the migration request.
2159: * Migration request is created by Developer and contains the list of all models selected
2160: * for Migration from the source's Configurator Repository, target Instance name and
2161: * target Repository Folder.
2162: */
2175:
2176: retcode:=0;
2177: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 0;
2178:
2179: FOR c_pub IN (SELECT publication_id ,max(node_depth) mdepth FROM cz_model_publications mp ,cz_model_ref_expls mr
2180: WHERE mp.migration_group_id = p_request_id AND mp.deleted_flag = '0' and mr.deleted_flag = '0'
2181: AND mp.publication_mode='M'
2182: and mr.model_id =mp.object_id
2183: group by publication_id
2234: L_RETURN_STATUS VARCHAR2(100) ;
2235: L_MSG_COUNT NUMBER ;
2236: L_MSG_DATA VARCHAR2(2000) ;
2237: ERR_PROFILE EXCEPTION;
2238: l_migration_group_id cz_model_publications.migration_group_id%TYPE;
2239: L_ERROR_IN_CP BOOLEAN;
2240:
2241: Begin
2242:
2270: SELECT COUNT(*)
2271: INTO noofreports
2272: FROM
2273: (SELECT DISTINCT migration_group_id
2274: FROM cz_model_publications
2275: WHERE deleted_flag ='0'
2276: AND publication_mode = 'M'
2277: AND(migration_group_id = p_request_id OR(p_request_id IS NULL AND migration_group_id IS NOT NULL))
2278: AND export_status = 'PEN'
2287: END IF;
2288:
2289: For c_model_conv IN (
2290: SELECT DISTINCT migration_group_id
2291: FROM cz_model_publications mp
2292: WHERE deleted_flag ='0' and
2293: publication_mode='M'
2294: AND server_id = 0
2295: AND export_status = 'PEN'
2327: END IF;
2328: --this procedures creates copy of the existing model
2329: copy_model_for_conversion(errbuf, Retcode, c_model_conv.migration_group_id);
2330: commit;
2331: UPDATE cz_model_publications set export_status='OK' where export_status='PEN' and migration_group_id=c_model_conv.migration_group_id;
2332: --this procedure converts the copied LCE models to FCE standard
2333: convertModels(c_model_conv.migration_group_id);
2334: commit;
2335: --
2419:
2420: FOR c_process IN (
2421:
2422: SELECT remote_model_id
2423: FROM cz_model_publications p , cz_pb_model_exports z
2424: WHERE p.export_status IN('OK')
2425: AND p.server_id = 0
2426: AND p.publication_mode = 'M'
2427: AND p.migration_group_id = P_request_id
2441:
2442: END LOOP;
2443:
2444: --an error has occured update status to reflect this
2445: UPDATE cz_model_publications SET export_status='ERR' WHERE migration_group_id = l_migration_group_id and server_id=0 ;
2446:
2447:
2448: commit;
2449: End Model_Convert_CP;