APPS.IRC_JBI_BUS dependencies on IRC_JOB_BASKET_ITEMS

Line 46: (p_person_id in irc_job_basket_items.person_id%type

42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure chk_person_id
46: (p_person_id in irc_job_basket_items.person_id%type
47: ,p_party_id in out nocopy irc_job_basket_items.party_id%type
48: ,p_effective_date in date
49: ) IS
50: --

Line 47: ,p_party_id in out nocopy irc_job_basket_items.party_id%type

43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure chk_person_id
46: (p_person_id in irc_job_basket_items.person_id%type
47: ,p_party_id in out nocopy irc_job_basket_items.party_id%type
48: ,p_effective_date in date
49: ) IS
50: --
51: l_proc varchar2(72) := g_package || 'chk_person_id';

Line 52: l_party_id irc_job_basket_items.party_id%type;

48: ,p_effective_date in date
49: ) IS
50: --
51: l_proc varchar2(72) := g_package || 'chk_person_id';
52: l_party_id irc_job_basket_items.party_id%type;
53: l_var varchar2(30);
54: --
55: --
56: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F.

Line 94: (p_associated_column1 => 'IRC_JOB_BASKET_ITEMS.PARTY_ID'

90: hr_utility.set_location(' Leaving:'||l_proc,70);
91: exception
92: when app_exception.application_exception then
93: if hr_multi_message.exception_add
94: (p_associated_column1 => 'IRC_JOB_BASKET_ITEMS.PARTY_ID'
95: ) then
96: hr_utility.set_location(' Leaving:'|| l_proc, 80);
97: raise;
98: end if;

Line 137: from irc_job_basket_items

133: Procedure chk_unique_item(p_job_basket_item_id in number) is
134: -- Cursor to check composite primary key is unique
135: cursor csr_unique_prim_key(p_job_basket_item_id number) is
136: select 1
137: from irc_job_basket_items
138: where
139: job_basket_item_id = p_job_basket_item_id;
140:
141: l_proc varchar2(72) := g_package||'chk_unique_item';