27: --
28: -- Declare cursor
29: --
30: -- EDIT_HERE In the following cursor statement add join(s) between
31: -- per_solution_sets and PER_BUSINESS_GROUPS
32: -- so that the security_group_id for
33: -- the current business group context can be derived.
34: -- Remove this comment when the edit has been completed.
35: cursor csr_sec_grp is
34: -- Remove this comment when the edit has been completed.
35: cursor csr_sec_grp is
36: select pbg.security_group_id
37: from per_business_groups pbg
38: , per_solution_sets sls
39: -- , EDIT_HERE table_name(s) 333
40: where sls.solution_set_name = p_solution_set_name
41: and sls.user_id = p_user_id;
42: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
106: --
107: -- Declare cursor
108: --
109: -- EDIT_HERE In the following cursor statement add join(s) between
110: -- per_solution_sets and PER_BUSINESS_GROUPS
111: -- so that the legislation_code for
112: -- the current business group context can be derived.
113: -- Remove this comment when the edit has been completed.
114: cursor csr_leg_code is
113: -- Remove this comment when the edit has been completed.
114: cursor csr_leg_code is
115: select pbg.legislation_code
116: from per_business_groups pbg
117: , per_solution_sets sls
118: -- , EDIT_HERE table_name(s) 333
119: where sls.solution_set_name = p_solution_set_name
120: and sls.user_id = p_user_id;
121: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
276: -- Access Status:
277: -- Internal Table Handler Use Only.
278: --
279: procedure chk_status
280: (p_solution_set_name in per_solution_sets.solution_set_name%TYPE
281: ,p_user_id in per_solution_sets.user_id%TYPE
282: ,p_status in per_solution_sets.status%TYPE
283: ,p_effective_date in date
284: ,p_object_version_number in per_solution_sets.object_version_number%TYPE
277: -- Internal Table Handler Use Only.
278: --
279: procedure chk_status
280: (p_solution_set_name in per_solution_sets.solution_set_name%TYPE
281: ,p_user_id in per_solution_sets.user_id%TYPE
282: ,p_status in per_solution_sets.status%TYPE
283: ,p_effective_date in date
284: ,p_object_version_number in per_solution_sets.object_version_number%TYPE
285: )
278: --
279: procedure chk_status
280: (p_solution_set_name in per_solution_sets.solution_set_name%TYPE
281: ,p_user_id in per_solution_sets.user_id%TYPE
282: ,p_status in per_solution_sets.status%TYPE
283: ,p_effective_date in date
284: ,p_object_version_number in per_solution_sets.object_version_number%TYPE
285: )
286: is
280: (p_solution_set_name in per_solution_sets.solution_set_name%TYPE
281: ,p_user_id in per_solution_sets.user_id%TYPE
282: ,p_status in per_solution_sets.status%TYPE
283: ,p_effective_date in date
284: ,p_object_version_number in per_solution_sets.object_version_number%TYPE
285: )
286: is
287: --
288: l_exists varchar2(1);