Oracle PLSQL Human Resource Salary Process in Oracle Apex

 CREATE TABLE SALARY AND ADD THESE COLUMNS :

MON,
BONUS_PERC,
BONUS_AMOUNT,
TOTAL

Process :

delete from salary where mon=:P21_YR||:P21_MON;
INSERT INTO SALARY
(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO,GENDER,MON,
BONUS_PERC,
BONUS_AMOUNT,
TOTAL)
SELECT
EMPNO,ENAME,JOB,MGR,HIREDATE,NVL(SAL,0),NVL(COMM,0),DEPTNO,GENDER,:P21_YR||:P21_MON,NVL(:P21_BONUS_PERC,0),NVL(:P21_BONUS_PERC*SAL/100,0),NVL(SAL,0)+NVL(COMM,0)+NVL(:P21_BONUS_PERC,0)*NVL(SAL,0)/100  FROM EMP;