1 package hr_kw_previous_employment_api as
2 /* $Header: pepemkwi.pkh 120.1 2005/10/02 02:43:42 aroussel $ */
3 /*#
4 * This package contains previous employment APIs.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Previous Employment for Kuwait
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_kw_previous_employer >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a previous employer record.
17 *
18 * This API is effectively an alternative to the API create_previous_employer.
19 * If p_validate is set to false, a previous employer 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 employee must already exist.
26 *
27 * <p><b>Post Success</b><br>
28 * The previous employer will be successfully inserted into the database.
29 *
30 * <p><b>Post Failure</b><br>
31 * The API does not create the previous employer and raises an error.
32 *
33 * @param p_effective_date Effective date of the program running
34 * @param p_validate If true, then validation alone will be performed and the
35 * database will remain unchanged. If false and all validation checks pass,
36 * then the database will be modified.
37 * @param p_business_group_id Business group ID of the person.
38 * @param p_person_id Pass the person_id of the employee for whom the previous
39 * employer details are being entered.
40 * @param p_party_id Party ID of the person.
41 * @param p_start_date The date from which the employee worked with the
42 * previous employer.
43 * @param p_end_date The date on which the employee left the previous employer.
44 * @param p_period_years Number of years of previous employment based on the
45 * employment start date and end date.
46 * @param p_period_months Number of months of previous employment based on the
47 * employment start date and end date.
48 * @param p_period_days Remaining number of days of employment based on number
49 * of days in period.
50 * @param p_employer_name Previous employer name.
51 * @param p_employer_country The country in which the previous employer is
52 * located.
53 * @param p_employer_address Address of the previous employer.
54 * @param p_employer_type Type of previous employer. Valid values for this
55 * field are Public Sector, Commercial, and Unknown.
56 * @param p_employer_subtype Subtype of the previous employer. This is
57 * dependent on employer type.
58 * @param p_description Description of the previous employer.
59 * @param p_all_assignments Indicates whether previous employer is applicable
60 * to all assignments of the current employer. The default value is N.The valid
61 * values for this field are Y or N.If this previous employer is applicable to
62 * all assignments of the current employer, pass Y.
63 * @param p_pem_attribute_category Descriptive flexfield structure defining
64 * column.
65 * @param p_pem_attribute1 Descriptive flexfield column
66 * @param p_pem_attribute2 Descriptive flexfield column
67 * @param p_pem_attribute3 Descriptive flexfield column
68 * @param p_pem_attribute4 Descriptive flexfield column
69 * @param p_pem_attribute5 Descriptive flexfield column
70 * @param p_pem_attribute6 Descriptive flexfield column
71 * @param p_pem_attribute7 Descriptive flexfield column
72 * @param p_pem_attribute8 Descriptive flexfield column
73 * @param p_pem_attribute9 Descriptive flexfield column
74 * @param p_pem_attribute10 Descriptive flexfield column
75 * @param p_pem_attribute11 Descriptive flexfield column
76 * @param p_pem_attribute12 Descriptive flexfield column
77 * @param p_pem_attribute13 Descriptive flexfield column
78 * @param p_pem_attribute14 Descriptive flexfield column
79 * @param p_pem_attribute15 Descriptive flexfield column
80 * @param p_pem_attribute16 Descriptive flexfield column
81 * @param p_pem_attribute17 Descriptive flexfield column
82 * @param p_pem_attribute18 Descriptive flexfield column
83 * @param p_pem_attribute19 Descriptive flexfield column
84 * @param p_pem_attribute20 Descriptive flexfield column
85 * @param p_pem_attribute21 Descriptive flexfield column
86 * @param p_pem_attribute22 Descriptive flexfield column
87 * @param p_pem_attribute23 Descriptive flexfield column
88 * @param p_pem_attribute24 Descriptive flexfield column
89 * @param p_pem_attribute25 Descriptive flexfield column
90 * @param p_pem_attribute26 Descriptive flexfield column
91 * @param p_pem_attribute27 Descriptive flexfield column
92 * @param p_pem_attribute28 Descriptive flexfield column
93 * @param p_pem_attribute29 Descriptive flexfield column
94 * @param p_pem_attribute30 Descriptive flexfield column
95 * @param p_termination_reason Termination reason.
96 * @param p_previous_employer_id Primary key of the table. This value is
97 * generated by a sequence and will be passed to the calling procedure.
98 * @param p_object_version_number After a new record is is created object
99 * version number is set to 1.
100 * @rep:displayname Create Previous Employer for Kuwait
101 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
102 * @rep:lifecycle active
103 * @rep:scope public
104 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
105 */
106 --
107 -- {End Of Comments}
108 --
109 procedure create_kw_previous_employer
110 ( p_effective_date IN date
111 ,p_validate IN boolean default false
112 ,p_business_group_id IN number
113 ,p_person_id IN number
114 ,p_party_id IN number default null
115 ,p_start_date IN date default null
116 ,p_end_date IN date default null
117 ,p_period_years IN number default null
118 ,p_period_months IN number default null
119 ,p_period_days IN number default null
120 ,p_employer_name IN varchar2
121 ,p_employer_country IN varchar2 default null
122 ,p_employer_address IN varchar2 default null
123 ,p_employer_type IN varchar2 default null
124 ,p_employer_subtype IN varchar2 default null
125 ,p_description IN varchar2 default null
126 ,p_all_assignments IN varchar2 default 'N'
127 ,p_pem_attribute_category IN varchar2 default null
128 ,p_pem_attribute1 IN varchar2 default null
129 ,p_pem_attribute2 IN varchar2 default null
130 ,p_pem_attribute3 IN varchar2 default null
131 ,p_pem_attribute4 IN varchar2 default null
132 ,p_pem_attribute5 IN varchar2 default null
133 ,p_pem_attribute6 IN varchar2 default null
134 ,p_pem_attribute7 IN varchar2 default null
135 ,p_pem_attribute8 IN varchar2 default null
136 ,p_pem_attribute9 IN varchar2 default null
137 ,p_pem_attribute10 IN varchar2 default null
138 ,p_pem_attribute11 IN varchar2 default null
139 ,p_pem_attribute12 IN varchar2 default null
140 ,p_pem_attribute13 IN varchar2 default null
141 ,p_pem_attribute14 IN varchar2 default null
142 ,p_pem_attribute15 IN varchar2 default null
143 ,p_pem_attribute16 IN varchar2 default null
144 ,p_pem_attribute17 IN varchar2 default null
145 ,p_pem_attribute18 IN varchar2 default null
146 ,p_pem_attribute19 IN varchar2 default null
147 ,p_pem_attribute20 IN varchar2 default null
148 ,p_pem_attribute21 IN varchar2 default null
149 ,p_pem_attribute22 IN varchar2 default null
150 ,p_pem_attribute23 IN varchar2 default null
151 ,p_pem_attribute24 IN varchar2 default null
152 ,p_pem_attribute25 IN varchar2 default null
153 ,p_pem_attribute26 IN varchar2 default null
154 ,p_pem_attribute27 IN varchar2 default null
155 ,p_pem_attribute28 IN varchar2 default null
156 ,p_pem_attribute29 IN varchar2 default null
157 ,p_pem_attribute30 IN varchar2 default null
158 ,p_termination_reason IN varchar2 default null
159 ,p_previous_employer_id OUT NOCOPY number
160 ,p_object_version_number OUT NOCOPY number
161 );
162 --
163 -- ----------------------------------------------------------------------------
164 -- |-----------------------< update_kw_previous_employer >--------------------|
165 -- ----------------------------------------------------------------------------
166 --
167 -- {Start Of Comments}
168 /*#
169 * This API updates the existing previous employer values.
170 *
171 * This API is effectively an alternative to the API update_previous_job. If
172 * p_validate is set to false, the previous job is updated.
173 *
174 * <p><b>Licensing</b><br>
175 * This API is licensed for use with Human Resources.
176 *
177 * <p><b>Prerequisites</b><br>
178 * The previous job record identified by p_previous_job_id must already exist.
179 *
180 * <p><b>Post Success</b><br>
181 * The previous employer values are changed.
182 *
183 * <p><b>Post Failure</b><br>
184 * The API does not update the previous employer and raises an error.
185 *
186 * @param p_effective_date Effective date of the program running
187 * @param p_validate If true, then validation alone will be performed and the
188 * database will remain unchanged. If false and all validation checks pass,
189 * then the database will be modified.
190 * @param p_previous_employer_id Primary key of the table. This value is
191 * generated by a sequence and will be passed to the calling procedure.
192 * @param p_start_date The date from which the employee worked with the
193 * previous employer.
194 * @param p_end_date The date on which the employee left the previous employer.
195 * @param p_period_years OUT Number of years for the previous employment. This
196 * is calculated based on the start date and end date.
197 * @param p_period_months OUT Number of months for the previous employment.
198 * This is calculated based on the start date and end date.
199 * @param p_period_days OUT Remaining number of days. It is calculated from
200 * period days.
201 * @param p_employer_name Previous employer name.
202 * @param p_employer_country The country in which the previous employer is
203 * located.
204 * @param p_employer_address Address of the previous employer.
205 * @param p_employer_type Type of previous employer. Valid values for this
206 * field are Public Sector, Commercial, and Unknown.
207 * @param p_employer_subtype Subtype of the previous employer. This is
208 * dependent on employer type.
209 * @param p_description Description of the previous employer.
210 * @param p_all_assignments Indicates whether previous employer is applicable
211 * to all assignments of the current employer. The default value is N.The valid
212 * values for this field are Y or N.If this previous employer is applicable to
213 * all assignments of the current employer, pass Y.
214 * @param p_pem_attribute_category Descriptive flexfield structure defining
215 * column.
216 * @param p_pem_attribute1 Descriptive flexfield column
217 * @param p_pem_attribute2 Descriptive flexfield column
218 * @param p_pem_attribute3 Descriptive flexfield column
219 * @param p_pem_attribute4 Descriptive flexfield column
220 * @param p_pem_attribute5 Descriptive flexfield column
221 * @param p_pem_attribute6 Descriptive flexfield column
222 * @param p_pem_attribute7 Descriptive flexfield column
223 * @param p_pem_attribute8 Descriptive flexfield column
224 * @param p_pem_attribute9 Descriptive flexfield column
225 * @param p_pem_attribute10 Descriptive flexfield column
226 * @param p_pem_attribute11 Descriptive flexfield column
227 * @param p_pem_attribute12 Descriptive flexfield column
228 * @param p_pem_attribute13 Descriptive flexfield column
229 * @param p_pem_attribute14 Descriptive flexfield column
230 * @param p_pem_attribute15 Descriptive flexfield column
234 * @param p_pem_attribute19 Descriptive flexfield column
231 * @param p_pem_attribute16 Descriptive flexfield column
232 * @param p_pem_attribute17 Descriptive flexfield column
233 * @param p_pem_attribute18 Descriptive flexfield column
235 * @param p_pem_attribute20 Descriptive flexfield column
236 * @param p_pem_attribute21 Descriptive flexfield column
237 * @param p_pem_attribute22 Descriptive flexfield column
238 * @param p_pem_attribute23 Descriptive flexfield column
239 * @param p_pem_attribute24 Descriptive flexfield column
240 * @param p_pem_attribute25 Descriptive flexfield column
241 * @param p_pem_attribute26 Descriptive flexfield column
242 * @param p_pem_attribute27 Descriptive flexfield column
243 * @param p_pem_attribute28 Descriptive flexfield column
244 * @param p_pem_attribute29 Descriptive flexfield column
245 * @param p_pem_attribute30 Descriptive flexfield column
246 * @param p_termination_reason Termination reason.
247 * @param p_object_version_number After a new record is is created object
248 * version number is set to 1.
249 * @rep:displayname Update Previous Employer for Kuwait
250 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
251 * @rep:lifecycle active
252 * @rep:scope public
253 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
254 */
255 --
256 -- {End Of Comments}
257 --
258 procedure update_kw_previous_employer
259 ( p_effective_date IN date
260 ,p_validate IN boolean default false
261 ,p_previous_employer_id IN number
262 ,p_start_date IN date default hr_api.g_date
263 ,p_end_date IN date default hr_api.g_date
264 ,p_period_years IN number default hr_api.g_number
265 ,p_period_months IN number default hr_api.g_number
266 ,p_period_days IN number default hr_api.g_number
267 ,p_employer_name IN varchar2 default hr_api.g_varchar2
268 ,p_employer_country IN varchar2 default hr_api.g_varchar2
269 ,p_employer_address IN varchar2 default hr_api.g_varchar2
270 ,p_employer_type IN varchar2 default hr_api.g_varchar2
271 ,p_employer_subtype IN varchar2 default hr_api.g_varchar2
272 ,p_description IN varchar2 default hr_api.g_varchar2
273 ,p_all_assignments IN varchar2 default 'N'
274 ,p_pem_attribute_category IN varchar2 default hr_api.g_varchar2
275 ,p_pem_attribute1 IN varchar2 default hr_api.g_varchar2
276 ,p_pem_attribute2 IN varchar2 default hr_api.g_varchar2
277 ,p_pem_attribute3 IN varchar2 default hr_api.g_varchar2
278 ,p_pem_attribute4 IN varchar2 default hr_api.g_varchar2
279 ,p_pem_attribute5 IN varchar2 default hr_api.g_varchar2
280 ,p_pem_attribute6 IN varchar2 default hr_api.g_varchar2
281 ,p_pem_attribute7 IN varchar2 default hr_api.g_varchar2
282 ,p_pem_attribute8 IN varchar2 default hr_api.g_varchar2
283 ,p_pem_attribute9 IN varchar2 default hr_api.g_varchar2
284 ,p_pem_attribute10 IN varchar2 default hr_api.g_varchar2
285 ,p_pem_attribute11 IN varchar2 default hr_api.g_varchar2
286 ,p_pem_attribute12 IN varchar2 default hr_api.g_varchar2
287 ,p_pem_attribute13 IN varchar2 default hr_api.g_varchar2
288 ,p_pem_attribute14 IN varchar2 default hr_api.g_varchar2
289 ,p_pem_attribute15 IN varchar2 default hr_api.g_varchar2
290 ,p_pem_attribute16 IN varchar2 default hr_api.g_varchar2
291 ,p_pem_attribute17 IN varchar2 default hr_api.g_varchar2
292 ,p_pem_attribute18 IN varchar2 default hr_api.g_varchar2
293 ,p_pem_attribute19 IN varchar2 default hr_api.g_varchar2
294 ,p_pem_attribute20 IN varchar2 default hr_api.g_varchar2
295 ,p_pem_attribute21 IN varchar2 default hr_api.g_varchar2
296 ,p_pem_attribute22 IN varchar2 default hr_api.g_varchar2
297 ,p_pem_attribute23 IN varchar2 default hr_api.g_varchar2
298 ,p_pem_attribute24 IN varchar2 default hr_api.g_varchar2
299 ,p_pem_attribute25 IN varchar2 default hr_api.g_varchar2
300 ,p_pem_attribute26 IN varchar2 default hr_api.g_varchar2
301 ,p_pem_attribute27 IN varchar2 default hr_api.g_varchar2
302 ,p_pem_attribute28 IN varchar2 default hr_api.g_varchar2
303 ,p_pem_attribute29 IN varchar2 default hr_api.g_varchar2
304 ,p_pem_attribute30 IN varchar2 default hr_api.g_varchar2
305 ,p_termination_reason IN varchar2 default hr_api.g_varchar2
306 ,p_object_version_number IN OUT NOCOPY number
307 );
308 --
309 end hr_kw_previous_employment_api;