[Home] [Help]
223: p_effective_date => p_sf52_data.effective_date
224: );
225: End if;
226:
227: ghr_history_api.reinit_g_session_var;
228: ghr_api.g_api_dml := FALSE;
229: hr_utility.set_location(' Leaving : ' || l_proc, 200);
230:
231: EXCEPTION
262: p_process_type in varchar2 default 'CURRENT',
263: p_capped_other_pay in number default null ) is
264:
265: l_today date:=sysdate;
266: l_session_var ghr_history_api.g_session_var_type;
267: l_result varchar2(30);
268: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
269: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
270: l_sf52_shadow ghr_pa_requests%rowtype;
277: l_sf52_data := p_sf52_data ; --NOCOPY Changes
278: hr_utility.set_location(' Entering : ' || l_proc, 10);
279: hr_utility.set_location('Inside single action Payment Option ' || p_sf52_data.pa_incentive_payment_option, 20);
280: -- reinitialise session variables
281: ghr_history_api.reinit_g_session_var;
282: -- set values of session variables
283: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
284: l_session_var.noa_id := p_sf52_data.first_noa_id;
285: l_session_var.fire_trigger := 'Y';
287: l_session_var.person_id := p_sf52_data.person_id;
288: l_session_var.program_name := 'sf50';
289: l_session_var.altered_pa_request_id := p_sf52_data.altered_pa_request_id;
290: l_session_var.assignment_id := p_sf52_data.employee_assignment_id;
291: ghr_history_api.set_g_session_var(l_session_var);
292:
293:
294: l_sf52_data := p_sf52_data;
295:
416: l_sf52_data_save ghr_pa_requests%rowtype;
417: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
418: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
419: l_shadow_data ghr_pa_request_shadow%rowtype;
420: l_session_var ghr_history_api.g_session_var_type;
421: l_result varchar2(30);
422: l_proc varchar2(30):='dual_action_sf52';
423: l_new_assignment_id per_all_assignments_f.assignment_id%type;
424: l_capped_other_pay number;
428: l_sf52_data := p_sf52_data ; --NOCOPY Changes
429:
430: hr_utility.set_location(' Entering : ' || l_proc, 10);
431: -- reinitialise session variables
432: ghr_history_api.reinit_g_session_var;
433: -- set values of session variables
434: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
435: l_session_var.noa_id := p_sf52_data.first_noa_id;
436: l_session_var.fire_trigger := 'Y';
437: l_session_var.date_Effective := p_sf52_data.effective_date;
438: l_session_var.person_id := p_sf52_data.person_id;
439: l_session_var.program_name := 'sf50';
440: l_session_var.assignment_id := p_sf52_data.employee_assignment_id;
441: ghr_history_api.set_g_session_var(l_session_var);
442: ghr_process_sf52.g_dual_action_yn := 'Y';
443: ghr_process_sf52.g_dual_first_noac := p_sf52_data.first_noa_code;
444: ghr_process_sf52.g_dual_second_noac := p_sf52_data.second_noa_code;
445:
543: p_sf52_data => l_sf52_data);
544: end if;
545:
546: -- reinitialise session variables
547: ghr_history_api.reinit_g_session_var;
548: -- set values of session variables
549: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
550: l_session_var.noa_id := p_sf52_data.second_noa_id;
551: l_session_var.fire_trigger := 'Y';
552: l_session_var.date_Effective := p_sf52_data.effective_date;
553: l_session_var.person_id := p_sf52_data.person_id;
554: l_session_var.program_name := 'sf50';
555: l_session_var.assignment_id := l_sf52_data.employee_assignment_id;
556: ghr_history_api.set_g_session_var(l_session_var);
557:
558: -- get sf52 extra info.
559: Fetch_extra_info( p_pa_request_id => p_sf52_data.pa_request_id,
560: p_noa_id => p_sf52_data.second_noa_id,
1599: l_from_to varchar2(1) ;
1600: l_field_name varchar2(150);
1601: l_to_field_name varchar2(150);
1602: l_dual_actions ghr_dual_proc_methods%rowtype;
1603: l_session_var ghr_history_api.g_session_var_type;
1604: l_pa_history_id ghr_pa_history.pa_history_id%type;
1605: l_to_field varchar2(2000);
1606: l_proc varchar2(30):='copy_to_new_rg_shared';
1607:
1875: else
1876: if (l_correction is null) then
1877: --determine if this is a correction of the 2nd action and act accordingly. i.e. -
1878: -- only refresh if this is a correction.
1879: -- ghr_history_api.get_g_session_var(l_session_var);
1880: open get_root_pa_hist_id(cp_pa_request_id => p_pa_req.pa_request_id,
1881: cp_noa_id => p_pa_req.second_noa_id);
1882: fetch get_root_pa_hist_id into l_pa_history_id;
1883: close get_root_pa_hist_id;
1886: -- dual action is being processed. i.e. - this is not a correction of the dual action.
1887: if l_pa_history_id is not null and p_pa_req.first_noa_code in ('002') then
1888: -- successfully found the root. Call refresh with this pa_history_id.
1889: l_correction := true;
1890: ghr_history_api.get_g_session_var(l_session_var);
1891: l_session_var.pa_history_id := l_pa_history_id;
1892: ghr_history_api.set_g_session_var(l_session_var);
1893: -- note that the following references to l_pa_req an p_pa_req are referencing definitions
1894: -- in assign_new_rg.
1888: -- successfully found the root. Call refresh with this pa_history_id.
1889: l_correction := true;
1890: ghr_history_api.get_g_session_var(l_session_var);
1891: l_session_var.pa_history_id := l_pa_history_id;
1892: ghr_history_api.set_g_session_var(l_session_var);
1893: -- note that the following references to l_pa_req an p_pa_req are referencing definitions
1894: -- in assign_new_rg.
1895: l_pa_req_ref2.from_position_id := l_pa_req.from_position_id;
1896: l_pa_req_ref2.to_position_id := l_pa_req.to_position_id;
1902: p_effective_date => p_pa_req.effective_date,
1903: p_sf52_data => l_pa_req_ref2);
1904:
1905: l_session_var.pa_history_id := null;
1906: ghr_history_api.set_g_session_var(l_session_var);
1907: else
1908: l_correction := false;
1909: end if;
1910: end if;
1938: else
1939: if (l_correction is null) then
1940: --determine if this is a correction of the 2nd action and act accordingly. i.e. -
1941: -- only refresh if this is a correction.
1942: -- ghr_history_api.get_g_session_var(l_session_var);
1943: open get_root_pa_hist_id(cp_pa_request_id => p_pa_req.pa_request_id,
1944: cp_noa_id => p_pa_req.second_noa_id);
1945: fetch get_root_pa_hist_id into l_pa_history_id;
1946: close get_root_pa_hist_id;
1948: -- dual action is being processed. i.e. - this is not a correction of the dual action.
1949: if l_pa_history_id is not null then
1950: -- successfully found the root. Call refresh with this pa_history_id.
1951: l_correction := true;
1952: ghr_history_api.get_g_session_var(l_session_var);
1953: l_session_var.pa_history_id := l_pa_history_id;
1954: ghr_history_api.set_g_session_var(l_session_var);
1955: -- note that the following references to l_pa_req an p_pa_req are referencing definitions
1956: -- in assign_new_rg.
1950: -- successfully found the root. Call refresh with this pa_history_id.
1951: l_correction := true;
1952: ghr_history_api.get_g_session_var(l_session_var);
1953: l_session_var.pa_history_id := l_pa_history_id;
1954: ghr_history_api.set_g_session_var(l_session_var);
1955: -- note that the following references to l_pa_req an p_pa_req are referencing definitions
1956: -- in assign_new_rg.
1957: l_pa_req_ref2.from_position_id := l_pa_req.from_position_id;
1958: l_pa_req_ref2.to_position_id := l_pa_req.to_position_id;
1962: refresh_pa_request(p_person_id => p_pa_req.person_id,
1963: p_effective_date => p_pa_req.effective_date,
1964: p_sf52_data => l_pa_req_ref2);
1965: l_session_var.pa_history_id := null;
1966: ghr_history_api.set_g_session_var(l_session_var);
1967: else
1968: l_correction := false;
1969: end if;
1970: end if;
3608: l_result_code varchar2(30);
3609: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%type;
3610: l_supervisory_diff_percentage ghr_pa_requests.to_supervisory_diff_percentage%type;
3611: l_staffing_diff_percentage ghr_pa_requests.to_staffing_diff_percentage%type;
3612: l_session_var ghr_history_api.g_session_var_type;
3613: l_noa_family_code ghr_pa_requests.noa_family_code%type;
3614: l_first_noa_id ghr_pa_requests.first_noa_id%type;
3615: l_first_noa_code ghr_pa_requests.first_noa_code%type;
3616: l_second_noa_id ghr_pa_requests.second_noa_id%type;
3774: between effective_start_date and effective_end_date;
3775:
3776: l_assignment_id per_all_assignments_f.assignment_id%type;
3777: l_asgei_data per_assignment_extra_info%rowtype;
3778: l_session ghr_history_api.g_session_var_type;
3779:
3780:
3781: BEGIN
3782: -- Get the Assignment ID from the position ID.
3796: IF (l_asgei_data.assignment_extra_info_id IS NOT NULL) THEN
3797: p_step_or_rate := l_asgei_data.aei_information3;
3798:
3799: ELSE
3800: ghr_history_api.get_g_session_var(l_session);
3801: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50
3802: (
3803: p_assignment_id => l_assignment_id,
3804: p_information_type => 'GHR_US_ASG_SF52',
3830: hr_utility.set_location('pay Rate in the beginning of Ref '|| p_sf52_data.pay_rate_determinant,11);
3831: hr_utility.set_location('To Pay Basis '|| p_sf52_data.to_pay_basis,11);
3832: hr_utility.set_location('Noa Family Code '|| p_sf52_data.noa_family_code,11);
3833:
3834: ghr_history_api.get_g_session_var( l_session_var);
3835: for c_rec in get_noa_info LOOP
3836: l_first_noa_id := c_rec.first_noa_id;
3837: l_first_noa_code := c_rec.first_noa_code;
3838: l_noa_family_code := c_rec.noa_family_code;
5709:
5710: l_adj_basic_message BOOLEAN;
5711: l_pay_cap_message BOOLEAN;
5712: l_temp_retention_allowance NUMBER;
5713: l_session_var ghr_history_api.g_session_var_type;
5714: l_multi_error_flag boolean;
5715: l_sf52_rec ghr_pa_requests%rowtype;
5716: l_capped_other_pay Number;
5717:
5932: End if;
5933: -- VSM temp call
5934: -- Begin Update 34 - Validation Logic
5935: hr_utility.set_location( 'Before calling do_pay_caps_main noa_family_code is ' ||p_sf52_rec.noa_family_code, 95);
5936: ghr_history_api.get_g_session_var( l_session_var);
5937: -- Bug#4486823 RRR Changes. Added GHR_INCENTIVE Family also.
5938: IF not (p_sf52_rec.noa_family_code in
5939: ('POS_REVIEW',
5940: 'RECRUIT_FILL',
7082: open c_dual_first;
7083: fetch c_dual_first into l_sf52_dual_first_rec;
7084: close c_dual_first;
7085:
7086: ghr_history_api.reinit_g_session_var;
7087:
7088: hr_utility.set_location('l_sf52_dual_sec_rec.from_position_id'||l_sf52_dual_sec_rec.from_position_id,10);
7089: hr_utility.set_location('l_sf52_dual_sec_rec.to_position_id'||l_sf52_dual_sec_rec.to_position_id,11);
7090: ghr_sf52_post_update.get_notification_details