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 858: from per_absence_attendances a

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

Line 874: from per_absence_attendances a

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

Line 1563: delete from per_absence_attendances a

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

Line 1573: update per_absence_attendances a

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

Line 1584: update per_absence_attendances a

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