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.HR_WIP_LCKS dependencies on HR_WIP_LOCKS

Line 9: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE

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

Line 11: ,p_table_name IN hr_wip_locks.table_name%TYPE

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

Line 12: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE

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

Line 13: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE

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

Line 14: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%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

Line 15: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%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

Line 16: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%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

Line 17: ,p_lock_id OUT NOCOPY hr_wip_locks.lock_id%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: );

Line 20: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%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 >-----------------------|

Line 27: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE

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

Line 28: ,p_table_name IN hr_wip_locks.table_name%TYPE

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

Line 29: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE

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

Line 30: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE

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

Line 31: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE

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

Line 32: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%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

Line 33: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%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: );

Line 35: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%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: -- ------------------------------------------------------------------------------

Line 36: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%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 >-----------------------|

Line 43: (p_table_name IN hr_wip_locks.table_name%TYPE

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

Line 44: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE

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

Line 45: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE

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

Line 46: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE

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

Line 47: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE

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

Line 48: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%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: );

Line 50: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%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;

Line 51: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%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;