APPS.PQH_RLS_BUS dependencies on PQH_ROLES

Line 29: from pqh_roles

25: is
26: dummy varchar2(1) := 'N';
27: cursor c1 is
28: select 'Y'
29: from pqh_roles
30: where role_type_cd = decode(p_role_type_cd,'PQH_EXCL','PQH_INCL','PQH_EXCL')
31: and enable_flag = 'Y'
32: and business_group_id = p_business_group_id;
33: --

Line 36: from pqh_roles

32: and business_group_id = p_business_group_id;
33: --
34: cursor c2 is
35: select 'Y'
36: from pqh_roles
37: where role_type_cd = decode(p_role_type_cd,'PQH_EXCL','PQH_INCL','PQH_EXCL')
38: and enable_flag = 'Y'
39: and business_group_id is null;
40: --

Line 42: -- message('Fired'||:PQH_ROLES.role_type_cd||' BG: '||:PQH_ROLES.business_group_id);pause;

38: and enable_flag = 'Y'
39: and business_group_id is null;
40: --
41: begin
42: -- message('Fired'||:PQH_ROLES.role_type_cd||' BG: '||:PQH_ROLES.business_group_id);pause;
43:
44: if p_role_type_cd in ('PQH_EXCL','PQH_INCL') and
45: p_enable_flag = 'Y' then
46: if NVL(p_business_group_id,-1) = -1 then

Line 79: ,pqh_roles rls

75: --
76: cursor csr_sec_grp is
77: select pbg.security_group_id
78: from per_business_groups pbg
79: ,pqh_roles rls
80: where
81: rls.role_id = p_role_id
82: and pbg.business_group_id = rls.business_group_id;
83: --

Line 140: ,pqh_roles rls

136: --
137: cursor csr_leg_code is
138: select pbg.legislation_code
139: from per_business_groups pbg
140: ,pqh_roles rls
141: where
142: rls.role_id = p_role_id
143: and pbg.business_group_id = rls.business_group_id;
144: --

Line 312: pqh_rls_shd.constraint_error('PQH_ROLES_PK');

308: <> pqh_rls_shd.g_old_rec.role_id) then
309: --
310: -- raise error as PK has changed
311: --
312: pqh_rls_shd.constraint_error('PQH_ROLES_PK');
313: --
314: elsif not l_api_updating then
315: --
316: -- check if PK is null

Line 322: pqh_rls_shd.constraint_error('PQH_ROLES_PK');

318: if p_role_id is not null then
319: --
320: -- raise error as PK is not null
321: --
322: pqh_rls_shd.constraint_error('PQH_ROLES_PK');
323: --
324: end if;
325: --
326: end if;

Line 374: FROM pqh_roles

370: WHERE role_id = p_role_id;
371:
372: CURSOR csr_role_name IS
373: SELECT role_name
374: FROM pqh_roles
375: WHERE role_id = p_role_id;
376:
377: l_posn_count NUMBER(15) := 0;
378: l_role_name pqh_roles.role_name%TYPE;

Line 378: l_role_name pqh_roles.role_name%TYPE;

374: FROM pqh_roles
375: WHERE role_id = p_role_id;
376:
377: l_posn_count NUMBER(15) := 0;
378: l_role_name pqh_roles.role_name%TYPE;
379: Begin
380: --
381: hr_utility.set_location('Entering:'||l_proc,5);
382: --

Line 582: from pqh_roles

578: l_dummy varchar2(1);
579:
580: cursor csr_role_name is
581: select 'X'
582: from pqh_roles
583: where role_name = p_role_name
584: and role_id <> nvl(p_role_id,0);
585:
586: Begin