[Home] [Help]
579: l_SERVERTYPEID_SERVERID CCT_KEYVALUE_VARR:= CCT_KEYVALUE_VARR();
580: l_result VARCHAR2(255);
581: Cursor c_server_type
582: is
583: Select IEO_SVR_SERVERS_S1.nextval server_id,Type_id,decode(type_id,10000,'_UWQ'
584: ,10001,'_OTM'
585: ,10080,'_ORS'
586: ,10110,'_IQD'
587: ,10090,'_ITS'
594: into l_server_group_name
595: from ieo_svr_groups
596: where server_group_id=p_server_Group_id;
597: For v_server in c_server_type Loop
598: Insert into ieo_svr_servers
599: (Server_id,type_id,server_name,member_Svr_group_id,description,
600: creation_date,created_By,last_update_date,last_updated_by)
601: Select v_server.server_id,v_server.type_id,l_server_group_name||v_server.type_name
602: ,p_server_group_id,v_server.type_description,
600: creation_date,created_By,last_update_date,last_updated_by)
601: Select v_server.server_id,v_server.type_id,l_server_group_name||v_server.type_name
602: ,p_server_group_id,v_server.type_description,
603: sysdate,1,sysdate,1 from dual
604: where not exists (Select 1 from ieo_Svr_servers where
605: member_svr_group_id=p_server_group_id
606: and type_id=v_server.type_id);
607: l_result:=CCT_COLLECTION_UTIL_PUB.PUT(l_SERVERTYPEID_SERVERID,v_server.type_id,v_server.server_id);
608: END LOOP;
639: l_return_status VARCHAR2(32);
640: Begin
641: Select type_id
642: into l_type_id
643: from ieo_svr_servers
644: where server_id=p_server_id;
645:
646: l_keys:=CCT_COLLECTION_UTIL_PUB.GETKEYS(p_param_value);
647:
786: If l_server_group_id is not null Then
787: Begin
788: Select m.middleware_id,m.config_name,t.middleware_type
789: into l_mw_id,l_mw,l_mw_type
790: from cct_middlewares m,ieo_svr_servers s,ieo_svr_params p,ieo_svr_values v,cct_middleware_types t
791: where s.type_id=10160
792: and s.member_svr_group_id=l_server_group_id
793: and v.server_id=s.server_id
794: and v.param_id=p.param_id