APPS.HXC_HAN_INS dependencies on HXC_APP_COMP_NOTIFICATIONS

Line 97: -- Insert the row into: hxc_app_comp_notifications

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

Line 99: insert into hxc_app_comp_notifications

95: --
96: --
97: -- Insert the row into: hxc_app_comp_notifications
98: --
99: insert into hxc_app_comp_notifications
100: (comp_notification_id
101: ,object_version_number
102: ,notification_number_retries
103: ,notification_timeout_value

Line 193: Cursor C_Sel1 is select hxc_app_comp_notifications_s.nextval from sys.dual;

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

Line 197: from hxc_app_comp_notifications

193: Cursor C_Sel1 is select hxc_app_comp_notifications_s.nextval from sys.dual;
194: --
195: Cursor C_Sel2 is
196: Select null
197: from hxc_app_comp_notifications
198: where comp_notification_id =
199: hxc_han_ins.g_comp_notification_id_i
200: or object_version_number =
201: hxc_han_ins.g_object_version_number_i;

Line 224: fnd_message.set_token('TABLE_NAME','hxc_app_comp_notifications');

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

Line 318: (p_module_name => 'HXC_APP_COMP_NOTIFICATIONS'

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