51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure insert_dml
55: (p_rec in out nocopy hxc_dtl_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72);
59: --
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: --
108: hxc_dtl_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: hxc_dtl_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: hxc_dtl_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 hxc_dtl_shd.g_rec_type
164: ,p_alias_definition_id in number
165: ) is
166: --
167: l_proc varchar2(72);
211: --
212: -- {End Of Comments}
213: -- ----------------------------------------------------------------------------
214: Procedure post_insert
215: (p_rec in hxc_dtl_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72);
219: --
257: -- ----------------------------------------------------------------------------
258: -- |---------------------------------< ins >----------------------------------|
259: -- ----------------------------------------------------------------------------
260: Procedure ins
261: (p_rec in out nocopy hxc_dtl_shd.g_rec_type
262: ,p_alias_definition_id in number
263: ) is
264: --
265: l_proc varchar2(72);
310: ,p_description in varchar2
311: ,p_prompt in varchar2
312: ) is
313: --
314: l_rec hxc_dtl_shd.g_rec_type;
315: l_proc varchar2(72);
316: --
317: Begin
318: g_debug:=hr_utility.debug_enabled;
324: -- Call conversion function to turn arguments into the
325: -- p_rec structure.
326: --
327: l_rec :=
328: hxc_dtl_shd.convert_args
329: (null
330: ,p_alias_definition_name
331: ,p_description
332: ,p_prompt