49: --
50: -- {End Of Comments}
51: -- ----------------------------------------------------------------------------
52: Procedure delete_dml
53: (p_rec in hxc_vtl_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72) ;
57: --
79: Exception
80: When hr_api.child_integrity_violated then
81: -- Child integrity has been violated
82: --
83: hxc_vtl_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When Others Then
86: --
87: Raise;
118: -- Internal Row Handler Use Only.
119: --
120: -- {End Of Comments}
121: -- ----------------------------------------------------------------------------
122: Procedure pre_delete(p_rec in hxc_vtl_shd.g_rec_type) is
123: --
124: l_proc varchar2(72) ;
125: --
126: Begin
163: -- Internal Row Handler Use Only.
164: --
165: -- {End Of Comments}
166: -- -----------------------------------------------------------------------------
167: Procedure post_delete(p_rec in hxc_vtl_shd.g_rec_type) is
168: --
169: l_proc varchar2(72) ;
170: --
171: Begin
181: => p_rec.alias_value_id
182: ,p_language
183: => p_rec.language
184: ,p_alias_value_name_o
185: => hxc_vtl_shd.g_old_rec.alias_value_name
186: ,p_source_lang_o
187: => hxc_vtl_shd.g_old_rec.source_lang
188: );
189: --
183: => p_rec.language
184: ,p_alias_value_name_o
185: => hxc_vtl_shd.g_old_rec.alias_value_name
186: ,p_source_lang_o
187: => hxc_vtl_shd.g_old_rec.source_lang
188: );
189: --
190: exception
191: --
205: -- ----------------------------------------------------------------------------
206: -- |---------------------------------< del >----------------------------------|
207: -- ----------------------------------------------------------------------------
208: Procedure del
209: (p_rec in hxc_vtl_shd.g_rec_type
210: ) is
211: --
212: l_proc varchar2(72) ;
213: --
219: end if;
220: --
221: -- We must lock the row which we need to delete.
222: --
223: hxc_vtl_shd.lck
224: (p_rec.alias_value_id
225: ,p_rec.language
226: );
227: --
250: (p_alias_value_id in number
251: ,p_language in varchar2
252: ) is
253: --
254: l_rec hxc_vtl_shd.g_rec_type;
255: l_proc varchar2(72) ;
256: --
257: Begin
258: g_debug :=hr_utility.debug_enabled;