STEP -1

CREATE REPORT LIKE--
select
SAL AS "SALARY",
NVL(COMM,0) AS "COMMISION",
DEPTNO
from EBA_DEMO_CHART_EMP

NOTE--STATIC ID --- emp
step-2
column-- SALARY
HTML Expression-- <span style="display:block; min-width:110px">#SALARY#</span>
static id -- SAL

column-- COMMISION
HTML Expression-- <span style="display:block; min-width:110px">#COMMISION#</span>
static id-- COMM

column-- DEPTNO
HTML Expression-- <span style="display:block; min-width:110px">#DEPTNO#</span>
static id-- DEPTNO

step-3 create ajax callback process--
name--AGG_PRO

pl/sql --

DECLARE
STR VARCHAR2(3000) :='';
BEGIN
APEX_JSON.OPEN_OBJECT;
SELECT JSON_OBJECT(
'SAL' VALUE SUM(SAL),
'COMM' VALUE SUM(COMM),
'DEPTNO' VALUE SUM(DEPTNO),
'DUMMY' VALUE TO_CHAR(SUM(1))
FORMAT JSON
) INTO STR
ROM EBA_DEMO_CHART_EMP;
apex_json.write('AGG', STR);
apex_json.close_object;
apex_json.close_all;
END;

step -4 create javascrip functin "add_agg_row" and keep this function code at "Function and Global Variable Declaration"

function add_agg_row(){
if( !$('#emp tbody tr:last').hasClass('gnr_agg')){
apex.server.process( "AGG_PRO", {
x01: "test",

}, {
success: function( data ) {
// if control break exist
if ($('#emp_control_panel').length > 0){
insert_agg_rec_control_break(data);
}
else{
insert_agg_rec(data);
}

},
error: function( jqXHR, textStatus, errorThrown ) {
}
} );
}
function insert_agg_rec(data){
var obj= JSON.parse(data.AGG);
var last_rec= $('#emp tbody tr:last');
var cell_html='';
var cell_txt='';
var agg_rec ='';
last_rec.children().each(function(index,element){
if($(this).text().length ==0){
$(this).text('^');
}
});

last_rec.children().each(function(index,element){
cell_html=element.outerHTML;
//console.log($(cell_html).text());
cell_txt=$(this).text();

if (typeof obj[$(this).attr('headers')] !=='undefined'){
cell_html=cell_html.replace('min-width:110px','$$$$');
cell_html=cell_html.replace(cell_txt,obj[$(this).attr('headers')]);
cell_html=cell_html.replace('$$$$','min-width:110px');

agg_rec=agg_rec+cell_html;
}else{
cell_html=cell_html.replace(cell_txt,'');
agg_rec=agg_rec+cell_html;
}
if($(this).text() =='^'){
$(this).text('');
}
});

$('#emp tbody tr:last').after('<tr class="gnr_agg">'+agg_rec+'</tr>'); //first
$('#emp .gnr_agg').children().each(function(){
if ($(this).text().length > 0){
$(this).css("background-color","yellow");
}
});
}

//console.log($('#emp_control_panel').length);

function insert_agg_rec_control_break(data){
var obj= JSON.parse(data.AGG);
var last_rec= $('#emp tbody tr:nth-child(3)');
var cell_html='';
var cell_txt='';
var agg_rec ='',
cell_headers='';;
last_rec.children().each(function(index,element){
cell_html=element.outerHTML;
cell_txt=$(this).text();
console.log($(this).attr('headers').split(' '));
cell_headers=($(this).attr('headers').split(' '));
if (typeof obj[cell_headers[0]] !=='undefined'){
cell_html=cell_html.replace(cell_headers[1],'');
cell_html=cell_html.replace('min-width:110px','$$$$');
cell_html=cell_html.replace(cell_txt,obj[(cell_headers[0]).trim()]);
cell_html=cell_html.replace('$$$$','min-width:110px');
agg_rec=agg_rec+cell_html;
}else{
cell_html=cell_html.replace(cell_txt,'');
agg_rec=agg_rec+cell_html;
}
});

$('#emp tbody tr:last').after('<tr class="gnr_agg">'+agg_rec+'</tr>'); //last
$('#emp .gnr_agg').children().each(function(){
if ($(this).text().length > 0){
$(this).css("background-color","yellow");
}
});
}
}

step -5 keep below defined code at "Function and Global Variable Declaration"

apex.jQuery( apex.gPageContext$ ).on( "apexreadyend", function( e ) {
add_agg_row();
} );

step -6 create a dynamic action
name- refresh report
event - after refresh
select type -region
region -- your report region
action- javascript code
add_agg_row();

STEP 1-- CREATE ITEM "P115_START_TIME" AS SELECT LIST
QUERY--

select to_char(TO_DATE('01/01/2021 09:00:00','DD/MM/YYYY HH24:MI:SS') + (1/1440*(level-1)*15),'HH24:MI') d ,
to_char(TO_DATE('01/01/2021 09:00:00','DD/MM/YYYY HH24:MI:SS') + (1/1440*(level-1)*15),'DD/MM/YYYY HH24:MI:SS') r
from dual CONNECT BY LEVEL<97;

NOTE- Format Mask===>DD/MM/YYYY HH24:MI:SS
Display Extra Values=> NO

STEP 2-- CREATE SECOND ITEM "P115_END_TIME" AS SELECT LIST

QUERY--
select TO_CHAR(to_date(:P115_START_TIME,'DD/MM/YYYY HH24:MI:SS') + (1/1440*(level-1)*15),'HH24:MI')||
CASE WHEN (((level-1)*15))/60 >1 THEN
CASE WHEN MOD(((level-1)*15),60)> 0 THEN '( '|| FLOOR((((level-1)*15))/60)||' HOURS '|| MOD(((level-1)*15),60)||' MINUTES )'
ELSE '( '||(((level-1)*15))/60||' HOURS)'
END
ELSE
CASE WHEN ((level-1)*15)=0 THEN '( 0 MINUTES )'
ELSE
CASE WHEN MOD(((level-1)*15),60) = 0 THEN '( 1 HOURS )'
ELSE '( '||MOD(((level-1)*15),60)||' MINUTES )'
END
END
END AS DD ,
((level-1)*15) RR

from dual CONNECT BY LEVEL<97

Cascading List of Values --
PARENT ITEM-- P115_START_TIME

step 1 assign static id for "order_value" column like "order_val"

step 2 create dynamic action
name-- order value validation
event- change
colmun- order_value

action-- execute javascript

var min_val = apex.item('p114_min').getValue();
var max_val = apex.item('p114_max').getValue();

var order=apex.item("order_val");
var v_order= order.getValue();

if (v_order >= min_val && v_order <=max_val){
order.node.setCustomValidity("");
}else{
order.node.setCustomValidity("invalid number");//--customize your error message as your requirement
}

create a dynamic action
"after refresh" report region
action == execute javascript code
like–
//– replace your conditional column with HIREDATE

$(‘.emp [headers=”HIREDATE”]’).each(function(index,element){
var x= element.innerHTML;
//console.log($(element).children().attr(‘data-id’));
var text= parseInt($(element).children().attr(‘data-id’));

if (text > 1){
$(this).closest(“tr”).children().css({“background-color”:”red”});
}
});