APPS.HXC_ATC_INS dependencies on HXC_ALIAS_TYPE_COMPONENTS

Line 97: -- Insert the row into: hxc_alias_type_components

93: p_rec.object_version_number := 1; -- Initialise the object version
94: --
95: --
96: --
97: -- Insert the row into: hxc_alias_type_components
98: --
99: insert into hxc_alias_type_components
100: (alias_type_component_id
101: ,component_name

Line 99: insert into hxc_alias_type_components

95: --
96: --
97: -- Insert the row into: hxc_alias_type_components
98: --
99: insert into hxc_alias_type_components
100: (alias_type_component_id
101: ,component_name
102: ,component_type
103: ,mapping_component_id

Line 194: Cursor C_Sel1 is select hxc_alias_type_components_s.nextval from sys.dual;

190: Procedure pre_insert
191: (p_rec in out nocopy hxc_atc_shd.g_rec_type
192: ) is
193: --
194: Cursor C_Sel1 is select hxc_alias_type_components_s.nextval from sys.dual;
195: --
196: Cursor C_Sel2 is
197: Select null
198: from hxc_alias_type_components

Line 198: from hxc_alias_type_components

194: Cursor C_Sel1 is select hxc_alias_type_components_s.nextval from sys.dual;
195: --
196: Cursor C_Sel2 is
197: Select null
198: from hxc_alias_type_components
199: where alias_type_component_id =
200: hxc_atc_ins.g_alias_type_component_id_i;
201: --
202: l_proc varchar2(72);

Line 223: fnd_message.set_token('TABLE_NAME','hxc_alias_type_components');

219: --
220: -- The primary key values are already in use.
221: --
222: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
223: fnd_message.set_token('TABLE_NAME','hxc_alias_type_components');
224: fnd_message.raise_error;
225: End If;
226: Close C_Sel2;
227: --

Line 317: (p_module_name => 'HXC_ALIAS_TYPE_COMPONENTS'

313: --
314: when hr_api.cannot_find_prog_unit then
315: --
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'HXC_ALIAS_TYPE_COMPONENTS'
318: ,p_hook_type => 'AI');
319: --
320: end;
321: --