DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_REQUISITIONS

Line 939: from per_requisitions r

935: into v_delete_permitted
936: from sys.dual
937: where not exists (
938: select null
939: from per_requisitions r
940: where r.person_id = P_PERSON_ID);
941: exception
942: when NO_DATA_FOUND then
943: hr_utility.set_message (801,'HR_6338_ALL_PER_REQ_NO_DEL');

Line 1522: update per_requisitions r

1518:
1519: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 888);
1520:
1521: begin
1522: update per_requisitions r
1523: set r.person_id = null
1524: where r.person_id = P_PERSON_ID;
1525: exception
1526: when NO_DATA_FOUND then