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 11: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE

7: -- ------------------------------------------------------------------------------
8: -- |-----------------------< chk_lock >-----------------------|
9: -- ------------------------------------------------------------------------------
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;

Line 55: ,p_table_name IN hr_wip_locks.table_name%TYPE

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

Line 56: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE

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
59: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
60: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE

Line 57: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE

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
59: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
60: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
61: ,p_commit IN BOOLEAN

Line 58: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE

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

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

Line 60: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%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
59: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%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

Line 62: ,p_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE

58: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
59: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%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

Line 65: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%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);
69: l_locked varchar2(1);

Line 67: l_lock_id 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);
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;

Line 70: l_locking_id hr_wip_locks.lock_id%TYPE;

66: )is
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

Line 74: insert into hr_wip_locks

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
76: ,transaction_id
77: ,table_name
78: ,primary_key_val1

Line 84: (hr_wip_locks_s.nextval

80: ,primary_key_val3
81: ,primary_key_val4
82: ,primary_key_val5)
83: VALUES
84: (hr_wip_locks_s.nextval
85: ,p_transaction_id
86: ,p_table_name
87: ,p_primary_key_val1
88: ,p_primary_key_val2

Line 102: If instr(l_err_msg,'HR_WIP_LOCKS_U1') <> 0

98: End if;
99: exception
100: when dup_val_on_index then
101: l_err_msg := trim(substr(sqlerrm,L_START_TOK_VAL));
102: If instr(l_err_msg,'HR_WIP_LOCKS_U1') <> 0
103: then
104: fnd_message.set_name('PER','PER_289679_LCK_ID_UNIQUE');
105: fnd_message.raise_error;
106: Elsif instr(l_err_msg,'HR_WIP_LOCKS_U2') <> 0

Line 106: Elsif instr(l_err_msg,'HR_WIP_LOCKS_U2') <> 0

102: If instr(l_err_msg,'HR_WIP_LOCKS_U1') <> 0
103: then
104: fnd_message.set_name('PER','PER_289679_LCK_ID_UNIQUE');
105: fnd_message.raise_error;
106: Elsif instr(l_err_msg,'HR_WIP_LOCKS_U2') <> 0
107: then
108: check_for_lock
109: (p_table_name => p_table_name
110: ,p_primary_key_val1 => p_primary_key_val1

Line 145: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE

141: -- ------------------------------------------------------------------------------
142: -- |-----------------------< create_lock >-----------------------|
143: -- ------------------------------------------------------------------------------
144: Procedure create_lock
145: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE
146: ,p_current_user_id IN fnd_user.user_id%TYPE
147: ,p_table_name IN hr_wip_locks.table_name%TYPE
148: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
149: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE

Line 147: ,p_table_name IN hr_wip_locks.table_name%TYPE

143: -- ------------------------------------------------------------------------------
144: Procedure create_lock
145: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE
146: ,p_current_user_id IN fnd_user.user_id%TYPE
147: ,p_table_name IN hr_wip_locks.table_name%TYPE
148: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
149: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
150: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
151: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE

Line 148: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE

144: Procedure create_lock
145: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE
146: ,p_current_user_id IN fnd_user.user_id%TYPE
147: ,p_table_name IN hr_wip_locks.table_name%TYPE
148: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
149: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
150: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%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

Line 149: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE

145: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE
146: ,p_current_user_id IN fnd_user.user_id%TYPE
147: ,p_table_name IN hr_wip_locks.table_name%TYPE
148: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
149: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
150: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%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

Line 150: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE

146: ,p_current_user_id IN fnd_user.user_id%TYPE
147: ,p_table_name IN hr_wip_locks.table_name%TYPE
148: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
149: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
150: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%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

Line 151: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE

147: ,p_table_name IN hr_wip_locks.table_name%TYPE
148: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
149: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
150: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%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

Line 152: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE

148: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
149: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
150: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%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

Line 153: ,p_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE

149: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
150: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%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

Line 156: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%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;
160: l_locked varchar2(1);

Line 159: l_lock_id hr_wip_locks.lock_id%TYPE;

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;
160: l_locked varchar2(1);
161: l_locking_tran_id hr_wip_locks.transaction_id%TYPE;
162: l_locking_lock_id hr_wip_locks.lock_id%TYPE;
163: begin

Line 161: l_locking_tran_id hr_wip_locks.transaction_id%TYPE;

157: )is
158: PRAGMA AUTONOMOUS_TRANSACTION;
159: l_lock_id hr_wip_locks.lock_id%TYPE;
160: l_locked varchar2(1);
161: l_locking_tran_id hr_wip_locks.transaction_id%TYPE;
162: l_locking_lock_id hr_wip_locks.lock_id%TYPE;
163: begin
164: chk_lock
165: (p_transaction_id => p_transaction_id

Line 162: l_locking_lock_id hr_wip_locks.lock_id%TYPE;

158: PRAGMA AUTONOMOUS_TRANSACTION;
159: l_lock_id hr_wip_locks.lock_id%TYPE;
160: l_locked varchar2(1);
161: l_locking_tran_id hr_wip_locks.transaction_id%TYPE;
162: l_locking_lock_id hr_wip_locks.lock_id%TYPE;
163: begin
164: chk_lock
165: (p_transaction_id => p_transaction_id
166: ,p_current_user_id => p_current_user_id

Line 206: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE

202: -- ------------------------------------------------------------------------------
203: -- |-----------------------< check_for_lock >-----------------------|
204: -- ------------------------------------------------------------------------------
205: Procedure check_for_lock
206: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE
207: ,p_table_name IN hr_wip_locks.table_name%TYPE
208: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
209: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
210: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE

Line 207: ,p_table_name IN hr_wip_locks.table_name%TYPE

203: -- |-----------------------< check_for_lock >-----------------------|
204: -- ------------------------------------------------------------------------------
205: Procedure check_for_lock
206: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE
207: ,p_table_name IN hr_wip_locks.table_name%TYPE
208: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
209: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
210: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
211: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE

Line 208: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE

204: -- ------------------------------------------------------------------------------
205: Procedure check_for_lock
206: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE
207: ,p_table_name IN hr_wip_locks.table_name%TYPE
208: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
209: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
210: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
211: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
212: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE

Line 209: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE

205: Procedure check_for_lock
206: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE
207: ,p_table_name IN hr_wip_locks.table_name%TYPE
208: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
209: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
210: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
211: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
212: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
213: ,p_locked OUT NOCOPY VARCHAR2

Line 210: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE

206: (p_transaction_id IN hr_wip_locks.transaction_id%TYPE
207: ,p_table_name IN hr_wip_locks.table_name%TYPE
208: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
209: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
210: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
211: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
212: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
213: ,p_locked OUT NOCOPY VARCHAR2
214: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE

Line 211: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE

207: ,p_table_name IN hr_wip_locks.table_name%TYPE
208: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
209: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
210: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
211: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
212: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
213: ,p_locked OUT NOCOPY VARCHAR2
214: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
215: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE

Line 212: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE

208: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
209: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
210: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
211: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
212: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
213: ,p_locked OUT NOCOPY VARCHAR2
214: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
215: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE
216: )is

Line 214: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE

210: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
211: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
212: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
213: ,p_locked OUT NOCOPY VARCHAR2
214: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
215: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE
216: )is
217: l_trans_id hr_wip_locks.transaction_id%TYPE;
218: l_lock_id hr_wip_locks.lock_id%TYPE;

Line 215: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE

211: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
212: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
213: ,p_locked OUT NOCOPY VARCHAR2
214: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
215: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE
216: )is
217: l_trans_id hr_wip_locks.transaction_id%TYPE;
218: l_lock_id hr_wip_locks.lock_id%TYPE;
219: cursor csr_lock is

Line 217: l_trans_id hr_wip_locks.transaction_id%TYPE;

213: ,p_locked OUT NOCOPY VARCHAR2
214: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
215: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE
216: )is
217: l_trans_id hr_wip_locks.transaction_id%TYPE;
218: l_lock_id hr_wip_locks.lock_id%TYPE;
219: cursor csr_lock is
220: select lck.transaction_id,
221: lck.lock_id

Line 218: l_lock_id hr_wip_locks.lock_id%TYPE;

214: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
215: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE
216: )is
217: l_trans_id hr_wip_locks.transaction_id%TYPE;
218: l_lock_id hr_wip_locks.lock_id%TYPE;
219: cursor csr_lock is
220: select lck.transaction_id,
221: lck.lock_id
222: from hr_wip_locks lck

Line 222: from hr_wip_locks lck

218: l_lock_id hr_wip_locks.lock_id%TYPE;
219: cursor csr_lock is
220: select lck.transaction_id,
221: lck.lock_id
222: from hr_wip_locks lck
223: where lck.transaction_id <> p_transaction_id
224: and lck.table_name = p_table_name
225: and lck.primary_key_val1 = p_primary_key_val1
226: and ((lck.primary_key_val2 = p_primary_key_val2)

Line 260: (p_table_name IN hr_wip_locks.table_name%TYPE

256: -- ------------------------------------------------------------------------------
257: -- |-----------------------< check_for_lock >-----------------------|
258: -- ------------------------------------------------------------------------------
259: Procedure check_for_lock
260: (p_table_name IN hr_wip_locks.table_name%TYPE
261: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
262: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
263: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
264: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE

Line 261: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE

257: -- |-----------------------< check_for_lock >-----------------------|
258: -- ------------------------------------------------------------------------------
259: Procedure check_for_lock
260: (p_table_name IN hr_wip_locks.table_name%TYPE
261: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
262: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
263: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
264: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
265: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE

Line 262: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE

258: -- ------------------------------------------------------------------------------
259: Procedure check_for_lock
260: (p_table_name IN hr_wip_locks.table_name%TYPE
261: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
262: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
263: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
264: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
265: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
266: ,p_locked OUT NOCOPY VARCHAR2

Line 263: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE

259: Procedure check_for_lock
260: (p_table_name IN hr_wip_locks.table_name%TYPE
261: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
262: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
263: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
264: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
265: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
266: ,p_locked OUT NOCOPY VARCHAR2
267: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE

Line 264: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE

260: (p_table_name IN hr_wip_locks.table_name%TYPE
261: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
262: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
263: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
264: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
265: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
266: ,p_locked OUT NOCOPY VARCHAR2
267: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
268: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE

Line 265: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE

261: ,p_primary_key_val1 IN hr_wip_locks.primary_key_val1%TYPE
262: ,p_primary_key_val2 IN hr_wip_locks.primary_key_val2%TYPE
263: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
264: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
265: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
266: ,p_locked OUT NOCOPY VARCHAR2
267: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
268: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE
269: )is

Line 267: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE

263: ,p_primary_key_val3 IN hr_wip_locks.primary_key_val3%TYPE
264: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
265: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
266: ,p_locked OUT NOCOPY VARCHAR2
267: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
268: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE
269: )is
270: l_trans_id hr_wip_locks.transaction_id%TYPE;
271: l_lock_id hr_wip_locks.lock_id%TYPE;

Line 268: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE

264: ,p_primary_key_val4 IN hr_wip_locks.primary_key_val4%TYPE
265: ,p_primary_key_val5 IN hr_wip_locks.primary_key_val5%TYPE
266: ,p_locked OUT NOCOPY VARCHAR2
267: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
268: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE
269: )is
270: l_trans_id hr_wip_locks.transaction_id%TYPE;
271: l_lock_id hr_wip_locks.lock_id%TYPE;
272: cursor csr_lock is

Line 270: l_trans_id hr_wip_locks.transaction_id%TYPE;

266: ,p_locked OUT NOCOPY VARCHAR2
267: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
268: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE
269: )is
270: l_trans_id hr_wip_locks.transaction_id%TYPE;
271: l_lock_id hr_wip_locks.lock_id%TYPE;
272: cursor csr_lock is
273: select lck.transaction_id,
274: lck.lock_id

Line 271: l_lock_id hr_wip_locks.lock_id%TYPE;

267: ,p_locking_lock_id OUT NOCOPY hr_wip_locks.lock_id%TYPE
268: ,p_locking_transaction_id OUT NOCOPY hr_wip_locks.transaction_id%TYPE
269: )is
270: l_trans_id hr_wip_locks.transaction_id%TYPE;
271: l_lock_id hr_wip_locks.lock_id%TYPE;
272: cursor csr_lock is
273: select lck.transaction_id,
274: lck.lock_id
275: from hr_wip_locks lck

Line 275: from hr_wip_locks lck

271: l_lock_id hr_wip_locks.lock_id%TYPE;
272: cursor csr_lock is
273: select lck.transaction_id,
274: lck.lock_id
275: from hr_wip_locks lck
276: where lck.table_name = p_table_name
277: and lck.primary_key_val1 = p_primary_key_val1
278: and ((lck.primary_key_val2 = p_primary_key_val2)
279: or (lck.primary_key_val2 is null and p_primary_key_val2 is null))