APPS.GHR_HISTORY_FETCH dependencies on GHR_HISTORY_FETCH

Line 1: Package Body GHR_HISTORY_FETCH as

1: Package Body GHR_HISTORY_FETCH as
2: /* $Header: ghhisfet.pkb 120.16.12020000.4 2012/12/27 10:27:40 vmididho ship $ */
3: -- Global Constant
4: c_not_found varchar2(30):='not_found';
5: --made the declaration in header

Line 87: -- |--------------------------< >--------------------------|

83: p_result_code out nocopy varchar2 );
84:
85: --
86: -- ----------------------------------------------------------------------------
87: -- |--------------------------< >--------------------------|
88: -- ----------------------------------------------------------------------------
89:
90: --
91: -- This procedue fetches the most recent record as of p_max_date_Effective

Line 1675: ghr_history_fetch.fetch_asgei ( p_assignment_extra_info_id => l_extra_info_id,

1671: END IF;
1672: If l_extra_info_id is not null then
1673: hr_utility.set_location(l_proc,10);
1674: ghr_history_api.get_g_session_var(l_session);
1675: ghr_history_fetch.fetch_asgei ( p_assignment_extra_info_id => l_extra_info_id,
1676: p_date_effective => p_date_effective,
1677: p_altered_pa_request_id => l_session.altered_pa_request_id,
1678: p_noa_id_corrected => l_session.noa_id_correct,
1679: p_pa_history_id => l_session.pa_history_id,

Line 1714: ghr_history_fetch.fetch_peopleei ( p_person_extra_info_id => l_extra_info_id,

1710: End loop;
1711: If l_extra_info_id is not null then
1712: hr_utility.set_location(l_proc,10);
1713: ghr_history_api.get_g_session_var(l_session);
1714: ghr_history_fetch.fetch_peopleei ( p_person_extra_info_id => l_extra_info_id,
1715: p_date_effective => p_date_effective,
1716: p_altered_pa_request_id => l_session.altered_pa_request_id,
1717: p_noa_id_corrected => l_session.noa_id_correct,
1718: p_pa_history_id => l_session.pa_history_id,

Line 1759: ghr_history_fetch.fetch_positionei(p_position_extra_info_id => l_extra_info_id,

1755: end loop;
1756: If l_extra_info_id is not null then
1757: hr_utility.set_location(l_proc,10);
1758: ghr_history_api.get_g_session_var(l_session);
1759: ghr_history_fetch.fetch_positionei(p_position_extra_info_id => l_extra_info_id,
1760: p_date_effective => p_date_effective,
1761: p_altered_pa_request_id => l_session.altered_pa_request_id,
1762: p_noa_id_corrected => l_session.noa_id_correct,
1763: p_pa_history_id => l_session.pa_history_id,

Line 2001: ghr_history_fetch.fetch_element_info_cor

1997: If l_session.noa_id_correct is not null then
1998:
1999: -- History package call fetch_element_entry_value picks new element name
2000: -- again in its call so sending old element name.
2001: ghr_history_fetch.fetch_element_info_cor
2002: (p_element_name => p_element_name,
2003: p_input_value_name => p_input_value_name,
2004: p_assignment_id => p_assignment_id,
2005: p_effective_date => p_date_effective,

Line 2528: ghr_history_fetch.fetch_positionei(

2524: l_proc varchar2(30):='fetch_positionei (1)';
2525: l_result_code varchar2(30);
2526: Begin
2527: hr_utility.set_location('Entering :' || l_proc, 10);
2528: ghr_history_fetch.fetch_positionei(
2529: p_position_extra_info_id => p_position_extra_info_id
2530: , p_date_effective => p_date_effective
2531: , p_posei_data => r_poi
2532: , p_result_code => p_result_code);

Line 2772: ghr_history_fetch.fetch_peopleei(

2768: l_proc varchar2(30):='fetch_peopleei (1)';
2769: l_result_code varchar2(30);
2770: Begin
2771: hr_utility.set_location(' Entering : ' || l_proc, 10);
2772: ghr_history_fetch.fetch_peopleei(
2773: p_person_extra_info_id => p_person_extra_info_id
2774: , p_date_effective => p_date_effective
2775: , p_peopleei_data => r_pei
2776: , p_result_code => p_result_code);

Line 2922: ghr_history_fetch.fetch_asgei(

2918: l_proc varchar2(30):='fetch_asgei (1)';
2919: l_result_code varchar2(30);
2920: Begin
2921: hr_utility.set_location(' Entering : ' || l_proc, 10);
2922: ghr_history_fetch.fetch_asgei(
2923: p_assignment_extra_info_id => p_assignment_extra_info_id
2924: , p_date_effective => p_date_effective
2925: , p_asgei_data => r_aei
2926: , p_result_code => p_result_code);

Line 3293: End GHR_HISTORY_FETCH;

3289: hr_utility.set_location('Leaving ' || l_proc, 100);
3290:
3291: End Fetch_asgn_prior_root_sf50;
3292:
3293: End GHR_HISTORY_FETCH;