[Home] [Help]
2073:
2074: v_model_conversion_set_id:=p_model_conversion_set_id;
2075: FOR v_models IN
2076: ( SELECT remote_model_id
2077: FROM cz_model_publications p , cz_pb_model_exports z
2078: WHERE p.export_status IN('OK')
2079: AND p.server_id = 0
2080: AND p.publication_mode = 'M'
2081: AND p.migration_group_id = p_model_conversion_set_id
2117: UPDATE cz_rules
2118: SET config_engine_type = 'F' , rule_class=nvl(rule_class,0)
2119: WHERE deleted_flag='0'
2120: AND devl_project_id IN( SELECT remote_model_id
2121: FROM cz_model_publications p , cz_pb_model_exports z
2122: WHERE p.export_status IN('OK')
2123: AND p.server_id = 0
2124: AND p.publication_mode = 'M'
2125: AND p.migration_group_id = p_model_conversion_set_id
2134: -- Clearing Initial values need to be done at last for all models
2135: -- as some models may have a downward contribute/consume and hence may require the initial values for accumulator rule creation
2136: FOR v_models IN
2137: ( SELECT remote_model_id
2138: FROM cz_model_publications p , cz_pb_model_exports z
2139: WHERE p.export_status IN('OK')
2140: AND p.server_id = 0
2141: AND p.publication_mode = 'M'
2142: AND p.migration_group_id = p_model_conversion_set_id
2186: /*
2187: * Copy Model For Conversionprocedure.
2188: * @param errbuf Standard Oracle Concurrent Program output parameters.
2189: * @param retcode Standard Oracle Concurrent Program output parameters.
2190: * @param p_request_id This is the CZ_MODEL_PUBLICATIONS, MIGRATION_GROUP_ID of the migration request.
2191: * Migration request is created by Developer and contains the list of all models selected
2192: * for Migration from the source's Configurator Repository, target Instance name and
2193: * target Repository Folder.
2194: */
2207:
2208: retcode:=0;
2209: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 0;
2210:
2211: FOR c_pub IN (SELECT publication_id ,max(node_depth) mdepth FROM cz_model_publications mp ,cz_model_ref_expls mr
2212: WHERE mp.migration_group_id = p_request_id AND mp.deleted_flag = '0' and mr.deleted_flag = '0'
2213: AND mp.publication_mode='M'
2214: and mr.model_id =mp.object_id
2215: group by publication_id
2266: L_RETURN_STATUS VARCHAR2(100) ;
2267: L_MSG_COUNT NUMBER ;
2268: L_MSG_DATA VARCHAR2(2000) ;
2269: ERR_PROFILE EXCEPTION;
2270: l_migration_group_id cz_model_publications.migration_group_id%TYPE;
2271: L_ERROR_IN_CP BOOLEAN;
2272:
2273: Begin
2274:
2302: SELECT COUNT(*)
2303: INTO noofreports
2304: FROM
2305: (SELECT DISTINCT migration_group_id
2306: FROM cz_model_publications
2307: WHERE deleted_flag ='0'
2308: AND publication_mode = 'M'
2309: AND(migration_group_id = p_request_id OR(p_request_id IS NULL AND migration_group_id IS NOT NULL))
2310: AND export_status = 'PEN'
2319: END IF;
2320:
2321: For c_model_conv IN (
2322: SELECT DISTINCT migration_group_id
2323: FROM cz_model_publications mp
2324: WHERE deleted_flag ='0' and
2325: publication_mode='M'
2326: AND server_id = 0
2327: AND export_status = 'PEN'
2360: END IF;
2361: --this procedures creates copy of the existing model
2362: copy_model_for_conversion(errbuf, Retcode, c_model_conv.migration_group_id);
2363: commit;
2364: UPDATE cz_model_publications set export_status='OK' where export_status='PEN' and migration_group_id=c_model_conv.migration_group_id;
2365: --this procedure converts the copied LCE models to FCE standard
2366: convertModels(c_model_conv.migration_group_id);
2367: commit;
2368: --
2412:
2413: FOR c_process IN (
2414:
2415: SELECT remote_model_id
2416: FROM cz_model_publications p , cz_pb_model_exports z
2417: WHERE p.export_status IN('OK')
2418: AND p.server_id = 0
2419: AND p.publication_mode = 'M'
2420: AND p.migration_group_id = P_request_id
2434:
2435: END LOOP;
2436:
2437: --an error has occured update status to reflect this
2438: UPDATE cz_model_publications SET export_status='ERR' WHERE migration_group_id = l_migration_group_id and server_id=0 ;
2439: commit;
2440: END;
2441: BEGIN
2442: call_status := FND_CONCURRENT.GET_REQUEST_STATUS(r, '', '', rphase,rstatus,dphase,dstatus, message);