DBA Data[Home] [Help]

APPS.HXC_ULP_DEL dependencies on HXC_ULP_SHD

Line 53: (p_rec in hxc_ulp_shd.g_rec_type

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

Line 82: hxc_ulp_shd.constraint_error

78: Exception
79: When hr_api.child_integrity_violated then
80: -- Child integrity has been violated
81: --
82: hxc_ulp_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_ulp_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_ulp_shd.g_rec_type) is
122: --
123: l_proc varchar2(72) ;
124: --
125: Begin

Line 166: Procedure post_delete(p_rec in hxc_ulp_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_ulp_shd.g_rec_type) is
167: --
168: l_proc varchar2(72) ;
169: --
170: Begin

Line 182: => hxc_ulp_shd.g_old_rec.layout_component_id

178: hxc_ulp_rkd.after_delete
179: (p_layout_comp_prompt_id
180: => p_rec.layout_comp_prompt_id
181: ,p_layout_component_id_o
182: => hxc_ulp_shd.g_old_rec.layout_component_id
183: ,p_prompt_alias_o
184: => hxc_ulp_shd.g_old_rec.prompt_alias
185: ,p_prompt_type_o
186: => hxc_ulp_shd.g_old_rec.prompt_type

Line 184: => hxc_ulp_shd.g_old_rec.prompt_alias

180: => p_rec.layout_comp_prompt_id
181: ,p_layout_component_id_o
182: => hxc_ulp_shd.g_old_rec.layout_component_id
183: ,p_prompt_alias_o
184: => hxc_ulp_shd.g_old_rec.prompt_alias
185: ,p_prompt_type_o
186: => hxc_ulp_shd.g_old_rec.prompt_type
187: ,p_region_code_o
188: => hxc_ulp_shd.g_old_rec.region_code

Line 186: => hxc_ulp_shd.g_old_rec.prompt_type

182: => hxc_ulp_shd.g_old_rec.layout_component_id
183: ,p_prompt_alias_o
184: => hxc_ulp_shd.g_old_rec.prompt_alias
185: ,p_prompt_type_o
186: => hxc_ulp_shd.g_old_rec.prompt_type
187: ,p_region_code_o
188: => hxc_ulp_shd.g_old_rec.region_code
189: ,p_region_application_id_o
190: => hxc_ulp_shd.g_old_rec.region_application_id

Line 188: => hxc_ulp_shd.g_old_rec.region_code

184: => hxc_ulp_shd.g_old_rec.prompt_alias
185: ,p_prompt_type_o
186: => hxc_ulp_shd.g_old_rec.prompt_type
187: ,p_region_code_o
188: => hxc_ulp_shd.g_old_rec.region_code
189: ,p_region_application_id_o
190: => hxc_ulp_shd.g_old_rec.region_application_id
191: ,p_attribute_code_o
192: => hxc_ulp_shd.g_old_rec.attribute_code

Line 190: => hxc_ulp_shd.g_old_rec.region_application_id

186: => hxc_ulp_shd.g_old_rec.prompt_type
187: ,p_region_code_o
188: => hxc_ulp_shd.g_old_rec.region_code
189: ,p_region_application_id_o
190: => hxc_ulp_shd.g_old_rec.region_application_id
191: ,p_attribute_code_o
192: => hxc_ulp_shd.g_old_rec.attribute_code
193: ,p_attribute_application_id_o
194: => hxc_ulp_shd.g_old_rec.attribute_application_id

Line 192: => hxc_ulp_shd.g_old_rec.attribute_code

188: => hxc_ulp_shd.g_old_rec.region_code
189: ,p_region_application_id_o
190: => hxc_ulp_shd.g_old_rec.region_application_id
191: ,p_attribute_code_o
192: => hxc_ulp_shd.g_old_rec.attribute_code
193: ,p_attribute_application_id_o
194: => hxc_ulp_shd.g_old_rec.attribute_application_id
195: ,p_object_version_number_o
196: => hxc_ulp_shd.g_old_rec.object_version_number

Line 194: => hxc_ulp_shd.g_old_rec.attribute_application_id

190: => hxc_ulp_shd.g_old_rec.region_application_id
191: ,p_attribute_code_o
192: => hxc_ulp_shd.g_old_rec.attribute_code
193: ,p_attribute_application_id_o
194: => hxc_ulp_shd.g_old_rec.attribute_application_id
195: ,p_object_version_number_o
196: => hxc_ulp_shd.g_old_rec.object_version_number
197: );
198: --

Line 196: => hxc_ulp_shd.g_old_rec.object_version_number

192: => hxc_ulp_shd.g_old_rec.attribute_code
193: ,p_attribute_application_id_o
194: => hxc_ulp_shd.g_old_rec.attribute_application_id
195: ,p_object_version_number_o
196: => hxc_ulp_shd.g_old_rec.object_version_number
197: );
198: --
199: exception
200: --

Line 218: (p_rec in hxc_ulp_shd.g_rec_type

214: -- ----------------------------------------------------------------------------
215: -- |---------------------------------< del >----------------------------------|
216: -- ----------------------------------------------------------------------------
217: Procedure del
218: (p_rec in hxc_ulp_shd.g_rec_type
219: ) is
220: --
221: l_proc varchar2(72) ;
222: --

Line 232: hxc_ulp_shd.lck

228: end if;
229: --
230: -- We must lock the row which we need to delete.
231: --
232: hxc_ulp_shd.lck
233: (p_rec.layout_comp_prompt_id
234: ,p_rec.object_version_number
235: );
236: --

Line 263: l_rec hxc_ulp_shd.g_rec_type;

259: (p_layout_comp_prompt_id in number
260: ,p_object_version_number in number
261: ) is
262: --
263: l_rec hxc_ulp_shd.g_rec_type;
264: l_proc varchar2(72) ;
265: --
266: Begin
267: g_debug :=hr_utility.debug_enabled;