DBA Data[Home] [Help]

APPS.IRC_IVC_BUS dependencies on IRC_VACANCY_CONSIDERATIONS

Line 189: (p_vacancy_id in irc_vacancy_considerations.vacancy_id%type

185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure chk_vacancy_id
189: (p_vacancy_id in irc_vacancy_considerations.vacancy_id%type
190: ,p_consideration_status in irc_vacancy_considerations.consideration_status%type
191: ,p_effective_date date
192: ) IS
193: --

Line 190: ,p_consideration_status in irc_vacancy_considerations.consideration_status%type

186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure chk_vacancy_id
189: (p_vacancy_id in irc_vacancy_considerations.vacancy_id%type
190: ,p_consideration_status in irc_vacancy_considerations.consideration_status%type
191: ,p_effective_date date
192: ) IS
193: --
194: l_proc varchar2(72) := g_package || 'chk_vacancy_id';

Line 250: (p_associated_column1 => 'IRC_VACANCY_CONSIDERATIONS.VACANCY_ID'

246: hr_utility.set_location(' Leaving:'||l_proc,40);
247: exception
248: when app_exception.application_exception then
249: if hr_multi_message.exception_add
250: (p_associated_column1 => 'IRC_VACANCY_CONSIDERATIONS.VACANCY_ID'
251: ) then
252: hr_utility.set_location(' Leaving:'|| l_proc, 50);
253: raise;
254: end if;

Line 285: (p_person_id in irc_vacancy_considerations.person_id%type

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure chk_person_id
285: (p_person_id in irc_vacancy_considerations.person_id%type
286: ,p_party_id in out nocopy irc_vacancy_considerations.party_id%type
287: ,p_effective_date date
288: ) IS
289: --

Line 286: ,p_party_id in out nocopy irc_vacancy_considerations.party_id%type

282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure chk_person_id
285: (p_person_id in irc_vacancy_considerations.person_id%type
286: ,p_party_id in out nocopy irc_vacancy_considerations.party_id%type
287: ,p_effective_date date
288: ) IS
289: --
290: l_proc varchar2(72) := g_package || 'chk_person_id';

Line 350: (p_associated_column1 => 'IRC_VACANCY_CONSIDERATIONS.PARTY_ID'

346: hr_utility.set_location(' Leaving:'||l_proc,70);
347: exception
348: when app_exception.application_exception then
349: if hr_multi_message.exception_add
350: (p_associated_column1 => 'IRC_VACANCY_CONSIDERATIONS.PARTY_ID'
351: ) then
352: hr_utility.set_location(' Leaving:'|| l_proc, 80);
353: raise;
354: end if;

Line 388: (p_consideration_status in irc_vacancy_considerations.

384: --
385: -- {End Of Comments}
386: -- ----------------------------------------------------------------------------
387: Procedure chk_consideration_status
388: (p_consideration_status in irc_vacancy_considerations.
389: consideration_status%type
390: ,p_vacancy_consideration_id in irc_vacancy_considerations.vacancy_consideration_id%type
391: ,p_object_version_number in irc_vacancy_considerations.
392: object_version_number%type

Line 390: ,p_vacancy_consideration_id in irc_vacancy_considerations.vacancy_consideration_id%type

386: -- ----------------------------------------------------------------------------
387: Procedure chk_consideration_status
388: (p_consideration_status in irc_vacancy_considerations.
389: consideration_status%type
390: ,p_vacancy_consideration_id in irc_vacancy_considerations.vacancy_consideration_id%type
391: ,p_object_version_number in irc_vacancy_considerations.
392: object_version_number%type
393: ,p_effective_date in date
394: ) IS

Line 391: ,p_object_version_number in irc_vacancy_considerations.

387: Procedure chk_consideration_status
388: (p_consideration_status in irc_vacancy_considerations.
389: consideration_status%type
390: ,p_vacancy_consideration_id in irc_vacancy_considerations.vacancy_consideration_id%type
391: ,p_object_version_number in irc_vacancy_considerations.
392: object_version_number%type
393: ,p_effective_date in date
394: ) IS
395: --