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_API dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 13: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type

9: -- Record Types
10: -- Provided by Levin Mootoosamy
11: --
12: type extra_info_rec_type is record
13: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
14: ,l_object_version_number per_assignment_extra_info.object_version_number%type
15: ,l_information1 per_assignment_extra_info.aei_information1%type
16: ,l_information2 per_assignment_extra_info.aei_information2%type
17: ,l_information3 per_assignment_extra_info.aei_information3%type

Line 14: ,l_object_version_number per_assignment_extra_info.object_version_number%type

10: -- Provided by Levin Mootoosamy
11: --
12: type extra_info_rec_type is record
13: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
14: ,l_object_version_number per_assignment_extra_info.object_version_number%type
15: ,l_information1 per_assignment_extra_info.aei_information1%type
16: ,l_information2 per_assignment_extra_info.aei_information2%type
17: ,l_information3 per_assignment_extra_info.aei_information3%type
18: ,l_information4 per_assignment_extra_info.aei_information4%type

Line 15: ,l_information1 per_assignment_extra_info.aei_information1%type

11: --
12: type extra_info_rec_type is record
13: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
14: ,l_object_version_number per_assignment_extra_info.object_version_number%type
15: ,l_information1 per_assignment_extra_info.aei_information1%type
16: ,l_information2 per_assignment_extra_info.aei_information2%type
17: ,l_information3 per_assignment_extra_info.aei_information3%type
18: ,l_information4 per_assignment_extra_info.aei_information4%type
19: ,l_information5 per_assignment_extra_info.aei_information5%type

Line 16: ,l_information2 per_assignment_extra_info.aei_information2%type

12: type extra_info_rec_type is record
13: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
14: ,l_object_version_number per_assignment_extra_info.object_version_number%type
15: ,l_information1 per_assignment_extra_info.aei_information1%type
16: ,l_information2 per_assignment_extra_info.aei_information2%type
17: ,l_information3 per_assignment_extra_info.aei_information3%type
18: ,l_information4 per_assignment_extra_info.aei_information4%type
19: ,l_information5 per_assignment_extra_info.aei_information5%type
20: ,l_information6 per_assignment_extra_info.aei_information6%type

Line 17: ,l_information3 per_assignment_extra_info.aei_information3%type

13: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
14: ,l_object_version_number per_assignment_extra_info.object_version_number%type
15: ,l_information1 per_assignment_extra_info.aei_information1%type
16: ,l_information2 per_assignment_extra_info.aei_information2%type
17: ,l_information3 per_assignment_extra_info.aei_information3%type
18: ,l_information4 per_assignment_extra_info.aei_information4%type
19: ,l_information5 per_assignment_extra_info.aei_information5%type
20: ,l_information6 per_assignment_extra_info.aei_information6%type
21: ,l_information7 per_assignment_extra_info.aei_information7%type

Line 18: ,l_information4 per_assignment_extra_info.aei_information4%type

14: ,l_object_version_number per_assignment_extra_info.object_version_number%type
15: ,l_information1 per_assignment_extra_info.aei_information1%type
16: ,l_information2 per_assignment_extra_info.aei_information2%type
17: ,l_information3 per_assignment_extra_info.aei_information3%type
18: ,l_information4 per_assignment_extra_info.aei_information4%type
19: ,l_information5 per_assignment_extra_info.aei_information5%type
20: ,l_information6 per_assignment_extra_info.aei_information6%type
21: ,l_information7 per_assignment_extra_info.aei_information7%type
22: ,l_information8 per_assignment_extra_info.aei_information8%type

Line 19: ,l_information5 per_assignment_extra_info.aei_information5%type

15: ,l_information1 per_assignment_extra_info.aei_information1%type
16: ,l_information2 per_assignment_extra_info.aei_information2%type
17: ,l_information3 per_assignment_extra_info.aei_information3%type
18: ,l_information4 per_assignment_extra_info.aei_information4%type
19: ,l_information5 per_assignment_extra_info.aei_information5%type
20: ,l_information6 per_assignment_extra_info.aei_information6%type
21: ,l_information7 per_assignment_extra_info.aei_information7%type
22: ,l_information8 per_assignment_extra_info.aei_information8%type
23: ,l_information9 per_assignment_extra_info.aei_information9%type

Line 20: ,l_information6 per_assignment_extra_info.aei_information6%type

16: ,l_information2 per_assignment_extra_info.aei_information2%type
17: ,l_information3 per_assignment_extra_info.aei_information3%type
18: ,l_information4 per_assignment_extra_info.aei_information4%type
19: ,l_information5 per_assignment_extra_info.aei_information5%type
20: ,l_information6 per_assignment_extra_info.aei_information6%type
21: ,l_information7 per_assignment_extra_info.aei_information7%type
22: ,l_information8 per_assignment_extra_info.aei_information8%type
23: ,l_information9 per_assignment_extra_info.aei_information9%type
24: ,l_information10 per_assignment_extra_info.aei_information10%type

Line 21: ,l_information7 per_assignment_extra_info.aei_information7%type

17: ,l_information3 per_assignment_extra_info.aei_information3%type
18: ,l_information4 per_assignment_extra_info.aei_information4%type
19: ,l_information5 per_assignment_extra_info.aei_information5%type
20: ,l_information6 per_assignment_extra_info.aei_information6%type
21: ,l_information7 per_assignment_extra_info.aei_information7%type
22: ,l_information8 per_assignment_extra_info.aei_information8%type
23: ,l_information9 per_assignment_extra_info.aei_information9%type
24: ,l_information10 per_assignment_extra_info.aei_information10%type
25: ,l_information11 per_assignment_extra_info.aei_information11%type

Line 22: ,l_information8 per_assignment_extra_info.aei_information8%type

18: ,l_information4 per_assignment_extra_info.aei_information4%type
19: ,l_information5 per_assignment_extra_info.aei_information5%type
20: ,l_information6 per_assignment_extra_info.aei_information6%type
21: ,l_information7 per_assignment_extra_info.aei_information7%type
22: ,l_information8 per_assignment_extra_info.aei_information8%type
23: ,l_information9 per_assignment_extra_info.aei_information9%type
24: ,l_information10 per_assignment_extra_info.aei_information10%type
25: ,l_information11 per_assignment_extra_info.aei_information11%type
26: ,l_information12 per_assignment_extra_info.aei_information12%type

Line 23: ,l_information9 per_assignment_extra_info.aei_information9%type

19: ,l_information5 per_assignment_extra_info.aei_information5%type
20: ,l_information6 per_assignment_extra_info.aei_information6%type
21: ,l_information7 per_assignment_extra_info.aei_information7%type
22: ,l_information8 per_assignment_extra_info.aei_information8%type
23: ,l_information9 per_assignment_extra_info.aei_information9%type
24: ,l_information10 per_assignment_extra_info.aei_information10%type
25: ,l_information11 per_assignment_extra_info.aei_information11%type
26: ,l_information12 per_assignment_extra_info.aei_information12%type
27: ,l_information13 per_assignment_extra_info.aei_information13%type

Line 24: ,l_information10 per_assignment_extra_info.aei_information10%type

20: ,l_information6 per_assignment_extra_info.aei_information6%type
21: ,l_information7 per_assignment_extra_info.aei_information7%type
22: ,l_information8 per_assignment_extra_info.aei_information8%type
23: ,l_information9 per_assignment_extra_info.aei_information9%type
24: ,l_information10 per_assignment_extra_info.aei_information10%type
25: ,l_information11 per_assignment_extra_info.aei_information11%type
26: ,l_information12 per_assignment_extra_info.aei_information12%type
27: ,l_information13 per_assignment_extra_info.aei_information13%type
28: ,l_information14 per_assignment_extra_info.aei_information14%type

Line 25: ,l_information11 per_assignment_extra_info.aei_information11%type

21: ,l_information7 per_assignment_extra_info.aei_information7%type
22: ,l_information8 per_assignment_extra_info.aei_information8%type
23: ,l_information9 per_assignment_extra_info.aei_information9%type
24: ,l_information10 per_assignment_extra_info.aei_information10%type
25: ,l_information11 per_assignment_extra_info.aei_information11%type
26: ,l_information12 per_assignment_extra_info.aei_information12%type
27: ,l_information13 per_assignment_extra_info.aei_information13%type
28: ,l_information14 per_assignment_extra_info.aei_information14%type
29: ,l_information15 per_assignment_extra_info.aei_information15%type

Line 26: ,l_information12 per_assignment_extra_info.aei_information12%type

22: ,l_information8 per_assignment_extra_info.aei_information8%type
23: ,l_information9 per_assignment_extra_info.aei_information9%type
24: ,l_information10 per_assignment_extra_info.aei_information10%type
25: ,l_information11 per_assignment_extra_info.aei_information11%type
26: ,l_information12 per_assignment_extra_info.aei_information12%type
27: ,l_information13 per_assignment_extra_info.aei_information13%type
28: ,l_information14 per_assignment_extra_info.aei_information14%type
29: ,l_information15 per_assignment_extra_info.aei_information15%type
30: ,l_information16 per_assignment_extra_info.aei_information16%type

Line 27: ,l_information13 per_assignment_extra_info.aei_information13%type

23: ,l_information9 per_assignment_extra_info.aei_information9%type
24: ,l_information10 per_assignment_extra_info.aei_information10%type
25: ,l_information11 per_assignment_extra_info.aei_information11%type
26: ,l_information12 per_assignment_extra_info.aei_information12%type
27: ,l_information13 per_assignment_extra_info.aei_information13%type
28: ,l_information14 per_assignment_extra_info.aei_information14%type
29: ,l_information15 per_assignment_extra_info.aei_information15%type
30: ,l_information16 per_assignment_extra_info.aei_information16%type
31: ,l_information17 per_assignment_extra_info.aei_information17%type

Line 28: ,l_information14 per_assignment_extra_info.aei_information14%type

24: ,l_information10 per_assignment_extra_info.aei_information10%type
25: ,l_information11 per_assignment_extra_info.aei_information11%type
26: ,l_information12 per_assignment_extra_info.aei_information12%type
27: ,l_information13 per_assignment_extra_info.aei_information13%type
28: ,l_information14 per_assignment_extra_info.aei_information14%type
29: ,l_information15 per_assignment_extra_info.aei_information15%type
30: ,l_information16 per_assignment_extra_info.aei_information16%type
31: ,l_information17 per_assignment_extra_info.aei_information17%type
32: ,l_information18 per_assignment_extra_info.aei_information18%type

Line 29: ,l_information15 per_assignment_extra_info.aei_information15%type

25: ,l_information11 per_assignment_extra_info.aei_information11%type
26: ,l_information12 per_assignment_extra_info.aei_information12%type
27: ,l_information13 per_assignment_extra_info.aei_information13%type
28: ,l_information14 per_assignment_extra_info.aei_information14%type
29: ,l_information15 per_assignment_extra_info.aei_information15%type
30: ,l_information16 per_assignment_extra_info.aei_information16%type
31: ,l_information17 per_assignment_extra_info.aei_information17%type
32: ,l_information18 per_assignment_extra_info.aei_information18%type
33: ,l_information19 per_assignment_extra_info.aei_information19%type

Line 30: ,l_information16 per_assignment_extra_info.aei_information16%type

26: ,l_information12 per_assignment_extra_info.aei_information12%type
27: ,l_information13 per_assignment_extra_info.aei_information13%type
28: ,l_information14 per_assignment_extra_info.aei_information14%type
29: ,l_information15 per_assignment_extra_info.aei_information15%type
30: ,l_information16 per_assignment_extra_info.aei_information16%type
31: ,l_information17 per_assignment_extra_info.aei_information17%type
32: ,l_information18 per_assignment_extra_info.aei_information18%type
33: ,l_information19 per_assignment_extra_info.aei_information19%type
34: ,l_information20 per_assignment_extra_info.aei_information20%type

Line 31: ,l_information17 per_assignment_extra_info.aei_information17%type

27: ,l_information13 per_assignment_extra_info.aei_information13%type
28: ,l_information14 per_assignment_extra_info.aei_information14%type
29: ,l_information15 per_assignment_extra_info.aei_information15%type
30: ,l_information16 per_assignment_extra_info.aei_information16%type
31: ,l_information17 per_assignment_extra_info.aei_information17%type
32: ,l_information18 per_assignment_extra_info.aei_information18%type
33: ,l_information19 per_assignment_extra_info.aei_information19%type
34: ,l_information20 per_assignment_extra_info.aei_information20%type
35: ,l_information21 per_assignment_extra_info.aei_information21%type

Line 32: ,l_information18 per_assignment_extra_info.aei_information18%type

28: ,l_information14 per_assignment_extra_info.aei_information14%type
29: ,l_information15 per_assignment_extra_info.aei_information15%type
30: ,l_information16 per_assignment_extra_info.aei_information16%type
31: ,l_information17 per_assignment_extra_info.aei_information17%type
32: ,l_information18 per_assignment_extra_info.aei_information18%type
33: ,l_information19 per_assignment_extra_info.aei_information19%type
34: ,l_information20 per_assignment_extra_info.aei_information20%type
35: ,l_information21 per_assignment_extra_info.aei_information21%type
36: ,l_information22 per_assignment_extra_info.aei_information22%type

Line 33: ,l_information19 per_assignment_extra_info.aei_information19%type

29: ,l_information15 per_assignment_extra_info.aei_information15%type
30: ,l_information16 per_assignment_extra_info.aei_information16%type
31: ,l_information17 per_assignment_extra_info.aei_information17%type
32: ,l_information18 per_assignment_extra_info.aei_information18%type
33: ,l_information19 per_assignment_extra_info.aei_information19%type
34: ,l_information20 per_assignment_extra_info.aei_information20%type
35: ,l_information21 per_assignment_extra_info.aei_information21%type
36: ,l_information22 per_assignment_extra_info.aei_information22%type
37: ,l_information23 per_assignment_extra_info.aei_information23%type

Line 34: ,l_information20 per_assignment_extra_info.aei_information20%type

30: ,l_information16 per_assignment_extra_info.aei_information16%type
31: ,l_information17 per_assignment_extra_info.aei_information17%type
32: ,l_information18 per_assignment_extra_info.aei_information18%type
33: ,l_information19 per_assignment_extra_info.aei_information19%type
34: ,l_information20 per_assignment_extra_info.aei_information20%type
35: ,l_information21 per_assignment_extra_info.aei_information21%type
36: ,l_information22 per_assignment_extra_info.aei_information22%type
37: ,l_information23 per_assignment_extra_info.aei_information23%type
38: ,l_information24 per_assignment_extra_info.aei_information24%type

Line 35: ,l_information21 per_assignment_extra_info.aei_information21%type

31: ,l_information17 per_assignment_extra_info.aei_information17%type
32: ,l_information18 per_assignment_extra_info.aei_information18%type
33: ,l_information19 per_assignment_extra_info.aei_information19%type
34: ,l_information20 per_assignment_extra_info.aei_information20%type
35: ,l_information21 per_assignment_extra_info.aei_information21%type
36: ,l_information22 per_assignment_extra_info.aei_information22%type
37: ,l_information23 per_assignment_extra_info.aei_information23%type
38: ,l_information24 per_assignment_extra_info.aei_information24%type
39: ,l_information25 per_assignment_extra_info.aei_information25%type

Line 36: ,l_information22 per_assignment_extra_info.aei_information22%type

32: ,l_information18 per_assignment_extra_info.aei_information18%type
33: ,l_information19 per_assignment_extra_info.aei_information19%type
34: ,l_information20 per_assignment_extra_info.aei_information20%type
35: ,l_information21 per_assignment_extra_info.aei_information21%type
36: ,l_information22 per_assignment_extra_info.aei_information22%type
37: ,l_information23 per_assignment_extra_info.aei_information23%type
38: ,l_information24 per_assignment_extra_info.aei_information24%type
39: ,l_information25 per_assignment_extra_info.aei_information25%type
40: ,l_information26 per_assignment_extra_info.aei_information26%type

Line 37: ,l_information23 per_assignment_extra_info.aei_information23%type

33: ,l_information19 per_assignment_extra_info.aei_information19%type
34: ,l_information20 per_assignment_extra_info.aei_information20%type
35: ,l_information21 per_assignment_extra_info.aei_information21%type
36: ,l_information22 per_assignment_extra_info.aei_information22%type
37: ,l_information23 per_assignment_extra_info.aei_information23%type
38: ,l_information24 per_assignment_extra_info.aei_information24%type
39: ,l_information25 per_assignment_extra_info.aei_information25%type
40: ,l_information26 per_assignment_extra_info.aei_information26%type
41: ,l_information27 per_assignment_extra_info.aei_information27%type

Line 38: ,l_information24 per_assignment_extra_info.aei_information24%type

34: ,l_information20 per_assignment_extra_info.aei_information20%type
35: ,l_information21 per_assignment_extra_info.aei_information21%type
36: ,l_information22 per_assignment_extra_info.aei_information22%type
37: ,l_information23 per_assignment_extra_info.aei_information23%type
38: ,l_information24 per_assignment_extra_info.aei_information24%type
39: ,l_information25 per_assignment_extra_info.aei_information25%type
40: ,l_information26 per_assignment_extra_info.aei_information26%type
41: ,l_information27 per_assignment_extra_info.aei_information27%type
42: ,l_information28 per_assignment_extra_info.aei_information28%type

Line 39: ,l_information25 per_assignment_extra_info.aei_information25%type

35: ,l_information21 per_assignment_extra_info.aei_information21%type
36: ,l_information22 per_assignment_extra_info.aei_information22%type
37: ,l_information23 per_assignment_extra_info.aei_information23%type
38: ,l_information24 per_assignment_extra_info.aei_information24%type
39: ,l_information25 per_assignment_extra_info.aei_information25%type
40: ,l_information26 per_assignment_extra_info.aei_information26%type
41: ,l_information27 per_assignment_extra_info.aei_information27%type
42: ,l_information28 per_assignment_extra_info.aei_information28%type
43: ,l_information29 per_assignment_extra_info.aei_information29%type

Line 40: ,l_information26 per_assignment_extra_info.aei_information26%type

36: ,l_information22 per_assignment_extra_info.aei_information22%type
37: ,l_information23 per_assignment_extra_info.aei_information23%type
38: ,l_information24 per_assignment_extra_info.aei_information24%type
39: ,l_information25 per_assignment_extra_info.aei_information25%type
40: ,l_information26 per_assignment_extra_info.aei_information26%type
41: ,l_information27 per_assignment_extra_info.aei_information27%type
42: ,l_information28 per_assignment_extra_info.aei_information28%type
43: ,l_information29 per_assignment_extra_info.aei_information29%type
44: ,l_information30 per_assignment_extra_info.aei_information30%type);

Line 41: ,l_information27 per_assignment_extra_info.aei_information27%type

37: ,l_information23 per_assignment_extra_info.aei_information23%type
38: ,l_information24 per_assignment_extra_info.aei_information24%type
39: ,l_information25 per_assignment_extra_info.aei_information25%type
40: ,l_information26 per_assignment_extra_info.aei_information26%type
41: ,l_information27 per_assignment_extra_info.aei_information27%type
42: ,l_information28 per_assignment_extra_info.aei_information28%type
43: ,l_information29 per_assignment_extra_info.aei_information29%type
44: ,l_information30 per_assignment_extra_info.aei_information30%type);
45: --

Line 42: ,l_information28 per_assignment_extra_info.aei_information28%type

38: ,l_information24 per_assignment_extra_info.aei_information24%type
39: ,l_information25 per_assignment_extra_info.aei_information25%type
40: ,l_information26 per_assignment_extra_info.aei_information26%type
41: ,l_information27 per_assignment_extra_info.aei_information27%type
42: ,l_information28 per_assignment_extra_info.aei_information28%type
43: ,l_information29 per_assignment_extra_info.aei_information29%type
44: ,l_information30 per_assignment_extra_info.aei_information30%type);
45: --
46: type generic_extra_info_rec_type is record

Line 43: ,l_information29 per_assignment_extra_info.aei_information29%type

39: ,l_information25 per_assignment_extra_info.aei_information25%type
40: ,l_information26 per_assignment_extra_info.aei_information26%type
41: ,l_information27 per_assignment_extra_info.aei_information27%type
42: ,l_information28 per_assignment_extra_info.aei_information28%type
43: ,l_information29 per_assignment_extra_info.aei_information29%type
44: ,l_information30 per_assignment_extra_info.aei_information30%type);
45: --
46: type generic_extra_info_rec_type is record
47: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type

Line 44: ,l_information30 per_assignment_extra_info.aei_information30%type);

40: ,l_information26 per_assignment_extra_info.aei_information26%type
41: ,l_information27 per_assignment_extra_info.aei_information27%type
42: ,l_information28 per_assignment_extra_info.aei_information28%type
43: ,l_information29 per_assignment_extra_info.aei_information29%type
44: ,l_information30 per_assignment_extra_info.aei_information30%type);
45: --
46: type generic_extra_info_rec_type is record
47: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
48: ,l_object_version_number per_assignment_extra_info.object_version_number%type

Line 47: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type

43: ,l_information29 per_assignment_extra_info.aei_information29%type
44: ,l_information30 per_assignment_extra_info.aei_information30%type);
45: --
46: type generic_extra_info_rec_type is record
47: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
48: ,l_object_version_number per_assignment_extra_info.object_version_number%type
49: ,l_information1 per_assignment_extra_info.aei_information1%type
50: ,l_information2 per_assignment_extra_info.aei_information2%type
51: ,l_information3 per_assignment_extra_info.aei_information3%type

Line 48: ,l_object_version_number per_assignment_extra_info.object_version_number%type

44: ,l_information30 per_assignment_extra_info.aei_information30%type);
45: --
46: type generic_extra_info_rec_type is record
47: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
48: ,l_object_version_number per_assignment_extra_info.object_version_number%type
49: ,l_information1 per_assignment_extra_info.aei_information1%type
50: ,l_information2 per_assignment_extra_info.aei_information2%type
51: ,l_information3 per_assignment_extra_info.aei_information3%type
52: ,l_information4 per_assignment_extra_info.aei_information4%type

Line 49: ,l_information1 per_assignment_extra_info.aei_information1%type

45: --
46: type generic_extra_info_rec_type is record
47: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
48: ,l_object_version_number per_assignment_extra_info.object_version_number%type
49: ,l_information1 per_assignment_extra_info.aei_information1%type
50: ,l_information2 per_assignment_extra_info.aei_information2%type
51: ,l_information3 per_assignment_extra_info.aei_information3%type
52: ,l_information4 per_assignment_extra_info.aei_information4%type
53: ,l_information5 per_assignment_extra_info.aei_information5%type

Line 50: ,l_information2 per_assignment_extra_info.aei_information2%type

46: type generic_extra_info_rec_type is record
47: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
48: ,l_object_version_number per_assignment_extra_info.object_version_number%type
49: ,l_information1 per_assignment_extra_info.aei_information1%type
50: ,l_information2 per_assignment_extra_info.aei_information2%type
51: ,l_information3 per_assignment_extra_info.aei_information3%type
52: ,l_information4 per_assignment_extra_info.aei_information4%type
53: ,l_information5 per_assignment_extra_info.aei_information5%type
54: ,l_information6 per_assignment_extra_info.aei_information6%type

Line 51: ,l_information3 per_assignment_extra_info.aei_information3%type

47: (l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
48: ,l_object_version_number per_assignment_extra_info.object_version_number%type
49: ,l_information1 per_assignment_extra_info.aei_information1%type
50: ,l_information2 per_assignment_extra_info.aei_information2%type
51: ,l_information3 per_assignment_extra_info.aei_information3%type
52: ,l_information4 per_assignment_extra_info.aei_information4%type
53: ,l_information5 per_assignment_extra_info.aei_information5%type
54: ,l_information6 per_assignment_extra_info.aei_information6%type
55: ,l_information7 per_assignment_extra_info.aei_information7%type

Line 52: ,l_information4 per_assignment_extra_info.aei_information4%type

48: ,l_object_version_number per_assignment_extra_info.object_version_number%type
49: ,l_information1 per_assignment_extra_info.aei_information1%type
50: ,l_information2 per_assignment_extra_info.aei_information2%type
51: ,l_information3 per_assignment_extra_info.aei_information3%type
52: ,l_information4 per_assignment_extra_info.aei_information4%type
53: ,l_information5 per_assignment_extra_info.aei_information5%type
54: ,l_information6 per_assignment_extra_info.aei_information6%type
55: ,l_information7 per_assignment_extra_info.aei_information7%type
56: ,l_information8 per_assignment_extra_info.aei_information8%type

Line 53: ,l_information5 per_assignment_extra_info.aei_information5%type

49: ,l_information1 per_assignment_extra_info.aei_information1%type
50: ,l_information2 per_assignment_extra_info.aei_information2%type
51: ,l_information3 per_assignment_extra_info.aei_information3%type
52: ,l_information4 per_assignment_extra_info.aei_information4%type
53: ,l_information5 per_assignment_extra_info.aei_information5%type
54: ,l_information6 per_assignment_extra_info.aei_information6%type
55: ,l_information7 per_assignment_extra_info.aei_information7%type
56: ,l_information8 per_assignment_extra_info.aei_information8%type
57: ,l_information9 per_assignment_extra_info.aei_information9%type

Line 54: ,l_information6 per_assignment_extra_info.aei_information6%type

50: ,l_information2 per_assignment_extra_info.aei_information2%type
51: ,l_information3 per_assignment_extra_info.aei_information3%type
52: ,l_information4 per_assignment_extra_info.aei_information4%type
53: ,l_information5 per_assignment_extra_info.aei_information5%type
54: ,l_information6 per_assignment_extra_info.aei_information6%type
55: ,l_information7 per_assignment_extra_info.aei_information7%type
56: ,l_information8 per_assignment_extra_info.aei_information8%type
57: ,l_information9 per_assignment_extra_info.aei_information9%type
58: ,l_information10 per_assignment_extra_info.aei_information10%type

Line 55: ,l_information7 per_assignment_extra_info.aei_information7%type

51: ,l_information3 per_assignment_extra_info.aei_information3%type
52: ,l_information4 per_assignment_extra_info.aei_information4%type
53: ,l_information5 per_assignment_extra_info.aei_information5%type
54: ,l_information6 per_assignment_extra_info.aei_information6%type
55: ,l_information7 per_assignment_extra_info.aei_information7%type
56: ,l_information8 per_assignment_extra_info.aei_information8%type
57: ,l_information9 per_assignment_extra_info.aei_information9%type
58: ,l_information10 per_assignment_extra_info.aei_information10%type
59: ,l_information11 per_assignment_extra_info.aei_information11%type

Line 56: ,l_information8 per_assignment_extra_info.aei_information8%type

52: ,l_information4 per_assignment_extra_info.aei_information4%type
53: ,l_information5 per_assignment_extra_info.aei_information5%type
54: ,l_information6 per_assignment_extra_info.aei_information6%type
55: ,l_information7 per_assignment_extra_info.aei_information7%type
56: ,l_information8 per_assignment_extra_info.aei_information8%type
57: ,l_information9 per_assignment_extra_info.aei_information9%type
58: ,l_information10 per_assignment_extra_info.aei_information10%type
59: ,l_information11 per_assignment_extra_info.aei_information11%type
60: ,l_information12 per_assignment_extra_info.aei_information12%type

Line 57: ,l_information9 per_assignment_extra_info.aei_information9%type

53: ,l_information5 per_assignment_extra_info.aei_information5%type
54: ,l_information6 per_assignment_extra_info.aei_information6%type
55: ,l_information7 per_assignment_extra_info.aei_information7%type
56: ,l_information8 per_assignment_extra_info.aei_information8%type
57: ,l_information9 per_assignment_extra_info.aei_information9%type
58: ,l_information10 per_assignment_extra_info.aei_information10%type
59: ,l_information11 per_assignment_extra_info.aei_information11%type
60: ,l_information12 per_assignment_extra_info.aei_information12%type
61: ,l_information13 per_assignment_extra_info.aei_information13%type

Line 58: ,l_information10 per_assignment_extra_info.aei_information10%type

54: ,l_information6 per_assignment_extra_info.aei_information6%type
55: ,l_information7 per_assignment_extra_info.aei_information7%type
56: ,l_information8 per_assignment_extra_info.aei_information8%type
57: ,l_information9 per_assignment_extra_info.aei_information9%type
58: ,l_information10 per_assignment_extra_info.aei_information10%type
59: ,l_information11 per_assignment_extra_info.aei_information11%type
60: ,l_information12 per_assignment_extra_info.aei_information12%type
61: ,l_information13 per_assignment_extra_info.aei_information13%type
62: ,l_information14 per_assignment_extra_info.aei_information14%type

Line 59: ,l_information11 per_assignment_extra_info.aei_information11%type

55: ,l_information7 per_assignment_extra_info.aei_information7%type
56: ,l_information8 per_assignment_extra_info.aei_information8%type
57: ,l_information9 per_assignment_extra_info.aei_information9%type
58: ,l_information10 per_assignment_extra_info.aei_information10%type
59: ,l_information11 per_assignment_extra_info.aei_information11%type
60: ,l_information12 per_assignment_extra_info.aei_information12%type
61: ,l_information13 per_assignment_extra_info.aei_information13%type
62: ,l_information14 per_assignment_extra_info.aei_information14%type
63: ,l_information15 per_assignment_extra_info.aei_information15%type

Line 60: ,l_information12 per_assignment_extra_info.aei_information12%type

56: ,l_information8 per_assignment_extra_info.aei_information8%type
57: ,l_information9 per_assignment_extra_info.aei_information9%type
58: ,l_information10 per_assignment_extra_info.aei_information10%type
59: ,l_information11 per_assignment_extra_info.aei_information11%type
60: ,l_information12 per_assignment_extra_info.aei_information12%type
61: ,l_information13 per_assignment_extra_info.aei_information13%type
62: ,l_information14 per_assignment_extra_info.aei_information14%type
63: ,l_information15 per_assignment_extra_info.aei_information15%type
64: ,l_information16 per_assignment_extra_info.aei_information16%type

Line 61: ,l_information13 per_assignment_extra_info.aei_information13%type

57: ,l_information9 per_assignment_extra_info.aei_information9%type
58: ,l_information10 per_assignment_extra_info.aei_information10%type
59: ,l_information11 per_assignment_extra_info.aei_information11%type
60: ,l_information12 per_assignment_extra_info.aei_information12%type
61: ,l_information13 per_assignment_extra_info.aei_information13%type
62: ,l_information14 per_assignment_extra_info.aei_information14%type
63: ,l_information15 per_assignment_extra_info.aei_information15%type
64: ,l_information16 per_assignment_extra_info.aei_information16%type
65: ,l_information17 per_assignment_extra_info.aei_information17%type

Line 62: ,l_information14 per_assignment_extra_info.aei_information14%type

58: ,l_information10 per_assignment_extra_info.aei_information10%type
59: ,l_information11 per_assignment_extra_info.aei_information11%type
60: ,l_information12 per_assignment_extra_info.aei_information12%type
61: ,l_information13 per_assignment_extra_info.aei_information13%type
62: ,l_information14 per_assignment_extra_info.aei_information14%type
63: ,l_information15 per_assignment_extra_info.aei_information15%type
64: ,l_information16 per_assignment_extra_info.aei_information16%type
65: ,l_information17 per_assignment_extra_info.aei_information17%type
66: ,l_information18 per_assignment_extra_info.aei_information18%type

Line 63: ,l_information15 per_assignment_extra_info.aei_information15%type

59: ,l_information11 per_assignment_extra_info.aei_information11%type
60: ,l_information12 per_assignment_extra_info.aei_information12%type
61: ,l_information13 per_assignment_extra_info.aei_information13%type
62: ,l_information14 per_assignment_extra_info.aei_information14%type
63: ,l_information15 per_assignment_extra_info.aei_information15%type
64: ,l_information16 per_assignment_extra_info.aei_information16%type
65: ,l_information17 per_assignment_extra_info.aei_information17%type
66: ,l_information18 per_assignment_extra_info.aei_information18%type
67: ,l_information19 per_assignment_extra_info.aei_information19%type

Line 64: ,l_information16 per_assignment_extra_info.aei_information16%type

60: ,l_information12 per_assignment_extra_info.aei_information12%type
61: ,l_information13 per_assignment_extra_info.aei_information13%type
62: ,l_information14 per_assignment_extra_info.aei_information14%type
63: ,l_information15 per_assignment_extra_info.aei_information15%type
64: ,l_information16 per_assignment_extra_info.aei_information16%type
65: ,l_information17 per_assignment_extra_info.aei_information17%type
66: ,l_information18 per_assignment_extra_info.aei_information18%type
67: ,l_information19 per_assignment_extra_info.aei_information19%type
68: ,l_information20 per_assignment_extra_info.aei_information20%type

Line 65: ,l_information17 per_assignment_extra_info.aei_information17%type

61: ,l_information13 per_assignment_extra_info.aei_information13%type
62: ,l_information14 per_assignment_extra_info.aei_information14%type
63: ,l_information15 per_assignment_extra_info.aei_information15%type
64: ,l_information16 per_assignment_extra_info.aei_information16%type
65: ,l_information17 per_assignment_extra_info.aei_information17%type
66: ,l_information18 per_assignment_extra_info.aei_information18%type
67: ,l_information19 per_assignment_extra_info.aei_information19%type
68: ,l_information20 per_assignment_extra_info.aei_information20%type
69: ,l_information21 per_assignment_extra_info.aei_information21%type

Line 66: ,l_information18 per_assignment_extra_info.aei_information18%type

62: ,l_information14 per_assignment_extra_info.aei_information14%type
63: ,l_information15 per_assignment_extra_info.aei_information15%type
64: ,l_information16 per_assignment_extra_info.aei_information16%type
65: ,l_information17 per_assignment_extra_info.aei_information17%type
66: ,l_information18 per_assignment_extra_info.aei_information18%type
67: ,l_information19 per_assignment_extra_info.aei_information19%type
68: ,l_information20 per_assignment_extra_info.aei_information20%type
69: ,l_information21 per_assignment_extra_info.aei_information21%type
70: ,l_information22 per_assignment_extra_info.aei_information22%type

Line 67: ,l_information19 per_assignment_extra_info.aei_information19%type

63: ,l_information15 per_assignment_extra_info.aei_information15%type
64: ,l_information16 per_assignment_extra_info.aei_information16%type
65: ,l_information17 per_assignment_extra_info.aei_information17%type
66: ,l_information18 per_assignment_extra_info.aei_information18%type
67: ,l_information19 per_assignment_extra_info.aei_information19%type
68: ,l_information20 per_assignment_extra_info.aei_information20%type
69: ,l_information21 per_assignment_extra_info.aei_information21%type
70: ,l_information22 per_assignment_extra_info.aei_information22%type
71: ,l_information23 per_assignment_extra_info.aei_information23%type

Line 68: ,l_information20 per_assignment_extra_info.aei_information20%type

64: ,l_information16 per_assignment_extra_info.aei_information16%type
65: ,l_information17 per_assignment_extra_info.aei_information17%type
66: ,l_information18 per_assignment_extra_info.aei_information18%type
67: ,l_information19 per_assignment_extra_info.aei_information19%type
68: ,l_information20 per_assignment_extra_info.aei_information20%type
69: ,l_information21 per_assignment_extra_info.aei_information21%type
70: ,l_information22 per_assignment_extra_info.aei_information22%type
71: ,l_information23 per_assignment_extra_info.aei_information23%type
72: ,l_information24 per_assignment_extra_info.aei_information24%type

Line 69: ,l_information21 per_assignment_extra_info.aei_information21%type

65: ,l_information17 per_assignment_extra_info.aei_information17%type
66: ,l_information18 per_assignment_extra_info.aei_information18%type
67: ,l_information19 per_assignment_extra_info.aei_information19%type
68: ,l_information20 per_assignment_extra_info.aei_information20%type
69: ,l_information21 per_assignment_extra_info.aei_information21%type
70: ,l_information22 per_assignment_extra_info.aei_information22%type
71: ,l_information23 per_assignment_extra_info.aei_information23%type
72: ,l_information24 per_assignment_extra_info.aei_information24%type
73: ,l_information25 per_assignment_extra_info.aei_information25%type

Line 70: ,l_information22 per_assignment_extra_info.aei_information22%type

66: ,l_information18 per_assignment_extra_info.aei_information18%type
67: ,l_information19 per_assignment_extra_info.aei_information19%type
68: ,l_information20 per_assignment_extra_info.aei_information20%type
69: ,l_information21 per_assignment_extra_info.aei_information21%type
70: ,l_information22 per_assignment_extra_info.aei_information22%type
71: ,l_information23 per_assignment_extra_info.aei_information23%type
72: ,l_information24 per_assignment_extra_info.aei_information24%type
73: ,l_information25 per_assignment_extra_info.aei_information25%type
74: ,l_information26 per_assignment_extra_info.aei_information26%type

Line 71: ,l_information23 per_assignment_extra_info.aei_information23%type

67: ,l_information19 per_assignment_extra_info.aei_information19%type
68: ,l_information20 per_assignment_extra_info.aei_information20%type
69: ,l_information21 per_assignment_extra_info.aei_information21%type
70: ,l_information22 per_assignment_extra_info.aei_information22%type
71: ,l_information23 per_assignment_extra_info.aei_information23%type
72: ,l_information24 per_assignment_extra_info.aei_information24%type
73: ,l_information25 per_assignment_extra_info.aei_information25%type
74: ,l_information26 per_assignment_extra_info.aei_information26%type
75: ,l_information27 per_assignment_extra_info.aei_information27%type

Line 72: ,l_information24 per_assignment_extra_info.aei_information24%type

68: ,l_information20 per_assignment_extra_info.aei_information20%type
69: ,l_information21 per_assignment_extra_info.aei_information21%type
70: ,l_information22 per_assignment_extra_info.aei_information22%type
71: ,l_information23 per_assignment_extra_info.aei_information23%type
72: ,l_information24 per_assignment_extra_info.aei_information24%type
73: ,l_information25 per_assignment_extra_info.aei_information25%type
74: ,l_information26 per_assignment_extra_info.aei_information26%type
75: ,l_information27 per_assignment_extra_info.aei_information27%type
76: ,l_information28 per_assignment_extra_info.aei_information28%type

Line 73: ,l_information25 per_assignment_extra_info.aei_information25%type

69: ,l_information21 per_assignment_extra_info.aei_information21%type
70: ,l_information22 per_assignment_extra_info.aei_information22%type
71: ,l_information23 per_assignment_extra_info.aei_information23%type
72: ,l_information24 per_assignment_extra_info.aei_information24%type
73: ,l_information25 per_assignment_extra_info.aei_information25%type
74: ,l_information26 per_assignment_extra_info.aei_information26%type
75: ,l_information27 per_assignment_extra_info.aei_information27%type
76: ,l_information28 per_assignment_extra_info.aei_information28%type
77: ,l_information29 per_assignment_extra_info.aei_information29%type

Line 74: ,l_information26 per_assignment_extra_info.aei_information26%type

70: ,l_information22 per_assignment_extra_info.aei_information22%type
71: ,l_information23 per_assignment_extra_info.aei_information23%type
72: ,l_information24 per_assignment_extra_info.aei_information24%type
73: ,l_information25 per_assignment_extra_info.aei_information25%type
74: ,l_information26 per_assignment_extra_info.aei_information26%type
75: ,l_information27 per_assignment_extra_info.aei_information27%type
76: ,l_information28 per_assignment_extra_info.aei_information28%type
77: ,l_information29 per_assignment_extra_info.aei_information29%type
78: ,l_information30 per_assignment_extra_info.aei_information30%type);

Line 75: ,l_information27 per_assignment_extra_info.aei_information27%type

71: ,l_information23 per_assignment_extra_info.aei_information23%type
72: ,l_information24 per_assignment_extra_info.aei_information24%type
73: ,l_information25 per_assignment_extra_info.aei_information25%type
74: ,l_information26 per_assignment_extra_info.aei_information26%type
75: ,l_information27 per_assignment_extra_info.aei_information27%type
76: ,l_information28 per_assignment_extra_info.aei_information28%type
77: ,l_information29 per_assignment_extra_info.aei_information29%type
78: ,l_information30 per_assignment_extra_info.aei_information30%type);
79: --

Line 76: ,l_information28 per_assignment_extra_info.aei_information28%type

72: ,l_information24 per_assignment_extra_info.aei_information24%type
73: ,l_information25 per_assignment_extra_info.aei_information25%type
74: ,l_information26 per_assignment_extra_info.aei_information26%type
75: ,l_information27 per_assignment_extra_info.aei_information27%type
76: ,l_information28 per_assignment_extra_info.aei_information28%type
77: ,l_information29 per_assignment_extra_info.aei_information29%type
78: ,l_information30 per_assignment_extra_info.aei_information30%type);
79: --
80: type asg_sf52_type is record

Line 77: ,l_information29 per_assignment_extra_info.aei_information29%type

73: ,l_information25 per_assignment_extra_info.aei_information25%type
74: ,l_information26 per_assignment_extra_info.aei_information26%type
75: ,l_information27 per_assignment_extra_info.aei_information27%type
76: ,l_information28 per_assignment_extra_info.aei_information28%type
77: ,l_information29 per_assignment_extra_info.aei_information29%type
78: ,l_information30 per_assignment_extra_info.aei_information30%type);
79: --
80: type asg_sf52_type is record
81: (asg_sf52_flag varchar2(1)

Line 78: ,l_information30 per_assignment_extra_info.aei_information30%type);

74: ,l_information26 per_assignment_extra_info.aei_information26%type
75: ,l_information27 per_assignment_extra_info.aei_information27%type
76: ,l_information28 per_assignment_extra_info.aei_information28%type
77: ,l_information29 per_assignment_extra_info.aei_information29%type
78: ,l_information30 per_assignment_extra_info.aei_information30%type);
79: --
80: type asg_sf52_type is record
81: (asg_sf52_flag varchar2(1)
82: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type

Line 82: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type

78: ,l_information30 per_assignment_extra_info.aei_information30%type);
79: --
80: type asg_sf52_type is record
81: (asg_sf52_flag varchar2(1)
82: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
83: ,object_version_number per_assignment_extra_info.object_version_number%type
84: ,step_or_rate per_assignment_extra_info.aei_information3%type
85: ,tenure per_assignment_extra_info.aei_information4%type
86: ,annuitant_indicator per_assignment_extra_info.aei_information5%type

Line 83: ,object_version_number per_assignment_extra_info.object_version_number%type

79: --
80: type asg_sf52_type is record
81: (asg_sf52_flag varchar2(1)
82: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
83: ,object_version_number per_assignment_extra_info.object_version_number%type
84: ,step_or_rate per_assignment_extra_info.aei_information3%type
85: ,tenure per_assignment_extra_info.aei_information4%type
86: ,annuitant_indicator per_assignment_extra_info.aei_information5%type
87: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type

Line 84: ,step_or_rate per_assignment_extra_info.aei_information3%type

80: type asg_sf52_type is record
81: (asg_sf52_flag varchar2(1)
82: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
83: ,object_version_number per_assignment_extra_info.object_version_number%type
84: ,step_or_rate per_assignment_extra_info.aei_information3%type
85: ,tenure per_assignment_extra_info.aei_information4%type
86: ,annuitant_indicator per_assignment_extra_info.aei_information5%type
87: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type
88: ,work_schedule per_assignment_extra_info.aei_information7%type

Line 85: ,tenure per_assignment_extra_info.aei_information4%type

81: (asg_sf52_flag varchar2(1)
82: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
83: ,object_version_number per_assignment_extra_info.object_version_number%type
84: ,step_or_rate per_assignment_extra_info.aei_information3%type
85: ,tenure per_assignment_extra_info.aei_information4%type
86: ,annuitant_indicator per_assignment_extra_info.aei_information5%type
87: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type
88: ,work_schedule per_assignment_extra_info.aei_information7%type
89: ,part_time_hours per_assignment_extra_info.aei_information8%type

Line 86: ,annuitant_indicator per_assignment_extra_info.aei_information5%type

82: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
83: ,object_version_number per_assignment_extra_info.object_version_number%type
84: ,step_or_rate per_assignment_extra_info.aei_information3%type
85: ,tenure per_assignment_extra_info.aei_information4%type
86: ,annuitant_indicator per_assignment_extra_info.aei_information5%type
87: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type
88: ,work_schedule per_assignment_extra_info.aei_information7%type
89: ,part_time_hours per_assignment_extra_info.aei_information8%type
90: -- FWFA Changes Bug#4444609

Line 87: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type

83: ,object_version_number per_assignment_extra_info.object_version_number%type
84: ,step_or_rate per_assignment_extra_info.aei_information3%type
85: ,tenure per_assignment_extra_info.aei_information4%type
86: ,annuitant_indicator per_assignment_extra_info.aei_information5%type
87: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type
88: ,work_schedule per_assignment_extra_info.aei_information7%type
89: ,part_time_hours per_assignment_extra_info.aei_information8%type
90: -- FWFA Changes Bug#4444609
91: ,calc_pay_table per_assignment_extra_info.aei_information9%type

Line 88: ,work_schedule per_assignment_extra_info.aei_information7%type

84: ,step_or_rate per_assignment_extra_info.aei_information3%type
85: ,tenure per_assignment_extra_info.aei_information4%type
86: ,annuitant_indicator per_assignment_extra_info.aei_information5%type
87: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type
88: ,work_schedule per_assignment_extra_info.aei_information7%type
89: ,part_time_hours per_assignment_extra_info.aei_information8%type
90: -- FWFA Changes Bug#4444609
91: ,calc_pay_table per_assignment_extra_info.aei_information9%type
92: -- FWFA Changes

Line 89: ,part_time_hours per_assignment_extra_info.aei_information8%type

85: ,tenure per_assignment_extra_info.aei_information4%type
86: ,annuitant_indicator per_assignment_extra_info.aei_information5%type
87: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type
88: ,work_schedule per_assignment_extra_info.aei_information7%type
89: ,part_time_hours per_assignment_extra_info.aei_information8%type
90: -- FWFA Changes Bug#4444609
91: ,calc_pay_table per_assignment_extra_info.aei_information9%type
92: -- FWFA Changes
93: );

Line 91: ,calc_pay_table per_assignment_extra_info.aei_information9%type

87: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type
88: ,work_schedule per_assignment_extra_info.aei_information7%type
89: ,part_time_hours per_assignment_extra_info.aei_information8%type
90: -- FWFA Changes Bug#4444609
91: ,calc_pay_table per_assignment_extra_info.aei_information9%type
92: -- FWFA Changes
93: );
94: --
95: -- Bug 2431934

Line 109: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type

105: -- Bug 2431934
106:
107: type asg_non_sf52_type is record
108: (asg_non_sf52_flag varchar2(1)
109: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
110: ,object_version_number per_assignment_extra_info.object_version_number%type
111: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
112: ,duty_status per_assignment_extra_info.aei_information4%type
113: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type

Line 110: ,object_version_number per_assignment_extra_info.object_version_number%type

106:
107: type asg_non_sf52_type is record
108: (asg_non_sf52_flag varchar2(1)
109: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
110: ,object_version_number per_assignment_extra_info.object_version_number%type
111: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
112: ,duty_status per_assignment_extra_info.aei_information4%type
113: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
114: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type

Line 111: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type

107: type asg_non_sf52_type is record
108: (asg_non_sf52_flag varchar2(1)
109: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
110: ,object_version_number per_assignment_extra_info.object_version_number%type
111: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
112: ,duty_status per_assignment_extra_info.aei_information4%type
113: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
114: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
115: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type

Line 112: ,duty_status per_assignment_extra_info.aei_information4%type

108: (asg_non_sf52_flag varchar2(1)
109: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
110: ,object_version_number per_assignment_extra_info.object_version_number%type
111: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
112: ,duty_status per_assignment_extra_info.aei_information4%type
113: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
114: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
115: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
116: ,parttime_indicator per_assignment_extra_info.aei_information8%type

Line 113: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type

109: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
110: ,object_version_number per_assignment_extra_info.object_version_number%type
111: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
112: ,duty_status per_assignment_extra_info.aei_information4%type
113: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
114: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
115: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
116: ,parttime_indicator per_assignment_extra_info.aei_information8%type
117: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type

Line 114: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type

110: ,object_version_number per_assignment_extra_info.object_version_number%type
111: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
112: ,duty_status per_assignment_extra_info.aei_information4%type
113: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
114: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
115: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
116: ,parttime_indicator per_assignment_extra_info.aei_information8%type
117: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
118: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type

Line 115: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type

111: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
112: ,duty_status per_assignment_extra_info.aei_information4%type
113: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
114: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
115: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
116: ,parttime_indicator per_assignment_extra_info.aei_information8%type
117: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
118: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type
119: ,date_trainee_promotion_expt per_assignment_extra_info.aei_information11%type);

Line 116: ,parttime_indicator per_assignment_extra_info.aei_information8%type

112: ,duty_status per_assignment_extra_info.aei_information4%type
113: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
114: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
115: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
116: ,parttime_indicator per_assignment_extra_info.aei_information8%type
117: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
118: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type
119: ,date_trainee_promotion_expt per_assignment_extra_info.aei_information11%type);
120: --

Line 117: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type

113: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
114: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
115: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
116: ,parttime_indicator per_assignment_extra_info.aei_information8%type
117: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
118: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type
119: ,date_trainee_promotion_expt per_assignment_extra_info.aei_information11%type);
120: --
121: type asg_nte_dates_type is record

Line 118: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type

114: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
115: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
116: ,parttime_indicator per_assignment_extra_info.aei_information8%type
117: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
118: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type
119: ,date_trainee_promotion_expt per_assignment_extra_info.aei_information11%type);
120: --
121: type asg_nte_dates_type is record
122: (asg_nte_dates_flag varchar2(1)

Line 119: ,date_trainee_promotion_expt per_assignment_extra_info.aei_information11%type);

115: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
116: ,parttime_indicator per_assignment_extra_info.aei_information8%type
117: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
118: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type
119: ,date_trainee_promotion_expt per_assignment_extra_info.aei_information11%type);
120: --
121: type asg_nte_dates_type is record
122: (asg_nte_dates_flag varchar2(1)
123: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type

Line 123: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type

119: ,date_trainee_promotion_expt per_assignment_extra_info.aei_information11%type);
120: --
121: type asg_nte_dates_type is record
122: (asg_nte_dates_flag varchar2(1)
123: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
124: ,object_version_number per_assignment_extra_info.object_version_number%type
125: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
126: ,assignment_nte per_assignment_extra_info.aei_information4%type
127: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type

Line 124: ,object_version_number per_assignment_extra_info.object_version_number%type

120: --
121: type asg_nte_dates_type is record
122: (asg_nte_dates_flag varchar2(1)
123: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
124: ,object_version_number per_assignment_extra_info.object_version_number%type
125: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
126: ,assignment_nte per_assignment_extra_info.aei_information4%type
127: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
128: ,lwop_nte per_assignment_extra_info.aei_information6%type

Line 125: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type

121: type asg_nte_dates_type is record
122: (asg_nte_dates_flag varchar2(1)
123: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
124: ,object_version_number per_assignment_extra_info.object_version_number%type
125: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
126: ,assignment_nte per_assignment_extra_info.aei_information4%type
127: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
128: ,lwop_nte per_assignment_extra_info.aei_information6%type
129: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type

Line 126: ,assignment_nte per_assignment_extra_info.aei_information4%type

122: (asg_nte_dates_flag varchar2(1)
123: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
124: ,object_version_number per_assignment_extra_info.object_version_number%type
125: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
126: ,assignment_nte per_assignment_extra_info.aei_information4%type
127: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
128: ,lwop_nte per_assignment_extra_info.aei_information6%type
129: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
130: ,suspension_nte per_assignment_extra_info.aei_information8%type

Line 127: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type

123: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
124: ,object_version_number per_assignment_extra_info.object_version_number%type
125: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
126: ,assignment_nte per_assignment_extra_info.aei_information4%type
127: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
128: ,lwop_nte per_assignment_extra_info.aei_information6%type
129: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
130: ,suspension_nte per_assignment_extra_info.aei_information8%type
131: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type

Line 128: ,lwop_nte per_assignment_extra_info.aei_information6%type

124: ,object_version_number per_assignment_extra_info.object_version_number%type
125: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
126: ,assignment_nte per_assignment_extra_info.aei_information4%type
127: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
128: ,lwop_nte per_assignment_extra_info.aei_information6%type
129: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
130: ,suspension_nte per_assignment_extra_info.aei_information8%type
131: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
132: ,furlough_nte per_assignment_extra_info.aei_information10%type

Line 129: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type

125: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
126: ,assignment_nte per_assignment_extra_info.aei_information4%type
127: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
128: ,lwop_nte per_assignment_extra_info.aei_information6%type
129: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
130: ,suspension_nte per_assignment_extra_info.aei_information8%type
131: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
132: ,furlough_nte per_assignment_extra_info.aei_information10%type
133: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type

Line 130: ,suspension_nte per_assignment_extra_info.aei_information8%type

126: ,assignment_nte per_assignment_extra_info.aei_information4%type
127: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
128: ,lwop_nte per_assignment_extra_info.aei_information6%type
129: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
130: ,suspension_nte per_assignment_extra_info.aei_information8%type
131: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
132: ,furlough_nte per_assignment_extra_info.aei_information10%type
133: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
134: ,lwp_nte per_assignment_extra_info.aei_information12%type

Line 131: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type

127: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
128: ,lwop_nte per_assignment_extra_info.aei_information6%type
129: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
130: ,suspension_nte per_assignment_extra_info.aei_information8%type
131: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
132: ,furlough_nte per_assignment_extra_info.aei_information10%type
133: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
134: ,lwp_nte per_assignment_extra_info.aei_information12%type
135: ,sabatical_nte per_assignment_extra_info.aei_information13%type

Line 132: ,furlough_nte per_assignment_extra_info.aei_information10%type

128: ,lwop_nte per_assignment_extra_info.aei_information6%type
129: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
130: ,suspension_nte per_assignment_extra_info.aei_information8%type
131: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
132: ,furlough_nte per_assignment_extra_info.aei_information10%type
133: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
134: ,lwp_nte per_assignment_extra_info.aei_information12%type
135: ,sabatical_nte per_assignment_extra_info.aei_information13%type
136: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type

Line 133: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type

129: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
130: ,suspension_nte per_assignment_extra_info.aei_information8%type
131: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
132: ,furlough_nte per_assignment_extra_info.aei_information10%type
133: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
134: ,lwp_nte per_assignment_extra_info.aei_information12%type
135: ,sabatical_nte per_assignment_extra_info.aei_information13%type
136: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type
137: ,assignment_number per_assignment_extra_info.aei_information15%type

Line 134: ,lwp_nte per_assignment_extra_info.aei_information12%type

130: ,suspension_nte per_assignment_extra_info.aei_information8%type
131: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
132: ,furlough_nte per_assignment_extra_info.aei_information10%type
133: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
134: ,lwp_nte per_assignment_extra_info.aei_information12%type
135: ,sabatical_nte per_assignment_extra_info.aei_information13%type
136: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type
137: ,assignment_number per_assignment_extra_info.aei_information15%type
138: ,position_change_nte per_assignment_extra_info.aei_information16%type);

Line 135: ,sabatical_nte per_assignment_extra_info.aei_information13%type

131: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
132: ,furlough_nte per_assignment_extra_info.aei_information10%type
133: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
134: ,lwp_nte per_assignment_extra_info.aei_information12%type
135: ,sabatical_nte per_assignment_extra_info.aei_information13%type
136: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type
137: ,assignment_number per_assignment_extra_info.aei_information15%type
138: ,position_change_nte per_assignment_extra_info.aei_information16%type);
139:

Line 136: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type

132: ,furlough_nte per_assignment_extra_info.aei_information10%type
133: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
134: ,lwp_nte per_assignment_extra_info.aei_information12%type
135: ,sabatical_nte per_assignment_extra_info.aei_information13%type
136: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type
137: ,assignment_number per_assignment_extra_info.aei_information15%type
138: ,position_change_nte per_assignment_extra_info.aei_information16%type);
139:
140: --

Line 137: ,assignment_number per_assignment_extra_info.aei_information15%type

133: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
134: ,lwp_nte per_assignment_extra_info.aei_information12%type
135: ,sabatical_nte per_assignment_extra_info.aei_information13%type
136: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type
137: ,assignment_number per_assignment_extra_info.aei_information15%type
138: ,position_change_nte per_assignment_extra_info.aei_information16%type);
139:
140: --
141: type loc_info_type is record

Line 138: ,position_change_nte per_assignment_extra_info.aei_information16%type);

134: ,lwp_nte per_assignment_extra_info.aei_information12%type
135: ,sabatical_nte per_assignment_extra_info.aei_information13%type
136: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type
137: ,assignment_number per_assignment_extra_info.aei_information15%type
138: ,position_change_nte per_assignment_extra_info.aei_information16%type);
139:
140: --
141: type loc_info_type is record
142: (loc_info_flag varchar2(1)

Line 428: ,step_or_rate per_assignment_extra_info.aei_information3%type

424: ,position_seq_no per_position_definitions.segment3%type
425: ,pay_plan per_grade_definitions.segment1%type
426: ,occ_code per_job_definitions.segment1%type
427: ,grade_or_level per_grade_definitions.segment2%type
428: ,step_or_rate per_assignment_extra_info.aei_information3%type
429: ,total_salary number
430: ,pay_basis per_position_extra_info.poei_information6%type
431: ,basic_pay number
432: ,locality_adj number

Line 444: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type);

440: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
441: ,position_id per_all_positions.position_id%type
442: ,duty_station_location_id hr_locations.location_id%type
443: , work_schedule ghr_pa_requests.work_schedule%type
444: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type);
445: --
446: type recruitment_bonus_type is record
447: (p_recruitment_bonus_flag varchar2(1)
448: ,p_recruitment_bonus ghr_pa_request_extra_info.rei_information1%type