3:
4: g_otherbg_hire_in_process boolean := false;
5:
6: procedure close_otherbg_applications(
7: apl_assignment_id in per_all_assignments_f.assignment_id%type,
8: effective_date date,
9: close_mode varchar2
10: );
11:
9: close_mode varchar2
10: );
11:
12: procedure open_otherbg_applications(
13: apl_assignment_id in per_all_assignments_f.assignment_id%type,
14: effective_date date,
15: open_mode varchar2
16: );
17:
14: effective_date date,
15: open_mode varchar2
16: );
17:
18: function isMultiRegVac(apl_assignment_id in per_all_assignments_f.assignment_id%type) return boolean;
19:
20: procedure reverse_terminate(
21: apl_assignment_id in per_all_assignments_f.assignment_id%type,
22: effective_date date
17:
18: function isMultiRegVac(apl_assignment_id in per_all_assignments_f.assignment_id%type) return boolean;
19:
20: procedure reverse_terminate(
21: apl_assignment_id in per_all_assignments_f.assignment_id%type,
22: effective_date date
23: );
24:
25: procedure delete_row1( p_assignment_id number,