eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MSL_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 1976: l_per_ei_data per_people_extra_info%rowtype;

1972: p_increase_percent in out nocopy number
1973: )
1974: return boolean IS
1975:
1976: l_per_ei_data per_people_extra_info%rowtype;
1977: l_comments varchar2(250);
1978: l_sel_flag varchar2(3);
1979: l_line number := 0;
1980: l_proc varchar2(72) := g_package || '.check_select_flg_msl_perc';

Line 2061: l_per_ei_data per_people_extra_info%rowtype;

2057: p_sel_flg in out nocopy varchar2
2058: )
2059: return boolean IS
2060:
2061: l_per_ei_data per_people_extra_info%rowtype;
2062: l_comments varchar2(250);
2063: l_sel_flag varchar2(3);
2064: l_line number := 0;
2065: l_temp NUMBER;

Line 2541: l_per_ei_data per_people_extra_info%rowtype;

2537: procedure update_sel_flg (p_person_id in number,p_effective_date date) is
2538:
2539: l_person_extra_info_id number;
2540: l_object_version_number number;
2541: l_per_ei_data per_people_extra_info%rowtype;
2542: l_proc varchar2(72) := g_package || '.update_sel_flg';
2543: l_ind number := 1;
2544: begin
2545: g_proc := 'update_sel_flg';

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

2569: ,P_PEI_INFORMATION_CATEGORY => 'GHR_US_PER_MASS_ACTIONS');
2570:
2571: l_ind := 30;
2572: hr_utility.set_location('Exiting ' || l_proc,10);
2573: -- There is a trigger on PER_PEOPLE_EXTRA_INFO to make the employee INVALID
2574: -- when there is a update done on the table.
2575: ---Commented the following three lines to remove Validation functionality on Person.
2576: --- ghr_validate_perwsepi.validate_perwsepi(p_person_id);
2577: --- l_ind := 40;

Line 2646: l_per_ei_data per_people_extra_info%rowtype;

2642: p_mass_salary_id in number,
2643: p_increase_percent out nocopy number,
2644: p_ses_basic_pay out nocopy number) is
2645:
2646: l_per_ei_data per_people_extra_info%rowtype;
2647: l_proc varchar2(72) := g_package || '.get_extra_info_comments';
2648: l_eff_date date;
2649:
2650: CURSOR chk_history (p_person_id in NUMBER ,

Line 2663: and table_name = 'PER_PEOPLE_EXTRA_INFO'

2659: and pa_history_id IN ( select max(pa_history_id)
2660: from ghr_pa_history
2661: where person_id = p_person_id
2662: and information5 = 'GHR_US_PER_MASS_ACTIONS'
2663: and table_name = 'PER_PEOPLE_EXTRA_INFO'
2664: and effective_date = eff_date
2665: group by information11);
2666:
2667: begin

Line 2735: l_per_ei_data per_people_extra_info%rowtype;

2731: p_increase_percent in number default NULL) is
2732:
2733: l_person_extra_info_id number;
2734: l_object_version_number number;
2735: l_per_ei_data per_people_extra_info%rowtype;
2736:
2737: CURSOR people_ext_cur (person number) is
2738: SELECT person_extra_info_id, object_version_number
2739: FROM PER_people_EXTRA_INFO

Line 2739: FROM PER_people_EXTRA_INFO

2735: l_per_ei_data per_people_extra_info%rowtype;
2736:
2737: CURSOR people_ext_cur (person number) is
2738: SELECT person_extra_info_id, object_version_number
2739: FROM PER_people_EXTRA_INFO
2740: WHERE person_ID = person
2741: and information_type = 'GHR_US_PER_MASS_ACTIONS';
2742:
2743: l_proc varchar2(72) := g_package || '.ins_upd_per_extra_info';

Line 3901: l_per_ei_data per_people_extra_info%rowtype;

3897: ,p_person_id in number
3898: ,p_effective_date in date) return varchar2 is
3899:
3900: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
3901: l_per_ei_data per_people_extra_info%rowtype;
3902:
3903: l_proc varchar2(72) := g_package || '.check_grade_retention';
3904:
3905: BEGIN

Line 4774: FROM PER_people_EXTRA_INFO

4770: procedure upd_ext_info_to_null(p_effective_date in date) is
4771:
4772: cursor cur1 is
4773: select person_id
4774: FROM PER_people_EXTRA_INFO
4775: WHERE information_type = 'GHR_US_PER_MASS_ACTIONS'
4776: AND pei_INFORMATION3 IS NOT NULL;
4777:
4778: l_person_id number;

Line 8743: l_per_ei_data per_people_extra_info%rowtype;

8739: p_ses_basic_pay in number default NULL) is
8740:
8741: l_person_extra_info_id number;
8742: l_object_version_number number;
8743: l_per_ei_data per_people_extra_info%rowtype;
8744:
8745: CURSOR people_ext_cur (person number) is
8746: SELECT person_extra_info_id, object_version_number
8747: FROM PER_people_EXTRA_INFO

Line 8747: FROM PER_people_EXTRA_INFO

8743: l_per_ei_data per_people_extra_info%rowtype;
8744:
8745: CURSOR people_ext_cur (person number) is
8746: SELECT person_extra_info_id, object_version_number
8747: FROM PER_people_EXTRA_INFO
8748: WHERE person_ID = person
8749: and information_type = 'GHR_US_PER_MASS_ACTIONS';
8750:
8751: l_proc varchar2(72) := g_package || '.ins_upd_per_ses_extra_info';

Line 8830: l_per_ei_data per_people_extra_info%rowtype;

8826: p_ses_basic_pay in out nocopy number
8827: )
8828: return boolean IS
8829:
8830: l_per_ei_data per_people_extra_info%rowtype;
8831: l_comments varchar2(250);
8832: l_sel_flag varchar2(3);
8833: l_line number := 0;
8834: l_proc varchar2(72) := g_package || '.check_select_flg_ses';