[Home] [Help]
PACKAGE: APPS.BEN_EXT_CHLG
Source
1 package ben_ext_chlg AUTHID CURRENT_USER as
2 /* $Header: benxchlg.pkh 120.3.12010000.3 2009/11/24 06:54:44 vkodedal ship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 --
11 Name
12 Benefit Extract Change Log
13 Purpose
14 This package is used to log changes for benefit extract
15 History
16 Date Who Version What?
17 10/28/98 Pdas 115.0 Created.
18 12/14/98 Pdas 115.1 Modified g_per_rec_type.
19 12/21/98 Pdas 115.2 Modified g_per_rec_type.
20 12/29/98 Pdas 115.3 Modified g_per_rec_type.
21 09 Mar 99 G Perry 115.4 IS to AS.
22 23 Mar 99 thayden 115.5 Added procedure log_benefit_chg.
23 12 May 99 isen 115.6 Added new change events
24 16 Jun 99 isen 115.7 Added new change events
25 24 Jun 99 isen 115.8 Added new change events
26 20 Jul 99 isen 115.9 Added log_abs_chg for absence change events
27 09 Aug 99 isen 115.10 Added new and old values
28 29 Sep 99 isen 115.11 Added new change events
29 10 Oct 99 thayden 115.12 Fixed application bug. Changed pos.
30 26 Jan 99 thayden 115.13 Added log_dependent_chg.
31 27 Jan 99 thayden 115.14 Added globals, pcp
32 30 Jan 99 thayden 115.15 Added element entries.
33 02 May 00 shas 115.16 Added g_cont_type and log_con_chg
34 12 Dec 01 Tmathers 115.17 dos2unix for 2128462.
35 23 May 02 tjesumic 115.18 per_infomration1 to 30 ,grade_id
36 correspondence_language,uses_tobacco_flag
37 added fro ansi
38 24 may 02 tjesumic 115.19 set veryfy off added
39 30 may 02 tjesumic 115.20 log_per_pay procedured added for base salary change
40 log_school_chg procedure added
41 log_prem_mo_chg proecude added
42 13 aug 02 glingapp 115.21 Added column normal_hours to g_asg_rec_type
43 and date_to to g_phn_rec_type
44 10-Jan-04 tjesumic 115.22 employee nuber added
45 26-Jan-04 vjhanak 115.24 Added primary flag to the asg record
46 25-Mar-05 tjesumic 115.25 Added position id in asg
47 30-Aug-05 tjesumic 115.26 log_per_chg overload procedure created, that will be called from SSHR
48 api
49 14-Oct-05 vjhanak 115.27 Added soft_coding_keyflex_id to the asg record
50 14-Nov-06 tjesumic 115.28 per_pay_proposal trigger moved to api (pepyprhi.pkb 115.60)
51 the global record changed to have all the column of the table
52 for future requirements.
53 Rqd: pepyprhi.pkb,115.60 benxchglg.pkb 115.61,benxbstg.sql 115.3
54 08-Jul-08 pvelugul 115.29 Modified for 6517369
55 24-Nov-09 vkodedal 115.30 Overloaded log_asg_chg, called from core HR bug#9092938
56
57 */
58 --
59 g_package varchar2(80) := 'ben_ext_chlg';
60 g_prev_upd_adr_person_id per_addresses.person_id%type;
61 g_prev_upd_adr_primary_flag per_addresses.primary_flag%type;
62 g_prev_upd_adr_to_date per_addresses.date_to%type;
63 g_prev_upd_adr_address_line1 per_addresses.address_line1%type;
64 g_prev_upd_adr_address_line2 per_addresses.address_line2%type;
65 g_prev_upd_adr_address_line3 per_addresses.address_line3%type;
66 g_prev_upd_adr_country per_addresses.country%type;
67 g_prev_upd_adr_postal_code per_addresses.postal_code%type;
68 g_prev_upd_adr_region_1 per_addresses.region_1%type;
69 g_prev_upd_adr_region_2 per_addresses.region_2%type;
70 g_prev_upd_adr_region_3 per_addresses.region_3%type;
71 g_prev_upd_adr_town_or_city per_addresses.town_or_city%type;
72 g_prev_upd_adr_address_id per_addresses.address_id%type;
73 -- g_prev_upd_adr_last_update_login
74 --
75 Type g_per_rec_type is RECORD
76 (national_identifier per_all_people_f.national_identifier%type
77 ,full_name per_all_people_f.full_name%type
78 ,last_name per_all_people_f.last_name%type
79 ,first_name per_all_people_f.first_name%type
80 ,middle_names per_all_people_f.middle_names%type
81 ,title per_all_people_f.title%type
82 ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83 ,suffix per_all_people_f.suffix%type
84 ,known_as per_all_people_f.known_as%type
85 ,previous_last_name per_all_people_f.previous_last_name%type
86 ,date_of_birth per_all_people_f.date_of_birth%type
87 ,sex per_all_people_f.sex%type
88 ,marital_status per_all_people_f.marital_status%type
89 ,business_group_id per_all_people_f.business_group_id%type
90 ,person_id per_all_people_f.person_id%type
91 ,person_type_id per_all_people_f.person_type_id%type
92 ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93 ,benefit_group_id per_all_people_f.benefit_group_id%type
94 ,student_status per_all_people_f.student_status%type
95 ,date_of_death per_all_people_f.date_of_death%type
96 ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97 ,effective_start_date per_all_people_f.effective_start_date%type
98 ,effective_end_date per_all_people_f.effective_end_date%type
99 ,attribute1 per_all_people_f.attribute1%type
100 ,attribute2 per_all_people_f.attribute2%type
101 ,attribute3 per_all_people_f.attribute3%type
102 ,attribute4 per_all_people_f.attribute4%type
103 ,attribute5 per_all_people_f.attribute5%type
104 ,attribute6 per_all_people_f.attribute6%type
105 ,attribute7 per_all_people_f.attribute7%type
106 ,attribute8 per_all_people_f.attribute8%type
107 ,attribute9 per_all_people_f.attribute9%type
108 ,attribute10 per_all_people_f.attribute10%type
109 ,email_address per_all_people_f.email_address%type
110 ,employee_number per_all_people_f.employee_number%type
111 ,per_information1 per_all_people_f.per_information1%type
112 ,per_information2 per_all_people_f.per_information2%type
113 ,per_information3 per_all_people_f.per_information3%type
114 ,per_information4 per_all_people_f.per_information4%type
115 ,per_information5 per_all_people_f.per_information5%type
116 ,per_information6 per_all_people_f.per_information6%type
117 ,per_information7 per_all_people_f.per_information7%type
118 ,per_information8 per_all_people_f.per_information8%type
119 ,per_information9 per_all_people_f.per_information9%type
120 ,per_information10 per_all_people_f.per_information10%type
121 ,per_information11 per_all_people_f.per_information11%type
122 ,per_information12 per_all_people_f.per_information12%type
123 ,per_information13 per_all_people_f.per_information13%type
124 ,per_information14 per_all_people_f.per_information14%type
125 ,per_information15 per_all_people_f.per_information15%type
126 ,per_information16 per_all_people_f.per_information16%type
127 ,per_information17 per_all_people_f.per_information17%type
128 ,per_information18 per_all_people_f.per_information18%type
129 ,per_information19 per_all_people_f.per_information19%type
130 ,per_information20 per_all_people_f.per_information20%type
131 ,per_information21 per_all_people_f.per_information21%type
132 ,per_information22 per_all_people_f.per_information22%type
133 ,per_information23 per_all_people_f.per_information23%type
134 ,per_information24 per_all_people_f.per_information24%type
135 ,per_information25 per_all_people_f.per_information25%type
136 ,per_information26 per_all_people_f.per_information26%type
137 ,per_information27 per_all_people_f.per_information27%type
138 ,per_information28 per_all_people_f.per_information28%type
139 ,per_information29 per_all_people_f.per_information29%type
140 ,per_information30 per_all_people_f.per_information30%type
141 ,correspondence_language per_all_people_f.correspondence_language%type
142 ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
143 ,update_mode varchar2(20)
144 );
145 --
146 Type g_cont_rec_type is RECORD
147 (contact_relationship_id per_contact_relationships.contact_relationship_id%type
148 ,contact_type per_contact_relationships.contact_type%type
149 ,person_id per_contact_relationships.person_id%type
150 ,contact_person_id per_contact_relationships.contact_person_id%type
151 ,business_group_id per_contact_relationships.business_group_id%type
152 ,date_start per_contact_relationships.date_start%TYPE
153 );
154 --
155 Type g_add_rec_type is RECORD
156 (address_id per_addresses.address_id%type
157 ,primary_flag per_addresses.primary_flag%type
158 ,person_id per_addresses.person_id%type
159 ,business_group_id per_addresses.business_group_id%type
160 ,address_line1 per_addresses.address_line1%type
161 ,address_line2 per_addresses.address_line2%type
162 ,address_line3 per_addresses.address_line3%type
163 ,country per_addresses.country%type
164 ,postal_code per_addresses.postal_code%type
165 ,region_1 per_addresses.region_1%type
166 ,region_2 per_addresses.region_2%type
167 ,region_3 per_addresses.region_3%type
168 ,town_or_city per_addresses.town_or_city%type
169 ,address_type per_addresses.address_type%type
170 ,date_from per_addresses.date_from%type
171 ,date_to per_addresses.date_to%type
172 );
173 --
174 Type g_asg_rec_type is RECORD
175 (assignment_id per_all_assignments_f.assignment_id%type
176 ,person_id per_all_assignments_f.person_id%type
177 ,business_group_id per_all_assignments_f.business_group_id%type
178 ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type
179 ,hourly_salaried_code per_all_assignments_f.hourly_salaried_code%type
180 ,normal_hours per_all_assignments_f.normal_hours%type --Bug 1554477
181 ,location_id per_all_assignments_f.location_id%type
182 ,position_id per_all_assignments_f.position_id%type
183 ,employment_category per_all_assignments_f.employment_category%type
184 ,assignment_type per_all_assignments_f.assignment_type%type
185 ,effective_start_date per_all_assignments_f.effective_start_date%type
186 ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
187 ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
188 ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
189 ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
190 ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
191 ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
192 ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
193 ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
194 ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
195 ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
196 ,payroll_id per_all_assignments_f.payroll_id%type
197 ,grade_id per_all_assignments_f.grade_id%type
198 --rpinjala
199 ,primary_flag per_all_assignments_f.primary_flag%TYPE
200 --rpinjala
201 -- vjhanak
202 ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
203 -- vjhanak
204 ,effective_end_date per_all_assignments_f.effective_end_date%type
205 ,update_mode varchar2(20)
206 );
207 --
208 Type g_pos_rec_type is RECORD
209 (period_of_service_id per_periods_of_service.period_of_service_id%type
210 ,person_id per_periods_of_service.person_id%type
211 ,business_group_id per_periods_of_service.business_group_id%type
212 ,date_start per_periods_of_service.date_start%type
213 ,actual_termination_date per_periods_of_service.actual_termination_date%type
214 ,leaving_reason per_periods_of_service.leaving_reason%type
215 ,last_update_date per_periods_of_service.last_update_date%type
216 ,update_mode varchar2(20)
217 );
218 --
219 Type g_abs_rec_type is RECORD
220 (absence_attendance_id per_absence_attendances.absence_attendance_id%type
221 ,business_group_id per_absence_attendances.business_group_id%type
222 ,absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%type
223 ,person_id per_absence_attendances.person_id%type
224 ,abs_attendance_reason_id per_absence_attendances.abs_attendance_reason_id%type
225 ,date_start per_absence_attendances.date_start%type
226 ,date_end per_absence_attendances.date_end%type
227 ,date_projected_start per_absence_attendances.date_projected_start%type
228 ,update_mode varchar2(20)
229 );
230 --
231 Type g_apl_rec_type is RECORD
232 (application_id per_applications.application_id%type
233 ,person_id per_applications.person_id%type
234 ,date_received per_applications.date_received%type
235 ,date_end per_applications.date_end%type
236 ,termination_reason per_applications.termination_reason%type
237 ,business_group_id per_applications.business_group_id%type
238 ,update_mode varchar2(20)
239 );
240 --
241 Type g_phn_rec_type is RECORD
242 (phone_id per_phones.phone_id%type
243 ,date_from per_phones.date_from%type
244 ,date_to per_phones.date_to%type --Bug 1554477
245 ,phone_type per_phones.phone_type%type
246 ,phone_number per_phones.phone_number%type
247 ,parent_table per_phones.parent_table%type
248 ,parent_id per_phones.parent_id%type
249 ,update_mode varchar2(20)
250 );
251 --
252 Type g_ptu_rec_type is RECORD
253 (person_type_usage_id per_person_type_usages_f.person_type_usage_id%type
254 ,person_id per_person_type_usages_f.person_id%type
255 ,effective_start_date per_person_type_usages_f.effective_start_date%type
256 ,person_type_id per_person_type_usages_f.person_type_id%type
257 ,update_mode varchar2(20)
258 );
259 ---
260 Type g_per_pay_rec_type is RECORD
261 (PERSON_ID per_all_people_f.person_id%type
262 ,BUSINESS_GROUP_ID per_pay_proposals.BUSINESS_GROUP_ID%type
263 ,PAY_PROPOSAL_ID per_pay_proposals.assignment_id%type
264 ,OBJECT_VERSION_NUMBER per_pay_proposals.OBJECT_VERSION_NUMBER%type
265 ,ASSIGNMENT_ID per_pay_proposals.ASSIGNMENT_ID%type
266 ,EVENT_ID per_pay_proposals.EVENT_ID%type
267 ,CHANGE_DATE per_pay_proposals.CHANGE_DATE%type
268 ,LAST_CHANGE_DATE per_pay_proposals.LAST_CHANGE_DATE%type
269 ,NEXT_PERF_REVIEW_DATE per_pay_proposals.NEXT_PERF_REVIEW_DATE%type
270 ,NEXT_SAL_REVIEW_DATE per_pay_proposals.NEXT_SAL_REVIEW_DATE%type
271 ,PERFORMANCE_RATING per_pay_proposals.PERFORMANCE_RATING%type
272 ,PROPOSAL_REASON per_pay_proposals.PROPOSAL_REASON%type
273 ,PROPOSED_SALARY_N per_pay_proposals.PROPOSED_SALARY_N%type
274 ,REVIEW_DATE per_pay_proposals.REVIEW_DATE%type
278 ,PERFORMANCE_REVIEW_ID per_pay_proposals.PERFORMANCE_REVIEW_ID%type
275 ,APPROVED per_pay_proposals.APPROVED%type
276 ,MULTIPLE_COMPONENTS per_pay_proposals.MULTIPLE_COMPONENTS%type
277 ,FORCED_RANKING per_pay_proposals.FORCED_RANKING%type
279 ,ATTRIBUTE1 per_pay_proposals.ATTRIBUTE1%type
280 ,ATTRIBUTE2 per_pay_proposals.ATTRIBUTE1%type
281 ,ATTRIBUTE3 per_pay_proposals.ATTRIBUTE1%type
282 ,ATTRIBUTE4 per_pay_proposals.ATTRIBUTE1%type
283 ,ATTRIBUTE5 per_pay_proposals.ATTRIBUTE1%type
284 ,ATTRIBUTE6 per_pay_proposals.ATTRIBUTE1%type
285 ,ATTRIBUTE7 per_pay_proposals.ATTRIBUTE1%type
286 ,ATTRIBUTE8 per_pay_proposals.ATTRIBUTE1%type
287 ,ATTRIBUTE9 per_pay_proposals.ATTRIBUTE1%type
288 ,ATTRIBUTE10 per_pay_proposals.ATTRIBUTE1%type
289 ,ATTRIBUTE11 per_pay_proposals.ATTRIBUTE1%type
290 ,ATTRIBUTE12 per_pay_proposals.ATTRIBUTE1%type
291 ,ATTRIBUTE13 per_pay_proposals.ATTRIBUTE1%type
292 ,ATTRIBUTE14 per_pay_proposals.ATTRIBUTE1%type
293 ,ATTRIBUTE15 per_pay_proposals.ATTRIBUTE1%type
294 ,ATTRIBUTE16 per_pay_proposals.ATTRIBUTE1%type
295 ,ATTRIBUTE17 per_pay_proposals.ATTRIBUTE1%type
296 ,ATTRIBUTE18 per_pay_proposals.ATTRIBUTE1%type
297 ,ATTRIBUTE19 per_pay_proposals.ATTRIBUTE1%type
298 ,ATTRIBUTE20 per_pay_proposals.ATTRIBUTE1%type
299 ,PROPOSED_SALARY per_pay_proposals.PROPOSED_SALARY%type
300 ,date_to per_pay_proposals.date_to%type
301 ,update_mode varchar2(20)
302 );
303 --
304
305 Type g_per_school_rec_type is RECORD
306 (person_id per_establishment_attendances.person_id%type
307 ,full_time per_establishment_attendances.full_time%type
308 ,attended_end_date per_establishment_attendances.attended_end_date%type
309 ,establishment_id per_establishment_attendances.establishment_id%type
310 ,attended_start_date per_establishment_attendances.attended_start_date%type
311 ,business_group_id per_establishment_attendances.business_group_id%type
312 ,update_mode varchar2(20)
313 );
314
315 Type g_prem_mo_rec_type is RECORD
316 (prtt_prem_id ben_prtt_prem_by_mo_f.prtt_prem_id%type
317 ,val ben_prtt_prem_by_mo_f.val%type
318 ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319 ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320 ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321 ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322 ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
323 ,cr_val ben_prtt_prem_by_mo_f.cr_val%type
324 ,uom ben_prtt_prem_by_mo_f.uom%type
325 ,update_mode varchar2(20)
326 );
327 --
328 -- added for bug 6517369 to audit changes to per_disabilities_f
329 Type per_dis_rec_type is RECORD
330 (person_id per_disabilities_f.person_id%type
331 ,effective_start_date per_disabilities_f.effective_start_date%type
332 ,effective_end_date per_disabilities_f.effective_end_date%type
333 ,business_group_id per_all_people_f.business_group_id%type
334 ,incident_id per_disabilities_f.incident_id%type
335 ,organization_id per_disabilities_f.organization_id%type
336 ,registration_id per_disabilities_f.registration_id%type
337 ,registration_date per_disabilities_f.registration_date%type
338 ,registration_exp_date per_disabilities_f.registration_exp_date%type
339 ,categoryname per_disabilities_f.category%type
340 ,description per_disabilities_f.description%type
341 ,degree per_disabilities_f.degree%type
342 ,quota_fte per_disabilities_f.quota_fte%type
343 ,reason per_disabilities_f.reason%type
344 ,pre_registration_job per_disabilities_f.pre_registration_job%type
345 ,work_restriction per_disabilities_f.work_restriction%type
346 ,object_version_number per_disabilities_f.object_version_number%type
347 ,status per_disabilities_f.status%type
348 ,attribute1 per_disabilities_f.attribute1%type
349 ,attribute2 per_disabilities_f.attribute2%type
350 ,attribute3 per_disabilities_f.attribute3%type
351 ,attribute4 per_disabilities_f.attribute4%type
352 ,attribute5 per_disabilities_f.attribute5%type
353 ,attribute6 per_disabilities_f.attribute6%type
354 ,attribute7 per_disabilities_f.attribute7%type
355 ,attribute8 per_disabilities_f.attribute8%type
356 ,attribute9 per_disabilities_f.attribute9%type
357 ,attribute10 per_disabilities_f.attribute10%type
358 ,dis_information1 per_disabilities_f.dis_information1%type
359 ,dis_information2 per_disabilities_f.dis_information2%type
360 ,dis_information3 per_disabilities_f.dis_information3%type
361 ,dis_information4 per_disabilities_f.dis_information4%type
362 ,dis_information5 per_disabilities_f.dis_information5%type
363 ,dis_information6 per_disabilities_f.dis_information6%type
364 ,dis_information7 per_disabilities_f.dis_information7%type
365 ,dis_information8 per_disabilities_f.dis_information8%type
366 ,dis_information9 per_disabilities_f.dis_information9%type
367 ,dis_information10 per_disabilities_f.dis_information10%type
368 ,update_mode varchar2(20)
369 );
370
371 --
372 Type g_char_tab_type is table of varchar2(200)
373 index by binary_integer;
374 --
375 Type g_date_tab_type is table of date
376 index by binary_integer;
377 --
378 Type g_num_tab_type is table of number
379 index by binary_integer;
380 --
381 Type g_old_val is table of ben_ext_chg_evt_log.old_val1%type
382 index by binary_integer;
383 --
384 Type g_new_val is table of ben_ext_chg_evt_log.new_val1%type
385 index by binary_integer;
386
387 --
388 procedure log_prem_mo_chg
389 (p_event in varchar2
390 ,p_old_rec in g_prem_mo_rec_type
391 ,p_new_rec in g_prem_mo_rec_type
392 ) ;
393 --
394 procedure log_per_pay_chg
395 (p_event in varchar2
396 ,p_old_rec in g_per_pay_rec_type
397 ,p_new_rec in g_per_pay_rec_type
398 ) ;
399 --
400 procedure log_school_chg
401 (p_event in varchar2
402 ,p_old_rec in g_per_school_rec_type
403 ,p_new_rec in g_per_school_rec_type
404 );
405
406 --
407 procedure log_per_chg
408 (p_event in varchar2
409 ,p_old_rec in g_per_rec_type
410 ,p_new_rec in g_per_rec_type
411 );
412
413 --- this is a overlaod procedure to call from SSHR
414 procedure log_per_chg
415 (p_event in varchar2
416 ,p_old_rec in per_per_shd.g_rec_type
417 ,p_new_rec in per_per_shd.g_rec_type
418 ---- ,p_mode in varchar2
419 );
420
421 --
422 procedure log_cont_chg
423 (
424 p_old_rec in g_cont_rec_type
425 ,p_new_rec in g_cont_rec_type
426 );
427 --
428 procedure log_add_chg
429 (p_event in varchar2
430 ,p_old_rec in g_add_rec_type
431 ,p_new_rec in g_add_rec_type
432 );
433 --
434 procedure log_asg_chg
435 (p_event in varchar2
436 ,p_old_rec in g_asg_rec_type
437 ,p_new_rec in g_asg_rec_type
438 );
439 -- this is a overload procedure to call from core HR api
440 procedure log_asg_chg
441 (p_event in varchar2
442 ,p_old_rec in per_asg_shd.g_rec_type
443 ,p_new_rec in per_asg_shd.g_rec_type
444 );
445 --
446 procedure log_abs_chg
447 (p_event in varchar2
448 ,p_old_rec in g_abs_rec_type
449 ,p_new_rec in g_abs_rec_type
450 );
451 --
452 procedure log_pos_chg
453 (p_event in varchar2
454 ,p_old_rec in g_pos_rec_type
455 ,p_new_rec in g_pos_rec_type
456 );
457 --
458 procedure log_apl_chg
459 (p_event in varchar2
460 ,p_old_rec in g_apl_rec_type
461 ,p_new_rec in g_apl_rec_type
462 );
463 --
464 procedure log_phn_chg
465 (p_event in varchar2
466 ,p_old_rec in g_phn_rec_type
467 ,p_new_rec in g_phn_rec_type
468 );
469 --
470 procedure log_ptu_chg
471 (p_event in varchar2
472 ,p_old_rec in g_ptu_rec_type
473 ,p_new_rec in g_ptu_rec_type
474 );
475 --
476 procedure log_benefit_chg(
477 p_action in varchar2, -- CREATE,UPDATE, or DELETE
478 p_pl_id in number default null,
479 p_old_pl_id in number default null,
480 p_oipl_id in number default null,
481 p_old_oipl_id in number default null,
482 p_enrt_cvg_strt_dt in date default null,
483 p_enrt_cvg_end_dt in date default null,
484 p_old_enrt_cvg_strt_dt in date default null,
485 p_old_enrt_cvg_end_dt in date default null,
486 p_bnft_amt in number default null,
487 p_old_bnft_amt in number default null,
488 p_pen_attribute1 in varchar2 default null,
489 p_pen_attribute2 in varchar2 default null,
490 p_pen_attribute3 in varchar2 default null,
491 p_pen_attribute4 in varchar2 default null,
492 p_pen_attribute5 in varchar2 default null,
493 p_pen_attribute6 in varchar2 default null,
494 p_pen_attribute7 in varchar2 default null,
495 p_pen_attribute8 in varchar2 default null,
496 p_pen_attribute9 in varchar2 default null,
497 p_pen_attribute10 in varchar2 default null,
498 p_old_pen_attribute1 in varchar2 default null,
499 p_old_pen_attribute2 in varchar2 default null,
500 p_old_pen_attribute3 in varchar2 default null,
501 p_old_pen_attribute4 in varchar2 default null,
502 p_old_pen_attribute5 in varchar2 default null,
503 p_old_pen_attribute6 in varchar2 default null,
504 p_old_pen_attribute7 in varchar2 default null,
505 p_old_pen_attribute8 in varchar2 default null,
506 p_old_pen_attribute9 in varchar2 default null,
507 p_old_pen_attribute10 in varchar2 default null,
508 p_effective_start_date in date default null,
509 p_effective_end_date in date default null,
513 p_old_per_in_ler_id in number default null,
510 p_prtt_enrt_rslt_id in number default null,
511 p_old_prtt_enrt_rslt_id in number default null,
512 p_per_in_ler_id in number default null,
514 p_person_id in number,
515 p_business_group_id in number,
516 p_effective_date in date);
517
518 --
519 procedure log_dependent_chg(
520 p_action in varchar2, -- CREATE,UPDATE, or DELETE
521 p_pl_id in number default null,
522 p_oipl_id in number default null,
523 p_cvg_strt_dt in date default null,
527 p_effective_start_date in date default null,
524 p_cvg_end_dt in date default null,
525 p_old_cvg_strt_dt in date default null,
526 p_old_cvg_end_dt in date default null,
528 p_effective_end_date in date default null,
529 p_prtt_enrt_rslt_id in number default null,
530 p_per_in_ler_id in number default null,
531 p_elig_cvrd_dpnt_id in number default null,
532 p_person_id in number,
533 p_dpnt_person_id in number,
534 p_business_group_id in number,
535 p_effective_date in date);
536
537 procedure log_pcp_chg(
538 p_action in varchar2,
539 p_ext_ident in varchar2 default null,
540 p_old_ext_ident in varchar2 default null,
541 p_name in varchar2 default null,
542 p_old_name in varchar2 default null,
543 p_prmry_care_prvdr_typ_cd in varchar2 default null,
544 p_old_prmry_care_prvdr_typ_cd in varchar2 default null,
545 p_prmry_care_prvdr_id in number default null,
546 p_elig_cvrd_dpnt_id in number default null,
547 p_prtt_enrt_rslt_id in number default null,
548 p_effective_start_date in date default null,
549 p_effective_end_date in date default null,
550 p_business_group_id in number,
551 p_effective_date in date);
552
553 procedure log_element_chg(
554 p_action in varchar2,
555 p_amt in number default null,
556 p_old_amt in number default null,
557 p_input_value_id in number default null,
558 p_element_entry_id in number default null,
559 p_person_id in number default null,
560 p_effective_start_date in date default null,
561 p_effective_end_date in date default null,
562 p_business_group_id in number,
563 p_effective_date in date);
564
565 --procedure for logging changes to per_disabilities_f
566 procedure log_per_dis_chg(
567 p_event in varchar2,
568 p_old_rec in per_dis_rec_type,
569 p_new_rec in per_dis_rec_type);
570
571
572 end ben_ext_chlg;
573