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_ALL_ASSIGNMENTS_F

Line 126: per_all_people_f and per_all_assignments_f

122: 115.5 08-SEP-98 smcmilla Disallow delete if orws exist in
123: PER_APPRAISALS or PER_PARTICIPANTS.
124: Change made to moderate_predel...
125: 115.6 17-MAR-1999 mmillmor 814301 Altered DELETE_A_PERSON to delete from
126: per_all_people_f and per_all_assignments_f
127: 115.7 18-MAR-98 CColeman Added WIP pre-del validation.
128: 115.8 13-APR-99 CCarter 800050 Added pre-del validation for the
129: following products ENG, AP, FA, PO
130: and RCV.

Line 1483: type assignmentid is table of per_all_assignments_f.assignment_id%type index by binary_integer;

1479:
1480: -- bug fix 3732129 starts here.
1481: -- to improve performance assignment id fetched into a pl/sql table.
1482:
1483: type assignmentid is table of per_all_assignments_f.assignment_id%type index by binary_integer;
1484: l_assignment_id assignmentid;
1485:
1486: Cursor c_asg is
1487: select distinct assignment_id

Line 2499: delete from per_all_assignments_f a

2495: --
2496: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 43);
2497: --
2498: begin
2499: delete from per_all_assignments_f a
2500: where a.person_id = P_PERSON_ID;
2501: exception
2502: when NO_DATA_FOUND then
2503: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4001);