DBA Data[Home] [Help]

APPS.GHR_COMPLAINTS2_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 299: l_asg_ei_data per_assignment_extra_info%rowtype;

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 ;

Line 302: l_information1 per_assignment_extra_info.aei_information1%type := p_information1 ;

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 ;

Line 303: l_information2 per_assignment_extra_info.aei_information2%type := p_information2 ;

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 ;

Line 304: l_information3 per_assignment_extra_info.aei_information3%type := p_information3 ;

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 ;

Line 305: l_information4 per_assignment_extra_info.aei_information4%type := p_information4 ;

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 ;

Line 306: l_information5 per_assignment_extra_info.aei_information5%type := p_information5 ;

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 ;

Line 307: l_information6 per_assignment_extra_info.aei_information6%type := p_information6 ;

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 ;

Line 308: l_information7 per_assignment_extra_info.aei_information7%type := p_information7 ;

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 ;

Line 309: l_information8 per_assignment_extra_info.aei_information8%type := p_information8 ;

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 ;

Line 310: l_information9 per_assignment_extra_info.aei_information9%type := p_information9 ;

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 ;

Line 311: l_information10 per_assignment_extra_info.aei_information10%type := p_information10 ;

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 ;

Line 312: l_information11 per_assignment_extra_info.aei_information11%type := p_information11 ;

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 ;

Line 313: l_information12 per_assignment_extra_info.aei_information12%type := p_information12 ;

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 ;

Line 314: l_information13 per_assignment_extra_info.aei_information13%type := p_information13 ;

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 ;

Line 315: l_information14 per_assignment_extra_info.aei_information14%type := p_information14 ;

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 ;

Line 316: l_information15 per_assignment_extra_info.aei_information15%type := p_information15 ;

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 ;

Line 317: l_information16 per_assignment_extra_info.aei_information16%type := p_information16 ;

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 ;

Line 318: l_information17 per_assignment_extra_info.aei_information17%type := p_information17 ;

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 ;

Line 319: l_information18 per_assignment_extra_info.aei_information18%type := p_information18 ;

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 ;

Line 320: l_information19 per_assignment_extra_info.aei_information19%type := p_information19 ;

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 ;

Line 321: l_information20 per_assignment_extra_info.aei_information20%type := p_information20 ;

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 ;

Line 322: l_information21 per_assignment_extra_info.aei_information21%type := p_information21 ;

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 ;

Line 323: l_information22 per_assignment_extra_info.aei_information22%type := p_information22 ;

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 ;

Line 324: l_information23 per_assignment_extra_info.aei_information23%type := p_information23 ;

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 ;

Line 325: l_information24 per_assignment_extra_info.aei_information24%type := p_information24 ;

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 ;

Line 326: l_information25 per_assignment_extra_info.aei_information25%type := p_information25 ;

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 ;

Line 327: l_information26 per_assignment_extra_info.aei_information26%type := p_information26 ;

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 ;

Line 328: l_information27 per_assignment_extra_info.aei_information27%type := p_information27 ;

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:

Line 329: l_information28 per_assignment_extra_info.aei_information28%type := p_information28 ;

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

Line 330: l_information29 per_assignment_extra_info.aei_information29%type := p_information29 ;

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(

Line 331: l_information30 per_assignment_extra_info.aei_information30%type := p_information30 ;

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