76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure insert_dml
80: (p_rec in out nocopy pqp_ers_shd.g_rec_type
81: ) is
82: --
83: l_proc varchar2(72) := g_package||'insert_dml';
84: --
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
113: pqp_ers_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
118: pqp_ers_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: pqp_ers_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: --
127: Raise;
164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure pre_insert
168: (p_rec in out nocopy pqp_ers_shd.g_rec_type
169: ) is
170: --
171:
172: Cursor C_Sel2 is
246: --
247: -- {End Of Comments}
248: -- ----------------------------------------------------------------------------
249: Procedure post_insert
250: (p_rec in pqp_ers_shd.g_rec_type
251: ) is
252: --
253: l_proc varchar2(72) := g_package||'post_insert';
254: --
284: -- ----------------------------------------------------------------------------
285: -- |---------------------------------< ins >----------------------------------|
286: -- ----------------------------------------------------------------------------
287: Procedure ins
288: (p_rec in out nocopy pqp_ers_shd.g_rec_type
289: ) is
290: --
291: l_proc varchar2(72) := g_package||'ins';
292: --
331: ,p_legislation_code in varchar2
332: ,p_object_version_number out nocopy number
333: ) is
334: --
335: l_rec pqp_ers_shd.g_rec_type;
336: l_proc varchar2(72) := g_package||'ins';
337: --
338: Begin
339: hr_utility.set_location('Entering:'||l_proc, 5);
341: -- Call conversion function to turn arguments into the
342: -- p_rec structure.
343: --
344: l_rec :=
345: pqp_ers_shd.convert_args
346: (p_database_item_suffix
347: ,p_legislation_code
348: ,p_exception_report_period
349: ,null