Please help me fix the error of my SQL code, I will provide my actual code as well as the error I am getting. Thank You.

Procedure GENERATE$\_$JOB$\_$ALERTS compiled

LINE$/$COL ERROR

$----------------------------------------------------------------------$

$11/9$ PL$/$SQL: SQL Statement ignored

$11/16$ PL$/$SQL: ORA$-00918$: column ambiguously defined

$40/13$ PL$/$SQL: SQL Statement ignored

$41/27$ PLS$-00364$: loop index variable $\text{'}$R$\_$JOB$\_$SEEKER' use is invalid

$41/27$ PL$/$SQL: ORA$-00904$: $"$R$\_$JOB$\_$SEEKER"."ACCID": invalid identifier

$52/13$ PL$/$SQL: SQL Statement ignored

$53/42$ PLS$-00364$: loop index variable $\text{'}$R$\_$JOB$\_$SEEKER' use is invalid

$53/55$ PL$/$SQL: ORA$-00984$: column not allowed here.

The actual code:

CREATE OR REPLACE PROCEDURE generate$\_$job$\_$alerts $($v$\_$jobid IN NUMBER, v$\_$timestamp IN TIMESTAMP$)$ AS

$--$ Cursor to find the job post and check if it is active

CURSOR cur$\_$job$\_$post IS

SELECT min$\_$degree, min$\_$years$\_$work$\_$exp, jobid

FROM job$\_$post

WHERE jobid $=$ v$\_$jobid AND j$\_$status $=1$;

$--$ Cursor to find job seekers who meet the degree and work experience requirements

CURSOR cur$\_$job$\_$seekers $($p$\_$degree NUMBER, p$\_$experience NUMBER$)$ IS

SELECT accid, username

FROM js$\_$account JOIN account$\_$t ON js$\_$account.accid $=$ account$\_$t$.$accid

WHERE degree $>=$ p$\_$degree AND num$\_$yrs$\_$wrk$\_$xp $>=$ p$\_$experience;

$--$ Variables to hold job requirements

v$\_$min$\_$degree NUMBER;

v$\_$min$\_$years$\_$work$\_$exp NUMBER;

v$\_$job$\_$post$\_$id NUMBER;

$--$ Variables for checking skills

v$\_$skill$\_$count NUMBER;

flag INT;

BEGIN

OPEN cur$\_$job$\_$post;

FETCH cur$\_$job$\_$post INTO v$\_$min$\_$degree, v$\_$min$\_$years$\_$work$\_$exp, v$\_$job$\_$post$\_$id;

IF cur$\_$job$\_$post$\%$NOTFOUND THEN

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Invalid job post ID$\text{'})$;

CLOSE cur$\_$job$\_$post;

RETURN;

END IF;

$--$ Loop through all qualified job seekers

FOR r$\_$job$\_$seeker IN cur$\_$job$\_$seekers$($v$\_$min$\_$degree, v$\_$min$\_$years$\_$work$\_$exp$)$ LOOP

flag :$=1$;

$--$ Check each required skill and level

FOR r$\_$skill IN $($SELECT skid, sklvl FROM job$\_$skills WHERE jobid $=$ v$\_$job$\_$post$\_$id$)$ LOOP

SELECT COUNT$(*)$ INTO v$\_$skill$\_$count FROM app$\_$skills

WHERE accid $=$ r$\_$job$\_$seeker.accid AND skid $=$ r$\_$skill.skid AND sklvl $>=$ r$\_$skill.sklvl;

IF v$\_$skill$\_$count $=0$ THEN

flag :$=0$;

EXIT;

END IF;

END LOOP;

IF flag $=1$ THEN

$--$ If all conditions are met, print and insert into message table

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$A job post $\text{'}||$ v$\_$job$\_$post$\_$id $||\text{'}$ is available and you are qualified to apply'$)$;

INSERT INTO message $($mid$,$ appid, mtime, mbody$)$

VALUES $($message$\_$seq.nextval, r$\_$job$\_$seeker.accid, v$\_$timestamp, 'A job post $\text{'}||$ v$\_$job$\_$post$\_$id $||\text{'}$ is available and you are qualified to apply'$)$;

END IF;

END LOOP;

CLOSE cur$\_$job$\_$post;

END;

Errors: check compiler log