The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select 1
into p_sql_Result
from fnd_user
where user_name=p_app_username;
Select 1
into p_sql_Result
from IEO_SVR_GROUPS
where Server_Group_ID=p_IC_SERVER_GROUP_ID;
Select 1
into p_sql_result
from cct_middlewares
where server_group_id=p_ic_server_Group_id
and middleware_id=p_middleware_config_id
and nvl(f_deletedflag,'N') <> 'D';
Select trunc(sysdate)
into l_date
from dual;
Select sales_credit_Type_id
into l_sales_credit_type_id
from oe_sales_credit_types
where rownum<2;
Update JTF_RS_RESOURCE_EXTNS
set server_group_id=p_ic_server_Group_id
where resource_id=p_resource_id;
Select role_id
into l_role_id
from jtf_rs_roles_Vl
where role_code=p_ic_role
and role_type_code='CALLCENTER';
Select middleware_type_id
into l_middleware_type_id
from cct_middlewares
where middlewaRE_id=p_middleware_config_id;
Select resource_param_id
into l_agent_param_id
from jtf_rs_resource_params
where name =l_agent_param_name
and param_type=l_middleware_type_id;
Select resource_param_id
into l_agent_param_id
from jtf_rs_resource_params
where name =l_agent_param_name
and param_type=l_middleware_type_id;
Select resource_param_id
into l_agent_param_id
from jtf_rs_resource_params
where name =l_agent_param_name
and param_type=l_middleware_type_id;
Select 1
into x_sql_Result
from ieo_svr_groups
where group_name=p_server_Group_name;
Select IEO_SVR_GROUPS_S1.nextval
into l_server_Group_id
from dual;
Insert into IEO_SVR_GROUPS
(Server_group_id,Group_name,Location,Description
,created_by,Creation_Date,last_updateD_by,last_update_date)
values(l_server_Group_id,p_server_group_name,p_server_group_name,p_server_group_name
,1,sysdate,1,sysdate);
Select IEO_SVR_SERVERS_S1.nextval server_id,Type_id,decode(type_id,10000,'_UWQ'
,10001,'_OTM'
,10080,'_ORS'
,10110,'_IQD'
,10090,'_ITS'
,10120,'_SS'
,10160,'_OTAS') type_name,Type_Description
from ieo_svr_types_tl
where type_id in (10000,10001,10080,10110,10090,10120,10160);
Select Group_name
into l_server_group_name
from ieo_svr_groups
where server_group_id=p_server_Group_id;
Insert into ieo_svr_servers
(Server_id,type_id,server_name,member_Svr_group_id,description,
creation_date,created_By,last_update_date,last_updated_by)
Select v_server.server_id,v_server.type_id,l_server_group_name||v_server.type_name
,p_server_group_id,v_server.type_description,
sysdate,1,sysdate,1 from dual
where not exists (Select 1 from ieo_Svr_servers where
member_svr_group_id=p_server_group_id
and type_id=v_server.type_id);
Select type_id
into l_type_id
from ieo_svr_servers
where server_id=p_server_id;
Select param_id
into l_param_id
from ieo_svr_params
where type_id=l_type_id
and param_name=l_param;
Select ieo_svr_values_s1.nextval
into l_value_id
from dual;
Insert into ieo_svr_values(value_id,server_id,param_id,value,value_index
,creation_date,created_by,last_update_date,last_updated_by)
Select l_value_id,p_server_id,l_param_id,l_value,0
,sysdate,1,sysdate,1 from dual
where not exists (Select 1 from ieo_svr_values
where server_id=p_server_id and param_id=l_param_id);
Select Middleware_type_id
into l_middleware_type_id
from cct_middleware_types
where middleware_type=p_middleware_type;
Select Group_name||'_MW'
into l_config_name
from ieo_svr_Groups
where server_group_id=p_server_Group_id;
Select CCT_MIDDLEWARES_S.nextval
into x_middleware_id
from dual;
Insert into CCT_Middlewares
(Middleware_id,Config_Name,Server_Group_id,middleware_type_id
,creation_Date,created_by,last_update_date,last_updated_by)
Select x_middleware_id,l_config_name,p_server_group_id,l_middleware_type_id
,sysdate,1,sysdate,1 from dual
where not exists (Select 1 from cct_middlewares
where server_group_id=p_server_Group_id and config_name=l_config_name);
Select p.name,v.value
from cct_middleware_params p,cct_middleware_values v
where v.middleware_id=p_middleware_id
and nvl(v.f_deletedflag,'N')<>'D'
and v.middleware_param_id=p.middleware_param_id;
Select server_group_id
into l_server_group_id
from ieo_Svr_groups
where group_name =p_server_Group_name;
Select m.middleware_id,m.config_name,t.middleware_type
into l_mw_id,l_mw,l_mw_type
from cct_middlewares m,ieo_svr_servers s,ieo_svr_params p,ieo_svr_values v,cct_middleware_types t
where s.type_id=10160
and s.member_svr_group_id=l_server_group_id
and v.server_id=s.server_id
and v.param_id=p.param_id
and p.param_name='TELE_MIDDLEWARE_CONFIG'
and v.value=m.config_name
and m.server_Group_id=s.member_svr_group_id
and m.middleware_type_id=t.middleware_type_id;
Select m.Config_name,t.middlewarE_type
into l_mw,l_mw_type
from cct_middlewares m,cct_middleware_types t
where m.middleware_id=p_middleware_id
and m.middleware_type_id=t.middleware_type_id;
Select teleset_type_id,number_of_line
into l_teleset_type_id,l_num_of_lines
from cct_teleset_Types
where upper(teleset_type)=upper(p_teleset_type);
Select server_group_id
into l_server_group_id
from cct_middlewares
where middleware_id=p_middleware_id;
Select CCT_Telesets_s.nextval
into l_teleset_id
from dual;
Insert into CCT_TELESETS(TELESET_ID,Teleset_type_id,Teleset_Name,Teleset_hardwarE_number,Middleware_id,server_group_id
,creation_date,created_by,last_update_date,last_updated_by)
Select l_teleset_id,l_teleset_type_id,l_teleset_hardware_number,l_teleset_hardware_number,p_middleware_id,l_server_group_id
,sysdate,1,sysdate,1
from dual where not exists (Select 1 from cct_telesets where teleset_type_id=l_teleset_type_id
and teleset_hardware_number=l_teleset_hardware_number and middlewarE_id=p_middleware_id);
Select cct_lines_s.nextval
into l_line_id
from dual;
Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
creation_date,created_by,last_update_date,last_updated_by)
Select l_line_id,l_counter,l_teleset_hardware_number,l_teleset_id,
sysdate,1,sysdate,1 from dual
where not exists (Select 1 from cct_lines where teleset_id=l_teleset_id
and line_index=l_counter);
Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
creation_date,created_by,last_update_date,last_updated_by)
Select CCT_LINES_S.nextval,1,l_line1,l_teleset_id,
sysdate,1,sysdate,1 from dual
where not exists (Select 1 from cct_lines where teleset_id=l_teleset_id
and line_index=1);
Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
creation_date,created_by,last_update_date,last_updated_by)
Select CCT_LINES_S.nextval,2,l_line2,l_teleset_id,
sysdate,1,sysdate,1 from dual
where not exists (Select 1 from cct_lines where teleset_id=l_teleset_id
and line_index=2);
Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
creation_date,created_by,last_update_date,last_updated_by)
Select CCT_LINES_S.nextval,3,l_line3,l_teleset_id,
sysdate,1,sysdate,1 from dual
where not exists (Select 1 from cct_lines where teleset_id=l_teleset_id
and line_index=3);
Select middleware_type_id
into l_middleware_Type_id
from cct_middlewares
where middlewarE_id=p_middleware_id;
Select middleware_param_id
into l_middleware_param_id
from cct_middleware_params
where middleware_type_id=l_middleware_type_id
and name=l_param;
Select cct_middleware_values_s.nextval
into l_value_id
from dual;
Insert into ccT_middleware_values(middleware_value_id,middleware_id,middleware_param_id,value
,creation_date,created_by,last_update_date,last_updated_by)
Select l_value_id,p_middleware_id,l_middleware_param_id,l_value
,sysdate,1,sysdate,1 from dual
where not exists (Select 1 from cct_middleware_values
where middleware_id=p_middleware_id and middleware_param_id=l_middleware_param_id
and nvl(f_deletedflag,'N')<>'D');
Select CCT_MW_ROUTE_POINTS_S.nextval
into l_route_point_id
from dual;
Insert into cct_mw_route_points(mw_route_point_id,middleware_id,route_point_number,description,
object_version_number,creation_date,created_by,last_update_date,last_updated_By)
Select l_route_point_id,p_middleware_id,p_route_point_number,p_route_point_number,
1,sysdate,1,sysdate,1 from dual
where not exists (Select 1 from cct_mw_route_points
where middleware_id=p_middleware_id and route_point_number=p_route_point_number
and nvl(f_deletedflag,'N')<>'D');
Select mw_route_point_param_id
into l_param_id
from cct_mw_route_point_params
where name=l_param;
Select cct_mw_route_point_values_s.nextval
into l_value_id
from dual;
Insert into ccT_mw_route_point_values(mw_route_point_value_id,mw_route_point_id,mw_route_point_param_id,value
,object_version_number,creation_date,created_by,last_update_date,last_updated_by)
Select l_value_id,p_route_point_id,l_param_id,l_value
,1,sysdate,1,sysdate,1 from dual
where not exists (Select 1 from cct_mw_route_point_values
where mw_route_point_id=p_route_point_id and mw_route_point_param_id=l_param_id
and nvl(f_deletedflag,'N')<>'D');