Wednesday, 25 January 2012

NUMBER TO WARD

function CF_1Formula return Char is
paise number ;
in_words varchar2(200);
begin
    in_words := 'Rs. '||conv_to_word(trunc(:cs_amount)) ;
 paise := (round(:cs_amount,2) - trunc(:cs_amount))*100 ;
 if paise <> 0 then
       in_words := in_words||' And Paise '||conv_to_word(trunc(paise)) ;
 end if;


 return(in_words||' Only' );
end;

No comments:

Post a Comment