XML Database (MOSC)

MOSC Banner

Before report trigger

edited Dec 27, 2010 8:20AM in XML Database (MOSC) 1 commentAnswered
I have to create a before report trigger which have to return a value and this value will be used in my SQL Query again. In reports Builder I assigned a value (by calling a function) to a user parameter.

E.g

Function BeforeReport return boolean is

BEGIN

  hr_standard.event('BEFORE REPORT');

  : p_profile_value := fnd_profile.VALUE('RESP_ID');

END;

How do I do this now in a XML Data Template? 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center