APPS.CCT_ICJUMPSTART_PUB dependencies on CCT_MIDDLEWARES

Line 160: from cct_middlewares

156: If (p_middleware_Config_id is not null) then
157: Begin
158: Select 1
159: into p_sql_result
160: from cct_middlewares
161: where server_group_id=p_ic_server_Group_id
162: and middleware_id=p_middleware_config_id
163: and nvl(f_deletedflag,'N') <> 'D';
164: Exception

Line 340: from cct_middlewares

336: If (p_middleware_config_id is not null) then
337: -- rem dbms_output.put_line('Adding Agent Parameter Values for '||p_last_name||', '||p_first_name);
338: Select middleware_type_id
339: into l_middleware_type_id
340: from cct_middlewares
341: where middlewaRE_id=p_middleware_config_id;
342:
343: If (p_acd_queue is not null) then
344: l_agent_param_name:='ACD_QUEUE';

Line 713: Select CCT_MIDDLEWARES_S.nextval

709: into l_config_name
710: from ieo_svr_Groups
711: where server_group_id=p_server_Group_id;
712:
713: Select CCT_MIDDLEWARES_S.nextval
714: into x_middleware_id
715: from dual;
716:
717: Insert into CCT_Middlewares

Line 717: Insert into CCT_Middlewares

713: Select CCT_MIDDLEWARES_S.nextval
714: into x_middleware_id
715: from dual;
716:
717: Insert into CCT_Middlewares
718: (Middleware_id,Config_Name,Server_Group_id,middleware_type_id
719: ,creation_Date,created_by,last_update_date,last_updated_by)
720: Select x_middleware_id,l_config_name,p_server_group_id,l_middleware_type_id
721: ,sysdate,1,sysdate,1 from dual

Line 722: where not exists (Select 1 from cct_middlewares

718: (Middleware_id,Config_Name,Server_Group_id,middleware_type_id
719: ,creation_Date,created_by,last_update_date,last_updated_by)
720: Select x_middleware_id,l_config_name,p_server_group_id,l_middleware_type_id
721: ,sysdate,1,sysdate,1 from dual
722: where not exists (Select 1 from cct_middlewares
723: where server_group_id=p_server_Group_id and config_name=l_config_name);
724: Exception
725: When No_Data_Found then
726: x_Return_Status:=FND_API.G_RET_STS_ERROR;

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;

Line 885: from cct_middlewares

881: where upper(teleset_type)=upper(p_teleset_type);
882:
883: Select server_group_id
884: into l_server_group_id
885: from cct_middlewares
886: where middleware_id=p_middleware_id;
887:
888:
889: l_teleset_hardware_number:=p_start_teleset_number;

Line 982: from cct_middlewares

978: l_return_status VARCHAR2(32);
979: Begin
980: Select middleware_type_id
981: into l_middleware_Type_id
982: from cct_middlewares
983: where middlewarE_id=p_middleware_id;
984: -- rem dbms_output.put_line('Creating Middleware Params for Middleware_id='||to_char(p_middleware_id));
985:
986: l_keys:=CCT_COLLECTION_UTIL_PUB.GETKEYS(p_param_value);