APPS.CCT_ICJUMPSTART_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 86

			Select 1
			into p_sql_Result
			from fnd_user
			where user_name=p_app_username;

Line: 139

		Select 1
		into p_sql_Result
		from IEO_SVR_GROUPS
		where Server_Group_ID=p_IC_SERVER_GROUP_ID;

Line: 158

		 	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';

Line: 178

	Select trunc(sysdate)
	into l_date
	from dual;

Line: 183

	Select sales_credit_Type_id
	into l_sales_credit_type_id
	from oe_sales_credit_types
	where rownum<2;

Line: 224

        Update JTF_RS_RESOURCE_EXTNS
        set server_group_id=p_ic_server_Group_id
 		where resource_id=p_resource_id;

Line: 304

	Select role_id
	into l_role_id
	from jtf_rs_roles_Vl
	where role_code=p_ic_role
	and role_type_code='CALLCENTER';

Line: 338

		Select middleware_type_id
		into l_middleware_type_id
		from cct_middlewares
		where middlewaRE_id=p_middleware_config_id;

Line: 348

				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;

Line: 396

				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;

Line: 444

				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;

Line: 519

		Select 1
		into x_sql_Result
		from ieo_svr_groups
		where group_name=p_server_Group_name;

Line: 535

			Select IEO_SVR_GROUPS_S1.nextval
			into l_server_Group_id
			from dual;

Line: 538

			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);

Line: 583

   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);

Line: 593

   Select Group_name
   into l_server_group_name
   from ieo_svr_groups
   where server_group_id=p_server_Group_id;

Line: 598

      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);

Line: 641

	Select type_id
	into l_type_id
	from ieo_svr_servers
	where server_id=p_server_id;

Line: 651

	       Select param_id
	       into l_param_id
	       from ieo_svr_params
	       where type_id=l_type_id
	       and param_name=l_param;

Line: 660

	       Select ieo_svr_values_s1.nextval
	       into l_value_id
	       from dual;

Line: 664

	       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);

Line: 703

	Select Middleware_type_id
	into l_middleware_type_id
	from cct_middleware_types
	where middleware_type=p_middleware_type;

Line: 708

	Select Group_name||'_MW'
	into l_config_name
	from ieo_svr_Groups
	where server_group_id=p_server_Group_id;

Line: 713

	Select CCT_MIDDLEWARES_S.nextval
	into x_middleware_id
	from dual;

Line: 717

	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);

Line: 760

 	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;

Line: 769

		 	Select server_group_id
		 	into l_server_group_id
		 	from ieo_Svr_groups
		 	where group_name =p_server_Group_name;

Line: 788

			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;

Line: 822

  			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;

Line: 878

	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);

Line: 883

	Select server_group_id
	into l_server_group_id
	from cct_middlewares
	where middleware_id=p_middleware_id;

Line: 900

		Select CCT_Telesets_s.nextval
		into l_teleset_id
		from dual;

Line: 904

		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);

Line: 913

	       	 Select cct_lines_s.nextval
	       	 into l_line_id
	       	 from dual;

Line: 916

	       	 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);

Line: 925

	       	 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);

Line: 931

	       	 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);

Line: 937

	       	 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);

Line: 980

	Select middleware_type_id
	into l_middleware_Type_id
	from cct_middlewares
	where middlewarE_id=p_middleware_id;

Line: 991

	       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;

Line: 999

	       Select cct_middleware_values_s.nextval
	       into l_value_id
	       from dual;

Line: 1003

	       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');

Line: 1041

  Select CCT_MW_ROUTE_POINTS_S.nextval
  into l_route_point_id
  from dual;

Line: 1045

  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');

Line: 1088

	       Select mw_route_point_param_id
	       into l_param_id
	       from cct_mw_route_point_params
	       where name=l_param;

Line: 1096

	       Select cct_mw_route_point_values_s.nextval
	       into l_value_id
	       from dual;

Line: 1100

	       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');