[Home] [Help]
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
913: Select cct_lines_s.nextval
914: into l_line_id
915: from dual;
916: Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
917: creation_date,created_by,last_update_date,last_updated_by)
923:
924: ELSIf (upper(p_teleset_type)='NORTEL') THEN
925: Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
926: creation_date,created_by,last_update_date,last_updated_by)
927: Select CCT_LINES_S.nextval,1,l_line1,l_teleset_id,
928: sysdate,1,sysdate,1 from dual
929: where not exists (Select 1 from cct_lines where teleset_id=l_teleset_id
930: and line_index=1);
931: Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
929: where not exists (Select 1 from cct_lines where teleset_id=l_teleset_id
930: and line_index=1);
931: Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
932: creation_date,created_by,last_update_date,last_updated_by)
933: Select CCT_LINES_S.nextval,2,l_line2,l_teleset_id,
934: sysdate,1,sysdate,1 from dual
935: where not exists (Select 1 from cct_lines where teleset_id=l_teleset_id
936: and line_index=2);
937: Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
935: where not exists (Select 1 from cct_lines where teleset_id=l_teleset_id
936: and line_index=2);
937: Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
938: creation_date,created_by,last_update_date,last_updated_by)
939: Select CCT_LINES_S.nextval,3,l_line3,l_teleset_id,
940: sysdate,1,sysdate,1 from dual
941: where not exists (Select 1 from cct_lines where teleset_id=l_teleset_id
942: and line_index=3);
943: l_line1:=l_line1+p_skip_by;