1810:
1811: hr_utility.set_location('cancel_emp_apl_hire ',121);
1812: hr_utility.set_location('l_assignment_id :'||l_assignment_id,121);
1813:
1814: if per_otherbg_apl_api.isMultiRegVac(l_assignment_id) then
1815: per_otherbg_apl_api.open_otherbg_applications(l_assignment_id,p_date_start,'CANCEL_HIRE');
1816: end if;
1817:
1818:
1811: hr_utility.set_location('cancel_emp_apl_hire ',121);
1812: hr_utility.set_location('l_assignment_id :'||l_assignment_id,121);
1813:
1814: if per_otherbg_apl_api.isMultiRegVac(l_assignment_id) then
1815: per_otherbg_apl_api.open_otherbg_applications(l_assignment_id,p_date_start,'CANCEL_HIRE');
1816: end if;
1817:
1818:
1819: end loop assignment;
1881: and person_id=p_person_id
1882: and effective_end_date= p_date_start -1;
1883: --
1884: --
1885: if per_otherbg_apl_api.isMultiRegVac(p_assignment_id) then
1886: per_otherbg_apl_api.open_otherbg_applications(p_assignment_id,p_date_start,'CANCEL_HIRE');
1887: end if;
1888:
1889: end loop;
1882: and effective_end_date= p_date_start -1;
1883: --
1884: --
1885: if per_otherbg_apl_api.isMultiRegVac(p_assignment_id) then
1886: per_otherbg_apl_api.open_otherbg_applications(p_assignment_id,p_date_start,'CANCEL_HIRE');
1887: end if;
1888:
1889: end loop;
1890: close ass1;
2728: set paf.effective_end_date = p_end_of_time
2729: where paf.rowid = p_rowid;
2730:
2731:
2732: if per_otherbg_apl_api.isMultiRegVac(p_assignment_id) then
2733: per_otherbg_apl_api.open_otherbg_applications(p_assignment_id,p_start_date,'CANCEL_HIRE');
2734: end if;
2735:
2736: --
2729: where paf.rowid = p_rowid;
2730:
2731:
2732: if per_otherbg_apl_api.isMultiRegVac(p_assignment_id) then
2733: per_otherbg_apl_api.open_otherbg_applications(p_assignment_id,p_start_date,'CANCEL_HIRE');
2734: end if;
2735:
2736: --
2737: hrentmnt.maintain_entries_asg(p_assignment_id