ERPstuff - Oracle EBS Community

I WANT TO PASS QUERY THAT WAS BUILT IN FORM BUILDER 9i TO REPORT BUILDER AS WE DONE IN FORMS 6I AS


ADD_PARAMETER(PL_ID,'P_1',DATA_PARAMETER,'EMP_QUERY');

THIS EMP_QUERY IS BUILT IN FORMS 6i AT RUNTIME.

THIS IS CODE WE WRITE IN FORMS 6I TO PASS RUNTIME QUERY THAT WAS BUILT AT FORM LEVEL AND PASS IT TO REPORTS TO GET RESULTS.THE RESULTS ARE DERIVED ACCORDING TO QUERY THAT WAS PASSED THROUGH PARAMETER.

HOW I CAN DO THAT IN FORMS 9i

ALSO TELL ME HOW TO USE SET_ALERT
WHEN I WRITE IN MY BUTTON CODE
ERROR IS GIVEN

"IDENTIFIER SET_ALERT MUST BE DECLARED"

PLEASE HELP ME


THANKS