insert values using trigger

Data will be first inserted into temp_data(using oracle APEX DML process) after the insertion comlplete i need to get those records and insert into temp_head and temp_detail. In, temp_head i need to insert sum on RATE and sum of Total when ID is same and in temp_detail there will be line wise entry same as temp_data based on ID.

create table temp_head(id number,rate number,total number);create table temp_detail(id number,rate number,total number);create table temp_data (id number,rate number,total number);insert into temp_data(1001,100,100);insert into temp_data(1001,200,200);insert into temp_data(1001,300,300);insert into temp_data(1002,400,400);insert into temp_data(1002,500,500); commit;

TEMP_DATA

id     rate  total

1001   100   100

1001   200   200

1001   300   300

1002   400   400

1002   500   500

So, expected output of TEMP_HEAD for ID = 1001 and ID = 1002:

id     rate  total

1001   600   600

1002   900   900

TEMP_DETAIL

  id     rate  total

1001   100   100

1001   200   200

1001   300   300

1002   400   400

1002   500   500

is there any way i can accomplish this using trigger.