123: 08-APR-05 pchowdav 115.42 4281500 update_contact modified to update the
124: relationship records date start when the
125: contact date of birth is updated with a later
126: date.
127: 12-APR-05 abparekh 115.43 4295302 Called procedure ben_ppf_ler from Insert_Row
128: and Update_Contact to trigger life event
129: reasons for insert/update of PER_ALL_PEOPLE_F
130: records for a Contact
131: 13-APR-05 abparekh 115.44 4295302 Fixed GSCC Error
811: AND effective_end_date;
812: --
813: -- Bug 4295302
814: --
815: l_ppf_ler_new_rec ben_ppf_ler.g_ppf_ler_rec;
816: l_ppf_ler_old_rec ben_ppf_ler.g_ppf_ler_rec;
817: --
818: BEGIN
819: --
812: --
813: -- Bug 4295302
814: --
815: l_ppf_ler_new_rec ben_ppf_ler.g_ppf_ler_rec;
816: l_ppf_ler_old_rec ben_ppf_ler.g_ppf_ler_rec;
817: --
818: BEGIN
819: --
820: --hr_person.derive_full_name (x_first_name, x_middle_names,
1201: --
1202: -- This procedure is will create potential life event reasons if the Person Change
1203: -- criteria is met (a part of Oracle Advanced Benefits functionality)
1204: --
1205: ben_ppf_ler.ler_chk( p_old => l_ppf_ler_old_rec
1206: ,p_new => l_ppf_ler_new_rec
1207: ,p_effective_date => x_session_date );
1208:
1209: --
2816: FROM per_all_people_f
2817: WHERE x_session_date BETWEEN effective_start_date AND effective_end_date
2818: AND person_id = cv_person_id;
2819: --
2820: l_ppf_ler_new_rec ben_ppf_ler.g_ppf_ler_rec;
2821: l_ppf_ler_old_rec ben_ppf_ler.g_ppf_ler_rec;
2822: --
2823: -- Bug 4295302
2824: --
2817: WHERE x_session_date BETWEEN effective_start_date AND effective_end_date
2818: AND person_id = cv_person_id;
2819: --
2820: l_ppf_ler_new_rec ben_ppf_ler.g_ppf_ler_rec;
2821: l_ppf_ler_old_rec ben_ppf_ler.g_ppf_ler_rec;
2822: --
2823: -- Bug 4295302
2824: --
2825: --
3098: --
3099: -- This procedure is will create potential life event reasons if the Person Change
3100: -- criteria is met (a part of Oracle Advanced Benefits functionality)
3101: --
3102: ben_ppf_ler.ler_chk( p_old => l_ppf_ler_old_rec
3103: ,p_new => l_ppf_ler_new_rec
3104: ,p_effective_date => x_session_date );
3105:
3106: --