Difference between revisions of "HR.ADD JOB HISTORY (procedure)"
| Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| − | |- | + | |- valign="top" |
| '''Procedure | | '''Procedure | ||
| HR.ADD_JOB_HISTORY | | HR.ADD_JOB_HISTORY | ||
| − | |||
|} | |} | ||
| − | |||
=== Source === | === Source === | ||
| Line 33: | Line 31: | ||
| '''Referenced Object | | '''Referenced Object | ||
| − | |- | + | |- valign="top" |
| Insert | | Insert | ||
| Table | | Table | ||
Revision as of 07:14, 24 June 2010
wikibot
| Procedure | HR.ADD_JOB_HISTORY |
Source
CREATE OR REPLACE PROCEDURE add_job_history
( p_emp_id job_history.employee_id%type
, p_start_date job_history.start_date%type
, p_end_date job_history.end_date%type
, p_job_id job_history.job_id%type
, p_department_id job_history.department_id%type
)
IS
BEGIN
INSERT INTO job_history (employee_id, start_date, end_date,
job_id, department_id)
VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id);
END add_job_history;
References
| Dependency Type | Object Type | Referenced Object |
| Insert | Table | HR.JOB_HISTORY |
