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_APPRAISALS

Line 120: per_appraisals,

116: per_person_dlvry_methods
117: 115.4 07-Sep-98 smcmilla Added to delete_a_person to delete from
118: hr_quest_answer_values,
119: hr_quest_answers,
120: per_appraisals,
121: per_participants.
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...

Line 123: PER_APPRAISALS or PER_PARTICIPANTS.

119: hr_quest_answers,
120: per_appraisals,
121: per_participants.
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.

Line 209: HR_QUEST_ANSWER_VALUES and PER_APPRAISALS.

205: 115.41 19-JAN-2006 vbanner 4873360 Performance Fix of SQL ID:14959971
206: Rewrote Delete from HR_QUEST_ANSWER_VALUES
207: to avoid a cartesian join and a full
208: table scan on PER_PARTICIPANTS,
209: HR_QUEST_ANSWER_VALUES and PER_APPRAISALS.
210: Broke query into two peices using Conditional logic in a pl/sql block to see
211: if delete needs to be run.
212: 115.42 27-Jul-2006 pdkundu 5405424 Modified the procedure hr_person_delete.
213: moderate_predel_validation to change the

Line 908: from per_appraisals apr

904: into v_delete_permitted
905: from sys.dual
906: where not exists (
907: select null
908: from per_appraisals apr
909: where apr.appraisee_person_id = P_PERSON_ID
910: or apr.appraiser_person_id = P_PERSON_ID);
911: exception
912: when NO_DATA_FOUND then

Line 1644: -- PER_PARTICIPANTS, HR_QUEST_ANSWER_VALUES and PER_APPRAISALS

1640: --
1641: -- Bug 4873360 fix for performance repository sql id 14959971.
1642: -- Rewrote the delete query commented out below (and already once tuned for
1643: -- bug 3619599) to avoid a merge join cartesian and a full table scan on
1644: -- PER_PARTICIPANTS, HR_QUEST_ANSWER_VALUES and PER_APPRAISALS
1645: --
1646: -- Broke query into two peices using conditional logic in a pl/sql block to
1647: -- see if delete needs to be run.
1648: --

Line 1688: from per_appraisals apr

1684: into v_dummy
1685: from sys.dual
1686: where exists (
1687: select null
1688: from per_appraisals apr
1689: where (apr.appraiser_person_id = P_PERSON_ID
1690: or apr.appraisee_person_id = P_PERSON_ID));
1691:
1692: if v_dummy = 2

Line 1700: ,per_appraisals apr

1696: where qsv2.quest_answer_val_id in
1697: (select qsv.quest_answer_val_id
1698: from hr_quest_answer_values qsv
1699: ,hr_quest_answers qsa
1700: ,per_appraisals apr
1701: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
1702: and qsa.type_object_id = apr.appraisal_id
1703: and qsa.type='APPRAISAL'
1704: and (apr.appraisee_person_id = P_PERSON_ID

Line 1723: , per_appraisals apr

1719: where qsv2.quest_answer_val_id in (
1720: select qsv.quest_answer_val_id
1721: from hr_quest_answer_values qsv
1722: , hr_quest_answers qsa
1723: , per_appraisals apr
1724: , per_participants par
1725: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
1726: and (qsa.type_object_id = apr.appraisal_id
1727: and qsa.type='APPRAISAL'

Line 1750: FROM per_appraisals

1746: WHERE scorecard_id IN (SELECT scorecard_id
1747: FROM per_personal_scorecards
1748: WHERE person_id = P_PERSON_ID)
1749: OR appraisal_id in (SELECT appraisal_id
1750: FROM per_appraisals
1751: WHERE appraisee_person_id = p_person_id) ;
1752:
1753: DELETE
1754: FROM per_scorecard_sharing

Line 1790: FROM per_appraisals

1786: FROM per_competence_elements
1787: WHERE assessment_id IN (SELECT assessment_id
1788: FROM per_assessments
1789: WHERE appraisal_id IN (SELECT appraisal_id
1790: FROM per_appraisals
1791: WHERE appraisee_person_id = P_PERSON_ID));
1792: DELETE
1793: FROM per_performance_ratings
1794: WHERE appraisal_id IN (SELECT appraisal_id

Line 1795: FROM per_appraisals

1791: WHERE appraisee_person_id = P_PERSON_ID));
1792: DELETE
1793: FROM per_performance_ratings
1794: WHERE appraisal_id IN (SELECT appraisal_id
1795: FROM per_appraisals
1796: WHERE appraisee_person_id = P_PERSON_ID);
1797: DELETE
1798: FROM per_assessments
1799: WHERE appraisal_id IN (SELECT appraisal_id

Line 1800: FROM per_appraisals

1796: WHERE appraisee_person_id = P_PERSON_ID);
1797: DELETE
1798: FROM per_assessments
1799: WHERE appraisal_id IN (SELECT appraisal_id
1800: FROM per_appraisals
1801: WHERE appraisee_person_id = P_PERSON_ID);
1802:
1803: EXCEPTION
1804: WHEN Others Then

Line 1815: , per_appraisals apr

1811: where qsa2.questionnaire_answer_id in (
1812: select qsa.questionnaire_answer_id
1813: from hr_quest_answers qsa
1814: , per_participants par
1815: , per_appraisals apr
1816: where (qsa.type_object_id = apr.appraisal_id
1817: and qsa.type='APPRAISAL'
1818: and (apr.appraiser_person_id = P_PERSON_ID
1819: or apr.appraisee_person_id = P_PERSON_ID))

Line 1838: AND par2.participation_in_table = 'PER_APPRAISALS'

1834: WHERE par2.person_id = P_PERSON_ID
1835: OR
1836: (
1837: par2.participation_in_column = 'APPRAISAL_ID'
1838: AND par2.participation_in_table = 'PER_APPRAISALS'
1839: AND par2.participation_in_id in
1840: (
1841: SELECT
1842: apr.appraisal_id

Line 1843: FROM per_appraisals apr

1839: AND par2.participation_in_id in
1840: (
1841: SELECT
1842: apr.appraisal_id
1843: FROM per_appraisals apr
1844: WHERE
1845: (
1846: apr.appraisee_person_id = P_PERSON_ID
1847: OR apr.appraiser_person_id = P_PERSON_ID

Line 1856: -- Now delete from per_appraisals

1852: when NO_DATA_FOUND then
1853: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 1103);
1854: end;
1855: --
1856: -- Now delete from per_appraisals
1857: --
1858: begin
1859: delete from per_appraisals apr
1860: where --apr.appraiser_person_id = P_PERSON_ID or -- changed as part of bug#8265994

Line 1859: delete from per_appraisals apr

1855: --
1856: -- Now delete from per_appraisals
1857: --
1858: begin
1859: delete from per_appraisals apr
1860: where --apr.appraiser_person_id = P_PERSON_ID or -- changed as part of bug#8265994
1861: apr.appraisee_person_id = P_PERSON_ID;
1862: exception
1863: when NO_DATA_FOUND then