APPS.PER_ROL_BUS dependencies on PER_ROLES

Line 29: , per_roles rol

25: --
26: cursor csr_sec_grp is
27: select null
28: from hr_organization_information hoi
29: , per_roles rol
30: , per_people_f per
31: where rol.role_id = p_role_id
32: and per.person_id = rol.person_id
33: and hoi.organization_id = per.business_group_id

Line 92: , per_roles rol

88: --
89: cursor csr_leg_code is
90: select pbg.legislation_code
91: from per_business_groups pbg
92: , per_roles rol
93: , per_people_f per
94: where rol.role_id = p_role_id
95: and rol.person_id = per.person_id
96: and per.business_group_id = pbg.business_group_id;

Line 185: (p_role_id in per_roles.person_id%TYPE

181: -- {End of Comments}
182: --
183: -- ---------------------------------------------------------------------------
184: procedure chk_person_id
185: (p_role_id in per_roles.person_id%TYPE
186: ,p_person_id in per_roles.person_id%TYPE
187: ,p_effective_date in date
188: ) is
189: --

Line 186: ,p_person_id in per_roles.person_id%TYPE

182: --
183: -- ---------------------------------------------------------------------------
184: procedure chk_person_id
185: (p_role_id in per_roles.person_id%TYPE
186: ,p_person_id in per_roles.person_id%TYPE
187: ,p_effective_date in date
188: ) is
189: --
190: l_proc varchar2(72) := g_package||'chk_person_id';

Line 743: ,p_descflex_name => 'PER_ROLES'

739: -- b) During insert.
740: --
741: hr_dflex_utility.ins_or_upd_descflex_attribs
742: (p_appl_short_name => 'PER'
743: ,p_descflex_name => 'PER_ROLES'
744: ,p_attribute_category => p_rec.ATTRIBUTE_CATEGORY
745: ,p_attribute1_name => 'ATTRIBUTE1'
746: ,p_attribute1_value => p_rec.attribute1
747: ,p_attribute2_name => 'ATTRIBUTE2'

Line 976: (p_person_id in per_roles.person_id%Type

972: -- ----------------------------------------------------------------------------
973: -- |---------------------------< chk_dup_roles >-------------------------------|
974: -- ----------------------------------------------------------------------------
975: function chk_dup_roles
976: (p_person_id in per_roles.person_id%Type
977: ,p_job_group_id in per_roles.job_group_id%Type
978: ,p_job_id in per_roles.job_id%Type
979: ) return boolean is
980: --

Line 977: ,p_job_group_id in per_roles.job_group_id%Type

973: -- |---------------------------< chk_dup_roles >-------------------------------|
974: -- ----------------------------------------------------------------------------
975: function chk_dup_roles
976: (p_person_id in per_roles.person_id%Type
977: ,p_job_group_id in per_roles.job_group_id%Type
978: ,p_job_id in per_roles.job_id%Type
979: ) return boolean is
980: --
981: --

Line 978: ,p_job_id in per_roles.job_id%Type

974: -- ----------------------------------------------------------------------------
975: function chk_dup_roles
976: (p_person_id in per_roles.person_id%Type
977: ,p_job_group_id in per_roles.job_group_id%Type
978: ,p_job_id in per_roles.job_id%Type
979: ) return boolean is
980: --
981: --
982: cursor csr_dup_roles is

Line 984: from per_roles

980: --
981: --
982: cursor csr_dup_roles is
983: select 'X'
984: from per_roles
985: where person_id = p_person_id
986: and job_group_id = p_job_group_id
987: and job_id = p_job_id;
988: --