1 PACKAGE ben_whatif_elig AUTHID CURRENT_USER as
2 /* $Header: benwatif.pkh 115.8 2003/05/08 10:47:22 glingapp ship $ */
3
4 --
5 -- Global variables to keep the temporal values like compensation
6 -- as entered by the user on weatif form.
7 --
8 -- Variables to hold the compensation values.
9 --
10 g_stat_comp number := null;
11 g_bnft_bal_comp number := null;
12 g_bal_comp number := null;
13
14 --
15 -- Variables to hours worked.
16 --
17 g_bnft_bal_hwf_val number := null;
18 g_bal_hwf_val number := null;
19
20 procedure p_rollback;
21
22 procedure WATIF_ABSENCE_ATTENDANCES_API(
23 p_person_id in number
24 ,p_ABSENCE_ATTENDANCE_TYPE_ID in varchar2
25 ,p_ABS_ATTENDANCE_REASON_ID in varchar2
26 ,p_DATE_END in date
27 ,p_DATE_START in date
28 ,p_business_group_id in number
29 ,p_effective_date in date
30 );
31
32
33
34 procedure WATIF_ADDRESSES_API(
35 p_person_id in number
36 ,p_POSTAL_CODE in varchar2
37 ,p_PRIMARY_FLAG in varchar2
38 ,p_REGION_2 in varchar2
39 ,p_ADDRESS_TYPE in varchar2
40 ,p_DATE_FROM in date
41 ,p_DATE_TO in date
42 ,p_effective_date in date
43 );
44
45
46 procedure WATIF_ALL_ASSIGNMENTS_F_API(
47 p_person_id in number
48 ,p_PAY_BASIS_ID in number
49 ,p_EMPLOYMENT_CATEGORY in varchar2
50 ,p_LABOUR_UNION_MEMBER_FLAG in varchar2
51 ,p_JOB_ID in number
52 ,p_PAYROLL_ID in number
53 ,p_PRIMARY_FLAG in varchar2
54 ,p_LOCATION_ID in number
55 ,p_CHANGE_REASON in varchar2
56 ,p_ASSIGNMENT_TYPE in varchar2
57 ,p_ORGANIZATION_ID in number
58 ,p_POSITION_ID in number
59 ,p_BARGAINING_UNIT_CODE in varchar2
60 ,p_NORMAL_HOURS in number
61 ,p_FREQUENCY in varchar2
62 ,p_ASSIGNMENT_STATUS_TYPE_ID in number
63 ,p_GRADE_ID in number
64 ,p_PEOPLE_GROUP_ID in NUMBER
65 ,p_HOURLY_SALARIED_CODE in varchar2
66 ,p_ASS_ATTRIBUTE_CATEGORY in varchar2
67 ,p_ASS_ATTRIBUTE1 in VARCHAR2
68 ,p_ASS_ATTRIBUTE10 in VARCHAR2
69 ,p_ASS_ATTRIBUTE11 in VARCHAR2
70 ,p_ASS_ATTRIBUTE12 in VARCHAR2
71 ,p_ASS_ATTRIBUTE13 in VARCHAR2
72 ,p_ASS_ATTRIBUTE14 in VARCHAR2
73 ,p_ASS_ATTRIBUTE15 in VARCHAR2
74 ,p_ASS_ATTRIBUTE16 in VARCHAR2
75 ,p_ASS_ATTRIBUTE17 in VARCHAR2
76 ,p_ASS_ATTRIBUTE18 in VARCHAR2
77 ,p_ASS_ATTRIBUTE19 in VARCHAR2
78 ,p_ASS_ATTRIBUTE2 in VARCHAR2
79 ,p_ASS_ATTRIBUTE20 in VARCHAR2
80 ,p_ASS_ATTRIBUTE21 in VARCHAR2
81 ,p_ASS_ATTRIBUTE22 in VARCHAR2
82 ,p_ASS_ATTRIBUTE23 in VARCHAR2
83 ,p_ASS_ATTRIBUTE24 in VARCHAR2
84 ,p_ASS_ATTRIBUTE25 in VARCHAR2
85 ,p_ASS_ATTRIBUTE26 in VARCHAR2
86 ,p_ASS_ATTRIBUTE27 in VARCHAR2
87 ,p_ASS_ATTRIBUTE28 in VARCHAR2
88 ,p_ASS_ATTRIBUTE29 in VARCHAR2
89 ,p_ASS_ATTRIBUTE3 in VARCHAR2
90 ,p_ASS_ATTRIBUTE30 in VARCHAR2
91 ,p_ASS_ATTRIBUTE4 in VARCHAR2
92 ,p_ASS_ATTRIBUTE5 in VARCHAR2
93 ,p_ASS_ATTRIBUTE6 in VARCHAR2
94 ,p_ASS_ATTRIBUTE7 in VARCHAR2
95 ,p_ASS_ATTRIBUTE8 in VARCHAR2
96 ,p_ASS_ATTRIBUTE9 in VARCHAR2
97 ,p_business_group_id in number
98 ,p_effective_date in date
99 );
100
101 procedure WATIF_ALL_PEOPLE_F_API(
102 p_person_id in number
103 ,p_STUDENT_STATUS in varchar2
104 ,p_MARITAL_STATUS in varchar2
105 ,p_DATE_OF_DEATH in date
106 ,p_DATE_OF_BIRTH in date
107 ,p_COORD_BEN_NO_CVG_FLAG in varchar2
108 ,p_ON_MILITARY_SERVICE in varchar2
109 ,p_REGISTERED_DISABLED_FLAG in varchar2
110 ,p_USES_TOBACCO_FLAG in varchar2
111 ,p_BENEFIT_GROUP_ID in number
112 ,p_PER_INFORMATION10 in varchar2
113 ,p_COORD_BEN_MED_PLN_NO in varchar2
114 ,p_DPDNT_VLNTRY_SVCE_FLAG in varchar2
115 ,p_RECEIPT_OF_DEATH_CERT_DATE in date
116 ,p_sex in varchar2
117 ,p_ATTRIBUTE1 in VARCHAR2
118 ,p_ATTRIBUTE10 in VARCHAR2
119 ,p_ATTRIBUTE11 in VARCHAR2
120 ,p_ATTRIBUTE12 in VARCHAR2
121 ,p_ATTRIBUTE13 in VARCHAR2
122 ,p_ATTRIBUTE14 in VARCHAR2
123 ,p_ATTRIBUTE15 in VARCHAR2
124 ,p_ATTRIBUTE16 in VARCHAR2
125 ,p_ATTRIBUTE17 in VARCHAR2
126 ,p_ATTRIBUTE18 in VARCHAR2
127 ,p_ATTRIBUTE19 in VARCHAR2
128 ,p_ATTRIBUTE2 in VARCHAR2
129 ,p_ATTRIBUTE20 in VARCHAR2
130 ,p_ATTRIBUTE21 in VARCHAR2
131 ,p_ATTRIBUTE22 in VARCHAR2
132 ,p_ATTRIBUTE23 in VARCHAR2
133 ,p_ATTRIBUTE24 in VARCHAR2
134 ,p_ATTRIBUTE25 in VARCHAR2
135 ,p_ATTRIBUTE26 in VARCHAR2
136 ,p_ATTRIBUTE27 in VARCHAR2
137 ,p_ATTRIBUTE28 in VARCHAR2
138 ,p_ATTRIBUTE29 in VARCHAR2
139 ,p_ATTRIBUTE3 in VARCHAR2
140 ,p_ATTRIBUTE30 in VARCHAR2
141 ,p_ATTRIBUTE4 in VARCHAR2
142 ,p_ATTRIBUTE5 in VARCHAR2
143 ,p_ATTRIBUTE6 in VARCHAR2
144 ,p_ATTRIBUTE7 in VARCHAR2
145 ,p_ATTRIBUTE8 in VARCHAR2
146 ,p_ATTRIBUTE9 in VARCHAR2
147 ,p_business_group_id in number
148 ,p_effective_date in date
149 );
150
151 procedure WATIF_CONTACT_RELATIONSHIP_API(
152 p_person_id in number
153 ,p_contact_person_id in number
154 ,p_DATE_START in date
155 ,p_DATE_END in date
156 ,p_CONTACT_TYPE in VARCHAR2
157 ,p_PERSONAL_FLAG in VARCHAR2
158 ,p_START_LIFE_REASON_ID in NUMBER
159 ,p_END_LIFE_REASON_ID in NUMBER
160 ,p_RLTD_PER_RSDS_W_DSGNTR_FLAG in VARCHAR2
161 ,p_business_group_id in number
162 ,p_effective_date in date
163 );
164
165 procedure WATIF_PERIODS_OF_SERVICE_API(
166 p_person_id in number
167 ,p_per_object_version_number in number
168 ,p_DATE_START in date
169 ,p_LEAVING_REASON in varchar2
170 ,p_ADJUSTED_SVC_DATE in date
171 ,p_ACTUAL_TERMINATION_DATE in date
172 ,p_FINAL_PROCESS_DATE in date
173 ,p_ATTRIBUTE1 in VARCHAR2
174 ,p_ATTRIBUTE2 in VARCHAR2
175 ,p_ATTRIBUTE3 in VARCHAR2
176 ,p_ATTRIBUTE4 in VARCHAR2
177 ,p_ATTRIBUTE5 in VARCHAR2
178 ,p_ATTRIBUTE6 in VARCHAR2
179 ,p_ATTRIBUTE7 in VARCHAR2
180 ,p_ATTRIBUTE8 in VARCHAR2
181 ,p_ATTRIBUTE9 in VARCHAR2
182 ,p_ATTRIBUTE10 in VARCHAR2
183 ,p_ATTRIBUTE11 in VARCHAR2
184 ,p_ATTRIBUTE12 in VARCHAR2
185 ,p_ATTRIBUTE13 in VARCHAR2
186 ,p_ATTRIBUTE14 in VARCHAR2
187 ,p_ATTRIBUTE15 in VARCHAR2
188 ,p_ATTRIBUTE16 in VARCHAR2
189 ,p_ATTRIBUTE17 in VARCHAR2
190 ,p_ATTRIBUTE18 in VARCHAR2
191 ,p_ATTRIBUTE19 in VARCHAR2
192 ,p_ATTRIBUTE20 in VARCHAR2
193 ,p_business_group_id in number
194 ,p_effective_date in date
195 );
196
197 procedure WATIF_PERSON_TYPE_USAGES_F_API(
198 p_person_id in number
199 ,p_PERSON_TYPE_ID in varchar2
200 ,p_business_group_id in number
201 ,p_effective_date in date
202 );
203
204
205 procedure WATIF_PER_BNFTS_BAL_F_API(
206 p_person_id in number
207 ,p_BNFTS_BAL_ID in number
208 ,p_VAL in number
209 ,p_EFFECTIVE_START_DATE in date
210 ,p_EFFECTIVE_END_DATE in date
211 ,p_business_group_id in number
212 ,p_effective_date in date
213 );
214
215 procedure WATIF_PER_ASG_BUDG_VAL_F_API(
216 p_person_id in number
217 ,p_ASSIGNMENT_BUDGET_VALUE_ID in number
218 ,p_VALUE in number
219 ,p_business_group_id in number
220 ,p_effective_date in date
221 );
222
223
224 procedure WATIF_ELIG_CVRD_DPNT_F_API(
225 p_person_id in number
226 ,p_CVG_STRT_DT in date
227 ,p_CVG_THRU_DT in date
228 ,p_EFFECTIVE_START_DATE in date
229 ,p_EFFECTIVE_END_DATE in date
230 ,p_business_group_id in number
231 ,p_effective_date in date
232 );
233
234
235 procedure WATIF_CRT_ORDR_API(
236 p_person_id in number
237 ,p_pl_id in number
238 ,p_CRT_ORDR_TYP_CD in varchar2
239 ,p_APLS_PERD_STRTG_DT in date
240 ,p_APLS_PERD_ENDG_DT in date
241 ,p_business_group_id in number
242 ,p_effective_date in date
243 );
244
245 --
246 procedure WATIF_TEMPORAL_LF_EVT_API(
247 p_person_id in number
248 ,p_business_group_id in number
249 ,p_ler_id in number
250 ,p_temporal_lf_evt in varchar2
251 ,p_lf_evt_ocrd_dt in date
252 ,p_effective_date in date
253 ,p_tpf_val in number default null
254 ,p_cmp_val in number default null
255 ,p_cmp_bnft_val in number default null
256 ,p_cmp_bal_val in number default null
257 ,p_hwf_val in number default null
258 ,p_hwf_bnft_val in number default null
259 );
260 --
261
262 --Bug 2831804 Qualification
263 procedure WATIF_PER_QUALIFICATIONS_API(
264 p_person_id in number
265 ,p_qualification_type_id in number
266 ,p_title in varchar2
267 ,p_start_date in date
268 ,p_end_date in date
269 ,p_attribute1 in varchar2
270 ,p_attribute2 in varchar2
271 ,p_attribute3 in varchar2
272 ,p_attribute4 in varchar2
273 ,p_attribute5 in varchar2
274 ,p_attribute6 in varchar2
275 ,p_attribute7 in varchar2
276 ,p_attribute8 in varchar2
277 ,p_attribute9 in varchar2
278 ,p_attribute10 in varchar2
279 ,p_attribute11 in varchar2
280 ,p_attribute12 in varchar2
281 ,p_attribute13 in varchar2
282 ,p_attribute14 in varchar2
283 ,p_attribute15 in varchar2
284 ,p_attribute16 in varchar2
285 ,p_attribute17 in varchar2
286 ,p_attribute18 in varchar2
287 ,p_attribute19 in varchar2
288 ,p_attribute20 in varchar2
289 ,p_business_group_id in number
290 ,p_effective_date in date
291 );
292 --Bug 2831804 Qualification
293
294 --Bug 2831804 Competence
295 procedure WATIF_PER_COMPETENCE_API(
296 p_person_id in number
297 ,p_competence_id in number
298 ,p_proficiency_level_id in number
299 ,p_effective_date_from in date
300 ,p_effective_date_to in date
301 ,p_attribute1 in varchar2
302 ,p_attribute2 in varchar2
303 ,p_attribute3 in varchar2
304 ,p_attribute4 in varchar2
305 ,p_attribute5 in varchar2
306 ,p_attribute6 in varchar2
307 ,p_attribute7 in varchar2
308 ,p_attribute8 in varchar2
309 ,p_attribute9 in varchar2
310 ,p_attribute10 in varchar2
311 ,p_attribute11 in varchar2
312 ,p_attribute12 in varchar2
313 ,p_attribute13 in varchar2
314 ,p_attribute14 in varchar2
315 ,p_attribute15 in varchar2
316 ,p_attribute16 in varchar2
317 ,p_attribute17 in varchar2
318 ,p_attribute18 in varchar2
319 ,p_attribute19 in varchar2
320 ,p_attribute20 in varchar2
321 ,p_business_group_id in number
322 ,p_effective_date in date
323 );
324 --Bug 2831804 Competence
325
326 --Bug 2831804 Performance
327
328 procedure WATIF_PER_PERFORMANCE_API(
329 p_person_id in number
330 ,p_performance_rating in varchar2
331 ,p_event_id in number
332 ,p_review_date in date
333 ,p_attribute1 in varchar2
334 ,p_attribute2 in varchar2
335 ,p_attribute3 in varchar2
336 ,p_attribute4 in varchar2
337 ,p_attribute5 in varchar2
338 ,p_attribute6 in varchar2
339 ,p_attribute7 in varchar2
340 ,p_attribute8 in varchar2
341 ,p_attribute9 in varchar2
342 ,p_attribute10 in varchar2
343 ,p_attribute11 in varchar2
344 ,p_attribute12 in varchar2
345 ,p_attribute13 in varchar2
346 ,p_attribute14 in varchar2
347 ,p_attribute15 in varchar2
348 ,p_attribute16 in varchar2
349 ,p_attribute17 in varchar2
350 ,p_attribute18 in varchar2
351 ,p_attribute19 in varchar2
352 ,p_attribute20 in varchar2
353 ,p_attribute21 in varchar2
354 ,p_attribute22 in varchar2
355 ,p_attribute23 in varchar2
356 ,p_attribute24 in varchar2
357 ,p_attribute25 in varchar2
358 ,p_attribute26 in varchar2
359 ,p_attribute27 in varchar2
360 ,p_attribute28 in varchar2
361 ,p_attribute29 in varchar2
362 ,p_attribute30 in varchar2
363 );
364
365 --Bug 2831804 Performance
366
367
368 --Bug 2868775 Pay Proposal
369
370 procedure WATIF_PAY_PROPOSAL_API(
371 p_person_id in number
372 ,p_approved in varchar2
373 ,p_change_date in date
374 ,p_event_id in number
375 ,p_forced_ranking in number
376 ,p_last_change_date in date
377 ,p_multiple_components in varchar2
378 ,p_next_sal_review_date in date
379 ,p_next_perf_review_date in date
380 ,p_performance_rating in varchar2
381 ,p_performance_review_id in number
382 ,p_proposal_reason in varchar2
383 ,p_proposed_salary_n in number
384 ,p_review_date in date
385 ,p_attribute1 in varchar2
386 ,p_attribute2 in varchar2
387 ,p_attribute3 in varchar2
388 ,p_attribute4 in varchar2
389 ,p_attribute5 in varchar2
390 ,p_attribute6 in varchar2
391 ,p_attribute7 in varchar2
392 ,p_attribute8 in varchar2
393 ,p_attribute9 in varchar2
394 ,p_attribute10 in varchar2
395 ,p_attribute11 in varchar2
396 ,p_attribute12 in varchar2
397 ,p_attribute13 in varchar2
398 ,p_attribute14 in varchar2
399 ,p_attribute15 in varchar2
400 ,p_attribute16 in varchar2
401 ,p_attribute17 in varchar2
402 ,p_attribute18 in varchar2
403 ,p_attribute19 in varchar2
404 ,p_attribute20 in varchar2
405 ,p_business_group_id in number
406 ,p_effective_date in date
407 );
408
409 --Bug 2868775 Pay Proposal
410
411 --
412 -- Bug 3961/1182908 : Initialise any temporal globals before
413 -- each run of the benmngle.
414 --
415 procedure p_init_watif_globals;
416 --
417 END ben_whatif_elig;