HR

ADD_JOB_HISTORY

Arguments

Argument name	Datatype	Default value	In/out
P_EMP_ID	NUMBER		IN
P_START_DATE	DATE		IN
P_END_DATE	DATE		IN
P_JOB_ID	VARCHAR2		IN
P_DEPARTMENT_ID	NUMBER		IN

Source

Code

1   :PROCEDURE add_job_history
2   :  (  p_emp_id          job_history.employee_id%type
3   :   , p_start_date      job_history.start_date%type
4   :   , p_end_date        job_history.end_date%type
5   :   , p_job_id          job_history.job_id%type
6   :   , p_department_id   job_history.department_id%type
7   :   )
8   :IS
9   :BEGIN
10  :  INSERT INTO job_history (employee_id, start_date, end_date,
11  :                           job_id, department_id)
12  :    VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id);
13  :END add_job_history;