50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy hr_tcp_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: --
87: hr_tcp_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --
92: hr_tcp_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --
97: hr_tcp_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: --
101: Raise;
138: --
139: -- {End Of Comments}
140: -- ----------------------------------------------------------------------------
141: Procedure pre_insert
142: (p_rec in out nocopy hr_tcp_shd.g_rec_type
143: ) is
144: --
145: l_proc varchar2(72) := g_package||'pre_insert';
146: --
192: --
193: -- {End Of Comments}
194: -- ----------------------------------------------------------------------------
195: Procedure post_insert
196: (p_rec in hr_tcp_shd.g_rec_type
197: ) is
198: --
199: l_proc varchar2(72) := g_package||'post_insert';
200: --
229: -- ----------------------------------------------------------------------------
230: -- |---------------------------------< ins >----------------------------------|
231: -- ----------------------------------------------------------------------------
232: Procedure ins
233: (p_rec in out nocopy hr_tcp_shd.g_rec_type
234: ) is
235: --
236: l_proc varchar2(72) := g_package||'ins';
237: --
270: ,p_template_item_context_page_i out nocopy number
271: ,p_object_version_number out nocopy number
272: ) is
273: --
274: l_rec hr_tcp_shd.g_rec_type;
275: l_proc varchar2(72) := g_package||'ins';
276: --
277: Begin
278: hr_utility.set_location('Entering:'||l_proc, 5);
280: -- Call conversion function to turn arguments into the
281: -- p_rec structure.
282: --
283: l_rec :=
284: hr_tcp_shd.convert_args
285: (null
286: ,null
287: ,p_template_item_context_id
288: ,p_template_tab_page_id