[Home] [Help]
49: --
50: -- {End Of Comments}
51: -- ----------------------------------------------------------------------------
52: Procedure delete_dml
53: (p_rec in hxc_ula_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72) ;
57: --
78: Exception
79: When hr_api.child_integrity_violated then
80: -- Child integrity has been violated
81: --
82: hxc_ula_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When Others Then
85: --
86: Raise;
117: -- Internal Row Handler Use Only.
118: --
119: -- {End Of Comments}
120: -- ----------------------------------------------------------------------------
121: Procedure pre_delete(p_rec in hxc_ula_shd.g_rec_type) is
122: --
123: l_proc varchar2(72) ;
124: --
125: Begin
162: -- Internal Row Handler Use Only.
163: --
164: -- {End Of Comments}
165: -- -----------------------------------------------------------------------------
166: Procedure post_delete(p_rec in hxc_ula_shd.g_rec_type) is
167: --
168: l_proc varchar2(72) ;
169: --
170: Begin
178: hxc_ula_rkd.after_delete
179: (p_layout_id
180: => p_rec.layout_id
181: ,p_layout_name_o
182: => hxc_ula_shd.g_old_rec.layout_name
183: ,p_application_id_o
184: => hxc_ula_shd.g_old_rec.application_id
185: ,p_layout_type_o
186: => hxc_ula_shd.g_old_rec.layout_type
180: => p_rec.layout_id
181: ,p_layout_name_o
182: => hxc_ula_shd.g_old_rec.layout_name
183: ,p_application_id_o
184: => hxc_ula_shd.g_old_rec.application_id
185: ,p_layout_type_o
186: => hxc_ula_shd.g_old_rec.layout_type
187: ,p_modifier_level_o
188: => hxc_ula_shd.g_old_rec.modifier_level
182: => hxc_ula_shd.g_old_rec.layout_name
183: ,p_application_id_o
184: => hxc_ula_shd.g_old_rec.application_id
185: ,p_layout_type_o
186: => hxc_ula_shd.g_old_rec.layout_type
187: ,p_modifier_level_o
188: => hxc_ula_shd.g_old_rec.modifier_level
189: ,p_modifier_value_o
190: => hxc_ula_shd.g_old_rec.modifier_value
184: => hxc_ula_shd.g_old_rec.application_id
185: ,p_layout_type_o
186: => hxc_ula_shd.g_old_rec.layout_type
187: ,p_modifier_level_o
188: => hxc_ula_shd.g_old_rec.modifier_level
189: ,p_modifier_value_o
190: => hxc_ula_shd.g_old_rec.modifier_value
191: ,p_top_level_region_code_o
192: => hxc_ula_shd.g_old_rec.top_level_region_code
186: => hxc_ula_shd.g_old_rec.layout_type
187: ,p_modifier_level_o
188: => hxc_ula_shd.g_old_rec.modifier_level
189: ,p_modifier_value_o
190: => hxc_ula_shd.g_old_rec.modifier_value
191: ,p_top_level_region_code_o
192: => hxc_ula_shd.g_old_rec.top_level_region_code
193: ,p_object_version_number_o
194: => hxc_ula_shd.g_old_rec.object_version_number
188: => hxc_ula_shd.g_old_rec.modifier_level
189: ,p_modifier_value_o
190: => hxc_ula_shd.g_old_rec.modifier_value
191: ,p_top_level_region_code_o
192: => hxc_ula_shd.g_old_rec.top_level_region_code
193: ,p_object_version_number_o
194: => hxc_ula_shd.g_old_rec.object_version_number
195: );
196: --
190: => hxc_ula_shd.g_old_rec.modifier_value
191: ,p_top_level_region_code_o
192: => hxc_ula_shd.g_old_rec.top_level_region_code
193: ,p_object_version_number_o
194: => hxc_ula_shd.g_old_rec.object_version_number
195: );
196: --
197: exception
198: --
212: -- ----------------------------------------------------------------------------
213: -- |---------------------------------< del >----------------------------------|
214: -- ----------------------------------------------------------------------------
215: Procedure del
216: (p_rec in hxc_ula_shd.g_rec_type
217: ) is
218: --
219: l_proc varchar2(72) ;
220: --
226: end if;
227: --
228: -- We must lock the row which we need to delete.
229: --
230: hxc_ula_shd.lck
231: (p_rec.layout_id
232: ,p_rec.object_version_number
233: );
234: --
257: (p_layout_id in number
258: ,p_object_version_number in number
259: ) is
260: --
261: l_rec hxc_ula_shd.g_rec_type;
262: l_proc varchar2(72) ;
263: --
264: Begin
265: g_debug :=hr_utility.debug_enabled;