Oracle Forms to Oracle APEX Migration (Help)

  How to control Check Box in Interactive Report (Allow One Selection of check box at time similar like Radio Button in Oracle APEX) Step 1 : Create Interactive Report with APEX_ITEM API for check box ,define p_attributes with OnlyOneChecked function while click on check box Go to Created Interactive Report ans change the setting of L_sel column (Escape Special Character off) Step 2 Your Output look like Step 3 :- Global Declaration (Define the OnlyOneChecked function). This code users JavaScript function to validate that only one check box is checked in group of check boxes. function OnlyOneChecked(pThis){ var ml = document.wwv_flow; var len = ml.elements.length; var indx; if (pThis.checked == false) pThis.checked = false; else { for (var j = 0; j < len; j++) { var e = ml.elements[j]; var e_type = e.type; if (e_type == ‘checkbox’) { e.checked = false; } } pThis.checked = true; } } step 4 (Test the Result) Multi Check box selection not allowed, only one check at time you can sel...

  APEX_AUTOMATION.EXECUTE :- the APEX_AUTOMATION.EXECUTE procedure executes the automation in the foreground (so you have to wait),   DBMS_SCHEDULER.CREATE_JOB :- executes the automation in the background. Objective:-   DBMS_SCHEDULER package to send your APEX_AUTOMATION.EXECUTE to the background. declare l_filters apex_exec.t_filters; l_static_id apex_appl_automations.static_id%type; l_exists number; l_application_id apex_appl_automations.application_id%type; l_job_short_name scheduled_jobs.job_short_name%type; BEGIN begin select static_id,application_id into l_static_id ,l_application_id from apex_appl_automations where AUTOMATION_ID=:P10_STATIC_ID; end; l_job_short_name:=replace(l_static_id,'-','_'); /* apex_exec.add_filter( p_filters => l_filters, p_column_name => 'DEPTNO', p_filter_type => apex_exec.c_filter_eq, p_value => 10 ); ...