1 PACKAGE HR_AE_VALIDATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: peaevald.pkh 120.4 2010/11/09 12:31:59 bkeshary ship $ */
3 PROCEDURE person_validate
4 (p_person_id in number
5 ,p_person_type_id in number
6 ,p_effective_date in date
7 ,p_sex in varchar2
8 ,p_first_name in varchar2 default null
9 ,p_last_name in varchar2 default null
10 ,p_nationality in varchar2 default null
11 ,p_national_identifier in varchar2 default null
12 ,p_title in varchar2 default null
13 ,p_marital_status in varchar2 default null
14 ,p_per_information_category in varchar2 default null
15 ,p_per_information1 in varchar2 default null
16 ,p_per_information2 in varchar2 default null
17 ,p_per_information3 in varchar2 default null
18 ,p_per_information4 in varchar2 default null
19 ,p_per_information5 in varchar2 default null
20 ,p_per_information6 in varchar2 default null
21 ,p_per_information7 in varchar2 default null
22 ,p_per_information8 in varchar2 default null
23 ,p_per_information9 in varchar2 default null
24 ,p_per_information10 in varchar2 default null
25 ,p_per_information11 in varchar2 default null
26 ,p_per_information12 in varchar2 default null
27 ,p_per_information13 in varchar2 default null
28 ,p_per_information14 in varchar2 default null
29 ,p_per_information15 in varchar2 default null
30 ,p_per_information16 in varchar2 default null
31 ,p_per_information17 in varchar2 default null
32 ,p_per_information18 in varchar2 default null
33 ,p_per_information19 in varchar2 default null
34 ,p_per_information20 in varchar2 default null
35 );
36
37 PROCEDURE applicant_validate
38 (p_business_group_id in number
39 ,p_person_type_id in number
40 ,p_date_received in date
41 ,p_sex in varchar2
42 ,p_first_name in varchar2 default null
43 ,p_last_name in varchar2 default null
44 ,p_nationality in varchar2 default null
45 ,p_national_identifier in varchar2 default null
46 ,p_title in varchar2 default null
47 ,p_marital_status in varchar2 default null
48 ,p_per_information_category in varchar2 default null
49 ,p_per_information1 in varchar2 default null
50 ,p_per_information2 in varchar2 default null
51 ,p_per_information3 in varchar2 default null
52 ,p_per_information4 in varchar2 default null
53 ,p_per_information5 in varchar2 default null
54 ,p_per_information6 in varchar2 default null
55 ,p_per_information7 in varchar2 default null
56 ,p_per_information8 in varchar2 default null
57 ,p_per_information9 in varchar2 default null
58 ,p_per_information10 in varchar2 default null
59 ,p_per_information11 in varchar2 default null
60 ,p_per_information12 in varchar2 default null
61 ,p_per_information13 in varchar2 default null
62 ,p_per_information14 in varchar2 default null
63 ,p_per_information15 in varchar2 default null
64 ,p_per_information16 in varchar2 default null
65 ,p_per_information17 in varchar2 default null
66 ,p_per_information18 in varchar2 default null
67 ,p_per_information19 in varchar2 default null
68 ,p_per_information20 in varchar2 default null
69 );
70
71 PROCEDURE employee_validate
72 (p_business_group_id in number
73 ,p_person_type_id in number
74 ,p_hire_date in date
75 ,p_sex in varchar2
76 ,p_first_name in varchar2 default null
77 ,p_last_name in varchar2 default null
78 ,p_nationality in varchar2 default null
82 ,p_per_information_category in varchar2 default null
79 ,p_national_identifier in varchar2 default null
80 ,p_title in varchar2 default null
81 ,p_marital_status in varchar2 default null
83 ,p_per_information1 in varchar2 default null
84 ,p_per_information2 in varchar2 default null
85 ,p_per_information3 in varchar2 default null
86 ,p_per_information4 in varchar2 default null
87 ,p_per_information5 in varchar2 default null
88 ,p_per_information6 in varchar2 default null
89 ,p_per_information7 in varchar2 default null
90 ,p_per_information8 in varchar2 default null
91 ,p_per_information9 in varchar2 default null
92 ,p_per_information10 in varchar2 default null
93 ,p_per_information11 in varchar2 default null
94 ,p_per_information12 in varchar2 default null
95 ,p_per_information13 in varchar2 default null
96 ,p_per_information14 in varchar2 default null
97 ,p_per_information15 in varchar2 default null
98 ,p_per_information16 in varchar2 default null
99 ,p_per_information17 in varchar2 default null
100 ,p_per_information18 in varchar2 default null
101 ,p_per_information19 in varchar2 default null
102 ,p_per_information20 in varchar2 default null
103 );
104
105 PROCEDURE contact_validate
106 (p_business_group_id in number
107 ,p_person_type_id in number
108 ,p_start_date in date
109 ,p_sex in varchar2
110 ,p_first_name in varchar2 default null
111 ,p_last_name in varchar2 default null
112 ,p_nationality in varchar2 default null
113 ,p_national_identifier in varchar2 default null
114 ,p_title in varchar2 default null
115 ,p_marital_status in varchar2 default null
116 ,p_per_information_category in varchar2 default null
117 ,p_per_information1 in varchar2 default null
118 ,p_per_information2 in varchar2 default null
119 ,p_per_information3 in varchar2 default null
120 ,p_per_information4 in varchar2 default null
121 ,p_per_information5 in varchar2 default null
122 ,p_per_information6 in varchar2 default null
123 ,p_per_information7 in varchar2 default null
124 ,p_per_information8 in varchar2 default null
125 ,p_per_information9 in varchar2 default null
126 ,p_per_information10 in varchar2 default null
127 ,p_per_information11 in varchar2 default null
128 ,p_per_information12 in varchar2 default null
129 ,p_per_information13 in varchar2 default null
130 ,p_per_information14 in varchar2 default null
131 ,p_per_information15 in varchar2 default null
132 ,p_per_information16 in varchar2 default null
133 ,p_per_information17 in varchar2 default null
134 ,p_per_information18 in varchar2 default null
135 ,p_per_information19 in varchar2 default null
136 ,p_per_information20 in varchar2 default null
137 );
138
139 PROCEDURE cwk_validate
140 (p_business_group_id in number
141 ,p_person_type_id in number
142 ,p_start_date in date
143 ,p_sex in varchar2
144 ,p_first_name in varchar2 default null
145 ,p_last_name in varchar2 default null
146 ,p_nationality in varchar2 default null
147 ,p_national_identifier in varchar2 default null
148 ,p_title in varchar2 default null
149 ,p_marital_status in varchar2 default null
150 ,p_per_information_category in varchar2 default null
151 ,p_per_information1 in varchar2 default null
152 ,p_per_information2 in varchar2 default null
153 ,p_per_information3 in varchar2 default null
154 ,p_per_information4 in varchar2 default null
155 ,p_per_information5 in varchar2 default null
156 ,p_per_information6 in varchar2 default null
157 ,p_per_information7 in varchar2 default null
158 ,p_per_information8 in varchar2 default null
159 ,p_per_information9 in varchar2 default null
160 ,p_per_information10 in varchar2 default null
161 ,p_per_information11 in varchar2 default null
162 ,p_per_information12 in varchar2 default null
163 ,p_per_information13 in varchar2 default null
164 ,p_per_information14 in varchar2 default null
165 ,p_per_information15 in varchar2 default null
166 ,p_per_information16 in varchar2 default null
167 ,p_per_information17 in varchar2 default null
168 ,p_per_information18 in varchar2 default null
169 ,p_per_information19 in varchar2 default null
170 ,p_per_information20 in varchar2 default null
171 );
172 --
173 PROCEDURE contract_validate
174 (p_effective_date IN DATE
175 ,p_type IN VARCHAR2
179 ,p_ctr_information1 IN VARCHAR2 DEFAULT NULL
176 ,p_duration IN NUMBER DEFAULT NULL
177 ,p_duration_units IN VARCHAR2 DEFAULT NULL
178 ,p_ctr_information_category IN VARCHAR2 DEFAULT NULL
180 ,p_ctr_information2 IN VARCHAR2 DEFAULT NULL
181 ,p_ctr_information3 IN VARCHAR2 DEFAULT NULL
182 ,p_ctr_information4 IN VARCHAR2 DEFAULT NULL
183 ,p_ctr_information5 IN VARCHAR2 DEFAULT NULL
184 );
185
186 --
187 PROCEDURE previous_employer_validate
188 (p_employer_name IN varchar2 default hr_api.g_varchar2
189 ,p_effective_date IN date default hr_api.g_date
190 ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
191 ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
192 );
193
194 PROCEDURE VALIDATE_CREATE_ORG_INF(
195 p_effective_date IN DATE
196 ,p_organization_id IN NUMBER
197 ,p_org_info_type_code IN VARCHAR2
198 ,p_org_information1 IN VARCHAR2 DEFAULT null
199 ,p_org_information2 IN VARCHAR2 DEFAULT null
200 ,p_org_information3 IN VARCHAR2 DEFAULT null
201 ,p_org_information4 IN VARCHAR2 DEFAULT null
202 ,p_org_information5 IN VARCHAR2 DEFAULT null
203 ,p_org_information6 IN VARCHAR2 DEFAULT null
204 ,p_org_information7 IN VARCHAR2 DEFAULT null
205 ,p_org_information8 IN VARCHAR2 DEFAULT null
206 ,p_org_information9 IN VARCHAR2 DEFAULT null
207 ,p_org_information10 IN VARCHAR2 DEFAULT null
208 );
209 PROCEDURE VALIDATE_UPDATE_ORG_INF(
210 p_effective_date IN DATE
211 ,p_org_information_id IN NUMBER
212 ,p_org_info_type_code IN VARCHAR2
213 ,p_org_information1 IN VARCHAR2 DEFAULT null
214 ,p_org_information2 IN VARCHAR2 DEFAULT null
215 ,p_org_information3 IN VARCHAR2 DEFAULT null
216 ,p_org_information4 IN VARCHAR2 DEFAULT null
217 ,p_org_information5 IN VARCHAR2 DEFAULT null
218 ,p_org_information6 IN VARCHAR2 DEFAULT null
219 ,p_org_information7 IN VARCHAR2 DEFAULT null
220 ,p_org_information8 IN VARCHAR2 DEFAULT null
221 ,p_org_information9 IN VARCHAR2 DEFAULT null
222 ,p_org_information10 IN VARCHAR2 DEFAULT null
223 );
224 --
225 /*PROCEDURE previous_employer_validate
226 (p_employer_name IN varchar2 default hr_api.g_varchar2
227 ,p_effective_date IN date default hr_api.g_date
228 ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
229 ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
230 );
231
232 PROCEDURE ASSIGNMENT_VALIDATE(
233 p_segment2 IN VARCHAR2
234 ,p_effective_date IN DATE
235 ,p_assignment_id IN NUMBER
236 );*/
237
238 PROCEDURE create_address_validate
239 (p_style IN VARCHAR2
240 ,p_person_id IN NUMBER
241 ,p_effective_date IN DATE
242 ,p_address_line3 IN VARCHAR2
243 ,p_town_or_city IN VARCHAR2
244 ,p_region_1 IN VARCHAR2);
245
246 PROCEDURE update_address_validate
247 (p_address_id IN NUMBER
248 ,p_effective_date IN DATE
249 ,p_address_line3 IN VARCHAR2
250 ,p_town_or_city IN VARCHAR2
251 ,p_region_1 IN VARCHAR2);
252
253 PROCEDURE create_location_validate
254 (p_style IN VARCHAR2
255 ,p_business_group_id IN NUMBER
256 ,p_effective_date IN DATE
257 ,p_address_line_3 IN VARCHAR2
258 ,p_town_or_city IN VARCHAR2
259 ,p_region_1 IN VARCHAR2);
260
261 PROCEDURE update_location_validate
262 (p_style IN VARCHAR2
263 ,p_location_id IN NUMBER
264 ,p_effective_date IN DATE
265 ,p_address_line_3 IN VARCHAR2
266 ,p_town_or_city IN VARCHAR2
267 ,p_region_1 IN VARCHAR2);
268
269 PROCEDURE update_asg_validate
270 (p_effective_date IN DATE
271 ,p_assignment_id IN NUMBER
272 ,p_segment1 IN VARCHAR2
273 ,p_segment2 IN VARCHAR2
274 ,p_segment3 IN VARCHAR2
275 ,p_segment4 IN VARCHAR2
276 ,p_segment5 IN VARCHAR2);
277
278 PROCEDURE CREATE_DISABILITY_VALIDATE
279 (p_effective_date IN DATE
280 ,p_person_id IN NUMBER
281 ,p_category IN VARCHAR2
282 ,p_degree IN NUMBER DEFAULT NULL
283 ,p_dis_information_category IN VARCHAR2 DEFAULT NULL
284 ,p_dis_information1 IN VARCHAR2 DEFAULT NULL
285 ,p_dis_information2 IN VARCHAR2 DEFAULT NULL);
286
287 PROCEDURE UPDATE_DISABILITY_VALIDATE
288 (p_effective_date IN DATE
289 ,p_disability_id IN NUMBER
290 ,p_category IN VARCHAR2
291 ,p_degree IN NUMBER DEFAULT NULL
292 ,p_dis_information_category IN VARCHAR2 DEFAULT NULL
293 ,p_dis_information1 IN VARCHAR2 DEFAULT NULL
294 ,p_dis_information2 IN VARCHAR2 DEFAULT NULL);
295
296 PROCEDURE CREATE_PAYMENT_METHOD_VALIDATE
297 (P_EFFECTIVE_DATE IN DATE
298 ,P_ASSIGNMENT_ID IN NUMBER
299 ,P_ORG_PAYMENT_METHOD_ID IN NUMBER
300 ,P_PPM_INFORMATION1 IN VARCHAR2 DEFAULT NULL);
301
302 PROCEDURE UPDATE_PAYMENT_METHOD_VALIDATE
303 (P_EFFECTIVE_DATE IN DATE
304 ,P_PERSONAL_PAYMENT_METHOD_ID IN NUMBER
305 ,P_PPM_INFORMATION1 IN VARCHAR2);
306
307 END HR_AE_VALIDATE_PKG;
308
[Home] [Help]