30:
31: cursor csr_sec_grp is
32: select pbg.security_group_id
33: from per_business_groups pbg
34: , per_competences cpn
35: , per_competences_tl cpl
36: where cpl.competence_id = p_competence_id
37: and pbg.business_group_id = cpn.business_group_id
38: and cpl.competence_id = cpn.competence_id;
31: cursor csr_sec_grp is
32: select pbg.security_group_id
33: from per_business_groups pbg
34: , per_competences cpn
35: , per_competences_tl cpl
36: where cpl.competence_id = p_competence_id
37: and pbg.business_group_id = cpn.business_group_id
38: and cpl.competence_id = cpn.competence_id;
39: --
99: --
100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups pbg
103: , per_competences_tl cpl
104: , per_competences cpn
105: where cpl.competence_id = p_competence_id
106: and cpl.language = p_language
107: and cpl.competence_id = cpn.competence_id
100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups pbg
103: , per_competences_tl cpl
104: , per_competences cpn
105: where cpl.competence_id = p_competence_id
106: and cpl.language = p_language
107: and cpl.competence_id = cpn.competence_id
108: and pbg.business_group_id = cpn.competence_id;
228: --
229: -- Description:
230: --
231: -- - Validates that it is unique within the table as per the constraint
232: -- it replaces (PER_COMPETENCES_UK3)
233: --
234: -- Pre_conditions:
235: -- None
236: --
251: --
252: --
253: --
254: procedure chk_alias
255: (p_competence_id in per_competences_tl.competence_id%TYPE
256: ,p_language in per_competences_tl.language%TYPE
257: ,p_competence_alias in per_competences_tl.competence_alias%TYPE
258: )
259: is
252: --
253: --
254: procedure chk_alias
255: (p_competence_id in per_competences_tl.competence_id%TYPE
256: ,p_language in per_competences_tl.language%TYPE
257: ,p_competence_alias in per_competences_tl.competence_alias%TYPE
258: )
259: is
260: --
253: --
254: procedure chk_alias
255: (p_competence_id in per_competences_tl.competence_id%TYPE
256: ,p_language in per_competences_tl.language%TYPE
257: ,p_competence_alias in per_competences_tl.competence_alias%TYPE
258: )
259: is
260: --
261: l_exists varchar2(1);
265: -- Cursor to check if competence_alias is unique
266: --
267: cursor csr_chk_alias is
268: select 'x'
269: from per_competences_tl pct
270: where (( p_competence_id is null)
271: or (p_competence_id <> pct.competence_id)
272: )
273: and language = p_language