24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- hxc_approval_period_sets 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: , hxc_approval_period_sets aps
36: -- , EDIT_HERE table_name(s) 333
37: where aps.approval_period_set_id = p_approval_period_set_id;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --
96: --
97: -- Declare cursor
98: --
99: -- EDIT_HERE In the following cursor statement add join(s) between
100: -- hxc_approval_period_sets and PER_BUSINESS_GROUPS
101: -- so that the legislation_code for
102: -- the current business group context can be derived.
103: -- Remove this comment when the edit has been completed.
104: cursor csr_leg_code is
103: -- Remove this comment when the edit has been completed.
104: cursor csr_leg_code is
105: select pbg.legislation_code
106: from per_business_groups pbg
107: , hxc_approval_period_sets aps
108: -- , EDIT_HERE table_name(s) 333
109: where aps.approval_period_set_id = p_approval_period_set_id;
110: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
111: --
261: -- {End Of Comments}
262: -- ----------------------------------------------------------------------------
263: Procedure chk_name
264: (
265: p_name in hxc_approval_period_sets.name%TYPE,
266: p_object_version_number in hxc_approval_period_sets.object_version_number%TYPE
267: ) IS
268: --
269: l_proc varchar2(72);
262: -- ----------------------------------------------------------------------------
263: Procedure chk_name
264: (
265: p_name in hxc_approval_period_sets.name%TYPE,
266: p_object_version_number in hxc_approval_period_sets.object_version_number%TYPE
267: ) IS
268: --
269: l_proc varchar2(72);
270: --
274: SELECT 'error'
275: FROM sys.dual
276: WHERE EXISTS (
277: SELECT 'x'
278: FROM hxc_approval_period_sets aps
279: WHERE aps.name = p_name
280: AND aps.object_version_number <> NVL(p_object_version_number, -1) );
281: --
282: l_error varchar2(5) := NULL;
343: -- {End Of Comments}
344: -- ----------------------------------------------------------------------------
345: Procedure chk_delete
346: (
347: p_approval_period_set_id in hxc_approval_period_sets.approval_period_set_id%TYPE
348: ) IS
349: --
350: l_proc varchar2(72);
351: --