1: PACKAGE BODY hxc_locking_rules_upload_pkg AS
2: /* $Header: hxclockrulesload.pkb 115.1 2004/05/13 02:18:37 dragarwa noship $ */
3:
4: PROCEDURE load_locking_rules_row (
5: p_owner_process_type IN VARCHAR2
9: , p_owner IN VARCHAR2
10: , p_grant_lock IN VARCHAR2
11: , p_custom_mode IN VARCHAR2 ) IS
12:
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;
10: , p_grant_lock IN VARCHAR2
11: , p_custom_mode IN VARCHAR2 ) IS
12:
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;
11: , p_custom_mode IN VARCHAR2 ) IS
12:
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);
52: ,l_requestor_id
53: ,l_owner
54: ,l_grant_lock
55:
56: FROM hxc_locking_rules lkr
57: WHERE lkr.locker_type_owner_id = l_owner_id
58: AND lkr.locker_type_requestor_id = l_requestor_id;
59:
60:
90: , p_grant_lock IN VARCHAR2
91: , p_custom_mode IN VARCHAR2
92: ,p_last_update_date IN VARCHAR2 ) IS
93:
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;
91: , p_custom_mode IN VARCHAR2
92: ,p_last_update_date IN VARCHAR2 ) IS
93:
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;
92: ,p_last_update_date IN VARCHAR2 ) IS
93:
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:
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;
104: l_last_update_date_f hxc_locking_rules.last_update_date%TYPE;
105:
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;
104: l_last_update_date_f hxc_locking_rules.last_update_date%TYPE;
105:
106: FUNCTION find_locker_type_id ( p_process_type VARCHAR2,p_locker_type VARCHAR2 ) RETURN number IS
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;
104: l_last_update_date_f hxc_locking_rules.last_update_date%TYPE;
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
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;
104: l_last_update_date_f hxc_locking_rules.last_update_date%TYPE;
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
143: ,l_grant_lock
144: ,l_last_update_date_db
145: ,l_last_updated_by_db
146:
147: FROM hxc_locking_rules lkr
148: WHERE lkr.locker_type_owner_id = l_owner_id
149: AND lkr.locker_type_requestor_id = l_requestor_id;
150:
151:
177:
178: END load_locking_rules_row;
179:
180:
181: END hxc_locking_rules_upload_pkg;