1: package body PER_GB_TERMINATION as
2: /* $Header: pergbtem.pkb 120.1 2006/10/26 10:58:50 kthampan noship $ */
3: /*
4: **
5: ** Copyright (C) 1999 Oracle Corporation
31: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE)
32: IS
33: BEGIN
34: -- doing no processing here
35: hr_utility.set_location('Entering per_gb_termination.actual_termination',10);
36: hr_utility.set_location('Leaving pay_gb_termination.actual_termination',100);
37: EXCEPTION
38: WHEN OTHERS
39: THEN
44: ,p_final_process_date Date)
45: IS
46: BEGIN
47: -- doing no processing here
48: hr_utility.set_location('Entering per_gb_termination.final_termination',10);
49: hr_utility.set_location('Leaving pay_gb_termination.final_termination',100);
50: EXCEPTION
51: WHEN OTHERS
52: THEN
83: AND p_date_active between asg.effective_start_date and asg.effective_end_date
84: ORDER BY assignment_id;
85: --
86: BEGIN
87: hr_utility.set_location('Entering per_gb_termination.reverse',10);
88:
89: if hr_general.g_data_migrator_mode <> 'Y' then
90: OPEN c_get_person_id (p_period_of_service_id);
91: FETCH c_get_person_id into l_person_id;
128: --
129: end if;
130: hr_utility.set_location('Leaving pay_gb_termination.reverse',100);
131: END REVERSE;
132: END per_gb_termination;