50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy hr_ftp_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: --
91: hr_ftp_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
96: hr_ftp_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
101: hr_ftp_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: --
105: Raise;
142: --
143: -- {End Of Comments}
144: -- ----------------------------------------------------------------------------
145: Procedure pre_insert
146: (p_rec in out nocopy hr_ftp_shd.g_rec_type
147: ) is
148: --
149: l_proc varchar2(72) := g_package||'pre_insert';
150: --
196: -- {End Of Comments}
197: -- ----------------------------------------------------------------------------
198: Procedure post_insert
199: (p_effective_date in date
200: ,p_rec in hr_ftp_shd.g_rec_type
201: ) is
202: --
203: l_proc varchar2(72) := g_package||'post_insert';
204: --
239: -- |---------------------------------< ins >----------------------------------|
240: -- ----------------------------------------------------------------------------
241: Procedure ins
242: (p_effective_date in date
243: ,p_rec in out nocopy hr_ftp_shd.g_rec_type
244: ) is
245: --
246: l_proc varchar2(72) := g_package||'ins';
247: --
285: ,p_form_tab_page_id out nocopy number
286: ,p_object_version_number out nocopy number
287: ) is
288: --
289: l_rec hr_ftp_shd.g_rec_type;
290: l_proc varchar2(72) := g_package||'ins';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
295: -- Call conversion function to turn arguments into the
296: -- p_rec structure.
297: --
298: l_rec :=
299: hr_ftp_shd.convert_args
300: (null
301: ,null
302: ,p_form_canvas_id
303: ,p_tab_page_name