8: l_proc varchar2(40):='hr_all_positions_f_afiud';
9:
10: PROCEDURE get_old_position_data( p_old_position_record in out NOCOPY hr_all_positions_f%rowtype) is
11: BEGIN
12: ghr_history_conv_rg.conv_to_position_rg(
13: p_position_id => :old.position_id,
14: p_effective_start_date => :old.effective_start_date,
15: p_effective_end_date => :old.effective_end_date,
16: p_availability_status_id => :old.availability_status_id,
187: :new.effective_end_date
188: THEN
189: hr_utility.set_location( l_proc , 140);
190: get_old_position_data(l_old_position_data);
191: ghr_history_conv_rg.conv_position_rg_to_hist_rg( p_position_data => l_old_position_data,
192: p_history_data => l_old_position_hist_data);
193: -- For core forms effective date must be set to effective start date.
194: -- Currently this is not set correctly thru core form. As it sets the
195: -- effective date to session date.
236: NULL;
237: ELSE
238: hr_utility.set_location('sf50 Updating '|| l_proc , 20);
239: get_old_position_data(l_old_position_data);
240: ghr_history_conv_rg.conv_position_rg_to_hist_rg( p_position_data => l_old_position_data,
241: p_history_data => l_old_position_hist_data);
242: ghr_history_api.set_operation_info(
243: p_table_name => ghr_history_api.g_posn_table,
244: p_program_name => l_session_var.program_name,