28: --
29: -- Declare cursor
30: --
31: -- EDIT_HERE In the following cursor statement add join(s) between
32: -- per_solution_type_cmpts and PER_BUSINESS_GROUPS
33: -- so that the security_group_id for
34: -- the current business group context can be derived.
35: -- Remove this comment when the edit has been completed.
36: cursor csr_sec_grp is
35: -- Remove this comment when the edit has been completed.
36: cursor csr_sec_grp is
37: select pbg.security_group_id
38: from per_business_groups pbg
39: , per_solution_type_cmpts stc
40: -- , EDIT_HERE table_name(s) 333
41: where stc.component_name = p_component_name
42: and stc.solution_type_name = p_solution_type_name;
43: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
115: -- Declare cursor
116: --
117: cursor csr_leg_code is
118: select stc.legislation_code
119: from per_solution_type_cmpts stc
120: where stc.component_name = p_component_name
121: and stc.solution_type_name = p_solution_type_name;
122: --
123: -- Declare local variables
274: -- Access Status:
275: -- Internal Table Handler Use Only.
276: --
277: procedure chk_updateable
278: (p_component_name in per_solution_type_cmpts.component_name%TYPE
279: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
280: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
281: ,p_updateable in per_solution_type_cmpts.updateable%TYPE
282: ,p_effective_date in date
275: -- Internal Table Handler Use Only.
276: --
277: procedure chk_updateable
278: (p_component_name in per_solution_type_cmpts.component_name%TYPE
279: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
280: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
281: ,p_updateable in per_solution_type_cmpts.updateable%TYPE
282: ,p_effective_date in date
283: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
276: --
277: procedure chk_updateable
278: (p_component_name in per_solution_type_cmpts.component_name%TYPE
279: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
280: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
281: ,p_updateable in per_solution_type_cmpts.updateable%TYPE
282: ,p_effective_date in date
283: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
284: )
277: procedure chk_updateable
278: (p_component_name in per_solution_type_cmpts.component_name%TYPE
279: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
280: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
281: ,p_updateable in per_solution_type_cmpts.updateable%TYPE
282: ,p_effective_date in date
283: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
284: )
285: is
279: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
280: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
281: ,p_updateable in per_solution_type_cmpts.updateable%TYPE
282: ,p_effective_date in date
283: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
284: )
285: is
286: --
287: l_exists varchar2(1);
386: -- Access Status:
387: -- Internal Table Handler Use Only.
388: --
389: procedure chk_extensible
390: (p_component_name in per_solution_type_cmpts.component_name%TYPE
391: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
392: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
393: ,p_extensible in per_solution_type_cmpts.extensible%TYPE
394: ,p_effective_date in date
387: -- Internal Table Handler Use Only.
388: --
389: procedure chk_extensible
390: (p_component_name in per_solution_type_cmpts.component_name%TYPE
391: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
392: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
393: ,p_extensible in per_solution_type_cmpts.extensible%TYPE
394: ,p_effective_date in date
395: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
388: --
389: procedure chk_extensible
390: (p_component_name in per_solution_type_cmpts.component_name%TYPE
391: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
392: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
393: ,p_extensible in per_solution_type_cmpts.extensible%TYPE
394: ,p_effective_date in date
395: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
396: )
389: procedure chk_extensible
390: (p_component_name in per_solution_type_cmpts.component_name%TYPE
391: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
392: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
393: ,p_extensible in per_solution_type_cmpts.extensible%TYPE
394: ,p_effective_date in date
395: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
396: )
397: is
391: ,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
392: ,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
393: ,p_extensible in per_solution_type_cmpts.extensible%TYPE
394: ,p_effective_date in date
395: ,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
396: )
397: is
398: --
399: l_exists varchar2(1);