[Home] [Help]
578: -- Bug#3780671 Added the Assignment Extra Info condition as
579: -- the EIT "GHR_US_ASG_NTE_DATES" requires the process similar to
580: -- Address table.
581: IF (l_hist.table_name = ghr_history_api.g_addres_table) OR
582: (l_hist.table_name = 'PER_ASSIGNMENT_EXTRA_INFO' and
583: l_hist.information5 = 'GHR_US_ASG_NTE_DATES') THEN
584:
585: SELECT *
586: INTO l_hist_rec
588: WHERE pa_history_id = l_hist.pa_history_id;
589:
590: hr_utility.set_location('Non 352 and Address '||l_hist.table_name,26);
591: -- Bug#3780671 Passed the parameter l_hist.table_name instead of Address table
592: -- to handle PER_ASSIGNMENT_EXTRA_INFO table.
593: ghr_history_api.fetch_history_info(
594: p_table_name => l_hist.table_name,
595: p_hist_data => l_hist_pre,
596: p_pa_history_id => l_hist_rec.pa_history_id,
607: c_pa_history_id => l_hist_rec.pa_history_id);
608: fetch c_follow_rec into l_buf;
609: if c_follow_rec%NOTFOUND then
610: -- Bug#3780671 Passed the parameter l_hist.table_name instead of Address table
611: -- to handle PER_ASSIGNMENT_EXTRA_INFO table.
612: delete_appl_row(
613: p_table_name => l_hist.table_name,
614: p_table_pk_id => l_hist_rec.information1,
615: p_dt_mode => null,
2788: l_proc varchar2(30):='apply_correction';
2789: l_sf52rec ghr_pa_requests%rowtype;
2790:
2791: -- Begin Bug# 5014663
2792: l_asg_ei_data per_assignment_extra_info%rowtype;
2793: l_award_salary number;
2794: l_temp_award_amount number;
2795: -- End Bug# 5014663
2796: BEGIN
4480: -- ---------------------------------------------------------------------------
4481: -- {Start Of Comments}
4482: --
4483: -- Description:
4484: -- This procedure deletes a row from per_assignment_extra_info table.
4485: --
4486: -- Pre-Requisities:
4487: -- None.
4488: --
4489: -- In Parameters:
4490: -- p_assignment_extra_info_id -> assignment_extra_info_id to be deleted.
4491: --
4492: -- Post Success:
4493: -- per_assignment_extra_info row will have been deleted.
4494: --
4495: -- Post Failure:
4496: -- message will have been displayed to user explaining why the delete could not be completed.
4497: --
4504: -- {End Of Comments}
4505: -- ---------------------------------------------------------------------------
4506:
4507: PROCEDURE delete_asgnei_row( p_assignment_extra_info_id in varchar2) IS
4508: l_proc varchar2(72) := 'delete_per_assignment_extra_info_row';
4509: l_ovn number;
4510: -- this cursor gets the object_version_number for the assignment_extra_info_id passed.
4511: cursor c_get_ovn (cp_assignment_extra_info_id in number) is
4512: SELECT object_version_number
4509: l_ovn number;
4510: -- this cursor gets the object_version_number for the assignment_extra_info_id passed.
4511: cursor c_get_ovn (cp_assignment_extra_info_id in number) is
4512: SELECT object_version_number
4513: FROM PER_ASSIGNMENT_EXTRA_INFO
4514: WHERE assignment_extra_info_id = cp_assignment_extra_info_id ;
4515: BEGIN
4516: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4517: open c_get_ovn(p_assignment_extra_info_id);