DBA Data[Home] [Help]

APPS.HXC_HAT_DEL dependencies on HXC_ALIAS_TYPES

Line 66: -- Delete the hxc_alias_types row.

62: end if;
63: --
64: --
65: --
66: -- Delete the hxc_alias_types row.
67: --
68: delete from hxc_alias_types
69: where alias_type_id = p_rec.alias_type_id;
70: --

Line 68: delete from hxc_alias_types

64: --
65: --
66: -- Delete the hxc_alias_types row.
67: --
68: delete from hxc_alias_types
69: where alias_type_id = p_rec.alias_type_id;
70: --
71: --
72: --

Line 122: cursor c_dep_comp(p_alias_type_id hxc_alias_types.alias_type_id%TYPE) is

118: -- {End Of Comments}
119: -- ----------------------------------------------------------------------------
120: Procedure pre_delete(p_rec in hxc_hat_shd.g_rec_type) is
121: --
122: cursor c_dep_comp(p_alias_type_id hxc_alias_types.alias_type_id%TYPE) is
123: select alias_type_component_id,object_version_number
124: from hxc_alias_type_components hac
125: where alias_type_id = p_alias_type_id;
126: l_proc varchar2(72);

Line 210: (p_module_name => 'HXC_ALIAS_TYPES'

206: --
207: when hr_api.cannot_find_prog_unit then
208: --
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'HXC_ALIAS_TYPES'
211: ,p_hook_type => 'AD');
212: --
213: end;
214: --