APPS.GHR_MLC_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 3038: l_per_ei_data per_people_extra_info%rowtype;

3034: p_mass_salary_id in number,
3035: p_sel_flg in out nocopy varchar2)
3036: RETURN boolean IS
3037:
3038: l_per_ei_data per_people_extra_info%rowtype;
3039: l_comments varchar2(250);
3040: l_sel_flag varchar2(3);
3041: l_line number := 0;
3042:

Line 3123: l_per_ei_data per_people_extra_info%rowtype;

3119: procedure update_sel_flg (p_person_id in number,p_effective_date date) is
3120:
3121: l_person_extra_info_id number;
3122: l_object_version_number number;
3123: l_per_ei_data per_people_extra_info%rowtype;
3124: l_proc varchar2(72) := g_package || '.update_sel_flg';
3125: l_ind number := 1;
3126: begin
3127: g_proc := 'update_sel_flg';

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

3149: ,P_PEI_INFORMATION_CATEGORY => 'GHR_US_PER_MASS_ACTIONS');
3150:
3151: l_ind := 30;
3152: hr_utility.set_location('Exiting ' || l_proc,10);
3153: -- There is a trigger on PER_PEOPLE_EXTRA_INFO to make the employee INVALID
3154: -- when there is a update done on the table.
3155: ---Commented the following three lines to remove Validation functionality on Person.
3156: --- ghr_validate_perwsepi.validate_perwsepi(p_person_id);
3157: --- l_ind := 40;

Line 3222: l_per_ei_data per_people_extra_info%rowtype;

3218: p_sel_flag in out nocopy varchar2,
3219: p_comments in out nocopy varchar2,
3220: p_mass_salary_id in number) is
3221:
3222: l_per_ei_data per_people_extra_info%rowtype;
3223: l_proc varchar2(72) := g_package || '.get_extra_info_comments';
3224: l_eff_date date;
3225:
3226: CURSOR chk_history (p_person_id in NUMBER ,

Line 3237: and table_name = 'PER_PEOPLE_EXTRA_INFO'

3233: and pa_history_id IN ( select max(pa_history_id)
3234: from ghr_pa_history
3235: where person_id = p_person_id
3236: and information5 = 'GHR_US_PER_MASS_ACTIONS'
3237: and table_name = 'PER_PEOPLE_EXTRA_INFO'
3238: and effective_date = eff_date
3239: group by information11);
3240:
3241: begin

Line 3296: l_per_ei_data per_people_extra_info%rowtype;

3292: p_sel_flag in varchar2, p_comment in varchar2,p_msl_id in number) is
3293:
3294: l_person_extra_info_id number;
3295: l_object_version_number number;
3296: l_per_ei_data per_people_extra_info%rowtype;
3297:
3298: CURSOR people_ext_cur (person number) is
3299: SELECT person_extra_info_id, object_version_number
3300: FROM PER_people_EXTRA_INFO

Line 3300: FROM PER_people_EXTRA_INFO

3296: l_per_ei_data per_people_extra_info%rowtype;
3297:
3298: CURSOR people_ext_cur (person number) is
3299: SELECT person_extra_info_id, object_version_number
3300: FROM PER_people_EXTRA_INFO
3301: WHERE person_ID = person
3302: and information_type = 'GHR_US_PER_MASS_ACTIONS';
3303:
3304: l_proc varchar2(72) := g_package || '.ins_upd_per_extra_info';

Line 3803: l_per_ei_data per_people_extra_info%rowtype;

3799: ,p_person_id in number
3800: ,p_effective_date in date) return varchar2 is
3801:
3802: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
3803: l_per_ei_data per_people_extra_info%rowtype;
3804:
3805: l_proc varchar2(72) := g_package || '.check_grade_retention';
3806:
3807: begin