Difference between revisions of "HR.ADD JOB HISTORY (procedure)"
| Line 3: | Line 3: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- | |- | ||
| − | | ''' | + | | '''Procedure |
| HR.ADD_JOB_HISTORY | | HR.ADD_JOB_HISTORY | ||
|- | |- | ||
| Line 9: | Line 9: | ||
| + | === Source === | ||
<pre> | <pre> | ||
CREATE OR REPLACE PROCEDURE add_job_history | CREATE OR REPLACE PROCEDURE add_job_history | ||
| Line 24: | Line 25: | ||
END add_job_history; | END add_job_history; | ||
</pre> | </pre> | ||
| + | |||
| + | === References === | ||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''Dependency Type | ||
| + | | '''Object Type | ||
| + | | '''Referenced Object | ||
| + | |||
| + | |- | ||
| + | | Insert | ||
| + | | Table | ||
| + | | [[HR.JOB_HISTORY_(table)|HR.JOB_HISTORY]] | ||
| + | |||
| + | |} | ||
Revision as of 08:26, 11 February 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 |
