Note: Page --> Reload on Submit: Always
declare
v_type varchar2(10);
HAWB_NUMBER varchar2(50);
begin
SELECT DISTINCT GET_HAWB_DTL('A',:P96_HAWB_ID) HAWB
INTO HAWB_NUMBER
FROM HAWB_MST;
if :P96_REPORT_FORMAT = 'PDF' then
v_type := 'PDF';
elsif :P96_REPORT_FORMAT = 'XLS'
then v_type := 'XLS';
end if;
xlib_jasperreports.set_report_url('http://jasper.maxapex.net:8090/JasperReportsIntegration/report');
xlib_jasperreports.show_report (p_rep_name => 'A234280/Report/HAWB_Dumy_copy/HAWB_dumy',
p_rep_format => :P96_REPORT_FORMAT,
p_data_source => 'RAI_A234280_1961',
p_out_filename => HAWB_NUMBER||'-HAWB_dumy' || '.' || :P96_REPORT_FORMAT,
p_rep_locale => 'en_US',
p_rep_encoding => 'UTF-8',
p_additional_params => 'V_COM=' || :P96_COM_ID||'&' ||
'HAWBID=' || :P96_HAWB_ID);
--||
-- stop rendering of the current APEX page
apex_application.g_unrecoverable_error := true;
end;
===============================================
declare
v_type varchar2(10);
begin
if :P362_REPORT_FORMAT = 'PDF' then
v_type := 'PDF';
elsif :P362_REPORT_FORMAT = 'XLS'
then v_type := 'XLS';
end if;
xlib_jasperreports.set_report_url('http://jasper.maxapex.net:8090/JasperReportsIntegration/report');
xlib_jasperreports.show_report (p_rep_name => 'A234280/Report/FROND_PAGE/FROND_PAGE',
p_rep_format => :P362_REPORT_FORMAT,
p_data_source => 'RAI_A234280_1961',
p_out_filename => 'AIREXPORT_FROND_PAGE' || '.' || :P362_REPORT_FORMAT,
p_rep_locale => 'en_US',
p_rep_encoding => 'UTF-8',
p_additional_params => 'AIREXP_ID=' || :P362_AIREXP_MST_ID);
--||
-- stop rendering of the current APEX page
apex_application.g_unrecoverable_error := true;
end;