[Home] [Help]
PACKAGE: APPS.HR_WIP_LCKS
Source
1 PACKAGE hr_wip_lcks
2 /* $Header: hrwiplck.pkh 115.1 2002/12/10 10:21:11 raranjan ship $ */
3 AUTHID CURRENT_USER AS
4 --
5 -- ------------------------------------------------------------------------------
6 -- |-----------------------< create_lock >-----------------------|
7 -- ------------------------------------------------------------------------------
8 Procedure create_lock
9 (p_transaction_id IN hr_wip_locks.transaction_id%TYPE
10 ,p_current_user_id IN fnd_user.user_id%TYPE
11 ,p_table_name IN hr_wip_locks.table_name%TYPE
12 ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
13 ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
14 ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
15 ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
16 ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
17 ,p_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
18 ,p_locked OUT NOCOPY VARCHAR2
19 ,p_locking_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
20 ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
21 );
22 --
23 -- ------------------------------------------------------------------------------
24 -- |-----------------------< check_for_lock >-----------------------|
25 -- ------------------------------------------------------------------------------
26 Procedure check_for_lock
27 (p_transaction_id IN hr_wip_locks.transaction_id%TYPE
28 ,p_table_name IN hr_wip_locks.table_name%TYPE
29 ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
30 ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
31 ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
32 ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
33 ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
34 ,p_locked OUT NOCOPY VARCHAR2
35 ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
36 ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE
37 );
38 --
39 -- ------------------------------------------------------------------------------
40 -- |-----------------------< check_for_lock >-----------------------|
41 -- ------------------------------------------------------------------------------
42 Procedure check_for_lock
43 (p_table_name IN hr_wip_locks.table_name%TYPE
44 ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
45 ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
46 ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
47 ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
48 ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
49 ,p_locked OUT NOCOPY VARCHAR2
50 ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
51 ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE
52 );
53 --
54 END hr_wip_lcks;