APPS.HXC_HAT_INS dependencies on HXC_ALIAS_TYPES

Line 97: -- Insert the row into: hxc_alias_types

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

Line 99: insert into hxc_alias_types

95: --
96: --
97: -- Insert the row into: hxc_alias_types
98: --
99: insert into hxc_alias_types
100: (alias_type_id
101: ,alias_type
102: ,reference_object
103: ,object_version_number

Line 189: Cursor C_Sel1 is select hxc_alias_types_s.nextval from sys.dual;

185: Procedure pre_insert
186: (p_rec in out nocopy hxc_hat_shd.g_rec_type
187: ) is
188: --
189: Cursor C_Sel1 is select hxc_alias_types_s.nextval from sys.dual;
190: --
191: Cursor C_Sel2 is
192: Select null
193: from hxc_alias_types

Line 193: from hxc_alias_types

189: Cursor C_Sel1 is select hxc_alias_types_s.nextval from sys.dual;
190: --
191: Cursor C_Sel2 is
192: Select null
193: from hxc_alias_types
194: where alias_type_id =
195: hxc_hat_ins.g_alias_type_id_i;
196: --
197: l_proc varchar2(72);

Line 218: fnd_message.set_token('TABLE_NAME','hxc_alias_types');

214: --
215: -- The primary key values are already in use.
216: --
217: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
218: fnd_message.set_token('TABLE_NAME','hxc_alias_types');
219: fnd_message.raise_error;
220: End If;
221: Close C_Sel2;
222: --

Line 306: (p_module_name => 'HXC_ALIAS_TYPES'

302: --
303: when hr_api.cannot_find_prog_unit then
304: --
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'HXC_ALIAS_TYPES'
307: ,p_hook_type => 'AI');
308: --
309: end;
310: --