DBA Data[Home] [Help]

APPS.GHR_MRE_PKG dependencies on GHR_HISTORY_API

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

2712: WHERE pr.pa_request_id = prh.pa_request_id
2713: and person_id = p_person_id
2714: and first_noa_code = p_first_noa_code
2715: and effective_DATE = p_effective_DATE
2716: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
2717: --Bug 657439
2718: -- and nvl(pr.first_noa_cancel_or_correct,'X') <> 'CANCELED'
2719: group by pr.pa_request_id;
2720:

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

2795: WHERE pr.pa_request_id = prh.pa_request_id
2796: and nvl(person_id,0) = p_person_id
2797: and nvl(second_noa_code,0) = p_second_noa_code
2798: and trunc(nvl(effective_DATE,sysDATE)) = trunc(p_effective_DATE)
2799: and nvl(pr.second_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
2800: --Bug 657439
2801: -- and nvl(pr.first_noa_cancel_or_correct,'X') <> 'CANCELED'
2802: group by pr.pa_request_id;
2803:

Line 4092: ghr_history_api.post_UPDATE_process;

4088: ghr_session.set_session_var_for_core( p_position_data_rec.effective_END_DATE );
4089: ghr_sf52_pos_UPDATE.UPDATE_position_info
4090: ( p_pos_data_rec => p_position_data_rec);
4091: hr_utility.set_location('Calling Pust_UPDATE_process ' || l_proc, 50);
4092: ghr_history_api.post_UPDATE_process;
4093: hr_utility.set_location('Leaving ' || l_proc, 100);
4094:
4095: END;
4096: