[Home] [Help]
149: p_effective_date => p_sf52_data.effective_date
150: );
151: End if;
152:
153: ghr_history_api.reinit_g_session_var;
154: ghr_api.g_api_dml := FALSE;
155: hr_utility.set_location(' Leaving : ' || l_proc, 200);
156:
157: EXCEPTION
188: p_process_type in varchar2 default 'CURRENT',
189: p_capped_other_pay in number default null ) is
190:
191: l_today date:=sysdate;
192: l_session_var ghr_history_api.g_session_var_type;
193: l_result varchar2(30);
194: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
195: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
196: l_sf52_shadow ghr_pa_requests%rowtype;
203: l_sf52_data := p_sf52_data ; --NOCOPY Changes
204: hr_utility.set_location(' Entering : ' || l_proc, 10);
205: hr_utility.set_location('Inside single action Payment Option ' || p_sf52_data.pa_incentive_payment_option, 20);
206: -- reinitialise session variables
207: ghr_history_api.reinit_g_session_var;
208: -- set values of session variables
209: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
210: l_session_var.noa_id := p_sf52_data.first_noa_id;
211: l_session_var.fire_trigger := 'Y';
213: l_session_var.person_id := p_sf52_data.person_id;
214: l_session_var.program_name := 'sf50';
215: l_session_var.altered_pa_request_id := p_sf52_data.altered_pa_request_id;
216: l_session_var.assignment_id := p_sf52_data.employee_assignment_id;
217: ghr_history_api.set_g_session_var(l_session_var);
218:
219:
220: l_sf52_data := p_sf52_data;
221:
342: l_sf52_data_save ghr_pa_requests%rowtype;
343: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
344: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
345: l_shadow_data ghr_pa_request_shadow%rowtype;
346: l_session_var ghr_history_api.g_session_var_type;
347: l_result varchar2(30);
348: l_proc varchar2(30):='dual_action_sf52';
349: l_new_assignment_id per_all_assignments_f.assignment_id%type;
350: l_capped_other_pay number := hr_api.g_number;
354: l_sf52_data := p_sf52_data ; --NOCOPY Changes
355:
356: hr_utility.set_location(' Entering : ' || l_proc, 10);
357: -- reinitialise session variables
358: ghr_history_api.reinit_g_session_var;
359: -- set values of session variables
360: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
361: l_session_var.noa_id := p_sf52_data.first_noa_id;
362: l_session_var.fire_trigger := 'Y';
363: l_session_var.date_Effective := p_sf52_data.effective_date;
364: l_session_var.person_id := p_sf52_data.person_id;
365: l_session_var.program_name := 'sf50';
366: l_session_var.assignment_id := p_sf52_data.employee_assignment_id;
367: ghr_history_api.set_g_session_var(l_session_var);
368:
369: l_sf52_data := p_sf52_data;
370:
371: refresh_req_shadow (
451: p_sf52_data => l_sf52_data);
452: end if;
453:
454: -- reinitialise session variables
455: ghr_history_api.reinit_g_session_var;
456: -- set values of session variables
457: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
458: l_session_var.noa_id := p_sf52_data.second_noa_id;
459: l_session_var.fire_trigger := 'Y';
460: l_session_var.date_Effective := p_sf52_data.effective_date;
461: l_session_var.person_id := p_sf52_data.person_id;
462: l_session_var.program_name := 'sf50';
463: l_session_var.assignment_id := l_sf52_data.employee_assignment_id;
464: ghr_history_api.set_g_session_var(l_session_var);
465:
466: -- get sf52 extra info.
467: Fetch_extra_info( p_pa_request_id => p_sf52_data.pa_request_id,
468: p_noa_id => p_sf52_data.second_noa_id,
1507: l_from_to varchar2(1) ;
1508: l_field_name varchar2(150);
1509: l_to_field_name varchar2(150);
1510: l_dual_actions ghr_dual_proc_methods%rowtype;
1511: l_session_var ghr_history_api.g_session_var_type;
1512: l_pa_history_id ghr_pa_history.pa_history_id%type;
1513: l_to_field varchar2(2000);
1514: l_proc varchar2(30):='copy_to_new_rg_shared';
1515:
1767: else
1768: if (l_correction is null) then
1769: --determine if this is a correction of the 2nd action and act accordingly. i.e. -
1770: -- only refresh if this is a correction.
1771: -- ghr_history_api.get_g_session_var(l_session_var);
1772: open get_root_pa_hist_id(cp_pa_request_id => p_pa_req.pa_request_id,
1773: cp_noa_id => p_pa_req.second_noa_id);
1774: fetch get_root_pa_hist_id into l_pa_history_id;
1775: close get_root_pa_hist_id;
1777: -- dual action is being processed. i.e. - this is not a correction of the dual action.
1778: if l_pa_history_id is not null then
1779: -- successfully found the root. Call refresh with this pa_history_id.
1780: l_correction := true;
1781: ghr_history_api.get_g_session_var(l_session_var);
1782: l_session_var.pa_history_id := l_pa_history_id;
1783: ghr_history_api.set_g_session_var(l_session_var);
1784: -- note that the following references to l_pa_req an p_pa_req are referencing definitions
1785: -- in assign_new_rg.
1779: -- successfully found the root. Call refresh with this pa_history_id.
1780: l_correction := true;
1781: ghr_history_api.get_g_session_var(l_session_var);
1782: l_session_var.pa_history_id := l_pa_history_id;
1783: ghr_history_api.set_g_session_var(l_session_var);
1784: -- note that the following references to l_pa_req an p_pa_req are referencing definitions
1785: -- in assign_new_rg.
1786: l_pa_req_ref2.from_position_id := l_pa_req.from_position_id;
1787: l_pa_req_ref2.to_position_id := l_pa_req.to_position_id;
1791: refresh_pa_request(p_person_id => p_pa_req.person_id,
1792: p_effective_date => p_pa_req.effective_date,
1793: p_sf52_data => l_pa_req_ref2);
1794: l_session_var.pa_history_id := null;
1795: ghr_history_api.set_g_session_var(l_session_var);
1796: else
1797: l_correction := false;
1798: end if;
1799: end if;
1826: else
1827: if (l_correction is null) then
1828: --determine if this is a correction of the 2nd action and act accordingly. i.e. -
1829: -- only refresh if this is a correction.
1830: -- ghr_history_api.get_g_session_var(l_session_var);
1831: open get_root_pa_hist_id(cp_pa_request_id => p_pa_req.pa_request_id,
1832: cp_noa_id => p_pa_req.second_noa_id);
1833: fetch get_root_pa_hist_id into l_pa_history_id;
1834: close get_root_pa_hist_id;
1836: -- dual action is being processed. i.e. - this is not a correction of the dual action.
1837: if l_pa_history_id is not null then
1838: -- successfully found the root. Call refresh with this pa_history_id.
1839: l_correction := true;
1840: ghr_history_api.get_g_session_var(l_session_var);
1841: l_session_var.pa_history_id := l_pa_history_id;
1842: ghr_history_api.set_g_session_var(l_session_var);
1843: -- note that the following references to l_pa_req an p_pa_req are referencing definitions
1844: -- in assign_new_rg.
1838: -- successfully found the root. Call refresh with this pa_history_id.
1839: l_correction := true;
1840: ghr_history_api.get_g_session_var(l_session_var);
1841: l_session_var.pa_history_id := l_pa_history_id;
1842: ghr_history_api.set_g_session_var(l_session_var);
1843: -- note that the following references to l_pa_req an p_pa_req are referencing definitions
1844: -- in assign_new_rg.
1845: l_pa_req_ref2.from_position_id := l_pa_req.from_position_id;
1846: l_pa_req_ref2.to_position_id := l_pa_req.to_position_id;
1850: refresh_pa_request(p_person_id => p_pa_req.person_id,
1851: p_effective_date => p_pa_req.effective_date,
1852: p_sf52_data => l_pa_req_ref2);
1853: l_session_var.pa_history_id := null;
1854: ghr_history_api.set_g_session_var(l_session_var);
1855: else
1856: l_correction := false;
1857: end if;
1858: end if;
3480: l_result_code varchar2(30);
3481: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%type;
3482: l_supervisory_diff_percentage ghr_pa_requests.to_supervisory_diff_percentage%type;
3483: l_staffing_diff_percentage ghr_pa_requests.to_staffing_diff_percentage%type;
3484: l_session_var ghr_history_api.g_session_var_type;
3485: l_noa_family_code ghr_pa_requests.noa_family_code%type;
3486: l_first_noa_id ghr_pa_requests.first_noa_id%type;
3487: l_first_noa_code ghr_pa_requests.first_noa_code%type;
3488: l_second_noa_id ghr_pa_requests.second_noa_id%type;
3593: between effective_start_date and effective_end_date;
3594:
3595: l_assignment_id per_all_assignments_f.assignment_id%type;
3596: l_asgei_data per_assignment_extra_info%rowtype;
3597: l_session ghr_history_api.g_session_var_type;
3598:
3599: BEGIN
3600: -- Get the Assignment ID from the position ID.
3601: FOR cur_ass_id_rec IN cur_ass_id(p_position_id,p_effective_date) LOOP
3614: IF (l_asgei_data.assignment_extra_info_id IS NOT NULL) THEN
3615: p_step_or_rate := l_asgei_data.aei_information3;
3616:
3617: ELSE
3618: ghr_history_api.get_g_session_var(l_session);
3619: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50
3620: (
3621: p_assignment_id => l_assignment_id,
3622: p_information_type => 'GHR_US_ASG_SF52',
3648: hr_utility.set_location('pay Rate in the beginning of Ref '|| p_sf52_data.pay_rate_determinant,11);
3649: hr_utility.set_location('To Pay Basis '|| p_sf52_data.to_pay_basis,11);
3650: hr_utility.set_location('Noa Family Code '|| p_sf52_data.noa_family_code,11);
3651:
3652: ghr_history_api.get_g_session_var( l_session_var);
3653: for c_rec in get_noa_info LOOP
3654: l_first_noa_id := c_rec.first_noa_id;
3655: l_first_noa_code := c_rec.first_noa_code;
3656: l_noa_family_code := c_rec.noa_family_code;
5463:
5464: l_adj_basic_message BOOLEAN;
5465: l_pay_cap_message BOOLEAN;
5466: l_temp_retention_allowance NUMBER;
5467: l_session_var ghr_history_api.g_session_var_type;
5468: l_multi_error_flag boolean;
5469: l_sf52_rec ghr_pa_requests%rowtype;
5470: l_capped_other_pay Number;
5471:
5672: End if;
5673: -- VSM temp call
5674: -- Begin Update 34 - Validation Logic
5675: hr_utility.set_location( 'Before calling do_pay_caps_main noa_family_code is ' ||p_sf52_rec.noa_family_code, 95);
5676: ghr_history_api.get_g_session_var( l_session_var);
5677: -- Bug#4486823 RRR Changes. Added GHR_INCENTIVE Family also.
5678: IF not (p_sf52_rec.noa_family_code in
5679: ('POS_REVIEW',
5680: 'RECRUIT_FILL',