DBA Data[Home] [Help]

APPS.HXC_LCK_INS dependencies on HXC_LOCKER_TYPES

Line 101: -- Insert the row into: hxc_locker_types

97: --
98: --
99: --
100: --
101: -- Insert the row into: hxc_locker_types
102: --
103: insert into hxc_locker_types
104: (locker_type_id
105: ,locker_type

Line 103: insert into hxc_locker_types

99: --
100: --
101: -- Insert the row into: hxc_locker_types
102: --
103: insert into hxc_locker_types
104: (locker_type_id
105: ,locker_type
106: ,process_type
107: ,creation_date

Line 191: Cursor C_Sel1 is select hxc_locker_types_s.nextval from sys.dual;

187: Procedure pre_insert
188: (p_rec in out nocopy hxc_lck_shd.g_rec_type
189: ) is
190: --
191: Cursor C_Sel1 is select hxc_locker_types_s.nextval from sys.dual;
192: --
193: Cursor C_Sel2 is
194: Select null
195: from hxc_locker_types

Line 195: from hxc_locker_types

191: Cursor C_Sel1 is select hxc_locker_types_s.nextval from sys.dual;
192: --
193: Cursor C_Sel2 is
194: Select null
195: from hxc_locker_types
196: where locker_type_id =
197: hxc_lck_ins.g_locker_type_id_i;
198: --
199: l_proc varchar2(72);

Line 222: fnd_message.set_token('TABLE_NAME','hxc_locker_types');

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

Line 310: (p_module_name => 'HXC_LOCKER_TYPES'

306: --
307: when hr_api.cannot_find_prog_unit then
308: --
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'HXC_LOCKER_TYPES'
311: ,p_hook_type => 'AI');
312: --
313: end;
314: --