DBA Data[Home] [Help]

APPS.HXC_HAD_DEL dependencies on HXC_HAD_SHD

Line 53: (p_rec in hxc_had_shd.g_rec_type

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

Line 81: hxc_had_shd.constraint_error

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

Line 120: Procedure pre_delete(p_rec in hxc_had_shd.g_rec_type) is

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

Line 165: Procedure post_delete(p_rec in hxc_had_shd.g_rec_type) is

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

Line 180: => hxc_had_shd.g_old_rec.description

176: hxc_had_rkd.after_delete
177: (p_alias_definition_id
178: => p_rec.alias_definition_id
179: ,p_description_o
180: => hxc_had_shd.g_old_rec.description
181: ,p_alias_definition_name_o
182: => hxc_had_shd.g_old_rec.alias_definition_name
183: ,p_alias_context_code_o
184: => hxc_had_shd.g_old_rec.alias_context_code

Line 182: => hxc_had_shd.g_old_rec.alias_definition_name

178: => p_rec.alias_definition_id
179: ,p_description_o
180: => hxc_had_shd.g_old_rec.description
181: ,p_alias_definition_name_o
182: => hxc_had_shd.g_old_rec.alias_definition_name
183: ,p_alias_context_code_o
184: => hxc_had_shd.g_old_rec.alias_context_code
185: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
186: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code

Line 184: => hxc_had_shd.g_old_rec.alias_context_code

180: => hxc_had_shd.g_old_rec.description
181: ,p_alias_definition_name_o
182: => hxc_had_shd.g_old_rec.alias_definition_name
183: ,p_alias_context_code_o
184: => hxc_had_shd.g_old_rec.alias_context_code
185: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
186: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
187: ,p_timecard_field_o
188: => hxc_had_shd.g_old_rec.timecard_field

Line 188: => hxc_had_shd.g_old_rec.timecard_field

184: => hxc_had_shd.g_old_rec.alias_context_code
185: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
186: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
187: ,p_timecard_field_o
188: => hxc_had_shd.g_old_rec.timecard_field
189: ,p_object_version_number_o
190: => hxc_had_shd.g_old_rec.object_version_number
191: ,p_alias_type_id_o
192: => hxc_had_shd.g_old_rec.alias_type_id

Line 190: => hxc_had_shd.g_old_rec.object_version_number

186: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
187: ,p_timecard_field_o
188: => hxc_had_shd.g_old_rec.timecard_field
189: ,p_object_version_number_o
190: => hxc_had_shd.g_old_rec.object_version_number
191: ,p_alias_type_id_o
192: => hxc_had_shd.g_old_rec.alias_type_id
193: );
194: --

Line 192: => hxc_had_shd.g_old_rec.alias_type_id

188: => hxc_had_shd.g_old_rec.timecard_field
189: ,p_object_version_number_o
190: => hxc_had_shd.g_old_rec.object_version_number
191: ,p_alias_type_id_o
192: => hxc_had_shd.g_old_rec.alias_type_id
193: );
194: --
195: exception
196: --

Line 214: (p_rec in hxc_had_shd.g_rec_type

210: -- ----------------------------------------------------------------------------
211: -- |---------------------------------< del >----------------------------------|
212: -- ----------------------------------------------------------------------------
213: Procedure del
214: (p_rec in hxc_had_shd.g_rec_type
215: ) is
216: --
217: l_proc varchar2(72);
218: --

Line 228: hxc_had_shd.lck

224: end if;
225: --
226: -- We must lock the row which we need to delete.
227: --
228: hxc_had_shd.lck
229: (p_rec.alias_definition_id
230: ,p_rec.object_version_number
231: );
232: --

Line 259: l_rec hxc_had_shd.g_rec_type;

255: (p_alias_definition_id in number
256: ,p_object_version_number in number
257: ) is
258: --
259: l_rec hxc_had_shd.g_rec_type;
260: l_proc varchar2(72);
261: --
262: Begin
263: g_debug:=hr_utility.debug_enabled;