1 package hr_ru_applicant_api AUTHID CURRENT_USER as
2 /* $Header: peapprui.pkh 120.1 2005/10/02 02:38:17 aroussel $ */
3 /*#
4 * This package contains applicant APIs for Russia.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Applicant for Russia
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |---------------------------< create_ru_applicant >------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a new applicant for Russia.
17 *
18 * This API also creates an application, a default applicant assignment, and if
19 * required, associated assignment budget values, and a letter request. The
20 * applicant is added to security lists so that secure users can see them. If a
21 * valid person_type_id is specified with a corresponding system type of 'APL',
22 * it must be active and in the same business group as that of the applicant
23 * being created. If a person_type_id is not specified, the API will use the
24 * default 'APL' type for the business group.
25 *
26 * <p><b>Licensing</b><br>
27 * This API is licensed for use with Human Resources.
28 *
29 * <p><b>Prerequisites</b><br>
30 * A valid business group id must exist for Russia.
31 *
32 * <p><b>Post Success</b><br>
33 * The applicant record is successfully created in the database.
34 *
35 * <p><b>Post Failure</b><br>
36 * The API does not create an applicant and raises an error.
37 *
38 * @param p_validate If true, then validation alone will be performed and the
39 * database will remain unchanged. If false and all validation checks pass,
40 * then the database will be modified.
41 * @param p_date_received The date an application was received and therefore
42 * the effective start date of the person, application, and assignment.
43 * @param p_business_group_id The applicant's business group.
44 * @param p_last_name The applicant's last name.
45 * @param p_person_type_id This is the identifier corresponding to the type of
46 * person. If an identification number is not specified, then the API will use
47 * the default 'APL' type for the business group.
48 * @param p_applicant_number If the number generation method is manual, then
49 * this parameter is mandatory. If the number generation method is automatic,
50 * then the value of this parameter must be NULL. If p_validate is false and
51 * the applicant number generation method is automatic, this will be set to to
52 * the generated applicant number of the person created. If p_validate is false
53 * and the applicant number generation method is manual, this will be set to
54 * the same value passed in. If p_validate is true, this will be set to the
55 * same value which was passed in.
56 * @param p_per_comments Comments for the person record.
57 * @param p_date_employee_data_verified Date when the applicant last verified
58 * the data.
59 * @param p_date_of_birth Date of birth.
60 * @param p_email_address E-mail address of the applicant.
61 * @param p_expense_check_send_to_addres Address to use as the mailing address.
62 * @param p_first_name Applicant's first name.
63 * @param p_known_as Applicant's alternative name.
64 * @param p_marital_status The marital status of the applicant. Valid values
65 * are defined by the 'MAR_STATUS' lookup type.
66 * @param p_middle_names Applicant's middle name(s).
67 * @param p_nationality Applicant's nationality. Valid values are defined by
68 * the 'NATIONALITY' lookup type.
69 * @param p_inn National identifier.
70 * @param p_previous_last_name Applicant's previous last name.
71 * @param p_registered_disabled_flag Indicates whether person is classified as
72 * disabled. Valid values are defined by the 'REGISTERED_DISABLED' lookup type.
73 * @param p_sex The sex of the applicant.
74 * @param p_title The title of the applicant. Valid values are defined by the
75 * 'TITLE' lookup type.
76 * @param p_work_telephone Work telephone of the applicant.
77 * @param p_attribute_category This context value determines which flexfield
78 * structure to use with the descriptive flexfield segments.
79 * @param p_attribute1 Descriptive flexfield segment.
80 * @param p_attribute2 Descriptive flexfield segment.
81 * @param p_attribute3 Descriptive flexfield segment.
82 * @param p_attribute4 Descriptive flexfield segment.
83 * @param p_attribute5 Descriptive flexfield segment.
84 * @param p_attribute6 Descriptive flexfield segment.
85 * @param p_attribute7 Descriptive flexfield segment.
86 * @param p_attribute8 Descriptive flexfield segment.
87 * @param p_attribute9 Descriptive flexfield segment.
88 * @param p_attribute10 Descriptive flexfield segment.
89 * @param p_attribute11 Descriptive flexfield segment.
90 * @param p_attribute12 Descriptive flexfield segment.
91 * @param p_attribute13 Descriptive flexfield segment.
92 * @param p_attribute14 Descriptive flexfield segment.
93 * @param p_attribute15 Descriptive flexfield segment.
94 * @param p_attribute16 Descriptive flexfield segment.
95 * @param p_attribute17 Descriptive flexfield segment.
96 * @param p_attribute18 Descriptive flexfield segment.
97 * @param p_attribute19 Descriptive flexfield segment.
98 * @param p_attribute20 Descriptive flexfield segment.
99 * @param p_attribute21 Descriptive flexfield segment.
100 * @param p_attribute22 Descriptive flexfield segment.
101 * @param p_attribute23 Descriptive flexfield segment.
102 * @param p_attribute24 Descriptive flexfield segment.
103 * @param p_attribute25 Descriptive flexfield segment.
104 * @param p_attribute26 Descriptive flexfield segment.
105 * @param p_attribute27 Descriptive flexfield segment.
106 * @param p_attribute28 Descriptive flexfield segment.
107 * @param p_attribute29 Descriptive flexfield segment.
108 * @param p_attribute30 Descriptive flexfield segment.
109 * @param p_place_of_birth The applicant's place of birth.Valid values are
110 * defined by the 'RU_OKATO' lookup type.
111 * @param p_references References for the applicant in the case of re-hire.
112 * @param p_local_coefficient Valid for applicants who live in Last North or
113 * regions that are equated to Last North.
114 * @param p_citizenship Applicant's citizenship. Valid values exist in the
115 * 'RU_CITIZENSHIP' lookup type.
116 * @param p_military_doc Military documents for the applicant. Valid value
117 * exists in the 'RU_MILITARY_DOC_TYPE' lookup type.
118 * @param p_reserve_category Reserve category of the applicant. Valid value
119 * exists in the 'RU_RESERVE_CATEGORY' lookup type.
120 * @param p_military_rank Military rank of the applicant. Valid value exists in
121 * the 'RU_MILITARY_RANK' lookup type.
122 * @param p_military_profile Military profile of the applicant. Valid value
123 * exists in the 'RU_MILITARY_PROFILE' lookup type.
124 * @param p_military_reg_code Military registration board code of the
125 * applicant.
126 * @param p_mil_srvc_readiness_category Military readiness service category of
127 * the applicant. Valid value exists in the 'RU_MILITARY_SERVICE_READINESS'
128 * lookup type.
129 * @param p_military_commissariat Military commissariat of the applicant.
130 * @param p_quitting_mark Conscription dismissal mark of the applicant. Valid
131 * value exists in the 'RU_QUITTING_MARK' lookup type.
132 * @param p_military_unit_number Military unit number of the applicant.
133 * @param p_military_reg_type Military Registration Type. Valid Values exists
134 * in RU_MILITARY_REGISTRATION
135 * @param p_military_reg_details Military Registration Details
136 * @param p_pension_fund_number Pension Fund Number of the applicant.
137 * @param p_background_check_status Y/N flag indicating whether background
138 * check has been performed or not.
139 * @param p_background_date_check Date background check was performed.
140 * @param p_correspondence_language Preferred language for correspondence.
141 * @param p_fte_capacity This parameter is currently unsupported.
142 * @param p_hold_applicant_date_until Date up to which applicant's file is to
143 * be maintained.
144 * @param p_honors Honors or degrees awarded.
145 * @param p_mailstop Office identifier for internal mail.
146 * @param p_office_number Office number of the applicant.
147 * @param p_on_military_service Y/N flag indicating whether the applicant is
148 * employed in military service.
149 * @param p_genitive_last_name Genitive last name of the applicant.
150 * @param p_projected_start_date This parameter is currently unsupported.
151 * @param p_resume_exists Y/N flag indicating whether resume is on file.
152 * @param p_resume_last_updated Date when the resume was last updated.
153 * @param p_student_status Full time/part time status of student. Valid values
154 * are defined by the 'STUDENT_STATUS' lookup type.
155 * @param p_work_schedule Type of work schedule indicating days on which the
156 * person works. Valid values are defined by the 'WORK_SCHEDULE' lookup type.
157 * @param p_suffix This parameter is currently unsupported.
158 * @param p_date_of_death Date of death of the applicant.
159 * @param p_benefit_group_id Identification for the benefit group.
160 * @param p_receipt_of_death_cert_date Date when the death certificate was
161 * received.
162 * @param p_coord_ben_med_pln_no Coordination of benefits medical group plan
163 * number.
164 * @param p_coord_ben_no_cvg_flag Coordination of benefits no other coverage
165 * flag.
166 * @param p_uses_tobacco_flag Tobacco type used by the applicant. Valid values
167 * are defined by the 'TOBACCO_USER' lookup type.
168 * @param p_dpdnt_adoption_date Date dependent was adopted.
169 * @param p_dpdnt_vlntry_svce_flag Indicates whether the dependent is on
170 * voluntary service.
171 * @param p_original_date_of_hire Original date of hire of the applicant.
172 * @param p_town_of_birth Town or city of birth of the applicant.
173 * @param p_region_of_birth Geographical region of birth of the applicant.
174 * @param p_country_of_birth Country of birth of the applicant.
175 * @param p_global_person_id Global identification number for the person.
176 * @param p_party_id Identifier for the party.
177 * @param p_person_id If p_validate is false, then this uniquely identifies the
178 * person created. If p_validate is true, then set to null.
179 * @param p_assignment_id If p_validate is false, then this uniquely identifies
180 * the created assignment. If p_validate is true, then set to null.
181 * @param p_application_id If p_validate is false, then this uniquely
182 * identifies the application created. If p_validate is true, then this
183 * parameter will be null.
184 * @param p_per_object_version_number If p_validate is false, then set to the
185 * version number of the created person. If p_validate is true, then the value
186 * will be null.
187 * @param p_asg_object_version_number If p_validate is false, then this
188 * parameter is set to the version number of the assignment created. If
189 * p_validate is true, then this parameter is null.
190 * @param p_apl_object_version_number If p_validate is false, then this will be
191 * set to the version number of the application created. If p_validate is true,
192 * then this parameter will be set to null.
193 * @param p_per_effective_start_date If p_validate is false, then this will be
194 * set to the effective start date of the applicant. If p_validate is true,
195 * then this will be null.
196 * @param p_per_effective_end_date If p_validate is false, then this will be
197 * set to the effective end date of the applicant. If p_validate is true, then
198 * this will be null.
199 * @param p_full_name If p_validate is false, then this will be set to the
200 * complete full name of the applicant. If p_validate is true, then this will
201 * be null.
202 * @param p_per_comment_id If p_validate is false and comment text was
203 * provided, then this will be set to the identifier of the created applicant
204 * record. If p_validate is true or no comment text was provided, then this
205 * will be null.
206 * @param p_assignment_sequence If p_validate is false, then this will be set
207 * to the assignment sequence of the assignment created. If p_validate is true,
208 * this parameter is set to null.
209 * @param p_name_combination_warning If set to true, then the combination of
210 * last name, first name and date of birth existed prior to calling this API.
211 * @param p_orig_hire_warning Set to true if the original date of hire is not
212 * null and the person type is not EMP, EMP_APL, EX_EMP, or EX_EMP_APL.
213 * @rep:displayname Create Applicant for Russia
214 * @rep:category BUSINESS_ENTITY PER_APPLICANT
215 * @rep:lifecycle active
216 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
217 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
218 * @rep:scope public
219 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
220 */
221 --
222 -- {End Of Comments}
223 --
224 procedure create_ru_applicant(
225 p_validate in boolean default false
226 ,p_date_received in date
227 ,p_business_group_id in number
228 ,p_last_name in varchar2
229 ,p_person_type_id in number default null
230 ,p_applicant_number in out nocopy varchar2
231 ,p_per_comments in varchar2 default null
232 ,p_date_employee_data_verified in date default null
233 ,p_date_of_birth in date default null
234 ,p_email_address in varchar2 default null
235 ,p_expense_check_send_to_addres in varchar2 default null
236 ,p_first_name in varchar2
237 ,p_known_as in varchar2 default null
238 ,p_marital_status in varchar2 default null
239 ,p_middle_names in varchar2 default null
240 ,p_nationality in varchar2 default null
241 ,p_inn in varchar2 default null
242 ,p_previous_last_name in varchar2 default null
243 ,p_registered_disabled_flag in varchar2 default null
244 ,p_sex in varchar2 default null
245 ,p_title in varchar2 default null
246 ,p_work_telephone in varchar2 default null
247 ,p_attribute_category in varchar2 default null
248 ,p_attribute1 in varchar2 default null
252 ,p_attribute5 in varchar2 default null
249 ,p_attribute2 in varchar2 default null
250 ,p_attribute3 in varchar2 default null
251 ,p_attribute4 in varchar2 default null
253 ,p_attribute6 in varchar2 default null
254 ,p_attribute7 in varchar2 default null
255 ,p_attribute8 in varchar2 default null
256 ,p_attribute9 in varchar2 default null
257 ,p_attribute10 in varchar2 default null
258 ,p_attribute11 in varchar2 default null
259 ,p_attribute12 in varchar2 default null
260 ,p_attribute13 in varchar2 default null
261 ,p_attribute14 in varchar2 default null
262 ,p_attribute15 in varchar2 default null
263 ,p_attribute16 in varchar2 default null
264 ,p_attribute17 in varchar2 default null
265 ,p_attribute18 in varchar2 default null
266 ,p_attribute19 in varchar2 default null
267 ,p_attribute20 in varchar2 default null
268 ,p_attribute21 in varchar2 default null
269 ,p_attribute22 in varchar2 default null
270 ,p_attribute23 in varchar2 default null
271 ,p_attribute24 in varchar2 default null
272 ,p_attribute25 in varchar2 default null
273 ,p_attribute26 in varchar2 default null
274 ,p_attribute27 in varchar2 default null
275 ,p_attribute28 in varchar2 default null
276 ,p_attribute29 in varchar2 default null
277 ,p_attribute30 in varchar2 default null
278 ,p_place_of_birth in varchar2 default null
279 ,p_references in varchar2 default null
280 ,p_local_coefficient in varchar2 default null
281 ,p_citizenship in varchar2
282 ,p_military_doc in varchar2 default null
283 ,p_reserve_category in varchar2 default null
284 ,p_military_rank in varchar2 default null
285 ,p_military_profile in varchar2 default null
286 ,p_military_reg_code in varchar2 default null
287 ,p_mil_srvc_readiness_category in varchar2 default null
288 ,p_military_commissariat in varchar2 default null
289 ,p_quitting_mark in varchar2 default null
290 ,p_military_unit_number in varchar2 default null
291 ,p_military_reg_type in varchar2 default null
292 ,p_military_reg_details in varchar2 default null
293 ,p_pension_fund_number in varchar2 default null
294 ,p_background_check_status in varchar2 default null
295 ,p_background_date_check in date default null
296 ,p_correspondence_language in varchar2 default null
297 ,p_fte_capacity in number default null
298 ,p_hold_applicant_date_until in date default null
299 ,p_honors in varchar2 default null
300 ,p_mailstop in varchar2 default null
301 ,p_office_number in varchar2 default null
302 ,p_on_military_service in varchar2 default null
303 ,p_genitive_last_name in varchar2 default null
304 ,p_projected_start_date in date default null
305 ,p_resume_exists in varchar2 default null
306 ,p_resume_last_updated in date default null
307 ,p_student_status in varchar2 default null
308 ,p_work_schedule in varchar2 default null
309 ,p_suffix in varchar2 default null
310 ,p_date_of_death in date default null
311 ,p_benefit_group_id in number default null
312 ,p_receipt_of_death_cert_date in date default null
313 ,p_coord_ben_med_pln_no in varchar2 default null
314 ,p_coord_ben_no_cvg_flag in varchar2 default null
315 ,p_uses_tobacco_flag in varchar2 default null
316 ,p_dpdnt_adoption_date in date default null
317 ,p_dpdnt_vlntry_svce_flag in varchar2 default null
318 ,p_original_date_of_hire in date default null
319 ,p_town_of_birth in varchar2 default null
320 ,p_region_of_birth in varchar2 default null
321 ,p_country_of_birth in varchar2 default null
322 ,p_global_person_id in varchar2 default null
323 ,p_party_id in number default null
324 ,p_person_id out nocopy number
325 ,p_assignment_id out nocopy number
326 ,p_application_id out nocopy number
327 ,p_per_object_version_number out nocopy number
328 ,p_asg_object_version_number out nocopy number
332 ,p_full_name out nocopy varchar2
329 ,p_apl_object_version_number out nocopy number
330 ,p_per_effective_start_date out nocopy date
331 ,p_per_effective_end_date out nocopy date
333 ,p_per_comment_id out nocopy number
334 ,p_assignment_sequence out nocopy number
335 ,p_name_combination_warning out nocopy boolean
336 ,p_orig_hire_warning out nocopy boolean
337 );
338
339 --
340
341 --
342 end hr_ru_applicant_api;
[Home] [Help]