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_US_NFC_EXTRACTS dependencies on GHR_HISTORY_FETCH

Line 980: ghr_history_fetch.fetch_positionei

976: );
977: --g_rpa_add_attr(p_assignment_id).ssn:=l_ssn.national_identifier;
978:
979: hr_utility.set_location (l_proc_name,15);
980: ghr_history_fetch.fetch_positionei
981: ( p_position_id => l_position_id
982: ,p_information_type =>'GHR_US_POS_GRP3'
983: ,p_date_effective => p_effective_date
984: ,p_pos_ei_data => l_posi_extra_info);

Line 989: ghr_history_fetch.fetch_positionei

985:
986: g_rpa_add_attr(p_assignment_id).nfc_agency_code := l_posi_extra_info.poei_information21;
987:
988: hr_utility.set_location (l_proc_name,20);
989: ghr_history_fetch.fetch_positionei
990: ( p_position_id => l_position_id
991: ,p_information_type =>'GHR_US_POS_GRP1'
992: ,p_date_effective => p_effective_date
993: ,p_pos_ei_data => l_posi_extra_info);

Line 1219: ghr_history_fetch.fetch_positionei

1215: IF g_awd_rec(p_request_id).to_position_id IS NULL then
1216: g_awd_rec(p_request_id).to_position_id := g_awd_rec(p_request_id).from_position_id;
1217: END IF;
1218:
1219: ghr_history_fetch.fetch_positionei
1220: ( p_position_id => g_awd_rec(p_request_id).to_position_id
1221: ,p_information_type =>'GHR_US_POS_GRP3'
1222: ,p_date_effective => p_effective_date
1223: ,p_pos_ei_data => l_posi_extra_info);

Line 1522: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id

1518: g_rpa_attr(p_request_id).assignment_id := p_assignment_id;
1519: g_rpa_attr(p_request_id).request_id := p_request_id;
1520:
1521:
1522: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id
1523: ,p_information_type =>'GHR_US_PER_GROUP1'
1524: ,p_date_effective =>p_effective_date
1525: ,p_per_ei_data =>l_per_ei_data
1526: );

Line 1562: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id

1558:
1559: hr_utility.set_location (l_proc_name,15);
1560: --modify
1561: l_per_ei_data:=NULL;
1562: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id
1563: ,p_information_type =>'GHR_US_PER_SEPARATE_RETIRE'
1564: ,p_date_effective =>p_effective_date
1565: ,p_per_ei_data =>l_per_ei_data
1566: );

Line 1581: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id

1577:
1578: hr_utility.set_location (l_proc_name,30);
1579: l_per_ei_data:=NULL;
1580:
1581: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id
1582: ,p_information_type =>'GHR_US_PER_LEAVE_INFO'
1583: ,p_date_effective =>p_effective_date
1584: ,p_per_ei_data =>l_per_ei_data
1585: );

Line 1600: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id

1596:
1597: hr_utility.set_location (l_proc_name,40);
1598:
1599: l_per_ei_data:=NULL;
1600: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id
1601: ,p_information_type =>'GHR_US_PER_SCD_INFORMATION'
1602: ,p_date_effective =>p_effective_date
1603: ,p_per_ei_data =>l_per_ei_data
1604: );

Line 1614: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id

1610:
1611: hr_utility.set_location (l_proc_name,45);
1612:
1613: l_per_ei_data:=NULL;
1614: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id
1615: ,p_information_type =>'GHR_US_PER_PROBATIONS'
1616: ,p_date_effective =>p_effective_date
1617: ,p_per_ei_data =>l_per_ei_data
1618: );

Line 1627: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id

1623:
1624: hr_utility.set_location (l_proc_name,50);
1625:
1626: l_per_ei_data:=NULL;
1627: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id
1628: ,p_information_type =>'GHR_US_PER_CONVERSIONS'
1629: ,p_date_effective =>p_effective_date
1630: ,p_per_ei_data =>l_per_ei_data
1631: );

Line 1635: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id

1631: );
1632: g_rpa_attr(p_request_id).Date_Career_perma_Ten_St :=l_per_ei_data.pei_information3;
1633:
1634: l_per_ei_data:=NULL;
1635: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id
1636: ,p_information_type =>'GHR_US_RETAINED_GRADE'
1637: ,p_date_effective =>p_effective_date
1638: ,p_per_ei_data =>l_per_ei_data
1639: );

Line 1653: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id

1649: null;
1650: END IF;
1651:
1652: l_per_ei_data:=NULL;
1653: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id
1654: ,p_information_type =>'GHR_US_PER_SF52'
1655: ,p_date_effective =>p_effective_date
1656: ,p_per_ei_data =>l_per_ei_data
1657: );

Line 1662: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id

1658: g_rpa_attr(p_request_id).Citizenship_code :=l_per_ei_data.pei_information3;
1659:
1660:
1661: l_per_ei_data:=NULL;
1662: ghr_history_fetch.fetch_peopleei(p_person_id =>p_person_id
1663: ,p_information_type =>'GHR_US_PER_UNIFORMED_SERVICES'
1664: ,p_date_effective =>p_effective_date
1665: ,p_per_ei_data =>l_per_ei_data
1666: );

Line 1761: ghr_history_fetch.fetch_element_entry_value

1757: CLOSE c_get_asg_extra_info;
1758: g_rpa_attr(p_request_id).special_emp_code := NVL(l_get_asg_extra_info.aei_information12,'00');
1759: g_rpa_attr(p_request_id).action_code := 1;
1760:
1761: ghr_history_fetch.fetch_element_entry_value
1762: (p_element_name =>'Health Benefits',
1763: p_input_value_name =>'Enrollment',
1764: p_assignment_id =>p_assignment_id,
1765: p_date_effective =>p_effective_date,

Line 1769: ghr_history_fetch.fetch_element_entry_value

1765: p_date_effective =>p_effective_date,
1766: p_screen_entry_value =>l_out_val
1767: ) ;
1768: IF l_out_val IS NULL THEN
1769: ghr_history_fetch.fetch_element_entry_value
1770: (p_element_name =>'Health Benefits Pre tax',
1771: p_input_value_name =>'Enrollment',
1772: p_assignment_id =>p_assignment_id,
1773: p_date_effective =>p_effective_date,

Line 1842: /*ghr_history_fetch.fetch_positionei

1838: );
1839:
1840: g_rpa_attr(p_request_id).pos_num := l_pos_num;
1841:
1842: /*ghr_history_fetch.fetch_positionei
1843: ( p_position_id => l_position_id
1844: ,p_information_type =>'GHR_US_POS_GRP3'
1845: ,p_date_effective => p_effective_date
1846: ,p_pos_ei_data => l_posi_extra_info);*/

Line 1863: /*ghr_history_fetch.fetch_positionei

1859:
1860: g_rpa_attr(p_request_id).nfc_agency := l_get_default_values.nfc_agency_code;
1861:
1862: l_posi_extra_info:=NULL;
1863: /*ghr_history_fetch.fetch_positionei
1864: ( p_position_id => l_position_id
1865: ,p_information_type =>'GHR_US_POS_GRP1'
1866: ,p_date_effective => p_effective_date
1867: ,p_pos_ei_data => l_posi_extra_info);*/

Line 1871: /*ghr_history_fetch.fetch_positionei

1867: ,p_pos_ei_data => l_posi_extra_info);*/
1868: g_rpa_attr(p_request_id).poi := l_get_default_values.personnel_office_id;
1869: l_posi_extra_info:=NULL;
1870: l_get_default_values:=NULL;
1871: /*ghr_history_fetch.fetch_positionei
1872: ( p_position_id => g_rpa_rec(p_request_id).to_position_id
1873: ,p_information_type =>'GHR_US_POS_GRP3'
1874: ,p_date_effective => p_effective_date
1875: ,p_pos_ei_data => l_posi_extra_info);*/

Line 1884: /*ghr_history_fetch.fetch_positionei

1880: FETCH c_get_default_values INTO l_get_default_values;
1881: CLOSE c_get_default_values;
1882: g_rpa_attr(p_request_id).pmso_agency := l_get_default_values.nfc_agency_code;
1883:
1884: /*ghr_history_fetch.fetch_positionei
1885: ( p_position_id =>g_rpa_rec(p_request_id).to_position_id
1886: ,p_information_type =>'GHR_US_POS_GRP1'
1887: ,p_date_effective => p_effective_date
1888: ,p_pos_ei_data => l_posi_extra_info);*/

Line 1916: ghr_history_fetch.fetch_element_entry_value

1912: );
1913:
1914:
1915:
1916: ghr_history_fetch.fetch_element_entry_value
1917: (p_element_name =>'Retirement Annuity',
1918: p_input_value_name =>'Sum',
1919: p_assignment_id =>p_assignment_id,
1920: p_date_effective =>p_effective_date,

Line 1926: ghr_history_fetch.fetch_element_entry_value

1922: ) ;
1923:
1924: g_rpa_attr(p_request_id).civil_service_annuitant_share := TO_NUMBER(l_out_val);
1925: l_out_val :=NULL;
1926: ghr_history_fetch.fetch_element_entry_value
1927: (p_element_name =>'Within Grade Increase',
1928: p_input_value_name =>'Last Equivalent Increase',
1929: p_assignment_id =>p_assignment_id,
1930: p_date_effective =>p_effective_date,