APPS.HXC_LKR_BUS dependencies on HXC_LOCKING_RULES

Line 31: -- hxc_locking_rules and PER_BUSINESS_GROUPS_PERF

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

Line 38: , hxc_locking_rules lkr

34: -- Remove this comment when the edit has been completed.
35: cursor csr_sec_grp is
36: select pbg.security_group_id
37: from per_business_groups_perf pbg
38: , hxc_locking_rules lkr
39: -- , EDIT_HERE table_name(s) 333
40: where lkr.locker_type_owner_id = p_locker_type_owner_id
41: and lkr.locker_type_requestor_id = p_locker_type_requestor_id;
42: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 116: -- hxc_locking_rules and PER_BUSINESS_GROUPS_PERF

112: --
113: -- Declare cursor
114: --
115: -- EDIT_HERE In the following cursor statement add join(s) between
116: -- hxc_locking_rules and PER_BUSINESS_GROUPS_PERF
117: -- so that the legislation_code for
118: -- the current business group context can be derived.
119: -- Remove this comment when the edit has been completed.
120: cursor csr_leg_code is

Line 123: , hxc_locking_rules lkr

119: -- Remove this comment when the edit has been completed.
120: cursor csr_leg_code is
121: select pbg.legislation_code
122: from per_business_groups_perf pbg
123: , hxc_locking_rules lkr
124: -- , EDIT_HERE table_name(s) 333
125: where lkr.locker_type_owner_id = p_locker_type_owner_id
126: and lkr.locker_type_requestor_id = p_locker_type_requestor_id;
127: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 281: p_owner_id in hxc_locking_rules.locker_type_owner_id%TYPE

277: -- {End Of Comments}
278: -- ----------------------------------------------------------------------------
279: Procedure chk_owner_requestor_id
280: (
281: p_owner_id in hxc_locking_rules.locker_type_owner_id%TYPE
282: ,p_requestor_id in hxc_locking_rules.locker_type_requestor_id%TYPE
283: ) IS
284: --
285: l_proc varchar2(72);

Line 282: ,p_requestor_id in hxc_locking_rules.locker_type_requestor_id%TYPE

278: -- ----------------------------------------------------------------------------
279: Procedure chk_owner_requestor_id
280: (
281: p_owner_id in hxc_locking_rules.locker_type_owner_id%TYPE
282: ,p_requestor_id in hxc_locking_rules.locker_type_requestor_id%TYPE
283: ) IS
284: --
285: l_proc varchar2(72);
286: --

Line 291: FROM hxc_locking_rules

287: -- cursor to check if the owner ID and requestor ID are not existing
288: --
289: CURSOR csr_chk_id IS
290: SELECT 'error'
291: FROM hxc_locking_rules
292: WHERE locker_type_owner_id = p_owner_id
293: AND locker_type_requestor_id = p_requestor_id;
294:
295: