DBA Data[Home] [Help]

APPS.CCT_ICJUMPSTART_PUB dependencies on CCT_MIDDLEWARE_TYPES

Line 705: from cct_middleware_types

701: l_config_name Varchar2(255);
702: Begin
703: Select Middleware_type_id
704: into l_middleware_type_id
705: from cct_middleware_types
706: where middleware_type=p_middleware_type;
707:
708: Select Group_name||'_MW'
709: into l_config_name

Line 790: from cct_middlewares m,ieo_svr_servers s,ieo_svr_params p,ieo_svr_values v,cct_middleware_types t

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

Line 824: from cct_middlewares m,cct_middleware_types t

820: If p_middleware_id is not null Then
821: if (x_config_name is null) then
822: Select m.Config_name,t.middlewarE_type
823: into l_mw,l_mw_type
824: from cct_middlewares m,cct_middleware_types t
825: where m.middleware_id=p_middleware_id
826: and m.middleware_type_id=t.middleware_type_id;
827: x_config_name:=l_mw;
828: x_middleware_type:=l_mw_type;