Database reference - HR

HR - procedures - HR.ADD_JOB_HISTORY

Description

none

Procedure properties

name	value
name	HR.ADD_JOB_HISTORY
created	2/7/2006 10:52:59 PM
modified	8/22/2011 6:48:53 PM
status	VALID
temporary	N
generated	N
secondary	N

Parameters

name	datatype	in/out
P_EMP_ID	NUMBER	IN
P_START_DATE	DATE	IN
P_END_DATE	DATE	IN
P_JOB_ID	VARCHAR2 (10)	IN
P_DEPARTMENT_ID	NUMBER	IN

Usage

exec HR.ADD_JOB_HISTORY(
    my_P_EMP_ID,
    my_P_START_DATE,
    my_P_END_DATE,
    my_P_JOB_ID,
    my_P_DEPARTMENT_ID
);

Dependency graph

JOB_HISTORYADD_JOB_HISTORY UPDATE_JOB_HISTORY

Objects that HR.ADD_JOB_HISTORY depends on

name	object type	level
JOB_HISTORY	table	1

Objects that depend on HR.ADD_JOB_HISTORY

name	object type	level
UPDATE_JOB_HISTORY	trigger	1

Documentation generated by SqlSpec