[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
1396:
1397: end if;
1398: for l_count in 1..l_chg_evt_tab.count loop
1399: if change_event_is_enabled(l_chg_evt_tab(l_count),p_new_rec.effective_start_date) then
1400: ben_ext_chg_evt_api.create_ext_chg_evt
1401: (p_validate => FALSE
1402: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
1403: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
1404: ,p_chg_eff_dt => p_new_rec.effective_start_date
1580: for l_count in l_ini_tab_counter+1..l_ini_tab_counter+l_cont_chg_evt_tab.count loop
1581: if change_event_is_enabled(l_cont_chg_evt_tab(l_count),p_new_rec.effective_start_date)
1582: then
1583:
1584: ben_ext_chg_evt_api.create_ext_chg_evt
1585: (p_validate => FALSE
1586: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
1587: ,p_chg_evt_cd => l_cont_chg_evt_tab(l_count)
1588: ,p_chg_eff_dt => p_new_rec.effective_start_date
1764: hr_utility.set_location ( ' change event ' || l_cont_chg_evt_tab(l_count) , 11 ) ;
1765: if change_event_is_enabled(l_cont_chg_evt_tab(l_count),p_new_rec.effective_start_date)
1766: then
1767:
1768: ben_ext_chg_evt_api.create_ext_chg_evt
1769: (p_validate => FALSE
1770: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
1771: ,p_chg_evt_cd => l_cont_chg_evt_tab(l_count)
1772: ,p_chg_eff_dt => p_new_rec.effective_start_date
1940: end if;
1941: for l_count in 1..l_chg_evt_tab.count loop
1942: if change_event_is_enabled(l_chg_evt_tab(l_count),trunc(sysdate)) then
1943: hr_utility.set_location ( 'calling api ' ,99) ;
1944: ben_ext_chg_evt_api.create_ext_chg_evt
1945: (p_validate => FALSE
1946: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
1947: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
1948: ,p_chg_eff_dt => l_chg_eff_tab(l_count)
3018: if change_event_is_enabled(l_chg_evt_tab(l_count),trunc(sysdate)) then
3019: if l_chg_evt_tab(l_count) in ('CCPA','CCMA','CCNPA','CCNMA') then
3020: l_person_id := nvl(l_prmtr_07_tab(l_count),l_relationship);
3021: end if;
3022: ben_ext_chg_evt_api.create_ext_chg_evt
3023: (p_validate => FALSE
3024: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
3025: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
3026: ,p_chg_eff_dt => l_chg_eff_tab(l_count)
3533: end if;
3534: --
3535: for l_count in 1..l_chg_evt_tab.count loop
3536: if change_event_is_enabled(l_chg_evt_tab(l_count),p_new_rec.effective_start_date) then
3537: ben_ext_chg_evt_api.create_ext_chg_evt
3538: (p_validate => FALSE
3539: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
3540: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
3541: ,p_chg_eff_dt => p_new_rec.effective_start_date
3761: --
3762: --
3763: for l_count in 1..l_chg_evt_tab.count loop
3764: if change_event_is_enabled(l_chg_evt_tab(l_count),l_chg_eff_dt) then
3765: ben_ext_chg_evt_api.create_ext_chg_evt
3766: (p_validate => FALSE
3767: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
3768: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
3769: ,p_chg_eff_dt => l_chg_eff_dt
3897: if p_old_oipl_id is null or (p_old_oipl_id
3898: is not null and p_oipl_id = p_old_oipl_id) then
3899: if nvl(p_bnft_amt,0) <> nvl(p_old_bnft_amt,0) and
3900: change_event_is_enabled('COECA',p_effective_date) then
3901: ben_ext_chg_evt_api.create_ext_chg_evt
3902: (p_validate => FALSE
3903: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
3904: ,p_chg_evt_cd => 'COECA' -- Change Coverage Amount
3905: ,p_chg_eff_dt => p_effective_date
3919: --
3920: else
3921:
3922: if change_event_is_enabled('AB',p_effective_date) then
3923: ben_ext_chg_evt_api.create_ext_chg_evt
3924: (p_validate => FALSE
3925: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
3926: ,p_chg_evt_cd => 'AB' -- Add Benefit
3927: ,p_chg_eff_dt => p_effective_date
3952: fetch c_option_name into l_new_option_name;
3953: close c_option_name;
3954: --
3955: if change_event_is_enabled('RB',p_effective_date) then
3956: ben_ext_chg_evt_api.create_ext_chg_evt
3957: (p_validate => FALSE
3958: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
3959: ,p_chg_evt_cd => 'RB' -- Reinstate Benefit
3960: ,p_chg_eff_dt => p_effective_date
3995: fetch c_option_name into l_old_option_name;
3996: close c_option_name;
3997: --
3998: if change_event_is_enabled('TBBC',p_effective_date) then
3999: ben_ext_chg_evt_api.create_ext_chg_evt
4000: (p_validate => FALSE
4001: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4002: ,p_chg_evt_cd => 'TBBC' -- Terminate Benefit before Coverage
4003: ,p_chg_eff_dt => p_effective_date --??
4029: fetch c_option_name into l_old_option_name;
4030: close c_option_name;
4031:
4032: if change_event_is_enabled('TBAC',p_effective_date) then
4033: ben_ext_chg_evt_api.create_ext_chg_evt
4034: (p_validate => FALSE
4035: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4036: ,p_chg_evt_cd => 'TBAC' -- Terminate Benefit after Coverage
4037: ,p_chg_eff_dt => p_effective_date --??
4063: fetch c_option_name into l_new_option_name;
4064: close c_option_name;
4065:
4066: if change_event_is_enabled('AB',p_effective_date) then
4067: ben_ext_chg_evt_api.create_ext_chg_evt
4068: (p_validate => FALSE
4069: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4070: ,p_chg_evt_cd => 'AB' -- Add Benefit
4071: ,p_chg_eff_dt => p_effective_date
4098: fetch c_option_name into l_old_option_name;
4099: close c_option_name;
4100: --
4101: if change_event_is_enabled('UOBO',p_effective_date) then
4102: ben_ext_chg_evt_api.create_ext_chg_evt
4103: (p_validate => FALSE
4104: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4105: ,p_chg_evt_cd => 'UOBO' -- Change of Option
4106: ,p_chg_eff_dt => p_effective_date
4124: --
4125: if p_enrt_cvg_strt_dt <> p_old_enrt_cvg_strt_dt then
4126: --
4127: if change_event_is_enabled('CCSD',p_effective_date) then
4128: ben_ext_chg_evt_api.create_ext_chg_evt
4129: (p_validate => FALSE
4130: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4131: ,p_chg_evt_cd => 'CCSD' -- Change Coverage Start Date
4132: ,p_chg_eff_dt => p_effective_date
4146: --
4147: if p_enrt_cvg_end_dt <> p_old_enrt_cvg_end_dt then
4148: --
4149: if change_event_is_enabled('CCED',p_effective_date) then
4150: ben_ext_chg_evt_api.create_ext_chg_evt
4151: (p_validate => FALSE
4152: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4153: ,p_chg_evt_cd => 'CCED' -- Change Coverage End Date
4154: ,p_chg_eff_dt => p_effective_date
4168: --
4169: if p_bnft_amt <> p_old_bnft_amt then
4170: --
4171: if change_event_is_enabled('COECA',p_effective_date) then
4172: ben_ext_chg_evt_api.create_ext_chg_evt
4173: (p_validate => FALSE
4174: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4175: ,p_chg_evt_cd => 'COECA' -- Change Coverage Amount
4176: ,p_chg_eff_dt => p_effective_date
4190: --
4191: if p_pen_attribute1 <> p_old_pen_attribute1 then
4192: --
4193: if change_event_is_enabled('COEF01',p_effective_date) then
4194: ben_ext_chg_evt_api.create_ext_chg_evt
4195: (p_validate => FALSE
4196: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4197: ,p_chg_evt_cd => 'COEF01' -- Change Flex field
4198: ,p_chg_eff_dt => p_effective_date
4212: --
4213: if p_pen_attribute2 <> p_old_pen_attribute2 then
4214: --
4215: if change_event_is_enabled('COEF02',p_effective_date) then
4216: ben_ext_chg_evt_api.create_ext_chg_evt
4217: (p_validate => FALSE
4218: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4219: ,p_chg_evt_cd => 'COEF02' -- Change Flex field
4220: ,p_chg_eff_dt => p_effective_date
4235: --
4236: if p_pen_attribute3 <> p_old_pen_attribute3 then
4237: --
4238: if change_event_is_enabled('COEF03',p_effective_date) then
4239: ben_ext_chg_evt_api.create_ext_chg_evt
4240: (p_validate => FALSE
4241: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4242: ,p_chg_evt_cd => 'COEF03' -- Change Flex field
4243: ,p_chg_eff_dt => p_effective_date
4257: --
4258: if p_pen_attribute4 <> p_old_pen_attribute4 then
4259: --
4260: if change_event_is_enabled('COEF04',p_effective_date) then
4261: ben_ext_chg_evt_api.create_ext_chg_evt
4262: (p_validate => FALSE
4263: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4264: ,p_chg_evt_cd => 'COEF04' -- Change Flex field
4265: ,p_chg_eff_dt => p_effective_date
4279: --
4280: if p_pen_attribute5 <> p_old_pen_attribute5 then
4281: --
4282: if change_event_is_enabled('COEF05',p_effective_date) then
4283: ben_ext_chg_evt_api.create_ext_chg_evt
4284: (p_validate => FALSE
4285: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4286: ,p_chg_evt_cd => 'COEF05' -- Change Flex field
4287: ,p_chg_eff_dt => p_effective_date
4301: --
4302: if p_pen_attribute6 <> p_old_pen_attribute6 then
4303: --
4304: if change_event_is_enabled('COEF06',p_effective_date) then
4305: ben_ext_chg_evt_api.create_ext_chg_evt
4306: (p_validate => FALSE
4307: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4308: ,p_chg_evt_cd => 'COEF06' -- Change Flex field
4309: ,p_chg_eff_dt => p_effective_date
4323: --
4324: if p_pen_attribute7 <> p_old_pen_attribute7 then
4325: --
4326: if change_event_is_enabled('COEF07',p_effective_date) then
4327: ben_ext_chg_evt_api.create_ext_chg_evt
4328: (p_validate => FALSE
4329: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4330: ,p_chg_evt_cd => 'COEF07' -- Change Flex field
4331: ,p_chg_eff_dt => p_effective_date
4345: --
4346: if p_pen_attribute8 <> p_old_pen_attribute8 then
4347: --
4348: if change_event_is_enabled('COEF08',p_effective_date) then
4349: ben_ext_chg_evt_api.create_ext_chg_evt
4350: (p_validate => FALSE
4351: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4352: ,p_chg_evt_cd => 'COEF08' -- Change Flex field
4353: ,p_chg_eff_dt => p_effective_date
4367: --
4368: if p_pen_attribute9 <> p_old_pen_attribute9 then
4369: --
4370: if change_event_is_enabled('COEF09',p_effective_date) then
4371: ben_ext_chg_evt_api.create_ext_chg_evt
4372: (p_validate => FALSE
4373: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4374: ,p_chg_evt_cd => 'COEF09' -- Change Flex field
4375: ,p_chg_eff_dt => p_effective_date
4389: --
4390: if p_pen_attribute10 <> p_old_pen_attribute10 then
4391: --
4392: if change_event_is_enabled('COEF10',p_effective_date) then
4393: ben_ext_chg_evt_api.create_ext_chg_evt
4394: (p_validate => FALSE
4395: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4396: ,p_chg_evt_cd => 'COEF10' -- Change Flex field
4397: ,p_chg_eff_dt => p_effective_date
4424: fetch c_option_name into l_old_option_name;
4425: close c_option_name;
4426: --
4427: if change_event_is_enabled('TBBC',p_effective_date) then
4428: ben_ext_chg_evt_api.create_ext_chg_evt
4429: (p_validate => FALSE
4430: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4431: ,p_chg_evt_cd => 'TBBC' -- Terminate Benefit before Coverage
4432: ,p_chg_eff_dt => p_effective_date
4458: fetch c_option_name into l_old_option_name;
4459: close c_option_name;
4460:
4461: if change_event_is_enabled('TBAC',p_effective_date) then
4462: ben_ext_chg_evt_api.create_ext_chg_evt
4463: (p_validate => FALSE
4464: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4465: ,p_chg_evt_cd => 'TBAC' -- Terminate Benefit after Coverage
4466: ,p_chg_eff_dt => p_effective_date
4583: -- the change log. 'Add Dependent' for the employee person, and 'Add Benefit'
4584: -- for the dependent person.
4585: --
4586: if change_event_is_enabled('AB',p_effective_date) then
4587: ben_ext_chg_evt_api.create_ext_chg_evt
4588: (p_validate => FALSE
4589: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4590: ,p_chg_evt_cd => 'AB' -- Add Benefit
4591: ,p_chg_eff_dt => p_effective_date
4606: );
4607: end if;
4608: --
4609: if change_event_is_enabled('AD',p_effective_date) then
4610: ben_ext_chg_evt_api.create_ext_chg_evt
4611: (p_validate => FALSE
4612: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4613: ,p_chg_evt_cd => 'AD' -- Add Dependent
4614: ,p_chg_eff_dt => p_effective_date
4633: --
4634: elsif p_action = 'REINSTATE' then
4635: --
4636: if change_event_is_enabled('RB',p_effective_date) then
4637: ben_ext_chg_evt_api.create_ext_chg_evt
4638: (p_validate => FALSE
4639: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4640: ,p_chg_evt_cd => 'RB' -- Reinstate Benefit
4641: ,p_chg_eff_dt => p_effective_date
4660: );
4661: end if;
4662: --
4663: if change_event_is_enabled('AD',p_effective_date) then
4664: ben_ext_chg_evt_api.create_ext_chg_evt
4665: (p_validate => FALSE
4666: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4667: ,p_chg_evt_cd => 'AD' -- Add dependent This should later change to
4668: -- Reinstate Dependent.
4696: --
4697: if p_cvg_end_dt < p_cvg_strt_dt then
4698: --
4699: if change_event_is_enabled('TBBC',p_effective_date) then
4700: ben_ext_chg_evt_api.create_ext_chg_evt
4701: (p_validate => FALSE
4702: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4703: ,p_chg_evt_cd => 'TBBC' -- Terminate Benefit before Coverage
4704: ,p_chg_eff_dt => p_effective_date
4725: --
4726: else
4727: --
4728: if change_event_is_enabled('TBAC',p_effective_date) then
4729: ben_ext_chg_evt_api.create_ext_chg_evt
4730: (p_validate => FALSE
4731: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4732: ,p_chg_evt_cd => 'TBAC' -- Terminate Benefit after Coverage
4733: ,p_chg_eff_dt => p_effective_date
4754: --
4755: end if; -- eff date
4756: --
4757: if change_event_is_enabled('DD',p_effective_date) then
4758: ben_ext_chg_evt_api.create_ext_chg_evt
4759: (p_validate => FALSE
4760: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4761: ,p_chg_evt_cd => 'DD' -- Delete Dependent
4762: ,p_chg_eff_dt => p_effective_date
4900: if p_action = 'CREATE' then
4901: if change_event_is_enabled('APCP',p_effective_date) then
4902: l_pcp_chg := TRUE;
4903: if l_person_id is not null then
4904: ben_ext_chg_evt_api.create_ext_chg_evt
4905: (p_validate => FALSE
4906: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4907: ,p_chg_evt_cd => 'APCP'
4908: ,p_chg_eff_dt => p_effective_date
4924: if p_prmry_care_prvdr_typ_cd <> p_old_prmry_care_prvdr_typ_cd then
4925: --
4926: if change_event_is_enabled('COPT',p_effective_date) then
4927: l_pcp_chg := TRUE;
4928: ben_ext_chg_evt_api.create_ext_chg_evt
4929: (p_validate => FALSE
4930: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4931: ,p_chg_evt_cd => 'COPT'
4932: ,p_chg_eff_dt => p_effective_date
4950: if p_name <> p_old_name then
4951: --
4952: if change_event_is_enabled('COPN',p_effective_date) then
4953: l_pcp_chg := TRUE;
4954: ben_ext_chg_evt_api.create_ext_chg_evt
4955: (p_validate => FALSE
4956: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4957: ,p_chg_evt_cd => 'COPN'
4958: ,p_chg_eff_dt => p_effective_date
4974: end if;
4975: --
4976: if p_ext_ident <> p_old_ext_ident then
4977: if change_event_is_enabled('COPI',p_effective_date) then
4978: ben_ext_chg_evt_api.create_ext_chg_evt
4979: (p_validate => FALSE
4980: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
4981: ,p_chg_evt_cd => 'COPI'
4982: ,p_chg_eff_dt => p_effective_date
5000: elsif p_action = 'DELETE' then
5001: --
5002: if change_event_is_enabled('DPCP',p_effective_date) then
5003: l_pcp_chg := TRUE;
5004: ben_ext_chg_evt_api.create_ext_chg_evt
5005: (p_validate => FALSE
5006: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5007: ,p_chg_evt_cd => 'DPCP'
5008: ,p_chg_eff_dt => p_effective_date
5029: elsif c_relationship%found then
5030: close c_relationship;
5031: l_person_id := l_relationship;
5032: if p_action = 'CREATE' then
5033: ben_ext_chg_evt_api.create_ext_chg_evt
5034: (p_validate => FALSE
5035: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5036: ,p_chg_evt_cd => 'CCPC'
5037: ,p_chg_eff_dt => p_effective_date
5051: v_prmry_care_prvdr_typ_cd := l_prmry_care_prvdr_typ_cd;
5052: else
5053: v_prmry_care_prvdr_typ_cd := l_old_prmry_care_prvdr_typ_cd;
5054: end if;
5055: ben_ext_chg_evt_api.create_ext_chg_evt
5056: (p_validate => FALSE
5057: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5058: ,p_chg_evt_cd => 'CCPC'
5059: ,p_chg_eff_dt => p_effective_date
5071: ,p_new_val1 => substr(l_name,1,240)
5072: ,p_new_val2 => substr(p_name,1,240)
5073: ,p_new_val3 => v_prmry_care_prvdr_typ_cd);
5074: elsif p_action = 'DELETE' then
5075: ben_ext_chg_evt_api.create_ext_chg_evt
5076: (p_validate => FALSE
5077: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5078: ,p_chg_evt_cd => 'CCPC'
5079: ,p_chg_eff_dt => p_effective_date
5098: fetch c_con_relationship into l_contact,l_relationship,l_name;
5099: exit when c_con_relationship%notfound ;
5100: l_person_id := l_relationship;
5101: if p_action = 'CREATE' then
5102: ben_ext_chg_evt_api.create_ext_chg_evt
5103: (p_validate => FALSE
5104: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5105: ,p_chg_evt_cd => 'CCNPC'
5106: ,p_chg_eff_dt => p_effective_date
5120: v_prmry_care_prvdr_typ_cd := l_prmry_care_prvdr_typ_cd;
5121: else
5122: v_prmry_care_prvdr_typ_cd := l_old_prmry_care_prvdr_typ_cd;
5123: end if;
5124: ben_ext_chg_evt_api.create_ext_chg_evt
5125: (p_validate => FALSE
5126: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5127: ,p_chg_evt_cd => 'CCNPC'
5128: ,p_chg_eff_dt => p_effective_date
5140: ,p_new_val1 => substr(l_name,1,240)
5141: ,p_new_val2 => substr(p_name,1,240)
5142: ,p_new_val3 => v_prmry_care_prvdr_typ_cd);
5143: elsif p_action = 'DELETE' then
5144: ben_ext_chg_evt_api.create_ext_chg_evt
5145: (p_validate => FALSE
5146: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5147: ,p_chg_evt_cd => 'CCNPC'
5148: ,p_chg_eff_dt => p_effective_date
5316: --
5317: for l_count in 1..l_chg_evt_tab.count loop
5318: if change_event_is_enabled(l_chg_evt_tab(l_count),l_chg_eff_dt(l_count)) then
5319: --Bug 4539732 Create ext change event with each event having its own l_chg_eff_dt
5320: ben_ext_chg_evt_api.create_ext_chg_evt
5321: (p_validate => FALSE
5322: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5323: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
5324: ,p_chg_eff_dt => l_chg_eff_dt(l_count)
5439: change_event_is_enabled('CCOPMPRM',p_new_rec.effective_start_date) ) then
5440:
5441: hr_utility.set_location('calling log event :', 10);
5442:
5443: ben_ext_chg_evt_api.create_ext_chg_evt
5444: (p_validate => FALSE
5445: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5446: ,p_chg_evt_cd => 'CCOPMPRM'
5447: ,p_chg_eff_dt => p_new_rec.effective_start_date
5497: if nvl(l_new_name,'$$$$') <> nvl(l_old_name,'$$$$')
5498: or p_new_rec.attended_start_date <> p_old_rec.attended_start_date
5499: or p_new_rec.attended_end_date <> p_old_rec.attended_end_date then
5500: if change_event_is_enabled('COSCOL',p_new_rec.attended_start_date) then
5501: ben_ext_chg_evt_api.create_ext_chg_evt
5502: (p_validate => FALSE
5503: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5504: ,p_chg_evt_cd => 'COSCOL'
5505: ,p_chg_eff_dt => p_new_rec.attended_start_date
5596: open c_person(p_new_rec.assignment_id);
5597: fetch c_person into l_person_id,l_business_group_id ;
5598: close c_person ;
5599:
5600: ben_ext_chg_evt_api.create_ext_chg_evt
5601: (p_validate => FALSE
5602: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5603: ,p_chg_evt_cd => 'COBSAL'
5604: ,p_chg_eff_dt => p_new_rec.change_date
5848:
5849: for l_count in 1..l_chg_evt_tab.count loop
5850: if change_event_is_enabled(l_chg_evt_tab(l_count),l_chg_eff_dt) then
5851:
5852: ben_ext_chg_evt_api.create_ext_chg_evt
5853: (p_validate => FALSE
5854: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5855: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
5856: ,p_chg_eff_dt => l_chg_eff_dt
5971: end if;
5972: --
5973: for l_count in 1..l_chg_evt_tab.count loop
5974: if change_event_is_enabled(l_chg_evt_tab(l_count),l_chg_eff_dt) then
5975: ben_ext_chg_evt_api.create_ext_chg_evt
5976: (p_validate => FALSE
5977: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
5978: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
5979: ,p_chg_eff_dt => l_chg_eff_dt
6037: close c_get_element_info;
6038: --
6039: if p_action = 'CREATE' then
6040: if change_event_is_enabled('AEE',p_effective_date) then
6041: ben_ext_chg_evt_api.create_ext_chg_evt
6042: (p_validate => FALSE
6043: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
6044: ,p_chg_evt_cd => 'AEE'
6045: ,p_chg_eff_dt => p_effective_date
6055: end if;
6056: --
6057: elsif p_action = 'UPDATE' then
6058: if change_event_is_enabled('UEE',p_effective_date) then
6059: ben_ext_chg_evt_api.create_ext_chg_evt
6060: (p_validate => FALSE
6061: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
6062: ,p_chg_evt_cd => 'UEE'
6063: ,p_chg_eff_dt => p_effective_date
6077: --
6078: elsif p_action = 'DELETE' then
6079: hr_utility.set_location('deleteing element entry ' , 195);
6080: if change_event_is_enabled('DEE',p_effective_date) then
6081: ben_ext_chg_evt_api.create_ext_chg_evt
6082: (p_validate => FALSE
6083: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
6084: ,p_chg_evt_cd => 'DEE'
6085: ,p_chg_eff_dt => p_effective_date
6999: end if;
7000:
7001: for l_count in 1..l_chg_evt_tab.count loop
7002: if change_event_is_enabled(l_chg_evt_tab(l_count),p_new_rec.effective_start_date) then
7003: ben_ext_chg_evt_api.create_ext_chg_evt
7004: (p_validate => FALSE
7005: ,p_ext_chg_evt_log_id => l_ext_chg_evt_log_id
7006: ,p_chg_evt_cd => l_chg_evt_tab(l_count)
7007: ,p_chg_eff_dt => p_new_rec.effective_start_date