APPS.HXC_LOCKING_RULES_UPLOAD_PKG dependencies on HXC_LOCKER_TYPES

Line 17: l_locker_type hxc_locker_types.locker_type%TYPE;

13: l_owner_id hxc_locking_rules.locker_type_owner_id%TYPE;
14: l_requestor_id hxc_locking_rules.locker_type_requestor_id%TYPE;
15: l_grant_lock hxc_locking_rules.grant_lock%TYPE;
16:
17: l_locker_type hxc_locker_types.locker_type%TYPE;
18: l_process_type hxc_locker_types.process_type%TYPE;
19: l_owner VARCHAR2(4000);
20:
21: FUNCTION find_locker_type_id ( p_process_type VARCHAR2,p_locker_type VARCHAR2 ) RETURN number IS

Line 18: l_process_type hxc_locker_types.process_type%TYPE;

14: l_requestor_id hxc_locking_rules.locker_type_requestor_id%TYPE;
15: l_grant_lock hxc_locking_rules.grant_lock%TYPE;
16:
17: l_locker_type hxc_locker_types.locker_type%TYPE;
18: l_process_type hxc_locker_types.process_type%TYPE;
19: l_owner VARCHAR2(4000);
20:
21: FUNCTION find_locker_type_id ( p_process_type VARCHAR2,p_locker_type VARCHAR2 ) RETURN number IS
22: CURSOR csr_get_locker_type_id IS

Line 24: FROM hxc_locker_types

20:
21: FUNCTION find_locker_type_id ( p_process_type VARCHAR2,p_locker_type VARCHAR2 ) RETURN number IS
22: CURSOR csr_get_locker_type_id IS
23: SELECT locker_type_id
24: FROM hxc_locker_types
25: WHERE locker_type = p_locker_type
26: AND process_type = p_process_type;
27:
28: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;

Line 28: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;

24: FROM hxc_locker_types
25: WHERE locker_type = p_locker_type
26: AND process_type = p_process_type;
27:
28: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;
29:
30: BEGIN
31:
32: l_locker_type_id :=NULL;

Line 98: l_locker_type hxc_locker_types.locker_type%TYPE;

94: l_owner_id hxc_locking_rules.locker_type_owner_id%TYPE;
95: l_requestor_id hxc_locking_rules.locker_type_requestor_id%TYPE;
96: l_grant_lock hxc_locking_rules.grant_lock%TYPE;
97:
98: l_locker_type hxc_locker_types.locker_type%TYPE;
99: l_process_type hxc_locker_types.process_type%TYPE;
100:
101: l_last_update_date_db hxc_locking_rules.last_update_date%TYPE;
102: l_last_updated_by_db hxc_locking_rules.last_updated_by%TYPE;

Line 99: l_process_type hxc_locker_types.process_type%TYPE;

95: l_requestor_id hxc_locking_rules.locker_type_requestor_id%TYPE;
96: l_grant_lock hxc_locking_rules.grant_lock%TYPE;
97:
98: l_locker_type hxc_locker_types.locker_type%TYPE;
99: l_process_type hxc_locker_types.process_type%TYPE;
100:
101: l_last_update_date_db hxc_locking_rules.last_update_date%TYPE;
102: l_last_updated_by_db hxc_locking_rules.last_updated_by%TYPE;
103: l_last_updated_by_f hxc_locking_rules.last_updated_by%TYPE;

Line 109: FROM hxc_locker_types

105:
106: FUNCTION find_locker_type_id ( p_process_type VARCHAR2,p_locker_type VARCHAR2 ) RETURN number IS
107: CURSOR csr_get_locker_type_id IS
108: SELECT locker_type_id
109: FROM hxc_locker_types
110: WHERE locker_type = p_locker_type
111: AND process_type = p_process_type;
112:
113: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;

Line 113: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;

109: FROM hxc_locker_types
110: WHERE locker_type = p_locker_type
111: AND process_type = p_process_type;
112:
113: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;
114:
115: BEGIN
116:
117: l_locker_type_id :=NULL;