1 Package hr_fi_previous_employment_api as
2 /* $Header: pepemfii.pkh 120.1 2005/10/02 02:43:36 aroussel $ */
3 /*#
4 * This package contains previous employment APIs for Finland.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Previous Employment for Finland
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< create_fi_previous_job >----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates previous job details.
17 *
18 * This API is effectively an alternative to the API create_previous_job. If
19 * p_validate is set to false, a previous job is created.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources.
23 *
24 * <p><b>Prerequisites</b><br>
25 * The previous employer must already exist.
26 *
27 * <p><b>Post Success</b><br>
28 * The previous job will be successfully inserted into the database.
29 *
30 * <p><b>Post Failure</b><br>
31 * The previous job will not be created and an error will be raised.
32 *
33 * @param p_effective_date Reference date for validating lookup values are
34 * applicable during the start to end active date range. This date does not
35 * determine when the changes take effect.
36 * @param p_validate If true, then validation alone will be performed and the
37 * database will remain unchanged. If false and all validation checks pass,
38 * then the database will be modified.
39 * @param p_previous_employer_id Foreign key for the table
40 * per_previous_employers.
41 * @param p_start_date The date from which the employee worked with the
42 * previous job. Start date should be between start and end dates for the
43 * previous employer record.
44 * @param p_end_date The date on which the employee left the previous job.
45 * @param p_period_years Number of years of previous employment based on the
46 * employment start date and end date.
47 * @param p_period_months Number of months of previous employment based on the
48 * employment start date and end date.
49 * @param p_period_days Remaining number of days of employment based on number
50 * of days in period.
51 * @param p_job_name The name of the previous job. This is free text, and
52 * should not be confused with jobs held with the current employer stored
53 * within Oracle Human Resources.
54 * @param p_employment_category Category of the previous job. Valid values are
55 * defined by EMPLOYEE_CATG lookup type.
56 * @param p_description Description of the previous job.
57 * @param p_all_assignments Indicates whether previous employer is applicable
58 * to all assignments of the current employer.
59 * @param p_pjo_attribute_category Descriptive flexfield structure defining
60 * column.
61 * @param p_pjo_attribute1 Descriptive flexfield column.
62 * @param p_pjo_attribute2 Descriptive flexfield column.
63 * @param p_pjo_attribute3 Descriptive flexfield column.
64 * @param p_pjo_attribute4 Descriptive flexfield column.
65 * @param p_pjo_attribute5 Descriptive flexfield column.
66 * @param p_pjo_attribute6 Descriptive flexfield column.
67 * @param p_pjo_attribute7 Descriptive flexfield column.
68 * @param p_pjo_attribute8 Descriptive flexfield column.
69 * @param p_pjo_attribute9 Descriptive flexfield column.
70 * @param p_pjo_attribute10 Descriptive flexfield column.
71 * @param p_pjo_attribute11 Descriptive flexfield column.
72 * @param p_pjo_attribute12 Descriptive flexfield column.
73 * @param p_pjo_attribute13 Descriptive flexfield column.
74 * @param p_pjo_attribute14 Descriptive flexfield column.
75 * @param p_pjo_attribute15 Descriptive flexfield column.
76 * @param p_pjo_attribute16 Descriptive flexfield column.
77 * @param p_pjo_attribute17 Descriptive flexfield column.
78 * @param p_pjo_attribute18 Descriptive flexfield column
79 * @param p_pjo_attribute19 Descriptive flexfield column.
80 * @param p_pjo_attribute20 Descriptive flexfield column.
81 * @param p_pjo_attribute21 Descriptive flexfield column.
82 * @param p_pjo_attribute22 Descriptive flexfield column.
83 * @param p_pjo_attribute23 Descriptive flexfield column.
84 * @param p_pjo_attribute24 Descriptive flexfield column.
85 * @param p_pjo_attribute25 Descriptive flexfield column.
86 * @param p_pjo_attribute26 Descriptive flexfield column.
87 * @param p_pjo_attribute27 Descriptive flexfield column.
88 * @param p_pjo_attribute28 Descriptive flexfield column.
89 * @param p_pjo_attribute29 Descriptive flexfield column.
90 * @param p_pjo_attribute30 Descriptive flexfield column.
91 * @param p_job_exp_classification Job experience classification. Valid values
92 * are defined by FI_JOB_EXP_CAT lookup type.
93 * @param p_previous_job_id If p_validate is false, then this uniquely
94 * identifies the created previous job. If p_validate is true, then set to
95 * null.
96 * @param p_object_version_number If p_validate is false, then set to the
97 * version number of the created previous job. If p_validate is true, then the
98 * value will be null.
99 * @rep:displayname Create Previous Job for Finland
100 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
101 * @rep:lifecycle active
102 * @rep:scope public
103 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
104 */
105 --
106 -- {End Of Comments}
107 --
108 procedure create_fi_previous_job
109 ( p_effective_date in date
110 ,p_validate in boolean default false
111 ,p_previous_employer_id in number
112 ,p_start_date in date default null
113 ,p_end_date in date default null
114 ,p_period_years in number default null
115 ,p_period_months in number default null
116 ,p_period_days in number default null
117 ,p_job_name in varchar2 default null
118 ,p_employment_category in varchar2 default null
119 ,p_description in varchar2 default null
120 ,p_all_assignments in varchar2 default 'N'
121 ,p_pjo_attribute_category in varchar2 default null
122 ,p_pjo_attribute1 in varchar2 default null
123 ,p_pjo_attribute2 in varchar2 default null
124 ,p_pjo_attribute3 in varchar2 default null
125 ,p_pjo_attribute4 in varchar2 default null
126 ,p_pjo_attribute5 in varchar2 default null
127 ,p_pjo_attribute6 in varchar2 default null
128 ,p_pjo_attribute7 in varchar2 default null
129 ,p_pjo_attribute8 in varchar2 default null
130 ,p_pjo_attribute9 in varchar2 default null
131 ,p_pjo_attribute10 in varchar2 default null
132 ,p_pjo_attribute11 in varchar2 default null
133 ,p_pjo_attribute12 in varchar2 default null
134 ,p_pjo_attribute13 in varchar2 default null
135 ,p_pjo_attribute14 in varchar2 default null
136 ,p_pjo_attribute15 in varchar2 default null
137 ,p_pjo_attribute16 in varchar2 default null
138 ,p_pjo_attribute17 in varchar2 default null
139 ,p_pjo_attribute18 in varchar2 default null
140 ,p_pjo_attribute19 in varchar2 default null
141 ,p_pjo_attribute20 in varchar2 default null
142 ,p_pjo_attribute21 in varchar2 default null
143 ,p_pjo_attribute22 in varchar2 default null
144 ,p_pjo_attribute23 in varchar2 default null
145 ,p_pjo_attribute24 in varchar2 default null
146 ,p_pjo_attribute25 in varchar2 default null
147 ,p_pjo_attribute26 in varchar2 default null
148 ,p_pjo_attribute27 in varchar2 default null
149 ,p_pjo_attribute28 in varchar2 default null
150 ,p_pjo_attribute29 in varchar2 default null
151 ,p_pjo_attribute30 in varchar2 default null
152 ,p_job_exp_classification in varchar2 default null
153 ,p_previous_job_id out nocopy number
154 ,p_object_version_number out nocopy number
155 );
156 --
157 -- ----------------------------------------------------------------------------
158 -- |--------------------------< update_fi_previous_job >----------------------|
159 -- ----------------------------------------------------------------------------
160 --
161 -- {Start Of Comments}
162 /*#
163 * This API modifies a previous job.
164 *
165 * This API is effectively an alternative to the API update_previous_job. If
166 * p_validate is set to false, the previous job is updated.
167 *
168 * <p><b>Licensing</b><br>
169 * This API is licensed for use with Human Resources.
170 *
171 * <p><b>Prerequisites</b><br>
172 * The previous job record identified by p_previous_job_id must already exist.
173 *
174 * <p><b>Post Success</b><br>
175 * The previous job will be updated.
176 *
177 * <p><b>Post Failure</b><br>
178 * The previous job will not be updated and an error will be raised.
179 *
180 * @param p_effective_date Reference date for validating lookup values are
181 * applicable during the start to end active date range. This date does not
182 * determine when the changes take effect.
183 * @param p_validate If true, then validation alone will be performed and the
184 * database will remain unchanged. If false and all validation checks pass,
185 * then the database will be modified.
186 * @param p_previous_job_id Primary key of the table.
187 * @param p_start_date The date from which the employee worked with the
188 * previous job. The start date should be in between the start and end dates
189 * for the previous employer record.
190 * @param p_end_date The date on which the employee left the previous job.
191 * @param p_period_years Number of years of previous employment based on the
192 * employment start date and end date.
193 * @param p_period_months Number of months of previous employment based on the
194 * employment start date and end date.
195 * @param p_period_days Remaining number of days of employment based on number
196 * of days in period.
197 * @param p_job_name The name of the previous job. This is free text, and
198 * should not be confused with jobs held with the current employer stored
199 * within Oracle Human Resources.
200 * @param p_employment_category Category of the previous job. Valid values are
201 * defined by EMPLOYEE_CATG lookup type.
202 * @param p_description Description of the previous job.
203 * @param p_all_assignments Indicates whether previous employer is applicable
204 * to all assignments of the current employer.
205 * @param p_pjo_attribute_category Descriptive flexfield structure defining
206 * column.
207 * @param p_pjo_attribute1 Descriptive flexfield column.
208 * @param p_pjo_attribute2 Descriptive flexfield column.
209 * @param p_pjo_attribute3 Descriptive flexfield column.
210 * @param p_pjo_attribute4 Descriptive flexfield column.
211 * @param p_pjo_attribute5 Descriptive flexfield column.
212 * @param p_pjo_attribute6 Descriptive flexfield column.
213 * @param p_pjo_attribute7 Descriptive flexfield column.
214 * @param p_pjo_attribute8 Descriptive flexfield column.
215 * @param p_pjo_attribute9 Descriptive flexfield column.
216 * @param p_pjo_attribute10 Descriptive flexfield column.
217 * @param p_pjo_attribute11 Descriptive flexfield column.
218 * @param p_pjo_attribute12 Descriptive flexfield column.
222 * @param p_pjo_attribute16 Descriptive flexfield column.
219 * @param p_pjo_attribute13 Descriptive flexfield column.
220 * @param p_pjo_attribute14 Descriptive flexfield column.
221 * @param p_pjo_attribute15 Descriptive flexfield column.
226 * @param p_pjo_attribute20 Descriptive flexfield column.
223 * @param p_pjo_attribute17 Descriptive flexfield column.
224 * @param p_pjo_attribute18 Descriptive flexfield column.
225 * @param p_pjo_attribute19 Descriptive flexfield column.
227 * @param p_pjo_attribute21 Descriptive flexfield column.
231 * @param p_pjo_attribute25 Descriptive flexfield column.
228 * @param p_pjo_attribute22 Descriptive flexfield column.
229 * @param p_pjo_attribute23 Descriptive flexfield column.
230 * @param p_pjo_attribute24 Descriptive flexfield column.
232 * @param p_pjo_attribute26 Descriptive flexfield column.
233 * @param p_pjo_attribute27 Descriptive flexfield column.
234 * @param p_pjo_attribute28 Descriptive flexfield column.
235 * @param p_pjo_attribute29 Descriptive flexfield column.
236 * @param p_pjo_attribute30 Descriptive flexfield column.
237 * @param p_job_exp_classification Job experience classification. Valid values
238 * are defined by FI_JOB_EXP_CAT lookup type.
239 * @param p_object_version_number Pass in the current version number of the
240 * previous job to be updated. When the API completes if p_validate is false,
241 * will be set to the new version number of the updated previous job. If
242 * p_validate is true will be set to the same value which was passed in.
243 * @rep:displayname Update Previous Job for Finland
244 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
245 * @rep:lifecycle active
246 * @rep:scope public
247 */
248 --
249 -- {End Of Comments}
250 --
251 procedure update_fi_previous_job
252 (p_effective_date in date
253 ,p_validate in boolean default false
254 ,p_previous_job_id in number
255 ,p_start_date in date default null
256 ,p_end_date in date default null
257 ,p_period_years in number default null
258 ,p_period_months in number default null
259 ,p_period_days in number default null
260 ,p_job_name in varchar2 default null
261 ,p_employment_category in varchar2 default null
262 ,p_description in varchar2 default null
263 ,p_all_assignments in varchar2 default 'N'
264 ,p_pjo_attribute_category in varchar2 default null
265 ,p_pjo_attribute1 in varchar2 default null
266 ,p_pjo_attribute2 in varchar2 default null
267 ,p_pjo_attribute3 in varchar2 default null
268 ,p_pjo_attribute4 in varchar2 default null
269 ,p_pjo_attribute5 in varchar2 default null
270 ,p_pjo_attribute6 in varchar2 default null
271 ,p_pjo_attribute7 in varchar2 default null
272 ,p_pjo_attribute8 in varchar2 default null
273 ,p_pjo_attribute9 in varchar2 default null
274 ,p_pjo_attribute10 in varchar2 default null
275 ,p_pjo_attribute11 in varchar2 default null
276 ,p_pjo_attribute12 in varchar2 default null
277 ,p_pjo_attribute13 in varchar2 default null
278 ,p_pjo_attribute14 in varchar2 default null
279 ,p_pjo_attribute15 in varchar2 default null
280 ,p_pjo_attribute16 in varchar2 default null
281 ,p_pjo_attribute17 in varchar2 default null
282 ,p_pjo_attribute18 in varchar2 default null
283 ,p_pjo_attribute19 in varchar2 default null
284 ,p_pjo_attribute20 in varchar2 default null
285 ,p_pjo_attribute21 in varchar2 default null
286 ,p_pjo_attribute22 in varchar2 default null
287 ,p_pjo_attribute23 in varchar2 default null
288 ,p_pjo_attribute24 in varchar2 default null
289 ,p_pjo_attribute25 in varchar2 default null
290 ,p_pjo_attribute26 in varchar2 default null
291 ,p_pjo_attribute27 in varchar2 default null
292 ,p_pjo_attribute28 in varchar2 default null
293 ,p_pjo_attribute29 in varchar2 default null
294 ,p_pjo_attribute30 in varchar2 default null
295 ,p_job_exp_classification in varchar2 default null
296 ,p_object_version_number in out nocopy number
297 );
298 --
299 end hr_fi_previous_employment_api;