APPS.PER_PERSON_ANALYSES_PKG dependencies on PER_PERSON_ANALYSES

Line 1: PACKAGE BODY PER_PERSON_ANALYSES_PKG as

1: PACKAGE BODY PER_PERSON_ANALYSES_PKG as
2: /* $Header: pepea01t.pkb 115.6 2003/09/03 02:36:29 smparame ship $ */
3: /*===========================================================================+
4: | Copyright (c) 1993 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 34: from per_person_analyses pa

30: ,p_person_id number
31: ,p_rowid varchar2) is
32: cursor c is
33: select 'x'
34: from per_person_analyses pa
35: , per_analysis_criteria ac
36: where pa.analysis_criteria_id = p_analysis_criteria_id
37: and pa.business_group_id + 0 = p_bg_id
38: and pa.analysis_criteria_id = ac.analysis_criteria_id

Line 50: hr_utility.set_location('per_person_analyses_pkg.check_for_duplicates',1);

46: pa.rowid <> chartorowid(p_rowid)));
47: --
48: l_exists varchar2(1);
49: begin
50: hr_utility.set_location('per_person_analyses_pkg.check_for_duplicates',1);
51: open c;
52: fetch c into l_exists;
53: if c%found then
54: close c;

Line 70: select per_person_analyses_s.nextval

66: --
67: function get_unique_id return number is
68: l_id number;
69: cursor c is
70: select per_person_analyses_s.nextval
71: from sys.dual;
72: --
73: begin
74: open c;

Line 128: from per_person_analyses pa,

124: and rule_mode = to_char(p_id_flex_num);
125: --
126: cursor c_duplicate_case is
127: select 'X'
128: from per_person_analyses pa,
129: per_analysis_criteria ac
130: where pa.business_group_id + 0 = p_business_group_id
131: and pa.analysis_criteria_id = ac.analysis_criteria_id
132: and ac.id_flex_num = p_id_flex_num

Line 173: -- returns 'Y' if a per_person_analyses record exists.

169: --
170: -- POPULATE_INFO_EXISTS
171: --
172: -- function accepts flex structure id, person_id, and business group and
173: -- returns 'Y' if a per_person_analyses record exists.
174: --
175: FUNCTION populate_info_exists
176: ( p_id_flex_num in per_person_analyses.id_flex_num%TYPE
177: , p_person_id in per_person_analyses.person_id%TYPE

Line 176: ( p_id_flex_num in per_person_analyses.id_flex_num%TYPE

172: -- function accepts flex structure id, person_id, and business group and
173: -- returns 'Y' if a per_person_analyses record exists.
174: --
175: FUNCTION populate_info_exists
176: ( p_id_flex_num in per_person_analyses.id_flex_num%TYPE
177: , p_person_id in per_person_analyses.person_id%TYPE
178: , p_business_group_id in per_person_analyses.business_group_id%TYPE
179: ) RETURN VARCHAR2 IS
180: --

Line 177: , p_person_id in per_person_analyses.person_id%TYPE

173: -- returns 'Y' if a per_person_analyses record exists.
174: --
175: FUNCTION populate_info_exists
176: ( p_id_flex_num in per_person_analyses.id_flex_num%TYPE
177: , p_person_id in per_person_analyses.person_id%TYPE
178: , p_business_group_id in per_person_analyses.business_group_id%TYPE
179: ) RETURN VARCHAR2 IS
180: --
181: -- Bug fix 2863766

Line 178: , p_business_group_id in per_person_analyses.business_group_id%TYPE

174: --
175: FUNCTION populate_info_exists
176: ( p_id_flex_num in per_person_analyses.id_flex_num%TYPE
177: , p_person_id in per_person_analyses.person_id%TYPE
178: , p_business_group_id in per_person_analyses.business_group_id%TYPE
179: ) RETURN VARCHAR2 IS
180: --
181: -- Bug fix 2863766
182: -- where clause to check the id_flex_num in per_analysis_criteria table

Line 186: from per_person_analyses ppa,per_analysis_criteria pac

182: -- where clause to check the id_flex_num in per_analysis_criteria table
183: -- added to the cursor c_ppa.
184: cursor c_ppa is
185: select 'Y'
186: from per_person_analyses ppa,per_analysis_criteria pac
187: where ppa.id_flex_num = p_id_flex_num
188: and ppa.person_id = p_person_id
189: and ppa.business_group_id = p_business_group_id
190: and pac.analysis_criteria_id = ppa.analysis_criteria_id

Line 205: END PER_PERSON_ANALYSES_PKG;

201: return l_return;
202:
203: END populate_info_exists;
204: --
205: END PER_PERSON_ANALYSES_PKG;