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 351: ghr_history_fetch.fetch_positionei

347: for c_orig_posn in c_position(p_pa_req_id => l_altered_pa_request_id) LOOP
348: l_to_position_id := c_orig_posn.to_position_id;
349: END LOOP;
350: end if;
351: ghr_history_fetch.fetch_positionei
352: (p_position_id => l_from_position_id,
353: p_information_type => 'GHR_US_POS_GRP1',
354: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
355: p_pos_ei_data => l_pos_ei_data

Line 359: ghr_history_fetch.fetch_positionei

355: p_pos_ei_data => l_pos_ei_data
356: );
357: l_from_poid := l_pos_ei_data.poei_information3;
358:
359: ghr_history_fetch.fetch_positionei
360: (p_position_id => l_to_position_id,
361: p_information_type => 'GHR_US_POS_GRP1',
362: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
363: p_pos_ei_data => l_pos_ei_data

Line 375: ghr_history_fetch.fetch_asgei

371: l_session1 := l_session;
372: l_session.noa_id_correct := NULL;
373: ghr_history_api.reinit_g_session_var;
374: ghr_history_api.set_g_session_var(l_session);
375: ghr_history_fetch.fetch_asgei
376: (p_assignment_id => l_assignment_id,
377: p_information_type => 'GHR_US_ASG_NON_SF52',
378: p_date_effective => p_effective_date-1,
379: p_asg_ei_data => l_asg_ei_data );

Line 384: ghr_history_fetch.fetch_asgei

380:
381: ghr_history_api.reinit_g_session_var;
382: ghr_history_api.set_g_session_var(l_session1);
383: ELSE
384: ghr_history_fetch.fetch_asgei
385: (p_assignment_id => l_assignment_id,
386: p_information_type => 'GHR_US_ASG_NON_SF52',
387: p_date_effective => p_effective_date,
388: p_asg_ei_data => l_asg_ei_data);

Line 971: ghr_history_fetch.fetch_peopleei

967: -- if the person_id is not the same as the old person_id then do the foll.
968: -- If l_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
969: -- a) Get PER_GROUP1 Information
970: l_refresh_flag := l_per_refresh_flag;
971: ghr_history_fetch.fetch_peopleei
972: (p_person_id => l_person_id,
973: p_information_type => 'GHR_US_PER_GROUP1',
974: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
975: p_per_ei_data => l_per_ei_data

Line 1003: ghr_history_fetch.fetch_peopleei

999:
1000: -- b) Get PER_UNIFORMED_SERVICES Information
1001: --Begin Bug# 12557463, commented following and added in proc ghr_scd_info
1002: /*
1003: ghr_history_fetch.fetch_peopleei
1004: (p_person_id => l_person_id,
1005: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
1006: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1007: p_per_ei_data => l_per_ei_data

Line 1015: ghr_history_fetch.fetch_peopleei

1011: l_per_ei_data := null;
1012: */
1013: --End Bug# 12557463
1014: -- c) Get PER_SEPARATE_RETIRE Information
1015: ghr_history_fetch.fetch_peopleei
1016: (p_person_id => l_person_id,
1017: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
1018: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1019: p_per_ei_data => l_per_ei_data

Line 1046: ghr_history_fetch.fetch_peopleei

1042:
1043: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
1044: -- Get PER_LEAVE Information
1045: hr_utility.set_location('per_leave_info' ,1);
1046: ghr_history_fetch.fetch_peopleei
1047: (p_person_id => l_person_id,
1048: p_information_type => 'GHR_US_PER_LEAVE_INFO',
1049: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1050: p_per_ei_data => l_per_ei_data

Line 1069: ghr_history_fetch.fetch_asgei

1065: If l_assignment_id is not null then
1066:
1067: -- Get ASG_NON_SF52 data
1068: l_refresh_flag := l_asg_refresh_flag;
1069: ghr_history_fetch.fetch_asgei
1070: (p_assignment_id => l_assignment_id,
1071: p_information_type => 'GHR_US_ASG_NON_SF52',
1072: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1073: p_asg_ei_data => l_asg_ei_data

Line 1101: ghr_history_fetch.fetch_positionei

1097: End if;
1098:
1099: If l_position_id is not null then
1100: l_refresh_flag := l_pos_refresh_flag;
1101: ghr_history_fetch.fetch_positionei
1102: (p_position_id => l_position_id,
1103: p_information_type => 'GHR_US_POS_GRP1',
1104: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
1105: p_pos_ei_data => l_pos_ei_data

Line 1113: ghr_history_fetch.fetch_positionei

1109: hr_utility.set_location('posei in test ei - ' || l_pos_ei_data.poei_information12,2);
1110: l_pos_ei_data := null;
1111: --Begin Bug# 14514445
1112: hr_utility.set_location('promotion_eligibility_date Position Id in appt_info '|| l_position_id,350);
1113: ghr_history_fetch.fetch_positionei
1114: (p_position_id => l_position_id,
1115: p_information_type => 'GHR_US_POS_VALID_GRADE',
1116: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
1117: p_pos_ei_data => l_pos_ei_data

Line 1163: ghr_history_fetch.fetch_peopleei

1159: END IF;
1160:
1161: --BUG # 14276354
1162: l_per_ei_data := NULL;
1163: ghr_history_fetch.fetch_peopleei
1164: (p_person_id => l_person_id,
1165: p_information_type => 'GHR_US_PER_GROUP2',
1166: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1167: p_per_ei_data => l_per_ei_data

Line 1552: ghr_history_fetch.fetch_peopleei

1548: hr_utility.set_location('Prev. FEGLI ' || l_prev_fegli,111);
1549: hr_utility.set_location('l_person_id ' || l_person_id,111);
1550: hr_utility.set_location('p_effective_date ' || p_effective_date,111);
1551:
1552: ghr_history_fetch.fetch_peopleei
1553: (p_person_id => l_person_id,
1554: p_information_type => 'GHR_US_PER_BENEFIT_INFO',
1555: p_date_effective => nvl(l_effective_date,trunc(sysdate)),
1556: p_per_ei_data => l_per_ei_data

Line 1903: ghr_history_fetch.fetch_peopleei

1899: hr_utility.set_location('appt_transfer - person id ' || l_person_id,1);
1900: --Bug 3128526. Changed p_person_id -> l_person_id
1901: If l_person_id is not null then
1902: l_refresh_flag := l_per_refresh_flag;
1903: ghr_history_fetch.fetch_peopleei
1904: (p_person_id => l_person_id,
1905: p_information_type => 'GHR_US_PER_GROUP1',
1906: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1907: p_per_ei_data => l_per_ei_data

Line 1945: ghr_history_fetch.fetch_peopleei

1941: l_org_rec.rei_information19 := l_per_ei_data.pei_information4;
1942: --Begin Bug# 12557463, commented following and added in proc ghr_scd_info
1943: /*l_per_ei_data := null;
1944:
1945: ghr_history_fetch.fetch_peopleei
1946: (p_person_id => l_person_id,
1947: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
1948: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1949: p_per_ei_data => l_per_ei_data

Line 1956: ghr_history_fetch.fetch_peopleei

1952: l_org_rec.rei_information6 := l_per_ei_data.pei_information5; */
1953: --End Bug# 12557463
1954: l_per_ei_data := null;
1955:
1956: ghr_history_fetch.fetch_peopleei
1957: (p_person_id => l_person_id,
1958: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
1959: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
1960: p_per_ei_data => l_per_ei_data

Line 1985: /*ghr_history_fetch.fetch_peopleei

1981: l_per_ei_data := null;
1982:
1983: --bug 4443968
1984: --Begin Bug# 12557463, commented following and added in proc ghr_scd_info
1985: /*ghr_history_fetch.fetch_peopleei
1986: (p_person_id => l_person_id,
1987: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
1988: p_date_effective => nvl (p_effective_date, trunc(sysdate)),
1989: p_per_ei_data => l_per_ei_data

Line 2001: ghr_history_fetch.fetch_peopleei

1997:
1998: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
1999: -- Get PER_LEAVE Information
2000: hr_utility.set_location('per_leave_info' ,1);
2001: ghr_history_fetch.fetch_peopleei
2002: (p_person_id => l_person_id,
2003: p_information_type => 'GHR_US_PER_LEAVE_INFO',
2004: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2005: p_per_ei_data => l_per_ei_data

Line 2020: ghr_history_fetch.fetch_asgei

2016: END IF; -- IF ghr_utility.is_ghr_nfc = 'TRUE'
2017: End if;
2018: If l_assignment_id is not null then
2019: l_refresh_flag := l_asg_refresh_flag;
2020: ghr_history_fetch.fetch_asgei
2021: (p_assignment_id => l_assignment_id,
2022: p_information_type => 'GHR_US_ASG_NON_SF52',
2023: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2024: p_asg_ei_data => l_asg_ei_data

Line 2065: ghr_history_fetch.fetch_positionei

2061: End if;
2062: --Check whether the follwing assignment would work correct in all cases
2063: If l_position_id is not null then
2064: l_refresh_flag := l_pos_refresh_flag;
2065: ghr_history_fetch.fetch_positionei
2066: (p_position_id => l_position_id,
2067: p_information_type => 'GHR_US_POS_GRP1',
2068: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2069: p_pos_ei_data => l_pos_ei_data

Line 2078: ghr_history_fetch.fetch_positionei

2074: End if;
2075: l_pos_ei_data := null;
2076: --Begin Bug# 14514445
2077: hr_utility.set_location('promotion_eligibility_date Position Id in appt_transfer '|| l_position_id,350);
2078: ghr_history_fetch.fetch_positionei
2079: (p_position_id => l_position_id,
2080: p_information_type => 'GHR_US_POS_VALID_GRADE',
2081: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
2082: p_pos_ei_data => l_pos_ei_data

Line 2137: ghr_history_fetch.fetch_peopleei

2133: Begin
2134: -- Read from history if person id is not null
2135: If l_person_id is not null then
2136: l_refresh_flag := l_per_refresh_flag;
2137: ghr_history_fetch.fetch_peopleei
2138: (p_person_id => l_person_id,
2139: p_information_type => 'GHR_US_PER_GROUP1',
2140: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2141: p_per_ei_data => l_per_ei_data

Line 2155: ghr_history_fetch.fetch_peopleei

2151:
2152:
2153: --BUG # 14276354
2154: l_per_ei_data := NULL;
2155: ghr_history_fetch.fetch_peopleei
2156: (p_person_id => l_person_id,
2157: p_information_type => 'GHR_US_PER_GROUP2',
2158: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2159: p_per_ei_data => l_per_ei_data

Line 2173: ghr_history_fetch.fetch_peopleei

2169:
2170: --Begin Bug# 12557463, commented following and added in proc ghr_scd_info
2171: /*l_per_ei_data := null;
2172:
2173: ghr_history_fetch.fetch_peopleei
2174: (p_person_id => l_person_id,
2175: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
2176: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2177: p_per_ei_data => l_per_ei_data

Line 2183: ghr_history_fetch.fetch_peopleei

2179: set_ei(l_org_rec.rei_information4,l_per_ei_data.pei_information5,l_rei_rec.rei_information4,l_refresh_flag);
2180: l_org_rec.rei_information4 := l_per_ei_data.pei_information5; */
2181: --End Bug# 12557463
2182: l_per_ei_data := null;
2183: ghr_history_fetch.fetch_peopleei
2184: (p_person_id => l_person_id,
2185: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2186: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2187: p_per_ei_data => l_per_ei_data

Line 2198: ghr_history_fetch.fetch_peopleei

2194: l_org_rec.rei_information10 := l_per_ei_data.pei_information4;
2195: set_ei(l_org_rec.rei_information21,l_per_ei_data.pei_information3,l_rei_rec.rei_information21,l_refresh_flag);
2196: l_org_rec.rei_information21 := l_per_ei_data.pei_information3;
2197: l_per_ei_data := null;
2198: ghr_history_fetch.fetch_peopleei
2199: (p_person_id => l_person_id,
2200: p_information_type => 'GHR_US_PER_CONVERSIONS',
2201: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2202: p_per_ei_data => l_per_ei_data

Line 2221: ghr_history_fetch.fetch_peopleei

2217: l_per_ei_data := null;
2218: -- Get PER_LEAVE Information
2219: hr_utility.set_location('per_leave_info' ,1);
2220: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
2221: ghr_history_fetch.fetch_peopleei
2222: (p_person_id => l_person_id,
2223: p_information_type => 'GHR_US_PER_LEAVE_INFO',
2224: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2225: p_per_ei_data => l_per_ei_data

Line 2238: ghr_history_fetch.fetch_asgei

2234: END IF; -- IF ghr_utility.is_ghr_nfc = 'TR
2235: End if;
2236: If NVL(l_assignment_id,p_assignment_id) is not null then
2237: l_refresh_flag := l_asg_refresh_flag;
2238: ghr_history_fetch.fetch_asgei
2239: (p_assignment_id => l_assignment_id,
2240: p_information_type => 'GHR_US_ASG_NON_SF52',
2241: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2242: p_asg_ei_data => l_asg_ei_data

Line 2269: ghr_history_fetch.fetch_positionei

2265: --Check whether the follwing assignment would work correct in all cases
2266: If l_position_id is not null then
2267: l_refresh_flag := l_pos_refresh_flag;
2268: -- Make sure that the foll. check is correct
2269: ghr_history_fetch.fetch_positionei
2270: (p_position_id => l_position_id,
2271: p_information_type => 'GHR_US_POS_GRP1',
2272: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2273: p_pos_ei_data => l_pos_ei_data

Line 2279: ghr_history_fetch.fetch_positionei

2275: set_ei(l_org_rec.rei_information9,l_pos_ei_data.poei_information12,l_rei_rec.rei_information9,l_refresh_flag);
2276: l_pos_ei_data := null;
2277: --Begin Bug# 14514445
2278: hr_utility.set_location('promotion_eligibility_date Position Id in conv_appt '|| l_position_id,350);
2279: ghr_history_fetch.fetch_positionei
2280: (p_position_id => l_position_id,
2281: p_information_type => 'GHR_US_POS_VALID_GRADE',
2282: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
2283: p_pos_ei_data => l_pos_ei_data

Line 2310: ghr_history_fetch.fetch_positionei

2306: l_from_position_id :=c_posn_to_frm.from_position_id;
2307: l_to_position_id := c_posn_to_frm.to_position_id;
2308: END LOOP;
2309:
2310: ghr_history_fetch.fetch_positionei
2311: (p_position_id => l_from_position_id,
2312: p_information_type => 'GHR_US_POS_GRP1',
2313: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
2314: p_pos_ei_data => l_pos_ei_data

Line 2319: ghr_history_fetch.fetch_positionei

2315: );
2316: l_from_poid := l_pos_ei_data.poei_information3;
2317: l_pos_ei_data := NULL;
2318:
2319: ghr_history_fetch.fetch_positionei
2320: (p_position_id => l_to_position_id,
2321: p_information_type => 'GHR_US_POS_GRP1',
2322: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
2323: p_pos_ei_data => l_pos_ei_data

Line 2334: ghr_history_fetch.fetch_asgei

2330: l_session1 := l_session;
2331: l_session.noa_id_correct := NULL;
2332: ghr_history_api.reinit_g_session_var;
2333: ghr_history_api.set_g_session_var(l_session);
2334: ghr_history_fetch.fetch_asgei
2335: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2336: p_information_type => 'GHR_US_ASG_NON_SF52',
2337: p_date_effective => p_effective_date-1,
2338: p_asg_ei_data => l_asg_ei_data );

Line 2342: ghr_history_fetch.fetch_asgei

2338: p_asg_ei_data => l_asg_ei_data );
2339: ghr_history_api.reinit_g_session_var;
2340: ghr_history_api.set_g_session_var(l_session1);
2341: ELSE
2342: ghr_history_fetch.fetch_asgei
2343: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2344: p_information_type => 'GHR_US_ASG_NON_SF52',
2345: p_date_effective => p_effective_date,
2346: p_asg_ei_data => l_asg_ei_data);

Line 2351: ghr_history_fetch.fetch_asgei

2347: END IF;
2348: set_ei(l_org_rec.rei_information5,l_asg_ei_data.aei_information3,l_rei_rec.rei_information5,l_refresh_flag);
2349: /*Start - Bug 7295154*/
2350: ELSIF l_to_poid IS NULL AND l_noa_family_code = 'CORRECT' THEN
2351: ghr_history_fetch.fetch_asgei
2352: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2353: p_information_type => 'GHR_US_ASG_NON_SF52',
2354: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2355: p_asg_ei_data => l_asg_ei_data

Line 2401: /*ghr_history_fetch.fetch_peopleei

2397:
2398: If l_person_id is not null then
2399: l_refresh_flag := l_per_refresh_flag;
2400: --Begin Bug# 12557463, commented following and added in proc ghr_scd_info
2401: /*ghr_history_fetch.fetch_peopleei
2402: (p_person_id => l_person_id,
2403: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
2404: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2405: p_per_ei_data => l_per_ei_data

Line 2410: ghr_history_fetch.fetch_peopleei

2406: );
2407: set_ei(l_org_rec.rei_information3,l_per_ei_data.pei_information5,l_rei_rec.rei_information3,l_refresh_flag);
2408: l_per_ei_data := null;
2409:
2410: ghr_history_fetch.fetch_peopleei
2411: (p_person_id => l_person_id,
2412: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2413: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2414: p_per_ei_data l_per_ei_data

Line 2420: ghr_history_fetch.fetch_peopleei

2416: set_ei(l_org_rec.rei_information5,l_per_ei_data.pei_information5,l_rei_rec.rei_information5,l_refresh_flag);*/
2417: --End Bug# 12557463
2418: -- Bug 3966783 changes
2419: IF NVL(l_noa_family_code,'C') = 'CORRECT' THEN
2420: ghr_history_fetch.fetch_peopleei
2421: (p_person_id => l_person_id,
2422: p_information_type => 'GHR_US_PER_GROUP1',
2423: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2424: p_per_ei_data => l_per_ei_data

Line 2433: ghr_history_fetch.fetch_asgei

2429: End if;
2430:
2431: If l_assignment_id is not null then
2432: l_refresh_flag := l_asg_refresh_flag;
2433: ghr_history_fetch.fetch_asgei
2434: (p_assignment_id => l_assignment_id,
2435: p_information_type => 'GHR_US_ASG_NON_SF52',
2436: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2437: p_asg_ei_data => l_asg_ei_data

Line 2466: ghr_history_fetch.fetch_asgei

2462: Procedure reassignment is
2463: Begin
2464: If l_assignment_id is not null then
2465: l_refresh_flag := l_asg_refresh_flag;
2466: ghr_history_fetch.fetch_asgei
2467: (p_assignment_id => l_assignment_id,
2468: p_information_type => 'GHR_US_ASG_NON_SF52',
2469: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2470: p_asg_ei_data => l_asg_ei_data

Line 2479: ghr_history_fetch.fetch_positionei

2475: l_asg_ei_data := null;
2476: End if;
2477: If l_position_id is not null then
2478: l_refresh_flag := l_pos_refresh_flag;
2479: ghr_history_fetch.fetch_positionei
2480: (p_position_id => l_position_id,
2481: p_information_type => 'GHR_US_POS_GRP1',
2482: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2483: p_pos_ei_data => l_pos_ei_data

Line 2490: ghr_history_fetch.fetch_positionei

2486: l_pos_ei_data := null;
2487:
2488: /* Bug # 1794090
2489:
2490: ghr_history_fetch.fetch_positionei
2491: (p_position_id => l_position_id,
2492: p_information_type => 'GHR_US_POS_GRP2',
2493: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2494: p_pos_ei_data => l_pos_ei_data

Line 2502: ghr_history_fetch.fetch_positionei

2498: l_pos_ei_data := null;
2499: */
2500: --Begin Bug# 14514445
2501: hr_utility.set_location('promotion_eligibility_date Position Id in reassignment '|| l_position_id,350);
2502: ghr_history_fetch.fetch_positionei
2503: (p_position_id => l_position_id,
2504: p_information_type => 'GHR_US_POS_VALID_GRADE',
2505: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
2506: p_pos_ei_data => l_pos_ei_data

Line 2522: ghr_history_fetch.fetch_peopleei

2518:
2519: IF SUBSTR(l_valid_grade_name,1,2) = SUBSTR(l_target_grade_name,1,2) AND
2520: TO_NUMBER(SUBSTR(l_valid_grade_name,4,5)) < TO_NUMBER(SUBSTR(l_target_grade_name,4,5)) THEN
2521: hr_utility.set_location('promotion_eligibility_date default in reassignment '|| l_valid_grade_name,353);
2522: ghr_history_fetch.fetch_peopleei
2523: (p_person_id => l_person_id,
2524: p_information_type => 'GHR_US_PER_GROUP1',
2525: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2526: p_per_ei_data => l_per_ei_data

Line 2541: ghr_history_fetch.fetch_positionei

2537: FOR c_posn_to_frm IN c_position LOOP
2538: l_from_position_id :=c_posn_to_frm.from_position_id;
2539: l_to_position_id := c_posn_to_frm.to_position_id;
2540: END LOOP;
2541: ghr_history_fetch.fetch_positionei
2542: (p_position_id => l_from_position_id,
2543: p_information_type => 'GHR_US_POS_GRP1',
2544: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
2545: p_pos_ei_data => l_pos_ei_data

Line 2550: ghr_history_fetch.fetch_positionei

2546: );
2547: l_from_poid := l_pos_ei_data.poei_information3;
2548: l_pos_ei_data := NULL;
2549:
2550: ghr_history_fetch.fetch_positionei
2551: (p_position_id => l_to_position_id,
2552: p_information_type => 'GHR_US_POS_GRP1',
2553: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2554: p_pos_ei_data => l_pos_ei_data

Line 2566: ghr_history_fetch.fetch_asgei

2562: l_session1 := l_session;
2563: l_session.noa_id_correct := NULL;
2564: ghr_history_api.reinit_g_session_var;
2565: ghr_history_api.set_g_session_var(l_session);
2566: ghr_history_fetch.fetch_asgei
2567: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2568: p_information_type => 'GHR_US_ASG_NON_SF52',
2569: p_date_effective => p_effective_date-1,
2570: p_asg_ei_data => l_asg_ei_data

Line 2575: ghr_history_fetch.fetch_asgei

2571: );
2572: ghr_history_api.reinit_g_session_var;
2573: ghr_history_api.set_g_session_var(l_session1);
2574: ELSE
2575: ghr_history_fetch.fetch_asgei
2576: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2577: p_information_type => 'GHR_US_ASG_NON_SF52',
2578: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2579: p_asg_ei_data => l_asg_ei_data

Line 2609: ghr_history_fetch.fetch_asgei

2605: -- Bug#4089400 Moved the cursor to the begining of the main procedure.
2606: IF NVL(l_noa_family_code,'C') = 'CORRECT' THEN
2607: If l_assignment_id is not null then
2608: l_refresh_flag := l_asg_refresh_flag;
2609: ghr_history_fetch.fetch_asgei
2610: (p_assignment_id => l_assignment_id,
2611: p_information_type => 'GHR_US_ASG_NON_SF52',
2612: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2613: p_asg_ei_data => l_asg_ei_data

Line 2620: ghr_history_fetch.fetch_positionei

2616: l_asg_ei_data := null;
2617: End if;
2618: If l_position_id is not null then
2619: l_refresh_flag := l_pos_refresh_flag;
2620: ghr_history_fetch.fetch_positionei
2621: (p_position_id => l_position_id,
2622: p_information_type => 'GHR_US_POS_GRP1',
2623: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2624: p_pos_ei_data => l_pos_ei_data

Line 2635: ghr_history_fetch.fetch_positionei

2631: set_ei(l_org_rec.rei_information11,l_pos_ei_data.poei_information5,l_rei_rec.rei_information11,l_refresh_flag);
2632:
2633: l_pos_ei_data := null;
2634:
2635: ghr_history_fetch.fetch_positionei
2636: (p_position_id => l_position_id,
2637: p_information_type => 'GHR_US_POS_GRP2',
2638: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2639: p_pos_ei_data => l_pos_ei_data

Line 2659: ghr_history_fetch.fetch_positionei

2655: l_bg_id per_positions.business_group_id%type;
2656: Begin
2657: If l_position_id is not null then
2658: l_refresh_flag := l_pos_refresh_flag;
2659: ghr_history_fetch.fetch_positionei
2660: (p_position_id => l_position_id,
2661: p_information_type => 'GHR_US_POS_GRP1',
2662: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2663: p_pos_ei_data => l_pos_ei_data

Line 2686: ghr_history_fetch.fetch_peopleei

2682: Procedure chg_retire_plan is
2683: Begin
2684: If l_person_id is not null then
2685: l_refresh_flag := l_per_refresh_flag;
2686: ghr_history_fetch.fetch_peopleei
2687: (p_person_id => l_person_id,
2688: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
2689: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2690: p_per_ei_data => l_per_ei_data

Line 2695: ghr_history_fetch.fetch_peopleei

2691: );
2692: set_ei(l_org_rec.rei_information3,l_per_ei_data.pei_information5,l_rei_rec.rei_information3,l_refresh_flag);
2693: l_per_ei_data := null;
2694:
2695: ghr_history_fetch.fetch_peopleei
2696: (p_person_id => l_person_id,
2697: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2698: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2699: p_per_ei_data => l_per_ei_data

Line 2707: ghr_history_fetch.fetch_peopleei

2703: set_ei(l_org_rec.rei_information6,l_per_ei_data.pei_information4,l_rei_rec.rei_information6,l_refresh_flag);
2704: l_per_ei_data := null;
2705: --Begin Bug# 14769681
2706:
2707: ghr_history_fetch.fetch_peopleei
2708: (p_person_id => l_person_id,
2709: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
2710: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2711: p_per_ei_data => l_per_ei_data

Line 2724: ghr_history_fetch.fetch_peopleei

2720: Procedure chg_scd is
2721: Begin
2722: If l_person_id is not null then
2723: l_refresh_flag := l_per_refresh_flag;
2724: ghr_history_fetch.fetch_peopleei
2725: (p_person_id => l_person_id,
2726: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
2727: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2728: p_per_ei_data => l_per_ei_data

Line 2748: ghr_history_fetch.fetch_peopleei

2744: set_ei(l_org_rec.rei_information12,l_per_ei_data.pei_information12,l_rei_rec.rei_information12,l_refresh_flag);
2745:
2746: l_per_ei_data := null;
2747:
2748: ghr_history_fetch.fetch_peopleei
2749: (p_person_id => l_person_id,
2750: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
2751: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2752: p_per_ei_data => l_per_ei_data

Line 2757: ghr_history_fetch.fetch_peopleei

2753: );
2754: set_ei(l_org_rec.rei_information5,l_per_ei_data.pei_information5,l_rei_rec.rei_information5,l_refresh_flag);
2755: l_per_ei_data := null;
2756:
2757: ghr_history_fetch.fetch_peopleei
2758: (p_person_id => l_person_id,
2759: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2760: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2761: p_per_ei_data => l_per_ei_data

Line 2779: ghr_history_fetch.fetch_peopleei

2775:
2776: hr_utility.set_location ('l_refresh_flag in prv_ret_info is '
2777: || l_refresh_flag, 4);
2778:
2779: ghr_history_fetch.fetch_peopleei
2780: (p_person_id => l_person_id
2781: , p_information_type => 'GHR_US_PER_SEPARATE_RETIRE'
2782: , p_date_effective => nvl (p_effective_date, trunc (sysdate))
2783: , p_per_ei_data => l_per_ei_data);

Line 2802: ghr_history_fetch.fetch_peopleei

2798:
2799: If l_person_id is not null then
2800: l_refresh_flag := l_per_refresh_flag;
2801: hr_utility.set_location('l_refresh_flag is ' || l_refresh_flag,1);
2802: ghr_history_fetch.fetch_peopleei
2803: (p_person_id => l_person_id,
2804: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
2805: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2806: p_per_ei_data => l_per_ei_data

Line 2824: ghr_history_fetch.fetch_peopleei

2820: If l_person_id is not null then
2821: l_refresh_flag := l_per_refresh_flag;
2822: hr_utility.set_location('l_refresh_flag is ' || l_refresh_flag,4);
2823: IF NVL(l_noa_family_code,'C') = 'CORRECT' THEN
2824: ghr_history_fetch.fetch_peopleei
2825: (p_person_id => l_person_id,
2826: p_information_type => 'GHR_US_PER_GROUP1',
2827: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2828: p_per_ei_data => l_per_ei_data

Line 2887: ghr_history_fetch.fetch_peopleei

2883: If l_person_id is not null then
2884: l_refresh_flag := l_per_refresh_flag;
2885: hr_utility.set_location('l_refresh_flag is ' || l_refresh_flag,5);
2886: IF NVL(l_noa_family_code,'C') = 'CORRECT' THEN
2887: ghr_history_fetch.fetch_peopleei
2888: (p_person_id => l_person_id,
2889: p_information_type => 'GHR_US_PER_GROUP1',
2890: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2891: p_per_ei_data => l_per_ei_data

Line 2974: ghr_history_fetch.fetch_positionei

2970: END IF;
2971: END LOOP;
2972: IF l_position_id is not null then
2973: l_refresh_flag := l_pos_refresh_flag;
2974: ghr_history_fetch.fetch_positionei
2975: (p_position_id => l_position_id,
2976: p_information_type => 'GHR_US_POS_GRP2',
2977: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
2978: p_pos_ei_data => l_pos_ei_data);

Line 3059: ghr_history_fetch.fetch_asgei

3055: l_work_schedule ghr_pa_requests.work_schedule%type;
3056: Begin
3057: If l_assignment_id is not null then
3058: l_refresh_flag := l_asg_refresh_flag;
3059: ghr_history_fetch.fetch_asgei
3060: (p_assignment_id => l_assignment_id,
3061: p_information_type => 'GHR_US_ASG_NON_SF52',
3062: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3063: p_asg_ei_data => l_asg_ei_data

Line 3089: ghr_history_fetch.fetch_peopleei

3085: --
3086: -- Read from history if person id is not null
3087: IF p_person_id is not null THEN
3088: l_refresh_flag := l_per_refresh_flag;
3089: ghr_history_fetch.fetch_peopleei
3090: (p_person_id => p_person_id,
3091: p_information_type => 'GHR_US_PER_GROUP1',
3092: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3093: p_per_ei_data => l_per_ei_data

Line 3137: ghr_history_fetch.fetch_peopleei

3133: l_per_ei_data := null;
3134: -- Read from history if person id is not null
3135: IF l_person_id IS NOT NULL THEN
3136: l_refresh_flag := l_per_refresh_flag;
3137: ghr_history_fetch.fetch_peopleei
3138: (p_person_id => p_person_id,
3139: p_information_type => 'GHR_US_PER_ETHNICITY_RACE',
3140: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3141: p_per_ei_data => l_per_ei_data

Line 3258: ghr_history_fetch.fetch_asgei

3254: or (l_noa_family_code = 'CORRECT') then
3255: If l_assignment_id is not null then
3256: -- Get ASG_NON_SF52 data
3257: l_refresh_flag := l_asg_refresh_flag;
3258: ghr_history_fetch.fetch_asgei
3259: (p_assignment_id => l_assignment_id,
3260: p_information_type => 'GHR_US_ASG_NON_SF52',
3261: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3262: p_asg_ei_data => l_asg_ei_data

Line 3294: ghr_history_fetch.fetch_positionei

3290:
3291: Begin
3292: /* l_per_ei_data := null;
3293: If l_position_id is not null then
3294: ghr_history_fetch.fetch_positionei
3295: (p_position_id => l_position_id,
3296: p_information_type => 'GHR_US_POS_GRP2',
3297: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
3298: p_pos_ei_data => l_pos_ei_data

Line 3310: ghr_history_fetch.fetch_peopleei

3306: END LOOP;
3307: --end Bug# 4588575
3308: */ --Backout the changes done for Bug# 4588575
3309: If l_person_id is not null then
3310: ghr_history_fetch.fetch_peopleei
3311: (p_person_id => l_person_id,
3312: p_information_type => 'GHR_US_PER_CONVERSIONS',
3313: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3314: p_per_ei_data => l_per_ei_data

Line 3374: ghr_history_fetch.fetch_peopleei

3370: WHERE pa_request_id = p_pa_request_id;
3371: Begin
3372: l_per_ei_data := null;
3373: If l_person_id is not null then
3374: ghr_history_fetch.fetch_peopleei
3375: (p_person_id => l_person_id,
3376: p_information_type => 'GHR_US_PER_PROBATIONS',
3377: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3378: p_per_ei_data => l_per_ei_data

Line 3465: ghr_history_fetch.fetch_peopleei

3461: END IF;
3462: END IF;
3463: --End Bug# 14001082
3464: ELSE
3465: ghr_history_fetch.fetch_peopleei
3466: (p_person_id => l_person_id,
3467: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
3468: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3469: p_per_ei_data => l_per_ei_data

Line 3502: ghr_history_fetch.fetch_peopleei

3498: --End Bug# 14001082
3499: set_ei(l_org_rec.rei_information8,l_per_ei_data.pei_information12,
3500: l_rei_rec.rei_information8,l_refresh_flag);
3501: l_per_ei_data := null;
3502: ghr_history_fetch.fetch_peopleei
3503: (p_person_id => l_person_id,
3504: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
3505: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3506: p_per_ei_data => l_per_ei_data);

Line 3511: ghr_history_fetch.fetch_peopleei

3507:
3508: set_ei(l_org_rec.rei_information7,l_per_ei_data.pei_information5,l_rei_rec.rei_information7,l_refresh_flag);
3509: l_per_ei_data := null;
3510:
3511: ghr_history_fetch.fetch_peopleei
3512: (p_person_id => l_person_id,
3513: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
3514: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3515: p_per_ei_data => l_per_ei_data);

Line 3599: ghr_history_fetch.fetch_peopleei

3595: l_per_ei_data := null;
3596: -- Read from history if person id is not null
3597: IF l_person_id IS NOT NULL THEN
3598: l_refresh_flag := l_per_refresh_flag;
3599: ghr_history_fetch.fetch_peopleei
3600: (p_person_id => p_person_id,
3601: p_information_type => 'GHR_US_PER_BENEFITS_CONT',
3602: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3603: p_per_ei_data => l_per_ei_data

Line 3626: ghr_history_fetch.fetch_peopleei

3622: l_per_ei_data := null;
3623: -- Read from history if person id is not null
3624: IF l_person_id IS NOT NULL THEN
3625: l_refresh_flag := l_per_refresh_flag;
3626: ghr_history_fetch.fetch_peopleei
3627: (p_person_id => p_person_id,
3628: p_information_type => 'GHR_US_PER_RETIRMENT_SYS_INFO',
3629: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3630: p_per_ei_data => l_per_ei_data

Line 3645: ghr_history_fetch.fetch_peopleei

3641: begin
3642: -- Read from history if person id is not null
3643: IF l_person_id IS NOT NULL THEN
3644: l_refresh_flag := l_per_refresh_flag;
3645: ghr_history_fetch.fetch_peopleei
3646: (p_person_id => p_person_id,
3647: p_information_type => 'GHR_US_PER_BENEFIT_INFO',
3648: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3649: p_per_ei_data => l_per_ei_data

Line 3670: ghr_history_fetch.fetch_asgei

3666: WHERE pa_request_id = p_pa_request_id;
3667: begin
3668: If NVL(l_assignment_id,p_assignment_id) is not null then--bug# 11781442
3669: l_refresh_flag := l_asg_refresh_flag;
3670: ghr_history_fetch.fetch_asgei
3671: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),--bug# 11781442
3672: p_information_type => 'GHR_US_ASG_DET_INFO',
3673: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3674: p_asg_ei_data => l_asg_ei_data

Line 4042: ghr_history_fetch.fetch_positionei

4038: (l_noa_family_code = 'CORRECT' AND l_second_noa_code IN ('702','703','713')) OR
4039: ---Bug# 8263918
4040: (l_first_noa_code is not null and l_second_noa_code is not null and l_second_noa_code in ('702','703','713')) THEN
4041: ---Bug# 8263918
4042: ghr_history_fetch.fetch_positionei
4043: (p_position_id => l_from_position_id,
4044: p_information_type => 'GHR_US_POS_GRP1',
4045: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
4046: p_pos_ei_data => l_pos_ei_data

Line 4050: ghr_history_fetch.fetch_positionei

4046: p_pos_ei_data => l_pos_ei_data
4047: );
4048: l_from_poid := l_pos_ei_data.poei_information3;
4049: l_pos_ei_data := NULL;
4050: ghr_history_fetch.fetch_positionei
4051: (p_position_id => l_to_position_id,
4052: p_information_type => 'GHR_US_POS_GRP1',
4053: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
4054: p_pos_ei_data => l_pos_ei_data

Line 4074: ghr_history_fetch.fetch_asgei

4070: l_session1 := l_session;
4071: l_session.noa_id_correct := NULL;
4072: ghr_history_api.reinit_g_session_var;
4073: ghr_history_api.set_g_session_var(l_session);
4074: ghr_history_fetch.fetch_asgei
4075: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
4076: p_information_type => 'GHR_US_ASG_NON_SF52',
4077: p_date_effective => p_effective_date-1,
4078: p_asg_ei_data => l_asg_ei_data

Line 4083: ghr_history_fetch.fetch_asgei

4079: );
4080: ghr_history_api.reinit_g_session_var;
4081: ghr_history_api.set_g_session_var(l_session1);
4082: ELSE
4083: ghr_history_fetch.fetch_asgei
4084: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
4085: p_information_type => 'GHR_US_ASG_NON_SF52',
4086: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
4087: p_asg_ei_data => l_asg_ei_data

Line 4093: ghr_history_fetch.fetch_asgei

4089: END IF;
4090: set_ei(l_org_rec.rei_information6,l_asg_ei_data.aei_information3,l_rei_rec.rei_information6,'Y');
4091: /*Start - Bug 6129752*/
4092: ELSIF l_to_poid IS NULL AND l_noa_family_code = 'CORRECT' THEN
4093: ghr_history_fetch.fetch_asgei
4094: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
4095: p_information_type => 'GHR_US_ASG_NON_SF52',
4096: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
4097: p_asg_ei_data => l_asg_ei_data

Line 4111: ghr_history_fetch.fetch_positionei

4107: END IF;
4108: --Begin Bug# 14514445
4109: hr_utility.set_location('promotion_eligibility_date Position Id in Salary change '|| l_position_id,350);
4110: l_pos_ei_data := null;
4111: ghr_history_fetch.fetch_positionei
4112: (p_position_id => l_position_id,
4113: p_information_type => 'GHR_US_POS_VALID_GRADE',
4114: p_date_effective => trunc(nvl(p_effective_date,sysdate)),
4115: p_pos_ei_data => l_pos_ei_data

Line 4134: ghr_history_fetch.fetch_peopleei

4130: hr_utility.set_location('promotion_eligibility_date default in Salary change '|| l_valid_grade_name,353);
4131: IF l_first_noa_code IN ('702') THEN
4132: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(p_effective_date+365),l_rei_rec.rei_information7,l_refresh_flag);
4133: ELSE
4134: ghr_history_fetch.fetch_peopleei
4135: (p_person_id => l_person_id,
4136: p_information_type => 'GHR_US_PER_GROUP1',
4137: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
4138: p_per_ei_data => l_per_ei_data