DBA Data[Home] [Help]

APPS.PER_CONTACT_RELATIONSHIPS_PKG dependencies on BEN_PPF_LER

Line 127: 12-APR-05 abparekh 115.43 4295302 Called procedure ben_ppf_ler from Insert_Row

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

Line 815: l_ppf_ler_new_rec ben_ppf_ler.g_ppf_ler_rec;

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: --

Line 816: l_ppf_ler_old_rec ben_ppf_ler.g_ppf_ler_rec;

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,

Line 1205: ben_ppf_ler.ler_chk( p_old => l_ppf_ler_old_rec

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: --

Line 2820: l_ppf_ler_new_rec ben_ppf_ler.g_ppf_ler_rec;

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: --

Line 2821: l_ppf_ler_old_rec ben_ppf_ler.g_ppf_ler_rec;

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: --

Line 3102: ben_ppf_ler.ler_chk( p_old => l_ppf_ler_old_rec

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: --