APPS.GHR_HISTORY_FETCH dependencies on HR_API

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

855:
856: -- This cursor traverses in the correction tree and finds the last node in the chain
857: -- other than with history_id = cp_pa_history_id.
858: -- Bug 3278827 Added +0 to nature_of_action_id to use GHR_PA_HISTORY_N1 Index.
859: cursor ghr_hist_ndt_traverse_corrs(cp_pa_history_id in number default hr_api.g_number,
860: cp_pa_request_id in number,
861: cp_noa_id in number,
862: cp_information1 in varchar2,
863: cp_table_name in varchar2) is

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

2030: Else
2031: hr_utility.set_location(l_proc || 'before exit',7);
2032: exit;
2033: End if;
2034: If nvl(lower(l_result),hr_api.g_varchar2) <> c_not_found then
2035: hr_utility.set_location(l_proc || 'l_result' || l_result,8);
2036: p_screen_entry_value := l_element_entry_data.screen_entry_value;
2037: hr_utility.set_location(l_proc || 'Value' || l_element_entry_data.screen_entry_value,8);
2038: exit;

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

2227: l_processing_type := ele_type.processing_type;
2228: hr_utility.set_location('proc type ' || l_processing_type,2);
2229: end loop;
2230:
2231: If nvl(l_processing_type,hr_api.g_varchar2) = 'R' then
2232: For fetch_elv_id in fetch_element_entry_value_id(
2233: l_element_type_id
2234: ,ll_bg_id)
2235: loop

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

2255: Else
2256: hr_utility.set_location(l_proc || 'before exit',7);
2257: exit;
2258: End if;
2259: If nvl(lower(l_result),hr_api.g_varchar2) <> c_not_found then
2260: hr_utility.set_location(l_proc || 'l_result' || l_result,8);
2261: p_value := l_element_entry_data.screen_entry_value;
2262: hr_utility.set_location(l_proc || 'Value' || l_element_entry_data.screen_entry_value,8);
2263: exit;

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

2263: exit;
2264: End if;
2265: End loop;
2266:
2267: Elsif nvl(l_processing_type,hr_api.g_varchar2) = 'N' then
2268: hr_utility.set_location('NOA ID COR ' || to_char(l_session.noa_id_correct),1);
2269: hr_utility.set_location('PAR ID COR ' || to_char(l_session.altered_pa_request_id),1);
2270: hr_utility.set_location('Element Name ' || l_new_element_name,2);
2271: hr_utility.set_location('IV Name ' || p_input_value_name,3);

Line 3006: ,p_special_info out nocopy ghr_api.special_information_type

3002: Procedure return_special_information
3003: (p_person_id in number
3004: ,p_structure_name in varchar2
3005: ,p_effective_date in date
3006: ,p_special_info out nocopy ghr_api.special_information_type
3007: )
3008: is
3009: l_proc varchar2(72) := 'return_special_information ';
3010: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;