[Home] [Help]
603: -- Bug#3780671 Added the Assignment Extra Info condition as
604: -- the EIT "GHR_US_ASG_NTE_DATES" requires the process similar to
605: -- Address table.
606: IF (l_hist.table_name = ghr_history_api.g_addres_table) OR
607: (l_hist.table_name = 'PER_ASSIGNMENT_EXTRA_INFO' and
608: l_hist.information5 = 'GHR_US_ASG_NTE_DATES') THEN
609:
610: SELECT *
611: INTO l_hist_rec
613: WHERE pa_history_id = l_hist.pa_history_id;
614:
615: hr_utility.set_location('Non 352 and Address '||l_hist.table_name,26);
616: -- Bug#3780671 Passed the parameter l_hist.table_name instead of Address table
617: -- to handle PER_ASSIGNMENT_EXTRA_INFO table.
618: ghr_history_api.fetch_history_info(
619: p_table_name => l_hist.table_name,
620: p_hist_data => l_hist_pre,
621: p_pa_history_id => l_hist_rec.pa_history_id,
632: c_pa_history_id => l_hist_rec.pa_history_id);
633: fetch c_follow_rec into l_buf;
634: if c_follow_rec%NOTFOUND then
635: -- Bug#3780671 Passed the parameter l_hist.table_name instead of Address table
636: -- to handle PER_ASSIGNMENT_EXTRA_INFO table.
637: delete_appl_row(
638: p_table_name => l_hist.table_name,
639: p_table_pk_id => l_hist_rec.information1,
640: p_dt_mode => null,
3085: l_proc varchar2(30):='apply_correction';
3086: l_sf52rec ghr_pa_requests%rowtype;
3087:
3088: -- Begin Bug# 5014663
3089: l_asg_ei_data per_assignment_extra_info%rowtype;
3090: l_award_salary number;
3091: l_temp_award_amount number;
3092: -- End Bug# 5014663
3093:
4822: -- ---------------------------------------------------------------------------
4823: -- {Start Of Comments}
4824: --
4825: -- Description:
4826: -- This procedure deletes a row from per_assignment_extra_info table.
4827: --
4828: -- Pre-Requisities:
4829: -- None.
4830: --
4831: -- In Parameters:
4832: -- p_assignment_extra_info_id -> assignment_extra_info_id to be deleted.
4833: --
4834: -- Post Success:
4835: -- per_assignment_extra_info row will have been deleted.
4836: --
4837: -- Post Failure:
4838: -- message will have been displayed to user explaining why the delete could not be completed.
4839: --
4846: -- {End Of Comments}
4847: -- ---------------------------------------------------------------------------
4848:
4849: PROCEDURE delete_asgnei_row( p_assignment_extra_info_id in varchar2) IS
4850: l_proc varchar2(72) := 'delete_per_assignment_extra_info_row';
4851: l_ovn number;
4852: -- this cursor gets the object_version_number for the assignment_extra_info_id passed.
4853: cursor c_get_ovn (cp_assignment_extra_info_id in number) is
4854: SELECT object_version_number
4851: l_ovn number;
4852: -- this cursor gets the object_version_number for the assignment_extra_info_id passed.
4853: cursor c_get_ovn (cp_assignment_extra_info_id in number) is
4854: SELECT object_version_number
4855: FROM PER_ASSIGNMENT_EXTRA_INFO
4856: WHERE assignment_extra_info_id = cp_assignment_extra_info_id ;
4857: BEGIN
4858: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4859: open c_get_ovn(p_assignment_extra_info_id);