DBA Data[Home] [Help]

APPS.HXC_HAT_DEL dependencies on HXC_ALIAS_TYPE_COMPONENTS

Line 124: from hxc_alias_type_components hac

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);
127: l_ALIAS_TYPE_COMPONENT_ID hxc_alias_type_components.alias_type_component_id%TYPE;
128: l_object_version_number hxc_alias_type_components.object_version_number%TYPE;

Line 127: l_ALIAS_TYPE_COMPONENT_ID hxc_alias_type_components.alias_type_component_id%TYPE;

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);
127: l_ALIAS_TYPE_COMPONENT_ID hxc_alias_type_components.alias_type_component_id%TYPE;
128: l_object_version_number hxc_alias_type_components.object_version_number%TYPE;
129: --
130: Begin
131: if g_debug then

Line 128: l_object_version_number hxc_alias_type_components.object_version_number%TYPE;

124: from hxc_alias_type_components hac
125: where alias_type_id = p_alias_type_id;
126: l_proc varchar2(72);
127: l_ALIAS_TYPE_COMPONENT_ID hxc_alias_type_components.alias_type_component_id%TYPE;
128: l_object_version_number hxc_alias_type_components.object_version_number%TYPE;
129: --
130: Begin
131: if g_debug then
132: l_proc := g_package||'pre_delete';