[Home] [Help]
1748: PROCEDURE purge_processed_recs(p_session_id in number,
1749: p_err_buf out nocopy varchar2) IS
1750: BEGIN
1751: p_err_buf := null;
1752: DELETE from ghr_mass_actions_preview
1753: WHERE mass_action_type = 'SALARY'
1754: AND session_id = p_session_id;
1755: COMMIT;
1756:
1846:
1847: l_proc varchar2(72) := g_package || '.pop_dtls_from_pa_req';
1848: l_sel_flag VARCHAR2(3) := NULL;
1849: l_comments VARCHAR2(150) := NULL;
1850: l_increase_percent ghr_mass_actions_preview.increase_percent%type;
1851: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;
1852:
1853: BEGIN
1854: g_proc := 'pop_dtls_from_pa_req';
1847: l_proc varchar2(72) := g_package || '.pop_dtls_from_pa_req';
1848: l_sel_flag VARCHAR2(3) := NULL;
1849: l_comments VARCHAR2(150) := NULL;
1850: l_increase_percent ghr_mass_actions_preview.increase_percent%type;
1851: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;
1852:
1853: BEGIN
1854: g_proc := 'pop_dtls_from_pa_req';
1855:
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';
1981: l_increase_percent ghr_mass_actions_preview.increase_percent%type; -- Added by Sundar 3843306
1982: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;
1983: l_temp_increase_percent number;
1984: begin
1985:
1978: l_sel_flag varchar2(3);
1979: l_line number := 0;
1980: l_proc varchar2(72) := g_package || '.check_select_flg_msl_perc';
1981: l_increase_percent ghr_mass_actions_preview.increase_percent%type; -- Added by Sundar 3843306
1982: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;
1983: l_temp_increase_percent number;
1984: begin
1985:
1986: g_proc := 'check_select_flg_msl_perc';
2062: l_comments varchar2(250);
2063: l_sel_flag varchar2(3);
2064: l_line number := 0;
2065: l_temp NUMBER;
2066: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;
2067:
2068: l_proc varchar2(72) := g_package || '.check_select_flg';
2069: begin
2070:
2128: BEGIN
2129: g_proc := 'purge_old_data';
2130:
2131: hr_utility.set_location('Entering ' || l_proc,5);
2132: delete from ghr_mass_actions_preview
2133: where mass_action_type = 'SALARY'
2134: and session_id = p_mass_salary_id;
2135: commit;
2136: hr_utility.set_location('Exiting ' || l_proc,10);
3235: l_grade_id per_assignments_f.grade_id%TYPE;
3236: l_business_group_id per_assignments_f.business_group_iD%TYPE;
3237: l_location_id per_assignments_f.location_id%TYPE;
3238: l_organization_id per_assignments_f.organization_id%TYPE;
3239: l_increase_percent ghr_mass_actions_preview.increase_percent%type;
3240: l_tenure VARCHAR2(35);
3241: l_annuitant_indicator VARCHAR2(35);
3242: l_pay_rate_determinant VARCHAR2(35);
3243: l_work_schedule VARCHAR2(35);
4489: raise msl_error;
4490: END IF;
4491: END IF;
4492:
4493: insert into GHR_MASS_ACTIONS_PREVIEW
4494: (
4495: mass_action_type,
4496: --report_type,
4497: ui_type,
7404: from ghr_pay_plans
7405: where pay_plan = c_pay_plan;
7406:
7407: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
7408: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;
7409:
7410:
7411: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE
7412: ,p_person_id per_assignments_f.person_id%TYPE
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';
8835: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;
8836: l_temp_ses_basic_pay number;
8837: l_increase_percent number;
8838: begin
8839: