APPS.GHR_VALIDATE_CHECK dependencies on GHR_PAY_CALC

Line 106: l_retained_grade ghr_pay_calc.retained_grade_rec_type;

102: l_row_low number;
103: l_user_table_id number;
104: l_pay_plan VARCHAR2(30);
105: l_grade_or_level VARCHAR2(60);
106: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
107:
108: ------- Retrieve Position Status --
109: cursor c_get_psn_status(p_position_id number) is
110: select pps.status from hr_all_positions_f pps -- Venkat - Position DT

Line 752: l_user_tab_id := ghr_pay_calc.get_user_table_id(

748: hr_utility.set_message(8301, 'GHR_38889_SES_WGI_NO');
749: hr_utility.raise_error;
750: END IF;
751:
752: l_user_tab_id := ghr_pay_calc.get_user_table_id(
753: p_position_id => p_pa_request_rec.to_position_id
754: ,p_effective_date => p_pa_request_rec.effective_date
755: );
756:

Line 779: l_user_tab_id := ghr_pay_calc.get_user_table_id(

775: hr_utility.set_message(8301, 'GHR_38897_EE_WGI_NO');
776: hr_utility.raise_error;
777: END IF;
778:
779: l_user_tab_id := ghr_pay_calc.get_user_table_id(
780: p_position_id => p_pa_request_rec.to_position_id
781: ,p_effective_date => p_pa_request_rec.effective_date
782: );
783:

Line 961: ghr_pay_calc.convert_amount(

957: END IF;
958: /* check staffing diff. */
959: l_staffing_differential:=p_pa_request_rec.TO_STAFFING_DIFFERENTIAL;
960: If l_staffing_differential is not null and
961: ghr_pay_calc.convert_amount(
962: l_staffing_differential,
963: 'PA',
964: p_pa_request_rec.to_pay_basis)
965: > round((nvl(l_To_Basic_Pay,0) * 0.05)) then

Line 1005: ghr_pay_calc.convert_amount(

1001: Added for bug 3067420 check supervisiry differential by Ashley
1002: l_to_supervisor_diff := p_pa_request_rec.TO_SUPERVISORY_DIFFERENTIAL ;
1003:
1004: if l_to_supervisor_diff is not null and
1005: ghr_pay_calc.convert_amount(
1006: l_to_supervisor_diff,
1007: 'PA',
1008: p_pa_request_rec.to_pay_basis)
1009: > (nvl(l_To_Basic_Pay,0) * 0.25) then

Line 1149: ghr_pay_calc.award_amount_calc (

1145: end if;
1146: END IF;
1147: --8528195
1148:
1149: ghr_pay_calc.award_amount_calc (
1150: p_position_id => p_pa_request_rec.to_position_id
1151: ,p_pay_plan => p_pa_request_rec.from_pay_plan
1152: ,p_award_percentage => NULL
1153: ,p_user_table_id => p_pa_request_rec.from_pay_table_identifier

Line 1170: /*l_award_salary := ghr_pay_calc.convert_amount(p_pa_request_rec.from_basic_pay

1166: l_award_salary := p_pa_request_rec.award_salary;
1167: END IF;
1168:
1169: -- End Bug# 5020754
1170: /*l_award_salary := ghr_pay_calc.convert_amount(p_pa_request_rec.from_basic_pay
1171: ,p_pa_request_rec.from_pay_basis,'PA');*/
1172: -- end Bug# 4748927
1173: --Use the same Message Name for All.
1174: hr_utility.set_message(8301,'GHR_38904_AWARD_AMT_TOO_BIG5');

Line 1238: ELSIF ( ghr_pay_calc.LEO_position( p_prd => l_temp

1234: hr_utility.set_message(8301, 'GHR_38898_AWARD_AMT_TOO_BIG3');
1235: hr_utility.raise_error;
1236: END IF;
1237: --3818297 Added NVL
1238: ELSIF ( ghr_pay_calc.LEO_position( p_prd => l_temp
1239: ,p_position_id => NVL(p_pa_request_rec.to_position_id,p_pa_request_rec.from_position_id)
1240: ,p_retained_user_table_id => l_temp
1241: ,p_duty_station_id => l_temp
1242: ,p_effective_date => p_pa_request_rec.effective_date

Line 1254: ELSIF (NOT ghr_pay_calc.LEO_position( p_prd => l_temp

1250: hr_utility.set_message(8301, 'GHR_38896_AWARD_AMT_TOO_BIG2');
1251: hr_utility.raise_error;
1252: END IF;
1253: --3818297 Added NVL
1254: ELSIF (NOT ghr_pay_calc.LEO_position( p_prd => l_temp
1255: ,p_position_id => NVL(p_pa_request_rec.to_position_id,p_pa_request_rec.from_position_id)
1256: ,p_retained_user_table_id => l_temp
1257: ,p_duty_station_id => l_temp
1258: ,p_effective_date => p_pa_request_rec.effective_date

Line 2291: IF ghr_pay_calc.get_open_pay_range

2287: ,'RECRUIT_FILL'
2288: ,'SEPARATION'
2289: ,'GHR_STUDENT_LOAN') THEN
2290: IF p_pa_request_rec.to_position_id is not null THEN
2291: IF ghr_pay_calc.get_open_pay_range
2292: (p_pa_request_rec.to_position_id
2293: ,p_pa_request_rec.person_id
2294: ,p_pa_request_rec.pay_rate_determinant
2295: ,p_pa_request_rec.pa_request_id

Line 2322: l_user_table_id := ghr_pay_calc.get_user_table_id (p_pa_request_rec.to_position_id

2318:
2319: ELSE
2320:
2321:
2322: l_user_table_id := ghr_pay_calc.get_user_table_id (p_pa_request_rec.to_position_id
2323: ,NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)) );
2324: --Start of the Bug 3604377
2325: -- Retive the Grade info from the POI history table
2326: ghr_history_fetch.fetch_positionei(

Line 2355: ghr_pay_calc.get_open_pay_table_values

2351:
2352: hr_utility.set_location('GHRVALID-l_user_table_id ' || to_char(l_user_table_id) ,5);
2353: hr_utility.set_location('GHRVALID-Open Pay Range get values' ,5);
2354:
2355: ghr_pay_calc.get_open_pay_table_values
2356: (p_user_table_id => l_user_table_id
2357: ,p_pay_plan => l_pay_plan
2358: ,p_grade_or_level => l_grade_or_level
2359: ,p_effective_date => NVL(p_pa_request_rec.effective_date,TRUNC(sysdate))