APPS.CCT_ICJUMPSTART_PUB dependencies on IEO_SVR_GROUPS

Line 141: from IEO_SVR_GROUPS

137: -- Check if the IC Server Group is valid
138: Begin
139: Select 1
140: into p_sql_Result
141: from IEO_SVR_GROUPS
142: where Server_Group_ID=p_IC_SERVER_GROUP_ID;
143: Exception
144: When others then
145: x_Return_Status:=FND_API.G_RET_STS_ERROR;

Line 521: from ieo_svr_groups

517: -- Check if the Server Group already exists
518: Begin
519: Select 1
520: into x_sql_Result
521: from ieo_svr_groups
522: where group_name=p_server_Group_name;
523: If (x_sql_result=1) then
524: x_return_status:=FND_API.G_RET_STS_ERROR;
525: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_SERVER_GROUP_EXISTS');

Line 535: Select IEO_SVR_GROUPS_S1.nextval

531: raise FND_API.G_EXC_UNEXPECTED_ERROR;
532: End if;
533: Exception
534: When No_data_found then
535: Select IEO_SVR_GROUPS_S1.nextval
536: into l_server_Group_id
537: from dual;
538: Insert into IEO_SVR_GROUPS
539: (Server_group_id,Group_name,Location,Description

Line 538: Insert into IEO_SVR_GROUPS

534: When No_data_found then
535: Select IEO_SVR_GROUPS_S1.nextval
536: into l_server_Group_id
537: from dual;
538: Insert into IEO_SVR_GROUPS
539: (Server_group_id,Group_name,Location,Description
540: ,created_by,Creation_Date,last_updateD_by,last_update_date)
541: values(l_server_Group_id,p_server_group_name,p_server_group_name,p_server_group_name
542: ,1,sysdate,1,sysdate);

Line 595: from ieo_svr_groups

591: where type_id in (10000,10001,10080,10110,10090,10120,10160);
592: Begin
593: Select Group_name
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,

Line 710: from ieo_svr_Groups

706: where middleware_type=p_middleware_type;
707:
708: Select Group_name||'_MW'
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

Line 771: from ieo_Svr_groups

767: If p_server_group_name is not null THEN
768: Begin
769: Select server_group_id
770: into l_server_group_id
771: from ieo_Svr_groups
772: where group_name =p_server_Group_name;
773: Exception
774: When No_Data_Found then
775: x_Return_Status:=FND_API.G_RET_STS_ERROR;