DBA Data[Home] [Help]

APPS.PER_SEU_INS dependencies on PER_SECURITY_USERS

Line 88: -- Insert the row into: per_security_users

84: p_rec.object_version_number := 1; -- Initialise the object version
85: --
86: --
87: --
88: -- Insert the row into: per_security_users
89: --
90: insert into per_security_users
91: (security_user_id
92: ,user_id

Line 90: insert into per_security_users

86: --
87: --
88: -- Insert the row into: per_security_users
89: --
90: insert into per_security_users
91: (security_user_id
92: ,user_id
93: ,security_profile_id
94: ,process_in_next_run_flag

Line 170: Cursor C_Sel1 is select per_security_users_s.nextval from sys.dual;

166: Procedure pre_insert
167: (p_rec in out nocopy per_seu_shd.g_rec_type
168: ) is
169: --
170: Cursor C_Sel1 is select per_security_users_s.nextval from sys.dual;
171: --
172: Cursor C_Sel2 is
173: Select null
174: from per_security_users

Line 174: from per_security_users

170: Cursor C_Sel1 is select per_security_users_s.nextval from sys.dual;
171: --
172: Cursor C_Sel2 is
173: Select null
174: from per_security_users
175: where security_user_id =
176: per_seu_ins.g_security_user_id_i;
177: --
178: l_proc varchar2(72) := g_package||'pre_insert';

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

192: --
193: -- The primary key values are already in use.
194: --
195: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
196: fnd_message.set_token('TABLE_NAME','per_security_users');
197: fnd_message.raise_error;
198: End If;
199: Close C_Sel2;
200: --

Line 283: (p_module_name => 'PER_SECURITY_USERS'

279: --
280: when hr_api.cannot_find_prog_unit then
281: --
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'PER_SECURITY_USERS'
284: ,p_hook_type => 'AI');
285: --
286: end;
287: --