[Home] [Help]
24: 12/21/98 Pdas 115.4 Added History Info.
25: 12/29/98 Pdas 115.5 Added prmtr_03..prmtr_07.
26: 02/24/99 mhoyes 115.6 Modified log_add_chg passed in
27: old business_group_id to
28: ben_ext_chg_evt_api.create_ext_chg_evt
29: rather than the new value
30: 03/08/99 tmathers 115.7 Changed MON-YYYY to /MM/YYYY.
31: 09 Mar 99 G Perry 115.8 IS to AS.
32: 23 Mar 99 thayden 115.9 Added procedure log_benefit_chg.
90: 09-Jan-04 rpgupta 115.47 Make change eff dt for delete phones as
91: greatest(nvl(dt_to, dt_from), sysdate)
92: 26-Jan-04 vjhanak 115.48 Changes made to track the creation of secondary
93: employeee assignment for NL.
94: 24-Feb-05 vborkar 115.49 In calls to ben_ext_chg_evt_api.create_ext_chg_evt,
95: whenever person's full name was getting truncated
96: to 200 characters, increased it to 240 characters.
97: 24-mar-05 tjesumic 115.50 position added in log
98: 11-Aug-05 rgajula 115.51 Bug 4539732 Changed the date type of l_chg_eff_dt to
1397:
1398: end if;
1399: for l_count in 1..l_chg_evt_tab.count loop
1400: if change_event_is_enabled(l_chg_evt_tab(l_count),p_new_rec.effective_start_date) then
1401: ben_ext_chg_evt_api.create_ext_chg_evt
1402: (p_validate => FALSE
1403: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
1404: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
1405: ,p_chg_eff_dt => p_new_rec.effective_start_date
1581: for l_count in l_ini_tab_counter+1..l_ini_tab_counter+l_cont_chg_evt_tab.count loop
1582: if change_event_is_enabled(l_cont_chg_evt_tab(l_count),p_new_rec.effective_start_date)
1583: then
1584:
1585: ben_ext_chg_evt_api.create_ext_chg_evt
1586: (p_validate => FALSE
1587: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
1588: ,p_chg_evt_cd => l_cont_chg_evt_tab(l_count)
1589: ,p_chg_eff_dt => p_new_rec.effective_start_date
1765: hr_utility.set_location ( ' change event ' || l_cont_chg_evt_tab(l_count) , 11 ) ;
1766: if change_event_is_enabled(l_cont_chg_evt_tab(l_count),p_new_rec.effective_start_date)
1767: then
1768:
1769: ben_ext_chg_evt_api.create_ext_chg_evt
1770: (p_validate => FALSE
1771: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
1772: ,p_chg_evt_cd => l_cont_chg_evt_tab(l_count)
1773: ,p_chg_eff_dt => p_new_rec.effective_start_date
1941: end if;
1942: for l_count in 1..l_chg_evt_tab.count loop
1943: if change_event_is_enabled(l_chg_evt_tab(l_count),trunc(sysdate)) then
1944: hr_utility.set_location ( 'calling api ' ,99) ;
1945: ben_ext_chg_evt_api.create_ext_chg_evt
1946: (p_validate => FALSE
1947: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
1948: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
1949: ,p_chg_eff_dt => l_chg_eff_tab(l_count)
3019: if change_event_is_enabled(l_chg_evt_tab(l_count),trunc(sysdate)) then
3020: if l_chg_evt_tab(l_count) in ('CCPA','CCMA','CCNPA','CCNMA') then
3021: l_person_id := nvl(l_prmtr_07_tab(l_count),l_relationship);
3022: end if;
3023: ben_ext_chg_evt_api.create_ext_chg_evt
3024: (p_validate => FALSE
3025: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
3026: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
3027: ,p_chg_eff_dt => l_chg_eff_tab(l_count)
3629: end if;
3630: --
3631: for l_count in 1..l_chg_evt_tab.count loop
3632: if change_event_is_enabled(l_chg_evt_tab(l_count),p_new_rec.effective_start_date) then
3633: ben_ext_chg_evt_api.create_ext_chg_evt
3634: (p_validate => FALSE
3635: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
3636: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
3637: ,p_chg_eff_dt => p_new_rec.effective_start_date
3857: --
3858: --
3859: for l_count in 1..l_chg_evt_tab.count loop
3860: if change_event_is_enabled(l_chg_evt_tab(l_count),l_chg_eff_dt) then
3861: ben_ext_chg_evt_api.create_ext_chg_evt
3862: (p_validate => FALSE
3863: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
3864: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
3865: ,p_chg_eff_dt => l_chg_eff_dt
3993: if p_old_oipl_id is null or (p_old_oipl_id
3994: is not null and p_oipl_id = p_old_oipl_id) then
3995: if nvl(p_bnft_amt,0) <> nvl(p_old_bnft_amt,0) and
3996: change_event_is_enabled('COECA',p_effective_date) then
3997: ben_ext_chg_evt_api.create_ext_chg_evt
3998: (p_validate => FALSE
3999: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4000: ,p_chg_evt_cd => 'COECA' -- Change Coverage Amount
4001: ,p_chg_eff_dt => p_effective_date
4015: --
4016: else
4017:
4018: if change_event_is_enabled('AB',p_effective_date) then
4019: ben_ext_chg_evt_api.create_ext_chg_evt
4020: (p_validate => FALSE
4021: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4022: ,p_chg_evt_cd => 'AB' -- Add Benefit
4023: ,p_chg_eff_dt => p_effective_date
4048: fetch c_option_name into l_new_option_name;
4049: close c_option_name;
4050: --
4051: if change_event_is_enabled('RB',p_effective_date) then
4052: ben_ext_chg_evt_api.create_ext_chg_evt
4053: (p_validate => FALSE
4054: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4055: ,p_chg_evt_cd => 'RB' -- Reinstate Benefit
4056: ,p_chg_eff_dt => p_effective_date
4091: fetch c_option_name into l_old_option_name;
4092: close c_option_name;
4093: --
4094: if change_event_is_enabled('TBBC',p_effective_date) then
4095: ben_ext_chg_evt_api.create_ext_chg_evt
4096: (p_validate => FALSE
4097: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4098: ,p_chg_evt_cd => 'TBBC' -- Terminate Benefit before Coverage
4099: ,p_chg_eff_dt => p_effective_date --??
4125: fetch c_option_name into l_old_option_name;
4126: close c_option_name;
4127:
4128: if change_event_is_enabled('TBAC',p_effective_date) then
4129: ben_ext_chg_evt_api.create_ext_chg_evt
4130: (p_validate => FALSE
4131: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4132: ,p_chg_evt_cd => 'TBAC' -- Terminate Benefit after Coverage
4133: ,p_chg_eff_dt => p_effective_date --??
4159: fetch c_option_name into l_new_option_name;
4160: close c_option_name;
4161:
4162: if change_event_is_enabled('AB',p_effective_date) then
4163: ben_ext_chg_evt_api.create_ext_chg_evt
4164: (p_validate => FALSE
4165: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4166: ,p_chg_evt_cd => 'AB' -- Add Benefit
4167: ,p_chg_eff_dt => p_effective_date
4194: fetch c_option_name into l_old_option_name;
4195: close c_option_name;
4196: --
4197: if change_event_is_enabled('UOBO',p_effective_date) then
4198: ben_ext_chg_evt_api.create_ext_chg_evt
4199: (p_validate => FALSE
4200: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4201: ,p_chg_evt_cd => 'UOBO' -- Change of Option
4202: ,p_chg_eff_dt => p_effective_date
4220: --
4221: if p_enrt_cvg_strt_dt <> p_old_enrt_cvg_strt_dt then
4222: --
4223: if change_event_is_enabled('CCSD',p_effective_date) then
4224: ben_ext_chg_evt_api.create_ext_chg_evt
4225: (p_validate => FALSE
4226: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4227: ,p_chg_evt_cd => 'CCSD' -- Change Coverage Start Date
4228: ,p_chg_eff_dt => p_effective_date
4242: --
4243: if p_enrt_cvg_end_dt <> p_old_enrt_cvg_end_dt then
4244: --
4245: if change_event_is_enabled('CCED',p_effective_date) then
4246: ben_ext_chg_evt_api.create_ext_chg_evt
4247: (p_validate => FALSE
4248: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4249: ,p_chg_evt_cd => 'CCED' -- Change Coverage End Date
4250: ,p_chg_eff_dt => p_effective_date
4264: --
4265: if p_bnft_amt <> p_old_bnft_amt then
4266: --
4267: if change_event_is_enabled('COECA',p_effective_date) then
4268: ben_ext_chg_evt_api.create_ext_chg_evt
4269: (p_validate => FALSE
4270: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4271: ,p_chg_evt_cd => 'COECA' -- Change Coverage Amount
4272: ,p_chg_eff_dt => p_effective_date
4286: --
4287: if p_pen_attribute1 <> p_old_pen_attribute1 then
4288: --
4289: if change_event_is_enabled('COEF01',p_effective_date) then
4290: ben_ext_chg_evt_api.create_ext_chg_evt
4291: (p_validate => FALSE
4292: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4293: ,p_chg_evt_cd => 'COEF01' -- Change Flex field
4294: ,p_chg_eff_dt => p_effective_date
4308: --
4309: if p_pen_attribute2 <> p_old_pen_attribute2 then
4310: --
4311: if change_event_is_enabled('COEF02',p_effective_date) then
4312: ben_ext_chg_evt_api.create_ext_chg_evt
4313: (p_validate => FALSE
4314: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4315: ,p_chg_evt_cd => 'COEF02' -- Change Flex field
4316: ,p_chg_eff_dt => p_effective_date
4331: --
4332: if p_pen_attribute3 <> p_old_pen_attribute3 then
4333: --
4334: if change_event_is_enabled('COEF03',p_effective_date) then
4335: ben_ext_chg_evt_api.create_ext_chg_evt
4336: (p_validate => FALSE
4337: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4338: ,p_chg_evt_cd => 'COEF03' -- Change Flex field
4339: ,p_chg_eff_dt => p_effective_date
4353: --
4354: if p_pen_attribute4 <> p_old_pen_attribute4 then
4355: --
4356: if change_event_is_enabled('COEF04',p_effective_date) then
4357: ben_ext_chg_evt_api.create_ext_chg_evt
4358: (p_validate => FALSE
4359: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4360: ,p_chg_evt_cd => 'COEF04' -- Change Flex field
4361: ,p_chg_eff_dt => p_effective_date
4375: --
4376: if p_pen_attribute5 <> p_old_pen_attribute5 then
4377: --
4378: if change_event_is_enabled('COEF05',p_effective_date) then
4379: ben_ext_chg_evt_api.create_ext_chg_evt
4380: (p_validate => FALSE
4381: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4382: ,p_chg_evt_cd => 'COEF05' -- Change Flex field
4383: ,p_chg_eff_dt => p_effective_date
4397: --
4398: if p_pen_attribute6 <> p_old_pen_attribute6 then
4399: --
4400: if change_event_is_enabled('COEF06',p_effective_date) then
4401: ben_ext_chg_evt_api.create_ext_chg_evt
4402: (p_validate => FALSE
4403: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4404: ,p_chg_evt_cd => 'COEF06' -- Change Flex field
4405: ,p_chg_eff_dt => p_effective_date
4419: --
4420: if p_pen_attribute7 <> p_old_pen_attribute7 then
4421: --
4422: if change_event_is_enabled('COEF07',p_effective_date) then
4423: ben_ext_chg_evt_api.create_ext_chg_evt
4424: (p_validate => FALSE
4425: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4426: ,p_chg_evt_cd => 'COEF07' -- Change Flex field
4427: ,p_chg_eff_dt => p_effective_date
4441: --
4442: if p_pen_attribute8 <> p_old_pen_attribute8 then
4443: --
4444: if change_event_is_enabled('COEF08',p_effective_date) then
4445: ben_ext_chg_evt_api.create_ext_chg_evt
4446: (p_validate => FALSE
4447: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4448: ,p_chg_evt_cd => 'COEF08' -- Change Flex field
4449: ,p_chg_eff_dt => p_effective_date
4463: --
4464: if p_pen_attribute9 <> p_old_pen_attribute9 then
4465: --
4466: if change_event_is_enabled('COEF09',p_effective_date) then
4467: ben_ext_chg_evt_api.create_ext_chg_evt
4468: (p_validate => FALSE
4469: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4470: ,p_chg_evt_cd => 'COEF09' -- Change Flex field
4471: ,p_chg_eff_dt => p_effective_date
4485: --
4486: if p_pen_attribute10 <> p_old_pen_attribute10 then
4487: --
4488: if change_event_is_enabled('COEF10',p_effective_date) then
4489: ben_ext_chg_evt_api.create_ext_chg_evt
4490: (p_validate => FALSE
4491: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4492: ,p_chg_evt_cd => 'COEF10' -- Change Flex field
4493: ,p_chg_eff_dt => p_effective_date
4520: fetch c_option_name into l_old_option_name;
4521: close c_option_name;
4522: --
4523: if change_event_is_enabled('TBBC',p_effective_date) then
4524: ben_ext_chg_evt_api.create_ext_chg_evt
4525: (p_validate => FALSE
4526: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4527: ,p_chg_evt_cd => 'TBBC' -- Terminate Benefit before Coverage
4528: ,p_chg_eff_dt => p_effective_date
4554: fetch c_option_name into l_old_option_name;
4555: close c_option_name;
4556:
4557: if change_event_is_enabled('TBAC',p_effective_date) then
4558: ben_ext_chg_evt_api.create_ext_chg_evt
4559: (p_validate => FALSE
4560: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4561: ,p_chg_evt_cd => 'TBAC' -- Terminate Benefit after Coverage
4562: ,p_chg_eff_dt => p_effective_date
4679: -- the change log. 'Add Dependent' for the employee person, and 'Add Benefit'
4680: -- for the dependent person.
4681: --
4682: if change_event_is_enabled('AB',p_effective_date) then
4683: ben_ext_chg_evt_api.create_ext_chg_evt
4684: (p_validate => FALSE
4685: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4686: ,p_chg_evt_cd => 'AB' -- Add Benefit
4687: ,p_chg_eff_dt => p_effective_date
4702: );
4703: end if;
4704: --
4705: if change_event_is_enabled('AD',p_effective_date) then
4706: ben_ext_chg_evt_api.create_ext_chg_evt
4707: (p_validate => FALSE
4708: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4709: ,p_chg_evt_cd => 'AD' -- Add Dependent
4710: ,p_chg_eff_dt => p_effective_date
4729: --
4730: elsif p_action = 'REINSTATE' then
4731: --
4732: if change_event_is_enabled('RB',p_effective_date) then
4733: ben_ext_chg_evt_api.create_ext_chg_evt
4734: (p_validate => FALSE
4735: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4736: ,p_chg_evt_cd => 'RB' -- Reinstate Benefit
4737: ,p_chg_eff_dt => p_effective_date
4756: );
4757: end if;
4758: --
4759: if change_event_is_enabled('AD',p_effective_date) then
4760: ben_ext_chg_evt_api.create_ext_chg_evt
4761: (p_validate => FALSE
4762: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4763: ,p_chg_evt_cd => 'AD' -- Add dependent This should later change to
4764: -- Reinstate Dependent.
4792: --
4793: if p_cvg_end_dt < p_cvg_strt_dt then
4794: --
4795: if change_event_is_enabled('TBBC',p_effective_date) then
4796: ben_ext_chg_evt_api.create_ext_chg_evt
4797: (p_validate => FALSE
4798: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4799: ,p_chg_evt_cd => 'TBBC' -- Terminate Benefit before Coverage
4800: ,p_chg_eff_dt => p_effective_date
4821: --
4822: else
4823: --
4824: if change_event_is_enabled('TBAC',p_effective_date) then
4825: ben_ext_chg_evt_api.create_ext_chg_evt
4826: (p_validate => FALSE
4827: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4828: ,p_chg_evt_cd => 'TBAC' -- Terminate Benefit after Coverage
4829: ,p_chg_eff_dt => p_effective_date
4850: --
4851: end if; -- eff date
4852: --
4853: if change_event_is_enabled('DD',p_effective_date) then
4854: ben_ext_chg_evt_api.create_ext_chg_evt
4855: (p_validate => FALSE
4856: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4857: ,p_chg_evt_cd => 'DD' -- Delete Dependent
4858: ,p_chg_eff_dt => p_effective_date
4996: if p_action = 'CREATE' then
4997: if change_event_is_enabled('APCP',p_effective_date) then
4998: l_pcp_chg := TRUE;
4999: if l_person_id is not null then
5000: ben_ext_chg_evt_api.create_ext_chg_evt
5001: (p_validate => FALSE
5002: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5003: ,p_chg_evt_cd => 'APCP'
5004: ,p_chg_eff_dt => p_effective_date
5020: if p_prmry_care_prvdr_typ_cd <> p_old_prmry_care_prvdr_typ_cd then
5021: --
5022: if change_event_is_enabled('COPT',p_effective_date) then
5023: l_pcp_chg := TRUE;
5024: ben_ext_chg_evt_api.create_ext_chg_evt
5025: (p_validate => FALSE
5026: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5027: ,p_chg_evt_cd => 'COPT'
5028: ,p_chg_eff_dt => p_effective_date
5046: if p_name <> p_old_name then
5047: --
5048: if change_event_is_enabled('COPN',p_effective_date) then
5049: l_pcp_chg := TRUE;
5050: ben_ext_chg_evt_api.create_ext_chg_evt
5051: (p_validate => FALSE
5052: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5053: ,p_chg_evt_cd => 'COPN'
5054: ,p_chg_eff_dt => p_effective_date
5070: end if;
5071: --
5072: if p_ext_ident <> p_old_ext_ident then
5073: if change_event_is_enabled('COPI',p_effective_date) then
5074: ben_ext_chg_evt_api.create_ext_chg_evt
5075: (p_validate => FALSE
5076: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5077: ,p_chg_evt_cd => 'COPI'
5078: ,p_chg_eff_dt => p_effective_date
5096: elsif p_action = 'DELETE' then
5097: --
5098: if change_event_is_enabled('DPCP',p_effective_date) then
5099: l_pcp_chg := TRUE;
5100: ben_ext_chg_evt_api.create_ext_chg_evt
5101: (p_validate => FALSE
5102: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5103: ,p_chg_evt_cd => 'DPCP'
5104: ,p_chg_eff_dt => p_effective_date
5125: elsif c_relationship%found then
5126: close c_relationship;
5127: l_person_id := l_relationship;
5128: if p_action = 'CREATE' then
5129: ben_ext_chg_evt_api.create_ext_chg_evt
5130: (p_validate => FALSE
5131: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5132: ,p_chg_evt_cd => 'CCPC'
5133: ,p_chg_eff_dt => p_effective_date
5147: v_prmry_care_prvdr_typ_cd := l_prmry_care_prvdr_typ_cd;
5148: else
5149: v_prmry_care_prvdr_typ_cd := l_old_prmry_care_prvdr_typ_cd;
5150: end if;
5151: ben_ext_chg_evt_api.create_ext_chg_evt
5152: (p_validate => FALSE
5153: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5154: ,p_chg_evt_cd => 'CCPC'
5155: ,p_chg_eff_dt => p_effective_date
5167: ,p_new_val1 => substr(l_name,1,240)
5168: ,p_new_val2 => substr(p_name,1,240)
5169: ,p_new_val3 => v_prmry_care_prvdr_typ_cd);
5170: elsif p_action = 'DELETE' then
5171: ben_ext_chg_evt_api.create_ext_chg_evt
5172: (p_validate => FALSE
5173: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5174: ,p_chg_evt_cd => 'CCPC'
5175: ,p_chg_eff_dt => p_effective_date
5194: fetch c_con_relationship into l_contact,l_relationship,l_name;
5195: exit when c_con_relationship%notfound ;
5196: l_person_id := l_relationship;
5197: if p_action = 'CREATE' then
5198: ben_ext_chg_evt_api.create_ext_chg_evt
5199: (p_validate => FALSE
5200: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5201: ,p_chg_evt_cd => 'CCNPC'
5202: ,p_chg_eff_dt => p_effective_date
5216: v_prmry_care_prvdr_typ_cd := l_prmry_care_prvdr_typ_cd;
5217: else
5218: v_prmry_care_prvdr_typ_cd := l_old_prmry_care_prvdr_typ_cd;
5219: end if;
5220: ben_ext_chg_evt_api.create_ext_chg_evt
5221: (p_validate => FALSE
5222: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5223: ,p_chg_evt_cd => 'CCNPC'
5224: ,p_chg_eff_dt => p_effective_date
5236: ,p_new_val1 => substr(l_name,1,240)
5237: ,p_new_val2 => substr(p_name,1,240)
5238: ,p_new_val3 => v_prmry_care_prvdr_typ_cd);
5239: elsif p_action = 'DELETE' then
5240: ben_ext_chg_evt_api.create_ext_chg_evt
5241: (p_validate => FALSE
5242: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5243: ,p_chg_evt_cd => 'CCNPC'
5244: ,p_chg_eff_dt => p_effective_date
5412: --
5413: for l_count in 1..l_chg_evt_tab.count loop
5414: if change_event_is_enabled(l_chg_evt_tab(l_count),l_chg_eff_dt(l_count)) then
5415: --Bug 4539732 Create ext change event with each event having its own l_chg_eff_dt
5416: ben_ext_chg_evt_api.create_ext_chg_evt
5417: (p_validate => FALSE
5418: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5419: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
5420: ,p_chg_eff_dt => l_chg_eff_dt(l_count)
5535: change_event_is_enabled('CCOPMPRM',p_new_rec.effective_start_date) ) then
5536:
5537: hr_utility.set_location('calling log event :', 10);
5538:
5539: ben_ext_chg_evt_api.create_ext_chg_evt
5540: (p_validate => FALSE
5541: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5542: ,p_chg_evt_cd => 'CCOPMPRM'
5543: ,p_chg_eff_dt => p_new_rec.effective_start_date
5593: if nvl(l_new_name,'$$$$') <> nvl(l_old_name,'$$$$')
5594: or p_new_rec.attended_start_date <> p_old_rec.attended_start_date
5595: or p_new_rec.attended_end_date <> p_old_rec.attended_end_date then
5596: if change_event_is_enabled('COSCOL',p_new_rec.attended_start_date) then
5597: ben_ext_chg_evt_api.create_ext_chg_evt
5598: (p_validate => FALSE
5599: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5600: ,p_chg_evt_cd => 'COSCOL'
5601: ,p_chg_eff_dt => p_new_rec.attended_start_date
5692: open c_person(p_new_rec.assignment_id);
5693: fetch c_person into l_person_id,l_business_group_id ;
5694: close c_person ;
5695:
5696: ben_ext_chg_evt_api.create_ext_chg_evt
5697: (p_validate => FALSE
5698: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5699: ,p_chg_evt_cd => 'COBSAL'
5700: ,p_chg_eff_dt => p_new_rec.change_date
5944:
5945: for l_count in 1..l_chg_evt_tab.count loop
5946: if change_event_is_enabled(l_chg_evt_tab(l_count),l_chg_eff_dt) then
5947:
5948: ben_ext_chg_evt_api.create_ext_chg_evt
5949: (p_validate => FALSE
5950: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5951: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
5952: ,p_chg_eff_dt => l_chg_eff_dt
6067: end if;
6068: --
6069: for l_count in 1..l_chg_evt_tab.count loop
6070: if change_event_is_enabled(l_chg_evt_tab(l_count),l_chg_eff_dt) then
6071: ben_ext_chg_evt_api.create_ext_chg_evt
6072: (p_validate => FALSE
6073: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
6074: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
6075: ,p_chg_eff_dt => l_chg_eff_dt
6133: close c_get_element_info;
6134: --
6135: if p_action = 'CREATE' then
6136: if change_event_is_enabled('AEE',p_effective_date) then
6137: ben_ext_chg_evt_api.create_ext_chg_evt
6138: (p_validate => FALSE
6139: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
6140: ,p_chg_evt_cd => 'AEE'
6141: ,p_chg_eff_dt => p_effective_date
6151: end if;
6152: --
6153: elsif p_action = 'UPDATE' then
6154: if change_event_is_enabled('UEE',p_effective_date) then
6155: ben_ext_chg_evt_api.create_ext_chg_evt
6156: (p_validate => FALSE
6157: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
6158: ,p_chg_evt_cd => 'UEE'
6159: ,p_chg_eff_dt => p_effective_date
6173: --
6174: elsif p_action = 'DELETE' then
6175: hr_utility.set_location('deleteing element entry ' , 195);
6176: if change_event_is_enabled('DEE',p_effective_date) then
6177: ben_ext_chg_evt_api.create_ext_chg_evt
6178: (p_validate => FALSE
6179: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
6180: ,p_chg_evt_cd => 'DEE'
6181: ,p_chg_eff_dt => p_effective_date
7095: end if;
7096:
7097: for l_count in 1..l_chg_evt_tab.count loop
7098: if change_event_is_enabled(l_chg_evt_tab(l_count),p_new_rec.effective_start_date) then
7099: ben_ext_chg_evt_api.create_ext_chg_evt
7100: (p_validate => FALSE
7101: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
7102: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
7103: ,p_chg_eff_dt => p_new_rec.effective_start_date