168: --
169: -- {End Of Comments}
170: -- ----------------------------------------------------------------------------
171: Procedure insert_dml
172: (p_rec in out nocopy hr_eap_shd.g_rec_type
173: ) is
174: --
175: l_proc varchar2(72) := g_package||'insert_dml';
176: --
199: Exception
200: When hr_api.check_integrity_violated Then
201: -- A check constraint has been violated
202: --
203: hr_eap_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated Then
206: -- Parent integrity has been violated
207: --
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated Then
206: -- Parent integrity has been violated
207: --
208: hr_eap_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated Then
211: -- Unique integrity has been violated
212: --
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated Then
211: -- Unique integrity has been violated
212: --
213: hr_eap_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When Others Then
216: --
217: Raise;
254: --
255: -- {End Of Comments}
256: -- ----------------------------------------------------------------------------
257: Procedure pre_insert
258: (p_rec in out nocopy hr_eap_shd.g_rec_type
259: ) is
260: --
261: Cursor C_Sel1 is select hr_ki_ext_applications_s.nextval from sys.dual;
262: --
341: --
342: -- {End Of Comments}
343: -- ----------------------------------------------------------------------------
344: Procedure post_insert
345: (p_rec in hr_eap_shd.g_rec_type
346: ) is
347: --
348: l_proc varchar2(72) := g_package||'post_insert';
349: --
376: -- ----------------------------------------------------------------------------
377: -- |---------------------------------< ins >----------------------------------|
378: -- ----------------------------------------------------------------------------
379: Procedure ins
380: (p_rec in out nocopy hr_eap_shd.g_rec_type
381: ) is
382: --
383: l_proc varchar2(72) := g_package||'ins';
384: --
422: ,p_external_application_id in varchar2
423: ,p_ext_application_id out nocopy number
424: ) is
425: --
426: l_rec hr_eap_shd.g_rec_type;
427: l_proc varchar2(72) := g_package||'ins';
428: --
429: Begin
430: hr_utility.set_location('Entering:'||l_proc, 5);
432: -- Call conversion function to turn arguments into the
433: -- p_rec structure.
434: --
435: l_rec :=
436: hr_eap_shd.convert_args
437: (null
438: ,p_external_application_name
439: ,p_external_application_id
440: );