APPS.HXC_RTR_BUS dependencies on HXC_RETRIEVAL_RULES

Line 29: -- hxc_retrieval_rules and PER_BUSINESS_GROUPS

25: --
26: -- Declare cursor
27: --
28: -- EDIT_HERE In the following cursor statement add join(s) between
29: -- hxc_retrieval_rules and PER_BUSINESS_GROUPS
30: -- so that the security_group_id for
31: -- the current business group context can be derived.
32: -- Remove this comment when the edit has been completed.
33: cursor csr_sec_grp is

Line 36: , hxc_retrieval_rules rtr

32: -- Remove this comment when the edit has been completed.
33: cursor csr_sec_grp is
34: select pbg.security_group_id
35: from per_business_groups pbg
36: , hxc_retrieval_rules rtr
37: -- , EDIT_HERE table_name(s) 333
38: where rtr.retrieval_rule_id = p_retrieval_rule_id;
39: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
40: --

Line 102: -- hxc_retrieval_rules and PER_BUSINESS_GROUPS

98: --
99: -- Declare cursor
100: --
101: -- EDIT_HERE In the following cursor statement add join(s) between
102: -- hxc_retrieval_rules and PER_BUSINESS_GROUPS
103: -- so that the legislation_code for
104: -- the current business group context can be derived.
105: -- Remove this comment when the edit has been completed.
106: cursor csr_leg_code is

Line 109: , hxc_retrieval_rules rtr

105: -- Remove this comment when the edit has been completed.
106: cursor csr_leg_code is
107: select pbg.legislation_code
108: from per_business_groups pbg
109: , hxc_retrieval_rules rtr
110: -- , EDIT_HERE table_name(s) 333
111: where rtr.retrieval_rule_id = p_retrieval_rule_id;
112: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
113: --

Line 269: p_name in hxc_retrieval_rules.name%TYPE,

265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Procedure chk_name
268: (
269: p_name in hxc_retrieval_rules.name%TYPE,
270: p_object_version_number in hxc_retrieval_rules.object_version_number%TYPE
271: ) IS
272: --
273: l_proc varchar2(72);

Line 270: p_object_version_number in hxc_retrieval_rules.object_version_number%TYPE

266: -- ----------------------------------------------------------------------------
267: Procedure chk_name
268: (
269: p_name in hxc_retrieval_rules.name%TYPE,
270: p_object_version_number in hxc_retrieval_rules.object_version_number%TYPE
271: ) IS
272: --
273: l_proc varchar2(72);
274: --

Line 282: FROM hxc_retrieval_rules rtr

278: SELECT 'error'
279: FROM sys.dual
280: WHERE EXISTS (
281: SELECT 'x'
282: FROM hxc_retrieval_rules rtr
283: WHERE rtr.name = p_name
284: AND rtr.object_version_number <> NVL(p_object_version_number, -1) );
285: --
286: l_error varchar2(5) := NULL;