Q: Report 2.5 - report name?
From: Ng TC <tcng_at_yas.com.sg>
Date: 1998/12/28
Message-ID: <766oar$sd4$1_at_newton3.pacific.net.sg>#1/1
Date: 1998/12/28
Message-ID: <766oar$sd4$1_at_newton3.pacific.net.sg>#1/1
Hi,
I am using Developer 2000 Reports 2.5.
[Quoted] I have a report 'RPFA9016'. This name is shown at the highest level in the
report designer.
I want to do a select statement in the beforereport trigger:
BEGIN
SELECT UPPER(User_Concurrent_Program_Name), Concurrent_Program_Name INTO :P_RPT_NAME, :P_RPT_ID FROM FND_Concurrent_Programs WHERE Concurrent_Program_Name = 'RPFA9016'; EXCEPTION WHEN NO_DATA_FOUND THEN :P_RPT_NAME := '*Report Name not found*';END ; But I do not want to hard code 'RPFA9016' in the above statement. Is there any global name/reserve word that I can replace the hard code with??
Thanks.
Regards,
T C
(Please also reply to mailto:tcng_at_yas.com.sg )
Received on Mon Dec 28 1998 - 00:00:00 CET