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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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);
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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);
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: --
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
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)
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
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
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
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
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
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
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
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
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: );
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
107: -- Bug 2431934
108:
109: type asg_non_sf52_type is record
110: (asg_non_sf52_flag varchar2(1)
111: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
112: ,object_version_number per_assignment_extra_info.object_version_number%type
113: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
114: ,duty_status per_assignment_extra_info.aei_information4%type
115: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
108:
109: type asg_non_sf52_type is record
110: (asg_non_sf52_flag varchar2(1)
111: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
112: ,object_version_number per_assignment_extra_info.object_version_number%type
113: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
114: ,duty_status per_assignment_extra_info.aei_information4%type
115: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
116: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
109: type asg_non_sf52_type is record
110: (asg_non_sf52_flag varchar2(1)
111: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
112: ,object_version_number per_assignment_extra_info.object_version_number%type
113: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
114: ,duty_status per_assignment_extra_info.aei_information4%type
115: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
116: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
117: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
110: (asg_non_sf52_flag varchar2(1)
111: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
112: ,object_version_number per_assignment_extra_info.object_version_number%type
113: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
114: ,duty_status per_assignment_extra_info.aei_information4%type
115: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
116: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
117: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
118: ,parttime_indicator per_assignment_extra_info.aei_information8%type
111: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
112: ,object_version_number per_assignment_extra_info.object_version_number%type
113: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
114: ,duty_status per_assignment_extra_info.aei_information4%type
115: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
116: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
117: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
118: ,parttime_indicator per_assignment_extra_info.aei_information8%type
119: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
112: ,object_version_number per_assignment_extra_info.object_version_number%type
113: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
114: ,duty_status per_assignment_extra_info.aei_information4%type
115: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
116: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
117: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
118: ,parttime_indicator per_assignment_extra_info.aei_information8%type
119: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
120: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type
113: ,date_arr_personnel_office per_assignment_extra_info.aei_information3%type
114: ,duty_status per_assignment_extra_info.aei_information4%type
115: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
116: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
117: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
118: ,parttime_indicator per_assignment_extra_info.aei_information8%type
119: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
120: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type
121: ,date_trainee_promotion_expt per_assignment_extra_info.aei_information11%type
114: ,duty_status per_assignment_extra_info.aei_information4%type
115: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
116: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
117: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
118: ,parttime_indicator per_assignment_extra_info.aei_information8%type
119: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
120: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type
121: ,date_trainee_promotion_expt per_assignment_extra_info.aei_information11%type
122: --Bug # 12652438 added new segment pay user ra status
115: ,key_emer_essential_empl per_assignment_extra_info.aei_information5%type
116: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
117: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
118: ,parttime_indicator per_assignment_extra_info.aei_information8%type
119: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
120: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type
121: ,date_trainee_promotion_expt per_assignment_extra_info.aei_information11%type
122: --Bug # 12652438 added new segment pay user ra status
123: ,pay_status_userra_status per_assignment_extra_info.aei_information14%type);
116: ,non_disc_agmt_status per_assignment_extra_info.aei_information6%type
117: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
118: ,parttime_indicator per_assignment_extra_info.aei_information8%type
119: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
120: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type
121: ,date_trainee_promotion_expt per_assignment_extra_info.aei_information11%type
122: --Bug # 12652438 added new segment pay user ra status
123: ,pay_status_userra_status per_assignment_extra_info.aei_information14%type);
124: --
117: ,date_wtop_exemp_expires per_assignment_extra_info.aei_information7%type
118: ,parttime_indicator per_assignment_extra_info.aei_information8%type
119: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
120: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type
121: ,date_trainee_promotion_expt per_assignment_extra_info.aei_information11%type
122: --Bug # 12652438 added new segment pay user ra status
123: ,pay_status_userra_status per_assignment_extra_info.aei_information14%type);
124: --
125: type asg_nte_dates_type is record
119: ,qualification_standard_waiver per_assignment_extra_info.aei_information9%type
120: ,trainee_promotion_id per_assignment_extra_info.aei_information10%type
121: ,date_trainee_promotion_expt per_assignment_extra_info.aei_information11%type
122: --Bug # 12652438 added new segment pay user ra status
123: ,pay_status_userra_status per_assignment_extra_info.aei_information14%type);
124: --
125: type asg_nte_dates_type is record
126: (asg_nte_dates_flag varchar2(1)
127: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
123: ,pay_status_userra_status per_assignment_extra_info.aei_information14%type);
124: --
125: type asg_nte_dates_type is record
126: (asg_nte_dates_flag varchar2(1)
127: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
128: ,object_version_number per_assignment_extra_info.object_version_number%type
129: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
130: ,assignment_nte per_assignment_extra_info.aei_information4%type
131: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
124: --
125: type asg_nte_dates_type is record
126: (asg_nte_dates_flag varchar2(1)
127: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
128: ,object_version_number per_assignment_extra_info.object_version_number%type
129: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
130: ,assignment_nte per_assignment_extra_info.aei_information4%type
131: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
132: ,lwop_nte per_assignment_extra_info.aei_information6%type
125: type asg_nte_dates_type is record
126: (asg_nte_dates_flag varchar2(1)
127: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
128: ,object_version_number per_assignment_extra_info.object_version_number%type
129: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
130: ,assignment_nte per_assignment_extra_info.aei_information4%type
131: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
132: ,lwop_nte per_assignment_extra_info.aei_information6%type
133: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
126: (asg_nte_dates_flag varchar2(1)
127: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
128: ,object_version_number per_assignment_extra_info.object_version_number%type
129: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
130: ,assignment_nte per_assignment_extra_info.aei_information4%type
131: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
132: ,lwop_nte per_assignment_extra_info.aei_information6%type
133: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
134: ,suspension_nte per_assignment_extra_info.aei_information8%type
127: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
128: ,object_version_number per_assignment_extra_info.object_version_number%type
129: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
130: ,assignment_nte per_assignment_extra_info.aei_information4%type
131: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
132: ,lwop_nte per_assignment_extra_info.aei_information6%type
133: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
134: ,suspension_nte per_assignment_extra_info.aei_information8%type
135: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
128: ,object_version_number per_assignment_extra_info.object_version_number%type
129: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
130: ,assignment_nte per_assignment_extra_info.aei_information4%type
131: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
132: ,lwop_nte per_assignment_extra_info.aei_information6%type
133: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
134: ,suspension_nte per_assignment_extra_info.aei_information8%type
135: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
136: ,furlough_nte per_assignment_extra_info.aei_information10%type
129: ,asg_nte_start_date per_assignment_extra_info.aei_information3%type
130: ,assignment_nte per_assignment_extra_info.aei_information4%type
131: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
132: ,lwop_nte per_assignment_extra_info.aei_information6%type
133: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
134: ,suspension_nte per_assignment_extra_info.aei_information8%type
135: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
136: ,furlough_nte per_assignment_extra_info.aei_information10%type
137: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
130: ,assignment_nte per_assignment_extra_info.aei_information4%type
131: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
132: ,lwop_nte per_assignment_extra_info.aei_information6%type
133: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
134: ,suspension_nte per_assignment_extra_info.aei_information8%type
135: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
136: ,furlough_nte per_assignment_extra_info.aei_information10%type
137: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
138: ,lwp_nte per_assignment_extra_info.aei_information12%type
131: ,lwop_nte_start_date per_assignment_extra_info.aei_information5%type
132: ,lwop_nte per_assignment_extra_info.aei_information6%type
133: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
134: ,suspension_nte per_assignment_extra_info.aei_information8%type
135: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
136: ,furlough_nte per_assignment_extra_info.aei_information10%type
137: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
138: ,lwp_nte per_assignment_extra_info.aei_information12%type
139: ,sabatical_nte per_assignment_extra_info.aei_information13%type
132: ,lwop_nte per_assignment_extra_info.aei_information6%type
133: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
134: ,suspension_nte per_assignment_extra_info.aei_information8%type
135: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
136: ,furlough_nte per_assignment_extra_info.aei_information10%type
137: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
138: ,lwp_nte per_assignment_extra_info.aei_information12%type
139: ,sabatical_nte per_assignment_extra_info.aei_information13%type
140: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type
133: ,suspension_nte_start_date per_assignment_extra_info.aei_information7%type
134: ,suspension_nte per_assignment_extra_info.aei_information8%type
135: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
136: ,furlough_nte per_assignment_extra_info.aei_information10%type
137: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
138: ,lwp_nte per_assignment_extra_info.aei_information12%type
139: ,sabatical_nte per_assignment_extra_info.aei_information13%type
140: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type
141: ,assignment_number per_assignment_extra_info.aei_information15%type
134: ,suspension_nte per_assignment_extra_info.aei_information8%type
135: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
136: ,furlough_nte per_assignment_extra_info.aei_information10%type
137: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
138: ,lwp_nte per_assignment_extra_info.aei_information12%type
139: ,sabatical_nte per_assignment_extra_info.aei_information13%type
140: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type
141: ,assignment_number per_assignment_extra_info.aei_information15%type
142: ,position_change_nte per_assignment_extra_info.aei_information16%type);
135: ,furlough_nte_Start_date per_assignment_extra_info.aei_information9%type
136: ,furlough_nte per_assignment_extra_info.aei_information10%type
137: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
138: ,lwp_nte per_assignment_extra_info.aei_information12%type
139: ,sabatical_nte per_assignment_extra_info.aei_information13%type
140: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type
141: ,assignment_number per_assignment_extra_info.aei_information15%type
142: ,position_change_nte per_assignment_extra_info.aei_information16%type);
143:
136: ,furlough_nte per_assignment_extra_info.aei_information10%type
137: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
138: ,lwp_nte per_assignment_extra_info.aei_information12%type
139: ,sabatical_nte per_assignment_extra_info.aei_information13%type
140: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type
141: ,assignment_number per_assignment_extra_info.aei_information15%type
142: ,position_change_nte per_assignment_extra_info.aei_information16%type);
143:
144: --Begin Bug# 8653508
137: ,lwp_nte_start_date per_assignment_extra_info.aei_information11%type
138: ,lwp_nte per_assignment_extra_info.aei_information12%type
139: ,sabatical_nte per_assignment_extra_info.aei_information13%type
140: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type
141: ,assignment_number per_assignment_extra_info.aei_information15%type
142: ,position_change_nte per_assignment_extra_info.aei_information16%type);
143:
144: --Begin Bug# 8653508
145: type asg_detail_info_type is record
138: ,lwp_nte per_assignment_extra_info.aei_information12%type
139: ,sabatical_nte per_assignment_extra_info.aei_information13%type
140: ,sabatical_nte_start_date per_assignment_extra_info.aei_information14%type
141: ,assignment_number per_assignment_extra_info.aei_information15%type
142: ,position_change_nte per_assignment_extra_info.aei_information16%type);
143:
144: --Begin Bug# 8653508
145: type asg_detail_info_type is record
146: (asg_detail_info_flag varchar2(1)
143:
144: --Begin Bug# 8653508
145: type asg_detail_info_type is record
146: (asg_detail_info_flag varchar2(1)
147: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
148: ,object_version_number per_assignment_extra_info.object_version_number%type
149: ,detail_begin_date per_assignment_extra_info.aei_information1%type
150: ,detail_end_date per_assignment_extra_info.aei_information2%type
151: ,detail_type per_assignment_extra_info.aei_information3%type
144: --Begin Bug# 8653508
145: type asg_detail_info_type is record
146: (asg_detail_info_flag varchar2(1)
147: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
148: ,object_version_number per_assignment_extra_info.object_version_number%type
149: ,detail_begin_date per_assignment_extra_info.aei_information1%type
150: ,detail_end_date per_assignment_extra_info.aei_information2%type
151: ,detail_type per_assignment_extra_info.aei_information3%type
152: ,unclss_duty_ind per_assignment_extra_info.aei_information4%type
145: type asg_detail_info_type is record
146: (asg_detail_info_flag varchar2(1)
147: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
148: ,object_version_number per_assignment_extra_info.object_version_number%type
149: ,detail_begin_date per_assignment_extra_info.aei_information1%type
150: ,detail_end_date per_assignment_extra_info.aei_information2%type
151: ,detail_type per_assignment_extra_info.aei_information3%type
152: ,unclss_duty_ind per_assignment_extra_info.aei_information4%type
153: ,position_name per_assignment_extra_info.aei_information5%type
146: (asg_detail_info_flag varchar2(1)
147: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
148: ,object_version_number per_assignment_extra_info.object_version_number%type
149: ,detail_begin_date per_assignment_extra_info.aei_information1%type
150: ,detail_end_date per_assignment_extra_info.aei_information2%type
151: ,detail_type per_assignment_extra_info.aei_information3%type
152: ,unclss_duty_ind per_assignment_extra_info.aei_information4%type
153: ,position_name per_assignment_extra_info.aei_information5%type
154: ,valid_grade per_assignment_extra_info.aei_information6%type
147: ,assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type
148: ,object_version_number per_assignment_extra_info.object_version_number%type
149: ,detail_begin_date per_assignment_extra_info.aei_information1%type
150: ,detail_end_date per_assignment_extra_info.aei_information2%type
151: ,detail_type per_assignment_extra_info.aei_information3%type
152: ,unclss_duty_ind per_assignment_extra_info.aei_information4%type
153: ,position_name per_assignment_extra_info.aei_information5%type
154: ,valid_grade per_assignment_extra_info.aei_information6%type
155: ,occ_series per_assignment_extra_info.aei_information7%type
148: ,object_version_number per_assignment_extra_info.object_version_number%type
149: ,detail_begin_date per_assignment_extra_info.aei_information1%type
150: ,detail_end_date per_assignment_extra_info.aei_information2%type
151: ,detail_type per_assignment_extra_info.aei_information3%type
152: ,unclss_duty_ind per_assignment_extra_info.aei_information4%type
153: ,position_name per_assignment_extra_info.aei_information5%type
154: ,valid_grade per_assignment_extra_info.aei_information6%type
155: ,occ_series per_assignment_extra_info.aei_information7%type
156: ,appropriation_code per_assignment_extra_info.aei_information8%type
149: ,detail_begin_date per_assignment_extra_info.aei_information1%type
150: ,detail_end_date per_assignment_extra_info.aei_information2%type
151: ,detail_type per_assignment_extra_info.aei_information3%type
152: ,unclss_duty_ind per_assignment_extra_info.aei_information4%type
153: ,position_name per_assignment_extra_info.aei_information5%type
154: ,valid_grade per_assignment_extra_info.aei_information6%type
155: ,occ_series per_assignment_extra_info.aei_information7%type
156: ,appropriation_code per_assignment_extra_info.aei_information8%type
157: ,flsa_category per_assignment_extra_info.aei_information9%type
150: ,detail_end_date per_assignment_extra_info.aei_information2%type
151: ,detail_type per_assignment_extra_info.aei_information3%type
152: ,unclss_duty_ind per_assignment_extra_info.aei_information4%type
153: ,position_name per_assignment_extra_info.aei_information5%type
154: ,valid_grade per_assignment_extra_info.aei_information6%type
155: ,occ_series per_assignment_extra_info.aei_information7%type
156: ,appropriation_code per_assignment_extra_info.aei_information8%type
157: ,flsa_category per_assignment_extra_info.aei_information9%type
158: ,bargaining_unit_status per_assignment_extra_info.aei_information10%type
151: ,detail_type per_assignment_extra_info.aei_information3%type
152: ,unclss_duty_ind per_assignment_extra_info.aei_information4%type
153: ,position_name per_assignment_extra_info.aei_information5%type
154: ,valid_grade per_assignment_extra_info.aei_information6%type
155: ,occ_series per_assignment_extra_info.aei_information7%type
156: ,appropriation_code per_assignment_extra_info.aei_information8%type
157: ,flsa_category per_assignment_extra_info.aei_information9%type
158: ,bargaining_unit_status per_assignment_extra_info.aei_information10%type
159: ,work_schedule per_assignment_extra_info.aei_information11%type
152: ,unclss_duty_ind per_assignment_extra_info.aei_information4%type
153: ,position_name per_assignment_extra_info.aei_information5%type
154: ,valid_grade per_assignment_extra_info.aei_information6%type
155: ,occ_series per_assignment_extra_info.aei_information7%type
156: ,appropriation_code per_assignment_extra_info.aei_information8%type
157: ,flsa_category per_assignment_extra_info.aei_information9%type
158: ,bargaining_unit_status per_assignment_extra_info.aei_information10%type
159: ,work_schedule per_assignment_extra_info.aei_information11%type
160: ,duty_location per_assignment_extra_info.aei_information12%type
153: ,position_name per_assignment_extra_info.aei_information5%type
154: ,valid_grade per_assignment_extra_info.aei_information6%type
155: ,occ_series per_assignment_extra_info.aei_information7%type
156: ,appropriation_code per_assignment_extra_info.aei_information8%type
157: ,flsa_category per_assignment_extra_info.aei_information9%type
158: ,bargaining_unit_status per_assignment_extra_info.aei_information10%type
159: ,work_schedule per_assignment_extra_info.aei_information11%type
160: ,duty_location per_assignment_extra_info.aei_information12%type
161: ,organization per_assignment_extra_info.aei_information13%type
154: ,valid_grade per_assignment_extra_info.aei_information6%type
155: ,occ_series per_assignment_extra_info.aei_information7%type
156: ,appropriation_code per_assignment_extra_info.aei_information8%type
157: ,flsa_category per_assignment_extra_info.aei_information9%type
158: ,bargaining_unit_status per_assignment_extra_info.aei_information10%type
159: ,work_schedule per_assignment_extra_info.aei_information11%type
160: ,duty_location per_assignment_extra_info.aei_information12%type
161: ,organization per_assignment_extra_info.aei_information13%type
162: );
155: ,occ_series per_assignment_extra_info.aei_information7%type
156: ,appropriation_code per_assignment_extra_info.aei_information8%type
157: ,flsa_category per_assignment_extra_info.aei_information9%type
158: ,bargaining_unit_status per_assignment_extra_info.aei_information10%type
159: ,work_schedule per_assignment_extra_info.aei_information11%type
160: ,duty_location per_assignment_extra_info.aei_information12%type
161: ,organization per_assignment_extra_info.aei_information13%type
162: );
163: --End Bug# 8653508
156: ,appropriation_code per_assignment_extra_info.aei_information8%type
157: ,flsa_category per_assignment_extra_info.aei_information9%type
158: ,bargaining_unit_status per_assignment_extra_info.aei_information10%type
159: ,work_schedule per_assignment_extra_info.aei_information11%type
160: ,duty_location per_assignment_extra_info.aei_information12%type
161: ,organization per_assignment_extra_info.aei_information13%type
162: );
163: --End Bug# 8653508
164: --
157: ,flsa_category per_assignment_extra_info.aei_information9%type
158: ,bargaining_unit_status per_assignment_extra_info.aei_information10%type
159: ,work_schedule per_assignment_extra_info.aei_information11%type
160: ,duty_location per_assignment_extra_info.aei_information12%type
161: ,organization per_assignment_extra_info.aei_information13%type
162: );
163: --End Bug# 8653508
164: --
165: type loc_info_type is record
455: ,position_seq_no per_position_definitions.segment3%type
456: ,pay_plan per_grade_definitions.segment1%type
457: ,occ_code per_job_definitions.segment1%type
458: ,grade_or_level per_grade_definitions.segment2%type
459: ,step_or_rate per_assignment_extra_info.aei_information3%type
460: ,total_salary number
461: ,pay_basis per_position_extra_info.poei_information6%type
462: ,basic_pay number
463: ,locality_adj number
471: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
472: ,position_id per_all_positions.position_id%type
473: ,duty_station_location_id hr_locations.location_id%type
474: , work_schedule ghr_pa_requests.work_schedule%type
475: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type);
476: --
477: type recruitment_bonus_type is record
478: (p_recruitment_bonus_flag varchar2(1)
479: ,p_recruitment_bonus ghr_pa_request_extra_info.rei_information1%type