[Home] [Help]
PACKAGE: APPS.AP_WEB_DB_HR_INT_PKG
Source
1 PACKAGE AP_WEB_DB_HR_INT_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwdbhrs.pls 120.21.12010000.2 2008/08/06 07:49:08 rveliche ship $ */
3
4 /*HR Employees */
5 ---------------------------------------------------------------------------------------------------
6 SUBTYPE empCurrent_employeeID IS HR_EMPLOYEES_CURRENT_V.employee_id%TYPE;
7 SUBTYPE empCurrent_fullName IS HR_EMPLOYEES_CURRENT_V.full_name%TYPE;
8 SUBTYPE empCurrent_empNum IS HR_EMPLOYEES_CURRENT_V.employee_num%TYPE;
9 SUBTYPE empCurrent_checkAddrFlag IS HR_EMPLOYEES_CURRENT_V.expense_check_address_flag%TYPE;
10 SUBTYPE empCurrent_defaultCodeCombID IS HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE;
11 SUBTYPE empCurrent_orgID IS
12 HR_EMPLOYEES_CURRENT_V.ORGANIZATION_ID%TYPE;
13 ---------------------------------------------------------------------------------------------------
14
15 /*PER Employees */
16 ---------------------------------------------------------------------------------------------------
17 SUBTYPE perEmp_employeeID IS PER_EMPLOYEES_CURRENT_X.employee_id%TYPE;
18 SUBTYPE perEmp_supervisorID IS PER_EMPLOYEES_CURRENT_X.supervisor_id%TYPE;
19 ---------------------------------------------------------------------------------------------------
20
21 /* FND User */
22 ---------------------------------------------------------------------------------------------------
23 SUBTYPE fndUser_userID IS FND_USER.user_id%TYPE;
24 SUBTYPE fndUser_employeeID IS FND_USER.employee_id%TYPE;
25 ---------------------------------------------------------------------------------------------------
26
27 /* AK Web User Security Attribute Values */
28 ---------------------------------------------------------------------------------------------------
29 SUBTYPE usrSecAttr_attrCode IS AK_WEB_USER_SEC_ATTR_VALUES.attribute_code%TYPE;
30 SUBTYPE usrSecAttr_webUserID IS AK_WEB_USER_SEC_ATTR_VALUES.web_user_id%TYPE;
31 ---------------------------------------------------------------------------------------------------
32
33
34 TYPE UserIdRefCursor IS REF CURSOR;
35 TYPE EmpInfoCursor IS REF CURSOR;
36 TYPE EmpNameCursor IS REF CURSOR;
37
38 --------------------------------------------------------------------------
39 TYPE EmployeeInfoRec IS RECORD (
40 employee_id empCurrent_employeeID,
41 employee_name empCurrent_fullName,
42 employee_num empCurrent_empNum,
43 emp_ccid empCurrent_defaultCodeCombID
44 );
45 --------------------------------------------------------------------------
46
47 --------------------------------------------------------------------------
48 FUNCTION GetUserIdForEmpCursor(
49 p_emp_id IN fndUser_employeeID,
50 p_user_id_ref_cursor OUT NOCOPY UserIdRefCursor
51 ) RETURN BOOLEAN;
52
53 --------------------------------------------------------------------------------
54 FUNCTION GetAllEmpListForWebUserCursor(
55 p_web_user_id IN usrSecAttr_webUserID,
56 p_emp_name_cursor OUT NOCOPY EmpNameCursor
57 ) RETURN BOOLEAN;
58 --------------------------------------------------------------------------------
59 FUNCTION GetEmpListForWebUserCursor(
60 p_web_user_id IN usrSecAttr_webUserID,
61 p_emp_name_cursor OUT NOCOPY EmpNameCursor
62 ) RETURN BOOLEAN;
63
64 FUNCTION getEmployeeID return number;
65
66 --------------------------------------------------------------------------------
67 FUNCTION GetEmployeeInfoCursor(
68 p_name_str IN VARCHAR2,
69 p_upper_approver_name_fuzzy IN empCurrent_fullName,
70 p_emp_info_cursor OUT NOCOPY EmpInfoCursor
71 ) RETURN BOOLEAN;
72 --------------------------------------------------------------------------------
73
74 -------------------------------------------------------------------
75 FUNCTION GetNumOfEmpForWebUser(
76 p_attribute_code IN usrSecAttr_attrCode,
77 p_web_user_id IN usrSecAttr_webUserID,
78 p_count OUT NOCOPY NUMBER
79 ) RETURN BOOLEAN;
80
81 -------------------------------------------------------------------
82 FUNCTION GetSupervisorID(
83 p_employee_id IN perEmp_employeeID,
84 p_manager_id OUT NOCOPY perEmp_supervisorID
85 ) RETURN BOOLEAN;
86
87 --------------------------------------------------------------------------------
88 FUNCTION GetEmpOrgId(
89 P_EmployeeID IN empCurrent_employeeID,
90 p_org_id OUT NOCOPY empCurrent_orgID
91 ) RETURN BOOLEAN;
92
93
94 -------------------------------------------------------------------
95 FUNCTION GetEmployeeInfo(p_employee_id IN empCurrent_employeeID,
96 p_emp_info_rec OUT NOCOPY EmployeeInfoRec
97 ) RETURN BOOLEAN;
98 -------------------------------------------------------------------
99
100 --------------------------------------------------------------------------------
101 FUNCTION GetEmpIdForUser(
102 p_user_id IN fndUser_userID,
103 p_emp_id OUT NOCOPY fndUser_employeeID
104 ) RETURN BOOLEAN;
105
106
107 FUNCTION GetSecurAttrCount(
108 P_WebUserID IN usrSecAttr_webUserID) RETURN NUMBER;
109
110 /*Bug 1347380: Function to get The Supervisor Name*/
111 FUNCTION GetSupervisorName(
112 p_employee_id IN NUMBER
113 ) RETURN VARCHAR2;
114
115 /* Bug 3176205: Inactive Employees and Contingent Workers project */
116 FUNCTION IsPersonActive (p_person_id IN NUMBER) RETURN VARCHAR2;
117
118 /* Bug 3176205: Inactive Employees and Contingent Workers project */
119 FUNCTION IsPersonCwk (p_person_id IN NUMBER) RETURN VARCHAR2;
120
121 /* Bug 3176205: Inactive Employees and Contingent Workers project */
122 PROCEDURE GetVendorAndVendorSite
123 (p_person_id IN NUMBER
124 ,p_effective_date IN DATE
125 ,p_vendor_id OUT NOCOPY NUMBER
126 ,p_vendor_site_id OUT NOCOPY NUMBER);
127
128 /* Bug 3251447: Bypass employee approval for terminated employee */
129 FUNCTION IsPersonTerminated (p_person_id IN NUMBER) return VARCHAR2;
130
131 /* Bug 3282097: Get supervisor id should also return supervisor for
132 terminated employees and contingent workers. */
133 /* returs only an active contingent worker or employee. */
134
135 FUNCTION GetSupervisorInfo(
136 p_employee_id IN NUMBER,
137 p_manager_id OUT NOCOPY NUMBER,
138 p_manager_name OUT NOCOPY VARCHAR2,
139 p_manager_org_id OUT NOCOPY NUMBER
140 ) RETURN BOOLEAN;
141
142 PROCEDURE GetSupervisorDetails(
143 p_employee_id IN NUMBER,
144 p_supervisor_id OUT NOCOPY NUMBER,
145 p_supervisor_name OUT NOCOPY VARCHAR2
146 );
147
148
149
150 /* Bug 3243527: Get Employee's Inactive Date */
151 FUNCTION GetEmpInactiveDate(
152 p_employee_id IN NUMBER
153 )RETURN DATE;
154
155 /* 3257576 : Get the manager ID, name and status.
156 returs an active/terminated/suspended employee
157 or contingent worker */
158 PROCEDURE GetManagerIdAndStatus(
159 p_employee_id IN NUMBER,
160 p_manager_id OUT NOCOPY NUMBER,
161 p_manager_name OUT NOCOPY VARCHAR2,
162 p_manager_status OUT NOCOPY VARCHAR2
163 );
164
165 FUNCTION GetEmployeeName(
166 p_employee_id IN NUMBER
167 ) RETURN VARCHAR2;
168
169
170 FUNCTION GetEmpOrgId(
171 p_employee_id IN empCurrent_employeeID,
172 p_effective_date IN Date,
173 P_organization_id OUT NOCOPY empCurrent_orgID
174 ) RETURN BOOLEAN;
175
176 FUNCTION HasValidFndUserAndWfAccount(
177 p_emp_id IN NUMBER
178 ) RETURN VARCHAR2;
179
180 FUNCTION getFinalActiveManager(p_employee_id IN NUMBER) RETURN NUMBER;
181
182 PROCEDURE GetEmpNameNumber(
183 p_employee_id IN NUMBER,
184 p_employee_number OUT NOCOPY VARCHAR2,
185 p_employee_name OUT NOCOPY VARCHAR2
186 );
187
188 PROCEDURE GetUserIdFromName(
189 p_user_name IN VARCHAR2,
190 p_user_id OUT NOCOPY NUMBER
191 );
192
193 END AP_WEB_DB_HR_INT_PKG;