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 HR_QUEST_ANSWER_VALUES

Line 118: hr_quest_answer_values,

114: PTU records when person deleted.
115: 115.3 13-Aug-98 I Harding Delete records from the table
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

Line 182: hr_quest_answer_values and hr_quest_answers

178: validation Code in procedure
179: moderate_pre_del_validation as this check
180: is not required for CWK.
181: 115.31 12-May-2004 bdivvela 3619599 Modified delete queries on tables
182: hr_quest_answer_values and hr_quest_answers
183: in delete_a_person procedure
184: 115.32 07-Jun-2004 sbuche 3598568 Modified delete_a_person and people_default_deletes
185: procedures to call hr_security.delete_per_from_list
186: procedure for deleting a record in static list

Line 206: Rewrote Delete from HR_QUEST_ANSWER_VALUES

202: 115.39 04-Jan-2006 bshukla 4889068 Performance Fix of SQL ID:14960008
203: 115.40 04-Jan-2006 bshukla 4889068 Performance Fix of SQL ID:14961062,14961042
204: and 14960478
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

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 1643: -- PER_PARTICIPANTS, HR_QUEST_ANSWER_VALUES and PER_APPRAISALS

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

Line 1648: begin -- Delete from HR_QUEST_ANSWER_VALUES

1644: --
1645: -- Broke query into two peices using conditional logic in a pl/sql block to
1646: -- see if delete needs to be run.
1647: --
1648: begin -- Delete from HR_QUEST_ANSWER_VALUES
1649: begin -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
1650: select 1
1651: into v_dummy
1652: from sys.dual

Line 1649: begin -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS

1645: -- Broke query into two peices using conditional logic in a pl/sql block to
1646: -- see if delete needs to be run.
1647: --
1648: begin -- Delete from HR_QUEST_ANSWER_VALUES
1649: begin -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
1650: select 1
1651: into v_dummy
1652: from sys.dual
1653: where exists (

Line 1661: delete from hr_quest_answer_values qsv2

1657:
1658: if v_dummy = 1
1659: then
1660: v_dummy := null;
1661: delete from hr_quest_answer_values qsv2
1662: where qsv2.quest_answer_val_id in
1663: (select qsv.quest_answer_val_id
1664: from hr_quest_answer_values qsv
1665: ,hr_quest_answers qsa

Line 1664: from hr_quest_answer_values qsv

1660: v_dummy := null;
1661: delete from hr_quest_answer_values qsv2
1662: where qsv2.quest_answer_val_id in
1663: (select qsv.quest_answer_val_id
1664: from hr_quest_answer_values qsv
1665: ,hr_quest_answers qsa
1666: ,per_participants par
1667: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
1668: and qsa.type_object_id = par.participant_id

Line 1679: end; -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS

1675: when NO_DATA_FOUND then
1676: v_dummy := null;
1677: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 211);
1678: /*End of bug 5464252*/
1679: end; -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
1680:
1681: begin -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
1682: select 2
1683: into v_dummy

Line 1681: begin -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS

1677: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 211);
1678: /*End of bug 5464252*/
1679: end; -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
1680:
1681: begin -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
1682: select 2
1683: into v_dummy
1684: from sys.dual
1685: where exists (

Line 1694: delete from hr_quest_answer_values qsv2

1690:
1691: if v_dummy = 2
1692: then
1693: v_dummy := null;
1694: delete from hr_quest_answer_values qsv2
1695: where qsv2.quest_answer_val_id in
1696: (select qsv.quest_answer_val_id
1697: from hr_quest_answer_values qsv
1698: ,hr_quest_answers qsa

Line 1697: from hr_quest_answer_values qsv

1693: v_dummy := null;
1694: delete from hr_quest_answer_values qsv2
1695: where qsv2.quest_answer_val_id in
1696: (select qsv.quest_answer_val_id
1697: from hr_quest_answer_values qsv
1698: ,hr_quest_answers qsa
1699: ,per_appraisals apr
1700: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
1701: and qsa.type_object_id = apr.appraisal_id

Line 1712: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS

1708: when NO_DATA_FOUND then
1709: v_dummy := null;
1710: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 220);
1711: /* end of bug 5464252 */
1712: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
1713: end; -- Delete from HR_QUEST_ANSWER_VALUES
1714: -- original sql.
1715: -- begin
1716: -- Delete from HR_QUEST_ANSWER_VALUES

Line 1713: end; -- Delete from HR_QUEST_ANSWER_VALUES

1709: v_dummy := null;
1710: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 220);
1711: /* end of bug 5464252 */
1712: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
1713: end; -- Delete from HR_QUEST_ANSWER_VALUES
1714: -- original sql.
1715: -- begin
1716: -- Delete from HR_QUEST_ANSWER_VALUES
1717: /* delete from hr_quest_answer_values qsv2

Line 1716: -- Delete from HR_QUEST_ANSWER_VALUES

1712: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
1713: end; -- Delete from HR_QUEST_ANSWER_VALUES
1714: -- original sql.
1715: -- begin
1716: -- Delete from HR_QUEST_ANSWER_VALUES
1717: /* delete from hr_quest_answer_values qsv2
1718: where qsv2.quest_answer_val_id in (
1719: select qsv.quest_answer_val_id
1720: from hr_quest_answer_values qsv

Line 1717: /* delete from hr_quest_answer_values qsv2

1713: end; -- Delete from HR_QUEST_ANSWER_VALUES
1714: -- original sql.
1715: -- begin
1716: -- Delete from HR_QUEST_ANSWER_VALUES
1717: /* delete from hr_quest_answer_values qsv2
1718: where qsv2.quest_answer_val_id in (
1719: select qsv.quest_answer_val_id
1720: from hr_quest_answer_values qsv
1721: , hr_quest_answers qsa

Line 1720: from hr_quest_answer_values qsv

1716: -- Delete from HR_QUEST_ANSWER_VALUES
1717: /* delete from hr_quest_answer_values qsv2
1718: where qsv2.quest_answer_val_id in (
1719: select qsv.quest_answer_val_id
1720: from hr_quest_answer_values qsv
1721: , hr_quest_answers qsa
1722: , per_appraisals apr
1723: , per_participants par
1724: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id