Wednesday 26 November 2014

After Parameter Report Date Format and Parameter Customer Ranges

Report Triggers  used in   After Parameter Form


:p_date_from := TO_CHAR (TO_DATE (SUBSTR (:p_date_from, 1, 10), 'YYYY/MM/DD'), 'DD-MON-YYYY');


  :p_date_to       := TO_CHAR (TO_DATE (SUBSTR (:p_date_to, 1, 10), 'YYYY/MM/DD'), 'DD-MON-YYYY');





if    :P_CUSTOMER_ID_FROM  >  :P_CUSTOMER_ID_TO then
                 :P_CUSTOMER_ID_TO:=:P_CUSTOMER_ID_FROM;
 
  end if;
 



 

No comments:

Post a Comment