[Home] [Help]
520: -- |---------------------------< chk_role_id >----------------------------|
521: -- ---------------------------------------------------------------------------
522: --
523: -- Description:
524: -- - Validates that a role id exists in table PER_ROLES
525: --
526: -- Pre-conditions:
527: -- None.
528: --
529: -- In Arguments:
530: -- p_role_id
531: --
532: -- Post Success:
533: -- If a row does exist in PER_ROLES for the given role id then
534: -- processing continues.
535: --
536: -- Post Failure:
537: -- If a row does not exist in PER_ROLES for the given role id then
533: -- If a row does exist in PER_ROLES for the given role id then
534: -- processing continues.
535: --
536: -- Post Failure:
537: -- If a row does not exist in PER_ROLES for the given role id then
538: -- an application error will be raised and processing is terminated.
539: --
540: -- Access Status:
541: -- Internal Table Handler Use Only.
552: l_role_id number;
553: --
554: cursor csr_valid_rid is
555: select role_id
556: from per_roles
557: where role_id = p_role_id;
558: --
559: begin
560: hr_utility.set_location('Entering:'|| l_proc, 10);
568: );
569: hr_utility.set_location(l_proc, 20);
570: --
571: --
572: -- Check that the Role ID is exists in PER_ROLES
573: --
574: open csr_valid_rid;
575: fetch csr_valid_rid into l_role_id;
576: if csr_valid_rid%notfound then