3: for each row
4: --
5: declare
6: --
7: l_old_rec ben_ext_chlg.g_cont_rec_type;
8: l_new_rec ben_ext_chlg.g_cont_rec_type;
9: --
10: begin
11: --
4: --
5: declare
6: --
7: l_old_rec ben_ext_chlg.g_cont_rec_type;
8: l_new_rec ben_ext_chlg.g_cont_rec_type;
9: --
10: begin
11: --
12: -- Not to be called when Data Migrator is in progress
27: l_new_rec.business_group_id := :new.business_group_id;
28: l_new_rec.date_start := :new.date_start;
29: --
30: if nvl(:new.contact_type,'$$') <> nvl(:old.contact_type,'$$') then
31: ben_ext_chlg.log_cont_chg
32: (
33: p_old_rec => l_old_rec
34: ,p_new_rec => l_new_rec
35: );