APPS.HR_WIP_LCKS dependencies on HR_WIP_TRANSACTIONS

Line 14: l_state hr_wip_transactions.state%TYPE;

10: Procedure chk_lock
11: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE
12: ,p_current_user_id IN fnd_user.user_id%TYPE
13: )is
14: l_state hr_wip_transactions.state%TYPE;
15: l_dml_mode hr_wip_transactions.dml_mode%TYPE;
16: cursor csr_state is
17: select state,dml_mode
18: from hr_wip_transactions

Line 15: l_dml_mode hr_wip_transactions.dml_mode%TYPE;

11: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE
12: ,p_current_user_id IN fnd_user.user_id%TYPE
13: )is
14: l_state hr_wip_transactions.state%TYPE;
15: l_dml_mode hr_wip_transactions.dml_mode%TYPE;
16: cursor csr_state is
17: select state,dml_mode
18: from hr_wip_transactions
19: where transaction_id = p_transaction_id;

Line 18: from hr_wip_transactions

14: l_state hr_wip_transactions.state%TYPE;
15: l_dml_mode hr_wip_transactions.dml_mode%TYPE;
16: cursor csr_state is
17: select state,dml_mode
18: from hr_wip_transactions
19: where transaction_id = p_transaction_id;
20: begin
21: open csr_state;
22: fetch csr_state into l_state,l_dml_mode;

Line 54: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE

50: -- ------------------------------------------------------------------------------
51: -- |-----------------------< ins >-----------------------|
52: -- ------------------------------------------------------------------------------
53: Procedure ins
54: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
55: ,p_table_name IN hr_wip_locks.table_name%TYPE
56: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
57: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
58: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE

Line 64: ,p_locking_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE

60: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
61: ,p_commit IN BOOLEAN
62: ,p_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
63: ,p_locked OUT NOCOPY VARCHAR2
64: ,p_locking_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
65: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
66: )is
67: l_lock_id hr_wip_locks.lock_id%TYPE;
68: l_err_msg varchar2(240);

Line 71: l_locking_trans_id hr_wip_transactions.transaction_id%TYPE;

67: l_lock_id hr_wip_locks.lock_id%TYPE;
68: l_err_msg varchar2(240);
69: l_locked varchar2(1);
70: l_locking_id hr_wip_locks.lock_id%TYPE;
71: l_locking_trans_id hr_wip_transactions.transaction_id%TYPE;
72: L_START_TOK_VAL constant number := 12;
73: begin
74: insert into hr_wip_locks
75: (lock_id

Line 155: ,p_locking_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE

151: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
152: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
153: ,p_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
154: ,p_locked OUT NOCOPY VARCHAR2
155: ,p_locking_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
156: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
157: )is
158: PRAGMA AUTONOMOUS_TRANSACTION;
159: l_lock_id hr_wip_locks.lock_id%TYPE;