45: -- Internal Row Handler Use Only.
46: --
47: -- {End Of Comments}
48: -- ----------------------------------------------------------------------------
49: Procedure insert_dml(p_rec in out nocopy per_stt_shd.g_rec_type) is
50: --
51: l_proc varchar2(72) := g_package||'insert_dml';
52: --
53: Begin
72: hr_utility.set_location(' Leaving:'||l_proc, 10);
73: Exception
74: When hr_api.check_integrity_violated Then
75: -- A check constraint has been violated
76: per_stt_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When hr_api.parent_integrity_violated Then
79: -- Parent integrity has been violated
80: per_stt_shd.constraint_error
76: per_stt_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When hr_api.parent_integrity_violated Then
79: -- Parent integrity has been violated
80: per_stt_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.unique_integrity_violated Then
83: -- Unique integrity has been violated
84: per_stt_shd.constraint_error
80: per_stt_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.unique_integrity_violated Then
83: -- Unique integrity has been violated
84: per_stt_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: Raise;
88: End insert_dml;
123: -- Internal Row Handler Use Only.
124: --
125: -- {End Of Comments}
126: -- ----------------------------------------------------------------------------
127: Procedure pre_insert(p_rec in out nocopy per_stt_shd.g_rec_type,
128: p_shared_type_id in number ) is
129: --
130: l_proc varchar2(72) := g_package||'pre_insert';
131: --
168: -- Internal Row Handler Use Only.
169: --
170: -- {End Of Comments}
171: -- ----------------------------------------------------------------------------
172: Procedure post_insert(p_rec in per_stt_shd.g_rec_type) is
173: --
174: l_proc varchar2(72) := g_package||'post_insert';
175: --
176: Begin
209: -- |---------------------------------< ins >----------------------------------|
210: -- ----------------------------------------------------------------------------
211: Procedure ins
212: (
213: p_rec in out nocopy per_stt_shd.g_rec_type ,
214: p_shared_type_id in number
215: ) is
216: --
217: l_proc varchar2(72) := g_package||'ins';
247: p_source_lang in varchar2,
248: p_shared_type_name in varchar2
249: ) is
250: --
251: l_rec per_stt_shd.g_rec_type;
252: l_proc varchar2(72) := g_package||'ins';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
257: -- Call conversion function to turn arguments into the
258: -- p_rec structure.
259: --
260: l_rec :=
261: per_stt_shd.convert_args
262: (
263: null,
264: p_language,
265: p_source_lang,