APPS.GHR_HISTORY_FETCH dependencies on HR_API

Line 850: cursor ghr_hist_ndt_traverse_corrs(cp_pa_history_id in number default hr_api.g_number,

846:
847: -- This cursor traverses in the correction tree and finds the last node in the chain
848: -- other than with history_id = cp_pa_history_id.
849: -- Bug 3278827 Added +0 to nature_of_action_id to use GHR_PA_HISTORY_N1 Index.
850: cursor ghr_hist_ndt_traverse_corrs(cp_pa_history_id in number default hr_api.g_number,
851: cp_pa_request_id in number,
852: cp_noa_id in number,
853: cp_information1 in varchar2,
854: cp_table_name in varchar2) is

Line 1934: If nvl(lower(l_result),hr_api.g_varchar2) <> c_not_found then

1930: Else
1931: hr_utility.set_location(l_proc || 'before exit',7);
1932: exit;
1933: End if;
1934: If nvl(lower(l_result),hr_api.g_varchar2) <> c_not_found then
1935: hr_utility.set_location(l_proc || 'l_result' || l_result,8);
1936: p_screen_entry_value := l_element_entry_data.screen_entry_value;
1937: hr_utility.set_location(l_proc || 'Value' || l_element_entry_data.screen_entry_value,8);
1938: exit;

Line 2131: If nvl(l_processing_type,hr_api.g_varchar2) = 'R' then

2127: l_processing_type := ele_type.processing_type;
2128: hr_utility.set_location('proc type ' || l_processing_type,2);
2129: end loop;
2130:
2131: If nvl(l_processing_type,hr_api.g_varchar2) = 'R' then
2132: For fetch_elv_id in fetch_element_entry_value_id(
2133: l_element_type_id
2134: ,ll_bg_id)
2135: loop

Line 2159: If nvl(lower(l_result),hr_api.g_varchar2) <> c_not_found then

2155: Else
2156: hr_utility.set_location(l_proc || 'before exit',7);
2157: exit;
2158: End if;
2159: If nvl(lower(l_result),hr_api.g_varchar2) <> c_not_found then
2160: hr_utility.set_location(l_proc || 'l_result' || l_result,8);
2161: p_value := l_element_entry_data.screen_entry_value;
2162: hr_utility.set_location(l_proc || 'Value' || l_element_entry_data.screen_entry_value,8);
2163: exit;

Line 2167: Elsif nvl(l_processing_type,hr_api.g_varchar2) = 'N' then

2163: exit;
2164: End if;
2165: End loop;
2166:
2167: Elsif nvl(l_processing_type,hr_api.g_varchar2) = 'N' then
2168: hr_utility.set_location('NOA ID COR ' || to_char(l_session.noa_id_correct),1);
2169: hr_utility.set_location('PAR ID COR ' || to_char(l_session.altered_pa_request_id),1);
2170: hr_utility.set_location('Element Name ' || l_new_element_name,2);
2171: hr_utility.set_location('IV Name ' || p_input_value_name,3);

Line 2906: ,p_special_info out nocopy ghr_api.special_information_type

2902: Procedure return_special_information
2903: (p_person_id in number
2904: ,p_structure_name in varchar2
2905: ,p_effective_date in date
2906: ,p_special_info out nocopy ghr_api.special_information_type
2907: )
2908: is
2909: l_proc varchar2(72) := 'return_special_information ';
2910: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;