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
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
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
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';
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: --
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: --