DBA Data[Home] [Help]

PACKAGE: APPS.POR_LOAD_EMP_TEMP_TABLE

Source


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