295: ,p_information28 IN OUT NOCOPY VARCHAR2
296: ,p_information29 IN OUT NOCOPY VARCHAR2
297: ,p_information30 IN OUT NOCOPY VARCHAR2) IS
298:
299: l_asg_ei_data per_assignment_extra_info%rowtype;
300:
301: -- NOCOPY Variables
302: l_information1 per_assignment_extra_info.aei_information1%type := p_information1 ;
303: l_information2 per_assignment_extra_info.aei_information2%type := p_information2 ;
298:
299: l_asg_ei_data per_assignment_extra_info%rowtype;
300:
301: -- NOCOPY Variables
302: l_information1 per_assignment_extra_info.aei_information1%type := p_information1 ;
303: l_information2 per_assignment_extra_info.aei_information2%type := p_information2 ;
304: l_information3 per_assignment_extra_info.aei_information3%type := p_information3 ;
305: l_information4 per_assignment_extra_info.aei_information4%type := p_information4 ;
306: l_information5 per_assignment_extra_info.aei_information5%type := p_information5 ;
299: l_asg_ei_data per_assignment_extra_info%rowtype;
300:
301: -- NOCOPY Variables
302: l_information1 per_assignment_extra_info.aei_information1%type := p_information1 ;
303: l_information2 per_assignment_extra_info.aei_information2%type := p_information2 ;
304: l_information3 per_assignment_extra_info.aei_information3%type := p_information3 ;
305: l_information4 per_assignment_extra_info.aei_information4%type := p_information4 ;
306: l_information5 per_assignment_extra_info.aei_information5%type := p_information5 ;
307: l_information6 per_assignment_extra_info.aei_information6%type := p_information6 ;
300:
301: -- NOCOPY Variables
302: l_information1 per_assignment_extra_info.aei_information1%type := p_information1 ;
303: l_information2 per_assignment_extra_info.aei_information2%type := p_information2 ;
304: l_information3 per_assignment_extra_info.aei_information3%type := p_information3 ;
305: l_information4 per_assignment_extra_info.aei_information4%type := p_information4 ;
306: l_information5 per_assignment_extra_info.aei_information5%type := p_information5 ;
307: l_information6 per_assignment_extra_info.aei_information6%type := p_information6 ;
308: l_information7 per_assignment_extra_info.aei_information7%type := p_information7 ;
301: -- NOCOPY Variables
302: l_information1 per_assignment_extra_info.aei_information1%type := p_information1 ;
303: l_information2 per_assignment_extra_info.aei_information2%type := p_information2 ;
304: l_information3 per_assignment_extra_info.aei_information3%type := p_information3 ;
305: l_information4 per_assignment_extra_info.aei_information4%type := p_information4 ;
306: l_information5 per_assignment_extra_info.aei_information5%type := p_information5 ;
307: l_information6 per_assignment_extra_info.aei_information6%type := p_information6 ;
308: l_information7 per_assignment_extra_info.aei_information7%type := p_information7 ;
309: l_information8 per_assignment_extra_info.aei_information8%type := p_information8 ;
302: l_information1 per_assignment_extra_info.aei_information1%type := p_information1 ;
303: l_information2 per_assignment_extra_info.aei_information2%type := p_information2 ;
304: l_information3 per_assignment_extra_info.aei_information3%type := p_information3 ;
305: l_information4 per_assignment_extra_info.aei_information4%type := p_information4 ;
306: l_information5 per_assignment_extra_info.aei_information5%type := p_information5 ;
307: l_information6 per_assignment_extra_info.aei_information6%type := p_information6 ;
308: l_information7 per_assignment_extra_info.aei_information7%type := p_information7 ;
309: l_information8 per_assignment_extra_info.aei_information8%type := p_information8 ;
310: l_information9 per_assignment_extra_info.aei_information9%type := p_information9 ;
303: l_information2 per_assignment_extra_info.aei_information2%type := p_information2 ;
304: l_information3 per_assignment_extra_info.aei_information3%type := p_information3 ;
305: l_information4 per_assignment_extra_info.aei_information4%type := p_information4 ;
306: l_information5 per_assignment_extra_info.aei_information5%type := p_information5 ;
307: l_information6 per_assignment_extra_info.aei_information6%type := p_information6 ;
308: l_information7 per_assignment_extra_info.aei_information7%type := p_information7 ;
309: l_information8 per_assignment_extra_info.aei_information8%type := p_information8 ;
310: l_information9 per_assignment_extra_info.aei_information9%type := p_information9 ;
311: l_information10 per_assignment_extra_info.aei_information10%type := p_information10 ;
304: l_information3 per_assignment_extra_info.aei_information3%type := p_information3 ;
305: l_information4 per_assignment_extra_info.aei_information4%type := p_information4 ;
306: l_information5 per_assignment_extra_info.aei_information5%type := p_information5 ;
307: l_information6 per_assignment_extra_info.aei_information6%type := p_information6 ;
308: l_information7 per_assignment_extra_info.aei_information7%type := p_information7 ;
309: l_information8 per_assignment_extra_info.aei_information8%type := p_information8 ;
310: l_information9 per_assignment_extra_info.aei_information9%type := p_information9 ;
311: l_information10 per_assignment_extra_info.aei_information10%type := p_information10 ;
312: l_information11 per_assignment_extra_info.aei_information11%type := p_information11 ;
305: l_information4 per_assignment_extra_info.aei_information4%type := p_information4 ;
306: l_information5 per_assignment_extra_info.aei_information5%type := p_information5 ;
307: l_information6 per_assignment_extra_info.aei_information6%type := p_information6 ;
308: l_information7 per_assignment_extra_info.aei_information7%type := p_information7 ;
309: l_information8 per_assignment_extra_info.aei_information8%type := p_information8 ;
310: l_information9 per_assignment_extra_info.aei_information9%type := p_information9 ;
311: l_information10 per_assignment_extra_info.aei_information10%type := p_information10 ;
312: l_information11 per_assignment_extra_info.aei_information11%type := p_information11 ;
313: l_information12 per_assignment_extra_info.aei_information12%type := p_information12 ;
306: l_information5 per_assignment_extra_info.aei_information5%type := p_information5 ;
307: l_information6 per_assignment_extra_info.aei_information6%type := p_information6 ;
308: l_information7 per_assignment_extra_info.aei_information7%type := p_information7 ;
309: l_information8 per_assignment_extra_info.aei_information8%type := p_information8 ;
310: l_information9 per_assignment_extra_info.aei_information9%type := p_information9 ;
311: l_information10 per_assignment_extra_info.aei_information10%type := p_information10 ;
312: l_information11 per_assignment_extra_info.aei_information11%type := p_information11 ;
313: l_information12 per_assignment_extra_info.aei_information12%type := p_information12 ;
314: l_information13 per_assignment_extra_info.aei_information13%type := p_information13 ;
307: l_information6 per_assignment_extra_info.aei_information6%type := p_information6 ;
308: l_information7 per_assignment_extra_info.aei_information7%type := p_information7 ;
309: l_information8 per_assignment_extra_info.aei_information8%type := p_information8 ;
310: l_information9 per_assignment_extra_info.aei_information9%type := p_information9 ;
311: l_information10 per_assignment_extra_info.aei_information10%type := p_information10 ;
312: l_information11 per_assignment_extra_info.aei_information11%type := p_information11 ;
313: l_information12 per_assignment_extra_info.aei_information12%type := p_information12 ;
314: l_information13 per_assignment_extra_info.aei_information13%type := p_information13 ;
315: l_information14 per_assignment_extra_info.aei_information14%type := p_information14 ;
308: l_information7 per_assignment_extra_info.aei_information7%type := p_information7 ;
309: l_information8 per_assignment_extra_info.aei_information8%type := p_information8 ;
310: l_information9 per_assignment_extra_info.aei_information9%type := p_information9 ;
311: l_information10 per_assignment_extra_info.aei_information10%type := p_information10 ;
312: l_information11 per_assignment_extra_info.aei_information11%type := p_information11 ;
313: l_information12 per_assignment_extra_info.aei_information12%type := p_information12 ;
314: l_information13 per_assignment_extra_info.aei_information13%type := p_information13 ;
315: l_information14 per_assignment_extra_info.aei_information14%type := p_information14 ;
316: l_information15 per_assignment_extra_info.aei_information15%type := p_information15 ;
309: l_information8 per_assignment_extra_info.aei_information8%type := p_information8 ;
310: l_information9 per_assignment_extra_info.aei_information9%type := p_information9 ;
311: l_information10 per_assignment_extra_info.aei_information10%type := p_information10 ;
312: l_information11 per_assignment_extra_info.aei_information11%type := p_information11 ;
313: l_information12 per_assignment_extra_info.aei_information12%type := p_information12 ;
314: l_information13 per_assignment_extra_info.aei_information13%type := p_information13 ;
315: l_information14 per_assignment_extra_info.aei_information14%type := p_information14 ;
316: l_information15 per_assignment_extra_info.aei_information15%type := p_information15 ;
317: l_information16 per_assignment_extra_info.aei_information16%type := p_information16 ;
310: l_information9 per_assignment_extra_info.aei_information9%type := p_information9 ;
311: l_information10 per_assignment_extra_info.aei_information10%type := p_information10 ;
312: l_information11 per_assignment_extra_info.aei_information11%type := p_information11 ;
313: l_information12 per_assignment_extra_info.aei_information12%type := p_information12 ;
314: l_information13 per_assignment_extra_info.aei_information13%type := p_information13 ;
315: l_information14 per_assignment_extra_info.aei_information14%type := p_information14 ;
316: l_information15 per_assignment_extra_info.aei_information15%type := p_information15 ;
317: l_information16 per_assignment_extra_info.aei_information16%type := p_information16 ;
318: l_information17 per_assignment_extra_info.aei_information17%type := p_information17 ;
311: l_information10 per_assignment_extra_info.aei_information10%type := p_information10 ;
312: l_information11 per_assignment_extra_info.aei_information11%type := p_information11 ;
313: l_information12 per_assignment_extra_info.aei_information12%type := p_information12 ;
314: l_information13 per_assignment_extra_info.aei_information13%type := p_information13 ;
315: l_information14 per_assignment_extra_info.aei_information14%type := p_information14 ;
316: l_information15 per_assignment_extra_info.aei_information15%type := p_information15 ;
317: l_information16 per_assignment_extra_info.aei_information16%type := p_information16 ;
318: l_information17 per_assignment_extra_info.aei_information17%type := p_information17 ;
319: l_information18 per_assignment_extra_info.aei_information18%type := p_information18 ;
312: l_information11 per_assignment_extra_info.aei_information11%type := p_information11 ;
313: l_information12 per_assignment_extra_info.aei_information12%type := p_information12 ;
314: l_information13 per_assignment_extra_info.aei_information13%type := p_information13 ;
315: l_information14 per_assignment_extra_info.aei_information14%type := p_information14 ;
316: l_information15 per_assignment_extra_info.aei_information15%type := p_information15 ;
317: l_information16 per_assignment_extra_info.aei_information16%type := p_information16 ;
318: l_information17 per_assignment_extra_info.aei_information17%type := p_information17 ;
319: l_information18 per_assignment_extra_info.aei_information18%type := p_information18 ;
320: l_information19 per_assignment_extra_info.aei_information19%type := p_information19 ;
313: l_information12 per_assignment_extra_info.aei_information12%type := p_information12 ;
314: l_information13 per_assignment_extra_info.aei_information13%type := p_information13 ;
315: l_information14 per_assignment_extra_info.aei_information14%type := p_information14 ;
316: l_information15 per_assignment_extra_info.aei_information15%type := p_information15 ;
317: l_information16 per_assignment_extra_info.aei_information16%type := p_information16 ;
318: l_information17 per_assignment_extra_info.aei_information17%type := p_information17 ;
319: l_information18 per_assignment_extra_info.aei_information18%type := p_information18 ;
320: l_information19 per_assignment_extra_info.aei_information19%type := p_information19 ;
321: l_information20 per_assignment_extra_info.aei_information20%type := p_information20 ;
314: l_information13 per_assignment_extra_info.aei_information13%type := p_information13 ;
315: l_information14 per_assignment_extra_info.aei_information14%type := p_information14 ;
316: l_information15 per_assignment_extra_info.aei_information15%type := p_information15 ;
317: l_information16 per_assignment_extra_info.aei_information16%type := p_information16 ;
318: l_information17 per_assignment_extra_info.aei_information17%type := p_information17 ;
319: l_information18 per_assignment_extra_info.aei_information18%type := p_information18 ;
320: l_information19 per_assignment_extra_info.aei_information19%type := p_information19 ;
321: l_information20 per_assignment_extra_info.aei_information20%type := p_information20 ;
322: l_information21 per_assignment_extra_info.aei_information21%type := p_information21 ;
315: l_information14 per_assignment_extra_info.aei_information14%type := p_information14 ;
316: l_information15 per_assignment_extra_info.aei_information15%type := p_information15 ;
317: l_information16 per_assignment_extra_info.aei_information16%type := p_information16 ;
318: l_information17 per_assignment_extra_info.aei_information17%type := p_information17 ;
319: l_information18 per_assignment_extra_info.aei_information18%type := p_information18 ;
320: l_information19 per_assignment_extra_info.aei_information19%type := p_information19 ;
321: l_information20 per_assignment_extra_info.aei_information20%type := p_information20 ;
322: l_information21 per_assignment_extra_info.aei_information21%type := p_information21 ;
323: l_information22 per_assignment_extra_info.aei_information22%type := p_information22 ;
316: l_information15 per_assignment_extra_info.aei_information15%type := p_information15 ;
317: l_information16 per_assignment_extra_info.aei_information16%type := p_information16 ;
318: l_information17 per_assignment_extra_info.aei_information17%type := p_information17 ;
319: l_information18 per_assignment_extra_info.aei_information18%type := p_information18 ;
320: l_information19 per_assignment_extra_info.aei_information19%type := p_information19 ;
321: l_information20 per_assignment_extra_info.aei_information20%type := p_information20 ;
322: l_information21 per_assignment_extra_info.aei_information21%type := p_information21 ;
323: l_information22 per_assignment_extra_info.aei_information22%type := p_information22 ;
324: l_information23 per_assignment_extra_info.aei_information23%type := p_information23 ;
317: l_information16 per_assignment_extra_info.aei_information16%type := p_information16 ;
318: l_information17 per_assignment_extra_info.aei_information17%type := p_information17 ;
319: l_information18 per_assignment_extra_info.aei_information18%type := p_information18 ;
320: l_information19 per_assignment_extra_info.aei_information19%type := p_information19 ;
321: l_information20 per_assignment_extra_info.aei_information20%type := p_information20 ;
322: l_information21 per_assignment_extra_info.aei_information21%type := p_information21 ;
323: l_information22 per_assignment_extra_info.aei_information22%type := p_information22 ;
324: l_information23 per_assignment_extra_info.aei_information23%type := p_information23 ;
325: l_information24 per_assignment_extra_info.aei_information24%type := p_information24 ;
318: l_information17 per_assignment_extra_info.aei_information17%type := p_information17 ;
319: l_information18 per_assignment_extra_info.aei_information18%type := p_information18 ;
320: l_information19 per_assignment_extra_info.aei_information19%type := p_information19 ;
321: l_information20 per_assignment_extra_info.aei_information20%type := p_information20 ;
322: l_information21 per_assignment_extra_info.aei_information21%type := p_information21 ;
323: l_information22 per_assignment_extra_info.aei_information22%type := p_information22 ;
324: l_information23 per_assignment_extra_info.aei_information23%type := p_information23 ;
325: l_information24 per_assignment_extra_info.aei_information24%type := p_information24 ;
326: l_information25 per_assignment_extra_info.aei_information25%type := p_information25 ;
319: l_information18 per_assignment_extra_info.aei_information18%type := p_information18 ;
320: l_information19 per_assignment_extra_info.aei_information19%type := p_information19 ;
321: l_information20 per_assignment_extra_info.aei_information20%type := p_information20 ;
322: l_information21 per_assignment_extra_info.aei_information21%type := p_information21 ;
323: l_information22 per_assignment_extra_info.aei_information22%type := p_information22 ;
324: l_information23 per_assignment_extra_info.aei_information23%type := p_information23 ;
325: l_information24 per_assignment_extra_info.aei_information24%type := p_information24 ;
326: l_information25 per_assignment_extra_info.aei_information25%type := p_information25 ;
327: l_information26 per_assignment_extra_info.aei_information26%type := p_information26 ;
320: l_information19 per_assignment_extra_info.aei_information19%type := p_information19 ;
321: l_information20 per_assignment_extra_info.aei_information20%type := p_information20 ;
322: l_information21 per_assignment_extra_info.aei_information21%type := p_information21 ;
323: l_information22 per_assignment_extra_info.aei_information22%type := p_information22 ;
324: l_information23 per_assignment_extra_info.aei_information23%type := p_information23 ;
325: l_information24 per_assignment_extra_info.aei_information24%type := p_information24 ;
326: l_information25 per_assignment_extra_info.aei_information25%type := p_information25 ;
327: l_information26 per_assignment_extra_info.aei_information26%type := p_information26 ;
328: l_information27 per_assignment_extra_info.aei_information27%type := p_information27 ;
321: l_information20 per_assignment_extra_info.aei_information20%type := p_information20 ;
322: l_information21 per_assignment_extra_info.aei_information21%type := p_information21 ;
323: l_information22 per_assignment_extra_info.aei_information22%type := p_information22 ;
324: l_information23 per_assignment_extra_info.aei_information23%type := p_information23 ;
325: l_information24 per_assignment_extra_info.aei_information24%type := p_information24 ;
326: l_information25 per_assignment_extra_info.aei_information25%type := p_information25 ;
327: l_information26 per_assignment_extra_info.aei_information26%type := p_information26 ;
328: l_information27 per_assignment_extra_info.aei_information27%type := p_information27 ;
329: l_information28 per_assignment_extra_info.aei_information28%type := p_information28 ;
322: l_information21 per_assignment_extra_info.aei_information21%type := p_information21 ;
323: l_information22 per_assignment_extra_info.aei_information22%type := p_information22 ;
324: l_information23 per_assignment_extra_info.aei_information23%type := p_information23 ;
325: l_information24 per_assignment_extra_info.aei_information24%type := p_information24 ;
326: l_information25 per_assignment_extra_info.aei_information25%type := p_information25 ;
327: l_information26 per_assignment_extra_info.aei_information26%type := p_information26 ;
328: l_information27 per_assignment_extra_info.aei_information27%type := p_information27 ;
329: l_information28 per_assignment_extra_info.aei_information28%type := p_information28 ;
330: l_information29 per_assignment_extra_info.aei_information29%type := p_information29 ;
323: l_information22 per_assignment_extra_info.aei_information22%type := p_information22 ;
324: l_information23 per_assignment_extra_info.aei_information23%type := p_information23 ;
325: l_information24 per_assignment_extra_info.aei_information24%type := p_information24 ;
326: l_information25 per_assignment_extra_info.aei_information25%type := p_information25 ;
327: l_information26 per_assignment_extra_info.aei_information26%type := p_information26 ;
328: l_information27 per_assignment_extra_info.aei_information27%type := p_information27 ;
329: l_information28 per_assignment_extra_info.aei_information28%type := p_information28 ;
330: l_information29 per_assignment_extra_info.aei_information29%type := p_information29 ;
331: l_information30 per_assignment_extra_info.aei_information30%type := p_information30 ;
324: l_information23 per_assignment_extra_info.aei_information23%type := p_information23 ;
325: l_information24 per_assignment_extra_info.aei_information24%type := p_information24 ;
326: l_information25 per_assignment_extra_info.aei_information25%type := p_information25 ;
327: l_information26 per_assignment_extra_info.aei_information26%type := p_information26 ;
328: l_information27 per_assignment_extra_info.aei_information27%type := p_information27 ;
329: l_information28 per_assignment_extra_info.aei_information28%type := p_information28 ;
330: l_information29 per_assignment_extra_info.aei_information29%type := p_information29 ;
331: l_information30 per_assignment_extra_info.aei_information30%type := p_information30 ;
332:
325: l_information24 per_assignment_extra_info.aei_information24%type := p_information24 ;
326: l_information25 per_assignment_extra_info.aei_information25%type := p_information25 ;
327: l_information26 per_assignment_extra_info.aei_information26%type := p_information26 ;
328: l_information27 per_assignment_extra_info.aei_information27%type := p_information27 ;
329: l_information28 per_assignment_extra_info.aei_information28%type := p_information28 ;
330: l_information29 per_assignment_extra_info.aei_information29%type := p_information29 ;
331: l_information30 per_assignment_extra_info.aei_information30%type := p_information30 ;
332:
333: BEGIN
326: l_information25 per_assignment_extra_info.aei_information25%type := p_information25 ;
327: l_information26 per_assignment_extra_info.aei_information26%type := p_information26 ;
328: l_information27 per_assignment_extra_info.aei_information27%type := p_information27 ;
329: l_information28 per_assignment_extra_info.aei_information28%type := p_information28 ;
330: l_information29 per_assignment_extra_info.aei_information29%type := p_information29 ;
331: l_information30 per_assignment_extra_info.aei_information30%type := p_information30 ;
332:
333: BEGIN
334: ghr_history_fetch.fetch_asgei(
327: l_information26 per_assignment_extra_info.aei_information26%type := p_information26 ;
328: l_information27 per_assignment_extra_info.aei_information27%type := p_information27 ;
329: l_information28 per_assignment_extra_info.aei_information28%type := p_information28 ;
330: l_information29 per_assignment_extra_info.aei_information29%type := p_information29 ;
331: l_information30 per_assignment_extra_info.aei_information30%type := p_information30 ;
332:
333: BEGIN
334: ghr_history_fetch.fetch_asgei(
335: p_assignment_id => p_assignment_id