1 Package PQH_FR_EMP_STAT_SITUATION_API as
2 /* $Header: pqpsuapi.pkh 120.0 2005/05/29 02:19:41 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------< CREATE_EMP_STAT_SITUATION >--------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure creates statutory situation for a French Civil Servant. The
11 -- employee passed must be of agent type Fonctionnaire. There cannot be any
12 -- overlap with other statutory situations recorded for the employee. The
13 -- Eligibility Conditions defined for the Situation are evaluated, when the
14 -- situation is marked as approved.
15 -- Prerequisites:
16 --
17 --
18 -- In Parameters:
19 -- Name Reqd Type Description
20 -- P_VALIDATE N BOOLEAN If passed as TRUE,then changes are not applied. Otherwise
21 -- changes are applied to the Database.
22 -- P_EFFECTIVE_DATE Y DATE Specifies the reference date for validating lookup values,
23 -- applicable within the active date range. This date does
24 -- not determine when the changes take effect.
25 -- P_STATUTORY_SITUATION_ID Y NUMBER Statutory situation to be recorded for the employee.
26 -- Foreign Key to PQH_FR_STAT_SITUATIONS table.
27 -- P_PERSON_ID Y NUMBER Employee for which the statutory situation is recorded. This
28 -- is a foreign key to PER_ALL_PEOPLE_F table. Valid employees
29 -- are those having agent type defined as Fonctionnaire.
30 -- P_PROVISIONAL_START_DATE Y DATE Tentative start date from which the civil servant will be placed
31 -- on the situation.
32 -- P_PROVISIONAL_END_DATE Y DATE Tentative end date for the situation. There cannot be an overlap with
33 -- other situations recorded for the employee.
34 -- P_ACTUAL_START_DATE N DATE Actual start date for the employee on the situation.
35 -- P_ACTUAL_END_DATE N DATE Actual End date for the employee on the situation.
36 -- P_APPROVAL_FLAG N VARCHAR2 Flag to indicate whether the civil servant's placement
37 -- on the situation is approved or not. Valid values are Y/N.
38 -- P_COMMENTS N VARCHAR2 Any generic comments for the situation.
39 -- P_CONTACT_PERSON_ID N NUMBER Contact person provided as supporiting details for
40 -- the situation. Foreign key to PER_CONTACT_RELATIONSHIPS table.
41 -- P_CONTACT_RELATIONSHIP N VARCHAR2 Relationship type of the contact with the employee. Valid values
42 -- are from the lookpup CONTACT.
43 -- P_EXTERNAL_ORGANIZATION_ID N NUMBER External organization to which the civil servant is seconded.
44 -- Required to be provided for External Secondment type situation.
45 -- Foreign Key to HR_ALL_ORGANIZATION_UNITS table.
46 -- P_RENEWAL_FLAG N VARCHAR2 Flag to indicate whether this record is renewal of employee's
47 -- current situation. Valid values are Y/N.
48 -- P_RENEW_STAT_SITUATION_ID N NUMBER Situation that is renewed. This is required to be provided when
49 -- renewal_flag is Y.
50 -- P_SECONDED_CAREER_ID N NUMBER Welcoming Career of the civil servant when recording the
51 -- internal secondment situation. Foreign key to PER_ALL_ASSIGNMENTS_F.
52 -- P_ATTRIBUTE_CATEGORY N VARCHAR2 Descriptive flexfield context column.
53 -- P_ATTRIBUTE1 N VARCHAR2 Descriptive flexfield segment.
54 -- P_ATTRIBUTE2 N VARCHAR2 Descriptive flexfield segment.
55 -- P_ATTRIBUTE3 N VARCHAR2 Descriptive flexfield segment.
56 -- P_ATTRIBUTE4 N VARCHAR2 Descriptive flexfield segment.
57 -- P_ATTRIBUTE5 N VARCHAR2 Descriptive flexfield segment.
58 -- P_ATTRIBUTE6 N VARCHAR2 Descriptive flexfield segment.
59 -- P_ATTRIBUTE7 N VARCHAR2 Descriptive flexfield segment.
60 -- P_ATTRIBUTE8 N VARCHAR2 Descriptive flexfield segment.
61 -- P_ATTRIBUTE9 N VARCHAR2 Descriptive flexfield segment.
62 -- P_ATTRIBUTE10 N VARCHAR2 Descriptive flexfield segment.
63 -- P_ATTRIBUTE11 N VARCHAR2 Descriptive flexfield segment.
64 -- P_ATTRIBUTE12 N VARCHAR2 Descriptive flexfield segment.
65 -- P_ATTRIBUTE13 N VARCHAR2 Descriptive flexfield segment.
66 -- P_ATTRIBUTE14 N VARCHAR2 Descriptive flexfield segment.
67 -- P_ATTRIBUTE15 N VARCHAR2 Descriptive flexfield segment.
68 -- P_ATTRIBUTE16 N VARCHAR2 Descriptive flexfield segment.
69 -- P_ATTRIBUTE17 N VARCHAR2 Descriptive flexfield segment.
70 -- P_ATTRIBUTE18 N VARCHAR2 Descriptive flexfield segment.
71 -- P_ATTRIBUTE19 N VARCHAR2 Descriptive flexfield segment.
72 -- P_ATTRIBUTE20 N VARCHAR2 Descriptive flexfield segment.
73 -- P_ATTRIBUTE21 N VARCHAR2 Descriptive flexfield segment.
74 -- P_ATTRIBUTE22 N VARCHAR2 Descriptive flexfield segment.
75 -- P_ATTRIBUTE23 N VARCHAR2 Descriptive flexfield segment.
76 -- P_ATTRIBUTE24 N VARCHAR2 Descriptive flexfield segment.
77 -- P_ATTRIBUTE25 N VARCHAR2 Descriptive flexfield segment.
78 -- P_ATTRIBUTE26 N VARCHAR2 Descriptive flexfield segment.
79 -- P_ATTRIBUTE27 N VARCHAR2 Descriptive flexfield segment.
80 -- P_ATTRIBUTE28 N VARCHAR2 Descriptive flexfield segment.
81 -- P_ATTRIBUTE29 N VARCHAR2 Descriptive flexfield segment.
82 -- P_ATTRIBUTE30 N VARCHAR2 Descriptive flexfield segment.
83 --
84 -- Post Success:
85 --
86 --
87 -- Name Type Description
88 -- P_EMP_STAT_SITUATION_ID NUMBER Sequence generated primary key for the situation.
89 -- P_OBJECT_VERSION_NUMBER NUMBER If, P_validate is false, the process returns the
90 -- version number of the created situation.
91 -- If, P_validate is true, it returns null.
92 --
93 -- Post Failure:
94 -- Raises appropriate error message and the changes are not posted to the database.
95 --
96 -- Access Status:
97 -- Public.
98 --
99 -- {End Of Comments}
100 --
101 procedure CREATE_EMP_STAT_SITUATION
102 (p_validate IN boolean default false
103 ,p_effective_date IN date
104 ,P_STATUTORY_SITUATION_ID IN NUMBER
105 ,P_PERSON_ID IN NUMBER
106 ,P_PROVISIONAL_START_DATE IN DATE
107 ,P_PROVISIONAL_END_DATE IN DATE
108 ,P_ACTUAL_START_DATE IN DATE default null
109 ,P_ACTUAL_END_DATE IN DATE default null
110 ,P_APPROVAL_FLAG IN VARCHAR2 default null
111 ,P_COMMENTS IN VARCHAR2 default null
112 ,P_CONTACT_PERSON_ID IN NUMBER default null
113 ,P_CONTACT_RELATIONSHIP IN VARCHAR2 default null
114 ,P_EXTERNAL_ORGANIZATION_ID IN NUMBER default null
115 ,P_RENEWAL_FLAG IN VARCHAR2 default null
116 ,P_RENEW_STAT_SITUATION_ID IN NUMBER default null
117 ,P_SECONDED_CAREER_ID IN NUMBER default null
118 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default null
119 ,P_ATTRIBUTE1 IN VARCHAR2 default null
120 ,P_ATTRIBUTE2 IN VARCHAR2 default null
121 ,P_ATTRIBUTE3 IN VARCHAR2 default null
122 ,P_ATTRIBUTE4 IN VARCHAR2 default null
123 ,P_ATTRIBUTE5 IN VARCHAR2 default null
124 ,P_ATTRIBUTE6 IN VARCHAR2 default null
125 ,P_ATTRIBUTE7 IN VARCHAR2 default null
126 ,P_ATTRIBUTE8 IN VARCHAR2 default null
127 ,P_ATTRIBUTE9 IN VARCHAR2 default null
128 ,P_ATTRIBUTE10 IN VARCHAR2 default null
129 ,P_ATTRIBUTE11 IN VARCHAR2 default null
130 ,P_ATTRIBUTE12 IN VARCHAR2 default null
131 ,P_ATTRIBUTE13 IN VARCHAR2 default null
132 ,P_ATTRIBUTE14 IN VARCHAR2 default null
136 ,P_ATTRIBUTE18 IN VARCHAR2 default null
133 ,P_ATTRIBUTE15 IN VARCHAR2 default null
134 ,P_ATTRIBUTE16 IN VARCHAR2 default null
135 ,P_ATTRIBUTE17 IN VARCHAR2 default null
137 ,P_ATTRIBUTE19 IN VARCHAR2 default null
138 ,P_ATTRIBUTE20 IN VARCHAR2 default null
139 ,P_ATTRIBUTE21 IN VARCHAR2 default null
140 ,P_ATTRIBUTE22 IN VARCHAR2 default null
141 ,P_ATTRIBUTE23 IN VARCHAR2 default null
142 ,P_ATTRIBUTE24 IN VARCHAR2 default null
143 ,P_ATTRIBUTE25 IN VARCHAR2 default null
144 ,P_ATTRIBUTE26 IN VARCHAR2 default null
145 ,P_ATTRIBUTE27 IN VARCHAR2 default null
146 ,P_ATTRIBUTE28 IN VARCHAR2 default null
147 ,P_ATTRIBUTE29 IN VARCHAR2 default null
148 ,P_ATTRIBUTE30 IN VARCHAR2 default null
149 ,P_EMP_STAT_SITUATION_ID OUT NOCOPY NUMBER
150 ,P_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
151 );
152 --
153 -- ----------------------------------------------------------------------------
154 -- |---------------------< UPDATE_EMP_STAT_SITUATION >--------------------|
155 -- ----------------------------------------------------------------------------
156 -- {Start Of Comments}
157 --
158 -- Description:
159 -- This procedure updates the statutory situation details for a French Civil
160 -- Servant. The employee passed must be of agent type Fonctionnaire. There
161 -- cannot be any overlap with other statutory situations recorded for the employee.
162 -- The Eligibility Conditions defined for the Situation are evaluated, when the
163 -- situation is marked as approved.
164 -- Prerequisites:
165 --
166 --
167 -- In Parameters:
168 -- Name Reqd Type Description
169 -- P_VALIDATE N BOOLEAN If passed as TRUE,then changes are not applied. Otherwise
170 -- changes are applied to the Database.
171 -- P_EFFECTIVE_DATE Y DATE Specifies the reference date for validating lookup values,
172 -- applicable within the active date range. This date does
173 -- not determine when the changes take effect.
174 -- P_STATUTORY_SITUATION_ID Y NUMBER Statutory situation to be recorded for the employee.
175 -- Foreign Key to PQH_FR_STAT_SITUATIONS table.
176 -- P_PERSON_ID Y NUMBER Employee for which the statutory situation is recorded. This
177 -- is a foreign key to PER_ALL_PEOPLE_F table. Valid employees
178 -- are those having agent type defined as Fonctionnaire.
179 -- P_PROVISIONAL_START_DATE Y DATE Tentative start date from which the civil servant will be placed
180 -- on the situation.
181 -- P_PROVISIONAL_END_DATE Y DATE Tentative end date for the situation. There cannot be an overlap with
182 -- other situations recorded for the employee.
183 -- P_ACTUAL_START_DATE N DATE Actual start date for the employee on the situation.
184 -- P_ACTUAL_END_DATE N DATE Actual End date for the employee on the situation.
185 -- P_APPROVAL_FLAG N VARCHAR2 Flag to indicate whether the civil servant's placement
186 -- on the situation is approved or not. Valid values are Y/N.
187 -- P_COMMENTS N VARCHAR2 Any generic comments for the situation.
188 -- P_CONTACT_PERSON_ID N NUMBER Contact person provided as supporiting details for
189 -- the situation. Foreign key to PER_CONTACT_RELATIONSHIPS table.
190 -- P_CONTACT_RELATIONSHIP N VARCHAR2 Relationship type of the contact with the employee. Valid values
191 -- are from the lookpup CONTACT.
192 -- P_EXTERNAL_ORGANIZATION_ID N NUMBER External organization to which the civil servant is seconded.
193 -- Required to be provided for External Secondment type situation.
194 -- Foreign Key to HR_ALL_ORGANIZATION_UNITS table.
195 -- P_RENEWAL_FLAG N VARCHAR2 Flag to indicate whether this record is renewal of employee's
196 -- current situation. Valid values are Y/N.
197 -- P_RENEW_STAT_SITUATION_ID N NUMBER Situation that is renewed. This is required to be provided when
198 -- renewal_flag is Y.
199 -- P_SECONDED_CAREER_ID N NUMBER Welcoming Career of the civil servant when recording the
200 -- internal secondment situation. Foreign key to PER_ALL_ASSIGNMENTS_F.
201 -- P_ATTRIBUTE_CATEGORY N VARCHAR2 Descriptive flexfield context column.
202 -- P_ATTRIBUTE1 N VARCHAR2 Descriptive flexfield segment.
203 -- P_ATTRIBUTE2 N VARCHAR2 Descriptive flexfield segment.
204 -- P_ATTRIBUTE3 N VARCHAR2 Descriptive flexfield segment.
205 -- P_ATTRIBUTE4 N VARCHAR2 Descriptive flexfield segment.
206 -- P_ATTRIBUTE5 N VARCHAR2 Descriptive flexfield segment.
207 -- P_ATTRIBUTE6 N VARCHAR2 Descriptive flexfield segment.
208 -- P_ATTRIBUTE7 N VARCHAR2 Descriptive flexfield segment.
212 -- P_ATTRIBUTE11 N VARCHAR2 Descriptive flexfield segment.
209 -- P_ATTRIBUTE8 N VARCHAR2 Descriptive flexfield segment.
210 -- P_ATTRIBUTE9 N VARCHAR2 Descriptive flexfield segment.
211 -- P_ATTRIBUTE10 N VARCHAR2 Descriptive flexfield segment.
213 -- P_ATTRIBUTE12 N VARCHAR2 Descriptive flexfield segment.
214 -- P_ATTRIBUTE13 N VARCHAR2 Descriptive flexfield segment.
215 -- P_ATTRIBUTE14 N VARCHAR2 Descriptive flexfield segment.
216 -- P_ATTRIBUTE15 N VARCHAR2 Descriptive flexfield segment.
217 -- P_ATTRIBUTE16 N VARCHAR2 Descriptive flexfield segment.
218 -- P_ATTRIBUTE17 N VARCHAR2 Descriptive flexfield segment.
219 -- P_ATTRIBUTE18 N VARCHAR2 Descriptive flexfield segment.
220 -- P_ATTRIBUTE19 N VARCHAR2 Descriptive flexfield segment.
221 -- P_ATTRIBUTE20 N VARCHAR2 Descriptive flexfield segment.
222 -- P_ATTRIBUTE21 N VARCHAR2 Descriptive flexfield segment.
223 -- P_ATTRIBUTE22 N VARCHAR2 Descriptive flexfield segment.
224 -- P_ATTRIBUTE23 N VARCHAR2 Descriptive flexfield segment.
225 -- P_ATTRIBUTE24 N VARCHAR2 Descriptive flexfield segment.
226 -- P_ATTRIBUTE25 N VARCHAR2 Descriptive flexfield segment.
227 -- P_ATTRIBUTE26 N VARCHAR2 Descriptive flexfield segment.
228 -- P_ATTRIBUTE27 N VARCHAR2 Descriptive flexfield segment.
229 -- P_ATTRIBUTE28 N VARCHAR2 Descriptive flexfield segment.
230 -- P_ATTRIBUTE29 N VARCHAR2 Descriptive flexfield segment.
231 -- P_ATTRIBUTE30 N VARCHAR2 Descriptive flexfield segment.
232 -- P_EMP_STAT_SITUATION_ID Y NUMBER ID of the employee's statutory situation to be udpated.
233 --
234 -- Post Success:
235 --
236 --
237 -- Name Type Description
238 --
239 -- P_OBJECT_VERSION_NUMBER NUMBER Passes the current version number of the Situation to be updated.
240 -- When the API completes if p_validate is false, the process returns
241 -- the new version number of the updated Length of Service Situation.
242 -- If p_validate, it returns the same value which was passed in.
243 --
244 -- Post Failure:
245 -- Raises appropriate error message and the changes are not posted to the database.
246 --
247 -- Access Status:
248 -- Public.
249 --
250 -- {End Of Comments}
251 --
252 procedure UPDATE_EMP_STAT_SITUATION
253 (p_validate IN boolean default false
254 ,p_effective_date IN date
255 ,P_EMP_STAT_SITUATION_ID IN NUMBER
256 ,P_STATUTORY_SITUATION_ID IN NUMBER default hr_api.g_number
257 ,P_PERSON_ID IN NUMBER default hr_api.g_number
258 ,P_PROVISIONAL_START_DATE IN DATE default hr_api.g_date
259 ,P_PROVISIONAL_END_DATE IN DATE default hr_api.g_date
260 ,P_ACTUAL_START_DATE IN DATE default hr_api.g_date
261 ,P_ACTUAL_END_DATE IN DATE default hr_api.g_date
262 ,P_APPROVAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
263 ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
264 ,P_CONTACT_PERSON_ID IN NUMBER default hr_api.g_number
265 ,P_CONTACT_RELATIONSHIP IN VARCHAR2 default hr_api.g_varchar2
266 ,P_EXTERNAL_ORGANIZATION_ID IN NUMBER default hr_api.g_number
267 ,P_RENEWAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
268 ,P_RENEW_STAT_SITUATION_ID IN NUMBER default hr_api.g_number
269 ,P_SECONDED_CAREER_ID IN NUMBER default hr_api.g_number
270 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
271 ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
272 ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
273 ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
274 ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
275 ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
276 ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
277 ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
278 ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
279 ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
280 ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
281 ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
282 ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
283 ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
284 ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
285 ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
286 ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
287 ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
288 ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
289 ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
290 ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
291 ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
292 ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
296 ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
293 ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
294 ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
295 ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
297 ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
298 ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
299 ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
300 ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
301 ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
302 );
303 --
304 --
305 -- ----------------------------------------------------------------------------
306 -- |---------------------< DELETE_EMP_STAT_SITUATION >--------------------|
307 -- ----------------------------------------------------------------------------
308 -- {Start Of Comments}
309 --
310 -- Description:
311 -- This procedure deletes the statutory situation details for a French Civil
312 -- Servant. A situation that is current or already passed cannot be deleted.
313 -- Only future dated situations can be deleted.
314 -- Prerequisites:
315 -- Employee Statutory situation must exist and should be of a future date.
316 --
317 -- In Parameters:
318 -- Name Reqd Type Description
319 -- P_VALIDATE N BOOLEAN If passed as TRUE,then changes are not applied. Otherwise
320 -- changes are applied to the Database.
321 -- P_EMP_STAT_SITUATION_ID Y NUMBER ID of the employee's statutory situation to be deleted.
322 -- P_OBJECT_VERSION_NUMBER Y NUMBER Version Number of the situation that is to be deleted.
323 -- Post Success:
324 -- Deletes the employee's statutory situation. Reverts any assignment changes that were effected
325 -- while recording the situation.
326 -- Post Failure:
327 -- Raises appropriated error messages. Situation details are not deleted.
328 Procedure DELETE_EMP_STAT_SITUATION
329 ( P_VALIDATE IN BOOLEAN DEFAULT FALSE
330 ,P_EMP_STAT_SITUATION_ID IN NUMBER
331 ,P_OBJECT_VERSION_NUMBER IN NUMBER);
332 --
333 --
334 -- ----------------------------------------------------------------------------
335 -- |---------------------< RENEW_EMP_STAT_SITUATION >--------------------|
336 -- ----------------------------------------------------------------------------
337 -- {Start Of Comments}
338 --
339 -- Description:
340 -- This procedure renews the current statutory situation for the civil servant.
341 -- By this, the renewed situation's duration is extended by the specified amount.
342 -- Prerequisites:
343 --
344 --
345 -- In Parameters:
346 -- Name Reqd Type Description
347 -- P_VALIDATE N BOOLEAN If passed as TRUE,then changes are not applied. Otherwise
348 -- changes are applied to the Database.
349 -- P_EMP_STAT_SITUATION_ID Y NUMBER ID of the renewal statutory situation for the employee.
350 -- P_RENEW_STAT_SITUATION_ID Y NUMBER ID of the employee's statutory situation to be renewed.
351 -- P_OBJECT_VERSION_NUMBER Y NUMBER Version Number of the situation that is to be renewed.
352 -- P_RENEWAL_DURATION Y NUMBER Duration by which the situation is to be extended.
353 -- P_DURATION_UNITS Y VARCHAR2 Units for the duration. Valid values are from lookup type QUALIFYING_UNITS.
354 -- Post Success:
355 -- Renews employee's statutory situation. If the renewal is approved then, updates
356 -- the original situation to extend the provisional and actual end dates. Also
357 -- extends the assignment changes (if any) by this duration. Returns the updated
358 -- Post Failure:
359 -- Raises appropriate error messages. Situation is not renewed.
360 Procedure RENEW_EMP_STAT_SITUATION
361 ( P_VALIDATE IN BOOLEAN DEFAULT FALSE
362 ,P_EMP_STAT_SITUATION_ID IN OUT NOCOPY NUMBER
363 ,P_RENEW_STAT_SITUATION_ID IN NUMBER
364 ,P_RENEWAL_DURATION IN NUMBER
365 ,P_DURATION_UNITS IN VARCHAR2
366 ,P_APPROVAL_FLAG IN VARCHAR2
367 ,P_COMMENTS IN VARCHAR2
368 ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER);
369 --
370 --
371 -- ----------------------------------------------------------------------------
372 -- |---------------------< REINSTATE_EMP_STAT_SITUATION >--------------------|
373 -- ----------------------------------------------------------------------------
374 -- {Start Of Comments}
375 --
376 -- Description:
377 -- This procedure reinstates the civil servant from the current statutory situation.
378 -- By this, the current situation is end dated and a new situation with default
379 -- In Activity type is created starting from the re-instatement date.
380 -- Prerequisites:
381 --
382 --
383 -- In Parameters:
384 -- Name Reqd Type Description
385 -- P_VALIDATE N BOOLEAN If passed as TRUE,then changes are not applied. Otherwise
386 -- changes are applied to the Database.
387 -- P_EMP_STAT_SITUATION_ID Y NUMBER ID of the employee's statutory situation to be reinstated.
388 -- P_REINSTATE_DATE Y DATE Date on which the civil servant is re-instated
389 -- Post Success:
390 -- Creates a new situation using the default "In Activity" type situation for the civil servant starting
391 -- with the reinstatement date. The current situation of the civil servant is end dated with a date as one day
392 -- prior to the reinstatement date. This also re-activates the career and affectations for the civil servant.
393 -- Returns the new "In Activity" situation id to P_NEW_EMP_STAT_SITUATION_ID.
394 -- Post Failure:
398 ,P_PERSON_ID IN NUMBER
395 -- Raises appropriated error messages. Situation is not renewed.
396 procedure reinstate_emp_stat_situation
397 ( P_VALIDATE IN BOOLEAN DEFAULT FALSE
399 ,P_EMP_STAT_SITUATION_ID IN NUMBER
400 ,P_REINSTATE_DATE IN DATE
401 ,P_COMMENTS IN VARCHAR2
402 ,P_NEW_EMP_STAT_SITUATION_ID OUT NOCOPY NUMBER) ;
403 --
404 PROCEDURE update_assignments(p_person_id IN NUMBER
405 ,p_emp_stat_situation_id IN NUMBER DEFAULT NULL
406 ,p_statutory_situation_id IN NUMBER
407 ,p_start_date IN DATE
408 ,p_end_date IN DATE DEFAULT NULL);
409 --
410 end PQH_FR_EMP_STAT_SITUATION_API;