Cursor Question

Let me prefix this post with the fact that I am really new at this and this is my first shot at creating a Stored Proc.  I have the shell and I have tried to code this but I am having some issues with the cursor.  Any tips or tricks that you can give me would be greatly appreciated.

Below is what I am trying to accomplish

Looking for the best approach to work with a complex cursor.

I have 4 files that are going to dump into a temp table. This is a sample of the Temp Table  

CHAN_ADDR,BRA,SRC_ID,R_Flag,C_Flag,S_Flag,N_Flag,Expire_Date,Wireless_Flag
1111111111,R,1-a,,,,NDNC,7/7/2006,
2222222222,R,2-b,,,SDNC,NDNC,7/7/2006,WIR
3333333333,R,3-c,,,SDNC,NDNC,7/8/2006,
4444444444,R,4-d,y,,SDNC,NDNC,7/9/2006,WIR
5555555555,R,5-e,y,,SDNC,,7/10/2006,
6666666666,R,6-f,y,,,,,WIR
7777777777,R,7-g,,,,,,
8888888888,R,8-h,y,,,NDNC,7/7/2006,WIR

I need to take this data and dump it into another table that looks like the following:

ADDR      Per_ID      Method      Name      Expire Date      Flag
1111111111      1-a      Phone      Nat      7/7/2006      Y
2222222222      2-b      Mobile      State      7/7/2006      Y
2222222222      2-b      Mobile      Nat      7/7/2006      Y
4444444444      3-c      Mobile      R      7/9/2006      y
4444444444      3-c      Mobile      State      7/9/2006      y
4444444444      3-c      Mobile      Nat      7/9/2006      y

 know that I need to use a cursor using loop and fetch but I am kind of confused on how to make this work.  I am fairly new to writing PL/SQL so any tips and tricks would be greatly appreciated.

For each phone number there can be 1 to 3 records written based on the flags.  For each of those records I must store the phone number, the id, flag data, expire date (for only State or National) and Flag must always be checked.

I have put together a small shell of the program but what goes in the middle is where I am having some problems.
CREATE OR REPLACE PROCEDURE USP_EIM_CONTACT3_UPD
IS

CURSOR dnc_cursor IS
SELECT CHAN_ADDR,
         BRA,
         SRC_ID,
         R_FLAG,
         C_FLAG,
         S_FLAG,
         N_FLAG,
         EBR_EXPIRE_DATE,
         WIRELESS_FLAG
FROM eim_admin.RCCL_OPT_OUT_TMP;

           v_counter                         NUMBER := 0;
           v_insert                          NUMBER := 0;
         v_sysdate                         DATE:=SYSDATE;
         v_chan_addr                        eim_admin.RCCL_OPT_OUT_TMP.chan_addr%TYPE;

BEGIN
        DBMS_OUTPUT.PUT_LINE ('***Begining USP_EIM_CONTACT3_UPD, time is ' ||
                          TO_CHAR (v_sysdate, 'MON-DD-YYYY HH24:MI.SS'));
        DBMS_OUTPUT.NEW_LINE;
FOR rec IN dnc_cursor LOOP
      
      v_counter:=v_counter+1;

      BEGIN
      SELECT CHAN_ADDR
        INTO v_chan_addr
        FROM eim_admin.RCCL_OPT_OUT_TMP;
      EXCEPTION
    WHEN OTHERS THEN
             DBMS_OUTPUT.PUT_LINE('*** Could not lookup RCCL_OPT_OUT_TMP. ***');
             DBMS_OUTPUT.PUT_LINE('ORA-'||SQLCODE||' '||SQLERRM);
      END;
BEGIN
             INSERT INTO siebel.S_PER_COMM_ADDR
              (ADDR)
          VALUES
            (rec.CHAN_ADDR);            
              v_insert := v_insert + SQL%ROWCOUNT;
          EXCEPTION WHEN OTHERS THEN
             DBMS_OUTPUT.PUT_LINE('*** Failed to insert into siebel.S_PER_COMM_AADDR DDR ***');
             DBMS_OUTPUT.PUT_LINE('ORA-'||SQLCODE||' '||SQLERRM);
      END;
END LOOP;

--Output STATISTICS.
  DBMS_OUTPUT.PUT_LINE('**Number records read :'||v_counter);
  DBMS_OUTPUT.NEW_LINE;
  DBMS_OUTPUT.PUT_LINE ('***Completing USP_EIM_CONTACT3_UPD, time is ' ||
                          TO_CHAR (SYSDATE, 'MON-DD-YYYY HH24:MI.SS'));

EXCEPTION
      WHEN OTHERS THEN
           DBMS_OUTPUT.PUT_LINE(' ****Error in USP_EIM_CONTACT3_UPD ****'||SQLCODE||SQLERRM);                                    
END USP_EIM_CONTACT3_UPD;

I have already created the table.  What we are going to do is using sqlloader to load our text files into our temp table.  From there we are going to read the data from the temp table into a table that is already created.

Basically what I am trying to do is the following:

Cursor 1
select * from Temp where, State_Flag and National_Flag is not null
Insert into Siebel.S_PER_COMM_ADDR
set id = source var
set phone = chann_add var

If
wireless flag is not null
set method = 'Mobile"
else
set method = 'Home'
end if

If
Brand = 'r' and R_Flag is not null
set name flg1
set flag as 'T'
 
and so on.

I am getting confused as to where to call the variables:
set id = source var
set phone = chann_add var

I am also confused on how to do the sets and how to set the date for S_Flag and N_Flag.

One of the other issues is that I need to go and look at the base table to pick up anyone else that has the phone number and update or delete based on the data in the table.