DBA Data[Home] [Help]

APPS.HXC_LKR_INS dependencies on HXC_LOCKING_RULES

Line 104: -- Insert the row into: hxc_locking_rules

100: --
101: --
102: --
103: --
104: -- Insert the row into: hxc_locking_rules
105: --
106: insert into hxc_locking_rules
107: (locker_type_owner_id
108: ,locker_type_requestor_id

Line 106: insert into hxc_locking_rules

102: --
103: --
104: -- Insert the row into: hxc_locking_rules
105: --
106: insert into hxc_locking_rules
107: (locker_type_owner_id
108: ,locker_type_requestor_id
109: ,grant_lock
110: ,creation_date

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

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

Line 198: from hxc_locking_rules

194: Cursor C_Sel1 is select hxc_locking_rules_s.nextval from sys.dual;
195: --
196: Cursor C_Sel2 is
197: Select null
198: from hxc_locking_rules
199: where locker_type_owner_id =
200: hxc_lkr_ins.g_locker_type_owner_id_i
201: or locker_type_requestor_id =
202: hxc_lkr_ins.g_locker_type_requestor_id_i;

Line 229: fnd_message.set_token('TABLE_NAME','hxc_locking_rules');

225: --
226: -- The primary key values are already in use.
227: --
228: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
229: fnd_message.set_token('TABLE_NAME','hxc_locking_rules');
230: fnd_message.raise_error;
231: End If;
232: Close C_Sel2;
233: --

Line 324: (p_module_name => 'HXC_LOCKING_RULES'

320: --
321: when hr_api.cannot_find_prog_unit then
322: --
323: hr_api.cannot_find_prog_unit_error
324: (p_module_name => 'HXC_LOCKING_RULES'
325: ,p_hook_type => 'AI');
326: --
327: end;
328: --