while n_Colomn_Num<=v_SUMQTY loop
strSql4 :='select NOTE_'|| to_char(n_Colomn_Num) ||' from JCD_PLAN_TEMP_ONE WHERE PROCESSNAME = ''' || v_ITEMNAME || ''' And PANELPCS = ''' || v_PANELPCS || ''' AND KEYNAME = ''1''';
EXECUTE IMMEDIATE strSql4 INTO v_TEMPSTEPNAME1;
n_Colomn_Num2 := 1;
while n_Colomn_Num2<=80 loop
strSql :='select NOTE_'|| to_char(n_Colomn_Num2) ||' from JCD_PLAN_TEMP_TWO WHERE KEYNAME = ''1''';
EXECUTE IMMEDIATE strSql INTO v_TEMPSTEPNAME2;
if v_TEMPSTEPNAME1=v_TEMPSTEPNAME2 then
strSql2 :='select NOTE_'|| to_char(n_Colomn_Num) ||' from JCD_PLAN_TEMP_ONE WHERE PROCESSNAME = ''' || v_ITEMNAME || ''' And PANELPCS = ''' || v_PANELPCS || ''' And KEYNAME = ''4''';
EXECUTE IMMEDIATE strSql2 INTO v_TEMPQTY;
strSql3 := 'UPDATE JCD_PLAN_TEMP_TWO SET NOTE_' || to_char(n_Colomn_Num2) || ' = ''' || v_TEMPQTY ;
strSql3 := strSql3 || ''' WHERE PROCESSNAME = ''' || v_ITEMNAME || ''' And PANELPCS = ''' || v_PANELPCS || ''' And KEYNAME = ''2''';
EXECUTE IMMEDIATE strSql3;
exit;
ELSE
n_Colomn_Num2 := n_Colomn_Num2 + 1;
end if;
end loop;
n_Colomn_Num := n_Colomn_Num + 1;
end loop;