319: -- |---------------------------< chk_organization_id >--------------------------|
320: -- ---------------------------------------------------------------------------
321: --
322: -- Description:
323: -- - Validates that a organization id exists in table hr_all_organization_units.
324: --
325: -- Pre-conditions:
326: -- None.
327: --
328: -- In Arguments:
329: -- p_organization_id
330: --
331: -- Post Success:
332: -- If a row does exist in hr_all_organization_units for the given organization id then
333: -- processing continues.
334: --
335: -- Post Failure:
336: -- If a row does not exist in hr_all_organization_units for the given organization id then
332: -- If a row does exist in hr_all_organization_units for the given organization id then
333: -- processing continues.
334: --
335: -- Post Failure:
336: -- If a row does not exist in hr_all_organization_units for the given organization id then
337: -- an application error will be raised and processing is terminated.
338: --
339: -- Access Status:
340: -- Internal Table Handler Use Only.
349: l_proc varchar2(72) := g_package||'chk_organization_id';
350: l_org varchar2(1);
351: cursor csr_org is
352: select null
353: from hr_all_organization_units haou
354: where haou.organization_id = p_organization_id;
355: --
356: --
357: begin