Q: Report 2.5 - report name?

From: Ng TC <tcng_at_yas.com.sg>
Date: 1998/12/28
Message-ID: <766oar$sd4$1@newton3.pacific.net.sg>#1/1

Hi,
I am using Developer 2000 Reports 2.5.
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 CST