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;
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