[Home] [Help]
618: l_true_or_false BOOLEAN := FALSE;
619: l_effective_date DATE;
620:
621: -- Bug 3021003
622: l_session ghr_history_api.g_session_var_type;
623: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
624: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
625: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
626: l_ia_effective_date ghr_pa_requests.effective_date%type;
638: l_retained_grade := p_retained_grade;
639: l_retained_step_or_rate := p_retained_step_or_rate;
640: l_temp_step := p_temp_step;
641:
642: ghr_history_api.get_g_session_var(l_session); -- Bug 3021003
643: -----------If an Intervening cancellation has been done, Need to take previous Step or rate
644: IF l_session.noa_id_correct IS NOT NULL THEN
645: -- Get notification id and step from RPA
646: hr_utility.set_location('Sun l_session.altered_pa_request_id' || l_session.altered_pa_request_id,10);
1009: l_pay_plan VARCHAR2(30);
1010: --
1011: l_proc VARCHAR2(30) := 'get_locality_adj';
1012: l_new_step_or_rate VARCHAR2(30); --AVR
1013: l_session ghr_history_api.g_session_var_type;
1014: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
1015:
1016:
1017: l_user_table_id pay_user_tables.user_table_id%type;
1072: l_retained_grade.step_or_rate := p_retained_grade.step_or_rate;
1073: l_retained_grade.temp_step := p_retained_grade.temp_step;
1074: -- to cater for PRD 'M' which may or may not have a retained grade record.
1075: -- if there is a retained grade record use that, otherwise use the position's
1076: ghr_history_api.get_g_session_var(l_session);
1077:
1078: IF p_retained_grade.pay_plan IS NOT NULL THEN
1079: l_pay_plan := p_retained_grade.pay_plan;
1080: l_user_table_id := p_retained_grade.user_table_id;
1806: between per1.effective_start_date and per1.effective_end_date
1807: and pet1.system_person_type = 'EX_EMP';
1808:
1809: l_ex_emp BOOLEAN;
1810: l_session ghr_history_api.g_session_var_type;
1811: v_session ghr_history_api.g_session_var_type;
1812:
1813: ----IA Correction Logic.
1814: cursor c_pa_req1 is
1807: and pet1.system_person_type = 'EX_EMP';
1808:
1809: l_ex_emp BOOLEAN;
1810: l_session ghr_history_api.g_session_var_type;
1811: v_session ghr_history_api.g_session_var_type;
1812:
1813: ----IA Correction Logic.
1814: cursor c_pa_req1 is
1815: select pa_notification_id
2057: hr_utility.set_location(' Passed Noa Fam Code = ' || p_noa_family_code,5);
2058: hr_utility.set_location(' Passed l_retention_allowance = ' || to_char(l_retention_allowance),5);
2059: hr_utility.set_location(' Passed l_to_ret_allow_percentage = ' || to_char(l_to_ret_allow_percentage),5);
2060:
2061: ghr_history_api.get_g_session_var(l_session);
2062: hr_utility.set_location( 'Get Ses NOAIDCORR is ' || to_char(l_session.noa_id_correct), 15);
2063: hr_utility.set_location( 'Get Ses ASGID is ' || to_char(l_session.assignment_id), 15);
2064: -- set values of session variables IA fetch sake.
2065: v_session.pa_request_id := l_session.pa_request_id;
2119:
2120: hr_utility.set_location( 'Ses NOAIDCORR is ' || to_char(v_session.noa_id_correct), 15);
2121: hr_utility.set_location( 'Ses ASGID is ' || to_char(v_session.assignment_id), 15);
2122:
2123: ghr_history_api.reinit_g_session_var;
2124: l_session.noa_id_correct := NULL;
2125: hr_utility.set_location( 'Set Ses NOAIDCORR is ' || to_char(l_session.noa_id_correct), 15);
2126: ghr_history_api.set_g_session_var(l_session);
2127:
2122:
2123: ghr_history_api.reinit_g_session_var;
2124: l_session.noa_id_correct := NULL;
2125: hr_utility.set_location( 'Set Ses NOAIDCORR is ' || to_char(l_session.noa_id_correct), 15);
2126: ghr_history_api.set_g_session_var(l_session);
2127:
2128: if l_ia_effective_date is not null then
2129: l_old_effective_date := l_ia_effective_date - 1;
2130: else
2229: end if;
2230: ELSE
2231: ghr_pc_basic_pay.g_noa_family_code := NULL;
2232: END IF;
2233: ghr_history_api.reinit_g_session_var;
2234: -- Reset values of session variables IA fetch sake.
2235: l_session.pa_request_id := v_session.pa_request_id;
2236: l_session.noa_id := v_session.noa_id;
2237: l_session.fire_trigger := v_session.fire_trigger;
2240: l_session.program_name := v_session.program_name;
2241: l_session.assignment_id := v_session.assignment_id;
2242: l_session.altered_pa_request_id := v_session.altered_pa_request_id;
2243: l_session.noa_id_correct := v_session.noa_id_correct;
2244: ghr_history_api.set_g_session_var(l_session);
2245:
2246: hr_utility.set_location( 'Ses NOAIDCORR is ' || to_char(l_session.noa_id_correct), 15);
2247: hr_utility.set_location( 'Ses ASGID is ' || to_char(l_session.assignment_id), 15);
2248:
4174: l_from_grade_id NUMBER;
4175: l_from_pos_ind VARCHAR2(30);
4176: l_to_pos_ind VARCHAR2(30);
4177: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
4178: l_session ghr_history_api.g_session_var_type;
4179:
4180:
4181: cursor get_equi_pay_plan(p_pay_plan in varchar2)
4182: is
4581: raise ghr_pay_calc.unable_to_calculate;
4582: END IF;
4583: --Bug# 9258929
4584: -- Get From assignment id and position id using person_id and effective date
4585: ghr_history_api.get_g_session_var(l_session);
4586: IF l_session.noa_id_correct is null then
4587: FOR ctr_get_asgn_pos IN get_asgn_pos(p_pay_calc_data.person_id,p_pay_calc_data.effective_date) LOOP
4588: l_from_position_id := ctr_get_asgn_pos.position_id;
4589: l_from_grade_id := ctr_get_asgn_pos.grade_id;