50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy hr_twn_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: --
108: hr_twn_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: --
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: --
113: hr_twn_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: --
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: --
118: hr_twn_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: --
122: Raise;
159: --
160: -- {End Of Comments}
161: -- ----------------------------------------------------------------------------
162: Procedure pre_insert
163: (p_rec in out nocopy hr_twn_shd.g_rec_type
164: ) is
165: --
166: l_proc varchar2(72) := g_package||'pre_insert';
167: --
212: --
213: -- {End Of Comments}
214: -- ----------------------------------------------------------------------------
215: Procedure post_insert
216: (p_rec in hr_twn_shd.g_rec_type
217: ) is
218: --
219: l_proc varchar2(72) := g_package||'post_insert';
220: --
249: -- ----------------------------------------------------------------------------
250: -- |---------------------------------< ins >----------------------------------|
251: -- ----------------------------------------------------------------------------
252: Procedure ins
253: (p_rec in out nocopy hr_twn_shd.g_rec_type
254: ) is
255: --
256: l_proc varchar2(72) := g_package||'ins';
257: --
290: ,p_template_window_id out nocopy number
291: ,p_object_version_number out nocopy number
292: ) is
293: --
294: l_rec hr_twn_shd.g_rec_type;
295: l_proc varchar2(72) := g_package||'ins';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);
300: -- Call conversion function to turn arguments into the
301: -- p_rec structure.
302: --
303: l_rec :=
304: hr_twn_shd.convert_args
305: (null
306: ,null
307: ,p_form_template_id
308: ,p_form_window_id