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

Line 308: ghr_history_fetch.fetch_positionei

304: FOR c_posn_to_frm IN c_position LOOP
305: l_from_position_id :=c_posn_to_frm.from_position_id;
306: l_to_position_id := c_posn_to_frm.to_position_id;
307: END LOOP;
308: ghr_history_fetch.fetch_positionei
309: (p_position_id => l_from_position_id,
310: p_information_type => 'GHR_US_POS_GRP1',
311: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
312: p_pos_ei_data => l_pos_ei_data

Line 316: ghr_history_fetch.fetch_positionei

312: p_pos_ei_data => l_pos_ei_data
313: );
314: l_from_poid := l_pos_ei_data.poei_information3;
315:
316: ghr_history_fetch.fetch_positionei
317: (p_position_id => l_to_position_id,
318: p_information_type => 'GHR_US_POS_GRP1',
319: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
320: p_pos_ei_data => l_pos_ei_data

Line 331: ghr_history_fetch.fetch_asgei

327: l_session1 := l_session;
328: l_session.noa_id_correct := NULL;
329: ghr_history_api.reinit_g_session_var;
330: ghr_history_api.set_g_session_var(l_session);
331: ghr_history_fetch.fetch_asgei
332: (p_assignment_id => l_assignment_id,
333: p_information_type => 'GHR_US_ASG_NON_SF52',
334: p_date_effective => p_effective_date-1,
335: p_asg_ei_data => l_asg_ei_data );

Line 339: ghr_history_fetch.fetch_asgei

335: p_asg_ei_data => l_asg_ei_data );
336: ghr_history_api.reinit_g_session_var;
337: ghr_history_api.set_g_session_var(l_session1);
338: ELSE
339: ghr_history_fetch.fetch_asgei
340: (p_assignment_id => l_assignment_id,
341: p_information_type => 'GHR_US_ASG_NON_SF52',
342: p_date_effective => p_effective_date,
343: p_asg_ei_data => l_asg_ei_data);

Line 893: ghr_history_fetch.fetch_peopleei

889: -- if the person_id is not the same as the old person_id then do the foll.
890: -- If l_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
891: -- a) Get PER_GROUP1 Information
892: l_refresh_flag := l_per_refresh_flag;
893: ghr_history_fetch.fetch_peopleei
894: (p_person_id => l_person_id,
895: p_information_type => 'GHR_US_PER_GROUP1',
896: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
897: p_per_ei_data => l_per_ei_data

Line 922: ghr_history_fetch.fetch_peopleei

918:
919: l_per_ei_data := null;
920:
921: -- b) Get PER_UNIFORMED_SERVICES Information
922: ghr_history_fetch.fetch_peopleei
923: (p_person_id => l_person_id,
924: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
925: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
926: p_per_ei_data => l_per_ei_data

Line 933: ghr_history_fetch.fetch_peopleei

929: l_org_rec.rei_information4 := l_per_ei_data.pei_information5;
930: l_per_ei_data := null;
931:
932: -- c) Get PER_SEPARATE_RETIRE Information
933: ghr_history_fetch.fetch_peopleei
934: (p_person_id => l_person_id,
935: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
936: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
937: p_per_ei_data => l_per_ei_data

Line 961: ghr_history_fetch.fetch_peopleei

957:
958: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
959: -- Get PER_LEAVE Information
960: hr_utility.set_location('per_leave_info' ,1);
961: ghr_history_fetch.fetch_peopleei
962: (p_person_id => l_person_id,
963: p_information_type => 'GHR_US_PER_LEAVE_INFO',
964: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
965: p_per_ei_data => l_per_ei_data

Line 983: ghr_history_fetch.fetch_asgei

979: If l_assignment_id is not null then
980:
981: -- Get ASG_NON_SF52 data
982: l_refresh_flag := l_asg_refresh_flag;
983: ghr_history_fetch.fetch_asgei
984: (p_assignment_id => l_assignment_id,
985: p_information_type => 'GHR_US_ASG_NON_SF52',
986: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
987: p_asg_ei_data => l_asg_ei_data

Line 1015: ghr_history_fetch.fetch_positionei

1011: End if;
1012:
1013: If l_position_id is not null then
1014: l_refresh_flag := l_pos_refresh_flag;
1015: ghr_history_fetch.fetch_positionei
1016: (p_position_id => l_position_id,
1017: p_information_type => 'GHR_US_POS_GRP1',
1018: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
1019: p_pos_ei_data => l_pos_ei_data

Line 1317: ghr_history_fetch.fetch_peopleei

1313: hr_utility.set_location('Prev. FEGLI ' || l_prev_fegli,111);
1314: hr_utility.set_location('l_person_id ' || l_person_id,111);
1315: hr_utility.set_location('p_effective_date ' || p_effective_date,111);
1316:
1317: ghr_history_fetch.fetch_peopleei
1318: (p_person_id => l_person_id,
1319: p_information_type => 'GHR_US_PER_BENEFIT_INFO',
1320: p_date_effective => nvl(l_effective_date,trunc(sysdate)),
1321: p_per_ei_data => l_per_ei_data

Line 1615: ghr_history_fetch.fetch_peopleei

1611: hr_utility.set_location('appt_transfer - person id ' || l_person_id,1);
1612: --Bug 3128526. Changed p_person_id -> l_person_id
1613: If l_person_id is not null then
1614: l_refresh_flag := l_per_refresh_flag;
1615: ghr_history_fetch.fetch_peopleei
1616: (p_person_id => l_person_id,
1617: p_information_type => 'GHR_US_PER_GROUP1',
1618: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1619: p_per_ei_data => l_per_ei_data

Line 1656: ghr_history_fetch.fetch_peopleei

1652: l_org_rec.rei_information19 := l_per_ei_data.pei_information4;
1653:
1654: l_per_ei_data := null;
1655:
1656: ghr_history_fetch.fetch_peopleei
1657: (p_person_id => l_person_id,
1658: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
1659: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1660: p_per_ei_data => l_per_ei_data

Line 1667: ghr_history_fetch.fetch_peopleei

1663: l_org_rec.rei_information6 := l_per_ei_data.pei_information5;
1664:
1665: l_per_ei_data := null;
1666:
1667: ghr_history_fetch.fetch_peopleei
1668: (p_person_id => l_person_id,
1669: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
1670: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1671: p_per_ei_data => l_per_ei_data

Line 1695: ghr_history_fetch.fetch_peopleei

1691:
1692: l_per_ei_data := null;
1693:
1694: --bug 4443968
1695: ghr_history_fetch.fetch_peopleei
1696: (p_person_id => l_person_id,
1697: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
1698: p_date_effective => nvl (p_effective_date, trunc(sysdate)),
1699: p_per_ei_data => l_per_ei_data

Line 1711: ghr_history_fetch.fetch_peopleei

1707:
1708: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
1709: -- Get PER_LEAVE Information
1710: hr_utility.set_location('per_leave_info' ,1);
1711: ghr_history_fetch.fetch_peopleei
1712: (p_person_id => l_person_id,
1713: p_information_type => 'GHR_US_PER_LEAVE_INFO',
1714: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1715: p_per_ei_data => l_per_ei_data

Line 1729: ghr_history_fetch.fetch_asgei

1725: END IF; -- IF ghr_utility.is_ghr_nfc = 'TRUE'
1726: End if;
1727: If l_assignment_id is not null then
1728: l_refresh_flag := l_asg_refresh_flag;
1729: ghr_history_fetch.fetch_asgei
1730: (p_assignment_id => l_assignment_id,
1731: p_information_type => 'GHR_US_ASG_NON_SF52',
1732: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1733: p_asg_ei_data => l_asg_ei_data

Line 1774: ghr_history_fetch.fetch_positionei

1770: End if;
1771: --Check whether the follwing assignment would work correct in all cases
1772: If l_position_id is not null then
1773: l_refresh_flag := l_pos_refresh_flag;
1774: ghr_history_fetch.fetch_positionei
1775: (p_position_id => l_position_id,
1776: p_information_type => 'GHR_US_POS_GRP1',
1777: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1778: p_pos_ei_data => l_pos_ei_data

Line 1808: ghr_history_fetch.fetch_peopleei

1804: Begin
1805: -- Read from history if person id is not null
1806: If l_person_id is not null then
1807: l_refresh_flag := l_per_refresh_flag;
1808: ghr_history_fetch.fetch_peopleei
1809: (p_person_id => l_person_id,
1810: p_information_type => 'GHR_US_PER_GROUP1',
1811: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1812: p_per_ei_data => l_per_ei_data

Line 1824: ghr_history_fetch.fetch_peopleei

1820: set_ei(l_org_rec.rei_information13,l_per_ei_data.pei_information4,l_rei_rec.rei_information13,l_refresh_flag);
1821: l_org_rec.rei_information13 := l_per_ei_data.pei_information4;
1822: l_per_ei_data := null;
1823:
1824: ghr_history_fetch.fetch_peopleei
1825: (p_person_id => l_person_id,
1826: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
1827: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1828: p_per_ei_data => l_per_ei_data

Line 1833: ghr_history_fetch.fetch_peopleei

1829: );
1830: set_ei(l_org_rec.rei_information4,l_per_ei_data.pei_information5,l_rei_rec.rei_information4,l_refresh_flag);
1831: l_org_rec.rei_information4 := l_per_ei_data.pei_information5;
1832: l_per_ei_data := null;
1833: ghr_history_fetch.fetch_peopleei
1834: (p_person_id => l_person_id,
1835: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
1836: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1837: p_per_ei_data => l_per_ei_data

Line 1846: ghr_history_fetch.fetch_peopleei

1842: l_org_rec.rei_information10 := l_per_ei_data.pei_information4;
1843: set_ei(l_org_rec.rei_information21,l_per_ei_data.pei_information3,l_rei_rec.rei_information21,l_refresh_flag);
1844: l_org_rec.rei_information21 := l_per_ei_data.pei_information3;
1845: l_per_ei_data := null;
1846: ghr_history_fetch.fetch_peopleei
1847: (p_person_id => l_person_id,
1848: p_information_type => 'GHR_US_PER_CONVERSIONS',
1849: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1850: p_per_ei_data => l_per_ei_data

Line 1869: ghr_history_fetch.fetch_peopleei

1865: l_per_ei_data := null;
1866: -- Get PER_LEAVE Information
1867: hr_utility.set_location('per_leave_info' ,1);
1868: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
1869: ghr_history_fetch.fetch_peopleei
1870: (p_person_id => l_person_id,
1871: p_information_type => 'GHR_US_PER_LEAVE_INFO',
1872: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1873: p_per_ei_data => l_per_ei_data

Line 1885: ghr_history_fetch.fetch_asgei

1881: END IF; -- IF ghr_utility.is_ghr_nfc = 'TR
1882: End if;
1883: If NVL(l_assignment_id,p_assignment_id) is not null then
1884: l_refresh_flag := l_asg_refresh_flag;
1885: ghr_history_fetch.fetch_asgei
1886: (p_assignment_id => l_assignment_id,
1887: p_information_type => 'GHR_US_ASG_NON_SF52',
1888: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1889: p_asg_ei_data => l_asg_ei_data

Line 1916: ghr_history_fetch.fetch_positionei

1912: --Check whether the follwing assignment would work correct in all cases
1913: If l_position_id is not null then
1914: l_refresh_flag := l_pos_refresh_flag;
1915: -- Make sure that the foll. check is correct
1916: ghr_history_fetch.fetch_positionei
1917: (p_position_id => l_position_id,
1918: p_information_type => 'GHR_US_POS_GRP1',
1919: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1920: p_pos_ei_data => l_pos_ei_data

Line 1930: ghr_history_fetch.fetch_positionei

1926: FOR c_posn_to_frm IN c_position LOOP
1927: l_from_position_id :=c_posn_to_frm.from_position_id;
1928: l_to_position_id := c_posn_to_frm.to_position_id;
1929: END LOOP;
1930: ghr_history_fetch.fetch_positionei
1931: (p_position_id => l_from_position_id,
1932: p_information_type => 'GHR_US_POS_GRP1',
1933: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
1934: p_pos_ei_data => l_pos_ei_data

Line 1939: ghr_history_fetch.fetch_positionei

1935: );
1936: l_from_poid := l_pos_ei_data.poei_information3;
1937: l_pos_ei_data := NULL;
1938:
1939: ghr_history_fetch.fetch_positionei
1940: (p_position_id => l_to_position_id,
1941: p_information_type => 'GHR_US_POS_GRP1',
1942: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
1943: p_pos_ei_data => l_pos_ei_data

Line 1954: ghr_history_fetch.fetch_asgei

1950: l_session1 := l_session;
1951: l_session.noa_id_correct := NULL;
1952: ghr_history_api.reinit_g_session_var;
1953: ghr_history_api.set_g_session_var(l_session);
1954: ghr_history_fetch.fetch_asgei
1955: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
1956: p_information_type => 'GHR_US_ASG_NON_SF52',
1957: p_date_effective => p_effective_date-1,
1958: p_asg_ei_data => l_asg_ei_data );

Line 1962: ghr_history_fetch.fetch_asgei

1958: p_asg_ei_data => l_asg_ei_data );
1959: ghr_history_api.reinit_g_session_var;
1960: ghr_history_api.set_g_session_var(l_session1);
1961: ELSE
1962: ghr_history_fetch.fetch_asgei
1963: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
1964: p_information_type => 'GHR_US_ASG_NON_SF52',
1965: p_date_effective => p_effective_date,
1966: p_asg_ei_data => l_asg_ei_data);

Line 1971: ghr_history_fetch.fetch_asgei

1967: END IF;
1968: set_ei(l_org_rec.rei_information5,l_asg_ei_data.aei_information3,l_rei_rec.rei_information5,l_refresh_flag);
1969: /*Start - Bug 7295154*/
1970: ELSIF l_to_poid IS NULL AND l_noa_family_code = 'CORRECT' THEN
1971: ghr_history_fetch.fetch_asgei
1972: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
1973: p_information_type => 'GHR_US_ASG_NON_SF52',
1974: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1975: p_asg_ei_data => l_asg_ei_data

Line 2020: ghr_history_fetch.fetch_peopleei

2016: Begin
2017:
2018: If l_person_id is not null then
2019: l_refresh_flag := l_per_refresh_flag;
2020: ghr_history_fetch.fetch_peopleei
2021: (p_person_id => l_person_id,
2022: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
2023: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2024: p_per_ei_data => l_per_ei_data

Line 2029: ghr_history_fetch.fetch_peopleei

2025: );
2026: set_ei(l_org_rec.rei_information3,l_per_ei_data.pei_information5,l_rei_rec.rei_information3,l_refresh_flag);
2027: l_per_ei_data := null;
2028:
2029: ghr_history_fetch.fetch_peopleei
2030: (p_person_id => l_person_id,
2031: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2032: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2033: p_per_ei_data => l_per_ei_data

Line 2039: ghr_history_fetch.fetch_peopleei

2035: set_ei(l_org_rec.rei_information5,l_per_ei_data.pei_information5,l_rei_rec.rei_information5,l_refresh_flag);
2036:
2037: -- Bug 3966783 changes
2038: IF NVL(l_noa_family_code,'C') = 'CORRECT' THEN
2039: ghr_history_fetch.fetch_peopleei
2040: (p_person_id => l_person_id,
2041: p_information_type => 'GHR_US_PER_GROUP1',
2042: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2043: p_per_ei_data => l_per_ei_data

Line 2052: ghr_history_fetch.fetch_asgei

2048: End if;
2049:
2050: If l_assignment_id is not null then
2051: l_refresh_flag := l_asg_refresh_flag;
2052: ghr_history_fetch.fetch_asgei
2053: (p_assignment_id => l_assignment_id,
2054: p_information_type => 'GHR_US_ASG_NON_SF52',
2055: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2056: p_asg_ei_data => l_asg_ei_data

Line 2071: ghr_history_fetch.fetch_asgei

2067: Procedure reassignment is
2068: Begin
2069: If l_assignment_id is not null then
2070: l_refresh_flag := l_asg_refresh_flag;
2071: ghr_history_fetch.fetch_asgei
2072: (p_assignment_id => l_assignment_id,
2073: p_information_type => 'GHR_US_ASG_NON_SF52',
2074: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2075: p_asg_ei_data => l_asg_ei_data

Line 2084: ghr_history_fetch.fetch_positionei

2080: l_asg_ei_data := null;
2081: End if;
2082: If l_position_id is not null then
2083: l_refresh_flag := l_pos_refresh_flag;
2084: ghr_history_fetch.fetch_positionei
2085: (p_position_id => l_position_id,
2086: p_information_type => 'GHR_US_POS_GRP1',
2087: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2088: p_pos_ei_data => l_pos_ei_data

Line 2095: ghr_history_fetch.fetch_positionei

2091: l_pos_ei_data := null;
2092:
2093: /* Bug # 1794090
2094:
2095: ghr_history_fetch.fetch_positionei
2096: (p_position_id => l_position_id,
2097: p_information_type => 'GHR_US_POS_GRP2',
2098: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2099: p_pos_ei_data => l_pos_ei_data

Line 2111: ghr_history_fetch.fetch_positionei

2107: FOR c_posn_to_frm IN c_position LOOP
2108: l_from_position_id :=c_posn_to_frm.from_position_id;
2109: l_to_position_id := c_posn_to_frm.to_position_id;
2110: END LOOP;
2111: ghr_history_fetch.fetch_positionei
2112: (p_position_id => l_from_position_id,
2113: p_information_type => 'GHR_US_POS_GRP1',
2114: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
2115: p_pos_ei_data => l_pos_ei_data

Line 2120: ghr_history_fetch.fetch_positionei

2116: );
2117: l_from_poid := l_pos_ei_data.poei_information3;
2118: l_pos_ei_data := NULL;
2119:
2120: ghr_history_fetch.fetch_positionei
2121: (p_position_id => l_to_position_id,
2122: p_information_type => 'GHR_US_POS_GRP1',
2123: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2124: p_pos_ei_data => l_pos_ei_data

Line 2136: ghr_history_fetch.fetch_asgei

2132: l_session1 := l_session;
2133: l_session.noa_id_correct := NULL;
2134: ghr_history_api.reinit_g_session_var;
2135: ghr_history_api.set_g_session_var(l_session);
2136: ghr_history_fetch.fetch_asgei
2137: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2138: p_information_type => 'GHR_US_ASG_NON_SF52',
2139: p_date_effective => p_effective_date-1,
2140: p_asg_ei_data => l_asg_ei_data

Line 2145: ghr_history_fetch.fetch_asgei

2141: );
2142: ghr_history_api.reinit_g_session_var;
2143: ghr_history_api.set_g_session_var(l_session1);
2144: ELSE
2145: ghr_history_fetch.fetch_asgei
2146: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2147: p_information_type => 'GHR_US_ASG_NON_SF52',
2148: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2149: p_asg_ei_data => l_asg_ei_data

Line 2180: ghr_history_fetch.fetch_asgei

2176: IF NVL(l_noa_family_code,'C') = 'CORRECT' THEN
2177:
2178: If l_assignment_id is not null then
2179: l_refresh_flag := l_asg_refresh_flag;
2180: ghr_history_fetch.fetch_asgei
2181: (p_assignment_id => l_assignment_id,
2182: p_information_type => 'GHR_US_ASG_NON_SF52',
2183: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2184: p_asg_ei_data => l_asg_ei_data

Line 2191: ghr_history_fetch.fetch_positionei

2187: l_asg_ei_data := null;
2188: End if;
2189: If l_position_id is not null then
2190: l_refresh_flag := l_pos_refresh_flag;
2191: ghr_history_fetch.fetch_positionei
2192: (p_position_id => l_position_id,
2193: p_information_type => 'GHR_US_POS_GRP1',
2194: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2195: p_pos_ei_data => l_pos_ei_data

Line 2206: ghr_history_fetch.fetch_positionei

2202: set_ei(l_org_rec.rei_information11,l_pos_ei_data.poei_information5,l_rei_rec.rei_information11,l_refresh_flag);
2203:
2204: l_pos_ei_data := null;
2205:
2206: ghr_history_fetch.fetch_positionei
2207: (p_position_id => l_position_id,
2208: p_information_type => 'GHR_US_POS_GRP2',
2209: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2210: p_pos_ei_data => l_pos_ei_data

Line 2230: ghr_history_fetch.fetch_positionei

2226: l_bg_id per_positions.business_group_id%type;
2227: Begin
2228: If l_position_id is not null then
2229: l_refresh_flag := l_pos_refresh_flag;
2230: ghr_history_fetch.fetch_positionei
2231: (p_position_id => l_position_id,
2232: p_information_type => 'GHR_US_POS_GRP1',
2233: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2234: p_pos_ei_data => l_pos_ei_data

Line 2257: ghr_history_fetch.fetch_peopleei

2253: Procedure chg_retire_plan is
2254: Begin
2255: If l_person_id is not null then
2256: l_refresh_flag := l_per_refresh_flag;
2257: ghr_history_fetch.fetch_peopleei
2258: (p_person_id => l_person_id,
2259: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
2260: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2261: p_per_ei_data => l_per_ei_data

Line 2266: ghr_history_fetch.fetch_peopleei

2262: );
2263: set_ei(l_org_rec.rei_information3,l_per_ei_data.pei_information5,l_rei_rec.rei_information3,l_refresh_flag);
2264: l_per_ei_data := null;
2265:
2266: ghr_history_fetch.fetch_peopleei
2267: (p_person_id => l_person_id,
2268: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2269: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2270: p_per_ei_data => l_per_ei_data

Line 2284: ghr_history_fetch.fetch_peopleei

2280: Procedure chg_scd is
2281: Begin
2282: If l_person_id is not null then
2283: l_refresh_flag := l_per_refresh_flag;
2284: ghr_history_fetch.fetch_peopleei
2285: (p_person_id => l_person_id,
2286: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
2287: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2288: p_per_ei_data => l_per_ei_data

Line 2308: ghr_history_fetch.fetch_peopleei

2304: set_ei(l_org_rec.rei_information12,l_per_ei_data.pei_information12,l_rei_rec.rei_information12,l_refresh_flag);
2305:
2306: l_per_ei_data := null;
2307:
2308: ghr_history_fetch.fetch_peopleei
2309: (p_person_id => l_person_id,
2310: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
2311: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2312: p_per_ei_data => l_per_ei_data

Line 2317: ghr_history_fetch.fetch_peopleei

2313: );
2314: set_ei(l_org_rec.rei_information5,l_per_ei_data.pei_information5,l_rei_rec.rei_information5,l_refresh_flag);
2315: l_per_ei_data := null;
2316:
2317: ghr_history_fetch.fetch_peopleei
2318: (p_person_id => l_person_id,
2319: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2320: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2321: p_per_ei_data => l_per_ei_data

Line 2338: ghr_history_fetch.fetch_peopleei

2334:
2335: If l_person_id is not null then
2336: l_refresh_flag := l_per_refresh_flag;
2337: hr_utility.set_location('l_refresh_flag is ' || l_refresh_flag,1);
2338: ghr_history_fetch.fetch_peopleei
2339: (p_person_id => l_person_id,
2340: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
2341: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2342: p_per_ei_data => l_per_ei_data

Line 2360: ghr_history_fetch.fetch_peopleei

2356: If l_person_id is not null then
2357: l_refresh_flag := l_per_refresh_flag;
2358: hr_utility.set_location('l_refresh_flag is ' || l_refresh_flag,4);
2359: IF NVL(l_noa_family_code,'C') = 'CORRECT' THEN
2360: ghr_history_fetch.fetch_peopleei
2361: (p_person_id => l_person_id,
2362: p_information_type => 'GHR_US_PER_GROUP1',
2363: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2364: p_per_ei_data => l_per_ei_data

Line 2382: ghr_history_fetch.fetch_peopleei

2378: If l_person_id is not null then
2379: l_refresh_flag := l_per_refresh_flag;
2380: hr_utility.set_location('l_refresh_flag is ' || l_refresh_flag,5);
2381: IF NVL(l_noa_family_code,'C') = 'CORRECT' THEN
2382: ghr_history_fetch.fetch_peopleei
2383: (p_person_id => l_person_id,
2384: p_information_type => 'GHR_US_PER_GROUP1',
2385: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2386: p_per_ei_data => l_per_ei_data

Line 2439: ghr_history_fetch.fetch_positionei

2435: END IF;
2436: END LOOP;
2437: IF l_position_id is not null then
2438: l_refresh_flag := l_pos_refresh_flag;
2439: ghr_history_fetch.fetch_positionei
2440: (p_position_id => l_position_id,
2441: p_information_type => 'GHR_US_POS_GRP2',
2442: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2443: p_pos_ei_data => l_pos_ei_data);

Line 2524: ghr_history_fetch.fetch_asgei

2520: l_work_schedule ghr_pa_requests.work_schedule%type;
2521: Begin
2522: If l_assignment_id is not null then
2523: l_refresh_flag := l_asg_refresh_flag;
2524: ghr_history_fetch.fetch_asgei
2525: (p_assignment_id => l_assignment_id,
2526: p_information_type => 'GHR_US_ASG_NON_SF52',
2527: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2528: p_asg_ei_data => l_asg_ei_data

Line 2554: ghr_history_fetch.fetch_peopleei

2550: --
2551: -- Read from history if person id is not null
2552: IF p_person_id is not null THEN
2553: l_refresh_flag := l_per_refresh_flag;
2554: ghr_history_fetch.fetch_peopleei
2555: (p_person_id => p_person_id,
2556: p_information_type => 'GHR_US_PER_GROUP1',
2557: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2558: p_per_ei_data => l_per_ei_data

Line 2602: ghr_history_fetch.fetch_peopleei

2598: l_per_ei_data := null;
2599: -- Read from history if person id is not null
2600: IF l_person_id IS NOT NULL THEN
2601: l_refresh_flag := l_per_refresh_flag;
2602: ghr_history_fetch.fetch_peopleei
2603: (p_person_id => p_person_id,
2604: p_information_type => 'GHR_US_PER_ETHNICITY_RACE',
2605: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2606: p_per_ei_data => l_per_ei_data

Line 2719: ghr_history_fetch.fetch_asgei

2715: If nvl(get_pos.from_position_id,0) = nvl(get_pos.to_position_id,0) then
2716: If l_assignment_id is not null then
2717: -- Get ASG_NON_SF52 data
2718: l_refresh_flag := l_asg_refresh_flag;
2719: ghr_history_fetch.fetch_asgei
2720: (p_assignment_id => l_assignment_id,
2721: p_information_type => 'GHR_US_ASG_NON_SF52',
2722: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2723: p_asg_ei_data => l_asg_ei_data

Line 2753: ghr_history_fetch.fetch_positionei

2749:
2750: Begin
2751: /* l_per_ei_data := null;
2752: If l_position_id is not null then
2753: ghr_history_fetch.fetch_positionei
2754: (p_position_id => l_position_id,
2755: p_information_type => 'GHR_US_POS_GRP2',
2756: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
2757: p_pos_ei_data => l_pos_ei_data

Line 2769: ghr_history_fetch.fetch_peopleei

2765: END LOOP;
2766: --end Bug# 4588575
2767: */ --Backout the changes done for Bug# 4588575
2768: If l_person_id is not null then
2769: ghr_history_fetch.fetch_peopleei
2770: (p_person_id => l_person_id,
2771: p_information_type => 'GHR_US_PER_CONVERSIONS',
2772: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2773: p_per_ei_data => l_per_ei_data

Line 2833: ghr_history_fetch.fetch_peopleei

2829: WHERE pa_request_id = p_pa_request_id;
2830: Begin
2831: l_per_ei_data := null;
2832: If l_person_id is not null then
2833: ghr_history_fetch.fetch_peopleei
2834: (p_person_id => l_person_id,
2835: p_information_type => 'GHR_US_PER_PROBATIONS',
2836: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2837: p_per_ei_data => l_per_ei_data

Line 2877: ghr_history_fetch.fetch_peopleei

2873: WHERE pa_request_id = p_pa_request_id;
2874: Begin
2875: l_per_ei_data := null;
2876: If l_person_id is not null then
2877: ghr_history_fetch.fetch_peopleei
2878: (p_person_id => l_person_id,
2879: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
2880: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2881: p_per_ei_data => l_per_ei_data

Line 2969: ghr_history_fetch.fetch_peopleei

2965: l_per_ei_data := null;
2966: -- Read from history if person id is not null
2967: IF l_person_id IS NOT NULL THEN
2968: l_refresh_flag := l_per_refresh_flag;
2969: ghr_history_fetch.fetch_peopleei
2970: (p_person_id => p_person_id,
2971: p_information_type => 'GHR_US_PER_BENEFITS_CONT',
2972: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2973: p_per_ei_data => l_per_ei_data

Line 2996: ghr_history_fetch.fetch_peopleei

2992: l_per_ei_data := null;
2993: -- Read from history if person id is not null
2994: IF l_person_id IS NOT NULL THEN
2995: l_refresh_flag := l_per_refresh_flag;
2996: ghr_history_fetch.fetch_peopleei
2997: (p_person_id => p_person_id,
2998: p_information_type => 'GHR_US_PER_RETIRMENT_SYS_INFO',
2999: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3000: p_per_ei_data => l_per_ei_data

Line 3015: ghr_history_fetch.fetch_peopleei

3011: begin
3012: -- Read from history if person id is not null
3013: IF l_person_id IS NOT NULL THEN
3014: l_refresh_flag := l_per_refresh_flag;
3015: ghr_history_fetch.fetch_peopleei
3016: (p_person_id => p_person_id,
3017: p_information_type => 'GHR_US_PER_BENEFIT_INFO',
3018: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3019: p_per_ei_data => l_per_ei_data

Line 3324: ghr_history_fetch.fetch_positionei

3320: l_second_noa_code := pa_rec.second_noa_code;
3321: END LOOP;
3322: IF l_first_noa_code IN ('702','703','713') OR
3323: (l_noa_family_code = 'CORRECT' AND l_second_noa_code IN ('702','703','713')) THEN
3324: ghr_history_fetch.fetch_positionei
3325: (p_position_id => l_from_position_id,
3326: p_information_type => 'GHR_US_POS_GRP1',
3327: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
3328: p_pos_ei_data => l_pos_ei_data

Line 3332: ghr_history_fetch.fetch_positionei

3328: p_pos_ei_data => l_pos_ei_data
3329: );
3330: l_from_poid := l_pos_ei_data.poei_information3;
3331: l_pos_ei_data := NULL;
3332: ghr_history_fetch.fetch_positionei
3333: (p_position_id => l_to_position_id,
3334: p_information_type => 'GHR_US_POS_GRP1',
3335: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
3336: p_pos_ei_data => l_pos_ei_data

Line 3356: ghr_history_fetch.fetch_asgei

3352: l_session1 := l_session;
3353: l_session.noa_id_correct := NULL;
3354: ghr_history_api.reinit_g_session_var;
3355: ghr_history_api.set_g_session_var(l_session);
3356: ghr_history_fetch.fetch_asgei
3357: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
3358: p_information_type => 'GHR_US_ASG_NON_SF52',
3359: p_date_effective => p_effective_date-1,
3360: p_asg_ei_data => l_asg_ei_data

Line 3365: ghr_history_fetch.fetch_asgei

3361: );
3362: ghr_history_api.reinit_g_session_var;
3363: ghr_history_api.set_g_session_var(l_session1);
3364: ELSE
3365: ghr_history_fetch.fetch_asgei
3366: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
3367: p_information_type => 'GHR_US_ASG_NON_SF52',
3368: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3369: p_asg_ei_data => l_asg_ei_data

Line 3375: ghr_history_fetch.fetch_asgei

3371: END IF;
3372: set_ei(l_org_rec.rei_information6,l_asg_ei_data.aei_information3,l_rei_rec.rei_information6,'Y');
3373: /*Start - Bug 6129752*/
3374: ELSIF l_to_poid IS NULL AND l_noa_family_code = 'CORRECT' THEN
3375: ghr_history_fetch.fetch_asgei
3376: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
3377: p_information_type => 'GHR_US_ASG_NON_SF52',
3378: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3379: p_asg_ei_data => l_asg_ei_data