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 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 1649: begin -- Delete from HR_QUEST_ANSWER_VALUES

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: --
1649: begin -- Delete from HR_QUEST_ANSWER_VALUES
1650: begin -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
1651: select 1
1652: into v_dummy
1653: from sys.dual

Line 1650: begin -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS

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

Line 1662: delete from hr_quest_answer_values qsv2

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

Line 1665: from hr_quest_answer_values qsv

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

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

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

Line 1682: begin -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS

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

Line 1695: delete from hr_quest_answer_values qsv2

1691:
1692: if v_dummy = 2
1693: then
1694: v_dummy := null;
1695: delete from hr_quest_answer_values qsv2
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

Line 1698: from hr_quest_answer_values qsv

1694: v_dummy := null;
1695: delete from hr_quest_answer_values qsv2
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

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

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

Line 1714: end; -- Delete from HR_QUEST_ANSWER_VALUES

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

Line 1717: -- Delete from HR_QUEST_ANSWER_VALUES

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

Line 1718: /* delete from hr_quest_answer_values qsv2

1714: end; -- Delete from HR_QUEST_ANSWER_VALUES
1715: -- original sql.
1716: -- begin
1717: -- Delete from HR_QUEST_ANSWER_VALUES
1718: /* delete from hr_quest_answer_values qsv2
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

Line 1721: from hr_quest_answer_values qsv

1717: -- Delete from HR_QUEST_ANSWER_VALUES
1718: /* delete from hr_quest_answer_values qsv2
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