1 PACKAGE hr_no_validate_pkg AS
2 /* $Header: penovald.pkh 120.5.12010000.2 2008/08/06 09:17:07 ubhat ship $ */
3
4 PROCEDURE person_validate
5 (p_person_type_id in number
6 ,p_first_name in varchar2 default null
7 ,p_national_identifier in varchar2 default null
8 );
9
10 PROCEDURE applicant_validate
11 (p_business_group_id in number
12 ,p_person_type_id in number
13 ,p_first_name in varchar2 default null
14 ,p_national_identifier in varchar2 default null
15 );
16
17 PROCEDURE employee_validate
18 (p_business_group_id in number
19 ,p_person_type_id in number
20 ,p_first_name in varchar2 default null
21 ,p_national_identifier in varchar2 default null
22 );
23
24 PROCEDURE cwk_validate
25 (p_business_group_id in number
26 ,p_person_type_id in number
27 ,p_first_name in varchar2 default null
28 ,p_national_identifier in varchar2 default null
29 );
30
31 /*
32
33 PROCEDURE validate_create_org_inf
34 (p_org_info_type_code in varchar2
35 ,p_organization_id in number
36 ,p_org_information1 in varchar2
37 ) ;
38
39
40 PROCEDURE validate_update_org_inf
41 (p_org_info_type_code in varchar2
42 ,p_org_information_id in number
43 ,p_org_information1 in varchar2
44 );
45
46 */
47
48 /* Bug Fix 4463101 */
49
50 PROCEDURE validate_create_org_inf
51 (p_org_info_type_code in varchar2
52 ,p_organization_id in number
53 ,p_org_information1 in varchar2
54 ,p_org_information2 in varchar2
55 ,p_org_information3 in varchar2
56 ,p_org_information4 in varchar2
57 ,p_org_information5 in varchar2
58 ,p_org_information6 in varchar2
59 ,p_org_information7 in varchar2
60 ,p_org_information8 in varchar2
61 ,p_org_information9 in varchar2
62 ,p_org_information10 in varchar2
63 ,p_org_information11 in varchar2
64 ,p_org_information12 in varchar2
65 ,p_org_information13 in varchar2
66 ,p_org_information14 in varchar2
67 ,p_org_information15 in varchar2
68 ,p_org_information16 in varchar2
69 ,p_org_information17 in varchar2
70 ,p_org_information18 in varchar2
71 ,p_org_information19 in varchar2
72 ,p_org_information20 in varchar2
73 ) ;
74 /* Bug Fix 4463101 */
75
76 PROCEDURE validate_update_org_inf
77 (p_org_info_type_code in varchar2
78 ,p_org_information_id in number
79 ,p_org_information1 in varchar2
80 ,p_org_information2 in varchar2
81 ,p_org_information3 in varchar2
82 ,p_org_information4 in varchar2
83 ,p_org_information5 in varchar2
84 ,p_org_information6 in varchar2
85 ,p_org_information7 in varchar2
86 ,p_org_information8 in varchar2
87 ,p_org_information9 in varchar2
88 ,p_org_information10 in varchar2
89 ,p_org_information11 in varchar2
90 ,p_org_information12 in varchar2
91 ,p_org_information13 in varchar2
92 ,p_org_information14 in varchar2
93 ,p_org_information15 in varchar2
94 ,p_org_information16 in varchar2
95 ,p_org_information17 in varchar2
96 ,p_org_information18 in varchar2
97 ,p_org_information19 in varchar2
98 ,p_org_information20 in varchar2
99 );
100
101 PROCEDURE qual_insert_validate
102 (p_business_group_id in number
103 ,p_qualification_type_id in number
104 ,p_qua_information_category in varchar2 default null
105 ,p_person_id in number
106 ,p_qua_information1 in varchar2 default null
107 ,p_qua_information2 in varchar2 default null
108 );
109
110 PROCEDURE qual_update_validate
111 (p_qua_information_category in varchar2 default null
112 ,p_qualification_id in number
113 ,p_qualification_type_id in number
114 ,p_qua_information1 in varchar2 default null
115 ,p_qua_information2 in varchar2 default null
116 );
117
118 PROCEDURE validate_create_org_cat
119 (p_organization_id in number
120 ,p_org_information1 in varchar2
121 ) ;
122
123 PROCEDURE create_contract_validate
124 (p_status in varchar2
125 ,p_effective_date in date
126 ,p_ctr_information_category in varchar2 default null
127 ,p_ctr_information1 in varchar2 default null
128 ) ;
129
130 PROCEDURE update_contract_validate
131 (p_contract_id in number default null
132 ,p_status in varchar2
133 ,p_effective_date in date
134 ,p_ctr_information_category in varchar2 default null
135 ,p_ctr_information1 in varchar2 default null
136 ) ;
137
138 PROCEDURE workinc_validate
139 (p_incident_date in date
140 ,p_inc_information_category in varchar2 default null
141 ,p_inc_information1 in varchar2 default null
142 ,p_inc_information2 in varchar2 default null
143 ) ;
144
145 PROCEDURE create_asg_validate
146 ( p_scl_segment12 IN VARCHAR2 DEFAULT NULL
147 ,p_scl_segment13 IN VARCHAR2 DEFAULT NULL
148 ,p_scl_segment14 IN VARCHAR2 DEFAULT NULL
149 ,p_effective_date IN DATE
150 ,p_person_id IN NUMBER
151 ) ;
152
153 PROCEDURE update_asg_validate
154 ( p_segment12 IN VARCHAR2 DEFAULT NULL
155 ,p_segment13 IN VARCHAR2 DEFAULT NULL
156 ,p_segment14 IN VARCHAR2 DEFAULT NULL
157 ,p_effective_date IN DATE
158 ,p_assignment_id IN NUMBER
159 ) ;
160
161 PROCEDURE CREATE_ELEMENT_ELE_CODE
162 (p_information_type IN VARCHAR2
163 ,p_element_type_id IN NUMBER
164 ,p_eei_attribute_category IN VARCHAR2
165 ,p_eei_attribute1 IN VARCHAR2
166 ,p_eei_attribute2 IN VARCHAR2
167 ,p_eei_attribute3 IN VARCHAR2
168 ,p_eei_attribute4 IN VARCHAR2
169 ,p_eei_attribute5 IN VARCHAR2
170 ,p_eei_attribute6 IN VARCHAR2
171 ,p_eei_attribute7 IN VARCHAR2
172 ,p_eei_attribute8 IN VARCHAR2
173 ,p_eei_attribute9 IN VARCHAR2
174 ,p_eei_attribute10 IN VARCHAR2
175 ,p_eei_attribute11 IN VARCHAR2
176 ,p_eei_attribute12 IN VARCHAR2
177 ,p_eei_attribute13 IN VARCHAR2
178 ,p_eei_attribute14 IN VARCHAR2
179 ,p_eei_attribute15 IN VARCHAR2
180 ,p_eei_attribute16 IN VARCHAR2
181 ,p_eei_attribute17 IN VARCHAR2
182 ,p_eei_attribute18 IN VARCHAR2
183 ,p_eei_attribute19 IN VARCHAR2
184 ,p_eei_attribute20 IN VARCHAR2
185 ,p_eei_information_category IN VARCHAR2
186 ,p_eei_information1 IN VARCHAR2
187 ,p_eei_information2 IN VARCHAR2
188 ,p_eei_information3 IN VARCHAR2
189 ,p_eei_information4 IN VARCHAR2
190 ,p_eei_information5 IN VARCHAR2
191 ,p_eei_information6 IN VARCHAR2
192 ,p_eei_information7 IN VARCHAR2
193 ,p_eei_information8 IN VARCHAR2
194 ,p_eei_information9 IN VARCHAR2
195 ,p_eei_information10 IN VARCHAR2
196 ,p_eei_information11 IN VARCHAR2
197 ,p_eei_information12 IN VARCHAR2
198 ,p_eei_information13 IN VARCHAR2
199 ,p_eei_information14 IN VARCHAR2
200 ,p_eei_information15 IN VARCHAR2
201 ,p_eei_information16 IN VARCHAR2
202 ,p_eei_information17 IN VARCHAR2
203 ,p_eei_information18 IN VARCHAR2
204 ,p_eei_information19 IN VARCHAR2
205 ,p_eei_information20 IN VARCHAR2
206 ,p_eei_information21 IN VARCHAR2
207 ,p_eei_information22 IN VARCHAR2
208 ,p_eei_information23 IN VARCHAR2
209 ,p_eei_information24 IN VARCHAR2
210 ,p_eei_information25 IN VARCHAR2
211 ,p_eei_information26 IN VARCHAR2
212 ,p_eei_information27 IN VARCHAR2
213 ,p_eei_information28 IN VARCHAR2
214 ,p_eei_information29 IN VARCHAR2
215 ,p_eei_information30 IN VARCHAR2
216 ) ;
217
218 PROCEDURE UPDATE_ELEMENT_ELE_CODE
219 (p_element_type_extra_info_id IN NUMBER
220 ,p_eei_attribute_category IN VARCHAR2
221 ,p_eei_attribute1 IN VARCHAR2
222 ,p_eei_attribute2 IN VARCHAR2
223 ,p_eei_attribute3 IN VARCHAR2
224 ,p_eei_attribute4 IN VARCHAR2
225 ,p_eei_attribute5 IN VARCHAR2
226 ,p_eei_attribute6 IN VARCHAR2
227 ,p_eei_attribute7 IN VARCHAR2
228 ,p_eei_attribute8 IN VARCHAR2
229 ,p_eei_attribute9 IN VARCHAR2
230 ,p_eei_attribute10 IN VARCHAR2
231 ,p_eei_attribute11 IN VARCHAR2
232 ,p_eei_attribute12 IN VARCHAR2
233 ,p_eei_attribute13 IN VARCHAR2
234 ,p_eei_attribute14 IN VARCHAR2
235 ,p_eei_attribute15 IN VARCHAR2
236 ,p_eei_attribute16 IN VARCHAR2
237 ,p_eei_attribute17 IN VARCHAR2
238 ,p_eei_attribute18 IN VARCHAR2
239 ,p_eei_attribute19 IN VARCHAR2
240 ,p_eei_attribute20 IN VARCHAR2
241 ,p_eei_information_category IN VARCHAR2
242 ,p_eei_information1 IN VARCHAR2
243 ,p_eei_information2 IN VARCHAR2
244 ,p_eei_information3 IN VARCHAR2
245 ,p_eei_information4 IN VARCHAR2
246 ,p_eei_information5 IN VARCHAR2
247 ,p_eei_information6 IN VARCHAR2
248 ,p_eei_information7 IN VARCHAR2
249 ,p_eei_information8 IN VARCHAR2
250 ,p_eei_information9 IN VARCHAR2
251 ,p_eei_information10 IN VARCHAR2
252 ,p_eei_information11 IN VARCHAR2
253 ,p_eei_information12 IN VARCHAR2
254 ,p_eei_information13 IN VARCHAR2
255 ,p_eei_information14 IN VARCHAR2
256 ,p_eei_information15 IN VARCHAR2
257 ,p_eei_information16 IN VARCHAR2
258 ,p_eei_information17 IN VARCHAR2
259 ,p_eei_information18 IN VARCHAR2
260 ,p_eei_information19 IN VARCHAR2
261 ,p_eei_information20 IN VARCHAR2
262 ,p_eei_information21 IN VARCHAR2
263 ,p_eei_information22 IN VARCHAR2
264 ,p_eei_information23 IN VARCHAR2
265 ,p_eei_information24 IN VARCHAR2
266 ,p_eei_information25 IN VARCHAR2
267 ,p_eei_information26 IN VARCHAR2
268 ,p_eei_information27 IN VARCHAR2
269 ,p_eei_information28 IN VARCHAR2
270 ,p_eei_information29 IN VARCHAR2
271 ,p_eei_information30 IN VARCHAR2
272 ,p_object_version_number IN NUMBER
273 ) ;
274
275
276 PROCEDURE update_ele_entry_bp
277 ( p_effective_date IN DATE
278 ) ;
279
280 PROCEDURE create_ele_entry_bp
281 ( p_effective_date IN DATE
282 ) ;
283
284 PROCEDURE update_ele_entry_ap
285 ( p_effective_date IN DATE
286 ) ;
287
288 PROCEDURE create_ele_entry_ap
289 ( p_effective_date IN DATE
290 ) ;
291
292 END hr_no_validate_pkg;