How to Integrate Oracle 10g Reports with Oracle Apex

Script 1:

var r_server = "http://192.168.100.100/reports/rwservlet?server=rep_appsrv1_asbiforms10&destype=cache&desformat";

var r_branch_code = $v("P100_BRANCH");

var r_emp_id = $v("P100_emp_NO");

var r_link = ""+r_server+"=pdf&userid=HR/HR@HR&REPORT=D:/A_REPORT/FUND_REPAYMENT_LETTER.rdf&P_BRANCH_CODE="+r_branch_code+"&P_REPAYMENT_NO="+r_emp_id+"";

window.open(r_link);

Script 2 :

var serIp = $v("P14_SERIP");

var catId = $v("P14_ITEM_CAT");

var scatId = $v("P14_ITEM_SUB_CAT");

var coaId = $v("P14_COA_TYPE");

var reportId = '&CATID='+catId+'&SCATID='+scatId+'&COAID='+coaId;

if ($v("14_RG")==1)

window.open(serIp+'COMPANY_INFO.rdf&SOMID=1');

else if ($v("14_RG")==2)

window.open(serIp+'DEPT_INFO.rdf');

else if ($v("14_RG")==3)

window.open(serIp+'DESIG_INFO.rdf');

else if ($v("14_RG")==4)

window.open(serIp+'LINE_INFO.rdf');

else if ($v("14_RG")==5)

window.open(serIp+'BLOCK_INFO.rdf');

else if ($v("14_RG")==6)

window.open(serIp+'BUYER_INFO.rdf');

else if ($v("14_RG")==7)

window.open(serIp+'SUPPLIER_INFO.rdf');

else if ($v("14_RG")==8)

window.open(serIp+'ITEM_INFO.rdf'+reportId);

else if ($v("14_RG")==9)

window.open(serIp+'CHART_OF_ACCOUNTS.rdf');

DECLARE

A VARCHAR2(100);

B VARCHAR2(100);

C VARCHAR2(200);

D VARCHAR2(200);

E NUMBER;

BEGIN

SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') INTO A FROM DUAL;

SELECT SUBSTR(A,0,3) INTO B FROM DUAL;

SELECT LENGTH(A) INTO E FROM DUAL;

SELECT LIC_LOCAL_IP,LIC_REAL_IP INTO C,D FROM ISP_RUNAUTO;

IF E>6 THEN

    IF B=192 THEN RETURN C; ELSE RETURN D; END IF;

ELSE

    RETURN C;

END IF;

END;