FETCH client_cur BULK COLLECT INTO v_cur LIMIT c_limit_n;
    
    EXIT WHEN v_cur.COUNT = 0;

    FOR i in v_cur.FIRST..v_cur.LAST  --Наполняем временную таблицу
      LOOP
      INSERT INTO SIEBEL.GTT_PERS_PARAM
      (
        PAR_ROW_ID, NEXT_UP_DISC_DC, REM_AMOUNT_DISC, WAVE_NUM, CLIENT_ID,  MAILING_ID, BOOT_NUM
      )
      VALUES
        (GET_ROW_PARAM(campaign_id,v_cur(i).CON_PER_ID,wave_number,load_number),
        GET_DISC_PERC(v_cur(i).CON_PER_ID), --Получаем проценты
        GET_DISC(v_cur(i).CON_PER_ID), --Получаем скидку
        wave_number,
        v_cur(i).CON_PER_ID,
        campaign_id,
        load_number);
       END LOOP;

FUNCTION GET_ROW_PARAM
(
	campaign_id  IN VARCHAR2,
  client_id    IN VARCHAR2,
  wave_number  IN NUMBER,
  load_number  IN NUMBER
) RETURN VARCHAR2
IS
countClient NUMBER;
Par VARCHAR2(15);
BEGIN

  IF (
       client_id   IS NULL OR
       campaign_id IS NULL OR
       wave_number IS NULL OR
       load_number IS NULL
     )
  THEN
     DBMS_OUTPUT.PUT_LINE('GET_ROW_PARAM: One or more of the required parameters not passed.');
     RETURN Par;
  END IF;

     DBMS_OUTPUT.PUT_LINE(''||client_id||' '||campaign_id||' '||wave_number||' '||load_number);

  SELECT count(*)
  INTO countClient
  FROM SIEBEL.CX_PERS_PARAM
  WHERE WAVE_NUM = wave_number
  AND MAILING_ID = campaign_id
  AND BOOT_NUM = load_number
  AND CLIENT_ID = client_id;

  IF (countClient = 0)
  THEN
    Par := SIEBEL.CX_PERS_PARAM_SEQ.nextval;
    RETURN Par;
  ELSE  
    SELECT cpp.ROW_ID
    INTO Par
    FROM SIEBEL.CX_PERS_PARAM cpp
    WHERE cpp.CLIENT_ID = client_id
    AND cpp.WAVE_NUM = wave_number
    AND cpp.MAILING_ID = campaign_id
    AND cpp.BOOT_NUM = load_number;
    RETURN Par;
  END IF;

EXCEPTION
  WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('Other error in GET_ROW_PARAM: '||sqlerrm);
    RETURN Par;

END GET_ROW_PARAM;

SELECT count(*)
  INTO countClient
  FROM SIEBEL.CX_PERS_PARAM
  WHERE WAVE_NUM = wave_number
  AND MAILING_ID = campaign_id
  AND BOOT_NUM = load_number
  AND CLIENT_ID = client_id;