APPS.HXC_HAS_BUS dependencies on HXC_APPROVAL_STYLES

Line 28: -- hxc_approval_styles and PER_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- hxc_approval_styles 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

Line 35: , hxc_approval_styles has

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_styles has
36: -- , EDIT_HERE table_name(s) 333
37: where has.approval_style_id = p_approval_style_id;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --

Line 100: -- hxc_approval_styles and PER_BUSINESS_GROUPS

96: --
97: -- Declare cursor
98: --
99: -- EDIT_HERE In the following cursor statement add join(s) between
100: -- hxc_approval_styles 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

Line 107: , hxc_approval_styles has

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_styles has
108: -- , EDIT_HERE table_name(s) 333
109: where has.approval_style_id = p_approval_style_id;
110: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
111: --

Line 265: p_name in hxc_approval_styles.name%TYPE,

261: -- {End Of Comments}
262: -- ----------------------------------------------------------------------------
263: Procedure chk_name
264: (
265: p_name in hxc_approval_styles.name%TYPE,
266: p_object_version_number in hxc_approval_styles.object_version_number%TYPE
267: ) IS
268: --
269: l_proc varchar2(72);

Line 266: p_object_version_number in hxc_approval_styles.object_version_number%TYPE

262: -- ----------------------------------------------------------------------------
263: Procedure chk_name
264: (
265: p_name in hxc_approval_styles.name%TYPE,
266: p_object_version_number in hxc_approval_styles.object_version_number%TYPE
267: ) IS
268: --
269: l_proc varchar2(72);
270: --

Line 280: FROM hxc_approval_styles has

276: SELECT 'error'
277: FROM sys.dual
278: WHERE EXISTS (
279: SELECT 'x'
280: FROM hxc_approval_styles has
281: WHERE has.name = p_name
282: AND has.object_version_number <>
283: decode(created_by,
284: 2, (NVL(decode(p_object_version_number, 1, null, p_object_version_number),-1)),

Line 354: p_approval_style_id in hxc_approval_styles.approval_style_id%TYPE

350: -- {End Of Comments}
351: -- ----------------------------------------------------------------------------
352: Procedure chk_delete
353: (
354: p_approval_style_id in hxc_approval_styles.approval_style_id%TYPE
355: ) IS
356: --
357: l_proc varchar2(72);
358: --

Line 532: p_run_recipient_extensions in hxc_approval_styles.run_recipient_extensions%TYPE

528: -- Internal Row Handler Use Only.
529: --
530: Procedure chk_run_recipient_extensions
531: (
532: p_run_recipient_extensions in hxc_approval_styles.run_recipient_extensions%TYPE
533: ) IS
534: Begin
535: IF not(p_run_recipient_extensions IS NULL OR p_run_recipient_extensions IN ('Y','N'))
536: THEN

Line 568: p_admin_role in hxc_approval_styles.admin_role%TYPE

564: -- Internal Row Handler Use Only.
565: --
566: Procedure chk_admin_role
567: (
568: p_admin_role in hxc_approval_styles.admin_role%TYPE
569: ) IS
570: l_admin_role varchar2(1):=null;
571: cursor crs_admin_role is select 'Y' from wf_local_roles where name=p_admin_role;
572: begin

Line 609: p_error_admin_role in hxc_approval_styles.error_admin_role%TYPE

605: -- Internal Row Handler Use Only.
606: --
607: Procedure chk_error_admin_role
608: (
609: p_error_admin_role in hxc_approval_styles.error_admin_role%TYPE
610: ) IS
611: l_error_admin_role varchar2(1):=null;
612: cursor crs_error_admin_role is select 'Y' from wf_local_roles where name=p_error_admin_role;
613: begin