DBA Data[Home] [Help]

APPS.HXC_TBB_DEL dependencies on HXC_TBB_SHD

Line 54: (p_rec in hxc_tbb_shd.g_rec_type

50: --
51: -- {end Of Comments}
52: -- --------------------------------------------------------------------------
53: procedure delete_dml
54: (p_rec in hxc_tbb_shd.g_rec_type
55: ) is
56:
57: l_proc varchar2(72);
58:

Line 80: hxc_tbb_shd.constraint_error

76:
77: exception
78: when hr_api.child_integrity_violated then
79: -- child integrity has been violated
80: hxc_tbb_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: when others Then
83: raise;
84:

Line 119: procedure pre_delete(p_rec in hxc_tbb_shd.g_rec_type) is

115: -- Internal Row Handler Use Only.
116: --
117: -- {end Of Comments}
118: -- --------------------------------------------------------------------------
119: procedure pre_delete(p_rec in hxc_tbb_shd.g_rec_type) is
120:
121: l_proc varchar2(72);
122:
123: begin

Line 168: procedure post_delete(p_rec in hxc_tbb_shd.g_rec_type) is

164: -- Internal Row Handler Use Only.
165: --
166: -- {end Of Comments}
167: -- ---------------------------------------------------------------------------
168: procedure post_delete(p_rec in hxc_tbb_shd.g_rec_type) is
169:
170: l_proc varchar2(72);
171:
172: begin

Line 186: => hxc_tbb_shd.g_old_rec.type

182: hxc_tbb_rkd.after_delete
183: (p_time_building_block_id
184: => p_rec.time_building_block_id
185: ,p_type_o
186: => hxc_tbb_shd.g_old_rec.type
187: ,p_measure_o
188: => hxc_tbb_shd.g_old_rec.measure
189: ,p_unit_of_measure_o
190: => hxc_tbb_shd.g_old_rec.unit_of_measure

Line 188: => hxc_tbb_shd.g_old_rec.measure

184: => p_rec.time_building_block_id
185: ,p_type_o
186: => hxc_tbb_shd.g_old_rec.type
187: ,p_measure_o
188: => hxc_tbb_shd.g_old_rec.measure
189: ,p_unit_of_measure_o
190: => hxc_tbb_shd.g_old_rec.unit_of_measure
191: ,p_start_time_o
192: => hxc_tbb_shd.g_old_rec.start_time

Line 190: => hxc_tbb_shd.g_old_rec.unit_of_measure

186: => hxc_tbb_shd.g_old_rec.type
187: ,p_measure_o
188: => hxc_tbb_shd.g_old_rec.measure
189: ,p_unit_of_measure_o
190: => hxc_tbb_shd.g_old_rec.unit_of_measure
191: ,p_start_time_o
192: => hxc_tbb_shd.g_old_rec.start_time
193: ,p_stop_time_o
194: => hxc_tbb_shd.g_old_rec.stop_time

Line 192: => hxc_tbb_shd.g_old_rec.start_time

188: => hxc_tbb_shd.g_old_rec.measure
189: ,p_unit_of_measure_o
190: => hxc_tbb_shd.g_old_rec.unit_of_measure
191: ,p_start_time_o
192: => hxc_tbb_shd.g_old_rec.start_time
193: ,p_stop_time_o
194: => hxc_tbb_shd.g_old_rec.stop_time
195: ,p_parent_building_block_id_o
196: => hxc_tbb_shd.g_old_rec.parent_building_block_id

Line 194: => hxc_tbb_shd.g_old_rec.stop_time

190: => hxc_tbb_shd.g_old_rec.unit_of_measure
191: ,p_start_time_o
192: => hxc_tbb_shd.g_old_rec.start_time
193: ,p_stop_time_o
194: => hxc_tbb_shd.g_old_rec.stop_time
195: ,p_parent_building_block_id_o
196: => hxc_tbb_shd.g_old_rec.parent_building_block_id
197: ,p_parent_building_block_ovn_o
198: => hxc_tbb_shd.g_old_rec.parent_building_block_ovn

Line 196: => hxc_tbb_shd.g_old_rec.parent_building_block_id

192: => hxc_tbb_shd.g_old_rec.start_time
193: ,p_stop_time_o
194: => hxc_tbb_shd.g_old_rec.stop_time
195: ,p_parent_building_block_id_o
196: => hxc_tbb_shd.g_old_rec.parent_building_block_id
197: ,p_parent_building_block_ovn_o
198: => hxc_tbb_shd.g_old_rec.parent_building_block_ovn
199: ,p_scope_o
200: => hxc_tbb_shd.g_old_rec.scope

Line 198: => hxc_tbb_shd.g_old_rec.parent_building_block_ovn

194: => hxc_tbb_shd.g_old_rec.stop_time
195: ,p_parent_building_block_id_o
196: => hxc_tbb_shd.g_old_rec.parent_building_block_id
197: ,p_parent_building_block_ovn_o
198: => hxc_tbb_shd.g_old_rec.parent_building_block_ovn
199: ,p_scope_o
200: => hxc_tbb_shd.g_old_rec.scope
201: ,p_object_version_number_o
202: => hxc_tbb_shd.g_old_rec.object_version_number

Line 200: => hxc_tbb_shd.g_old_rec.scope

196: => hxc_tbb_shd.g_old_rec.parent_building_block_id
197: ,p_parent_building_block_ovn_o
198: => hxc_tbb_shd.g_old_rec.parent_building_block_ovn
199: ,p_scope_o
200: => hxc_tbb_shd.g_old_rec.scope
201: ,p_object_version_number_o
202: => hxc_tbb_shd.g_old_rec.object_version_number
203: ,p_approval_status_o
204: => hxc_tbb_shd.g_old_rec.approval_status

Line 202: => hxc_tbb_shd.g_old_rec.object_version_number

198: => hxc_tbb_shd.g_old_rec.parent_building_block_ovn
199: ,p_scope_o
200: => hxc_tbb_shd.g_old_rec.scope
201: ,p_object_version_number_o
202: => hxc_tbb_shd.g_old_rec.object_version_number
203: ,p_approval_status_o
204: => hxc_tbb_shd.g_old_rec.approval_status
205: ,p_resource_id_o
206: => hxc_tbb_shd.g_old_rec.resource_id

Line 204: => hxc_tbb_shd.g_old_rec.approval_status

200: => hxc_tbb_shd.g_old_rec.scope
201: ,p_object_version_number_o
202: => hxc_tbb_shd.g_old_rec.object_version_number
203: ,p_approval_status_o
204: => hxc_tbb_shd.g_old_rec.approval_status
205: ,p_resource_id_o
206: => hxc_tbb_shd.g_old_rec.resource_id
207: ,p_resource_type_o
208: => hxc_tbb_shd.g_old_rec.resource_type

Line 206: => hxc_tbb_shd.g_old_rec.resource_id

202: => hxc_tbb_shd.g_old_rec.object_version_number
203: ,p_approval_status_o
204: => hxc_tbb_shd.g_old_rec.approval_status
205: ,p_resource_id_o
206: => hxc_tbb_shd.g_old_rec.resource_id
207: ,p_resource_type_o
208: => hxc_tbb_shd.g_old_rec.resource_type
209: ,p_approval_style_id_o
210: => hxc_tbb_shd.g_old_rec.approval_style_id

Line 208: => hxc_tbb_shd.g_old_rec.resource_type

204: => hxc_tbb_shd.g_old_rec.approval_status
205: ,p_resource_id_o
206: => hxc_tbb_shd.g_old_rec.resource_id
207: ,p_resource_type_o
208: => hxc_tbb_shd.g_old_rec.resource_type
209: ,p_approval_style_id_o
210: => hxc_tbb_shd.g_old_rec.approval_style_id
211: ,p_date_from_o
212: => hxc_tbb_shd.g_old_rec.date_from

Line 210: => hxc_tbb_shd.g_old_rec.approval_style_id

206: => hxc_tbb_shd.g_old_rec.resource_id
207: ,p_resource_type_o
208: => hxc_tbb_shd.g_old_rec.resource_type
209: ,p_approval_style_id_o
210: => hxc_tbb_shd.g_old_rec.approval_style_id
211: ,p_date_from_o
212: => hxc_tbb_shd.g_old_rec.date_from
213: ,p_date_to_o
214: => hxc_tbb_shd.g_old_rec.date_to

Line 212: => hxc_tbb_shd.g_old_rec.date_from

208: => hxc_tbb_shd.g_old_rec.resource_type
209: ,p_approval_style_id_o
210: => hxc_tbb_shd.g_old_rec.approval_style_id
211: ,p_date_from_o
212: => hxc_tbb_shd.g_old_rec.date_from
213: ,p_date_to_o
214: => hxc_tbb_shd.g_old_rec.date_to
215: ,p_comment_text_o
216: => hxc_tbb_shd.g_old_rec.comment_text

Line 214: => hxc_tbb_shd.g_old_rec.date_to

210: => hxc_tbb_shd.g_old_rec.approval_style_id
211: ,p_date_from_o
212: => hxc_tbb_shd.g_old_rec.date_from
213: ,p_date_to_o
214: => hxc_tbb_shd.g_old_rec.date_to
215: ,p_comment_text_o
216: => hxc_tbb_shd.g_old_rec.comment_text
217: ,p_application_set_id_o
218: => hxc_tbb_shd.g_old_rec.application_set_id

Line 216: => hxc_tbb_shd.g_old_rec.comment_text

212: => hxc_tbb_shd.g_old_rec.date_from
213: ,p_date_to_o
214: => hxc_tbb_shd.g_old_rec.date_to
215: ,p_comment_text_o
216: => hxc_tbb_shd.g_old_rec.comment_text
217: ,p_application_set_id_o
218: => hxc_tbb_shd.g_old_rec.application_set_id
219: ,p_translation_display_key_o
220: => hxc_tbb_shd.g_old_rec.translation_display_key

Line 218: => hxc_tbb_shd.g_old_rec.application_set_id

214: => hxc_tbb_shd.g_old_rec.date_to
215: ,p_comment_text_o
216: => hxc_tbb_shd.g_old_rec.comment_text
217: ,p_application_set_id_o
218: => hxc_tbb_shd.g_old_rec.application_set_id
219: ,p_translation_display_key_o
220: => hxc_tbb_shd.g_old_rec.translation_display_key
221: );
222:

Line 220: => hxc_tbb_shd.g_old_rec.translation_display_key

216: => hxc_tbb_shd.g_old_rec.comment_text
217: ,p_application_set_id_o
218: => hxc_tbb_shd.g_old_rec.application_set_id
219: ,p_translation_display_key_o
220: => hxc_tbb_shd.g_old_rec.translation_display_key
221: );
222:
223: exception
224: when hr_api.cannot_find_prog_unit then

Line 240: (p_rec in hxc_tbb_shd.g_rec_type

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

Line 256: hxc_tbb_shd.lck

252: end if;
253:
254: -- we must lock the row which we need to delete.
255:
256: hxc_tbb_shd.lck
257: (p_rec.time_building_block_id
258: ,p_rec.object_version_number
259: );
260:

Line 287: l_rec hxc_tbb_shd.g_rec_type;

283: (p_time_building_block_id in number
284: ,p_object_version_number in number
285: ) is
286:
287: l_rec hxc_tbb_shd.g_rec_type;
288: l_proc varchar2(72);
289:
290: begin
291: