[Home] [Help]
84: (SELECT NOA_FAMILY_CODE FROM ghr_noa_families
85: WHERE nature_of_action_id in
86: (SELECT nature_of_action_id
87: FROM ghr_nature_of_actions
88: WHERE code = nvl(ghr_msl_pkg.g_first_noa_code,'895') )
89: ) and proc_method_flag = 'Y';
90:
91: l_assignment_id per_assignments_f.assignment_id%type;
92: l_position_id per_assignments_f.position_id%type;
226: BEGIN
227: g_proc := 'execute_mlc';
228: hr_utility.set_location('Entering ' || l_proc,5);
229:
230: ghr_msl_pkg.g_first_noa_code := null;
231:
232: p_retcode := 0;
233: BEGIN
234: FOR msl IN ghr_msl (p_mass_salary_id)
280:
281: if l_effective_date >= to_date('2007/01/07','YYYY/MM/DD') AND
282: l_lac_sf52_rec.first_action_la_code1 = 'VGR' THEN
283:
284: ghr_msl_pkg.g_first_noa_code := '894';
285:
286: end if;
287:
288: --------GPPA Update 46 end
368: end;
369:
370: BEGIN
371: -- Get Pay table ID and other details
372: ghr_msl_pkg.get_pay_plan_and_table_id(l_pay_rate_determinant,per.person_id,
373: l_position_id,l_effective_date,
374: l_grade_id, l_assignment_id,'SHOW',l_pay_plan,
375: l_pay_table_id,l_grade_or_level, l_step_or_rate,
376: l_pay_basis);
374: l_grade_id, l_assignment_id,'SHOW',l_pay_plan,
375: l_pay_table_id,l_grade_or_level, l_step_or_rate,
376: l_pay_basis);
377: EXCEPTION
378: when ghr_msl_pkg.msl_error then
379: l_mlcerrbuf := hr_utility.get_message;
380: raise mlc_error;
381: END;
382:
448: close get_sal_chg_fam;
449:
450: l_pay_calc_in_data.person_id := per.person_id;
451: l_pay_calc_in_data.position_id := l_position_id;
452: l_pay_calc_in_data.noa_code := nvl(ghr_msl_pkg.g_first_noa_code,'895');
453: l_pay_calc_in_data.second_noa_code := null;
454: l_pay_calc_in_data.first_action_la_code1 := l_lac_sf52_rec.first_action_la_code1;
455: l_pay_calc_in_data.effective_date := l_effective_date;
456: l_pay_calc_in_data.pay_rate_determinant := l_pay_rate_determinant;
640: ,p_pay_plan => l_pay_plan
641: ,p_to_position_id => l_position_id
642: ,p_pay_basis => l_pay_basis
643: ,p_person_id => per.person_id
644: ,p_noa_code => nvl(ghr_msl_pkg.g_first_noa_code,'895')
645: ,p_basic_pay => l_new_basic_pay
646: ,p_locality_adj => l_new_locality_adj
647: ,p_adj_basic_pay => l_new_adj_basic_pay
648: ,p_total_salary => l_new_total_salary
804:
805: ELSIF upper(p_action) = 'CREATE' then
806:
807: BEGIN
808: ghr_msl_pkg.get_pay_plan_and_table_id
809: (l_pay_rate_determinant,per.person_id,
810: l_position_id,l_effective_date,
811: l_grade_id, l_assignment_id,'CREATE',
812: l_pay_plan,l_pay_table_id,
812: l_pay_plan,l_pay_table_id,
813: l_grade_or_level, l_step_or_rate,
814: l_pay_basis);
815: EXCEPTION
816: when ghr_msl_pkg.msl_error then
817: l_mlcerrbuf := hr_utility.get_message;
818: raise mlc_error;
819: END;
820:
1583: IF nvl(rec_pp_prd_per_gr(l_cnt).prd,'ALL') = 'ALL' OR
1584: nvl(rec_pp_prd_per_gr(l_cnt).prd,l_pay_rate_determinant) = l_pay_rate_determinant THEN
1585: -- Get Pay table ID and other details
1586: BEGIN
1587: ghr_msl_pkg.get_pay_plan_and_table_id(l_pay_rate_determinant,p_person_id,
1588: l_position_id,l_effective_date,
1589: l_grade_id, l_assignment_id,'SHOW',l_pay_plan,
1590: l_pay_table_id,l_grade_or_level, l_step_or_rate,
1591: l_pay_basis);
1999:
2000:
2001: ELSIF upper(p_action) = 'CREATE' then
2002: BEGIN
2003: ghr_msl_pkg.get_pay_plan_and_table_id
2004: (l_pay_rate_determinant,p_person_id,
2005: l_position_id,l_effective_date,
2006: l_grade_id, l_assignment_id,'CREATE',
2007: l_pay_plan,l_pay_table_id,
2214: hr_utility.set_location('Entering ' || l_proc,5);
2215: p_retcode := 0;
2216: l_count := 0;
2217:
2218: ghr_msl_pkg.g_first_noa_code := null;
2219:
2220:
2221: BEGIN
2222: FOR msl IN ghr_msl (p_mass_salary_id)
2273: rec_pp_prd_per_gr(1).grade := null;
2274: end if;
2275:
2276: IF upper(p_action) = 'CREATE' then
2277: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
2278: ELSE
2279: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
2280: END IF;
2281:
2798: from ghr_pa_requests
2799: where person_id = p_person_id
2800: and effective_date = p_effective_date
2801: and substr(request_number,(instr(request_number,'-')+1)) = to_char(p_mass_salary_id)
2802: and first_noa_code = nvl(ghr_msl_pkg.g_first_noa_code,'895');
2803:
2804: l_proc varchar2(72) := g_package || '.pop_dtls_from_pa_req';
2805: begin
2806: g_proc := 'pop_dtls_from_pa_req';
3483: IF p_action = 'CREATE' THEN
3484: IF person_in_pa_req_1noa
3485: (p_person_id => p_person_id,
3486: p_effective_date => p_effective_date,
3487: p_first_noa_code => nvl(ghr_msl_pkg.g_first_noa_code,'895'),
3488: p_pay_plan => p_pay_plan
3489: ) then
3490: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));
3491: RETURN FALSE;
4514: p_org_structure_id,
4515: p_agency_sub_element_code,
4516: p_person_id,
4517: p_sel_flg,
4518: nvl(ghr_msl_pkg.g_first_noa_code,'895'),
4519: p_first_action_la_code1,
4520: p_first_action_la_code2,
4521: p_grade_or_level,
4522: l_step_or_rate,