APPS.GHR_MLC_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 3084: l_per_ei_data per_people_extra_info%rowtype;

3080: p_mass_salary_id in number,
3081: p_sel_flg in out nocopy varchar2)
3082: RETURN boolean IS
3083:
3084: l_per_ei_data per_people_extra_info%rowtype;
3085: l_comments varchar2(250);
3086: l_sel_flag varchar2(3);
3087: l_line number := 0;
3088:

Line 3169: l_per_ei_data per_people_extra_info%rowtype;

3165: procedure update_sel_flg (p_person_id in number,p_effective_date date) is
3166:
3167: l_person_extra_info_id number;
3168: l_object_version_number number;
3169: l_per_ei_data per_people_extra_info%rowtype;
3170: l_proc varchar2(72) := g_package || '.update_sel_flg';
3171: l_ind number := 1;
3172: begin
3173: g_proc := 'update_sel_flg';

Line 3199: -- There is a trigger on PER_PEOPLE_EXTRA_INFO to make the employee INVALID

3195: ,P_PEI_INFORMATION_CATEGORY => 'GHR_US_PER_MASS_ACTIONS');
3196:
3197: l_ind := 30;
3198: hr_utility.set_location('Exiting ' || l_proc,10);
3199: -- There is a trigger on PER_PEOPLE_EXTRA_INFO to make the employee INVALID
3200: -- when there is a update done on the table.
3201: ---Commented the following three lines to remove Validation functionality on Person.
3202: --- ghr_validate_perwsepi.validate_perwsepi(p_person_id);
3203: --- l_ind := 40;

Line 3268: l_per_ei_data per_people_extra_info%rowtype;

3264: p_sel_flag in out nocopy varchar2,
3265: p_comments in out nocopy varchar2,
3266: p_mass_salary_id in number) is
3267:
3268: l_per_ei_data per_people_extra_info%rowtype;
3269: l_proc varchar2(72) := g_package || '.get_extra_info_comments';
3270: l_eff_date date;
3271:
3272: CURSOR chk_history (p_person_id in NUMBER ,

Line 3283: and table_name = 'PER_PEOPLE_EXTRA_INFO'

3279: and pa_history_id IN ( select max(pa_history_id)
3280: from ghr_pa_history
3281: where person_id = p_person_id
3282: and information5 = 'GHR_US_PER_MASS_ACTIONS'
3283: and table_name = 'PER_PEOPLE_EXTRA_INFO'
3284: and effective_date = eff_date
3285: group by information11);
3286:
3287: begin

Line 3342: l_per_ei_data per_people_extra_info%rowtype;

3338: p_sel_flag in varchar2, p_comment in varchar2,p_msl_id in number) is
3339:
3340: l_person_extra_info_id number;
3341: l_object_version_number number;
3342: l_per_ei_data per_people_extra_info%rowtype;
3343:
3344: CURSOR people_ext_cur (person number) is
3345: SELECT person_extra_info_id, object_version_number
3346: FROM PER_people_EXTRA_INFO

Line 3346: FROM PER_people_EXTRA_INFO

3342: l_per_ei_data per_people_extra_info%rowtype;
3343:
3344: CURSOR people_ext_cur (person number) is
3345: SELECT person_extra_info_id, object_version_number
3346: FROM PER_people_EXTRA_INFO
3347: WHERE person_ID = person
3348: and information_type = 'GHR_US_PER_MASS_ACTIONS';
3349:
3350: l_proc varchar2(72) := g_package || '.ins_upd_per_extra_info';

Line 3849: l_per_ei_data per_people_extra_info%rowtype;

3845: ,p_person_id in number
3846: ,p_effective_date in date) return varchar2 is
3847:
3848: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
3849: l_per_ei_data per_people_extra_info%rowtype;
3850:
3851: l_proc varchar2(72) := g_package || '.check_grade_retention';
3852:
3853: begin