eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERSON_DELETE dependencies on PER_ABSENCE_ATTENDANCES

Line 859: from per_absence_attendances a

855: into v_delete_permitted
856: from sys.dual
857: where not exists (
858: select null
859: from per_absence_attendances a
860: where a.person_id = P_PERSON_ID);
861: exception
862: when NO_DATA_FOUND then
863: hr_utility.set_message (801,'HR_6335_ALL_PER_ABS_ATT_NO_DEL');

Line 875: from per_absence_attendances a

871: into v_delete_permitted
872: from sys.dual
873: where not exists (
874: select null
875: from per_absence_attendances a
876: where a.authorising_person_id = P_PERSON_ID
877: or a.replacement_person_id = P_PERSON_ID);
878: exception
879: when NO_DATA_FOUND then

Line 1564: delete from per_absence_attendances a

1560: --
1561: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 3);
1562: --
1563: begin
1564: delete from per_absence_attendances a
1565: where a.person_id = P_PERSON_ID;
1566: exception
1567: when NO_DATA_FOUND then
1568: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 301);

Line 1574: update per_absence_attendances a

1570: --
1571: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4);
1572: --
1573: begin
1574: update per_absence_attendances a
1575: set a.authorising_person_id = null
1576: where a.authorising_person_id = P_PERSON_ID;
1577: exception
1578: when NO_DATA_FOUND then

Line 1585: update per_absence_attendances a

1581: --
1582: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 5);
1583: --
1584: begin
1585: update per_absence_attendances a
1586: set a.replacement_person_id = null
1587: where a.replacement_person_id = P_PERSON_ID;
1588: exception
1589: when NO_DATA_FOUND then