24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- per_solution_types and PER_BUSINESS_GROUPS
29: -- so that the security_group_id for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is
31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is
33: select pbg.security_group_id
34: from per_business_groups pbg
35: , per_solution_types slt
36: -- , EDIT_HERE table_name(s) 333
37: where slt.solution_type_name = p_solution_type_name;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --
94: --
95: -- Declare cursor
96: --
97: -- EDIT_HERE In the following cursor statement add join(s) between
98: -- per_solution_types 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_solution_types slt
106: -- , EDIT_HERE table_name(s) 333
107: where slt.solution_type_name = p_solution_type_name;
108: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
109: --
199: -- Access Status:
200: -- Internal Table Handler Use Only.
201: --
202: procedure chk_solution_category
203: (p_solution_type_name in per_solution_types.solution_type_name%TYPE
204: ,p_solution_category in per_solution_types.solution_category%TYPE
205: ,p_effective_date in date
206: ,p_object_version_number in per_solution_types.object_version_number%TYPE
207: )
200: -- Internal Table Handler Use Only.
201: --
202: procedure chk_solution_category
203: (p_solution_type_name in per_solution_types.solution_type_name%TYPE
204: ,p_solution_category in per_solution_types.solution_category%TYPE
205: ,p_effective_date in date
206: ,p_object_version_number in per_solution_types.object_version_number%TYPE
207: )
208: is
202: procedure chk_solution_category
203: (p_solution_type_name in per_solution_types.solution_type_name%TYPE
204: ,p_solution_category in per_solution_types.solution_category%TYPE
205: ,p_effective_date in date
206: ,p_object_version_number in per_solution_types.object_version_number%TYPE
207: )
208: is
209: --
210: l_exists varchar2(1);
300: -- Access Status:
301: -- Internal Table Handler Use Only.
302: --
303: procedure chk_updateable
304: (p_solution_type_name in per_solution_types.solution_type_name%TYPE
305: ,p_updateable in per_solution_types.updateable%TYPE
306: ,p_effective_date in date
307: ,p_object_version_number in per_solution_types.object_version_number%TYPE
308: )
301: -- Internal Table Handler Use Only.
302: --
303: procedure chk_updateable
304: (p_solution_type_name in per_solution_types.solution_type_name%TYPE
305: ,p_updateable in per_solution_types.updateable%TYPE
306: ,p_effective_date in date
307: ,p_object_version_number in per_solution_types.object_version_number%TYPE
308: )
309: is
303: procedure chk_updateable
304: (p_solution_type_name in per_solution_types.solution_type_name%TYPE
305: ,p_updateable in per_solution_types.updateable%TYPE
306: ,p_effective_date in date
307: ,p_object_version_number in per_solution_types.object_version_number%TYPE
308: )
309: is
310: --
311: l_exists varchar2(1);