DBA Data[Home] [Help]

APPS.GHR_MRE_PKG dependencies on GHR_HISTORY_API

Line 2562: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel

2558: WHERE pr.pa_request_id = prh.pa_request_id
2559: and person_id = p_person_id
2560: and first_noa_code = p_first_noa_code
2561: and effective_DATE = p_effective_DATE
2562: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
2563: --Bug 657439
2564: -- and nvl(pr.first_noa_cancel_or_correct,'X') <> 'CANCELED'
2565: group by pr.pa_request_id;
2566:

Line 2638: and nvl(pr.second_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel

2634: WHERE pr.pa_request_id = prh.pa_request_id
2635: and nvl(person_id,0) = p_person_id
2636: and nvl(second_noa_code,0) = p_second_noa_code
2637: and trunc(nvl(effective_DATE,sysDATE)) = trunc(p_effective_DATE)
2638: and nvl(pr.second_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
2639: --Bug 657439
2640: -- and nvl(pr.first_noa_cancel_or_correct,'X') <> 'CANCELED'
2641: group by pr.pa_request_id;
2642:

Line 3925: ghr_history_api.post_UPDATE_process;

3921: ghr_session.set_session_var_for_core( p_position_data_rec.effective_END_DATE );
3922: ghr_sf52_pos_UPDATE.UPDATE_position_info
3923: ( p_pos_data_rec => p_position_data_rec);
3924: hr_utility.set_location('Calling Pust_UPDATE_process ' || l_proc, 50);
3925: ghr_history_api.post_UPDATE_process;
3926: hr_utility.set_location('Leaving ' || l_proc, 100);
3927:
3928: END;
3929: