[Home] [Help]
PACKAGE: APPS.PER_ZA_USER_HOOK_PKG
Source
1 PACKAGE PER_ZA_USER_HOOK_PKG AUTHID CURRENT_USER AS
2 /* $Header: pezauhkp.pkh 120.7 2010/10/28 14:09:09 bkeshary ship $ */
3
4 -------------------------------------------------------------------------------
5 -- validate_applicant
6 -------------------------------------------------------------------------------
7 -- Description:
8 -- Create applicant, before process user hook for South Africa
9 -- Called from:
10 -- hr_applicant_api before process user hooks
11 -- Person DDF segments used :
12 -- SEGMENT NAME
13 -- ------- ----
14 -- PER_INFORMATION4 Race
15 --
16 ---------------------------------------------------------------------------
17 -- --
18 ---------------------------------------------------------------------------
19 PROCEDURE validate_applicant
20 ( p_business_group_id
21 in per_all_people_f.business_group_id%type default null
22 , p_date_received
23 in date
24 , p_person_type_id
25 in per_all_people_f.person_type_id%type default null
26 , p_per_information_category
27 in per_all_people_f.per_information_category%type default null
28 , p_per_information2
29 in per_all_people_f.per_information2%type default null
30 , p_per_information4
31 in per_all_people_f.per_information4%type default null
32 , p_per_information10
33 in per_all_people_f.per_information10%type default null
34 , p_email_address
35 in per_all_people_f.email_address%type default null
36 );
37 -------------------------------------------------------------------------------
38 -- validate_employee
39 -------------------------------------------------------------------------------
40 -- Description:
41 -- Create employee, before process user hook for South Africa.
42 -- Called from:
43 -- hr_employee_api before process user hook
44 -- Person DDF segments used :
45 -- SEGMENT NAME
46 -- ------- ----
47 -- PER_INFORMATION4 Race
48 --
49 ---------------------------------------------------------------------------
50 -- --
51 ---------------------------------------------------------------------------
52 PROCEDURE validate_employee
53 ( p_business_group_id
54 in per_all_people_f.business_group_id%type default null
55 , p_hire_date
56 in date
57 , p_person_type_id
58 in per_all_people_f.person_type_id%type default null
59 , p_per_information_category
60 in per_all_people_f.per_information_category%type default null
61 , p_per_information2
62 in per_all_people_f.per_information2%type default null
63 , p_per_information4
64 in per_all_people_f.per_information4%type default null
65 , p_per_information10
66 in per_all_people_f.per_information10%type default null
67 , p_email_address
68 in per_all_people_f.email_address%type default null
69 , p_per_information12
70 in per_all_people_f.per_information12%type default null
71 , p_last_name
72 in per_all_people_f.last_name%type default null
73 , p_first_name
74 in per_all_people_f.first_name%type default null
75 , p_middle_names
76 in per_all_people_f.MIDDLE_NAMES%type default null
77 , p_employee_number
78 in per_all_people_f.EMPLOYEE_NUMBER%type default null
79 , p_national_identifier
80 in per_all_people_f.NATIONAL_IDENTIFIER%type default null
81 , p_per_information1
82 in per_all_people_f.per_information1%type default null
83 , p_date_of_birth
84 in per_all_people_f.date_of_birth%type default null
85 );
86 -------------------------------------------------------------------------------
87 -- validate_cwk
88 -------------------------------------------------------------------------------
89 -- Description:
90 -- Create contingent worker, before process user hook for South Africa.
91 -- Called from:
92 -- hr_contingent_worker_api before process user hook
93 -- Person DDF segments used :
94 -- SEGMENT NAME
95 -- ------- ----
96 -- PER_INFORMATION4 Race
97 --
98 ---------------------------------------------------------------------------
99 -- --
100 ---------------------------------------------------------------------------
101 PROCEDURE validate_cwk
102 ( p_business_group_id
103 in per_all_people_f.business_group_id%type default null
104 , p_start_date
105 in date
106 , p_person_type_id
107 in per_all_people_f.person_type_id%type default null
108 , p_per_information_category
109 in per_all_people_f.per_information_category%type default null
110 , p_per_information2
111 in per_all_people_f.per_information2%type default null
112 , p_per_information4
113 in per_all_people_f.per_information4%type default null
114 , p_per_information10
115 in per_all_people_f.per_information10%type default null
116 , p_email_address
117 in per_all_people_f.email_address%type default null
118 );
119 -------------------------------------------------------------------------------
120 -- validate_person
121 -------------------------------------------------------------------------------
122 -- Description:
123 -- Validates person's email_id for South Africa.
124 -- Called from:
125 -- 1) PERZAOBJ ( Person
126 -- Person DDF segments used :
127 -- SEGMENT NAME
128 -- ------- ----
129 -- PER_INFORMATION4 Race
130 --
131 ---------------------------------------------------------------------------
132 -- --
133 ---------------------------------------------------------------------------
134 PROCEDURE validate_person
135 ( p_person_id
136 in per_all_people_f.person_id%type
137 , p_effective_date
138 in date
139 , p_person_type_id
140 in per_all_people_f.person_type_id%type
141 , p_per_information_category
142 in per_all_people_f.per_information_category%type
143 , p_per_information2
144 in per_all_people_f.per_information2%type default null
145 , p_per_information4
146 in per_all_people_f.per_information4%type
147 , p_per_information10
148 in per_all_people_f.per_information10%type default null
149 , p_email_address
150 in per_all_people_f.email_address%type default null
151 , p_per_information12
152 in per_all_people_f.per_information12%type default null
153 , p_last_name
154 in per_all_people_f.last_name%type default null
155 , p_first_name
156 in per_all_people_f.first_name%type default null
157 , p_middle_names
158 in per_all_people_f.MIDDLE_NAMES%type default null
159 , p_employee_number
160 in per_all_people_f.EMPLOYEE_NUMBER%type default null
161 , p_national_identifier
162 in per_all_people_f.NATIONAL_IDENTIFIER%type default null
163 , p_per_information1
164 in per_all_people_f.per_information1%type default null
165 , p_date_of_birth
166 in per_all_people_f.date_of_birth%type default null
167 );
168 -------------------------------------------------------------------------------
169 -- validate_email_id
170 -------------------------------------------------------------------------------
171 -- Description:
172 -- Validates person's email_id for South Africa.
173 -- Called from:
174 -- 1) PERZAOBJ ( ZA specific code for Person Form)
175 -- 2) Person create/update APIs Before Hook process
176 --
177 ---------------------------------------------------------------------------
178 -- --
179 ---------------------------------------------------------------------------
180 procedure validate_email_id (p_email_id varchar2);
181 -------------------------------------------------------------------------------
182 -- validate_phone_no
183 -------------------------------------------------------------------------------
184 -- Description:
185 -- Validates phone numbers for South Africa.
186 -- Called from:
187 -- PER_PHONES before create and before update APIs
188 --
189 ---------------------------------------------------------------------------
190 -- --
191 ---------------------------------------------------------------------------
192 procedure validate_phone_no ( p_phone_type in varchar2,
193 p_phone_number in varchar2);
194 -------------------------------------------------------------------------------
195 -- validate_asg_extra_info
196 -------------------------------------------------------------------------------
197 -- Description:
198 -- Validates Assignment Extra Information for South Africa.
199 -- Called from:
200 -- create_za_assign_extra_info and update_za_assign_extra_info
201 -- Assignment EIT segments used :
202 -- SEGMENT NAME
203 -- ------- ----
204 -- AEI_ATTRIBUTE2 Employee Trade Name
205 -- AEI_INFORMATION4 Nature of Person
206 -- AEI_ATTRIBUTE13 Payment Type
207 -- AEI_INFORMATION14 SARS Reporting Account Number
208 ---------------------------------------------------------------------------
209 -- --
210 ---------------------------------------------------------------------------
211 procedure validate_asg_extra_info (P_AEI_INFORMATION_CATEGORY in VARCHAR2
212 , P_AEI_INFORMATION2 in VARCHAR2
213 , P_AEI_INFORMATION4 in VARCHAR2
214 , P_AEI_INFORMATION13 in VARCHAR2
215 , P_AEI_INFORMATION14 in VARCHAR2);
216 -------------------------------------------------------------------------------
217
218 -------------------------------------------------------------------------------
219 -- validate_asg_extra_info
220 -------------------------------------------------------------------------------
221 -- Description:
222 -- Validates Assignment Extra Information for South Africa.
223 -- Called from:
224 -- CREATE_ASSIGNMENT_EXTRA_INFO
225 -- Assignment EIT segments used :
226 -- SEGMENT NAME
227 -- ------- ----
228 -- ASSIGNMENT_ID Assignment ID
229 -- AEI_INFORMATION_CATEGORY Assignment Information Cateogry
230 -- AEI_ATTRIBUTE2 Employee Trade Name
231 -- AEI_INFORMATION4 Nature of Person
232 -- AEI_ATTRIBUTE13 Payment Type
233 -- AEI_INFORMATION14 SARS Reporting Account Number
234 ---------------------------------------------------------------------------
235 -- --
236 ---------------------------------------------------------------------------
237
238 procedure create_za_assign_extra_info(p_assignment_id in number
239 ,P_AEI_INFORMATION_CATEGORY in VARCHAR2
240 , P_AEI_INFORMATION2 in VARCHAR2
241 , P_AEI_INFORMATION4 in VARCHAR2
242 , P_AEI_INFORMATION13 in VARCHAR2
243 , P_AEI_INFORMATION14 in VARCHAR2);
244 --
245
246 -------------------------------------------------------------------------------
247 -- validate_asg_extra_info
248 -------------------------------------------------------------------------------
249 -- Description:
250 -- Validates Assignment Extra Information for South Africa.
251 -- Called from:
252 -- UPDATE_ASSIGNMENT_EXTRA_INFO APIs
253 -- Assignment EIT segments used :
254 -- SEGMENT NAME
255 -- ------- ----
256 -- ASSIGNMENT_EXTRA_INFO_ID Assignment Extra Info ID
257 -- AEI_INFORMATION_CATEGORY Assignment Information Category
258 -- AEI_ATTRIBUTE2 Employee Trade Name
259 -- AEI_INFORMATION4 Nature of Person
260 -- AEI_ATTRIBUTE13 Payment Type
261 -- AEI_INFORMATION14 SARS Reporting Account Number
262 ---------------------------------------------------------------------------
263 -- --
264 ---------------------------------------------------------------------------
265 procedure update_za_assign_extra_info(P_ASSIGNMENT_EXTRA_INFO_ID in number
266 ,P_AEI_INFORMATION_CATEGORY in VARCHAR2
267 , P_AEI_INFORMATION2 in VARCHAR2
268 , P_AEI_INFORMATION4 in VARCHAR2
269 , P_AEI_INFORMATION13 in VARCHAR2
270 , P_AEI_INFORMATION14 in VARCHAR2);
271
272 -------------------------------------------------------------------------------
273 -- validate_charcter_set
274 -------------------------------------------------------------------------------
275 -- Description:
276 -- Validates Character Sets for South Africa.
277 --
278 ---------------------------------------------------------------------------
279 -- --
280 ---------------------------------------------------------------------------
281 function validate_charcter_set (p_input_value in varchar2
282 , p_mode in varchar2 ) return boolean ;
283
284 -------------------------------------------------------------------------------
285 -- validate_person_address
286 -------------------------------------------------------------------------------
287 -- Description:
288 -- Validates Personal address for Address Style 'South Africa'.
289 -- Called from:
290 -- CREATE_PERSON_ADDRESS and UPDATE_PERS_ADDR_WITH_STYLE APIs
291 ---------------------------------------------------------------------------
292 -- --
293 ---------------------------------------------------------------------------
294 procedure validate_person_address (P_STYLE in varchar2
295 ,P_ADDRESS_TYPE in varchar2
296 ,P_PRIMARY_FLAG in varchar2
297 ,P_ADDRESS_LINE1 in varchar2
298 ,P_ADDRESS_LINE2 in varchar2
299 ,P_ADDRESS_LINE3 in varchar2
300 ,P_TELEPHONE_NUMBER_1 in varchar2
301 ,P_REGION_1 in varchar2
302 ,P_REGION_2 in varchar2
303 ,P_TOWN_OR_CITY in varchar2
304 ,P_POSTAL_CODE in varchar2);
305 -------------------------------------------------------------------------------
306 -- validate_location_extra_info
307 -------------------------------------------------------------------------------
308 -- Description:
309 -- Validates Location EIT address for Address Style 'South Africa - SARS'.
310 -- Called from:
311 -- CREATE_LOCATION_EXTRA_INFO and UPDATE_LOCATION_EXTRA_INFO APIs
312 ---------------------------------------------------------------------------
313 -- --
314 ---------------------------------------------------------------------------
315 procedure validate_location_extra_info (
316 P_LEI_INFORMATION_CATEGORY in varchar2,
317 P_LEI_INFORMATION1 in varchar2,
318 P_LEI_INFORMATION2 in varchar2,
319 P_LEI_INFORMATION3 in varchar2,
320 P_LEI_INFORMATION4 in varchar2,
321 P_LEI_INFORMATION5 in varchar2,
322 P_LEI_INFORMATION6 in varchar2,
323 P_LEI_INFORMATION7 in varchar2);
324 -------------------------------------------------------------------------------
325 -- validate_org_info
326 -------------------------------------------------------------------------------
327 -- Description:
328 -- Validate Organization Information
329 -- Called from:
330 -- CREATE_ORG_INFORMATION and UPDATE_ORG_INFORMATION
331 --
332 ---------------------------------------------------------------------------
333 -- --
334 ---------------------------------------------------------------------------
335 procedure validate_org_info (p_org_info_type_code IN VARCHAR2
336 ,p_org_information1 IN VARCHAR2
337 ,p_org_information2 IN VARCHAR2
338 ,p_org_information3 IN VARCHAR2
339 ,p_org_information4 IN VARCHAR2
340 ,p_org_information5 IN VARCHAR2
341 ,p_org_information6 IN VARCHAR2
342 ,p_org_information7 IN VARCHAR2
343 ,p_org_information8 IN VARCHAR2
344 ,p_org_information9 IN VARCHAR2
345 ,p_org_information10 IN VARCHAR2
346 ,p_org_information11 IN VARCHAR2
347 ,p_org_information12 IN VARCHAR2
348 ,p_org_information13 IN VARCHAR2
349 ,p_org_information14 IN VARCHAR2 -- 9864910 fix
350 ,p_org_information15 IN VARCHAR2 -- 9864910 fix
351 ,p_org_information16 IN VARCHAR2 -- 9864910 fix
352 ,p_org_information17 IN VARCHAR2); -- 9815318 fix
353 ----------------------------------------------------------------------------
354 -- validate_update_per_payment
355 -- Description:
356 -- Validates Personal Payment DDF
357 -- Called from:
358 -- UPDATE_PERSONAL_PAY_METHOD
359
360 ----------------------------------------------------------------------------
361 procedure validate_update_per_payment (P_EFFECTIVE_DATE IN DATE
362 ,P_EFFECTIVE_START_DATE IN DATE
363 ,P_EFFECTIVE_END_DATE IN DATE
364 ,P_PERSONAL_PAYMENT_METHOD_ID IN NUMBER
365 ,P_PPM_INFORMATION1 IN VARCHAR2);
366
367
368
369 ----------------------------------------------------------------------------
370 -- validate_create_per_payment
371 -- Description:
372 -- Validates Personal Payment DDF
373 -- Called from:
374 -- CREATE_PERSONAL_PAY_METHOD
375
376 ----------------------------------------------------------------------------
377 procedure validate_create_per_payment (P_EFFECTIVE_START_DATE IN DATE
378 ,P_EFFECTIVE_END_DATE IN DATE
379 ,P_ASSIGNMENT_ID IN NUMBER
380 ,P_PERSONAL_PAYMENT_METHOD_ID IN NUMBER
381 ,P_PPM_INFORMATION1 IN VARCHAR2 DEFAULT NULL);
382
383
384
385 END per_za_user_hook_pkg;