Home » Applications » Oracle Fusion Apps & E-Business Suite » How to request Report by Zoom functions ?
How to request Report by Zoom functions ? [message #198381] Mon, 16 October 2006 22:36
triluu
Messages: 12
Registered: September 2006
Junior Member

Hi all !
I want use Zoom functions in the Oracle form to request my report. Form name is : ARXRWMAI and block name is: RGW_FOLDER

My code here
procedure event(event_name varchar2) is 

		form_name  varchar2(30) := name_in('system.current_form'); 
    	block_name varchar2(30) := name_in('system.cursor_block'); 
    	pl_id				ParamList;	
  begin 
   if (event_name = 'ZOOM') then 
 		 if (form_name='ARXRWMAI' and block_name='RGW_FOLDER') then
 	 			pl_id := GET_PARAMETER_LIST('PARAMS');
 	 			If NOT ID_NULL(pl_id) then
 	 				DESTROY_PARAMETER_LIST(pl_id);
 	 			end if;
 	 			pl_id := CREATE_PARAMETER_LIST('PARAMS');
 	 			ADD_PARAMETER(pl_id,'P_thu',TEXT_PARAMETER,name_in('RGW_FOLDER.cash_receipt_id'));
	--	 add_parameter(plid, 'P_thu', TEXT_PARAMETER,name_in('RGW_FOLDER.cash_receipt_id'));
     		run_product(REPORTS,'BDPTKH.rdf',SYNCHRONOUS,RUNTIME,FILESYSTEM,pl_id,null);
     End if;
	 End if; 
End event; 

what is wrong code.
Help me. Thank you very much.

[Updated on: Mon, 16 October 2006 22:37]

Report message to a moderator

Previous Topic: ORA-27123
Next Topic: Supplier - Item - Price - Relation
Goto Forum:
  


Current Time: Mon Jul 01 07:02:30 CDT 2024