Closing a child (pop) window called by using javascript. Parent javascript: popup=window.open(“https://dvrr.gs.ing.net/dvrr1/fp=110:2″,””,”location=no,toolbar=no,menubar=no,status=no, resizable=1,width=700,height=500″); window.onunload = function() { if (popup && !popup.closed) { popup.close(); } };
Sometimes it would be easy to have a view which is parameterized. One of the options is to use sys_context. Another option is to makeuse of a pipelined function. Example package CREATE OR REPLACE PACKAGE okps_preop_tst IS TYPE outrec_typ IS RECORD ( id pof_dossiers.id%TYPE, dossier_type pof_dossiers.dsr_type%TYPE, dossier_nr pof_dossiers.dossier_nr%TYPE, dossier_datum pof_dossiers.dossier_datum%TYPE, Read more…
To change the background color of a region assign a static ID to the region and add CSS-styles in top of the page. To color the background with a certain opacity without effect on foreground text use this code: <style> #Tmp1{ background: rgba(200, 54, 54, 0.5); } } </style> The Read more…
To get a background image in Apex just add the following code to a region in a page or in css-part of a page. Putting it into a region its maybe easier to reference item with name of image and by using a process you could even randomise that. To Read more…
A classic report in APex can be refreshed dynamically. A pl/sql region is more difficult, you must do this by using an application proces. Create a plsql region calling a procedure/package with htp.p-commands. IE <div id=HK3>xcvxvxvxvc</div> BEGIN show_data; END; create a application process (refresh_data) DECLARE l_param1 varchar2(100); BEGIN l_param1:= apex_application.g_x01; Read more…
You can upload files of course but restiting the file types can be done by changing the following fields: item : The item of type file browse Settings – file types : .xls, .xlsx, .csv , .txt