DBA Data[Home] [Help]

APPS.PER_SEU_SHD dependencies on PER_SECURITY_USERS

Line 22: If (p_constraint_name = 'PER_SECURITY_USERS_PK') Then

18: l_proc varchar2(72) := g_package||'constraint_error';
19: --
20: Begin
21: --
22: If (p_constraint_name = 'PER_SECURITY_USERS_PK') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;

Line 55: from per_security_users

51: ,user_id
52: ,security_profile_id
53: ,process_in_next_run_flag
54: ,object_version_number
55: from per_security_users
56: where security_user_id = p_security_user_id;
57: --
58: l_fct_ret boolean;
59: --

Line 125: from per_security_users

121: ,user_id
122: ,security_profile_id
123: ,process_in_next_run_flag
124: ,object_version_number
125: from per_security_users
126: where security_user_id = p_security_user_id
127: for update nowait;
128: --
129: l_proc varchar2(72) := g_package||'lck';

Line 174: fnd_message.set_token('TABLE_NAME', 'per_security_users');

170: -- The object is locked therefore we need to supply a meaningful
171: -- error message.
172: --
173: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
174: fnd_message.set_token('TABLE_NAME', 'per_security_users');
175: fnd_message.raise_error;
176: End lck;
177: --
178: -- ----------------------------------------------------------------------------