APPS.PQH_RCT_BUS dependencies on PQH_ROLES

Line 848: l_enable_flag pqh_roles.enable_flag%type;

844: Procedure chk_override_role_id (p_routing_category_id in number,
845: p_override_role_id in number,
846: p_object_version_number in number) is
847: --
848: l_enable_flag pqh_roles.enable_flag%type;
849: --
850: l_proc varchar2(72) := g_package||'chk_override_role_id';
851: l_api_updating boolean;
852: --

Line 855: from pqh_roles a

851: l_api_updating boolean;
852: --
853: cursor c1 is
854: select nvl(enable_flag,'N')
855: from pqh_roles a
856: where a.role_id = p_override_role_id;
857: --
858: Begin
859: --

Line 873: -- pqh_roles table

869: or not l_api_updating) and
870: p_override_role_id is not null then
871: --
872: -- check if override_role_id value exists in
873: -- pqh_roles table
874: --
875: open c1;
876: --
877: fetch c1 into l_enable_flag;

Line 969: -- pqh_roles table

965: or not l_api_updating) and
966: p_override_user_id is not null then
967: --
968: -- check if override_user_id value exists in
969: -- pqh_roles table
970: --
971: open c1;
972: --
973: fetch c1 into l_dummy;