76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy per_rei_shd.g_rec_type
81: ,p_effective_date in date
82: ,p_datetrack_mode in varchar2
83: ,p_validation_start_date in date
84: ,p_validation_end_date in date
90: t.creation_date
91: from per_contact_extra_info_f t
92: where t.contact_extra_info_id = p_rec.contact_extra_info_id
93: and t.effective_start_date =
94: per_rei_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by per_contact_extra_info_f.created_by%TYPE;
148: l_last_updated_by := fnd_global.user_id;
149: l_last_update_login := fnd_global.login_id;
150: End If;
151: --
152: per_rei_shd.g_api_dml := true; -- Set the api dml status
153: --
154: -- Insert the row into: per_contact_extra_info_f
155: --
156: insert into per_contact_extra_info_f
291: ,l_last_updated_by
292: ,l_last_update_login
293: );
294: --
295: per_rei_shd.g_api_dml := false; -- Unset the api dml status
296: hr_utility.set_location(' Leaving:'||l_proc, 15);
297: --
298: Exception
299: When hr_api.check_integrity_violated Then
297: --
298: Exception
299: When hr_api.check_integrity_violated Then
300: -- A check constraint has been violated
301: per_rei_shd.g_api_dml := false; -- Unset the api dml status
302: per_rei_shd.constraint_error
303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304: When hr_api.unique_integrity_violated Then
305: -- Unique integrity has been violated
298: Exception
299: When hr_api.check_integrity_violated Then
300: -- A check constraint has been violated
301: per_rei_shd.g_api_dml := false; -- Unset the api dml status
302: per_rei_shd.constraint_error
303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304: When hr_api.unique_integrity_violated Then
305: -- Unique integrity has been violated
306: per_rei_shd.g_api_dml := false; -- Unset the api dml status
302: per_rei_shd.constraint_error
303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304: When hr_api.unique_integrity_violated Then
305: -- Unique integrity has been violated
306: per_rei_shd.g_api_dml := false; -- Unset the api dml status
307: per_rei_shd.constraint_error
308: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
309: When Others Then
310: per_rei_shd.g_api_dml := false; -- Unset the api dml status
303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304: When hr_api.unique_integrity_violated Then
305: -- Unique integrity has been violated
306: per_rei_shd.g_api_dml := false; -- Unset the api dml status
307: per_rei_shd.constraint_error
308: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
309: When Others Then
310: per_rei_shd.g_api_dml := false; -- Unset the api dml status
311: Raise;
306: per_rei_shd.g_api_dml := false; -- Unset the api dml status
307: per_rei_shd.constraint_error
308: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
309: When Others Then
310: per_rei_shd.g_api_dml := false; -- Unset the api dml status
311: Raise;
312: End dt_insert_dml;
313: --
314: -- ----------------------------------------------------------------------------
314: -- ----------------------------------------------------------------------------
315: -- |------------------------------< insert_dml >------------------------------|
316: -- ----------------------------------------------------------------------------
317: Procedure insert_dml
318: (p_rec in out nocopy per_rei_shd.g_rec_type
319: ,p_effective_date in date
320: ,p_datetrack_mode in varchar2
321: ,p_validation_start_date in date
322: ,p_validation_end_date in date
377: --
378: -- {End Of Comments}
379: -- ----------------------------------------------------------------------------
380: Procedure pre_insert
381: (p_rec in out nocopy per_rei_shd.g_rec_type
382: ,p_effective_date in date
383: ,p_datetrack_mode in varchar2
384: ,p_validation_start_date in date
385: ,p_validation_end_date in date
469: --
470: -- {End Of Comments}
471: -- ----------------------------------------------------------------------------
472: Procedure post_insert
473: (p_rec in per_rei_shd.g_rec_type
474: ,p_effective_date in date
475: ,p_datetrack_mode in varchar2
476: ,p_validation_start_date in date
477: ,p_validation_end_date in date
667: -- ----------------------------------------------------------------------------
668: Procedure ins_lck
669: (p_effective_date in date
670: ,p_datetrack_mode in varchar2
671: ,p_rec in per_rei_shd.g_rec_type
672: ,p_validation_start_date out nocopy date
673: ,p_validation_end_date out nocopy date
674: ) is
675: --
716: -- |---------------------------------< ins >----------------------------------|
717: -- ----------------------------------------------------------------------------
718: Procedure ins
719: (p_effective_date in date
720: ,p_rec in out nocopy per_rei_shd.g_rec_type
721: ) is
722: --
723: l_proc varchar2(72) := g_package||'ins';
724: l_datetrack_mode varchar2(30) := hr_api.g_insert;
855: ,p_effective_start_date out nocopy date
856: ,p_effective_end_date out nocopy date
857: ) is
858: --
859: l_rec per_rei_shd.g_rec_type;
860: l_proc varchar2(72) := g_package||'ins';
861: --
862: Begin
863: hr_utility.set_location('Entering:'||l_proc, 5);
865: -- Call conversion function to turn arguments into the
866: -- p_rec structure.
867: --
868: l_rec :=
869: per_rei_shd.convert_args
870: (null
871: ,null
872: ,null
873: ,p_contact_relationship_id