[Home] [Help]
896: if(p_line3 is not null) then
897: l_line3:=p_line3;
898: end if;
899: For l_counter in 1..p_number_of_Telesets Loop
900: Select CCT_Telesets_s.nextval
901: into l_teleset_id
902: from dual;
903: -- rem dbms_output.put_line('Creating Teleset='||to_char(l_teleset_hardware_number));
904: Insert into CCT_TELESETS(TELESET_ID,Teleset_type_id,Teleset_Name,Teleset_hardwarE_number,Middleware_id,server_group_id
900: Select CCT_Telesets_s.nextval
901: into l_teleset_id
902: from dual;
903: -- rem dbms_output.put_line('Creating Teleset='||to_char(l_teleset_hardware_number));
904: Insert into CCT_TELESETS(TELESET_ID,Teleset_type_id,Teleset_Name,Teleset_hardwarE_number,Middleware_id,server_group_id
905: ,creation_date,created_by,last_update_date,last_updated_by)
906: Select l_teleset_id,l_teleset_type_id,l_teleset_hardware_number,l_teleset_hardware_number,p_middleware_id,l_server_group_id
907: ,sysdate,1,sysdate,1
908: from dual where not exists (Select 1 from cct_telesets where teleset_type_id=l_teleset_type_id
904: Insert into CCT_TELESETS(TELESET_ID,Teleset_type_id,Teleset_Name,Teleset_hardwarE_number,Middleware_id,server_group_id
905: ,creation_date,created_by,last_update_date,last_updated_by)
906: Select l_teleset_id,l_teleset_type_id,l_teleset_hardware_number,l_teleset_hardware_number,p_middleware_id,l_server_group_id
907: ,sysdate,1,sysdate,1
908: from dual where not exists (Select 1 from cct_telesets where teleset_type_id=l_teleset_type_id
909: and teleset_hardware_number=l_teleset_hardware_number and middlewarE_id=p_middleware_id);
910:
911: If (upper(p_teleset_type)='LUCENT') THEN
912: For l_counter in 1..l_num_of_lines Loop