[Home] [Help]
23: --
24: -- Now check delete referential integrity as it will cause date
25: -- effective delete.
26: --
27: hr_assignment.del_ref_int_check(p_ass_id, 'END', p_sess_date);
28: --
29: hr_utility.set_location('Leaving: '|| 'PER_ASSIGNMENTS_F3_PKG.process_end_status', 5);
30: end process_end_status;
31: ---------------------------------------------------------------------------
68: -- for the Period of Service. If it is terminated the termination must be
69: -- as a result of termination of the Employees Period of Service i.e. the
70: -- first termination date is on the Actual Termination Date.
71: --
72: -- HR_ASSIGNMENT.CHECK_ASS_FOR_PRIMARY performs these checks on an
73: -- assignment that has had its PRIMARY FLAG set to 'Yes'
74: --
75: begin
76: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.validate_primary_flag.' , 5);
73: -- assignment that has had its PRIMARY FLAG set to 'Yes'
74: --
75: begin
76: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.validate_primary_flag.' , 5);
77: hr_assignment.check_ass_for_primary(
78: p_pd_os_id,
79: p_ass_id,
80: p_val_st_date);
81: end validate_primary_flag;
99: -- future becomes the "leading TERM_ASSIGN").
100: --
101: begin
102: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.test_for_cancel_term' , 5);
103: hr_assignment.test_for_cancel_reterm(
104: p_ass_id,
105: p_val_start_date,
106: p_val_end_date,
107: p_mode,
138: -- In order to cater for this a check is done to see whether there will
139: -- be a change of primary flag at any point in time. N.B. This may be from
140: -- primary to non-primary or vice versa.
141: --
142: -- HR_ASSIGNMENT.CHECK_FUTURE_PRIMARY returns an indicator PRIMARY_CHANGE_FLAG
143: -- to show whether a change will be made. C_NEW_PRIMARY_FLAG is the value
144: -- the current record will have after the operation and
145: -- C_PRIMARY_DATE_FROM is the date on which changes to other assignment
146: -- records must be catered for in order to maintain the rule that there
151: -- then a new primary assignment record is not required. Otherwise another
152: -- assignmnet must be chosen to become the new primary assignment with
153: -- effect from C_PRIMARY_DATE_FROM.
154: --
155: -- HR_ASSIGNMENT.GET_NEW_PRIMARY_ASSIGNMENT determines whether there is a
156: -- single candidate assignment in which case the ID is returned in the
157: -- variable C_NEW_PRIMARY_ASS_ID. Otherwise an indicator is returned that
158: -- results in a QuickPick List of Candidate Assignments being displayed.
159: --
176: -- The last is OUT only so no need to get p_prim_date_from, we will
177: -- only write to the item.
178: --
179: hr_utility.set_location('per_assignments_f3_pkg.check_future_primary',2);
180: hr_assignment.check_future_primary(
181: p_ass_id,
182: l_start_date,
183: p_eff_end_date,
184: p_dt_mode,
197: -- As above, last parameter is OUT only - it's actually a varchar2
198: -- returning a number value!
199: --
200: hr_utility.set_location('per_assignments_f3_pkg.check_future_primary',3);
201: hr_assignment.get_new_primary_assignment(
202: p_ass_id,
203: p_pd_os_id,
204: l_start_date,
205: p_new_prim_ass_id);
624: end if;
625: --
626: p_new_end_date := null;
627: --
628: hr_assignment.check_term(
629: p_pd_os_id,
630: p_ass_id,
631: l_start_date,
632: p_eff_end_date,
635: p_new_end_date);
636: --
637: --Bug# 5758747
638: IF l_leg_code = 'US' THEN
639: hr_assignment.check_for_cobra(
640: p_ass_id,
641: p_val_st_date,
642: p_val_end_date);
643: if hr_utility.check_warning then
674: l_dt_mode := p_dt_del_mode;
675: end if;
676: end if;
677: --
678: hr_assignment.warn_del_term(
679: p_ass_id,
680: l_dt_mode,
681: l_start_date,
682: p_eff_end_date);
918: -- CHECK_TERM_COBRA:
919: --
920: --Bug# 5758747
921: IF l_leg_code = 'US' THEN
922: hr_assignment.check_for_cobra(
923: p_ass_id,
924: p_val_st_date,
925: p_val_end_date);
926: --