[Home] [Help]
26: --
27: -- Declare cursor
28: --
29: -- EDIT_HERE In the following cursor statement add join(s) between
30: -- per_position_extra_info and PER_BUSINESS_GROUPS
31: -- so that the security_group_id for
32: -- the current business group context can be derived.
33: -- Remove this comment when the edit has been completed.
34: cursor csr_sec_grp is
33: -- Remove this comment when the edit has been completed.
34: cursor csr_sec_grp is
35: select pbg.security_group_id
36: from per_business_groups pbg
37: , per_position_extra_info poi
38: , hr_all_positions_f pos
39: where poi.position_extra_info_id = p_position_extra_info_id
40: and pbg.business_group_id = pos.business_group_id
41: and pos.position_id = poi.position_id;
94: --
95: -- Declare cursor
96: --
97: -- In the following cursor statement add join(s) between
98: -- per_position_extra_info, per_positions and PER_BUSINESS_GROUPS
99: -- so that the legislation_code for
100: -- the current business group context can be derived.
101: -- Remove this comment when the edit has been completed.
102: cursor csr_leg_code is
101: -- Remove this comment when the edit has been completed.
102: cursor csr_leg_code is
103: select pbg.legislation_code
104: from per_business_groups pbg
105: , per_position_extra_info poi
106: , per_positions pos
107: where poi.position_extra_info_id = p_position_extra_info_id
108: and pos.position_id = poi.position_id
109: and pbg.business_group_id = pos.business_group_id;
276: -- {End Of Comments}
277: -- ----------------------------------------------------------------------------
278: Procedure chk_position_id
279: (
280: p_position_id in per_position_extra_info.position_id%type
281: ) is
282: --
283: l_proc varchar2(72) := g_package||'chk_position_id';
284: l_dummy varchar2(1);
351: --
352: -- {End Of Comments}
353: -- ----------------------------------------------------------------------------
354: Procedure chk_multiple_occurences_flag
355: (p_information_type in per_position_extra_info.information_type%type
356: ,p_position_id in per_position_extra_info.position_id%type
357: ) is
358: --
359: l_proc varchar2(72) := g_package||'chk_multiple_occurences_flag';
352: -- {End Of Comments}
353: -- ----------------------------------------------------------------------------
354: Procedure chk_multiple_occurences_flag
355: (p_information_type in per_position_extra_info.information_type%type
356: ,p_position_id in per_position_extra_info.position_id%type
357: ) is
358: --
359: l_proc varchar2(72) := g_package||'chk_multiple_occurences_flag';
360: l_multi_occur_flag per_position_info_types.multiple_occurences_flag%type;
367: where information_type = code;
368: --
369: cursor c_get_row (code varchar2, id number) is
370: select 'x'
371: from per_position_extra_info
372: where information_type = code
373: and position_id = id;
374: --
375: Begin
575: -- b) During insert.
576: --
577: hr_dflex_utility.ins_or_upd_descflex_attribs
578: (p_appl_short_name => 'PER'
579: ,p_descflex_name => 'PER_POSITION_EXTRA_INFO'
580: ,p_attribute_category => p_rec.poei_attribute_category
581: ,p_attribute1_name => 'POEI_ATTRIBUTE1'
582: ,p_attribute1_value => p_rec.poei_attribute1
583: ,p_attribute2_name => 'POEI_ATTRIBUTE2'
811: l_position_family varchar2(100);
812: l_chk boolean := false;
813: cursor c1 is
814: select poei_information3
815: from per_position_extra_info
816: where position_id = p_rec.position_id
817: and position_extra_info_id <> p_rec.position_extra_info_id
818: and information_type = 'PER_FAMILY'
819: and poei_information3 in ('ACADEMIC','FACULTY');
841: l_position_family varchar2(100);
842: l_chk boolean := false;
843: cursor c1 is
844: select poei_information3
845: from per_position_extra_info
846: where position_id = p_position_id
847: and information_type = 'PER_FAMILY'
848: and poei_information3 in ('ACADEMIC','FACULTY');
849: begin