eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_LOCKING_RULES_UPLOAD_PKG dependencies on HXC_LOCKING_RULES

Line 1: PACKAGE BODY hxc_locking_rules_upload_pkg AS

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

Line 13: l_owner_id hxc_locking_rules.locker_type_owner_id%TYPE;

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;

Line 14: l_requestor_id hxc_locking_rules.locker_type_requestor_id%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;

Line 15: l_grant_lock hxc_locking_rules.grant_lock%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);

Line 56: FROM hxc_locking_rules lkr

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:

Line 94: l_owner_id hxc_locking_rules.locker_type_owner_id%TYPE;

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;

Line 95: l_requestor_id hxc_locking_rules.locker_type_requestor_id%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;

Line 96: l_grant_lock hxc_locking_rules.grant_lock%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:

Line 101: l_last_update_date_db hxc_locking_rules.last_update_date%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;
104: l_last_update_date_f hxc_locking_rules.last_update_date%TYPE;
105:

Line 102: l_last_updated_by_db hxc_locking_rules.last_updated_by%TYPE;

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

Line 103: l_last_updated_by_f hxc_locking_rules.last_updated_by%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
107: CURSOR csr_get_locker_type_id IS

Line 104: l_last_update_date_f hxc_locking_rules.last_update_date%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
108: SELECT locker_type_id

Line 147: FROM hxc_locking_rules lkr

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:

Line 181: END hxc_locking_rules_upload_pkg;

177:
178: END load_locking_rules_row;
179:
180:
181: END hxc_locking_rules_upload_pkg;