APPS.HXC_ULC_DEL dependencies on HXC_ULC_SHD

Line 53: (p_rec in hxc_ulc_shd.g_rec_type

49: --
50: -- {End Of Comments}
51: -- ----------------------------------------------------------------------------
52: Procedure delete_dml
53: (p_rec in hxc_ulc_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72) ;
57: --

Line 82: hxc_ulc_shd.constraint_error

78: Exception
79: When hr_api.child_integrity_violated then
80: -- Child integrity has been violated
81: --
82: hxc_ulc_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When Others Then
85: --
86: Raise;

Line 121: Procedure pre_delete(p_rec in hxc_ulc_shd.g_rec_type) is

117: -- Internal Row Handler Use Only.
118: --
119: -- {End Of Comments}
120: -- ----------------------------------------------------------------------------
121: Procedure pre_delete(p_rec in hxc_ulc_shd.g_rec_type) is
122: --
123: l_proc varchar2(72) ;
124: --
125: Begin

Line 166: Procedure post_delete(p_rec in hxc_ulc_shd.g_rec_type) is

162: -- Internal Row Handler Use Only.
163: --
164: -- {End Of Comments}
165: -- -----------------------------------------------------------------------------
166: Procedure post_delete(p_rec in hxc_ulc_shd.g_rec_type) is
167: --
168: l_proc varchar2(72) ;
169: --
170: Begin

Line 182: => hxc_ulc_shd.g_old_rec.layout_id

178: hxc_ulc_rkd.after_delete
179: (p_layout_component_id
180: => p_rec.layout_component_id
181: ,p_layout_id_o
182: => hxc_ulc_shd.g_old_rec.layout_id
183: ,p_parent_component_id_o
184: => hxc_ulc_shd.g_old_rec.parent_component_id
185: ,p_component_name_o
186: => hxc_ulc_shd.g_old_rec.component_name

Line 184: => hxc_ulc_shd.g_old_rec.parent_component_id

180: => p_rec.layout_component_id
181: ,p_layout_id_o
182: => hxc_ulc_shd.g_old_rec.layout_id
183: ,p_parent_component_id_o
184: => hxc_ulc_shd.g_old_rec.parent_component_id
185: ,p_component_name_o
186: => hxc_ulc_shd.g_old_rec.component_name
187: ,p_component_value_o
188: => hxc_ulc_shd.g_old_rec.component_value

Line 186: => hxc_ulc_shd.g_old_rec.component_name

182: => hxc_ulc_shd.g_old_rec.layout_id
183: ,p_parent_component_id_o
184: => hxc_ulc_shd.g_old_rec.parent_component_id
185: ,p_component_name_o
186: => hxc_ulc_shd.g_old_rec.component_name
187: ,p_component_value_o
188: => hxc_ulc_shd.g_old_rec.component_value
189: ,p_sequence_o
190: => hxc_ulc_shd.g_old_rec.sequence

Line 188: => hxc_ulc_shd.g_old_rec.component_value

184: => hxc_ulc_shd.g_old_rec.parent_component_id
185: ,p_component_name_o
186: => hxc_ulc_shd.g_old_rec.component_name
187: ,p_component_value_o
188: => hxc_ulc_shd.g_old_rec.component_value
189: ,p_sequence_o
190: => hxc_ulc_shd.g_old_rec.sequence
191: ,p_name_value_string_o
192: => hxc_ulc_shd.g_old_rec.name_value_string

Line 190: => hxc_ulc_shd.g_old_rec.sequence

186: => hxc_ulc_shd.g_old_rec.component_name
187: ,p_component_value_o
188: => hxc_ulc_shd.g_old_rec.component_value
189: ,p_sequence_o
190: => hxc_ulc_shd.g_old_rec.sequence
191: ,p_name_value_string_o
192: => hxc_ulc_shd.g_old_rec.name_value_string
193: ,p_region_code_o
194: => hxc_ulc_shd.g_old_rec.region_code

Line 192: => hxc_ulc_shd.g_old_rec.name_value_string

188: => hxc_ulc_shd.g_old_rec.component_value
189: ,p_sequence_o
190: => hxc_ulc_shd.g_old_rec.sequence
191: ,p_name_value_string_o
192: => hxc_ulc_shd.g_old_rec.name_value_string
193: ,p_region_code_o
194: => hxc_ulc_shd.g_old_rec.region_code
195: ,p_region_code_app_id_o
196: => hxc_ulc_shd.g_old_rec.region_code_app_id

Line 194: => hxc_ulc_shd.g_old_rec.region_code

190: => hxc_ulc_shd.g_old_rec.sequence
191: ,p_name_value_string_o
192: => hxc_ulc_shd.g_old_rec.name_value_string
193: ,p_region_code_o
194: => hxc_ulc_shd.g_old_rec.region_code
195: ,p_region_code_app_id_o
196: => hxc_ulc_shd.g_old_rec.region_code_app_id
197: ,p_attribute_code_o
198: => hxc_ulc_shd.g_old_rec.attribute_code

Line 196: => hxc_ulc_shd.g_old_rec.region_code_app_id

192: => hxc_ulc_shd.g_old_rec.name_value_string
193: ,p_region_code_o
194: => hxc_ulc_shd.g_old_rec.region_code
195: ,p_region_code_app_id_o
196: => hxc_ulc_shd.g_old_rec.region_code_app_id
197: ,p_attribute_code_o
198: => hxc_ulc_shd.g_old_rec.attribute_code
199: ,p_attribute_code_app_id_o
200: => hxc_ulc_shd.g_old_rec.attribute_code_app_id

Line 198: => hxc_ulc_shd.g_old_rec.attribute_code

194: => hxc_ulc_shd.g_old_rec.region_code
195: ,p_region_code_app_id_o
196: => hxc_ulc_shd.g_old_rec.region_code_app_id
197: ,p_attribute_code_o
198: => hxc_ulc_shd.g_old_rec.attribute_code
199: ,p_attribute_code_app_id_o
200: => hxc_ulc_shd.g_old_rec.attribute_code_app_id
201: ,p_object_version_number_o
202: => hxc_ulc_shd.g_old_rec.object_version_number

Line 200: => hxc_ulc_shd.g_old_rec.attribute_code_app_id

196: => hxc_ulc_shd.g_old_rec.region_code_app_id
197: ,p_attribute_code_o
198: => hxc_ulc_shd.g_old_rec.attribute_code
199: ,p_attribute_code_app_id_o
200: => hxc_ulc_shd.g_old_rec.attribute_code_app_id
201: ,p_object_version_number_o
202: => hxc_ulc_shd.g_old_rec.object_version_number
203: ,p_layout_comp_definition_id_o
204: => hxc_ulc_shd.g_old_rec.layout_comp_definition_id

Line 202: => hxc_ulc_shd.g_old_rec.object_version_number

198: => hxc_ulc_shd.g_old_rec.attribute_code
199: ,p_attribute_code_app_id_o
200: => hxc_ulc_shd.g_old_rec.attribute_code_app_id
201: ,p_object_version_number_o
202: => hxc_ulc_shd.g_old_rec.object_version_number
203: ,p_layout_comp_definition_id_o
204: => hxc_ulc_shd.g_old_rec.layout_comp_definition_id
205: ,p_component_alias_o
206: => hxc_ulc_shd.g_old_rec.component_alias

Line 204: => hxc_ulc_shd.g_old_rec.layout_comp_definition_id

200: => hxc_ulc_shd.g_old_rec.attribute_code_app_id
201: ,p_object_version_number_o
202: => hxc_ulc_shd.g_old_rec.object_version_number
203: ,p_layout_comp_definition_id_o
204: => hxc_ulc_shd.g_old_rec.layout_comp_definition_id
205: ,p_component_alias_o
206: => hxc_ulc_shd.g_old_rec.component_alias
207: ,p_parent_bean_o
208: => hxc_ulc_shd.g_old_rec.parent_bean

Line 206: => hxc_ulc_shd.g_old_rec.component_alias

202: => hxc_ulc_shd.g_old_rec.object_version_number
203: ,p_layout_comp_definition_id_o
204: => hxc_ulc_shd.g_old_rec.layout_comp_definition_id
205: ,p_component_alias_o
206: => hxc_ulc_shd.g_old_rec.component_alias
207: ,p_parent_bean_o
208: => hxc_ulc_shd.g_old_rec.parent_bean
209: ,p_attribute1_o
210: => hxc_ulc_shd.g_old_rec.attribute1

Line 208: => hxc_ulc_shd.g_old_rec.parent_bean

204: => hxc_ulc_shd.g_old_rec.layout_comp_definition_id
205: ,p_component_alias_o
206: => hxc_ulc_shd.g_old_rec.component_alias
207: ,p_parent_bean_o
208: => hxc_ulc_shd.g_old_rec.parent_bean
209: ,p_attribute1_o
210: => hxc_ulc_shd.g_old_rec.attribute1
211: ,p_attribute2_o
212: => hxc_ulc_shd.g_old_rec.attribute2

Line 210: => hxc_ulc_shd.g_old_rec.attribute1

206: => hxc_ulc_shd.g_old_rec.component_alias
207: ,p_parent_bean_o
208: => hxc_ulc_shd.g_old_rec.parent_bean
209: ,p_attribute1_o
210: => hxc_ulc_shd.g_old_rec.attribute1
211: ,p_attribute2_o
212: => hxc_ulc_shd.g_old_rec.attribute2
213: ,p_attribute3_o
214: => hxc_ulc_shd.g_old_rec.attribute3

Line 212: => hxc_ulc_shd.g_old_rec.attribute2

208: => hxc_ulc_shd.g_old_rec.parent_bean
209: ,p_attribute1_o
210: => hxc_ulc_shd.g_old_rec.attribute1
211: ,p_attribute2_o
212: => hxc_ulc_shd.g_old_rec.attribute2
213: ,p_attribute3_o
214: => hxc_ulc_shd.g_old_rec.attribute3
215: ,p_attribute4_o
216: => hxc_ulc_shd.g_old_rec.attribute4

Line 214: => hxc_ulc_shd.g_old_rec.attribute3

210: => hxc_ulc_shd.g_old_rec.attribute1
211: ,p_attribute2_o
212: => hxc_ulc_shd.g_old_rec.attribute2
213: ,p_attribute3_o
214: => hxc_ulc_shd.g_old_rec.attribute3
215: ,p_attribute4_o
216: => hxc_ulc_shd.g_old_rec.attribute4
217: ,p_attribute5_o
218: => hxc_ulc_shd.g_old_rec.attribute5

Line 216: => hxc_ulc_shd.g_old_rec.attribute4

212: => hxc_ulc_shd.g_old_rec.attribute2
213: ,p_attribute3_o
214: => hxc_ulc_shd.g_old_rec.attribute3
215: ,p_attribute4_o
216: => hxc_ulc_shd.g_old_rec.attribute4
217: ,p_attribute5_o
218: => hxc_ulc_shd.g_old_rec.attribute5
219: );
220: --

Line 218: => hxc_ulc_shd.g_old_rec.attribute5

214: => hxc_ulc_shd.g_old_rec.attribute3
215: ,p_attribute4_o
216: => hxc_ulc_shd.g_old_rec.attribute4
217: ,p_attribute5_o
218: => hxc_ulc_shd.g_old_rec.attribute5
219: );
220: --
221: exception
222: --

Line 240: (p_rec in hxc_ulc_shd.g_rec_type

236: -- ----------------------------------------------------------------------------
237: -- |---------------------------------< del >----------------------------------|
238: -- ----------------------------------------------------------------------------
239: Procedure del
240: (p_rec in hxc_ulc_shd.g_rec_type
241: ) is
242: --
243: l_proc varchar2(72) ;
244: --

Line 254: hxc_ulc_shd.lck

250: end if;
251: --
252: -- We must lock the row which we need to delete.
253: --
254: hxc_ulc_shd.lck
255: (p_rec.layout_component_id
256: ,p_rec.object_version_number
257: );
258: --

Line 285: l_rec hxc_ulc_shd.g_rec_type;

281: (p_layout_component_id in number
282: ,p_object_version_number in number
283: ) is
284: --
285: l_rec hxc_ulc_shd.g_rec_type;
286: l_proc varchar2(72) ;
287: --
288: Begin
289: g_debug :=hr_utility.debug_enabled;