need help on urgent basis [message #90139] |
Sun, 07 November 2004 07:41 |
fanni
Messages: 96 Registered: March 2004
|
Member |
|
|
i am calling the reports by using this code
----------------
OCEDURE Call_module ( p_cm_name Varchar2) IS
v_cm_type varchar2(30);
v_cm_module varchar2(130);
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status varchar2(20);
pl_id ParamList;
BEGIN
SELECT FUNCTION_TYPE, FUNCTION_MODULE
INTO v_cm_type, v_cm_module
FROM CMS_FUNCTIONS
WHERE FUNCTION_NAME = p_cm_name;
IF v_cm_type = 'FORMS' THEN
CALL_Form( v_cm_module);--, NO_HIDE, dO_REPLACE );
ELSE
pl_id := Create_Parameter_List('tmpdata');
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Add_Parameter(pl_id, 'P_LOGIN_SEASON', TEXT_PARAMETER, :GLOBAL.P_LOGIN_SEASON);
Run_Product(REPORTS, v_cm_module, ASYNCHRONOUS, RUNTIME,FILESYSTEM,pl_id,null);
Destroy_Parameter_List( pl_id );
END IF;
EXCEPTION
WHEN OTHERS THEN
MESSAGE('When Others error...'||sqlerrm);
END;
----------------
i have made a function and uses this function for caling the reports from the menu. but there is a problem that it opens only one report at one time if one report is opened and i click the othr report it does not open the second report untill the first report is closed.
i need it on urgent basis
regards
farhan ashraf
|
|
|