| Re: Parameter input changes report main heading [message #88571] |
Tue, 19 November 2002 11:22 |
George B
Messages: 28
Registered: November 2002
|
Junior Member |
|
|
function AfterPForm return boolean is
begin
select decode(:P_TransactionType, 'Remove from UPA', 'UPA Details Removed by Transaction Code',
'Deposit to UPA','Deposit to UPA Summary for || to_char(:P_Effective_Date, "mm/dd/yyyy")')
into :P_ReportHeader from dual;
return (TRUE);
end;
It doesn't work..I guess by now you might have guessed I am a newbie to this Oracle stuff.
here is the display I get :
Deposit to UPA summary for ||to_char....so on...
it did not do the date conversion..
again, thanks for our patience...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
