eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_IPD_BUS dependencies on IRC_PENDING_DATA

Line 364: (p_vacancy_id in irc_pending_data.vacancy_id%type

360: --
361: -- {End Of Comments}
362: -- ----------------------------------------------------------------------------
363: Procedure chk_vacancy_id
364: (p_vacancy_id in irc_pending_data.vacancy_id%type
365: ,p_creation_date in irc_pending_data.creation_date%type
366: ) IS
367: --
368: l_proc varchar2(72) := g_package || 'chk_vacancy_id';

Line 365: ,p_creation_date in irc_pending_data.creation_date%type

361: -- {End Of Comments}
362: -- ----------------------------------------------------------------------------
363: Procedure chk_vacancy_id
364: (p_vacancy_id in irc_pending_data.vacancy_id%type
365: ,p_creation_date in irc_pending_data.creation_date%type
366: ) IS
367: --
368: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
369: l_num number;

Line 405: 'IRC_PENDING_DATA.VACANCY_ID'

401: exception
402: when app_exception.application_exception then
403: if hr_multi_message.exception_add
404: (p_associated_column1 =>
405: 'IRC_PENDING_DATA.VACANCY_ID'
406: ) then
407: hr_utility.set_location(' Leaving:'||l_proc,50);
408: raise;
409: end if;

Line 439: (p_vacancy_id in irc_pending_data.vacancy_id%type

435: --
436: -- {End Of Comments}
437: -- ----------------------------------------------------------------------------
438: Procedure chk_job_already_apld_for
439: (p_vacancy_id in irc_pending_data.vacancy_id%type
440: ,p_email_address in irc_pending_data.email_address%type
441: ) IS
442: --
443: l_proc varchar2(72) := g_package || 'chk_job_already_apld_for';

Line 440: ,p_email_address in irc_pending_data.email_address%type

436: -- {End Of Comments}
437: -- ----------------------------------------------------------------------------
438: Procedure chk_job_already_apld_for
439: (p_vacancy_id in irc_pending_data.vacancy_id%type
440: ,p_email_address in irc_pending_data.email_address%type
441: ) IS
442: --
443: l_proc varchar2(72) := g_package || 'chk_job_already_apld_for';
444: l_num number;

Line 448: from irc_pending_data

444: l_num number;
445: --
446: cursor csr_job is
447: select 1
448: from irc_pending_data
449: where vacancy_id = p_vacancy_id
450: and upper(email_address) = upper(p_email_address);
451: --
452: Begin

Line 457: p_check_column1 => 'IRC_PENDING_DATA.VACANCY_ID'

453: --
454: hr_utility.set_location(' Entering:'||l_proc,10);
455: --
456: if hr_multi_message.no_exclusive_error(
457: p_check_column1 => 'IRC_PENDING_DATA.VACANCY_ID'
458: ) then
459: --
460: open csr_job;
461: fetch csr_job into l_num;

Line 474: (p_associated_column1 => 'IRC_PENDING_DATA.VACANCY_ID'

470: --
471: exception
472: when app_exception.application_exception then
473: if hr_multi_message.exception_add
474: (p_associated_column1 => 'IRC_PENDING_DATA.VACANCY_ID'
475: ,p_associated_column2 => 'IRC_PENDING_DATA.EMAIL_ADDRESS'
476: ) then
477: hr_utility.set_location(' Leaving:'||l_proc,30);
478: raise;

Line 475: ,p_associated_column2 => 'IRC_PENDING_DATA.EMAIL_ADDRESS'

471: exception
472: when app_exception.application_exception then
473: if hr_multi_message.exception_add
474: (p_associated_column1 => 'IRC_PENDING_DATA.VACANCY_ID'
475: ,p_associated_column2 => 'IRC_PENDING_DATA.EMAIL_ADDRESS'
476: ) then
477: hr_utility.set_location(' Leaving:'||l_proc,30);
478: raise;
479: end if;

Line 511: (p_sex in irc_pending_data.sex%type

507: --
508: -- {End Of Comments}
509: -- ----------------------------------------------------------------------------
510: Procedure chk_sex
511: (p_sex in irc_pending_data.sex%type
512: ,p_creation_date in irc_pending_data.creation_date%type
513: ,p_pending_data_id in irc_pending_data.pending_data_id%type
514: ) IS
515: --

Line 512: ,p_creation_date in irc_pending_data.creation_date%type

508: -- {End Of Comments}
509: -- ----------------------------------------------------------------------------
510: Procedure chk_sex
511: (p_sex in irc_pending_data.sex%type
512: ,p_creation_date in irc_pending_data.creation_date%type
513: ,p_pending_data_id in irc_pending_data.pending_data_id%type
514: ) IS
515: --
516: l_api_updating boolean;

Line 513: ,p_pending_data_id in irc_pending_data.pending_data_id%type

509: -- ----------------------------------------------------------------------------
510: Procedure chk_sex
511: (p_sex in irc_pending_data.sex%type
512: ,p_creation_date in irc_pending_data.creation_date%type
513: ,p_pending_data_id in irc_pending_data.pending_data_id%type
514: ) IS
515: --
516: l_api_updating boolean;
517: l_proc varchar2(72) := g_package||'chk_sex';

Line 532: p_check_column1 => 'IRC_PENDING_DATA.VACANCY_ID'

528: (p_pending_data_id => p_pending_data_id
529: );
530: --
531: if hr_multi_message.no_exclusive_error(
532: p_check_column1 => 'IRC_PENDING_DATA.VACANCY_ID'
533: ) then
534: --
535: if (l_api_updating and nvl(p_sex,hr_api.g_varchar2)
536: <> nvl(irc_ipd_shd.g_old_rec.sex,hr_api.g_varchar2)

Line 561: 'IRC_PENDING_DATA.SEX'

557: exception
558: when app_exception.application_exception then
559: if hr_multi_message.exception_add
560: (p_associated_column1 =>
561: 'IRC_PENDING_DATA.SEX'
562: ) then
563: hr_utility.set_location(' Leaving:'||l_proc,30);
564: raise;
565: end if;

Line 596: (p_allow_access in irc_pending_data.allow_access%type

592: -- Internal Row Handler Use Only.
593: --
594: -- ----------------------------------------------------------------------------
595: Procedure chk_allow_access
596: (p_allow_access in irc_pending_data.allow_access%type
597: ) is
598: --
599: l_proc varchar2(72) := g_package||'chk_allow_access';
600: --

Line 623: (p_associated_column1 => 'IRC_PENDING_DATA.ALLOW_ACCESS'

619: --
620: exception
621: when app_exception.application_exception then
622: if hr_multi_message.exception_add
623: (p_associated_column1 => 'IRC_PENDING_DATA.ALLOW_ACCESS'
624: ) then
625: --
626: hr_utility.set_location(' Leaving:'||l_proc,40);
627: --

Line 710: (p_person_id in irc_pending_data.person_id%TYPE

706: -- Access Status:
707: -- Internal Table Handler Use Only.
708: --
709: procedure chk_GB_per_information
710: (p_person_id in irc_pending_data.person_id%TYPE
711: ,p_per_information_category in irc_pending_data.per_information_category
712: %TYPE
713: ,p_per_information1 in irc_pending_data.per_information1%TYPE
714: ,p_per_information2 in irc_pending_data.per_information2%TYPE

Line 711: ,p_per_information_category in irc_pending_data.per_information_category

707: -- Internal Table Handler Use Only.
708: --
709: procedure chk_GB_per_information
710: (p_person_id in irc_pending_data.person_id%TYPE
711: ,p_per_information_category in irc_pending_data.per_information_category
712: %TYPE
713: ,p_per_information1 in irc_pending_data.per_information1%TYPE
714: ,p_per_information2 in irc_pending_data.per_information2%TYPE
715: ,p_per_information3 in irc_pending_data.per_information3%TYPE

Line 713: ,p_per_information1 in irc_pending_data.per_information1%TYPE

709: procedure chk_GB_per_information
710: (p_person_id in irc_pending_data.person_id%TYPE
711: ,p_per_information_category in irc_pending_data.per_information_category
712: %TYPE
713: ,p_per_information1 in irc_pending_data.per_information1%TYPE
714: ,p_per_information2 in irc_pending_data.per_information2%TYPE
715: ,p_per_information3 in irc_pending_data.per_information3%TYPE
716: ,p_per_information4 in irc_pending_data.per_information4%TYPE
717: ,p_per_information5 in irc_pending_data.per_information5%TYPE

Line 714: ,p_per_information2 in irc_pending_data.per_information2%TYPE

710: (p_person_id in irc_pending_data.person_id%TYPE
711: ,p_per_information_category in irc_pending_data.per_information_category
712: %TYPE
713: ,p_per_information1 in irc_pending_data.per_information1%TYPE
714: ,p_per_information2 in irc_pending_data.per_information2%TYPE
715: ,p_per_information3 in irc_pending_data.per_information3%TYPE
716: ,p_per_information4 in irc_pending_data.per_information4%TYPE
717: ,p_per_information5 in irc_pending_data.per_information5%TYPE
718: ,p_per_information6 in irc_pending_data.per_information6%TYPE

Line 715: ,p_per_information3 in irc_pending_data.per_information3%TYPE

711: ,p_per_information_category in irc_pending_data.per_information_category
712: %TYPE
713: ,p_per_information1 in irc_pending_data.per_information1%TYPE
714: ,p_per_information2 in irc_pending_data.per_information2%TYPE
715: ,p_per_information3 in irc_pending_data.per_information3%TYPE
716: ,p_per_information4 in irc_pending_data.per_information4%TYPE
717: ,p_per_information5 in irc_pending_data.per_information5%TYPE
718: ,p_per_information6 in irc_pending_data.per_information6%TYPE
719: ,p_per_information7 in irc_pending_data.per_information7%TYPE

Line 716: ,p_per_information4 in irc_pending_data.per_information4%TYPE

712: %TYPE
713: ,p_per_information1 in irc_pending_data.per_information1%TYPE
714: ,p_per_information2 in irc_pending_data.per_information2%TYPE
715: ,p_per_information3 in irc_pending_data.per_information3%TYPE
716: ,p_per_information4 in irc_pending_data.per_information4%TYPE
717: ,p_per_information5 in irc_pending_data.per_information5%TYPE
718: ,p_per_information6 in irc_pending_data.per_information6%TYPE
719: ,p_per_information7 in irc_pending_data.per_information7%TYPE
720: ,p_per_information8 in irc_pending_data.per_information8%TYPE

Line 717: ,p_per_information5 in irc_pending_data.per_information5%TYPE

713: ,p_per_information1 in irc_pending_data.per_information1%TYPE
714: ,p_per_information2 in irc_pending_data.per_information2%TYPE
715: ,p_per_information3 in irc_pending_data.per_information3%TYPE
716: ,p_per_information4 in irc_pending_data.per_information4%TYPE
717: ,p_per_information5 in irc_pending_data.per_information5%TYPE
718: ,p_per_information6 in irc_pending_data.per_information6%TYPE
719: ,p_per_information7 in irc_pending_data.per_information7%TYPE
720: ,p_per_information8 in irc_pending_data.per_information8%TYPE
721: ,p_per_information9 in irc_pending_data.per_information9%TYPE

Line 718: ,p_per_information6 in irc_pending_data.per_information6%TYPE

714: ,p_per_information2 in irc_pending_data.per_information2%TYPE
715: ,p_per_information3 in irc_pending_data.per_information3%TYPE
716: ,p_per_information4 in irc_pending_data.per_information4%TYPE
717: ,p_per_information5 in irc_pending_data.per_information5%TYPE
718: ,p_per_information6 in irc_pending_data.per_information6%TYPE
719: ,p_per_information7 in irc_pending_data.per_information7%TYPE
720: ,p_per_information8 in irc_pending_data.per_information8%TYPE
721: ,p_per_information9 in irc_pending_data.per_information9%TYPE
722: ,p_per_information10 in irc_pending_data.per_information10%TYPE

Line 719: ,p_per_information7 in irc_pending_data.per_information7%TYPE

715: ,p_per_information3 in irc_pending_data.per_information3%TYPE
716: ,p_per_information4 in irc_pending_data.per_information4%TYPE
717: ,p_per_information5 in irc_pending_data.per_information5%TYPE
718: ,p_per_information6 in irc_pending_data.per_information6%TYPE
719: ,p_per_information7 in irc_pending_data.per_information7%TYPE
720: ,p_per_information8 in irc_pending_data.per_information8%TYPE
721: ,p_per_information9 in irc_pending_data.per_information9%TYPE
722: ,p_per_information10 in irc_pending_data.per_information10%TYPE
723: ,p_per_information11 in irc_pending_data.per_information11%TYPE

Line 720: ,p_per_information8 in irc_pending_data.per_information8%TYPE

716: ,p_per_information4 in irc_pending_data.per_information4%TYPE
717: ,p_per_information5 in irc_pending_data.per_information5%TYPE
718: ,p_per_information6 in irc_pending_data.per_information6%TYPE
719: ,p_per_information7 in irc_pending_data.per_information7%TYPE
720: ,p_per_information8 in irc_pending_data.per_information8%TYPE
721: ,p_per_information9 in irc_pending_data.per_information9%TYPE
722: ,p_per_information10 in irc_pending_data.per_information10%TYPE
723: ,p_per_information11 in irc_pending_data.per_information11%TYPE
724: ,p_per_information12 in irc_pending_data.per_information12%TYPE

Line 721: ,p_per_information9 in irc_pending_data.per_information9%TYPE

717: ,p_per_information5 in irc_pending_data.per_information5%TYPE
718: ,p_per_information6 in irc_pending_data.per_information6%TYPE
719: ,p_per_information7 in irc_pending_data.per_information7%TYPE
720: ,p_per_information8 in irc_pending_data.per_information8%TYPE
721: ,p_per_information9 in irc_pending_data.per_information9%TYPE
722: ,p_per_information10 in irc_pending_data.per_information10%TYPE
723: ,p_per_information11 in irc_pending_data.per_information11%TYPE
724: ,p_per_information12 in irc_pending_data.per_information12%TYPE
725: ,p_per_information13 in irc_pending_data.per_information13%TYPE

Line 722: ,p_per_information10 in irc_pending_data.per_information10%TYPE

718: ,p_per_information6 in irc_pending_data.per_information6%TYPE
719: ,p_per_information7 in irc_pending_data.per_information7%TYPE
720: ,p_per_information8 in irc_pending_data.per_information8%TYPE
721: ,p_per_information9 in irc_pending_data.per_information9%TYPE
722: ,p_per_information10 in irc_pending_data.per_information10%TYPE
723: ,p_per_information11 in irc_pending_data.per_information11%TYPE
724: ,p_per_information12 in irc_pending_data.per_information12%TYPE
725: ,p_per_information13 in irc_pending_data.per_information13%TYPE
726: ,p_per_information14 in irc_pending_data.per_information14%TYPE

Line 723: ,p_per_information11 in irc_pending_data.per_information11%TYPE

719: ,p_per_information7 in irc_pending_data.per_information7%TYPE
720: ,p_per_information8 in irc_pending_data.per_information8%TYPE
721: ,p_per_information9 in irc_pending_data.per_information9%TYPE
722: ,p_per_information10 in irc_pending_data.per_information10%TYPE
723: ,p_per_information11 in irc_pending_data.per_information11%TYPE
724: ,p_per_information12 in irc_pending_data.per_information12%TYPE
725: ,p_per_information13 in irc_pending_data.per_information13%TYPE
726: ,p_per_information14 in irc_pending_data.per_information14%TYPE
727: ,p_per_information15 in irc_pending_data.per_information15%TYPE

Line 724: ,p_per_information12 in irc_pending_data.per_information12%TYPE

720: ,p_per_information8 in irc_pending_data.per_information8%TYPE
721: ,p_per_information9 in irc_pending_data.per_information9%TYPE
722: ,p_per_information10 in irc_pending_data.per_information10%TYPE
723: ,p_per_information11 in irc_pending_data.per_information11%TYPE
724: ,p_per_information12 in irc_pending_data.per_information12%TYPE
725: ,p_per_information13 in irc_pending_data.per_information13%TYPE
726: ,p_per_information14 in irc_pending_data.per_information14%TYPE
727: ,p_per_information15 in irc_pending_data.per_information15%TYPE
728: ,p_per_information16 in irc_pending_data.per_information16%TYPE

Line 725: ,p_per_information13 in irc_pending_data.per_information13%TYPE

721: ,p_per_information9 in irc_pending_data.per_information9%TYPE
722: ,p_per_information10 in irc_pending_data.per_information10%TYPE
723: ,p_per_information11 in irc_pending_data.per_information11%TYPE
724: ,p_per_information12 in irc_pending_data.per_information12%TYPE
725: ,p_per_information13 in irc_pending_data.per_information13%TYPE
726: ,p_per_information14 in irc_pending_data.per_information14%TYPE
727: ,p_per_information15 in irc_pending_data.per_information15%TYPE
728: ,p_per_information16 in irc_pending_data.per_information16%TYPE
729: ,p_per_information17 in irc_pending_data.per_information17%TYPE

Line 726: ,p_per_information14 in irc_pending_data.per_information14%TYPE

722: ,p_per_information10 in irc_pending_data.per_information10%TYPE
723: ,p_per_information11 in irc_pending_data.per_information11%TYPE
724: ,p_per_information12 in irc_pending_data.per_information12%TYPE
725: ,p_per_information13 in irc_pending_data.per_information13%TYPE
726: ,p_per_information14 in irc_pending_data.per_information14%TYPE
727: ,p_per_information15 in irc_pending_data.per_information15%TYPE
728: ,p_per_information16 in irc_pending_data.per_information16%TYPE
729: ,p_per_information17 in irc_pending_data.per_information17%TYPE
730: ,p_per_information18 in irc_pending_data.per_information18%TYPE

Line 727: ,p_per_information15 in irc_pending_data.per_information15%TYPE

723: ,p_per_information11 in irc_pending_data.per_information11%TYPE
724: ,p_per_information12 in irc_pending_data.per_information12%TYPE
725: ,p_per_information13 in irc_pending_data.per_information13%TYPE
726: ,p_per_information14 in irc_pending_data.per_information14%TYPE
727: ,p_per_information15 in irc_pending_data.per_information15%TYPE
728: ,p_per_information16 in irc_pending_data.per_information16%TYPE
729: ,p_per_information17 in irc_pending_data.per_information17%TYPE
730: ,p_per_information18 in irc_pending_data.per_information18%TYPE
731: ,p_per_information19 in irc_pending_data.per_information19%TYPE

Line 728: ,p_per_information16 in irc_pending_data.per_information16%TYPE

724: ,p_per_information12 in irc_pending_data.per_information12%TYPE
725: ,p_per_information13 in irc_pending_data.per_information13%TYPE
726: ,p_per_information14 in irc_pending_data.per_information14%TYPE
727: ,p_per_information15 in irc_pending_data.per_information15%TYPE
728: ,p_per_information16 in irc_pending_data.per_information16%TYPE
729: ,p_per_information17 in irc_pending_data.per_information17%TYPE
730: ,p_per_information18 in irc_pending_data.per_information18%TYPE
731: ,p_per_information19 in irc_pending_data.per_information19%TYPE
732: ,p_per_information20 in irc_pending_data.per_information20%TYPE

Line 729: ,p_per_information17 in irc_pending_data.per_information17%TYPE

725: ,p_per_information13 in irc_pending_data.per_information13%TYPE
726: ,p_per_information14 in irc_pending_data.per_information14%TYPE
727: ,p_per_information15 in irc_pending_data.per_information15%TYPE
728: ,p_per_information16 in irc_pending_data.per_information16%TYPE
729: ,p_per_information17 in irc_pending_data.per_information17%TYPE
730: ,p_per_information18 in irc_pending_data.per_information18%TYPE
731: ,p_per_information19 in irc_pending_data.per_information19%TYPE
732: ,p_per_information20 in irc_pending_data.per_information20%TYPE
733: ,p_per_information21 in irc_pending_data.per_information21%TYPE

Line 730: ,p_per_information18 in irc_pending_data.per_information18%TYPE

726: ,p_per_information14 in irc_pending_data.per_information14%TYPE
727: ,p_per_information15 in irc_pending_data.per_information15%TYPE
728: ,p_per_information16 in irc_pending_data.per_information16%TYPE
729: ,p_per_information17 in irc_pending_data.per_information17%TYPE
730: ,p_per_information18 in irc_pending_data.per_information18%TYPE
731: ,p_per_information19 in irc_pending_data.per_information19%TYPE
732: ,p_per_information20 in irc_pending_data.per_information20%TYPE
733: ,p_per_information21 in irc_pending_data.per_information21%TYPE
734: ,p_per_information22 in irc_pending_data.per_information22%TYPE

Line 731: ,p_per_information19 in irc_pending_data.per_information19%TYPE

727: ,p_per_information15 in irc_pending_data.per_information15%TYPE
728: ,p_per_information16 in irc_pending_data.per_information16%TYPE
729: ,p_per_information17 in irc_pending_data.per_information17%TYPE
730: ,p_per_information18 in irc_pending_data.per_information18%TYPE
731: ,p_per_information19 in irc_pending_data.per_information19%TYPE
732: ,p_per_information20 in irc_pending_data.per_information20%TYPE
733: ,p_per_information21 in irc_pending_data.per_information21%TYPE
734: ,p_per_information22 in irc_pending_data.per_information22%TYPE
735: ,p_per_information23 in irc_pending_data.per_information23%TYPE

Line 732: ,p_per_information20 in irc_pending_data.per_information20%TYPE

728: ,p_per_information16 in irc_pending_data.per_information16%TYPE
729: ,p_per_information17 in irc_pending_data.per_information17%TYPE
730: ,p_per_information18 in irc_pending_data.per_information18%TYPE
731: ,p_per_information19 in irc_pending_data.per_information19%TYPE
732: ,p_per_information20 in irc_pending_data.per_information20%TYPE
733: ,p_per_information21 in irc_pending_data.per_information21%TYPE
734: ,p_per_information22 in irc_pending_data.per_information22%TYPE
735: ,p_per_information23 in irc_pending_data.per_information23%TYPE
736: ,p_per_information24 in irc_pending_data.per_information24%TYPE

Line 733: ,p_per_information21 in irc_pending_data.per_information21%TYPE

729: ,p_per_information17 in irc_pending_data.per_information17%TYPE
730: ,p_per_information18 in irc_pending_data.per_information18%TYPE
731: ,p_per_information19 in irc_pending_data.per_information19%TYPE
732: ,p_per_information20 in irc_pending_data.per_information20%TYPE
733: ,p_per_information21 in irc_pending_data.per_information21%TYPE
734: ,p_per_information22 in irc_pending_data.per_information22%TYPE
735: ,p_per_information23 in irc_pending_data.per_information23%TYPE
736: ,p_per_information24 in irc_pending_data.per_information24%TYPE
737: ,p_per_information25 in irc_pending_data.per_information25%TYPE

Line 734: ,p_per_information22 in irc_pending_data.per_information22%TYPE

730: ,p_per_information18 in irc_pending_data.per_information18%TYPE
731: ,p_per_information19 in irc_pending_data.per_information19%TYPE
732: ,p_per_information20 in irc_pending_data.per_information20%TYPE
733: ,p_per_information21 in irc_pending_data.per_information21%TYPE
734: ,p_per_information22 in irc_pending_data.per_information22%TYPE
735: ,p_per_information23 in irc_pending_data.per_information23%TYPE
736: ,p_per_information24 in irc_pending_data.per_information24%TYPE
737: ,p_per_information25 in irc_pending_data.per_information25%TYPE
738: ,p_per_information26 in irc_pending_data.per_information26%TYPE

Line 735: ,p_per_information23 in irc_pending_data.per_information23%TYPE

731: ,p_per_information19 in irc_pending_data.per_information19%TYPE
732: ,p_per_information20 in irc_pending_data.per_information20%TYPE
733: ,p_per_information21 in irc_pending_data.per_information21%TYPE
734: ,p_per_information22 in irc_pending_data.per_information22%TYPE
735: ,p_per_information23 in irc_pending_data.per_information23%TYPE
736: ,p_per_information24 in irc_pending_data.per_information24%TYPE
737: ,p_per_information25 in irc_pending_data.per_information25%TYPE
738: ,p_per_information26 in irc_pending_data.per_information26%TYPE
739: ,p_per_information27 in irc_pending_data.per_information27%TYPE

Line 736: ,p_per_information24 in irc_pending_data.per_information24%TYPE

732: ,p_per_information20 in irc_pending_data.per_information20%TYPE
733: ,p_per_information21 in irc_pending_data.per_information21%TYPE
734: ,p_per_information22 in irc_pending_data.per_information22%TYPE
735: ,p_per_information23 in irc_pending_data.per_information23%TYPE
736: ,p_per_information24 in irc_pending_data.per_information24%TYPE
737: ,p_per_information25 in irc_pending_data.per_information25%TYPE
738: ,p_per_information26 in irc_pending_data.per_information26%TYPE
739: ,p_per_information27 in irc_pending_data.per_information27%TYPE
740: ,p_per_information28 in irc_pending_data.per_information28%TYPE

Line 737: ,p_per_information25 in irc_pending_data.per_information25%TYPE

733: ,p_per_information21 in irc_pending_data.per_information21%TYPE
734: ,p_per_information22 in irc_pending_data.per_information22%TYPE
735: ,p_per_information23 in irc_pending_data.per_information23%TYPE
736: ,p_per_information24 in irc_pending_data.per_information24%TYPE
737: ,p_per_information25 in irc_pending_data.per_information25%TYPE
738: ,p_per_information26 in irc_pending_data.per_information26%TYPE
739: ,p_per_information27 in irc_pending_data.per_information27%TYPE
740: ,p_per_information28 in irc_pending_data.per_information28%TYPE
741: ,p_per_information29 in irc_pending_data.per_information29%TYPE

Line 738: ,p_per_information26 in irc_pending_data.per_information26%TYPE

734: ,p_per_information22 in irc_pending_data.per_information22%TYPE
735: ,p_per_information23 in irc_pending_data.per_information23%TYPE
736: ,p_per_information24 in irc_pending_data.per_information24%TYPE
737: ,p_per_information25 in irc_pending_data.per_information25%TYPE
738: ,p_per_information26 in irc_pending_data.per_information26%TYPE
739: ,p_per_information27 in irc_pending_data.per_information27%TYPE
740: ,p_per_information28 in irc_pending_data.per_information28%TYPE
741: ,p_per_information29 in irc_pending_data.per_information29%TYPE
742: ,p_per_information30 in irc_pending_data.per_information30%TYPE

Line 739: ,p_per_information27 in irc_pending_data.per_information27%TYPE

735: ,p_per_information23 in irc_pending_data.per_information23%TYPE
736: ,p_per_information24 in irc_pending_data.per_information24%TYPE
737: ,p_per_information25 in irc_pending_data.per_information25%TYPE
738: ,p_per_information26 in irc_pending_data.per_information26%TYPE
739: ,p_per_information27 in irc_pending_data.per_information27%TYPE
740: ,p_per_information28 in irc_pending_data.per_information28%TYPE
741: ,p_per_information29 in irc_pending_data.per_information29%TYPE
742: ,p_per_information30 in irc_pending_data.per_information30%TYPE
743: ,p_creation_date in irc_pending_data.creation_date%TYPE

Line 740: ,p_per_information28 in irc_pending_data.per_information28%TYPE

736: ,p_per_information24 in irc_pending_data.per_information24%TYPE
737: ,p_per_information25 in irc_pending_data.per_information25%TYPE
738: ,p_per_information26 in irc_pending_data.per_information26%TYPE
739: ,p_per_information27 in irc_pending_data.per_information27%TYPE
740: ,p_per_information28 in irc_pending_data.per_information28%TYPE
741: ,p_per_information29 in irc_pending_data.per_information29%TYPE
742: ,p_per_information30 in irc_pending_data.per_information30%TYPE
743: ,p_creation_date in irc_pending_data.creation_date%TYPE
744: )

Line 741: ,p_per_information29 in irc_pending_data.per_information29%TYPE

737: ,p_per_information25 in irc_pending_data.per_information25%TYPE
738: ,p_per_information26 in irc_pending_data.per_information26%TYPE
739: ,p_per_information27 in irc_pending_data.per_information27%TYPE
740: ,p_per_information28 in irc_pending_data.per_information28%TYPE
741: ,p_per_information29 in irc_pending_data.per_information29%TYPE
742: ,p_per_information30 in irc_pending_data.per_information30%TYPE
743: ,p_creation_date in irc_pending_data.creation_date%TYPE
744: )
745: is

Line 742: ,p_per_information30 in irc_pending_data.per_information30%TYPE

738: ,p_per_information26 in irc_pending_data.per_information26%TYPE
739: ,p_per_information27 in irc_pending_data.per_information27%TYPE
740: ,p_per_information28 in irc_pending_data.per_information28%TYPE
741: ,p_per_information29 in irc_pending_data.per_information29%TYPE
742: ,p_per_information30 in irc_pending_data.per_information30%TYPE
743: ,p_creation_date in irc_pending_data.creation_date%TYPE
744: )
745: is
746: --

Line 743: ,p_creation_date in irc_pending_data.creation_date%TYPE

739: ,p_per_information27 in irc_pending_data.per_information27%TYPE
740: ,p_per_information28 in irc_pending_data.per_information28%TYPE
741: ,p_per_information29 in irc_pending_data.per_information29%TYPE
742: ,p_per_information30 in irc_pending_data.per_information30%TYPE
743: ,p_creation_date in irc_pending_data.creation_date%TYPE
744: )
745: is
746: --
747: l_error exception;

Line 752: l_per_information6 irc_pending_data.per_information6%TYPE;

748: l_proc varchar2(72) := g_package||'chk_GB_per_information';
749: l_api_updating boolean;
750: l_lookup_type varchar2(30);
751: l_info_attribute number(2);
752: l_per_information6 irc_pending_data.per_information6%TYPE;
753: l_per_information7 irc_pending_data.per_information7%TYPE;
754: l_per_information8 irc_pending_data.per_information8%TYPE;
755: l_output varchar2(150);
756: l_rgeflg varchar2(10);

Line 753: l_per_information7 irc_pending_data.per_information7%TYPE;

749: l_api_updating boolean;
750: l_lookup_type varchar2(30);
751: l_info_attribute number(2);
752: l_per_information6 irc_pending_data.per_information6%TYPE;
753: l_per_information7 irc_pending_data.per_information7%TYPE;
754: l_per_information8 irc_pending_data.per_information8%TYPE;
755: l_output varchar2(150);
756: l_rgeflg varchar2(10);
757: --

Line 754: l_per_information8 irc_pending_data.per_information8%TYPE;

750: l_lookup_type varchar2(30);
751: l_info_attribute number(2);
752: l_per_information6 irc_pending_data.per_information6%TYPE;
753: l_per_information7 irc_pending_data.per_information7%TYPE;
754: l_per_information8 irc_pending_data.per_information8%TYPE;
755: l_output varchar2(150);
756: l_rgeflg varchar2(10);
757: --
758: begin

Line 1193: (p_person_id in irc_pending_data.person_id%TYPE

1189: -- Access Status:
1190: -- Internal Table Handler Use Only
1191: --
1192: procedure chk_US_per_information
1193: (p_person_id in irc_pending_data.person_id%TYPE
1194: ,p_per_information_category in irc_pending_data.per_information_category
1195: %TYPE
1196: ,p_per_information1 in irc_pending_data.per_information1%TYPE
1197: ,p_per_information2 in irc_pending_data.per_information2%TYPE

Line 1194: ,p_per_information_category in irc_pending_data.per_information_category

1190: -- Internal Table Handler Use Only
1191: --
1192: procedure chk_US_per_information
1193: (p_person_id in irc_pending_data.person_id%TYPE
1194: ,p_per_information_category in irc_pending_data.per_information_category
1195: %TYPE
1196: ,p_per_information1 in irc_pending_data.per_information1%TYPE
1197: ,p_per_information2 in irc_pending_data.per_information2%TYPE
1198: ,p_per_information3 in irc_pending_data.per_information3%TYPE

Line 1196: ,p_per_information1 in irc_pending_data.per_information1%TYPE

1192: procedure chk_US_per_information
1193: (p_person_id in irc_pending_data.person_id%TYPE
1194: ,p_per_information_category in irc_pending_data.per_information_category
1195: %TYPE
1196: ,p_per_information1 in irc_pending_data.per_information1%TYPE
1197: ,p_per_information2 in irc_pending_data.per_information2%TYPE
1198: ,p_per_information3 in irc_pending_data.per_information3%TYPE
1199: ,p_per_information4 in irc_pending_data.per_information4%TYPE
1200: ,p_per_information5 in irc_pending_data.per_information5%TYPE

Line 1197: ,p_per_information2 in irc_pending_data.per_information2%TYPE

1193: (p_person_id in irc_pending_data.person_id%TYPE
1194: ,p_per_information_category in irc_pending_data.per_information_category
1195: %TYPE
1196: ,p_per_information1 in irc_pending_data.per_information1%TYPE
1197: ,p_per_information2 in irc_pending_data.per_information2%TYPE
1198: ,p_per_information3 in irc_pending_data.per_information3%TYPE
1199: ,p_per_information4 in irc_pending_data.per_information4%TYPE
1200: ,p_per_information5 in irc_pending_data.per_information5%TYPE
1201: ,p_per_information6 in irc_pending_data.per_information6%TYPE

Line 1198: ,p_per_information3 in irc_pending_data.per_information3%TYPE

1194: ,p_per_information_category in irc_pending_data.per_information_category
1195: %TYPE
1196: ,p_per_information1 in irc_pending_data.per_information1%TYPE
1197: ,p_per_information2 in irc_pending_data.per_information2%TYPE
1198: ,p_per_information3 in irc_pending_data.per_information3%TYPE
1199: ,p_per_information4 in irc_pending_data.per_information4%TYPE
1200: ,p_per_information5 in irc_pending_data.per_information5%TYPE
1201: ,p_per_information6 in irc_pending_data.per_information6%TYPE
1202: ,p_per_information7 in irc_pending_data.per_information7%TYPE

Line 1199: ,p_per_information4 in irc_pending_data.per_information4%TYPE

1195: %TYPE
1196: ,p_per_information1 in irc_pending_data.per_information1%TYPE
1197: ,p_per_information2 in irc_pending_data.per_information2%TYPE
1198: ,p_per_information3 in irc_pending_data.per_information3%TYPE
1199: ,p_per_information4 in irc_pending_data.per_information4%TYPE
1200: ,p_per_information5 in irc_pending_data.per_information5%TYPE
1201: ,p_per_information6 in irc_pending_data.per_information6%TYPE
1202: ,p_per_information7 in irc_pending_data.per_information7%TYPE
1203: ,p_per_information8 in irc_pending_data.per_information8%TYPE

Line 1200: ,p_per_information5 in irc_pending_data.per_information5%TYPE

1196: ,p_per_information1 in irc_pending_data.per_information1%TYPE
1197: ,p_per_information2 in irc_pending_data.per_information2%TYPE
1198: ,p_per_information3 in irc_pending_data.per_information3%TYPE
1199: ,p_per_information4 in irc_pending_data.per_information4%TYPE
1200: ,p_per_information5 in irc_pending_data.per_information5%TYPE
1201: ,p_per_information6 in irc_pending_data.per_information6%TYPE
1202: ,p_per_information7 in irc_pending_data.per_information7%TYPE
1203: ,p_per_information8 in irc_pending_data.per_information8%TYPE
1204: ,p_per_information9 in irc_pending_data.per_information9%TYPE

Line 1201: ,p_per_information6 in irc_pending_data.per_information6%TYPE

1197: ,p_per_information2 in irc_pending_data.per_information2%TYPE
1198: ,p_per_information3 in irc_pending_data.per_information3%TYPE
1199: ,p_per_information4 in irc_pending_data.per_information4%TYPE
1200: ,p_per_information5 in irc_pending_data.per_information5%TYPE
1201: ,p_per_information6 in irc_pending_data.per_information6%TYPE
1202: ,p_per_information7 in irc_pending_data.per_information7%TYPE
1203: ,p_per_information8 in irc_pending_data.per_information8%TYPE
1204: ,p_per_information9 in irc_pending_data.per_information9%TYPE
1205: ,p_per_information10 in irc_pending_data.per_information10%TYPE

Line 1202: ,p_per_information7 in irc_pending_data.per_information7%TYPE

1198: ,p_per_information3 in irc_pending_data.per_information3%TYPE
1199: ,p_per_information4 in irc_pending_data.per_information4%TYPE
1200: ,p_per_information5 in irc_pending_data.per_information5%TYPE
1201: ,p_per_information6 in irc_pending_data.per_information6%TYPE
1202: ,p_per_information7 in irc_pending_data.per_information7%TYPE
1203: ,p_per_information8 in irc_pending_data.per_information8%TYPE
1204: ,p_per_information9 in irc_pending_data.per_information9%TYPE
1205: ,p_per_information10 in irc_pending_data.per_information10%TYPE
1206: ,p_per_information11 in irc_pending_data.per_information11%TYPE

Line 1203: ,p_per_information8 in irc_pending_data.per_information8%TYPE

1199: ,p_per_information4 in irc_pending_data.per_information4%TYPE
1200: ,p_per_information5 in irc_pending_data.per_information5%TYPE
1201: ,p_per_information6 in irc_pending_data.per_information6%TYPE
1202: ,p_per_information7 in irc_pending_data.per_information7%TYPE
1203: ,p_per_information8 in irc_pending_data.per_information8%TYPE
1204: ,p_per_information9 in irc_pending_data.per_information9%TYPE
1205: ,p_per_information10 in irc_pending_data.per_information10%TYPE
1206: ,p_per_information11 in irc_pending_data.per_information11%TYPE
1207: ,p_per_information12 in irc_pending_data.per_information12%TYPE

Line 1204: ,p_per_information9 in irc_pending_data.per_information9%TYPE

1200: ,p_per_information5 in irc_pending_data.per_information5%TYPE
1201: ,p_per_information6 in irc_pending_data.per_information6%TYPE
1202: ,p_per_information7 in irc_pending_data.per_information7%TYPE
1203: ,p_per_information8 in irc_pending_data.per_information8%TYPE
1204: ,p_per_information9 in irc_pending_data.per_information9%TYPE
1205: ,p_per_information10 in irc_pending_data.per_information10%TYPE
1206: ,p_per_information11 in irc_pending_data.per_information11%TYPE
1207: ,p_per_information12 in irc_pending_data.per_information12%TYPE
1208: ,p_per_information13 in irc_pending_data.per_information13%TYPE

Line 1205: ,p_per_information10 in irc_pending_data.per_information10%TYPE

1201: ,p_per_information6 in irc_pending_data.per_information6%TYPE
1202: ,p_per_information7 in irc_pending_data.per_information7%TYPE
1203: ,p_per_information8 in irc_pending_data.per_information8%TYPE
1204: ,p_per_information9 in irc_pending_data.per_information9%TYPE
1205: ,p_per_information10 in irc_pending_data.per_information10%TYPE
1206: ,p_per_information11 in irc_pending_data.per_information11%TYPE
1207: ,p_per_information12 in irc_pending_data.per_information12%TYPE
1208: ,p_per_information13 in irc_pending_data.per_information13%TYPE
1209: ,p_per_information14 in irc_pending_data.per_information14%TYPE

Line 1206: ,p_per_information11 in irc_pending_data.per_information11%TYPE

1202: ,p_per_information7 in irc_pending_data.per_information7%TYPE
1203: ,p_per_information8 in irc_pending_data.per_information8%TYPE
1204: ,p_per_information9 in irc_pending_data.per_information9%TYPE
1205: ,p_per_information10 in irc_pending_data.per_information10%TYPE
1206: ,p_per_information11 in irc_pending_data.per_information11%TYPE
1207: ,p_per_information12 in irc_pending_data.per_information12%TYPE
1208: ,p_per_information13 in irc_pending_data.per_information13%TYPE
1209: ,p_per_information14 in irc_pending_data.per_information14%TYPE
1210: ,p_per_information15 in irc_pending_data.per_information15%TYPE

Line 1207: ,p_per_information12 in irc_pending_data.per_information12%TYPE

1203: ,p_per_information8 in irc_pending_data.per_information8%TYPE
1204: ,p_per_information9 in irc_pending_data.per_information9%TYPE
1205: ,p_per_information10 in irc_pending_data.per_information10%TYPE
1206: ,p_per_information11 in irc_pending_data.per_information11%TYPE
1207: ,p_per_information12 in irc_pending_data.per_information12%TYPE
1208: ,p_per_information13 in irc_pending_data.per_information13%TYPE
1209: ,p_per_information14 in irc_pending_data.per_information14%TYPE
1210: ,p_per_information15 in irc_pending_data.per_information15%TYPE
1211: ,p_per_information16 in irc_pending_data.per_information16%TYPE

Line 1208: ,p_per_information13 in irc_pending_data.per_information13%TYPE

1204: ,p_per_information9 in irc_pending_data.per_information9%TYPE
1205: ,p_per_information10 in irc_pending_data.per_information10%TYPE
1206: ,p_per_information11 in irc_pending_data.per_information11%TYPE
1207: ,p_per_information12 in irc_pending_data.per_information12%TYPE
1208: ,p_per_information13 in irc_pending_data.per_information13%TYPE
1209: ,p_per_information14 in irc_pending_data.per_information14%TYPE
1210: ,p_per_information15 in irc_pending_data.per_information15%TYPE
1211: ,p_per_information16 in irc_pending_data.per_information16%TYPE
1212: ,p_per_information17 in irc_pending_data.per_information17%TYPE

Line 1209: ,p_per_information14 in irc_pending_data.per_information14%TYPE

1205: ,p_per_information10 in irc_pending_data.per_information10%TYPE
1206: ,p_per_information11 in irc_pending_data.per_information11%TYPE
1207: ,p_per_information12 in irc_pending_data.per_information12%TYPE
1208: ,p_per_information13 in irc_pending_data.per_information13%TYPE
1209: ,p_per_information14 in irc_pending_data.per_information14%TYPE
1210: ,p_per_information15 in irc_pending_data.per_information15%TYPE
1211: ,p_per_information16 in irc_pending_data.per_information16%TYPE
1212: ,p_per_information17 in irc_pending_data.per_information17%TYPE
1213: ,p_per_information18 in irc_pending_data.per_information18%TYPE

Line 1210: ,p_per_information15 in irc_pending_data.per_information15%TYPE

1206: ,p_per_information11 in irc_pending_data.per_information11%TYPE
1207: ,p_per_information12 in irc_pending_data.per_information12%TYPE
1208: ,p_per_information13 in irc_pending_data.per_information13%TYPE
1209: ,p_per_information14 in irc_pending_data.per_information14%TYPE
1210: ,p_per_information15 in irc_pending_data.per_information15%TYPE
1211: ,p_per_information16 in irc_pending_data.per_information16%TYPE
1212: ,p_per_information17 in irc_pending_data.per_information17%TYPE
1213: ,p_per_information18 in irc_pending_data.per_information18%TYPE
1214: ,p_per_information19 in irc_pending_data.per_information19%TYPE

Line 1211: ,p_per_information16 in irc_pending_data.per_information16%TYPE

1207: ,p_per_information12 in irc_pending_data.per_information12%TYPE
1208: ,p_per_information13 in irc_pending_data.per_information13%TYPE
1209: ,p_per_information14 in irc_pending_data.per_information14%TYPE
1210: ,p_per_information15 in irc_pending_data.per_information15%TYPE
1211: ,p_per_information16 in irc_pending_data.per_information16%TYPE
1212: ,p_per_information17 in irc_pending_data.per_information17%TYPE
1213: ,p_per_information18 in irc_pending_data.per_information18%TYPE
1214: ,p_per_information19 in irc_pending_data.per_information19%TYPE
1215: ,p_per_information20 in irc_pending_data.per_information20%TYPE

Line 1212: ,p_per_information17 in irc_pending_data.per_information17%TYPE

1208: ,p_per_information13 in irc_pending_data.per_information13%TYPE
1209: ,p_per_information14 in irc_pending_data.per_information14%TYPE
1210: ,p_per_information15 in irc_pending_data.per_information15%TYPE
1211: ,p_per_information16 in irc_pending_data.per_information16%TYPE
1212: ,p_per_information17 in irc_pending_data.per_information17%TYPE
1213: ,p_per_information18 in irc_pending_data.per_information18%TYPE
1214: ,p_per_information19 in irc_pending_data.per_information19%TYPE
1215: ,p_per_information20 in irc_pending_data.per_information20%TYPE
1216: ,p_per_information21 in irc_pending_data.per_information21%TYPE

Line 1213: ,p_per_information18 in irc_pending_data.per_information18%TYPE

1209: ,p_per_information14 in irc_pending_data.per_information14%TYPE
1210: ,p_per_information15 in irc_pending_data.per_information15%TYPE
1211: ,p_per_information16 in irc_pending_data.per_information16%TYPE
1212: ,p_per_information17 in irc_pending_data.per_information17%TYPE
1213: ,p_per_information18 in irc_pending_data.per_information18%TYPE
1214: ,p_per_information19 in irc_pending_data.per_information19%TYPE
1215: ,p_per_information20 in irc_pending_data.per_information20%TYPE
1216: ,p_per_information21 in irc_pending_data.per_information21%TYPE
1217: ,p_per_information22 in irc_pending_data.per_information22%TYPE

Line 1214: ,p_per_information19 in irc_pending_data.per_information19%TYPE

1210: ,p_per_information15 in irc_pending_data.per_information15%TYPE
1211: ,p_per_information16 in irc_pending_data.per_information16%TYPE
1212: ,p_per_information17 in irc_pending_data.per_information17%TYPE
1213: ,p_per_information18 in irc_pending_data.per_information18%TYPE
1214: ,p_per_information19 in irc_pending_data.per_information19%TYPE
1215: ,p_per_information20 in irc_pending_data.per_information20%TYPE
1216: ,p_per_information21 in irc_pending_data.per_information21%TYPE
1217: ,p_per_information22 in irc_pending_data.per_information22%TYPE
1218: ,p_per_information23 in irc_pending_data.per_information23%TYPE

Line 1215: ,p_per_information20 in irc_pending_data.per_information20%TYPE

1211: ,p_per_information16 in irc_pending_data.per_information16%TYPE
1212: ,p_per_information17 in irc_pending_data.per_information17%TYPE
1213: ,p_per_information18 in irc_pending_data.per_information18%TYPE
1214: ,p_per_information19 in irc_pending_data.per_information19%TYPE
1215: ,p_per_information20 in irc_pending_data.per_information20%TYPE
1216: ,p_per_information21 in irc_pending_data.per_information21%TYPE
1217: ,p_per_information22 in irc_pending_data.per_information22%TYPE
1218: ,p_per_information23 in irc_pending_data.per_information23%TYPE
1219: ,p_per_information24 in irc_pending_data.per_information24%TYPE

Line 1216: ,p_per_information21 in irc_pending_data.per_information21%TYPE

1212: ,p_per_information17 in irc_pending_data.per_information17%TYPE
1213: ,p_per_information18 in irc_pending_data.per_information18%TYPE
1214: ,p_per_information19 in irc_pending_data.per_information19%TYPE
1215: ,p_per_information20 in irc_pending_data.per_information20%TYPE
1216: ,p_per_information21 in irc_pending_data.per_information21%TYPE
1217: ,p_per_information22 in irc_pending_data.per_information22%TYPE
1218: ,p_per_information23 in irc_pending_data.per_information23%TYPE
1219: ,p_per_information24 in irc_pending_data.per_information24%TYPE
1220: ,p_per_information25 in irc_pending_data.per_information25%TYPE

Line 1217: ,p_per_information22 in irc_pending_data.per_information22%TYPE

1213: ,p_per_information18 in irc_pending_data.per_information18%TYPE
1214: ,p_per_information19 in irc_pending_data.per_information19%TYPE
1215: ,p_per_information20 in irc_pending_data.per_information20%TYPE
1216: ,p_per_information21 in irc_pending_data.per_information21%TYPE
1217: ,p_per_information22 in irc_pending_data.per_information22%TYPE
1218: ,p_per_information23 in irc_pending_data.per_information23%TYPE
1219: ,p_per_information24 in irc_pending_data.per_information24%TYPE
1220: ,p_per_information25 in irc_pending_data.per_information25%TYPE
1221: ,p_per_information26 in irc_pending_data.per_information26%TYPE

Line 1218: ,p_per_information23 in irc_pending_data.per_information23%TYPE

1214: ,p_per_information19 in irc_pending_data.per_information19%TYPE
1215: ,p_per_information20 in irc_pending_data.per_information20%TYPE
1216: ,p_per_information21 in irc_pending_data.per_information21%TYPE
1217: ,p_per_information22 in irc_pending_data.per_information22%TYPE
1218: ,p_per_information23 in irc_pending_data.per_information23%TYPE
1219: ,p_per_information24 in irc_pending_data.per_information24%TYPE
1220: ,p_per_information25 in irc_pending_data.per_information25%TYPE
1221: ,p_per_information26 in irc_pending_data.per_information26%TYPE
1222: ,p_per_information27 in irc_pending_data.per_information27%TYPE

Line 1219: ,p_per_information24 in irc_pending_data.per_information24%TYPE

1215: ,p_per_information20 in irc_pending_data.per_information20%TYPE
1216: ,p_per_information21 in irc_pending_data.per_information21%TYPE
1217: ,p_per_information22 in irc_pending_data.per_information22%TYPE
1218: ,p_per_information23 in irc_pending_data.per_information23%TYPE
1219: ,p_per_information24 in irc_pending_data.per_information24%TYPE
1220: ,p_per_information25 in irc_pending_data.per_information25%TYPE
1221: ,p_per_information26 in irc_pending_data.per_information26%TYPE
1222: ,p_per_information27 in irc_pending_data.per_information27%TYPE
1223: ,p_per_information28 in irc_pending_data.per_information28%TYPE

Line 1220: ,p_per_information25 in irc_pending_data.per_information25%TYPE

1216: ,p_per_information21 in irc_pending_data.per_information21%TYPE
1217: ,p_per_information22 in irc_pending_data.per_information22%TYPE
1218: ,p_per_information23 in irc_pending_data.per_information23%TYPE
1219: ,p_per_information24 in irc_pending_data.per_information24%TYPE
1220: ,p_per_information25 in irc_pending_data.per_information25%TYPE
1221: ,p_per_information26 in irc_pending_data.per_information26%TYPE
1222: ,p_per_information27 in irc_pending_data.per_information27%TYPE
1223: ,p_per_information28 in irc_pending_data.per_information28%TYPE
1224: ,p_per_information29 in irc_pending_data.per_information29%TYPE

Line 1221: ,p_per_information26 in irc_pending_data.per_information26%TYPE

1217: ,p_per_information22 in irc_pending_data.per_information22%TYPE
1218: ,p_per_information23 in irc_pending_data.per_information23%TYPE
1219: ,p_per_information24 in irc_pending_data.per_information24%TYPE
1220: ,p_per_information25 in irc_pending_data.per_information25%TYPE
1221: ,p_per_information26 in irc_pending_data.per_information26%TYPE
1222: ,p_per_information27 in irc_pending_data.per_information27%TYPE
1223: ,p_per_information28 in irc_pending_data.per_information28%TYPE
1224: ,p_per_information29 in irc_pending_data.per_information29%TYPE
1225: ,p_per_information30 in irc_pending_data.per_information30%TYPE

Line 1222: ,p_per_information27 in irc_pending_data.per_information27%TYPE

1218: ,p_per_information23 in irc_pending_data.per_information23%TYPE
1219: ,p_per_information24 in irc_pending_data.per_information24%TYPE
1220: ,p_per_information25 in irc_pending_data.per_information25%TYPE
1221: ,p_per_information26 in irc_pending_data.per_information26%TYPE
1222: ,p_per_information27 in irc_pending_data.per_information27%TYPE
1223: ,p_per_information28 in irc_pending_data.per_information28%TYPE
1224: ,p_per_information29 in irc_pending_data.per_information29%TYPE
1225: ,p_per_information30 in irc_pending_data.per_information30%TYPE
1226: ,p_creation_date in irc_pending_data.creation_date%TYPE

Line 1223: ,p_per_information28 in irc_pending_data.per_information28%TYPE

1219: ,p_per_information24 in irc_pending_data.per_information24%TYPE
1220: ,p_per_information25 in irc_pending_data.per_information25%TYPE
1221: ,p_per_information26 in irc_pending_data.per_information26%TYPE
1222: ,p_per_information27 in irc_pending_data.per_information27%TYPE
1223: ,p_per_information28 in irc_pending_data.per_information28%TYPE
1224: ,p_per_information29 in irc_pending_data.per_information29%TYPE
1225: ,p_per_information30 in irc_pending_data.per_information30%TYPE
1226: ,p_creation_date in irc_pending_data.creation_date%TYPE
1227: ,p_api_updating in boolean

Line 1224: ,p_per_information29 in irc_pending_data.per_information29%TYPE

1220: ,p_per_information25 in irc_pending_data.per_information25%TYPE
1221: ,p_per_information26 in irc_pending_data.per_information26%TYPE
1222: ,p_per_information27 in irc_pending_data.per_information27%TYPE
1223: ,p_per_information28 in irc_pending_data.per_information28%TYPE
1224: ,p_per_information29 in irc_pending_data.per_information29%TYPE
1225: ,p_per_information30 in irc_pending_data.per_information30%TYPE
1226: ,p_creation_date in irc_pending_data.creation_date%TYPE
1227: ,p_api_updating in boolean
1228: )

Line 1225: ,p_per_information30 in irc_pending_data.per_information30%TYPE

1221: ,p_per_information26 in irc_pending_data.per_information26%TYPE
1222: ,p_per_information27 in irc_pending_data.per_information27%TYPE
1223: ,p_per_information28 in irc_pending_data.per_information28%TYPE
1224: ,p_per_information29 in irc_pending_data.per_information29%TYPE
1225: ,p_per_information30 in irc_pending_data.per_information30%TYPE
1226: ,p_creation_date in irc_pending_data.creation_date%TYPE
1227: ,p_api_updating in boolean
1228: )
1229: is

Line 1226: ,p_creation_date in irc_pending_data.creation_date%TYPE

1222: ,p_per_information27 in irc_pending_data.per_information27%TYPE
1223: ,p_per_information28 in irc_pending_data.per_information28%TYPE
1224: ,p_per_information29 in irc_pending_data.per_information29%TYPE
1225: ,p_per_information30 in irc_pending_data.per_information30%TYPE
1226: ,p_creation_date in irc_pending_data.creation_date%TYPE
1227: ,p_api_updating in boolean
1228: )
1229: is
1230: --