[Home] [Help]
24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- hxc_recurring_periods 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_recurring_periods hrp
36: -- , EDIT_HERE table_name(s) 333
37: where hrp.recurring_period_id = p_recurring_period_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_recurring_periods 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_recurring_periods hrp
108: -- , EDIT_HERE table_name(s) 333
109: where hrp.recurring_period_id = p_recurring_period_id;
110: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
111: --
262: -- {End Of Comments}
263: -- ----------------------------------------------------------------------------
264: Procedure chk_name
265: (
266: p_name in hxc_recurring_periods.name%TYPE,
267: p_object_version_number in hxc_recurring_periods.object_version_number%TYPE
268: ) IS
269: --
270: l_proc varchar2(72);
263: -- ----------------------------------------------------------------------------
264: Procedure chk_name
265: (
266: p_name in hxc_recurring_periods.name%TYPE,
267: p_object_version_number in hxc_recurring_periods.object_version_number%TYPE
268: ) IS
269: --
270: l_proc varchar2(72);
271: --
275: SELECT 'error'
276: FROM sys.dual
277: WHERE EXISTS (
278: SELECT 'x'
279: FROM hxc_recurring_periods hrp
280: WHERE hrp.name = p_name
281: AND hrp.object_version_number <> NVL(p_object_version_number, -1) );
282: --
283: l_error varchar2(5) := NULL;
349: -- {End Of Comments}
350: -- ----------------------------------------------------------------------------
351: Procedure chk_period_type
352: (
353: p_period_type in hxc_recurring_periods.period_type%TYPE
354: ) IS
355: --
356: -- Validation cursor, Bi Months are not currently supported
357: -- by the self service OTC code. Remove the extra check when
357: -- by the self service OTC code. Remove the extra check when
358: -- they are.
359: --
360: cursor c_period_type(
361: p_period_type in HXC_RECURRING_PERIODS.PERIOD_TYPE%TYPE
362: ) is
363: select 'Y'
364: from PER_TIME_PERIOD_TYPES ptpt
365: where ptpt.period_type = p_period_type
437: -- {End Of Comments}
438: -- ----------------------------------------------------------------------------
439: Procedure chk_type_duration
440: (
441: p_period_type in hxc_recurring_periods.period_type%TYPE,
442: p_duration_in_days in hxc_recurring_periods.duration_in_days%TYPE
443: ) IS
444: --
445: l_proc varchar2(72);
438: -- ----------------------------------------------------------------------------
439: Procedure chk_type_duration
440: (
441: p_period_type in hxc_recurring_periods.period_type%TYPE,
442: p_duration_in_days in hxc_recurring_periods.duration_in_days%TYPE
443: ) IS
444: --
445: l_proc varchar2(72);
446: l_error varchar2(5) := NULL;
491: -- {End Of Comments}
492: -- ----------------------------------------------------------------------------
493: Procedure chk_delete
494: (
495: p_recurring_period_id in hxc_recurring_periods.recurring_period_id%TYPE
496: ) IS
497: --
498: l_proc varchar2(72);
499: --