DBA Data[Home] [Help]

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 655: l_user_tab_id := ghr_pay_calc.get_user_table_id(

651: hr_utility.set_message(8301, 'GHR_38889_SES_WGI_NO');
652: hr_utility.raise_error;
653: END IF;
654:
655: l_user_tab_id := ghr_pay_calc.get_user_table_id(
656: p_position_id => p_pa_request_rec.to_position_id
657: ,p_effective_date => p_pa_request_rec.effective_date
658: );
659:

Line 682: l_user_tab_id := ghr_pay_calc.get_user_table_id(

678: hr_utility.set_message(8301, 'GHR_38897_EE_WGI_NO');
679: hr_utility.raise_error;
680: END IF;
681:
682: l_user_tab_id := ghr_pay_calc.get_user_table_id(
683: p_position_id => p_pa_request_rec.to_position_id
684: ,p_effective_date => p_pa_request_rec.effective_date
685: );
686:

Line 862: ghr_pay_calc.convert_amount(

858: END IF;
859: /* check staffing diff. */
860: l_staffing_differential:=p_pa_request_rec.TO_STAFFING_DIFFERENTIAL;
861: If l_staffing_differential is not null and
862: ghr_pay_calc.convert_amount(
863: l_staffing_differential,
864: 'PA',
865: p_pa_request_rec.to_pay_basis)
866: > round((nvl(l_To_Basic_Pay,0) * 0.05)) then

Line 906: ghr_pay_calc.convert_amount(

902: Added for bug 3067420 check supervisiry differential by Ashley
903: l_to_supervisor_diff := p_pa_request_rec.TO_SUPERVISORY_DIFFERENTIAL ;
904:
905: if l_to_supervisor_diff is not null and
906: ghr_pay_calc.convert_amount(
907: l_to_supervisor_diff,
908: 'PA',
909: p_pa_request_rec.to_pay_basis)
910: > (nvl(l_To_Basic_Pay,0) * 0.25) then

Line 1026: ghr_pay_calc.award_amount_calc (

1022: IF p_pa_request_rec.noa_family_code = 'AWARD' THEN
1023: -- Begin Bug# 4748927
1024: -- Begin Bug# 5020754
1025: IF p_pa_request_rec.award_salary IS NULL THEN
1026: ghr_pay_calc.award_amount_calc (
1027: p_position_id => p_pa_request_rec.to_position_id
1028: ,p_pay_plan => p_pa_request_rec.from_pay_plan
1029: ,p_award_percentage => NULL
1030: ,p_user_table_id => p_pa_request_rec.from_pay_table_identifier

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

1042: ELSE
1043: l_award_salary := p_pa_request_rec.award_salary;
1044: END IF;
1045: -- End Bug# 5020754
1046: /*l_award_salary := ghr_pay_calc.convert_amount(p_pa_request_rec.from_basic_pay
1047: ,p_pa_request_rec.from_pay_basis,'PA');*/
1048: -- end Bug# 4748927
1049: --Use the same Message Name for All.
1050: hr_utility.set_message(8301,'GHR_38904_AWARD_AMT_TOO_BIG5');

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

1104: hr_utility.set_message(8301, 'GHR_38898_AWARD_AMT_TOO_BIG3');
1105: hr_utility.raise_error;
1106: END IF;
1107: --3818297 Added NVL
1108: ELSIF ( ghr_pay_calc.LEO_position( p_prd => l_temp
1109: ,p_position_id => NVL(p_pa_request_rec.to_position_id,p_pa_request_rec.from_position_id)
1110: ,p_retained_user_table_id => l_temp
1111: ,p_duty_station_id => l_temp
1112: ,p_effective_date => p_pa_request_rec.effective_date

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

1120: hr_utility.set_message(8301, 'GHR_38896_AWARD_AMT_TOO_BIG2');
1121: hr_utility.raise_error;
1122: END IF;
1123: --3818297 Added NVL
1124: ELSIF (NOT ghr_pay_calc.LEO_position( p_prd => l_temp
1125: ,p_position_id => NVL(p_pa_request_rec.to_position_id,p_pa_request_rec.from_position_id)
1126: ,p_retained_user_table_id => l_temp
1127: ,p_duty_station_id => l_temp
1128: ,p_effective_date => p_pa_request_rec.effective_date

Line 2064: IF ghr_pay_calc.get_open_pay_range

2060: ,'RECRUIT_FILL'
2061: ,'SEPARATION'
2062: ,'GHR_STUDENT_LOAN') THEN
2063: IF p_pa_request_rec.to_position_id is not null THEN
2064: IF ghr_pay_calc.get_open_pay_range
2065: (p_pa_request_rec.to_position_id
2066: ,p_pa_request_rec.person_id
2067: ,p_pa_request_rec.pay_rate_determinant
2068: ,p_pa_request_rec.pa_request_id

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

2091:
2092: ELSE
2093:
2094:
2095: l_user_table_id := ghr_pay_calc.get_user_table_id (p_pa_request_rec.to_position_id
2096: ,NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)) );
2097: --Start of the Bug 3604377
2098: -- Retive the Grade info from the POI history table
2099: ghr_history_fetch.fetch_positionei(

Line 2128: ghr_pay_calc.get_open_pay_table_values

2124:
2125: hr_utility.set_location('GHRVALID-l_user_table_id ' || to_char(l_user_table_id) ,5);
2126: hr_utility.set_location('GHRVALID-Open Pay Range get values' ,5);
2127:
2128: ghr_pay_calc.get_open_pay_table_values
2129: (p_user_table_id => l_user_table_id
2130: ,p_pay_plan => l_pay_plan
2131: ,p_grade_or_level => l_grade_or_level
2132: ,p_effective_date => NVL(p_pa_request_rec.effective_date,TRUNC(sysdate))