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.GHR_SF52_DO_UPDATE dependencies on HR_API

Line 20: ,p_information1 IN varchar2 default hr_api.g_varchar2

16: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE
17: ,p_l_information_type IN varchar2
18: ,p_extra_info_id IN number
19: ,p_l_object_version_number IN out nocopy number
20: ,p_information1 IN varchar2 default hr_api.g_varchar2
21: ,p_information2 IN varchar2 default hr_api.g_varchar2
22: ,p_information3 IN varchar2 default hr_api.g_varchar2
23: ,p_information4 IN varchar2 default hr_api.g_varchar2
24: ,p_information5 IN varchar2 default hr_api.g_varchar2

Line 21: ,p_information2 IN varchar2 default hr_api.g_varchar2

17: ,p_l_information_type IN varchar2
18: ,p_extra_info_id IN number
19: ,p_l_object_version_number IN out nocopy number
20: ,p_information1 IN varchar2 default hr_api.g_varchar2
21: ,p_information2 IN varchar2 default hr_api.g_varchar2
22: ,p_information3 IN varchar2 default hr_api.g_varchar2
23: ,p_information4 IN varchar2 default hr_api.g_varchar2
24: ,p_information5 IN varchar2 default hr_api.g_varchar2
25: ,p_information6 IN varchar2 default hr_api.g_varchar2

Line 22: ,p_information3 IN varchar2 default hr_api.g_varchar2

18: ,p_extra_info_id IN number
19: ,p_l_object_version_number IN out nocopy number
20: ,p_information1 IN varchar2 default hr_api.g_varchar2
21: ,p_information2 IN varchar2 default hr_api.g_varchar2
22: ,p_information3 IN varchar2 default hr_api.g_varchar2
23: ,p_information4 IN varchar2 default hr_api.g_varchar2
24: ,p_information5 IN varchar2 default hr_api.g_varchar2
25: ,p_information6 IN varchar2 default hr_api.g_varchar2
26: ,p_Information7 IN varchar2 default hr_api.g_varchar2

Line 23: ,p_information4 IN varchar2 default hr_api.g_varchar2

19: ,p_l_object_version_number IN out nocopy number
20: ,p_information1 IN varchar2 default hr_api.g_varchar2
21: ,p_information2 IN varchar2 default hr_api.g_varchar2
22: ,p_information3 IN varchar2 default hr_api.g_varchar2
23: ,p_information4 IN varchar2 default hr_api.g_varchar2
24: ,p_information5 IN varchar2 default hr_api.g_varchar2
25: ,p_information6 IN varchar2 default hr_api.g_varchar2
26: ,p_Information7 IN varchar2 default hr_api.g_varchar2
27: ,p_information8 IN varchar2 default hr_api.g_varchar2

Line 24: ,p_information5 IN varchar2 default hr_api.g_varchar2

20: ,p_information1 IN varchar2 default hr_api.g_varchar2
21: ,p_information2 IN varchar2 default hr_api.g_varchar2
22: ,p_information3 IN varchar2 default hr_api.g_varchar2
23: ,p_information4 IN varchar2 default hr_api.g_varchar2
24: ,p_information5 IN varchar2 default hr_api.g_varchar2
25: ,p_information6 IN varchar2 default hr_api.g_varchar2
26: ,p_Information7 IN varchar2 default hr_api.g_varchar2
27: ,p_information8 IN varchar2 default hr_api.g_varchar2
28: ,p_information9 IN varchar2 default hr_api.g_varchar2

Line 25: ,p_information6 IN varchar2 default hr_api.g_varchar2

21: ,p_information2 IN varchar2 default hr_api.g_varchar2
22: ,p_information3 IN varchar2 default hr_api.g_varchar2
23: ,p_information4 IN varchar2 default hr_api.g_varchar2
24: ,p_information5 IN varchar2 default hr_api.g_varchar2
25: ,p_information6 IN varchar2 default hr_api.g_varchar2
26: ,p_Information7 IN varchar2 default hr_api.g_varchar2
27: ,p_information8 IN varchar2 default hr_api.g_varchar2
28: ,p_information9 IN varchar2 default hr_api.g_varchar2
29: ,p_information10 IN varchar2 default hr_api.g_varchar2

Line 26: ,p_Information7 IN varchar2 default hr_api.g_varchar2

22: ,p_information3 IN varchar2 default hr_api.g_varchar2
23: ,p_information4 IN varchar2 default hr_api.g_varchar2
24: ,p_information5 IN varchar2 default hr_api.g_varchar2
25: ,p_information6 IN varchar2 default hr_api.g_varchar2
26: ,p_Information7 IN varchar2 default hr_api.g_varchar2
27: ,p_information8 IN varchar2 default hr_api.g_varchar2
28: ,p_information9 IN varchar2 default hr_api.g_varchar2
29: ,p_information10 IN varchar2 default hr_api.g_varchar2
30: ,p_information11 IN varchar2 default hr_api.g_varchar2

Line 27: ,p_information8 IN varchar2 default hr_api.g_varchar2

23: ,p_information4 IN varchar2 default hr_api.g_varchar2
24: ,p_information5 IN varchar2 default hr_api.g_varchar2
25: ,p_information6 IN varchar2 default hr_api.g_varchar2
26: ,p_Information7 IN varchar2 default hr_api.g_varchar2
27: ,p_information8 IN varchar2 default hr_api.g_varchar2
28: ,p_information9 IN varchar2 default hr_api.g_varchar2
29: ,p_information10 IN varchar2 default hr_api.g_varchar2
30: ,p_information11 IN varchar2 default hr_api.g_varchar2
31: ,p_information12 IN varchar2 default hr_api.g_varchar2

Line 28: ,p_information9 IN varchar2 default hr_api.g_varchar2

24: ,p_information5 IN varchar2 default hr_api.g_varchar2
25: ,p_information6 IN varchar2 default hr_api.g_varchar2
26: ,p_Information7 IN varchar2 default hr_api.g_varchar2
27: ,p_information8 IN varchar2 default hr_api.g_varchar2
28: ,p_information9 IN varchar2 default hr_api.g_varchar2
29: ,p_information10 IN varchar2 default hr_api.g_varchar2
30: ,p_information11 IN varchar2 default hr_api.g_varchar2
31: ,p_information12 IN varchar2 default hr_api.g_varchar2
32: ,p_information13 IN varchar2 default hr_api.g_varchar2

Line 29: ,p_information10 IN varchar2 default hr_api.g_varchar2

25: ,p_information6 IN varchar2 default hr_api.g_varchar2
26: ,p_Information7 IN varchar2 default hr_api.g_varchar2
27: ,p_information8 IN varchar2 default hr_api.g_varchar2
28: ,p_information9 IN varchar2 default hr_api.g_varchar2
29: ,p_information10 IN varchar2 default hr_api.g_varchar2
30: ,p_information11 IN varchar2 default hr_api.g_varchar2
31: ,p_information12 IN varchar2 default hr_api.g_varchar2
32: ,p_information13 IN varchar2 default hr_api.g_varchar2
33: ,p_information14 IN varchar2 default hr_api.g_varchar2

Line 30: ,p_information11 IN varchar2 default hr_api.g_varchar2

26: ,p_Information7 IN varchar2 default hr_api.g_varchar2
27: ,p_information8 IN varchar2 default hr_api.g_varchar2
28: ,p_information9 IN varchar2 default hr_api.g_varchar2
29: ,p_information10 IN varchar2 default hr_api.g_varchar2
30: ,p_information11 IN varchar2 default hr_api.g_varchar2
31: ,p_information12 IN varchar2 default hr_api.g_varchar2
32: ,p_information13 IN varchar2 default hr_api.g_varchar2
33: ,p_information14 IN varchar2 default hr_api.g_varchar2
34: ,p_information15 IN varchar2 default hr_api.g_varchar2

Line 31: ,p_information12 IN varchar2 default hr_api.g_varchar2

27: ,p_information8 IN varchar2 default hr_api.g_varchar2
28: ,p_information9 IN varchar2 default hr_api.g_varchar2
29: ,p_information10 IN varchar2 default hr_api.g_varchar2
30: ,p_information11 IN varchar2 default hr_api.g_varchar2
31: ,p_information12 IN varchar2 default hr_api.g_varchar2
32: ,p_information13 IN varchar2 default hr_api.g_varchar2
33: ,p_information14 IN varchar2 default hr_api.g_varchar2
34: ,p_information15 IN varchar2 default hr_api.g_varchar2
35: ,p_information16 IN varchar2 default hr_api.g_varchar2

Line 32: ,p_information13 IN varchar2 default hr_api.g_varchar2

28: ,p_information9 IN varchar2 default hr_api.g_varchar2
29: ,p_information10 IN varchar2 default hr_api.g_varchar2
30: ,p_information11 IN varchar2 default hr_api.g_varchar2
31: ,p_information12 IN varchar2 default hr_api.g_varchar2
32: ,p_information13 IN varchar2 default hr_api.g_varchar2
33: ,p_information14 IN varchar2 default hr_api.g_varchar2
34: ,p_information15 IN varchar2 default hr_api.g_varchar2
35: ,p_information16 IN varchar2 default hr_api.g_varchar2
36: ,p_information17 IN varchar2 default hr_api.g_varchar2

Line 33: ,p_information14 IN varchar2 default hr_api.g_varchar2

29: ,p_information10 IN varchar2 default hr_api.g_varchar2
30: ,p_information11 IN varchar2 default hr_api.g_varchar2
31: ,p_information12 IN varchar2 default hr_api.g_varchar2
32: ,p_information13 IN varchar2 default hr_api.g_varchar2
33: ,p_information14 IN varchar2 default hr_api.g_varchar2
34: ,p_information15 IN varchar2 default hr_api.g_varchar2
35: ,p_information16 IN varchar2 default hr_api.g_varchar2
36: ,p_information17 IN varchar2 default hr_api.g_varchar2
37: ,p_information18 IN varchar2 default hr_api.g_varchar2

Line 34: ,p_information15 IN varchar2 default hr_api.g_varchar2

30: ,p_information11 IN varchar2 default hr_api.g_varchar2
31: ,p_information12 IN varchar2 default hr_api.g_varchar2
32: ,p_information13 IN varchar2 default hr_api.g_varchar2
33: ,p_information14 IN varchar2 default hr_api.g_varchar2
34: ,p_information15 IN varchar2 default hr_api.g_varchar2
35: ,p_information16 IN varchar2 default hr_api.g_varchar2
36: ,p_information17 IN varchar2 default hr_api.g_varchar2
37: ,p_information18 IN varchar2 default hr_api.g_varchar2
38: ,p_information19 IN varchar2 default hr_api.g_varchar2

Line 35: ,p_information16 IN varchar2 default hr_api.g_varchar2

31: ,p_information12 IN varchar2 default hr_api.g_varchar2
32: ,p_information13 IN varchar2 default hr_api.g_varchar2
33: ,p_information14 IN varchar2 default hr_api.g_varchar2
34: ,p_information15 IN varchar2 default hr_api.g_varchar2
35: ,p_information16 IN varchar2 default hr_api.g_varchar2
36: ,p_information17 IN varchar2 default hr_api.g_varchar2
37: ,p_information18 IN varchar2 default hr_api.g_varchar2
38: ,p_information19 IN varchar2 default hr_api.g_varchar2
39: ,p_information20 IN varchar2 default hr_api.g_varchar2

Line 36: ,p_information17 IN varchar2 default hr_api.g_varchar2

32: ,p_information13 IN varchar2 default hr_api.g_varchar2
33: ,p_information14 IN varchar2 default hr_api.g_varchar2
34: ,p_information15 IN varchar2 default hr_api.g_varchar2
35: ,p_information16 IN varchar2 default hr_api.g_varchar2
36: ,p_information17 IN varchar2 default hr_api.g_varchar2
37: ,p_information18 IN varchar2 default hr_api.g_varchar2
38: ,p_information19 IN varchar2 default hr_api.g_varchar2
39: ,p_information20 IN varchar2 default hr_api.g_varchar2
40: ,p_information21 IN varchar2 default hr_api.g_varchar2

Line 37: ,p_information18 IN varchar2 default hr_api.g_varchar2

33: ,p_information14 IN varchar2 default hr_api.g_varchar2
34: ,p_information15 IN varchar2 default hr_api.g_varchar2
35: ,p_information16 IN varchar2 default hr_api.g_varchar2
36: ,p_information17 IN varchar2 default hr_api.g_varchar2
37: ,p_information18 IN varchar2 default hr_api.g_varchar2
38: ,p_information19 IN varchar2 default hr_api.g_varchar2
39: ,p_information20 IN varchar2 default hr_api.g_varchar2
40: ,p_information21 IN varchar2 default hr_api.g_varchar2
41: ,p_information22 IN varchar2 default hr_api.g_varchar2

Line 38: ,p_information19 IN varchar2 default hr_api.g_varchar2

34: ,p_information15 IN varchar2 default hr_api.g_varchar2
35: ,p_information16 IN varchar2 default hr_api.g_varchar2
36: ,p_information17 IN varchar2 default hr_api.g_varchar2
37: ,p_information18 IN varchar2 default hr_api.g_varchar2
38: ,p_information19 IN varchar2 default hr_api.g_varchar2
39: ,p_information20 IN varchar2 default hr_api.g_varchar2
40: ,p_information21 IN varchar2 default hr_api.g_varchar2
41: ,p_information22 IN varchar2 default hr_api.g_varchar2
42: ,p_information23 IN varchar2 default hr_api.g_varchar2

Line 39: ,p_information20 IN varchar2 default hr_api.g_varchar2

35: ,p_information16 IN varchar2 default hr_api.g_varchar2
36: ,p_information17 IN varchar2 default hr_api.g_varchar2
37: ,p_information18 IN varchar2 default hr_api.g_varchar2
38: ,p_information19 IN varchar2 default hr_api.g_varchar2
39: ,p_information20 IN varchar2 default hr_api.g_varchar2
40: ,p_information21 IN varchar2 default hr_api.g_varchar2
41: ,p_information22 IN varchar2 default hr_api.g_varchar2
42: ,p_information23 IN varchar2 default hr_api.g_varchar2
43: ,p_information24 IN varchar2 default hr_api.g_varchar2

Line 40: ,p_information21 IN varchar2 default hr_api.g_varchar2

36: ,p_information17 IN varchar2 default hr_api.g_varchar2
37: ,p_information18 IN varchar2 default hr_api.g_varchar2
38: ,p_information19 IN varchar2 default hr_api.g_varchar2
39: ,p_information20 IN varchar2 default hr_api.g_varchar2
40: ,p_information21 IN varchar2 default hr_api.g_varchar2
41: ,p_information22 IN varchar2 default hr_api.g_varchar2
42: ,p_information23 IN varchar2 default hr_api.g_varchar2
43: ,p_information24 IN varchar2 default hr_api.g_varchar2
44: ,p_information25 IN varchar2 default hr_api.g_varchar2

Line 41: ,p_information22 IN varchar2 default hr_api.g_varchar2

37: ,p_information18 IN varchar2 default hr_api.g_varchar2
38: ,p_information19 IN varchar2 default hr_api.g_varchar2
39: ,p_information20 IN varchar2 default hr_api.g_varchar2
40: ,p_information21 IN varchar2 default hr_api.g_varchar2
41: ,p_information22 IN varchar2 default hr_api.g_varchar2
42: ,p_information23 IN varchar2 default hr_api.g_varchar2
43: ,p_information24 IN varchar2 default hr_api.g_varchar2
44: ,p_information25 IN varchar2 default hr_api.g_varchar2
45: ,p_information26 IN varchar2 default hr_api.g_varchar2

Line 42: ,p_information23 IN varchar2 default hr_api.g_varchar2

38: ,p_information19 IN varchar2 default hr_api.g_varchar2
39: ,p_information20 IN varchar2 default hr_api.g_varchar2
40: ,p_information21 IN varchar2 default hr_api.g_varchar2
41: ,p_information22 IN varchar2 default hr_api.g_varchar2
42: ,p_information23 IN varchar2 default hr_api.g_varchar2
43: ,p_information24 IN varchar2 default hr_api.g_varchar2
44: ,p_information25 IN varchar2 default hr_api.g_varchar2
45: ,p_information26 IN varchar2 default hr_api.g_varchar2
46: ,p_information27 IN varchar2 default hr_api.g_varchar2

Line 43: ,p_information24 IN varchar2 default hr_api.g_varchar2

39: ,p_information20 IN varchar2 default hr_api.g_varchar2
40: ,p_information21 IN varchar2 default hr_api.g_varchar2
41: ,p_information22 IN varchar2 default hr_api.g_varchar2
42: ,p_information23 IN varchar2 default hr_api.g_varchar2
43: ,p_information24 IN varchar2 default hr_api.g_varchar2
44: ,p_information25 IN varchar2 default hr_api.g_varchar2
45: ,p_information26 IN varchar2 default hr_api.g_varchar2
46: ,p_information27 IN varchar2 default hr_api.g_varchar2
47: ,p_information28 IN varchar2 default hr_api.g_varchar2

Line 44: ,p_information25 IN varchar2 default hr_api.g_varchar2

40: ,p_information21 IN varchar2 default hr_api.g_varchar2
41: ,p_information22 IN varchar2 default hr_api.g_varchar2
42: ,p_information23 IN varchar2 default hr_api.g_varchar2
43: ,p_information24 IN varchar2 default hr_api.g_varchar2
44: ,p_information25 IN varchar2 default hr_api.g_varchar2
45: ,p_information26 IN varchar2 default hr_api.g_varchar2
46: ,p_information27 IN varchar2 default hr_api.g_varchar2
47: ,p_information28 IN varchar2 default hr_api.g_varchar2
48: ,p_information29 IN varchar2 default hr_api.g_varchar2

Line 45: ,p_information26 IN varchar2 default hr_api.g_varchar2

41: ,p_information22 IN varchar2 default hr_api.g_varchar2
42: ,p_information23 IN varchar2 default hr_api.g_varchar2
43: ,p_information24 IN varchar2 default hr_api.g_varchar2
44: ,p_information25 IN varchar2 default hr_api.g_varchar2
45: ,p_information26 IN varchar2 default hr_api.g_varchar2
46: ,p_information27 IN varchar2 default hr_api.g_varchar2
47: ,p_information28 IN varchar2 default hr_api.g_varchar2
48: ,p_information29 IN varchar2 default hr_api.g_varchar2
49: ,p_information30 IN varchar2 default hr_api.g_varchar2) is

Line 46: ,p_information27 IN varchar2 default hr_api.g_varchar2

42: ,p_information23 IN varchar2 default hr_api.g_varchar2
43: ,p_information24 IN varchar2 default hr_api.g_varchar2
44: ,p_information25 IN varchar2 default hr_api.g_varchar2
45: ,p_information26 IN varchar2 default hr_api.g_varchar2
46: ,p_information27 IN varchar2 default hr_api.g_varchar2
47: ,p_information28 IN varchar2 default hr_api.g_varchar2
48: ,p_information29 IN varchar2 default hr_api.g_varchar2
49: ,p_information30 IN varchar2 default hr_api.g_varchar2) is
50:

Line 47: ,p_information28 IN varchar2 default hr_api.g_varchar2

43: ,p_information24 IN varchar2 default hr_api.g_varchar2
44: ,p_information25 IN varchar2 default hr_api.g_varchar2
45: ,p_information26 IN varchar2 default hr_api.g_varchar2
46: ,p_information27 IN varchar2 default hr_api.g_varchar2
47: ,p_information28 IN varchar2 default hr_api.g_varchar2
48: ,p_information29 IN varchar2 default hr_api.g_varchar2
49: ,p_information30 IN varchar2 default hr_api.g_varchar2) is
50:
51: --

Line 48: ,p_information29 IN varchar2 default hr_api.g_varchar2

44: ,p_information25 IN varchar2 default hr_api.g_varchar2
45: ,p_information26 IN varchar2 default hr_api.g_varchar2
46: ,p_information27 IN varchar2 default hr_api.g_varchar2
47: ,p_information28 IN varchar2 default hr_api.g_varchar2
48: ,p_information29 IN varchar2 default hr_api.g_varchar2
49: ,p_information30 IN varchar2 default hr_api.g_varchar2) is
50:
51: --
52: l_proc varchar2(70) := 'Generic Update Extra Info';

Line 49: ,p_information30 IN varchar2 default hr_api.g_varchar2) is

45: ,p_information26 IN varchar2 default hr_api.g_varchar2
46: ,p_information27 IN varchar2 default hr_api.g_varchar2
47: ,p_information28 IN varchar2 default hr_api.g_varchar2
48: ,p_information29 IN varchar2 default hr_api.g_varchar2
49: ,p_information30 IN varchar2 default hr_api.g_varchar2) is
50:
51: --
52: l_proc varchar2(70) := 'Generic Update Extra Info';
53: l_id number;

Line 58: l_extra_info_rec ghr_api.extra_info_rec_type;

54: l_ovn number;
55: l_initial_ovn number;
56: l_index varchar2(10);
57: l_extra_info_id number(15);
58: l_extra_info_rec ghr_api.extra_info_rec_type;
59: --
60: l_asg_cre_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
61: l_asg_cre_ovn per_assignment_extra_info.object_version_number%type;
62: l_per_cre_extra_info_id per_people_extra_info.person_extra_info_id%type;

Line 162: -- extra information, with all the parameters defaulted to hr_api.g_varchar2

158:
159: -- The foll. code sets the information to null , if they get passed in as null
160: -- and is then used in case of create Extr Info .This was done so that
161: -- we could work with just one procedure for both update as well as create of
162: -- extra information, with all the parameters defaulted to hr_api.g_varchar2
163: -- therby ensuring that while updating, none of the existing data gets over-written.
164:
165: l_extra_info_id := p_extra_info_id;
166: hr_utility.set_location('l_extra_info_id is ' ||l_extra_info_id || ' ' || l_proc,8);

Line 167: If p_information1 = hr_api.g_varchar2 THEN

163: -- therby ensuring that while updating, none of the existing data gets over-written.
164:
165: l_extra_info_id := p_extra_info_id;
166: hr_utility.set_location('l_extra_info_id is ' ||l_extra_info_id || ' ' || l_proc,8);
167: If p_information1 = hr_api.g_varchar2 THEN
168: l_information1 := null;
169: Else
170: l_information1 := p_information1;
171: End if;

Line 172: IF p_information2 = hr_api.g_varchar2 THEN

168: l_information1 := null;
169: Else
170: l_information1 := p_information1;
171: End if;
172: IF p_information2 = hr_api.g_varchar2 THEN
173: l_information2 := null;
174: Else
175: l_information2 := p_information2;
176: End if;

Line 177: IF p_information3 = hr_api.g_varchar2 THEN

173: l_information2 := null;
174: Else
175: l_information2 := p_information2;
176: End if;
177: IF p_information3 = hr_api.g_varchar2 THEN
178: l_information3 := null;
179: ELSE
180: l_information3 := p_information3;
181: END IF;

Line 182: IF p_information4 = hr_api.g_varchar2 THEN

178: l_information3 := null;
179: ELSE
180: l_information3 := p_information3;
181: END IF;
182: IF p_information4 = hr_api.g_varchar2 THEN
183: l_information4 := null;
184: ELSE
185: l_information4 := p_information4;
186: END IF;

Line 187: IF p_information5 = hr_api.g_varchar2 THEN

183: l_information4 := null;
184: ELSE
185: l_information4 := p_information4;
186: END IF;
187: IF p_information5 = hr_api.g_varchar2 THEN
188: l_information5 := null;
189: ELSE
190: l_information5 := p_information5;
191: END IF;

Line 192: IF p_information6 = hr_api.g_varchar2 THEN

188: l_information5 := null;
189: ELSE
190: l_information5 := p_information5;
191: END IF;
192: IF p_information6 = hr_api.g_varchar2 THEN
193: l_information6 := null;
194: ELSE
195: l_information6 := p_information6;
196: END IF;

Line 197: IF p_information7 = hr_api.g_varchar2 THEN

193: l_information6 := null;
194: ELSE
195: l_information6 := p_information6;
196: END IF;
197: IF p_information7 = hr_api.g_varchar2 THEN
198: l_information7 := null;
199: ELSE
200: l_information7 := p_information7;
201: END IF;

Line 202: IF p_information8 = hr_api.g_varchar2 THEN

198: l_information7 := null;
199: ELSE
200: l_information7 := p_information7;
201: END IF;
202: IF p_information8 = hr_api.g_varchar2 THEN
203: l_information8 := null;
204: ELSE
205: l_information8 := p_information8;
206: END IF;

Line 207: IF p_information9 = hr_api.g_varchar2 THEN

203: l_information8 := null;
204: ELSE
205: l_information8 := p_information8;
206: END IF;
207: IF p_information9 = hr_api.g_varchar2 THEN
208: l_information9 := null;
209: ELSE
210: l_information9 := p_information9;
211: END IF;

Line 212: IF p_information10 = hr_api.g_varchar2 THEN

208: l_information9 := null;
209: ELSE
210: l_information9 := p_information9;
211: END IF;
212: IF p_information10 = hr_api.g_varchar2 THEN
213: l_information10 := null;
214: ELSE
215: l_information10 := p_information10;
216: END IF;

Line 217: IF p_information11 = hr_api.g_varchar2 THEN

213: l_information10 := null;
214: ELSE
215: l_information10 := p_information10;
216: END IF;
217: IF p_information11 = hr_api.g_varchar2 THEN
218: l_information11 := null;
219: ELSE
220: l_information11 := p_information11;
221: END IF;

Line 222: IF p_information12 = hr_api.g_varchar2 THEN

218: l_information11 := null;
219: ELSE
220: l_information11 := p_information11;
221: END IF;
222: IF p_information12 = hr_api.g_varchar2 THEN
223: l_information12 := null;
224: ELSE
225: l_information12 := p_information12;
226: END IF;

Line 227: IF p_information13 = hr_api.g_varchar2 THEN

223: l_information12 := null;
224: ELSE
225: l_information12 := p_information12;
226: END IF;
227: IF p_information13 = hr_api.g_varchar2 THEN
228: l_information13 := null;
229: ELSE
230: l_information13 := p_information13;
231: END IF;

Line 232: IF p_information14 = hr_api.g_varchar2 THEN

228: l_information13 := null;
229: ELSE
230: l_information13 := p_information13;
231: END IF;
232: IF p_information14 = hr_api.g_varchar2 THEN
233: l_information14 := null;
234: ELSE
235: l_information14 := p_information14;
236: END IF;

Line 237: IF p_information15 = hr_api.g_varchar2 THEN

233: l_information14 := null;
234: ELSE
235: l_information14 := p_information14;
236: END IF;
237: IF p_information15 = hr_api.g_varchar2 THEN
238: l_information15 := null;
239: ELSE
240: l_information15 := p_information15;
241: END IF;

Line 242: IF p_information16 = hr_api.g_varchar2 THEN

238: l_information15 := null;
239: ELSE
240: l_information15 := p_information15;
241: END IF;
242: IF p_information16 = hr_api.g_varchar2 THEN
243: l_information16 := null;
244: ELSE
245: l_information16 := p_information16;
246: END IF;

Line 247: IF p_information17 = hr_api.g_varchar2 THEN

243: l_information16 := null;
244: ELSE
245: l_information16 := p_information16;
246: END IF;
247: IF p_information17 = hr_api.g_varchar2 THEN
248: l_information17 := null;
249: ELSE
250: l_information17 := p_information17;
251: END IF;

Line 252: IF p_information18 = hr_api.g_varchar2 THEN

248: l_information17 := null;
249: ELSE
250: l_information17 := p_information17;
251: END IF;
252: IF p_information18 = hr_api.g_varchar2 THEN
253: l_information18 := null;
254: ELSE
255: l_information18 := p_information18;
256: END IF;

Line 257: IF p_information19 = hr_api.g_varchar2 THEN

253: l_information18 := null;
254: ELSE
255: l_information18 := p_information18;
256: END IF;
257: IF p_information19 = hr_api.g_varchar2 THEN
258: l_information19 := null;
259: ELSE
260: l_information19 := p_information19;
261: END IF;

Line 262: IF p_information20 = hr_api.g_varchar2 THEN

258: l_information19 := null;
259: ELSE
260: l_information19 := p_information19;
261: END IF;
262: IF p_information20 = hr_api.g_varchar2 THEN
263: l_information20 := null;
264: ELSE
265: l_information20 := p_information20;
266: END IF;

Line 267: IF p_information21 = hr_api.g_varchar2 THEN

263: l_information20 := null;
264: ELSE
265: l_information20 := p_information20;
266: END IF;
267: IF p_information21 = hr_api.g_varchar2 THEN
268: l_information21 := null;
269: ELSE
270: l_information21 := p_information21;
271: END IF;

Line 272: IF p_information22 = hr_api.g_varchar2 THEN

268: l_information21 := null;
269: ELSE
270: l_information21 := p_information21;
271: END IF;
272: IF p_information22 = hr_api.g_varchar2 THEN
273: l_information22 := null;
274: ELSE
275: l_information22 := p_information22;
276: END IF;

Line 277: IF p_information23 = hr_api.g_varchar2 THEN

273: l_information22 := null;
274: ELSE
275: l_information22 := p_information22;
276: END IF;
277: IF p_information23 = hr_api.g_varchar2 THEN
278: l_information23 := null;
279: ELSE
280: l_information23 := p_information23;
281: END IF;

Line 282: IF p_information24 = hr_api.g_varchar2 THEN

278: l_information23 := null;
279: ELSE
280: l_information23 := p_information23;
281: END IF;
282: IF p_information24 = hr_api.g_varchar2 THEN
283: l_information24 := null;
284: ELSE
285: l_information24 := p_information24;
286: END IF;

Line 287: IF p_information25 = hr_api.g_varchar2 THEN

283: l_information24 := null;
284: ELSE
285: l_information24 := p_information24;
286: END IF;
287: IF p_information25 = hr_api.g_varchar2 THEN
288: l_information25 := null;
289: ELSE
290: l_information25 := p_information25;
291: END IF;

Line 292: IF p_information26 = hr_api.g_varchar2 THEN

288: l_information25 := null;
289: ELSE
290: l_information25 := p_information25;
291: END IF;
292: IF p_information26 = hr_api.g_varchar2 THEN
293: l_information26 := null;
294: ELSE
295: l_information26 := p_information26;
296: END IF;

Line 297: IF p_information27 = hr_api.g_varchar2 THEN

293: l_information26 := null;
294: ELSE
295: l_information26 := p_information26;
296: END IF;
297: IF p_information27 = hr_api.g_varchar2 THEN
298: l_information27 := null;
299: ELSE
300: l_information27 := p_information27;
301: END IF;

Line 302: IF p_information28 = hr_api.g_varchar2 THEN

298: l_information27 := null;
299: ELSE
300: l_information27 := p_information27;
301: END IF;
302: IF p_information28 = hr_api.g_varchar2 THEN
303: l_information28 := null;
304: ELSE
305: l_information28 := p_information28;
306: END IF;

Line 307: IF p_information29 = hr_api.g_varchar2 THEN

303: l_information28 := null;
304: ELSE
305: l_information28 := p_information28;
306: END IF;
307: IF p_information29 = hr_api.g_varchar2 THEN
308: l_information29 := null;
309: ELSE
310: l_information29 := p_information29;
311: END IF;

Line 312: IF p_information30 = hr_api.g_varchar2 THEN

308: l_information29 := null;
309: ELSE
310: l_information29 := p_information29;
311: END IF;
312: IF p_information30 = hr_api.g_varchar2 THEN
313: l_information30 := null;
314: ELSE
315: l_information30 := p_information30;
316: END IF;

Line 624: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE) IS

620: End Generic_Update_Extra_Info;
621:
622: Procedure Update_Retained_Grade
623: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE ,
624: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE) IS
625: --
626: --
627: cursor c_702_rec is
628: select rei_information3,pei_information1,

Line 636: and nvl(rei.rei_information30,hr_api.g_varchar2) <> 'Original RPA';

632: where pa_request_id = p_pa_request_rec.pa_request_id
633: and pei.person_extra_info_id = rei.rei_information3
634: and pei.information_type = 'GHR_US_RETAINED_GRADE'
635: and rei.information_type = 'GHR_US_PAR_TERM_RG_PROMO'
636: and nvl(rei.rei_information30,hr_api.g_varchar2) <> 'Original RPA';
637: --
638: cursor c_740_rec is
639: select rei_information3,pei_information1,
640: pei.object_version_number ovn

Line 648: and nvl(rei.rei_information30,hr_api.g_varchar2) <> 'Original RPA';

644: and pei.person_extra_info_id = rei.rei_information3
645: and pei.information_type = 'GHR_US_RETAINED_GRADE'
646: and rei.information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
647: and (rei.rei_information5 is null or rei.rei_information5 = 'Y')
648: and nvl(rei.rei_information30,hr_api.g_varchar2) <> 'Original RPA';
649:
650:
651: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
652: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;

Line 678: l_per_retained_grade GHR_API.Per_retained_grade_TYPE;

674: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
675:
676: l_session ghr_history_api.g_session_var_type;
677: l_proc varchar2(70) := 'Update_Retained_Grade';
678: l_per_retained_grade GHR_API.Per_retained_grade_TYPE;
679: -- Bug#4698321 Added pei_information1 to the cursor.
680: Cursor c_retained_grade_ovn is
681: select object_version_number,
682: pei_information1,

Line 1021: l_special_info ghr_api.special_information_type;

1017: l_academic_discipline ghr_pa_requests.academic_discipline%type;
1018: l_object_version_number number(9);
1019: l_multiple varchar2(1);
1020: l_session ghr_history_api.g_session_var_type;
1021: l_special_info ghr_api.special_information_type;
1022:
1023:
1024:
1025: -- Cursor to fetch the id_flex_num for the "US Fed Education" structure

Line 1199: If nvl(l_education_level,hr_api.g_varchar2) <> nvl(p_pa_request_rec.education_level,hr_api.g_varchar2) or

1195: hr_utility.set_location('p_pa_request_rec.education_level is '||p_pa_request_rec.education_level,46);
1196: hr_utility.set_location('p_pa_request_rec.academic_discipline is '||p_pa_request_rec.academic_discipline,46);
1197: hr_utility.set_location('p_pa_request_rec.year_degree_attained is '||p_pa_request_rec.year_degree_attained,46);
1198:
1199: If nvl(l_education_level,hr_api.g_varchar2) <> nvl(p_pa_request_rec.education_level,hr_api.g_varchar2) or
1200: nvl(l_academic_discipline,hr_api.g_varchar2) <> nvl(p_pa_request_rec.academic_discipline,hr_api.g_varchar2) or
1201: to_char(nvl(l_year_degree_attained,hr_api.g_number)) <> to_char(nvl(p_pa_request_rec.year_degree_attained,hr_api.g_number)) then
1202:
1203: -- Commented out by skutteti for bug # 655203 as multiple occurences flag need not be checked for edu sit.

Line 1200: nvl(l_academic_discipline,hr_api.g_varchar2) <> nvl(p_pa_request_rec.academic_discipline,hr_api.g_varchar2) or

1196: hr_utility.set_location('p_pa_request_rec.academic_discipline is '||p_pa_request_rec.academic_discipline,46);
1197: hr_utility.set_location('p_pa_request_rec.year_degree_attained is '||p_pa_request_rec.year_degree_attained,46);
1198:
1199: If nvl(l_education_level,hr_api.g_varchar2) <> nvl(p_pa_request_rec.education_level,hr_api.g_varchar2) or
1200: nvl(l_academic_discipline,hr_api.g_varchar2) <> nvl(p_pa_request_rec.academic_discipline,hr_api.g_varchar2) or
1201: to_char(nvl(l_year_degree_attained,hr_api.g_number)) <> to_char(nvl(p_pa_request_rec.year_degree_attained,hr_api.g_number)) then
1202:
1203: -- Commented out by skutteti for bug # 655203 as multiple occurences flag need not be checked for edu sit.
1204: -- If nvl(l_multiple,'Y') = 'Y' and l_session.noa_id_correct is null then

Line 1201: to_char(nvl(l_year_degree_attained,hr_api.g_number)) <> to_char(nvl(p_pa_request_rec.year_degree_attained,hr_api.g_number)) then

1197: hr_utility.set_location('p_pa_request_rec.year_degree_attained is '||p_pa_request_rec.year_degree_attained,46);
1198:
1199: If nvl(l_education_level,hr_api.g_varchar2) <> nvl(p_pa_request_rec.education_level,hr_api.g_varchar2) or
1200: nvl(l_academic_discipline,hr_api.g_varchar2) <> nvl(p_pa_request_rec.academic_discipline,hr_api.g_varchar2) or
1201: to_char(nvl(l_year_degree_attained,hr_api.g_number)) <> to_char(nvl(p_pa_request_rec.year_degree_attained,hr_api.g_number)) then
1202:
1203: -- Commented out by skutteti for bug # 655203 as multiple occurences flag need not be checked for edu sit.
1204: -- If nvl(l_multiple,'Y') = 'Y' and l_session.noa_id_correct is null then
1205:

Line 1250: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,

1246: -- *************************
1247: --
1248: Procedure call_extra_info_api
1249: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1250: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,

Line 1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,

1247: --
1248: Procedure call_extra_info_api
1249: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1250: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,

Line 1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,

1248: Procedure call_extra_info_api
1249: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1250: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,

Line 1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,

1249: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1250: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,

Line 1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,

1250: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,

Line 1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,

1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,

Line 1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,

1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,

Line 1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,

1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1261: --Bug#4486823 RRR Changes

Line 1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,

1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1261: --Bug#4486823 RRR Changes
1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,

Line 1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,

1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1261: --Bug#4486823 RRR Changes
1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,

Line 1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,

1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1261: --Bug#4486823 RRR Changes
1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1264: -- BEN_EIT Changes

Line 1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,

1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1261: --Bug#4486823 RRR Changes
1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1264: -- BEN_EIT Changes
1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,

Line 1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,

1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1261: --Bug#4486823 RRR Changes
1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1264: -- BEN_EIT Changes
1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,

Line 1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,

1261: --Bug#4486823 RRR Changes
1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1264: -- BEN_EIT Changes
1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,

Line 1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,

1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1264: -- BEN_EIT Changes
1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,

Line 1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,

1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1264: -- BEN_EIT Changes
1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,

Line 1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,

1264: -- BEN_EIT Changes
1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,

Line 1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,

1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,

Line 1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,

1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,

Line 1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,

1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,

Line 1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,

1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,

Line 1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,

1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,

Line 1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,

1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1278: -- Bug #6312144 New RPA EIT Benefits

Line 1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,

1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1278: -- Bug #6312144 New RPA EIT Benefits
1279: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,

Line 1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,

1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1278: -- Bug #6312144 New RPA EIT Benefits
1279: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,
1280: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is

Line 1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,

1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1278: -- Bug #6312144 New RPA EIT Benefits
1279: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,
1280: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is
1281:

Line 1279: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,

1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1278: -- Bug #6312144 New RPA EIT Benefits
1279: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,
1280: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is
1281:
1282: --
1283: l_proc varchar2(70) := 'Call Extra Info';

Line 1280: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is

1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1278: -- Bug #6312144 New RPA EIT Benefits
1279: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,
1280: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is
1281:
1282: --
1283: l_proc varchar2(70) := 'Call Extra Info';
1284: l_segment_rec ghr_api.special_information_type;

Line 1284: l_segment_rec ghr_api.special_information_type;

1280: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is
1281:
1282: --
1283: l_proc varchar2(70) := 'Call Extra Info';
1284: l_segment_rec ghr_api.special_information_type;
1285: l_form_field_name varchar2(50);
1286: l_posn_title_pm varchar2(50);
1287: l_WS_pm varchar2(50);
1288: l_DS_pm varchar2(50);

Line 1461: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;

1457: l_Cur_Appt_Auth_desc2 per_people_extra_info.pei_information23%type;
1458: --Bug# 4941984(AFHR2)
1459:
1460: -- No copy Changes variables.
1461: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;

Line 1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;

1458: --Bug# 4941984(AFHR2)
1459:
1460: -- No copy Changes variables.
1461: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;

Line 1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;

1459:
1460: -- No copy Changes variables.
1461: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;

Line 1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;

1460: -- No copy Changes variables.
1461: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;

Line 1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;

1461: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;

Line 1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;

1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;

Line 1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;

1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;

Line 1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;

1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes

Line 1469: l_Per_probations GHR_API.Per_probations_TYPE;

1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes
1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;

Line 1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;

1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes
1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1474: l_Per_conversions GHR_API.Per_conversions_TYPE;

Line 1471: l_Per_security GHR_API.Per_security_TYPE;

1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes
1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1474: l_Per_conversions GHR_API.Per_conversions_TYPE;
1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes

Line 1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;

1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes
1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1474: l_Per_conversions GHR_API.Per_conversions_TYPE;
1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;

Line 1474: l_Per_conversions GHR_API.Per_conversions_TYPE;

1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes
1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1474: l_Per_conversions GHR_API.Per_conversions_TYPE;
1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;

Line 1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes

1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes
1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1474: l_Per_conversions GHR_API.Per_conversions_TYPE;
1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;

Line 1477: l_per_benefit_info GHR_API.per_benefit_info_type;

1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1474: l_Per_conversions GHR_API.Per_conversions_TYPE;
1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;

Line 1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;

1474: l_Per_conversions GHR_API.Per_conversions_TYPE;
1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;

Line 1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;

1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;

Line 1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;

1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;

Line 1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;

1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;

Line 1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;

1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;

Line 1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;

1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;
1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;

Line 1484: l_Perf_appraisal ghr_api.performance_appraisal_type;

1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;
1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1488: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;

Line 1485: l_conduct_performance ghr_api.conduct_performance_type;

1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;
1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1488: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1489: ---for bug 3267632

Line 1486: l_Loc_Info GHR_API.Loc_Info_TYPE;

1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;
1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1488: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1489: ---for bug 3267632
1490: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;

Line 1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;

1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;
1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1488: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1489: ---for bug 3267632
1490: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;
1491: --

Line 1488: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;

1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;
1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1488: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1489: ---for bug 3267632
1490: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;
1491: --
1492: -- Bug 3390876

Line 2061: AND nvl(p_pa_request_rec.to_position_id,hr_api.g_number) <>

2057: END Loop;
2058:
2059: hr_utility.set_location('To Posn PM ' || l_posn_title_pm ,81);
2060: IF p_pa_request_rec.to_position_id IS NOT NULL AND l_posn_title_pm in ('APUE','UE')
2061: AND nvl(p_pa_request_rec.to_position_id,hr_api.g_number) <>
2062: nvl(p_pa_request_rec.from_position_id,hr_api.g_number)
2063: OR p_pa_request_rec.to_position_id IS NOT NULL AND l_WS_pm in ('APUE','UE')
2064: OR nvl(p_pa_request_rec.first_noa_code,hr_api.g_number) = '782'
2065: OR nvl(p_pa_request_rec.second_noa_code,hr_api.g_number) = '782'

Line 2062: nvl(p_pa_request_rec.from_position_id,hr_api.g_number)

2058:
2059: hr_utility.set_location('To Posn PM ' || l_posn_title_pm ,81);
2060: IF p_pa_request_rec.to_position_id IS NOT NULL AND l_posn_title_pm in ('APUE','UE')
2061: AND nvl(p_pa_request_rec.to_position_id,hr_api.g_number) <>
2062: nvl(p_pa_request_rec.from_position_id,hr_api.g_number)
2063: OR p_pa_request_rec.to_position_id IS NOT NULL AND l_WS_pm in ('APUE','UE')
2064: OR nvl(p_pa_request_rec.first_noa_code,hr_api.g_number) = '782'
2065: OR nvl(p_pa_request_rec.second_noa_code,hr_api.g_number) = '782'
2066: THEN

Line 2064: OR nvl(p_pa_request_rec.first_noa_code,hr_api.g_number) = '782'

2060: IF p_pa_request_rec.to_position_id IS NOT NULL AND l_posn_title_pm in ('APUE','UE')
2061: AND nvl(p_pa_request_rec.to_position_id,hr_api.g_number) <>
2062: nvl(p_pa_request_rec.from_position_id,hr_api.g_number)
2063: OR p_pa_request_rec.to_position_id IS NOT NULL AND l_WS_pm in ('APUE','UE')
2064: OR nvl(p_pa_request_rec.first_noa_code,hr_api.g_number) = '782'
2065: OR nvl(p_pa_request_rec.second_noa_code,hr_api.g_number) = '782'
2066: THEN
2067: hr_utility.set_location('Posn Update With WS/PTH' || l_posn_title_pm ,81);
2068:

Line 2065: OR nvl(p_pa_request_rec.second_noa_code,hr_api.g_number) = '782'

2061: AND nvl(p_pa_request_rec.to_position_id,hr_api.g_number) <>
2062: nvl(p_pa_request_rec.from_position_id,hr_api.g_number)
2063: OR p_pa_request_rec.to_position_id IS NOT NULL AND l_WS_pm in ('APUE','UE')
2064: OR nvl(p_pa_request_rec.first_noa_code,hr_api.g_number) = '782'
2065: OR nvl(p_pa_request_rec.second_noa_code,hr_api.g_number) = '782'
2066: THEN
2067: hr_utility.set_location('Posn Update With WS/PTH' || l_posn_title_pm ,81);
2068:
2069: ---------------------------- bug#2623692

Line 2424: and nvl(ast.business_group_id,hr_api.g_number) = hr_api.g_number

2420: ast.active_flag
2421: from per_assignment_status_types ast
2422: where ast.per_system_status = l_system_status
2423: and ast.user_status like '%' || l_user_status || '%'
2424: and nvl(ast.business_group_id,hr_api.g_number) = hr_api.g_number
2425: and ast.legislation_code = 'US';
2426:
2427: cursor c_asg_status_type_471 is
2428: select ast.assignment_status_type_id,

Line 2434: and nvl(ast.business_group_id,hr_api.g_number) = hr_api.g_number

2430: from per_assignment_status_types ast
2431: where ast.per_system_status = l_system_status
2432: and ast.user_status like '%' || l_user_status || '%'
2433: and instr(ast.user_status,'NTE') = 0
2434: and nvl(ast.business_group_id,hr_api.g_number) = hr_api.g_number
2435: and ast.legislation_code = 'US';
2436: -- Bug# 4672772 Begin
2437: l_user_apnt_status per_assignment_status_types.user_status%type;
2438: l_user_apnt_eff_date date;

Line 3501: IF nvl(p_pa_request_rec.duty_station_location_id,hr_api.g_number)

3497: -- Start Bug 1613367
3498: For ovn in asg_ovn(p_pa_request_rec.employee_assignment_id) loop
3499: l_temp_asg_loc_id := ovn.location_id;
3500: End loop;
3501: IF nvl(p_pa_request_rec.duty_station_location_id,hr_api.g_number)
3502: <> nvl(l_temp_asg_loc_id,hr_api.g_number) then
3503: l_position_data_rec_type.location_id := p_pa_request_rec.duty_station_location_id;
3504: ELSE
3505: l_position_data_rec_type.location_id := NULL;

Line 3502: <> nvl(l_temp_asg_loc_id,hr_api.g_number) then

3498: For ovn in asg_ovn(p_pa_request_rec.employee_assignment_id) loop
3499: l_temp_asg_loc_id := ovn.location_id;
3500: End loop;
3501: IF nvl(p_pa_request_rec.duty_station_location_id,hr_api.g_number)
3502: <> nvl(l_temp_asg_loc_id,hr_api.g_number) then
3503: l_position_data_rec_type.location_id := p_pa_request_rec.duty_station_location_id;
3504: ELSE
3505: l_position_data_rec_type.location_id := NULL;
3506: END IF;

Line 3720: If nvl(p_pa_request_rec.From_Position_Id, hr_api.g_number) <>

3716: l_activate_flag := 'Y';
3717: End if;
3718:
3719: -- Code added by skutteti on 13-jul-98 bug #699856
3720: If nvl(p_pa_request_rec.From_Position_Id, hr_api.g_number) <>
3721: nvl(p_pa_request_rec.to_position_id, hr_api.g_number) then
3722: l_employee_api_update_criteria := 'Y';
3723: l_update_gre := 'Y';
3724: end if;

Line 3721: nvl(p_pa_request_rec.to_position_id, hr_api.g_number) then

3717: End if;
3718:
3719: -- Code added by skutteti on 13-jul-98 bug #699856
3720: If nvl(p_pa_request_rec.From_Position_Id, hr_api.g_number) <>
3721: nvl(p_pa_request_rec.to_position_id, hr_api.g_number) then
3722: l_employee_api_update_criteria := 'Y';
3723: l_update_gre := 'Y';
3724: end if;
3725:

Line 3736: If nvl(p_pa_request_rec.From_Position_Id,hr_api.g_number) <> P_pa_request_rec.to_position_id

3732: l_employee_api_update_criteria := 'Y';
3733: l_update_gre := 'Y'; -- Added Venkat Bug # 1239688
3734: End if;
3735: If p_pa_request_rec.to_position_id is not null then
3736: If nvl(p_pa_request_rec.From_Position_Id,hr_api.g_number) <> P_pa_request_rec.to_position_id
3737: then
3738: hr_utility.set_location('Non Appointment -- To pos <> From Pos - GRE ' ||l_proc,41);
3739: l_employee_api_update_criteria := 'Y';
3740: l_update_gre := 'Y';

Line 3777: nvl(p_pa_request_rec.from_grade_or_level,hr_api.g_varchar2) <> p_pa_request_rec.to_grade_or_level then

3773: -- of the change in position for NOA 713 (change to lower grade)
3774: --
3775: --if l_noa_family_code = 'SALARY_CHG' then
3776: if p_pa_request_rec.to_grade_or_level is not null and
3777: nvl(p_pa_request_rec.from_grade_or_level,hr_api.g_varchar2) <> p_pa_request_rec.to_grade_or_level then
3778: l_employee_api_update_criteria := 'Y';
3779: end if;
3780: --
3781: -- Update of Pay Plan GG to Assignmentn 855 processing.

Line 3792: IF nvl(p_pa_request_rec.from_pay_plan,hr_api.g_varchar2) <> p_pa_request_rec.to_pay_plan then

3788: l_noa_family_code = 'REASSIGNMENT' --Bug# 7209120
3789: OR
3790: l_noa_family_code like 'GHR_SAL%' THEN
3791:
3792: IF nvl(p_pa_request_rec.from_pay_plan,hr_api.g_varchar2) <> p_pa_request_rec.to_pay_plan then
3793: l_employee_api_update_criteria := 'Y';
3794: END IF;
3795: END IF;
3796: --

Line 3844: OR (nvl(P_pa_request_rec.to_grade_id,hr_api.g_number) <> nvl(l_grade_id,hr_api.g_number)))

3840: hr_utility.set_location('l_grade id for the new position '||l_grade_id,875);
3841: --Bug# 6010971, added grade_id condition
3842: IF l_asg_position IS NOT NULL
3843: AND ((l_position_id <> l_asg_position)
3844: OR (nvl(P_pa_request_rec.to_grade_id,hr_api.g_number) <> nvl(l_grade_id,hr_api.g_number)))
3845: THEN
3846: hr_utility.set_location('To pos <> Assg Pos ' ||l_proc,650);
3847: l_employee_api_update_criteria := 'Y';
3848: END IF;

Line 3902: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and

3898: hr_utility.set_location('l_REGION_2 ' ||substr(l_REGION_2,1,40),73 );
3899: hr_utility.set_location('l_POSTAL_CODE ' ||l_POSTAL_CODE,74 );
3900: hr_utility.set_location('l_COUNTRY ' ||substr(l_COUNTRY,1,40),75 );
3901: IF l_session.noa_id_correct is null THEN
3902: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
3903: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
3904: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3905: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3906: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and

Line 3903: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and

3899: hr_utility.set_location('l_POSTAL_CODE ' ||l_POSTAL_CODE,74 );
3900: hr_utility.set_location('l_COUNTRY ' ||substr(l_COUNTRY,1,40),75 );
3901: IF l_session.noa_id_correct is null THEN
3902: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
3903: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
3904: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3905: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3906: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
3907: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and

Line 3904: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and

3900: hr_utility.set_location('l_COUNTRY ' ||substr(l_COUNTRY,1,40),75 );
3901: IF l_session.noa_id_correct is null THEN
3902: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
3903: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
3904: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3905: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3906: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
3907: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
3908: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN

Line 3905: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and

3901: IF l_session.noa_id_correct is null THEN
3902: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
3903: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
3904: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3905: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3906: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
3907: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
3908: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
3909: null;

Line 3906: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and

3902: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
3903: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
3904: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3905: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3906: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
3907: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
3908: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
3909: null;
3910: hr_utility.set_location('Non Correction -- No Action ' || l_proc,76);

Line 3907: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and

3903: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
3904: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3905: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3906: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
3907: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
3908: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
3909: null;
3910: hr_utility.set_location('Non Correction -- No Action ' || l_proc,76);
3911: ELSE

Line 3908: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN

3904: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3905: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3906: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
3907: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
3908: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
3909: null;
3910: hr_utility.set_location('Non Correction -- No Action ' || l_proc,76);
3911: ELSE
3912: l_create_address := 'Y';

Line 3924: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and

3920: fetch c_upd_primary_address into l_address_id;
3921: hr_utility.set_location('address_id is ' || l_address_id, 66);
3922:
3923: IF c_upd_primary_address%NOTFOUND then
3924: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
3925: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
3926: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3927: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3928: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and

Line 3925: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and

3921: hr_utility.set_location('address_id is ' || l_address_id, 66);
3922:
3923: IF c_upd_primary_address%NOTFOUND then
3924: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
3925: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
3926: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3927: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3928: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
3929: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and

Line 3926: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and

3922:
3923: IF c_upd_primary_address%NOTFOUND then
3924: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
3925: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
3926: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3927: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3928: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
3929: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
3930: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN

Line 3927: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and

3923: IF c_upd_primary_address%NOTFOUND then
3924: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
3925: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
3926: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3927: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3928: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
3929: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
3930: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
3931: NULL;

Line 3928: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and

3924: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
3925: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
3926: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3927: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3928: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
3929: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
3930: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
3931: NULL;
3932: hr_utility.set_location('Correction -- No Action ' || l_proc,69);

Line 3929: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and

3925: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
3926: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3927: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3928: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
3929: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
3930: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
3931: NULL;
3932: hr_utility.set_location('Correction -- No Action ' || l_proc,69);
3933: ELSE

Line 3930: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN

3926: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
3927: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
3928: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
3929: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
3930: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
3931: NULL;
3932: hr_utility.set_location('Correction -- No Action ' || l_proc,69);
3933: ELSE
3934: l_create_address := 'Y';

Line 4035: and nvl(termination_flag,hr_api.g_varchar2) = 'Y';

4031: -- Start Changes for 3150551
4032: /*
4033: delete from per_person_list_changes
4034: where person_id = p_pa_request_rec.person_id
4035: and nvl(termination_flag,hr_api.g_varchar2) = 'Y';
4036: */
4037: hr_security_internal.clear_from_person_list_changes
4038: ( p_person_id => p_pa_request_rec.person_id );
4039: -- End Changes for 3150551

Line 4108: IF nvl(P_pa_request_rec.to_grade_id,hr_api.g_number) <> nvl(l_grade_id,hr_api.g_number) then

4104: hr_utility.set_location('Assignment status type id '|| l_asg_status_type_id,997);
4105: l_activate_flag := 'Y';
4106: -- Bug 2839332
4107: --Bug# 6010971
4108: IF nvl(P_pa_request_rec.to_grade_id,hr_api.g_number) <> nvl(l_grade_id,hr_api.g_number) then
4109: l_employee_api_update_criteria := 'Y';
4110: end if;
4111: --Bug# 6010971
4112: ELSE --(l_noa_family_code = 'RETURN_TO_DUTY')

Line 4161: If nvl(p_pa_request_rec.duty_station_location_id,hr_api.g_number) <> nvl(l_asg_location_id,hr_api.g_number) then

4157: end if;
4158: --Pradeep end of bug #4148743
4159:
4160:
4161: If nvl(p_pa_request_rec.duty_station_location_id,hr_api.g_number) <> nvl(l_asg_location_id,hr_api.g_number) then
4162: l_employee_api_update_criteria := 'Y';
4163: End if;
4164:
4165: --

Line 4641: if nvl(p_pa_request_rec.employee_national_identifier,hr_api.g_varchar2) <> nvl(l_per_national_identifier,hr_api.g_varchar2) or

4637: l_per_date_of_birth := per.date_of_birth;
4638: end loop;
4639: hr_utility.set_location(l_proc,138);
4640:
4641: if nvl(p_pa_request_rec.employee_national_identifier,hr_api.g_varchar2) <> nvl(l_per_national_identifier,hr_api.g_varchar2) or
4642: nvl(p_pa_request_rec.employee_date_of_birth,hr_api.g_date) <> nvl(l_per_date_of_birth,hr_api.g_date) or
4643: nvl(p_pa_request_rec.employee_last_name,hr_api.g_varchar2) <> nvl(l_per_last_name,hr_api.g_varchar2) or
4644: nvl(p_pa_request_rec.employee_first_name,hr_api.g_varchar2) <> nvl(l_per_first_name,hr_api.g_varchar2)or
4645: nvl(p_pa_request_rec.employee_middle_names,hr_api.g_varchar2) <> nvl(l_per_middle_names,hr_api.g_varchar2) then

Line 4642: nvl(p_pa_request_rec.employee_date_of_birth,hr_api.g_date) <> nvl(l_per_date_of_birth,hr_api.g_date) or

4638: end loop;
4639: hr_utility.set_location(l_proc,138);
4640:
4641: if nvl(p_pa_request_rec.employee_national_identifier,hr_api.g_varchar2) <> nvl(l_per_national_identifier,hr_api.g_varchar2) or
4642: nvl(p_pa_request_rec.employee_date_of_birth,hr_api.g_date) <> nvl(l_per_date_of_birth,hr_api.g_date) or
4643: nvl(p_pa_request_rec.employee_last_name,hr_api.g_varchar2) <> nvl(l_per_last_name,hr_api.g_varchar2) or
4644: nvl(p_pa_request_rec.employee_first_name,hr_api.g_varchar2) <> nvl(l_per_first_name,hr_api.g_varchar2)or
4645: nvl(p_pa_request_rec.employee_middle_names,hr_api.g_varchar2) <> nvl(l_per_middle_names,hr_api.g_varchar2) then
4646:

Line 4643: nvl(p_pa_request_rec.employee_last_name,hr_api.g_varchar2) <> nvl(l_per_last_name,hr_api.g_varchar2) or

4639: hr_utility.set_location(l_proc,138);
4640:
4641: if nvl(p_pa_request_rec.employee_national_identifier,hr_api.g_varchar2) <> nvl(l_per_national_identifier,hr_api.g_varchar2) or
4642: nvl(p_pa_request_rec.employee_date_of_birth,hr_api.g_date) <> nvl(l_per_date_of_birth,hr_api.g_date) or
4643: nvl(p_pa_request_rec.employee_last_name,hr_api.g_varchar2) <> nvl(l_per_last_name,hr_api.g_varchar2) or
4644: nvl(p_pa_request_rec.employee_first_name,hr_api.g_varchar2) <> nvl(l_per_first_name,hr_api.g_varchar2)or
4645: nvl(p_pa_request_rec.employee_middle_names,hr_api.g_varchar2) <> nvl(l_per_middle_names,hr_api.g_varchar2) then
4646:
4647: l_update_mode := return_update_mode

Line 4644: nvl(p_pa_request_rec.employee_first_name,hr_api.g_varchar2) <> nvl(l_per_first_name,hr_api.g_varchar2)or

4640:
4641: if nvl(p_pa_request_rec.employee_national_identifier,hr_api.g_varchar2) <> nvl(l_per_national_identifier,hr_api.g_varchar2) or
4642: nvl(p_pa_request_rec.employee_date_of_birth,hr_api.g_date) <> nvl(l_per_date_of_birth,hr_api.g_date) or
4643: nvl(p_pa_request_rec.employee_last_name,hr_api.g_varchar2) <> nvl(l_per_last_name,hr_api.g_varchar2) or
4644: nvl(p_pa_request_rec.employee_first_name,hr_api.g_varchar2) <> nvl(l_per_first_name,hr_api.g_varchar2)or
4645: nvl(p_pa_request_rec.employee_middle_names,hr_api.g_varchar2) <> nvl(l_per_middle_names,hr_api.g_varchar2) then
4646:
4647: l_update_mode := return_update_mode
4648: (p_id => p_pa_request_rec.person_id,

Line 4645: nvl(p_pa_request_rec.employee_middle_names,hr_api.g_varchar2) <> nvl(l_per_middle_names,hr_api.g_varchar2) then

4641: if nvl(p_pa_request_rec.employee_national_identifier,hr_api.g_varchar2) <> nvl(l_per_national_identifier,hr_api.g_varchar2) or
4642: nvl(p_pa_request_rec.employee_date_of_birth,hr_api.g_date) <> nvl(l_per_date_of_birth,hr_api.g_date) or
4643: nvl(p_pa_request_rec.employee_last_name,hr_api.g_varchar2) <> nvl(l_per_last_name,hr_api.g_varchar2) or
4644: nvl(p_pa_request_rec.employee_first_name,hr_api.g_varchar2) <> nvl(l_per_first_name,hr_api.g_varchar2)or
4645: nvl(p_pa_request_rec.employee_middle_names,hr_api.g_varchar2) <> nvl(l_per_middle_names,hr_api.g_varchar2) then
4646:
4647: l_update_mode := return_update_mode
4648: (p_id => p_pa_request_rec.person_id,
4649: p_effective_date => p_pa_request_rec.effective_date,

Line 4715: nvl(p_pa_request_rec.to_position_id,hr_api.g_number) <> nvl(p_pa_request_rec.from_position_id,hr_api.g_number)) OR

4711:
4712: hr_utility.set_location('To Posn PM ' || l_posn_title_pm ,151);
4713: IF l_posn_title_pm = 'UE' OR
4714: (l_posn_title_pm = 'APUE' AND
4715: nvl(p_pa_request_rec.to_position_id,hr_api.g_number) <> nvl(p_pa_request_rec.from_position_id,hr_api.g_number)) OR
4716: l_DS_pm in ('APUE','UE') OR
4717: (p_pa_request_rec.effective_date >= to_date('2007/01/07','YYYY/MM/DD') AND p_pa_request_rec.first_noa_code = '894') THEN
4718: ghr_sf52_pos_update.update_positions_location(
4719: p_position_id => p_pa_request_rec.to_position_id,

Line 4743: ,p_wgi in out nocopy ghr_api.within_grade_increase_type

4739: -- ********************************
4740: --
4741: Procedure Process_salary_Info
4742: (p_pa_request_rec in ghr_pa_requests%rowtype
4743: ,p_wgi in out nocopy ghr_api.within_grade_increase_type
4744: ,p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type
4745: ,p_capped_other_pay in number default null
4746: ) is
4747:

Line 4744: ,p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type

4740: --
4741: Procedure Process_salary_Info
4742: (p_pa_request_rec in ghr_pa_requests%rowtype
4743: ,p_wgi in out nocopy ghr_api.within_grade_increase_type
4744: ,p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type
4745: ,p_capped_other_pay in number default null
4746: ) is
4747:
4748: l_proc varchar2(70) := 'Process_salary_info';

Line 4826: l_wgi ghr_api.within_grade_increase_type;

4822: pei_information9
4823: from per_people_extra_info
4824: where person_extra_info_id = l_retained_grade_rec.person_extra_info_id;
4825:
4826: l_wgi ghr_api.within_grade_increase_type;
4827: l_retention_allow_review ghr_api.retention_allow_review_type;
4828:
4829:
4830: CURSOR cur_temp_step

Line 4827: l_retention_allow_review ghr_api.retention_allow_review_type;

4823: from per_people_extra_info
4824: where person_extra_info_id = l_retained_grade_rec.person_extra_info_id;
4825:
4826: l_wgi ghr_api.within_grade_increase_type;
4827: l_retention_allow_review ghr_api.retention_allow_review_type;
4828:
4829:
4830: CURSOR cur_temp_step
4831: IS

Line 5805: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'

5801:
5802: hr_utility.trace('Pradeep l_session.noa_id_correct:'||l_session.noa_id_correct);
5803: IF l_session.noa_id_correct is null THEN
5804:
5805: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
5806: ,p_input_value_name => 'Amount'
5807: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
5808: ,p_effective_date => l_effective_date
5809: ,p_value => l_retention_allowance

Line 5955: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN

5951: -- OR condition for Pay Plan FE is added as FE is nomore ES equ pay plan
5952: IF NOT ((l_equ_pay_plan = 'ES' OR l_to_pay_plan='FE')
5953: AND p_pa_request_rec.first_noa_code IN ('891', '892', '890', '897')) THEN
5954:
5955: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN
5956: ('APP',
5957: 'APP_TRANSFER',
5958: 'RETURN_TO_DUTY',
5959: 'CHG_WORK_SCHED',

Line 5966: nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) LIKE 'GHR_SAL%' AND

5962: 'DENIAL_WGI',
5963: 'CONV_APP')
5964: OR
5965: (
5966: nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) LIKE 'GHR_SAL%' AND
5967: nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) NOT IN ('894','895','850')
5968: ) THEN
5969:
5970: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN

Line 5967: nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) NOT IN ('894','895','850')

5963: 'CONV_APP')
5964: OR
5965: (
5966: nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) LIKE 'GHR_SAL%' AND
5967: nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) NOT IN ('894','895','850')
5968: ) THEN
5969:
5970: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN
5971: ('APP',

Line 5970: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN

5966: nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) LIKE 'GHR_SAL%' AND
5967: nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) NOT IN ('894','895','850')
5968: ) THEN
5969:
5970: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN
5971: ('APP',
5972: 'APP_TRANSFER',
5973: 'RETURN_TO_DUTY',
5974: 'CHG_WORK_SCHED',

Line 5981: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) = 'CONV_APP' THEN

5977: 'DENIAL_WGI',
5978: 'CONV_APP') THEN
5979: -- Bug 4031919 If Conversion to appointment and we're moving from WGI to Non-WGI position
5980: -- End date the WGI element
5981: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) = 'CONV_APP' THEN
5982: -- If Correction action, then take pay plan from Original action
5983: IF l_session.noa_id_correct IS NOT NULL AND p_pa_request_rec.to_pay_plan IS NULL THEN
5984: FOR l_get_pay_plan IN c_get_pay_plan(p_pa_request_rec.altered_pa_request_id) LOOP
5985: l_to_pay_plan := l_get_pay_plan.to_pay_plan;

Line 6030: END IF; -- IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) = 'CONV_APP'

6026: l_wgi_cleared := TRUE;
6027: END IF;
6028: END IF; -- IF l_is_wgi_eligible = FALSE
6029: END IF;
6030: END IF; -- IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) = 'CONV_APP'
6031:
6032: -- proceed only if date_wgi_due is not null
6033: l_wgi_due_date := fnd_date.canonical_to_date(p_wgi.p_date_wgi_due);
6034: IF l_wgi_due_date IS NOT NULL AND l_wgi_cleared = FALSE THEN

Line 6062: ELSIF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN ('APP','CONV_APP')

6058: -- If WGI Due date is not entered for Appointment and Conversion to Appointment, atleast create
6059: -- WGI element with Last equivalent increase.
6060: -- Bug 3998686 In correction action, if DLEI is present and WGI Due date is cleared,
6061: -- it comes here. Need to update NULL in that case. .
6062: ELSIF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN ('APP','CONV_APP')
6063: AND p_wgi.p_last_equi_incr IS NOT NULL AND l_wgi_cleared = FALSE THEN
6064: hr_utility.set_location('Inside elsif loop',511);
6065: ghr_element_api.process_sf52_element
6066: (p_assignment_id => p_pa_request_rec.employee_assignment_id

Line 6511: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type

6507: -- ********************************
6508: --
6509: Procedure Process_non_salary_Info
6510: (p_pa_request_rec in ghr_pa_requests%rowtype
6511: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6512: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type

Line 6512: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type

6508: --
6509: Procedure Process_non_salary_Info
6510: (p_pa_request_rec in ghr_pa_requests%rowtype
6511: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6512: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type

Line 6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type

6509: Procedure Process_non_salary_Info
6510: (p_pa_request_rec in ghr_pa_requests%rowtype
6511: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6512: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6517: ,p_gov_award in out nocopy ghr_api.government_awards_type

Line 6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type

6511: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6512: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6517: ,p_gov_award in out nocopy ghr_api.government_awards_type
6518: ,p_entitlement in out nocopy ghr_api.entitlement_type
6519: -- Bug#2759379 Added FEGLI parameter

Line 6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type

6512: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6517: ,p_gov_award in out nocopy ghr_api.government_awards_type
6518: ,p_entitlement in out nocopy ghr_api.entitlement_type
6519: -- Bug#2759379 Added FEGLI parameter
6520: ,p_fegli in out nocopy ghr_api.fegli_type

Line 6517: ,p_gov_award in out nocopy ghr_api.government_awards_type

6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6517: ,p_gov_award in out nocopy ghr_api.government_awards_type
6518: ,p_entitlement in out nocopy ghr_api.entitlement_type
6519: -- Bug#2759379 Added FEGLI parameter
6520: ,p_fegli in out nocopy ghr_api.fegli_type
6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type

Line 6518: ,p_entitlement in out nocopy ghr_api.entitlement_type

6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6517: ,p_gov_award in out nocopy ghr_api.government_awards_type
6518: ,p_entitlement in out nocopy ghr_api.entitlement_type
6519: -- Bug#2759379 Added FEGLI parameter
6520: ,p_fegli in out nocopy ghr_api.fegli_type
6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6522: -- Bug# 3385386 Added FTA parameter

Line 6520: ,p_fegli in out nocopy ghr_api.fegli_type

6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6517: ,p_gov_award in out nocopy ghr_api.government_awards_type
6518: ,p_entitlement in out nocopy ghr_api.entitlement_type
6519: -- Bug#2759379 Added FEGLI parameter
6520: ,p_fegli in out nocopy ghr_api.fegli_type
6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6522: -- Bug# 3385386 Added FTA parameter
6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type

Line 6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type

6517: ,p_gov_award in out nocopy ghr_api.government_awards_type
6518: ,p_entitlement in out nocopy ghr_api.entitlement_type
6519: -- Bug#2759379 Added FEGLI parameter
6520: ,p_fegli in out nocopy ghr_api.fegli_type
6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6522: -- Bug# 3385386 Added FTA parameter
6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type

Line 6523: ,p_fta in out nocopy ghr_api.fta_type

6519: -- Bug#2759379 Added FEGLI parameter
6520: ,p_fegli in out nocopy ghr_api.fegli_type
6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6522: -- Bug# 3385386 Added FTA parameter
6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type

Line 6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type

6520: ,p_fegli in out nocopy ghr_api.fegli_type
6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6522: -- Bug# 3385386 Added FTA parameter
6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type

Line 6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type

6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6522: -- Bug# 3385386 Added FTA parameter
6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type

Line 6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type

6522: -- Bug# 3385386 Added FTA parameter
6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type

Line 6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type

6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type

Line 6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type

6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type

Line 6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type

6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type

Line 6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type

6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type

Line 6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type

6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type

Line 6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type

6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type

Line 6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type

6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type

Line 6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type

6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan

Line 6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type

6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6539: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type

Line 6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type

6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6539: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
6540: ) is

Line 6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type

6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6539: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
6540: ) is
6541:

Line 6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan

6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6539: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
6540: ) is
6541:
6542: l_proc varchar2(70) := 'Process_Non_salary_info';

Line 6539: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type

6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6539: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
6540: ) is
6541:
6542: l_proc varchar2(70) := 'Process_Non_salary_info';
6543: l_warning boolean;

Line 6547: l_recruitment_bonus ghr_api.recruitment_bonus_type;

6543: l_warning boolean;
6544: l_effective_date date;
6545: --
6546: -- No copy Changes.
6547: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6548: l_relocation_bonus ghr_api.relocation_bonus_type;
6549: l_gov_award ghr_api.government_awards_type;
6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

Line 6548: l_relocation_bonus ghr_api.relocation_bonus_type;

6544: l_effective_date date;
6545: --
6546: -- No copy Changes.
6547: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6548: l_relocation_bonus ghr_api.relocation_bonus_type;
6549: l_gov_award ghr_api.government_awards_type;
6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable

Line 6549: l_gov_award ghr_api.government_awards_type;

6545: --
6546: -- No copy Changes.
6547: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6548: l_relocation_bonus ghr_api.relocation_bonus_type;
6549: l_gov_award ghr_api.government_awards_type;
6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;

Line 6550: l_entitlement ghr_api.entitlement_type;

6546: -- No copy Changes.
6547: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6548: l_relocation_bonus ghr_api.relocation_bonus_type;
6549: l_gov_award ghr_api.government_awards_type;
6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;

Line 6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

6547: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6548: l_relocation_bonus ghr_api.relocation_bonus_type;
6549: l_gov_award ghr_api.government_awards_type;
6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;

Line 6553: l_fta ghr_api.fta_type;

6549: l_gov_award ghr_api.government_awards_type;
6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;

Line 6554: l_edp_pay ghr_api.edp_pay_type;

6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;

Line 6555: l_hazard_pay ghr_api.hazard_pay_type;

6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;

Line 6556: l_health_benefits ghr_api.health_benefits_type;

6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;

Line 6557: l_danger_pay ghr_api.danger_pay_type;

6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;

Line 6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;

6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

Line 6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;

6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;

Line 6560: l_post_diff_amt ghr_api.post_diff_amt_type;

6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;

Line 6561: l_post_diff_percent ghr_api.post_diff_percent_type;

6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;

Line 6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;

Line 6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;

6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;

Line 6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;

6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;

Line 6565: l_premium_pay ghr_api.premium_pay_type;

6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

Line 6566: l_retirement_annuity ghr_api.retirement_annuity_type;

6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6570: l_student_loan_repay ghr_api.student_loan_repay_type;

Line 6567: l_severance_pay ghr_api.severance_pay_type;

6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6570: l_student_loan_repay ghr_api.student_loan_repay_type;
6571: -- Bug#4486823 RRR Changes

Line 6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;

6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6570: l_student_loan_repay ghr_api.student_loan_repay_type;
6571: -- Bug#4486823 RRR Changes
6572: l_total_salary ghr_pa_requests.to_total_salary%TYPE;

Line 6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6570: l_student_loan_repay ghr_api.student_loan_repay_type;
6571: -- Bug#4486823 RRR Changes
6572: l_total_salary ghr_pa_requests.to_total_salary%TYPE;
6573: --

Line 6570: l_student_loan_repay ghr_api.student_loan_repay_type;

6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6570: l_student_loan_repay ghr_api.student_loan_repay_type;
6571: -- Bug#4486823 RRR Changes
6572: l_total_salary ghr_pa_requests.to_total_salary%TYPE;
6573: --
6574: PROCEDURE Create_incentive_Remark(p_pa_request_id IN NUMBER,

Line 7922: If nvl(p_pa_request_rec.pay_Rate_determinant,hr_api.g_varchar2) in ('A','B','E','F') then

7918: l_pos_ei_data per_position_extra_info%ROWTYPE;
7919:
7920: Begin
7921: hr_utility.set_location('entering ' || l_proc,5);
7922: If nvl(p_pa_request_rec.pay_Rate_determinant,hr_api.g_varchar2) in ('A','B','E','F') then
7923: for next_from_step in c_next_Step loop
7924: hr_utility.set_location(l_proc,34);
7925: l_step_or_rate := next_from_step.to_step;
7926: end loop;

Line 8209: p_segment_rec in ghr_api.special_information_type

8205: --
8206: Procedure generic_update_sit
8207: (p_pa_request_rec in ghr_pa_requests%rowtype,
8208: p_special_information_type in fnd_id_flex_structures_tl.id_flex_structure_name%type,
8209: p_segment_rec in ghr_api.special_information_type
8210: )
8211: is
8212:
8213: l_proc varchar2(72) := 'Generic Update SIT';