[Home] [Help]
1946: p_increase_percent in out nocopy number
1947: )
1948: return boolean IS
1949:
1950: l_per_ei_data per_people_extra_info%rowtype;
1951: l_comments varchar2(250);
1952: l_sel_flag varchar2(3);
1953: l_line number := 0;
1954: l_proc varchar2(72) := g_package || '.check_select_flg_msl_perc';
2029: p_sel_flg in out nocopy varchar2
2030: )
2031: return boolean IS
2032:
2033: l_per_ei_data per_people_extra_info%rowtype;
2034: l_comments varchar2(250);
2035: l_sel_flag varchar2(3);
2036: l_line number := 0;
2037: l_temp NUMBER;
2509: procedure update_sel_flg (p_person_id in number,p_effective_date date) is
2510:
2511: l_person_extra_info_id number;
2512: l_object_version_number number;
2513: l_per_ei_data per_people_extra_info%rowtype;
2514: l_proc varchar2(72) := g_package || '.update_sel_flg';
2515: l_ind number := 1;
2516: begin
2517: g_proc := 'update_sel_flg';
2541: ,P_PEI_INFORMATION_CATEGORY => 'GHR_US_PER_MASS_ACTIONS');
2542:
2543: l_ind := 30;
2544: hr_utility.set_location('Exiting ' || l_proc,10);
2545: -- There is a trigger on PER_PEOPLE_EXTRA_INFO to make the employee INVALID
2546: -- when there is a update done on the table.
2547: ---Commented the following three lines to remove Validation functionality on Person.
2548: --- ghr_validate_perwsepi.validate_perwsepi(p_person_id);
2549: --- l_ind := 40;
2614: p_mass_salary_id in number,
2615: p_increase_percent out nocopy number,
2616: p_ses_basic_pay out nocopy number) is
2617:
2618: l_per_ei_data per_people_extra_info%rowtype;
2619: l_proc varchar2(72) := g_package || '.get_extra_info_comments';
2620: l_eff_date date;
2621:
2622: CURSOR chk_history (p_person_id in NUMBER ,
2631: and pa_history_id IN ( select max(pa_history_id)
2632: from ghr_pa_history
2633: where person_id = p_person_id
2634: and information5 = 'GHR_US_PER_MASS_ACTIONS'
2635: and table_name = 'PER_PEOPLE_EXTRA_INFO'
2636: and effective_date = eff_date
2637: group by information11);
2638:
2639: begin
2703: p_increase_percent in number default NULL) is
2704:
2705: l_person_extra_info_id number;
2706: l_object_version_number number;
2707: l_per_ei_data per_people_extra_info%rowtype;
2708:
2709: CURSOR people_ext_cur (person number) is
2710: SELECT person_extra_info_id, object_version_number
2711: FROM PER_people_EXTRA_INFO
2707: l_per_ei_data per_people_extra_info%rowtype;
2708:
2709: CURSOR people_ext_cur (person number) is
2710: SELECT person_extra_info_id, object_version_number
2711: FROM PER_people_EXTRA_INFO
2712: WHERE person_ID = person
2713: and information_type = 'GHR_US_PER_MASS_ACTIONS';
2714:
2715: l_proc varchar2(72) := g_package || '.ins_upd_per_extra_info';
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
4712: procedure upd_ext_info_to_null(p_effective_date in date) is
4713:
4714: cursor cur1 is
4715: select person_id
4716: FROM PER_people_EXTRA_INFO
4717: WHERE information_type = 'GHR_US_PER_MASS_ACTIONS'
4718: AND pei_INFORMATION3 IS NOT NULL;
4719:
4720: l_person_id number;
8575: p_ses_basic_pay in number default NULL) is
8576:
8577: l_person_extra_info_id number;
8578: l_object_version_number number;
8579: l_per_ei_data per_people_extra_info%rowtype;
8580:
8581: CURSOR people_ext_cur (person number) is
8582: SELECT person_extra_info_id, object_version_number
8583: FROM PER_people_EXTRA_INFO
8579: l_per_ei_data per_people_extra_info%rowtype;
8580:
8581: CURSOR people_ext_cur (person number) is
8582: SELECT person_extra_info_id, object_version_number
8583: FROM PER_people_EXTRA_INFO
8584: WHERE person_ID = person
8585: and information_type = 'GHR_US_PER_MASS_ACTIONS';
8586:
8587: l_proc varchar2(72) := g_package || '.ins_upd_per_ses_extra_info';
8662: p_ses_basic_pay in out nocopy number
8663: )
8664: return boolean IS
8665:
8666: l_per_ei_data per_people_extra_info%rowtype;
8667: l_comments varchar2(250);
8668: l_sel_flag varchar2(3);
8669: l_line number := 0;
8670: l_proc varchar2(72) := g_package || '.check_select_flg_ses';