APPS.HXC_LCK_BUS dependencies on HXC_LOCKER_TYPES

Line 29: -- hxc_locker_types and PER_BUSINESS_GROUPS_PERF

25: --
26: -- Declare cursor
27: --
28: -- EDIT_HERE In the following cursor statement add join(s) between
29: -- hxc_locker_types and PER_BUSINESS_GROUPS_PERF
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_locker_types lck

32: -- Remove this comment when the edit has been completed.
33: cursor csr_sec_grp is
34: select distinct pbg.security_group_id
35: from per_business_groups_perf pbg
36: , hxc_locker_types lck
37: -- , EDIT_HERE table_name(s) 333
38: where lck.locker_type_id = p_locker_type_id;
39: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
40: --

Line 104: -- hxc_locker_types and PER_BUSINESS_GROUPS_PERF

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

Line 111: , hxc_locker_types lck

107: -- Remove this comment when the edit has been completed.
108: cursor csr_leg_code is
109: select pbg.legislation_code
110: from per_business_groups_perf pbg
111: , hxc_locker_types lck
112: -- , EDIT_HERE table_name(s) 333
113: where lck.locker_type_id = p_locker_type_id;
114: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
115: --

Line 260: p_locker_type in hxc_locker_types.locker_type%TYPE

256: -- {End Of Comments}
257: -- ----------------------------------------------------------------------------
258: Procedure chk_locker_process_type
259: (
260: p_locker_type in hxc_locker_types.locker_type%TYPE
261: ,p_process_type in hxc_locker_types.process_type%TYPE
262: ,p_locker_type_id in hxc_locker_types.locker_type_id%TYPE
263: ) IS
264: --

Line 261: ,p_process_type in hxc_locker_types.process_type%TYPE

257: -- ----------------------------------------------------------------------------
258: Procedure chk_locker_process_type
259: (
260: p_locker_type in hxc_locker_types.locker_type%TYPE
261: ,p_process_type in hxc_locker_types.process_type%TYPE
262: ,p_locker_type_id in hxc_locker_types.locker_type_id%TYPE
263: ) IS
264: --
265: l_proc varchar2(72);

Line 262: ,p_locker_type_id in hxc_locker_types.locker_type_id%TYPE

258: Procedure chk_locker_process_type
259: (
260: p_locker_type in hxc_locker_types.locker_type%TYPE
261: ,p_process_type in hxc_locker_types.process_type%TYPE
262: ,p_locker_type_id in hxc_locker_types.locker_type_id%TYPE
263: ) IS
264: --
265: l_proc varchar2(72);
266: --

Line 271: FROM hxc_locker_types

267: -- cursor to check if the process Type and locker Type are not existing
268: --
269: CURSOR csr_chk_name IS
270: SELECT 'error'
271: FROM hxc_locker_types
272: WHERE locker_type = p_locker_type
273: AND process_type = p_process_type
274: AND locker_type_id <> NVL(p_locker_type_id,9.99E125);
275:

Line 343: p_locker_type_id in hxc_locker_types.locker_type_id%TYPE

339: -- {End Of Comments}
340: -- ----------------------------------------------------------------------------
341: Procedure chk_delete
342: (
343: p_locker_type_id in hxc_locker_types.locker_type_id%TYPE
344: ) IS
345: --
346: l_proc varchar2(72);
347: --