27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: where pbg.business_group_id = hr_general.get_business_group_id;
32: --
33: -- Declare local variables
34: --
35: l_security_group_id number;
95: --
96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups_perf pbg
99: where pbg.business_group_id = hr_general.get_business_group_id;
100: --
101: -- Declare local variables
102: --
103: l_legislation_code varchar2(150);
739: -- Call all supporting business operations
740: --
741:
742: hr_api.validate_bus_grp_id
743: (p_business_group_id => nvl(hr_general.get_business_group_id,0) );
744:
745: chk_unique_insert(p_rec.gross_index);
746:
747: hr_multi_message.end_validation_set;
815: -- Call all supporting business operations
816: --
817:
818: hr_api.validate_bus_grp_id
819: (p_business_group_id => nvl(hr_general.get_business_group_id,0) );
820:
821: chk_unique_update(p_rec.gross_index,p_rec.increased_index,p_rec.global_index_id);
822:
823: hr_multi_message.end_validation_set;