APPS.IRC_ITA_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 335: -- - Validates that a organization id exists in table hr_all_organization_units.

331: -- |---------------------------< chk_organization_id >--------------------------|
332: -- ---------------------------------------------------------------------------
333: --
334: -- Description:
335: -- - Validates that a organization id exists in table hr_all_organization_units.
336: --
337: -- Pre-conditions:
338: -- None.
339: --

Line 344: -- If a row does exist in hr_all_organization_units for the given organization id then

340: -- In Arguments:
341: -- p_organization_id
342: --
343: -- Post Success:
344: -- If a row does exist in hr_all_organization_units for the given organization id then
345: -- processing continues.
346: --
347: -- Post Failure:
348: -- If a row does not exist in hr_all_organization_units for the given organization id then

Line 348: -- If a row does not exist in hr_all_organization_units for the given organization id then

344: -- If a row does exist in hr_all_organization_units for the given organization id then
345: -- processing continues.
346: --
347: -- Post Failure:
348: -- If a row does not exist in hr_all_organization_units for the given organization id then
349: -- an application error will be raised and processing is terminated.
350: --
351: -- Access Status:
352: -- Internal Table Handler Use Only.

Line 365: from hr_all_organization_units haou

361: l_proc varchar2(72) := g_package||'chk_organization_id';
362: l_org varchar2(1);
363: cursor csr_org is
364: select null
365: from hr_all_organization_units haou
366: where haou.organization_id = p_organization_id;
367: --
368: --
369: begin