1 PACKAGE POR_LOAD_EMP_TEMP_TABLE AUTHID CURRENT_USER as
2 /* $Header: PORLEMTS.pls 115.1 2001/06/28 18:57:04 pkm ship $ */
3
4 PROCEDURE insert_update_emp_temp_table (
5 x_employee_number IN VARCHAR2,
6 x_first_name IN VARCHAR2,
7 x_last_name IN VARCHAR2,
8 x_sex IN VARCHAR2,
9 x_effective_start_date IN DATE,
10 x_effective_end_date IN DATE,
11 x_business_group_name IN VARCHAR2,
12 x_location_name IN VARCHAR2,
13 x_default_employee_account IN VARCHAR2,
14 x_set_of_books_name IN VARCHAR2,
15 x_supervisor_emp_number IN VARCHAR2,
16 x_job_name IN VARCHAR2,
17 x_user_name IN VARCHAR2,
18 x_password IN VARCHAR2,
19 x_email_address IN VARCHAR2,
20 x_work_telephone IN VARCHAR2);
21
22 FUNCTION get_employee_exists (p_employee_number IN VARCHAR2) RETURN BOOLEAN;
23
24 END POR_LOAD_EMP_TEMP_TABLE;
25