1 PACKAGE POR_LOAD_EMPLOYEE AUTHID CURRENT_USER as
2 /* $Header: PORLEMPS.pls 115.3 2002/11/19 00:34:10 jjessup ship $ */
3
4 PROCEDURE insert_update_employee_info (
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_email_address IN VARCHAR2,
18 x_work_telephone IN VARCHAR2);
19
20 FUNCTION get_business_group_id (p_business_group_name IN VARCHAR2) RETURN NUMBER;
21
22 FUNCTION get_employee_exists (p_employee_number IN VARCHAR2) RETURN NUMBER;
23
24 FUNCTION get_row_id (p_employee_number IN VARCHAR2) RETURN VARCHAR2;
25
26 PROCEDURE get_employee_details(x_employee_number IN VARCHAR2,
27 p_Effective_Start_Date OUT NOCOPY DATE,
28 p_Effective_End_Date OUT NOCOPY DATE,
29 p_Business_Group_Id OUT NOCOPY NUMBER,
30 p_Person_Type_Id OUT NOCOPY NUMBER,
31 p_Last_Name OUT NOCOPY VARCHAR2,
32 p_Start_Date OUT NOCOPY DATE,
33 p_Hire_date OUT NOCOPY DATE,
34 p_Applicant_Number OUT NOCOPY VARCHAR2,
35 p_Comment_Id OUT NOCOPY NUMBER,
36 p_Current_Applicant_Flag OUT NOCOPY VARCHAR2,
37 p_Current_Emp_Or_Apl_Flag OUT NOCOPY VARCHAR2,
38 p_Current_Employee_Flag OUT NOCOPY VARCHAR2,
39 p_Date_Employee_Data_Verified OUT NOCOPY DATE,
40 p_Date_Of_Birth OUT NOCOPY DATE,
41 p_Email_Address OUT NOCOPY VARCHAR2,
42 p_Expense_Check_To_Address OUT NOCOPY VARCHAR2,
43 p_First_Name OUT NOCOPY VARCHAR2,
44 p_Full_Name OUT NOCOPY VARCHAR2,
45 p_Known_As OUT NOCOPY VARCHAR2,
46 p_Marital_Status OUT NOCOPY VARCHAR2,
47 p_Middle_Names OUT NOCOPY VARCHAR2,
48 p_Nationality OUT NOCOPY VARCHAR2,
49 p_National_Identifier OUT NOCOPY VARCHAR2,
50 p_Previous_Last_Name OUT NOCOPY VARCHAR2,
51 p_Registered_Disabled_Flag OUT NOCOPY VARCHAR2,
52 p_Sex OUT NOCOPY VARCHAR2,
53 p_Title OUT NOCOPY VARCHAR2,
54 p_Vendor_Id OUT NOCOPY NUMBER,
55 p_Work_Telephone OUT NOCOPY VARCHAR2,
56 p_Attribute_Category OUT NOCOPY VARCHAR2,
57 p_Attribute1 OUT NOCOPY VARCHAR2,
58 p_Attribute2 OUT NOCOPY VARCHAR2,
59 p_Attribute3 OUT NOCOPY VARCHAR2,
60 p_Attribute4 OUT NOCOPY VARCHAR2,
61 p_Attribute5 OUT NOCOPY VARCHAR2,
62 p_Attribute6 OUT NOCOPY VARCHAR2,
63 p_Attribute7 OUT NOCOPY VARCHAR2,
64 p_Attribute8 OUT NOCOPY VARCHAR2,
65 p_Attribute9 OUT NOCOPY VARCHAR2,
66 p_Attribute10 OUT NOCOPY VARCHAR2,
67 p_Attribute11 OUT NOCOPY VARCHAR2,
68 p_Attribute12 OUT NOCOPY VARCHAR2,
69 p_Attribute13 OUT NOCOPY VARCHAR2,
70 p_Attribute14 OUT NOCOPY VARCHAR2,
71 p_Attribute15 OUT NOCOPY VARCHAR2,
72 p_Attribute16 OUT NOCOPY VARCHAR2,
73 p_Attribute17 OUT NOCOPY VARCHAR2,
74 p_Attribute18 OUT NOCOPY VARCHAR2,
75 p_Attribute19 OUT NOCOPY VARCHAR2,
76 p_Attribute20 OUT NOCOPY VARCHAR2,
77 p_Attribute21 OUT NOCOPY VARCHAR2,
78 p_Attribute22 OUT NOCOPY VARCHAR2,
79 p_Attribute23 OUT NOCOPY VARCHAR2,
80 p_Attribute24 OUT NOCOPY VARCHAR2,
81 p_Attribute25 OUT NOCOPY VARCHAR2,
82 p_Attribute26 OUT NOCOPY VARCHAR2,
83 p_Attribute27 OUT NOCOPY VARCHAR2,
84 p_Attribute28 OUT NOCOPY VARCHAR2,
85 p_Attribute29 OUT NOCOPY VARCHAR2,
86 p_Attribute30 OUT NOCOPY VARCHAR2,
87 p_Last_Update_Date OUT NOCOPY DATE,
88 p_Last_Updated_By OUT NOCOPY NUMBER,
89 p_Last_Update_Login OUT NOCOPY NUMBER);
90
91 END POR_LOAD_EMPLOYEE;