eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_VALIDATE_CHECK dependencies on HR_API

Line 5: ,p_per_group1 IN ghr_api.per_group1_type

1: package body GHR_Validate_CHECK AS
2: /* $Header: ghrvalid.pkb 120.31.12010000.3 2008/12/12 09:40:29 utokachi ship $ */
3:
4: procedure Validate_CHECK(p_pa_request_rec IN ghr_pa_requests%ROWTYPE
5: ,p_per_group1 IN ghr_api.per_group1_type
6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type
7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type

Line 6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type

2: /* $Header: ghrvalid.pkb 120.31.12010000.3 2008/12/12 09:40:29 utokachi ship $ */
3:
4: procedure Validate_CHECK(p_pa_request_rec IN ghr_pa_requests%ROWTYPE
5: ,p_per_group1 IN ghr_api.per_group1_type
6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type
7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type

Line 7: ,p_per_sep_retire in ghr_api.per_sep_retire_type

3:
4: procedure Validate_CHECK(p_pa_request_rec IN ghr_pa_requests%ROWTYPE
5: ,p_per_group1 IN ghr_api.per_group1_type
6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type
7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type

Line 8: ,p_per_conversions in ghr_api.per_conversions_type

4: procedure Validate_CHECK(p_pa_request_rec IN ghr_pa_requests%ROWTYPE
5: ,p_per_group1 IN ghr_api.per_group1_type
6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type
7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type

Line 9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type

5: ,p_per_group1 IN ghr_api.per_group1_type
6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type
7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type

Line 10: ,p_pos_grp1 in ghr_api.pos_grp1_type

6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type
7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type

Line 11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type

7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type
15: ,p_agency_code in varchar2

Line 12: ,p_loc_info in ghr_api.loc_info_type

8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type
15: ,p_agency_code in varchar2
16: ,p_gov_awards_type in ghr_api.government_awards_type

Line 13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type

9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type
15: ,p_agency_code in varchar2
16: ,p_gov_awards_type in ghr_api.government_awards_type
17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type

Line 14: ,p_personal_info in ghr_api.personal_info_type

10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type
15: ,p_agency_code in varchar2
16: ,p_gov_awards_type in ghr_api.government_awards_type
17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
18: ,p_health_plan in varchar2

Line 16: ,p_gov_awards_type in ghr_api.government_awards_type

12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type
15: ,p_agency_code in varchar2
16: ,p_gov_awards_type in ghr_api.government_awards_type
17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
18: ,p_health_plan in varchar2
19: ,p_asg_non_sf52 in ghr_api.asg_non_sf52_type
20: --Pradeep

Line 17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type

13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type
15: ,p_agency_code in varchar2
16: ,p_gov_awards_type in ghr_api.government_awards_type
17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
18: ,p_health_plan in varchar2
19: ,p_asg_non_sf52 in ghr_api.asg_non_sf52_type
20: --Pradeep
21: ,p_premium_pay in ghr_api.premium_pay_type

Line 19: ,p_asg_non_sf52 in ghr_api.asg_non_sf52_type

15: ,p_agency_code in varchar2
16: ,p_gov_awards_type in ghr_api.government_awards_type
17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
18: ,p_health_plan in varchar2
19: ,p_asg_non_sf52 in ghr_api.asg_non_sf52_type
20: --Pradeep
21: ,p_premium_pay in ghr_api.premium_pay_type
22: --Bug#5036370
23: ,p_per_service_oblig in ghr_api.per_service_oblig_type

Line 21: ,p_premium_pay in ghr_api.premium_pay_type

17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
18: ,p_health_plan in varchar2
19: ,p_asg_non_sf52 in ghr_api.asg_non_sf52_type
20: --Pradeep
21: ,p_premium_pay in ghr_api.premium_pay_type
22: --Bug#5036370
23: ,p_per_service_oblig in ghr_api.per_service_oblig_type
24: ,p_within_grade_incr in ghr_api.within_grade_increase_type --Bug 5527363
25: ) IS

Line 23: ,p_per_service_oblig in ghr_api.per_service_oblig_type

19: ,p_asg_non_sf52 in ghr_api.asg_non_sf52_type
20: --Pradeep
21: ,p_premium_pay in ghr_api.premium_pay_type
22: --Bug#5036370
23: ,p_per_service_oblig in ghr_api.per_service_oblig_type
24: ,p_within_grade_incr in ghr_api.within_grade_increase_type --Bug 5527363
25: ) IS
26: l_assignment_found boolean := FALSE;
27: l_per_system_status VARCHAR2(30);

Line 24: ,p_within_grade_incr in ghr_api.within_grade_increase_type --Bug 5527363

20: --Pradeep
21: ,p_premium_pay in ghr_api.premium_pay_type
22: --Bug#5036370
23: ,p_per_service_oblig in ghr_api.per_service_oblig_type
24: ,p_within_grade_incr in ghr_api.within_grade_increase_type --Bug 5527363
25: ) IS
26: l_assignment_found boolean := FALSE;
27: l_per_system_status VARCHAR2(30);
28:

Line 204: l_temp_step per_people_extra_info.pei_information9%type := hr_api.g_varchar2;

200: SELECT rei_information3 temp_step
201: FROM ghr_pa_request_extra_info
202: WHERE pa_request_id = p_pa_request_rec.pa_request_id
203: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
204: l_temp_step per_people_extra_info.pei_information9%type := hr_api.g_varchar2;
205:
206: -- Family Code
207: -- Bug # 1145963
208: -- Bug#3941541 Added effective date condition.

Line 932: ghr_api.retrieve_element_entry_value

928:
929:
930: If p_pa_request_rec.first_noa_code = '818' then -- if AUo
931: -- check if the person already gets an AP
932: ghr_api.retrieve_element_entry_value
933: (P_ELEMENT_NAME => 'Availability Pay',
934: P_INPUT_VALUE_NAME => 'Premium Pay Ind',
935: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
936: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 941: ghr_api.retrieve_element_entry_value

937: P_VALUE => l_Prem_pay,
938: P_MULTIPLE_ERROR_FLAG => l_multiple_error_flag
939: );
940:
941: ghr_api.retrieve_element_entry_value
942: (P_ELEMENT_NAME => 'Availability Pay',
943: P_INPUT_VALUE_NAME => 'Amount',
944: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
945: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 958: ghr_api.retrieve_element_entry_value

954: End if;
955:
956: Elsif p_pa_request_rec.first_noa_code = '819' then -- if AP
957: -- check if the person already gets an AUO
958: ghr_api.retrieve_element_entry_value
959: (P_ELEMENT_NAME => 'AUO',
960: P_INPUT_VALUE_NAME => 'Premium Pay Ind',
961: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
962: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 967: ghr_api.retrieve_element_entry_value

963: P_VALUE => l_Prem_pay,
964: P_MULTIPLE_ERROR_FLAG => l_multiple_error_flag
965: );
966:
967: ghr_api.retrieve_element_entry_value
968: (P_ELEMENT_NAME => 'AUO',
969: P_INPUT_VALUE_NAME => 'Amount',
970: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
971: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 1332: ghr_api.retrieve_element_entry_value (p_element_name => 'Student Loan Repayment'

1328: END IF;
1329: END IF;
1330:
1331: IF l_repay_sch = 'L' THEN
1332: ghr_api.retrieve_element_entry_value (p_element_name => 'Student Loan Repayment'
1333: ,p_input_value_name => 'Amount'
1334: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
1335: ,p_effective_date => p_pa_request_rec.effective_date
1336: ,p_value => l_slr_recur_amount

Line 1343: ghr_api.retrieve_element_entry_value (p_element_name => 'Student Loan Repayment LumpSum'

1339: hr_utility.set_message(8301,'GHR_38864_ERR_CHG_REPAYMNT');
1340: hr_utility.raise_error;
1341: end if;
1342: else
1343: ghr_api.retrieve_element_entry_value (p_element_name => 'Student Loan Repayment LumpSum'
1344: ,p_input_value_name => 'Amount'
1345: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
1346: ,p_effective_date => p_pa_request_rec.effective_date
1347: ,p_value => l_slr_lumpsum

Line 1375: ghr_api.retrieve_element_entry_value

1371: --- check for other pay null for first time 810,818,819 actions
1372:
1373: IF p_pa_request_rec.first_noa_code = '810'
1374: and l_session.noa_id_correct is NULL THEN
1375: ghr_api.retrieve_element_entry_value
1376: (p_element_name => 'Retention Allowance',
1377: p_input_value_name => 'Amount',
1378: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1379: p_effective_date => p_pa_request_rec.effective_date,

Line 1383: ghr_api.retrieve_element_entry_value

1379: p_effective_date => p_pa_request_rec.effective_date,
1380: p_value => l_reta_amount,
1381: p_multiple_error_flag => l_multiple_error_flag
1382: );
1383: ghr_api.retrieve_element_entry_value
1384: (p_element_name => 'Supervisory Differential',
1385: p_input_value_name => 'Amount',
1386: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1387: p_effective_date => p_pa_request_rec.effective_date,

Line 1391: ghr_api.retrieve_element_entry_value

1387: p_effective_date => p_pa_request_rec.effective_date,
1388: p_value => l_supv_amount,
1389: p_multiple_error_flag => l_multiple_error_flag
1390: );
1391: ghr_api.retrieve_element_entry_value
1392: (p_element_name => 'Staffing Differential',
1393: p_input_value_name => 'Amount',
1394: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1395: p_effective_date => p_pa_request_rec.effective_date,

Line 1429: ghr_api.retrieve_element_entry_value

1425: END LOOP;
1426:
1427: IF l_premium_pay_ind IS NULL THEN
1428:
1429: ghr_api.retrieve_element_entry_value
1430: (p_element_name => 'Premium Pay',
1431: p_input_value_name => 'Premium Pay Ind',
1432: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1433: p_effective_date => p_pa_request_rec.effective_date,

Line 1502: ghr_api.retrieve_element_entry_value

1498: hr_utility.raise_error;
1499:
1500: End If;
1501:
1502: ghr_api.retrieve_element_entry_value
1503: (P_ELEMENT_NAME => 'Availability Pay',
1504: P_INPUT_VALUE_NAME => 'Amount',
1505: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
1506: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 1512: ghr_api.retrieve_element_entry_value

1508: P_MULTIPLE_ERROR_FLAG => l_multiple_error_flag
1509: );
1510: hr_utility.set_location('AP Amount '||l_ap_amount,7);
1511:
1512: ghr_api.retrieve_element_entry_value
1513: (P_ELEMENT_NAME => 'AUO',
1514: P_INPUT_VALUE_NAME => 'Amount',
1515: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
1516: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 1613: ghr_api.retrieve_element_entry_value

1609: l_null_list := null;
1610:
1611: If l_mddds_special_pay_amount is NULL or l_mddds_special_pay_amount = 0 THEN
1612:
1613: ghr_api.retrieve_element_entry_value
1614: (p_element_name => 'MDDDS Special Pay',
1615: p_input_value_name => 'Amount',
1616: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1617: p_effective_date => p_pa_request_rec.effective_date,

Line 1630: ghr_api.retrieve_element_entry_value

1626: END IF;
1627:
1628: If l_mddds_specia_pay_nte_date is NULL THEN
1629:
1630: ghr_api.retrieve_element_entry_value
1631: (p_element_name => 'MDDDS Special Pay',
1632: p_input_value_name => 'MDDDS Special Pay NTE Date',
1633: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1634: p_effective_date => p_pa_request_rec.effective_date,

Line 1675: ghr_api.retrieve_element_entry_value

1671: END LOOP;
1672:
1673: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,3);
1674: IF l_premium_pay_ind IS NULL THEN
1675: ghr_api.retrieve_element_entry_value
1676: (p_element_name => 'Premium Pay',
1677: p_input_value_name => 'Premium Pay Ind',
1678: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1679: p_effective_date => p_pa_request_rec.effective_date,

Line 1717: ghr_api.retrieve_element_entry_value

1713: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,3);
1714:
1715: IF l_premium_pay_ind IS NULL THEN
1716: --Bug#3579579
1717: ghr_api.retrieve_element_entry_value
1718: (p_element_name => 'Premium Pay',
1719: p_input_value_name => 'Premium Pay Ind',
1720: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1721: p_effective_date => p_pa_request_rec.effective_date,

Line 1776: ghr_api.retrieve_element_entry_value

1772: -- END IF;
1773:
1774: IF p_pa_request_rec.first_noa_code = '819'
1775: and l_session.noa_id_correct is NULL THEN
1776: ghr_api.retrieve_element_entry_value
1777: (P_ELEMENT_NAME => 'Availability Pay',
1778: P_INPUT_VALUE_NAME => 'Amount',
1779: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
1780: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 1794: ghr_api.retrieve_element_entry_value

1790: END IF;
1791:
1792: --Pradeep
1793: --Title 38 Employess should not get Avaialability Pay.
1794: ghr_api.retrieve_element_entry_value
1795: (p_element_name => 'Premium Pay',
1796: p_input_value_name => 'Premium Pay Ind',
1797: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1798: p_effective_date => p_pa_request_rec.effective_date,

Line 1832: ghr_api.retrieve_element_entry_value

1828: END IF;
1829:
1830: IF p_pa_request_rec.first_noa_code = '818'
1831: and l_session.noa_id_correct is NULL THEN
1832: ghr_api.retrieve_element_entry_value
1833: (P_ELEMENT_NAME => 'AUO',
1834: P_INPUT_VALUE_NAME => 'Amount',
1835: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
1836: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 1850: ghr_api.retrieve_element_entry_value

1846: END IF;
1847:
1848: --Pradeep
1849: --Title 38 Employess should not get AUO.
1850: ghr_api.retrieve_element_entry_value
1851: (p_element_name => 'Premium Pay',
1852: p_input_value_name => 'Premium Pay Ind',
1853: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1854: p_effective_date => p_pa_request_rec.effective_date,

Line 1946: ghr_api.retrieve_element_entry_value

1942: -- check whether more than one other pay is changed for NOA 810
1943: --
1944: if p_pa_request_rec.first_noa_code = '810' then
1945: l_for_810_count := 0;
1946: ghr_api.retrieve_element_entry_value
1947: (p_element_name => 'Retention Allowance',
1948: p_input_value_name => 'Amount',
1949: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1950: p_effective_date => p_pa_request_rec.effective_date,

Line 1957: ghr_api.retrieve_element_entry_value

1953: );
1954: if NVL(p_pa_request_rec.to_retention_allowance,0) <> NVL(l_amount,0) then
1955: l_for_810_count := l_for_810_count + 1;
1956: end if;
1957: ghr_api.retrieve_element_entry_value
1958: (p_element_name => 'Supervisory Differential',
1959: p_input_value_name => 'Amount',
1960: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1961: p_effective_date => p_pa_request_rec.effective_date,

Line 1968: ghr_api.retrieve_element_entry_value

1964: );
1965: if NVL(p_pa_request_rec.to_supervisory_differential,0) <> NVL(l_amount,0) then
1966: l_for_810_count := l_for_810_count + 1;
1967: end if;
1968: ghr_api.retrieve_element_entry_value
1969: (p_element_name => 'Staffing Differential',
1970: p_input_value_name => 'Amount',
1971: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1972: p_effective_date => p_pa_request_rec.effective_date,