BEGIN
  v_bill_cycle_end_date DATE := TO_DATE('10/12/2008','MM/DD/YYYY');
    v_query               VARCHAR2(500); 
  
   v_query := 'UPDATE REQUESTS_DUP SET status = ''PI'' WHERE NEXT_INVOICE_PRINT_DATE = :1';

   EXECUTE IMMEDIATE v_query using v_bill_cycle_end_date;
   commit;
   DBMS_OUTPUT.PUT_LINE(' '||v_query);

UPDATE REQUESTS_DUP SET status = 'PI' WHERE NEXT_INVOICE_PRINT_DATE = :1