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.6.12010000.1 2008/07/28 10:31:27 appldev ship $ */
3: -- Global Constant
4: c_not_found varchar2(30):='not_found';
5: g_info_type per_position_extra_info.information_type%type;

Line 86: -- |--------------------------< >--------------------------|

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

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

1576: End loop;
1577: If l_extra_info_id is not null then
1578: hr_utility.set_location(l_proc,10);
1579: ghr_history_api.get_g_session_var(l_session);
1580: ghr_history_fetch.fetch_asgei ( p_assignment_extra_info_id => l_extra_info_id,
1581: p_date_effective => p_date_effective,
1582: p_altered_pa_request_id => l_session.altered_pa_request_id,
1583: p_noa_id_corrected => l_session.noa_id_correct,
1584: p_pa_history_id => l_session.pa_history_id,

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

1615: End loop;
1616: If l_extra_info_id is not null then
1617: hr_utility.set_location(l_proc,10);
1618: ghr_history_api.get_g_session_var(l_session);
1619: ghr_history_fetch.fetch_peopleei ( p_person_extra_info_id => l_extra_info_id,
1620: p_date_effective => p_date_effective,
1621: p_altered_pa_request_id => l_session.altered_pa_request_id,
1622: p_noa_id_corrected => l_session.noa_id_correct,
1623: p_pa_history_id => l_session.pa_history_id,

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

1660: end loop;
1661: If l_extra_info_id is not null then
1662: hr_utility.set_location(l_proc,10);
1663: ghr_history_api.get_g_session_var(l_session);
1664: ghr_history_fetch.fetch_positionei(p_position_extra_info_id => l_extra_info_id,
1665: p_date_effective => p_date_effective,
1666: p_altered_pa_request_id => l_session.altered_pa_request_id,
1667: p_noa_id_corrected => l_session.noa_id_correct,
1668: p_pa_history_id => l_session.pa_history_id,

Line 1901: ghr_history_fetch.fetch_element_info_cor

1897: If l_session.noa_id_correct is not null then
1898:
1899: -- History package call fetch_element_entry_value picks new element name
1900: -- again in its call so sending old element name.
1901: ghr_history_fetch.fetch_element_info_cor
1902: (p_element_name => p_element_name,
1903: p_input_value_name => p_input_value_name,
1904: p_assignment_id => p_assignment_id,
1905: p_effective_date => p_date_effective,

Line 2428: ghr_history_fetch.fetch_positionei(

2424: l_proc varchar2(30):='fetch_positionei (1)';
2425: l_result_code varchar2(30);
2426: Begin
2427: hr_utility.set_location('Entering :' || l_proc, 10);
2428: ghr_history_fetch.fetch_positionei(
2429: p_position_extra_info_id => p_position_extra_info_id
2430: , p_date_effective => p_date_effective
2431: , p_posei_data => r_poi
2432: , p_result_code => p_result_code);

Line 2672: ghr_history_fetch.fetch_peopleei(

2668: l_proc varchar2(30):='fetch_peopleei (1)';
2669: l_result_code varchar2(30);
2670: Begin
2671: hr_utility.set_location(' Entering : ' || l_proc, 10);
2672: ghr_history_fetch.fetch_peopleei(
2673: p_person_extra_info_id => p_person_extra_info_id
2674: , p_date_effective => p_date_effective
2675: , p_peopleei_data => r_pei
2676: , p_result_code => p_result_code);

Line 2822: ghr_history_fetch.fetch_asgei(

2818: l_proc varchar2(30):='fetch_asgei (1)';
2819: l_result_code varchar2(30);
2820: Begin
2821: hr_utility.set_location(' Entering : ' || l_proc, 10);
2822: ghr_history_fetch.fetch_asgei(
2823: p_assignment_extra_info_id => p_assignment_extra_info_id
2824: , p_date_effective => p_date_effective
2825: , p_asgei_data => r_aei
2826: , p_result_code => p_result_code);

Line 3193: End GHR_HISTORY_FETCH;

3189: hr_utility.set_location('Leaving ' || l_proc, 100);
3190:
3191: End Fetch_asgn_prior_root_sf50;
3192:
3193: End GHR_HISTORY_FETCH;