50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy pqh_rha_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: --
107: pqh_rha_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: --
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: --
112: pqh_rha_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: --
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: --
117: pqh_rha_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: --
121: Raise;
158: --
159: -- {End Of Comments}
160: -- ----------------------------------------------------------------------------
161: Procedure pre_insert
162: (p_rec in out nocopy pqh_rha_shd.g_rec_type
163: ) is
164: --
165: l_proc varchar2(72) := g_package||'pre_insert';
166: --
212: -- {End Of Comments}
213: -- ----------------------------------------------------------------------------
214: Procedure post_insert
215: (p_effective_date in date
216: ,p_rec in pqh_rha_shd.g_rec_type
217: ) is
218: --
219: l_proc varchar2(72) := g_package||'post_insert';
220: --
271: -- |---------------------------------< ins >----------------------------------|
272: -- ----------------------------------------------------------------------------
273: Procedure ins
274: (p_effective_date in date
275: ,p_rec in out nocopy pqh_rha_shd.g_rec_type
276: ) is
277: --
278: l_proc varchar2(72) := g_package||'ins';
279: --
325: ,p_routing_hist_attrib_id out nocopy number
326: ,p_object_version_number out nocopy number
327: ) is
328: --
329: l_rec pqh_rha_shd.g_rec_type;
330: l_proc varchar2(72) := g_package||'ins';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);
335: -- Call conversion function to turn arguments into the
336: -- p_rec structure.
337: --
338: l_rec :=
339: pqh_rha_shd.convert_args
340: (null
341: ,p_routing_history_id
342: ,p_attribute_id
343: ,p_from_char