DBA Data[Home] [Help]

APPS.HXC_HAS_BUS dependencies on WF_LOCAL_ROLES

Line 548: -- Validate the admin_role is either null or present in WF_LOCAL_ROLES table.

544: -- -------------------------------------------------------------------------
545: --
546: --
547: -- Description:
548: -- Validate the admin_role is either null or present in WF_LOCAL_ROLES table.
549: --
550: -- Pre-Requisites:
551: -- None
552: --

Line 571: cursor crs_admin_role is select 'Y' from wf_local_roles where name=p_admin_role;

567: (
568: p_admin_role in hxc_approval_styles.admin_role%TYPE
569: ) IS
570: l_admin_role varchar2(1):=null;
571: cursor crs_admin_role is select 'Y' from wf_local_roles where name=p_admin_role;
572: begin
573: open crs_admin_role;
574: fetch crs_admin_role into l_admin_role;
575: IF NOT(p_admin_role IS NULL OR crs_admin_role%found)

Line 589: -- Validate the error_admin_role is either null or present in WF_LOCAL_ROLES table.

585: -- -------------------------------------------------------------------------
586: --
587: --
588: -- Description:
589: -- Validate the error_admin_role is either null or present in WF_LOCAL_ROLES table.
590: --
591: -- Pre-Requisites:
592: -- None
593: --

Line 612: cursor crs_error_admin_role is select 'Y' from wf_local_roles where name=p_error_admin_role;

608: (
609: p_error_admin_role in hxc_approval_styles.error_admin_role%TYPE
610: ) IS
611: l_error_admin_role varchar2(1):=null;
612: cursor crs_error_admin_role is select 'Y' from wf_local_roles where name=p_error_admin_role;
613: begin
614: open crs_error_admin_role;
615: fetch crs_error_admin_role into l_error_admin_role;
616: IF NOT(p_error_admin_role IS NULL OR crs_error_admin_role%found)