DBA Data[Home] [Help]

PACKAGE: APPS.HR_FI_PREVIOUS_EMPLOYMENT_API

Source


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;