DBA Data[Home] [Help]

APPS.IRC_IRF_BUS dependencies on IRC_REFERRAL_INFO

Line 513: (p_source_criteria in irc_referral_info.source_criteria1%TYPE

509: -- ----------------------------------------------------------------------------
510: -- |---------------------------< chk_source_criteria >-----------------------|
511: -- ----------------------------------------------------------------------------
512: Procedure chk_source_criteria
513: (p_source_criteria in irc_referral_info.source_criteria1%TYPE
514: ,p_source_criteria_index in number
515: ,p_effective_date in date
516: ) is
517: --

Line 545: (p_source_type in irc_referral_info.source_type%TYPE

541: -- ----------------------------------------------------------------------------
542: -- |---------------------------< chk_source_type >-----------------------|
543: -- ----------------------------------------------------------------------------
544: Procedure chk_source_type
545: (p_source_type in irc_referral_info.source_type%TYPE
546: ,p_effective_date in date
547: ) is
548: --
549: l_proc varchar2(72) := g_package||'chk_source_type';

Line 652: (p_person_id in irc_referral_info.object_id%TYPE

648: --
649: -- {End Of Comments}
650: -- ----------------------------------------------------------------------------
651: Procedure chk_person_id
652: (p_person_id in irc_referral_info.object_id%TYPE
653: ,p_effective_date in Date
654: ) IS
655: --
656: l_proc varchar2(72) := g_package || 'chk_person_id';

Line 683: 'IRC_REFERRAL_INFO.OBJECT_ID'

679: exception
680: when app_exception.application_exception then
681: if hr_multi_message.exception_add
682: (p_associated_column1 =>
683: 'IRC_REFERRAL_INFO.OBJECT_ID'
684: ) then
685: hr_utility.set_location(' Leaving:'||l_proc,40);
686: raise;
687: end if;

Line 714: (p_party_id in irc_referral_info.object_id%TYPE

710: --
711: -- {End Of Comments}
712: -- ----------------------------------------------------------------------------
713: Procedure chk_party_id
714: (p_party_id in irc_referral_info.object_id%TYPE
715: ,p_effective_date in Date
716: ) IS
717: --
718: l_proc varchar2(72) := g_package || 'chk_party_id';

Line 745: 'IRC_REFERRAL_INFO.OBJECT_ID'

741: exception
742: when app_exception.application_exception then
743: if hr_multi_message.exception_add
744: (p_associated_column1 =>
745: 'IRC_REFERRAL_INFO.OBJECT_ID'
746: ) then
747: hr_utility.set_location(' Leaving:'||l_proc,40);
748: raise;
749: end if;

Line 777: (p_assignment_id in irc_referral_info.object_id%type

773: --
774: -- {End Of Comments}
775: -- ----------------------------------------------------------------------------
776: Procedure chk_assignment_id
777: (p_assignment_id in irc_referral_info.object_id%type
778: ,p_effective_date in Date
779: ) is
780: --
781: l_proc varchar2(72) := g_package || 'chk_assignment_id';

Line 783: l_assignment_id irc_referral_info.object_id%type ;

779: ) is
780: --
781: l_proc varchar2(72) := g_package || 'chk_assignment_id';
782: --
783: l_assignment_id irc_referral_info.object_id%type ;
784: --
785: cursor csr_applicant_assignment is
786: select 1
787: from per_all_assignments_f