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 168: -- extra information, with all the parameters defaulted to hr_api.g_varchar2

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

Line 173: If p_information1 = hr_api.g_varchar2 THEN

169: -- therby ensuring that while updating, none of the existing data gets over-written.
170:
171: l_extra_info_id := p_extra_info_id;
172: hr_utility.set_location('l_extra_info_id is ' ||l_extra_info_id || ' ' || l_proc,8);
173: If p_information1 = hr_api.g_varchar2 THEN
174: l_information1 := null;
175: Else
176: l_information1 := p_information1;
177: End if;

Line 178: IF p_information2 = hr_api.g_varchar2 THEN

174: l_information1 := null;
175: Else
176: l_information1 := p_information1;
177: End if;
178: IF p_information2 = hr_api.g_varchar2 THEN
179: l_information2 := null;
180: Else
181: l_information2 := p_information2;
182: End if;

Line 183: IF p_information3 = hr_api.g_varchar2 THEN

179: l_information2 := null;
180: Else
181: l_information2 := p_information2;
182: End if;
183: IF p_information3 = hr_api.g_varchar2 THEN
184: l_information3 := null;
185: ELSE
186: l_information3 := p_information3;
187: END IF;

Line 188: IF p_information4 = hr_api.g_varchar2 THEN

184: l_information3 := null;
185: ELSE
186: l_information3 := p_information3;
187: END IF;
188: IF p_information4 = hr_api.g_varchar2 THEN
189: l_information4 := null;
190: ELSE
191: l_information4 := p_information4;
192: END IF;

Line 193: IF p_information5 = hr_api.g_varchar2 THEN

189: l_information4 := null;
190: ELSE
191: l_information4 := p_information4;
192: END IF;
193: IF p_information5 = hr_api.g_varchar2 THEN
194: l_information5 := null;
195: ELSE
196: l_information5 := p_information5;
197: END IF;

Line 198: IF p_information6 = hr_api.g_varchar2 THEN

194: l_information5 := null;
195: ELSE
196: l_information5 := p_information5;
197: END IF;
198: IF p_information6 = hr_api.g_varchar2 THEN
199: l_information6 := null;
200: ELSE
201: l_information6 := p_information6;
202: END IF;

Line 203: IF p_information7 = hr_api.g_varchar2 THEN

199: l_information6 := null;
200: ELSE
201: l_information6 := p_information6;
202: END IF;
203: IF p_information7 = hr_api.g_varchar2 THEN
204: l_information7 := null;
205: ELSE
206: l_information7 := p_information7;
207: END IF;

Line 208: IF p_information8 = hr_api.g_varchar2 THEN

204: l_information7 := null;
205: ELSE
206: l_information7 := p_information7;
207: END IF;
208: IF p_information8 = hr_api.g_varchar2 THEN
209: l_information8 := null;
210: ELSE
211: l_information8 := p_information8;
212: END IF;

Line 213: IF p_information9 = hr_api.g_varchar2 THEN

209: l_information8 := null;
210: ELSE
211: l_information8 := p_information8;
212: END IF;
213: IF p_information9 = hr_api.g_varchar2 THEN
214: l_information9 := null;
215: ELSE
216: l_information9 := p_information9;
217: END IF;

Line 218: IF p_information10 = hr_api.g_varchar2 THEN

214: l_information9 := null;
215: ELSE
216: l_information9 := p_information9;
217: END IF;
218: IF p_information10 = hr_api.g_varchar2 THEN
219: l_information10 := null;
220: ELSE
221: l_information10 := p_information10;
222: END IF;

Line 223: IF p_information11 = hr_api.g_varchar2 THEN

219: l_information10 := null;
220: ELSE
221: l_information10 := p_information10;
222: END IF;
223: IF p_information11 = hr_api.g_varchar2 THEN
224: l_information11 := null;
225: ELSE
226: l_information11 := p_information11;
227: END IF;

Line 228: IF p_information12 = hr_api.g_varchar2 THEN

224: l_information11 := null;
225: ELSE
226: l_information11 := p_information11;
227: END IF;
228: IF p_information12 = hr_api.g_varchar2 THEN
229: l_information12 := null;
230: ELSE
231: l_information12 := p_information12;
232: END IF;

Line 233: IF p_information13 = hr_api.g_varchar2 THEN

229: l_information12 := null;
230: ELSE
231: l_information12 := p_information12;
232: END IF;
233: IF p_information13 = hr_api.g_varchar2 THEN
234: l_information13 := null;
235: ELSE
236: l_information13 := p_information13;
237: END IF;

Line 238: IF p_information14 = hr_api.g_varchar2 THEN

234: l_information13 := null;
235: ELSE
236: l_information13 := p_information13;
237: END IF;
238: IF p_information14 = hr_api.g_varchar2 THEN
239: l_information14 := null;
240: ELSE
241: l_information14 := p_information14;
242: END IF;

Line 243: IF p_information15 = hr_api.g_varchar2 THEN

239: l_information14 := null;
240: ELSE
241: l_information14 := p_information14;
242: END IF;
243: IF p_information15 = hr_api.g_varchar2 THEN
244: l_information15 := null;
245: ELSE
246: l_information15 := p_information15;
247: END IF;

Line 248: IF p_information16 = hr_api.g_varchar2 THEN

244: l_information15 := null;
245: ELSE
246: l_information15 := p_information15;
247: END IF;
248: IF p_information16 = hr_api.g_varchar2 THEN
249: l_information16 := null;
250: ELSE
251: l_information16 := p_information16;
252: END IF;

Line 253: IF p_information17 = hr_api.g_varchar2 THEN

249: l_information16 := null;
250: ELSE
251: l_information16 := p_information16;
252: END IF;
253: IF p_information17 = hr_api.g_varchar2 THEN
254: l_information17 := null;
255: ELSE
256: l_information17 := p_information17;
257: END IF;

Line 258: IF p_information18 = hr_api.g_varchar2 THEN

254: l_information17 := null;
255: ELSE
256: l_information17 := p_information17;
257: END IF;
258: IF p_information18 = hr_api.g_varchar2 THEN
259: l_information18 := null;
260: ELSE
261: l_information18 := p_information18;
262: END IF;

Line 263: IF p_information19 = hr_api.g_varchar2 THEN

259: l_information18 := null;
260: ELSE
261: l_information18 := p_information18;
262: END IF;
263: IF p_information19 = hr_api.g_varchar2 THEN
264: l_information19 := null;
265: ELSE
266: l_information19 := p_information19;
267: END IF;

Line 268: IF p_information20 = hr_api.g_varchar2 THEN

264: l_information19 := null;
265: ELSE
266: l_information19 := p_information19;
267: END IF;
268: IF p_information20 = hr_api.g_varchar2 THEN
269: l_information20 := null;
270: ELSE
271: l_information20 := p_information20;
272: END IF;

Line 273: IF p_information21 = hr_api.g_varchar2 THEN

269: l_information20 := null;
270: ELSE
271: l_information20 := p_information20;
272: END IF;
273: IF p_information21 = hr_api.g_varchar2 THEN
274: l_information21 := null;
275: ELSE
276: l_information21 := p_information21;
277: END IF;

Line 278: IF p_information22 = hr_api.g_varchar2 THEN

274: l_information21 := null;
275: ELSE
276: l_information21 := p_information21;
277: END IF;
278: IF p_information22 = hr_api.g_varchar2 THEN
279: l_information22 := null;
280: ELSE
281: l_information22 := p_information22;
282: END IF;

Line 283: IF p_information23 = hr_api.g_varchar2 THEN

279: l_information22 := null;
280: ELSE
281: l_information22 := p_information22;
282: END IF;
283: IF p_information23 = hr_api.g_varchar2 THEN
284: l_information23 := null;
285: ELSE
286: l_information23 := p_information23;
287: END IF;

Line 288: IF p_information24 = hr_api.g_varchar2 THEN

284: l_information23 := null;
285: ELSE
286: l_information23 := p_information23;
287: END IF;
288: IF p_information24 = hr_api.g_varchar2 THEN
289: l_information24 := null;
290: ELSE
291: l_information24 := p_information24;
292: END IF;

Line 293: IF p_information25 = hr_api.g_varchar2 THEN

289: l_information24 := null;
290: ELSE
291: l_information24 := p_information24;
292: END IF;
293: IF p_information25 = hr_api.g_varchar2 THEN
294: l_information25 := null;
295: ELSE
296: l_information25 := p_information25;
297: END IF;

Line 298: IF p_information26 = hr_api.g_varchar2 THEN

294: l_information25 := null;
295: ELSE
296: l_information25 := p_information25;
297: END IF;
298: IF p_information26 = hr_api.g_varchar2 THEN
299: l_information26 := null;
300: ELSE
301: l_information26 := p_information26;
302: END IF;

Line 303: IF p_information27 = hr_api.g_varchar2 THEN

299: l_information26 := null;
300: ELSE
301: l_information26 := p_information26;
302: END IF;
303: IF p_information27 = hr_api.g_varchar2 THEN
304: l_information27 := null;
305: ELSE
306: l_information27 := p_information27;
307: END IF;

Line 308: IF p_information28 = hr_api.g_varchar2 THEN

304: l_information27 := null;
305: ELSE
306: l_information27 := p_information27;
307: END IF;
308: IF p_information28 = hr_api.g_varchar2 THEN
309: l_information28 := null;
310: ELSE
311: l_information28 := p_information28;
312: END IF;

Line 313: IF p_information29 = hr_api.g_varchar2 THEN

309: l_information28 := null;
310: ELSE
311: l_information28 := p_information28;
312: END IF;
313: IF p_information29 = hr_api.g_varchar2 THEN
314: l_information29 := null;
315: ELSE
316: l_information29 := p_information29;
317: END IF;

Line 318: IF p_information30 = hr_api.g_varchar2 THEN

314: l_information29 := null;
315: ELSE
316: l_information29 := p_information29;
317: END IF;
318: IF p_information30 = hr_api.g_varchar2 THEN
319: l_information30 := null;
320: ELSE
321: l_information30 := p_information30;
322: END IF;

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

635: End Generic_Update_Extra_Info;
636:
637: Procedure Update_Retained_Grade
638: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE ,
639: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE) IS
640: --
641: --
642: cursor c_702_rec is
643: select rei_information3,pei_information1,

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

647: where pa_request_id = p_pa_request_rec.pa_request_id
648: and pei.person_extra_info_id = rei.rei_information3
649: and pei.information_type = 'GHR_US_RETAINED_GRADE'
650: and rei.information_type = 'GHR_US_PAR_TERM_RG_PROMO'
651: and nvl(rei.rei_information30,hr_api.g_varchar2) <> 'Original RPA';
652: --
653: cursor c_740_rec is
654: select rei_information3,pei_information1,
655: pei.object_version_number ovn

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

659: and pei.person_extra_info_id = rei.rei_information3
660: and pei.information_type = 'GHR_US_RETAINED_GRADE'
661: and rei.information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
662: and (rei.rei_information5 is null or rei.rei_information5 = 'Y')
663: and nvl(rei.rei_information30,hr_api.g_varchar2) <> 'Original RPA';
664:
665:
666: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
667: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;

Line 693: l_per_retained_grade GHR_API.Per_retained_grade_TYPE;

689: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
690:
691: l_session ghr_history_api.g_session_var_type;
692: l_proc varchar2(70) := 'Update_Retained_Grade';
693: l_per_retained_grade GHR_API.Per_retained_grade_TYPE;
694: -- Bug#4698321 Added pei_information1 to the cursor.
695: Cursor c_retained_grade_ovn is
696: select object_version_number,
697: pei_information1,

Line 1036: l_special_info ghr_api.special_information_type;

1032: l_academic_discipline ghr_pa_requests.academic_discipline%type;
1033: l_object_version_number number(9);
1034: l_multiple varchar2(1);
1035: l_session ghr_history_api.g_session_var_type;
1036: l_special_info ghr_api.special_information_type;
1037:
1038:
1039:
1040: -- Cursor to fetch the id_flex_num for the "US Fed Education" structure

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

1210: hr_utility.set_location('p_pa_request_rec.education_level is '||p_pa_request_rec.education_level,46);
1211: hr_utility.set_location('p_pa_request_rec.academic_discipline is '||p_pa_request_rec.academic_discipline,46);
1212: hr_utility.set_location('p_pa_request_rec.year_degree_attained is '||p_pa_request_rec.year_degree_attained,46);
1213:
1214: If nvl(l_education_level,hr_api.g_varchar2) <> nvl(p_pa_request_rec.education_level,hr_api.g_varchar2) or
1215: nvl(l_academic_discipline,hr_api.g_varchar2) <> nvl(p_pa_request_rec.academic_discipline,hr_api.g_varchar2) or
1216: 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
1217:
1218: -- Commented out by skutteti for bug # 655203 as multiple occurences flag need not be checked for edu sit.

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

1211: hr_utility.set_location('p_pa_request_rec.academic_discipline is '||p_pa_request_rec.academic_discipline,46);
1212: hr_utility.set_location('p_pa_request_rec.year_degree_attained is '||p_pa_request_rec.year_degree_attained,46);
1213:
1214: If nvl(l_education_level,hr_api.g_varchar2) <> nvl(p_pa_request_rec.education_level,hr_api.g_varchar2) or
1215: nvl(l_academic_discipline,hr_api.g_varchar2) <> nvl(p_pa_request_rec.academic_discipline,hr_api.g_varchar2) or
1216: 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
1217:
1218: -- Commented out by skutteti for bug # 655203 as multiple occurences flag need not be checked for edu sit.
1219: -- If nvl(l_multiple,'Y') = 'Y' and l_session.noa_id_correct is null then

Line 1216: 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

1212: hr_utility.set_location('p_pa_request_rec.year_degree_attained is '||p_pa_request_rec.year_degree_attained,46);
1213:
1214: If nvl(l_education_level,hr_api.g_varchar2) <> nvl(p_pa_request_rec.education_level,hr_api.g_varchar2) or
1215: nvl(l_academic_discipline,hr_api.g_varchar2) <> nvl(p_pa_request_rec.academic_discipline,hr_api.g_varchar2) or
1216: 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
1217:
1218: -- Commented out by skutteti for bug # 655203 as multiple occurences flag need not be checked for edu sit.
1219: -- If nvl(l_multiple,'Y') = 'Y' and l_session.noa_id_correct is null then
1220:

Line 1265: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,

1261: -- *************************
1262: --
1263: Procedure call_extra_info_api
1264: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1265: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1266: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1267: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1268: p_asg_detail_info in OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
1269: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,

Line 1266: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,

1262: --
1263: Procedure call_extra_info_api
1264: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1265: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1266: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1267: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1268: p_asg_detail_info in OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
1269: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1270: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,

Line 1267: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,

1263: Procedure call_extra_info_api
1264: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1265: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1266: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1267: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1268: p_asg_detail_info in OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
1269: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1270: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1271: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,

Line 1268: p_asg_detail_info in OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508

1264: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1265: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1266: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1267: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1268: p_asg_detail_info in OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
1269: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1270: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1271: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1272: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,

Line 1269: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,

1265: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1266: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1267: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1268: p_asg_detail_info in OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
1269: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1270: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1271: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1272: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1273: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,

Line 1270: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,

1266: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1267: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1268: p_asg_detail_info in OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
1269: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1270: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1271: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1272: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1273: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1274: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,

Line 1271: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,

1267: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1268: p_asg_detail_info in OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
1269: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1270: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1271: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1272: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1273: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1274: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1275: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,

Line 1272: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,

1268: p_asg_detail_info in OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
1269: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1270: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1271: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1272: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1273: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1274: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1275: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1276: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,

Line 1273: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,

1269: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1270: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1271: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1272: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1273: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1274: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1275: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1276: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1277: --Bug#4486823 RRR Changes

Line 1274: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,

1270: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1271: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1272: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1273: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1274: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1275: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1276: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1277: --Bug#4486823 RRR Changes
1278: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,

Line 1275: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,

1271: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1272: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1273: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1274: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1275: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1276: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1277: --Bug#4486823 RRR Changes
1278: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1279: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,

Line 1276: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,

1272: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1273: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1274: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1275: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1276: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1277: --Bug#4486823 RRR Changes
1278: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1279: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1280: -- BEN_EIT Changes

Line 1278: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,

1274: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1275: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1276: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1277: --Bug#4486823 RRR Changes
1278: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1279: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1280: -- BEN_EIT Changes
1281: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1282: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,

Line 1279: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,

1275: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1276: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1277: --Bug#4486823 RRR Changes
1278: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1279: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1280: -- BEN_EIT Changes
1281: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1282: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1283: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,

Line 1281: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,

1277: --Bug#4486823 RRR Changes
1278: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1279: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1280: -- BEN_EIT Changes
1281: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1282: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1283: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1284: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1285: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,

Line 1282: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,

1278: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1279: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1280: -- BEN_EIT Changes
1281: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1282: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1283: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1284: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1285: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1286: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,

Line 1283: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,

1279: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1280: -- BEN_EIT Changes
1281: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1282: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1283: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1284: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1285: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1286: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1287: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,

Line 1284: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,

1280: -- BEN_EIT Changes
1281: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1282: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1283: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1284: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1285: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1286: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1287: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1288: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,

Line 1285: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,

1281: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1282: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1283: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1284: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1285: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1286: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1287: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1288: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1289: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,

Line 1286: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,

1282: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1283: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1284: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1285: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1286: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1287: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1288: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1289: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1290: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,

Line 1287: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,

1283: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1284: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1285: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1286: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1287: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1288: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1289: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1290: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1291: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,

Line 1288: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,

1284: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1285: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1286: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1287: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1288: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1289: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1290: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1291: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1292: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,

Line 1289: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,

1285: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1286: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1287: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1288: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1289: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1290: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1291: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1292: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1293: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,

Line 1290: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,

1286: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1287: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1288: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1289: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1290: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1291: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1292: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1293: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1294: -- Bug #6312144 New RPA EIT Benefits

Line 1291: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,

1287: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1288: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1289: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1290: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1291: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1292: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1293: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1294: -- Bug #6312144 New RPA EIT Benefits
1295: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,

Line 1292: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,

1288: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1289: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1290: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1291: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1292: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1293: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1294: -- Bug #6312144 New RPA EIT Benefits
1295: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,
1296: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is

Line 1293: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,

1289: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1290: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1291: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1292: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1293: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1294: -- Bug #6312144 New RPA EIT Benefits
1295: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,
1296: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is
1297:

Line 1295: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,

1291: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1292: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1293: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1294: -- Bug #6312144 New RPA EIT Benefits
1295: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,
1296: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is
1297:
1298: --
1299: l_proc varchar2(70) := 'Call Extra Info';

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

1292: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1293: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1294: -- Bug #6312144 New RPA EIT Benefits
1295: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,
1296: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is
1297:
1298: --
1299: l_proc varchar2(70) := 'Call Extra Info';
1300: l_segment_rec ghr_api.special_information_type;

Line 1300: l_segment_rec ghr_api.special_information_type;

1296: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is
1297:
1298: --
1299: l_proc varchar2(70) := 'Call Extra Info';
1300: l_segment_rec ghr_api.special_information_type;
1301: l_form_field_name varchar2(50);
1302: l_posn_title_pm varchar2(50);
1303: l_WS_pm varchar2(50);
1304: l_DS_pm varchar2(50);

Line 1491: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;

1487: --bug# 12596901,12994100
1488: --End Bug# 12557463
1489:
1490: -- No copy Changes variables.
1491: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1492: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1493: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1494: l_Asg_detail_info GHR_API.asg_detail_info_type;-- Bug# 8653508
1495: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;

Line 1492: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;

1488: --End Bug# 12557463
1489:
1490: -- No copy Changes variables.
1491: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1492: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1493: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1494: l_Asg_detail_info GHR_API.asg_detail_info_type;-- Bug# 8653508
1495: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1496: l_Per_Group1 GHR_API.Per_Group1_TYPE;

Line 1493: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;

1489:
1490: -- No copy Changes variables.
1491: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1492: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1493: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1494: l_Asg_detail_info GHR_API.asg_detail_info_type;-- Bug# 8653508
1495: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1496: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1497: l_Per_Group2 GHR_API.Per_Group2_TYPE;

Line 1494: l_Asg_detail_info GHR_API.asg_detail_info_type;-- Bug# 8653508

1490: -- No copy Changes variables.
1491: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1492: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1493: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1494: l_Asg_detail_info GHR_API.asg_detail_info_type;-- Bug# 8653508
1495: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1496: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1497: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1498: l_Per_scd_info GHR_API.Per_scd_info_TYPE;

Line 1495: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;

1491: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1492: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1493: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1494: l_Asg_detail_info GHR_API.asg_detail_info_type;-- Bug# 8653508
1495: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1496: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1497: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1498: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1499: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;

Line 1496: l_Per_Group1 GHR_API.Per_Group1_TYPE;

1492: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1493: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1494: l_Asg_detail_info GHR_API.asg_detail_info_type;-- Bug# 8653508
1495: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1496: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1497: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1498: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1499: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1500: l_Per_probations GHR_API.Per_probations_TYPE;

Line 1497: l_Per_Group2 GHR_API.Per_Group2_TYPE;

1493: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1494: l_Asg_detail_info GHR_API.asg_detail_info_type;-- Bug# 8653508
1495: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1496: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1497: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1498: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1499: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1500: l_Per_probations GHR_API.Per_probations_TYPE;
1501: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;

Line 1498: l_Per_scd_info GHR_API.Per_scd_info_TYPE;

1494: l_Asg_detail_info GHR_API.asg_detail_info_type;-- Bug# 8653508
1495: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1496: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1497: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1498: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1499: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1500: l_Per_probations GHR_API.Per_probations_TYPE;
1501: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1502: l_Per_security GHR_API.Per_security_TYPE;

Line 1499: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;

1495: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1496: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1497: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1498: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1499: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1500: l_Per_probations GHR_API.Per_probations_TYPE;
1501: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1502: l_Per_security GHR_API.Per_security_TYPE;
1503: --Bug#4486823 RRR Changes

Line 1500: l_Per_probations GHR_API.Per_probations_TYPE;

1496: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1497: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1498: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1499: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1500: l_Per_probations GHR_API.Per_probations_TYPE;
1501: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1502: l_Per_security GHR_API.Per_security_TYPE;
1503: --Bug#4486823 RRR Changes
1504: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;

Line 1501: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;

1497: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1498: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1499: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1500: l_Per_probations GHR_API.Per_probations_TYPE;
1501: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1502: l_Per_security GHR_API.Per_security_TYPE;
1503: --Bug#4486823 RRR Changes
1504: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1505: l_Per_conversions GHR_API.Per_conversions_TYPE;

Line 1502: l_Per_security GHR_API.Per_security_TYPE;

1498: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1499: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1500: l_Per_probations GHR_API.Per_probations_TYPE;
1501: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1502: l_Per_security GHR_API.Per_security_TYPE;
1503: --Bug#4486823 RRR Changes
1504: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1505: l_Per_conversions GHR_API.Per_conversions_TYPE;
1506: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes

Line 1504: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;

1500: l_Per_probations GHR_API.Per_probations_TYPE;
1501: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1502: l_Per_security GHR_API.Per_security_TYPE;
1503: --Bug#4486823 RRR Changes
1504: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1505: l_Per_conversions GHR_API.Per_conversions_TYPE;
1506: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1507: -- BEN_EIT Changes
1508: l_per_benefit_info GHR_API.per_benefit_info_type;

Line 1505: l_Per_conversions GHR_API.Per_conversions_TYPE;

1501: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1502: l_Per_security GHR_API.Per_security_TYPE;
1503: --Bug#4486823 RRR Changes
1504: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1505: l_Per_conversions GHR_API.Per_conversions_TYPE;
1506: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1507: -- BEN_EIT Changes
1508: l_per_benefit_info GHR_API.per_benefit_info_type;
1509: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;

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

1502: l_Per_security GHR_API.Per_security_TYPE;
1503: --Bug#4486823 RRR Changes
1504: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1505: l_Per_conversions GHR_API.Per_conversions_TYPE;
1506: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1507: -- BEN_EIT Changes
1508: l_per_benefit_info GHR_API.per_benefit_info_type;
1509: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1510: l_Pos_oblig GHR_API.Pos_oblig_TYPE;

Line 1508: l_per_benefit_info GHR_API.per_benefit_info_type;

1504: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1505: l_Per_conversions GHR_API.Per_conversions_TYPE;
1506: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1507: -- BEN_EIT Changes
1508: l_per_benefit_info GHR_API.per_benefit_info_type;
1509: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1510: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1511: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1512: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;

Line 1509: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;

1505: l_Per_conversions GHR_API.Per_conversions_TYPE;
1506: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1507: -- BEN_EIT Changes
1508: l_per_benefit_info GHR_API.per_benefit_info_type;
1509: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1510: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1511: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1512: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1513: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;

Line 1510: l_Pos_oblig GHR_API.Pos_oblig_TYPE;

1506: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1507: -- BEN_EIT Changes
1508: l_per_benefit_info GHR_API.per_benefit_info_type;
1509: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1510: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1511: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1512: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1513: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1514: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;

Line 1511: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;

1507: -- BEN_EIT Changes
1508: l_per_benefit_info GHR_API.per_benefit_info_type;
1509: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1510: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1511: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1512: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1513: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1514: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1515: l_Perf_appraisal ghr_api.performance_appraisal_type;

Line 1512: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;

1508: l_per_benefit_info GHR_API.per_benefit_info_type;
1509: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1510: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1511: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1512: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1513: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1514: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1515: l_Perf_appraisal ghr_api.performance_appraisal_type;
1516: l_conduct_performance ghr_api.conduct_performance_type;

Line 1513: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;

1509: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1510: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1511: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1512: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1513: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1514: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1515: l_Perf_appraisal ghr_api.performance_appraisal_type;
1516: l_conduct_performance ghr_api.conduct_performance_type;
1517: l_Loc_Info GHR_API.Loc_Info_TYPE;

Line 1514: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;

1510: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1511: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1512: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1513: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1514: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1515: l_Perf_appraisal ghr_api.performance_appraisal_type;
1516: l_conduct_performance ghr_api.conduct_performance_type;
1517: l_Loc_Info GHR_API.Loc_Info_TYPE;
1518: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;

Line 1515: l_Perf_appraisal ghr_api.performance_appraisal_type;

1511: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1512: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1513: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1514: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1515: l_Perf_appraisal ghr_api.performance_appraisal_type;
1516: l_conduct_performance ghr_api.conduct_performance_type;
1517: l_Loc_Info GHR_API.Loc_Info_TYPE;
1518: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1519: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;

Line 1516: l_conduct_performance ghr_api.conduct_performance_type;

1512: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1513: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1514: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1515: l_Perf_appraisal ghr_api.performance_appraisal_type;
1516: l_conduct_performance ghr_api.conduct_performance_type;
1517: l_Loc_Info GHR_API.Loc_Info_TYPE;
1518: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1519: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1520: ---for bug 3267632

Line 1517: l_Loc_Info GHR_API.Loc_Info_TYPE;

1513: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1514: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1515: l_Perf_appraisal ghr_api.performance_appraisal_type;
1516: l_conduct_performance ghr_api.conduct_performance_type;
1517: l_Loc_Info GHR_API.Loc_Info_TYPE;
1518: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1519: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1520: ---for bug 3267632
1521: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;

Line 1518: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;

1514: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1515: l_Perf_appraisal ghr_api.performance_appraisal_type;
1516: l_conduct_performance ghr_api.conduct_performance_type;
1517: l_Loc_Info GHR_API.Loc_Info_TYPE;
1518: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1519: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1520: ---for bug 3267632
1521: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;
1522: --

Line 1519: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;

1515: l_Perf_appraisal ghr_api.performance_appraisal_type;
1516: l_conduct_performance ghr_api.conduct_performance_type;
1517: l_Loc_Info GHR_API.Loc_Info_TYPE;
1518: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1519: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1520: ---for bug 3267632
1521: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;
1522: --
1523: -- Bug 3390876

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

2153: END Loop;
2154:
2155: hr_utility.set_location('To Posn PM ' || l_posn_title_pm ,81);
2156: IF p_pa_request_rec.to_position_id IS NOT NULL AND l_posn_title_pm in ('APUE','UE')
2157: AND nvl(p_pa_request_rec.to_position_id,hr_api.g_number) <>
2158: nvl(p_pa_request_rec.from_position_id,hr_api.g_number)
2159: OR p_pa_request_rec.to_position_id IS NOT NULL AND l_WS_pm in ('APUE','UE')
2160: OR nvl(p_pa_request_rec.first_noa_code,hr_api.g_number) = '782'
2161: OR nvl(p_pa_request_rec.second_noa_code,hr_api.g_number) = '782'

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

2154:
2155: hr_utility.set_location('To Posn PM ' || l_posn_title_pm ,81);
2156: IF p_pa_request_rec.to_position_id IS NOT NULL AND l_posn_title_pm in ('APUE','UE')
2157: AND nvl(p_pa_request_rec.to_position_id,hr_api.g_number) <>
2158: nvl(p_pa_request_rec.from_position_id,hr_api.g_number)
2159: OR p_pa_request_rec.to_position_id IS NOT NULL AND l_WS_pm in ('APUE','UE')
2160: OR nvl(p_pa_request_rec.first_noa_code,hr_api.g_number) = '782'
2161: OR nvl(p_pa_request_rec.second_noa_code,hr_api.g_number) = '782'
2162: THEN

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

2156: IF p_pa_request_rec.to_position_id IS NOT NULL AND l_posn_title_pm in ('APUE','UE')
2157: AND nvl(p_pa_request_rec.to_position_id,hr_api.g_number) <>
2158: nvl(p_pa_request_rec.from_position_id,hr_api.g_number)
2159: OR p_pa_request_rec.to_position_id IS NOT NULL AND l_WS_pm in ('APUE','UE')
2160: OR nvl(p_pa_request_rec.first_noa_code,hr_api.g_number) = '782'
2161: OR nvl(p_pa_request_rec.second_noa_code,hr_api.g_number) = '782'
2162: THEN
2163: hr_utility.set_location('Posn Update With WS/PTH' || l_posn_title_pm ,81);
2164:

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

2157: AND nvl(p_pa_request_rec.to_position_id,hr_api.g_number) <>
2158: nvl(p_pa_request_rec.from_position_id,hr_api.g_number)
2159: OR p_pa_request_rec.to_position_id IS NOT NULL AND l_WS_pm in ('APUE','UE')
2160: OR nvl(p_pa_request_rec.first_noa_code,hr_api.g_number) = '782'
2161: OR nvl(p_pa_request_rec.second_noa_code,hr_api.g_number) = '782'
2162: THEN
2163: hr_utility.set_location('Posn Update With WS/PTH' || l_posn_title_pm ,81);
2164:
2165: ---------------------------- bug#2623692

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

2518: ast.active_flag
2519: from per_assignment_status_types ast
2520: where ast.per_system_status = l_system_status
2521: and ast.user_status like '%' || l_user_status || '%'
2522: and nvl(ast.business_group_id,hr_api.g_number) = hr_api.g_number
2523: and ast.legislation_code = 'US';
2524:
2525: cursor c_asg_status_type_471 is
2526: select ast.assignment_status_type_id,

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

2528: from per_assignment_status_types ast
2529: where ast.per_system_status = l_system_status
2530: and ast.user_status like '%' || l_user_status || '%'
2531: and instr(ast.user_status,'NTE') = 0
2532: and nvl(ast.business_group_id,hr_api.g_number) = hr_api.g_number
2533: and ast.legislation_code = 'US';
2534: -- Bug# 4672772 Begin
2535: l_user_apnt_status per_assignment_status_types.user_status%type;
2536: l_user_apnt_eff_date date;

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

3717: -- Start Bug 1613367
3718: For ovn in asg_ovn(p_pa_request_rec.employee_assignment_id) loop
3719: l_temp_asg_loc_id := ovn.location_id;
3720: End loop;
3721: IF nvl(p_pa_request_rec.duty_station_location_id,hr_api.g_number)
3722: <> nvl(l_temp_asg_loc_id,hr_api.g_number) then
3723: l_position_data_rec_type.location_id := p_pa_request_rec.duty_station_location_id;
3724: ELSE
3725: l_position_data_rec_type.location_id := NULL;

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

3718: For ovn in asg_ovn(p_pa_request_rec.employee_assignment_id) loop
3719: l_temp_asg_loc_id := ovn.location_id;
3720: End loop;
3721: IF nvl(p_pa_request_rec.duty_station_location_id,hr_api.g_number)
3722: <> nvl(l_temp_asg_loc_id,hr_api.g_number) then
3723: l_position_data_rec_type.location_id := p_pa_request_rec.duty_station_location_id;
3724: ELSE
3725: l_position_data_rec_type.location_id := NULL;
3726: END IF;

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

3945: l_activate_flag := 'Y';
3946: End if;
3947:
3948: -- Code added by skutteti on 13-jul-98 bug #699856
3949: If nvl(p_pa_request_rec.From_Position_Id, hr_api.g_number) <>
3950: nvl(p_pa_request_rec.to_position_id, hr_api.g_number) then
3951: l_employee_api_update_criteria := 'Y';
3952: l_update_gre := 'Y';
3953: end if;

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

3946: End if;
3947:
3948: -- Code added by skutteti on 13-jul-98 bug #699856
3949: If nvl(p_pa_request_rec.From_Position_Id, hr_api.g_number) <>
3950: nvl(p_pa_request_rec.to_position_id, hr_api.g_number) then
3951: l_employee_api_update_criteria := 'Y';
3952: l_update_gre := 'Y';
3953: end if;
3954:

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

3961: l_employee_api_update_criteria := 'Y';
3962: l_update_gre := 'Y'; -- Added Venkat Bug # 1239688
3963: End if;
3964: If p_pa_request_rec.to_position_id is not null then
3965: If nvl(p_pa_request_rec.From_Position_Id,hr_api.g_number) <> P_pa_request_rec.to_position_id
3966: then
3967: hr_utility.set_location('Non Appointment -- To pos <> From Pos - GRE ' ||l_proc,41);
3968: l_employee_api_update_criteria := 'Y';
3969: l_update_gre := 'Y';

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

4002: -- of the change in position for NOA 713 (change to lower grade)
4003: --
4004: --if l_noa_family_code = 'SALARY_CHG' then
4005: if p_pa_request_rec.to_grade_or_level is not null and
4006: nvl(p_pa_request_rec.from_grade_or_level,hr_api.g_varchar2) <> p_pa_request_rec.to_grade_or_level then
4007: l_employee_api_update_criteria := 'Y';
4008: end if;
4009: --
4010: -- Update of Pay Plan GG to Assignmentn 855 processing.

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

4017: l_noa_family_code = 'REASSIGNMENT' --Bug# 7209120
4018: OR
4019: l_noa_family_code like 'GHR_SAL%' THEN
4020:
4021: IF nvl(p_pa_request_rec.from_pay_plan,hr_api.g_varchar2) <> p_pa_request_rec.to_pay_plan then
4022: l_employee_api_update_criteria := 'Y';
4023: END IF;
4024: END IF;
4025: --

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

4069: hr_utility.set_location('l_grade id for the new position '||l_grade_id,875);
4070: --Bug# 6010971, added grade_id condition
4071: IF l_asg_position IS NOT NULL
4072: AND ((l_position_id <> l_asg_position)
4073: OR (nvl(P_pa_request_rec.to_grade_id,hr_api.g_number) <> nvl(l_grade_id,hr_api.g_number)))
4074: THEN
4075: hr_utility.set_location('To pos <> Assg Pos ' ||l_proc,650);
4076: l_employee_api_update_criteria := 'Y';
4077: END IF;

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

4126: hr_utility.set_location('l_REGION_2 ' ||substr(l_REGION_2,1,40),73 );
4127: hr_utility.set_location('l_POSTAL_CODE ' ||l_POSTAL_CODE,74 );
4128: hr_utility.set_location('l_COUNTRY ' ||substr(l_COUNTRY,1,40),75 );
4129: IF l_session.noa_id_correct is null THEN
4130: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
4131: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
4132: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4133: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4134: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and

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

4127: hr_utility.set_location('l_POSTAL_CODE ' ||l_POSTAL_CODE,74 );
4128: hr_utility.set_location('l_COUNTRY ' ||substr(l_COUNTRY,1,40),75 );
4129: IF l_session.noa_id_correct is null THEN
4130: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
4131: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
4132: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4133: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4134: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
4135: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and

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

4128: hr_utility.set_location('l_COUNTRY ' ||substr(l_COUNTRY,1,40),75 );
4129: IF l_session.noa_id_correct is null THEN
4130: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
4131: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
4132: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4133: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4134: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
4135: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
4136: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN

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

4129: IF l_session.noa_id_correct is null THEN
4130: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
4131: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
4132: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4133: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4134: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
4135: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
4136: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
4137: null;

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

4130: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
4131: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
4132: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4133: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4134: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
4135: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
4136: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
4137: null;
4138: hr_utility.set_location('Non Correction -- No Action ' || l_proc,76);

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

4131: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
4132: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4133: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4134: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
4135: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
4136: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
4137: null;
4138: hr_utility.set_location('Non Correction -- No Action ' || l_proc,76);
4139: ELSE

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

4132: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4133: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4134: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
4135: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
4136: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
4137: null;
4138: hr_utility.set_location('Non Correction -- No Action ' || l_proc,76);
4139: ELSE
4140: l_create_address := 'Y';

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

4148: fetch c_upd_primary_address into l_address_id;
4149: hr_utility.set_location('address_id is ' || l_address_id, 66);
4150:
4151: IF c_upd_primary_address%NOTFOUND then
4152: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
4153: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
4154: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4155: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4156: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and

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

4149: hr_utility.set_location('address_id is ' || l_address_id, 66);
4150:
4151: IF c_upd_primary_address%NOTFOUND then
4152: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
4153: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
4154: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4155: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4156: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
4157: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and

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

4150:
4151: IF c_upd_primary_address%NOTFOUND then
4152: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
4153: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
4154: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4155: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4156: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
4157: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
4158: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN

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

4151: IF c_upd_primary_address%NOTFOUND then
4152: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
4153: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
4154: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4155: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4156: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
4157: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
4158: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
4159: NULL;

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

4152: IF nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE1,hr_api.g_varchar2) = nvl(l_address_line1 ,hr_api.g_varchar2) and
4153: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
4154: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4155: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4156: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
4157: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
4158: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
4159: NULL;
4160: hr_utility.set_location('Correction -- No Action ' || l_proc,69);

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

4153: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE2 ,hr_api.g_varchar2)= nvl(l_address_line2 ,hr_api.g_varchar2) and
4154: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4155: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4156: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
4157: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
4158: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
4159: NULL;
4160: hr_utility.set_location('Correction -- No Action ' || l_proc,69);
4161: ELSE

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

4154: nvl(p_pa_request_rec.FORWARDING_ADDRESS_LINE3 ,hr_api.g_varchar2)= nvl(l_address_line3 ,hr_api.g_varchar2) and
4155: nvl(p_pa_request_rec.FORWARDING_TOWN_OR_CITY ,hr_api.g_varchar2) = nvl(l_town_or_city ,hr_api.g_varchar2) and
4156: nvl(p_pa_request_rec.FORWARDING_REGION_2 ,hr_api.g_varchar2) = nvl(l_region_2 ,hr_api.g_varchar2) and
4157: nvl(p_pa_request_rec.FORWARDING_POSTAL_CODE ,hr_api.g_varchar2) = nvl(l_postal_code ,hr_api.g_varchar2) and
4158: nvl(P_pa_request_rec.FORWARDING_COUNTRY ,hr_api.g_varchar2) = nvl(l_country ,hr_api.g_varchar2) THEN
4159: NULL;
4160: hr_utility.set_location('Correction -- No Action ' || l_proc,69);
4161: ELSE
4162: l_create_address := 'Y';

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

4259: -- Start Changes for 3150551
4260: /*
4261: delete from per_person_list_changes
4262: where person_id = p_pa_request_rec.person_id
4263: and nvl(termination_flag,hr_api.g_varchar2) = 'Y';
4264: */
4265: hr_security_internal.clear_from_person_list_changes
4266: ( p_person_id => p_pa_request_rec.person_id );
4267: -- End Changes for 3150551

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

4338: hr_utility.set_location('Assignment status type id '|| l_asg_status_type_id,997);
4339: l_activate_flag := 'Y';
4340: -- Bug 2839332
4341: --Bug# 6010971
4342: IF nvl(P_pa_request_rec.to_grade_id,hr_api.g_number) <> nvl(l_grade_id,hr_api.g_number) then
4343: l_employee_api_update_criteria := 'Y';
4344: end if;
4345: --Bug# 6010971
4346: ELSE --(l_noa_family_code = 'RETURN_TO_DUTY')

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

4392: end if;
4393: --Pradeep end of bug #4148743
4394:
4395:
4396: If nvl(p_pa_request_rec.duty_station_location_id,hr_api.g_number) <> nvl(l_asg_location_id,hr_api.g_number) then
4397: l_employee_api_update_criteria := 'Y';
4398: End if;
4399:
4400: --BUG # 8258924

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

4896: l_per_date_of_birth := per.date_of_birth;
4897: end loop;
4898: hr_utility.set_location(l_proc,138);
4899:
4900: if nvl(p_pa_request_rec.employee_national_identifier,hr_api.g_varchar2) <> nvl(l_per_national_identifier,hr_api.g_varchar2) or
4901: nvl(p_pa_request_rec.employee_date_of_birth,hr_api.g_date) <> nvl(l_per_date_of_birth,hr_api.g_date) or
4902: nvl(p_pa_request_rec.employee_last_name,hr_api.g_varchar2) <> nvl(l_per_last_name,hr_api.g_varchar2) or
4903: nvl(p_pa_request_rec.employee_first_name,hr_api.g_varchar2) <> nvl(l_per_first_name,hr_api.g_varchar2)or
4904: nvl(p_pa_request_rec.employee_middle_names,hr_api.g_varchar2) <> nvl(l_per_middle_names,hr_api.g_varchar2) then

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

4897: end loop;
4898: hr_utility.set_location(l_proc,138);
4899:
4900: if nvl(p_pa_request_rec.employee_national_identifier,hr_api.g_varchar2) <> nvl(l_per_national_identifier,hr_api.g_varchar2) or
4901: nvl(p_pa_request_rec.employee_date_of_birth,hr_api.g_date) <> nvl(l_per_date_of_birth,hr_api.g_date) or
4902: nvl(p_pa_request_rec.employee_last_name,hr_api.g_varchar2) <> nvl(l_per_last_name,hr_api.g_varchar2) or
4903: nvl(p_pa_request_rec.employee_first_name,hr_api.g_varchar2) <> nvl(l_per_first_name,hr_api.g_varchar2)or
4904: nvl(p_pa_request_rec.employee_middle_names,hr_api.g_varchar2) <> nvl(l_per_middle_names,hr_api.g_varchar2) then
4905:

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

4898: hr_utility.set_location(l_proc,138);
4899:
4900: if nvl(p_pa_request_rec.employee_national_identifier,hr_api.g_varchar2) <> nvl(l_per_national_identifier,hr_api.g_varchar2) or
4901: nvl(p_pa_request_rec.employee_date_of_birth,hr_api.g_date) <> nvl(l_per_date_of_birth,hr_api.g_date) or
4902: nvl(p_pa_request_rec.employee_last_name,hr_api.g_varchar2) <> nvl(l_per_last_name,hr_api.g_varchar2) or
4903: nvl(p_pa_request_rec.employee_first_name,hr_api.g_varchar2) <> nvl(l_per_first_name,hr_api.g_varchar2)or
4904: nvl(p_pa_request_rec.employee_middle_names,hr_api.g_varchar2) <> nvl(l_per_middle_names,hr_api.g_varchar2) then
4905:
4906: l_update_mode := return_update_mode

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

4899:
4900: if nvl(p_pa_request_rec.employee_national_identifier,hr_api.g_varchar2) <> nvl(l_per_national_identifier,hr_api.g_varchar2) or
4901: nvl(p_pa_request_rec.employee_date_of_birth,hr_api.g_date) <> nvl(l_per_date_of_birth,hr_api.g_date) or
4902: nvl(p_pa_request_rec.employee_last_name,hr_api.g_varchar2) <> nvl(l_per_last_name,hr_api.g_varchar2) or
4903: nvl(p_pa_request_rec.employee_first_name,hr_api.g_varchar2) <> nvl(l_per_first_name,hr_api.g_varchar2)or
4904: nvl(p_pa_request_rec.employee_middle_names,hr_api.g_varchar2) <> nvl(l_per_middle_names,hr_api.g_varchar2) then
4905:
4906: l_update_mode := return_update_mode
4907: (p_id => p_pa_request_rec.person_id,

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

4900: if nvl(p_pa_request_rec.employee_national_identifier,hr_api.g_varchar2) <> nvl(l_per_national_identifier,hr_api.g_varchar2) or
4901: nvl(p_pa_request_rec.employee_date_of_birth,hr_api.g_date) <> nvl(l_per_date_of_birth,hr_api.g_date) or
4902: nvl(p_pa_request_rec.employee_last_name,hr_api.g_varchar2) <> nvl(l_per_last_name,hr_api.g_varchar2) or
4903: nvl(p_pa_request_rec.employee_first_name,hr_api.g_varchar2) <> nvl(l_per_first_name,hr_api.g_varchar2)or
4904: nvl(p_pa_request_rec.employee_middle_names,hr_api.g_varchar2) <> nvl(l_per_middle_names,hr_api.g_varchar2) then
4905:
4906: l_update_mode := return_update_mode
4907: (p_id => p_pa_request_rec.person_id,
4908: p_effective_date => p_pa_request_rec.effective_date,

Line 4974: 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

4970:
4971: hr_utility.set_location('To Posn PM ' || l_posn_title_pm ,151);
4972: IF l_posn_title_pm = 'UE' OR
4973: (l_posn_title_pm = 'APUE' AND
4974: 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
4975: l_DS_pm in ('APUE','UE') OR
4976: (p_pa_request_rec.effective_date >= to_date('2007/01/07','YYYY/MM/DD') AND p_pa_request_rec.first_noa_code = '894') THEN
4977: ghr_sf52_pos_update.update_positions_location(
4978: p_position_id => p_pa_request_rec.to_position_id,

Line 5002: ,p_wgi in out nocopy ghr_api.within_grade_increase_type

4998: -- ********************************
4999: --
5000: Procedure Process_salary_Info
5001: (p_pa_request_rec in ghr_pa_requests%rowtype
5002: ,p_wgi in out nocopy ghr_api.within_grade_increase_type
5003: ,p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type
5004: ,p_capped_other_pay in number default null
5005: ) is
5006:

Line 5003: ,p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type

4999: --
5000: Procedure Process_salary_Info
5001: (p_pa_request_rec in ghr_pa_requests%rowtype
5002: ,p_wgi in out nocopy ghr_api.within_grade_increase_type
5003: ,p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type
5004: ,p_capped_other_pay in number default null
5005: ) is
5006:
5007: l_proc varchar2(70) := 'Process_salary_info';

Line 5085: l_wgi ghr_api.within_grade_increase_type;

5081: pei_information9
5082: from per_people_extra_info
5083: where person_extra_info_id = l_retained_grade_rec.person_extra_info_id;
5084:
5085: l_wgi ghr_api.within_grade_increase_type;
5086: l_retention_allow_review ghr_api.retention_allow_review_type;
5087:
5088:
5089: CURSOR cur_temp_step

Line 5086: l_retention_allow_review ghr_api.retention_allow_review_type;

5082: from per_people_extra_info
5083: where person_extra_info_id = l_retained_grade_rec.person_extra_info_id;
5084:
5085: l_wgi ghr_api.within_grade_increase_type;
5086: l_retention_allow_review ghr_api.retention_allow_review_type;
5087:
5088:
5089: CURSOR cur_temp_step
5090: IS

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

6060:
6061: hr_utility.trace('Pradeep l_session.noa_id_correct:'||l_session.noa_id_correct);
6062: IF l_session.noa_id_correct is null THEN
6063:
6064: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
6065: ,p_input_value_name => 'Amount'
6066: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
6067: ,p_effective_date => l_effective_date
6068: ,p_value => l_retention_allowance

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

6210: -- OR condition for Pay Plan FE is added as FE is nomore ES equ pay plan
6211: IF NOT ((l_equ_pay_plan = 'ES' OR l_to_pay_plan='FE')
6212: AND p_pa_request_rec.first_noa_code IN ('891', '892', '890', '897')) THEN
6213:
6214: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN
6215: ('APP',
6216: 'APP_TRANSFER',
6217: 'RETURN_TO_DUTY',
6218: 'CHG_WORK_SCHED',

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

6221: 'DENIAL_WGI',
6222: 'CONV_APP')
6223: OR
6224: (
6225: nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) LIKE 'GHR_SAL%' AND
6226: nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) NOT IN ('894','895','850')
6227: ) THEN
6228:
6229: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN

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

6222: 'CONV_APP')
6223: OR
6224: (
6225: nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) LIKE 'GHR_SAL%' AND
6226: nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) NOT IN ('894','895','850')
6227: ) THEN
6228:
6229: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN
6230: ('APP',

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

6225: nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) LIKE 'GHR_SAL%' AND
6226: nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) NOT IN ('894','895','850')
6227: ) THEN
6228:
6229: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN
6230: ('APP',
6231: 'APP_TRANSFER',
6232: 'RETURN_TO_DUTY',
6233: 'CHG_WORK_SCHED',

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

6236: 'DENIAL_WGI',
6237: 'CONV_APP') THEN
6238: -- Bug 4031919 If Conversion to appointment and we're moving from WGI to Non-WGI position
6239: -- End date the WGI element
6240: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) = 'CONV_APP' THEN
6241: -- If Correction action, then take pay plan from Original action
6242: IF l_session.noa_id_correct IS NOT NULL AND p_pa_request_rec.to_pay_plan IS NULL THEN
6243: FOR l_get_pay_plan IN c_get_pay_plan(p_pa_request_rec.altered_pa_request_id) LOOP
6244: l_to_pay_plan := l_get_pay_plan.to_pay_plan;

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

6285: l_wgi_cleared := TRUE;
6286: END IF;
6287: END IF; -- IF l_is_wgi_eligible = FALSE
6288: END IF;
6289: END IF; -- IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) = 'CONV_APP'
6290:
6291: -- proceed only if date_wgi_due is not null
6292: l_wgi_due_date := fnd_date.canonical_to_date(p_wgi.p_date_wgi_due);
6293: IF l_wgi_due_date IS NOT NULL AND l_wgi_cleared = FALSE THEN

Line 6302: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN ('RETURN_TO_DUTY') AND p_wgi.p_last_equi_incr IS NULL THEN

6298: p_retained_grade_rec => l_retained_grade_rec,
6299: p_dlei => NULL
6300: );
6301: --Begin Bug 10104811
6302: IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN ('RETURN_TO_DUTY') AND p_wgi.p_last_equi_incr IS NULL THEN
6303: ghr_history_fetch.fetch_element_entry_value
6304: (p_element_name => 'Within Grade Increase',
6305: p_input_value_name => 'Last Equivalent Increase',
6306: p_assignment_id => p_pa_request_rec.employee_assignment_id,

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

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

Line 6782: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type

6778: -- ********************************
6779: --
6780: Procedure Process_non_salary_Info
6781: (p_pa_request_rec in ghr_pa_requests%rowtype
6782: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6783: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6784: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6785: --Pradeep
6786: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type

Line 6783: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type

6779: --
6780: Procedure Process_non_salary_Info
6781: (p_pa_request_rec in ghr_pa_requests%rowtype
6782: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6783: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6784: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6785: --Pradeep
6786: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6787: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type

Line 6784: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type

6780: Procedure Process_non_salary_Info
6781: (p_pa_request_rec in ghr_pa_requests%rowtype
6782: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6783: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6784: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6785: --Pradeep
6786: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6787: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6788: ,p_gov_award in out nocopy ghr_api.government_awards_type

Line 6786: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type

6782: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6783: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6784: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6785: --Pradeep
6786: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6787: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6788: ,p_gov_award in out nocopy ghr_api.government_awards_type
6789: ,p_entitlement in out nocopy ghr_api.entitlement_type
6790: -- Bug#2759379 Added FEGLI parameter

Line 6787: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type

6783: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6784: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6785: --Pradeep
6786: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6787: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6788: ,p_gov_award in out nocopy ghr_api.government_awards_type
6789: ,p_entitlement in out nocopy ghr_api.entitlement_type
6790: -- Bug#2759379 Added FEGLI parameter
6791: ,p_fegli in out nocopy ghr_api.fegli_type

Line 6788: ,p_gov_award in out nocopy ghr_api.government_awards_type

6784: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6785: --Pradeep
6786: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6787: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6788: ,p_gov_award in out nocopy ghr_api.government_awards_type
6789: ,p_entitlement in out nocopy ghr_api.entitlement_type
6790: -- Bug#2759379 Added FEGLI parameter
6791: ,p_fegli in out nocopy ghr_api.fegli_type
6792: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type

Line 6789: ,p_entitlement in out nocopy ghr_api.entitlement_type

6785: --Pradeep
6786: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6787: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6788: ,p_gov_award in out nocopy ghr_api.government_awards_type
6789: ,p_entitlement in out nocopy ghr_api.entitlement_type
6790: -- Bug#2759379 Added FEGLI parameter
6791: ,p_fegli in out nocopy ghr_api.fegli_type
6792: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6793: -- Bug# 3385386 Added FTA parameter

Line 6791: ,p_fegli in out nocopy ghr_api.fegli_type

6787: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6788: ,p_gov_award in out nocopy ghr_api.government_awards_type
6789: ,p_entitlement in out nocopy ghr_api.entitlement_type
6790: -- Bug#2759379 Added FEGLI parameter
6791: ,p_fegli in out nocopy ghr_api.fegli_type
6792: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6793: -- Bug# 3385386 Added FTA parameter
6794: ,p_fta in out nocopy ghr_api.fta_type
6795: ,p_edp_pay in out nocopy ghr_api.edp_pay_type

Line 6792: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type

6788: ,p_gov_award in out nocopy ghr_api.government_awards_type
6789: ,p_entitlement in out nocopy ghr_api.entitlement_type
6790: -- Bug#2759379 Added FEGLI parameter
6791: ,p_fegli in out nocopy ghr_api.fegli_type
6792: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6793: -- Bug# 3385386 Added FTA parameter
6794: ,p_fta in out nocopy ghr_api.fta_type
6795: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6796: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type

Line 6794: ,p_fta in out nocopy ghr_api.fta_type

6790: -- Bug#2759379 Added FEGLI parameter
6791: ,p_fegli in out nocopy ghr_api.fegli_type
6792: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6793: -- Bug# 3385386 Added FTA parameter
6794: ,p_fta in out nocopy ghr_api.fta_type
6795: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6796: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6797: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6798: ,p_danger_pay in out nocopy ghr_api.danger_pay_type

Line 6795: ,p_edp_pay in out nocopy ghr_api.edp_pay_type

6791: ,p_fegli in out nocopy ghr_api.fegli_type
6792: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6793: -- Bug# 3385386 Added FTA parameter
6794: ,p_fta in out nocopy ghr_api.fta_type
6795: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6796: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6797: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6798: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6799: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type

Line 6796: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type

6792: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6793: -- Bug# 3385386 Added FTA parameter
6794: ,p_fta in out nocopy ghr_api.fta_type
6795: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6796: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6797: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6798: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6799: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6800: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type

Line 6797: ,p_health_benefits in out nocopy ghr_api.health_benefits_type

6793: -- Bug# 3385386 Added FTA parameter
6794: ,p_fta in out nocopy ghr_api.fta_type
6795: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6796: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6797: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6798: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6799: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6800: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6801: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type

Line 6798: ,p_danger_pay in out nocopy ghr_api.danger_pay_type

6794: ,p_fta in out nocopy ghr_api.fta_type
6795: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6796: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6797: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6798: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6799: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6800: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6801: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6802: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type

Line 6799: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type

6795: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6796: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6797: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6798: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6799: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6800: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6801: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6802: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6803: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type

Line 6800: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type

6796: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6797: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6798: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6799: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6800: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6801: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6802: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6803: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6804: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type

Line 6801: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type

6797: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6798: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6799: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6800: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6801: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6802: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6803: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6804: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6805: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type

Line 6802: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type

6798: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6799: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6800: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6801: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6802: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6803: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6804: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6805: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6806: ,p_premium_pay in out nocopy ghr_api.premium_pay_type

Line 6803: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type

6799: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6800: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6801: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6802: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6803: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6804: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6805: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6806: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6807: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type

Line 6804: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type

6800: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6801: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6802: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6803: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6804: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6805: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6806: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6807: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6808: ,p_severance_pay in out nocopy ghr_api.severance_pay_type

Line 6805: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type

6801: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6802: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6803: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6804: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6805: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6806: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6807: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6808: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6809: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan

Line 6806: ,p_premium_pay in out nocopy ghr_api.premium_pay_type

6802: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6803: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6804: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6805: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6806: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6807: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6808: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6809: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6810: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type

Line 6807: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type

6803: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6804: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6805: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6806: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6807: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6808: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6809: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6810: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
6811: --Bug # 13571004

Line 6808: ,p_severance_pay in out nocopy ghr_api.severance_pay_type

6804: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6805: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6806: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6807: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6808: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6809: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6810: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
6811: --Bug # 13571004
6812: ,p_tsp_roth in out nocopy ghr_api.tsp_roth_type

Line 6809: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan

6805: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6806: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6807: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6808: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6809: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6810: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
6811: --Bug # 13571004
6812: ,p_tsp_roth in out nocopy ghr_api.tsp_roth_type
6813: ) is

Line 6810: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type

6806: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6807: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6808: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6809: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6810: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
6811: --Bug # 13571004
6812: ,p_tsp_roth in out nocopy ghr_api.tsp_roth_type
6813: ) is
6814:

Line 6812: ,p_tsp_roth in out nocopy ghr_api.tsp_roth_type

6808: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6809: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6810: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
6811: --Bug # 13571004
6812: ,p_tsp_roth in out nocopy ghr_api.tsp_roth_type
6813: ) is
6814:
6815: l_proc varchar2(70) := 'Process_Non_salary_info';
6816: l_warning boolean;

Line 6820: l_recruitment_bonus ghr_api.recruitment_bonus_type;

6816: l_warning boolean;
6817: l_effective_date date;
6818: --
6819: -- No copy Changes.
6820: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6821: l_relocation_bonus ghr_api.relocation_bonus_type;
6822: l_gov_award ghr_api.government_awards_type;
6823: l_entitlement ghr_api.entitlement_type;
6824: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

Line 6821: l_relocation_bonus ghr_api.relocation_bonus_type;

6817: l_effective_date date;
6818: --
6819: -- No copy Changes.
6820: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6821: l_relocation_bonus ghr_api.relocation_bonus_type;
6822: l_gov_award ghr_api.government_awards_type;
6823: l_entitlement ghr_api.entitlement_type;
6824: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6825: -- Bug# 3385386 Added l_fta variable

Line 6822: l_gov_award ghr_api.government_awards_type;

6818: --
6819: -- No copy Changes.
6820: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6821: l_relocation_bonus ghr_api.relocation_bonus_type;
6822: l_gov_award ghr_api.government_awards_type;
6823: l_entitlement ghr_api.entitlement_type;
6824: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6825: -- Bug# 3385386 Added l_fta variable
6826: l_fta ghr_api.fta_type;

Line 6823: l_entitlement ghr_api.entitlement_type;

6819: -- No copy Changes.
6820: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6821: l_relocation_bonus ghr_api.relocation_bonus_type;
6822: l_gov_award ghr_api.government_awards_type;
6823: l_entitlement ghr_api.entitlement_type;
6824: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6825: -- Bug# 3385386 Added l_fta variable
6826: l_fta ghr_api.fta_type;
6827: l_edp_pay ghr_api.edp_pay_type;

Line 6824: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

6820: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6821: l_relocation_bonus ghr_api.relocation_bonus_type;
6822: l_gov_award ghr_api.government_awards_type;
6823: l_entitlement ghr_api.entitlement_type;
6824: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6825: -- Bug# 3385386 Added l_fta variable
6826: l_fta ghr_api.fta_type;
6827: l_edp_pay ghr_api.edp_pay_type;
6828: l_hazard_pay ghr_api.hazard_pay_type;

Line 6826: l_fta ghr_api.fta_type;

6822: l_gov_award ghr_api.government_awards_type;
6823: l_entitlement ghr_api.entitlement_type;
6824: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6825: -- Bug# 3385386 Added l_fta variable
6826: l_fta ghr_api.fta_type;
6827: l_edp_pay ghr_api.edp_pay_type;
6828: l_hazard_pay ghr_api.hazard_pay_type;
6829: l_health_benefits ghr_api.health_benefits_type;
6830: l_danger_pay ghr_api.danger_pay_type;

Line 6827: l_edp_pay ghr_api.edp_pay_type;

6823: l_entitlement ghr_api.entitlement_type;
6824: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6825: -- Bug# 3385386 Added l_fta variable
6826: l_fta ghr_api.fta_type;
6827: l_edp_pay ghr_api.edp_pay_type;
6828: l_hazard_pay ghr_api.hazard_pay_type;
6829: l_health_benefits ghr_api.health_benefits_type;
6830: l_danger_pay ghr_api.danger_pay_type;
6831: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;

Line 6828: l_hazard_pay ghr_api.hazard_pay_type;

6824: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6825: -- Bug# 3385386 Added l_fta variable
6826: l_fta ghr_api.fta_type;
6827: l_edp_pay ghr_api.edp_pay_type;
6828: l_hazard_pay ghr_api.hazard_pay_type;
6829: l_health_benefits ghr_api.health_benefits_type;
6830: l_danger_pay ghr_api.danger_pay_type;
6831: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6832: l_living_quarters_allow ghr_api.living_quarters_allow_type;

Line 6829: l_health_benefits ghr_api.health_benefits_type;

6825: -- Bug# 3385386 Added l_fta variable
6826: l_fta ghr_api.fta_type;
6827: l_edp_pay ghr_api.edp_pay_type;
6828: l_hazard_pay ghr_api.hazard_pay_type;
6829: l_health_benefits ghr_api.health_benefits_type;
6830: l_danger_pay ghr_api.danger_pay_type;
6831: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6832: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6833: l_post_diff_amt ghr_api.post_diff_amt_type;

Line 6830: l_danger_pay ghr_api.danger_pay_type;

6826: l_fta ghr_api.fta_type;
6827: l_edp_pay ghr_api.edp_pay_type;
6828: l_hazard_pay ghr_api.hazard_pay_type;
6829: l_health_benefits ghr_api.health_benefits_type;
6830: l_danger_pay ghr_api.danger_pay_type;
6831: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6832: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6833: l_post_diff_amt ghr_api.post_diff_amt_type;
6834: l_post_diff_percent ghr_api.post_diff_percent_type;

Line 6831: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;

6827: l_edp_pay ghr_api.edp_pay_type;
6828: l_hazard_pay ghr_api.hazard_pay_type;
6829: l_health_benefits ghr_api.health_benefits_type;
6830: l_danger_pay ghr_api.danger_pay_type;
6831: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6832: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6833: l_post_diff_amt ghr_api.post_diff_amt_type;
6834: l_post_diff_percent ghr_api.post_diff_percent_type;
6835: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

Line 6832: l_living_quarters_allow ghr_api.living_quarters_allow_type;

6828: l_hazard_pay ghr_api.hazard_pay_type;
6829: l_health_benefits ghr_api.health_benefits_type;
6830: l_danger_pay ghr_api.danger_pay_type;
6831: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6832: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6833: l_post_diff_amt ghr_api.post_diff_amt_type;
6834: l_post_diff_percent ghr_api.post_diff_percent_type;
6835: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6836: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;

Line 6833: l_post_diff_amt ghr_api.post_diff_amt_type;

6829: l_health_benefits ghr_api.health_benefits_type;
6830: l_danger_pay ghr_api.danger_pay_type;
6831: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6832: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6833: l_post_diff_amt ghr_api.post_diff_amt_type;
6834: l_post_diff_percent ghr_api.post_diff_percent_type;
6835: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6836: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6837: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;

Line 6834: l_post_diff_percent ghr_api.post_diff_percent_type;

6830: l_danger_pay ghr_api.danger_pay_type;
6831: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6832: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6833: l_post_diff_amt ghr_api.post_diff_amt_type;
6834: l_post_diff_percent ghr_api.post_diff_percent_type;
6835: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6836: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6837: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6838: l_premium_pay ghr_api.premium_pay_type;

Line 6835: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

6831: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6832: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6833: l_post_diff_amt ghr_api.post_diff_amt_type;
6834: l_post_diff_percent ghr_api.post_diff_percent_type;
6835: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6836: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6837: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6838: l_premium_pay ghr_api.premium_pay_type;
6839: l_retirement_annuity ghr_api.retirement_annuity_type;

Line 6836: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;

6832: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6833: l_post_diff_amt ghr_api.post_diff_amt_type;
6834: l_post_diff_percent ghr_api.post_diff_percent_type;
6835: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6836: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6837: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6838: l_premium_pay ghr_api.premium_pay_type;
6839: l_retirement_annuity ghr_api.retirement_annuity_type;
6840: l_severance_pay ghr_api.severance_pay_type;

Line 6837: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;

6833: l_post_diff_amt ghr_api.post_diff_amt_type;
6834: l_post_diff_percent ghr_api.post_diff_percent_type;
6835: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6836: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6837: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6838: l_premium_pay ghr_api.premium_pay_type;
6839: l_retirement_annuity ghr_api.retirement_annuity_type;
6840: l_severance_pay ghr_api.severance_pay_type;
6841: l_thrift_saving_plan ghr_api.thrift_saving_plan;

Line 6838: l_premium_pay ghr_api.premium_pay_type;

6834: l_post_diff_percent ghr_api.post_diff_percent_type;
6835: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6836: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6837: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6838: l_premium_pay ghr_api.premium_pay_type;
6839: l_retirement_annuity ghr_api.retirement_annuity_type;
6840: l_severance_pay ghr_api.severance_pay_type;
6841: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6842: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

Line 6839: l_retirement_annuity ghr_api.retirement_annuity_type;

6835: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6836: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6837: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6838: l_premium_pay ghr_api.premium_pay_type;
6839: l_retirement_annuity ghr_api.retirement_annuity_type;
6840: l_severance_pay ghr_api.severance_pay_type;
6841: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6842: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6843: l_student_loan_repay ghr_api.student_loan_repay_type;

Line 6840: l_severance_pay ghr_api.severance_pay_type;

6836: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6837: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6838: l_premium_pay ghr_api.premium_pay_type;
6839: l_retirement_annuity ghr_api.retirement_annuity_type;
6840: l_severance_pay ghr_api.severance_pay_type;
6841: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6842: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6843: l_student_loan_repay ghr_api.student_loan_repay_type;
6844: -- Bug#4486823 RRR Changes

Line 6841: l_thrift_saving_plan ghr_api.thrift_saving_plan;

6837: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6838: l_premium_pay ghr_api.premium_pay_type;
6839: l_retirement_annuity ghr_api.retirement_annuity_type;
6840: l_severance_pay ghr_api.severance_pay_type;
6841: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6842: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6843: l_student_loan_repay ghr_api.student_loan_repay_type;
6844: -- Bug#4486823 RRR Changes
6845: l_total_salary ghr_pa_requests.to_total_salary%TYPE;

Line 6842: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

6838: l_premium_pay ghr_api.premium_pay_type;
6839: l_retirement_annuity ghr_api.retirement_annuity_type;
6840: l_severance_pay ghr_api.severance_pay_type;
6841: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6842: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6843: l_student_loan_repay ghr_api.student_loan_repay_type;
6844: -- Bug#4486823 RRR Changes
6845: l_total_salary ghr_pa_requests.to_total_salary%TYPE;
6846: --

Line 6843: l_student_loan_repay ghr_api.student_loan_repay_type;

6839: l_retirement_annuity ghr_api.retirement_annuity_type;
6840: l_severance_pay ghr_api.severance_pay_type;
6841: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6842: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6843: l_student_loan_repay ghr_api.student_loan_repay_type;
6844: -- Bug#4486823 RRR Changes
6845: l_total_salary ghr_pa_requests.to_total_salary%TYPE;
6846: --
6847:

Line 6849: l_tsp_roth ghr_api.tsp_roth_type;

6845: l_total_salary ghr_pa_requests.to_total_salary%TYPE;
6846: --
6847:
6848: --Bug # 13571004
6849: l_tsp_roth ghr_api.tsp_roth_type;
6850: PROCEDURE Create_incentive_Remark(p_pa_request_id IN NUMBER,
6851: p_effective_date IN DATE,
6852: p_category IN VARCHAR2,
6853: p_noa_code IN VARCHAR2,

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

8221: l_pos_ei_data per_position_extra_info%ROWTYPE;
8222:
8223: Begin
8224: hr_utility.set_location('entering ' || l_proc,5);
8225: If nvl(p_pa_request_rec.pay_Rate_determinant,hr_api.g_varchar2) in ('A','B','E','F') then
8226: for next_from_step in c_next_Step loop
8227: hr_utility.set_location(l_proc,34);
8228: l_step_or_rate := next_from_step.to_step;
8229: end loop;

Line 8512: p_segment_rec in ghr_api.special_information_type

8508: --
8509: Procedure generic_update_sit
8510: (p_pa_request_rec in ghr_pa_requests%rowtype,
8511: p_special_information_type in fnd_id_flex_structures_tl.id_flex_structure_name%type,
8512: p_segment_rec in ghr_api.special_information_type
8513: )
8514: is
8515:
8516: l_proc varchar2(72) := 'Generic Update SIT';