[Home] [Help]
86: (SELECT NOA_FAMILY_CODE FROM ghr_noa_families
87: WHERE nature_of_action_id in
88: (SELECT nature_of_action_id
89: FROM ghr_nature_of_actions
90: WHERE code = nvl(ghr_msl_pkg.g_first_noa_code,'895') )
91: ) and proc_method_flag = 'Y';
92:
93: l_assignment_id per_assignments_f.assignment_id%type;
94: l_position_id per_assignments_f.position_id%type;
228: BEGIN
229: g_proc := 'execute_mlc';
230: hr_utility.set_location('Entering ' || l_proc,5);
231:
232: ghr_msl_pkg.g_first_noa_code := null;
233:
234: p_retcode := 0;
235: BEGIN
236: FOR msl IN ghr_msl (p_mass_salary_id)
279: l_lac_sf52_rec);
280:
281: --------GPPA Update 46 start
282: if l_effective_date >= to_date('2007/01/07','YYYY/MM/DD') THEN
283: ghr_msl_pkg.g_first_noa_code := '894';
284: --Begin Bug# 10387022, Removed LAC check from if condition
285: end if;
286:
287: --------GPPA Update 46 end
307: --BUG # 11924741 added to check whether already RPA exists with the NOA
308: IF chk_pa_req_already_exists
309: (p_person_id => per.person_id,
310: p_effective_date => l_effective_date,
311: p_first_noa_code => nvl(ghr_msl_pkg.g_first_noa_code,'895'),
312: p_action => p_action
313: ) then
314:
315: hr_utility.set_location('The location id is:'||l_location_id,12345);
375: end;
376:
377: BEGIN
378: -- Get Pay table ID and other details
379: ghr_msl_pkg.get_pay_plan_and_table_id(l_pay_rate_determinant,per.person_id,
380: l_position_id,l_effective_date,
381: l_grade_id, l_assignment_id,'SHOW',l_pay_plan,
382: l_pay_table_id,l_grade_or_level, l_step_or_rate,
383: l_pay_basis);
381: l_grade_id, l_assignment_id,'SHOW',l_pay_plan,
382: l_pay_table_id,l_grade_or_level, l_step_or_rate,
383: l_pay_basis);
384: EXCEPTION
385: when ghr_msl_pkg.msl_error then
386: l_mlcerrbuf := hr_utility.get_message;
387: raise mlc_error;
388: END;
389: IF get_user_table_name(l_pay_table_id) IN ('0000','0491') THEN --Bug# 10387022
457: close get_sal_chg_fam;
458:
459: l_pay_calc_in_data.person_id := per.person_id;
460: l_pay_calc_in_data.position_id := l_position_id;
461: l_pay_calc_in_data.noa_code := nvl(ghr_msl_pkg.g_first_noa_code,'895');
462: l_pay_calc_in_data.second_noa_code := null;
463: l_pay_calc_in_data.first_action_la_code1 := l_lac_sf52_rec.first_action_la_code1;
464: l_pay_calc_in_data.effective_date := l_effective_date;
465: l_pay_calc_in_data.pay_rate_determinant := l_pay_rate_determinant;
652: ,p_pay_plan => l_pay_plan
653: ,p_to_position_id => l_position_id
654: ,p_pay_basis => l_pay_basis
655: ,p_person_id => per.person_id
656: ,p_noa_code => nvl(ghr_msl_pkg.g_first_noa_code,'895')
657: ,p_basic_pay => l_new_basic_pay
658: ,p_locality_adj => l_new_locality_adj
659: ,p_adj_basic_pay => l_new_adj_basic_pay
660: ,p_total_salary => l_new_total_salary
818:
819: ELSIF upper(p_action) = 'CREATE' then
820:
821: BEGIN
822: ghr_msl_pkg.get_pay_plan_and_table_id
823: (l_pay_rate_determinant,per.person_id,
824: l_position_id,l_effective_date,
825: l_grade_id, l_assignment_id,'CREATE',
826: l_pay_plan,l_pay_table_id,
826: l_pay_plan,l_pay_table_id,
827: l_grade_or_level, l_step_or_rate,
828: l_pay_basis);
829: EXCEPTION
830: when ghr_msl_pkg.msl_error then
831: l_mlcerrbuf := hr_utility.get_message;
832: raise mlc_error;
833: END;
834:
1611: IF nvl(rec_pp_prd_per_gr(l_cnt).prd,'ALL') = 'ALL' OR
1612: nvl(rec_pp_prd_per_gr(l_cnt).prd,l_pay_rate_determinant) = l_pay_rate_determinant THEN
1613: -- Get Pay table ID and other details
1614: BEGIN
1615: ghr_msl_pkg.get_pay_plan_and_table_id(l_pay_rate_determinant,p_person_id,
1616: l_position_id,l_effective_date,
1617: l_grade_id, l_assignment_id,'SHOW',l_pay_plan,
1618: l_pay_table_id,l_grade_or_level, l_step_or_rate,
1619: l_pay_basis);
2033:
2034:
2035: ELSIF upper(p_action) = 'CREATE' then
2036: BEGIN
2037: ghr_msl_pkg.get_pay_plan_and_table_id
2038: (l_pay_rate_determinant,p_person_id,
2039: l_position_id,l_effective_date,
2040: l_grade_id, l_assignment_id,'CREATE',
2041: l_pay_plan,l_pay_table_id,
2251: hr_utility.set_location('Entering ' || l_proc,5);
2252: p_retcode := 0;
2253: l_count := 0;
2254:
2255: ghr_msl_pkg.g_first_noa_code := null;
2256:
2257:
2258: BEGIN
2259: FOR msl IN ghr_msl (p_mass_salary_id)
2310: rec_pp_prd_per_gr(1).grade := null;
2311: end if;
2312:
2313: IF upper(p_action) = 'CREATE' then
2314: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
2315: ELSE
2316: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
2317: END IF;
2318:
2840: from ghr_pa_requests
2841: where person_id = p_person_id
2842: and effective_date = p_effective_date
2843: and substr(request_number,(instr(request_number,'-')+1)) = to_char(p_mass_salary_id)
2844: and first_noa_code = nvl(ghr_msl_pkg.g_first_noa_code,'895');
2845:
2846: l_proc varchar2(72) := g_package || '.pop_dtls_from_pa_req';
2847: begin
2848: g_proc := 'pop_dtls_from_pa_req';
3529: IF p_action = 'CREATE' THEN
3530: IF person_in_pa_req_1noa
3531: (p_person_id => p_person_id,
3532: p_effective_date => p_effective_date,
3533: p_first_noa_code => nvl(ghr_msl_pkg.g_first_noa_code,'895'),
3534: p_pay_plan => p_pay_plan
3535: ) then
3536: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));
3537: RETURN FALSE;
4566: p_org_structure_id,
4567: p_agency_sub_element_code,
4568: p_person_id,
4569: p_sel_flg,
4570: nvl(ghr_msl_pkg.g_first_noa_code,'895'),
4571: p_first_action_la_code1,
4572: p_first_action_la_code2,
4573: p_grade_or_level,
4574: l_step_or_rate,